Answered step by step
Verified Expert Solution
Question
1 Approved Answer
QUESTION IS VERY CLEAR PLEASE TELL WHAT DO YOU THINK IS UNCLEAR? YOU CAN SIMPLY USE HOLD CTRL BUTTON AND USE MOUSE WHELL TO ZOOM
QUESTION IS VERY CLEAR PLEASE TELL WHAT DO YOU THINK IS UNCLEAR?
YOU CAN SIMPLY USE HOLD CTRL BUTTON AND USE MOUSE WHELL TO ZOOM ON QUESTION AS I DID IT BECOMES CLEAR THEN.
Table 2: Availability of Employees 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 08:00 AM-4:00 PM, the second between 4:00 PM- 12:00 AM and the third between 12:00 AM and 08: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 08:00 AM) at least one employee with minimum 6 years of experience should be present. In each shift, at least three employees should be working. Availability Employee | Monday Tuesday Wednesday Thursday Friday Saturday Sunday S1 S2 S3 S1 S2 S3 S1 S2 S3 S1 S2 S3 S1 S2 S3 S1 S2 S3 S1 S2 S3 Aysu Yes Yes Yes Yes Yes Yes | Yes Yes Yes Yes Yes Yes Bahar Yes Yes Yes YesYes Yes Yes | Yes Yes Yes Yes Yes Can Yes Yes Yes Yes Yes Yes Yes Yes Yes Ve Yes Yes Yes Yes Yes Deniz Yes Yes Yes Yes Y es Yes Yes Yes Yes Yes Yes Erhan Yes Yes Yes Yes Yes Yes | Yes Yes | Yes Yes | Yes Yes Yes Gamze Yes Yes Yes Yes Yes Yes Y es Yes Yes Yes Yes Yes Yes Yes ilgi Yes Yes Yes Yes Yes YesYes Yes Yes Yes Yes Yes Yes Koray Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Lale Yes YesYes Yes Yes Yes YesYes Yes Yes Yes Yes Yes | Yes Yes Yes Tugay Yes Yes Yes Yes Yes Y es Yes Yes Yes Yes Yes Yes Table 1. Employee Information Employee Experience Wage ($) per shift Aysu 1 year 24 Bahar 5 years 7 years Deniz 4 years Erhan 1.5 years Gamze 15 years ilgi 2.5 years Koray o years Lale 8 years 51 Tugay 2 years 30 Can *S1: 08:00 AM-4:00 PM S2: 4:00 PM12:00 AM S3: 12:00 AM-08:00 AM 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 5 and at most 8 shifts a week. - A person cannot work on two shifts the same day. - The novices Aysu and Erhan cannot be assigned together to any of the shifts. (a) Develop a mathematical formulation for this problem. Define all your decision variables and constraints clearly. (b) Solve the model using an optimization solver (Excel, OPL etc.) and upload your optimization code to moodle. Due to the size of the model, you need "Open Solver" add on for Excel (you can download from web). Table 2: Availability of Employees 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 08:00 AM-4:00 PM, the second between 4:00 PM- 12:00 AM and the third between 12:00 AM and 08: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 08:00 AM) at least one employee with minimum 6 years of experience should be present. In each shift, at least three employees should be working. Availability Employee | Monday Tuesday Wednesday Thursday Friday Saturday Sunday S1 S2 S3 S1 S2 S3 S1 S2 S3 S1 S2 S3 S1 S2 S3 S1 S2 S3 S1 S2 S3 Aysu Yes Yes Yes Yes Yes Yes | Yes Yes Yes Yes Yes Yes Bahar Yes Yes Yes YesYes Yes Yes | Yes Yes Yes Yes Yes Can Yes Yes Yes Yes Yes Yes Yes Yes Yes Ve Yes Yes Yes Yes Yes Deniz Yes Yes Yes Yes Y es Yes Yes Yes Yes Yes Yes Erhan Yes Yes Yes Yes Yes Yes | Yes Yes | Yes Yes | Yes Yes Yes Gamze Yes Yes Yes Yes Yes Yes Y es Yes Yes Yes Yes Yes Yes Yes ilgi Yes Yes Yes Yes Yes YesYes Yes Yes Yes Yes Yes Yes Koray Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Lale Yes YesYes Yes Yes Yes YesYes Yes Yes Yes Yes Yes | Yes Yes Yes Tugay Yes Yes Yes Yes Yes Y es Yes Yes Yes Yes Yes Yes Table 1. Employee Information Employee Experience Wage ($) per shift Aysu 1 year 24 Bahar 5 years 7 years Deniz 4 years Erhan 1.5 years Gamze 15 years ilgi 2.5 years Koray o years Lale 8 years 51 Tugay 2 years 30 Can *S1: 08:00 AM-4:00 PM S2: 4:00 PM12:00 AM S3: 12:00 AM-08:00 AM 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 5 and at most 8 shifts a week. - A person cannot work on two shifts the same day. - The novices Aysu and Erhan cannot be assigned together to any of the shifts. (a) Develop a mathematical formulation for this problem. Define all your decision variables and constraints clearly. (b) Solve the model using an optimization solver (Excel, OPL etc.) and upload your optimization code to moodle. Due to the size of the model, you need "Open Solver" add on for Excel (you can download from web)Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started