(shaded region only needs to be solved)

raw data

Develop a forecast for Period 14 using the Trend Adjusted model provided. Be sure to include any necessary updates, given the information you have available. Show any calculations in this text box, or cut and paste them in the space below this text box - e.g. if you wish to write out the calculations. (Do not include these directions in your final text box). Fill in the highlighted area only those numbers that are necessay in determining your final forecast. G A B t D E D Qtr Demand F E Forecast Error Year Period * 2015 -7 7 0 13 -16 F A Average 167 198 232 265 302 330 363 388 406 414 427 1 T. Trend 33 32 33 33 33 33 33 32 31 28 27 2016 1 2 3 4 5 6 7 8 9 10 11 12 13 14 1 Qtr 1 Qtr2 Qtr3 Qtr4 Qtr 1 Qtr2 Qtr3 Qtr4 Qtr 1 Qtr2 Qtr3 Qtr4 Qtr 1 Qtr2 193 237 265 310 319 363 370 374 361 392 359 293 1 200 230 265 298 335 362 395 420 436 442 3 -25 -46 -73 -51 TE 5 2017 3 2018 Year 2015 2016 2017 Quarter Demand Qtr 1 193 Qtr2 237 Qtr3 265 Qtr4 311 Qtr 1 319 Qtr2 363 Qtr3 370 Qtr4 374 Qtr 1 363 Qtr2 392 Qtr3 359 Qtr4 293 Qtr 1 293 Qtr2 356 Qtr3 381 Qtr4 409 Qtr 1 457 Qtr2 419 Qtr3 459 Qtr4 458 Qtr 1 525 Qtr2 Qtr3 Qtr4 2018 2019 2020 = .3 =.1 10 427 27 442 -51 Qtr2 Qtr3 Qtr4 Qtr 1 Qtr2 392 359 293 12 13 14 2018