Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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


image

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting Theory

Authors: William R. Scott

7th edition

132984660, 978-0132984669

More Books

Students also viewed these General Management questions

Question

Where does the person work?

Answered: 1 week ago