Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Table 1 is monthly sales with four months of no sales in 2014 due to tornado For

ID: 3384490 • 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, each month is a "season" for this problem).

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.802

Explanation / Answer

Table 1 is monthly sales with four months of no sales in 2014 due to tornado For