Settings
Set your working rhythm and your trade list. Trade names feed the dropdowns on Crews and Backlog, so they always match.
Crews
One row per crew, sub or W-2. The number that matters most is install $ per crew-day: the contract value one crew installs in one working day. If you do not know it, take a typical job's value and divide by the days it takes. Utilization covers weather, callbacks, and no-work days. Percentages are whole numbers: 85 means 85%.
| Crew ID | Trade | Type | Days / Wk | Utilization % | Install $ / Crew-Day | Sub Cost % | W-2 $ / Day | Crew-Days / Wk | Weekly Capacity | Weekly Labor |
|---|
Backlog
One row per sold job not yet complete. Only Backlog and In Progress jobs count toward the model; On Hold and Complete drop out automatically. Leave crew-days at 0 and the model derives them from that trade's average $ per crew-day.
| Job ID | Customer | Trade | Contract $ | Sold Date | Status | Crew-Days (0 = auto) | Age (days) | Modeled Days |
|---|
Capacity vs Backlog by Trade
Weeks of Backlog is the headline. Under 2 weeks: crews run out of work soon; that is a sales problem. Over your threshold: sold revenue is stuck waiting on capacity. Use the Scenario column to test adding crew-days per week (hiring a crew, onboarding a sub) and watch the weeks move.
| Trade | Crews | Crew-Days / Wk | Weekly Capacity | Labor % | Backlog $ | Backlog Days | Weeks of Backlog | Scenario: + Days / Wk | Scenario Weeks | Status |
|---|