Wholesale Order Profitability Planner methodology

unitsOrdered = cases ordered * units per case

productRevenueExTax = cases ordered * wholesale price per case

totalRevenueExTax = product revenue + freight recovered

productCostExTax = units ordered * product cost per unit

fulfilmentCostExTax = pick/pack + case handling + freight

paymentAndBadDebtCostExTax = total revenue * (payment fee + bad-debt rate)

fundingCostExTax = total revenue * annual funding rate * payment days / 365

totalCostExTax = product + fulfilment + payment leakage + funding

contributionExTax = total revenue - total order cost

contributionMargin = contribution / total revenue

requiredPricePerCaseExTax = protected order cost and leakage solved at target margin

minimumOrderCases = fixed order cost / contribution per case before fixed cost

Money inputs and outputs use the currency selected in the scenario without changing the canonical methodology. Rates, margins, utilisation and buffers are entered as percentages and converted to decimal values for calculation.

• All inputs must be finite and inside the visible validation boundaries.
• Rates are retained as decimal values and shown as percentages only at the presentation boundary.
• The worked fixture must expose every declared result: unitsOrdered, productRevenueExTax, totalRevenueExTax, productCostExTax, fulfilmentCostExTax, paymentAndBadDebtCostExTax, fundingCostExTax, totalCostExTax, contributionExTax, contributionMargin, requiredPricePerCaseExTax, minimumOrderCases.
• Scenario comparison changes one declared driver while holding the remaining industry records constant.

Cases ordered minimum

casesOrdered ≥ 0 whole cases/order — A lower value is rejected before calculation.

Cases ordered maximum

casesOrdered ≤ 100,000,000 whole cases/order — A higher value is rejected before calculation.

Units per case minimum

unitsPerCase ≥ 1 whole units/case — A lower value is rejected before calculation.

Units per case maximum

unitsPerCase ≤ 100,000 whole units/case — A higher value is rejected before calculation.

Wholesale price per case minimum

pricePerCaseExTax ≥ 0 currency units/case, ex tax — A lower value is rejected before calculation.

Wholesale price per case maximum

pricePerCaseExTax ≤ 10,000,000 currency units/case, ex tax — A higher value is rejected before calculation.

Product cost per unit minimum

productCostPerUnitExTax ≥ 0 currency units/unit, ex tax — A lower value is rejected before calculation.

Product cost per unit maximum

productCostPerUnitExTax ≤ 10,000,000 currency units/unit, ex tax — A higher value is rejected before calculation.

Pick and pack cost per order minimum

pickPackCostPerOrderExTax ≥ 0 currency units/order, ex tax — A lower value is rejected before calculation.

Pick and pack cost per order maximum

pickPackCostPerOrderExTax ≤ 10,000,000 currency units/order, ex tax — A higher value is rejected before calculation.

Handling cost per case minimum

handlingCostPerCaseExTax ≥ 0 currency units/case, ex tax — A lower value is rejected before calculation.

Handling cost per case maximum

handlingCostPerCaseExTax ≤ 10,000,000 currency units/case, ex tax — A higher value is rejected before calculation.

Freight cost minimum

freightCostExTax ≥ 0 currency units/order, ex tax — A lower value is rejected before calculation.

Freight cost maximum

freightCostExTax ≤ 10,000,000 currency units/order, ex tax — A higher value is rejected before calculation.

Freight recovered minimum

freightRecoveredExTax ≥ 0 currency units/order, ex tax — A lower value is rejected before calculation.

Freight recovered maximum

freightRecoveredExTax ≤ 10,000,000 currency units/order, ex tax — A higher value is rejected before calculation.

Payment fee rate minimum

paymentFeeRate ≥ 0 decimal fraction of wholesale order revenue — A lower value is rejected before calculation.

Payment fee rate maximum

paymentFeeRate ≤ 1 decimal fraction of wholesale order revenue — A higher value is rejected before calculation.

Expected bad-debt rate minimum

badDebtRate ≥ 0 decimal fraction of wholesale order revenue not collected — A lower value is rejected before calculation.

Expected bad-debt rate maximum

badDebtRate ≤ 1 decimal fraction of wholesale order revenue not collected — A higher value is rejected before calculation.

Payment term days minimum

paymentTermDays ≥ 0 whole days/order payment term — A lower value is rejected before calculation.

Payment term days maximum

paymentTermDays ≤ 3,650 whole days/order payment term — A higher value is rejected before calculation.

Annual funding rate minimum

annualFundingRate ≥ 0 decimal annual funding rate — A lower value is rejected before calculation.

Annual funding rate maximum

annualFundingRate ≤ 1 decimal annual funding rate — A higher value is rejected before calculation.

Target wholesale margin minimum

targetMargin ≥ 0 decimal fraction of wholesale order revenue — A lower value is rejected before calculation.

Target wholesale margin maximum

targetMargin ≤ 0.99 decimal fraction of wholesale order revenue — A higher value is rejected before calculation.

• Costs, capacity, contract terms, tax rates and targets are supplied by the user.
• No provider default, jurisdictional rule or industry benchmark is embedded.
• The shared engine retains full precision and display formatting never feeds calculation.

This planner has no current policy-data dependency. Its commercial assumptions are user supplied. Registered family-level regression suites exercise the shared business-logic engine and worked-result reconciliation.

• Results are only as reliable as the timing, scope and basis of the entered records.
• The workflow does not predict demand or establish accounting, tax, contractual or legal treatment.

This is educational decision support, not tax, accounting, legal or financial advice. Check the treatment of your actual transactions under the rules that apply to your business and seek qualified advice where appropriate.

Registered family-level suites test formula invariants and example reconciliation; the release ledger records that coverage without claiming a separate oracle for every line of public copy. There is no official threshold or benchmark to refresh for this planner. Commercial inputs remain user-supplied because they vary by business and contract.

1. 2026-07-31: Initial public release of the planner and methodology after pre-launch calculation, content, source and interaction review.