can someone help explain how to do part J. Create a forecast for each month of 2020? The senior VP of sales has adjusted the forecast down because of the COVID-19 pandemic. She wants you to use the forecast of 14,000 bottles for 2020.

H M While you've calculated the forecast for 2020 in the regression tab, the Senior VP of Sales has adjusted that forecast down because of the COVID-19 pandemic. She wants you to use a forecast of 14,000 bottles for 2020. Calculate the seasonal indices for each month. Create a forecast for each month of 2020. Year Jan Feb Mar Apr May Jun 2018 $1,015 $829 $988 $1,110 $1,289 $1,332 $1,557 $1,589 $1,509 $1,646 $1,402 $1,169 L 2019 Average Seasonal Index Forcast 2020 $1,094 $1,055 0.8077 $1,000 $915 0.7004 $1,176 $1,082 0.8287 $1,286 $1,198 0.9176 $1,483 $1,386 1.0616 $1,547 $1,440 1.1025 $1,682 $1,620 1.2404 $1,642 $1,616 1.2373 $1,433 $1,471 1.1267 $1,466 $1,556 1.1918 $1,118 $1,260 0.9651 $973 $1,071 0.8203 10 1 2 3 4 5 6 7 Aug Sep Oct Nov Dec Total Average $15,435 $15,900 $1,306 The forecast equation is: Forecast = 1100.6(Year) -2,205,939 h) Create a regression forecast for the YEAR 2020 Slope - Intercept 1100.6 -2205939 Forcast 2020 $17,273