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.
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.
Show cost and chart tables
| Cash item | Plan A | Plan B | Highest 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 |
| Tier | Produced | Sold | Unsold | Cash outlay | Cash result |
|---|---|---|---|---|---|
| Zero output | 0 | 0 | 0 | $500.00 | -$500.00 |
| Tier 1 | 1 | 1 | 0 | $512.00 | -$480.00 |
| Tier 1 | 100 | 100 | 0 | $1,700.00 | $1,500.00 |
| Tier 2 | 101 | 101 | 0 | $2,315.00 | $917.00 |
| Tier 2 | 180 | 180 | 0 | $3,500.00 | $2,260.00 |
| Tier 3 | 181 | 180 | 1 | $3,866.50 | $1,893.50 |
| Tier 3 | 250 | 180 | 70 | $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 CSVShow selectable CSV
How to use this calculator
- Choose Capacity charge example or Limited sales example. Enter Plan A output and Plan B output in whole units for the same planning period.
- 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.
- 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.
- 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.
- 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
Break-Even Calculator
Find the break-even point for your business — how many units you must sell to cover all costs.
Profit Margin Calculator
Calculate gross, operating, and net profit margin percentages for your business or product.
EOQ & Inventory Ordering Planner
Compare economic order quantities with pack sizes, all-units discounts, storage and order budgets. Visualize carrying costs, stock cycles and supplier tradeoffs.
Cash Conversion Cycle & Inventory Days Calculator
Calculate inventory, receivable and payable days together. Compare growth and timing scenarios, visualize operating-capital changes, weight balance snapshots and export the full analysis.
