Answer Happy

The following data report total, monthly U.S. gasoline sales in millions of dollars from January 2017 to December 2018. (To find the data. go to the site https://www.census.gov/retail/index.html#mrts, find "Monthly Retail Trade Report." then select "Time Series/Trend Charts.") Year 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Sales (8 millions) $34,530 32,872 37,522 37,873 39,639 38,989 38,697 40, 117 48,246 42,617 39,086 38,946 38,123 36,277 41,548 42,999 46,949 46,446 46,891 47,733 44,485 47,242 42,139 38,526

d. Evaluate a seasonally adjusted trend forecasting model. What is the MAD? (Round your answers to 3 decimal places.) Period Month-Year Month Trend Index Sales (s Million) 34,530 Forecast Absolute Error 1 1 Jan-2017 Feb-2017 2 2 3 Mar-2017 3 4 32,872 37.522 37.873 39,839 38,909 5 5 6 6 7 Apr-2017 May-2017 Jun-2017 Jul-2017 Aug-2017 Sep-2017 Oct-2017 7 8 8 9 10 10 38,697 40.117 40,248 40,617 39,088 38.948 38,123 38,277 11 11 12 12 Nov-2017 Dec-2017 Jan-2018 Feb-2018 13 1 14 2 15 3 16 4 Mar-2018 Apr-2018 May-2018 Jun-2018 17 5 18 6 19 7 41,548 42,009 48,949 46.446 46,891 47.733 44.485 47,242 42,139 38,528 20 8 Jul-2018 Aug-2018 Sep-2018 Oct-2018 21 9 SNNS 22 10 23 Nov-2018 11 24 Dec-2018 12 MADE

e. What are the monthly indexes? (Round your answers to 3 decimal places.) Month Index 1 2 3 4 5 6 7 8 9 10 11 12 t. Forecast sales for January, February, March, and April of 2019. (Round your answers to 2 decimal places.) Forecasted Slaes Period 25 Sales Period 28 Sales Period 27 Sales Period 28 Sales million million million million