Problem 4. PepsiCo Quarterly Revenue figures are given for the years 2019-2021 and the first two...
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
Related Book For
Posted Date:
Students also viewed these general management questions
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Requirements Calculate the net undiscounted and discount cash flows that you would use in the impairment tests. Explain why the discount rate used to calculate discounted cash flows is appropriate...
-
You are developing an industrial building with a gross building area of 150,000 sf. The building efficiency ratio is 75%. The market gross rent is $25 psf. The vacancy rate is 5%; the cap rate is 5%;...
-
1. Briefly describe an organization with which you are familiar. Describe a situation when a manager in that organization could use cost behavior information and how the manager could use the...
-
From the tenth floor of her office building, Katherine Rally watches the swarms of New Yorkers fight their way through the streets infested with yellow cabs and the sidewalks littered with hot dog...
-
Relate multiplicity, aggregation, and generalization to designing user interface classes. Provide examples.
-
IPort Products makes cases for portable music players in two processes, cutting and sewing. The cutting process has a capacity of 100,000 units per year; sewing has a capacity of 120,000 units per...
-
Required information Problem 1-35A (Static) Recording events in a horizontal statements model LO 1-3, 1-4, 1-5, 1-6, 1-7, 1-8, 1-9, 1-10 [The following information applies to the questions displayed...
-
Details of a company's insurance policy are shown below: Premium for year ended 31 March 2008 paid April 2007 Premium for year ending 31 March 2009 paid April 2008 $25,920 $28,800 What figures should...
-
The local authority of a small town maintains a theatre and arts centre for the use of a local repertory company , other visiting groups and exhibitions .Management decisions are taken by a committee...
-
Search the Internet and find examples of three new sports products recently introduced in the marketplace.
-
Find three Internet sites of professional athletes in any sport. In what stage of the product life cycle are these athletes? Support with evidence found on the Internet.
-
Find any advertisement for a sports product. Then describe and explain each of the elements in the communications process for that ad. Do the same (i.e., explain the communications process) for the...
-
Evaluate the promotional mix used for the marketing of any intercollegiate womens sport at your university. Do you believe the proper blend of promotional tools are being used? What could be done to...
-
Locate advertisements for three different sports products. Comment on which response in the hierarchy of effects you believe each advertisement is trying to elicit from its target audience.
-
Prepare a case brief of California v. Hodari, 499 U.S. 621 (1991). The case brief should include the following information: 1) case citation, 2) statement of facts, 3) procedural history, 4)...
-
Chloroplasts are illuminated until the levels of the Calvin cycle intermediates reach a steady state. The light is then turned off. How does the level of RuBP vary after this point?
-
Young and Yang ( 2011) examined managers stock repurchase decisions, under which firms buy back outstanding shares on the market, for a sample of U. K. companies during 1998 2006. As the authors...
-
An economist suggests that the best measure of a firms income is the change in the market value of that firms shares over the period (adjusted for capital transactions). Furthermore, he argues, such...
-
A number of firms, such as BCE Inc., Coca Cola, and McDonalds, have discontinued their practice of issuing quarterly earnings forecasts, thereby lowering their disclosure quality. Often, a reason...
-
(a) Calculate to lowest order the decay rate \(h ightarrow b \bar{b}\). (b) Calculate the decay rate for \(h ightarrow g g\). (Hint: This problem requires a one-loop calculation and some care and...
-
Recall that Programming Exercise 5 in Chapter 8 asked you to design a program that asks the user to enter a charge account number. The program should determine whether the number is valid by...
-
Jay believes the Commerce Clause enhances the governments power to regulate business, but Ellie believes the Commerce Clause restricts the governments power in this regard. How could both be correct...
Study smarter with the SolutionInn App