{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

week 2 professors

# week 2 professors - The Schonlind Company Schedule of Sales...

This preview shows page 1. Sign up to view the full content.

The Schonlind Company Schedule of Sales Year Amount 1999 \$300,000 2000 225,000 2001 325,000 2002 650,000 2003 540,000 2004 675,000 2005 825,000 Question 1 Moving Average Method \$3,540,000 7 \$505,714 Question 2 The Schonlind Company Revised Schedule of Sales Year Amount 1999 \$300,000 2000 \$225,000 2001 \$325,000 2002 \$450,000 2003 \$540,000 2004 \$675,000 2005 \$825,000 Question 3 Revised Moving Average Method \$3,340,000 7 \$477,143 Question 4 The revised schedule of sales would be more representative of the Schonlind Company's sales pattern since the \$200,000 sale in 2002 was a one-time event that is not likely to be repeated. It is recommended that all forecasting techniques use the revised schedule without the one-time sale. Question 5 Exponential Smoothing Year Amount Weight 1999 \$300,000 1 \$300,000 2000 225,000 2 450,000 2001 325,000 3 975,000 2002 450,000 4 1,800,000 2003 540,000 5 2,700,000 2004 675,000 6 4,050,000 2005 825,000 7 5,775,000 Totals 28 \$16,050,000 \$573,214 Question 6 Trend line GROWTH(I5:I11,G5:G11,2006) 988,651 Graph Question 7 Forecast sales of \$850,000 Question 8 The Schonlind Company Schedule of Sales Year Amount 1999 \$300,000 \$24,190 2000 \$225,000 26,194 2001 \$325,000 27,466 2002 \$450,000 29,994 2003 \$540,000 33,467 2004 \$675,000 36,348 2005 \$825,000 35,700 2006 35,430 Projected Regression analysis \$686,529 Question 9
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern