Question

Analyze Ambassador Suites’ staffing budget Ambassador Suites Inc. operates a downtown hotel property that has 300...

  1. Analyze Ambassador Suites’ staffing budget

    Ambassador Suites Inc. operates a downtown hotel property that has 300 rooms. On average, 80% of Ambassador Suites’ rooms are occupied on weekdays, and 40% are occupied during the weekend. The manager has asked you to develop a budget for the housekeeping and restaurant staff for weekdays and weekends. You have determined that the housekeeping staff requires 30 minutes to clean each occupied room. The housekeeping staff is paid $14 per hour. The housekeeping labor cost is fully variable to the number of occupied rooms. The restaurant has six full-time staff on duty to staff the restaurant for breakfast and lunch (eight hours), regardless of occupancy. However, for every 60 occupied rooms, an additional person is brought in to work in the restaurant for breakfast and lunch (eight hours). The restaurant staff is paid $12 per hour.

    Enter any percentages as whole numbers.

    a. Determine the number of rooms occupied for an average weekday and weekend day.
    b. Determine the housekeeping staff budget for an average weekday and weekend day.
    c. Determine the restaurant staff budget for an average weekday and weekend day.
    d. Determine the total staff budget for an average weekday and weekend day.

    Ambassador Suites Inc.
    Direct Labor Cost Budget
    For a Weekday or a Weekend Day
    Weekday Weekend Day
    Room occupancy
    • Number of minutes to clean a room
    • Room capacity
    • Rooms occupied
    • Total minutes
    • Total hour
    • Number of minutes to clean a room
    • Occupancy
    • Rooms occupied
    • Total minutes
    • Total hour
    x% x%
    • Number of minutes to clean a room
    • Room capacity
    • Rooms occupied
    • Total minutes
    • Total hour
    Housekeeping
    • Housekeeping staff budget per day
    • Labor rate per hour
    • Number of minutes to clean a room
    • Total hours
    • Total minutes
    x x
    • Housekeeping staff budget per day
    • Labor rate per hour
    • Number of minutes to clean a room
    • Total hours
    • Total minutes
    • Housekeeping staff budget per day
    • Labor rate per hour
    • Number of minutes to clean a room
    • Total hours
    • Total minutes
    • Housekeeping staff budget per day
    • Labor rate per hour
    • Number of minutes to clean a room
    • Total hours
    • Total minutes
    x $ x $
    • Housekeeping staff budget per day
    • Labor rate per hour
    • Number of minutes to clean a room
    • Total hours
    • Total minutes
    $ $
    Restaurant staff
    • Base restaurant staff
    • Hours per day
    • Number of minutes to clean a room
    • Total hours
    • Total staff
    • Hours per day
    • Incremental staff for room blocks
    • Number of minutes to clean a room
    • Total staff
    • Total hours
    + +
    • Base restaurant staff
    • Hours per day
    • Number of minutes to clean a room
    • Total hours
    • Total staff
    • Base restaurant staff
    • Hours per day
    • Number of minutes to clean a room
    • Total hours
    • Total staff
    x x
    • Hours per day
    • Labor rate per hour
    • Restaurant staff budget per day
    • Total hours
    • Total staff
    • Hours per day
    • Labor rate per hour
    • Restaurant staff budget per day
    • Total hours
    • Total staff
    x $ x $
    • Hours per day
    • Labor rate per hour
    • Restaurant staff budget per day
    • Total hours
    • Total staff
    $ $
    Total staff budget per day $ $

    Feedback

Loading item

There was an error loading this item. If this continues to occur, please contact Technical Support.

Check My Work5 more Check My Work uses remaining.

  • Previous
  • Next
  • 100% Correct
  • Partially Correct
  • Incorrect
  • Needs Instructor Grading

Basic Calculatorclose

0

UseEntBSBSpCEHomCEnd

789+

456-

123*

0.=/

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
The downtown hotel has 105 guest rooms, a budgeted annual occupancy rate of 79%, a budgeted...
The downtown hotel has 105 guest rooms, a budgeted annual occupancy rate of 79%, a budgeted average daily room rate of $265.00, a budgeted average RevPAR of $209.00, and a budgeted variable housekeeping cost of $14.22 per room. Actual data indicated the annual occupancy rate was 85%, actual average daily room rate 85%, actual RevPAR was $236.51, and actual housekeeping costs were $14.93 per room. Answer the following about the housekeeping costs. 1) What was the Annual budget variance? Is...
Calculate labor variances in a hotel (Learning Objective 3) This case is a continuation of the...
Calculate labor variances in a hotel (Learning Objective 3) This case is a continuation of the Caesars Entertainment Corporation serial case that began in Chapter 1. Refer to the introductory story in Chapter 1 herefor additional background. (The components of the Caesars serial case can be completed in any order.) Housekeeping is a significant cost in running a hotel; housekeeping includes daily cleaning of occupied guest rooms and guest bathrooms. Before the late 2015 renovation, the Roman Tower, formerly known...
Ivanka Trump after moving to Pakisatan and has purchase PC hotel Karachi in November 2020 and...
Ivanka Trump after moving to Pakisatan and has purchase PC hotel Karachi in November 2020 and renamed it Ivayana. The hotel is a 5 star luxury hotel consisting of 100 single rooms 70 double rooms and 40 Suites. The average night stay in a single room costs Rs 8000. Double bed cost Rs 19000 and suite costs Rs 35000. On average 70 single rooms, 60 double rooms and 35 suites are occupied. Besides, there are 4 ball rooms. The ball...
Great Eastern Inns has a total of 800 rooms in its chain of motels located in...
Great Eastern Inns has a total of 800 rooms in its chain of motels located in eastern Canada. On average, 55% of the rooms are occupied each day. The company’s operating costs are $39 per occupied room per day at this occupancy level, assuming a 30-day month. This $39 figure contains both variable and fixed cost elements. During February, the occupancy rate dropped to only 45%. A total of $484,800 in operating cost was incurred during February. Required: 1. Estimate...
Great Eastern Inns has a total of 1,000 rooms in its chain of motels located in...
Great Eastern Inns has a total of 1,000 rooms in its chain of motels located in eastern Canada. On average, 60% of the rooms are occupied each day. The company’s operating costs are $17 per occupied room per day at this occupancy level, assuming a 30-day month. This $17 figure contains both variable and fixed cost elements. During February, the occupancy rate dropped to only 50%. A total of $283,500 in operating cost was incurred during February. 1. Estimate the...
Great Eastern Inns has a total of 1,600 rooms in its chain of motels located in...
Great Eastern Inns has a total of 1,600 rooms in its chain of motels located in eastern Canada. On average, 60% of the rooms are occupied each day. The company’s operating costs are $16 per occupied room per day at this occupancy level, assuming a 30-day month. This $16 figure contains both variable and fixed cost elements. During February, the occupancy rate dropped to only 40%. A total of $379,200 in operating cost was incurred during February. Required: 1. Estimate...
Great Eastern Inns has a total of 2,300 rooms in its chain of motels located in...
Great Eastern Inns has a total of 2,300 rooms in its chain of motels located in eastern Canada. On average, 45% of the rooms are occupied each day. The company’s operating costs are $39 per occupied room per day at this occupancy level, assuming a 30-day month. This $39 figure contains both variable and fixed cost elements. During February, the occupancy rate dropped to only 30%. A total of $1,074,330 in operating cost was incurred during February. 1. Estimate the...
Great Eastern Inns has a total of 2,300 rooms in its chain of motels located in...
Great Eastern Inns has a total of 2,300 rooms in its chain of motels located in eastern Canada. On average, 45% of the rooms are occupied each day. The company’s operating costs are $39 per occupied room per day at this occupancy level, assuming a 30-day month. This $39 figure contains both variable and fixed cost elements. During February, the occupancy rate dropped to only 30%. A total of $1,074,330 in operating cost was incurred during February. 1. Estimate the...
A young entrepreneur is planning to open a budget hotel with a start-up capital of RM...
A young entrepreneur is planning to open a budget hotel with a start-up capital of RM 300,000. The hotel will have single-bed rooms with an expected rate of RM 80 per room. An average room occupancy rate is about 210 per month.    Annual operating expenses for which cover administration, utility and maintenance costs are about RM 80,000. The cash flows will be expected to remain unchanged for the next 10 years. The applicable tax rate is 30% and a total...
Professional Labor Cost Budget for a Service Company Rollins and Cohen, CPAs, offer three types of...
Professional Labor Cost Budget for a Service Company Rollins and Cohen, CPAs, offer three types of services to clients: auditing, tax, and small business accounting. Based on experience and projected growth, the following billable hours have been estimated for the year ending December 31, 20Y8: Billable Hours Audit Department: Staff 36,000 Partners 5,400 Tax Department: Staff 26,600 Partners 3,300 Small Business Accounting Department: Staff 5,000 Partners 700 Based on the data provided above and assuming that the average compensation per...