Question: I need help with an assignment. Jones Company distributes power supplies used for electronic toys.They have been in business for five years and the past

I need help with an assignment.

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

Assuming 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. 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?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!