Skip to content
Tutorials Center
My learning

Topics

Lesson 35 of 41 ยท Tools and Reporting

Monitoring, Control and Status Reporting

Monitor and control a project: KPIs, RAG status, status reports, milestone tracking, earned value indicators SPI and CPI, forecast at completion and dashboards, with Python.

Planning is a guess; monitoring and controlling is how you find out how wrong the guess is, while there is still time to act. Monitoring means collecting and checking data about progress. Controlling means comparing it with the baseline and deciding on corrective or preventive action. The two go together, and they run in a loop from the first day until closure.

flowchart LR
  M["Measure progress"] --> C["Compare with baseline"]
  C --> A["Analyze variances"]
  A --> D["Decide action"]
  D --> I["Implement change"]
  I --> M

Data without a decision is just paperwork.

What to measure

Choose a few key performance indicators (KPIs) that cover each dimension of the project. Too many metrics hide the signal.

Dimension Example indicators
Schedule Milestones met, tasks late, schedule variance
Cost Spend versus budget, forecast to finish
Scope Work completed (percent), change requests approved
Quality Defects open, test pass rate, rework
Risk Open high risks, risks triggered
Team and stakeholders Satisfaction, blockers, turnover

A good indicator is a leading one (predicts trouble, like growing bug count or tasks not started on time) as well as lagging ones (report outcomes, like total cost). Prefer measures that cannot be gamed. "Percent complete" is notoriously easy to fake; "work items done to the Definition of Done" is harder.

RAG status

Most status reports use a Red-Amber-Green signal per dimension.

  • Green: on track, within tolerance.
  • Amber: at risk; the manager has a recovery plan and does not yet need help.
  • Red: off track; needs a decision or escalation.

Define thresholds in advance (for example, amber when cost variance exceeds 5 percent, red above 10 percent) so colors are not opinions. A project that is always green is not necessarily healthy; it may mean bad news is hidden. "Watermelon" projects, green outside and red inside, are a classic reporting failure.

Earned value indicators

Earned value management (EVM) gives schedule and cost performance in comparable money terms. Three base values:

  • PV (planned value): budgeted cost of work scheduled to be done by now.
  • EV (earned value): budgeted cost of work actually completed.
  • AC (actual cost): what you really spent.

From them:

TEXT
SV  = EV - PV      (schedule variance: negative = behind)
CV  = EV - AC      (cost variance: negative = over budget)
SPI = EV / PV      (schedule performance index: below 1 = behind)
CPI = EV / AC      (cost performance index: below 1 = over budget)

Forecasts: BAC is the original total budget, EAC (estimate at completion) is the expected total cost. If the current cost trend will continue, EAC = BAC / CPI. ETC (estimate to complete) is EAC - AC, and VAC (variance at completion) is BAC - EAC.

Python Earned value report

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

The CPI of 0.82 says that each currency unit spent has produced 0.82 units of planned value. Unless something changes, the project will end about 22 percent over budget. A TCPI far above 1 tells you that to finish on budget the team would need to work much more efficiently than it has so far, which is unlikely; time to reforecast and talk to the sponsor.

A status report people read

A good status report fits one page, is sent at the same time each period, and is written for decisions.

  1. Summary: overall RAG and one-sentence reason.
  2. Progress: done since last report, planned next.
  3. Milestones: baseline date, forecast date, status.
  4. Budget: spent, forecast, variance.
  5. Top risks and issues: owner, action, date.
  6. Decisions or help needed: a short list with a deadline.
Python Generate a one-page status report

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Milestone trend

Track the forecast date of each milestone report after report. A milestone whose forecast moves later each week while the report says "green" is a warning. A trend chart (a milestone trend analysis) plots baseline date on one axis and reporting date on the other; a line that rises means slipping.

Python Milestone slippage trend

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Control actions

When data shows a deviation, choose among:

  • Corrective action: bring performance back to plan (add people to a non-critical-path task, reduce rework, fix a blocker).
  • Preventive action: reduce the chance of future deviation (training, early testing).
  • Change request: if the baseline itself must change (see change control).
  • Escalation: when the issue exceeds your authority or tolerance.

For schedule recovery, two classic techniques are crashing (add resources, spending money to save time on the critical path) and fast tracking (do tasks in parallel that were sequential, accepting more risk and rework). Both only help on the critical path.

In agile projects

The same loop exists, with different measures: burndown and burnup, velocity trend, cycle time, cumulative flow, defect trend, and the product increment itself. The sprint review is the monitoring event, and a visible board is the status report. See sprint planning and burndown and Kanban.

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. EV = 90,000, PV = 100,000 and AC = 95,000. What is the SPI?

    SPI = EV / PV = 90,000 / 100,000 = 0.90, so the project is behind schedule.
  2. 2. With BAC = 300,000 and CPI = 0.75, what is EAC if the trend continues?

    EAC = BAC / CPI = 300,000 / 0.75 = 400,000.
  3. 3. A project's status is always green, but milestone forecasts slip every week. This is called:

    Trend data contradicts the reported color, so the reporting hides real problems.
  4. 4. Fast tracking means:

    Fast tracking overlaps tasks, saving time at the price of more risk and rework.

Summary

  • Monitoring and controlling is a loop: measure, compare, analyze, act.
  • Use a few leading and lagging KPIs and define RAG thresholds beforehand.
  • Earned value gives SV, CV, SPI, CPI, and forecasts EAC, ETC, VAC and TCPI.
  • A status report is one page, regular and decision-oriented; watch milestone trends.
  • Respond with corrective or preventive actions, change requests or escalation; crash or fast track only on the critical path.

Next: Project Leadership