Principles of Logistics-EXCEL

Q1

Q1. Simple Moving Average
	Demand	3PMA	3PF	Error	Abs Error	MAPE
Oct	9,797
Nov	11,134
Dec	10,687
Jan	9,724
Feb	8,786
Mar	9,254
Apr	10,691
May	9,256
Jun	8,700
Jul	10,192
Aug	10,751
Sep	9,724
Oct	10,193
Nov	11,599
Dec	11,130
Total Demand
Avg. Demand
Total Bias
Ave. Bias
Abs Dev
MAD
MAPE

Q2

Q2. Weighted Moving Average
	Demand	3PMA	3PF	Error	Abs Error	MAPE
Oct	9,797							alpha	0.5
Nov	11,134							beta	0.3
Dec	10,687							gama	0.2
Jan	9,724
Feb	8,786
Mar	9,254
Apr	10,691
May	9,256
Jun	8,700
Jul	10,192
Aug	10,751
Sep	9,724
Oct	10,193
Nov	11,599
Dec	11,130
Total Demand
Avg. Demand
Total Bias
Ave. Bias
Absolute Dev
Mean Abs Dev
MAPE

Q3

Q3. Exponential Smoothing
	Demand	Forecast	Error	Abs Error	Abs % error
Jan	9,724	9,500				alpha	0.1
Feb	8,786					beta	0.9
Mar	9,254
Apr	10,691
May	9,256
Jun	8,700
Jul	10,192
Aug	10,751
Sep	9,724
Oct	10,193
Nov	11,599
Dec	11,130
Total Demand	120,000
Avg. Demand	10,000.00
Total Bias
Ave. Bias
Absolute Dev
Mean Abs Dev
MAPE

Q4

	Q1	Q2	Q3
	3 AMU	3 WAMU	Ex Smoothing
Total Bias
Ave. Bias
Abs Dev
Mean Abs Dev
MAPE
Ranking

1

2

3

4

5

6

7

8

9

A

B

C

Q1

Q2

3 AMU

3 WAMU

Total Bias

Ave. Bias

Abs Dev

Mean Abs Dev

MAPE

Ranking