Free Recipe Costing Software - Is There Any?

Business By tanya3b Updated 18 Jul 2017 , 4:53pm by cantrollmyrs

tanya3b Cake Central Cake Decorator Profile
tanya3b Posted 15 Nov 2011 , 9:32pm
post #1 of 14

Hi I am in the process of writing a business plan to start a cake business. I don't want to put out a bunch of cost up front until I know it is a go. My problem is I am trying to write a business model and need to cost my recipes, I have my baking certificate, but have kind of forgotten some things sice getting it 15 years ago. I am wondering if there is a free download out there for costing recipes. I hear the Cake Boss program is great, but it is $100.
Help please

13 replies
scp1127 Cake Central Cake Decorator Profile
scp1127 Posted 16 Nov 2011 , 5:42am
post #2 of 14

You can easily do it yourself. I think it takes me all of 5 seconds to price a recipe in my head. But you can use a calculator.

Get together the actual price of all ingredients. Start dividing bags of sugar and flour into cups per bag. Same with milk. Then do butter by the pound or quarter pound, eggs divided by 12. Make yourself a master list, right down to tsp in a bottle of vanilla.

Now out to the side of every recipe, list the cost and add it up. On every recipe, I have the cost in the upper right corner on a post-it note... you can change these with price increases.

This will work until you can afford a program, but you may be so good at it you won't need a program.

cakeladyatLA Cake Central Cake Decorator Profile
cakeladyatLA Posted 16 Nov 2011 , 6:50am
post #3 of 14

There is one here in CC, search for it. I dont remember what the thread is.

Good luck.

Patty*

KSMill Cake Central Cake Decorator Profile
KSMill Posted 16 Nov 2011 , 7:00am
post #4 of 14

I think this is the link to download the pricing matrix that's an excel spreadsheet. If it's the one I found, it is quite detailed and helpful. Good luck
http://cakecentral.com/modules.....ad&id=2480

tanya3b Cake Central Cake Decorator Profile
tanya3b Posted 16 Nov 2011 , 5:34pm
post #5 of 14

I have been doing it manually with a calculator, and I know it works fine, it is just time comsuming. I will check out the cake central one. The excel one does it not require you to set up formulas to calculate everything?

jcstefanick Cake Central Cake Decorator Profile
jcstefanick Posted 16 Nov 2011 , 6:11pm
post #6 of 14

I just did a Google search for "recipe pricing calculator" and several free download options came up. You can check them out and see if any of them work for you.

imagenthatnj Cake Central Cake Decorator Profile
imagenthatnj Posted 16 Nov 2011 , 6:59pm
post #7 of 14

You can download one here in Excel.

tanya3b, usually the formulas are already set up by the person who offers the download.

This one is even pretty, but it's simple. With some excel knowledge, you can change it and improve it if you want to.

http://thecarolinaclipper.com/2011/03/free-download-recipe-cost-calculator/

Scroll down for download.

tanya3b Cake Central Cake Decorator Profile
tanya3b Posted 16 Nov 2011 , 10:56pm
post #8 of 14

The only thing I have to say is that this one is not very user friendly, you can modify it. What I mean is you can add your own ingredients to the list. Plus I live is Canada, so yes we use some imperial, but we are metric, so litres, and grams.

thanks for trying, anything I have seen you have to pay for.

rowantree Cake Central Cake Decorator Profile
rowantree Posted 1 Dec 2011 , 6:16am
post #9 of 14
Quote:
Originally Posted by tanya3b

The only thing I have to say is that this one is not very user friendly, you can modify it. What I mean is you can add your own ingredients to the list. Plus I live is Canada, so yes we use some imperial, but we are metric, so litres, and grams.

thanks for trying, anything I have seen you have to pay for.




I looked that one over and wrote up one myself that is easy to add to, and will add up all the amounts you need by units--no matter if they are imperial or metric--you choose the cost per unit, and the quantity and they are multiplied by the form and you get a column with totals that are added up at the bottom as a total recipe cost, and you can then divide that cost by the number of servings for a per serving cost..

I did it with my own list of basic ingredients of things we use in the bakery I work in. I don't have prices for anything because I don't handle that part, but in your own place you have access to that info and can just plug it in. I can send you the spreadsheet if you have excel, or if you don't, you can use http://download.openoffice.org/ to read and use it. Let me know.

chefdrose Cake Central Cake Decorator Profile
chefdrose Posted 28 Nov 2013 , 5:29pm
post #10 of 14

you can send the excel to me. i am trying to price out my plates to be sure i am selling them for the right amount. thank you very much

justmikey Cake Central Cake Decorator Profile
justmikey Posted 2 Dec 2013 , 6:51am
post #11 of 14

AI realize this is an old post but wondering if anyone has the spreadsheet to share. All the above links are dead.

Thanks!

iredoo Cake Central Cake Decorator Profile
iredoo Posted 28 Feb 2014 , 7:55pm
post #12 of 14

Quote:

 I just did a Google search for "recipe pricing calculator" and several free download options came up. You can check them out and see if any of them work for you.

 

Here is one for free. Not a excel sheet, but a online tool. http://www.cookkeepbook.com

JohnInVenice Cake Central Cake Decorator Profile
JohnInVenice Posted 11 Jun 2014 , 7:20pm
post #13 of 14

You should consider your needs...yes, you can cost manually, it is really about the time and having to do redundant tasks every time you cost.  Considering the food price inflation currently in the market, costing needs to be rather regular.  There are a scattering of free spreadsheets, but they tend to lack conversion abilities (converting volume to weight, etc.) and a useful history so you can track costs.  

 

That being said, there are programs under 40 bucks which have a lot of great features if you just need to cost, record your recipes, and not have the program run your entire business.  I would recommend CostGizmo -- it's 40 bucks, but they are really nice and will usually send you a coupon for 10 off if you just email them.  It's a simple yet comprehensive app that gives you all the reports and output you need.  It's all a very colorful and lively program, not clinical like a lot of programs.  It runs on the Excel engine, though you don't see excel running when it is on.

 

If you want to go with a free spreadsheet for costing, I suggest googling "menu (or recipe) costing spreadsheet free".  That will give you a top level search of several free spreadsheets that you can run in Excel like any normal workbook.

cantrollmyrs Cake Central Cake Decorator Profile
cantrollmyrs Posted 18 Jul 2017 , 4:53pm
post #14 of 14

I've been an excel user for a long time.  While this is great, it is pretty time consuming and doesn't offer many features. Quickbooks doesn't really work either because that seems to be more for just keeping business records.

I started delving into paid / free software and found one called CostBrain. They let me keep track of my invoices for free but cost a small fee for the food costing aspect.  I probably wouldn't recommend this for personal use but if you are a smaller to larger restaurant this could help.

I found them in the Apple App store....

Quote by @%username% on %date%

%body%