





One workbook, two questions: can this shop pay for itself at this mix, and can it price the electrification work everyone is quoting?
Built on a real shop — Apex Electric LLC, 8 heads, pre-costed electrification templates (EV charger, 200A panel, solar + battery), the headline Job Mix tab (service vs project cash cycles), and the apprentice ratio your licensing board asks about (labeled illustrative).
Five explicit years of statements that tie out to zero — balance check = $0 by construction — plus retainage drag modeled in working capital, per-level rate card with burden decomposition, service dispatch engine, project job costing, materials and markup, COGS, and the ten numbers on the KPI dashboard.
6 files: the 26-tab workbook (415 formulas, all values cached, no macros), a 10-page How-To guide walking the worked example, and two one-page cards — the 60-Second Shop Check and the EV / Panel / Solar Job Cost Card.