Question: Using ExcelQM, calculate three forecasts using the following data. First, for periods 4 through 10, develop the exponentially smoothed forecasts using a forecast for period

Using ExcelQM, 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. 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 70,.20, and .10, with 0.70 applied to the most recent data. 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 Demand 146 148 143 148 49 150 146 147

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!

MGMT 330 Chapter 12 Problems #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)...

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....

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....

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 120.0 and an alpha of 0.3....

#2) 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....

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...

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 ( F 3) of 120.0 and an alpha of 0.3....

When would it be appropriate to shortcut the chain of command when seeking approval for a decision?

Applying the principles of the Integrated Information Response Model (see Figure 8.3), which response pattern did they usehigh involvement, low involvement, or continual switching?

On the left are a series of Control Activities commonly used in Accounting. On the right, identify the control activity as either preventative or detective. Prompt 1 Segregating duties between the...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...