scieee AI-readable full text Open interactive document viewer

Optimization of Personnel Cost in Aircrew Assignment Problem using a Simple Fuzzy Logic Approach

Sumarti, Novriana; Chandra, Ferdyanto; Minardi, Jeremy

Abstract

In aviation industries, the aircrew assignment problem is one of the most important factors in total operational cost optimization. This problem will be solved in two steps: flight pairing and aircrew scheduling. The constraints to be satisfied in flight pairing include having the same airport for first departure and final destination, and the limitations of flying time, duty time and transit time. The optimization process results in optimal flight pairings that minimize the number of personnel needed to serve a flight schedule over a given period of time. Further optimization is needed to obtain a schedule in which an aircrew team can serve a rotation with the largest possible number of pairings on the condition that all constraints are fulfilled. For aircrew scheduling, there are constraints on flying time, resting time, total number of takeoffs, and number of holidays and workdays. The investigated optimization process was designed to get optimal rotations along with maximum total personnel cost reduction. The data set used in this research is a one-month full flight schedule from a big airline in Indonesia. A simple fuzzy logic approach was used to find a new flying time constraint in order to optimize personnel cost and evenly distribute the assignments. The results show that the new optimal flying time constraint can reduce personnel cost up to 5.07% per month, so it can yield significant savings on a yearly basis.

Full text

MENDEL — Soft Computing Journal, Volume 23, No.1, June 2017, Brno, Czech RepublicX OPTIMIZATION OF PERSONNEL COST IN AIRCREW ASSIGNMENT PROBLEM USING A SIMPLE FUZZY LOGIC APPROACH Novriana Sumarti, Ferdyanto Chandra and Jeremy Minardi Institut Teknologi Bandung Department of Mathematics Jl. Ganesha 10 Bandung, 40132 Indonesia [email protected] Abstract:In aviation industries, the aircrew assignment problem is one of the most important factors in total operational cost optimization. This problem will be solved in two steps: flight pairing and aircrew scheduling. The constraints to be satisfied in flight pairing include having the same airport for first departure and final destination, and the limitations of flying time, duty time and transit time. The optimization process results in optimal flight pairings that minimize the number of personnel needed to serve a flight schedule over a given period of time. Further optimization is needed to obtain a schedule in which an aircrew team can serve a rotation with the largest possible number of pairings on the condition that all constraints are fulfilled. For aircrew scheduling, there are constraints on flying time, resting time, total number of takeoffs, and number of holidays and workdays. The investigated optimization process was designed to get optimal rotations along with maximum total personnel cost reduction. The data set used in this research is a onemonth full flight schedule from a big airline in Indonesia. A simple fuzzy logic approach was used to find a new flying time constraint in order to optimize personnel cost and evenly distribute the assignments. The results show that the new optimal flying time constraint can reduce personnel cost up to 5.07% per month, so it can yield significant savings on a yearly basis.. Keywords:flight pairings, aircrew assignment problem, optimization, fuzzy logic, finance. 1 Introduction The optimization problem dealing with allocation of optimal flight pairs and assignment of aircrews to each rotation is called the aircrew scheduling problem. Since the last decade of the 20th century many aspects of this problem have been discussed extensively, including computational techniques and the management of incidental problems. In [1], the authors consider the problem with a set of sectors (or flights) requiring 2 regular pilots and a supplementary crew (a third pilot) in some sectors to generate more cost-efficient scheduling. A heuristic procedure was used to solve the sequence of matching problems, i.e., a repeated matching algorithm. In [2], the authors designed and implemented an aircrew assignment system based on the principle of artificial intelligence and the framework of abductive logic programming (ALP). Here, abduction is defined as the process of reasoning for explaining a given observation according to a general theory that describes the domain of observation. This approach gives a flexible modelling environment in which both the basic problem and its constraints can be easily represented directly from their high-level natural specification. Then an effective automatic translation (reduction) of this high-level representation is provided to the lower-level computational goals (constraints) that need to be solved. This approach is able to tackle the problem of adjusting or correcting existing solutions due to changes in the application environment. In [3], the authors present a scatter search algorithm, which is a population-based meta-heuristic method in which solutions are intelligently combined to yield better solutions. Its aim is to assign a personalized roster to each aircrew member ensuring fairness among regular aircrew members considering each’s preferences. This method has similar main steps as a genetic algorithm method. The result revealed efficient performance compared to variable neighbourhood search and branch-and-price methods. In [4, 5 and 6], the authors used a simulated annealing method, which is a technique based on an analogy between solving optimization problems and a simulation of the annealing of solids that minimize the energy of the states of the solid. This method is a search technique similar to the steepest descent algorithm, but it allows the occasional acceptance of an inferior solution in an effort to avoid being trapped in a local optimum. In [5 and 6], the authors applied their methods in solving a large-scale problem at a big airline company in Indonesia. The schedule was managed using the basic operations manual (BOM) containing general guidance for flight crew members regarding policies, procedures and aspects of flight operations that are applicable to all aircraft types. In [7], the original approach of solving the problem of aircrew pairing consists of dividing it into a cyclic daily problem, a cyclic weekly problem, and a dated monthly problem. This approach prohibits the repetition of the same flight numbers in the pairing process. The authors proposed an alternative solution that exploits flight number repetition 133 ISSN: 1803-3814 MENDEL — Soft Computing Journal, Volume 23, No.1, June 2017, Brno, Czech RepublicX in pairings by skipping the first two phases and solving the monthly problem directly using a rolling horizon approach based on column generation. A model applying various flexible strategies, in particular in the determination of shifts, squad members and working hours, has been proposed in [8] so that an airline can effectively manage its maintenance manpower supply. It uses a mixed integer program and implemented operating data from a leading Taiwan airline. In [9], the authors discuss the feasibility and cost efficiency of airline schedules in relation to incidental problems due to reactionary delays. They propose an indicator of stability to generate more robust aircraft and crew schedules. The integrated formulation of the problem results in a nonlinear stochastic recourse function. It is then decomposed into separate linear problems, which are solved using a heuristic iterative approach based on column generation and dynamic programming for the recourse functions. In [10], the authors discuss the optimal length of prognostic distance, i.e., the time interval needed to gather information to predict future failures and to take appropriate action in order to decrease total cost related to a maintenance function. The model was implemented for minimizing life cycle costs and maximizing availability of aircraft across an airline network. In [11], the authors propose to solve the aircrew recovery problem when a schedule is out of sync due to incidents of mechanical failure and bad weather. This method eliminates the step of rotation generation to allow the crew recovery problem to be dealt with directly in relation to flight legs. The model is about a hundred times faster than the traditional process. Data from an international airline in Taiwan were implemented in the model. A fuzzy logic approach was used in [12] to solve the crew rostering problem, including the construction of personalized monthly schedules (rosters). Its multi-criteria decision making problem is solved using fuzzy control methods. For instance, fuzzy sets are used to describe the relative deviation of the assigned flight time from the ideal flight time or the assigned number of foreign per diem allowances from the ideal number. Defined fuzzy preferences are used, such as HN (highly negative relative deviation of the assigned value from the ideal), MN (moderately negative relative deviation of the assigned value from the ideal), S (small relative deviation of the assigned value from the ideal), MP (moderately positive relative deviation of the assigned value from the ideal), HP (highly positive relative deviation of the assigned value from the ideal) and ANY (any deviation whatsoever of the assigned value from the ideal). The approach was tested on data from airline companies characterized as small and medium sized. In this paper we utilize a simple fuzzy logic approach for searching the optimal permitted flying time per pilot for a particular time period in order to optimize the total personnel cost. We will use the data and general guidance BOM from [4, 5]. In the second section we explain the selection of flight pairings from given departure-arrival times in the schedule, and the determination of their binding conditions. In the third section, the objective functions and their constraints for solving the aircrew scheduling problem are formulated. A new set of flying times is proposed in the fourth section and the process of the fuzzy inference system to determine the new salary arrangement is explained. Finally, data implementation and discussion of the results are provided in the last 3 sections. 2 Flight Pairing and Aircrew Scheduling Problems 2.1 Construction of Flight Couples and Pairings Restricted conditions determined by the airline become the constraints to be satisfied in constructing flight pairings. They are: having the same airport for the first departure and the final destination, and the limitations of flying time, duty time and transit time. The airport of first departure and last arrival of a pairing should be the same. This airport is classified as the home base. In this case only 2 home base airports are considered out of 13 airports. There is also a regulation that any pair should contain one or more 2-flight sets that are taking off and landing from the same home base. For instance if A, B, C are the names of airports and A is the home base, the itinerary of pairing−𝑖 containing only one 2-flight set is A – B – A and the itinerary of pairing−𝑗 containing two 2-flight sets is A – B – A – C – A. Due to this condition, the total number of flights in one time period of the schedule should be even. Flying time is defined as the time period between the taking off and landing of the aircraft. Its maximum length for one pair is defined to be dependent on the number of pilots in the team: a regular 2-pilot crew team is allowed to have 9 hours flying time, an enlarged 3-pilot crew team can have 12 hours, and an enlarged 4-pilot crew team can have 22 hours. On the other hand, flight duty time (working hours) is defined as the time interval used by the aircrew team from the moment of report delivery upon departure at the beginning of a pair up to report delivery after the arrival at the end of a pair. The duration of each report delivery for one pair is 90 minutes. A one-day period is considered if the flying time is less than 14.5 hours and the duty time is less than 17 hours. A two-day period is considered if the flying time is between 14.5 and 22 hours and the duty time is between 17 and 34 hours. Transit time is the time interval between the aircraft’s landing from a previous flight and its next takeoff. The minimum transit time is 45 minutes or 0.75 hour. The actual length of transit time is an optimality consideration in constructing the flight pairs. Before obtaining a pair consisting of two or more flights in one consecutive journey it is good to arrange all flights in couples, i.e., sets of 2-flights satisfying the constraints. Let 𝑚 be an (even) number of all flights in the schedule. The 134 Optimization of Personnel Cost in Aircrew Assignment Problem using a Simple Fuzzy Logic Approach MENDEL — Soft Computing Journal, Volume 23, No.1, June 2017, Brno, Czech RepublicX selection of the matched flights is conducted randomly. Let 𝑘 be the number of couples where 0 < 𝑘 ≤𝑚 2. Let 𝑥 ∈ ℛ𝑘 ×𝑚 be all possible flight couples and 𝑥 𝑖 be the 𝑖-th couple for 𝑖= 1,2, …,𝑘 . There are 2 distinct indices 1 ≤𝑖1,𝑖2≤ 𝑚 so that 𝑥 𝑖,𝑖1=𝑥 𝑖,𝑖2= 1 and 𝑥 𝑖,𝑗= 0 for 𝑗≠𝑖1,𝑖2. All flights having been coupled, the next step is finding two or more couples that can be combined as a pair, using the technique introduced in [6]. Let 𝐺∈ℛ𝑚 2×𝑚 2 be the matrix of possible pairs, 𝐺𝑖𝑗 = 1 if couple−𝑖 and couple−𝑗 can be paired for 𝑗>𝑖, and 0 otherwise. Matrix 𝐺 is an upper triangular matrix. Let 𝐷,𝐸∈ℛ𝑚 2 be the vectors containing the numbers of possible pairs with the next and previous couples respectively. Here 𝐷 is the result of the row-wise summation of matrix 𝐺, and 𝐸 is the result of the column-wise summation of matrix 𝐺. 𝐷𝑖= 𝐺𝑖𝑗 𝑚/2 𝑗=𝑖+1 ,𝐸𝑗= 𝐺𝑖𝑗 𝑚/2 𝑖=1 . (1) If 𝐷𝑝= 1 and𝐸𝑝= 0 for 𝑝= 1, 2, …,𝑚 2, then couple−𝑝 can be paired directly with couple−𝑝𝑗 if𝐺𝑝,𝑝𝑗= 1. In this case, the existence of index 𝑝𝑗 is unique. In the same way, if𝐷𝑝= 0 and𝐸𝑝= 1, there is a uniquely existing 𝑝𝑖 such that 𝐺𝑝𝑖,𝑝= 1 so couple−𝑝 can be paired directly with couple−𝑝𝑖. For other nonzero values of 𝐷𝑖 and𝐸𝑗, the construction of pairs will be done randomly. A pair can contain more than two couples on condition that all constraints are satisfied. The construction of pairs yields matrix 𝑥∈ℛ𝑘×𝑚, where 𝑘 is the number of pairs. The values of𝑥𝑖,𝑖= 1,2, …,𝑚 are 0 or 1. For instance the first pair has𝑥1𝑖= 1 for 𝑖= 1,3,4,8, and 𝑥1𝑗= 0 for 𝑗≠𝑖. This means pair–1 contains flight numbers 1, 3, 4 and 8. There are no more possible flights that could be paired with those flights, considering the binding constraints. One pair of couples consists of matched flights that can be served by a team containing 2, 3 or 4 pilots. The value of 𝑘 also determines the number of aircrew members needed for one full flight schedule. We will choose the set of pairs 𝑥 that optimizes the number of possible pairs or the number of personnel needed to run one full schedule. This means it will find the minimum value of 𝑘. Let 𝐹𝑇 𝑥 ∈ℛ𝑘and 𝑇𝑇(𝑥)∈ℛ𝑘 be the total flying time and the transit time respectively resulted from pairing 𝑥. min 𝑥𝑓(𝑥,𝐹𝑇,𝑇𝑇). Here 𝑓:ℛ𝑘×𝑚×ℛ𝑘×ℛ𝑘→ℛ is an objective function. One way to determine the objective function is defining the following function: 𝐻 𝑥 = 𝐹𝑇(𝑥)𝑖 𝑘 𝑖=1 + 1 45−𝑇𝑇(𝑥)𝑖 𝑘 𝑖=1 . (2) The first term of the function is the total length of the flying time in minutes and the second term is the summation of the inversion of the difference between the minimum transit time (45 minutes) and the real transit time. The first term’s value is in hundreds and the second term’s value is in negative tens, so they are appropriate values to be added up. The pilot and his/her copilot(s) in a crew team could serve more than one pair during one period of the given schedule. The real required number of personnel can be reduced by finding the optimal scheduling, which is explained in the next section. 2.2 Aircrew Scheduling There are four restricted conditions with respect to the time length of the schedule under observation, which in this case is one month. They are: the maximum length of flying time, the number of days off, the number of takeoffs, and the minimum length of rest period. The maximum length of flying time depends on the license owned by the aircrew to fly a particular type of aircraft. In this case we use one type of aircraft to run the schedule and the maximum length of time considered here is 85 hours in one month. Later, this maximum length will become an open question in finding the optimal personnel cost for one month using fuzzy logic. In searching this new flying time constraint, there is an assumption that other regulations binding this maximum length are also satisfied. There is an obligation for each aircrew member to take one day off after working 7 days in a row. The total number of days off in one month should be at least 8. The maximum number of each aircrew member’s takeoffs in one month is 90. The minimum length of rest period for each aircrew member is 9 hours. In finding possible rotations for an aircrew team, the obtained pairs are combined in a consecutive way with the smallest length of total time every two pairs or more. The number of possibilities to combine is huge. However, based on experience, pairs with large flight numbers in their schedule have a smaller possibility than those with small flight numbers, which are usually the airports of popular destinations. Therefore, we begin with the large flight numbers and continue from there on. Let 𝑦∈ℛ𝑛×𝑘 be a set of flight rotations, where 𝑛 is the number of rotations and 𝑘 is the minimum number of pairs obtained from the previous optimization result. For instance rotation–29 has𝑦29,𝑗= 1 for 𝑗= 1,4,5,6,11,15,29, and 𝑦29,𝑖= 0 for 𝑖≠𝑗. This means that the 29th-team of pilots serves pairings 𝑥1,𝑥4,𝑥5,𝑥6,𝑥11,𝑥15 and𝑥29. We define 𝑙(𝑦)∈ℛ𝑛 to be the number of crew members needed to serve the schedule for set of rotations 𝑦. The objective of the aircrew scheduling task is to find the number of rotations that gives the minimum amount of total personnel cost. Let 𝐹𝑇𝑟(𝑦)∈ℛ𝑛and 𝑆(𝑦)∈ℛ𝑛 be the flying time and the amount of total salary respectively for set of rotations 𝑦. Let 𝑀𝑆 be a constant amount of basic salary per month if the pilot works with a flying time less than or equal to constant 𝐴𝐹𝑇(𝑦), i.e., the average flying time for one month. There will be an additional amount of salary if 135 N. Sumarti et al. MENDEL — Soft Computing Journal, Volume 23, No.1, June 2017, Brno, Czech RepublicX the crew member’s flying time is more than 𝐴𝐹𝑇(𝑦). The calculation for the additional amount is the multiplication between the extra hours and a constant amount of bonus money𝑆𝑏= 0.75% 𝑀𝑆. The optimization problem for the minimum personnel cost needed for operating one full flight schedule is as follows: min 𝑦𝑔(𝑦,𝐹𝑇𝑟,𝑆) where 𝑔:ℛ𝑛×𝑘×ℛ𝑛×ℛ𝑛→ℛ is an objective function. One way of determining this objective function is 𝑄1 𝑦 = 𝑀𝑆+ max 𝐹𝑇𝑟(𝑦)𝑖−𝐴𝐹𝑇(𝑦) ∙𝑆𝑏 𝑛 𝑖=1 (3) which calculates the total salary for all aircrew members in set of rotations 𝑦. We can set the objective function that can provide the arrangement of evenly distributed tasks among all crew members. The optimization problem for the minimum personnel cost needed for operating a one-month full flight schedule is as follows: min 𝑦𝑔(𝑦,𝐹𝑇𝑟,𝐴𝐹𝑇) The objective function can be in the following form: 𝑄2 𝑦 =1 𝑙(𝑦)𝑗 𝑛 𝑗=1 𝑙(𝑦)𝑖(𝑀𝑆+ max 𝐹𝑇𝑟(𝑦)𝑖−𝐴𝐹𝑇(𝑦) ∙𝑆𝑏) 𝑛 𝑖=1 (4) We can see the difference between the results of these objective functions in the fifth section. 3 A Simple Fuzzy Logic Approach for Optimizing the Flying Time Constraint We assume that the flying time constraint can still be modified so the optimal one can be found. The choice of this constraint is the only one that can significantly change the other constraints. A simple fuzzy logic approach is utilized for relaxing the limit of the permitted flying time per pilot for a particular period in order to solve the problem of optimizing the total personnel cost. Let 𝐹 = [𝑓𝐿,𝑓𝑀𝐿,𝑓𝑀𝑅,𝑓𝑅] be a fuzzy number defining the permitted flying time. In the original optimization problem, the permitted flying time per crew member is𝑓𝑀=1 2(𝑓𝑀𝐿+𝑓𝑀𝑅) per month. The new optimal flying time constraint should be within 𝐹 , but intuively it is not far from𝑓𝑀. It is straightforward that for 𝑥𝜖𝐹 the minimum number of crew members needed decreases while the values of the average flying time per aircrew increase. Now we need to determine the basic salary, which depends on the average flying time for each value of the new flying time 𝐹 . We define 3 (three) types of salary for the aircrew, i.e., low, medium and high, which are represented by 3 (three) triangular fuzzy numbers, 𝐿 ,𝑀 and𝐻 , and their membership functions,𝜇𝐿 𝑥 ,𝜇𝑀 𝑥 ,and 𝜇𝐻 𝑥 , respectively. 𝜇𝐿 𝑥 = 𝑓𝑀𝐿−𝑥 𝑓𝑀𝐿−𝑓𝐿,𝑓𝐿≤𝑥≤𝑓𝑀𝐿 0, 𝑥>𝑓𝑀𝐿 ,𝜇𝑀 𝑥 = 𝑥−𝑓𝐿 𝑓𝑀𝐿−𝑓𝐿,𝑓𝐿≤𝑥<𝑓𝑀𝐿 1, 𝑓𝑀𝐿 ≤𝑥≤𝑓𝑀𝑅 𝑓𝑅−𝑥 𝑓𝑅−𝑓𝑀𝑅,𝑓𝑀𝑅 <𝑥≤𝑓𝑅 ,𝜇𝐻 𝑥 = 𝑥−𝑓𝑀𝑅 𝑓𝑅−𝑓𝑀𝑅 ,𝑓𝑀𝑅 ≤𝑥≤𝑓𝑅 0, 𝑥>𝑓𝑅. (5) We need to define new basic salaries in order to make fair payment, because the lower flying time constraint will result in a smaller number of flights being able to be served by an aircrew team for the given period. On the other hand, the higher flying time constraint will result in a larger number of flights being able to be served by an aircrew team for the same period of time. Let𝐿𝑆,𝑀𝑆, and 𝐻𝑆 be the new basic salaries, where 𝐿𝑆= 1−𝑟 𝑀𝑆 and𝐻𝑆= 1 + 𝑟 𝑀𝑆, 0 < 𝑟< 1. In the original problem, there is only 𝑀𝑆 as the basic salary per hour. Let 𝐵𝑆(𝑥) be the basic salary per month for a new flying constraint for𝑥∈ 𝐹 . We define the basic salary based on the Sugeno method by the weighted average for𝑓𝐿≤𝑥≤𝑓𝐻. 𝐵𝑆 𝑥 =𝜇𝐿 𝑥 ∙𝐿𝑆+𝜇𝑀 𝑥 ∙𝑀𝑆+𝜇𝐻 𝑥 ∙𝐻𝑆 𝜇𝐿 𝑥 +𝜇𝑀 𝑥 +𝜇𝐻 𝑥 . The amount of bonus money added on top of the basic salary is𝑆𝑏= 0.75% 𝐵𝑆 per extra hour for each value of the average flying time. The optimum value of the total personnel cost is the minimum value of the multiplication between total flying time and salary. The total personnel cost depends on the determination of how far the values of 𝐿𝑆 and 𝑀𝑆 are from𝑀𝑆. A sensitivity analysis is conducted to see how the varying values of 𝑟 affect the optimal solution. The process of aircrew scheduling from the second section is redone using each new flying time constraint. The objective functions used are Equations (3) and (4), which are the same as in the original problem. 4 Numerical Results 4.1 Solving the Original Problem The data set used in solving the flight pairing problem here is a one-month full flight schedule from a big airline in Indonesia, which contains 𝑚=702 flights. There are 13 airports and 2 of them, CGK and DPS, become the home base airports. The optimization in pairing and scheduling processes follow the Monte-Carlo method developed using Matlab, where the next flight to be matched in the pairing process or the next pair to be united in the scheduling process is 136 Optimization of Personnel Cost in Aircrew Assignment Problem using a Simple Fuzzy Logic Approach MENDEL — Soft Computing Journal, Volume 23, No.1, June 2017, Brno, Czech RepublicX chosen randomly from the collection of possible candidates. The solution for the optimization problem is chosen as the best optimal value of the objective function. From the total of 702 flights, the pairing process results in 228 pairs that contain 2, 4 or 6 flights. The obtained total flying times are between 3.17 and 20.83 hours. The numbers of pairs containing 2, 3 and 4 pilots are 49, 43 and 136 pairs respectively. The total number of crew members needed to run the full schedule is 771 pilots. Examples of flight pairs can be found in Table 1. The rotation-making process yields 40 rotations for the one-month flight schedule. Based on the average salary in Indonesia, the basic salary 𝑀𝑆= 4000 USD per month. We define bonus 𝑆𝑏=300 USD per extra hour. Table 2 shows an example of the results from the objective function in Equation (3), where the minimum of the total salary of all personnel is calculated. The flying time lengths vary from 29 to 85 hours, the flying time average is 76.40 hours and the average working day is 7.58 days. Notice that this flying time average is still far from the maximum length, 85 hours. With the total number of crew members at 146 pilots, the personnel cost is 603,890 USD per month. Table 1: Examples of obtained flight pairs Pair no. Flight nos. Flying time (hours) Flying duty time (hours) Nb of crew 1. 1, 3, 4, 8 7.00 11.50 2 2. 2, 6 9.42 11.92 3 3. 5, 11, 17, 24 17.33 26.33 4 4. 7, 10 3.17 5.67 2 5. 9, 12 3.50 6.00 2 6. 13,19 4.58 12.67 2 7. 14, 25 20.17 23.83 4 17. 36, 51, 56, 57, 62, 67 10.50 31.08 3 Table 2: Examples of rotations obtained with objective function (3) Rotation no. Pair nos. Nb of flights Flying time (hours) Nb of crew 1. 7, 20 6 39 4 2. 10, 23 8 35 4 3. 3, 12, 24, 31, 39 20 84 4 4. 9, 14, 28, 37 14 63 4 5. 25, 32, 40,56 20 75 4 6. 18, 26, 33, 44 12 76 4 29. 1, 4, 5, 6, 11, 15, 19 20 36 2 40. 187, 192, 195, 205, 209, 213, 223, 227 16 82 3 Now we use the second objective function in Equation (4). Examples of the obtained rotations can be found in Table 3. The flying time lengths, the average flying times and the numbers of crew members needed are similar with the previous results. However, the total personnel cost is 603,350 USD per month. Table 3: Examples of rotations obtained with objective function (4) Rotation no. Pair nos. Number of flights Flying time (hours) Nb of crew 1. 3, 20 8 36 4 2. 10, 23, 39 12 51 4 3. 7, 12, 28, 37 14 71 4 4. 14, 24, 31, 40 16 68 4 5. 18, 26, 33, 42 10 78 4 6. 25, 32, 44, 56 20 76 4 25. 2, 8, 13, 19, 19, 22, 35, 38, 11 20 83 3 40. 143, 167, 171, 178, 180, 185, 186, 189, 196, 207, 211, 212, 215, 222 48 85 2 137 N. Sumarti et al. MENDEL — Soft Computing Journal, Volume 23, No.1, June 2017, Brno, Czech RepublicX 4.2 Optimal Flying Time Problem Now, a simple fuzzy logic approach is used to find the new optimal flying time constraint. Set 𝐹 = [65,80,90,105], where the original problem has the flying time constraint 𝑓𝑀=85 hours per month. Figure 1 shows a decreasing trend in the number of crew members needed in order to serve the full schedule, declining from 194 to 121. Due to the constant total amount of flying time for the full schedule, i.e., 11,154.76 hours, the ideal flying time per crew 𝐹𝑇𝐼𝑑 increases from 57.50 to 92.19 hours. Letting 𝐿 ,𝑀 and𝐻 be fuzzy numbers, the graphs of their membership functions are shown in Figure 2. These fuzzy numbers and their membership functions are used to define the basic salaries if the flying time constraints vary from 65 to 105 hours. Here, the basic salary for the new flying time constraints varying from 80 hours to 90 hours are defined as the same as the basic salary for the previous flying time constraint at 85 hours. Figure 1: Number of crew members and the amount of ideal flying time. Figure 2: Fuzzy numbers 𝐿 ,𝑀 and𝐻 . In the previous section, the basic salary per hour is 𝑀𝑆=4000 USD. For 𝑟=20%, we define: low rate (LR) = 3200 USD, medium rate (MR) = 4000 USD, and high rate (HR) = 4800 USD. Using the weighted average, the basic salary for 65 ≤𝑥≤105, shown as a striped line in Figure 3,ranges from 3200 to 4800 USD. It increases in the interval from 65 to 80, remains constant at 4000 USD in the interval from 80 to 90, and increases again in the interval from 90 to 105. This new arrangement of the basic salary can be modified with respect to different values of𝑟. Using the right vertical axis, the total salary amount obtained by solving the optimality problem for each integer 𝑥 in [65,105] can be seen in Figure 3. These amounts fluctuate above 600,000 USD when 𝑥≤86, below 600,000 USD when 87 ≤𝑥≤101, and increase when 𝑥≥102. The percentage changes of these total salary amounts with respect to 𝑥=85 can be found in Figure 4. The minimum amount of total salary in Figure 3 is 571,260 USD at 𝑥=89 hours. This is a 5.40% reduction from the amount obtained from the original problem at 𝑥=85, shown as the lowest point in Figure 4. The choice of reduction percentage r=20% is in fact the best one. Based on Figure 5, other values of r give the lowest cost at the lowest flying time constraint x=65. This flying time is too far from the original problem.Similar results are obtained when we use the objective function in Equation (4). If 𝑥=85, the average amount of salary per month per crew is 413,253.42 and the total amount of personnel cost is 603,350 USD. If 𝑥=90, for 𝑟= 0.2 or 𝑟= 0.4, the salary average is 403,352.11, or a 2.39% decrease, and the personnel cost savings are 5.07%. The decrease rate of personnel cost is larger than the decrease rate of average salary. If we compare to 𝑥=72 for 0 50 100 150 200 250 65 67 69 71 73 75 77 79 81 83 85 87 89 91 93 95 97 99 101 103 105 0 20 40 60 80 100 Number of crews Ideal Flying Time 0 0,2 0,4 0,6 0,8 1 65 67 69 71 73 75 77 79 81 83 85 87 89 91 93 95 97 99 101 103 105 M L H 138 Optimization of Personnel Cost in Aircrew Assignment Problem using a Simple Fuzzy Logic Approach MENDEL — Soft Computing Journal, Volume 23, No.1, June 2017, Brno, Czech RepublicX 𝑟= 0.6, the average salary is 281,544.44, or a 31.87% decrease, and the personnel cost savings are 21.14%. The decrease rate of personnel cost is smaller than the decrease rate of average salary. It follows that the most significant difference is produced by 𝑟= 0.2. Figure 3: Basic salaries and total salaries. Figure 4: Total salary amount changes with respect to 𝑥=85. Figure 5: Sensitivity analysis on reduction percentage 𝑟. Figure 6: Sensitivity analysis on reduction percentage 𝑟 for evenly distributed salary. 520 000 540 000 560 000 580 000 600 000 620 000 640 000 660 000 65 68 71 74 77 80 83 86 89 92 95 98 101 104 0 1000 2000 3000 4000 5000 6000 Total Salaries Basic Salaries -0,1000 -0,0500 0,0000 0,0500 0,1000 65 67 69 71 73 75 77 79 81 83 85 87 89 91 93 95 97 99 101 103 105 Total Salary Changes 0 200 000 400 000 600 000 800 000 1 000 000 65 67 69 71 73 75 77 79 81 83 85 87 89 91 93 95 97 99 101 103 105 r=0.2 r=0.235 r=0.4 r=0.6 r=0.8 0 200000 400000 600000 800000 65 67 69 71 73 75 77 79 81 83 85 87 89 91 93 95 97 99 101 r=0.2 r=0.4 r=0.8 139 N. Sumarti et al. MENDEL — Soft Computing Journal, Volume 23, No.1, June 2017, Brno, Czech RepublicX 5 Conclusions Based on data from 702 flights in a one-month schedule from a big airline in Indonesia using the original flying time limitation, the total number of flight pairings is 228 pairings, with 144 pairings for home base CGK and 84 pairings for home base DPS. The total number of crew members needed to operate the full schedule in one month is 146 pilots. The total personnel cost for one month is 603,890 USD, the average number of flights per pilot is 17.55, and the average flying time per crew member is 76.40 hours. The average flying time is much lower than the flying time constraint per crew member of 85 hours per month. Using a fuzzy logic approach and optimization of the amount of personnel cost, the new flying time limitation is 89 hours, so 138 pilots are needed; the average flying time per crew member is 80.83 hours and the total personnel cost is 571,260 USD. This means that a change in the flying time constraint from 85 to 89 hours can reduce total personnel cost up to 5.40%. This reduction is very significant for the operation over a longer time period. Having the optimization for an evenly distributed flying time, the new flying time limitation is 90 hours with 142 pilots and the average flying time per crew member is 78.55 hours. A change of the flying time constraint from 85 to 90 hours can reduce total personnel cost up to 5.07%. We conclude that a change in the flying time limitation reduces the optimal number of required crew members and the optimal personnel cost significantly. However, it is important to consider the impact of this longer flying time on the health and fitness of the crew members in executing their duties.In this case, the obtained result does not violate the civil aviation regulations [13,14] where the threshold is about 100 - 133 hours per month. The model can be modified in terms of the size of the schedule, the applied regulations in determining the constraints, and theamount of basic salary in order to see the behaviour of the obtained solutions. Acknowledgement: We are grateful to get a partial support from 2017 PM3I KK MIK ITB fund. We also thank to Dr. A.Y. Gunawan who gives significant input in this research. References [1] Wark, P., Holt, J., Ronnqvist. M., and Ryan, D. Aircrew schedule generation using repeated matching, European Journal of Operational Research 102. Pages 21-35 (1997). [2] Kakas, A.C. and Michael, A. Air-Crew Scheduling through Abduction, Proceedings of IEA/AIE-99 (1999). [3] Maenhout, B., and Vanhoucke, M. A Hybrid Scatter Search Heuristic for Personalized Crew Rostering in the Airline Industry, European Journal of Operational Research, 206 (1). Pages 155-167 (2010). [4] Lucic, P. and Teodorovic, D. Simulated annealing for the multi-objective aircrew rostering problem, Transportation Research Part A 33. Pages. 19-45 (1999). [5] Sumarti, N., Rakhman, R.N., Hadianti, R. and Uttunggadewa, S. Application of Simulated Annealing Method on Aircrew Assignment Problems in Garuda Indonesia, Proceeding of the 2012 International Conference of Applied and Engineering Mathematics (ICAEM’12), London, 4-6 July 2012. [6] Hadianti, R., Novianingsih, K., Uttunggadewa, S., Sidarto, K.A., Sumarti, N., and Soewono, E. Optimization model for an airline crew rostering problem: Case of Garuda Indonesia, Journal of Mathematical and Fundamental Sciences, Vol. 45 (3). Pages 218-234 (2014). [7] Saddoune, M., Desaulniers, G., and Soumis, F. Aircrew pairings with possible repetitions of the same flight number. Computers & Operations Research 40. Pages 805-814 (2013). [8] Yang, T., Yan, S., and Chen, H. An airline maintenance manpower planning model with flexible strategies. Journal of Air Transport Management 9. Pages 233-239(2003). [9] Dück, V., Ionescu, L., Kliewer, N., and Suhl, L. Increasing stability of crew and aircraft schedules. Transportation Research Part C 20. Pages 47-61 (2012). [10] Fritzsche, R., Gupta, J.N.D. and Lasch, R. Optimal prognostic distance to minimize total maintenance cost: The case of the airline industry. International Journal of Production Economics 151. Pages 76-88 (2014). [11] Chang, S. A duty based approach in solving the aircrew recovery problem. Journal of Air Transport Management 19. Pages 16-20 (2012). [12] Lucic, P. and Teodorovic, D. A fuzzy set theory approach to the aircrew rostering problem, Fuzzy Sets and Systems 95. Pages 261-271 (1998). [13] Federal Aviation Administration (FAA), USA, https://www.faa.gov/regulations_policies/faa_regulations/ retrieved in June 2017. [14] 2011Civil Aviation Regulations, The Minister of Transport, ZA, http://www.sapfa.co.za/sites/default/files/CIVIL_AVIATION_REGULATIONS-2011.pdf , retrieved in June 2017. 140 Optimization of Personnel Cost in Aircrew Assignment Problem using a Simple Fuzzy Logic Approach