Companion files · The Private Markets Career Guides
Running a Profitable Electrical Subcontracting Company: Labor Rates, Overhead, Estimating by Labor Units, Copper Clauses, Productivity, WIP, Retainage, Cash, Davis-Bacon Work and Bonding.
DRM-free PDF edition, $19.99: searchable, printable, instant download.Buy the PDFFree sample
These are the companion files of the book. Six workbooks follow Pellmarsh Electric, the fictional electrical contractor of the case, across two fiscal years: the labor rate, the estimate, copper, productivity, the WIP and overhead, and cash and bonding. A toolkit holds the check-lists of Appendix B in editable form.
The archive holds the six workbooks, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links, no password. The workbooks recalculate in Excel, LibreOffice or Google Sheets.
Chapters 3, 11 and 12
The burdened labor rate by worker class, the composite rate of each fiscal year, the J05 crew under the wage determination and the apprentice ratio breach. Sheets: Rates, Composite, J05 crew. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 117 KBChapters 5 and 7
The J08 estimate by labor units: takeoff, copper wire priced from its content, factors, markup and the bid, and a change order priced two ways. Sheets: Takeoff, Wire, Summary, Change order. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 220 KBChapter 6
The copper indexation clause applied purchase by purchase, and a bid without one. Sheets: Clause, Purchases. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 312 KBChapter 10
Earned hours, productivity factors by task and a forecast of hours to complete. Sheets: J07 tasks, Forecast. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 414 KBChapters 4, 13 and 14
The work in progress schedule at both year ends, a losing job booked whole, and overhead per field hour. Sheets: Schedule, Loss, Overhead. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 517 KBChapters 15 and 16
Cash and the line of credit month by month, the balance sheet and working capital, and the bonding program. Sheets: Cash, Balance sheet, Bonding. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 617 KBAppendix B
Bid or no bid; The estimate before it leaves; The subcontract before signing; Job start; Monthly productivity review; Monthly WIP and fade meeting; Davis-Bacon payroll week; Weekly cash review; Job close-out and retainage.
Download the toolkit41 KBRead first
What each file holds, which workbook answers which chapter, and the two inputs to change first.
Download the read-me4 KB| The composite rate | The FY2026 roster weighted by head: $55.20 an hour, against $52.63 the year before |
| The J08 bid | 3,824 labor-unit hours, material and markup: $574,000 |
| The bonding program | Aggregate $11,600,000 then $8,200,000; single job limit $2,730,000 in FY2026 |
The files are provided as they are, without warranty of any kind. The model is illustrative: Pellmarsh Electric, Orrisford and every party are fictional, and the wages, labor units, prices, copper values, markups and surety terms are the book’s assumptions, not market terms or the practice of any real contractor, surety or bank. Rules and forms change: check the current texts, the subcontract as signed, your outside CPA, your bond agent and your counsel.