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:
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...
-
If there were differences in the responses of the employees you interviewed, how do you account for them? Discuss.
-
A 0.86 percent by mass solution of NaCl is called "physiological saline" because its osmotic pressure is equal to that of the solution in blood cells. Calculate the osmotic pressure of this solution...
-
Draw an energy diagram for the situation presented in Exercise 9.4, but choose the system that comprises block, spring, surface, and Earth. Data from Exercises 9.4 A block initially at rest is...
-
Campus Package Delivery (CPD) provides delivery services in and around Paradise. Its profits have been declining, and management is planning to add an express service that is expected to increase...
-
19 20 Assertion A compass needle is placed near a current carrying wire. The deflection of the compass needle decreases when the magnitude of the current in the wire is increased. Reason The strength...
-
On September 1, 201X, Dan Potter opened an auto repair shop. Here is his chart of accounts: Assets Liabilities Equity 101 Cash 201 Accounts Payable 301 Dan Potter, Capital 102 Accounts Receivable 302...
-
In 2017, Ritzi, Ray, and Schumann published an article in the International Journal of Play Therapy. What was the title of the article? Intensive Short-Term Child-Centered Play Therapy and...
-
Explain and discuss what is meant by the concept of "function creep" in relation to surveillance. Secondly, identify and briefly discuss an example of "function creep" in relation to surveillance....
-
Evaluate the existing capacity against seasonal demand as a function of under-utilization or overcapacity. Inventory: 10,000 units at $5 holding cost per unit per month. Ordering: Average order cost...
-
Find 10 job advertisements for similar positions (all for litigation, probate, general law office, etc.) and copy the descriptions into a table or spreadsheet. Identify the skills that these...
-
Let x be a random variable with cdf F(x) = {(x = -1)/7, -1)/7, 1, Find the pdf of x. x <1 1x <8 x8
-
Prove the identity: (An B)U(ANC)U(Bn C) = (An B)U(ANC) Problem 2. (10 points) Consider the following functions: . f(x) = 1x, over the domain R of real numbers and g(x)= x, over the domain [0,+0) of...
-
According to The Vancouver Sun (December 18, 2010) McDonald's chicken fajita is labeled as having 8 grams of fat on average with a standard deviation of 1.7 grams. They did a sample of 6 fajitas, and...
-
Prove the formula for (d/dx)(cos-1x) by the same method as for (d/dx)(sin-1x).
-
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...
-
Explain the building blocks of accounting: ethics, principles, and assumptions.
-
On May 1, 2025, Park Flying School Ltd., a company that provides flying lessons, was started with an investment of 45,000 cash in the business. Following are the assets and liabilities of the company...
-
The historical cost basis results in: a. initially recording assets at cost and adjusting when the current value changes. b. keeping activities of an entity separate and distinct from its owner. c....
Study smarter with the SolutionInn App