3. (6 pts) Your team has been tasked to develop a seasonal index for use forecasting your company's energy use. A 12-month moving average and centered trend have already been calculated. Your assignment is to complete the work. Mont Energy Center Year 1 Use ed 2015 Jan 134.3 a. Use a multiplicative decomposition model to calculate average (adjusted) Feb 115.7 monthly seasonal factors la seasonal index). // Thuis is Aliwy 0377 Mar 96.6 one meteoeckler: =0.999977 Apr 88.1 May 98.1 Jun 112.1 b. Use the seasonal index to comment on the seasonality of energy use 110.3 106.8 throughout a typical year. Aug 100.4 106.5 Sep 87.8 106.3 Oct 91.6 106.2 Nov 115.2 106.2 c. Explain the meaning of your seasonal index value for December. Dec 132.2 106.2 2016 Jan 131.8 106.3 Feb 112.1 106.4 Mar 95.7 106.4 Apr 87.2 106.4 May 98.3 106.3 Jun 112.5 105.9 Jul 111.8 105.0 Aug 101.3 104.2 Sep 87.2 103.9 Oct 90.4 103.9 Nov 114.8 103.8 Dec 123.8 103.8 2017 Jan 118.1 103.8 Feb 106 103.7 Mar 95103.7 Apr 86.9 103.7 May 97.9 103.8 Jun 112.4 104.5 Jul 111.3 106.1 Aug 100.7 107.8 Sep 87.3 108.7 Oot 90.5 108.7 Nov 115.9 108.7 Dec 140.6 108.7 2018 Jan 139.8 108.7 Feb 124.6 108.7 Mar 96.8 108.7 Apr 85.8 108.7 May 99.2 108.6 Jun 111.4 108.1 112.4 Aug 99.3 Sep 88.3 Oct 89.4 Nov 116.3 Dec 127.7