Pottery Studio: Kiln Firing Cost Per Piece

Excel Formulas › Pottery Studio

All versions

Every studio knows roughly what the electric bill is and nobody knows what a single mug costs to fire. It is two multiplications and a division, and once you have it, member pricing and firing fees stop being guesses. A glaze firing usually costs more per piece than a bisque, and the reason is entirely visible in the numbers.


Quick formula: Kilowatts times hours gives kilowatt-hours; times the rate gives dollars; over pieces gives the answer:
=ROUND(B2*C2*D2/E2,2)

An 8.5 kW kiln on an 11-hour glaze firing at $0.14/kWh costs $13.09 — 36 cents a piece across a 36-piece load.

Functions used (tap for the full reference guide):

The example

Three firings from one week, on the same meter and the same rate.

ABCDEFG
1FiringKiln kWHours$/kWhPiecesFiring costCost per piece
2Bisque cone 048.590.1448$10.71$0.22
3Glaze cone 68.5110.1436$13.09$0.36
4Test kiln1.860.1410$1.51$0.15

The formula

The intermediate kilowatt-hour figure is worth knowing even if it does not get its own column:

=ROUND(B2*C2*D2,2) then =ROUND(F2/E2,2) // kWh x rate = firing cost, then spread across the pieces

How it works

Four inputs, and the last two matter most:

  1. B2*C2 is kilowatt-hours. Read kilowatts off the kiln's data plate — a common studio electric kiln is 8–11 kW, a test kiln 1–2 kW.
  2. *D2 applies the rate. Use the all-in figure from the bill including delivery and demand charges, not the headline supply rate; the difference is often a third of the cost.
  3. /E2 is the part that changes behaviour. A half-full kiln costs almost exactly what a full one costs, so pieces-per-load is the lever, not hours.
  4. Round to cents. Fractions of a cent per mug are noise, and a studio fee schedule quoted to four decimals looks like it was never sanity-checked.

This is the energy cost only. Shelves, posts, elements, kiln wash and the eventual relining are real and belong in a separate per-firing overhead line before you set a member fee.

Try it: interactive demo

Interactive

Enter your kiln rating, firing length, electricity rate and the pieces in the load.

Variations

Cost with a duty cycle

A kiln does not draw full power the whole cycle — elements switch off as it holds temperature. Multiply by a measured duty cycle of 0.6–0.8 for a more honest figure.

=ROUND(B2*C2*DutyCycle*D2/E2,2)

Break-even firing fee

Add per-firing overhead before dividing, so the fee covers elements and shelves rather than just electricity.

=ROUND((B2*C2*D2+Overhead)/E2,2)

Pitfalls & errors

Nameplate kilowatts is the maximum draw, not the average. Without a duty-cycle factor this calculation overstates cost, often by 25–40% on a long glaze firing with a hold.

Put a cheap energy monitor on the kiln circuit for one firing. One real kWh reading replaces every assumption in this sheet and takes an afternoon.

Do not price a half-empty kiln at the full-load per-piece rate. The firing cost barely moves with load size, so a 20-piece glaze load costs nearly double per piece — that is the argument for waiting a day to fill it.

Practice workbook

📊
Download the free Pottery Studio: Kiln Firing Cost Per Piece practice workbook
Edit the yellow kW, hours, rate and pieces cells; firing cost and cost per piece recalculate.

Frequently asked questions

Why does a glaze firing cost more than a bisque?
Two reasons, both visible in the table: it runs hotter and longer, so the hours go up; and pieces cannot touch during a glaze firing, so fewer of them fit in the same kiln. The cost rises and the divisor falls at the same time, which is why the per-piece figure moves so much.
Should I charge members per piece or per firing?
Per piece is easier to sell and per firing is easier to defend. Many studios do both: a per-piece shelf fee for casual members and a whole-kiln rate for anyone firing their own load. The calculation supports either — it is the same numerator, just a different divisor.

Stop fighting formulas. Learn them in a day.

This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.

See the Formulas & Functions Class

Related formulas: Laundromat: Utility Cost Per Load · Print Shop: Cost Per Print · Powder Coating: Area Price

Function references: ROUNDPRODUCT