Operations template
Capacity Planning Template
Check whether your team can take on more. Utilisation shows planned work as a share of available hours.
Opening a template uses no credits.
What's inside
| Row | A | B | C | D | E | F | G |
|---|---|---|---|---|---|---|---|
| 1 | Team | People | Hours each | Available | Planned | Utilisation | Spare |
| 2 | Design | 3 | 140 | =B2*C2 | 380 | =E2/D2 | =D2-E2 |
| 3 | Engineering | 6 | 140 | =B3*C3 | 900 | =E3/D3 | =D3-E3 |
Preview with sample numbers. Formulas are shown in green.
The formulas, explained
D2 =B2*C2
People times hours per person.
F2 =E2/D2
Planned hours as a share of available hours.
Make it yours by asking
Try a request like this in Tabstra:
"Create a capacity plan with team, people, hours per person, available hours, planned hours, utilisation and spare capacity"