(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

log in to your account

Don't have a membership account?
REGISTER

reset password

Back to
log in

sign up

Back to
log in