Skip to content

Lip Balm Batch Calculator: Grams, Tubes and Cost

A lip balm batch calculator in Excel: turn a percent recipe into grams, see how many tubes or tins a batch fills after loss, and what each one costs to fill.

By Koa Sterling. Product specialist at TaroStack and small business owner. Yes, I am a real human, and I actually sit in front of a computer and write these articles. Reviewed November 19, 2026 · 5 min read

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.

Questions people also ask

How many lip balm tubes does a batch make?

Divide the batch weight, less your loss, by the fill weight. A 1,000 g batch at 4% loss fills about 225 tubes of 4.25 g.

How much lip balm is in a standard tube?

The common tube is labeled 0.15 oz, which is 4.25 g.

How do I convert a lip balm recipe to percent?

Weigh each ingredient in grams, add them up, and divide each by the total. Those shares work at any batch size.

We use AI to help with the research for these articles. Every one is read, checked against its sources and edited by Koa before it's published. Spot a mistake? Tell us and we'll fix it and say so. How we write these.

Let’s get your stack in order.

Get TaroStack

Sign up now for your free 14 day trial. No credit card required.