Please formulate the linear programming model.

Don't use the excel!

Question 2 The director of the Computer Center needs to schedule the staffing of the center. It is open from 8am until midnight. The director has monitored the usage of the center at various times of the day and determined that the following number of computer consultants are required: Time of Day Minimum number of consultants required to be on duty 20 8am-noon 26 Noon-4pm 4pm-8pm 8pm-midnight 36 20 The two types of computer consultants can be hired: full-time and part-time. The full-time consultants work for 8 consecutive hours in any of the following shifts: morning (8am-4pm), afternoon (noon-8pm), and evening (4pm-midnight). Full-time consultants are paid $65 per hour. Part-time consultants can be hired to work any of the four shifts listed in the table. Part-time consultants are paid $50 per hour. An additional requirement is that during every time period, there needs to be at least three full- time consultants on duty for every part-time consultant on duty. The director wants to determine the number of full-time and part-time staff for each period so as to minimize the total daily cost. (a) Formulate the linear programming model for this problem. (b) Solve the model using Excel Solver