Question: Using the data below, complete the following questions by hand (note: I want to see all of your work): Period 12 32 42 52 Month

Using the data below, complete the following

Using the data below, complete the following questions by hand (note: I want to see all of your work): Period 12 32 42 52 Month March April May June July August September October November December Actual Issues Remediated 3552 234 2672 1892 301 2224 2452 4324 324 1872 62 72 82 92 104 1. Use a 3-month moving average model to forecast issues remediated for periods 6- 10. (15 poin 2. Use a 5-month moving average model to forecast issues remediated for periods 6- 10. (15 points) 3. Use an exponential smoothing model with a = 2 to forecast issues remediated for periods 6-10. (Assume a beginning forecast of 320 for period 5). (15 points) 4. Use an exponential smoothing model with a =.4 to forecast issues remediated for periods 6-10. (Assume a beginning forecast of 320 for period 5) (15 points) 5. Compare the forecasts in questions 1 through 4. Which is best? Why? Support your answer. (20 points) 6. Starting with your solution to question 4, complete a double smoothing model for periods 6-10 for issues remediated. Again here, assume a beginning forecast of 320 for period 5. How does this model perform compared to question 4? Support you answer with statistics. (20 points)

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!