Question
Polar Frozen Pops opens its first store in Calgary in May 2022. It sells two types of fresh fruit-based ice cream (regular & special) to
Polar Frozen Pops opens its first store in Calgary in May 2022. It sells two types of fresh fruit-based ice cream (regular & special) to Calgarian kids. Below is the list of revenue and expenses for the store's first four months of operation (May- August 2022). May June July August Sales Revenue: $ $ $ $ Regular 4800 6000 9120 10800 Special 4500 6000 12000 15000 Expenses: Cost of Ingredients 3720 4800 8448 10320 Supplies 930 1800 3168 3870 Shop rental 1500 1500 1500 1500 Salaries and Wages 6000 6000 6000 6000 Telephone 100 100 100 100 Internet 90 90 90 90 Electricity 279 360 634 774 Water 230 180 317 387 Marketing & Advertising 1000 700 500 500 Insurances 180 180 180 180 Instruction: Your task is to record and analyse the store's revenue and expenses using Excel and summarise your findings in a Word Document.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started