Question: You are required to plan the weekly schedule for a medical clinic. The clinic works 7 days a week, in three shifts; first shift is



You are required to plan the weekly schedule for a medical clinic. The clinic works 7 days a week, in three shifts; first shift is between o8:00 AM-4:00 PM, the second between 4:00 PM12:00 AM and the third between 12:00 AM and o8:00 AM. The experiences and the wages of the 10 employees are given in Table 1. In the second shift (4:00 PM-12:00 AM), at least one employee with minimum 3 years of experience should be present. In the third shift (12:00 AM and o8:00 AM) at least one employee with minimum 7 years of experience should be present. In each shift, at least two employees should be working. Table 1. Employee Information The availability of the employees for the following week is given in Table 2. In developing the schedule, we additionally have the following constraints: - Each person should be working at least 3 and at most 6 shifts a week. - A person cannot work on two shifts the same day. - The novices Ada and Ezgi cannot be assigned together to any of the shifts. (a) Develop a mathematical formulation for this problem. Define all your sets, decision variables, and parameters clearly. Write each constraint together with its explanation. (b) Solve the model using an optimization solver (Excel, GAMS etc.) and upload your optimization code to moodle. Due to the size of the model, you need "Open Solver" add on for Excel . (https://sourceforge.net/projects/opensolver/) You need to submit two files: a) Word or pdf file including part (a) and tables for the solution of your model as a word or pdf file, b) Excel or optimization solver file. Table 2: Availability of Employees *S1: 08:00 AM-4:00 PM S2: 4:00 PM-12:00 AM S3: 12:00 AM-o8:00 AM
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
