Question
Subject: Supply Chain Management Answer the following questions base on the actual sales data, listed below. Keep 2 decimal point for all calculation step. Show
Subject: Supply Chain Management
Answer the following questions base on the actual sales data, listed below. Keep 2 decimal point for all calculation step. Show sufficient calculation step for partial credit.\
Month | Sales data |
Apr | 500 |
May | 480 |
June | 420 |
July | 550 |
Aug | 520 |
Sept | 450 |
Oct | 490 |
Nov | 560 |
(a) Determine the forecast error using MAPE if, the forecasting method is Weighted Moving Average (N=3) where weights are 9, 2,10. (8 marks)
(b) Determine the forecast error using MAD if, the forecasting method is Linear Regression, where slope = -5 and intercept = 510 (5 marks)
(c) Explain why your solution from part (a) and part (b) cannot be utilized to determine which forecasting model is deem more accurate. Discuss the necessary modification to enable accuracy comparison between forecasting model in part (a) and in part (b) (7 marks)
(d) Based on your conclusion in part (c), determine which forecasting model, part (a) or part (b), is deem more accurate. Justify your conclusion. (5 marks)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started