Blog · Territory, capacity and quota planning
Managing multiple customer segments requires comparing contribution with the service workload each group creates. Build a reconciled spreadsheet from customer revenue, direct costs, and service hours before allocating commercial capacity.
Multiple customer segments compete for attention when sales and service teams share limited capacity. Compare contribution dollars with the hours each group requires, then test specific opportunities against the capacity that remains. Revenue rankings alone do not show the trade-off.
A US equipment supplier serves standard supply accounts, managed service accounts, and custom project customers. Its planning question is where to put additional service effort without missing commitments to existing accounts.
This article assumes the groups already exist. B2B customer segmentation from the ledger covers how to define them. Use one primary group per account for financial totals, with separate tags for overlapping attributes such as industry and region.
The SBA's market research guidance recommends examining competition by product line or service and market segment. Pair that market view with your own delivery economics: an attractive market still requires enough capacity to serve the work you accept.
Agree on the scarce resource before calculating efficiency. Here it is general service hours. If specialist installation hours are the actual constraint, a ratio based on all service hours can point toward the wrong allocation.
Take quarterly net revenue and direct product costs from the customer profitability export. Bring service hours from the activity file for the same quarter. The illustrative table below excludes sales tax and uses revenue after credits.
Finance supplies a standard service cost of $100 per recorded hour. It is a costing assumption for this comparison, not a claim that every hour removed saves that amount in cash. Direct product costs exclude the service labor being allocated separately.
| Account | Primary group | Revenue (USD) | Direct product costs (USD) | Service hours |
|---|---|---|---|---|
| S01 | Standard supply | 50,000 | 30,000 | 20 |
| S02 | Standard supply | 30,000 | 18,000 | 15 |
| M01 | Managed service | 60,000 | 30,000 | 60 |
| M02 | Managed service | 40,000 | 20,000 | 40 |
| C01 | Custom projects | 45,000 | 20,000 | 80 |
| C02 | Custom projects | 25,000 | 10,000 | 50 |
| Total | 250,000 | 128,000 | 265 |
Put these rows in A1:E7 and the service rate in K2. Calculate allocated service cost in F2 and contribution in G2:
=E2*$K$2
=C2-D2-F2
Fill through row 7. The contribution amounts are $18,000, $10,500, $24,000, $16,000, $17,000, and $10,000, in table order. Contribution is before unallocated overhead and therefore differs from net profit.
Place the three group names in J5:J7. In K5 through O5, calculate revenue, product costs, hours, allocated service cost, and contribution respectively:
=SUMIFS($C$2:$C$7,$B$2:$B$7,J5)
=SUMIFS($D$2:$D$7,$B$2:$B$7,J5)
=SUMIFS($E$2:$E$7,$B$2:$B$7,J5)
=SUMIFS($F$2:$F$7,$B$2:$B$7,J5)
=SUMIFS($G$2:$G$7,$B$2:$B$7,J5)
These formulas work in Excel and Google Sheets, following the criteria-based summation documented by Microsoft and Google. Covirage is not affiliated with Microsoft or Google.
Contribution per hour in P5 is:
=IF(M5=0,"No recorded hours",O5/M5)
| Group | Revenue (USD) | Product costs (USD) | Hours | Service cost (USD) | Contribution (USD) | Contribution per hour (USD) |
|---|---|---|---|---|---|---|
| Standard supply | 80,000 | 48,000 | 35 | 3,500 | 28,500 | 814.29 |
| Managed service | 100,000 | 50,000 | 100 | 10,000 | 40,000 | 400.00 |
| Custom projects | 70,000 | 30,000 | 130 | 13,000 | 27,000 | 207.69 |
| Total | 250,000 | 128,000 | 265 | 26,500 | 95,500 | 360.38 |
Hourly amounts are rounded to cents. Divide summed contribution by summed hours; do not average account or group ratios.
The proof is 250,000 - 128,000 - 26,500 = $95,500. Group revenue and direct costs must match the customer export, and 35 + 100 + 130 = 265 hours must match the activity file. Service costs also reconcile as 265 × 100 = $26,500.
Managed service generates the most contribution dollars. Standard supply generates the most contribution per recorded hour. Custom projects require the most hours. These are distinct observations; none automatically determines where the next hour belongs.
Suppose operations confirms 300 usable hours for the next comparable period and existing commitments still require 265. Available capacity is 300 - 265 = 35 hours. A proposed order requires 30 hours, brings $15,000 of revenue, and carries $9,000 of direct product costs.
At the agreed service rate, its allocated service cost is 30 × 100 = $3,000 and contribution is 15,000 - 9,000 - 3,000 = $3,000. Accepting it leaves five hours available. This order's economics, rather than a historical segment average, should inform approval; assess actual incremental cash costs separately when staffing is fixed.
Review service commitments using segments and tiers. If expansion depends on unmet product needs, a cross-sell matrix can identify candidates before you estimate their workload.
Bring a customer revenue file, direct costs, service activity, and your declared group assignments. Covirage maps the columns, and its tools compute and check contribution and workload comparisons; the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See capacity planning for the supporting planning context.
Service should reflect contractual obligations, customer needs, and the economics of delivery. Different contact schedules or support arrangements can be appropriate, but approve those policies explicitly. A segment's lower contribution does not cancel commitments already made to its customers.
Not necessarily. Revenue measures sales, while contribution also deducts the costs included in the report. A large segment may consume considerable service effort. Compare contribution dollars and contribution per constrained hour before deciding where extra capacity would help.
Use one primary commercial group for reconciliation and retain overlapping characteristics as separate tags. Assign clear precedence when several rules match. If a customer changes groups, preserve the historical assignment so migration can be distinguished from changing customer performance.