Question

Hot Pot Restaurant has the following information:

customer count, daily sales, food cost percentage, and labor cost percentage information.  The establishment does not estimate beverage cost separately.

Completed the forecast daily sales, average check, food cost percentage, food cost, labor cost and labor cost percentage.

	Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday	Totals/Avg
Customer count	104	62	76	100	146	200	150
Daily sales ($)	$2,300.	$1,563	$1,876	$2,694.	$4,151.	$5,183.	$6000.
Average check per customer ($)	?	?	?	?	?	?	?	?
Food cost (%)	27%	28%	29%	28%	30%	31%	33%	?
Food cost budget ($)	?	?	?	?	?	?	?	?
Labor cost (%)	25%	28%	30%	29%	29%	30%	32%	?
Labor cost budget ($)	?	?	?	?	?	?	?	?

Answer 1

In excel :

Average check per customer for Sunday=C5=C4/C3

(Drag this cell formula to the right for rest of the days )

Food cost budget for Sunday=C7=C6*C4

(Drag this cell formula to the right for rest of the days )

Labor cost budget=C9=C8*C4

(Drag this cell formula to the right for rest of the days )

Totals/Avg for Average check per customer =SUM(C5:I5)/AVERAGE(C5:I5)

(Drag this cell formula down for rest of entries )

The calculations are as shown below :

С5 Sunday Monday Tuesday WednesdaThursday Friday Saturday Totals/Av Customer count Daily sales(S Average check per customer Food cost(% Food cost budget Labor cost(% Labor cost budget 104 62 100 146 76 200 150 2300 2694 4151 1563 1876 5183 6000 22.1 25.2 24.7 26.9 28.4 25.9 40.0 0.28 0.3 0.27 0.29 0.28 0.31 0.33 544.0 621.0 437.6 754.31245.3 1606.71980.0 0.28 0.3 0.3 0.25 0.29 0.29 0.32 575.0 437.6 562.8 781.3 1203.81554.9 1920.0