AC556 Week 2 Problem Sales Forecasting NOTE: It is expected that this problem will be completed using an Excel spreadsheet using formulas. Please see the Excel Tutorial that is available under the course home tab. The Schonlind Company has gathered information regarding past sales: Year 1999 2000 2001 2002 2003 2004 2005 Sales $300,000 225,000 325,000 650,000 540,000 675,000 825,000 Required: 1. 2. Predict the sales for 2006 using the moving average method. You noticed a sudden jump in sales in 2002. After inquiring about this jump, you were told that there was a one-time sale for $200,000 in that year that is not likely to be repeated. What revision, if any, would you make in the sales information used for projection? If you revised you historical sales to be used to project 2006 sales, recalculate your projection using the moving average method. 3. Schonlind Company's historical sales? Why