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: Minimum number of consultants Time of Day rec uired to be on dut Sam-noon 20 Noon4 Im 26 4 I [11-8 I [n 36 8 I mmidni 1 ht 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). Fulltime consultants are paid $65 per hour. Parttime consultants can be hired to work any of the four shifts listed in the table. Parttime 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 dug: for every part-time consultant on duty. The director wants to determine the number of fulltime and parttime 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