Forcasting with Indicies

Running Head: Forecasting with Indices

Forecasting with Indices

University of Phoenix Online

April 18, 2011

Ohidul Siddiqui

The data that I used to gather my information was from the University of Phoenix website “The Summer Historical Inventory Data”. As you can see the data that was provided covers twelve months over a four year period. What I did was I took the average of each year, which was adding the demand of each of the months and dividing that by twelve which in return gave me the average. (See below spreadsheet)

|Month |Year 1 |Year 2 |Year 3 |Year 4 |Average |

|1 |$18,000.00 |$45,100.00 |$59,800.00 |$35,500.00 |$39,600.00 |

|2 |$19,800.00 |$46,530.00 |$30,740.00 |$51,250.00 |$37,080.00 |

|3 |$15,700.00 |$22,100.00 |$47,800.00 |$34,400.00 |$30,000.00 |

|4 |$53,600.00 |$41,350.00 |$73,890.00 |$68,000.00 |$59,210.00 |

|5 |$83,200.00 |$46,000.00 |$60,200.00 |$68,100.00 |$64,375.00 |

|6 |$72,900.00 |$41,800.00 |$55,200.00 |$61,100.00 |$57,750.00 |

|7 |$55,200.00 |$39,800.00 |$32,180.00 |$62,300.00 |$47,370.00 |

|8 |$57,350.00 |$64,100.00 |$38,600.00 |$66,500.00 |$56,637.50 |

|9 |$15,400.00 |$47,600.00 |$25,020.00 |$31,400.00 |$29,855.00 |

|10 |$27,700.00 |$43,050.00 |$51,300.00 |$36,500.00 |$39,637.50 |

|11 |$21,400.00 |$39,300.00 |$31,790.00...