Operations / Job Costing · Meridian Construction
Demo · synced 3 min ago Blind mode AP

Active jobs · Q1 2026

Live P&L across your portfolio. Margin captured upstream of invoicing.
Unbilled value · captured
$47,283
Across 23 events, Q1. +$12,140 surfaced this week.
Active jobs
8
6 on track · 2 at risk
Margin alerts · open
23
4 critical · 12 review · 7 info
Avg margin delta
−2.4%
vs 18% target, Q1 · trending ↓
All · 8 On track · 5 At risk · 2 Critical · 1 Complete · 2
Job Customer Start Billed Unbilled Margin Trend Status
Demo note. Click any row to drill into rate variance, timeline, and crew. J-4521 Sanderson Pad 14 is the hero drill-down — $4,875 in rate variance captured before invoicing.
Back to jobs

Sanderson Pad 14

J-4521 · Started Feb 3, 2026 · Weld County, CO
Sanderson Energy
Margin · live
6.1%
Target 18% · −11.9pp
Unbilled · captured
$4,875
Rate variance + 3rd-party markup delta · 6 line items
Billable hrs
1,124 / 1,340
84% complete · burn pace tracking +4.2%
Rate variance 6
Hours & fuel
Timeline 9
Crew 7
Line item Meridian rate MSA ceiling Δ Hrs / qty $ impact Note
Captured unbilled · J-4521 −$4,875
Paul's Apr 16 observation: Superintendent billed $55/hr but P66 MSA ceiling is $62.50/hr. 168 hrs × $7.50 = $1,260 left on the table — surfaced before QuickBooks close.

Margin alerts

Real-time exceptions, surfaced as rules fire. 23 open across 8 active jobs.
All · 12 Rate variance · 5 Unauthorized use · 2 Hours/fuel · 2 Mapping · 1 Other · 2
Rules firing here: 123 MSA rules, 10 business rules, 34 item mappings. Paul's Apr 12 rules tab shipped — browsable + searchable behind Rules tab on the sidebar.

Benchmarks · J-4521 Sanderson Pad 14

Compared against 4 historically similar jobs. Pattern recognition and recommendations.
Job Pad cycle Days Margin Fuel / rev Unbilled captured
J-4521 (current) Sanderson Pad 14 68 6.1% 2.0% $4,875
J-4455 Sanderson Pad 13 73 15.2% 1.6% $1,820
J-4401 Sanderson Pad 12 69 17.4% 1.4% $980
J-4388 Sanderson Pad 11 71 18.1% 1.3% $1,140
J-4302 Sanderson Pad 10 74 16.8% 1.5% $2,410

Performance vs historical cohort

Margin Schedule Rate eff. Fuel eff. Crew util.
Cohort avg (Pads 10-13) J-4521 (current)
Pattern detected
Sanderson pad jobs historically run 8–10% over on fuel. J-4521 is tracking at 11.2%. Unit 4412 accounts for 34% of the variance.
Margin drift
Margin has dropped 12pp vs cohort. Primary drivers: Superintendent rate gap ($1,260) + Pickup w/ Tools gap ($1,320).
Recommendation · rate card
Reset Meridian rates to MSA ceiling on next MSA cycle. Projected recovery: ~$6,200/pad at current volume.
Recommendation · operational
Limit non-ticketed GPS hours for Unit 4412. Cross-check WEX fuel with FieldCap tickets daily — current gap is W7 ($38 gal, 0 hrs).

Rules engine

MSA ceilings, business rules, and item mappings — browsable and searchable.
MSA rules
123
P66 MSA Rev 14 · 4 customers
Business rules
10
Rate ceiling · passthrough · markup
Item mappings
34
Equipment → MSA line item

P66 MSA · Rev 14

Superintendent, operator, equipment, and 3rd-party markup ceilings across oilfield services.

58 rules

Sanderson MSA · Rev 8

Cyclical pad work rate card with fuel passthrough and crew size limits.

31 rules

Apex Midstream MSA

Pipeline-focused line items with region differential for ND/SD/MT.

24 rules

Cascade MSA · v3

Commercial construction rates with union/non-union split.

10 rules

Equipment mappings

Pickup w/ Tools = 3/4 Ton 4x4 · Operator Pickup = 1/2 Ton 4x4 · Welder's Truck = PV passthrough · Excavator 170 pending.

34 maps

Business rules

3rd-party markup ceiling, region differential, crew-size limits, fuel passthrough, late ticket penalty.

10 rules

Reports

Canned reports for ops review, customer invoice prep, and board meetings.

Weekly margin review

Per-job margin vs target, rate variance summary, open alerts digest.

Mondays · 7am

Invoice pre-audit

Rate variance check against MSA ceiling before QuickBooks post.

On demand

Customer billing pack

Tickets, rate detail, margin transparency slice per customer.

Monthly

Unit utilization

Hours ticketed vs GPS vs fuel, unit-by-unit, variance flags.

Weekly

MSA compliance audit

Every billed line item mapped to an MSA rule · gap log.

Quarterly

Board KPI pack

Revenue, margin, jobs, unbilled captured — ready-to-paste slides.

Monthly