Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Horngrens Financial And Managerial Accounting

Authors: Tracie Miller Nobles, Brenda Mattison, Ella Mae Matsumura

6th Edition

0134486838, 978-0134486833

More Books

Students also viewed these Accounting questions

Question

5. How can I help others in the network achieve their goals?

Answered: 1 week ago