Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A B D E F H K M N P R S 1 Month Demand Forecasts Error Absolute Error t At 3 Period Simple
A B D E F H K M N P R S 1 Month Demand Forecasts Error Absolute Error t At 3 Period Simple Weighted Exp 2 Moving Avg. Moving Avg. Smoothing Regression 3 Period Simple Moving Avg. Weighted Exp 3 Period Simple Weighted Exp Moving Avg. Smoothing Regression Moving Avg. Moving Avg. Smoothing Regression 3 Period Simple Moving Avg. Squared Error Moving Exp Avg. Smoothing Regression Absolute Percent Error 3 Period Simple Weighted Exp Moving Avg. Moving Avg. Smoothing Regression 3 1 200 239 4 2 240 200 242 5 3 300 212 244 6 4 270 247 260 238 247 -23 -10 -32 -23 23 10 32 23 7 5 230 270 270 248 249 40 40 18 19 40 40 18 19 8 6 260 267 258 243 252 7 -3 -17 -8 7 3 17 8 544.44 1600.00 44.44 9 7 210 253 255 248 255 43 45 38 45 43 45 38 45 1877.78 10 8 275 233 228 236 257 -42 -48 -39 -18 42 48 39 18 1736.11 11 9 248 255 248 260 25 25 -32 15 31 29 29 23 1161 100.00 1600.00 6.25 2025.00 2256.25 1198 998.56 319.69 305.69 536.02 0.09 0.04 0.12 0.09 376.65 0.17 0.17 0.08 0.08 64.53 0.03 0.01 0.07 0.03 1425.91 1982.61 1487.43 907 0.21 0.21 0.18 0.21 320.91 0.15 0.17 0.14 0.07 656 0.13 0.12 0.12 0.10 12 13 14 15 Weights 16 W3 17 w2 0.25 0.25 18 W1 (most rec 0.5 19 20 21 Smoothing Constant 23 24 25 27 22222222228 350 300 250 200 0.3 150 100 50 Regression Forecast of Lager Demand y=2,5595x+236.61 R=0.0336 0 0 1 2 3 4 5 6 8 9 Forecast Method RSFE MAD MAPE MSE RMSE 3 Period Simple Moving Avg. 25 31 12.9% 1161 34.07 Weighted Moving Avg. 25 29 12.2% 1198 34.60 Exp Smoothing -32 29 11.6% 907 30.12 Regression 15 23 9.6% 656 25.62 W Upper 95.0% 615.439702 56.9250049 562.690995 702.275077 795.025063
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