The weekly workload fits into the spreadsheet only because nobody has included client revisions. A capacity planning worksheet should compare committed demand with the actual availability of the roles needed to deliver it. Keep the assumptions visible; the worksheet is a decision aid, not a precise forecast.
Photo by Lukas Blazek on Unsplash.
Build two views of the same week
For demand, record client, deliverable, due date, stage, required role and estimated effort. For capacity, record person or role, available working time, existing commitments and known absence. Include coordination, reviews and support that consume the same people.
Keep uncertainty separate
Mark work as committed, likely or possible. Use a reasonable effort range for unfamiliar tasks and explain it. Do not make every opportunity a firm commitment, or every estimate a promise. Show which roles become constrained if the likely work arrives.
Use this weekly decision checklist
Are reviews and revisions included?
Does specialist work have specialist capacity?
Which dates depend on client inputs?
What reserve is needed for known variability?
Who can approve moving, narrowing or declining work?
An illustrative planning conversation
A small communications agency has ten available hours in client servicing and two in senior editorial review. A new report needs three review hours. The total team may look underused, but the review constraint remains. The owner can change the review sequence, move the commitment or arrange suitable cover; spare hours in another role do not resolve it automatically.
Related guidance: guide to working with an external operations partner.
Update the worksheet with actual effort after delivery and discuss differences without treating estimates as personal failures. Over time, those observations can improve the assumptions. Hili Consulting can help make capacity decisions visible before an overloaded week becomes a client-service problem.
