Ingredient costs and Recipe pricing calculator (with retail and wholesale margins)

Food maker?

Do you know your recipe costs? And have you updated them lately with current ingredient pricing?

✨ This is a document for you to track your ingredient prices and calculate recipe costs. ✨

It's a database (in coda).

You will enter your ingredients ONCE and use them in multiple recipes.

This makes it easier to update pricing when costs go up (or down).  

The new pricing will flow through to each recipe that uses the ingredient. You don't have to change the price in multiple spots.

You can also add labor costs and material costs (packaging, boxes, etc.)

Your final cost per sku will therefore include ingredients + labor + materials.

You can then have accurate pricing, which leads to accurate wholesale and retail margins.

***

✨ BIG NOTE:  This method is based on WEIGHT.  ✨

All ingredients must be entered in pounds or grams.  Your recipes must be in grams.

You will need to get out a scale and weigh everything once.

✨

BUT...once it is done, it is done.

And yes...you do need to weigh your liquids.  

Example:  we used maple syrup during the granola years and measured it in ounces.  Just once thought, for this pricing document, I had to weigh 60 oz. of maple syrup and enter it in grams (I just measured 20 and multiplied it by 3.)

Play with the demo

This document has data in it, and you can check out how it works. Your changes will not be saved.

https://coda.io/@hope-lawrence/ingredient-prices-and-recipe-costs-calculator-1-0

Why use this doc?

• You're a food producer and need to get a handle on your ingredient costs and recipe costs.
• You want to know and manage your wholesale and retail margins.
• You're tired of having a messy spreadsheet and entering prices multiple times.
• You are open to using Coda (it's like a spreadsheet and document in one.). (coda.io)

What can you do with this doc?

• Add and manage all of your ingredients in one spot.
• Build subrecipes (e..g., a baking mix) that is then used in recipes.
• Add and manage all of your recipes in one spot.
• Add your retail and wholesale prices for each sku.
• Add your labor and material costs for each sku.
• Add multiple skus (e.g., you sell granola in 3 oz., 6 oz., and 12 oz. pouches) and see data for each SKU.
• And ultimately, see your batch costs, sku costs, wholesale margins, and retail margins for each recipe, product, and SKU.

FAQs

Who is this template for?

Food producers who can enter ingredients and recipes in pounds and grams.

How will I get the template?

You'll get a link to a coda document, and you'll then create a copy in your own coda account.

Do I need a Coda account? Do I need a paid account?

Yes, you'll need a Coda account. You can create one for free.

*However, this document is VERY CLOSE to the max. size for a free account. Most likely, you will need to upgrade to a paid account. (Currently $12/month).

Can I customize this doc?
Yes, you can add notes and additional fields as desired. Please do not delete any columns or tables. You can hide columns as desired and move pages as desired.

**

My refund policy is simple; if you don't like this template or it's not what you were expecting, you'll get a full refund within the first 10 days. No questions asked. Email me at hello@smallbatchempire.com with any questions or concerns.