Question
Develop a crew schedule using the following information. Purpose: To prepare a three-day time schedule for variable employees based on sales forecast. The operation is
Develop a crew schedule using the following information.
Purpose: To prepare a three-day time schedule for variable employees based on sales forecast. The operation is of a fast-food type located in a college town, with the variable employees able to interchange in the various positions. There are two full-time (Bob and Tammy) and eight part-time employees. Scheduling Guidelines:
No split shifts are allowed (e.g., lunch and dinner).
Full-time employees always work 8 hours a day and are not given split shifts.
Part-time employees should work at least 4 hours a day and no more than 8 hours a day.
Part-time employees are limited to a 20-hour total work for Friday, Saturday, and Sunday.
The minimum number of employees allowed per shift is four; the maximum is five. Dinner shift on Sundays is the only exception to these rules.
Dinner shifts on Friday and Saturday should always have two full-time employees on staff. Employee Scheduling Constraints:
Tammy needs to have Sundays off.
Jamal cannot work after 7 p.m.
Carl cannot work after 3 p.m. (except Saturdays).
Lei cannot work after 3 p.m. on Fridays.
Pete is not allowed to work after 7 p.m.
Paloma is not available on Sundays.
Jean is available for any shift on any day.
Barb can work on Saturdays and Sundays only after 7 p.m.
Miguel cannot work between 11 a.m. and 3 p.m. on Fridays and Saturdays.
Employee Pay Rates: The labor cost for full-time employees is $10 per hour. Part-time employees have a labor cost of $8 per hour.
Labor Budget Target: Labor cost percentage should be below 25 percent on a daily basis.
Sales Forecast: The sales forecast for Friday, Saturday, and Sunday is as follows: Hours:
11 a.m.3 p.m. 3 p.m.7 p.m. 7 p.m.11 p.m.
Friday $550 $900 $1,000
Saturday $550 $850 $1,100
Sunday $650 $750 $475
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started