Concentrated shampoo looks expensive by the gallon and cheap by the bottle, and both are wrong. What matters is what each groom uses. This tool works it out by size, from your own products and dilution ratios.
Curious what it looks like inside? Here's how cost per groom is figured, step by step. Most owners use it alongside our groom pricing calculator.
What the Grooming Shampoo & Supply Cost Calculator does
- Dilution for any ratio and bottle size, with a quick mix chart
- Cost per mixed ounce for every shampoo, conditioner and spray
- Supply cost per groom for XS to XL dogs and cats
- Average supply cost based on your own size mix
- Monthly and yearly supply budget
- Inventory with grooms left and a reorder list with how many to buy
- Catches common slips, like a ratio typed as 1:16 or a missing container size
What's inside
6 tabs: Start Here, Dilution, Cost Per Groom, Reorder, Products, Settings.
Who it's for
Any groomer who mixes concentrates, and owners who want supply costs inside their prices instead of guessed.
What you get
Two spreadsheet files (.xlsx): one filled with examples so you can see exactly how it works, and a blank copy ready for your business. For Microsoft Excel and Google Sheets. No macros, no subscription.
The formulas are locked, so a stray keystroke can't break them. You only type in the yellow cells.
What you need to use it
- Microsoft Excel 2010 or newer, on Windows or Mac, including Microsoft 365
- Or Google Sheets in any web browser, free with a Google account
- A laptop or desktop works best for setup. Phones and tablets are fine for checking numbers and quick entries.
- No macros, add-ins or internet connection needed once it's downloaded. Apple Numbers isn't supported.
Questions
Does it work with ready-to-use products?
Yes. Leave the ratio blank and it's treated as ready to use.
Does it include towels and laundry?
Yes. Add them as a per-groom cost and they're counted in every size.
Is there a blank version?
Yes. Every download has two files: one filled with examples so you can see how everything works, and a blank copy ready for your own business. Your rates and settings come filled in as a starting point, so change them to match yours.
Can I change the formulas?
The gray formula cells are locked so they can't be erased by accident. If you really want to change one, open Review in Excel and choose Unprotect Sheet. There's no password.
Does it work in Google Sheets?
Yes. Upload the file to Google Drive and open it with Google Sheets. Everything works the same.
How do Free Lifetime Updates work?
Whenever we release a new version, you can download it free from your account, forever. We'll email you when there's something new.
