Tiered Pricing Calculator

The biggest tiered pricing calculation error is choosing the wrong threshold rule. Under tiered or graduated pricing, each band prices only the units that fall inside it. Under volume pricing, your billable quantity selects one rate and that rate prices every billable unit.

These definitions match the distinction documented by Zuora's official charge-model guide and Crystallize's tiered pricing documentation. Both describe volume pricing as one selected rate for the full quantity and graduated pricing as separate rates for separate bands.

Check the wording on the provider's pricing page, contract, or quote. If it only says “tiered,” calculate one quantity at the threshold and another just above it. If crossing the threshold reprices the earlier units, the schedule uses volume pricing.

The default example starts with 750 total units, 100 included units, and a $19.00 base fee. That leaves 650 billable units. The schedule charges $0.12 through 100 billable units, $0.08 through 500, and $0.05 above 500.

With graduated pricing, the first 100 units cost $12.00, the next 400 cost $32.00, and the last 150 cost $7.50. Usage fees are $51.50, so the estimated total is $70.50. With volume pricing, all 650 billable units use the $0.05 rate. Usage fees are $32.50 and the estimated total is $51.50.

The pricing ledger shows the range, charged units, unit price, and subtotal for every active band. Use it to trace an unexpected usage-based billing charge back to the exact tier instead of trying to reconstruct the invoice from one advertised rate.

The blended unit price equals usage fees divided by billable units. It excludes the base fee, making it easier to see the average rate created by the tiers. The effective unit price shown below the ledger includes the base fee and divides the full cost by total usage, including any allowance.

The next-breakpoint result shows how many more billable units remain in the current band and the corresponding total-usage threshold. The final tier is open-ended, so it has no later breakpoint.

For a SaaS, API, or usage-based pricing calculator, use calls, tokens, credits, seats, storage, or compute units as the quantity. Included usage can represent a plan allowance, the base fee can represent the subscription charge, and the tier ledger shows the overage moving through each price band.

For wholesale, procurement, or bulk pricing, use items, cases, or another consistent purchasing unit. The result can estimate the buyer's price or the seller's revenue for that quantity. It does not calculate product cost, gross profit, or margin, so sellers should check those figures separately before publishing a quantity discount.

Keep the unit consistent from input to result. If a published API rate is per 1,000 requests, either enter quantity in thousands or convert every threshold and rate to individual requests. Mixing the two is a common source of large billing errors.

First calculate billable units = MAX(0, total usage − included usage). For each graduated tier, use MAX(0, MIN(billable units, upper limit) − lower limit) × unit price. Round each tier subtotal to two decimals, sum the rows, and add the base fee.

Put total usage in B1, included usage in B2, and the base fee in B3. In B4, enter =MAX(0,B1-B2). Build the tier table in A8:C10 with lower limits, upper limits, and unit prices. Use 1,000,000,000 as the final upper limit so the last tier matches this calculator's supported maximum.

In D8, enter =MAX(0,MIN($B$4,B8)-A8) to calculate charged units. In E8, enter =ROUND(D8*C8,2) to calculate the rounded tier subtotal. Copy both formulas through row 10. The graduated total is =ROUND($B$3+SUM(E8:E10),2).

For a single modern Excel or Google Sheets formula, use =$B$3+SUMPRODUCT(ROUND(IF($B$4<=$A$8:$A$10,0,IF($B$4<$B$8:$B$10,$B$4-$A$8:$A$10,$B$8:$B$10-$A$8:$A$10))*$C$8:$C$10,2)). This version preserves line-level cent rounding.

For volume pricing, find the row containing B4, multiply all billable units by that row's price, round once to cents, and add B3. Label the pricing model in the sheet. An ambiguous “tiered” column can produce the wrong total.

We tested the default $0.12, $0.08, and $0.05 schedule with no included usage or base fee. At exactly 500 units, the second tier remains active. At 501 units, the third tier starts.

Graduated pricing changes smoothly because only the extra unit receives the new rate. Volume pricing reprices the full quantity, so the total drops from $40.00 to $25.05. This price cliff is valid under the selected rule, but it is also why you should confirm the provider's contract before relying on a volume estimate.

You can build 2 to 5 pricing tiers. Quantities and cumulative thresholds may be as high as 1,000,000,000 units with up to six decimal places. Per-unit prices accept up to six decimal places, the base fee accepts cents, and the final tier has no upper limit.

For graduated pricing, each tier subtotal is rounded half up to the nearest cent before the lines are added. For volume pricing, the single usage line is rounded to cents. The base fee is added after usage fees are rounded.

This estimate does not handle taxes, credits, one-time charges, minimum commitments, maximum charges, flat stairstep fees, or provider-specific exceptions. For progressive percentage fees applied to dollar amounts, use the Tiered Fee Calculator. For one percentage rate plus an optional fixed charge, use the Percentage Fee Calculator. The payment processing fee guide explains percentage, fixed, and other transaction costs.