Capacity planning template

Build a support workload sheet by period and skill, then download editable spreadsheet formulas. Your entries stay in this browser.

Forecast work

Use the same duration for every period, such as one week.

Work 1

Work 2

Team availability

Staff 1

Separate skills with commas. Each must match a required skill.

Allocate usable hours

Allocation 1

Support team

Allocation 2

Support team

Skill and period gaps

Uncovered work

1.33 hours

Required handling

44 hours

Usable staff time

48 hours

Example assumptions. Allocations share each staff row’s usable hours.

1.33 hours of work remain uncovered by the entered allocations.

Workload and capacity grid

Work by period and skill
WorkRequiredAllocatedSigned gapUncoveredCapacity
Peak week / Product enquiries / Product34.67405.330Capacity allocated
Peak week / Returns / Returns9.338-1.331.33Capacity allocated
Staff hours by period
StaffScheduledUnavailable timeUsableAllocated
Peak week / Support team6020%4848

All grid figures are hours. A positive signed gap is spare allocated time.

Build your capacity planning sheet

This capacity planning template compares your support workload with the skilled hours you allocate to it. Edit the example in your browser, then download the grid for your staffing discussion.

Choose a common period duration. Add a work row for each period and category, then name its required skill. Enter new contacts that need a person and backlog contacts you intend to clear during that period.

Add each person once per period, or use groups containing different people. Enter gross scheduled hours and eligible skills. Separate skill names with commas. Use the same period label on matching work and staff rows.

Allocate usable hours from each staff row to eligible work rows. Split one person’s hours across several categories where needed. Total allocations cannot exceed that person’s usable hours.

Add work and staff rows with another period label to extend the plan. The browser accepts up to 24 work rows, 24 staff rows and 96 allocations. Export before closing the page. A reload restores the example.

The workload and available-hours formulas

Required hours equal new human contacts multiplied by active handling minutes, divided by 60. Backlog contacts to clear add the same handling work. Each row uses (new contacts + backlog contacts) × handling minutes ÷ 60.

Active handling time includes the minutes spent reading, answering and doing active follow-up work. Elapsed resolution time includes waiting between those actions. Enter active minutes per contact to avoid counting waiting as continuous staff work.

Usable hours equal gross scheduled hours × (1 − unavailable time ÷ 100). Unavailable time covers leave, breaks, training and other excluded work once. Microsoft’s capacity planning guidance calls time away from handling conversations shrinkage.

Signed gap equals allocated usable hours minus required hours. Uncovered hours equal the positive portion of required hours minus allocated hours. This sheet applies no occupancy multiplier, so an idle-time assumption cannot reduce usable hours a second time.

A peak-period support example

The illustrative peak week has 300 new human contacts at 8 active minutes each. Clearing 30 backlog contacts at the same handling time brings required work to 44 hours.

The team has 60 gross scheduled hours. At the example’s 20% unavailable time, 48 usable hours remain. Total usable time exceeds workload by 4 hours.

The split reveals a skill gap. Product enquiries have 240 new contacts and 20 backlog contacts, requiring 34.67 hours. Returns have 60 new contacts and 10 backlog contacts, requiring 9.33 hours.

Allocating 40 hours to product enquiries and 8 hours to returns leaves 1.33 returns hours uncovered. Product enquiries have 5.33 spare allocated hours. Those spare hours need a deliberate eligible reallocation before they cover returns.

Change product enquiries to 120 new contacts, zero backlog and 7.25 handling minutes. That row requires 14.5 hours in the browser and the exported workbook. The 20% example is replaceable, not a staffing benchmark.

Read gaps without promising response times

Read each period and skill before using the total. Spare time in a later period cannot clear work that must finish now. A person with a different skill cannot cover the category until you change the eligible allocation.

A row with zero allocated capacity shows “No available capacity” and its full required hours as uncovered. The tool shows hours directly and calculates no ratio with a zero denominator.

This table plans asynchronous workload and backlog clearance. Its totals do not predict queue waiting probability, a service level or a live-chat response promise. The related Erlang C calculator handles a synchronous queue estimate.

Contact counts and hours must be non-negative. Counts must be whole numbers. Unavailable time must be between 0% and 100%, and handling time must be positive when contacts are present.

Use the template in Excel or another spreadsheet

Download CSV to preserve the entered assumptions and current calculated values. It includes period, category and skill, contact forecasts, backlog and handling minutes. Staff rows include scheduled hours, unavailable time and allocated usable hours.

The Excel-compatible workbook separates Work, Staff and Allocations inputs from its Summary. Edit the input columns listed on its Guide sheet. Workload, usable hours and gaps recalculate with formulas when the spreadsheet application recalculates.

Keep row identifiers unchanged. Allocation formulas match staff and work by those identifiers and check period, skill and available hours. Correct every Check column after editing. An invalid allocation contributes zero accepted hours until corrected.

CSV contains values rather than workbook formulas. Add more rows in the browser before exporting a larger workbook. Both downloads run locally without sign-in, calendar access or a connection to your store’s accounts.