{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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

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

View Full Document Right Arrow Icon
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
Image of page 1
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    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.

    Student Picture

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

  • Left Quote Icon

    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.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    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.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern