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