Question: Please show work. 1) Calculate three forecasts using the following data. First, for periods 4 through 10 develop the exponentially smoothed forecasts using a forecast

Please show work. Please show work. 1) Calculate three forecasts

1) Calculate three forecasts using the following data. First, for periods 4 through 10 develop the exponentially smoothed forecasts using a forecast for period 3 (F3) of 120.0 and an alpha of 0.3. Second, calculate the three-period moving average forecast for periods 4 through 10. Third, calculate the weighted moving average for periods 4 through 10, using weights of .60, 30, and .10. Calculate the mean absolute deviation (MAD) and the cumulative sum of forecast error (CFE) for each forecasting procedure. Which forecasting procedure would you select? Why? Month 1 2 3 4 5 6 7 8 9 10 Demand 120 115 125 119 127 114 120 124 116 137

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!

Calculate three forecasts using the following data. First, for periods 4 through 10, develop the exponentially smoothed forecasts using a forecast for period 3 (F3) of 46.0 and an alpha of 0.3....

D) Calculate three forecasts using the following data. First, for periods 4 through 10, develop the exponentially smoothed forecasts using a forecast for period 3(F3) of 45.0 and an alpha of 0.4 ....

Please post excel formulas for guidance: 1) Calculate three forecasts using the following data. First, for periods 4 through 10, develop the exponentially smoothed forecasts using a forecast for...

Calculate three forecasts using the following data. First, for periods 4 through 11 , develop the exponentially smoothed forecasts using a forecast for period 3( F_3) of 120.0 and an alpha of 0.3. Sec

Calculate two forecasts using the following data. First, for periods 4 through 1 0 , develop the 3 period weighted moving average forecasts.. Second, calculate the three - period moving - average...

D) Calculate three forecasts using the following data. First, for periods 4 through 10, develop the exponentially smoothed forecasts using a forecast for period 3 ( F 3) of 45.0 and an alpha of 0.4....

Forecasting Handouts 1. The marketing department for a major retailor tracks sales and advertising expenditures each month. Data from the past nine months and regression results from the marketing...

Question #2 Month Demand 1 45 2 48 3 43 4 48 5 49 6 54 7 47 8 50 9 46 10 47 Using the table above, calculate two forecasts using the following method:- First, for periods 4 through 10, develop the...

i . First, for periods 4 through 1 0 , develop the exponentially smoothed forecasts using a forecast for period 3 ( F 3 ) of 4 5 . 0 and an alpha of 0 . 4 . ii . Calculate the weighted moving average...

Explain why an appropriation of Retained Earnings is not the same as setting aside cash. How does a corporation dispose of a Retained Earnings Appropriated account such as Retained Earnings...

40 60 A circle of 200 mm dia. is drawn on a mild steel plate before it is subjected to two mutually perpendicular stresses of 160 MPa and 40 MPa along with a shear stress of 60 MPa. After stressing,...

Mega simulator when is cash available after you take out a loan

What is an example of constructive feedback? provide reference