Essay Business Applications for Hospitality Industry – Calculate the Itemized Labour Cost – Management Assignment Help

Assignment Task:

Premise

You are the manager of a large hotel.  You’re told that 120 guests will be staying in your establishment for a mid-week conference.  The client has requested double occupancy only.  The guests will be arriving on Monday morning and staying until Thursday afternoon.

You will be responsible for providing a daily buffet-style breakfast and lunch with a formal sit-down dinner services.  The breakfast is to be ready by 7:00 am and finished by 8:30 am.  Lunch is to be served promptly at noon and to be finished by 1 pm.  Dinner is scheduled to start at 6:00 pm and go until 8:00pm

Task :

You are to provide the required staff schedule, which is to be posted on your hotel’s intranet so the staff can access it easily.  In addition to the schedule, you must also calculate the itemized labour cost.  Remember you are not concerned with any other costs other than labour.  To accomplish this you develop the following:

Requirements :

• There must be a completed Documentation Page & each sheet tab should be renamed and recoloured
• The name of your establishment should be centered at the top of each worksheet
• There should be appropriate use of cell styles, clip art, etc.
• There will be a custom footer with the hotel name in the bottom left and the date in the bottom right
• Provide a chart sheet detailing the labour cost.  You decide the style of chart that best shows your data
• The Labour Cost worksheet should include subtotals for each category