Food Product Cost & Pricing Tutorial

Step-by-step directions on how to use the Small Food Business Food Product Cost & Pricing Spreadsheet tool to determine accurate product costs and create a profitable multi-channel pricing strategy.

[@Mr2Paws]

Very informative and useful. Highly recommended for those just starting a new food business. Thank you for uploading this video.

[@excel-tutorial]

Thanks a lot for sharing the info. I believe that there are a lot things to consider for running business. Therefore, I attempted to build a tool to manage the restaurant in Excel. Just following title, you can find a nice solution: Restaurant Management System - Food cost control - Dashboard Tutorial in Excel

[@smallfoodbiz]

Aaron, if you are familiar enough with excel formulas, you can have the prices pull from another spreadsheet or workbook so that every time you make a change in the first workbook it will then automatically change in this costing spreadsheet. You'll want to input the '=...' Formulas in the ingredient costs cells.

[@mahmoudgad7988]

can you help me to dowmload excel sheet

[@ArdyssUKVideos]

Thank you for this very informative video, even though I am not in the food industry I found it very useful for formulation for pricing items.

[@rajumadhavan9615]

0000

[@ladydoublemint]

I like this concept but as a person just starting my business. Will this allow me to input all my recipes new and old and also the ones I create on my own or can you only input so many?

[@edwardladrera86]

Find the cost per preparation and add up the amount you want as profit. In my case I priced my dishes always a little lower than my competitors.

[@danielsmarketgarden3980]

I am super happy to have found this video and in turn your website!!! Outstanding and thank you!!! What a great compilation of resources, delivered in a very clear and concise manner. Thank you!!!

[@jackian4914]

do you have spreadsheet tools for food cost calculation every month aside from pricing ..thanks

[@gracielatorres5019]

Awesome explanation video

[@kentonhenderson6351]

I love what's being presented on this video. Thank you by the way. However I can seem to find the actual spreadsheet to download. Is there one available?

[@darlenecloma8348]

Is this still available? Can I change the dollar sign to Peso sign? If I bought this one...? Thanks

[@Adbhut]

Thank you so much for this!

[@mikev.9050]

Hi! Nice discussion. Can you share the spreadsheet?

[@annao163]

Do you have a spreadsheet for a restaurant with many different ingredients? I notice this spreadsheet can only do 10. Thank you

[@kevinwilkin1475]

Great video and concept , however in my opinion the cost of acquiring this spreadsheet, is to expensive ($65.00) . I do have a working knowledge of Excel that's why I was drawn to it. But I am sure the average small business owner does not use Excel. However based on the price, you don't want to take the chance and get it and then it does not suite you . As a small business owner my self , you tend to concentrate on saving money to put towards your business.

[@asesorcomercial8477]

I think the same

[@kevinwilkin1475]

@@VionTuran12 can you buy it for me please

[@edwintoussaint5834]

From the tutorial, this is not for small business owners. Also I would suggest that this spread sheet be sub divided , I find that it would work better in terms of stages of success and familiarization for the new spread sheet users.

[@arpandoshi9878]

Excellent 🙏

[@GeorgeAJululian]

Thanks very helpful

[@BenEehayeh]

This is really cool.

[@francissebbi8890]

Thanks for the insightful video. How did you get the oz in the original recipe?

[@MohamadSimo]

You are the best thanks a lot it helped me a lot

[@naturesvibe1735]

Amazing! Thanks for your time and hard work :)

[@tellAPnJ]

Cant add to cart the spreadsheet..whats wrong?

[@user-jn2hq3lt1d]

Hello! Thanks for this great video. How can I get my hands on the spreadsheet itself?

[@armando2111]

Excelent video , where can I get this excell sheet ? thank you in advance .

[@bhattanabin]

the video was very helpful thank you. Can u please provide me with the excel sheet

[@janbarreda]

Hi one question please. How do you compute your price to distributors and brokers commission? :)

[@Flamellinas]

Would be even better if it had an ingredient table connected

[@smallfoodbiz]

Usama, you can find the program at smallfoodbiz.com and download it from there. Thanks!

[@poplicolapublicola374]

Or, since she shows you the layout of it in the video, you can simply make it yourself in Excel in about 15 minutes like I'm doing!

[@JuanTorres-ww2lq]

Small Food Business

[@Sarafara7]

Poplicola Publicola it's not just the layout, there are calculations involved :)

[@renanatalbi9694]

+Poplicola Publicola hey, do you know how to do all the calculations at the end?

[@lortnokmeister]

Poplicola Publicola can you send it to me or make a deal, she doesnt reply to my email. Please let me know, would be huge help, I need it for a school project and time is very limited.

[@cesarmontanez5780]

Greetings from Peru, I wanted to ask on the packaging box where it says units used in original recipe, there are the numbers 22, 87 and 22, what does it mean and how do those numbers come out? I'll stay and thank you for the answer

[@joshpeoples7729]

Hello, I have a question. My product is Mead (honey wine) how would you calculate for taxes, distribution, import export etc. as percentage or in a monetary value? would you input those numbers into the channels margin or else where?

[@Yordanov1990]

How to find this template. Its amazing ! Where is the VAT in the price?

[@AuntieRoseCafe]

Real serious question because I make soup with chicken wings or pork how do I add meats to the ingredients?

[@khiriedwards1490]

Hi I really wanted to buy this tool but wasn't sure if it was changeable to British pounds and whether that would affect the programming or not. Please advise thank you.

[@martiray7162]

Do you share/sell your spreadsheet and is there a cost associated with having a working copy of your spreadsheet what are the steps of downloading a copy? Thank you

[@juliochum]

Hi! Thanks for the excellent video and content. How can I get access to the spreadsheet, please?

[@mekam2760]

Hi I have a question. I used ounces for the measurements for a Fried chicken recipe. (Recipe yield is 84 which = how many pieces comes in the case of chicken) Each piece of chicken = 4 ounces. Each order receives three pieces of chicken which = 12 ounces. I entered 12 in the Units in the original recipe box. I'm confused when it comes to the Per unit ingredient cost box. For the Total ingredient cost (one package) Do I put 3 which represents the number of pieces of chicken? or 12 which represents the ounces of chicken per order? Thanks

[@HealTheWorld312]

Hi, I'm gonna try to help you. The Total Ingredient Cost (one package) should be calculated. You should not have to enter anything. are you calculating for one order or the entire 84? If you are calculating for one order of 4 pieces, , your line should look like this: Ingredients: Chicken (ounces) Total Quantity(=84*4): 336 Total Price: ???? Price Per Unit: should be calculated. Units in Original recipe (3 pieces by 4 ounces each): 12. Units Required for Desired Yield: SHOULD be calculated based on the Yield Difference. I don't have the program so I cannot verify. HOWEVER, this is not really used as it should be anyway. If not calculated, you can multiply 4(units in original recipe) by the yield difference. Ingredient Cost: should be calculated. There are some shortcomings in this program. For instance: if the desired yield is more (or less) than the recipe yield, the ingredient cost should change to reflect that since you are making more (or less), thus using more of each ingredient for each 'unit' or batch.

[@ThinkOFood]

It is very nice and thank you for the video. I do have a question about how to tackle different unite measurements. I am from Canada and here it is ridiculous how places sell produce. In one store the lettuce is sold by pcs, the other by lbs, and the third by kg. How can I incorporate this into excel? without starting separately converting measurements and prices. Thank you, Andrey

[@emiliorossi5804]

I am slightly confused between the Wholesale price and Distributor price. If I were a small microbakery, which one would I charge my individual customers? Which one would I charge a business that I purchasing cookies in bulk from me?

[@seongjungong2949]

Hi it’s great video to help me out. How to share this spread sheet?

[@aio-ti877]

I am interested in purchasing this program for my catering business. However, my menu items list is just over 50 and granting that the spreadsheet is limited to 10 spreadsheet pages, would that mean that are required by the program twice to cover the rest of my menu items?

[@adriancampbell630]

Could you please tell me how you calculated the cost per piece in order to get the answer .43. I have racked my brain trying to figure it out. Will you please help me. I am new to costing my recipes and need help understanding the formula you used to get this. Thank you.

[@startwithpaint]

I created a video explaining it... Search "Food Product Cost and Pricing Tool Explained" on KZbin

[@adriancampbell630]

@@startwithpaint thank you!

[@aaronfitzpatrick966]

can this program pull prices form another sheet or do I have input the ingredient cost every time i make a recipe?

[@abbywilliams]

Hello, Just purchased the 50 recipe program. Some cells are too small for my country currency. You stated I could use it regardless of the currency but some amounts are too large for the cell size you placed. I would need the cells adjusted because the prices don't add up when it "#####" in a cell. Hoping for your quick response. Looked everywhere for a contact info and I can't seem to find any.

[@tracjay1]

This is exactly what I need. It this downloadable?

[@telmocarvalho3578]

I am interested in purchasing this program for my catering business.

[@tsgeeta]

how to convert to weight if something is measured in 1/2 tsp and 1/4 teaspoon? should we say 1/2 = 2.5 gms?

[@MarkAlex]

Why other expenses are not considered such as electricity, water, rent etc... ?

[@emiliorossi5804]

Is this calculated in the margin Percentages?

[@MohamedAly-oe1pp]

Hey small food business, i tried to download the US spread sheet but it is not letting me add to cart, can you please help me! i want to purchase this template because it will help me so much! thanks

[@thomassmith8700]

Very nice spreadsheet. Now, how much are those Mama Bear cookies for real? :)

[@user-no4cn8vi8y]

Hi, I bought the template but I have a few questions and the link for the tutorial is not working. Who can I contact for help? Thank you

[@klion7133]

Please share this excel template

[@davidt7431]

Hey i bought and downloaded this about 2 years ago. I lost it where can i redownload ?

[@janinegarciamota3940]

Hi I bought this from you in 2016 or 2017 but it was emailed to my business email account. i have since lost that account is there anyway to get it a copy of it?

[@leimalutapasei2631]

nice could you please share the spreadsheet please

[@luyimapatricksemakula4978]

How can I get this spreadsheet with built-in formulas?

[@jasonstewart3023]

For clarification, this product is $65 for 30 recipes, or up to 30 ingredients in a recipe? Is this a template or a training method?

[@vivianeddington7574]

Is the download still available ? tried to follow thru google drive but was unable. there is to button to download. Please help, love the tutorial but not proficient in excel. HELP

[@eddiesalsa1214]

How can I get this product cost and pricing tool in my iPad

[@rickeena2462]

Hi how do I get the spreadsheet template

[@nsampson1738]

I cannot download the costing sheet.

[@mahmoudgad7988]

can you help me to dowmload excel sheet

[@paulmuzio7473]

at 12:00, Your Per Piece Cost? Batch Ingredient Cost is Based on 65 cookies not 24, making the Per Piece cost .16, not .43, correct?

[@imthatguy4179]

hello i produce hand sanitizer and my issue is pricing at the right price.

[@zekedees2138]

Hey, Im trying to understand @11:03 how you got .43 for the Per Piece Cost?

[@sweetie21hubby]

me too.. what is the formula for that..

[@anouarbelaiter2567]

Hi Isaac, the formula is as follows : the price of hourly rate/60 minutes * 35 minutes = 11.50: 60= 0.19*35=6.65. So the amount required to produce 24 pieces within 35 minutes is $ 6.65. Ingredients cost is 3.67,and hourly rate is 6.65 then the total cost for 24 pieces is 10.32 and per piece is 0.43, which is simply 10.32 devide by 24. Hope it is clear. Regards

[@rookiescookies511]

@@anouarbelaiter2567 please how does she get per unit price? i am confused with the figures

[@startwithpaint]

there's a video explaining it... Search "Food Product Cost and Pricing Tool Explained" on KZbin

[@energizerxxx4147]

Hi so I bought your copy of this food calculator, and there is no way for me to be able to reach you on your website is their anyway you can help me by being able to send me a copy of this format again? I do have an email confirmation on it if you need that? This would be very helpful, thank you.

[@isyjeon959]

What about for a service?

[@vasumallireddy6406]

Can you explain product cost and praising, with example

[@jeromejohnson794]

I am interested but the price is a little high. Could you please offer a discount and is this still available and updated?

[@sylviakong1066]

got any link to download the spreadsheet ?

[@chrlnshgn9220]

how to compute the desired yield? please help

[@hayleighcox2826]

I'm in the uk. If I download this can I change the currency from dollars to pounds? Thanks x

[@smallfoodbiz]

Thanks for asking. There is a UK version that you can purchase from the smallfoodbiz.com site.

[@aishawilliams5933]

Where do we get these spreadsheets?

[@Barangsky]

Can this app be also used for non-food business?

[@ricarteb.becera7786]

Can you paste the link of the excel spreadsheet, thank you

[@aronnabruno4820]

How did you arrive with $0.43? ... Im a bit confused

[@hellenicfoodservices]

great

[@Funktrade]

how would I do a recipe costing with a combination of recipes to make one product. example their is the cake component eggs flour butter etc the cake also has a custard filling with its own recipe and an icing with its own recipe so thats 3 recipes to make 1 cake ?

[@tipandidea]

Hi.. Just a suggestion, u can do the unit costing per recipe and incorporate it to the finished product costing. Hope it helps.

[@stephentse481]

How do I design this same spreadsheet in NZD$

[@maniacmusic405]

Can I still purchase this spreadsheet?

[@chefakbarkhan820]

This format how to take it

[@DamianPomodoro]

Is this template available for download?

[@almutazabualhamail88]

if I need customized worksheet for my business can you support

[@birdiestanden9367]

Is this program still available?

[@user-lz6ut7mk2k]

where can i get this excel

[@abdulmojid7488]

Very nice and how do i download

[@SirajKhan-tn8eh]

Can you help me to download excel sheet ?

[@stephentse481]

Where can I get this template?

[@donleyevans8506]

I think the cost per ounce is 11 cents. .035 .. would be 35% of a penny... per unit price is 11 cents

[@abbywilliams]

Who can I contact? I spent $89 on something I'm unable to use and no one or email to contact. This is ridiculous!!! You can't out something up for purchase and no contact information if there is an issue.

[@manuelbalbi6440]

where can i get this?

[@abbywilliams]

Unable to get an accurate "Per unit product cost". If you can provide an email so i could send you a screenshot of the issue. Please, this is very urgent.

[@rennermlcod8738]

how to downnload that template?

[@hzkaelgetahun8246]

can i get the excel document

[@sureshragotra4367]

Plz share the sheet

[@samking9798]

Hi, Small Food Business. I just tried to buy/download your AUS spreadsheet but it said 'I'm sorry, the page you are looking for cannot be found. Please try again or report your problem to the webmaster.' are you able to assist me?

[@smallfoodbiz]

Sorry, the link has moved. You can find the spreadsheet here:www.smallfoodbiz.com/downloads/food-product-cost-pricing-spreadsheet-aus/

[@yonstri5915]

hi i need workbook please

[@larsneumann5294]

Hi, thank for ur tutorial. But how do u actually calculate ur per piece cost in consideration its the labor rate? any help will b very much appreciated.

[@startwithpaint]

there's a video explaining it... Search "Food Product Cost and Pricing Tool Explained" on KZbin

[@jbgirl3780]

Is this calculator still available?

[@barbra429]

Can someone give the link to the download please.

[@asesorcomercial8477]

The download is not free, the excel file costs $65

[@tingtingvlogtv]

Hello ma’am can you send me that formulated file thanks

[@zairajose]

What happen with the website ?

[@usamasaed4493]

How do I download the program

[@annieanonymous2294]

+HollywoodUndeadRares How rude...

[@QuadrantBottomHalf]

+Usama Saed Download.com

[@note2665]

+Annie “Koala” Anonymous j