I have attached my time series forecasting assignment that I am having a little difficulty answering. Please include answers on the blocks provided on the page
Untitled Spreadsheet Instructions MGSC 778 Time Series Forecasting Assignment Instructions: 1. Forecast the weekly demand for Sep 2nd - Sep 30th, 2018. Use any forecasting method that you like. Your forecast will be measured against the actual data of this time period. The criteria for evaluation is the sum of the absolute errors, the cumulative size of your CIs and the number of times the actual demand falls outside of your Confidence Intervals x 30,000,000. You can choose any confidence interval that you like, balancing the trade-off of having confidence intervals that are too wide versus the probability of a data point falling outside of them. 2. Include your answers on this page in the blocks provided. The specifics of your solution may be saved as separate worksheets on this spreadsheet. Place your forecast and CIs in the yellow blocks below. 3. Name your file using the following format: TimeSeriesProjectLast name of each team member.xlsx. Also, please fill out the main results in the appropriate boxes on this spreadsheet. My Triple Exp Smoothing ResultsIs Demand outside CI? PeriodActualForecastErrorABS(Error)Low x% CIHigh x% CIGap1=Y 0=N 2-Sep-18?ERROR:#VALUE!ERROR:#VALUE!- 01 9-Sep-18?ERROR:#VALUE!ERROR:#VALUE!- 01 16-Sep-18?ERROR:#VALUE!ERROR:#VALUE!- 01 23-Sep-18?ERROR:#VALUE!ERROR:#VALUE!- 01 30-Sep-18?ERROR:#VALUE!ERROR:#VALUE!- 01 TotalsERROR:#VALUE!- 05 Total Absolute ErrorERROR:#VALUE! Total CI Gap- 010000 Number of times outside CI * 30,000,000150000000 Total ScoreERROR:#VALUE! Grade: Your grade will be based on the total score above on a relative basis compared to the total scores of the other teams. Actual vs. Forecast Actuals433454335243359433664337300000Forecasts4334543352433594336643373 Units Sold Put your names here Raw Data DateTotal Volume 26-Aug-1836,867,975 19-Aug-1840,735,733 12-Aug-1840,901,950 5-Aug-1839,427,667 29-Jul-1840,512,782 22-Jul-1841,906,917 15-Jul-1843,126,773 8-Jul-1847,848,190 1-Jul-1845,572,739 24-Jun-1844,742,750 17-Jun-1844,009,085 10-Jun-1845,613,372 3-Jun-1844,705,039 27-May-1847,105,314 20-May-1844,458,798 13-May-1846,371,246 6-May-1863,716,144 29-Apr-1843,856,759 22-Apr-1844,313,979 15-Apr-1847,098,678 8-Apr-1842,964,068 1-Apr-1841,109,689 25-Mar-1843,409,836 18-Mar-1841,386,314 11-Mar-1840,449,603 4-Mar-1840,741,214 25-Feb-1840,021,529 18-Feb-1836,709,887 11-Feb-1843,167,806 4-Feb-1862,505,647 28-Jan-1840,171,641 21-Jan-1842,939,822 14-Jan-1837,299,945 7-Jan-1836,703,157 31-Dec-1738,267,342 24-Dec-1729,102,349 17-Dec-1730,757,767 10-Dec-1735,634,913 3-Dec-1733,824,253 26-Nov-1724,686,675 19-Nov-1729,253,484 12-Nov-1732,336,225 5-Nov-1732,051,594 29-Oct-1730,237,911 22-Oct-1726,706,972 15-Oct-1725,031,589 8-Oct-1724,397,166 1-Oct-1724,610,645 24-Sep-1724,637,148 17-Sep-1725,394,903 10-Sep-1726,385,081 3-Sep-1726,808,411 27-Aug-1728,785,280 20-Aug-1729,913,744 13-Aug-1732,817,254 6-Aug-1732,529,920 30-Jul-1731,756,097 23-Jul-1732,608,302 16-Jul-1732,455,047 9-Jul-1739,367,336 2-Jul-1738,010,426 25-Jun-1737,305,308 18-Jun-1738,247,669 11-Jun-1737,039,854 4-Jun-1737,352,361 28-May-1737,030,894 21-May-1734,397,651 14-May-1736,634,269 7-May-1747,293,922 30-Apr-1738,315,500 23-Apr-1735,729,014 16-Apr-1735,182,321 9-Apr-1734,785,713 2-Apr-1734,468,017 26-Mar-1732,555,119 19-Mar-1731,595,125 12-Mar-1732,020,574 5-Mar-1733,684,175 26-Feb-1737,007,798 19-Feb-1733,905,855 12-Feb-1741,077,471 5-Feb-1761,034,457 29-Jan-1739,373,579 22-Jan-1742,140,393 15-Jan-1738,295,488 8-Jan-1738,049,803 1-Jan-1738,879,717 25-Dec-1630,287,854 18-Dec-1629,583,883 11-Dec-1630,093,541 4-Dec-1631,621,222 27-Nov-1622,923,063 20-Nov-1624,989,703 13-Nov-1624,075,126 6-Nov-1622,534,698 30-Oct-1621,009,730 23-Oct-1624,753,514 16-Oct-1627,707,047 9-Oct-1628,857,582 2-Oct-1629,615,008 25-Sep-1630,305,113 18-Sep-1631,346,091 11-Sep-1634,126,731 4-Sep-1637,130,689 28-Aug-1633,993,931 21-Aug-1633,592,098 14-Aug-1634,386,177 7-Aug-1633,819,909 31-Jul-1631,201,590 24-Jul-1632,339,377 17-Jul-1632,656,124 10-Jul-1635,567,568 3-Jul-1639,993,186 26-Jun-1636,617,024 19-Jun-1638,489,936 12-Jun-1635,580,820 5-Jun-1640,231,260 29-May-1640,019,075 22-May-1636,958,036 15-May-1639,914,997 8-May-1646,324,530 1-May-1642,867,609 24-Apr-1639,607,695 17-Apr-1637,467,885 10-Apr-1636,584,029 3-Apr-1633,668,451 27-Mar-1635,930,196 20-Mar-1636,335,484 13-Mar-1636,374,516 6-Mar-1635,064,506 28-Feb-1636,801,818 21-Feb-1632,804,733 14-Feb-1636,476,442 7-Feb-1652,288,698 31-Jan-1634,721,250 24-Jan-1632,787,079 17-Jan-1634,426,342 10-Jan-1635,264,336 3-Jan-1638,142,088 27-Dec-1527,297,984 20-Dec-1525,083,647 13-Dec-1528,041,335 6-Dec-1528,800,397 Units Sold Per Week Total Volume433384333143324433174331043303432964328943282432754326843261432544324743240432334322643219432124320543198431914318443177431704316343156431494314243135431284312143114431074310043093430864307943072430654305843051430444303743030430234301643009430024299542988429814297442967429604295342946429394293242925429184291142904428974289042883428764286942862428554284842841428344282742820428134280642799427924278542778427714276442757427504274342736427294272242715427084270142694426874268042673426664265942652426454263842631426244261742610426034259642589425824257542568425614255442547425404253342526425194251242505424984249142484424774247042463424564244942442424354242842421424144240742400423934238642379423724236542358423514234436867974.57999999840735732.6840901950.00999999839427666.53999999940512782.18999999841906916.84000000443126773.21999999947848189.78999999945572739.17000000244742749.88000000344009084.78000000145613372.42000000244705039.04999999747105314.28000000144458798.29999999746371245.84000000463716144.14999999943856758.99000000244313979.29999999747098677.6842964067.6841109688.71999999943409835.7541386314.11999999740449603.11999999740741214.04999999740021528.75999999836709887.49000000243167806.09000000462505646.52000000340171640.84000000442939821.54999999737299945.21999999936703156.71999999938267341.60999999929102349.32999999830757767.03000000135634913.0099999983382425324686675292534843233622532051594.23999999830237911.2326706971.51000000225031589.0924397166.19000000124610645.21000000124637148.37999999925394902.8226385081.35999999926808410.64999999928785279.7529913744.37000000132817254.12999999932529920.2331756097.21999999932608301.51000000232455047.10999999939367336.1838010426.15999999637305307.6838247669.32999999837039853.79999999737352360.59000000437030893.72999999734397651.14999999936634269.03000000147293921.60000000138315500.4335729013.92000000235182320.78000000134785712.54999999734468017.35999999932555119.3231595125.2332020573.94000000133684175.00999999837007797.68999999833905854.57999999841077470.64999999961034457.10000000139373579.2542140393.39000000138295488.31000000238049802.61999999738879716.85000000130287853.69999999929583882.60999999930093540.69999999931621221.89999999922923062.64999999924989702.7524075126.48999999822534698.37999999921009730.21000000124753513.94999999927707046.8228857581.9829615008.48999999830305112.89000000131346091.46000000134126730.95000000337130688.90999999633993931.31000000233592097.71999999934386177.29999999733819909.09000000431201590.21999999932339377.0932656123.62999999935567568.4339993186.03999999936617023.78999999938489936.1400000013558082040231259.64999999940019075.24000000236958035.50999999839914996.74000000246324529.70000000342867608.53999999939607695.29999999737467885.18999999836584029.39000000133668450.54999999735930195.92000000236335483.78000000136374516.14000000135064506.03999999936801817.6832804733.21999999936476441.85999999952288697.89000000134721249.92000000232787079.21000000134426341.86999999735264336.00999999838142088.03999999927297983.67000000225083647.17000000228041335.37999999928800396.57Week Volume Sold Time Series DateTotal Volume 6-Dec-1528,800,397 13-Dec-1528,041,335 20-Dec-1525,083,647 27-Dec-1527,297,984 3-Jan-1638,142,088 10-Jan-1635,264,336 17-Jan-1634,426,342 24-Jan-1632,787,079 31-Jan-1634,721,250 7-Feb-1652,288,698 14-Feb-1636,476,442 21-Feb-1632,804,733 28-Feb-1636,801,818 6-Mar-1635,064,506 13-Mar-1636,374,516 20-Mar-1636,335,484 27-Mar-1635,930,196 3-Apr-1633,668,451 10-Apr-1636,584,029 17-Apr-1637,467,885 24-Apr-1639,607,695 1-May-1642,867,609 8-May-1646,324,530 15-May-1639,914,997 22-May-1636,958,036 29-May-1640,019,075 5-Jun-1640,231,260 12-Jun-1635,580,820 19-Jun-1638,489,936 26-Jun-1636,617,024 3-Jul-1639,993,186 10-Jul-1635,567,568 17-Jul-1632,656,124 24-Jul-1632,339,377 31-Jul-1631,201,590 7-Aug-1633,819,909 14-Aug-1634,386,177 21-Aug-1633,592,098 28-Aug-1633,993,931 4-Sep-1637,130,689 11-Sep-1634,126,731 18-Sep-1631,346,091 25-Sep-1630,305,113 2-Oct-1629,615,008 9-Oct-1628,857,582 16-Oct-1627,707,047 23-Oct-1624,753,514 30-Oct-1621,009,730 6-Nov-1622,534,698 13-Nov-1624,075,126 20-Nov-1624,989,703 27-Nov-1622,923,063 4-Dec-1631,621,222 11-Dec-1630,093,541 18-Dec-1629,583,883 25-Dec-1630,287,854 1-Jan-1738,879,717 8-Jan-1738,049,803 15-Jan-1738,295,488 22-Jan-1742,140,393 29-Jan-1739,373,579 5-Feb-1761,034,457 12-Feb-1741,077,471 19-Feb-1733,905,855 26-Feb-1737,007,798 5-Mar-1733,684,175 12-Mar-1732,020,574 19-Mar-1731,595,125 26-Mar-1732,555,119 2-Apr-1734,468,017 9-Apr-1734,785,713 16-Apr-1735,182,321 23-Apr-1735,729,014 30-Apr-1738,315,500 7-May-1747,293,922 14-May-1736,634,269 21-May-1734,397,651 28-May-1737,030,894 4-Jun-1737,352,361 11-Jun-1737,039,854 18-Jun-1738,247,669 25-Jun-1737,305,308 2-Jul-1738,010,426 9-Jul-1739,367,336 16-Jul-1732,455,047 23-Jul-1732,608,302 30-Jul-1731,756,097 6-Aug-1732,529,920 13-Aug-1732,817,254 20-Aug-1729,913,744 27-Aug-1728,785,280 3-Sep-1726,808,411 10-Sep-1726,385,081 17-Sep-1725,394,903 24-Sep-1724,637,148 1-Oct-1724,610,645 8-Oct-1724,397,166 15-Oct-1725,031,589 22-Oct-1726,706,972 29-Oct-1730,237,911 5-Nov-1732,051,594 12-Nov-1732,336,225 19-Nov-1729,253,484 26-Nov-1724,686,675 3-Dec-1733,824,253 10-Dec-1735,634,913 17-Dec-1730,757,767 24-Dec-1729,102,349 31-Dec-1738,267,342 7-Jan-1836,703,157 14-Jan-1837,299,945 21-Jan-1842,939,822 28-Jan-1840,171,641 4-Feb-1862,505,647 11-Feb-1843,167,806 18-Feb-1836,709,887 25-Feb-1840,021,529 4-Mar-1840,741,214 11-Mar-1840,449,603 18-Mar-1841,386,314 25-Mar-1843,409,836 1-Apr-1841,109,689 8-Apr-1842,964,068 15-Apr-1847,098,678 22-Apr-1844,313,979 29-Apr-1843,856,759 6-May-1863,716,144 13-May-1846,371,246 20-May-1844,458,798 27-May-1847,105,314 3-Jun-1844,705,039 10-Jun-1845,613,372 17-Jun-1844,009,085 24-Jun-1844,742,750 1-Jul-1845,572,739 8-Jul-1847,848,190 15-Jul-1843,126,773 22-Jul-1841,906,917 29-Jul-1840,512,782 5-Aug-1839,427,667 12-Aug-1840,901,950 19-Aug-1840,735,733 26-Aug-1836,867,975 2-Sep-18? 9-Sep-18? 16-Sep-18? 23-Sep-18? 30-Sep-18?