Which method used when demand is assumed to have level and trend in the systematic component of demand but no seasonality?

This method calculates a trend, a seasonal index, and an exponentially smoothed average from the sales order history. The system then applies a projection of the trend to the forecast and adjusts for the seasonal index.

This method requires the number of periods best fit plus two years of sales data, and is useful for items that have both trend and seasonality in the forecast. You can enter the alpha and beta factor, or have the system calculate them. Alpha and beta factors are the smoothing constant that the system uses to calculate the smoothed average for the general level or magnitude of sales (alpha) and the trend component of the forecast (beta).

This method is similar to Method 11, Exponential Smoothing, in that a smoothed average is calculated. However, Method 12 also includes a term in the forecasting equation to calculate a smoothed trend. The forecast is composed of a smoothed average that is adjusted for a linear trend. When specified in the processing option, the forecast is also adjusted for seasonality.

Forecast specifications:

• Alpha equals the smoothing constant that is used in calculating the smoothed average for the general level or magnitude of sales.

  Values for alpha range from 0 to 1.

• Beta equals the smoothing constant that is used in calculating the smoothed average for the trend component of the forecast.

  Values for beta range from 0 to 1.

• Whether a seasonal index is applied to the forecast.

Minimum required sales history: One year plus the number of time periods that are required to evaluate the forecast performance (periods of best fit). When two or more years of historical data is available, the system uses two years of data in the calculations.

Method 12 uses two Exponential Smoothing equations and one simple average to calculate a smoothed average, a smoothed trend, and a simple average seasonal index.

An exponentially smoothed average:

At = α (Dt/St-L) + (1 - α)(At-1 + Tt-1)

An exponentially smoothed trend:

Tt = β (At - At-1) + (1 - β)Tt-1

A simple average seasonal index:

The forecast is then calculated by using the results of the three equations:

Ft+m = (At + Ttm)St-L+m

where:

• L is the length of seasonality (L equals 12 months or 52 weeks).

• t is the current time period.

• m is the number of time periods into the future of the forecast.

• S is the multiplicative seasonal adjustment factor that is indexed to the appropriate time period.

  This table lists history used in the forecast calculation:

  Calculation of Linear and Seasonal Exponential Smoothing, given alpha = 0.3, beta = 0.4

Initializing the Process:

January of past year 1 Seasonal Index, S1 =

S1 = (125 + 128 / 1534 + 1514) × 12 = 0.083005 × 12 = 0.9961

January of past year 1 Smoothed Average*, A1 =

A1 = (January of past year 1 Actual) / (January Seasonal Index)

A1 = 128 / 0.9960

A1 = 128.51

January of past year 1 Smoothed Trend*, T1 =

T1 = 0 insufficient information to calculate first smoothed trend

February of past year 1 Seasonal Index, S2 =

S2 = (123 + 117 / 1534 + 1514) × 12 = 0.07874 × 12 = 0.9449

February of past year 1 Smoothed Average, A2 =

A2 = α(D2 / S2) + (1 – α) (A1 + T1)

A2 = 0.3(117 / 0.9449) + (1 – 0.3) (128.51 + 0) = 127.10

February of past year 1 Smoothed Trend, T2 =

T2 = β(A2 - A1) + (1 - β)T1

T2=0.4 (127.10 – 128.51) + (1 – 0.4) × 0 = –0.56

March of past year 1 Seasonal Index, S3 =

S3 = (115 + 115 / 1534 + 1514) × 12 = 0.07546 × 12 = 0.9055

March of past year 1 Smoothed Average, A3 =

A3 = α(D3/S3) + (1 – α)(A2 + T2)

A3 = 0.3 (115 / 0.9055) + (1 – 0.3)(127.10 – 0.56) = 126.68

March of past year 1 Smoothed Trend, T3 =

T3 = β(A3 –A2) + (1 – β)T2

T3 = 0.4(126.68 – 127.10) + (1 – 0.4) x – 0.56 = – 0.50

(Continue through December of past year 1)

December of past year 1 Seasonal Index, S12 =

S12 = (133 + 137 / 1534 + 1514) × 12 = 0.08858 × 12 = 1.0630

December of past year 1 Smoothed Average, A12 =

A12 = α (D12/S12)+ (1 – α)( A11 + T11)

A12 = 0.3 (137/1.0630 ) + ( 1 – 0.3)( 124.64 – 1.121 ) = 125.13

December of past year 1 Smoothed Trend, T12 =

T12 = β (A12 – A11) + (1 – β)T11

T12 = 0.4 (125.13 – 124.64)+ ( 1 – 0.4) x – 1.121 = – 0.477

Calculation of linear and seasonal exponentially smoothed forecast is calculated as follows:

F t + m = (At +Tt m )St – L + m

* Calculations for Exponential Smoothing with Trend and Seasonality are initialized by setting the first smoothed average equal to the deseasonalized first actual sales data. The trend is initialized at zero for the first iteration. For subsequent calculations, alpha and beta are set to the values that are specified in the processing options.

This table indicates the Exponential Smoothing with Trend and Seasonality forecast for next year, where alpha = 0.3, beta = 0.4: