Question

Please help me with 5.4 Question's solution.

***PLEASE PROVIDE A DETAILED SOLUTION FOR MY UNDERSTANDING***

Your time & help is highly appreciated.

Thanks

EXERCISES 5.1 Plot the following data and then calculate and plot a three 5.4 Referring to the data in exercise 1, use Excel's Solver or period moving average. Then calculate and plot a five- period moving average. What do you observe in comparing the plots of the three- and five-period moving averages? trial and error to find the value of α that minimizes the MADRetrict the value of a to be between 0.05 and 0.30. 5.5 Consider the following data for a children's toy: Period 2 3 45 6 789 10 Demand 60 52 55 42 57 33 26 42 35 3 Deman Modh F MAMDAS Month

Answer 1

1 Period Demand Prediction Absolute forecast error 60 52 alpha 8.00 MAD 0.2 11.33 60.00 60.00 58.40 57.72 54.58 55.06 50.65 45.72 44.98 42.98 3.40 15.72 2.42 22.06 24.65 3.72 9.98 11.98 4 3 42 57 26 42 35 31 10 10 12 13