1 1

Essentially Natural

Formulation Calculator & Costing Tool

Formulation Calculator & Costing Tool

Formulation Calculator & Costing Tool is a free, interactive Excel worksheet that helps you build, scale, and cost your formulations in one place. Enter your ingredient percentages and batch size, and it calculates the grams required for each ingredient automatically. It also includes simple costing fields so you can estimate total batch cost from your ingredient pricing. It’s designed to be easy to use for both beginners and experienced formulators.

Download instantly here.

Need detailed info? COAs and SDSs are available — just send us the product name and batch number, and we’ll gladly share them with you.
  • Format: Excel workbook (.xlsx)
  • Tool Type: Formulation worksheet, batch calculator, costing sheet
  • Includes: Phase, function, ingredient name, INCI, percentage, grams, costing columns, notes sections
  • Compatibility: Microsoft Excel or similar spreadsheet program/app
  • Cost: Free

    This product is commonly used to:

  • Convert percentages into grams for a chosen batch size
  • Scale a formula up or down quickly
  • Record ingredient functions and INCI in one worksheet
  • Estimate ingredient costs and total batch cost
  • Keep clear notes on method, observations, and changes

    This product is suitable for:

  • DIY formulators and hobby makers
  • Small brands and batch makers who need quick costing
  • Students learning formulation structure and batch scaling

    • This product is not for:

  • Anyone without spreadsheet software that can open .xlsx files
  • Regulatory compliance checks or automated label claim validation
  • As a Formulation Worksheet: Enter your formula name, date, and batch size.
  • As a Batch Calculator: Fill in your ingredient percentages and let the sheet calculate grams used.
  • As a Costing Tool: Add your ingredient cost per kg (or your chosen unit) to calculate total ingredient cost.
  • Processing Tip: Double-check that your total percentage adds to 100% before batching.
  • This tool supports calculation and costing only and does not replace stability testing or preservative efficacy testing.
  • Always verify your final weights and calculations before manufacturing.
  • Store a backup copy of your file before making edits.

Q: Can I use this for any batch size?
A: Yes, set your batch size and the sheet will calculate grams for each ingredient based on your percentages.

Q: Can I use a different currency?
A: Yes, you can edit the currency fields to match your preferred currency.

Q: Will it work in Google Sheets or other apps?
A: It is designed for Excel-style spreadsheets, and compatibility may vary in other programs.

View full details