Nothing Special   »   [go: up one dir, main page]

E Matrik

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 1

(untitled)

Forecasting Moving averages - 2 period moving average


This
This spreadsheet
spreadsheet was
was created
created by
by either
either POM,
POM, QM
QM or
or POM-QM
POM-QM for Forecasting
for Windows,
Windows, V4.
V4.
140
120
100
80
Data Error analysis 60 Demand

Value
40 Forecast
Period Demand Forecast Error Absolute
20 Squared |% Error|
January 129 0
February 100 1 3 5 7 9 11
March 90 114.5 -24.5 24.5 Time
600.25 0.272222
April 65 95 -30 30 900 0.461538
May 90 77.5 12.5 12.5 156.25 0.138889
June 82 77.5 4.5 4.5 20.25 0.054878
July 112 86 26 26 676 0.232143
August 116 97 19 19 361 0.163793
September 98 114 -16 16 256 0.163265
October 116 107 9 9 81 0.077586
November 106 107 -1 1 1 0.009434
December 102 111 -9 9 81 0.088235
Total -9.5 151.5 3132.75 1.661984
Average -0.95 15.15 313.275 0.166198
Bias MAD MSE MAPE
SE 19.78873
Next period 104

You might also like