Calculate Forecast Spread by Existing EAC
A set of examples may help demonstrate how Cobra calculates forecast spread according to the Existing EAC method.
Scenario: Extend Dates
Assume that you have the following data:
Current Spread
- Forecast Start Date: March 31, 2023
- Forecast Finish Date: May 30, 2023
Periods | Totals | March | April | May |
ETC Hours | 50 | 10 | 30 | 10 |
Then, extend the forecast start and finish dates as follows:
- Forecast Start Date: Feb 28, 2023
- Forecast Finish Date: June 30, 2023
Periods | Total | February | March | April | May | June |
ETC Hours | 50 | 0 | 10 | 30 | 10 | 0 |
After the Calculate Forecast spread, the spread would be as follows:
Periods | Total | February | March | April | May | June |
ETC Hours | 50 | 6 | 10 | 18 | 10 | 6 |
Scenario: Shrink Dates
Assume that you have the following data:
- Forecast Start Date: Feb 28, 2023
- Forecast Finish Date: June 30, 2023
Periods | Total | February | March | April | May | June |
ETC Hours | 50 | 6 | 10 | 18 | 10 | 6 |
Then, shrink the forecast start and finish dates as follows:
- Forecast Start Date: March 31, 2023
- Forecast Finish Date: May 30, 2023
Periods | Total | February | March | April | May | June |
ETC Hours | 50 | 6 | 10 | 18 | 10 | 6 |
After the Calculate Forecast spread, the spread would be as follows:
Periods | Total | March | April | May |
ETC Hours | 50 | 2.67 | 24.57 | 2.67 |
Scenario: Shift of Dates with the Same Number of Periods for Planned Work Package
Assume that you have the following data:
- Forecast Start Date: March 31, 2023
- Forecast Finish Date: May 31, 2023
Periods | Total | March | April | May |
ETC Hours | 30 | 0 | 10 | 20 |
Then, move the forecast start and finish dates as follows:
- Forecast Start Date: April 30, 2023
- Forecast Finish Date: June 30, 2023
Periods | Total | March | April | May | June |
ETC Hours | 30 | 0 | 10 | 20 | 0 |
After the Calculate Forecast spread, the spread would be as follows:
Periods | Total | April | May | June |
ETC Hours | 30 | 0 | 10 | 20 |
How to...
Set Up a Retain EAC Forecast with the Scale EAC Option
Copy Budget to a Manual Forecast Using the Reclass Wizard
Learn more about...