85 is the example result. Read it using the units and relationship stated below.
Tiered Pricing uses base price, tier 1 discount (%), tier 2 discount (%).
Protecting contribution before accepting a price
For tiered pricing, the relationship is Result = minimum([Base price] × (1 − [Tier 1 discount (%)] ÷ 100), [Base price] × (1 − [Tier 2 discount (%)] ÷ 100), [Base price] × (1 − [Tier 3 discount (%)] ÷ 100)). The amount depends on the supplied base price, tier 1 discount (%), rather than a live market price or a value imported from another record. A quote can meet a revenue target and still leave too little to cover delivery. Separate the selling-price denominator from the cost denominator: margin and markup answer different questions. A discount changes contribution even when the supplier cost stays fixed.
What the model includes
Result = minimum([Base price] × (1 − [Tier 1 discount (%)] ÷ 100), [Base price] × (1 − [Tier 2 discount (%)] ÷ 100), [Base price] × (1 − [Tier 3 discount (%)] ÷ 100)) A pricing review should retain the supplier cost, sale price and the reason for any allowance. Returns, payment charges, delivery and tax require explicit treatment; they should not disappear inside a percentage labelled profit. Compare the proposed price with the customer agreement and delivery capacity. A mathematically achievable margin does not establish that buyers will accept the offer.
Example with the supplied inputs
Base price: 100; Tier 1 discount (%): 5; Tier 2 discount (%): 10; Tier 3 discount (%): 15. Result: 85. The values are illustrative.
Compare one changed input
Base price changes from 100 to 110. The result becomes 93.5. All other inputs remain fixed.
Calculation rule
Result = minimum([Base price] × (1 − [Tier 1 discount (%)] ÷ 100), [Base price] × (1 − [Tier 2 discount (%)] ÷ 100), [Base price] × (1 − [Tier 3 discount (%)] ÷ 100))
Inputs and output
| Input | Example value | Entry convention |
|---|---|---|
| Base price | 100 | Use base price on the currency and period basis shown by the formula. Keep gross amounts, net amounts and unit amounts distinct; the page does not fetch a price or exchange rate. |
| Tier 1 discount (%) | 5 | Enter tier 1 discount (%) on the percentage scale used in the formula (20 means 20%, not 0.20). Keep its base and reporting period consistent with the other inputs. |
| Tier 2 discount (%) | 10 | Enter tier 2 discount (%) on the percentage scale used in the formula (20 means 20%, not 0.20). Keep its base and reporting period consistent with the other inputs. |
| Tier 3 discount (%) | 15 | Enter tier 3 discount (%) on the percentage scale used in the formula (20 means 20%, not 0.20). Keep its base and reporting period consistent with the other inputs. |
Output: 85 is the example result. Read it using the units and relationship stated below. Use the formula to distinguish a cash amount, count, percentage or ratio.
How to use the page
Collect the inputs
Gather Base price, Tier 1 discount (%), Tier 2 discount (%). Use one period and the units shown in the form.
Run the calculation
Enter the values and select the action. The calculation rule above explains how the inputs produce the result.
Compare a scenario
Change Base price on its own, keeping the other inputs fixed. Read both results before changing another assumption.
Worked example
With the example inputs listed above, the result is 85.
Change Base price from 100 to 110 while keeping every other value fixed. The result becomes 93.5. This comparison isolates that input; it does not forecast how other variables will respond.
Check the stated formula, units and limits before using the result in a decision.
Keep the displayed formula, input units and model scope with the result. Corrections or questions can be sent through the request section on this page.
Content updated: October 11, 2026