The Application of Time Series Modelling and Monte Carlo Simulation: Forecasting Volatile Inventory Requirements

Davies, Robert, Coole, Tim and Osipyw, David (2014) The Application of Time Series Modelling and Monte Carlo Simulation: Forecasting Volatile Inventory Requirements. Applied Mathematics,, 5 (8). pp. 1152-1168. ISSN 2152-7385

[img]
Preview
Text
C:\tim's stuf\steve davies\-7402068 (3).pdf
Available under License Creative Commons Attribution.

Download (3MB) | Preview

Abstract

During the assembly of internal combustion engines, the specific size of crankshaft shell bearing is not known until the crankshaft is fitted to the engine block. Though the build requirements for the engine are consistent, the consumption profile of the different size shell bearings can follow a highly volatile trajectory due to minor variation in the dimensions of the crankshaft and engine block. The paper assesses the suitability of time series models including ARIMA and exponential smoothing as an appropriate method to forecast future requirements. Additionally, a Monte Carlo method is applied through building a VBA simulation tool in Microsoft Excel and comparing the output to the time series forecasts.

Item Type: Article
Divisions: ?? BucksNewUniversity ??
Depositing User: ULCC Admin
Date Deposited: 11 Feb 2016 10:55
Last Modified: 11 Dec 2017 19:17
URI: https://bnu.repository.guildhe.ac.uk/id/eprint/9524

Actions (login required)

Edit Item Edit Item