• Case Assignment: Case 7.1 Tires for You. Pgs. 229 – 230
  • All assignments need be solved in the excel template file provided (formulas in the Excel cells)  and uploaded to this dropbox.
  • Data from the assignments may not be the same as the text book.
  • Students will need to use the data from the template.

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
0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *