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

Downing, Matthew; Chipulu, Max; Kaparis, Dinos; Ojiako, Udechukwu

Abstract

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.

• Journal Article Type: Article
• Acceptance Date: Jan 2, 2012
• Online Publication Date: Feb 9, 2012
• Publication Date: 2014
• Deposit Date: Sep 21, 2021
• Journal: Production Planning & Control: The Management of Operations
• Print ISSN: 0953-7287
• Publisher: Taylor & Francis
• Peer Reviewed: Peer Reviewed
• Volume: 25
• Issue: 1
• Pages: 73-90
• DOI: https://doi.org/10.1080/09537287.2012.658451
• Keywords: Forecasting; Inventory planning; Support systems
• Public URL: http://researchrepository.napier.ac.uk/Output/2802464