The retail-to-service ratio is product sales as a percentage of service revenue. Retail is high-margin add-on income, and the ratio shows how well the team recommends take-home product.
The example
$1,200 retail, $8,000 service.
| A | B | |
|---|---|---|
| 1 | Item | Value |
| 2 | 1200 / 8000 | — |
| 3 | Ratio | → 15% |
The formula
The formula:
How it works
How it works:
- Divide retail (product) sales by service sales for the ratio.
- Industry benchmarks often cite 10–25% as a healthy range.
- Retail carries higher margin and needs no chair time — it’s pure leverage.
- Track per stylist with SUMIF to see who recommends product effectively.
Retail is the most profitable hour a stylist never works. A product recommendation at checkout adds margin without consuming chair time, so a salon at 20% retail-to-service is meaningfully more profitable than one at 5% on the same service revenue. Tracking the ratio per stylist (with SUMIF) turns “sell more product” into a coachable number and often into a commission tier.
Try it: interactive demo
Retail and service sales.
Variations
Per stylist
Who sells product:
Retail per client
Average add-on:
Retail share of total
Of all revenue:
Pitfalls & errors
Ratio to service. The standard ratio is retail ÷ service, not ÷ total.
Same period. Retail and service over the same window.
Zero service. No service revenue gives #DIV/0!.
Practice workbook
Frequently asked questions
How do I calculate retail-to-service ratio in Excel?
What's a healthy ratio?
How do I track it per stylist?
Stop fighting formulas. Learn them in a day.
This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class