Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed 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). 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 "Polar May - August". 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

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

Auditing Leadership The Professional And Leadership Skills You Need

Authors: Brian D. Kush

1st Edition

0470450010, 9780470450017

More Books

Students also viewed these Accounting questions

Question

4. How is culture a contested site?

Answered: 1 week ago