Question

In: Operations Management

Calculate exponential smoothing forecast for these data using an α of 0.7 and an initial forecast...

Calculate exponential smoothing forecast for these data using an α of 0.7 and an initial forecast (F1) of 18 ), or Exponential Smoothing with Trend (use optimal α and δ,

Past Months Cinnamon Buns
1 18
2 17
3 19
4 19
5 22
6 23
7 23
8 25
9 24
10 26
11 27
12 28
13 29
14 31
15 33
16 30

Solutions

Expert Solution

EXPONENTIAL SMOOTHING

FORECAST = F(T-1) + (ALPHA * (A(T-1) - F(T-1)), A = ACTUAL DEMAND, F = FORECAST, (T-1) = PREVIOUS PERIOD

FORECAST 2 = 18 + (0.7 * (18 - 18) = 18

FORECAST 3 = 18 + (0.7 * (17 - 18) = 17.3

FORECAST 4 = 17.3 + (0.7 * (19 - 17.3) = 18.49

FORECAST 5 = 18.49 + (0.7 * (19 - 18.49) = 18.85

FORECAST 6 = 18.85 + (0.7 * (22 - 18.85) = 21.06

FORECAST 7 = 21.06 + (0.7 * (23 - 21.06) = 22.42

FORECAST 8 = 22.42 + (0.7 * (23 - 22.42) = 22.83

FORECAST 9 = 22.83 + (0.7 * (25 - 22.83) = 24.35

FORECAST 10 = 24.35 + (0.7 * (24 - 24.35) = 24.11

FORECAST 11 = 24.11 + (0.7 * (26 - 24.11) = 25.43

FORECAST 12 = 25.43 + (0.7 * (27 - 25.43) = 26.53

FORECAST 13 = 26.53 + (0.7 * (28 - 26.53) = 27.56

FORECAST 14 = 27.56 + (0.7 * (29 - 27.56) = 28.57

FORECAST 15 = 28.57 + (0.7 * (31 - 28.57) = 30.27

FORECAST 16 = 30.27 + (0.7 * (33 - 30.27) = 32.18

FORECAST 17 = 32.18 + (0.7 * (30 - 32.18) = 30.65

Do leave a like for the answer if you found it helpful.


Related Solutions

Using exponential smoothing with α of 0.1 and the given forecast for year 1
As you can see in the following table, demand for heart transplant surgery at Washington General Hospital has increased steadily in the past few years: Year12345Heart Transplants46.048.055.057.057.0The director of medical services predicted 6 years ago that demand in year 1 would be 42.0 surgeries a) Using exponential smoothing with α of 0.1 and the given forecast for year 1, the forecasts for years 2 through 6 are (round your responses to one decimal place): Year123456Forecast42.0For the forecast made using exponential smoothing with α...
Question: Use the first-order exponential smoothing model with α = 0.2 to forecast for these data...
Question: Use the first-order exponential smoothing model with α = 0.2 to forecast for these data and for the first six months of the third year. Compute MSD/E, MAD, MAPE, and Bias. Month (t) Demand A(t) 1 148 2 125 3 78 4 53 5 25 6 29 7 9 8 68 9 84 10 110 11 147 12 120 13 147 14 109 15 96 16 70 17 42 18 36 19 34 20 28 21 71 22 102...
a. Show the naive forecast, an exponential smoothing forecasts using α = 0.2, and a 3-month moving average forecast.
Month137244335450534630750829936103511411245a.  Show the naive forecast, an exponential smoothing forecasts using α = 0.2, and a 3-month moving average forecast.b. Compare the MFE, MSE, and MAPE on the modelsc.  Make a conclusion on which model to use.d. Find the alpha (smoothing constant) that minimizes the MSE.
Problem 1: An organization is considering to generate forecast for April using exponential smoothing method (smoothing...
Problem 1: An organization is considering to generate forecast for April using exponential smoothing method (smoothing constant α =0.3) and the 2-period moving average technique. The actual sales are given in the table for January, February, March. The forecast for January using exponential smoothing method and the forecast for January and February using 2-period moving average technique are provided as well: Period Actual sales Forecast using Exponential Smoothing with α =0.3 Forecast using Simple 2-Period Moving Average Jan 50 60...
Given the following data, use exponential smoothing with a = 0.3 and α =.5 to develop...
Given the following data, use exponential smoothing with a = 0.3 and α =.5 to develop a demand forecasts for period 7.  Assume that the forecast for week 1= 19. Use the Mean Absolute Percent Error to determine which forecasts are more accurate. Period 1 2 3 4 5 6 Demand 17 19 15 19 13 18
Generate one step ahead forecast using simple exponential smoothing(SES), using alfa= 0.80. Calculate RMSE, MAE, and...
Generate one step ahead forecast using simple exponential smoothing(SES), using alfa= 0.80. Calculate RMSE, MAE, and MAPE. Please explain how to do this in excel. Notes: In the case of SES: a. uses the actual value of day one (18,085.45) as initial of value (starting value) of the forecast for 9/9/16 and calculate forecasts for day 2 to day 20. b. In process of calculating RMSE, MAE, and MAPE (after you generate forecast for day 2 to day 20) ignore...
What is this year's forecast using exponential smoothing with alpha = .4, if last year's smoothed forecast was 2600?
The dean of a school of business is forecasting total student enrollment for this year's summer session classes based on the following historical data:Four years ago 2000There years ago 2200Two years ago 2800Last year 3000What is this year's forecast using exponential smoothing with alpha = .4, if last year's smoothed forecast was 2600?A. 2,600B. 2,760C. 2,800D. 3,840E. 3,000
Determine the seventh projection of the following process variable data: Using Exponential Smoothing (α= 2/n+1) Actual...
Determine the seventh projection of the following process variable data: Using Exponential Smoothing (α= 2/n+1) Actual Results 100 123 140 110 150 105
What is the formula for a two step ahead exponential smoothing forecast?
What is the formula for a two step ahead exponential smoothing forecast?
a) Use α = 0.2 to compute the exponential smoothing forecasts for the time series.
Consider the following time series data. Week 1 2 3 4 5 6 Value 18 11 13 10 14 12 a) Use α = 0.2 to compute the exponential smoothing forecasts for the time series. Week Time Series Value Forecast 1 18 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? (Round your answer to two...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT