Designing, Analyzing, and Costing a Variety of Restaurant Menus

This assignment focuses on the design and analysis of various restaurant menus, including a la carte, buffet, cyclical, degustation, ethnic, set, table d’hôte, and seasonal menus. The student was tasked with creating each menu, specifying menu items, and assigning prices. A crucial component of the assignment involved conducting a detailed menu analysis for the a la carte menu, calculating menu mix percentages, amounts sold, food cost percentages, sales prices, menu costs, and menu revenues. The analysis also included adjustments to the menu items to optimize profitability and understand the financial implications of each menu choice. The assignment demonstrates a practical understanding of menu engineering and cost control within a food service context.

Designing and Analysing a Basic Menu
Institution Name
Student Name:

Students must design following menus and cost them all by conducting a menu analysis
for each menu. The essential requirements of each menu are listed below:
A la carte Menu (Lunch)
Menu Item Price
Entrees $120
Beef and Broccoli
Chicken Rice with Quinoa, Kale, and
Tomatoes
Bacon- Wrapped Pork Tenderloin
Cranberry Beef Stew Over Noddles
Sweet Potatoes and Apples
Mains $150
Fairy Bread
Tim Tams
Meat Pies
Anzac Cookies
Chicken Parmigiana
Desserts $120
Caramel Slice
Chocolate Crackle
Lamington
Iced Vovo
ANZAC Biscuits
Buffet at $350
Menu Item
Entrees
Beef and Broccoli
Chicken Rice with Quinoa, Kale, and Tomatoes
Bacon- Wrapped Pork Tenderloin
Cranberry Beef Stew Over Noddles
Sweet Potatoes and Apples
Mains
Fairy Bread
Tim Tams
Meat Pies
Anzac Cookies
Chicken Parmigiana
Desserts
Caramel Slice
Chocolate Crackle
Lamington
Iced Vovo
ANZAC Biscuits

Cyclical
Menu Item Day Served Price
Entrees
Beef and Broccoli Monday and Friday $12
Chicken Rice with Quinoa,
Kale, and Tomatoes
Tuesday $13
Bacon- Wrapped Pork
Tenderloin
Wednesday and Saturday $12
Cranberry Beef Stew Over
Noddles
Thursday $10
Sweet Potatoes and Apples Daily $10
Mains
Fairy Bread Monday and Friday $40
Tim Tams Tuesday $42
Meat Pies Wednesday and Saturday $40
Anzac Cookies Thursday $42
Chicken Parmigiana Daily $39
Desserts
Caramel Slice Monday and Friday $12
Chocolate Crackle Tuesday $15
Lamington Wednesday and Saturday $14
Iced Vovo Thursday $13
ANZAC Biscuits Daily $12
Degustation
Menu Item Price
Entrees Price
Beef and Broccoli
Chicken Rice with Quinoa, Kale, and
Tomatoes
$13
Bacon- Wrapped Pork Tenderloin $11
Cranberry Beef Stew Over Noddles $12
Sweet Potatoes and Apples $10
Mains $10
Fairy Bread
Tim Tams $42
Meat Pies $42
Anzac Cookies $43
Chicken Parmigiana $41
Desserts $37
Caramel Slice
Chocolate Crackle $17
Lamington $14
Iced Vovo $14

ANZAC Biscuits $13
$12
Ethnic
Menu Item Price
Entrees Price
Beef and Broccoli
Chicken Rice with Quinoa, Kale, and
Tomatoes
$12
Bacon- Wrapped Pork Tenderloin $13
Cranberry Beef Stew Over Noddles $12
Sweet Potatoes and Apples $10
Mains $10
Fairy Bread
Tim Tams $40
Meat Pies $42
Anzac Cookies $40
Chicken Parmigiana $42
Desserts $39
Caramel Slice
Chocolate Crackle $12
Lamington $15
Iced Vovo $14
ANZAC Biscuits $13
$12
Set
Menu Item Price
Entrees Price
Beef and Broccoli
Chicken Rice with Quinoa, Kale, and
Tomatoes
$12
Bacon- Wrapped Pork Tenderloin $13
Cranberry Beef Stew Over Noddles $12
Sweet Potatoes and Apples $10
Mains $10
Fairy Bread
Tim Tams $40
Meat Pies $42
Anzac Cookies $40
Chicken Parmigiana $42
Desserts $39
Caramel Slice

Chocolate Crackle $12
Lamington $15
Iced Vovo $14
ANZAC Biscuits $13
$12
Table d’hôte
Menu Item Price($)
Entrees
Beef and Broccoli 12
Chicken Rice with Quinoa, Kale, and
Tomatoes
13
Bacon- Wrapped Pork Tenderloin 12
Cranberry Beef Stew Over Noddles 12
Sweet Potatoes and Apples 11
Mains
Fairy Bread 35
Tim Tams 45
Meat Pies 45
Anzac Cookies 34
Chicken Parmigiana 45
Desserts
Caramel Slice 14
Chocolate Crackle 15
Lamington 15
Iced Vovo 13
ANZAC Biscuits 11
Seasonal
Menu Item Season Available Price ($)
Entrees
Beef and Broccoli Summer 12
Chicken Rice with
Quinoa, Kale, and
Tomatoes
Summer 12
Bacon- Wrapped Pork
Tenderloin
Winter 13
Cranberry Beef Stew
Over Noddles
Winter 14
Sweet Potatoes and
Apples
Always 13

Mains
Fairy Bread Always 36
Tim Tams Summer 37
Meat Pies Summer 45
Anzac Cookies Winter 23
Chicken Parmigiana Winter 34
Desserts
Caramel Slice Summer 34
Chocolate Crackle Summer 34
Lamington Winter 45
Iced Vovo Winter 22
ANZAC Biscuits Always 22
Menu Analysis
A La Carte Menu Analysis
Menu item Menu mix
%
Amoun
t sold
Food cost
%
Food
cost
Sales
price
Menu
cost
Menu
revenue
Entrees
Beef and
Broccoli 31.88% 110 287.50% 345 120 37950 13200
Chicken Rice
with Quinoa,
Kale and
Tomatoes
52.56% 123 195.00% 234 120 28782 14760
Bacon-
Wrapped
Pork
Tenderloin
49.79% 121 202.50% 243 120 29403 14520
Cranberry
Beef Stew
Over Noddles
18.78% 102 452.50% 543 120 55386 12240
Sweet
Potatoes and
Aples
33.26% 151 378.33% 454 120 68554 18120
Mains
Fairy Bread 33.40% 345 688.67% 1033 150 356385 51750
Tim Tams 19.01% 657 2304.00% 3456 150 2270592 98550
Meat Pies 61.59% 765 828.00% 1242 150 950130 114750
Anzac
Cookies 19.15% 657 2287.33% 3431 150 2254167 98550
Chicken
Parmigiana 415.60% 453 72.67% 109 150 49377 67950
Desserts

Caramel slice 54.91% 676 1025.83% 1231 120 832156 81120
Chocolate
Crackle 16.10% 161 833.33% 1000 120 161000 19320
Lamington 18.25% 545 2489.17% 2987 120 1627915 65400
Iced Vovo 33.59% 522 1295.00% 1554 120 811188 62640
ANZAC
Biscuits 18.90% 254 1344 341376 0
Total
dishes
sold
5642 19206
TOTAL Food
cost
percentage %
13.473551 9874361 732870
TOTALS
Adjustments in the Menu Analysis
Menu item Menu mix
%
Amoun
t sold
Food
cost %
Food
cost
Sales
price
Menu
cost
Menu
revenu
e
Entrees
Beef and
Broccoli 31.88% 110 287.50
% 345 120 37950 13200
Chicken
Rice with
Quinoa,
Kale and
Tomatoes
118.84% 123 86.25% 103.5 120 12730.5 14760
Bacon-
Wrapped
Pork
Tenderloin
389.69% 121 25.88% 31.05 120 3757.05 14520
Cranberry
Beef Stew
Over
Noddles
1095.01% 102 7.76% 9.315 120 950.13 12240
Sweet
Potatoes
and Aples
5403.47% 151 2.33% 2.7945 120 421.969
5 18120
Mains
Fairy
Bread #DIV/0! 345 0.00% 0 150 0 51750
Tim Tams 622.75% 657 70.33% 105.5 150 69313.5 98550
Meat Pies 2417.06% 765 21.10% 31.65 150 24212.2 114750

5
Anzac
Cookies 6919.43% 657 6.33% 9.495 150 6238.21
5 98550
Chicken
Parmigian
a
15903.11% 453 1.90% 2.8485 150 1290.37
1 67950
Desserts
Caramel
slice 653.14% 676 86.25% 103.5 120 69966 81120
Chocolate
Crackle 518.52% 161 25.88% 31.05 120 4999.05 19320
Lamington 5850.78% 545 7.76% 9.315 120 5076.67
5 65400
Iced Vovo 18679.55% 522 2.33% 2.7945 120 1458.72
9 62640
ANZAC
Biscuits 30297.61% 254 0.83835 212.940
9 0
Total dishes
sold 5642 0.25150
5
TOTAL
Food cost
percentage
%
0.32553847
2
238577.
4 732870
TOTAL
S