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 medicalclinic. The clinic works 7 days a week, in three shifts; firstshift is between o8:00 AM-4:00 PM, the second between 4:00 PM12:00 AM

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!