Blog · Board and management reporting
A business unit manager dashboard separates the operating results a manager can influence from shared costs assigned by corporate finance. Work through actuals, budget, a volume-and-cost bridge, and an allocation change using one US business unit.
A business unit manager dashboard compares a unit's revenue, gross profit, and controllable spending with budget, then shows shared corporate allocations separately. Its purpose is to distinguish an operating problem the manager can address from a cost assignment that requires a corporate decision. Every variance needs a consistent scope and an accountable owner.
Define the unit by the same location, product group, or responsibility code in both actuals and budget. State which costs the manager can approve within the review period. A centrally negotiated expense may be assigned to a unit without being locally controllable.
Use a short scorecard: the result, its budget variance, the operating driver, and the person responsible for reviewing it. Add a separate line for allocated corporate costs and a reconciliation to fully allocated unit profit.
The SEC's financial statement guide distinguishes revenue, cost of sales, gross profit, and operating expenses. A unit's internal contribution subtotal is a management measure with its own stated boundary. Label it explicitly so readers do not confuse it with the company's reported operating income.
For a broader choice of management views, see business dashboard examples. This example focuses on the boundary between local performance and corporate allocation.
The source workbook needs period, business unit, account, amount, and budget version. Retain invoice or journal references in the actuals export. Keep volume and unit-cost assumptions in the budget, and identify the shared pool, allocation percentage, and effective period in the allocation file.
Separate cost of goods sold from unit selling and support payroll. The IRS discussion of cost of goods sold includes production-related costs such as direct manufacturing labor and necessary manufacturing overhead. That illustrates why account classification matters: a cost already included in COGS must not appear again below gross profit.
In this distributor example, the payroll row below is selling and support payroll, excluded from COGS. Finance has agreed that payroll and other local operating expenses are controllable for this review.
An illustrative US distributor, Huron Industrial Supply, reviews its Central unit for September 2026. It sells a single standardized product in this simplified example. Budget volume is 10,000 units at $120 each, with COGS of $72 per unit. Actual volume is 9,500 units at the same selling price, with COGS of $74.40 per unit.
| Scorecard line | Budget (USD) | Actual (USD) | Actual minus budget (USD) |
|---|---|---|---|
| Revenue | 1,200,000 | 1,140,000 | -60,000 |
| COGS | 720,000 | 706,800 | -13,200 |
| Gross profit | 480,000 | 433,200 | -46,800 |
| Unit selling/support payroll | 180,000 | 176,000 | -4,000 |
| Other controllable expenses | 60,000 | 68,000 | 8,000 |
| Controllable unit contribution | 240,000 | 189,200 | -50,800 |
| Shared corporate allocation | 100,000 | 120,000 | 20,000 |
| Fully allocated unit profit | 140,000 | 69,200 | -70,800 |
Revenue checks as 10,000 × $120 = $1,200,000 budget and 9,500 × $120 = $1,140,000 actual. Actual COGS is 9,500 × $74.40 = $706,800. Gross margin is $480,000 / $1,200,000 = 40.0% budget and $433,200 / $1,140,000 = 38.0% actual.
Controllable unit contribution = Revenue − COGS − Controllable operating expenses
Fully allocated unit profit = Controllable unit contribution − Shared corporate allocation
Actual contribution is $433,200 − $176,000 − $68,000 = $189,200. Subtract the $120,000 allocation to reach $69,200. Expense variances use actual minus budget: a negative expense variance is favorable, while a negative profit variance is unfavorable.
The lower COGS total can look favorable until volume is considered. At actual volume and the budget cost rate, COGS would be 9,500 × $72 = $684,000. Actual cost is $22,800 above that amount.
Bridge the profit change in a fixed order: volume at budget economics, then cost rate at actual volume. Selling price is unchanged, so there is no price effect in this case.
| Driver | Calculation | Profit effect (USD) |
|---|---|---|
| Fewer units sold | (9,500 − 10,000) × (120 − 72) | -24,000 |
| Higher cost per unit | 9,500 × (72 − 74.40) | -22,800 |
| Lower selling/support payroll | 180,000 − 176,000 | 4,000 |
| Higher other controllable expense | 60,000 − 68,000 | -8,000 |
| Controllable contribution change | Sum of operating effects | -50,800 |
| Higher corporate allocation | 100,000 − 120,000 | -20,000 |
| Fully allocated profit change | Sum of all effects | -70,800 |
The proof is $240,000 − $24,000 − $22,800 + $4,000 − $8,000 = $189,200. The separate allocation effect then reconciles $140,000 − $70,800 = $69,200.
The manager should investigate lost volume, purchase cost changes, and local expense overruns. Finance should explain the allocation increase. Keep operating margin comparisons on the same cost boundary; use EBITDA margin only when that separate measure is explicitly required.
The allocation rule assigns Central 50% of a shared corporate pool. The budget pool is $200,000, giving $100,000. The actual pool is $240,000, giving $120,000. The percentage itself has not changed.
Now change only the actual shared pool to $200,000. Central's allocation becomes $200,000 × 50% = $100,000, and fully allocated profit becomes $189,200 − $100,000 = $89,200. The budget shortfall narrows to $140,000 − $89,200 = $50,800.
Local contribution remains $189,200. This variation explains how the unit's reported bottom line can improve without any change in local performance. Display the pool and rate beside the allocation so readers can reproduce it.
Before review, tie actual amounts to the unit ledger and budget amounts to the approved workbook. Check that all allocations across recipient units equal the shared pool, and that contribution less allocation equals fully allocated profit.
Bring your actuals export, approved budget, and allocation workbook to Covirage; it maps the columns, and its tools compute and check the figures within your stated unit boundaries. The external AI model explains the operating and allocation differences with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See financial planning and analysis reporting for the supporting workflow.
Start with revenue, gross profit, controllable operating expenses, and the resulting unit contribution against budget. Add the drivers that explain those results, such as sales volume and unit cost. Show shared corporate allocations separately, with the allocation basis visible.
Include them when the reporting policy requires a fully allocated result, but keep them distinct from controllable spending. Show both results and reconcile between them. Otherwise a change in corporate cost or allocation policy can look like a change in local execution.
The unit manager owns the operating response, while finance owns reconciliation, classification, and the approved budget comparison. Corporate finance should explain shared cost pools and allocation changes. Name an owner for every material variance and document the agreed next action.