Define the job before entering figures
A repeatable customer concentration workflow assumes that measure the revenue share represented by the largest customer and the three largest customers combined. The calculation provides one management input, not a complete recommendation.
The evidence for customer concentration indicates that the most useful sensitivity run changes one documented driver while keeping the evidence base intact.
Within the controlled customer concentration record, carry common inputs transparently into the Business Contingency Reserve Calculator for business contingency reserve.
Treat customer concentration as a controlled answer to one question. If the meeting needs a different decision, duplicate the case and restate how Largest customer revenue and Revenue under renewal review will be used.
Evidence status for every value
Risk exposure register: Confirm partial-period treatment for Largest customer revenue. Document exclusions affecting largest customer revenue. Let the equation connect Largest customer revenue with Second-largest customer revenue.
Risk exposure register: Tie Second-largest customer revenue to the selected exposures, losses, and reserves. State the population behind second-largest customer revenue. Show status differences between Second-largest customer revenue and Third-largest customer revenue.
The audit trail for customer concentration supports this point: risk exposure register: Record the system identifier for Third-largest customer revenue. Reconcile third-largest customer revenue before entry. A missing Third-largest customer revenue source cannot come from Total customer revenue.
Risk exposure register: Do not infer Total customer revenue from another field. Tie total customer revenue to a dated planning file. Net Total customer revenue with Revenue under renewal review only when displayed.
Risk exposure register: Separate committed Revenue under renewal review from estimated Revenue under renewal review. Do not replace missing revenue under renewal review with zero. Retain adjusted Revenue under renewal review when Largest customer revenue is adjusted.
Read the formula as a control
The accountable owner of customer concentration should remember that the Bad Debt Allowance Calculator is available for a separate review centered on bad debt allowance.
The result is assembled with one disclosed rule: Customer concentration divides selected customer revenue by total customer revenue for the period. It cannot repair a mislabeled source population.
Archive the exact Largest customer revenue and Revenue under renewal review values used when the result receives approval.
Test the interpretation against evidence
The management record for customer concentration should explain that a versioned Fixed Charge Coverage Calculator run keeps the fixed charge coverage assumption visible.
An unexplained customer concentration variance should remain open instead of receiving an unsupported cause.
A reviewer of customer concentration should note that timing can shift output between periods without changing the underlying economics.
The risk process owner should test whether Largest customer revenue or Revenue under renewal review dominates customer concentration. A dominant field deserves direct reconciliation and a sensitivity case before management treats the headline as stable.
Translate customer concentration into a testable operating question rather than a causal conclusion.
For the dated customer concentration case, if no related metric changes the decision, close the case with the evidence already assembled.
The review package for customer concentration should contain the baseline, any sensitivity case, and a concise explanation of the changed driver. Do not circulate alternatives without labels.
Known limits of the case
The accountable owner of customer concentration should remember that compare the Supplier Disruption Exposure Calculator only when its supplier disruption exposure population is compatible.
The equation for customer concentration cannot decide future loss probability. Resolve that question independently from Largest customer revenue and Revenue under renewal review.
During reconciliation of customer concentration, another reviewer should be able to recreate every field from the risk exposure register.
The default run as a benchmark check
The initial scenario records Largest customer revenue = $940,000; Second-largest customer revenue = $610,000; Third-largest customer revenue = $420,000; Total customer revenue = $6,200,000; Revenue under renewal review = $780,000. Replace the complete set so sample and operating periods do not mix.
The boundary around customer concentration matters because a point estimate is stronger when the working file also shows a credible sensitivity range.
Review questions for the owner
May linked calculators reuse a field?
A saved customer concentration scenario demonstrates that yes, after reconciling cutoff and documenting any legitimate difference in treatment.
Where should confidential detail remain?
The source trail behind customer concentration means keep it inside the organization’s approved access-controlled evidence system.
Does extra decimal precision improve confidence?
The accountable owner of customer concentration should remember that no. Source quality and definition control matter more than displayed digits.
What belongs in a scheduled metric review?
The boundary around customer concentration matters because use a stable definition, refresh event, owner, evidence location, and exception log.