Soap Cost Calculator Excel
HTML-код
- Опубликовано: 6 фев 2025
- In order to grow your business, you must be able to nail down exactly how much it costs to make your products. Learn how to set up an Excel file to help you keep track of your soap-making costs. This video shows you how to set up Excel formulas and takes some of the intimidation away - hopefully.
If you watch this video and still aren't very confident in your Excel skills don't worry, the files shown in the video are available for purchase. Details below.
============================================================
Etsy Links:
Supplies Cost Tracker | www.etsy.com/l...
Soap Recipe Cost Calculator | www.etsy.com/l...
============================================================
Links to website in video:
www.soapqueen....
images.soapquee...
============================================================
Music by: Purple Planet Music
www.purple-pla...
============================================================
*Disclaimer*
This is NOT an all-encompassing tutorial & I'm not an Excel expert. This is a demonstration of how I set up my worksheets to track recipe costs. Neither The Element Bath & Body nor any of its agents will be held responsible for any damages that may occur.
![I.N "HALLUCINATION" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/n5B5q1Hwt_U/mqdefault.jpg)
As a new soaper entering this “rabbit hole”, I want to thank you so much for this presentation!! This tutorial is just what I needed to get started with!
Thank you so much! I'm glad it was helpful! 💚
Another awesome informative video. Thank you
Greetings from Miami 😅😅
Thank you for this! You were a big help explaining formulas and calculations. Your voice was very calming for me to listen and follow along with.
Hi! Thank you so much. I'm glad that you found this information helpful! 💚
Oh wow Christi can I say how amazing you are?? Thanks a whole bunch for taking the time to do this, I’m super grateful!! I’ll watch the video a few more times to let it sink in 🥰
Hi Lisa! Thank you for watching & supporting! :)
Looove this! Needed a new method of tracking my COGS! Question: since FL OZ & OZ has a different weight…. do you calculate your liquid oils in FL OZ and your butters/powders/clays in standard OZ? -or- do you calculate all ingredients in standard OZ?
Thank you for this indepth overview.
How do you compensate for the oils we buy are sold in fluid ounces and the soap we make is in pound ounces? Or doesn't that even matter/ I may be just splitting hairs here.
Sorry about the delayed response. I calculate my production costs using a spreadsheet. That calculation is the foundation for determining your prices. Here is the link to purchase the pre-formatted spreadsheet...just input your oil costs and it calculated for you!
www.etsy.com/listing/1085928096/soap-supplies-cost-tracker-worksheet?ref=listings_manager_grid
I just asked the same question because FL OZ and regular OZ has a different weight in grams! I don’t know what to do 🥴
This really was a great help to me formulae and all. But how do we do the over head? Im having trouble calculating that. help would be greatly appreciated
Hi! Thanks for watching & that's a great question. I do a loose calculation for overhead. Once I learn a more efficient method, I'll definitely share here. 💚
Do you have a Mac compatible program?
Supper
Thank you!
@@TheElementSoap welcome
🏆
Thank you so much!
Please, please stop swirling the pointer on every page and all over the place. It does not help. The viewer gets dizzy following the pointer. You cannot listen, read and follow the pointer at the same time.
Thank you for watching & commenting! My brain likes the pointer but I was totally unaware of that perspective. I will keep that in mind for future videos! ;)
@@TheElementSoap the pointer is called a pointer for a reason .-) [btw: you don't need a hidden formula to round a number. Two options: Select the range of numbers you want to affect, (1) on the "Home" tab click on "Decrease Decimal" (a small icon above the number tab) OR (2) on the "Number" tab choose the option "Number" then choose the number of decimals and Bob 's your uncle. ]
@@brunowalther275 Thanks again! I stumbled through teaching myself Excel. That's very helpful!