You are the executive housekeeper of the Royal Hotel, London. It is September and the rooms divis… 1 answer below »

 
   

Need your ASSIGNMENT done? Use our paper writing service to score better and meet your deadlines.  

You are the executive housekeeper of the Royal Hotel, London. It is September and the rooms division director asks you to submit a budget draft (rough estimate) for the coming fiscal year. The projected total rooms revenue has been set at $3,500,000.

Prepare the draft of your operating budget using the following list of items that you think you will need for the year. Show dollars and percentages for the projected revenue, costs, and income (departmental profit).

Estimated salaries and wages for the year:          $280,000

Estimated cleaning supplies cost:                        5% of total revenue

Estimated guest supplies cost:                             $35,000

Estimated linen replacement cost:                       $70,000

Complete the table below:

Budget

Dollars

Percentage

Revenue

Salaries & Wages

Cleaning Supplies (5% of revenue)

Guest Supplies

Linen Replacement

Departmental Income

INVENTORY EXERCISE

As executive housekeeper of an Omni hotel in Orlando, Florida, you have been made aware by the hotel controller that the use of guest supplies has been unusually high for the past three months. To investigate the issue, you decide to take inventory on May 31. These are your findings:

Value of guest supplies on beginning inventory May 1st:                                       $4,500

Value of purchases of guest supplies for the month of May:                                 $800

Value of physical inventory taken on May 31st:                                                     $2,800

The rooms division revenue for the month of May was:                                       $190,000

The budget percentage (expense / revenue) target for guest supplies was:           0.5%

Find:

Cost of guest supplies used in May.

Difference between cost percentage results in May and budgeted cost percentage.

Which are the probable causes for the difference?