Act on the result
Set minimum quantity and payment terms only after checking capacity and funding exposure.
Educational only: Business decision support, not accounting, tax or legal advice.
Privacy: No account is required. Tool inputs and results stay in this browser. Anonymous categorical usage analytics send only governed page, tool, cluster and action identifiers; tool inputs and results are never sent. Error monitoring is disabled. Optional saved state stays only on this device.
Update policy: Reviewed when formulas or official dependencies change.
Scope: Market-neutral small-business planning using your own assumptions.
What this planner helps you decide
Best for
Product businesses testing a wholesale order after discount, freight and payment terms.
Outputs
Order revenue, loaded order cost, contribution, margin and funding effect.
Start here
Enter one order quantity and all incremental production, fulfilment and financing costs.
Use a different tool when: Do not use this to set a profitable order floor; use Minimum Order Value Planner for that decision. Use this tool to test wholesale order contribution after discounts, production, freight, terms and minimum quantities.
Commerce & operations
Wholesale Order Profitability: order revenue
Order revenue, loaded order cost, contribution, margin and funding effect.
Amounts use the same currency as your inputs. No currency conversion is performed.
Your industry scenario
Price a wholesale order from case packs, product cost, handling, fulfilment, freight recovery, payment leakage, bad debt and funding time.
Your numbers stay in this browser
Whole cases in the customer order.
Whole saleable units packed into each case.
Entered product price for each case. Keep every amount on the same ex-tax currency basis.
Product cost for each unit packed in a case. Keep every amount on the same ex-tax currency basis.
Fixed fulfilment cost incurred once for the order. Keep every amount on the same ex-tax currency basis.
Variable handling and warehouse cost per case. Keep every amount on the same ex-tax currency basis.
Outbound freight cost for the order. Keep every amount on the same ex-tax currency basis.
Shipping amount charged separately to the wholesale customer. Keep every amount on the same ex-tax currency basis.
Share of total order revenue paid in processing fees.
Share of total order revenue expected not to be collected.
Entered days between invoicing and expected collection.
Entered annual cost of funding the order until collection.
Contribution margin to protect in the required case price.
Industry decision result
Set a case price and minimum order quantity that protect the entered margin after order-level and payment-term costs. Review every output on the same entered business basis.
- Units ordered
- 120
- Product revenue
- 1,200.00
- Total order revenue
- 1,280.00
- Product cost
- 600.00
- Fulfilment and freight cost
- 170.00
- Payment and bad-debt cost
- 38.40
- Payment-term funding cost
- 12.62
- Total wholesale order cost
- 821.02
- Wholesale order contribution
- 458.98
- Wholesale order margin
- 35.9%
- Required price per case
- 100.43
- Minimum order cases
- 2
Scenario comparison
Each row names the assumption axis changed from the baseline.
ScenarioResultDifference
Current industry scenario458.98Baseline
Lower Cases ordered405.76-53.22
Higher Cases ordered512.1953.22
Save these results, change an input, then compare the updated figures with this baseline.
The baseline is temporary in this tab and is not added to shared scenario links or generated reports.
Calculation details
View calculation detailsView the formulas and inputs used for these results.
Units ordered
Units ordered
cases ordered * units per case120 unitsResult120
Uses the named industry records and reports this output in units. The shared engine retains full precision; display rounding never feeds the calculation.
Wholesale Order Profitability Planner formulas →Inputs used by these formula steps
- Units orderedCases Ordered
- 10
- Units orderedUnits Per Case
- 12
- Units orderedPrice Per Case Ex Tax
- 120
- Units orderedProduct Cost Per Unit Ex Tax
- 5
- Units orderedPick Pack Cost Per Order Ex Tax
- 50
- Units orderedHandling Cost Per Case Ex Tax
- 2
- Units orderedFreight Cost Ex Tax
- 100
- Units orderedFreight Recovered Ex Tax
- 80
- Units orderedPayment Fee Rate
- 0.02
- Units orderedBad Debt Rate
- 0.01
- Units orderedPayment Term Days
- 30
- Units orderedAnnual Funding Rate
- 0.12
- Units orderedTarget Margin
- 0.25
Product revenue
Product revenue
cases ordered * wholesale price per case1,200 , ex taxResult1,200.00
Uses the named industry records and reports this output, ex tax. The shared engine retains full precision; display rounding never feeds the calculation.
Wholesale Order Profitability Planner formulas →Inputs used by these formula steps
- Product revenueCases Ordered
- 10
- Product revenueUnits Per Case
- 12
- Product revenuePrice Per Case Ex Tax
- 120
- Product revenueProduct Cost Per Unit Ex Tax
- 5
- Product revenuePick Pack Cost Per Order Ex Tax
- 50
- Product revenueHandling Cost Per Case Ex Tax
- 2
- Product revenueFreight Cost Ex Tax
- 100
- Product revenueFreight Recovered Ex Tax
- 80
- Product revenuePayment Fee Rate
- 0.02
- Product revenueBad Debt Rate
- 0.01
- Product revenuePayment Term Days
- 30
- Product revenueAnnual Funding Rate
- 0.12
- Product revenueTarget Margin
- 0.25
Total order revenue
Total order revenue
product revenue + freight recovered1,280 , ex taxResult1,280.00
Uses the named industry records and reports this output, ex tax. The shared engine retains full precision; display rounding never feeds the calculation.
Wholesale Order Profitability Planner formulas →Inputs used by these formula steps
- Total order revenueCases Ordered
- 10
- Total order revenueUnits Per Case
- 12
- Total order revenuePrice Per Case Ex Tax
- 120
- Total order revenueProduct Cost Per Unit Ex Tax
- 5
- Total order revenuePick Pack Cost Per Order Ex Tax
- 50
- Total order revenueHandling Cost Per Case Ex Tax
- 2
- Total order revenueFreight Cost Ex Tax
- 100
- Total order revenueFreight Recovered Ex Tax
- 80
- Total order revenuePayment Fee Rate
- 0.02
- Total order revenueBad Debt Rate
- 0.01
- Total order revenuePayment Term Days
- 30
- Total order revenueAnnual Funding Rate
- 0.12
- Total order revenueTarget Margin
- 0.25
Product cost
Product cost
units ordered * product cost per unit600 , ex taxResult600.00
Uses the named industry records and reports this output, ex tax. The shared engine retains full precision; display rounding never feeds the calculation.
Wholesale Order Profitability Planner formulas →Inputs used by these formula steps
- Product costCases Ordered
- 10
- Product costUnits Per Case
- 12
- Product costPrice Per Case Ex Tax
- 120
- Product costProduct Cost Per Unit Ex Tax
- 5
- Product costPick Pack Cost Per Order Ex Tax
- 50
- Product costHandling Cost Per Case Ex Tax
- 2
- Product costFreight Cost Ex Tax
- 100
- Product costFreight Recovered Ex Tax
- 80
- Product costPayment Fee Rate
- 0.02
- Product costBad Debt Rate
- 0.01
- Product costPayment Term Days
- 30
- Product costAnnual Funding Rate
- 0.12
- Product costTarget Margin
- 0.25
Fulfilment and freight cost
Fulfilment and freight cost
pick/pack + case handling + freight170 , ex taxResult170.00
Uses the named industry records and reports this output, ex tax. The shared engine retains full precision; display rounding never feeds the calculation.
Wholesale Order Profitability Planner formulas →Inputs used by these formula steps
- Fulfilment and freight costCases Ordered
- 10
- Fulfilment and freight costUnits Per Case
- 12
- Fulfilment and freight costPrice Per Case Ex Tax
- 120
- Fulfilment and freight costProduct Cost Per Unit Ex Tax
- 5
- Fulfilment and freight costPick Pack Cost Per Order Ex Tax
- 50
- Fulfilment and freight costHandling Cost Per Case Ex Tax
- 2
- Fulfilment and freight costFreight Cost Ex Tax
- 100
- Fulfilment and freight costFreight Recovered Ex Tax
- 80
- Fulfilment and freight costPayment Fee Rate
- 0.02
- Fulfilment and freight costBad Debt Rate
- 0.01
- Fulfilment and freight costPayment Term Days
- 30
- Fulfilment and freight costAnnual Funding Rate
- 0.12
- Fulfilment and freight costTarget Margin
- 0.25
Payment and bad-debt cost
Payment and bad-debt cost
total revenue * (payment fee + bad-debt rate)38.40 , ex taxResult38.40
Uses the named industry records and reports this output, ex tax. The shared engine retains full precision; display rounding never feeds the calculation.
Wholesale Order Profitability Planner formulas →Inputs used by these formula steps
- Payment and bad-debt costCases Ordered
- 10
- Payment and bad-debt costUnits Per Case
- 12
- Payment and bad-debt costPrice Per Case Ex Tax
- 120
- Payment and bad-debt costProduct Cost Per Unit Ex Tax
- 5
- Payment and bad-debt costPick Pack Cost Per Order Ex Tax
- 50
- Payment and bad-debt costHandling Cost Per Case Ex Tax
- 2
- Payment and bad-debt costFreight Cost Ex Tax
- 100
- Payment and bad-debt costFreight Recovered Ex Tax
- 80
- Payment and bad-debt costPayment Fee Rate
- 0.02
- Payment and bad-debt costBad Debt Rate
- 0.01
- Payment and bad-debt costPayment Term Days
- 30
- Payment and bad-debt costAnnual Funding Rate
- 0.12
- Payment and bad-debt costTarget Margin
- 0.25
Payment-term funding cost
Payment-term funding cost
total revenue * annual funding rate * payment days / 36512.62 , ex taxResult12.62
Uses the named industry records and reports this output, ex tax. The shared engine retains full precision; display rounding never feeds the calculation.
Wholesale Order Profitability Planner formulas →Inputs used by these formula steps
- Payment-term funding costCases Ordered
- 10
- Payment-term funding costUnits Per Case
- 12
- Payment-term funding costPrice Per Case Ex Tax
- 120
- Payment-term funding costProduct Cost Per Unit Ex Tax
- 5
- Payment-term funding costPick Pack Cost Per Order Ex Tax
- 50
- Payment-term funding costHandling Cost Per Case Ex Tax
- 2
- Payment-term funding costFreight Cost Ex Tax
- 100
- Payment-term funding costFreight Recovered Ex Tax
- 80
- Payment-term funding costPayment Fee Rate
- 0.02
- Payment-term funding costBad Debt Rate
- 0.01
- Payment-term funding costPayment Term Days
- 30
- Payment-term funding costAnnual Funding Rate
- 0.12
- Payment-term funding costTarget Margin
- 0.25
Total wholesale order cost
Total wholesale order cost
product + fulfilment + payment leakage + funding821.02 , ex taxResult821.02
Uses the named industry records and reports this output, ex tax. The shared engine retains full precision; display rounding never feeds the calculation.
Wholesale Order Profitability Planner formulas →Inputs used by these formula steps
- Total wholesale order costCases Ordered
- 10
- Total wholesale order costUnits Per Case
- 12
- Total wholesale order costPrice Per Case Ex Tax
- 120
- Total wholesale order costProduct Cost Per Unit Ex Tax
- 5
- Total wholesale order costPick Pack Cost Per Order Ex Tax
- 50
- Total wholesale order costHandling Cost Per Case Ex Tax
- 2
- Total wholesale order costFreight Cost Ex Tax
- 100
- Total wholesale order costFreight Recovered Ex Tax
- 80
- Total wholesale order costPayment Fee Rate
- 0.02
- Total wholesale order costBad Debt Rate
- 0.01
- Total wholesale order costPayment Term Days
- 30
- Total wholesale order costAnnual Funding Rate
- 0.12
- Total wholesale order costTarget Margin
- 0.25
Wholesale order contribution
Wholesale order contribution
total revenue - total order cost458.98 , ex taxResult458.98
Uses the named industry records and reports this output, ex tax. The shared engine retains full precision; display rounding never feeds the calculation.
Wholesale Order Profitability Planner formulas →Inputs used by these formula steps
- Wholesale order contributionCases Ordered
- 10
- Wholesale order contributionUnits Per Case
- 12
- Wholesale order contributionPrice Per Case Ex Tax
- 120
- Wholesale order contributionProduct Cost Per Unit Ex Tax
- 5
- Wholesale order contributionPick Pack Cost Per Order Ex Tax
- 50
- Wholesale order contributionHandling Cost Per Case Ex Tax
- 2
- Wholesale order contributionFreight Cost Ex Tax
- 100
- Wholesale order contributionFreight Recovered Ex Tax
- 80
- Wholesale order contributionPayment Fee Rate
- 0.02
- Wholesale order contributionBad Debt Rate
- 0.01
- Wholesale order contributionPayment Term Days
- 30
- Wholesale order contributionAnnual Funding Rate
- 0.12
- Wholesale order contributionTarget Margin
- 0.25
Wholesale order margin
Wholesale order margin
contribution / total revenue0.36 decimal rateResult35.9%
Uses the named industry records and reports this output in decimal rate. The shared engine retains full precision; display rounding never feeds the calculation.
Wholesale Order Profitability Planner formulas →Inputs used by these formula steps
- Wholesale order marginCases Ordered
- 10
- Wholesale order marginUnits Per Case
- 12
- Wholesale order marginPrice Per Case Ex Tax
- 120
- Wholesale order marginProduct Cost Per Unit Ex Tax
- 5
- Wholesale order marginPick Pack Cost Per Order Ex Tax
- 50
- Wholesale order marginHandling Cost Per Case Ex Tax
- 2
- Wholesale order marginFreight Cost Ex Tax
- 100
- Wholesale order marginFreight Recovered Ex Tax
- 80
- Wholesale order marginPayment Fee Rate
- 0.02
- Wholesale order marginBad Debt Rate
- 0.01
- Wholesale order marginPayment Term Days
- 30
- Wholesale order marginAnnual Funding Rate
- 0.12
- Wholesale order marginTarget Margin
- 0.25
Required price per case
Required price per case
protected order cost and leakage solved at target margin100.43 , ex taxResult100.43
Uses the named industry records and reports this output, ex tax. The shared engine retains full precision; display rounding never feeds the calculation.
Wholesale Order Profitability Planner formulas →Inputs used by these formula steps
- Required price per caseCases Ordered
- 10
- Required price per caseUnits Per Case
- 12
- Required price per casePrice Per Case Ex Tax
- 120
- Required price per caseProduct Cost Per Unit Ex Tax
- 5
- Required price per casePick Pack Cost Per Order Ex Tax
- 50
- Required price per caseHandling Cost Per Case Ex Tax
- 2
- Required price per caseFreight Cost Ex Tax
- 100
- Required price per caseFreight Recovered Ex Tax
- 80
- Required price per casePayment Fee Rate
- 0.02
- Required price per caseBad Debt Rate
- 0.01
- Required price per casePayment Term Days
- 30
- Required price per caseAnnual Funding Rate
- 0.12
- Required price per caseTarget Margin
- 0.25
Minimum order cases
Minimum order cases
fixed order cost / contribution per case before fixed cost2 unitsResult2
Uses the named industry records and reports this output in units. The shared engine retains full precision; display rounding never feeds the calculation.
Wholesale Order Profitability Planner formulas →Inputs used by these formula steps
- Minimum order casesCases Ordered
- 10
- Minimum order casesUnits Per Case
- 12
- Minimum order casesPrice Per Case Ex Tax
- 120
- Minimum order casesProduct Cost Per Unit Ex Tax
- 5
- Minimum order casesPick Pack Cost Per Order Ex Tax
- 50
- Minimum order casesHandling Cost Per Case Ex Tax
- 2
- Minimum order casesFreight Cost Ex Tax
- 100
- Minimum order casesFreight Recovered Ex Tax
- 80
- Minimum order casesPayment Fee Rate
- 0.02
- Minimum order casesBad Debt Rate
- 0.01
- Minimum order casesPayment Term Days
- 30
- Minimum order casesAnnual Funding Rate
- 0.12
- Minimum order casesTarget Margin
- 0.25
Inputs used
- Cases ordered (whole cases/order)
- 10
- Units per case (whole units/case)
- 12
- Wholesale price per case (/case, ex tax)
- 120
- Product cost per unit (/unit, ex tax)
- 5
- Pick and pack cost per order (/order, ex tax)
- 50
- Handling cost per case (/case, ex tax)
- 2
- Freight cost (/order, ex tax)
- 100
- Freight recovered (/order, ex tax)
- 80
- Payment fee rate (decimal fraction of wholesale order revenue)
- 0.02
- Expected bad-debt rate (decimal fraction of wholesale order revenue not collected)
- 0.01
- Payment term days (whole days/order payment term)
- 30
- Annual funding rate (decimal annual funding rate)
- 0.12
- Target wholesale margin (decimal fraction of wholesale order revenue)
- 0.25
Open this calculator with preset values
This calculator supports documented, shareable scenario URLs. Compatible assistants and applications can construct links using the parameters below.
Scenario links contain only allowlisted numeric and closed-choice inputs shown in the URL; Margin101 excludes free text and identifying fields. Anyone you share the URL with can read those numbers, so do not include private or identifying data.
| Parameter | Meaning | Unit | Allowed values | Presence | Default |
|---|---|---|---|---|---|
| annualFundingRate | Entered annual cost of funding the order until collection. | decimal annual funding rate | 0 to 1 | Required | 0.12 |
| badDebtRate | Share of total order revenue expected not to be collected. | decimal fraction of wholesale order revenue not collected | 0 to 1 | Required | 0.01 |
| casesOrdered | Whole cases in the customer order. | whole cases/order | 0 to 100000000 | Required | 10 |
| freightCostExTax | Outbound freight cost for the order. Keep every amount on the same ex-tax currency basis. | currency units/order, ex tax | 0 to 10000000 | Required | 100 |
| freightRecoveredExTax | Shipping amount charged separately to the wholesale customer. Keep every amount on the same ex-tax currency basis. | currency units/order, ex tax | 0 to 10000000 | Required | 80 |
| handlingCostPerCaseExTax | Variable handling and warehouse cost per case. Keep every amount on the same ex-tax currency basis. | currency units/case, ex tax | 0 to 10000000 | Required | 2 |
| paymentFeeRate | Share of total order revenue paid in processing fees. | decimal fraction of wholesale order revenue | 0 to 1 | Required | 0.02 |
| paymentTermDays | Entered days between invoicing and expected collection. | whole days/order payment term | 0 to 3650 | Required | 30 |
| pickPackCostPerOrderExTax | Fixed fulfilment cost incurred once for the order. Keep every amount on the same ex-tax currency basis. | currency units/order, ex tax | 0 to 10000000 | Required | 50 |
| pricePerCaseExTax | Entered product price for each case. Keep every amount on the same ex-tax currency basis. | currency units/case, ex tax | 0 to 10000000 | Required | 120 |
| productCostPerUnitExTax | Product cost for each unit packed in a case. Keep every amount on the same ex-tax currency basis. | currency units/unit, ex tax | 0 to 10000000 | Required | 5 |
| targetMargin | Contribution margin to protect in the required case price. | decimal fraction of wholesale order revenue | 0 to 0.99 | Required | 0.25 |
| unitsPerCase | Whole saleable units packed into each case. | whole units/case | 1 to 100000 | Required | 12 |
Wholesale Order Profitability: order revenue
Order contribution must include discount, freight, fulfilment and payment-term burden.
Formula summary
- Primary formula
- total revenue - total order cost
Data used here
- The estimate uses your inputs and the general business formula documented in the methodology.
Decision checks
Stress-test the decision
Retest lower quantity, higher freight and slower payment.
When this estimate can be misleading
- Industry costs, tax, contract terms, capacity and targets are entered by the user; no market benchmark is embedded.
- Use records from one consistent period and one ex-tax currency basis where money applies.
- This is educational business decision support, not accounting, tax, legal or financial advice.
- Order contribution must include discount, freight, fulfilment and payment-term burden.
Educational estimate, not advice. See all assumptions & limitations →
Related reading
Guides to interpret the decision and its assumptions.
- Wholesale Economics: Trade Discount, Terms and Volume
Reconcile wholesale contribution, payment timing, order volume and funding needs before accepting a trade account.
Read guide
Frequently asked questions
How do I test wholesale order contribution after discounts, production, freight, terms and minimum quantities?
Set minimum quantity and payment terms only after checking capacity and funding exposure.
Which planning assumptions should I stress-test?
Compare a plausible alternative scenario and verify the decision-critical assumption that changes the plan most.