Weekly margin tracking, in the workflow PMs already do
Drop your weekly JDE Cost Distribution Report (or Sage 300, Vista, Foundation, Spectrum, ComputerEase, Penta — coming). Scoprix maps it to a projection workspace that mirrors the spreadsheet your PMs already maintain — peach-cell remaining-hours editor, Pending COs, POs, Trend Summary.
This week's projection
By phase
| Phase | Budget | Spent | Remaining hrs★ | Projected cost | Variance |
|---|---|---|---|---|---|
| 10 General | $380,000 | $285,000 | 0 | $380,000 | $0 |
| 20 SM-Precon/Fab | $1,240,000 | $1,122,000 | 320 | $1,286,400 | +$46,400 |
| 21 SM-Install | $1,640,000 | $932,000 | 4,120 | $1,708,800 | +$68,800 |
| 30 PF-Precon/Fab | $980,000 | $745,000 | 280 | $985,000 | +$5,000 |
| 31 PF-Install | $1,460,000 | $712,000 | 3,900 | $1,536,000 | +$76,000 |
| 60 Field Ops | $410,000 | $268,000 | 540 | $409,000 | $-1,000 |
Peach cells are PM-editable. Update remaining hours each week — Scoprix recomputes Projected Cost and the margin float automatically.
Pending COs
Track every change order through 8 states (verbal → drafted → submitted → approved). Each carries a realization probability that flows into the projection.
POs + Subcontracts
Mark a PO/sub as locked vs floating. Locked commitments roll straight into Projected; floating ones get a probability-weighted estimate.
Trend Summary
Week-over-week: Contract Amount, ECAC, Markup %, billed vs paid. Spot a margin slip three weeks before it becomes a fire drill.
Bring your weekly CDR
Drop your latest JDE export. Scoprix parses every cost code, maps it to the projection workspace, and you're editing peach cells in 30 seconds.