Marginal Cost & Production Tier Calculator

Compare production quantities when capacity requires a new shift, rental or other fixed charge. Enter cost tiers, the unit selling price and a sales cap for one planning period. See the cash result at each output, the next unit’s marginal cost, and how unsold inventory changes the comparison. Use the chart to find the best modeled quantity and inspect the cost jumps that lead to it.

Unit costs and capacity

Plan production across cost tiers

Compare two output levels, see the cost of crossing capacity thresholds, and identify the best modeled quantity for your sales cap.

Output and sales assumptions

Use the same planning period for all amounts. Units above the sales cap remain in stock and bring in zero revenue for this period.

Production comparison

Plan A · 100 produced

$1,500.00

Cash result

100 sold · 0 unsold

Cost of unit 101

$615.00

Includes $600.00 capacity charge.

Cash result change -$583.00

Plan B · 195 produced

$1,662.50

Cash result

180 sold · 15 unsold

Cost of unit 196

$16.50

Includes $2.50 carrying cost.

Cash result change -$16.50

Change from A to B

Cash result +$162.50 · outlay +$2,397.50

$25.24 average extra cost per unit between the two outputs.

Highest modeled cash result

$2,260.00

At 180 produced · 180 sold · 0 unsold

Plan B cash result change +$162.50. Highest modeled cash result $2,260.00 at 180 units.

Cash result across output levels

Solid lines join quantities within a tier. Dashed lines join adjacent quantities across capacity thresholds.

The sales cap is 180 units, shown by the vertical marker.

Output (whole units)

  • Plan A
  • Plan B
  • Highest result

Production tiers

Enter strictly increasing capacities. The unit cost applies to units within that tier. Its activation charge is incurred once when output reaches the first unit in the tier.

Tier 1
Tier 2
Tier 3
Show cost and chart tables
Period cash ledger
Cash itemPlan APlan BHighest result
Base overhead$500.00$500.00$500.00
Sales revenue$3,200.00$5,760.00$5,760.00
Variable production$1,200.00$2,610.00$2,400.00
Capacity charges$0.00$950.00$600.00
Unsold stock carrying$0.00$37.50$0.00
Cash outlay$1,700.00$4,097.50$3,500.00
Cash result$1,500.00$1,662.50$2,260.00
Chart data at tier boundaries and sales cap
TierProducedSoldUnsoldCash outlayCash result
Zero output000$500.00-$500.00
Tier 1110$512.00-$480.00
Tier 11001000$1,700.00$1,500.00
Tier 21011010$2,315.00$917.00
Tier 21801800$3,500.00$2,260.00
Tier 31811801$3,866.50$1,893.50
Tier 325018070$5,005.00$755.00

Export the production plan

Include your assumptions, tier allocations, next-unit changes and plot values in the CSV.

Download production CSV
Show selectable CSV

How to use this calculator

  1. Choose Capacity charge example or Limited sales example. Enter Plan A output and Plan B output in whole units for the same planning period.
  2. Enter Selling price per unit, Sales cap, Base period overhead and Carrying cost per unsold unit. Use the sales cap for the units you can sell during the period.
  3. In Production tiers, enter Capacity through as cumulative output, then set the incremental unit cost and one-time activation charge for each tier. Add or remove tiers as needed.
  4. Read Production comparison to compare cash results, units sold and unsold, next-unit cost, change from A to B and the highest modeled cash result.
  5. Inspect Cash result across output levels and open Show cost and chart tables. Download production CSV or use its selectable copy to retain the exact cents and quantities.

The Formula

The mathematical logic powering this calculation is:

For production Q and cumulative tier ceiling Tᵢ, tier i receives Uᵢ = max(0, min(Q, Tᵢ) − Tᵢ₋₁) units, with T₀ = 0. Its variable production cost is Uᵢ × unit cost. Its activation charge applies once when Uᵢ > 0. Every earlier used tier retains its own charge and incremental unit cost.
With sales cap D, units sold S = min(Q, D) and unsold units U = Q − S. Revenue = S × selling price. Cash outlay C(Q) = base overhead + all variable production costs + activation charges + U × carrying cost per unsold unit. Cash result is revenue minus outlay. Base overhead remains in the period at zero production.
The next unit’s marginal cash cost is C(Q + 1) − C(Q). It includes the applicable new tier charge or carrying cost. The model also calculates the change in sales revenue and cash result. At the final capacity there is no modeled next unit. The average incremental cost between plans A and B is [C(B) − C(A)]/(B − A), defined when their quantities differ.
Within a tier, cash result is linear on each side of the sales cap, in whole-unit quantities. To find its exact maximum, the model compares zero output, the first and last units of every tier, and the sales cap when it falls inside a tier. Ties favor the smallest output. The plot joins these points within tiers and marks the jump between adjacent outputs in different tiers.
Use 1–10 tiers with strictly increasing whole-unit capacities from 1 to 1,000,000. The plans and sales cap allow 0 to 1,000,000 whole units, with plan outputs limited by the final tier. Price, unit production cost and carrying cost allow $0 to $1,000,000 per unit. Period overhead and tier activation allow $0 to $1,000,000,000 per amount. Enter USD decimals to two places without grouping marks. The model uses integer cents for period amounts and rounds the interval average for display.
The worksheet uses a single planning period, known sale price and sales cap, full payment for units produced, and no proceeds this period for unsold units. It measures modeled cash rather than assigning accounting value to remaining stock. Taxes, financing, future sales and multi-product constraints belong in a separate analysis.

Worked Example

If you input:

  • Plan A output: 100 units
  • Plan B output: 195 units
  • Selling price per unit: $32
  • Sales cap: 180 units
  • Base period overhead: $500
  • Carrying cost per unsold unit: $2.50
  • Production tiers: Through 100 at $12 per unit and $0 activation. Through 180 at $15 and $600. Through 250 at $14 and $350.

Result:

Plan A has a $1,500.00 cash result. Unit 101 costs $615.00 because it starts tier 2 and triggers a $600.00 charge. Plan B has a $1,662.50 cash result with 15 unsold units. The change from A to B is +$162.50. The highest modeled cash result is $2,260.00 at 180 units.

Frequently Asked Questions

How do I calculate the marginal cost of the next unit?

Subtract the current total cash outlay from the outlay after producing one more unit. If the unit reaches a new tier, include its activation charge. If it remains unsold, include its carrying cost.

What is the difference between marginal cost and average incremental cost?

The next-unit marginal cost applies only to an increase of one unit. The interval average spreads the outlay difference over all the extra units between two quantities. The first unit in a new tier may carry a large charge even when the interval average is modest.

Does the cost in a later tier replace the earlier prices?

The chosen rates apply incrementally. If tier 1 ends at 100 units and output is 125, the first 100 units keep the tier 1 rate and the remaining 25 use tier 2.

Can a larger output create a smaller period cash result?

Yes. The higher quantity may trigger a capacity charge before it generates enough extra sales to cover that charge. Above the sales cap, additional production can increase both production and carrying costs while period revenue stays flat.

What happens to the unsold units in this model?

They remain in stock. Their production outlay is paid in the modeled period, and they incur the carrying cost you enter. The calculation assigns future sales proceeds to a future period.

Why is the best modeled quantity sometimes zero?

Zero output still incurs the base overhead. If every allowed positive output gives an equal or lower cash result, the model chooses the smallest quantity. The displayed result reflects the entered price, sales and capacity assumptions.

Similar Calculators