Schedule Over Time

Anamusementparkneedsacertainnumber ofemployeeseachdayoftheweek. Everyemployee mustbeonaschedulethat giveshim/hertwoconsecutivedaysoff and the park decided to use overtime, workers would be paid overtime for the 6^th 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 7^th 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.

016 V I X Vfx A B C D E F G H J K L M Schedule Demand: 22 17 13 14 15 18 24 Daily Earnings: 120 80 80 80 80 80 120 W N Schedule Days off OT Day # Employees Sun Mon Tue Wed Thu Fri Sat Total Earnings A Sunday, Monday B Monday, Tuesday C Tuesday, Wed. D Wed., Thursday 8 E Thursday, Friday CO F Friday, Saturday 10 G Saturday, Sunday 11 A1 Sunday, Monday Sunday 12 B1 Monday, Tuesday Monday 13 C1 Tuesday, Wed Tuesday 14 D1 Wed., Thursday Wednesday 15 E1 Thursday, Friday Thursday 16 F1 Friday, Saturday Friday 17 G1 Saturday, Sunday Saturday 18 19 Totals: 20 21