Submitted by: Submitted by downeys
Views: 402
Words: 583
Pages: 3
Category: Business and Industry
Date Submitted: 05/23/2011 09:47 AM
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...