Tires For You Case Assignment

profileesaap17
TEMPLATETiresForyouStudentsRev.xlsx
Home>Business & Finance homework help>Accounting homework help>Tires For You Case Assignment

Q1

Q1. Simple Moving Average
Demand 3PMA 3PF Error Abs Error MAPE
Oct 10,193
Nov 11,599
Dec 11,130
Jan 10,696
Feb 9,665
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
Avg. Demand
Total Bias
Ave. Bias
Abs Dev
MAD
MAPE

Q2

Q2. Weighted Moving Average
Demand 3PMA 3PF Error Abs Error MAPE
Oct 10,193 alpha 0.6
Nov 11,599 beta 0.3
Dec 11,130 gama 0.1
Jan 10,696
Feb 9,665
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
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