Food Product Cost by % (Part 2) | How to Calculate Food Cost | Excel Demonstration| Cake Pricing
HTML-код
- Опубликовано: 7 окт 2024
- #Foodcostbypercentage
#Sellingprice
Hello everyone, in this video is the part 2 of our food cost computation by percentage but this time gagamit po ako ng excel spreadsheet.
Also, maybe you would like to learn how to use the excel spreadsheet, I have a sort of tutorial of how to create formulas and use it as your calculator. Hope you will watch it until the end so you can watch how I calculated the food cost by percentage.
Thank you so much for Subscribing to my Channel and for always watching and supporting my videos.
Keep safe and God Bless everyone 🙏
Time Stamps👇
🎆How to get the product of Food Cost Using Excel formula
8:40
11:00
🎆How to Sum-up total Cost Using Excel formula
13:44
🎆Formula Calculation
FC by% = Selling Price
23:30
Disclaimer:
Again guys, I'm not an expert on this. I made this video so I can help you out to have an idea of how you will manage your product pricing. Hope you will watch from the start to end so you will completely understand the procedure.😊
You can watch Part 1 How to compute costing and pricing using "Rule of thumb" (multiply by 3) best for beginners and small time business computation. ruclips.net/video/ztcdGY-ihWk/видео.html
Very helpful po thank you for sharing po. God bless po 🥰♥️
You're welcome po
ito po ung hinahanap ko n formula salamat nakita ko to...
Your welcome po ☺️💕
Congrats for the complete explantation, very useful for your compatriots who want to start a small business
Ang galing mo sissy mg compute ng ganito and saludo ako sayo kasi ikaw lahat gumawa nito plus you still have to do baking. You manage your time well
Salamat Sissy..medyo sumakit brain ko dito haha..pero ok lang importante mka help kahit papano. Thank you so much sissy koy.😊💞
now ate na pick up ko na paano mag costing.. salamat ng marami malaki tulong e2 sa aking munti business d2 sa hk
Your welcome sissy.💞🙂
Very clear, informative and marvelous! Thank you soooo much madam. Keep it up!
Your welcome po.💕😊
Thank you very much. Really appreciated 👍
You're welcome po ☺️💕
Thank you for the info. Very informative! Galing nyo po. ❤️
Your welcome po. Thank you also.😊💞
Wow grabe hehe. Lahat detailed. Anyway thanks for teaching us how to use this method.😀I will try this po
My pleasure po. Thank you also for watching and subscribing to my channel.💞😊
Thumbs up done sissy, harang at the moment
Thanks po maam😍 sana pede madownload yung spreadsheet na to
Wow ang galing mo sa calculations sis at need talaga i consider lagi ang mga workers din
Oo sissy dapat e include talaga lahat para hindi malugi din. Thank you sissy koy.💞😊
Sa isang order po ng red velvet cake, magkano ang kukunin nyo for your labor?
Thank you for sharing ma'am
You're welcome po🥰
Very informative sissy koy, keep it up. Got your back always.
Magaling po. Pashare naman po sana ng format maam 🙌
i wish I could share it with you po kaso nasira hindi ko na retrieve yung file ko nung nasira po yung desktop computer ko last year.
Thank you for sharing po💞
Thank you Leonie💞😊
Welcome po💞
Hi I'm a newbie & homebased - I would like to follow your food costing sample - paano i-add ang costing for water kung it's a main ingredient sa recipe mo - for example, gelatin dessert - need 4 cups water
Hi ma'am yung water pwede niyo po estimate nlang yung cost Kasi since distributed Naman po yung usage sa bahay. Nasa sau po magkano ilagay niyo as costing. But if u are using a distilled water alam niyo po Kung ilang ML ang isang bottle at magkano ang bili niyo just get the 1 cup to ml conversion sa Google and same computation ang gawin. Thank you.😊
Tnx for sharing your formula mam..Hope you can share me your format..tnx much
Thank you so much for the tutorial. Is there anyway that I could ask for the template or link for the table you made?
I apologized but I wasn't able to retrieve the data from the desktop that I used for the Template. If I do have a laptop perhaps i could make another one and upload it again.
Watching here
Thank you sissy😊💞
So helpful.thanks sis .new sub here.
kasama ba po ang water content as part of the ingredients sa recipe calculation kahit wala siyang cost involve? thanks!
For me depende po sa water at sa dami na nagagamit. on my side d ko na minsan include yun since hindi naman ganun kadami. Pero syempre pag we speak about business all must be counted po dapat.☺️
Pwede po ba makahingi ng excel nito?
Hi ask ko po. Paano po pag sa double recipe magkasama na po ang cake & cupcake paano po computation?
For me lang po ha, mas maganda e separate niyo yung pag compute if for cakes or for cupcakes. Kasi iba po naman yung production nila.
Hello good day. For sharing po ba ang template ninyo? Thank you po 🙏
Hi sorry nasira kasi yung desktop ko hindi ko na retrieve yung file nito.
Hello po M'Mary. Nakagawa na po ako. Ang kaso hindi ko po alam kung tama. Mini donut po kase yung sa aken. Yung po pinaka huli na computation regarding sa yeild. Ang nilagay ko po kase eh 25 pcs na mini donuts. Kase yun po ang nagawa. Tapos po pag nilagay na po sa clamshells bale 4 clamshells with 6 pcs inside.
Paano po ba yung yield? Kung ilang pcs ang nagawa or by boxes(clamshells?
Thank you po🙏
Ma'am thank you po. ang galing. Ask ko lang po
1. ung 5% at 45% ay standard po? Pwede tumaas pero hnd pwede bumaba?
2. kung may isa pa ako business at ice cream ung gngwa ko ay pwede gamitin ung formula na 5% at 45%?
3. Anu nga po pla ung 45% or TP(Total Profit). Saan po kinuha un?
Maraming salamat po. 😊 New subs here. 😊
Please click this time maps it will answer your questions po. 23:00
And yes you can adjust the TC (Total creativity) 5% if you think napakahirap gawin yung design like intricate siya..u can adjust po and it's up to you ilan e mark up niyo.
@@togsiscooking i mean ma'am ung 45% standard po xa? ung mkukuha nmen jan ay yan ung gusto nmen tubuin? ganyan po kze pag kakaintindi ko. pasenya po ma'am, bago lng po sa ganito 😁.
and by the way ma'am pwede ko iapply ung formula n 5% at 45% s ice cream?
It's up to you if you will add more % on TP and TC, as i have said in the video na hindi po akin ang formula(nag research lang po) at pinag aralan ko lang siya so i can share it to you guys the way i understand it ☺️. Also, it says na standard daw yung TP but subject to change yung TC. Kasi it will depend how intricate your work. Nasa inyo na rin po if u will use this formula sa iba niyo na business as long yiu think na tama at d kau dehado sa computation niyo.☺️ If u think mababa para sau yung 45% nasa inyo na po if tataasan niyo pa.
Hi po konting clarification because I'm just a beginner so bali dun sa apat na naproduce na yields babalik din yung 2,244 by selling those 4 cakes sa presyong 561 ?
Yes by checking the product e multiply mo yung 561 x 4 then it will give you 2,244.
Maam Baka Pwedi ko hingingin format mo hehehe salamat if pwedi lang po hehehe
Hi, wish i could give it to you kaso nasira yung computer na ginamit ko dati at hindi ko na retrieve yung mga files ko dun.😔
Ano po yung yield na tinatawag ? By layers po ba yun sa cake ? Or quantity po yun kung ilan po pans na sinalang nyo ?
Yield po sa isang recipe or ingredients kung ilan po ang nagagawa nito.
@@togsiscooking so bali po apat na pan po ang isasalang sa oven ?
Yes kung yun po ang nagagawa ng isang recipe.
Wala po bang accurate na computation para sa Gas, electricity and water? Bat estimate lang? Sana po may computation din kung paano makuha yung actual consumption.
Nag rough estimate lang po tayo diyan sa gas, electric and water kasi depende po yan sa na consume niyo. If meron kayo fix na production daily at alam niyo kung ilang days nauubos yung 1 tank ng gasul niyo. Then pwede niyo siya ma compute ng exact. Halimbawa yung bili niyo ng gas ay 1000/per tank at nauubos niyo eto ng isang buwan at kda araw ay meron kayo 3 cakes na nagagawa (example lang eto ha) computation: 30days x 3 cakes = 90 cakes sa isang buwan. 1000 gas price divide niyo sa 90cakes = 11.11 pesos so, each cake eto yung gas costing niyo. Disclaimer hindi po ako expert mag compute base lang po eto sa pag kaintindi ko. Hope naka help po eto sa inyo. Same thing sa electric and water po yan..mag base kayo sa production niyo, water bill and electric bill. masakit nga lang sa bangs mag compute 😁
Pano llgyan ng formula pra mag compute sya
@@charlinemuceros8044 tinuro ko po sa video paano mag lagay ng formula. Thank you ☺️
Hi pwde po pahingi nang copy nang formula nang percentage ung pwde mag edit thanks
Hello Ma'am. Thank you for this video. May we ask how you arrive at your cost used for eggs? Trying to replicate your computation for 15 pcs saba banana which is worth 60 pesos all-in-all. Thanks for your help :)
Hi the cost value formula for eggs will depend on the purchase quantity. For example sa video i used 1doz (12pcs) at nabibili ko po ng 89 pesos (price sample used was like 2yrs ago) So when the recipe needs like 3 eggs eto po yung computation 89 ÷ 12 = 7.41 cost value, so 3 x 7.42 = 22.23 cost value ng 3 eggs. Same computation if you purchase by tray example price at present in my place 320/tray(small) ÷ 30 pcs (quantity/tray) = 10.66/egg
@@togsiscooking Thank you so much :)
Your welcome po. ☺️
paano po pag may yield? hinahanap ko pano comoutation ng may yield po
@@kimbacabac7687 hi kim, nakasulat sa taas ng excel sheets yung yield at size ng cake, also I mentioned the yield repeatedly . You can watch it again po simula dito 11:00 (time stamps). Thank po
Hi po maam , yung percentage po sa TP na 45% , standard na din po ba yun ?
Yes as per research standard po nag formula
Sa isang order ng Red Velvet cake, magkano po ang kinukuha nyo for your labor?
Maam pa click po etong time maps 21:40 ma redirect po kau dun sa part ng video kung saan nag banggit po tayo about labor.☺️
Maam ask ko lang kung 4 cakes yun yield nya. Magkano po kaya selling price kun 2 layerd cakes? Pa-add ko lang po ba un 2 yield cake at yun na po ba ang selling price ko? Salamat po
Just compute all the costing from ingredients, materials and etc...and same pa din yung yield kung ilan nagawa mo for that ingredients cost but adjust po kayo sa percentage as mentioned depende how intricate na yung work at ilang days mo ginawa. Make sure na include mo lahat pati puyat at pagod mo. Then use the computation same as shown in the video.
@@togsiscooking yes po nacompute ko na po lahat ng ingredient cost sinunod ko din po lahat ng computation po ninyo iba lang po ang mga prices na gamit ko. Kung halimbawa po 564 selling price per cake kasi po 4 din po yield niya ibig sabihin po ba yun price ng 2 layered cake ay pa add ko lang price nun 2 yield cake? Sorry po baguhan lang po kasi gusto ko po sana malaman kung hindi po ako talo sa selling price na mga binebenta ko. Salamat po sa inyo. More power po
@rhyteejeanhelera7091 depende po yan sayo paano mo siya e price kasi pag ganyan na layered cakes lalo na pag customized siya "cake pricing will be based on design na talaga" like mahirap ba eto ginawa mo intricate ba masyado, at ilang days ang inilaan mo for that layered cakes. So you have to mark up your price depending on your labor and location of course included na yung computed cost mo. Based on your location meaning kung ano yung market standard diyan sa lugar mo. The computation will guide you lang na hindi ka malugi sa pag price ng cakes mo.
@@togsiscooking gnaya ko lang din po kasi un design nyo sa red velvet hehe. Mag mark up lang po talga yun price depende sa design at pagod sa pagbuo ko po sa layered cake. Cge po isama ko po sa computation para makita ko po talaga kung magkano selling price parang po kc lugi po ako sa layerd cake na 8x2 pan huhu. Thank u po sa pagsagot po sa akin malaking tulong po talga ito❤️
Walang anuman po basta kaya ko lang sagutin hehe. Enjoy Baking and Good luck! 🥰
Ang bilis di ako nakasunod aha
Sensiya po...😊
tal ves podrias tener mas vistas si hablas engles
Pwede po ma send po yung sample sakin po ty
Time Stamps👇
🎆How to get the product of Food Cost Using Excel formula
8:40
11:00
🎆How to Sum-up total Cost Using Excel formula
13:44
🎆Formula Calculation
FC by% = Selling Price
23:30
what about the formulas
The formula is given po if you have watch it fully makikita niyo po yun. Thank you po😊
Ate yung total profit po Ba 45% po Ba tagala dapat eh lagay kahit isang cake Lang ginawa mo?
Nasa sau na yan pwede mo e adjust, price will always vary depende sa cost, labor, time consumed sa pag gawa ng cake and how intricate your design and etc. Etong computation will based as guide din po. Nasa sau if sundin mo lahat.
Also pwede rin gamitin ang Rule of thumb na computation ex. Total cost ÷ yield x 3 = selling price
Again, pwede niyo e adjust ang price. Meron ako vid for that yung part 1 na video.
@@togsiscooking thank-you po ang linaw nyo po mag turo at nagkaroon ako ng idea pano ko patakbohin business ko ng maayos at di nalulugi 😊 godbless 💜💜🥰
My pleasure to help basta kaya ko lang po.☺️💕
Ma'am pwede po bang makahingi ng copy ng computation nyo po?
Hi sorry hindi ko na save yung copy sa desktop na ginamit ko nasira po kasi. Pero nasa sa dulo ng video po yung formula pwede niyo po ma screenshot yun.
@@togsiscooking no worries po. Thank you po mam for sharing your knowledge. sobrang kailangan ko po ito.
Your welcome po.☺️
d naka abut
Ok lang yan sis d man eto naka premiere. Hehe..thank you sis.💞😊
Ang gulooo
sensiya po naguluhan kayo. Thank you and God bless 🥰
thanks for the info , pero wag sanang maraming sinasabi na paulet ulet lang kasi mas nakakalito. kasi pag di nman nmin maintindihan pwede nmn namin panuurin ulet .thanks
@@antoniocruz2555 okay 👍