← Back to projects

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.

Intranet / Capacity planningSample data
PlannedNormal capacity
  1. Week 1880 %

    320 h planned 400 h normal capacity

  2. Week 19110 %

    440 h planned 400 h normal capacity

  3. Week 20Not calculable

    180 h planned capacity unavailable

  1. Plan hoursProject, group, week
  2. Calculate capacityValidity and calendar
  3. Show the comparisonWeb view and Excel
Simplified example with fictional planning figures for three independent weeks. Percentages use normal capacity and do not represent production warning thresholds.

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.