Question: table [ [ Month , Year 1 , Year 2 , Year 3 , Year 4 , Year 5 ] , [ January ,

\table[[Month,Year 1,Year 2,Year 3,Year 4,Year 5],[January,,6381.07,11016.55,11965.68,10580.74],[February,,4405.83,8264.14,12761.98,13420.87],[March,4566.4,9126.95,6843.95,18126.7,34476.27],[April,6941.89,10970.45,20109.68,19092.9,19108.79],[May,7047.23,10189.28,11148.64,15384.01,18109.54],[June,6784.37,7043.85,8365.4,12237,13743.6],[July,5814.23,6717.37,9469.08,13252.53,18339.25],[August,6906.38,9139.72,10221,13819.77,],[September,8075.13,11315.19,15161.41,21755.64,],[October,7913.56,10838.4,17731.08,24838.1,],[November,9054.18,11150.94,17508.99,15955.6,],[December,14114.58,17592.2,27566.89,19370.7,]]
Develop a forecast for the sales in August of Year 5 by using three different forecasting techniques: Three-month simple moving average, Weighted moving average with weights 0.5,0.3,0.2(the weight 0.5 is given to the most recent observation), and Exponential smoothing method with a smoothing constant of 0.3.(15 points)
Which forecasting method you considered in Question 1 is the most accurate according to the Mean Absolute Deviation (MAD) criterion? Please justify your answer. (5 points)
Calculate a 95% confidence interval of the forecast made for August of the fifth year. While developing the confidence interval, use the forecasting method identified in question 2 as the
 \table[[Month,Year 1,Year 2,Year 3,Year 4,Year 5],[January,,6381.07,11016.55,11965.68,10580.74],[February,,4405.83,8264.14,12761.98,13420.87],[March,4566.4,9126.95,6843.95,18126.7,34476.27],[April,6941.89,10970.45,20109.68,19092.9,19108.79],[May,7047.23,10189.28,11148.64,15384.01,18109.54],[June,6784.37,7043.85,8365.4,12237,13743.6],[July,5814.23,6717.37,9469.08,13252.53,18339.25],[August,6906.38,9139.72,10221,13819.77,],[September,8075.13,11315.19,15161.41,21755.64,],[October,7913.56,10838.4,17731.08,24838.1,],[November,9054.18,11150.94,17508.99,15955.6,],[December,14114.58,17592.2,27566.89,19370.7,]] Develop a forecast for the

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!