# The Electrical Contractor Business Owner: companion files

Julian R. Sterling

## What is here

- **Electrical_Contractor_1_Labor_Rate.xlsx** (Chapters 3, 11 and 12; Labor Rate workbook of Appendix A): sheets Rates, Composite, J05 crew, then Checks. The burdened hourly cost of every worker class for FY2025 and FY2026, the composite rate ($52.63 then $55.20 an hour), the J05 crew rate under the wage determination and the apprentice ratio breach of $4,588.
- **Electrical_Contractor_2_Estimate.xlsx** (Chapters 5 and 7; Estimate workbook): sheets Takeoff, Wire, Summary, Change order, then Checks. The J08 fire station takeoff by labor units, copper wire priced from its copper content, 3,824 hours and a bid of $574,000, and change order CO-03 priced as a lump sum and as time and material.
- **Electrical_Contractor_3_Copper.xlsx** (Chapter 6; Copper workbook): sheets Clause, Purchases, then Checks. The J06 indexation clause purchase by purchase ($10,168 recovered, $1,764 absorbed) and the J07 bid without a clause ($17,050 carried).
- **Electrical_Contractor_4_Productivity.xlsx** (Chapter 10; Productivity workbook): sheets J07 tasks, Forecast, then Checks. Earned hours and productivity factors on J07 at 31 March 2026, a job factor of 0.75 and a forecast of 20,313 hours against 15,200.
- **Electrical_Contractor_5_WIP.xlsx** (Chapters 4, 13 and 14; WIP workbook): sheets Schedule, Loss, Overhead, then Checks. The work in progress schedule at both year ends, the J07 loss of $175,305 booked whole, and overhead per field hour and as a share of job cost.
- **Electrical_Contractor_6_Cash_and_Bonding.xlsx** (Chapters 15 and 16; Cash and Bonding workbook): sheets Cash, Balance sheet, Bonding, then Checks. Cash and the line of credit month by month in FY2026 ($1,560,923 at 30 September 2026), the balance sheet, working capital and the bonding program ($11,600,000 then $8,200,000).
- **Electrical_Contractor_Toolkit.docx**: the 9 check-lists of Appendix B, editable (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).

## How to use the workbooks

Blue type on a light blue background is an input, black type a formula, green type a link to another sheet. Change one input at a time, note the result, and set the input back before the next test: the Checks sheet of each workbook compares the live cells with the figures printed in the book and reads ALL CHECKS OK at the base case. Each of the 9 exercises of Appendix A is done in the workbook it names.

The arithmetic is plain: multiply, divide, subtract and round. No date function, workday count or lookup formula is used. When a figure is rounded, the note at the top of the sheet says which way.

Two inputs to try first:

1. In Electrical_Contractor_1_Labor_Rate.xlsx, on Rates, change the blended burden rate: every burdened cost and both composite rates move, and so does the J05 breach.
2. In Electrical_Contractor_3_Copper.xlsx, on Clause, set the band to 15 percent: the first J06 purchase falls inside the band and the $10,168 adjustment disappears.

The workbooks are separate files with no link between them: the composite rate is typed again in the Estimate workbook.

## A word of caution

Pellmarsh Electric, Inc., the city of Orrisford, the three general contractors and every party in the case are fictional. Wages, fringe benefits, burden rates, labor units, prices, copper values, markups, overhead, interest rates and the surety guideline are teaching assumptions, not market norms or recommendations. Federal rules, standard forms and state laws change: read them in their current text and in the subcontract as signed, with your outside CPA, your bond agent and your counsel. No software is described or recommended. Nothing here is legal, tax or accounting advice.
