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 roomRoom capacityRooms occupiedTotal minutesTotal hour	- Select -	- Select -
Number of minutes to clean a roomOccupancyRooms occupiedTotal minutesTotal hour	x- Select -%	x- Select -%
Number of minutes to clean a roomRoom capacityRooms occupiedTotal minutesTotal hour	- Select -	- Select -
Housekeeping
Housekeeping staff budget per dayLabor rate per hourNumber of minutes to clean a roomTotal hoursTotal minutes	x- Select -	x- Select -
Housekeeping staff budget per dayLabor rate per hourNumber of minutes to clean a roomTotal hoursTotal minutes	- Select -	- Select -
Housekeeping staff budget per dayLabor rate per hourNumber of minutes to clean a roomTotal hoursTotal minutes	- Select -	- Select -
Housekeeping staff budget per dayLabor rate per hourNumber of minutes to clean a roomTotal hoursTotal minutes	x $- Select -	x $- Select -
Housekeeping staff budget per dayLabor rate per hourNumber of minutes to clean a roomTotal hoursTotal minutes	$- Select -	$- Select -
Restaurant staff
Base restaurant staffHours per dayNumber of minutes to clean a roomTotal hoursTotal staff	- Select -	- Select -
Hours per dayIncremental staff for room blocksNumber of minutes to clean a roomTotal staffTotal hours	+- Select -	+- Select -
Base restaurant staffHours per dayNumber of minutes to clean a roomTotal hoursTotal staff	- Select -	- Select -
Base restaurant staffHours per dayNumber of minutes to clean a roomTotal hoursTotal staff	x- Select -	x- Select -
Hours per dayLabor rate per hourRestaurant staff budget per dayTotal hoursTotal staff	- Select -	- Select -
Hours per dayLabor rate per hourRestaurant staff budget per dayTotal hoursTotal staff	x $- Select -	x $- Select -
Hours per dayLabor rate per hourRestaurant staff budget per dayTotal hoursTotal staff	$- Select -	$- Select -
Total staff budget per day	$fill in the blank 46	$fill in the blank 47