Question: Question 11 5 pts Given the following data and a 4-period weighted moving average. t At 1 16 2 12 3 18 4 5 20

Question 11 5 pts Given the following data and a

Question 11 5 pts Given the following data and a 4-period weighted moving average. t At 1 16 2 12 3 18 4 5 20 Supposed the weights of the four periods are 4, 6, 9, 12 for the OLDEST to NEWEST periods, respectively. Compute the 4-period weighted moving average in period 5. 18 18 13.8 17.68 15.82 12.32 Question 12 5 pts Given the following actual and forecast data. Compute MAPE (MARD) in Period 5. MAPE= MARD=AVERAGE(abs(A-F)/A). DO NOT multiply by 100. ROUND your answer to TWO decimal point. t At Ft 1 185 203 N 166 65 3 145 161 4 140 55 5 178 235 Question 11 5 pts Given the following data and a 4-period weighted moving average. t At 1 16 2 12 3 18 4 5 20 Supposed the weights of the four periods are 4, 6, 9, 12 for the OLDEST to NEWEST periods, respectively. Compute the 4-period weighted moving average in period 5. 18 18 13.8 17.68 15.82 12.32 Question 12 5 pts Given the following actual and forecast data. Compute MAPE (MARD) in Period 5. MAPE= MARD=AVERAGE(abs(A-F)/A). DO NOT multiply by 100. ROUND your answer to TWO decimal point. t At Ft 1 185 203 N 166 65 3 145 161 4 140 55 5 178 235

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!