Calculate a two month moving average for months

Assignment Help Operation Management

Reference no: EM131708888

The table below shows the demand for a product for each of the last 9 months.

Month Demand

1. 215

2. 260

3. 282

4. 305

5. 279

6. 293

7. 278

8. 281

9. 250

Calculate a two month moving average (MAF) for months two through nine. What is the forecast for the demand in month ten?

Apply exponential smoothing (ESF) with a smoothing constant of 0.2 to determine a forecast for the demand in month ten.

Provide a chart that shows actual, MAF, and ESF.

Using MAD, MSE, and MAPE on both forecasts (MAF and ESF) for months three through nine, which of the two forecasts for month ten do you prefer and why?

What value of alpha do you need for ESF to obtain the same MAD as MAF at a two month moving average? Tip: use “goal seek” in excel to calculate this. Provide the value of alpha rounded to 3 decimal places.

Reference no: EM131708888

Questions Cloud

Big springfield vs. shelbyville football game : There are two neighboring towns, Springfield and Shelbyville, and these towns have a raffle every year at the big Springfield vs. Shelbyville football game.

Social and cultural issues to assess the consumer market : Define and analyze various social and cultural issues to assess the “consumer” market for a selected country.

Evaluate the governance policy of firm : For this assignment, each student is asked to evaluate the governance policy of a firm they might consider working for and then comparing

Leadership theories-transactional and transformational : LEADERSHIP THEORIES-Transactional and Transformational. Analyze health care organization challenges where these theories can be applied.

Calculate a two month moving average for months : Calculate a two month moving average (MAF) for months two through nine. What is the forecast for the demand in month ten?

Similarities between descriptive and and inferential statics : What are the similarities between descriptive and and inferential statics?

Explain employer liability for employee acts : Explain employer liability for employee acts (vicarious liability) to three people you know and ask them if that is a good or bad idea and why?

Guilty of hiring and harboring illegal aliens : What argument would you make that Tipton and Seferi were guilty of hiring and harboring illegal aliens?

Businesses maintain a high level of visibility : Why is it important that businesses maintain a high level of visibility on search engine results pages?

User Account

All Pages