Simulation models are becoming essential for the estimating the requirements for Airports. I was interested in finding out how it works and decided to develop one for my self. The only problem was what tool should I use for the same. After looking for various possiblilities like MATLAB or Witness, I decided the one most widely available and easily understood by all; Excel. Now the only issue was how valid it will be to use it for the simulation of complex process of Airport Check-in. I have simulated only the Check-in process with Check-in Desks, Kiosks and Web Check-in. The results were interesting and I thought it will be very nice to share with some of you, thus decided to write a blog on the same. This was part of my MSc Thesis at Cranfield University and I am awaiting results.I have used Excel 2007 to make the Model and thus the files does not have backward compatibility. I am sharing the user guide and kind of things that can be achieved by the model. I can forward the file with anyone who wants to know more about it. Leave a comment or two and I will get back to you very soon.
The Simulation model is designed in MS Office Excel 2007.The simulation model simulates the check-in process at airport with self-service and web check-in.It is designed to estimate the requirements for a two step self service check-in, which includes kiosks and bag drop-off at the airport.The model enables the users to analyze the impacts of the changes made in resources and estimate the requirements of check-in counters, kiosks and bag drop-off.The structure of the model, the inputs required and interpretation of results have been explained to enable the user to get the maximum utility from the model.
The model has been kept as simple as possible and there is no additional software or macros required to run the simulation.The model is limited to the size of the inputs. The model can only compute for maximum 2500 Peak hour passengers or maximum resources of 25 in each mode.
The model can determine the average queuing time for passengers, determine the resources required to process the total passengers with various combination of resources possible. The simulation model can also determine the Fast Bag drop off which is big unknown for the airports right now.
The model was developed after collecting data from three airports. It was noticed that the queuing at airport was determined by the arrival profiles at the airport. Thus the model was designed so that the airport can modify the arrival profile to suit the local situations. It was observed that there are in particular three types of arrival profiles as leisure, business and mixed.
During the development of model various options were evaluated and other variables like processing times and arrival in groups were also tested. It was observed that other variables did not affect the queuing at the check-in desk to a great extent, thus those were not included as variables that a user can modify easily. The model still addresses the variability in processing times and number of bags per person.
The results were interesting and various scenarios were tested to check the sensitivity of the model. The model was able to replicate the as is scenarios and also was able to provide the logical answers to the porblem of exact resources. The conclusion was that self-service check-in can be very useful to the airports with more business travellers or passengers with less bags. It was noticed that the limiting factor was the fast bag drop-off and not the CUSS Check-ins.
I would be glad to share more information and knowledge with anyone and discuss more about the details if you are interested. Thanks for reading and I will appreciate your inputs!!!
