Question: Problem 5 - Use the data below to calculate two forecasts: 1) A 2 period Moving Average; 2) An Exponetial Smoothed forecast with an alpha

Problem 5 - Use the data below to calculate two forecasts: 1) A 2 period Moving Average; 2) An Exponetial Smoothed forecast with an alpha of .35 Based on the MAD, what is the expected error for these two forecasting techniques? Which one do you recommend using? Explain your choice
Actual
Month Demand
January 650
February 665
March 750
April 825
May 1110
June 660
July 690
August 760
September 810
October 1060
November 1000
December 900
January 850
February 780
March 770
April 760
May 810
June 740
July 750
August 1125
September 1250
October 1850
November 1930
December 2100

Please show all work

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!

Q:

not sure the answer / how to work out... please answer all parts. thank you! Problem 5 - Use the data below to calculate two forecasts: 1) A 2 period Moving Average; 2) An Exponetial Smoothed...

Q:

please help!!! Problem 5 - Use the data below to calculate two Exponetial Smoothed Forecasts. The first forecast should use an alpha of 3 and the second should use an alpha of 7. For both forecasts...

Q:

please show work or formulas used, thank you! M Problem 5 - Use the data below to calculate two Exponetial Smoothed Forecasts. The first should use an alpha of 33 and the second should use an alpha...

Q:

Problem 5 - Use the data below to calculate two Exponetial Smoothed Forecasts. The first forecast should use an alpha of .3 and the second should use an alpha of 7. For both forecasts round your...

Q:

Problem 5 - Use the data below to calculate two Exponetial Smoothed Forecasts. The first should use an alpha of .2 and the second should use an alpha of 8. For both forecasts round your forecasts to...

Q:

ha brief sertence, explain 1 diiadvartage of ualee the s mele moving average ovet the weighted moving average. Imerf amsarhere: The Barbecue fBecj coinpany you work for recently Bired a niw demand...

Q:

L 3 D E G H The data sheet shows the percentage of stocks in a portfolio for nine quarters from 2019 to 2021. Use the data to complete the following tasks: 1. Construct a time series plot (line...

Q:

Use the Historical demand data below to calculate TWO forecasts. 1) 3 Period Weighted moving average using weights of .5, 3.2, with the heavier weights being used for the most recent periods, and 2)...

Q:

A 1 Year 2 3 4 5 5 7 3 Quarter Stock % 2019 1 29.8 2 31.0 3 29.9 4 30.1 2020 1 32.2 2 31.3 3 32.0 4 31.9 2021 1 30.0 LO 1 The data sheet shows the percentage of stocks in a portfolio for nine...

Q:

1 Use the Historical demand data below to calculate TWO forecasts. 1) 3 Period Weighted moving average using weights of .5,.3,.2, with the heavier weights being used for the most recent periods, and...

Q:

Suppose that the pound is pegged to gold at 6 pounds per ounce, whereas the franc is pegged to gold at 12 francs per ounce. This, of course, implies that the equilibrium exchange rate should be two...

Q:

Find a parametrization for the curve described below. the line segment with endpoints (4, -1) and (2,2) X= for 0 st 1 y=for 0sts 1

Q:

El ejercicio fiscal est comprendido entre a. El 1 de enero y el 25 de diciembre de cada ao b. Al inicio de periodo fiscal, no tiene fecha de termino c. El 1 de diciembre al 1 de enero del ao...

Q:

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...