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 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 10 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.) Period Demand 6-Period SMA Absolute Error 130 0.0 0.0 N 122 0.0 0.0 3 121 0.0 0.0 4 112 0.0 0.0 141 0.0 0.0 109 0.0 0.0 116 121.8 5.8 8 118 119.5 1.5 142 118.8 25.2 10 125 122.3 2.3 . .11 |' 124.5[ 0.0 c. Compute the MAD. (Round your answer to 1 decimal place.) cl. What is the forecast demand for period 11? (Round your answer to 1 decimal place.) 124.8 e. What is the error associated with the eleventh-period forecast? (Round your answer to 1 decimal place.) Period Sales $ 1, 001 1, 131 841 1, 044 1, 012 703 682 712 646 10 686 11 909 12 469 13 566 14 488 15 688 16 675 17 303 18 381 Click here for the Excel Data File d-1. Compute all possible forecasts using a trend forecasting model using simple linear regression? (Round your answers to 2 decimal places.) Period Sales Predicted Sales Absolute Error 1,001 N 1,131 3 841 4 1,044 5 1,012 6 703d-2. What is the MAD? (Round your answer to 2 decimal places.) :| cl-3. What is the trend equation based on the regression analysis? (Round your answers to 2 decimal places.) e. What is the predicted annual change of industry sales? {Round your answer to 2 decimal places.} f. Predict sales for the next three periods. [Round your answers to 2 decimal places} Sales {19) Sales {20} Sales (21)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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