Book a consultation
Operations

Capacity planning models

Capacity planning models built on your own data, showing demand against capacity for teams, plants and agencies, so you decide when to hire, reschedule or add shifts.

See how we work
Design team is overbooked in weeks 6 to 9Capacity heatmap of five teams over twelve weeks; the design team runs at 112 to 132 percent in weeks 6 to 9.Design team is overbooked in weeks 6 to 9Demo dataBooked hours as % of available hours, next 12 weeksW1W2W3W4W5W6W7W8W9W10W11W12Design82889197100118132124112958478Engineering7479858892969910194908683Project mgmt909295989910110410097939088Install64615866728088941041089890QA555862687482869092958870Peak 132% in week 7Over 105%: overload70 to 105%: balancedUnder 70%: idleDesign team is overbooked in weeks 6 to 9Capacity heatmap of five teams over twelve weeks; the design team runs at 112 to 132 percent in weeks 6 to 9.Demo dataDesign team is overbookedin weeks 6 to 9Booked hours as % of available hoursWeeks 4 to 9 of the next 12W4W5W6W7W8W9Design97100118132124112Engineering8892969910194Project mgmt989910110410097Install6672808894104QA687482869092Peak 132% in week 7Over 105%: overload70 to 105%: balancedUnder 70%: idle

You plan capacity in a spreadsheet, and it is out of date the day it is shared. We build capacity planning models and dashboards instead. We combine demand from your CRM, ERP or project tools with available hours, machines and skills. You see where you will be overloaded or idle weeks ahead.

Then you choose: hire, reschedule, add shifts or bring in contractors, with the cost of each option visible. Unlike capacity planning tools tied to one product, our models run on the systems you already use. Book a consultation.

What it is

What is capacity planning? Matching what you can deliver to what is coming

In short

Capacity planning matches what your organization can deliver, in people, machines, space or time, to the demand you expect. The goal is enough capacity to meet demand without paying for idle resources.

  1. It works at three levels. Strategic planning looks a year or more ahead: new sites, major equipment, hiring plans. Tactical planning looks months ahead: shifts, contractors, project start dates. Operational planning covers the next days and weeks: who works on what, and which order runs on which line.

  2. The basic math is simple. Available capacity equals resources times available time times a utilization factor. For example, take a team of 10 people with 160 working hours each per month and a 75 percent utilization target. That gives 1,200 productive hours. If forecast demand is 1,400 hours, you have a 200-hour gap to cover through hiring, overtime, contractors or rescheduling.

  3. Capacity planning is not the same as resource planning. Capacity planning asks whether you have enough in total. Resource planning assigns specific people or machines to specific work. The first sets the limits; the second works within them.

  4. Good capacity planning links both to the same demand forecast, so plans and assignments never drift apart.

A 200-hour gap, found before it hurtsTiles show 10 people times 160 hours times a 75% utilization target equals 1,200 productive hours; against 1,400 hours of forecast demand, that leaves a 200-hour gap.Worked exampleA 200-hour gap, found before it hurtsThe capacity math from the example above, hours per month10people×160 heach per month×75%utilization target=1,200 hproductive capacity1,400 hforecast demand−1,200 h200 h gapto cover by hiring, overtime, contractors or reschedulingCapacity planning asks whether you have enough in total; resource planning then assignsspecific people to specific work within that limit.A 200-hour gap, found before it hurtsTiles show 10 people times 160 hours times a 75% utilization target equals 1,200 productive hours; against 1,400 hours of forecast demand, that leaves a 200-hour gap.Worked exampleA 200-hour gap, found before ithurtsThe capacity math from the example above,hours per month10people× 160 heach per month× 75%utilization target= 1,200 hproductive capacity1,400 hforecast demand200 h gaphire, overtime, contractors or reschedule
Challenges we solve

Five signs your capacity planning is costing you margin

Capacity problems show up in margins, deadlines and morale long before anyone calls them a planning issue. The root cause is usually the same: demand and capacity live in different places, and nobody sees them side by side.

  1. 1A plan that does not depend on one person

    Today capacity lives in one spreadsheet, updated weekly at best and disconnected from the CRM or ERP.

    The model refreshes on its own.

  2. 2Less firefighting

    Teams swing between overload and idle time, so overtime rises in busy weeks and utilization drops in quiet ones.

    Plans change before costs rise.

  3. 3Sales commits only what you can deliver

    Deals are accepted without checking capacity, so delivery dates slip.

    Sales sees capacity before quoting.

  4. 4Hiring at the right time

    Without a forward view, hiring comes too late or too early. Both cost money.

    Hiring follows the forecast.

  5. 5Margin the CFO can see

    Utilization and bench time are not measured consistently, so their effect on profit stays hidden.

    The CFO sees margin by team.

  6. 6Fewer late projects

    Overloads are spotted weeks ahead, so start dates can move before deadlines slip.

    Clients get dates you can keep.

The earlier you see a gap, the less it costsBars of the cost to cover a 200-hour gap: $16K with one week of notice (overtime), $13K with three weeks (contractors), $8K with six weeks and $4K with ten weeks (rescheduling start dates).Demo dataThe earlier you see a gap, the less it costsCost to cover the same 200-hour gap, by weeks of notice, $K (demo data)1 week: overtime$16K3 weeks: contractors$13K6 weeks: part reschedule, part contractors$8K10 weeks: reschedule start dates$4KOvertime and rush contractors cost more than planned hours; a forward view leaves the cheap options openThe earlier you see a gap, the less it costsBars of the cost to cover a 200-hour gap: $16K with one week of notice (overtime), $13K with three weeks (contractors), $8K with six weeks and $4K with ten weeks (rescheduling start dates).Demo dataThe earlier you see a gap, theless it costsCost to cover the same 200-hour gap, by weeksof notice, $K (demo data)1 week: overtime$16K3 weeks: contractors$13K6 weeks: part reschedule, part contractors$8K10 weeks: reschedule start dates$4KSeeing the gap 10 weeks ahead cuts the costto a quarter.

If two or more of these sound familiar, your planning is reacting instead of planning.

Each symptom has a direct cost. Overtime and contractors cost more than planned hours. Idle staff cost salary with no revenue. Late delivery costs client trust and, often, penalties. Late hiring costs deals you could not take.

The fix is not a bigger spreadsheet. It is a model that joins demand and capacity automatically and shows the gap by week, team and skill. Then leaders can act early, when options are still cheap.

Capacity planning also fails when it lives in one team. Sales sees pipeline. Operations sees schedules. Finance sees costs. Nobody sees all three together. Our model puts them side by side, so every leader works from the same forward view and the trade-offs become visible.

The earlier you see a gap, the more options you have and the less each one costs.

How we work

We build your capacity planning model in five steps, on your own data

We do not hand you a generic template. The build follows a capacity planning assessment and starts only when your data and planners are ready; if they are not, we begin with advisory or training. We then build the model from your demand and capacity data, in five steps. Each step ends with a working output you can review.

Your capacity planning model in five steps

Select a stage, use Next or the arrow keys

Map demand. Demand you can count on. Map demand from pipeline, orders or project plans, and convert it into hours or units.

Step 1 of 5

The model usually runs in Power BI and refreshes on its own. Every formula is documented, so operations and finance read the numbers the same way.

Demand and capacity are both converted into the same unit, usually hours or machine time. That sounds simple, but it is where most spreadsheets break. We agree the conversion rules with your managers, test them on recent history and adjust until the model matches reality.

Once the model is live, the weekly planning meeting changes. Instead of debating who is busy, managers review the gap and choose an action. The model then shows the effect of that action at once.

The model is planned to go live within the first phase of the engagement. We then run it alongside your current spreadsheet for a few cycles and train your planners, so your team can compare results and trust the new view before the old one is retired.

data modernization projectsanalytics as a service
What we offer

Workforce, production and capacity requirement planning answer different questions

Different businesses face different limits. An agency runs out of people. A plant runs out of machine time. We build models for each type, often combined in one view.

Agencies decide when to hire

Workforce planning: billable hours by role against pipeline, with bench time and hiring needs. Linked to pipeline. Bench time is visible. Roles and skills both count.

  • Linked to pipeline
  • Bench time visible
  • Hiring needs by role

Capacity requirement planning (CRP) deserves a plain explanation. It turns planned production orders into the hours needed at each work center, period by period, and compares them with available hours. It depends on accurate routings, work centers and planned production orders from an ERP with manufacturing features, such as NetSuite or Odoo.

For agencies, this is the core of capacity planning software for agencies, built on your own data instead of another tool.

In practice, many businesses need more than one type. A manufacturer plans machines and people. An agency plans roles and skills. One model can hold both, so leaders see every constraint in one place.

We start with the constraint that limits revenue most. For an agency, that is usually senior roles. For a plant, it is usually one bottleneck machine. Fixing the tightest constraint first gives the fastest return on the planning effort.

The model then shows the cost and service effect of each option, so the choice of lead, lag or match becomes a deliberate policy rather than an accident of timing.

supply chain analytics
KPIs we track

Five capacity KPIs show whether you are over or under

Each KPI has a written formula and source, and targets are set with you.

GoalEnough capacity to meet demand without idle cost
  1. Use of capacity
    • Utilization rate
    • Bench rate
  2. Fit to demandReview first
    • Capacity gap
    • Demand coverage
  3. Strain on teams
    • Overtime and contractor share
Goal, drivers, metrics. The highlighted driver is the one to review first.

Productive time protected

Demo

Utilization rate: productive or billable hours divided by available hours.

The gap in plain numbers

Demo

Capacity gap: required minus available capacity per period.

Demand you can deliver

Demo

Demand coverage: share of forecast demand current capacity delivers on time.

Less idle payroll

Demo

Bench rate: share of available hours not assigned to work.

Early warning on burnout

Demo

Overtime and contractor share of total hours.

Read together, they show whether to add capacity, move work or hold steady. A high utilization rate with rising overtime usually points to hiring. A high bench rate suggests sales should fill the gap first.

Sample views

One view shows where demand outruns capacity and what closes the gap

Our sample chart, on demo data, shows a design team's demand against available hours for the next 12 weeks. Bars above the capacity line are overloads; bars well below it are idle time. On the current plan, the team is 293 hours over in weeks 6 to 9. Hiring one designer in week 4 cuts that to 51 hours. The same view also compares overtime and contractors. Book a consultation for a live walkthrough.

Hiring one designer in week 4 closes most of the gapWeekly design demand bars against two capacity lines: the current 340 hours leaves 293 hours over in weeks 6 to 9; one hire from week 4 lifts capacity to 410 hours and leaves 51 hours over, 39 of them in week 7.Demo dataHiring one designer in week 4 closes most of the gapDesign team, demand vs available hours per week, next 12 weeks0100200300400500W1W2W3W4W5W6W7W8W9W10W11W12W7: gap down to 39 hWith one hire51 h over, weeks 7 to 8Current plan293 h over, weeks 6 to 9Demand, hoursStill over with the hireThe same view compares overtime only (161 h unmet) and contractors (0 h unmet, highest cost)Hiring one designer in week 4 closes most of the gapWeekly design demand bars against two capacity lines: the current 340 hours leaves 293 hours over in weeks 6 to 9; one hire from week 4 lifts capacity to 410 hours and leaves 51 hours over, 39 of them in week 7.Demo dataHiring one designer in week 4closes most of the gapDesign team, demand vs available hours perweek, next 12 weeks0250500W1W3W5W7W9W11W1239 hWith one hire: 51 h overCurrent plan: 293 h overStill over with the hire

Managers use it in the weekly planning meeting to decide what to move, who to hire and which projects to start.

Book a consultation
Benefits

Good capacity planning protects margin and delivery at once

Operations leaders see overloads weeks ahead.

They can reschedule, hire or bring in contractors on their own terms, not in a rush.

Forecast error falls with each planning cycleLine chart: the gap between forecast and actual demand falls from 24% in the first quarter to 8% in the sixth.Demo dataForecast error falls with each planning cycleGap between forecast and actual demand, %, by quarter since the model went live0%10%20%30%Q1Q2Q3Q4Q5Q68% after six quarters24% in the first quarterEach cycle compares forecast with actual demand, so hiring and capacity plans get more reliableForecast error falls with each planning cycleLine chart: the gap between forecast and actual demand falls from 24% in the first quarter to 8% in the sixth.Demo dataForecast error falls with eachplanning cycleGap between forecast and actual demand, %, byquarter since the model went live0%15%30%Q1Q2Q3Q4Q5Q68%From 24% in the first quarter to 8% aftersix.

Sales gets realistic delivery dates, which builds client trust. Finance sees how utilization and staffing costs drive margin, and can plan hiring against forecast demand. Teams face fewer crunch periods and less idle time, which helps retention.

Over time, the model builds a record of forecast against actual demand, so each planning cycle gets more accurate.

The result is a business that grows on purpose, not by accident.

It also makes growth plans credible to investors and lenders, because hiring and capacity are tied to demand.

Platforms we use

Our capacity planning tools connect the systems you already use

Most capacity planning tools are built into one product and only see their own data. We take a different approach. We connect the systems where demand and capacity already live and build one model across them.

Demand and capacity data meet in one capacity modelCRM and ERP demand plus timesheet and assignment capacity flow through automation into a Power BI capacity model that frames hire, reschedule or subcontract.Demand and capacity meet in one modelDemand sourcesHubSpot or SalesforceNetSuite, Odoo, ZohoQuickBooks ordersCapacity sourcesTimesheetsAirtable assignmentsProject toolsAutomationZapier, Make, n8nCapacity modelPower BI heatmapHire, rescheduleor subcontractcost of each optionTimesheets and spreadsheets are collected automatically, not retypedDemand and capacity data meet in one capacity modelCRM and ERP demand plus timesheet and assignment capacity flow through automation into a Power BI capacity model that frames hire, reschedule or subcontract.Demand and capacity meetin one modelDemand sourcesHubSpot or SalesforceNetSuite, Odoo, ZohoQuickBooks ordersCapacity sourcesTimesheetsAirtable assignmentsProject toolsAutomationZapier, Make, n8nCapacity modelPower BI heatmapHire, reschedule or subcontractcost of each optionTimesheets and spreadsheets are collectedautomatically, not retyped
HubSpotImplementation, reporting and CRM dataSalesforceSalesforce reporting, dashboards and integrationPower BIPower BI dashboards and developmentGoogle Analytics 4GA4, tracking and attribution set up rightERPNetSuite, Odoo and Zoho implementation and reportingQuickBooksQuickBooks reporting, forecasting and integration

Typical sources are HubSpot or Salesforce for pipeline; NetSuite, Odoo, Zoho or QuickBooks for orders, production and costs; and Airtable or project tools for assignments. The model and dashboards run in Power BI. Zapier, Make or n8n collect timesheets and spreadsheet data automatically.

Already using dedicated capacity planning software? We bring its data into the wider view, so leaders see capacity next to revenue and cost.

The advantage is a single view. Pipeline, delivery and cost live side by side, so a sales commitment, a hiring decision and a margin forecast are all made on the same numbers. And because there is no new license to buy, the model fits the budget of a mid-size company.

operations automation
Industries

The method is the same across industries; the limits differ

Agencies, professional services, manufacturers and construction firms all plan capacity. What runs out first is different in each.

The planning method is the same; the constraint differs by industryThree mini heatmaps: agency billable hours by role, manufacturing machine load with line 3 at 118 percent, and construction crews and equipment.Demo dataAgencies and servicesBillable hours by roleStrategyDesignDevPMW1W8Strategy role at 112% in week 5Same model, different constraintManufacturingMachine load by work centerLine 1Line 2Line 3PackW1W8Line 3 at 118% in weeks 3 and 4Same model, different constraintConstructionCrews and equipment by projectCrew ACrew BCraneSubsW1W8Crane booked twice in week 6Same model, different constraintThe planning method is the same; the constraint differs by industryThree mini heatmaps: agency billable hours by role, manufacturing machine load with line 3 at 118 percent, and construction crews and equipment.Demo dataAgencies and servicesBillable hours by roleStrategyDesignDevPMW1W8Strategy role at 112% in week 5ManufacturingMachine load by work centerLine 1Line 2Line 3PackW1W8Line 3 at 118% in weeks 3 and 4ConstructionCrews and equipment by projectCrew ACrew BCraneSubsW1W8Crane booked twice in week 6

Agencies and services firms: steady utilization

Billable hours, bench time and hiring needs by role, linked to pipeline.

Manufacturing: no surprise bottlenecks

Line and machine load, shifts and capacity requirement planning by work center.

Construction: bids you can staff

Crews, equipment and subcontractors across projects, linked to schedules and bids.

We start with the constraint that costs you most, then add the others. The model, KPIs and planning routine stay the same, so teams across sites or departments speak one language about capacity.

Every model is built on demo data first, so you can see the structure before we connect your systems.

manufacturingconstruction
Frequently asked questions

Capacity planning: questions operations leaders ask before building a model

How do you calculate capacity?

Available capacity equals the number of resources times available time times a utilization factor. For example, with illustrative figures, 10 people with 160 hours each and a 75 percent utilization target give 1,200 productive hours a month. Compare this with the hours forecast demand requires to find your capacity gap.

What is the difference between capacity planning and resource planning?

Capacity planning asks whether you have enough people, machines or time in total to meet expected demand. Resource planning assigns specific people or equipment to specific tasks and dates. Capacity planning comes first and sets the limits; resource planning then works within them.

What tools are used for capacity planning?

Capacity planning often starts in spreadsheets, then moves to capacity planning tools or to modules in ERP or project software. We build tool-agnostic models in Power BI that combine CRM, ERP and project data, so capacity is visible next to pipeline, revenue and cost.

A capacity planning assessment shows your gap and how to close it

Start with a capacity planning assessment. We review how you forecast demand, where capacity data lives and how planning decisions are made today. We map your main constraints, test the data and outline the model and dashboard that fit your business.

You receive a short written recommendation with scope, timeline and price, plus quick improvements you can make even without us. If a model is premature, the recommendation says so. Prefer to start small? Our capacity planning template is a practical first step for teams still in spreadsheets.

We also offer strategic planning advisory on hiring plans, shift patterns or expansion, and an AI and data readiness assessment if capacity is part of a wider data program. Book a consultation to get started.

The assessment has a fixed scope and price, agreed before it starts. It usually involves short interviews with operations, sales and finance, and a review of sample data. One consultant leads it from start to finish.

At the end, you will know the size of your capacity gap, what is causing it and the cheapest way to close it. That answer is designed to inform the next hiring or scheduling decision.

strategic planning advisoryAI readiness assessmentoperational analytics
See how we work