Question: Please solve yellow boxes RAW TIME SERIES DATA Demand (Dt) January-16 130,000 February-16 146,000 March-16 108,500 April-16 159,500 May-16 1,375,300 June-16 640,212 July-16 757,000 August-16

Please solve yellow boxes

Please solve yellow boxes RAW TIME SERIES DATA

RAW TIME SERIES DATA Demand (Dt) January-16 130,000 February-16 146,000 March-16 108,500 April-16 159,500 May-16 1,375,300 June-16 640,212 July-16 757,000 August-16 1,114,000 1 2 3 7 FORECAST USING SIMPLE MOVING AVERAGE "Lookback" window n= 8 5 7 Your forecast for September, 2016 553,814 3 1 2 3 4 5 5 FORECAST USING WEIGHTED MOVING AVERAGE WITH n=8 "Lookback" window n= 8 weights w7 0.05 w6 0.05 w5 0.07 W4 0.08 w3 0.1 w2 0.1 w1 0.25 wo 0.3 SUM 1 7 3 2 1 2 3 Your forecast for September, 2016 94,894.53 4 5 5 7 8 9 FORECAST USING EXPONENTIAL SMOOTHING Smoothing factor a= 0.435 Prior forecast for August, 2016 350,739 Observed demand in August, 2016 1,114,000 1 2 Your forecast for September, 2016 682,758

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!