Question

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

Answer 1

as Average monthly sale has been already done. and seasonal index also been given. so to calculate per month sale multiply Average sales with Seasonal index.

Year                         Average                      Seasonal Index                                Forecast 2020

                                    a                                     b                                           a x b

Jan                            1055    0.8077                                   852.12

feb                             915    0.7004                                  640.87

mar                       1082 0.8287                                  896.65

apr                            1198          0.9176                                 1099.28

may                           1386                                1.0616                                    1471.38

jun 1440                                1.1025                                    1587.60

jul                              1620    1.2404                                       2009.45

aug                            1616    1.2373                                       1999.48

sep                            1471    1.1267                                   1657.38

oct                             1556                                1.1918                                       1854.44

nov    1260                               0.9651                                       1216.03

dec 1071    0.8203                                   878.54

                                                                  Total                                           16163.22

so forecast sale of 14000 bottles are as above.