Answer To: SITXFIN004 Prepare and monitor budgets SITXFIN004 Prepare and monitor budgets XXXXXXXXXXRTO No:...
Tanmoy answered on Sep 07 2021
Write up and numerical on Hotel Management
Introduction
Hotel industry is growing globally around the world with new and branded companies constructing new hotels with modern amenities and various sophisticated technologies. Also, due to the rising cost of construction, hotels are trying to create a low cost construction technique combined with class and quality that helps them to minimize the operating costs. Hotel is a service industry and investment on training and imparting skills to enhance the serviceability of the employees working in hotel industry should be the ultimate goal of hotel industry. This will help them to create great values and augment the hotels to build their individual brands towards its customers. Investment on advertising and other operating expenses will rarely help to create higher return in the future for the hotel industries globally. We will discuss on the actual figures of the income statement of a hotel for 2018-19 and try to prepare a projected income statement for 2019-20 based on certain assumptions. We will also try to evaluate the variance and the percentage variance or changes by comparing the projected with the actual figures. We will also project the income statement based on a 28% increase in the net profit compared to the actual figures of 2018-19.
Income statement of a Hotel (Actual and Budgeted)
2018 - 2019
2019 - 2020
Variance
Percentage Change
Profit Increase to 28%
Current Budget
With cost increases
Revenue
$
$
$
$
Food
2,19,000.00
2,62,800.00
$43,800.00
20.00%
2,62,800.00
Beverage
73,000.00
87,600.00
$14,600.00
20.00%
87,600.00
Accommodation
4,34,000.00
7,24,092.00
$2,90,092.00
66.84%
7,24,092.00
Total Revenue
7,26,000.00
10,74,492.00
$3,48,492.00
48.00%
10,74,492.00
Cost of Sales
$
$
$
$
Food (25%)
54,750.00
65,700.00
$10,950.00
20.00%
65,700.00
Beverage (30%)
21,900.00
26,280.00
$4,380.00
20.00%
26,280.00
Accommodation (20%)
86,800.00
1,44,818.40
$58,018.40
66.84%
1,44,818.40
Total COGS
1,63,450.00
2,36,798.40
$73,348.40
44.88%
2,36,798.40
Gross Profit
5,62,550.00
8,37,693.60
$2,75,143.60
48.91%
8,37,693.60
Operating Expenses
$
$
$
$
Wages
1,81,500.00
2,68,623.00
$87,123.00
48.00%
2,68,623.00
Operating supplies
36,000.00
53,724.60
$17,724.60
49.24%
75,214.44
Administration
18,000.00
21,489.84
$3,489.84
19.39%
53,724.60
Advertising
36,000.00
53,724.60
$17,724.60
49.24%
32,403.95
Maintenance
20,000.00
32,234.76
$12,234.76
61.17%
53,724.60
Utilities
32,000.00
42,979.68
$10,979.68
34.31%
54,799.09
Depreciation
10,000.00
10,744.92
$744.92
7.45%
10,744.92
Interest
17,500.00
17,675.00
$175.00
1.00%
17,675.00
Total Operating Costs
3,51,000.00
5,01,196.40
$1,50,196.40
42.79%
5,66,909.60
Net profit before...