What the numbers are meant to answer
The distributor margin file adds an important point: the useful question is narrower than the title may suggest. Compare a distributor purchase price with its resale price after variable handling cost and show both margin and markup. Keep the calculation attached to the selling period it describes.
In the distributor margin review, assign an owner to the assumption set and note when it was prepared. The next reviewer can then distinguish a revision from a correction.
Figures to collect first
Distributor purchase price. The pricing file supporting distributor margin should confirm it. Invoice cost per unit. Trace Distributor purchase price independently from Distributor resale price before another reviewer receives the distributor margin file.
Distributor resale price. For distributor margin, Price charged downstream. Do not replace Distributor resale price with a target while treating Variable handling per unit as observed history.
Variable handling per unit. Before the distributor margin calculation, verify this instruction: Per-unit logistics or handling cost. Keep Variable handling per unit and Units distributed on the same distributor margin basis during an alternative review.
Units distributed. For the selected selling period in distributor margin, Units in the measured period. Write exclusions for Units distributed beside the saved value for Distributor purchase price.
The operating context for distributor margin is clear: a change in contribution margin warrants its own worksheet. Open the Contribution Margin Calculator instead of hiding it in an unrelated field.
Formula and intermediate values
A second reader of distributor margin should note that this model uses no lookup table: Distributor contribution subtracts purchase and handling cost from resale price; margin divides contribution by resale price. Every changing amount is visible among the fields.
Challenge the baseline
A reversal caused by Units distributed means the conclusion is conditional on that input and should be labeled accordingly.
Compare a documented alternative for Units distributed with the baseline; do not move unrelated fields merely to create a range.
What can change the headline
A second reader of distributor margin should note that a zero or negative answer may be meaningful rather than erroneous. Check the business interpretation before replacing it with a more comfortable assumption.
If Distributor purchase price comes from a firm record but Units distributed is forecast, label the second value as the uncertainty driving the case.
Interpret distributor margin only after Distributor purchase price and Units distributed have been reconciled. Their evidence may use different cutoff, allocation, or recognition rules.
Once distributor margin is reconciled, document what the business will change, who owns the work, and when the effect will be measured.
While examining distributor margin, the next useful check may be value based pricing; if so, retain this output and open the Value Based Pricing Calculator.
Reproduce the sample case
Entries used in this walkthrough: Distributor purchase price = $42; Distributor resale price = $61; Variable handling per unit = $3.50; Units distributed = 5000 units.
The operating context for distributor margin is clear: enter the figures, calculate, and retain each row. Change Units distributed afterward; only effects connected to that field should move.
Questions the formula cannot settle
The operating context for distributor margin is clear: a mathematically correct answer can still be unsuitable. Rebates, credit losses, inventory carrying cost, taxes, and fixed distribution overhead are not included.
While examining distributor margin, attach the calculation to the proposal, ledger extract, or workpaper from which its figures came.
The distributor margin file adds an important point: preserve the current calculation while the Price Increase Revenue Impact Calculator examines price increase revenue impact from its own inputs.
In the distributor margin review, before acting, decide whether bundle pricing margin needs the distinct treatment offered by the Bundle Pricing Margin Calculator.
Checks for a second reader
Can cash and accrual figures be mixed?
The operating context for distributor margin is clear: only when the conversion is explicit. Otherwise keep a consistent accounting basis.
Can two entities share one calculation?
While examining distributor margin, use separate runs unless their records, currency, dates, and definitions genuinely match.
What belongs in the archive?
The distributor margin file adds an important point: keep inputs, rows, preparation date, owner, purpose, and evidence version.
Can the result be copied into a report?
In the distributor margin review, yes, with its assumptions, date, and limitations attached.
Who should own the assumptions?
From a distributor margin standpoint, assign the case to the person responsible for the supporting pricing file.
May default values remain in a saved case?
A second reader of distributor margin should note that only when they are actual documented values; otherwise replace or clearly label them illustrative.