complete

profileHade1113
TiresforyouTemplate.xlsx
Home>Business & Finance homework help>complete

Q1

Q1. Simple Moving Average
Demand 3PF Error Abs Error Abs % Deviation
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 3PF Error Abs Error Abs % Deviation
Oct 9,797 alpha 0.6
Nov 11,134 beta 0.3
Dec 10,687 gama 0.1
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 10,696 9,500 alpha 0.4
Feb 9,665 beta 0.6
Mar 10,179
Apr 11,760
May 9,150
Jun 9,571
Jul 8,375
Aug 11,826
Sep 10,696
Oct 11,212
Nov 9,750
Dec 9,380
Total Demand 122,260
Avg. Demand 10,188.33
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