Projected measure for the next 3 months (calculated as adjusted linear trend based on the first 3 months of the period).
Calculation
-
Projected measure for the particular month = linear trend for the particular month * Seasonality Adjustment
-
Seasonality Adjustment = (measure for the (particular month - 12 months) ) / Average of the value for the last 12 months) -
If the projected value is negative, then we return 0 instead.
-
measure = Number of Transactions, Margin or Revenue
Example
Revenue Projection Calculation
|
regressionFactor |
|
|
|
|
|
|
|---|---|---|---|---|---|---|
|
Slope |
161.24 |
|
|
|
|
|
|
interception |
-310.7 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Month |
Revenue |
Seasonality Adjustment |
regression |
Projected Revenue |
|
|
|
1 |
Jan-21 |
100 |
|
|
|
|
|
2 |
Feb-21 |
150 |
|
|
|
|
|
3 |
Mar-21 |
200 |
|
|
|
|
|
4 |
Apr-21 |
150 |
|
|
|
|
|
5 |
May-21 |
300 |
|
|
|
|
|
6 |
Jun-21 |
200 |
|
|
|
|
|
7 |
Jul-21 |
100 |
|
|
|
|
|
8 |
Aug-21 |
80 |
|
|
|
|
|
9 |
Sep-21 |
350 |
|
|
|
|
|
10 |
Oct-21 |
500 |
|
|
|
|
|
11 |
Nov-21 |
600 |
|
|
|
|
|
12 |
Dec-21 |
650 |
|
|
|
|
|
13 |
Jan-22 |
|
0.36 |
1,785.42 |
633.88 |
|
|
14 |
Feb-22 |
|
0.53 |
1,946.66 |
1,036.68 |
|
|
15 |
Mar-22 |
|
0.71 |
2,107.90 |
1,496.73 |
|
|
|
|
|
|
|
|
|
|
==> Average Value |
281.6667 |
|
|
|
|