Intranet / Capacity planning
Project hours need a point of comparison.
Capacity planning compares planned project hours with available hours for each work group and calendar week. Calendar rules and capacity assignments valid for that week feed the calculation. The web view and Excel export use the same calculation service.
-
Week 1880 %
320 h planned 400 h normal capacity
-
Week 19110 %
440 h planned 400 h normal capacity
-
Week 20Not calculable
180 h planned capacity unavailable
- Plan hoursProject, group, week
- Calculate capacityValidity and calendar
- Show the comparisonWeb view and Excel
The problem
Hours alone do not show utilization
The same planned hours can mean different things in two different weeks. Available working time and calendar rules change the basis for comparison.
The decision
Calculate per group and week
Planned demand and available capacity are calculated together. When no capacity basis has been configured, that remains visible as a separate state.
The result
Missing input stays visible
The overview shows the relationship between planned work and capacity. Missing input is not presented as overload. The web view and export use the same rules.
The decisions behind it
1. Account for the calendar
Weekly capacity considers working hours, headcount, a configured absence factor, and day and bridge-day factors. It uses the capacity assignments valid for the relevant week.
2. Unknown is a separate state
When every configured capacity is zero, the calculation returns no utilization class. The interface marks the missing basis in gray. Warning levels follow configured capacity thresholds, so 110 percent does not automatically imply a particular warning class.
3. Share rules between the view and export
The weekly JSON endpoint and Excel export use the same capacity service. After a planning edit, the interface reloads the affected groups and weeks, with a full reload available as a fallback.
Tech stack
Symfony · Doctrine DBAL · SQL Server · Stimulus · PhpSpreadsheet
This module belongs to the same internal Symfony intranet as the manufacturing workflow and the other modules shown here.