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
Which benefits and drawbacks of …show more content…
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.
Sum of queue flux
2.2 and 2.1 under
Table Results from our iterations
What is the optimal work plan? What is the total cost?
The optimal work plan is now calculated in GAMS and shown in Table
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.
Which benefits and drawbacks do you see with this approach and with your choice of values for cot and cut?
The company saves money by allowing understaffing and gain some flexibility in the work plan regarding