Demand forecasting and inventory control: A simulation study on automotive spare parts

José Roberto do Rego and Marco Aurélio de Mesquita

International Journal of Production Economics, 2015, vol. 161, issue C, 1-16

Abstract: This paper presents results of a large-scale simulation study on spare parts demand forecasting and inventory control to select best policies within each SKU category. Simulations were conducted over 10,032 SKUs of an automaker that operates in Brazil, considering six years of demand data. Literature review drove the selection of different models simulated. The study included three alternatives to record demand data (individual orders data, weekly and monthly time buckets), three demand forecasting models (SMA – Simple Moving Average, SBA – Syntetos–Boylan Approximation and Bootstrapping) and six models for demand distribution during lead-time (Normal, Gamma, NBD-Negative Binomial Distribution, compound Poisson-Normal, compound Poisson-Gamma and Bootstrapping) resulting in 17 “combined” policies. These policies were applied under (s, nQ) inventory control (reorder point, multiples of fixed order quantity), considering two alternative frequencies for model parameters revision (monthly and semi-annually) and four Target-Fill-Rates (TFR=80%, 90%, 95% and 99%), totalizing 136 simulation runs over each SKU. Parameter values (s, Q) were calculated towards TFR using methods from literature. Performance of each combined policy was measured by total costs and RFR – Realized-Fill-Rate. Major contributions of the research are the policy recommendations within each SKU category, a new Bootstrapping procedure and the highlight of Single Demand Approach (SDA) as a promising area for future theoretical and empirical studies. Results shall be used as guideline for practitioners under similar operations.

Keywords: Spare parts; Demand forecasting; Inventory control; Simulation (search for similar items in EconPapers)
Date: 2015
References: View references in EconPapers View complete reference list from CitEc
Citations: View citations in EconPapers (12)

Downloads: (external link)
http://www.sciencedirect.com/science/article/pii/S0925527314003594
Full text for ScienceDirect subscribers only

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:eee:proeco:v:161:y:2015:i:c:p:1-16

DOI: 10.1016/j.ijpe.2014.11.009

Access Statistics for this article

International Journal of Production Economics is currently edited by Stefan Minner

More articles in International Journal of Production Economics from Elsevier
Bibliographic data for series maintained by Catherine Liu ().