Part 2: Develop a Staffing Guide

Using information obtained in Part 1, fill in the blanks below to develop a room attendant staffing guide for the occupancy percentages of 100, 90, 80, and 70. When doing so, assume that the average hourly pay rate for room attendants is $15.00.

Room Attendants

Occupancy %	100%	90%	80%	70%
Rooms Occupied
Productivity Standard 0.38 hours per room
Labor Hours
Room Attendants
Labor Expense

Handout 5.2: Analyze a Weekly Labor Hour Usage Report

Weekly Labor Hour Report

Dining Room Servers								Labor Hours
Employee	Mon	Tues	Wed	Thur	Fri	Sat	Sun	Actual	Standard
JM	6	-	6	5.5	6	5	-	28.5	27
PW	-	6	5.5	6	5.5	5.5	4	32.5	30
AH	-	4	7	6	7	9	-	33	28
JP	7	5	5	3.5	-	-	5	235	24
TE	3	3	5.5	-	3.5	-	4	19	20
MH	5	4	4	4	4	-	-	21	20
GG	5	-	-	5	5	7	7	29	27
								188.5	176

Questions:

1. What is the variance (difference) between the total actual hours worked and the total standard (scheduled) hours worked for this week?

2. If the average hourly wage for service staff is $10.00, what is the variance between the total labor expense for actual hours worked and the total labor expense for scheduled (standard) labor hours?

3. What would it cost the operation if actual hours worked differed from scheduled labor hours at the same rate for an entire 52-week year?

4. If the operation requires a profit of 9 percent of revenue generated by sales, how much revenue must the operation generate in additional sales to make up the amount determined in question #3?