View the step-by-step solution to:

# Customer Qualitative Forecast Memo Instructions: Jones Company distributes power supplies used for electronic toys.

Customer Qualitative Forecast Memo

Instructions:

Jones Company distributes power supplies used for electronic toys. They have been in business for five years and the past five-year demand for power supply X52 is the following:

Year Demand

1 12,925

2 17,263

3 22,512

4 28,765

5 31,646

Assume it's January 1 and Jones needs help with developing the forecast for the next two years. Jones needs:

1. 24-month qualitative forecast. You can use a method of your choosing. Make sure you identify the assumptions you relied on and discuss how you developed the forecast.
2. linear regression forecast for the next two years. SHOW ALL CALCULATIONS. Assume your forecast for the first six months of the first year is the following: JAN 2,000; FEB 2,800, MAR 3,200, APR 2,800; MAY 3,500; JUNE 3,300. Also, assume actual customer demand is the following: JAN 2,500; FEB 2,700, MAR 3,000, APR 2,600; MAY 3,200; JUNE 3,000. The acceptable tracking signal target is 1.5. Will you need to update your forecast for Jones? If so when?
3. Memo summarizing and defining the conclusions drawn in completing your two year linear regression forecast. Your memo is to be addressed to the CEO of Jones Company(Amanda Jones).

Required Elements of the Customer Qualitative Forecast Memo :

1. 24-month qualitative forecast. You can use a method of your choosing. Make sure you identify the assumptions you relied on and discuss how you developed the forecast.
2. linear regression forecast for the next two years.

memo summarizing your work, and clearly defining, supporting and explaining the logic used in drawing your conclusions. The memo should be suitable for presentation to the CEO of Jones Company and addressed to same (Amanda Jones).

### Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

### -

Educational Resources
• ### -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents