Budgeting for Hotel Futura: Revenue and Expense Forecast

Running head: BUDGETING
Budgeting
Name of the student
Name of the university
Student ID
Author note

1BUDGETING
Table of Contents
Task 1.........................................................................................................................................2
Task 2.........................................................................................................................................2
Task 3.........................................................................................................................................2
Scenario 1...............................................................................................................................2
Scenario 2...............................................................................................................................3
Scenario 3...............................................................................................................................4
Reference....................................................................................................................................6

2BUDGETING
Task 1
Hotel Futura Budget Forecast
Total Revenue
2016
$
129,59,085.
46
$
-
Forecaste
d 2017
Total
expenses
$
60,79,149.7
0
Room Budget Forecast
$
Forecast
%
Expenses Analysis
Rooms Available 61320 96% COGS $
11,03,760.0
0
15
%
Rooms Occupied 49056 Staff
costs
$
14,71,680.0
0
20
%
Total Occupancy
%
80.00 80.70% Other
Expenses
$
5,88,672.00
8%
Revenue Per
Available Room
$
150.00
Total
Expenses
$
31,64,112.0
0
Total Room
Revenue
$
73,58,400.0
0
Total Catering
Revenue
$
56,00,685.4

3BUDGETING
6
Food Budget
(Restaurants)
Expenses Analysis
Total Revenue $
23,02,728.0
7
COGS
Food Revenue $
20,01,129.7
3
86.90% Staff
costs
$
10,13,200.3
5
44
%
Beverage Revenue $
3,01,598.34
13.10% Other
Expenses
$
1,61,190.96
7%
Total
Expenses
$
11,74,391.3
2
Banquet Budget Expenses Analysis
Total Revenue $
23,21,539.4
5
COGS $
6,03,600.26
26
%
Food Revenue $
20,00,000.0
0
86.15% Staff
costs
$
4,41,092.50
19
%
Beverage Revenue $
3,21,539.45
13.85% Other
Expenses
$
3,25,015.52
14
%
Total
expenses
$
13,69,708.2