An analyst wants to use the ratio-to-moving-average method to forecast a company's sales ...

profileguru2009
 (Not rated)
 (Not rated)
Chat

     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
    Means as percentage of Mean of Means 62.8101 88.5412 ...
    NOT RATED

    Purchase the answer to view it

    blurred-text
    • attachment
      Ananalystwantstousetheratio-to-moving-averagemethod.xls