Complete the following Income Statement to include the percentages. Note: Total Sales is the base (100%)...
Fantastic news! We've Found the answer you've been seeking!
Question:
![Complete the following Income Statement to include the percentages. Note: Total Sales is the base (100%)](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2023/08/64e5cb84b8f07_1692781443485.jpg)
![Sales Food Sales Beverage Sales Total Sales Cost of Sales Cost of Food Sold Cost of Beverages Sold Total Cost](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2023/08/64e5cb9048942_1692781455678.jpg)
![3. (14 Marks) a) Complete the menu engineering chart on the following page, and classify all the menu items.](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2023/08/64e5cb99782b7_1692781464642.jpg)
![Menu Item Corned Beef Tuna Salad Club Sandwich Hot Turkey Chicken Wings Veggie Platter Beef Lasagna Linguine](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2023/08/64e5cba42aca3_1692781475301.jpg)
Transcribed Image Text:
Complete the following Income Statement to include the percentages. Note: Total Sales is the base (100%) Sales Food Sales Beverage Sales Total Sales Cost of Sales Cost of Food Sold Cost of Beverages Sold Total Cost of Sales Gross Margin Operating Expenses Labour Rent Other fixed costs Total Expenses Operating Income $ $437,920 $344,080 $153,272 $103,224 $289,340 $140,000 $57,400 $ $782,000 $256,496 $525,504 $486,740 $38,764 % 2. (12 Marks) a) Using the previous Income Statement as a guide, complete the income statement on the following page assuming that total sales revenue will increase. • The percentage increase will be based on the first 3 numbers of your student number. For example, if your student number is 199 201 200, the percentage increase will be 19.9%. So based on that increase your new sales revenue would increase by $782,000 x 0.199 = $155,618. This means in this example Sales would be $782,000+$155,618 = $937,618. This would be set at 100% in the new income statement. • Food sales and Beverage sales would increase in terms of dollars but remain at the same percentage of total sales. Cost of food and cost of beverages sold percentages will remain the same. The percentages will remain the same, but the dollar amounts will increase since sales would have increased. Fixed costs will remain the same. Payroll or Labour costs are considered variable, meaning they are based on total sales. Apply the labour cost percentage you calculated in question 1, to the total sales in question 2 to calculate Total Labour expenses. Sales Food Sales Beverage Sales Total Sales Cost of Sales Cost of Food Sold Cost of Beverages Sold Total Cost of Sales Gross Margin Operating Expenses Labour Rent Other fixed costs Total Expenses Operating Income $ b) Calculate the breakeven level of sales $ % 3. (14 Marks) a) Complete the menu engineering chart on the following page, and classify all the menu items. There are three missing numbers from this chart that you need to complete first. You are not provided with the number sold for three menu items, Corned Beef, Chicken Wings, and Spring Rolls Similar to question 2 we will use your student number to input these missing numbers. For this question the first 3 numbers of your student number will be the actual number of Corned Beef sold, the middle 3 numbers will be the actual number of chicken wings sold, and the last 3 numbers of your student number will be the actual number of Spring rolls sold. For example, if your student number is 199 201 200, Corned Beef sold will be 199, Chicken wings will be 201, and Spring rolls will be 200 b) Once the chart is completed, make your recommendations. In this section you must be specific with your analysis specific to this menu. Do not simply write out the definitions of the item classifications, or generic recommendations obtained by an internet search. If you suggest new prices to certain items, state them and why you are changing them. If you want to redesign the menu, show the new menu and why you are placing the items in different order. If you want to remove certain items and replace them, state reasons why, and what items you will add to the menu. Menu Item Corned Beef Tuna Salad Club Sandwich Hot Turkey Chicken Wings Veggie Platter Beef Lasagna Linguine Spring Rolls Ribeye Steak Clams Casino Lobster Total Number Sold 328 420 192 156 182 255 160 270 180 Menu Mix % Menu Price $ 8.95 7.95 12.00 10.95 8.50 9.50 14.95 8.95 29.00 27.15 Comments and recommendations Item Food Cost $ 3.25 2.32 2.78 4.75 1.75 9.50 8.25 3.75 18.12 17.40 Item CM $ 5.75 4.15 Gross Margin $ 3234 1917 Avg. CM $ CM Category MM% Category Classification Avg. Menu Mix% Complete the following Income Statement to include the percentages. Note: Total Sales is the base (100%) Sales Food Sales Beverage Sales Total Sales Cost of Sales Cost of Food Sold Cost of Beverages Sold Total Cost of Sales Gross Margin Operating Expenses Labour Rent Other fixed costs Total Expenses Operating Income $ $437,920 $344,080 $153,272 $103,224 $289,340 $140,000 $57,400 $ $782,000 $256,496 $525,504 $486,740 $38,764 % 2. (12 Marks) a) Using the previous Income Statement as a guide, complete the income statement on the following page assuming that total sales revenue will increase. • The percentage increase will be based on the first 3 numbers of your student number. For example, if your student number is 199 201 200, the percentage increase will be 19.9%. So based on that increase your new sales revenue would increase by $782,000 x 0.199 = $155,618. This means in this example Sales would be $782,000+$155,618 = $937,618. This would be set at 100% in the new income statement. • Food sales and Beverage sales would increase in terms of dollars but remain at the same percentage of total sales. Cost of food and cost of beverages sold percentages will remain the same. The percentages will remain the same, but the dollar amounts will increase since sales would have increased. Fixed costs will remain the same. Payroll or Labour costs are considered variable, meaning they are based on total sales. Apply the labour cost percentage you calculated in question 1, to the total sales in question 2 to calculate Total Labour expenses. Sales Food Sales Beverage Sales Total Sales Cost of Sales Cost of Food Sold Cost of Beverages Sold Total Cost of Sales Gross Margin Operating Expenses Labour Rent Other fixed costs Total Expenses Operating Income $ b) Calculate the breakeven level of sales $ % 3. (14 Marks) a) Complete the menu engineering chart on the following page, and classify all the menu items. There are three missing numbers from this chart that you need to complete first. You are not provided with the number sold for three menu items, Corned Beef, Chicken Wings, and Spring Rolls Similar to question 2 we will use your student number to input these missing numbers. For this question the first 3 numbers of your student number will be the actual number of Corned Beef sold, the middle 3 numbers will be the actual number of chicken wings sold, and the last 3 numbers of your student number will be the actual number of Spring rolls sold. For example, if your student number is 199 201 200, Corned Beef sold will be 199, Chicken wings will be 201, and Spring rolls will be 200 b) Once the chart is completed, make your recommendations. In this section you must be specific with your analysis specific to this menu. Do not simply write out the definitions of the item classifications, or generic recommendations obtained by an internet search. If you suggest new prices to certain items, state them and why you are changing them. If you want to redesign the menu, show the new menu and why you are placing the items in different order. If you want to remove certain items and replace them, state reasons why, and what items you will add to the menu. Menu Item Corned Beef Tuna Salad Club Sandwich Hot Turkey Chicken Wings Veggie Platter Beef Lasagna Linguine Spring Rolls Ribeye Steak Clams Casino Lobster Total Number Sold 328 420 192 156 182 255 160 270 180 Menu Mix % Menu Price $ 8.95 7.95 12.00 10.95 8.50 9.50 14.95 8.95 29.00 27.15 Comments and recommendations Item Food Cost $ 3.25 2.32 2.78 4.75 1.75 9.50 8.25 3.75 18.12 17.40 Item CM $ 5.75 4.15 Gross Margin $ 3234 1917 Avg. CM $ CM Category MM% Category Classification Avg. Menu Mix%
Expert Answer:
Answer rating: 100% (QA)
To address your request we will first need to complete the income statement by applying the given percentage increase to the total sales revenue Lets assume your student number leads to a percentage i... View the full answer
Related Book For
Financial Accounting and Reporting a Global Perspective
ISBN: 978-1408076866
4th edition
Authors: Michel Lebas, Herve Stolowy, Yuan Ding
Posted Date:
Students also viewed these general management questions
-
Use the attached "words.txt" file to store the words along with their ranks in an AVL tree. Then provide the user the option to search for any word. If the word exists the program displays the rank...
-
We have looked at the breakeven calculations for a single-product firm. However, most firms make more than one product - or service. Conceptually, multiple-product breakeven is the same as single...
-
Complete the following income statement and vertical analysis? Marten's Family Store Income Statement For Year Ending December 31, 2013 Percent of net sales Revenue: Gross sales Sales returns and...
-
Briefly explain the DHCP lease process. What packets are sent and when are they sent? (5 marks) Question 2 any three advantages of IPv6 over IPv4? How many classes are there in IPv4 and what is the...
-
How does the emotion-reducing model work?
-
Define each of the following terms: a. Greenmail b. White knight c. Golden parachute d. Crown jewels e. Shark repellent f. Corporate raider g. Poison pill h. Tender offer i. Leveraged buyout (LBO)
-
Demonstrate that the solution to the backward equation (2.4) is given by (2.5). (Hint: apply Itos lemma to the expectation of the option price.)
-
Comprehensive Income Armstrong Corporation reported the following for 2010: net sales $1,200,000 cost of goods sold $720,000: selling and administrative expenses $320,000: and an unrealized holding...
-
When trying to make a "sell or process further" decision relative to joint products, the manufacturing cost of making the joint products up to the split-off point are: never relevant sometimes...
-
Image transcription text Example time steps for a 6 x 6 matrix Starting Matrix (Time Step 0) Time Step 1 Time Step 2 0 1 2 3 4 5 0 1 2 3 4 5 0 1 2 3 4 5 O O O O O O O O O O O O O O O O O W N K O O O...
-
Outline the steps in detail for developing a product from its inception
-
Required Information Comprehensive Problem 3-85 (LO 8-1, LO 8-2, LO 8-3, LO 8-4, LO 8-5) [The following information applies to the questions displayed below.) John and Sandy Ferguson got married...
-
In the circuit shown in Figure 4, a battery supplies a constant voltage of 40 V, the inductance is 2 H, the resistance is 10, and l(0) = 0. (a) Find l(t). (b) Find the current after 0.1s.
-
Unilever is a Anglo-Dutch supplier of fast moving consumer goods. The two parent companies, Unilever N.V. and Unilever PLC, together with their group companies, operate as Unilever Group. The...
-
Granados Companys current accounting policies call for the expensing of R&D expenditures in the year incurred. The following table presents the amount of forecasted expenditures from Year 1 to Year...
-
A company has the following shareholders equity section: Ordinary shares: par = 2 CU; 250,000 shares authorized; 100,000 shares issued and outstanding .. 200,000 Share premium . 30,000 Retained...
-
What are the three ways that ratios can be expressed? AppendixLO1
-
What is the purpose of profitability ratios? Explain earnings per share and the price-earnings ratio. AppendixLO1
-
What does a statement of stockholders' equity show? AppendixLO1
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App