use excel

Amal is the director of the Computer Center for a local school. She now needs to schedule the staffing of the center. It is open from 8 A.M. until midnight. Amal has monitored the usage of the center at various times of the day, and determined that the following number of combuter consultants are reauired. Two types of consultants can be hired: full-time and part-time. The full-time consultants work for 8 consecutive hours in any of the following shifts: moming (8 A.M.-4 P.M.), aftemoon (noon-8 P.M.), and evening (4 P.M.-midnight). Full-time consultants are paid 4 KWD per hour. Part-time consultants can be hired to work any of the four shifts listed in the above table. Part-time consultants are paid 2KWD per hour. An additional requirement is that during every time period, there must be at least 2 full-time consultants on duty for every part-time consultant on duty. Amal would like to determine how many full-time and how many part-time workers should work each shift to meet the above requirements at the minimum possible cost. a. Formulate and solve a linear program to help Amal prepare her staffing plan at the lowest possible cost. (15 points) b. If Amal can lower the minimum number of consultants in any of the four 4-hour shifts, which one should she choose? Explain. (5 points)