Question: X = 6. Please provide calculation steps, don't use excel 2. The following table shows the demand of a certain product for the last 8

X = 6. Please provide calculation steps, don't use excel
2. The following table shows the demand of a certain product for the last 8 months: Demand 52 44 33 Month 1 2 3 4 5 6 7 8 x + 40 58 47 45 39 (x is the last numeric digit of your student ID number. For example, if your student ID number is 20012345S, then x=5, and x+40 =45) a) b) c) Forecast the demand of Month 9 using the nave method. (1 mark) Forecast the demand of Month 9 using three-period moving average. (2 marks) Forecast the demand of Month 9 using exponential smoothing with a smoothing constant a=0.3. (3 marks) Compare the Mean Square Errors (MSEs) of the three forecasting methods used above. Which method would you recommend? Explain. (3 marks) Based on the results in part (a) to (e), what is your suggestion to the manager of the company? (1 mark) d)Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
