Question: The production line employees at Grummins Engine work four days per week, 10 hours per day. Each day of the week, the following minimum numbers
The production line employees at Grummins Engine work four days per week, 10 hours per day. Each day of the week, the following minimum numbers of line employees are needed: Monday through Friday, 70 employees; Saturday and Sunday, 30 employees. Grummins employs 110 line employees. Determine how to maximize the number of consecutive days off received by these employees. For example, a worker who gets Sunday, Monday, and Wednesday off receives two consecutive days off.
Step by Step Solution
3.23 Rating (161 Votes )
There are 3 Steps involved in it
Model Scheduling employees Range names used Consec ModelH14 Number of workers with the... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
1497_6040a1aee231c_694783.xlsx
300 KBs Excel File
