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 report is worth 1 point and each sub-question is worth .1. The answers can be as short as one word or a few words or a sentence.

1) MENU ENGINEERING WORKSHEET

Date: 12/1/2021

Restaurant: Downtown Grill Meal Period: Lunch

(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 Item Classification

A

481

?

4.90

12.50

?

?

?

?

?

?

?

B

190

?

6.50

14.75

?

?

?

?

?

?

?

C

205

?

5.20

10.60

?

?

?

?

?

?

?

D

340

?

7.00

16.80

?

?

?

?

?

?

?

N

I

J

M

Column Total

?

?

?

?

O=M/N

Q = (100%/items) x (70%)

?

?

2) Please review the menu engineering reports you filled and answer the following questions:

a) What is the total contribution of the menu?

b) What item generates the highest contribution margin?

c) What menu item category is the item B? Why?

d) What is the weakest menu item? Why?

e) What specific menu items would it make sense to offer as a daily special?

f) What specific menu items should be given high menu visibility?

g) What specific menu items could be possibly removed from the menu?

h) What specific menu item may be overpriced?

i) What does this report help the manager to understand?

j) For what menu item the management may consider price increase along with the improved appearance of the menu item?