Budget Preparation

Based on the information below, prepare an operating budget.

Thesales budgetis to be based on the anticipated volumes of business activity indicated by the figures in the table below:

January February March April May June Budget Budget Budget Budget Budget Budget Breakfast No of Guests / Day 30 30 30 30 30 30 AVG $ spent per Guest 20 20 20 20 20 20 Lunch No of Guests / Day 50 50 50 50 50 50 AVG $ spent per Guest 30 30 30 30 30 30 Dinner No of Guests / Day 45 45 45 45 45 45 AVG $ spent per Guest 40 40 40 40 40 40 Days in month* 31 28 31 30 31 30Statement of operation for the 6-month period ending 30 June 2021 January February March April May June Actual Actual Actual Actual Actual Actual Revenue Breakfast 22,444 19,096 23,529 24,480 26,784 27,360 Lunch 59,675 52,360 55,242 48,000 43,245 36,000 Dinner 58,590 49,392 50,840 43,320 43,524 36,750 Total COGS 39,416 31,420 40,179 39,372 43,524 34,037 Total Payroll 39,416 31,420 40,179 39,372 43,150 34,037 Other Operating Expenses Rent of Premises 9,900 9,900 9,900 10,890 10,890 10,890 Advertising 6,300 4,500 4,000 4,000 3,500 3,500 Electricity 2,370 2,370 2,370 2,511 2,511 2,511 Gas 911 911 911 812 812 812 Telephone 390 390 390 390 390 390 Chemicals 3,007 2,858 3,016 2,958 12,935 2,901 Linen Cleaning and Hire 4,865 4,486 4,682 4,416 4,421 4,202 Bank Interest 5,000 5,000 5,000 6,500 6,500 6,500