Capacity planning report: measures and example

A capacity planning report compares demand with net available hours, shows actual completed work, and identifies where a team needs a decision. Company totals must reconcile, but the report should expose shortages by the resource that can actually perform the work. A balanced total can still hide an overloaded team and unfinished customer commitments.

Define the report before choosing the chart

State the period, work unit, resource and version on the first page. Decide whether the report looks forward at an approved schedule, backward at completed work, or compares both. Label plan and actual columns explicitly so reviewers do not interpret expected demand as realized activity.

The Federal Reserve's capacity methodology defines industrial capacity as sustainable potential output and utilization as output relative to capacity. A company service-hours report needs its own stated denominator. The example below measures completed service hours against net available service hours; it is not directly comparable with an industrial utilization series.

Bring the demand or booking file, the staffing calendar, approved time exclusions, and closed work tickets. Carry the team and period identifiers through each export. If demand begins as units rather than hours, use the separate demand-to-capacity planning method before preparing this report.

A worked report for a US service company

An illustrative US equipment-service business reviews the four-week period June 1 through June 28, 2026. East and West use comparable service-hour units. In this example, booked hours and completed hours use the same job-time basis, with no rework or changes to job standards.

Scheduled hours come from the staffed calendar. Exclusions are approved leave and training, recorded once. Demand includes all work due in the period, with no opening backlog or cancellations. Completed hours come from closed tickets for that same demand; unfinished work remains due at the cutoff.

The calendar reconciliation is 2,240 − 280 = 1,960 available hours. The demand check is 1,260 + 700 = 1,960, and completed work is 1,050 + 630 = 1,680 hours. These are separate totals from separate source files, rather than figures typed into the final report.

Use columns A through F matching the table. Net available time in D2 is:

=B2-C2

Fill down to the West row and sum each numeric column for the total. Keep exclusions traceable to their calendar records. A change in the exclusion policy can move every percentage even when demand and completed work are unchanged.

Turn the rows into management measures

Use the following definitions consistently:

Planned load = Demand hours / Net available hours

Completed-work utilization = Completed hours / Net available hours

Capacity gap = Demand hours − Net available hours

Unfinished demand = Demand hours − Completed hours

A positive capacity gap means a shortage. A negative gap means spare capacity before considering actual execution. Unfinished demand is a separate measure; it shows work still due under the assumptions above.

Percentages are rounded to one decimal place; hours remain exact. Add columns G through J to the source table and enter:

=IF(D2=0,"No capacity",E2/D2)
=IF(D2=0,"No capacity",F2/D2)
=E2-D2
=E2-F2

East needed 1,260 / 1,120 = 112.5% of its capacity but completed 1,050 / 1,120 = 93.8%. The report therefore contains two questions: how to cover the planned shortage and why some available time did not become completed service work.

West has spare scheduled capacity and still leaves work unfinished. A manager should examine job readiness, geography, skills and timing before treating those hours as transferable. The table identifies the questions; it does not establish the operational cause.

Prove the total and write the decision

The overall utilization is 1,680 / 1,960 = 85.7%. Divide totals, rather than taking a simple average of team percentages. As a second check, weight each unrounded team utilization by its available hours:

=SUMPRODUCT(D2:D3,H2:H3)/SUM(D2:D3)

Microsoft's SUMPRODUCT documentation explains that the function sums products of corresponding ranges. Here it reconstructs completed hours from available hours and utilization before dividing by total availability. Use full-precision cells, rather than percentages copied from the printed report. Covirage is not affiliated with Microsoft.

The unfinished-demand reconciliation is also useful: 210 + 70 = 280 hours, matching 1,960 − 1,680. If work was canceled, transferred out of scope or added late, show those movements separately in a backlog reconciliation before claiming that identity proves the report.

Attach decisions to the detail. East's operations manager owns the shortage response; dispatch owns the review of unfinished jobs and usable hours. Record the proposed action, evidence required, decision date and status. A company percentage without those assignments leaves the constraint unresolved.

For sales organizations, capacity is arithmetic explains the underlying calls-and-representatives calculation, while ramp and attrition explains why staffing totals need adjustment. This report summarizes a supplied capacity basis rather than replacing those methods.

A second variation: change East's available hours

For a planning comparison using the same demand, assume approved overtime can add 140 service hours to East. The supplied incremental rate is $55 per hour, and all added hours are usable for the required work. The only changed operating input is East's added available hours; demand and West's capacity stay fixed.

East's shortage becomes 1,260 − 1,260 = zero. Company capacity becomes 1,960 + 140 = 2,100 hours, giving 1,960 / 2,100 = 93.3% planned load. Incremental cost is 140 × $55 = $7,700.

This case shows available capacity, not additional completed work. It cannot rewrite the closed period's actual utilization or prove that overtime will resolve readiness issues. Management must confirm feasibility before using it in the next comparable scheduling cycle.

Where it goes wrong

• Nominal hours become available hours. Approved absences and training must be deducted once, using the report's stated availability policy.
• Total headroom hides local shortages. Skills, sites and delivery dates can prevent spare time from covering another team's commitments.
• Load is labeled actual utilization. Required work and completed work belong in separate columns with separate ratios.
• Unfinished demand uses incompatible units. Demand standards, ticket completion and cancellations must share a documented basis before subtraction.
• An action case changes history. Keep proposed availability separate from closed-period actuals and record approval before adopting the revised plan.

Reconcile your capacity report in Covirage

Upload a file or Google Sheet with demand, staffing calendars, exclusions and completed work; Covirage maps the columns, and its tools compute and check the supplied comparisons. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account, set up your business and bring a sample of your own data; creating the account takes about a minute.

See Excel analysis for the supporting file-analysis context.