PLEASE DONT USE EXCEL SOLVER

Problem 3: Larry Edison is the director of the computer center for Buckly College. He now needs to schedule the staffing of the center. If it open from 8 am until midnight. Larry has monitored the usage of the center at various times of the day and determined that the following number of computer consultants is required. Time of Day 8 am - Noon Noon - 4pm 4pm - 8pm 8pm - Midnight Minimum Number of Consultants Required To Be on Duty 6 8 12 6 Two types of computer consultants can be hired: full-time and part-time. The full-time consultants work for eight consecutive hours in any of the following shifts: morning (8am - 4pm), afternoon (noon - 8pm), and evening (4pm - midnight). Full-time consultants are paid $14 per hour. Part-time consultants can be hired to work any of the four shifts listed in the table. Part- time consultants are paid $12 per hour. Larry would like to determine how many full-time and part-time consultants should work each shift to meet the above requirements at the minimum possible cost. 1) Based on this information, formulate the decision problem into a linear programming in mathematic forms. [25 points] 2) Suppose now an additional requirement is that during every time period, there must be at least two full-time consultants on duty for every part-time consultant on duty. What additional constraints you'd like to add to the linear programming problem you formulated in part (2)? [7 points) Problem 3: Larry Edison is the director of the computer center for Buckly College. He now needs to schedule the staffing of the center. If it open from 8 am until midnight. Larry has monitored the usage of the center at various times of the day and determined that the following number of computer consultants is required. Time of Day 8 am - Noon Noon - 4pm 4pm - 8pm 8pm - Midnight Minimum Number of Consultants Required To Be on Duty 6 8 12 6 Two types of computer consultants can be hired: full-time and part-time. The full-time consultants work for eight consecutive hours in any of the following shifts: morning (8am - 4pm), afternoon (noon - 8pm), and evening (4pm - midnight). Full-time consultants are paid $14 per hour. Part-time consultants can be hired to work any of the four shifts listed in the table. Part- time consultants are paid $12 per hour. Larry would like to determine how many full-time and part-time consultants should work each shift to meet the above requirements at the minimum possible cost. 1) Based on this information, formulate the decision problem into a linear programming in mathematic forms. [25 points] 2) Suppose now an additional requirement is that during every time period, there must be at least two full-time consultants on duty for every part-time consultant on duty. What additional constraints you'd like to add to the linear programming problem you formulated in part (2)? [7 points)