When the project starts the forecast cost is spread according to the start/end dates and forecast method selected
Linear 01/01/2021 30/06/2021
Original forecast
Period |
01/21 |
02/21 |
03/21 |
04/21 |
05/21 |
06/21 |
Forecast |
1000 |
1000 |
1000 |
1000 |
1000 |
1000 |
Actual |
|
|
|
|
|
|
Once the project receives actual costs.
The user must be given an option what to do with the difference between forecast and actual cost.
Example
The actual cost for period 01/21 is $500.
Period |
01/21 |
02/21 |
03/21 |
04/21 |
05/21 |
06/21 |
Forecast |
1000 |
1000 |
1000 |
1000 |
1000 |
1000 |
Actual |
500 |
|
|
|
|
|
Difference |
500 |
|
|
|
|
|
Option 1
Move remaining forecast to next period.
Period |
01/21 |
02/21 |
03/21 |
04/21 |
05/21 |
06/21 |
Forecast |
0 |
1500 |
1000 |
1000 |
1000 |
1000 |
Actual |
500 |
|
|
|
|
|
Difference |
500 |
|
|
|
|
|
Option 2
Spread remaining forecast to “Select” no of periods.
Period = 2
Period |
01/21 |
02/21 |
03/21 |
04/21 |
05/21 |
06/21 |
Forecast |
0 |
1250 |
1250 |
1100 |
1000 |
1000 |
Actual |
500 |
|
|
|
|
|
Difference |
500 |
|
|
|
|
|
Option 3
spread remaining forecast to “end of date range”.
Period |
01/21 |
02/21 |
03/21 |
04/21 |
05/21 |
06/21 |
Forecast |
0 |
1100 |
1100 |
1100 |
1100 |
1100 |
Actual |
500 |
|
|
|
|
|
Difference |
500 |
|
|
|
|
|