HTM 241 Name EX9-3: Labor Cost Variance analysis A hotel budged to sell 25,550 rooms per year at $60 per room. The housekeeper wage was budged to be $10 per hour. The stand cleaning time is 30 minutes per room per housekeeper At the end of the year, the actual number of rooms sold turned out to be 25,300 at an ADR of $62. Actual total cost of housekeeper wage was $140,000 and the actual cleaning time per room is 32 minutes ADR Time room Worked wage hours hour Room nights 25.550 Total Budget $60 30 S10 mins Actual $62 25,300 $140,000 mins Difference Q1: Complete the above table Q2: Analyze room revenue for price, volume and total variances. Q3: Analyze housekeeping wages for rate, volume, efficiency, and total variances. HTM 241 Name EX9-3: Labor Cost Variance analysis A hotel budged to sell 25,550 rooms per year at $60 per room. The housekeeper wage was budged to be $10 per hour. The stand cleaning time is 30 minutes per room per housekeeper At the end of the year, the actual number of rooms sold turned out to be 25,300 at an ADR of $62. Actual total cost of housekeeper wage was $140,000 and the actual cleaning time per room is 32 minutes ADR Time room Worked wage hours hour Room nights 25.550 Total Budget $60 30 S10 mins Actual $62 25,300 $140,000 mins Difference Q1: Complete the above table Q2: Analyze room revenue for price, volume and total variances. Q3: Analyze housekeeping wages for rate, volume, efficiency, and total variances