Question - The Schonlind Company has gathered information regarding past sales:
|
Year
|
Sales
|
|
1999
|
$300,000
|
|
2000
|
225,000
|
|
2001
|
325,000
|
|
2002
|
650,000
|
|
2003
|
540,000
|
|
2004
|
675,000
|
|
2005
|
825,000
|
Required: Predict the sales for 2006 using the moving average method.
NOTE: It is expected that this problem will be completed using an Excel spreadsheet using formulas.