Question: iv. Which method is the most appropriate method to use for demand forecasting based on the error measures given in the TABLE 3? (3 points)

iv. Which method is the most appropriate method
iv. Which method is the most appropriate method
iv. Which method is the most appropriate method
iv. Which method is the most appropriate method
iv. Which method is the most appropriate method
iv. Which method is the most appropriate method to use for demand forecasting based on the error measures given in the TABLE 3? (3 points) a) Averaging method b) Last value method c) Moving average method d) Exponential smoothing method TABLE 3 MAD MSE MAPE LAD 39.61 1887.96 0.04 75.25 34.79 1882.51 0.05 71.04 Method Averaging method Last value method Moving average method Exponential smoothing method 40.14 1891.02 0.03 79.91 41.12 1990.94 0.09 80.81 QUESTION 6 a) Compute the forecast for month 5 in TABLE 5 using the weighted moving average with m=3 months (weights are 0.3, 0.5 and 0.2). (5 points) TABLE 5 Month Actual Demand 1 12 2 13 3 15 4 19 5 b) Compute the actual forecast for all quarters of 2019 using the last value method with the seasonality indices given below. (15 points) Quarter Q1 Q2 Q3 Q4 SF 0.83 0.85 1.26 1.04 TABLE 6 Year Quarter Actual demand Deseasonalized Deseasonalized Actual forecast demand forecast 2017 Q1 995 1193.64 Q2 1025 1203.33 Q3 1500 1186.08 Q4 1251 1191.47 2018 Q1 990 1187.65 Q2 1009 1184.55 Q3 1502 1187.66 Q4 1205 1147.66 2019 Q1 g8| Q2 Q3 Q4

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!