Busy Office ERP

Capacity — Q4

Load per work centre per week, as a percentage of available hours. The decision this screen serves is what to move, so the weeks over 100% have to be findable at a glance — and the figure is in every cell, because a colour on its own would not say by how much.

Work centre load by week, percentage of available hours
Work centre W36 W37 W38 W39 W40 W41 W42 W43
Assembly line 1 72% 81% 96% — near capacity 104% — over capacity 88% — near capacity 61% 55% 49%
Assembly line 2 58% 64% 79% 118% — over capacity 126% — over capacity 92% — near capacity 70% 66%
Machining cell 90% — near capacity 94% — near capacity 88% — near capacity 83% 77% 102% — over capacity 111% — over capacity 85%
Paint booth 41% 38% 52% 60% 55% 47% 44% 40%
Test rig 66% 70% 68% 74% 91% — near capacity 99% — near capacity 86% — near capacity 72%
All work centres 65% 69% 77% 88% 87% 80% 73% 62%