resources

A practical Excel workbook for cosmetic formulators who need to cost formulas properly, manage ingredient inventory, calculate packaging costs, compare suppliers, convert currencies, and build more accurate commercial pricing without expensive software or guesswork.

Built for real lab work, it includes an Ingredient Cost Calculator, Commercial Cost Calculator, Ingredient Inventory, Formula Archive, Packaging Cost tool, Supplier Comparison tab, SG Conversion Tool, and Exchange Rate tab. It helps you calculate raw material costs, batch costs, cost per gram, packaging assemblies, wholesale pricing, RRP, supplier price differences, and formula cost changes over time.

The workbook is supplied as a self-contained .xlsx file with no macros, no add-ins, no plugins, and no live internet connection required. It works best in Microsoft Excel, also works in LibreOffice Calc, and can be used with some limitations in Google Sheets and Apple Numbers. If you would like a Google Sheet version, please email me after purchase and I can send you the Sheet version.

A video tutorial is included here: https://youtu.be/7tehskC4abg