Premium Essay

Forcasting with Indicies

In:

Submitted By geigerml
Words 1369
Pages 6
Forecasting with Indices
Geist Industries manufactures various types of snow shovels for distribution to several states in the United States, mostly for small retail businesses. The corporate headquarters and manufacturing plant are located in Anchorage, Alaska with distribution plants in 21 states. The company has recently hired a new CEO who has asked that I make a seasonal demand forecast based on the last four years of winter historical inventory data that has been recorded. The winter historical inventory data is based on actual demand in numbers of snow shovels manufactured by Geist Industries. To minimize the data and make it more manageable for analysis, I have devised a twelve month average for each of the four years and plotted the resulting data to forecast the upcoming year’s demand in Figure A. The following formula was used to calculate the twelve month average individually for years one through four:

Total Demand (Actual) for Year (January thru December) = Individual Year Average 12

(Figure A) I have extended the trend line to forecast the 5th year demand, in this case to provide a forecasted average that follows a similar trend to that which has been displayed in the past four years. The trend line that has been established displays an R2 value of 0.9553 allowing a conclusion that the data set is relatively useful in forecasting future demand. Using the 12 month average for the last four years of data we can safely assume that next years average demand will be potentially somewhere in the neighborhood of 49,000.
Analyzing the Historical Inventory Data Figure B illustrates the Winter Historical Inventory Data. To make a determination regarding how to best construct a forecast and index the data must first be reviewed for any inaccuracies or data that may need to

Similar Documents

Free Essay

Forcasting with Indicies

...Forecasting with Indices Andrea Quantitative Reasoning for Business - QRB 501 Kumar Das, PhD January 24, 2011   Forecasting is a tool business use to help plan for the future. Businesses forecast, revenue, overhead, needed inventory, consumers demands, as well as other factors. Forecasting helps to determine the future market value of a company or organization. Forecasting is important because the curse of action business take today often depends on what is going to happen in the future. The winter historical data for the University of Phoenix covers four years of demand in actual units. Each year has been broken down to 12 months of data. The data is presented in figure 1.1 Typical Seasonal Demand for Winter Highs Actual Demands (in units) Month Year 1 Year 2 Year 3 Year 4 Forecast 1 55,200 39,800 32,180 62,300 2 57,350 64,100 38,600 66,500 3 15,400 47,600 25,020 31,400 4 27,700 43,050 51,300 36,500 5 21,400 39,300 31,790 16,800 6 17,100 10,300 31,100 18,900 7 18,000 45,100 59,800 35,500 8 19,800 46,530 30,740 51,250 9 15,700 22,100 47,800 34,400 10 53,600 41,350 73,890 68,000 11 83,200 46,000 60,200 68,100 12 72,900 41,800 55,200 61,100 Avg. Figure 1.1 (University of Phoenix, 2011). The Time-Series Method is an example of quantitative forecasting. This forecasting model uses historical data to try to predict future events .Knowing the data from the last four years, will help to predict how long the demand in units...

Words: 758 - Pages: 4