Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Linear Algebra with Applications

Authors: Steven J. Leon

7th edition

131857851, 978-0131857858

More Books

Students also viewed these Mathematics questions

Question

Explain how the input energy is utilised in comminution processes

Answered: 1 week ago

Question

What are the different types of cases?

Answered: 1 week ago

Question

What is the purpose of using cases as a technique of study?

Answered: 1 week ago

Question

Write a short note on elevator etiquette.

Answered: 1 week ago