Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started