Soap Cost Calculator Excel

Тәжірибелік нұсқаулар және стиль

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/listing/10859280...
Soap Recipe Cost Calculator | www.etsy.com/listing/10997227...
============================================================
Links to website in video:
www.soapqueen.com/business/mu...
images.soapqueen.com.s3.amazon...
============================================================
Music by: Purple Planet Music
www.purple-planet.com/
============================================================
*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.

Пікірлер: 23

  • @60soffspring
    @60soffspring5 ай бұрын

    Thank you for this indepth overview.

  • @peaceofearthnj
    @peaceofearthnj Жыл бұрын

    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!

  • @TheElementSoap

    @TheElementSoap

    Жыл бұрын

    Thank you so much! I'm glad it was helpful! 💚

  • @kbug37
    @kbug372 жыл бұрын

    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.

  • @TheElementSoap

    @TheElementSoap

    2 жыл бұрын

    Hi! Thank you so much. I'm glad that you found this information helpful! 💚

  • @ruefeee
    @ruefeee2 жыл бұрын

    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 🥰

  • @TheElementSoap

    @TheElementSoap

    2 жыл бұрын

    Hi Lisa! Thank you for watching & supporting! :)

  • @convenantcreations6017
    @convenantcreations601710 ай бұрын

    Another awesome informative video. Thank you Greetings from Miami 😅😅

  • @TootieTheMUA
    @TootieTheMUA7 ай бұрын

    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?

  • @myssblairbear
    @myssblairbear2 жыл бұрын

    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

  • @TheElementSoap

    @TheElementSoap

    2 жыл бұрын

    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. 💚

  • @rozenwynsee2521
    @rozenwynsee2521 Жыл бұрын

    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.

  • @TheElementSoap

    @TheElementSoap

    Жыл бұрын

    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

  • @TootieTheMUA

    @TootieTheMUA

    7 ай бұрын

    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 🥴

  • @latonyawhitaker4577
    @latonyawhitaker45772 жыл бұрын

    🏆

  • @TheElementSoap

    @TheElementSoap

    2 жыл бұрын

    Thank you so much!

  • @MIMGURU
    @MIMGURU2 жыл бұрын

    Supper

  • @TheElementSoap

    @TheElementSoap

    2 жыл бұрын

    Thank you!

  • @MIMGURU

    @MIMGURU

    2 жыл бұрын

    @@TheElementSoap welcome

  • @brunowalther275
    @brunowalther27511 ай бұрын

    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.

  • @TheElementSoap

    @TheElementSoap

    11 ай бұрын

    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! ;)

  • @brunowalther275

    @brunowalther275

    11 ай бұрын

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

  • @TheElementSoap

    @TheElementSoap

    11 ай бұрын

    @@brunowalther275 Thanks again! I stumbled through teaching myself Excel. That's very helpful!

Келесі