1. Analyze the daily payroll report, noting any major departures from the budgeted amounts. If you were the general manager for this property, what actions would you take and why?

Concept Check The Canyon Hotel and Meeting Center is a popular property among the many local corporations that hold meetings there. This hotel is conveniently located near a major metropolitan area, with easy access from several major highways. Because the majority of the business is done during 50 CHAPTER 2 - FINANCIAL REPORTING the day, room totals do not tend to coincide with food sales and the number of meeting guests. For example, on November 20, the hotel sold 213 rooms and 703 food covers, and serviced 512 meeting guests. Mr. Stan Domla is the general manager of the Canyon Hotel, and one of his responsibilities is to review the daily payroll report created by the department heads at the property. Mr. Domla has to check the reports for inconsistencies and make sure each department is meeting its budgeted goals. Not only does he need to look at today's numbers but also at the month-to-date calculations to determine if there are any trends. As of November 20, the Canyon Hotel and Meeting Center sold 1,593 rooms and 11,980 covers, and serviced 3,645 meeting guests. Total Category Rooms | Daily Regular Daily Payroll Regular Hour Over Time Over Time Hours Total PaxRolls Labor Cost Cost Room 0.50 0.00 1.08 4.32 5.90 46.52 $694.53 18.01 $285.64 27.78 $324.55 129.32 $1,388.43 222.35 2,693.15 3.26 1.34 1.52 6.52 12.64 Cost Cover 1.38 698.58 273.39 405.31 1,897.50 3,265.78 9.00 707.58 0.00 273.39 16.20 421.51 86.40 1,983.90 111.60 3.386.38 $10,574.44 $4.335.99 $4,923.28 $21,406.18 $41,239.89 M-T-D Labor Cost Cost Room 6.64 2.72 3.09 13.44 25.89 Cost Cover 1.34 Budget Labor Cost Cost Room $5.68 $2.75 $3.00 $12.87 $24.30 3.06 63.59 $969.64 918.85 105.32 1,024.17 $16,033.93 $2.91 Front Desk 46.02 Reservations 18.01 Guest Service 26.70 Housekeeping 125.00 Total Rooms 215.73 Food and Beverage Banquet 60.53 Service In-Room 24.00 Dining Greenleaf 105.35 Restaurant Flower Caf 18.95 General 233.84 Total F&B 442.67 0.00 24.00 $173.52 0.25 364.32 16.00 380.32 $2,807.55 0.23 $9.83 0.00 105.35 $1,107.23 1.58 1,599.21 12.35 1,611.56 $17,002.43 1.42 $3.85 0.00 3.16 6.22 18.95 $113.70 237.00 $3,514.28 448.89 $5,878.37 0.16 5.00 8.36 287.66 7,597.18 10,767.22 6.08 143.27 283.02 293.74 $1,780.69 7,740.45 $115,072.08 11,050.2 $152,696.68 4 0.15 9.61 12.75 $6.72 $0.78 $24.09 Meetings Cost Meetin Cost Meeting Cost 3.21 g Cost 42.40 2.35 44.75 $1,044.79 99.70 446.40 32.05 498.45 $11,704.31 $3.25 3.60 56.00 96.00 0.00 3.65 56.00 99.65 $911.12 $527.67 1.78 1.03 616.00 1,056.00 619.60 $10,110.18 1,121.32 $6,000.70 2.77 1.65 $3.46 $1.45 65.32 Meeting Management Audio-Visual Meeting Attendants Meeting Floor Meeting Concierge Total Meetings 116.35 0.00 116.35 $1,790.63 3.50 1,279.85 0.00 1,279.85 $19,696.89 5.40 $5.60 107.25 4.09 111.34 $1,374.23 2.68 1,179.75 12.05 1,191.80 $14,517.64 3.98 $2.32 418.00 10.09 428.09 $5,648.44 108.69 4,578.00 113.02 4711.02 $62,029.72 17.01 16.08 Concept Check The Canyon Hotel and Meeting Center is a popular property among the many local corporations that hold meetings there. This hotel is conveniently located near a major metropolitan area, with easy access from several major highways. Because the majority of the business is done during 50 CHAPTER 2 - FINANCIAL REPORTING the day, room totals do not tend to coincide with food sales and the number of meeting guests. For example, on November 20, the hotel sold 213 rooms and 703 food covers, and serviced 512 meeting guests. Mr. Stan Domla is the general manager of the Canyon Hotel, and one of his responsibilities is to review the daily payroll report created by the department heads at the property. Mr. Domla has to check the reports for inconsistencies and make sure each department is meeting its budgeted goals. Not only does he need to look at today's numbers but also at the month-to-date calculations to determine if there are any trends. As of November 20, the Canyon Hotel and Meeting Center sold 1,593 rooms and 11,980 covers, and serviced 3,645 meeting guests. Total Category Rooms | Daily Regular Daily Payroll Regular Hour Over Time Over Time Hours Total PaxRolls Labor Cost Cost Room 0.50 0.00 1.08 4.32 5.90 46.52 $694.53 18.01 $285.64 27.78 $324.55 129.32 $1,388.43 222.35 2,693.15 3.26 1.34 1.52 6.52 12.64 Cost Cover 1.38 698.58 273.39 405.31 1,897.50 3,265.78 9.00 707.58 0.00 273.39 16.20 421.51 86.40 1,983.90 111.60 3.386.38 $10,574.44 $4.335.99 $4,923.28 $21,406.18 $41,239.89 M-T-D Labor Cost Cost Room 6.64 2.72 3.09 13.44 25.89 Cost Cover 1.34 Budget Labor Cost Cost Room $5.68 $2.75 $3.00 $12.87 $24.30 3.06 63.59 $969.64 918.85 105.32 1,024.17 $16,033.93 $2.91 Front Desk 46.02 Reservations 18.01 Guest Service 26.70 Housekeeping 125.00 Total Rooms 215.73 Food and Beverage Banquet 60.53 Service In-Room 24.00 Dining Greenleaf 105.35 Restaurant Flower Caf 18.95 General 233.84 Total F&B 442.67 0.00 24.00 $173.52 0.25 364.32 16.00 380.32 $2,807.55 0.23 $9.83 0.00 105.35 $1,107.23 1.58 1,599.21 12.35 1,611.56 $17,002.43 1.42 $3.85 0.00 3.16 6.22 18.95 $113.70 237.00 $3,514.28 448.89 $5,878.37 0.16 5.00 8.36 287.66 7,597.18 10,767.22 6.08 143.27 283.02 293.74 $1,780.69 7,740.45 $115,072.08 11,050.2 $152,696.68 4 0.15 9.61 12.75 $6.72 $0.78 $24.09 Meetings Cost Meetin Cost Meeting Cost 3.21 g Cost 42.40 2.35 44.75 $1,044.79 99.70 446.40 32.05 498.45 $11,704.31 $3.25 3.60 56.00 96.00 0.00 3.65 56.00 99.65 $911.12 $527.67 1.78 1.03 616.00 1,056.00 619.60 $10,110.18 1,121.32 $6,000.70 2.77 1.65 $3.46 $1.45 65.32 Meeting Management Audio-Visual Meeting Attendants Meeting Floor Meeting Concierge Total Meetings 116.35 0.00 116.35 $1,790.63 3.50 1,279.85 0.00 1,279.85 $19,696.89 5.40 $5.60 107.25 4.09 111.34 $1,374.23 2.68 1,179.75 12.05 1,191.80 $14,517.64 3.98 $2.32 418.00 10.09 428.09 $5,648.44 108.69 4,578.00 113.02 4711.02 $62,029.72 17.01 16.08