Calculate simple three-moving average forecast for periods

Assignment Help Operation Management

Reference no: EM132085843

Month Actual Demand 1 62 2 65 3 67 4 68 5 71 6 73 7 76 8 78 9 78 10 80 11 84 12 85 a) Calculate the simple three-moving average forecast for periods 4-12. b) Calculate the weighted three-moving average using the following sets of weights : 1) 0.50, 0.30, and 0.20 for periods 4-12. 2) 0.40, 0.35, and 0.25 for periods 4-12. 3) 0.60, 0.25, and 0.15 for periods 4-12. c) Calculate the single exponential smoothing forecast for periods 2-12 using the following information: 1) Initial forecast (F1) of 61 and an alpha of 0.10. 2) Initial forecast (F1) of 61 and an alpha of 0.20. 3) Initial forecast (F1) of 61 and an alpha of 0.30. d) Calculate the forecast for periods 4-12 using simple linear regression using Excel. e) Calculate the mean absolute deviation (MAD) and Mean square error (MSE) for all the previous forecasts made by each technique for the periods 4-12. Which forecasting method do you recommend to use?

Reference no: EM132085843

Questions Cloud

Summary of the hiring practices-work group methodologies : Summary of the hiring practices, work group methodologies, and training methods utilized in this business/industry.

Demand and cost of acquiring supplies and ingredients : As you can see, local demand and the cost of acquiring supplies and ingredients from a store in the Arctic drives Angelo's accounting.

Terms regarding subjective interpretation : Which of the following countries uses high-context language? Which of the following terms regarding subjective interpretation is incorrect?

How many new mothers are staying in children hospital : How many new mothers are staying in Children’s Hospital (at any time point)? How many new mothers are staying in Swedish Hospital (at any time point)?

Calculate simple three-moving average forecast for periods : Calculate the simple three-moving average forecast for periods

Describe one of the models in the continuum of care : Health Insurance and managed care may be thought of as a continuum of models. Identify and briefly describe one of the models in the continuum of care

Mid-level employees to ignore-kill disruptive technologies : What are the corporate factors that lead mid-level employees to ignore or kill disruptive technologies?

Difference between contract manufacturing and outsourcing : What is the difference between (contract manufacturing) and (outsourcing)?

Distance between defects in automated weaving process : The distance between defects in an automated weaving process at Craft Mills, Inc. is exponentially distributed.

User Account

All Pages