Food Product Cost & Pricing Tutorial

[@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

[@Mr2Paws]

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

[@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

[@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?

[@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?

[@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.

[@francissebbi8890]

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

[@jackian4914]

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

[@AlyssaLioutas]

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

[@mikev.9050]

Hi! Nice discussion. Can you share the spreadsheet?

[@darlenecloma8348]

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

[@annao163]

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

[@AuntieRoseCafe]

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

[@Yordanov1990]

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

[@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

[@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?

[@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!!!

[@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.

[@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

[@juliochum]

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

[@armando2111]

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

[@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.

[@janbarreda]

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

[@MariamAldajani]

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

[@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.

[@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.

[@tellAPnJ]

Cant add to cart the spreadsheet..whats wrong?

[@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

[@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!

[@luyimapatricksemakula4978]

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

[@gracielatorres5019]

Awesome explanation video

[@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?

[@telmocarvalho3578]

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

[@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?

[@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.

[@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?

[@bhattanabin]

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

[@ac-bq5ru]

So how am I supposed to get this spreadsheet?

[@eddiesalsa1214]

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

[@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?

[@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

[@danielgalusca7441]

Did you ever figure it out? I’m very confused

[@aaronfitzpatrick966]

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

[@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

[@tracjay1]

This is exactly what I need. It this downloadable?

[@Flamellinas]

Would be even better if it had an ingredient table connected

[@seongjungong2949]

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

[@davidt7431]

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

[@naturesvibe1735]

Amazing! Thanks for your time and hard work :)

[@aronnabruno4820]

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

[@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.

[@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?

[@aishawilliams5933]

Where do we get these spreadsheets?

[@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

[@GeorgeAJululian]

Thanks very helpful

[@Adbhut]

Thank you so much for this!

[@isyjeon959]

What about for a service?

[@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?

[@klion7133]

Please share this excel template

[@maniacmusic405]

Can I still purchase this spreadsheet?

[@BenEehayeh]

This is really cool.

[@arpandoshi9878]

Excellent 🙏

[@sylviakong1066]

got any link to download the spreadsheet ?

[@rickeena2462]

Hi how do I get the spreadsheet template

[@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.

[@leimalutapasei2631]

nice could you please share the spreadsheet please

[@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.

[@stephentse481]

How do I design this same spreadsheet in NZD$

[@jeromejohnson794]

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

[@MohamadSimo]

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

[@imthatguy4179]

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

[@birdiestanden9367]

Is this program still available?

[@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.

[@MarkAlex]

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

[@emiliorossi5804]

Is this calculated in the margin Percentages?

[@ricarteb.becera7786]

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

[@DamianPomodoro]

Is this template available for download?

[@abdulmojid7488]

Very nice and how do i download

[@Barangsky]

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

[@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.

[@chefakbarkhan820]

This format how to take it

[@manuelbalbi6440]

where can i get this?

[@vasumallireddy6406]

Can you explain product cost and praising, with example

[@chrlnshgn9220]

how to compute the desired yield? please help

[@thomassmith8700]

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

[@jbgirl3780]

Is this calculator still available?

[@nsampson1738]

I cannot download the costing sheet.

[@mahmoudgad7988]

can you help me to dowmload excel 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

[@donleyevans8506]

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

[@rennermlcod8738]

how to downnload that template?

[@almutazabualhamail88]

if I need customized worksheet for my business can you support

[@SirajKhan-tn8eh]

Can you help me to download excel sheet ?

[@hzkaelgetahun8246]

can i get the excel document

[@sureshragotra4367]

Plz share the sheet

[@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

[@barbra429]

Can someone give the link to the download please.

[@asesorcomercial8477]

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

[@zairajose]

What happen with the website ?

[@tingtingvlogtv]

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

[@muhammadagil2826]

pls share the format

[@shivarudrads5034]

Please share mw working sheet

[@EDDIEGARAGE]

Formula ?????