Question: Problem 2 - Forecasting [3 points] Assume that your stock of sales merchandise is maintained based on the forecast demand. If the distributor's sales personnel

Problem 2 - Forecasting [3 points]

Assume that your stock of sales merchandise is maintained based on the forecast demand. If the distributor's sales personnel call on the first day of each month, compute your forecast sales by each of the three methods requested here. Round your answers to the nearest whole number.

ACTUAL

June

140

July

170

August

210

  1. [1 point] Using a simple three-month moving average, what is the forecast for September?

Septembers forecast = _________

  1. [1 point] Using a weighted moving average, what is the forecast for September with weights of 0.40, 0.50, and 0.10 for June, July, and August, respectively?

Septembers forecast = _________

  1. [1 point] Using single exponential smoothing and assuming that the forecast for June is 130. What is the forecast for September with a smoothing constant of 0.20.

Septembers forecast = _________

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!