Question: Excel sheet A B C D E F G H L P R S T Number sold (MM) Menu Mix % Item Food Cost Item

Excel sheet

Number sold (MM)

Menu Mix %

Item Food Cost

Item Selling Price

Item CM (E-D)

Menu Costs (D*B)

Menu Revenues (E*B)

Menu CM (F*B)

CM Category

MM% Category

Menu Item Classification

Profit Factor

Steak 8 Oz

331

5.5

12.95

plowhorse

Steak 10 Oz

295

6.8

15.95

star

Chicken Breast

320

3.25

7.95

plowhorse

Veal Neptune

175

5.75

12.45

dog

Prime Rib

452

5.95

16.95

star

Lamb Chops

307

5.7

12.95

plowhorse

Fried Shrimp

254

4.2

10.95

plowhorse

Sole Filet

314

5.05

12.45

plowhorse

Crab Legs

246

6.1

13.95

star

Salmon Steak

179

4.95

12.45

dog

Columm Totals

I = G

J = H

M = L

Average CM = M / Menu Items:

Additional Computations:

K = I / J

O = M / N

Q = (100 / Items) (70%)

Assignment 4 is to fill out all information in the spreadsheet using functions in Excel. Check the answers (page 256 in the ninth edition; page 252 in the eighth edition). In the next tab, dog items are deleted. Fill out necessary information (6 points). Due: March 30

Number sold (MM)

Menu Mix %

Item Food Cost

Item Selling Price

Item CM (E-D)

Menu Costs (D*B)

Menu Revenues (E*B)

Menu CM (F*B)

CM Category

MM% Category

Menu Item Classification

Profit Factor

Steak 8 Oz

331

5.5

12.95

Steak 10 Oz

295

6.8

15.95

Chicken Breast

320

3.25

7.95

Prime Rib

452

5.95

16.95

Lamb Chops

307

5.7

12.95

Fried Shrimp

254

4.2

10.95

Sole Filet

314

5.05

12.45

Crab Legs

246

6.1

13.95

Columm Totals

I = G

J = H

M = L

Average CM = M / Menu Items:

Additional Computations:

K = I / J

O = M / N

Q = (100 / Items) (70%)

In this sheet, two dog items are deleted. Consequently, there will be some changes in the CM and MM% categories. Please fill out all information (8 points).

Discuss how you would adjust the menu (by changing sales and price) and make a few comments what you learned from this assignment (6 points).

Your response:

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Period Oct 10 - 15 A B C D E F G H L P R S Menu Item Name # Menu Food Sales Item CM Menu Cost Menu Reve- Menu CM CM MM Menu Item Sold Mix % Cost Price (E-D) (D*B) nues (E*B) (F*B) Category Category...

1) If the total contribution margin of all menu items equals $2,500 and 250 items were sold, how you determine what items are H and what items are L in CM (contribution margin) category column on the...

Complete the menu engineering report on the next page by inserting the values instead of question marks. Round all calculations to hundredth (.00). The question has 2 parts. The menu engineering...

1. Complete the menu engineering report on the next page by inserting the values instead of question marks. Round all calculations to hundredth (.00). The question has 2 parts. The menu engineering...

A) (B) (C) (D) (E) (F) (G) (H) (L) (P) (R) (S) Menu Item Name Number Sold (MM) Menu Mix (%) Item Food Cost Item Selling Price Item CM Menu Costs Menu Revenues Menu CM CM Category MM% Category Menu...

Complete the menu engineering report on the next page by replacing the question marks (?) with values. Round all calculation to hundredth (.00) unless the number naturally rounds up to a whole number...

What is MM% Rank, CM Rank, Menu Item Class, and Profit Factor Please give explanation and formula. For MM% Rank, this is what you compare but I am not sure what to compare on this chart, Brand...

This is in Cost Control. Examine the given table. Analyze what class will belong to the types of entrees. Write "S" stars, "D" dogs, "PH" plowhorses, and "P" puzzles. V.ANALYZATION. Examine the given...

Fill in the missing amounts in each of the case situations below. Each case is independent of the others. Required: a. Assume that only one product is being sold in each of the four following case...

Bags of grass seed are stored on a wooden plank as shown. To move the plank, a 9° wedge is driven under end A. Knowing that the weight of the grass seed can be represented by the distributed load...

Earnings of C corporations can be Multiple Choice 9 : 3 4 taxed twice if they are distributed as dividends to stockholders. k taxed by the federal government, but they are exempt from state taxes if...

College Student goes to Lightly Used Rides to buy a used car.She finds one she likes on August 1 st , and negotiates a price of $5,000.Every car that Rides sells comes with a 3 day no-questions asked...