Answer Happy

The following data report total, monthly, U.S. grocery store sales in millions of dollars from January 2017 to December 2018. (On the site https://www.census.gov/retail/index.html#mrts, find "Monthly Retail Trade Report," then select "Time Series/Trend Charts" to find the data for many retail sectors of the economy.) Year Month ($ Sales millions) $ 52,256 48,835 2017 Jan 2017 Feb 2017 Mar 53,811 2017 Apr 53,012 2017 May 54,979 2017 Jun 53,441 2017 Jul 54,359 2017 Aug 54,269 2017 Sep 53,365 2017 Oct 53,796 2017 Nov 54,691 2017 Dec 58,347 2018 Jan 54,336 2018 Feb 50,547 2018 Mar 56,955 2018 Apr 53,336 2018 May 57,535 2018 Jun 55,749 2018 Jul 56,372 2018 Aug 56,673 2018 Sep 54,568 2018 Oct 55,730 2018 Nov 56,307 2018 Dec 58,769
d. Evaluate a seasonally adjusted trend forecasting model. What is the MAD? (Round your answers to 3 decimal places.) Period Month-Year Month Sales ($ Million) Trend Index Forecast Absolute Error 1 1 2 2 3 3 4 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Jan-2017 Feb-2017 Mar-2017 Apr-2017 May-2017 Jun-2017 Jul-2017 Aug-2017 Sep-2017 Oct-2017 Nov-2017 Dec-2017 Jan-2018 Feb-2018 Mar-2018 Apr-2018 May-2018 Jun-2018 Jul-2018 Aug-2018 Sep-2018 Oct-2018 Nov-2018 Dec-2018 52,256 48,835 53,811 53,012 54,979 53,441 54,359 54,269 53,365 53,796 54,691 58,347 54,336 50,547 56,955 53,336 57,535 55,749 56,372 56,673 54,568 55,730 56,307 58,769 MAD
e. What are the monthly indexes? (Round your answers to 3 decimal places.) Month Index 1 2 3₂ 4 5 6 7 00 8 9 10 11 12
f. Forecast sales for January, February, March, and April of 2019. (Round your answers to 3 decimal places.) Forecasted Slaes Period 25 Sales million Period 26 Sales million Period 27 Sales million Period 28 Sales million