Table 1 is monthly sales with four months of no sales in 201
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 |
Solution
