# A Spreadsheet Soap Price Calculator

### Help Support Soapmaking Forum:

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

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.

#### TheGecko

##### Well-Known Member
So my base price for selling 1 bar of calendula soap will be 33.78.

\$33.78 for one bar of soap?!?

My cost for a single color, scented bar with packaging is \$1.73. My recipe includes RSPO and 20% Butters. I sell at \$5.00 (local market price).

#### jcandleattic

##### Well-Known Member
Yeah, I'd say the calculations are off just a bit.

I use a combination of SM3 and my own spreadsheet I've made for my cost analysis'.

amd

#### Anstarx

##### Well-Known Member
\$33.78 for one bar of soap?!?

My cost for a single color, scented bar with packaging is \$1.73. My recipe includes RSPO and 20% Butters. I sell at \$5.00 (local market price).
. I saw that too but figured it was a different currency?

I have stated that the calculator is in my local currency, not USD, which is why I told people to do their own calculation of oil price. It's a about 4-5 USD. 33 is a pretty normal price for my local soap market.

#### Jersey Girl

Supporting Member
I have stated that the calculator is in my local currency, not USD, which is why I told people to do their own calculation of oil price. It's a about 4-5 USD. 33 is a pretty normal price for my local soap market.

I assumed that.

#### earlene

##### Grandmother & Soaper
Supporting Member
Very nice, Anstarx! Thank you for sharing. Excellent job.

And of course, you DID state it was for your local currency. It's funny how often folks forget we don't all hail from the same country.

#### jcandleattic

##### Well-Known Member
And of course, you DID state it was for your local currency.
I think we ALL just kinda glossed over that part.

#### Zing

Supporting Member
Uh, people, clearly @Anstarx is from Cloud Nine so of course it's going to be 33.78! Also, clearly I need to move there or at least visit. I'm thinking that it may be a pandemic-free zone there? Right? Please? Yes?

#### Anstarx

##### Well-Known Member
I think we ALL just kinda glossed over that part.
No worries, mate! Probably should've made that part clearer in my original post to avoid confusion
Uh, people, clearly @Anstarx is from Cloud Nine so of course it's going to be 33.78! Also, clearly I need to move there or at least visit. I'm thinking that it may be a pandemic-free zone there? Right? Please? Yes?
Yep you totally should visit once traveling got easier! The weather's perfect, no virus allowed, and everyone loves soap!

In seriousness tho, I use the same username in other online communities and I've received some unprovoked and unwanted political debate recently, so I just changed my location in all my public profiles across the internet to Cloud Nine to save myself the hassles lol.

#### Arimara

Supporting Member
That looks pretty nifty. I'm still not selling but it is nice to know how much a bar of soap is worth.

#### privatekane

##### Member
Hi, I just came to say thank you for sharing!! I love when people share!

#### melonpan

Supporting Member
This is really handy! Thank you for sharing.
I tried to create a spreadsheet for myself a few months ago that would give me the price breakdown but it's less easy to use and I just realised I actually missed the lye and fragrance on mine. I'm happy you shared yours as it just makes more sense this way

#### Alfa_Lazcares

##### Well-Known Member
And here I was making calculations by hand. Thank you!

#### Peachy Clean Soap

##### Well-Known Member
@Anstarx Thank you so much' so very nice of you to share it w/ This Group. I'm gonna down load it & face my soap cost reality... Ouch'

Replies
4
Views
390
Replies
73
Views
5K
Replies
20
Views
1K
Replies
19
Views
634
Replies
3
Views
608