MIP FAQs: MIP Dashboard

1. We are working on a project in a particular county, but it does not seem to be present on the Project Dashboard on the MIP. Could you investigate?
2. Please explain the CPI calculation for the color coding in the project dash board. There are three colors that result as the CPI varies. I would like to understand what the desired scores are and what scores result in what colors.
3. Please clarify how the dashboard schedule indices are computed over time. After all of the data development tasks are completed, and all reported greater than 20% late, but the preliminary map is issued on schedule, will the lights re-set and reflect the preliminary map issuance schedule satisfaction, green? Or would the dashboard continue to reflect poor health (red) over the life of the project - if all of the data development tasks are done late, but the preliminary map and effective map are completed on schedule?

1.  We are working on a project in a particular county, but it does not seem to be present on the Project Dashboard on the MIP. Could you investigate?

Studies projects do not appear on the Dashboard until they have completed the Scoping task. Since the Cost Performance Index (CPI) and Schedule Performance Index (SPI) for a project are calculated as the average of the CPI and SPI from all associated tasks with cost and schedule information, nothing will be calculated for a project until at least the Scoping task is complete.

Back to top

2. ‘Please explain the CPI calculation for the color coding in the project dash board. There are three colors that result as the CPI varies. I would like to understand what the desired scores are and what scores result in what colors.

Tolerances

The following are the tolerances currently set for the study project status indicators:

SPI:

Green: 0.95 <= SPI <= 1.05

Yellow: 0.90 <= SPI < 0.95 or 1.05 < SPI <= 1.10

Red: SPI < 0.90 or SPI > 1.10

CPI:

Green: 0.95 <= CPI <= 1.05

Yellow: 0.90 <= CPI < 0.95 or 1.05 < CPI <= 1.10

Red: CPI < 0.90 or CPI > 1.10

Health Indicator

The Health Indicator is a combined status of the other two indicators.

The overall health status is determined by combining the CPI status and SPI status as indicated in the table below:

Composite Status Indicators

For the composite status of study projects for a geographic area (e.g. region, state, county), the composite values will be calculated by summing up the budgeted and actual cost and schedule information for each task in the project in the selected area and then calculating CPI and SPI.

Rules for SPI and CPI Calculations

The following provides rules for the earned value calculations used to determine the study dashboard status indicators, CPI and SPI.

The following are the formulas used for CPI and SPI:

CPI (Cost Performance Index) = BCWP / ACWP

Where:

BCWP (Budgeted Cost of Work Performed) = Activity Baseline Budgeted Cost x Physical % of Work Actually Completed
(Assumes level load over activity duration)

ACWP (Actual Cost of Work Performed) = Actual Cost to Date

SPI (Schedule Performance Index) =  BCWP / BCWS

Where:

BCWP (Budgeted Cost of Work Performed) = Task Baseline Budgeted Cost x Physical % of Work Actually Completed

(Assumes level load over activity duration)

BCWS (Budgeted Cost of Work Scheduled) = Task Baseline Budgeted Cost x (Days Since Baseline Task Start/ Total Duration of the Task in Days)

Back to top

3. Please clarify how the dashboard schedule indices are computed over time. After all of the data development tasks are completed, and all reported greater than 20% late, but the preliminary map is issued on schedule, will the lights re-set and reflect the preliminary map issuance schedule satisfaction, green? Or would the dashboard continue to reflect poor health (red) over the life of the project - if all of the data development tasks are done late, but the preliminary map and effective map are completed on schedule?

The current design and implementation of the dashboard uses all tasks, whether completed, in progress, or not yet started, to determine the overall project status. So in the case that a data development task was very behind schedule but was eventually completed and the prelim and post prelim tasks are on schedule, the project will still display that the project is at risk because of those completed yet delayed data development tasks.

Back to top