Example Using Forecasting Method 1: Percent Increase of Rolling 12 Months Over Prior Rolling Months
This table lists the results of the forecast calculation based on reported sales from October 2006 to September 2007:
Month |
2006-2007 |
2007-2008 |
2008 |
Value Type |
Forecast Calculation |
---|---|---|---|---|---|
OCTOBER |
88,048 |
97,420 |
84,821 |
Reported (RPT) |
|
NOVEMBER |
88,636 |
97,355 |
RPT |
||
DECEMBER |
90,520 |
101,217 |
RPT |
||
JANUARY |
121,928 |
104,431 |
RPT |
||
FEBRUARY |
98,552 |
115,141 |
RPT |
||
MARCH |
98,155 |
122,095 |
RPT |
||
APRIL |
94,741 |
120,730 |
RPT |
||
MAY |
98,765 |
107,837 |
RPT |
||
JUNE |
106,026 |
102,469 |
RPT |
||
JULY |
105,369 |
96,900 |
RPT |
||
AUGUST |
106,312 |
103,977 |
RPT |
||
SEPTEMBER |
97,083 |
89,204 |
RPT |
||
TOTAL |
1,194,135 |
1,258,776 |
|||
PERCENT INCREASE |
5.41 percent |
||||
NOVEMBER |
102,622 |
Estimated (EST) = |
97,355 × 1.0541 |
||
DECEMBER |
106,693 |
EST = |
101,217 × 1.0541 |
By applying the forecast calculation from the previous table, determine at the sales estimate for November and December based on the sales figures for the same month in the previous year. The table also shows the percent increase in sales between the two time periods.