Prime cost/Contribution margin

profilex0mchi
worksheet.xlsx

Chapter 10

Chapter 10 Apply What You Know-Student Worksheet Chapter 10 Apply What You Know-Student Worksheet 0
10.1 10.1
Menu Item Selling Price Product Cost Per Serving Labor Cost Food Cost % Prime Cost Contribution Margin Menu Item Selling Price Product Cost Per Serving Labor Cost Food Cost % Prime Cost Contribution Margin
New York Strip $ 26.95 $ 12.97 $ 1.95 New York Strip $ 26.95 $ 12.97 $ 1.95 0.0% 0.0% 0.0%
1/2 Duckling $ 25.95 $ 11.73 $ 2.55 1/2 Duckling $ 25.95 $ 11.73 $ 2.55 0.0% 0.0% 0.0%
Veal Chop $ 31.95 $ 13.85 $ 1.95 Veal Chop $ 31.95 $ 13.85 $ 1.95 0.0% 0.0% 0.0%
Roasted Free-Range Chicken $ 18.95 $ 6.53 $ 2.55 Roasted Free-Range Chicken $ 18.95 $ 6.53 $ 2.55 0.0% 0.0% 0.0%
Pork Medallions $ 24.95 $ 5.58 $ 3.10 Pork Medallions $ 24.95 $ 5.58 $ 3.10 0.0% 0.0% 0.0%
Portabella Mushroom Pasta $ 18.95 $ 3.85 $ 4.25 Portabella Mushroom Pasta $ 18.95 $ 3.85 $ 4.25 0.0% 0.0% 0.0%
Total Sum FC % Total Sum FC %
Average FC % Average FC %
10.2 10.2
Nightly Revenue Generation re-cap Date: Today Nightly Revenue Generation re-cap Date: Today
Hour of Operation Guests Served Check Average Revenue Hour of Operation Guests Served Check Average Revenue
5–6 p.m. 118 $11.25 5–6 p.m. 118 $11.25 0.0%
6–7 p.m. 251 $13.25 6–7 p.m. 251 $13.25 0.0%
7–8 p.m. $13.97 $4,400.55 7–8 p.m. 0.0% $13.97 $4,400.55
8–9 p.m. 264 $12.98 8–9 p.m. 264 $12.98 0.0%
9–10 p.m. 102 $1,096.50 9–10 p.m. 102 0.0% $1,096.50
Total Total 0.0% 0.0% 0.0%
Table Turns = Table Turns = 0.0%
10.3 10.3
Lara’s Menu Mix Lara’s Menu Mix
Menu Item # Sold per 1,000 Guests Selling Price Revenue Menu Item # Sold per 1,000 Guests Selling Price Revenue
Salad 660 3.49 Salad 660 3.49 0.0%
Sub 812 6.99 Sub 812 6.99 0.0%
Chips 420 0.99 Chips 420 0.99 0.0%
Drinks 940 0.99 Drinks 940 0.99 0.0%
Total Revenue Total Revenue 0.0%
Check Average Check Average 0.0%
10.3 10.3
Part A Part A
Item Price Monday Revenue Check Average Item Price Monday Revenue Check Average
Chicken $ 14.95 30% Chicken $ 14.95 30% 0.0%
Brisket $ 18.95 50% Brisket $ 18.95 50% 0.0%
Links $ 11.95 20% Links $ 11.95 20% 0.0%
Total 0.0% 0.0%
Part B Part B
Item Price Tuesday Revenue Check Average Item Price Tuesday Revenue Check Average
Chicken $ 14.95 50% Chicken $ 14.95 50% 0.0%
Brisket $ 18.95 30% Brisket $ 18.95 30% 0.0%
Links $ 11.95 20% Links $ 11.95 20% 0.0%
Total 0.0% 0.0%
Part C Part C
Item Price Wednesday Revenue Check Average Item Price Wednesday Revenue Check Average
Chicken $ 14.95 20% Chicken $ 14.95 20% 0.0%
Brisket $ 18.95 30% Brisket $ 18.95 30% 0.0%
Links $ 11.95 50% Links $ 11.95 50% 0.0%
Total 0.0% 0.0%
Part D Part D
Day Revenue Check Average Day Revenue Check Average
Monday Monday 0.0%
Tuesday Tuesday 0.0%
Wednesday Wednesday 0.0%
Total 0.0% 0.0%

Chapter 10 (2)

Chapter 10 Apply What You Know-Student Worksheet
10.1
Menu Item Selling Price Product Cost Per Serving Labor Cost Food Cost % Prime Cost Contribution Margin
New York Strip $ 26.95 $ 12.97 $ 1.95 48.1% $ 14.92 $ 13.98
1/2 Duckling $ 25.95 $ 11.73 $ 2.55 45.2% $ 14.28 $ 14.22
Veal Chop $ 31.95 $ 13.85 $ 1.95 43.3% $ 15.80 $ 18.10
Roasted Free-Range Chicken $ 18.95 $ 6.53 $ 2.55 34.5% $ 9.08 $ 12.42
Pork Medallions $ 24.95 $ 5.58 $ 3.10 22.4% $ 8.68 $ 19.37
Portabella Mushroom Pasta $ 18.95 $ 3.85 $ 4.25 20.3% $ 8.10 $ 15.10
Total Sum FC % 213.8%
Average FC % 35.6%
10.2
Nightly Revenue Generation re-cap Date: Today
Hour of Operation Guests Served Check Average Revenue
5–6 p.m. 118 $11.25 $1,327.50
6–7 p.m. 251 $13.25 $3,325.75
7–8 p.m. 315 $13.97 $4,400.55
8–9 p.m. 264 $12.98 $3,426.72
9–10 p.m. 102 $10.75 $1,096.50
Total 1050 $12.93 $13,577.02
Table Turns = 3.5
10.3
Lara’s Menu Mix
Menu Item # Sold per 1,000 Guests Selling Price Revenue
Salad 660 3.49 $2,303.40
Sub 812 6.99 $5,675.88
Chips 420 0.99 $415.80
Drinks 940 0.99 $930.60
Total Revenue $9,325.68
Check Average $9.33
10.3
Part A
Item Price Monday Revenue Check Average
Chicken $ 14.95 30% $ 4,485.00
Brisket $ 18.95 50% $ 9,475.00
Links $ 11.95 20% $ 2,390.00
$ 16,350.00 $ 16.35
Part B
Item Price Tuesday Revenue Check Average
Chicken $ 14.95 50% $ 7,475.00
Brisket $ 18.95 30% $ 5,685.00
Links $ 11.95 20% $ 2,390.00
$ 15,550.00 $ 15.55
Part C
Item Price Wednesday Revenue Check Average
Chicken $ 14.95 20% $ 2,990.00
Brisket $ 18.95 30% $ 5,685.00
Links $ 11.95 50% $ 5,975.00
$ 14,650.00 $ 14.65
Part D
Day Revenue Check Average
Monday $ 16,350.00
Tuesday $ 15,550.00
Wednesday $ 14,650.00
$ 46,550.00 $ 15.52
Difference %