For each job over budget, breaks down which cost category is driving it — labor, materials, or subs — and shows how far over you are in dollars and percent.
Using my Knowify data, pull all active jobs where actual costs (sum of LaborCommitted, MaterialsCommitted, SubsCommitted) exceed the BudgetTotal. For each overrun job, break down which cost category — labor, materials, or subcontractors — is driving the overrun. How far over are we, in dollars and percent? Help me understand what’s causing the problem on each job.