Question

Gerald Glynn manages the Michaels Distribution Center. After careful examination of his database​ information, he has determined the daily requirements for​ part-time loading dock personnel. The distribution center operates 7 days a​ week, and the daily​ part-time staffing requirements are                                                                                                                      Day M T W Th F S Su Requirements 5 5 3 3 7 2 4 Find the minimum number of workers Glynn must hire. Prepare a workforce schedule for these individuals so that each will have 2 consecutive days off per week and all staffing requirements will be satisfied. Give preference to the​ S-Su pair in case of a tie. ​(Note: If there is a tie that cannot be broken by following the preference to the​ S-Su pair, choose the pair closest to the beginning of the considered​ week.) The minimum number of workers is 7 workers. ​(Enter your response as a whole​ number.) Specify the workforce schedule for each employee by indicating the day offs​ (other days are considered to be work​ days.) Make sure to give preference to the​ S-Su pair in case of a tie. ​(Note: If there is a tie that cannot be broken by following the preference to the​ S-Su pair, choose the pair closest to the beginning of the considered​ week, with Monday being considered as the first day of the​ week.)

Answer 1

Below is the screenshot of the LP table -

Below is the screenshot of the formula applied -

Below is the screenshot of the solver -

Below is the screenshot of the result -

Below is the Week off detail basis above -

Week Off	Number of Employees
Sat-Sun	3
Sun-Mon	0
Mon-Tue	2
Tue-Wed	0
Wed-Thu	2
Thu-Fri	0
Fri-Sat	0