See below supported excel file.

Please explain in detail step by step and the formulas used.

Q3. As people were spending more time at home during the pandemic and gyms were closed, there was an increase in demand for home gyms. You developed a home gym package to sell to customers (including dumbells, a bench, a yoga mat, and skipping rope - all included in the package). Your company wants to forecast future sales of the gym kits. See file Q3 data file. Required: Please do the following: Construct a financial model using the data from the file you are given a. Create a scatter plot b. Perform a moving average forecast for at least three time intervals c. Perform an exponential smoothing forecast d. Optimize the exponential smoothing e. Calculate and evaluate the MAPE for all forecasts. 1 Home Gym 2 3 Period 4 January 1, 2018 5 February 1, 2018 6 March 1, 2018 April 1, 2018 7 8 May 1, 2018 9 June 1, 2018 10 July 1, 2018 11 August 1, 2018 12 September 1, 2018 13 October 1, 2018 14 November 1, 2018 15 December 1, 2018 16 January 1, 2019 17 February 1, 2019 18 March 1, 2019 19 April 1, 2019 20 May 1, 2019 21 June 1, 2019 22 July 1, 2019 23 August 1, 2019 24 September 1, 2019 25 October 1, 2019 26 November 1, 2019 27 December 1, 2019 28 January 1, 2020 29 February 1, 2020 30 March 1, 2020 31 April 1, 2020 32 May 1, 2020 33 June 1, 2020 34 July 1, 2020 35 August 1, 2020 36 September 1, 2020 37 October 1, 2020 38 November 1, 2020 39 December 1, 2020 40 January 1, 2021 41 February 1, 2021 42 March 1, 2021 43 April 1, 2021 44 May 1, 2021 45 June 1, 2021 n = 89 141 148 143 140 138 131 120 124 123 154 139 125 119 122 134 141 133 144 147 151 145 144 143 138 159 150 145 141 154 134 146 186 143 129 140 161 161 131 138 147 150 170 46 July 1, 2021 47 August 1, 2021 48 September 1, 2021 49 October 1, 2021 50 November 1, 2021 51 December 1, 2021 52 January 1, 2022 53 February 1, 2022 54 March 1, 2022 55 April 1, 2022 56 May 1, 2022 57 June 1, 2022 58 July 1, 2022 59 August 1, 2022 60 September 1, 2022 61 October 1, 2022 62 November 1, 2022 63 December 1, 2022 64 January 1, 2023 65 February 1, 2023 66 March 1, 2023 67 April 1, 2023 68 May 1, 2023 69 June 1, 2023 70 July 1, 2023 71 August 1, 2023 72 September 1, 2023 73 October 1, 2023 74 November 1, 2023 75 December 1, 2023 76 January 1, 2024 77 February 1, 2024 78 March 1, 2024 79 April 1, 2024 80 May 1, 2024 81 June 1, 2024 82 July 1, 2024 83 August 1, 2024 84 September 1, 2024 85 October 1, 2024 86 November 1, 2024 165 151 142 146 179 170 179 200 191 164 160 186 173 162 188 172 174 199 165 176 162 182 188 184 184 198 171 202 191 161 159 179 181 152 163 161 182 154 176 171 162 87 December 1, 2024 88 January 1, 2025 89 February 1, 2025 90 March 1, 2025 91 April 1, 2025 92 May 1, 2025 187 186 181 205 189 199 Q3. As people were spending more time at home during the pandemic and gyms were closed, there was an increase in demand for home gyms. You developed a home gym package to sell to customers (including dumbells, a bench, a yoga mat, and skipping rope - all included in the package). Your company wants to forecast future sales of the gym kits. See file Q3 data file. Required: Please do the following: Construct a financial model using the data from the file you are given a. Create a scatter plot b. Perform a moving average forecast for at least three time intervals c. Perform an exponential smoothing forecast d. Optimize the exponential smoothing e. Calculate and evaluate the MAPE for all forecasts. 1 Home Gym 2 3 Period 4 January 1, 2018 5 February 1, 2018 6 March 1, 2018 April 1, 2018 7 8 May 1, 2018 9 June 1, 2018 10 July 1, 2018 11 August 1, 2018 12 September 1, 2018 13 October 1, 2018 14 November 1, 2018 15 December 1, 2018 16 January 1, 2019 17 February 1, 2019 18 March 1, 2019 19 April 1, 2019 20 May 1, 2019 21 June 1, 2019 22 July 1, 2019 23 August 1, 2019 24 September 1, 2019 25 October 1, 2019 26 November 1, 2019 27 December 1, 2019 28 January 1, 2020 29 February 1, 2020 30 March 1, 2020 31 April 1, 2020 32 May 1, 2020 33 June 1, 2020 34 July 1, 2020 35 August 1, 2020 36 September 1, 2020 37 October 1, 2020 38 November 1, 2020 39 December 1, 2020 40 January 1, 2021 41 February 1, 2021 42 March 1, 2021 43 April 1, 2021 44 May 1, 2021 45 June 1, 2021 n = 89 141 148 143 140 138 131 120 124 123 154 139 125 119 122 134 141 133 144 147 151 145 144 143 138 159 150 145 141 154 134 146 186 143 129 140 161 161 131 138 147 150 170 46 July 1, 2021 47 August 1, 2021 48 September 1, 2021 49 October 1, 2021 50 November 1, 2021 51 December 1, 2021 52 January 1, 2022 53 February 1, 2022 54 March 1, 2022 55 April 1, 2022 56 May 1, 2022 57 June 1, 2022 58 July 1, 2022 59 August 1, 2022 60 September 1, 2022 61 October 1, 2022 62 November 1, 2022 63 December 1, 2022 64 January 1, 2023 65 February 1, 2023 66 March 1, 2023 67 April 1, 2023 68 May 1, 2023 69 June 1, 2023 70 July 1, 2023 71 August 1, 2023 72 September 1, 2023 73 October 1, 2023 74 November 1, 2023 75 December 1, 2023 76 January 1, 2024 77 February 1, 2024 78 March 1, 2024 79 April 1, 2024 80 May 1, 2024 81 June 1, 2024 82 July 1, 2024 83 August 1, 2024 84 September 1, 2024 85 October 1, 2024 86 November 1, 2024 165 151 142 146 179 170 179 200 191 164 160 186 173 162 188 172 174 199 165 176 162 182 188 184 184 198 171 202 191 161 159 179 181 152 163 161 182 154 176 171 162 87 December 1, 2024 88 January 1, 2025 89 February 1, 2025 90 March 1, 2025 91 April 1, 2025 92 May 1, 2025 187 186 181 205 189 199