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

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 Mathematics Questions!