42401 Project Assignment 1
Scheduling of the Central Security Checkpoint
GAMS and Excel
This report has been generated using GAMS as the solver and then Excel to process and visualize the results.
In GAMS, two sets has been used. One set for the shifts, and another for the timeslots. Since in GAMS it is not allowed to have “.” or “,” in a set name, the timeslots has been denoted 4:30=45.
A file which holds all the parameters has been generated, named parameters.gms. In this file all the data such as a shift cost, the time shift table etc. is present.
Part 1 - Basic model for decision support
Question 1
Which benefits and drawbacks of …show more content…
By taking the sum of the queue flux during the whole day it shows whether the staff meets the demands or not, and thus if the queue will grow or diminish.
Making the iterations of Table , it shows that that 2.2 and 2.1 both had the same staffing and resulted in a sum queue flux of -2.
The optimal solution would have a sum of zero and since this number represents how many customers are in queue when the dayshift ends and it is better to have it negative.
In Error: Reference source not found it is also possible to notice that the queue fluctuates and that potential queues are diminished within a reasonable timeframe.
Understaffing coefficient
Sum of queue flux
1.5 under
191
3 under
-75
2.2 and 2.1 under
-2
2.0 under
22
Table Results from our iterations
Question 10
What is the optimal work plan? What is the total cost?
The optimal work plan is now calculated in GAMS and shown in Table
Shift
A
D
G
H
I
J
N
O
P
Q
S
Employees
3
3
10
1
15
4
9
2
2
2
3
Table Best schedule with understaffing
This work plan results in a staff of 54 employees and the total cost being
€ 11119.40, including penalties for over- and understaffing.
Question 11
Which benefits and drawbacks do you see with this approach and with your choice of values for cot and cut?
Benefits
The company saves money by allowing understaffing and gain some flexibility in the work plan regarding