Lotion formulas are written in percent by weight so they work at any size. To make a batch, multiply the batch weight by each ingredient's percent: in a 4,000 g batch, water at 70% is 2,800 g and a preservative at 1% is 40 g. The percents have to add to exactly 100. Then divide the batch by what one jar takes, less what stays in the pot, to find how many jars you'll fill. Below is a worked formula at three sizes, how to size a batch for an order, and an Excel file that does it and checks the total.
The short version
- Grams of each ingredient = batch weight × its percent.
- Everything by weight, water included.
- The percents must add to 100. If they don't, something is missing or doubled.
- Batch for an order = jars × fill weight ÷ (1 − your loss).
- Small percents need a scale that reads to 0.1 g or better.
- TaroStack scales the formula to the batch and records which lots went in. More below.
A formula, as percent and as grams
A made-up skincare maker's lotion. The percents are an example for the arithmetic, not a tested formula.
| Ingredient | Phase | Share | In 4,000 g | Cost |
|---|---|---|---|---|
| Distilled water | Water | 70% | 2,800 g | $0.84 |
| Glycerin | Water | 4% | 160 g | $1.06 |
| Coconut oil, fractionated | Oil | 10% | 400 g | $5.28 |
| Shea butter | Oil | 6% | 240 g | $2.54 |
| Emulsifying wax | Oil | 5% | 200 g | $3.08 |
| Stearic acid | Oil | 3% | 120 g | $1.06 |
| Preservative | Cool-down | 1% | 40 g | $2.12 |
| Fragrance | Cool-down | 1% | 40 g | $3.53 |
| Total | 100% | 4,000 g | $19.50 |
At 232 g a jar, 4,000 g fills 17 jars on paper, and the ingredients come to $1.15 a jar.
Three batch sizes
| Batch | Water | Oils and wax | Preservative | Fragrance | Jars at 232 g | Ingredients |
|---|---|---|---|---|---|---|
| 1,000 g | 700 g | 240 g | 10 g | 10 g | 4 | $4.88 |
| 4,000 g | 2,800 g | 960 g | 40 g | 40 g | 17 | $19.50 |
| 8,000 g | 5,600 g | 1,920 g | 80 g | 80 g | 34 | $39.00 |
The oils and wax column adds the four oil-phase rows. Glycerin makes up the rest.
Size the batch for the order, with the loss in
Seventeen jars at 232 g is 3,944 g. That leaves 56 g of a 4,000 g batch, which is 1.4%. If more than that stays on the pot, the stick blender and the piping bag, the seventeenth jar comes up short. So work the other way:
| Step | Sum | Result |
|---|---|---|
| Jars wanted × fill | 34 × 232 g | 7,888 g |
| Loss allowed | 3% | |
| Batch to make | 7,888 ÷ 0.97 | 8,132 g |
Weigh the pot before and after a batch or two to find your own loss. Three percent is this maker's figure.
Things the percent hides
| Thing | Why it matters |
|---|---|
| The scale | 1% of a 500 g test batch is 5 g. A scale that reads in whole grams is too coarse for that |
| Water lost to heating | A water phase held hot loses weight. Weigh it after heating and top it up |
| Preservative rate | The supplier states the range for their product. Use theirs, not this example's |
| Fragrance limit | The fragrance's supplier gives a maximum for leave-on products |
| A change to one percent | Something else has to change to keep the total at 100. Usually the water |
What to write down for each batch is in lotion making log sheet and cosmetic batch record template. How long the finished lotion keeps is in lotion shelf life.
Get the calculator
Download the lotion batch calculator. Type the batch size and your formula's percents. It shows the grams of each, says whether the percents add to 100, and works out the jars and the cost a jar. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers. To add jars, labels and your time, use the batch cost calculator.
Where this stops working
The calculator gives the same answer for every batch. Real batches aren't the same: this one used the new drum of shea, that one was made with the last of the old preservative, and a customer's jar has a batch code that leads to a line in a notebook, if it leads anywhere.
How TaroStack does it
TaroStack makes the formula the recipe and each batch a record.
The formula scales to the batch. A recipe holds its ingredients and its batch size, with versions kept when the formula changes. Record a 4,000 g batch or an 8,000 g one and the amounts follow.
Recording the batch notes the lots. Which shea, which preservative, which fragrance: the lots used go onto the batch record automatically, and the jars get a lot code of their own.
"What could I make right now" says how many jars the ingredients and the empty jars on hand can make.
Your checks go on the batch. pH, temperatures and initials are fields of your own on the batch-record form.
Dates on every lot. Ingredients and finished jars carry their dates, and the soonest to expire is used first.
| The job | Calculator and notebook | In TaroStack |
|---|---|---|
| Grams for this batch | Type the size | The recipe, scaled to the batch |
| Which lots went in | Written down, sometimes | On the batch record |
| A jar's batch code | Leads to a notebook | Leads to the batch and its lots |
| Preservative near its date | Read the drum | An alert |
Recipes, batches and lots are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes). The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.
