Advanced inventory planning and forecasting solutions: a case study of the UKTLCS Chinook maintenance programme

• Published in: Production planning & control Vol. 25; no. 1; pp. 73 - 90
• Main Authors: Downing, Matthew, Chipulu, Max, Ojiako, Udechukwu, Kaparis, Dinos
• Format: Journal Article
• Language: English
• Published: London Taylor & Francis 02-01-2014; Taylor & Francis LLC
• Subjects: Forecasting; Forecasting techniques; Information systems; Inventory management; inventory planning; Military helicopters; Software; Studies; support systems; United Kingdom > UK
• ISSN: 0953-7287; 1366-5871
• DOI: 10.1080/09537287.2012.658451

This article which advances on earlier published work by the authors, evaluates the forecasting performance of the inventory planning and forecasting support system used by Boeing's United Kingdom Through Life Customer Support to manage inventory for the maintenance of the Royal Air force fleet of Chinook helicopters. Focussing mainly on a sample of the spare-part components considered most influential on maintenance costs, limitations in the current forecasting system are identified. Approaches for improving forecasting performance are explored using Visual Basic for Applications (VBA)-based tools. It is found that generic proprietary inventory and forecasting systems can be enhanced by using VBA tools that allow detailed examination of each component's demand time series. For propriety reasons, all data have been sanitised.