Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the data on Walmart sales available in Walmart_2.xlsx Download Walmart_2.xlsx. Plot the quarterly sales data and verify that the series exhibits a seasonal element.

Consider the data on Walmart sales available in Walmart_2.xlsx Download Walmart_2.xlsx. Plot the quarterly sales data and verify that the series exhibits a seasonal element. Using the ESM contrast the additive seasonal, multiplicative seasonal, and logarithmic forms for forecasting sales, using the last 12 quarters as a hold-out sample.

Year Walmart Stores Super Stores Sam's Club Year Quarter Sales ($ billion)
1995 2176 154 453 2003 1 56.7
1996 2218 255 470 2003 2 62.6
1997 1960 344 436 2003 3 62.5
1998 1921 441 443 2003 4 74.5
1999 1860 564 451 2004 1 64.8
2000 1801 721 463 2004 2 69.7
2001 1736 888 475 2004 3 68.5
2002 1647 1066 500 2004 4 82.2
2003 1568 1258 525 2005 1 70.0
2004 1478 1471 538 2005 2 75.9
2005 1353 1713 551 2005 3 74.6
2006 1209 1980 567 2005 4 88.4
2007 1075 2256 579 2006 1 78.8
2008 971 2447 591 2006 2 84.5
2009 891 2612 602 2006 3 83.5
2010 708 2907 609 2006 4 98.1
2011 629 3029 611 2007 1 85.4
2012 561 3158 620 2007 2 92.0
2013 508 3288 632 2007 3 90.9
2014 470 3407 647 2007 4 106.3
2015 442 3465 655 2008 1 94.1
2008 2 101.6
2008 3 97.6
2008 4 108.0
2009 1 93.5
2009 2 100.1
2009 3 98.7
2009 4 112.8
2010 1 99.1
2010 2 103
2010 3 101.2
2010 4 115.6
2011 1 103.4
2011 2 108.6
2011 3 109.5
2011 4 122.3
2012 1 112.3
2012 2 113.5
2012 3 113.2
2012 4 127.1
2013 1 113.3
2013 2 116.1
2013 3 114.9
2013 4 128.8
2014 1 114.2
2014 2 119.3
2014 3 118.1
2014 4 130.7
2015 1 114
2015 2 119.3
2015 3 116.6
2015 4 128.7

Year Quarter Sales ($ billion) GDP L1_GDP L4_GDP L1_Sales L4_Sales
2003 1 56.7 11230.1
2003 2 62.6 11370.7 11230.1 56.7
2003 3 62.5 11625.1 11370.7 62.6
2003 4 74.5 11816.8 11625.1 62.5
2004 1 64.8 11988.4 11816.8 11230.1 74.5 56.7
2004 2 69.7 12181.4 11988.4 11370.7 64.8 62.6
2004 3 68.5 12367.7 12181.4 11625.1 69.7 62.5
2004 4 82.2 12562.2 12367.7 11816.8 68.5 74.5
2005 1 70.0 12813.7 12562.2 11988.4 82.2 64.8
2005 2 75.9 12974.1 12813.7 12181.4 70.0 69.7
2005 3 74.6 13205.4 12974.1 12367.7 75.9 68.5
2005 4 88.4 13381.6 13205.4 12562.2 74.6 82.2
2006 1 78.8 13648.9 13381.6 12813.7 88.4 70.0
2006 2 84.5 13799.8 13648.9 12974.1 78.8 75.9
2006 3 83.5 13908.5 13799.8 13205.4 84.5 74.6
2006 4 98.1 14066.4 13908.5 13381.6 83.5 88.4
2007 1 85.4 14233.2 14066.4 13648.9 98.1 78.8
2007 2 92.0 14422.3 14233.2 13799.8 85.4 84.5
2007 3 90.9 14569.7 14422.3 13908.5 92.0 83.5
2007 4 106.3 14685.3 14569.7 14066.4 90.9 98.1
2008 1 94.1 14668.4 14685.3 14233.2 106.3 85.4
2008 2 101.6 14813.0 14668.4 14422.3 94.1 92.0
2008 3 97.6 14843.0 14813.0 14569.7 101.6 90.9
2008 4 108.0 14549.9 14843.0 14685.3 97.6 106.3
2009 1 93.5 14383.9 14549.9 14668.4 108.0 94.1
2009 2 100.1 14340.4 14383.9 14813.0 93.5 101.6
2009 3 98.7 14384.1 14340.4 14843.0 100.1 97.6
2009 4 112.8 14566.5 14384.1 14549.9 98.7 108.0
2010 1 99.1 14681.1 14566.5 14383.9 112.8 93.5
2010 2 103 14888.6 14681.1 14340.4 99.1 100.1
2010 3 101.2 15057.7 14888.6 14384.1 103.0 98.7
2010 4 115.6 15230.2 15057.7 14566.5 101.2 112.8
2011 1 103.4 15238.4 15230.2 14681.1 115.6 99.1
2011 2 108.6 15460.9 15238.4 14888.6 103.4 103.0
2011 3 109.5 15587.1 15460.9 15057.7 108.6 101.2
2011 4 122.3 15785.3 15587.1 15230.2 109.5 115.6
2012 1 112.3 15973.9 15785.3 15238.4 122.3 103.4
2012 2 113.5 16121.9 15973.9 15460.9 112.3 108.6
2012 3 113.2 16227.9 16121.9 15587.1 113.5 109.5
2012 4 127.1 16297.3 16227.9 15785.3 113.2 122.3
2013 1 113.3 16475.4 16297.3 15973.9 127.1 112.3
2013 2 116.1 16541.4 16475.4 16121.9 113.3 113.5
2013 3 114.9 16749.3 16541.4 16227.9 116.1 113.2
2013 4 128.8 16999.9 16749.3 16297.3 114.9 127.1
2014 1 114.2 17025.2 16999.9 16475.4 128.8 113.3
2014 2 119.3 17285.6 17025.2 16541.4 114.2 116.1
2014 3 118.1 17569.4 17285.6 16749.3 119.3 114.9

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

Operations And Supply Chain Management

Authors: David A. Collier, James R. Evans

2nd Edition

035713169X, 978-0357131695

More Books

Students also viewed these General Management questions

Question

2. Information that comes most readily to mind (availability).

Answered: 1 week ago

Question

3. An initial value (anchoring).

Answered: 1 week ago

Question

4. Similarity (representativeness).

Answered: 1 week ago