Production cost is what one unit of a product took to make: ingredients and packaging at what you paid, plus waste, plus the labor and overheads you choose to include, divided by how many good units the batch produced. Work it out per batch, then enter the result as Cost per item in Shopify so profit reports mean something. The two mistakes that make it wrong are dividing by the planned yield instead of the actual one, and leaving out what went in the bin.
The short version
- Cost of a batch = ingredients + packaging + freight + labor + overhead you assign.
- Cost per unit = cost of the batch ÷ good units made.
- Use actual yield, not the recipe's planned yield.
- Include waste: trimmings, failed units, product used for testing.
- Update Shopify's cost per item when a major ingredient changes price.
A worked example
Kapahulu Cookie Co., a made-up bakery, makes chocolate chip cookies in batches meant to give 240.
| Line | Quantity | Price | Cost |
|---|---|---|---|
| Flour | 18 lb | $0.62/lb | $11.16 |
| Butter | 12 lb | $4.10/lb | $49.20 |
| Sugar (brown and white) | 14 lb | $0.85/lb | $11.90 |
| Eggs | 36 | $0.38 | $13.68 |
| Chocolate chips | 15 lb | $5.40/lb | $81.00 |
| Vanilla, salt, soda | $6.20 | ||
| Bags and labels (for 6-packs) | 40 | $0.32 | $12.80 |
| Labor, 3 hours | $22/hr | $66.00 | |
| Ingredients, packaging and labor | $251.94 |
Planned yield: 240 cookies, 40 six-packs. Actual: 12 cookies broke and 6 were eaten testing, so 222 good cookies, 37 six-packs.
- Per six-pack on planned yield: $251.94 ÷ 40 = $6.30.
- Per six-pack on actual yield: $251.94 ÷ 37 = $6.81.
The 51-cent difference is the real cost of breakage. If the six-pack sells for $14 on Shopify, the margin is 51%, not 55%.
What to include, and what to leave for later
- Always: ingredients, packaging, freight on ingredients.
- Usually: direct labor for making and packing.
- Your choice: rent, utilities and equipment, spread per batch. Including them gives a truer cost; leaving them out gives a cleaner comparison between products. Be consistent.
- Not here: Shopify fees, shipping to customers, marketing. Those are selling costs.
Putting it into Shopify
Enter $6.81 as the six-pack's Cost per item. Shopify uses the cost recorded at the time of sale for its profit reports, so update it when butter or chocolate move. Shopify cost per item and Shopify cost of goods sold cover the reports.
Where this stops working
The calculation above is a snapshot. Next week butter costs more, the next batch yields 230, and the number in Shopify is still $6.81. Doing this by hand for every product after every price change is the job most makers stop doing by March. Recipe costing template for Google Sheets covers a spreadsheet version, and Shopify FIFO covers costing stock made at different prices.
How TaroStack does it
TaroStack for Shopify runs inside your Shopify admin and works out each batch's cost from what it actually used and what it actually yielded, at what each ingredient actually cost, including freight. It shows actual against standard cost, flags suppliers whose prices are creeping, and keeps margins on what things really cost. Free for 14 days.
