Question: 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

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 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	Demand
1	120
2	115
3	125
4	119
5	127
6	114
7	120
8	124
9	116
10	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!

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 for period 3 (F3) of 120.0 and...

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

Using any Forecasting Software, solve following problems. In preparing your homework, show the steps of the solution supported by screenshots . I NEED THE SOLVING ON PAPER AND EXCEL PLEASE Calculate...

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

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

The following unrelated events are typical of those experienced by business entities: 1. Pay cash for operating expenses. 2. Pay an office manager's salary with cash. 3. Receive cash for services...

Table 12-1 Count Sequence of 3-bit synchronous counter Q Q

A Choose three biometric technologies, explain them, and provide an example of a criminal investigation in which they might be used. Use the editor to format your

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...