Provide description of how project delays and budget use are measured in the data

[vob2]

I created a team for us on Github. The hope is that this automates some of the communication and notification features.

[vibhuti6]

Here's an example of how delays and budget use can be calculated from the dataset.

The Department of Transportation awarded an R&D contract to Science Applications International Corporation. A brief summary of this contract is as follows:

We observe a timestamped record of each modification made to this project's budget and completion date. We also have a text description outlining the reason for each modification.

Delays

This project's initial completion date was Dec 1, 2015. It was extended several times and the eventual completion date was June 30, 2018. In the screenshot below, 'action_date' denotes the timestamp, and 'period_of_performance_current_end_date' represents the deadline corresponding to it.

Here are the reasons for each of these five modifications:

Cost overruns

Calculating the change in budget is a little tricky. But here's one way of doing it. We have the following two columns (and their definitions from the data dictionary) in the dataset: 1) BaseAndExercisedOptionsValue: The change (from this transaction only) to the current contract value 2) CurrentTotalValueOfAward: Total amount obligated to date on an award. For a contract, this amount includes the base and exercised options.

For the project under consideration, we observe the following changes to these variables:

This indicates that the project's initial budget was $1,018,765 and another $125,997.54 was added along the way.