Question: Given the following demand data, PeriodDemand 1 6 2 2 5 9 3 6 4 4 5 9 5 6 5 Compute a weighted average

Given the following demand data,
PeriodDemand162259364459565
Compute a weighted average forecast using a weight of 0.4 for the most recent period, 0.3 for the next most recent, 0.2 for the next, and 0.1 for the next.
Note: Round all your answers to two decimal points.
If the actual demand for period 6 is 63, forecast demand for period 7 using the same weights as in part a.
A five-month moving average.
Note: Round your answer to 2 decimal places.
A weighted average using 0.75 for August, 0.15 for July, and 0.10 for June.
Note: Round your answer to 2 decimal places.
Exponential smoothing with a smoothing constant equal to 0.30, assuming a March forecast of 18(000).
Note: Round your intermediate forecast values and final answer to 2 decimal places.
A linear trend equation.
Note: Round your intermediate calculations and final answer to 2 decimal places.

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!