Answers are correct. Need to know how they were calculated on Excel using Solver. Thanks

hapter 6 Winter 2021 eBook Garden City Beach is a popular summer vacation destination for thousands of people. Each summer, the city hires temporary lifeguards to ensure the safety of the vacationing public Garden City's lifeguards are assigned to work five consecutive days each week and then have two days off. However, the city's Insurance company requires them to have at least the following number of lifeguards on duty each day of the week: Minimum Number of lifeguards Required Each Day Sunday Monday Tuesday Wednesday Thursday Friday Saturday Lifeguards 18 17 16 16 16 14 19 The city manager would like to determine the minimum number of lifeguards that will have to be hired. a. Select the correct ILP model for this problem, I 11 MIN X1 + X2 + xy + x + x + X6 + X7 ST X2 + x3 + X: + Xs + X5 2 17 X3 + X4+ Xs+ X6 + X7 18 X1 +XXs+ X6 + xy 16 X1 + X2 + x + Xs+X7 16 X: + x2 + x3 + x + xy 14 X1 + X2 + x3 + x4 + X; 2 16 X1 + X2 + X+X+X5 2 19 X20 MIN X1 + X2 + xy + XA + Xs+ X6 + X7 ST X2 + X3 + X4+ X5 X6 2 18 X3 X4 Xs + X6 + X7 2 17 X1 + X4+ Xs + X6 + X 16 X1 + X2 + Xs + X6 + X7 2 16 X1 + x2 + x3 + X6 + X7 2 16 X1 + X2 + X3 + X4+ X7 2 14 X1 + X2 + X3 X4 X5 219 X/20 III MAX X1 + xy + xy + X4+ Xs+X6 + X7 STX2 + Xs+ X4+Xs+ X6 $ 17 Xs+ Xs+ Xs+Xs+ X518 XI +X4+X5 + X + 1) = 16 X: + X2 + Xs+X+X7 S 16 X1 + X) + X1 + X: + X1 514 IV MAX X1 + X2 + X3 X4+ Xs+ X6 + X7 ST X2 X3 + X4 X5 + XS S 18 X3 + X4 X5 X6 + X1 2 17 X: +X+Xs+ X6 + X7 2 16 X: + X2 + x + X6 + XS 19 X X X X X X 16 22 X W Q Search this course 4 Chapter 6 Winter 2021 + b. Implement your model in a spreadsheet and solve it. How many lifeguards will Garden City Beach have to schedule for each day of the week Workers Shin Scheduled 1 5 2 2 3 6 4 2 5 6 . on 2 7 c. What is the total number of feguards that Garden City Beach will have to hire? 24 d. Several lifeguards tuve expressed a preference to be off on Saturdays and Sundays. What is the maximum number of lifeguards that can be off on the weekend without increasing the total number of life guards required Hide Feedback Correct Check My Wick os W 22