A lip balm recipe works at any size once it's written in percent by weight. Multiply the batch weight by each percent for the grams, and divide the batch by what one tube holds for the count. A standard tube labeled 0.15 oz takes 4.25 g, so a 1,000 g batch fills 235 on paper. Some balm always stays in the pot and the pipette, so the real number is lower: at 4% loss, 225. For an order, work backward: tubes × 4.25 ÷ 0.96. Below is a recipe at three sizes, the sum for an order, and an Excel file that does it.
The short version
- Grams of each ingredient = batch weight × its percent.
- The percents add to 100.
- Tubes = batch weight × (1 − loss) ÷ the fill weight.
- Batch for an order = tubes × fill weight ÷ (1 − loss).
- Check the fill on a scale. The label states a net weight.
- TaroStack scales the recipe, takes the tubes and caps off stock, and gives each batch a lot. More below.
A recipe, as percent and as grams
A made-up apothecary's peppermint balm. The shares are an example for the arithmetic.
| Ingredient | Share | In 1,000 g | Cost |
|---|---|---|---|
| Sweet almond oil | 48% | 480 g | $4.75 |
| Beeswax | 25% | 250 g | $5.40 |
| Shea butter | 25% | 250 g | $2.65 |
| Vitamin E | 1% | 10 g | $0.88 |
| Peppermint essential oil | 1% | 10 g | $1.23 |
| Total | 100% | 1,000 g | $14.92 |
That's $14.92 of ingredients for 225 tubes, or about 7 cents a tube. The tube, its cap and the label cost several times what goes inside: the full sum is in how to price lip balm.
Three sizes
| Batch | Almond oil | Beeswax | Shea | Vitamin E | Peppermint | Tubes on paper | Tubes at 4% loss |
|---|---|---|---|---|---|---|---|
| 250 g | 120 g | 62.5 g | 62.5 g | 2.5 g | 2.5 g | 58 | 56 |
| 1,000 g | 480 g | 250 g | 250 g | 10 g | 10 g | 235 | 225 |
| 2,000 g | 960 g | 500 g | 500 g | 20 g | 20 g | 470 | 451 |
At 250 g, the peppermint is 2.5 g. That needs a scale that reads to 0.1 g or finer.
The batch for an order
| Step | Sum | Result |
|---|---|---|
| Tubes wanted × fill | 500 × 4.25 g | 2,125 g |
| Loss allowed | 4% | |
| Batch to make | 2,125 ÷ 0.96 | 2,214 g |
| A few spare, for the ones that sink or bubble | + 10 tubes | 2,258 g |
The 4% is this maker's own figure. To find yours, weigh the pot and pipette before and after a batch.
Tubes, tins and fill weight
| Container | Fill | From 1,000 g at 4% loss |
|---|---|---|
| Tube, 0.15 oz | 4.25 g | 225 |
| Tin, 0.5 oz | 14.2 g | 67 |
| Jar, 0.25 oz | 7.1 g | 135 |
Balm shrinks a little as it sets, which leaves a dip at the top of the tube. Many makers top up with a second small pour. Weigh ten filled tubes, subtract ten empties, and divide by ten: that's your real fill, and it should be at least the weight on the label.
Changing the recipe
Every change keeps the total at 100. A firmer balm for summer takes more wax and less oil: 28% wax and 45% oil, say. A softer one for tins goes the other way. For essential oils and flavors, the supplier gives a maximum for lip products; stay under it. Once a recipe changes, it's a new version with a new date, and the old tubes stay tied to the old one. How long a balm keeps is in lip balm shelf life, and what to record for each batch in cosmetic batch record template.
Get the calculator
Download the lip balm batch calculator. Type the batch size, your recipe's percents and the fill weight. It shows the grams of each, says whether the percents add to 100, and works out the tubes and the cost of each. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers. Packing them for sale is in how to package lip balm for sale.
Where this stops working
The sum says 2,258 g. The shelf has 400 tubes, 520 caps and a bag of beeswax that might be 300 g. And three months from now, a shop asks which batch a tube came from, and the answer is a guess.
How TaroStack does it
TaroStack sizes the batch from the recipe and the shelf together.
The recipe scales to the batch. It holds the balm's ingredients by weight and the tube, cap and label by the each. Record a batch of 225 or 510 and the amounts follow.
"What could I make right now" says how many tubes the wax, the oils, the empty tubes and the caps on hand can make. Whichever runs out first sets the number.
Recording the batch notes the lots. Which beeswax, which shea, which peppermint: on the batch record automatically. The tubes get a lot code of their own, and lot labels print with it.
Versions are kept. The summer recipe and the winter one are versions of the same balm, each dated.
Dates on every lot. The soonest to expire sells first, with an alert before a date passes.
| The job | Calculator | In TaroStack |
|---|---|---|
| Grams for 500 tubes | Work it backward | The recipe, scaled to the batch |
| Enough tubes and caps? | Count them | What could I make right now |
| Which batch is this tube? | A guess | Its lot code, and the lots that went in |
| Which recipe was that? | The newest file | The version the batch used |
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.
