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

Using simple moving averages and the following time series data, respond to each of the Items. Period Demand 130 122 121 112 141 105 116 118 146 125 Click here for the Excel Data File b. Compute all possible forecasts using a six-perlod simple moving average model. (Round your answers to 1 decimal place.) * Answer is complete but not entirely correct. Period Demand 6-Period SMA Absolute Error 1 130 0.0 0.0 2 122 0.0 0.0 3 121 0.0 0.0 112 0.0 0.0 5 141 0.0 0.0 6 105 0.0 0.0 7 116 121.8 5.80 8 118 119.5 1.50 9 146 118.8 0 23.2 X 10 125 122.3 x 6.7 x 11 125.2 0.0 c. Compute the MAD. (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
