Assignment:
ABC Cracker Company manufactures cheddar cheese fish crackers. They are shipped in full truckloads to the retailer customers' DCs. Below is the number of truckloads ABC shipped per month during 2013:
| 2015 |
TL shipped (demand) |
|
| October |
168 |
|
| November |
191 |
|
| December |
184 |
|
|
|
|
| 2016 |
|
2017 TL shipped (demand) |
| January |
179 |
197 |
| February |
162 |
179 |
| March |
170 |
187 |
| April |
196 |
216 |
| May |
180 |
198 |
| June |
136 |
150 |
| July |
185 |
204 |
| August |
190 |
209 |
| September |
179 |
197 |
| October |
187 |
206 |
| November |
213 |
234 |
| December |
204 |
224 |
Q1. Use exponential smoothing to generate a monthly forecast for 2017. Assume F1 = 187. Use alpha =0.6
Q2. Create a table for the three forecasting methods you used here. Make sure you include statistics on: bias, MAD, MSE, MAPE, and tracking signal (this is just CFE/MAD). Indicate which forecasting method gives you the best result.
Provide complete and step by step solution for the question and show calculations and use formulas.