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