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.
 Bisgard, S. and Kulachi, M. (2011) Time Series Analysis and Forecasting by Example. Wiley & Sons Inc., New York.
 Kirchgassner, D., Wolters, J. and Hassler, U. (2013) Introduction to Modern Time Series Analysis. 2nd Edition, Springer Heidelberg, New York.
 Brown, R.G. (1956) Exponential Smoothing for Predicting Demand.
 Sokolowski, J.A. (2010) Monte Carlo Simulation. In: Sokolowski, J.A. and Banks, C.M., Eds., Modelling and Simulation Fundamentals: Theoretical Underpinnings and Practical Domains, Wiley & Sons Inc., New Jersey, 131-145.
 Metropolis, N. and Ulam, S. (1949) The Monte Carlo Method. Journal of the American Statistical Association, 44, 335-341.
 Azzalini, A. (2008) The Skew-Normal Probability Distribution.