You are to complete a budget for the first half of the fiscal year starting July 1 for this 100 room hotel. You will need to figure all revenues and expenses for both Rooms and Food & Beverage Departments. Put all budget information into a P&L format in Excel.

Here are some assumptions that need to be made:

• Occupancy should be raised by 3%
• ADR should go up by 2%
• Average RPOR(Revenue Per Occupied Room) should go up by 2%
• Food Cost should be at 30%
• Beverage Cost should be at 29%
• Labor for F&B should run 25% for BOH(food production- use food revenue only for BOH) and 22% for FOH(service staff)

• Labor for Front Office- Front Office= 12% and Bell Staff=6%

Rooms Info

Month	Rooms Occupied	ADR
July	1825	$131.10
August	2165	$119.36
September	2478	$124.67
October	2635	$126.45
November	2243	$118.22
December	2085	$123.96
January	1980	$121.56
February	1840	$120.89
March	2033	$125.50
April	2180	$124.25
May	2475	$122.11
June	2516	$123.86

Van Costs= $2.10 per occupied room

Commissions= $3.00 per occupied rooms

HVAC= $1100/month

Other expenses= 3% of sales

Salaries= $3200/month

F&B Info

Month	Covers	Average Check
July	2840	$25.01
August	3015	$23.25
September	3269	$22.98
October	3126	$23.76
November	2945	$24.63
December	3096	$25.44
January	2930	$24.75
February	2615	$24.18
March	2728	$23.12
April	2780	$23.77
May	3199	$24.54
June	3054	$25.76

Salaries=$4900/month

Beverage Distribution average 21%

Marketing= $350/month

Other Expenses= $1.60/per cover

Below is the template:

Beverage Revenue

July

August

September

October

November

December

January

February

March

April

May

June

Rooms Revenue

Food Revenue

Beverage Revenue

Total Revenue

Cost of Sales

Cost of Sales- Food

Cost of Sales- Beverage

Total Cost of Sales

Gross Revenue

Expenses

Professional Wages

Front Office Salaries

F&B Salaries

Total Professional Wages

Service Wages

Front Office Wages

Bell Staff Wages

Service Staff Wages

Food Production Wages

Total Service Wages

Operating Expenses

Transportation

Commissions

HVAC

Marketing

Hotel Other Expenses

F&B other expenses

Total Operating Expenses

Total Expenses

Net Profit/Loss