Question

Use
excel, show excel commands. #8





For problerms 7 througl use the following time serles data:l Th fol PERIOD DEMAND 221 247 228 233 240 152 163 155 167 158 4 5 7 10 7. () Develop a last period forecast for periods 2 through 11. Calculate the MFE, MAD, and MAPE values for periods 2 through 10. Is this a good model? Why? 8. () Develop a three-period weighted moving average forecast for periods 4 through 11. Use weights of 0.4, 0.35, and 0.3, with the most recent observation weighted the highest. Calculate the MFE, MAD, and MAPE values for periods 4 through 10. How do your results compare with those for problem 7?
For problerms 7 througl use the following time serles data:l Th fol PERIOD DEMAND 221 247 228 233 240 152 163 155 167 158 4 5 7 10 7. () Develop a last period forecast for periods 2 through 11. Calculate the MFE, MAD, and MAPE values for periods 2 through 10. Is this a good model? Why? 8. () Develop a three-period weighted moving average forecast for periods 4 through 11. Use weights of 0.4, 0.35, and 0.3, with the most recent observation weighted the highest. Calculate the MFE, MAD, and MAPE values for periods 4 through 10. How do your results compare with those for problem 7?