Compute the sales forecast for September using a 3-month moving average. Please include at least one step of calculation and the correct answer for full credit.

Compute the sales forecast for September using a 3-month moving average. Please include at least one step of calculation and the correct answer for full credit.

1.
Company E sells personal computers. The monthly sales for the
previous 4 months are summarized as follows:

Month

Actual Sales

May

20,000

June

18,000

July

20,000

August

24,000

(a) Compute the sales forecast for September
using a 3-month moving average. Please
include at least one step of calculation and the correct answer for full
credit. (4 points)

(b) Compute the sales forecast for September
using a weighted 3-month moving average using 0.20 for June, 0.30 for July, and
0.50 for August. Please include the
formula, at least one step of calculation and the correct answer for full
credit. (6 points)

(c) Suppose the forecast for August was 20,000
units. Using a smoothing constantα= 0.2, compute the sales forecast for
September. Please include the formula,
at least one step of calculation and the correct answer for full credit. (6
points)


Price: £ 45

100% Plagiarism Free & Custom Written, Tailored to your instructions

Leave your Comments


Can't read the image? click here to refresh