** Please use excel solver and provide formulas***

The company realizes that the optimal solution is a bit impractical as there is quite a bit of fluctuation on the number of agents who start their shift on a particular day. The company would like that to be more uniform and wants to minimize the largest number of shift workers who start on any given day. a. Formulate this is a mini-mix problem and find the optimal solution b. Is this a better solution than that obtained from the original (pure) cost minimization problem? Justify your answer based on solution quality and impact to cost. Staff Scheduling Decision Variables Shift Number S1 S2 S3 S4 S5 S6 S7 staff 4 2 6 1 6 3 11 Objective Function Total Minimize Cost 680 705 705 705 705 680 655 22540 Constraints Shift1 Shift2 Shift3 Shift4 Shift5 Shift6 Shift7 LHS RHS SU 0 1 1 1 1 18 >= 18 MO 0 0 1 27 >= 27 TU O 1 25 >= 22 WE O 26 >= 26 POOPPP OOPPPP TH 26 >= 25 H POO FR 24 >= 21 SA 19 >= 19 Minimize: 18 By changing: B5:H5 Subject to: 111:117>=K11:K17 B5:H5>=0 & integer\f