02.04.2012
02.04.2012

SCM HOTEL | MODULE ASSIGNMENT PDO PART C |

SCM HOTEL | MODULE ASSIGNMENT PDO PART C |

Other Operating Expenses at the company which makes a high turnover and a bad staff satibout . e in the HOTS game.

Year: 2011-2012
Module: 3

Team 8

Other Operating Expenses at the company which makes a high turnover and a bad staff satibout . e in the HOTS game.
Year: 2011-2012
Module: 3
Class: 2PDOd
Team 8

Inhalt 1 Performance dashboard year 2 & 3: 3 Total turnover 4 Figure 1; Total revenue. 4 Figure 2; Net income 5 Figure 3; Total rooms sold 6 Figure 4; Room occupancy % 7 Figure 5; The average room rate (ARR) 8 Figure 6; Revenue per available room (RevPAR) 9 Figure; 7 Public awareness 10 Figure 8; …show more content…

The figure shows that only year 1 is relatively stable year 1 and 3 are very unstable and fluctuated every month. In year zero the staff turnover was the lowest with an average of 27.53%, in year 1 it increased to the percentage of 43.44%, in year 2 it increased again while the average was 64.13% and in year 3 this was the highest with an average of 70.34%.

Benchmark Internal year 2 & 3 using variance analysis

In this chapter the differences between the budget and the actual results from year 2 and 3 will be given. A table with the estimated budget which were made in HOTS assignment part B will be shown and explanation for the actual results will be given. The budget in assignment B was based on the results of year 1. | Year 1 | Budget y2 | Budget y3 | Sales | | | | Rooms | 3.834.606,00 | 6.820.937,50 | 9.695.312,50 | Food | 1.943.338,00 | 2.332.005,60 | 2.681.806,44 | Beverage | 887.156,00 | 505.689,20 | 581.542,58 | Other | 328.258,00 | 393.909,60 | 452.996,04 | | 6.993.358,00 | 10.052.541,90 | 13.411.657,56 | | | | | Cost of Sales | | | | Room | 18.321,00 | 32.589,11 | 82.397,41 | Food & Bev | 1.182.670,00 | 1.185.678,72 | 1.366.999,36 | Other | 62.957,00 | 75.548,40 | 104.256,79 | | 1.263.948,00 | 1.293.816,23 | 1.553.653,57 | | | | | Payroll & Related | | | | Front office | 203.371,00 | 166.799,36 | 208.499,20 | House keeping |