Readthe Phoenix Hotel Consultation Project: Cost Analysis document and follow the assignment instructions.

Phoenix Hotel Consultation Project:Cost Analysis HTT/231 Version 2 University of Phoenix Material Phoenix Hotel Consultation Project: Cost Analysis Project Details You have been hired as a consultant for the Phoenix Hotel. In your role as a consultant to the Phoenix Hotel, you have been asked to perform a cost analysis of payroll costs in an effort to effectively budget in the coming quarters. The Phoenix Hotel is a full service property with a restaurant and conference facility. The Phoenix Hotel is a busy property catering to corporate clients as well as conventions. The labor usage tends to fluctuate up and down depending on where the action is because the property has so many different revenue outlets (sleeping rooms, conference facility, and restaurant). The General Manager of the Phoenix Hotel has taken the time and effort to work with each of the department heads to establish labor budgets for the month based on the forecasted levels of business. Since hospitality business can fluctuate, these labor budgets are targets and the staffing levels need to be adjusted based on business levels. You have been asked to evaluate the Daily Payroll Report provided by the general manager and evaluate how the property is operating today and for the month so far. In addition, the general manager has asked for you to suggest corrective action if you notice any departments that are off target. For this project you will: Review the Project Cost Analysis Data for the Phoenix Hotel. Research the methods for calculating hotel occupancy percentages, average daily rates (ADR), and revenue per available room (RevPAR). Write a 350- to 700- word summary of your findings as a consultant in the Hospitality industry to include the following: A summary of your analysis of the payroll data to include any departures from budgeted or abnormalities you see in each of the operating departments. Your recommendations for the Phoenix Hotel of corrective action tha can be taken to ensure the hotel meets its payroll objectives. Provide support for your recommendations. Copyright 2015 by University of Phoenix. All rights reserved. 1 Phoenix Hotel Consultation Project: Cost Analysis Data Phoenix Hotel Daily Payroll Report The Phoenix Hotel is a full service property with a restaurant and conference facility. The Phoenix Hotel is a busy property catering to corporate clients as well as conventions. The labor usage tends to fluctuate up and down depending on where the action is because the property has so many different revenue outlets (sleeping rooms, conference facility, and restaurant). Because the majority of the business is done during the day, room totals do not tend to coincide with food sales and the number of meeting guests. For example, on June 18, the hotel sold 213 rooms and 703 food covers, and serviced 512 meeting guests. As of June 18 (month-to-date), the Phoenix Hotel sold 1,593 rooms and 11,980 covers, and serviced 3,645 meeting guests. As you review the Daily Payroll Report for June 18, 2015, you will need to calculate the labor cost per unit for June 18 and the month-to-date labor cost per unit, and then total each column. (Fill in the gray shaded areas in the daily payroll report on the following page.) Copyright 2015 by University of Phoenix. All rights reserved. Phoenix Hotel Consultation Project:Cost Analysis Data HTT/231 Version 2 2 Daily Payroll Report Phoenix Hotel June 18, 2015 Daily Month-to-Date Category Rooms Regular Overtime Total Payroll $ Front Desk 46.02 0.50 46.52 Reservations 18.01 0.00 Guest Svc. 26.70 Housekeeping 125.00 Labor Cost Cost / Room Budget Regular Overtime Total Payroll $ Labor Cost Cost / Room Labor Cost Cost / Room $694.53 698.58 9.00 707.58 $10,574 $5.68 18.01 $285.64 273.39 0.00 273.39 $4,335 $2.75 1.08 27.78 $324.55 405.31 16.20 421.51 $4,923 $3.00 4.32 129.32 $1388.43 1,897.50 86.40 1,983.90 $21,406 $12.87 Total Rooms Food and Beverage Cost / Cover Cost / Cover Cost / Cover Banquet Svc. 60.53 3.06 63.59 $969.64 918.85 105.32 1,024.17 $16,033 $2.91 In-room 24.00 0.00 24.00 $173.52 364.32 16.00 380.32 $2,807 $9.83 Restaurant 105.35 0.00 105.35 $1,107.23 1,599.21 12.35 1,611.56 $17,002 $3.85 Caf 18.95 0.00 18.95 $113.70 287.66 6.08 293.74 $1,780 $6.72 General 233.84 3.16 237.00 $3,514.28 7,597.18 143.27 7,740.45 $115,072 $0.78 Total F&B Meetings Cost / Mtg Gst Cost / Mtg Gst Cost / Mtg Gst Meeting Mgt. 42.40 2.35 44.75 $1,044.79 466.40 32.05 498.45 $11,704 $3.25 Audio/Visual 56.00 0.00 56.00 $911.12 616.00 3.60 619.60 $10,110 $3.46 Meeting Atd. 96.00 3.65 99.65 $527.67 1,056.00 65.32 1,121.32 $6,000 $1.45 Meeting Floor 116.35 0.00 116.35 $1,790.63 1,279.85 0.00 1,279.85 $19,696 $5.60 Concierge 107.25 4.09 111.34 $1,374.23 1,179.75 12.05 1,191.80 $14,517 $2.32 Total Mtgs. Copyright 2015 by University of Phoenix. All rights reserved