I only need number #2 to be answered.
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 SO CHAPTER 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,59 rooms and 11.980 corets, and serviced 3,645 meeting guests Daily Payroll Report Canyon Hotel and Meeting Center November 20, 2009 Daily Hours Daily Laler Cost Regular Overtime Total Payroll Cost/Room 4602 0.50 46.52 $69.53 18.01 0.00 18.01 $285.64 1.08 27.78 5324.55 42.129.2251.38847 Month-le-Dute M-T-D Hours M-T-D Labor Cost Regular Overtime Total Payroll Cow/Room 69.58 9.00 707.5 510,57444 273.19 0.00 27319 54.339.99 105.31 16.20 4211 54,923.28 1,892.50 86.40 1.98.905214001 Bulgate Labor Cou Cout/Roone SAN 52.75 51.00 $12.87 26.70 125.00 Category Rooms Front Desk Reservat Guest Services Housekeeping Total Rooms Food and Beverage Banque Service In-mom Dining Greenleaf Restaurant Flower Care General Tolu FOR Cod Cour Cost Cover Cost Cover 5191 24.00 105 35 1865 3314 30665.99 5969.64 0.00 24.00 $173.52 0.00 105.35 $1.107.23 0.00 18.95 5113,70 3.16 247.60 55,514.28 91885 1412 1,599.21 287.66 105.2 1.034.17 $16.033.5 16.00 30.12 $2.0755 12.3 1.611.56 $17.00.43 11.08 293.74 $1.76 14327140.45 $115.072 ON SES 507 Cast Meeting Cond Meeting G 42.40 56.00 Cost/Newting GR 46140 in 00 Meetings keting Management Audio Morting Attendant Meeting For Metin Conce Total Sleting 235 44.75 51.044.79 0.00 0.00 5911.12 5527.01 0.00 $170.65 7.09 TL4 SR24 2:15 1945 S11,70431 614.80510110 65.32 1.121.32 Sh.000.0 0.00 295 $19.6. 12.05 1191 MDS14517 Ins 10-25 1.173 QUESTIONS 1. 2. 3. Calculate the labor cost per unit for November 20 and the month-to-date labor cost per unit, and then total each column. (Ful in the gray shaded areas in the daily payroll roport provided) 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? 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 SO CHAPTER 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,59 rooms and 11.980 corets, and serviced 3,645 meeting guests Daily Payroll Report Canyon Hotel and Meeting Center November 20, 2009 Daily Hours Daily Laler Cost Regular Overtime Total Payroll Cost/Room 4602 0.50 46.52 $69.53 18.01 0.00 18.01 $285.64 1.08 27.78 5324.55 42.129.2251.38847 Month-le-Dute M-T-D Hours M-T-D Labor Cost Regular Overtime Total Payroll Cow/Room 69.58 9.00 707.5 510,57444 273.19 0.00 27319 54.339.99 105.31 16.20 4211 54,923.28 1,892.50 86.40 1.98.905214001 Bulgate Labor Cou Cout/Roone SAN 52.75 51.00 $12.87 26.70 125.00 Category Rooms Front Desk Reservat Guest Services Housekeeping Total Rooms Food and Beverage Banque Service In-mom Dining Greenleaf Restaurant Flower Care General Tolu FOR Cod Cour Cost Cover Cost Cover 5191 24.00 105 35 1865 3314 30665.99 5969.64 0.00 24.00 $173.52 0.00 105.35 $1.107.23 0.00 18.95 5113,70 3.16 247.60 55,514.28 91885 1412 1,599.21 287.66 105.2 1.034.17 $16.033.5 16.00 30.12 $2.0755 12.3 1.611.56 $17.00.43 11.08 293.74 $1.76 14327140.45 $115.072 ON SES 507 Cast Meeting Cond Meeting G 42.40 56.00 Cost/Newting GR 46140 in 00 Meetings keting Management Audio Morting Attendant Meeting For Metin Conce Total Sleting 235 44.75 51.044.79 0.00 0.00 5911.12 5527.01 0.00 $170.65 7.09 TL4 SR24 2:15 1945 S11,70431 614.80510110 65.32 1.121.32 Sh.000.0 0.00 295 $19.6. 12.05 1191 MDS14517 Ins 10-25 1.173 QUESTIONS 1. 2. 3. Calculate the labor cost per unit for November 20 and the month-to-date labor cost per unit, and then total each column. (Ful in the gray shaded areas in the daily payroll roport provided) 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
