Question

The CEO requested forecasts based on the given historical data.  Put your final answers in the table....

The CEO requested forecasts based on the given historical data.  Put your final answers in the table.

Round answers to 3 decimals for each method. Show work for full credit.

Period

Actual Demand

3 Month Moving Average

Moving Average Tracking Signal

3 Month Weighted Average

Weighted Average Tracking Signal

1

62

X

X

X

X

2

59

X

X

X

X

3

48

X

X

X

X

4

57

56.33

59.4

5

60

54.66

54.4

6

56

55

52.83

MAD

X

X

MAPE

X

X

  1. (10 pts) Calculate simple three-month moving average forecast for periods 4-6.
  1. (10 pts) Calculate weighted three-month moving average forecast for periods 4-6. The weights are .5 for t-1, .4 for t-2. and .1 for t-3.
  1. (15 pts) Calculate the mean absolute deviation – MAD, mean absolute percent error – MAPE, and tracking signal for each of the methods above.

The CEO requested forecasts based on the given historical data.  Put your final answers in the table.

Round answers to 3 decimals for each method. Show work for full credit.

Period

Actual Demand

Single Exponential Smoothing

Single Exponential Tracking Signal

Exponential Smoothing with Trend

Smoothing with Trend Tracking Signal

1

62

60

60

2

59

3

48

4

57

5

60

6

56

MAD

X

X

MAPE

X

X

  1. (25 pts) Calculate single exponential smoothing forecast for periods 2-6. The initial forecast (F1) is 60 and an α (alpha) .40.
  1. (25 pts) Calculate exponential smoothing with trend forecast for periods 2-6.

The initial forecast with trend(F1)  of 59, and trend (T1) of  1, FIT1= 60, α (alpha) .40 and ? (delta) of .30.

  1. (15 pts) Calculate the mean absolute deviation – MAD, mean absolute percent error – MAPE, and tracking signal for each of the methods above.

Homework Answers

Answer #1

10. Using 3 period Moving Average Forecast method, the forecast would be:

F(6) = {Actual(3) + Actual(4) + Actual(5)}/3

= (52 + 80 + 79)/3

= 70.33

Using the Last Value forecast method, the forecast would be:

F(6) = Actual(5)

= 79

11. Using the exponential smoothing, the forecast would be:

F(4 Years Ago) = 0.8*Actual(5 Years Ago) + (1-0.8)*F(5 Years Ago)

= 0.8*1270 + 0.2*1200

= 1256

F(3 Years Ago) = 0.8*1060 + 0.2*1256

= 1099.2

F(2 Years Ago) = 0.8*1500 + 0.2*1099.2

= 1419.84

F(Last Year) = 0.8*1100 + 0.2*1419.84

= 1163.968

F(Next Year) = 0.8*1030 + 0.2*1163.968

= 1057 Approximately

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Your manager is trying to determine what forecasting method to use. Based upon the following historical...
Your manager is trying to determine what forecasting method to use. Based upon the following historical data, calculate the following forecast and specify what procedure you would utilize. - PLEASE show all work in Excel including formulas. a. Calculate the simple three-month moving average forecast for periods 4-12. b. Calculate the weighted three-month moving average using weights of 0.50, 0.30, and 0.20 for periods 4-12. c. Calculate the single exponential smoothing forecast for periods 2-12 using an initial forecast (F1)...
The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 28...
The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 28 2 30 3 29 4 40 5 43 6 42 7 43 8 45 9 44 10 47 a. Calculate the single exponential smoothing forecast for these data using an α of 0.20 and an initial forecast (F1) of 28. (Round your intermediate calculations and answers to 2 decimal places.) Month Exponential Smoothing 1 2 3 4 5 6 7 8 9 10 b....
In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple...
In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple moving average; 4 period weighted moving average (0.63, 0.26, 0.08, 0.03); exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53); linear regression with the equation based on all 12 periods; and quadratic regression with the equation based on all 12 periods.  Round all numerical answers to two decimal places. The actual values for 12 periods (shown in order) are: (1) 45  (2)...
The actual values for 12 periods (listed in order, 1-12). In Excel, create forecasts for periods...
The actual values for 12 periods (listed in order, 1-12). In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple moving average; 4 period weighted moving average (0.63, 0.26, 0.08, 0.03); exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53); linear regression with the equation based on all 12 periods; and quadratic regression with the equation based on all 12 periods.  Round all numerical answers to two decimal places. A. The...
For the data given below, forecast period 17 using following methods and suggest the best forecasting...
For the data given below, forecast period 17 using following methods and suggest the best forecasting model 1. Simple Moving Average (Three Period) 2. Weighted Average (50% on t-1, 30% on t-2, 20% on t-3) 3. Exponential Smoothing (α=.1), F1= y intercept from regression) 4. Exponential Smoothing (α=.3), F1= y intercept from regression) 5. Exponential Smoothing with trend (α=.3) and (δ=.3), F1= y intercept from regression)** 5. Exponential Smoothing with trend (α=.1) and (δ=.3), F1= y intercept from regression)** 6....
The table below shows the actual demand and the forecasted amounts (where available). Use this table...
The table below shows the actual demand and the forecasted amounts (where available). Use this table to answer questions. Actual Forecast 1 100 - 2 95 - 3 102 - 4 100 105 5 110 111 6 120 115 7 112 115 8 130 125 9 130 128 What is the mean absolute deviation for the forecast? 3.5 2.33 3.89 2.86 What is the mean squared error for the forecast (round to two decimal point)? 89.12 9.94 14.83 4.72 The...
The following time series shows the number of units of a particular product sold over the...
The following time series shows the number of units of a particular product sold over the past six months. Month Units Sold 1 9 2 4 3 5 4 6 5 13 6 11 ​a. Compute the three-month moving average forecast for month 4. b. Compute the three-month moving average forecast for month 5. c. Compute the three-month moving average forecast for month 6. d. Compute the mean squared error (MSE) for the three-month moving average forecasts. e. Use α...
Instructions The Data contains the actual values for 12 periods (listed in order, 1-12). In Excel,...
Instructions The Data contains the actual values for 12 periods (listed in order, 1-12). In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple moving average; 4 period weighted moving average (0.63, 0.26, 0.08, 0.03); exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53); linear regression with the equation based on all 12 periods; and quadratic regression with the equation based on all 12 periods.  Round all numerical answers to two...
Question 1 contains the actual values for 12 periods (listed in order, 1-12). In Excel, create...
Question 1 contains the actual values for 12 periods (listed in order, 1-12). In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple moving average; 4 period weighted moving average (0.63, 0.26, 0.08, 0.03); exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53); linear regression with the equation based on all 12 periods; and quadratic regression with the equation based on all 12 periods.  Round all numerical answers to two decimal...
(b) Develop the three-week moving average forecasts for this time series. (Round your answers to two...
(b) Develop the three-week moving average forecasts for this time series. (Round your answers to two decimal places.) Week Time Series Value Forecast 1 16 2 11 3 13 4 10 5 14 6 12 Compute MSE. (Round your answer to two decimal places.) MSE = What is the forecast for week 7? (c) Use α = 0.2 to compute the exponential smoothing forecasts for the time series. Week Time Series Value Forecast 1 16 2 11 3 13 4...