The screenshot Excel file (Forecasting Assignment Data) contains quarterly Food shipments for Kraft Foods, Inc from 2000 through 2006. Forecast Kraft Foods quarterly food shipments for 2007 using:

1) Holts Method

2) Winters Method

3) Linear Trend Model

4) Quadratic Trend Model

5) Quadratic Trend with Seasonal Indices Model

In addition, make a recommendation of which forecasting method you think Kraft Foods Inc should use and why. Please show work through excel.

Year 2000 2001 2002 Quarter 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 Period 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 2003 Demand A 49,057 53,329 48,077 54,129 54,154 60,161 56,611 63,535 64,669 65,540 67,474 65,970 70,608 76,025 67,458 77,056 74,090 82,034 80,578 80,587 76,716 77,128 87,585 87,588 79,506 79,796 97,046 92,848 2004 2005 2006 26 AN 27 28