Customer Qualitative Forecast Memo

 

 

Customer Qualitative Forecast Memo

Purpose:

The purpose of this assignment is for you to demonstrate how to create a 24 month qualitative forecast. Its expected outcomes should have the student provide an understanding of how a customer’s demand is forecasted, assessed and measured for accuracy and customer satisfaction.

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.Complete the following tasks to help Jones:

Create a 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.

Create a linear regression forecast for the next two years.MAKE SURE TO SHOW ALL CALCULATIONS FOR FULL CREDIT. 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 should you do this? MAKE SURE TO SHOW ALL CALCULATIONS FOR FULL CREDIT.

Write a 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:

• Create a 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.
• Create a linear regression forecast for the next two years.
• Create a 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)