C4 Problem 4.1 Exponential smoothing

C4 Problem 4.1 Exponential smoothing - Average -38.55594...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Forecasting Exponential smoothing Alpha 0.25 Data Forecasts and Error Analysis Period Demand Forecast Error Absolute Squared Abs Pct Err Period 1 345 345 0 0 0 00.00% Period 2 370 345 25 25 625 06.76% Period 3 410 351.25 58.75 58.75 3451.5625 14.33% Period 4 378 365.9375 12.0625 12.0625 145.50391 03.19% Period 5 368 368.95313 -0.953125 0.953125 0.9084473 00.26% Period 6 374 368.71484 5.2851563 5.2851563 27.932877 01.41% Period 7 370.03613 -370.0361 370.03613 136926.74 #DIV/0! Total -269.8916 472.08691 141177.65 #DIV/0!
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Average -38.55594 67.440988 20168.235 #DIV/0! Bias MAD MSE MAPE SE 168.03431 Next period 277.5271 1 2 3 4 5 6 300 320 340 360 380 400 420 Forecasting 345 345 Time Value Enter alpha (between 0 and 1), enter the past demands in the shaded column then enter a starting forecast. If the starting forecast is not in the first period then delete the error analysis for all rows above the starting forecast....
View Full Document

Ask a homework question - tutors are online