/
/
Compare crew production rates on one cost code across jobs
For operations leads and estimators who want to compare budgeted and actual production rates for a cost code across projects, asking their AI assistant.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
The problem
Productivity comparisons end up in spreadsheet formulas
To compare crew productivity on the same work across jobs you export reports and build rate maths by hand. Zero quantities break the formulas, and a rate based on very little work looks like a trend.
Without PopdockAI
- Export the field production report for the cost code
- Divide hours by quantity for budgeted and actual
- Work around rows with zero quantity
- Rank the jobs and guess which numbers to trust
With PopdockAI
- Rows for the cost code are read across projects
- Budgeted and actual rates are worked out with the unit stated
- Zero quantity rows are skipped and listed
- Projects are ranked, with thin data flagged
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Compare how productivity on cost code {cost-code} differs across projects, optionally limited to projects whose name contains {project-name-contains}.
**Step 1: Pull the rows**
Call procore-get-field-production-report with cost-code set to {cost-code}. If {project-name-contains} is given, pass it as project-name.contains. If {company} is given, pass it as company.
**Step 2: Work out rates**
* Budgeted rate is udgeted-hours divided by udgeted-quantity; actual rate is ctual-hours divided by ctual-quantity. State the unit-of-measure.
* Skip rows with zero quantity and list them separately.
* Ratio of actual rate to budgeted rate above 1 means slower than planned.
**Step 3: Report**
A table by project-name with budgeted rate, actual rate, ratio and percent-complete, sorted slowest first. Add a short note on the spread between best and worst projects and which rates are based on little completed work.
**Rules & Guidelines:**
* This is a read-only job. procore-get-field-production-report is the only tool; never attempt to change any Procore record.
* Quote figures exactly as returned; do not invent hours or quantities that are not in the rows.
**Validation:**
* If the read returns no rows, say so, list the filters used, and suggest loosening them.
* If a field is blank or zero (for example budgeted hours of 0), note it and exclude it from ratios instead of dividing by it.Who it's for
One answer, three teams that use it
Operations managers
See which crews are slow
Rank projects by how far actual production is from budget on a cost code, so support goes where the gap is largest.
Which projects are slowest against budget on cost code 05-120?
Estimators
Update your rates with real data
Check how actual production compares with budget on completed work, before you price the next bid on the same cost code.
Show budgeted and actual production rates for cost code 09-250 across our projects.
Project controls analysts
Trust the numbers you report
Find the rates built on little completed work so they are not mistaken for performance in the monthly report.
For cost code 03-300, which projects have a rate based on less than 10 percent complete?
How it works
What PopdockAI does when you ask
You name the cost code. Your AI assistant works out the rates from the field production rows and ranks the projects, and never changes a record.
Ask
You give a cost code, and optionally part of a project name or a company.
Read
It reads the field production rows for that cost code across projects.
Calculate
It works out budgeted and actual rates and their ratio, skipping rows with no quantity.
Report
You get a table by project, slowest first, with a note on the spread and weak rates.
What PopdockAI provides
The tools behind the answer
Ready made tools for Procore and one secure connection to your AI tool. No code, no exports.
procore-get-field-production-report
This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.
The outcome
A fair comparison of the same work on every job
Related use cases
More ways to put this data to work
One prompt template with infinite possibilities.
Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.
Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.

.webp)
