The effect of demand aggregation on spare part supply chain planning: An empirical study of oil company.

Document Type : Research Paper


School of Industrial Engineering, Iran University of Science and Technology, Tehran, Iran


Spare parts with intermittent demand cause complexity in forecasting and planning decisions since the demand is zero in some periods. Therefore, the difficulties in planning regarding the demand quantity and arrival time motivate this study to investigate a well-structured strategy that aggregates the demand in low-frequency time intervals to reduce the zero-demand occurrence. In this way, the planning accuracy increases since the forecasting error is reduced by the use of demand aggregation. We fill the research gap by integrating the aggregation and planning model for repairable spare parts to answer the question of what the optimal aggregation level is. In this paper, we develope a planning model for a repairable spare part supply chain (SPSC) to examine the effect of aggregation on cost, stock level, and shortage. An empirical investigation from an Iranian oil company is used to validate the benefit of integrated demand aggregation. The results show that choosing an optimal aggregation level optimizes the cost, stock level, and shortage. It also improves the demand estimation gap. The provided model, measures, and managerial insights help the practitioners make robust decisions since the coefficient of variation decreases due to optimal aggregation level, which leads to improvement in the planning performance.


Main Subjects

  1. Axsäter, S. (2003). Evaluation of unidirectional lateral transshipments and substitutions in inventory systems. European Journal of Operational Research, 149(2), 438–447.

    Babai, M. Z., Ali, M. M., & Nikolopoulos, K. (2012). Impact of temporal aggregation on stock control performance of intermittent demand estimators: Empirical analysis. Omega, 40(6), 713–721.

    Babai, M. Z., Boylan, J. E., & Rostami-Tabar, B. (2021). Demand forecasting in supply chains: A review of aggregation and hierarchical approaches. International Journal of Production Research, 1–25.

    Babai, M. Z., Dallery, Y., Boubaker, S., & Kalai, R. (2019). A new method to forecast intermittent demand in the presence of inventory obsolescence. International Journal of Production Economics, 209, 30–41.

    Basten, R. J., Van der Heijden, M. C., Schutten, J. M., & Kutanoglu, E. (2015). An approximate approach for the joint problem of level of repair analysis and spare parts stocking. Annals of Operations Research, 224(1), Article 1.

    Chopra, S., & Meindl, P. (2007). Supply chain management. Strategy, planning & operation. In Das summa summarum des management (pp. 265–275). Springer.

    Croston, J. D. (1972). Forecasting and stock control for intermittent demands. Journal of the Operational Research Society, 23(3), 289–303.

    DeLurgio, S. A. (1998). Forecasting principles and applications. McGraw-Hill/Irwin.

    Dodin, P., Xiao, J., Adulyasak, Y., Etebari Alamdari, N., Gauthier, L., Grangier, P., Lemaitre, P., & Hamilton, W. (2021). Bombardier Aftermarket Demand Forecast with Machine Learning. Available at SSRN 3957452.

    Driessen, M. A. (2018). Integrated capacity planning and inventory control for repairable spare parts.

    Fan, L., Liu, X., Mao, W., Yang, K., & Song, Z. (2023). Spare Parts Demand Forecasting Method Based on Intermittent Feature Adaptation. Entropy, 25(5), 764.

    Farhadi, M. (2013). Developing a model for maximizing the availability considering the redundancy.

    Goltsos, T. E., Syntetos, A. A., Glock, C. H., & Ioannou, G. (2022). Inventory – forecasting: Mind the gap. European Journal of Operational Research, 299(2), 397–419.

    Gross, D., & Ince, J. F. (1978). Spares Provisioning for Repairable Items: Cyclic Queues in Light Traffic. A I I E Transactions, 10(3), 307–314.

    Jain, S., & Raghavan, N. R. S. (2009). A queuing approach for inventory planning with batch ordering in multi-echelon supply chains. Central European Journal of Operations Research, 17(1), 95–110.

    Keizer, M. C. A. O., Teunter, R. H., & Veldman, J. (2017). Joint condition-based maintenance and inventory optimization for systems with multiple components. European Journal of Operational Research, 257(1), 209–222.

    Lapide, L. (1998). New developments in business forecasting. The Journal of Business Forecasting, 17(1), 21.

    Li, L., Kang, Y., Petropoulos, F., & Li, F. (2023). Feature-based intermittent demand forecast combinations: Accuracy and inventory implications. International Journal of Production Research, 61(22), 7557–7572.

    1. Assadi, M. Mobin, H. Cheraghi, & Z. Li. (2019). An Algorithm for Performance Evaluation of Closed-Loop Spare Supply Systems With Generally Distributed Failure and Repair Times. IEEE Transactions on Reliability, 68(2), 678–688.

    Marfuah, U., Panudju, A. T., & Mansyuri, U. (2023). Dynamic Programming Approach in Aggregate Production Planning Model under Uncertainty. International Journal of Advanced Computer Science and Applications, 14(3).

    Mircetic, D., Rostami-Tabar, B., Nikolicic, S., & Maslaric, M. (2022). Forecasting hierarchical time series in supply chains: An empirical investigation. International Journal of Production Research, 60(8), 2514–2533.

    Moini, G., Teimoury, E., Seyedhosseini, S. M., Radfar, R., & Alborzi, M. (2021). A forward-reverse repairable spare part network considering inventory management. International Journal of Industrial Engineering and Production Research, 32(4), 1–23.

    Nikolopoulos, K., Syntetos, A. A., Boylan, J. E., Petropoulos, F., & Assimakopoulos, V. (2011). An aggregate–disaggregate intermittent demand approach (ADIDA) to forecasting: An empirical proposition and analysis. Journal of the Operational Research Society, 62(3), 544–554.

    Oey, E., Wijaya, W. A., & Hansopaheluwakan, S. (2020). Forecasting and aggregate planning application – a case study of a small enterprise in Indonesia. International Journal of Process Management and Benchmarking, 10(1), 1–21.

    Pinçe, Ç., Turrini, L., & Meissner, J. (2021). Intermittent demand forecasting for spare parts: A Critical review. Omega, 105, 102513.

    Punia, S., & Shankar, S. (2022). Predictive analytics for demand forecasting: A deep learning-based decision support system. Knowledge-Based Systems, 258, 109956.

    Sanguri, K., Patra, S., Nikolopoulos, K., & Punia, S. (2023). Intermittent demand, inventory obsolescence, and temporal aggregation forecasts. International Journal of Production Research, 1–23.

    Sarlo, R., Fernandes, C., & Borenstein, D. (2023). Lumpy and intermittent retail demand forecasts with score-driven models. European Journal of Operational Research, 307(3), 1146–1160.

    Setiawan, I., Nurdiansyah, N., Tosin, M., Lusia, V., & Wahid, M. (2022). Aggregate Planning Implementation for Planning and Controlling the Materials in the Beverage Packaging Industry. Spektrum Industri, 20(1), 91–100.

    Sherbrooke, C. C. (1968). METRIC: A multi-echelon technique for recoverable item control. Operations Research, 16(1), Article 1.

    Sousa, M., Tomé, A. M., & Moreira, J. (2022). Long-term forecasting of hourly retail customer flow on intermittent time series with multiple seasonality. Data Science and Management, 5(3), 137–148.

    Syntetos, A. A., & Boylan, J. E. (2005). The accuracy of intermittent demand estimates. International Journal of Forecasting, 21(2), 303–314.

    van Jaarsveld, W., Dollevoet, T., & Dekker, R. (2015). Improving spare parts inventory control at a repair shop. Omega, 57, 217–229.

    Walker, J. (1997). Base stock level determination for “insurance type” spares. International Journal of Quality & Reliability Management, 14(6), 569–574.

    Willemain, T. R., Smart, C. N., & Schwarz, H. F. (2004). A new approach to forecasting intermittent demand for service parts inventories. International Journal of Forecasting, 20(3), 375–387.