Example of Forecasting for the Reporting Period Only

In this example, you want to generate an estimate for the month of June only. This table lists the results:

Month

Seasonality

Sales 2007

Sales 2008

Sales Estimate

JANUARY

8.2192

30,000

40,000

FEBRUARY

6.8493

25,000

35,000

MARCH

5.4795

20,000

25,000

APRIL

7.6712

28,000

MAY

8.2192

30,000

JUNE

9.5890

35,000

43,749.43

The projected sales for June are calculated as follows:

Sales Estimate (June) = 0.095890 × (25,000 ÷ 0.054795 + 0 + 0) ÷ 1

0.095890 × 456,246.01 = 43,749.43