Optimal Production Inventory Policies for Operations: A Case Study of PVC Pipes Production

Abstract:

This study focuses on solving the problem of overstocking and under stocking of production inventory in manufacturing sector. To ensure effective management of inventory in manufacturing sector, three years production data were gathered and properly analyzed using multiple linear regression analysis and time series forecasting methods. A multiple linear regression model was developed in MINITAB software to make prediction for inventory requirements. From the result, the coefficient of determination (R²) is 1.00, the adjusted R² is 1.00, F-distribution is 4.212 x 10⁷ which is greater than any value in F-distribution table, and all these show a very strong relationship between the dependent variable and the independent variables. Also, a Time series analysis was done to make forecast of monthly inventory requirements for both raw materials and finished products. Trend analysis and Moving Average method were used in Time series forecasting, and lower Mean Absolute Percent Error (MAPE) and Mean Absolute Deviation (MAD) were used as criteria for selecting the method that gives the best forecast. From the results obtained, Trend analysis gave MAPE 13% and MAD 2350, while Moving Average gave MAPE 14% and MAD 2574. This work adds to growing body of literatures on data driven inventory management by utilizing historical data in customized software for generation of models that can effectively make forecast of inventory requirements in manufacturing sector. Nomenclature: a = Value of y_t at t = 0; b = Trend Value; MA= Moving Average; MAD = Mean Absolute Deviation MAPE =Mean Absolute Percentage Error; N = Number of periods; t = Period Yt = Forecast for period t y = Monthly Quantity of Product Produced α=regression constant β1-βk=Coefficients of the independent variables

• Periodical: Advanced Materials Research (Volume 824)
• Pages: 536-543
• DOI: https://doi.org/10.4028/www.scientific.net/AMR.824.536
• Online since: September 2013
• Authors: Harold C. Godwin, Uchendu O. Onwurah
• Keywords: Inventory Management, Multiple Linear Regression, Production Forecasting Models, Time Series Analysis

References

[1] I.E. Grossmann, Enterprise-wide Optimization: A new Frontier in Process Systems Engineering, AIChE Journal, 51(2005) 1846-1857.

DOI: 10.1002/aic.10617

[2] S. Chopra, P. Meindl, Supply Chain Management: Strategy, Planning and Operation, Prentice Hall, Saddle River, NJ, (2003).

[3] B. Azizul, A. K. Anton, Inventory Management Systems with Hazardous Items of Two-Parameter Exponential Distribution, Journal of Social Sciences, 5(2009) 183-187.

DOI: 10.3844/jssp.2009.183.187

[4] M. Telsang, Industrial Engineering and Production Management, S. Chand & Company Ltd, New Delhi, (2001).

[5] W.J. Stevenson, Operations Management, 10th ed., The McGraw-Hill Companies, New York, (2009).

[6] H. Arsham, Time-critical Decision Making for Business Administration. Http: /home. ubalt. edu/ntsbarsh/stat-data/forecast. htm(2009). Retrieved on (2012).

[7] C.C. Ihueze, E.C. Okafor, Multivariate Time Series Analysis for Optimum Production Forecast: A Case Study of 7Up Soft Drink Company in Nigeria, African Research Review, 4(2010) 276-305.

DOI: 10.4314/afrrev.v4i3.60191

[8] P.C. Nnabude, A.D. Nkemnebe, M.O. Ezenwa, Reading in Research Methodology and Grant Writing, Rex Charles & Patrick ltd, Nimo, (2009).