Reference no: EM13966547

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.

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.)

You already work on this question only with the analysis portion(Calculation) of the question looks good.  There is supposed to be an essay portion that consists of 350 to 700 words in which I do not believe I see from you. 

Here is what needs to be provided: