Question: Using simple moving averages and the following time series data, respond to each of the items. Period Demand 1 130 2 122 3 121 4
Using simple moving averages and the following time series data, respond to each of the items. Period Demand 1 130 2 122 3 121 4 112 5 143 6 105 7 116 8 118 9 142 10 125 An older version of the Microsoft Excel logo. Click here for the Excel Data File Required: Compute all possible forecasts using a six-period simple moving average model. Note: Round all your answers to 1 decimal places except "Absolute percent error" answers which should be rounded to 2 decimal places. Compute the MAD and MAPE. Note: Round your answer to 1 decimal place except "MAPE" answer which should be rounded to 2 decimal places. What is the forecast demand for period 11? Note: Round your answer to 1 decimal place. What is the error associated with the eleventh-period forecast? Note: Round your answer to 1 decimal place
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
