Question: Problem #1: (30 points) Fill out the following problem table and show full work for at least two of the months. Demand for Month Bulldozers

Problem #1: (30 points) Fill out the following

Problem #1: (30 points) Fill out the following problem table and show full work for at least two of the months. Demand for Month Bulldozers Error 4MA Error 1 8 2 12 3 7 4 9 5 15 6 11 7 10 8 12 9 ? AE = AE = a) Compute three-month moving average for months 4-9 and four-month moving average for months 5-9. Use at least one decimal place: so your forecast should be 10.3, etc. b) Compute the errors for each forecast (note: can't do this for month 9), and (at the bottom) the Average Error for only months 5-8 for each. (Note: it's important to compare the two forecasts evenly). c) Why is there a difference between the Average Error for the two moving averages, given that they are only different by about a month? Hint: there are several reasons why 3MA has less Average Error, think about trends in the data

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!