Anstarx
Well-Known Member
I've seen people asking about a basic price calculator and figured I could share mine if anyone's interested.
I only made it for myself so it's pretty basic and calculate the price batch by batch. I typically use it as a guideline and will consider other elements (cure time, difficulty to make, etc.) when coming up with a final price.
There are programs out there for soap makers to use but they usually have a fee. However, if you are just starting and just want to roughly calculate your cost and go from there, I believe this can be useful.
You can download it from here:
https://drive.google.com/file/d/1VP6ixfeMf2ohw_OHXlLHAkJm_HTQtiB4/view?usp=sharing
Some basic tutorial of the calculator:
1. Once you downloaded and opened the file, it should look something like this.
2. The default number for the oils' price are from my supplier and based on my local currency. You need to do the calculation and change those to what price your oils come in yourself.
I put olive oils on top since they are in every batch of mine. Other oils are arranged in alphabet order.
Feel free to change the types of oil, price, and units, according to your need. I like using the price/g but you can change it to lb, oz, kg etc., just put in the corresponding number for price per unit.
If you don't need this much oil types and want to delete some, I recommend you just leave blanks instead of deleting them, as I worry it may mess up the calculation
3. Type in the amount of the oils you used in the yellow column. Don't edit anything in the Total column since it does the calculation.
4. Put in other costs
The lye entry is colored blue, don't forget about it.
You need to manually put in fragrance and additive cost since I figured they can be estimated easily. You can also easily make a copy and customize the calculator into a fragrance calculator.
For packaging, price/pc is how much it costs you to package each bar of soap. pc# is how many bars of soap came out of this batch. Total is how much packaging alone costs, like before you don't need to do anything about it.
5. See the pricing. The result is automatically generated as you put oil and other costs in.
Basically, if you just want to know the material cost, see the orange row.
The white row is simply a guide on pricing. You can customize it by editing the calculation.
6. Sample calculation using my calendula soap recipe.
Since distilled water is very cheap for me I didn't include it in the calculation. If I used special liquid like milk, beer, aloe vera, etc, I will put its cost in with the additives.
So my base price for selling 1 bar of calendula soap will be 33.78. If someone want to buy the whole batch the base price will be 225.2 per batch.
I ended up decided to sell this soap at 36 since my olive oil was infused therefore took more effort.
That's it! If you have any suggestions or questions, feel free to let me know.
I only made it for myself so it's pretty basic and calculate the price batch by batch. I typically use it as a guideline and will consider other elements (cure time, difficulty to make, etc.) when coming up with a final price.
There are programs out there for soap makers to use but they usually have a fee. However, if you are just starting and just want to roughly calculate your cost and go from there, I believe this can be useful.
You can download it from here:
https://drive.google.com/file/d/1VP6ixfeMf2ohw_OHXlLHAkJm_HTQtiB4/view?usp=sharing
Some basic tutorial of the calculator:
1. Once you downloaded and opened the file, it should look something like this.
2. The default number for the oils' price are from my supplier and based on my local currency. You need to do the calculation and change those to what price your oils come in yourself.
I put olive oils on top since they are in every batch of mine. Other oils are arranged in alphabet order.
Feel free to change the types of oil, price, and units, according to your need. I like using the price/g but you can change it to lb, oz, kg etc., just put in the corresponding number for price per unit.
If you don't need this much oil types and want to delete some, I recommend you just leave blanks instead of deleting them, as I worry it may mess up the calculation
3. Type in the amount of the oils you used in the yellow column. Don't edit anything in the Total column since it does the calculation.
4. Put in other costs
The lye entry is colored blue, don't forget about it.
You need to manually put in fragrance and additive cost since I figured they can be estimated easily. You can also easily make a copy and customize the calculator into a fragrance calculator.
For packaging, price/pc is how much it costs you to package each bar of soap. pc# is how many bars of soap came out of this batch. Total is how much packaging alone costs, like before you don't need to do anything about it.
5. See the pricing. The result is automatically generated as you put oil and other costs in.
Basically, if you just want to know the material cost, see the orange row.
The white row is simply a guide on pricing. You can customize it by editing the calculation.
6. Sample calculation using my calendula soap recipe.
Since distilled water is very cheap for me I didn't include it in the calculation. If I used special liquid like milk, beer, aloe vera, etc, I will put its cost in with the additives.
So my base price for selling 1 bar of calendula soap will be 33.78. If someone want to buy the whole batch the base price will be 225.2 per batch.
I ended up decided to sell this soap at 36 since my olive oil was infused therefore took more effort.
That's it! If you have any suggestions or questions, feel free to let me know.
I think we ALL just kinda glossed over that part. 
Yes?
