Here are annual revenue data in billions of dollars for the 10-year period 20082017 for two wellknown

Question:

Here are annual revenue data in billions of dollars for the 10-year period 2008–2017 for two wellknown retailers:
Amazon: 19.1; 24.5; 32.4; 48.1; 61.1; 74.5; 89.0; 107.9; 136.0; 177.9.
Walmart: 402.2; 406.1; 420.0; 445.0; 467.2; 474.5; 483.5; 480.0; 482.2; 496.8.

a. For each company, use linear extrapolation in Excel to forecast revenue in the year 2021.

b. Based on these extrapolations, when would Amazon be predicted to equal Walmart in revenue?

c. Why has Amazon been growing faster than Walmart? Is the slow growth of Walmart related to the rapid growth of Amazon?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For book-img-for-question

Managerial Economics And Strategy

ISBN: 9780134899701

3rd Edition

Authors: Jeffrey M. Perloff, James A. Brander

See More Books

Question Posted: Nov 02, 2021 01:19 AM

See More Questions

The data show the traveler spending in billions of dollars for a recent year for a sample of the states. Find the range, variance, and standard deviation for the data. 110.8 30.9 58.4 20.1 33.5 74.8...
The following chart depicts the earnings in billions of dollars for ExxonMobil for the period 2003 until 2014. Write a brief report discussing the earnings at ExxonMobil during the period. Was one...
The following chart depicts the earnings in billions of dollars for ExxonMobil for the period 2005 until 2016. Write a brief report discussing the earnings at ExxonMobil during the period. Was one...
In April 1999, one of Capital Blue Cross' health-care insurance plans had been in the field for three years, but hadn't performed as well as expected. The ratio of premiums to claims payments wasn't...
Give the phase and the missing properties of P, T, v and x.
On December 31, 2010, the Adandt Company listed the following items in its adjusted trial balance: Extraordinary loss (pretax) ...................................................... $ 8,000 Interest...
Explain the importance of viewing selection as a two-way process
The eight general audit procedures produce evidence about the principal management assertions in financial statements. However, some procedures are useful for producing evidence about certain...
Treasury stock that had been purchased for $4,566 last month was reissued this month for $5,184. What would the journal entry to record the reissuance include? Select the correct answer. Credit to...
Crane Company has a December 31 fiscal year end. Selected information follows for Crane Company for three independent situations as at December 31, 2020: 1. Crane purchased a patent from Hopkins Inc....
Which of the following pairs of goods are complements and which are substitutes? Are the goods that are substitutes likely to be perfect substitutes for some or all consumers? a. An e-book version...
Recessions (when consumers incomes fall) strongly affect FedExs revenue, but have less of an effect on Heinzs revenue. Both firms revenues vary seasonally. What regression specifications would you...
Rewrite Exercise 5.8 to display at most two digits after the decimal point for the temperature using the DecimalFormat class. Data from Exercise 5.8 Write a program that prompts the user to enter the...
Question 7 Two objects, of masses 3 and 4 kg, are hung from the ends of a stick that is 70 cm long and has marks every 10 cm, as shown above. If the mass of the stick is negligible, at which of the...
Since they do not have enough saved, Rachel and John would like to consider retiring later. Create a new timeline and recalculate all of the relevant values to determine at what age Rachel and John...
Problem 6 Find the partial derivative with respect to x for the following functions: (a) p = 56 (b) y(x)=56-4x (c) m = r (d) q= x (e) f(x) =x3 (f) g(x,y) = xy 2 (g) h(x,y) = Ax1/2y1/2, where A is a...
Consider the information in the file named Cost Functions of the Firm (also presented above). Please read that file carefully before answering this and the following questions. The fixed cost of...
On January 1, 2022, Monica Company acquired 80 percent of Young Company's outstanding common stock for $872,000. The fair value of the noncontrolling interest at the acquisition date was $218,000....
On July 1, 2016, Steelman Company acquired a new machine for $140,000 and estimated it would have a useful life of 10 years and residual value of $7,000. At the beginning of 2019, the company decided...
C- Consider the following scenario:- A supermarket needs to develop the following software to encourage regular customers. For this, the customer needs to supply his/her residence address, telephone...
Given that the U. S. supply of frozen orange juice comes mainly from Florida and Brazil, what effect would a freeze that damages oranges in Florida have on the price and quantity of frozen orange...
The major BP oil spill in the Gulf of Mexico substantially reduced the harvest of shrimp and other seafood in the Gulf, but had limited impact on the prices that U. S. consumers paid in 2010...
Increasingly, instead of advertising in newspapers, individuals and firms use Web sites that offer free or inexpensive classified ads, such as ClassifiedAds.com, Craigslist.org, Realtor.com,...
DISCUSSION ACTIVITY All jurisdictions have legislation protecting seniority and benefits for qualified employees who are members of the Canadian Forces Reserves and who are deployed for active...
Firm J has net income of $90,160, sales of $980,000, and average total assets of $490,000. Firm J has net income of $90,160, sales of $980,000, and average total assets of $490,000. Required:...
Read Chapter 5 and the Tyco case and identify some of the signals of the misuse of acquisitions or merger reserves. How could these signals have helped the users of Tyco's financial statements...

Here are annual revenue data in billions of dollars for the 10-year period 20082017 for two wellknown

Question:

Step by Step Answer:

a To use linear extrapolation in Excel to forecast revenue in the year 2021 one would need to create ...View the full answer

Managerial Economics And Strategy

Students also viewed these Business questions