A heuristic to minimize the inventory value of repairable parts with service constraints: application to an airline company

A heuristic to minimize the inventory value of repairable parts with service constraints: application to an airline company

Manuel Cardós, Eugenia Babiloni, Marta E. Palmer, Ester Guijarro

Universitat Politècnica de València (Spain)





Received: September 2012

Accepted: March 2013


Cardós, M., Babiloni, E., Palmer, M.E. & Guijarro, E. (2013). A heuristic to minimize the inventory value of repairable parts with service constraints: application to an airline company. Journal of Industrial Engineering and Management, 6(3), 771-778. http://dx.doi.org/10.3926/jiem.564

---------------------

Abstract:

Purpose: This paper focuses on the improvement of the inventory management of repairable parts of the airline company Air Nostrum. The company uses a common sales replacement policy to manage their repairable parts and the same target fill rate for every item. This target is very high in order to assure a high availability of the aircrafts, dealing also to a high inventory value.

Design/methodology/approach: However, this paper shows that an alternative heuristic approach outperforms the previous one terms of inventory value while fulfilling the target fill rate.

Findings: This improvement is illustrated with an extensive and real dataset and may lead to a significant inventory reduction.

Originality/value: Therefore, a company can design its inventory policies applying this heuristic focused on inventory reduction with a service level constraint instead of the usual cost optimization or service level fulfillment.

Keywords: inventory management, airline industry, ABC classification

---------------------

1. Introduction and literature review

Repairable parts are a kind of spare part that may be repaired and eventually used again. Nowadays the optimization of the inventory of repairable parts has become a strategic issue in industries such as airlines because: (i) they serve an installation with a high turn off cost; (ii) items are so critical that when just one of them is out of service then the airplane must stay on ground, also called aircraft on ground (AOG) condition; (iii) a high inventory level is needed in order to assure a high availability of the installation served; (iv) repairable parts are usually expensive and therefore repairing them becomes a good option to save costs; and (v) the resulting inventory value is usually very large, in fact it is told in this industry that one of every twenty aircrafts is always on the ground in the form of spare parts. Not surprisingly for the last years researchers have focused on developing models to improve the management of these items. A complete literature review on the subject can be found in (Guide & Srivastava, 1997) and (Kennedy, Patterson & Fredendall, 2002).

In practice, the most common policy used to manage repairable parts is the base stock sales replacement policy (S-1, S). Additionally, most of the repairable items show erratic or lumpy demand, being zero demand the most frequent demand per period. Therefore, traditional approximations fail to provide acceptable fill rate (FR) estimations and as a consequence exact procedures are needed. In this context (Feeney & Sherbrooke, 1966) develop an exact method to compute the fill rate as the expected amount of demand that can be filled immediately from the on-hand stock, assuming compound Poisson distributed demands. Some years later, (Muckstadt & Thomas, 1980) apply that approach for Poisson distributed demands deriving the easy-to-compute expression to calculate the fill rate:

(1)

where S is the base stock level and FL(·) is the cumulative distribution function of demand during the reparation lead time L. More recently (Palmer, Babiloni, Cardós & Estellés, 2012) propose a general expression to compute the fill rate for any discrete, independent and identically distributed demand:

(2)

If a company decides to use the fill rate as service level metric and the same target for all the items, then the reference stock will be one unit for most of the items due to the erratic nature of their demand, as will be explained later. Furthermore, the average expected fill rate will clearly exceed the target dealing to an unnecessary overstock. It should be noted that the average fill rate can be calculated (Thonemann, Brown & Hausman, 2002) as the average of the item fill rates weighted by the fraction of demand corresponding to each item.

The company may go further and can set fixed service targets per ABC classes, using a demand value or demand volume criterion (Silver, Pyke & Peterson, 1998). However, the question is what those targets should be. The literature does not help because on the one hand some authors (Armstrong, 1985) affirm that A items should have the highest targets to avoid frequent backlogs but on the other hand it has been argued (Knod & Schonberger, 2001) that C items should have the highest service targets to avoid dealing with frequent stockouts.

Additionally (Zhang, Hopp & Supatgiat, 2001) have proposed a new ranking criteria according to the ratio D/L · c2 being D the expected annual demand, L the lead time and c the unit cost.

More recently (Teunter, Babai & Syntetos, 2010) have considered the classification from an inventory costs perspective and have proposed a cost criterion rank (D · b)(Q · h) being b the shortage cost, h the unit holding cost and Q the order size. This criterion includes a measure of item criticality, a factor considered by some authors especially for spare parts management, in the form of stockout cost. The authors claim that this criterion outperforms the previous ones.

However, it cannot be forgotten that: “Since a subjective evaluation of stockout cost is necessary in many (if not most) inventory-planning situations, the issue is not whether to make such an evaluation but how to make the evaluation” (Badinelli, 1986). Therefore it has been suggested (Fogarty, Blackstone & Hoffman, 1991) that stockout costs should be replaced by an appropriate target service level. In fact, in practice it is not possible to provide an objective evaluation of stockout costs for an airline company.

Anyway, operations management has always to cope not only with the economical aspects of its decisions but also with their impact on the financial needs of the company. Accordingly the inventory cost optimization has received a lot of work, but surprisingly it has not happened to the inventory value optimization. This paper focuses on this gap so that the main objective of this paper is to provide a procedure to minimize the inventory value while fulfilling a target fill rate.

The remainder of this paper is organized as follows. In Section 2 we present the problem addressed by this paper. In Section 3 we propose the new heuristic to minimize the inventory value while fulfilling the average target fill rate and we examine some results base on an extensive historical dataset. Finally in Section 4 we provide our conclusion, some managerial insights and direction for further research.

2. Description of the problem

The Spanish airline company Air Nostrum is one of the most important European regional airlines, and is ranked among the 15 largest regional airlines in the world. This company operates 450 flights and more than 150 routes to over 60 destinations in European and African countries. The company has been involved in a project to improve the management of repairable and critical items because of their large inventory value and high impact on the customer service. Additionally, these parts cannot be easily replaced by a similar one due to international regulations.

Fortunately every item can be accepted to be equally critical because the lack of any of them may produce an AOG condition, so the consideration of the criticality of every part can be avoided.

The data used in this paper include are the historical data on failures that took place during 911 consecutive days for 941 items. In order to illustrate the behaviour of the failures, it is shown the histograms of SKU-1 and SKU-2 in Figure 1 and Figure 2 respectively. SKU-1 is one of the few spare parts having demand (failures) almost all the days while the demand of SKU-2 is zero except for one day with 7 units demanded and another one with 13 units. A chi-square test shows that both demand patterns can be described by a negative binomial but not by a Poisson distribution. Having no demand during most of the periods is very usual for spare parts.


Figure 1. Demand pattern of SKU-1


Figure 2. Demand pattern of SKU-2

Statistical analysis shows that the demand pattern of these items can be described by a Poisson or a negative binomial distribution. However, these distributions play very different roles as shown in Table 1 where items have classified using an ABC demand volume criterion. About 80% of the item demand patterns can be described by a Poisson distribution, but they only account for 28% of the units demanded. This justifies the need of expression (2) for the exact fill rate estimation.


Poisson

Negative binomial

Category

# parts

units

# parts

units

A

36

3,244

56

15,997

B

182

2,322

93

1,263

C

531

1,060

43

154

Total

749 (80%)

6,626 (28%)

192 (20%)

17,414 (72%)

Table 1. Distribution functions of demand patterns

It can be seen in Table 1 that class C items have an average demand as low as one unit per year or lower, so a dilemma appears. If a unit stock reference is set then the expected service level is about 100% but if no stock reference is set then the expected service level is 0%. This is an example of the kind of decisions involved in a multi-item stock reference assignment.

The problem we address can be formulated as the selection of a reference stock for every item so that the inventory value minimizes and the target average fill rate is reached. It should be highlighted that the solution to this problem includes the decision of which items should be stocked or not.

3. Proposed heuristic and application

The heuristic we propose is based on a very simple idea: the next unit will be added to the item reference stock with the highest contribution to the average fill rate increase when compared to the inventory value increase. In order to apply this idea, the fill rate cost index (FCI) is defined for every item as:

(3)

being w the weight of the demand of the item, c the unit cost and FR(S) the fill rate with an S base stock. In every step, an additional unit is increased to the most suitable item.

This approach is very easy to understand but quite complex to apply because every item has to be considered for every additional stock base unit. Alternatively a more efficient procedure can be applied to avoid the simultaneous evaluation of all the items:

  1. A minimum FCI limit is set for all the items. In other words, it is established the lowest average fill rate increase that can be accepted per each Euro devoted to the inventory value.

  2. In an item per item basis, it is determined the maximum stock reference exceeding the FCI limit.

  3. If the average target fill rate is reached then the procedure stops, else step 2 is repeated and the FCI limit adjusted.

This procedure has been applied to the historical dataset of failures in Airnostrum beginning with a 1% increase of the average fill rate per each Euro added to the inventory value (FCI = 0.01). The result is an average fill rate of 80% and 10.1 million Euros inventory value. Afterwards the FCI is lowered three times providing the data shown in Table 2 and illustrated in Figure 3.

FCI limit

Inventory Value (€)

Average Fill Rate

0.01000

10,066,670

0.80877

0.00100

14,871,837

0.92765

0.00050

18,878,887

0.95587

0.00030

23,660,378

0.97504

Table 2. Minimum fill rate cost index (FCI), corresponding inventory value and average fill rate


Figure 4. Average fill rate vs. inventory value for different FCI values

It can be observed that the inventory value grows quicker than the service level. For example, 5 million Euros are needed to increase the average fill rate 12 points from 81% to 93%, but an additional investment of 4 million Euros is needed just to increase another 3 points to 0.96. However, the most important point to be highlighted is the company has reached a 97% average fill rate with 28.3 million Euros, so this heuristic reaches the same service level but lowering the inventory value in 4.6 million Euros.

4. Conclusions

A simple but effective heuristic has been proposed in this paper to reduce the inventory value subject to an average fill rate constraint in a multi-item context. This approach is not based on the usual ABC classification nor the more recent inventory cost perspective but on a novel inventory value focus. Additionally this heuristic does not require any subjective estimation such as in the case of the stockout cost.

Obviously these results have to be carefully evaluated before its implementation, including an extensive inventory cost assessment. Anyway, this method provides a lower bound of the inventory value reduction that can be obtained and can be very useful to reduce the financial stress that companies may suffer.

In a near future it should be analyzed the trade-off between inventory costs and inventory value optimization as long as both of them are connected to important aspects of the operations management.

Acknowledgements

This work is part of a project supported by the Universitat Politècnica de València, Ref. PAID-06-11/2022.

References

Armstrong, D.J. (1985). Sharpening Inventory Management. Harvard Business Review, 63(6), 42-58.

Badinelli, R.D. (1986). Optimal safety-stock investment through subjective evaluation of stockout costs. Decision Sciences, 17(3), 312-328. http://dx.doi.org/10.1111/j.1540-5915.1986.tb00229.x

Feeney, G.J., & Sherbrooke, C.C. (1966). The (S-1,S) inventory policy under compound Poisson demand. Management Science, 12(5), 391-411. http://dx.doi.org/10.1287/mnsc.12.5.391

Fogarty, D.W., Blackstone, J.H., & Hoffman, T.R. (1991). Production and Inventory Management. Second ed. Cincinnati, Ohio: South-Western Publishing Co.

Guide, J., & Srivastava, R. (1997). Repairable inventory theory: Models and applications. European Journal of Operational Research, 102(1), 1-20. http://dx.doi.org/10.1016/S0377-2217(97)00155-0

Kennedy, W.J., Patterson, J.W., & Fredendall, L.D. (2002). An overview of recent literature on spare parts inventories. International Journal of Production Economics, 76(2), 201-215. http://dx.doi.org/10.1016/S0925-5273(01)00174-8

Knod, E., & Schonberger, R. (2001). Operations management: Meeting customer demands. Cincinnati, Ohio: South-Western Publishing Co.

Muckstadt, J.A., & Thomas, L.J. (1980). Are Multi-Echelon Inventory Methods Worth Implementing in Systems with Low-Demand-Rate Items. Management Science, 26(5), 483‑494. http://dx.doi.org/10.1287/mnsc.26.5.483

Palmer, M., Babiloni, E., Cardós, M., & Estellés, S. (2012). On the Exact Calculation of the Fill Rate for Repairable Parts: Application to an Airline Company. In Industrial Engineering: Innovative Networks. Springer-Verlag London Limited.

Silver, E.A., Pyke, D.F., & Peterson, R. (1998). Inventory Management and Production Planning and Scheduling. (3ª ed.) Wiley.

Teunter, R.H., Babai, M.Z., & Syntetos, A.A. (2010). ABC Classification: Service Levels and Inventory Costs. Production and Operations Management, 19(3), 343-352. http://dx.doi.org/10.1111/j.1937-5956.2009.01098.x

Thonemann, U.W., Brown, A. O., & Hausman, W. H. (2002). Easy quantification of improved spare parts inventory policies. Management Science, 48(9), 1213-1225. http://dx.doi.org/10.1287/mnsc.48.9.1213.173

Zhang, R.Q., Hopp, W.J., & Supatgiat, C. (2001). Spreadsheet implementable inventory control for a distribution center. Journal of Heuristics, 7(2), 185-203. http://dx.doi.org/10.1023/A:1009613921001




Licencia de Creative Commons 

This work is licensed under a Creative Commons Attribution 4.0 International License

Journal of Industrial Engineering and Management, 2008-2024

Online ISSN: 2013-0953; Print ISSN: 2013-8423; Online DL: B-28744-2008

Publisher: OmniaScience