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 2003, the analyst collects the following sales data(in millions of dollars).
Estimate the seasonal index associated with Quarter 2. Round your answer to at least three decimal places.
Time Period Quarter Sales Moving Average
1 4 142.4
2 1 147.6 145.700
3 2 169.0 139.400
4 3 123.8 145.975
5 4 117.2 146.800
6 1 173.9 147.250
7 2 172.3 153.975
8 3 125.6 154.150
9 4 144.1 161.150
10 1 174.6 167.600
11 2 200.3
12 3 151.4
This posting contains solution to following problem on forecasting using ratio-to-moving average method.