Fictional company · Invented figures

Where did the price go?

Explore the orders. Change a rule. See what moves in the calculation.

Demo Industrial Co. is an invented A$180 million industrial distributor.

This order sample is a subset, not its full annual revenue. No client records, benchmarks or estimated customer responses are used.

Try a pricing rule

Edits stay in this page. No uploads, accounts or input tracking. Reset, refresh or leaving clears changes and notes.

Try a guided scenario

Each choice replaces the current rules with invented assumptions. Your selected sample stays the same.

Choose the sample to inspect

Branch

Customer segment

Product group

All / All / All · 144 invented orders · 31,679 packs

Set the scenario

Rules apply to every qualifying retained order in the selected sample. Application is assumed, not predicted.

Preparing the demo.

Price and discount rules

List price increase (%)

Increase the list price by 0 to 30%. Original quantities stay unchanged unless you assume a downside.

Maximum invoice discount (%)

Cap each original invoice discount at this percentage. 100 keeps all original discounts.

Freight and small orders

Delivery charge rule

Minimum mode uses the higher of the existing and minimum charge, unless the free-delivery threshold applies. Collection orders have no freight.

Minimum delivery charge (A$)

Used only with the minimum delivery charge rule.

Free delivery from (A$)

In minimum mode, waive freight at or above this invoice merchandise value. 0 means no free-delivery threshold.

Small-order threshold (A$)

Add a small-order charge below this invoice merchandise value. 0 switches this rule off.

Small-order charge (A$)

A separate charge on qualifying orders, including collection orders. Do not include it again in freight.

Modelled cost to serve

These assumed costs apply to both cases. Fixed overheads and capacity changes remain outside the model.

Processing cost per order (A$)

Cost for each retained order.

Delivery cost per delivered order (A$)

Additional cost for each retained delivered order.

Handling cost per pack (A$)

Additional cost for each retained pack. Packs differ between product groups.

Assume a volume downside

Assumed reduction in orders and units (%)

0 to 100%. A uniform reduction in orders and packs, not a demand estimate. Fractional order equivalents can result.

The comparison uses the applied assumptions.

Same invented orders · Two cases

Baseline against scenario

Custom / default scenario.

Net revenueA$4.29mA$4.29m baseline · A$0 change

Contribution after modelled costsA$1.24mA$1.24m baseline · A$0 change

Retained order equivalents144144 baseline · 31,679 retained packs

Modelled delivery cost: A$4,860.00 baseline; A$4,860.00 scenario. This is part of modelled cost to serve, not an additional deduction. Amounts are rounded per retained order.

Baseline price-to-contribution waterfall

Rebates and credits reduce invoice merchandise revenue once. Freight and small-order charges are added once. Costs are then deducted.

Invented sample. All amounts in Australian dollars, excluding GST.
Measure	Baseline	Scenario	Change
List value	A$4,737,760.00	A$4,737,760.00	A$0.00
Invoice discounts	A$404,052.40	A$404,052.40	A$0.00
Invoice merchandise revenue	A$4,333,707.60	A$4,333,707.60	A$0.00
Off-invoice rebates	A$43,614.10	A$43,614.10	A$0.00
Credits	A$2,000.00	A$2,000.00	A$0.00
Freight charged	A$6,120.00	A$6,120.00	A$0.00
Small-order charges	A$0.00	A$0.00	A$0.00
Net revenue including charges	A$4,294,213.50	A$4,294,213.50	A$0.00
Product cost	A$3,036,392.20	A$3,036,392.20	A$0.00
Modelled cost to serve	A$18,107.65	A$18,107.65	A$0.00
Contribution after modelled costs	A$1,239,713.65	A$1,239,713.65	A$0.00

Compare within the sample

Group by

Grouped by product group. No company rankings or benchmarks.
Product group	Baseline net revenue	Scenario net revenue	Contribution change
Fasteners	A$591,563.10	A$591,563.10	A$0.00
Site supplies	A$849,172.87	A$849,172.87	A$0.00
Workshop consumables	A$1,141,593.32	A$1,141,593.32	A$0.00
Safety equipment	A$1,711,884.21	A$1,711,884.21	A$0.00

Contribution exceptions

Rank the invented sample below a contribution margin you choose. These are arithmetic comparisons, not recommendations.

View by

Case to rank

Contribution margin threshold (%)

Rows strictly below this percentage qualify.

Scenario · customer · threshold 15% · 0 below threshold · 0 with margin unavailable.

Margin is contribution after modelled costs divided by net revenue. Nonpositive net revenue has no margin. Ranked by the largest dollar gap to the threshold, then the label.

No rows are below this threshold in the selected case. Change the case or threshold to inspect more.

Trace the calculation

Inspect an invented order

Order to inspect

D-001 · Demo account 01 · North depot · Contract accounts · Fasteners

57 packs at A$80.00 list per pack. Product cost: A$45.60 per pack. Original invoice discount: 4%. Off-invoice rebate: 0% of invoice merchandise revenue. Collection order.

Invented sample. All amounts in Australian dollars, excluding GST.
Measure	Baseline	Scenario	Change
List value	A$4,560.00	A$4,560.00	A$0.00
Invoice discounts	A$182.40	A$182.40	A$0.00
Invoice merchandise revenue	A$4,377.60	A$4,377.60	A$0.00
Off-invoice rebates	A$0.00	A$0.00	A$0.00
Credits	A$125.00	A$125.00	A$0.00
Freight charged	A$0.00	A$0.00	A$0.00
Small-order charges	A$0.00	A$0.00	A$0.00
Net revenue including charges	A$4,252.60	A$4,252.60	A$0.00
Product cost	A$2,599.20	A$2,599.20	A$0.00
Modelled cost to serve	A$34.95	A$34.95	A$0.00
Contribution after modelled costs	A$1,618.45	A$1,618.45	A$0.00

Keep the decision trail

Your demonstration summary

This is a fictional scenario, not a recommendation. Record what you changed and which assumptions you would check in a real business.

Decision note (optional)

No decision note recorded.

Applied assumptions and method

Custom / default scenario.

Exception view: customer, Scenario, threshold 15%.

Delivery charges: Keep existing charges
List price increase (%): 0
Maximum invoice discount (%): 100
Minimum delivery charge (A$): 85
Free delivery from (A$): 0
Small-order threshold (A$): 0
Small-order charge (A$): 0
Processing cost per order (A$): 15
Delivery cost per delivered order (A$): 45
Handling cost per pack (A$): 0.35
Assumed reduction in orders and units (%): 0

What these figures can show

All orders and commercial constants were invented for this demonstration. No client dataset, calibration or price-response estimate was used.

Invoice merchandise revenue equals list value less invoice discounts.
Rebates use invoice merchandise revenue as their basis. Credits are separate fixed amounts on the invented orders.
Delivery and small-order thresholds use invoice merchandise value, before rebates, credits and charges.
Net revenue includes freight and small-order charges. Contribution deducts product cost and the entered cost-to-serve assumptions.
A volume downside reduces orders, packs and monetary components uniformly. Rounding occurs in cents for each component, then invoices and totals reconcile.
Both cases use the same entered cost assumptions. Taxes, fixed overheads, capacity, customer mix changes and collection risk are excluded.

The original discounts and credits describe invented records. The scenario applies proposed rules mechanically. It does not establish customer acceptance, achievable savings or operating profit.