ARIMA Model Comparison and Prediction for Transformer Requirement
Added on 2019-09-13
9 Pages1193 Words419 Views
|
|
|
Running Head: A-CAT CORPORATIONA-CAT CORPORATIONStudent Name
A-CAT CORPORATIONExecutive SummaryThis report aims toward providing an analytical approach for predicting/forecasting the transformer requirements and sales of refrigerators by A-CAT corporation in order to solve the issue of under andover-stocking faced by the inventory department and the sales division forproviding a good measure for the right amount of inventory. This report used different time series forecasting method to predict the future sales and the requirements of the primary product of the company. The study uses the data available from January’06 to December’10 to make the prediction for next year. Three different models namely Auto-Regression (AR model), Moving-Average (MA-model) and ARMA model wasused for the prediction. The MA model or moving average model was found to be the best model in terms of least error in predicting the already known sales figures.
A-CAT CORPORATIONA-CAT CorporationA-CAT was one of the leading producers of electrical appliances in India. It competed with and belonged to the category of medium scale industry, which produced and distributed domestic electrical appliances to the ruralpopulation in and around the Vidarbha region. The company owned and operated two medium-sized manufacturing units in a sleepy town called Gondia, in one of the remote districts in Vidarbha, ironically a backward region in the most progressive state of India, Maharashtra. A-CAT had an alliance partnership with Jupiter Inc. for the production of cabinets and had a collaborative venture with Global Electricals for manufacturing TV signal boosters and battery chargers (Shumway, 2011).A-CAT's primary flagship product was a voltage regulator of 500 kilovolt amps (KVA) that was branded and sold under the tag of VR-500. These voltage regulators were used for varied purposes but were most commonly used in households as a protective device for refrigerators and television sets, so as to protect the latter from the vagaries of load fluctuations and/or frequent power failures, which were a very common phenomenon in Vidarbha.Forecasting Process – SignificanceDuring the past few months, the sales of voltage regulators had fallen off. In reaction, A-CAT recently started deliberating on its policy of purchasing and stocking spares and components in the system especially with regard to schedule and stock-in-hand inventory. The firm stored all its spares andcomponents, including the transformers, in its factory store.Orders for the main product of A-CAT - that is, voltage regulators are throughout the year. Most of the time, these orders were categorized as "rush orders," and the store managers knew that the supplier of the transformers required for the product needed at least one week, if not more' for delivery. On top of this, it was likely that the transformer supplier would raise prices if uniformity and continuity in placing of ordersfor transformers were not guaranteed. Placing orders beyond a certain limit also stretched the system - whereas A-CAT had previously had access to four suppliers. Now there was only one. Moreover, the blocking of capital had a domino effect on the purchase and inventories of other products' spares and components. An increased cost of its primary spare component was the last thing A-CAT needed. The sales division was supposed to forecast the demand for voltage regulators as a measure for determining the right amount of transformers to keep in inventory.
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents