Bulk Pricing / Volume Discount
Unit price and order total with up to three quantity-break discount tiers (all-units pricing).
Inputs
units
units
%
units
%
units
%
Results
- Order total
- 8,100
- Unit price
- 10.8
- Discount applied
- 10 %
- Savings
- 900
Formula
Tier = highest threshold ≤ quantity
Unit price = list × (1 − tier discount)
Total = unit price × quantity
Assumptions & limits
- All-units pricing: the reached tier applies to every unit. Set a threshold to 0 to disable that tier.
Worked example
750 units reaches tier 2 (10%): 10.80 × 750 = 8,100.00, saving 900.00.