Please use this identifier to cite or link to this item:
Title: Using integer programming for airport service planning in staff scheduling
Authors: Ip, WH 
Chung, N 
Ho, TS
Keywords: Airport service
Manpower scheduling
Issue Date: 2010
Publisher: SAGE Publications
Source: International journal of engineering business management, 2010, v. 2, no. 2, p. 85-92 How to cite?
Journal: International journal of engineering business management 
Abstract: Reliability and safety in flight is extremely necessary and that depend on the adoption of proper maintenance system. Therefore, it is essential for aircraft maintenance companies to perform the manpower scheduling efficiently. One of the objectives of this paper is to provide an Integer Programming approach to determine the optimal solutions to aircraft maintenance planning and scheduling and hence the planning and scheduling processes can become more efficient and effective. Another objective is to develop a set of computational schedules for maintenance manpower to cover all scheduled flights. In this paper, a sequential methodology consisting of 3 stages is proposed. They are initial maintenance demand schedule, the maintenance pairing and the maintenance group(s) assignment. Since scheduling would split up into different stages, different mathematical techniques have been adopted to cater for their own problem characteristics. Microsoft Excel would be used. Results from the first stage and second stage would be inputted into integer programming model using Microsoft Excel Solver to find the optimal solution. Also, Microsoft Excel VBA is used for devising a scheduling system in order to reduce the manual process and provide a user friendly interface. For the results, all can be obtained optimal solution and the computation time is reasonable and acceptable. Besides, the comparison of the peak time and non-peak time is discussed.
EISSN: 1847-9790
DOI: 10.5772/9716
Rights: This work is licensed under the terms of the Creative Commons Attribution 3.0 Unported License (
Appears in Collections:Journal/Magazine Article

Files in This Item:
File Description SizeFormat 
Ip_Integer_Programming_Airport.pdf791.82 kBAdobe PDFView/Open
View full-text via PolyU eLinks SFX Query
Show full item record
PIRA download icon_1.1View/Download Contents


Last Week
Last month
Citations as of Jul 31, 2018

Page view(s)

Last Week
Last month
Citations as of Aug 14, 2018


Citations as of Aug 14, 2018

Google ScholarTM



Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.