(All Steps) An analyst wants to use the ratio-to-moving-average method to forecast a company's sales for the next few quarters. Beginning in Quarter 4 of
Question: An analyst wants to use the ratio-to-moving-average method to forecast a company's sales for the next few quarters. Beginning in Quarter 4 of 2006 , the analyst collects the following sales data (in millions of dollars).
Estimate the seasonal index associated with Quarter 4 . Round your answer to at least three decimal places.
| Data for excel 1 | 4 | 123.2 | |
| 2 | 1 | 209.9 | |
| 143.4 | |||
| 3 | 2 | 141.3 | |
| 136.25 | |||
| 4 | 3 | 99.2 | |
| 140.35 | |||
| 5 | 4 | 94.6 | |
| 143.7 | |||
| 6 | 1 | 226.3 | |
| 149.15 | |||
| 7 | 2 | 154.7 | |
| 154.225 | |||
| 8 | 3 | 121 | |
| 150.075 | |||
| 9 | 4 | 114.9 | |
| 144.625 | |||
| 10 | 1 | 209.7 | |
| 144.8 | |||
| 11 | 2 | 132.9 | |
| 12 | 3 | 121.7 | |
Price: $2.99
Solution: The downloadable solution consists of 2 pages
Deliverable: Word Document 