Skip to Main Content
Status Future consideration
Created by Guest
Created on Apr 6, 2021

Forecast spread

Forecast spread

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

  • Attach files