Does this work in Excel and Google Sheets?

Both. Google Sheets: File > Import, or open and make a copy. Excel 365: open it directly. No macros, no add-ons, nothing to install.

How is this different from the full COGS Calculator?

Same engine, smaller and cheaper. This one is built to cost a single item quickly, with a shorter materials list. If you run many products and want a bigger material library, the full Handmade Product COGS Calculator is the step up.

Which units can I buy and use in?

Weight, volume, count, length and area. Grams to pounds, milliliters to gallons, millimeters to yards, square centimeters to square feet, and each or dozen.

Why does my line cost show zero?

You bought the material in one family and used it in another, length into area, or weight into volume. Convert the purchase to the family you work in.

I'm not confident with spreadsheets. Will I manage?

Yes. The white cells are the only ones you touch. The Quick-Start Guide has your first real number on screen in about five minutes, and if you get stuck, message me.

Home → Tools → Cost Per Item Calculator

The materials were a few dollars, the price felt fair, and somehow the item made nothing.

The true cost of one item across materials, labor and overhead, and the minimum price that keeps your target margin. Cost one thing at a time, simply.

$5 USD · one-time

Buy on Etsy · $5

✓ 30-day money-back guarantee. Not right for you? Message me for a full refund.

An editable Excel & Google Sheets file, not a printable and not an app. No macros or add-ons to install. Instant download, works on Mac and Windows · on Etsy today, Gumroad soon.

Built by a commercial-finance professional. Every formula is tested against a separate model, so the number holds up.

Cost per item dashboard showing cost per unit, minimum price and gross margin

Who it's for

Made for the way you actually work.

Makers who want to cost one product without a whole system
Etsy and craft-fair sellers pricing a new item
Anyone whose own hours vanish somewhere inside the price
Makers moving from guesswork to a costed price

What's included

Everything in one file.

Dashboard: Three headline numbers and two charts. Read-only.
Start Here: Five steps from opening the file to a real number on screen.
Item Cost: Where you cost one recipe. The main working sheet.
Materials: Your shelf. Enter each purchase once; used everywhere.
Settings: Labor rate, overhead, target margin and fees.
Instructions: What each sheet does, and what to do if a number looks off.
About: Version, license and support.
PDF Quick-Start Guide: two pages, first result in five minutes

How it works

Three steps to a number you trust.

Open Settings. Set your labor rate, overhead %, and the gross margin you want to keep.
Open Materials. Enter each purchase the way you buy it, and set yield % for anything that leaves scraps.
Open Item Cost. Name the item and say how many the batch makes.

A look inside

The screens you'll be working in.

List of the eight sheets in the cost per item calculator

Item Cost sheet with materials, labor and cost per item

Materials sheet with pack prices, units and yield

Settings sheet with overhead, target margin and fees

Three steps to a price: load materials, cost the item, read the minimum

Compatibility list showing Excel, Google Sheets, Mac and Windows support

Questions

Good to know.

Does this work in Excel and Google Sheets?: Both. Google Sheets: File > Import, or open and make a copy. Excel 365: open it directly. No macros, no add-ons, nothing to install.
How is this different from the full COGS Calculator?: Same engine, smaller and cheaper. This one is built to cost a single item quickly, with a shorter materials list. If you run many products and want a bigger material library, the full Handmade Product COGS Calculator is the step up.
Which units can I buy and use in?: Weight, volume, count, length and area. Grams to pounds, milliliters to gallons, millimeters to yards, square centimeters to square feet, and each or dozen.
Why does my line cost show zero?: You bought the material in one family and used it in another, length into area, or weight into volume. Convert the purchase to the family you work in.
I'm not confident with spreadsheets. Will I manage?: Yes. The white cells are the only ones you touch. The Quick-Start Guide has your first real number on screen in about five minutes, and if you get stuck, message me.

One mispriced job costs more than this.

$5 once, and it's yours to keep. It pays for itself the first time it stops you underpricing a job or leaving margin on the table. No subscription, no login, just a file that does the maths.

Buy on Etsy · $5

✓ 30-day money-back guarantee. If it doesn't do what you need, message me for a full refund.

Related tools

Owners like you also use.

Quoting & EstimatingCreative & Digital

Photography Package Quoting Calculator

Quote shoots from real shooting, editing and retouching hours, with the price solved from the margin you want to keep.

$39View →

Profit TrackingCreative & Digital

Shoot Profitability Calculator

Compare what a shoot was quoted at against what it actually cost in shooting, editing and retouching hours, and find where the day really went.

$39View →

Profit TrackingCreative & Digital

Agency Project Profitability Tracker

Compare what a project was scoped at against what it actually cost in hours, and find where the fee went.

$49View →