Executive MIS
Operational pipeline
The water-purification pipeline from §3, made literal. Open work orders only — every stage drills to the jobs behind it.
US-039 · SRS §3
Sourcing6847 potential · 21 trial
Pre-Repair2110 inward · 11 awaiting quote
In-Repair5113 alloted · 25 in progress · 9 pending spare · 4 on hold
Repair Completed2614 peer · 12 customer
Closed — Ready for Invoice18awaiting Zoho push
Closed this period — 18 ready for invoice, 6 written off, 2 customer rejected. Rework jobs: 3 of 26 closures.
Yield this period
75%
▲ 4 pts vs July · 18 : 6
Unbilled hours
134 h
15.0% of 892 h logged
Stuck jobs
7
▲ 2 over 5 business days
Pending spare
9
▲ 1 · 4 awaiting a purchase request
Open work orders
116
21 + 51 + 26 + 18 across four statuses
Reconciliation rule (AC-039-002). Status counts must total open work orders exactly — 21 + 51 + 26 + 18 = 116. No job counted twice, none missing. The four boxes are the configurable status categories (US-041), so this row follows the hierarchy rather than a hard-coded pipeline.