Question
Antarctic Frozen Pops opens its first store in Calgary in January 2022. It sells two types of fresh fruit-based ice cream (regular & special) to
Antarctic Frozen Pops opens its first store in Calgary in January 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 (January- April).
January February March April
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 334 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. Below are the steps to complete the tasks.
Part A- Excel
1. Open a new Excel workbook and enter the list of revenues and expenses above on an Excel sheet.
2. Label your sheet Antarctic January-April 2022.
3. Add a $ sign to all amounts.
4. Convert the list into a table.
5. Use the appropriate formula/functions to calculate the following:
5.1 Totals sales (Regular+ Special) for each month.
5.2 Total Expenses for each month
5.3 Net income (Total sales- Total Expenses) for each month.
5.4 Format your table so that it highlights the important figures and looks presentable.
6. Create a bar chart for sales from January to April.
7. Create a pie chart for January expenses.
8. Create a line chart for net income from January to April.
Note:
o The charts should appear on the same sheet where the table is. You may position the charts below or beside the table.
o Add a title for each chart, for example, Antarctic Sales for sales, Antarctic Expense for expense, and Antarctic Net Income for net income.
o Add elements and labels to your chart. o Feel free to design your chart. For example, you can change the colours or design. Your goal should be to make your chart meaningful and presentable.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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