Yummy-Licious Ice Cream opens its first store in Calgary in November 2021. It sells two types...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Yummy-Licious Ice Cream opens its first store in Calgary in November 2021. 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 (November- February). Sales Revenue: Regular Special Expenses: Cost of Ingredients Supplies Shop rental Salaries and Wages Telephone Internet Electricity Water Marketing & Advertising Insurances November December January February $ S S $ 4800 6000 9120 10800 4500 6000 12000 15000 3720 930 1500 6000 100 90 279 230 1000 180 4800 1800 1500 6000 100 90 360 180 700 180 8448 10320 3168 3870 1500 1500 6000 6000 100 100 90 90 6334 774 317 387 500 500 180 180 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 Yummy Nov- February. 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 the total sales from November to February 7. Create a pie chart for November expenses. 8. Create a line chart for net income from November to February. 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, Yummy Sales for sales, Yummy Expense, and Yummy 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. Part B- Word 1. Open a new Word document. 2. Write your complete name in the Header. 3. Write the document title "Yummy -Licious Summary of Revenue and Expenses (November to February)" 4. Present a summary of your Excel calculations a. Copy and paste the charts from the Excel sheet. (There will be three charts). b. Below each chart, write down brief descriptions/highlights or the key information contained in the chart. For example, you can describe the trend (increasing or decreasing?), the highest amount or the month of the highest amount, etc. You should provide at least two highlights for each chart. You can use the following questions as your guide in identifying which information to highlight. Of course, feel free to go beyond these. i. What is the trend of sales, expenses, or net income in the first four months of operation? ii. Which expense is the highest/lowest for November? iii. Which ice cream type sells more? 5. Format your document according to the following: a. The margin should be 2.54 cm all around. b. Font size is 14 for the title and 12 for the rest of the texts. c. Font style- Calibri or Arial d. Bold headings and subheadings if any. e. The title should be centred, and the rest of the texts aligned to the left. f. Feel free to use other formatting options in the paragraph command groups. For example, you can use the number, bullets, and spacing options if you wish. Your goal is to make the document presentable and readable. g. The whole document should be a maximum of two pages. Items for Marking Excel (60 marks) Sheet label Workbook filename Dollar signs for all figures. Total Sales Total Expenses Net income Table (inc. design and presentation) Bar chart (inc. design and presentation) Pie Chart (inc, design and presentation) Line Chart (inc. design and presentation) Chart & Table Design marking Outstanding (shows creativity) Basic (minimum or slightly above requirement) Poor (below minimum requirement) WORD (40 marks) Correct filename Header Title Charts Chart Highlights/ Description Formatting of the entire document Outstanding (shows creativity) Basic (minimum or slightly above requirement) Poor (below minimum requirement) Mark Allocated 2 3 3 4 4 4 10 10 10 10 9-10 7-8.5 0-7 2.5 2.5 5 10 10 10 9-10 7-8.5 0-7 Mark Awarded Comments Yummy-Licious Ice Cream opens its first store in Calgary in November 2021. 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 (November- February). Sales Revenue: Regular Special Expenses: Cost of Ingredients Supplies Shop rental Salaries and Wages Telephone Internet Electricity Water Marketing & Advertising Insurances November December January February $ S S $ 4800 6000 9120 10800 4500 6000 12000 15000 3720 930 1500 6000 100 90 279 230 1000 180 4800 1800 1500 6000 100 90 360 180 700 180 8448 10320 3168 3870 1500 1500 6000 6000 100 100 90 90 6334 774 317 387 500 500 180 180 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 Yummy Nov- February. 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 the total sales from November to February 7. Create a pie chart for November expenses. 8. Create a line chart for net income from November to February. 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, Yummy Sales for sales, Yummy Expense, and Yummy 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. Part B- Word 1. Open a new Word document. 2. Write your complete name in the Header. 3. Write the document title "Yummy -Licious Summary of Revenue and Expenses (November to February)" 4. Present a summary of your Excel calculations a. Copy and paste the charts from the Excel sheet. (There will be three charts). b. Below each chart, write down brief descriptions/highlights or the key information contained in the chart. For example, you can describe the trend (increasing or decreasing?), the highest amount or the month of the highest amount, etc. You should provide at least two highlights for each chart. You can use the following questions as your guide in identifying which information to highlight. Of course, feel free to go beyond these. i. What is the trend of sales, expenses, or net income in the first four months of operation? ii. Which expense is the highest/lowest for November? iii. Which ice cream type sells more? 5. Format your document according to the following: a. The margin should be 2.54 cm all around. b. Font size is 14 for the title and 12 for the rest of the texts. c. Font style- Calibri or Arial d. Bold headings and subheadings if any. e. The title should be centred, and the rest of the texts aligned to the left. f. Feel free to use other formatting options in the paragraph command groups. For example, you can use the number, bullets, and spacing options if you wish. Your goal is to make the document presentable and readable. g. The whole document should be a maximum of two pages. Items for Marking Excel (60 marks) Sheet label Workbook filename Dollar signs for all figures. Total Sales Total Expenses Net income Table (inc. design and presentation) Bar chart (inc. design and presentation) Pie Chart (inc, design and presentation) Line Chart (inc. design and presentation) Chart & Table Design marking Outstanding (shows creativity) Basic (minimum or slightly above requirement) Poor (below minimum requirement) WORD (40 marks) Correct filename Header Title Charts Chart Highlights/ Description Formatting of the entire document Outstanding (shows creativity) Basic (minimum or slightly above requirement) Poor (below minimum requirement) Mark Allocated 2 3 3 4 4 4 10 10 10 10 9-10 7-8.5 0-7 2.5 2.5 5 10 10 10 9-10 7-8.5 0-7 Mark Awarded Comments
Expert Answer:
Answer rating: 100% (QA)
ANSWER Formula for Excel Note cell value based on my ... View the full answer
Related Book For
Strategic Management Text and Cases
ISBN: 978-1259302923
8th edition
Authors: Gregory Dess, Tom Lumpkin, Alan Eisner, Gerry McNamara
Posted Date:
Students also viewed these accounting questions
-
The Ranch 888 Noodle Company sells two types of dried noodles:ramen, at $6.50 per box, and chow fun, at $7.70 per box. So farthis year, the company has sold a total of 110,096 boxes ofnoodles,...
-
A local beer producer sells two types of beer, a regular brand and a light brand with 30% fewer calories. The companys marketing department wants to verify that its traditional approach of appealing...
-
24SEVEN convenience store, which opened its first store in New Delhis Lajpat Nagar in 2005, presently operates 38 round-the-clock stores in Indias capital region. Assume that the chain is planning to...
-
What personal constructs do you rely on when perceiving the people in this photo?
-
What are all the partitions of the set {a. b, c, d, e} which have exactly two cells?
-
The condensed financial statements of Ness Company for the years 2016 and 2017 are presented below. Compute the following ratios for 2017 and 2016. (a) Current ratio. (b) Inventory turnover....
-
Is an international organization like the World Trade Organization in the best position to create rules governing facial recognition technology companies can use?
-
Prepare the income statement of Decorating Arrangements for the year ended December 31, 2016. Insurance Expense....... $ 2,000 Service Revenue....... 80,000 Utilities Expense....... 500 Rent...
-
In 1960, Maury bought a new house for $12,900. How much would it have cost in 2010? Round your answer to the nearest dollar. CPI in year B (price in year A) Year CPI Price in year B = CPI in year A...
-
Determine vo for each network of Fig. 2.173 for the input shown. 20 V 2 V Ideal Ideal 2.2 k -5 V
-
A drive -in movie charges $3.50 per car. The drive -in has already admitted 100 cars. Write and solve an inequality to find how many more cars the drive -in needs to admit to earn at least $500.
-
What is the edible portion cost per ounce for sliced shallots if the as purchase shallots cost $10.60 for a 10 pound box and the yield percentage for sliced shallots is 90.6%?
-
The ABC company uses Contingency Reserves Of 8%. And it also uses Activity Contingency Reserves of 6.1% to account for currency fluctuations for their activities based in US dollars..If a project has...
-
A kickback scheme has been discovered in a warehouse company that purchases office supplies for resale. The perpetrator is the purchasing agent. The agent personally benefited from receiving around...
-
Consider the following inverse demand of a market: P = 100 Q. Suppose the firms in the market are identical and have MC = 80. If a process innovation reduces MC to 70, is the innovation drastic or...
-
Water Source Inc. manufactures badminton rackets. The company estimates the following costs for the next year: Indirect factory wages $171,000 Supervisor salaries 42,000 Direct materials 213,000...
-
A company must choose between the following three mutually exclusive projects: Year O cash flow Year 1 cash flow Year 2 cash flow Year 3 cash flow Year 4 cash flow Project X -$15,000 -$2,000 $4,000...
-
7. FALSE DILEMMA 8. GANDWAGON Definition: Fallacy example: How to revise argument: Definition: Fallacy example: How to revise argument:
-
What internal resources and assets does JetBlue have that may give it a competitive advantage? Is JetBlues competitive advantage sustainable? JetBlue was a domestic airline in the United States with...
-
How should Jamba Juice compete? What internal resources and assets does Jamba Juice have that may give it a competitive advantage? How should Jamba Juice manage growth? How should leadership manage...
-
What internal resources and assets does Ford have that may give it a competitive advantage? How should Ford compete? What has leadership done to implement strategy, and what challenges remain? In...
-
Consider the following project information. The total budget is $36,000 and is expected to last six months. After four months, you have calculated the following information about the project: PV =...
-
Go to www.brighthubpm.com/monitoring-projects/51982-understanding-the-s-curve-theory-for-project-management-monitoring/ and read the article on the multiple uses of project S-curves. What does the...
-
You had planned to construct a series of eight traffic roundabouts in your town, with each roundabout costing $150,000. Your goal was to complete the project during the four (4) months of good...
Study smarter with the SolutionInn App