Project Status Reporting Agent
Writes weekly status reports for capital projects and turnarounds and explains slips.
- Industry
- Oil & Gas
- Department
- Management
- Team
- Project Delivery
- Kind
- Investigator
- Approver
- Asset Manager
- Code
- MGT-06
It writes the weekly status report for capital projects, well campaigns and turnarounds from the schedule, cost against AFE, HSE statistics and risks, and sets the RAG by the reporting standard. When a project slips or overspends it works out why from the evidence, such as late long-lead equipment, weather, rig performance or scope growth, and names the recovery action. **The problem it solves:** Why the project is off track: which milestones or costs have moved from baseline or AFE, by how much, since when, and what changed in that period on site, in the supply chain or in scope.
How it works
6 steps, and a person signs off before step 6.
- 01Looks it up
Finds the record the request is about in the ERP's finance, maintenance and supply modules: the AFE, actual and committed cost, baseline and forecast milestone dates and long-lead purchase order status for the project and week named..
- 02Reads the request
Works out what is being asked and what a complete answer needs.
- 03Checks the facts
Checks figures, dates and rules against the source records, not from memory.
- 04Works it through
Weighs competing explanations against the evidence and shows which one holds up.
- 05Asks a person
Hands the work to Asset Manager with its reasoning before anything goes out.
- 06Acts
Once approved, it acts in the ERP's finance, maintenance and supply modules: it publishes the weekly status report to the project record and updates its RAG status. and records what was done.
What it works with
Your knowledge, your systems, your people.
Knows
The project reporting standard: RAG definitions for schedule, cost against AFE, HSE and scope, the report template, the audiences including joint-venture partners, and the variance thresholds.
Reads from
the ERP's finance, maintenance and supply modules: the AFE, actual and committed cost, baseline and forecast milestone dates and long-lead purchase order status for the project and week named.
Acts in
the ERP's finance, maintenance and supply modules: it publishes the weekly status report to the project record and updates its RAG status.
Hands back
An object with overall (green, amber or red), dimensions (an object with schedule, cost, hse and scope, each with rag and reason), variances (a list, each with item, planned, forecast, variance and cause), causes (a ranked list, each with cause, evidence, confidence and how_to_confirm), recovery_actions (a list, each with step, owner and due), hse_summary (man_hours, recordables, process_safety_events) and next_week (a list).
Asks a person when
The overall status is red or worse than last week, HSE is red, a red is caused by a contractor or a partner, cost is red and needs a supplementary AFE, or the report goes to joint-venture partners.
Settings
Your limits, set by your managers.
| Setting | Default | What it controls |
|---|---|---|
| Slip that makes schedule amber (days) | 7 | A milestone forecast this many days or more after baseline makes the schedule amber. |
| Slip that makes schedule red (days) | 21 | A milestone forecast this many days or more after baseline makes the schedule red. |
| Forecast over AFE that makes cost amber (%) | 5 | A forecast at completion this far over the AFE makes cost amber. |
| Forecast over AFE that makes cost red (%) | 10 | A forecast at completion this far over the AFE makes cost red and needs a supplementary AFE. |
| Publish on | Friday | The day the weekly report is published. |
| Cost detail shown to JV partners | AFE totals only | How much cost detail a report for joint-venture partners carries. |
Limits are settings, not code: a manager changes them without a developer.
Rules it always follows
- Schedule is amber at a slip of 7 days and red at 21 days; cost is amber at 5 percent over AFE and red at 10 percent.
- HSE is red for any recordable injury, process-safety event or high-potential incident in the period, whatever the other dimensions say.
- The overall status is the worst of schedule, cost, HSE and scope; never report green over a red dimension.
- For every amber or red, give the cause the evidence supports (long-lead delivery, weather or window, rig or contractor performance, scope growth, permits, or estimate), how sure it is, and a recovery action with an owner and date.
- Never state the cause of an HSE incident; refer to the investigation by its reference.
- A report for joint-venture partners carries cost at AFE totals only level, and reports publish on Friday.
See the Project Status Reporting Agent agent on your own work.
We’ll run it on a sample of your work and show you what your approver would see.