Blog · Board and management reporting · Sales teams
Regional manager KPIs compare location revenue, gross margin, and target attainment on consistent definitions. Use a worked regional review to separate the net result from the locations that need attention.
Regional manager KPIs should compare location revenue, margin, and target attainment using consistent periods and definitions. Show both the regional total and each location's dollar exception, because a region near target can still contain a substantial local problem.
Revenue says how much business the region delivered. Gross profit says what remains after the agreed cost of goods sold. Gross margin expresses that profit relative to sales, while target attainment expresses actual revenue relative to the approved revenue target.
None replaces the others. A location can beat its revenue target through low-margin sales, or have a strong margin on too little revenue. Keep the measures together and assign an owner to the question each raises.
The regional manager owns the review and follow-up. Finance owns the revenue and cost definitions and reconciliation. Location managers explain the operational circumstances, while sales operations validates customer and location assignments. A target should come from the approved plan, with its effective period recorded, rather than being revised to match the latest outcome.
Broader sales KPIs for B2B sales teams cover selling performance. The regional review has a narrower job: decide which location exceptions deserve management time.
Use a ledger or sales export with location ID, posting period, net revenue, and cost of goods sold. Obtain the approved target file with the same location IDs and periods. Summarize actuals by location before attaching the target, so the target does not repeat on every transaction.
For a US distributor reviewing April 2026, the inputs are:
| Location | Revenue (USD) | COGS (USD) | Revenue target (USD) |
|---|---|---|---|
| Denver | 420,000 | 294,000 | 400,000 |
| Boise | 240,000 | 180,000 | 300,000 |
| Reno | 180,000 | 108,000 | 150,000 |
| Region | 840,000 | 582,000 | 850,000 |
All amounts cover the same month, are in USD, and use the same cost policy. Revenue is net of credits and returns posted to the period. The example has no location openings, closures, or transfers during the month.
In a real review, retain those events as context. A newly opened branch may need a separate ramp schedule; a closed branch may remain in the ledger after it stops trading. Removing either silently changes the population and can make a regional trend look better than the underlying business.
Gross profit = Revenue - Cost of goods sold
Gross margin = Gross profit / Revenue
Revenue target attainment = Revenue / Revenue target
Dollar gap to target = Revenue - Revenue target
The input table produces this scorecard. Percentages are rounded to one decimal place; calculations use unrounded amounts.
| Location | Gross profit (USD) | Gross margin | Revenue attainment | Gap to target (USD) |
|---|---|---|---|---|
| Denver | 126,000 | 30.0% | 105.0% | 20,000 |
| Boise | 60,000 | 25.0% | 80.0% | -60,000 |
| Reno | 72,000 | 40.0% | 120.0% | 30,000 |
| Region | 258,000 | 30.7% | 98.8% | -10,000 |
Denver's gross profit is 420,000 - 294,000 = $126,000, and its margin is 126,000 / 420,000 = 30.0%. Boise's attainment is 240,000 / 300,000 = 80.0%, while Reno's is 180,000 / 150,000 = 120.0%.
If the input table occupies A1:D4, enter these Excel formulas in E2:H2 and fill down:
=B2-C2
=IF(B2=0,"No revenue",E2/B2)
=IF(D2=0,"No target",B2/D2)
=B2-D2
For the regional ratios, use =SUM(E2:E4)/SUM(B2:B4) for margin and =SUM(B2:B4)/SUM(D2:D4) for attainment. Do not average the displayed percentages. The gross profit margin guide explains the revenue-weighted calculation in more detail.
The regional profit must reconcile both ways. Revenue less cost gives 840,000 - 582,000 = $258,000. Summing location profit gives 126,000 + 60,000 + 72,000 = the same $258,000.
The target reconciliation is equally important: 20,000 - 60,000 + 30,000 = -$10,000, matching 840,000 - 850,000. The total is almost on target, but it includes $50,000 of favorable location gaps offsetting Boise's $60,000 shortfall.
Add a gross-shortfall check to the meeting pack. With gaps in H2:H4, this Excel formula returns -$60,000:
=SUMIFS(H2:H4,H2:H4,"<0")
Microsoft's SUMIFS documentation confirms the function sums entries meeting the selected criteria. This separates unfavorable gaps from favorable offsets instead of losing both inside the net result.
With attainment in G2:G4, =COUNTIFS(G2:G4,"<1") returns one location below target. Microsoft documents COUNTIFS as a count of entries meeting criteria. The count identifies spread; the dollar shortfall identifies materiality. Both depend on complete target records and should exclude locations labeled as having no target.
Finally, tie the actuals to the regional ledger and the target total to the approved plan. Matching the arithmetic within a table does not prove an export is complete.
Boise is the first exception to investigate because it is below revenue target and has the lowest gross margin in the displayed population. The table does not prove a cause. Review credits, product mix, customer losses, price realization, and comparable trading activity before choosing an action.
Reno deserves a different conversation: its attainment and margin are strongest, but its gross profit is smaller than Denver's. Ask which practices could transfer without assuming another location has the same customer mix or capacity.
Record an accountable owner, the next evidence needed, and a review date for each exception. Regional manager data analysis covers the follow-up investigation, while commercial manager KPIs addresses the broader commercial role. Keep those discussions connected without expanding the regional scorecard into every available measure.
Covirage is not affiliated with Microsoft.
Bring your location sales or ledger export and approved target file. Covirage maps the columns, and its tools compute and check location and regional 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 sales insights for the wider review of sales performance.
Start with revenue against approved target and gross profit against the same period's revenue. Review both percentage attainment and the dollar shortfall by location. Then investigate the customer, product, staffing, or service measures that could explain the largest material exceptions.
Use target attainment and margin percentages alongside absolute dollars. Confirm targets reflect the approved scope and trading period, and identify openings or closures separately. A small location can lead on attainment while a larger location contributes more gross profit.
Calculate regional attainment by dividing total actual revenue by total target revenue. An unweighted average gives every location equal influence regardless of its target. Keep location percentages for diagnosis, while using the ratio of totals for the regional result.