OPMT 3197 Midterm Test Part A Summer 2022 Question 4 [16 marks] You are the manager...

Transcribed Image Text:

OPMT 3197 Midterm Test Part A Summer 2022 Question 4 [16 marks] You are the manager of the Computer Center for BCIT and responsible for scheduling the staffing of the center, which is open from 8 a.m. until midnight. You have 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 noon 8 a.m. Noon - 4 p.m. 4 p.m. - 8 p.m. 8 p.m. - midnight Minimum Number of Consultants Required To Be on Duty 4886 10 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 (8 a.m. - 4 p.m.), afternoon (noon - 8 p.m.), and evening (4 p.m. - midnight). Full time consultants are paid $16 per hour. Part-time consultants can be hired to work any of the four shifts listed in the table. Part-time consultants are paid $14 per hour. An additional requirement is that during every time period, there must be at least one full-time consultant on duty for every part-time consultant on duty. You would like to determine to minimum-cost staffing plan for the center. Note: the number of consultants must be in whole number. Create a well-organized spreadsheet model for this problem and find a solution using Solver. (label the tab in Excel spreadsheet as Q5) OPMT 3197 Midterm Test Part A Summer 2022 Question 4 [16 marks] You are the manager of the Computer Center for BCIT and responsible for scheduling the staffing of the center, which is open from 8 a.m. until midnight. You have 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 noon 8 a.m. Noon - 4 p.m. 4 p.m. - 8 p.m. 8 p.m. - midnight Minimum Number of Consultants Required To Be on Duty 4886 10 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 (8 a.m. - 4 p.m.), afternoon (noon - 8 p.m.), and evening (4 p.m. - midnight). Full time consultants are paid $16 per hour. Part-time consultants can be hired to work any of the four shifts listed in the table. Part-time consultants are paid $14 per hour. An additional requirement is that during every time period, there must be at least one full-time consultant on duty for every part-time consultant on duty. You would like to determine to minimum-cost staffing plan for the center. Note: the number of consultants must be in whole number. Create a well-organized spreadsheet model for this problem and find a solution using Solver. (label the tab in Excel spreadsheet as Q5)