1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 -40 41 42 43 44 45 46 47 48 49 50 -51 Date A Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 B Auber monthly trips (mill) 374 5 374 7 412.5 403 1 418.4 418.2 447.5 443.7 450.4 472.9 452.1 431,3 528.3 532.8 513.3 479.1 500.3 500.3 570.5 625.9 638.9 693.8 683,7 669.2 672.8 691.9 672.8 213.3 201.9 226.7 384.5 371.9 358.7 402 402 411.2 390.8 424 4 404.4 478 441.9 449 582.9 622.9 621.5 581.2 633.1 620.1 Assume today's date is Dec 31, 2021. To answer the following questions. use Date and Auber monthly trips (mill) provided in sheet Auber monthly trips Obtain the seasonal indexes for Jan to Dec based on the past FOUR years (2018-2021) in yellow cells below Obtain the Seasonally Adjusted Actual for Jan 21 to Dec 21 in orange cells below Using only 2021 data and Exponential Smoothing with Trend (a-0.3, 8-0.5), forecast Trips (mill) for Jan 22 in light blue cell below Obtain MSE for 2021 in gray cell below. Using Excers Solver, obtain the optimal parameters (a and B) that minimize MSE for 2021. GENERATE SOLVER'S ANSWER REPORT Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Annual Actual Actual 2018 2019 Actual Actual 2020 2021 Seasonal Index Seasonal y Ad 2021 MSE Forecast 2022 Senter trips forecast (mill) for Jan 22 here enter MSE for 2021 here 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 -40 41 42 43 44 45 46 47 48 49 50 -51 Date A Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 B Auber monthly trips (mill) 374 5 374 7 412.5 403 1 418.4 418.2 447.5 443.7 450.4 472.9 452.1 431,3 528.3 532.8 513.3 479.1 500.3 500.3 570.5 625.9 638.9 693.8 683,7 669.2 672.8 691.9 672.8 213.3 201.9 226.7 384.5 371.9 358.7 402 402 411.2 390.8 424 4 404.4 478 441.9 449 582.9 622.9 621.5 581.2 633.1 620.1 Assume today's date is Dec 31, 2021. To answer the following questions. use Date and Auber monthly trips (mill) provided in sheet Auber monthly trips Obtain the seasonal indexes for Jan to Dec based on the past FOUR years (2018-2021) in yellow cells below Obtain the Seasonally Adjusted Actual for Jan 21 to Dec 21 in orange cells below Using only 2021 data and Exponential Smoothing with Trend (a-0.3, 8-0.5), forecast Trips (mill) for Jan 22 in light blue cell below Obtain MSE for 2021 in gray cell below. Using Excers Solver, obtain the optimal parameters (a and B) that minimize MSE for 2021. GENERATE SOLVER'S ANSWER REPORT Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Annual Actual Actual 2018 2019 Actual Actual 2020 2021 Seasonal Index Seasonal y Ad 2021 MSE Forecast 2022 Senter trips forecast (mill) for Jan 22 here enter MSE for 2021 here
