Respond to each of the items using the following time series data. Period 1 2 3...

Transcribed Image Text:

Respond to each of the items using the following time series data. Period 1 2 3 4 5 6 7 8 9 10 11. 12 13 14 15 16 Period Click here for the Excel Data File b. Compute all possible forecasts using a five-period moving average. (Round your answers to 1 decimal places.) 1 2 3 4 5 6 Demand 104 132 117 120 104 141 120 7 8 9 10 11 12 13 14 15 16 17 136 109 143 142 109 113 124 113. 104 Demand 104 132 117 120 104 141 120 136 109 143 142 109 113 124 113 104 5-period SMA Absolute Errors c. Compute the MAD. (Round your answer to 1 decimal place.) MAD d. What is the forecast demand for period 17? (Round your answer to 1 decimal place.) Forecast demand for period 17 units e. What is the error associated with the period 17 forecast? (Round your answer to 1 decimal place.) Error associated with the period 17 forecast Respond to each of the items using the following time series data. Period 1 2 3 4 5 6 7 8 9 10 11. 12 13 14 15 16 Period Click here for the Excel Data File b. Compute all possible forecasts using a five-period moving average. (Round your answers to 1 decimal places.) 1 2 3 4 5 6 Demand 104 132 117 120 104 141 120 7 8 9 10 11 12 13 14 15 16 17 136 109 143 142 109 113 124 113. 104 Demand 104 132 117 120 104 141 120 136 109 143 142 109 113 124 113 104 5-period SMA Absolute Errors c. Compute the MAD. (Round your answer to 1 decimal place.) MAD d. What is the forecast demand for period 17? (Round your answer to 1 decimal place.) Forecast demand for period 17 units e. What is the error associated with the period 17 forecast? (Round your answer to 1 decimal place.) Error associated with the period 17 forecast

Answer rating: 100% (QA)

Answer I have given the detailed explanation in the above image I have given the d... View the full answer