Food and Beverage Metrics Lab: Calculations for Restaurant

BUS8510 Food and Beverage Metrics Hours: 11:00 am - 10:00 pm Assignment ALL CELLS highlighted in yellow are required. Do not rewrite already established formulas. Do not edit "X" Cells Restaurant: The Keg Steakhouse Size: 115 seat dining room Location: Waterloo, Ontario Using the information on the "calculations" tab, complete the missing in category listed. Utilize formula's to expedite the process and assist in th making changes

nformation for each he future when

Total points = 50 points (1 point each) 1. Revenue Per Available Seat Hour (REVPASH) Lunch Hour Available Seats Guests Served 11a.m–12 p.m. 115 58 12–1 p.m. 115 58 1–2 p.m. 115 58 2–3 p.m. 115 58 3–4 p.m. 115 58 Total 575 290 Dinner 4–5 p.m. 115 26 5–6 p.m. 115 68 6–7 p.m. 115 132 7–8 p.m. 115 185 8–9 p.m. 115 107 9–10 p.m. 115 67 Total 690 585 2. Seat Utilization Lunch Hour Available Seats Guests Served 11a.m–12 p.m. 115 58

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

12–1 p.m. 115 112 1–2 p.m. 115 85 2–3 p.m. 115 43 3–4 p.m. 115 22 Dinner 4–5 p.m. 115 26 5–6 p.m. 115 68 6–7 p.m. 115 132 7–8 p.m. 115 185 8–9 p.m. 115 107 9–10 p.m. 115 67 Total 690 585 3. Average Guest Cheque Lunch Hour Available Seats Guests Served 11a.m–12 p.m. 115 58 12–1 p.m. 115 112 1–2 p.m. 115 85 2–3 p.m. 115 43 3–4 p.m. 115 22 Dinner

4–5 p.m. 115 26 5–6 p.m. 115 68 6–7 p.m. 115 132 7–8 p.m. 115 185 8–9 p.m. 115 107 9–10 p.m. 115 67 Total 690 585

2 Decimal Places Revenue REVPASH $925 $ 8.04 $2,770 $ 24.09 4. What is t $1,675 $ 14.57 $690 $ 6.00 $410 $ 3.57 SEAT UT $6,470 $11.25 AVE. GUES $610 $5.30 $1,550 $13.48 $4,125 $35.87 $3,690 $32.09 $1,600 $13.91 $1,570 $13.65 13145 $19.05 2 Decimal Places Revenue $925 50.43% Seat Utilization %

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

$2,770 97.39% $1,675 73.91% $690 37.39% $410 19.13% $610 22.61% $1,550 59.13% $4,125 114.78% $3,690 160.87% $1,600 93.04% $1,570 58.26% 13145 84.78% 2 Decimal Places Revenue $925 $15.95 $2,770 $24.73 $1,675 $19.71 $690 $16.05 $410 $18.64 Average Guest Cheque $

$610 $23.46 $1,550 $22.79 $4,125 $31.25 $3,690 $19.95 $1,600 $14.95 $1,570 $23.43 13145 $22.47

the restaurants average results for the entire day? REVPASH for the day is: $ 15.15 TILIZATION for the day is: ST CHEQUE for the day is:

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

BUS8510- - Practical Lab 4 - Food and Beverage Metrics

Related Documents