Ingredient Calculations Not Adding Up Correctly

KNSoap

Active member
Premium
Joined
Mar 26, 2022
Messages
127
The ingredient calculations are not adding up to what they should be when using the % is based on “total batch”. For example, in this particular formula linked below, I have Sodium Lactate at 2% of total batch, and it calculates out to 117.63g; however, if the 2% is based on the total batch weight, which is 7142.82g, it should have calculated out to 142.85g. There are multiple ones on this formula that are not calculating right. This is just an example.

 

Attachments

  • IMG_0656.jpeg
    IMG_0656.jpeg
    33.9 KB · Views: 7
  • IMG_0657.jpeg
    IMG_0657.jpeg
    33.9 KB · Views: 7
The ingredient calculations are not adding up to what they should be when using the % is based on “total batch”. For example, in this particular formula linked below, I have Sodium Lactate at 2% of total batch, and it calculates out to 117.63g; however, if the 2% is based on the total batch weight, which is 7142.82g, it should have calculated out to 142.85g. There are multiple ones on this formula that are not calculating right. This is just an example.


The developer told me that this is a non-soap recipe, and currently our soapmaking software doesn’t support % of batch for non-soap. That’s why it’s not adding it up correctly. We’ll see if he can add it soon.
 
The developer told me that this is a non-soap recipe, and currently our soapmaking software doesn’t support % of batch for non-soap. That’s why it’s not adding it up correctly. We’ll see if he can add it soon.
Ok.
 
@KNSoap we've show total batch weight for non-soap product. Also 5881 g is your total batch weight not 7142 g.
 
@KNSoap we've show total batch weight for non-soap product. Also 5881 g is your total batch weight not 7142 g.
No sir. The total weight is 7142g. 5881g is only the oils and fragrance, you have to include the rest of the additives and the water too. Add up all of these numbers and it will be 7142g.
 

Attachments

  • IMG_0759.jpeg
    IMG_0759.jpeg
    23.8 KB · Views: 1
No sir. The total weight is 7142g. 5881g is only the oils and fragrance, you have to include the rest of the additives and the water too. Add up all of these numbers and it will be 7142g.
Total batch weight = total oils + fragrances + additives (only items with fixed amount)

In your recipes most of them are % of batch so they're excluded in batch weight.
 
Total batch weight = total oils + fragrances + additives (only items with fixed amount)

In your recipes most of them are % of batch so they're excluded in batch weight.
That’s not how the math is supposed to work. Formulas are always written as w/w%. To calculate the % of each ingredient, you have to know how big of a batch you want, for example, let’s say I wanted a 100g total batch weight and I need 2% of the total batch to be Sodium Lactate, this would calculate out to 2g of Sodium Lactate for the whole batch. There needs to be something similar to the “oil weight” but it should be something like “desired batch weight” for the percentages to calculate correctly.

Here’s an explanation that I hope helps:
 

Attachments

  • IMG_0761.jpeg
    IMG_0761.jpeg
    68.8 KB · Views: 1
We've deploy new fixes. Can you check it? @KNSoap
Thank you! I’m playing around with it now. One thing I did notice is that the oils, fats, butters column states that it must equal 100%, which, in a non-soap item is not necessarily true. For example, these ingredients need to be 1.5% of the total batch weight and will not equal 100%. So maybe that 100% should only show for soap products but for non-soap products, the percentages should be based on the whole batch. I hope that helps!
 

Attachments

  • IMG_0793.jpeg
    IMG_0793.jpeg
    190.4 KB · Views: 0
@Alan the fragrance for cosmetics should be based on the total batch weight, not the oil weight. Can that be updated?
 

Attachments

  • IMG_0795.jpeg
    IMG_0795.jpeg
    117.1 KB · Views: 1
Top