Average Known Weeks of WorkMean Known Weeks across teams with available capacity.= AVG((Maintenance Hrs Due + Booked Quoted Hrs) ÷ Net Available Hrs/wk).
-- wks
Mean pipeline depth across service teams
ACS Labor Loading Dashboard
Weekly backlog, staffing load, and budget risk by department
...Loading live data
Overall UtilizationWeighted last-week utilization.= SUM(Worked Last Week) ÷ SUM(Net Available Hrs/wk).
--%
-- worked hrs / -- available
Unassigned Known WorkTotal remaining hours of active Service backlog not assigned to one of the six service teams.= Σ remaining_hours where team resolves to Unassigned / Other (no tech, or tech on a non-service team).
-- hrs
Work not on a service team
Service Loading by Team
Three-zone row: capacity → demand subtotal → actuals
CapacityDemandActuals
| TeamThe Service teams in service_loading_v2; membership by employees.team. | Capacity | Demand | Actuals | |||||
|---|---|---|---|---|---|---|---|---|
| MembersActive employees on this Service team.= COUNT(employees WHERE active = true AND team = this team). | Net Available Hrs / wkWeekly team capacity.= 40 × Members. |
Maintenance Hrs DueMaintenance backlog due.= Σ remaining_hours of active M- service cost centers; remaining = MAX(Estimate − Actual, 0). |
+ Booked Quoted HrsBooked quoted backlog.= Σ remaining_hours of active S- service cost centers; remaining = MAX(Estimate − Actual, 0). |
Total Hours subtotalTotal known backlog on the team's books.= Maintenance Hrs Due + Booked Quoted Hrs. |
Known Weeks of WorkKnown weeks of work.= (Maintenance Hrs Due + Booked Quoted Hrs) ÷ Net Available Hrs/wk; empty when Net Available = 0. |
Worked Last WeekPrior completed Mon–Sun (America/Los_Angeles).= Σ schedule_blocks.hrs via job_schedules.team for this team. |
Last Week UtilizationLast week utilization.= Worked Last Week ÷ Net Available Hrs/wk; empty when Net Available = 0. |
|
| Loading live service loading... | ||||||||
| Job #↑ | Job Name | Stage | Status | Assigned Tech | Est Hrs | Act Hrs | Remaining Hrs |
|---|
No jobs found for this backlog
Total Remaining HoursOpen construction backlog after actuals, all departments.= Σ department Remaining Hours (revised).
-- hrs
Open construction backlog after actuals
windowed
Weeks of BacklogPortfolio capacity horizon.= Total Remaining Hours ÷ (40 × total active construction headcount).
-- wks
Capacity horizon across active teams
windowed
Overall Backlog TrendPortfolio Remaining Hours vs. prior 4 weeks.Builds over 8 weeks of history.
--
—
Launch state— History building · 8 wks
windowed
Construction Labor Load by Department
Risk-ranked within operating bands · Hours based on revised estimates.
Critical
Watch
Healthy
—History building
| DepartmentConstruction departmentMapped from active construction cost centers. | Remaining HoursOpen revised backlog after actuals.= Σ MAX(Revised Est − Actual, 0) across the department's active jobs.Windowed Remaining Hours Remaining hours whose evenly-distributed monthly buckets fall inside the selected window. Jobs with no dates, or windows entirely in the past, fall to the current month. | HeadcountActive people assigned to this department.= COUNT(active employees WHERE department = this). | WeeksCapacity horizon for this department.= Remaining Hours ÷ (40 × Headcount); empty when Headcount = 0. | TrendDirection of Remaining Hours vs. prior 4 weeks.Builds over 8 weeks of history; shows — until then. | Forecast OverrunProjected finish vs. revised budget.= (Forecast Hours − Revised Budget) ÷ Revised Budget. Positive = over. | Sales HoursEstimated hours on quoted/awarded work not yet started.= Σ estimated hours of active sold jobs for this department. |
|---|---|---|---|---|---|---|
| Loading live construction rollup... | ||||||
Health rule: red = over budget and forecast >10%; amber = one condition; green = neither. Rows are risk-ranked inside each operating band; stable org order keeps Trades first and Controls/Automation second.
| Job #↑ | Job Name | Stage | Start Date | End Date | Revised Hrs | Actual Hrs | Remaining Hrs |
|---|
No jobs found for this department
Overall Maintenance Attainment
--%
-- / -- PM hrs delivered this month
Total Remaining Service Hours
-- hrs
Open service + maintenance hours after actuals
Attainment Trend
--
—
Launch state— History building · 8 wks
0 maintenance goal jobs excluded
Service Maintenance Attainment by Team
Flat list sorted worst variance first; S-/M- subtotal slot pattern reserved
Behind PM goal
Mild gap
Delivered/on-track
—History building
| Team | Headcount | Total Avail Hours | Hours Worked | Maint Goal | Maint Actual | Variance (%) | Sales Hours |
|---|---|---|---|---|---|---|---|
| Loading live service rollup... | |||||||
Health rule: red = significantly behind contracted PM goal; amber = mild undelivered PM gap; green = delivered or on-track. Variance is signed because Service is inverse of Construction: undelivered maintenance is the risk, while capacity hours support the read.