Following are data from Room Department of 80-room Windy Hotel in December 2019 Budget of Dec...

  

Transcribed Image Text:

Following are data from Room Department of 80-room Windy Hotel in December 2019 Budget of Dec 2019 Room revenues Occupancy percentage Dec 2018 $63,875 60% 3. Rooms cleaned per shift 4. Front office wage cost percentage 5. Wage cost per occupied room 6. Housekeeping wage cost percentage 7. Revenues per employee hour worked 8. Comment on Room Department productivity in Dec 2019. $19,163 10 4 4 $71,175 Wage cost Number of full-time employees -Front office staff (employee) -Housekeepers (employee) Number of casual labor hours (part-time) The full-time employees are off 4 days a month and not used for working overtime. The average salary of front office and housekeeping is $2.500 and $1,000 per month per employee respectively. Wage of casual labor $10 per hour per employee. Total part-time hours in Dec 2018, Budget of Dec 2018 and Dec 2019 are 200, 250 and 250 hours respectively. 200 65% $21.333 10 4 4 Dec 2019 250 Required: 1. Calculate the following ratios in December of last year, the budget, and the current year: 2. Labor hours per room sold $72,392 68% $20,333 10 4 4 250 Following are data from Room Department of 80-room Windy Hotel in December 2019 Budget of Dec 2019 Room revenues Occupancy percentage Dec 2018 $63,875 60% 3. Rooms cleaned per shift 4. Front office wage cost percentage 5. Wage cost per occupied room 6. Housekeeping wage cost percentage 7. Revenues per employee hour worked 8. Comment on Room Department productivity in Dec 2019. $19,163 10 4 4 $71,175 Wage cost Number of full-time employees -Front office staff (employee) -Housekeepers (employee) Number of casual labor hours (part-time) The full-time employees are off 4 days a month and not used for working overtime. The average salary of front office and housekeeping is $2.500 and $1,000 per month per employee respectively. Wage of casual labor $10 per hour per employee. Total part-time hours in Dec 2018, Budget of Dec 2018 and Dec 2019 are 200, 250 and 250 hours respectively. 200 65% $21.333 10 4 4 Dec 2019 250 Required: 1. Calculate the following ratios in December of last year, the budget, and the current year: 2. Labor hours per room sold $72,392 68% $20,333 10 4 4 250

Answer rating: 100% (QA)

Lets calculate the requested ratios and values for December of the last year Dec 2018 the budget for Dec 2019 and the actual performance in Dec 2019 O... View the full answer