Lotion & Body Butter Cost Calculator – Percent Formula, Containers, Pumps, Labor & Pricing
Price Lotions and Body Butters From Your Formula — Water, Oils, Butters, Emulsifier, Preservative, Containers, and Labor
A lotion and body butter calculator built on a percent formula. Enter batch size, container net weight, fill loss, bottle and pump cost, labels, and extras, then up to 8 ingredients as a percent with cost per pound to see ounces of each, containers per batch, batch cost, true cost per container, and suggested retail and wholesale prices.
What This Spreadsheet Calculates
- Formula total check
- Ounces of each ingredient
- Containers per batch
- Batch ingredient cost
- True cost per container
- Ingredient cost per ounce
- Suggested retail and wholesale
- Profit per batch hour
Lotions earn repeat buyers. Price them right the first time.
Price every bottle right.
Each purchase comes with a .xlsx spreadsheet compatible with Microsoft Excel, Google Sheets, and Numbers. Enjoy free updates for every spreadsheet you own. You'll be notified when a file is updated, and you can download the latest version anytime from your account page.
This is a one-time payment, so you pay once and own the spreadsheet forever. You can download the original file anytime, and future updates are included at no extra cost!
We offer a 7-day money-back guarantee. If you feel our spreadsheets aren't providing the pricing calculations you need, we'll refund your purchase—no questions asked!
Need More Than One Spreadsheet?
The Craft Calculators Lifetime Spreadsheet Vault includes 323 spreadsheets across 29 categories — soap and bath, crochet and knitting, machine embroidery, home bakery, candle making, pricing, labor costs, HTV, balloon decor, paper crafts, jewelry, Etsy fees, digital products, and more. One-time payment. Lifetime access. Free future updates.
