Problem 4. PepsiCo Quarterly Revenue figures are given for the years 2019-2021 and the first two...

Transcribed Image Text:

Problem 4. PepsiCo Quarterly Revenue figures are given for the years 2019-2021 and the first two quarters of 2022. Their revenue is seasonal and this table provides the revenue in the original seasonal amount and then deseasonalized using a seasonal relative. time t 15 Date 3/31/2019 16 6/30/2019 9/30/2019 12/31/2019 3/31/2020 6/30/2020 9/30/2020 time Revenue Seasonal (Billions) Relative 12.884 16.449 17.188 20.640 13.881 15.945 HNMAS6700 c 1 2 3 4 5 12/31/2020 8 3/31/2021 9 6/30/2021 10 9/30/2021 11 12/31/2021 12 3/31/2022 13 6/30/2022 14 18.091 22.455 14.820 19.217 20.189 25.248 15.538 19.605 Forecast Revenue 0.767 0.951 1.022 1.260 0.767 0.951 1.022 1.260 0.767 0.951 1.022 1.260 0.767 0.951 Use the above data to calculate the forecasted deseasonalized and seasonal revenue for time t = 15 and time t = 16. You will find the M2 Seasonal Demo video in Module 2 extremely helpful in solving this problem. 4.1 Enter the values for t = 15 and 16, up to 3 decimals only. (20 points) De- Seasonalized Seasonal Relative 16.808 17.291 16.811 16.384 18.109 16.761 17.694 17.825 19.334 20.200 19.746 20.042 20.272 20.608 De-seasonalized Forecast Revenue Problem 4. PepsiCo Quarterly Revenue figures are given for the years 2019-2021 and the first two quarters of 2022. Their revenue is seasonal and this table provides the revenue in the original seasonal amount and then deseasonalized using a seasonal relative. time t 15 Date 3/31/2019 16 6/30/2019 9/30/2019 12/31/2019 3/31/2020 6/30/2020 9/30/2020 time Revenue Seasonal (Billions) Relative 12.884 16.449 17.188 20.640 13.881 15.945 HNMAS6700 c 1 2 3 4 5 12/31/2020 8 3/31/2021 9 6/30/2021 10 9/30/2021 11 12/31/2021 12 3/31/2022 13 6/30/2022 14 18.091 22.455 14.820 19.217 20.189 25.248 15.538 19.605 Forecast Revenue 0.767 0.951 1.022 1.260 0.767 0.951 1.022 1.260 0.767 0.951 1.022 1.260 0.767 0.951 Use the above data to calculate the forecasted deseasonalized and seasonal revenue for time t = 15 and time t = 16. You will find the M2 Seasonal Demo video in Module 2 extremely helpful in solving this problem. 4.1 Enter the values for t = 15 and 16, up to 3 decimals only. (20 points) De- Seasonalized Seasonal Relative 16.808 17.291 16.811 16.384 18.109 16.761 17.694 17.825 19.334 20.200 19.746 20.042 20.272 20.608 De-seasonalized Forecast Revenue