Table 1 is monthly sales with four months of no sales in 2014 due to tornado For
ID: 2709314 • Letter: T
Question
Table 1 is monthly sales with four months of no sales in 2014 due to tornado
Forecast the sales that would have occurred at our store had there been no tornado (in excel, seasonality with trend)
Year Month 2010 2011 2012 2013 2014 Jan 2.019 2.346 3.142 3.579 Feb 2.107 2.799 3.184 3.614 Mar 2.478 2.912 3.973 4.426 April 3.040 3.204 3.754 4.148 May 3.448 3.226 4.471 4.303 June 3.345 3.975 4.407 5.008 July 4.251 5.141 4.665 5.493 Aug 3.555 3.885 4.611 5.393 Sept 3.274 3.817 3.526 4.010 Oct 2.528 2.694 3.149 4.217 Nov 2.752 2.635 2.624 3.283 Dec 2.642 2.744 2.715 2.802Explanation / Answer
Year Month 2010 2010 Trend 2011 2011 trend 2012 2012 trend 2013 2013 trend 2014 2014 trend Jan 2.019 2.346 3.142 3.579 Feb 2.107 4.36% 2.799 19.31% 3.184 1.34% 3.614 0.98% Mar 2.478 17.61% 2.912 4.04% 3.973 24.78% 4.426 22.47% April 3.04 22.68% 3.204 10.03% 3.754 -5.51% 4.148 -6.28% May 3.448 13.42% 3.226 0.69% 4.471 19.10% 4.303 3.74% June 3.345 -2.99% 3.975 23.22% 4.407 -1.43% 5.008 16.38% July 4.251 27.09% 5.141 29.33% 4.665 5.85% 5.493 9.68% Aug 3.555 -16.37% 3.885 -24.43% 4.611 -1.16% 5.393 -1.82% Sept 3.274 3.817 7.37% 3.526 -9.24% 4.01 -13.03% 4.5317379 -15.97% -0.86126 Oct 2.528 -22.79% 2.694 -29.42% 3.149 -10.69% 4.217 5.16% 4.9985069 10.30% 0.466769 Nov 2.752 8.86% 2.635 -2.19% 2.624 -16.67% 3.283 -22.15% 3.64891004 -27.00% -1.3496 Dec 2.642 -4.00% 2.744 4.14% 2.715 3.47% 2.802 -14.65% 3.33875269 -8.50% -0.31016
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.