Question

In: Accounting

Sleep-EZ Suites Inc., operates a downtown hotel property that has 600 rooms. On average, 90% of...

Sleep-EZ Suites Inc., operates a downtown hotel property that has 600 rooms. On average, 90% of Sleep-EZ Suites's rooms are occupied on weekdays, and 60% are occupied during the weekend. The manager has asked you to develop a direct labor budget for the housekeeping and restaurant staff for weekdays and weekends. You have determined that the housekeeping staff requires 40 minutes to clean each occupied room. The housekeeping staff is paid $10 per hour. The restaurant has 12 full-time staff (eight-hour day) on duty, regardless of occupancy. However, for every 20 occupied rooms, an additional person is brought in to work in the restaurant for the eight-hour day. The restaurant staff is paid $8 per hour.

Determine the estimated housekeeping, restaurant, and total direct labor cost for an average weekday and average weekend day. Enter percentages as whole numbers.

Sleep-EZ Suites Inc.
Direct Labor Cost Budget
For a Weekday or a Weekend Day
Weekday Weekend Day
Room occupancy
Room capacity
Occupied percent x% x%
Rooms occupied
Housekeeping
Number of minutes to clean a room x x
Total minutes
Total hours
Labor rate per hour x$ x$
Housekeeping daily labor budget $ $
Restaurant staff
Base restaurant staff
Incremental 20 room blocks
Total staff
Hours per day x x
Total hours
Labor rate per hour x$ x$
Restaurant staff daily labor budget $ $
Total daily labor budget $ $

Solutions

Expert Solution

SLEEP-EZ SUITES INC.
Direct Labor Cost Budget
For a Weekday or a Weekend Day
Weekday Weekend Day
Room occupancy                   600                 600
Room capacity                   600                 600
Occupied percent 90% 60%
Rooms occupied                   540                 360
Housekeeping
Number of minutes to clean a room               40.00             40.00
Total minutes       21,600.00     14,400.00
Total hours             360.00           240.00
Labor rate per hour               10.00             10.00
Housekeeping daily labor budget         3,600.00       2,400.00
Restaurant staff
Base restaurant staff               12.00             12.00
Incremental 20 room blocks               27.00             18.00
Total staff               39.00             30.00
Hours per day                 8.00                8.00
Total hours             312.00           240.00
Labor rate per hour                 8.00                8.00
Restaurant staff daily labor budget         2,496.00       1,920.00
Total daily labor budget         6,096.00       4,320.00

Related Solutions

A 600​-room hotel can rent every one of its rooms at $90 per room. For each​...
A 600​-room hotel can rent every one of its rooms at $90 per room. For each​ $1 increase in​ rent, 3 fewer rooms are rented. Each rented room costs the hotel​ $10 to service per day. How much should the hotel charge for each room to maximize its daily​ profit? What is the maximum daily​ profit?
A hotel has 210 units. All rooms are occupied when the hotel charges ​$90 per day...
A hotel has 210 units. All rooms are occupied when the hotel charges ​$90 per day for a room. For every increase of x dollars in the daily room​ rate, there are x rooms vacant. Each occupied room costs $ 36 per day to service and maintain. What should the hotel charge per day in order to maximize daily​ profit?
The Harriet Hotel in downtown Boston has 100 rooms that rent for $150 per night. It costs the hotel $30 per room in variable costs
In Crystal BallThe Harriet Hotel in downtown Boston has 100 rooms that rent for $150 per night. It costs the hotel $30 per room in variable costs (cleaning, bathroom items, etc.) each night a room is occupied. For each reservation accepted, there is a 5% chance that the guest will not arrive. If the hotel overbooks, it costs $200 to compensate guests whose reservations cannot be honored.How many reservations should the hotel accept if it wants to maximize the average...
a) In order to determine the average price of hotel rooms in Atlanta, a sample of...
a) In order to determine the average price of hotel rooms in Atlanta, a sample of 61 hotels were selected. It was determined that the average price of the rooms in the sample was $111.9. The population standard deviation is known to be $19. We would like to test whether or not the average room price is significantly different from $110. Compute the test statistic. b) In order to determine the average price of hotel rooms in Atlanta, a sample...
The city of Seattle sells an average of 30,000 hotel rooms per night. Currently, those rooms...
The city of Seattle sells an average of 30,000 hotel rooms per night. Currently, those rooms have an average tax of $90. The city proposed an additional tax of $10 per room to help finance a stadium. Economists believe that without the tax, the city would average an extra 4000 rooms per night due to the new stadium. But with the tax, the number of rooms sold would fall to 27,000 even with the stadium. Based on these numbers, would...
5. When consumer demand for hotel rooms increases, the average selling prices for those rooms typically...
5. When consumer demand for hotel rooms increases, the average selling prices for those rooms typically increase as well. In the foodservice business that has not historically been the case. Fluctuations in consumer demand (e.g., volume differences between high demand Saturday nights and lower­volume Sunday nights) in restaurants do not typically result in menu price changes. Given that both hotels and restaurants are part of the hospitality industry, how do you account for these fundamental differences in approach toward strategic...
A hotel in Saint Augustine books an average of 50 rooms per night. There is a...
A hotel in Saint Augustine books an average of 50 rooms per night. There is a standard deviation of 10 rooms per night. What is the probability that... a) more than 50 rooms are booked on a given night? b) between 50 and 60 rooms are booked on a given night?    c) 60 rooms or less are booked on a given night?    d) between 30 and 70 rooms are booked on a given night? e) less than 40...
a)In order to determine the average price of hotel rooms in georgia, a sample of 63...
a)In order to determine the average price of hotel rooms in georgia, a sample of 63 hotels were selected. It was determined that the test statistic (z) was $1.74. We would like to test whether or not the average room price is significantly different from $110. Population standard deviation is known to us.Compute the p-value. b)In order to determine the average price of hotel rooms in Atlanta, a sample of 36 hotels were selected. It was determined that the average...
a) In order to determine the average price of hotel rooms in Atlanta. Using a 0.1...
a) In order to determine the average price of hotel rooms in Atlanta. Using a 0.1 level of significance, we would like to test whether or not the average room price is significantly different from $110. The population standard deviation is known to be $16. A sample of 64 hotels was selected. The p-value associated with the test statistic (z) is calculated and it is 0.03. We conclude that the average price of hotel rooms in Atlanta is NOT significantly...
Ada Hotel sells two room tpes: standard rooms and deluxe rooms. Average daily rate (ADR) and...
Ada Hotel sells two room tpes: standard rooms and deluxe rooms. Average daily rate (ADR) and variable costs (VC) of the two room types are provided in the table below: (Hint: Treat two room types as two different products.)                                                 ADR ($)   Variable Cost ($)               Standard rooms    394.50   256.43               Deluxe rooms   631.20   366.10                                     ...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT