Question: Using simple moving averages and the following time series data, respond to each of the items. Period Demand 130 122 121 112 141 109 116




Using simple moving averages and the following time series data, respond to each of the items. Period Demand 130 122 121 112 141 109 116 118 142 125 Click here for the Excel Data File b. Compute all possible forecasts using a six-period simple moving average model. (Round your answers to 1 decimal place.)e. What is the error associated with the eleventhperiod forecast? (Round your answer to 1 decimal place.) 6 Answer is complete but not entirely correct. 7.? 6 c. Compute the MAD. {Round your answer to 1 decimal place.) 6 Answer is complete but not entirely correct. cl. What is the forecast demand for period 11? {Round your answer to 1 decimal place.) 0 Answer is complete and correct. b. Compute all possible forecasts using a sixperiod simple moving average model. {Round your answers to 1 decimal place.) 6 Answer is complete but not entirely correct. 1 130 0.0 o 0.0 o 2 122 0.0 o 0.0 Q 3 121 0.0 o 0.0 Q 4 112 0.0 o 0.0 Q 5 141 0.0 o 0.0 o 5 109 0.0 o 0.0 Q 7 116 121.8 6 3.8 9 8 113 120.2 0 2.2 Q 9 142 110.5 0 22.5 o 10 125 123.0 0 2.0 Q 11 125.2 0 0 0
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
