Sales forecasting for schonlind company

Assignment Help Business Management

Reference no: EM1367891

Sales Forecasting for Schonlind Company

Sales Forecasting

NOTE: It is expected that this problem will be completed using an Excel spreadsheet using formulas.

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:
1. Predict the sales for 2006 using the moving average method.
2. 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?
3. If you revised you historical sales to be used to project 2006 sales, recalculate your projection using the moving average method.
4. Which projection (question 1 or question 3) do you feel is more representative of the Schonlind Company's historical sales? Why?

Please complete the remaining questions using the revised historical data.
5. Predict the sales for 2006 using exponential smoothing.
6. Predict the sales for 2006 using a trend line technique using. (GROWTH function in Excel).
7. Predict the sales for 2006 using a graphing technique.
8. It has been suggested that sales for the company may be connected to disposal income. Using the information below regarding historical disposable income, predict the sale for 2006 using regression analysis if a reliable prediction for disposable income for 2006 is $35,430.

Year Disposable Income
1999 $24,190
2000 26,194
2001 27,466
2002 29,994
2003 33,467
2004 36,348
2005 35,700

9. Which method do you think provides the most realistic sales projections for 2006? Why?

Reference no: EM1367891

Questions Cloud

Calculate perfectly competitive and monopoly price : Calculate the perfectly competitive and monopoly price and output and what is the total consumer expenditures on this product under monopoly and under perfect competition?

Nurses in the healthcare organization : What nurses in the healthcare organization is responsible for? What does a typical day intel? How do they relay their information to head nurses and doctors.

Illustrate what distortions do you think would appear : Illustrate what assumptions do you make in answering this question. Illustrate what distortions do you think would appear in economy if such a tax were introduced.

Monopolistically competitive markets : Based upon marginal revenue or marginal cost analysis, explain how output and price are determined in monopolistically competitive markets.

Sales forecasting for schonlind company : Predict the sales for 2006 using exponential smoothing and predict the sales for 2006 using a trend line technique using and sales Forecasting for Schonlind Company

Type of innovation in nursing : If you heard that the kind of innovation you are proposing was to be introduced in your present work setting, describe what you would want to know about it before willing to participate in such a project.

Elucidate how a recessionary output gap would emerge : Elucidate how a recessionary output gap would emerge in an economy where long-run aggregate supply curve is persistently shifting to right.

Determine the total intrinsic value : Suppose you wants to determine the total intrinsic value of a large gas and electricity utility company. This company has publicly trade stock and has been paying a regular dividend for several years.

Write application layer protocols to permit through firewall : As part of your own planning process, write the application layer protocols which you would permit through the firewall, those you would block and your reasons for doing so.

User Account

All Pages