Question

Your local hotel has a dining room which has the capacity to seat 140 guests. It is opened for breakfast and lunch seven days a week and fully expects to be at capacity at these times. During January 2021, management has forecast the seat turnover for breakfast will be 3 times and for lunch 2 times, with the average bill to be $28 for breakfast and $58 for lunch. Beverage revenue is usually 12 per cent of the breakfast revenue and 28 per cent of the lunch revenue.  

Calculate budgeted total revenue of food and beverage for the 31 days of January 2021. Express the answer as a daily food and beverage outcome and also a monthly figure.

Answer 1

Budgeted total revenue of food and beverage for the month of January 2021:

Particulars	Seat capacity		Seat turnover		Guests served		Average billing		Daily food revenue	Beverage %	Beverage revenue	Total revenue	Number of days	Monthly
	A		B		A*B=C		D		C*D=E	F	E*F=G	E+G=H	I	H*I
Breakfast		140		3		420		28	11,760	12%	1,411.20	13,171.20	31	408,307.20
Lunch		140		2		280		58	16,240	28%	4,547.20	20,787.20	31	644,403.20
Total						700			28,000		5,958.40	33,958.40		1,052,710.40

Daily food and beverage outcome and a monthly figure for budgeted total revenue of food and beverage for the 31 days of January 2021:

Particulars	Daily Revenue	Monthly Revenue
Daily food revenue	Beverage revenue	Daily food revenue	Beverage revenue
	A	B	A*31	B*31
Breakfast	11,760.00	1,411.20	364,560.00	43,747.20
Lunch	16,240.00	4,547.20	503,440.00	140,963.20
Total	28,000.00	5,958.40	868,000.00	184,710.40
33,958.40	1,052,710.40