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, respondto each of the items. Period Demand 130 122 121 112 141109 116 118 142 125 Click here for the Excel Data Fileb. Compute all possible forecasts using a six-period simple moving average model.

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

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!