Please solve using excel and solver. Please show how you got your answers.

3-17 A hospital emergency room is open 24 hours a day. Nurses report for duty at 1 A.M., 5 A.M., 9 A.M., 1 P.M., 5 P.M., or 9 P.M., and each works an 8-hour 2 PAY RATE/ WEEK SHIFTS WORK TIMES A and A (alt) 5 A.M.-5 P.M. $756 B and B (alt) 7 A.M.-7 P.M. $840 C and C (alt) 5 P.M.-5 A.M. $882 D and D (alt) 7 P.M.-7 A.M. $924 The shift pay differentials are based on the most and least desirable times to begin and end work. In any one week, techs on shift A might work Sunday through Tuesday, while techs on shift A (alt) would work at the same times but on Wednesday through Saturday. In the following week, techs on shift A would work Sunday through Wednesday, while techs on shift A (alt) would work the corresponding Thursday through Saturday. Therefore, the same number of techs would be sched- uled for shift A as for shift A (alt). The requirements for lab techs during the 24-hour day are shown in the following table. What is the most economical schedule for the lab techs? 5 A.M.- 7 A.M. 7 A.M.- 5 P.M. 5 P.M.- 7 P.M. 7 P.M.- 5 A.M. 12 8 14 10 Lab techs needed