Blog · Finance metrics and formulas · Finance and FP&A teams
Calculate marginal cost per unit by comparing total production costs at two output levels. Follow the spreadsheet formulas, a worked capacity-step example and the checks that separate marginal cost from average unit cost.
How to calculate marginal cost per unit: divide the change in total production cost by the change in output. Use comparable cost records at the lower and higher volume, then identify any capacity costs that begin within that range. The result measures the extra production cost per additional unit.
Marginal cost per unit = (Higher total cost − Lower total cost) / (Higher output − Lower output)
OpenStax defines marginal cost using that change-in-cost over change-in-output relationship. When the volume change covers a batch, the calculation gives the average incremental cost across that batch; it does not prove that every individual unit costs the same.
Take a production-volume export and the matching operating-cost detail. Group them by product, facility and period. Define output consistently: completed acceptable units, for example, rather than units started in one row and units sold in another.
Use total production costs with the same scope at each volume. Keep material consumption, production labor, utilities and relevant facility costs in consistent columns. Exclude sales costs unless the analysis expressly includes them, and disclose that boundary.
Historical cost differences can include price and product-mix changes as well as output. For a production decision, prepare estimated cases at each volume using the same input prices and production assumptions. Comparing unrelated historical months does not establish the cost of making the next batch.
For the cost of all output divided by all units, use how to calculate cost per unit. That is a separate denominator and answers a different question.
A US manufacturer prepares three monthly production cases for the same product. Material prices and the reporting period stay constant. The highest case requires added facility capacity and a more expensive labor schedule.
Put the headers below in row one and the cases in rows two through four. All costs are in USD.
| A: Output units | B: Facility cost (USD) | C: Materials (USD) | D: Production labor (USD) | E: Utilities (USD) | F: Total cost (USD) | G: Average cost per unit (USD) |
|---|---|---|---|---|---|---|
| 1,000 | 12,000 | 8,000 | 6,000 | 2,000 | 28,000 | 28.00 |
| 1,200 | 12,000 | 9,600 | 7,200 | 2,400 | 31,200 | 26.00 |
| 1,400 | 15,000 | 11,200 | 9,800 | 2,800 | 38,800 | 27.71 |
Enter these formulas in F2 and G2, respectively:
=SUM(B2:E2)
=IF(A2>0,F2/A2,NA())
Fill them down. Average unit costs are displayed to two decimal places; keep unrounded figures for later calculations. The first row, for example, is $12,000 + $8,000 + $6,000 + $2,000 = $28,000, divided by 1,000 units = $28.00 per unit.
For a deeper treatment of the total manufacturing-cost boundary, see average manufacturing cost per unit. Keep that boundary unchanged throughout this comparison.
Add H for extra output, I for extra cost and J for marginal cost per unit. Start in row three because row two has no lower-volume comparison in this table.
Enter these formulas in H3, I3 and J3, respectively:
=A3-A2
=F3-F2
=IF(H3>0,I3/H3,NA())
Fill down to row four. The guard requires increasing output; sort the cases first and inspect duplicate volumes.
| Output range | Extra output units | Extra cost calculation (USD) | Extra cost (USD) | Marginal cost per unit (USD) |
|---|---|---|---|---|
| 1,000 to 1,200 | 200 | 31,200 − 28,000 | 3,200 | 16.00 |
| 1,200 to 1,400 | 200 | 38,800 − 31,200 | 7,600 | 38.00 |
The first extra batch costs $16.00 per unit even though the average cost at its ending volume is $26.00. Existing facility cost is spread over more units, but it does not increase in that range. The next batch costs $38.00 per unit because the higher volume changes the cost structure.
Subtract each cost category separately for the second range:
| Cost category | At 1,200 units (USD) | At 1,400 units (USD) | Increase (USD) |
|---|---|---|---|
| Facility | 12,000 | 15,000 | 3,000 |
| Materials | 9,600 | 11,200 | 1,600 |
| Production labor | 7,200 | 9,800 | 2,600 |
| Utilities | 2,400 | 2,800 | 400 |
| Total | 31,200 | 38,800 | 7,600 |
The $3,000 facility increase belongs in this range because the case requires it. The existing facility cost cancels; the additional commitment does not. Confirm whether that commitment lasts only for the modeled month or creates an obligation beyond it.
Finance owns the cost reconciliation, operations confirms the capacity assumption, and procurement checks material-price consistency. Compare additional revenue with all relevant additional costs before accepting extra work. The contribution margin ratio supplies the related revenue comparison, but a capacity step still needs separate attention.
Marginal cost multiplied by extra output must recover the cost increase. The two ranges give $16.00 × 200 = $3,200 and $38.00 × 200 = $7,600. Their sum is $10,800, which matches $38,800 − $28,000.
For rows three and four, check that bridge with:
=SUMPRODUCT(H3:H4,J3:J4)-(F4-F2)
It must return zero. Microsoft's SUMPRODUCT documentation confirms that the function multiplies corresponding entries and sums the products. Covirage is not affiliated with Microsoft.
Across the entire increase, $10,800 / 400 = $27.00 per extra unit. That wider-range figure hides the $38.00 rate for the final batch, so retain the adjacent ranges when reviewing capacity.
Bring a workbook containing output, cost categories and the assumptions behind each volume case. Covirage maps the columns, its tools compute and check cost changes and unit rates, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, and bring a sample of your own data.
See cost variance analysis for the questions these operating-cost comparisons support.
No. Average cost spreads the total cost of all output over all units. Marginal cost measures the extra cost across a specified output increase. Average cost can fall while marginal cost rises, especially when a higher volume starts to require overtime or added capacity.
Unchanged fixed costs cancel when you subtract the two total-cost amounts. Include a fixed-cost increase when the added output actually requires it, such as renting another production area. State the output range because the same cost can remain fixed within one range and step up in another.
A zero change in output makes the marginal-cost calculation undefined. Investigate the cost movement as a price, efficiency, timing or mix change instead. Do not replace the division error with zero, because that would imply that additional production has no cost.