Scheduling of the Central Security Checkpoint
Date 11/10/2013
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 the two scenarios would you expect considering PlanAir, the employees and their unions?
Scenario one:
Benefits
If the work schedule is produced for every single day of the year according to the forecast, the number of employees needed, will be more accurate than with a “general day” scenario.
Drawbacks
PlanAir will also need a very flexible workforce since it could be hard to have all the employees working full time.
It takes a lot of effort to create this schedule because of the many work plans that has to be generated and taken into consideration.
Scenario two:
Benefits
It’s easier to calculate the work plan mathematically and requires a less flexible workforce.
Drawbacks
If only the average number of employees are in the schedule, the company might be some employees short or too many at work on a given day.
If there are too many employees working on a shift, then an overstaffing problem arises and that results in a loss of money for PlanAir.
If there is understaffing, then it has a negative impact on an employee’s working environment during that particular shift, because they will have to do more work leading to stress.
Question 2
Taking into account the data given for shifts, employees and demand, which
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 the two scenarios would you expect considering PlanAir, the employees and their unions?
Scenario one:
Benefits
If the work schedule is produced for every single day of the year according to the forecast, the number of employees needed, will be more accurate than with a “general day” scenario.
Drawbacks
PlanAir will also need a very flexible workforce since it could be hard to have all the employees working full time.
It takes a lot of effort to create this schedule because of the many work plans that has to be generated and taken into consideration.
Scenario two:
Benefits
It’s easier to calculate the work plan mathematically and requires a less flexible workforce.
Drawbacks
If only the average number of employees are in the schedule, the company might be some employees short or too many at work on a given day.
If there are too many employees working on a shift, then an overstaffing problem arises and that results in a loss of money for PlanAir.
If there is understaffing, then it has a negative impact on an employee’s working environment during that particular shift, because they will have to do more work leading to stress.
Question 2
Taking into account the data given for shifts, employees and demand, which