An analyst wants to use the ratio-to-moving-average method to forecast a company's sales ...
An analyst wants to use the ratio-to-moving-average method to forecast a company's sales for the next few months. Beginning in August of 2008 , the analyst collects the following sales data (in millions of dollars). Estimate the seasonal index associated with October. Round your answer to at least three decimal places.
Time Period Month Sales 1 Aug 101.1 2 Sep 127.9 3 Oct 164.3 4 Nov 135.2 5 Dec 183.7 6 Jan 209.1 7 Feb 204.3 8 Mar 140 9 Apr 185.3 10 May 123.4 11 Jun 94.7 12 Jul 90 13 Aug 96.1 14 Sep 135.3 15 Oct 166.8 16 Nov 135.1 17 Dec 191.4 18 Jan 184.8 19 Feb 213.9 20 Mar 134.9 21 Apr 147.5 22 May 138.5 23 Jun 111.4 24 Jul 128.8 25 Aug 87.4 26 Sep 125.2 27 Oct 177.9 28 Nov 125.3 29 Dec 179.5 30 Jan 215.8 31 Feb 224 32 Mar 172.5 33 Apr 190.7 34 May 150.8 35 Jun 107.7 36 Jul 149.7
8 years ago
Purchase the answer to view it

- Ananalystwantstousetheratio-to-moving-averagemethod.xls