- estimating
- labor
- electrical estimating
Electrical estimate labor by cost code: hours to crew-days
Group an estimate's labor hours by cost code, divide by crew size × 8 hours to get crew-days, and export one task per code to schedule the job in MS Project.
The TakeOn Team 5 min read
In short: To turn an electrical estimate into a crew budget, group its labor hours by cost code, then divide each code’s hours by crew size × hours per day to get crew-days. Those numbers tell a foreman how much time each part of the job has, and they become the tasks of a schedule. In TakeOn, the Bid Summary’s Labor by cost code section does the grouping, and Export schedule (CSV) sends it to MS Project.
Key takeaways
- A bid’s total labor hours don’t help a foreman. Hours per cost code (rough in, wire pull, devices, fixtures, gear) do.
- Crew-days = hours ÷ (crew size × hours per day).
- Code every part. A kit’s hours belong to its parts’ codes, not to one line.
- Use the adjusted hours, after labor factors, or the field budget will be short by the same amount the bid was padded.
- TakeOn builds the tree from the same numbers as the Bid Summary, so its total always matches the bid.
What is labor by cost code?
Labor by cost code is an estimate’s labor hours and labor cost grouped under the cost codes of your work breakdown (for example 26 05 33 raceways, 26 27 26 wiring devices), instead of one total. Cost codes are usually dotted and nested, so hours roll up from a part to its group to its phase.
Estimators price by line item. Project managers and foremen run the job by cost code. Labor by cost code is the bridge: the same hours, re-sorted into the buckets the field tracks.
How do you convert labor hours into crew-days?
You convert labor hours into crew-days by dividing by the crew size times the length of a working day:
Crew-days = labor hours ÷ (crew size × hours per day)
Worked example (illustrative numbers): a cost code carries 96 hours, and the crew is 3 electricians working 8-hour days.
| Step | Calculation | Result |
|---|---|---|
| Crew-hours per day | 3 × 8 | 24 |
| Crew-days | 96 ÷ 24 | 4 |
The same 96 hours is 6 days for a crew of 2, and 3 days for a crew of 4, assuming the work can actually be split that way. Crew-days are a budget, not a schedule. Access, inspections and other trades decide the calendar.
Which hours should go into the crew budget?
The crew budget should use the bid’s adjusted labor hours: the base hours after any labor factors for working height, occupied space or difficulty. If the bid carried 1,000 base hours with a 1.10 factor, the field has 1,100 hours to spend, and the budget per code should add up to 1,100.
Leave out labor you priced but won’t perform with your crew, such as quoted subcontract work, and anything on an alternate the owner hasn’t accepted.
How does TakeOn show labor by cost code?
TakeOn shows labor by cost code in the Bid Summary, in the Labor by cost code section after the Sanity check. It is a tree of your top-level codes, collapsed by default, with Expand all. Each code shows Hours, Crew-days and Labor $, and opens to its child codes and the line items coded at it. Uncoded sits at the bottom and a Total row closes the tree.
The numbers come from the same calculation as the Bid Summary:
- Hours are the base hours times the project’s labor factors, so the Total equals the bid’s adjusted labor hours.
- Labor $ is hours × the labor rate × (1 + burden), or the crew-mix blend of journeyman, apprentice and foreman rates when you’ve set one, so the Total equals the bid’s labor cost.
- Crew-days are hours ÷ (crew size × 8). The crew size is the one in the Bid Summary’s Sanity check; change it and the crew-days move.
The section covers the base bid only. Labor tagged to an alternate or a change order stays out. On a finalized bid, the tree is frozen with the locked snapshot.
How does TakeOn assign each hour to a cost code?
TakeOn assigns each hour to a cost code with one rule, used everywhere the codes appear:
- A line’s labor goes under its linked catalog material’s cost code.
- If that material has no code, or the template has no material, it goes under the template’s own Cost code (a field in the template editor).
- A kit (an assembly) is split by part: each part’s hours go under that part’s code, and a labor-only line in the kit, such as cable installation time, goes under its own code.
- A manual estimate line goes under its picked material’s code.
- Anything left is Uncoded.
The kit split is the one that matters. A data outlet kit’s hours are mostly cable, a little jack termination and a little rough-in, and each lands in its own bucket instead of all sitting under “data outlet”. The assemblies post covers how kits are built.
If the Uncoded row is large, code the materials in your catalog or set a Cost code on the templates that carry the hours.
How do you get the estimate into MS Project?
You get the estimate into MS Project with Export schedule (CSV) in the Labor by cost code section. The dialog asks for:
- Crew size, prefilled from the project, with Duration = hours ÷ (crew × 8 h/day).
- Include line items under each code, if you want the line items as tasks under each code.
The CSV has the columns Name, Outline Level, Work, Duration and Notes, one row per code, depth first. Work (hours) and Duration (days) are filled in only on the lowest-level tasks, so Project rolls up the rest. Open it with MS Project’s import wizard and map the columns.
What the export leaves to you: dates, dependencies and sequencing. TakeOn writes the work, not the plan.
The same rule also drives Export → Group by → Cost Code, which lists each kit part under its own code. For what’s inside the labor rate, see what labor burden is. The estimating features in TakeOn page covers the Bid Summary. Try TakeOn free.
Frequently asked questions
- How do you convert labor hours to crew-days?
- Divide the labor hours by the crew size times the hours in a working day. With an 8-hour day, 96 hours for a crew of 3 is 96 ÷ (3 × 8) = 4 crew-days. TakeOn's Labor by cost code section uses that 8-hour day and the crew size from the Bid Summary's Sanity check.
- Where does TakeOn show labor hours by cost code?
- In the Bid Summary's Labor by cost code section. It is a tree of your cost codes with Hours, Crew-days and Labor $ on each code, Uncoded at the bottom and a Total row that matches the bid's adjusted labor hours and labor cost.
- How does TakeOn decide which cost code an hour belongs to?
- TakeOn files a line's labor under its linked catalog material's cost code, or the template's own Cost code if the material has none. A kit is split by part, so each part's hours go under that part's code. Labor with no code at all is listed as Uncoded.
- Can I export a TakeOn estimate to Microsoft Project?
- Yes. Export schedule (CSV) in the Bid Summary's Labor by cost code section downloads one task per cost code, with Work in hours and Duration in days on the lowest-level tasks, for MS Project's import wizard. It has no dates or dependencies; you add those in Project.
- Are alternates and change orders included in labor by cost code in TakeOn?
- No. TakeOn's Labor by cost code covers the base bid only, so labor tagged to an alternate or a change order is left out of the tree and the schedule export.