Schedule Over Time Anamusementparkneedsacertainnumber ofemployeeseachdayoftheweek. Everyemployee mustbeonaschedulethat giveshim/hertwoconsecutivedaysoff and the park decided to use overtime, workers would
Question:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/6678f10b1279e_0596678f10b00867.jpg)
Schedule Over Time
Anamusementparkneedsacertainnumber ofemployeeseachdayoftheweek. Everyemployee mustbeonaschedulethat giveshim/hertwoconsecutivedaysoff and the park decided to use overtime, workers would be paid overtime for the 6th consecutive day (workers are paid $560 for a M-S or a S-F schedule and $600 for any schedule that requires them to work both weekend days). The contract does not allow workers to be scheduled for a 7th consecutive day.Most of this information is contained in the worksheet and a model shell has been created for you (how nice of me!) If overtime is allowed, how many employees should the park hire and what schedule should they be on the minimize total payroll cost?
Please provide step by step in the below excel structure with formulas and parameters passed in the solver.
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/6678f10b6f3df_0596678f10b599b6.jpg)