Question: b . Compute the sales forecast for July using the approaches given below. Do not round intermediate calculations. Round your answers to the nearest whole

b. Compute the sales forecast for July using the approaches given below. Do not round intermediate calculations. Round your answers to the nearest whole number.
a three-month moving average
computers
a weighted three-month moving average using 0.60 for June, 0.30 for May, and 0.10 for April
computers
a linear trend equation
computers
exponential smoothing with a(smoothing constant) equal to 0.50, assuming a February forecast of 20,000
computers
c. Calculate the MAD for each of the four techniques in part b. Use only the last 3 months to compare the same number of months for all methods. Do not round intermediate calculations.
Round your answers to the nearest whole number.
MAD (three-month moving average):
MAD (weighted three-month moving average):
MAD (linear trend equation):
computers
MAD (exponential smoothing):
Which is the best? Why? Ms. Winnie Lin's company sells computers. Monthly sales for a six-month period are as follows:
 b. Compute the sales forecast for July using the approaches given

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 General Management Questions!