The file Walmart_Raw Data.xlsx contains quarterly revenues of Wal-Mart during the years 1994-2009. Use the Ratio to

Question:

The file Walmart_Raw Data.xlsx contains quarterly revenues of Wal-Mart during the years 1994-2009. Use the Ratio to Moving Average Method to forecast revenues for Quarter 3 and 4 in 2009 and Quarter 1 and 2 in 2010. Use Quarters 53-60 to create a trend estimate that you use in your forecast

Quarter#YearQuarterSales
11994117686000
21994219942315
31994320417717
41994425365968
51995120440000
61995222723000
71995322913000
81995428673000
91996122772000
101996225587000
111996325644000
121996432143000
131997125409000
141997228386000
151997328777000
161997436727000
171998129819000
181998233521000
191998333509000
201998442359000
211999134717000
221999238470000
231999340432000
241999453190000
252000142985000
262000246112000
272000345676000
282000458522000
292001148052000
302001252799000
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  answer-question

Managerial Statistics

ISBN: 9780534389314

1st Edition

Authors: S. Christian Albright, Wayne L. Winston, Christopher Zappe

Question Posted: