Question: Problem 2: Forecasting Methods (7 points) Below is the actual demand for an item over a 6-month period. Your boss wants to test two forecasting

Problem 2: Forecasting Methods (7 points) Below

Problem 2: Forecasting Methods (7 points) Below is the actual demand for an item over a 6-month period. Your boss wants to test two forecasting methods to see which method was better over this period. Month June July Aug Sept Oct Nov Actual Demand 260 280 210 330 250 220 a) Forecast Sept-Dec using a three-month moving average. (2 points) b) Forecast Aug-Dec using a two-month weighted moving average. Use 0.8 for the weight for the most recent month, and 0.2 for the weight for the previous month.(2 points) c) Calculate the MAD for each forecast you created in parts a and b. (2 points) d) Using the more accurate forecast you identified in part c, what is your forecast for December? (1 point - you can leave the answer as a decimal)

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!