A rental fleet is a pile of capital that only pays when it is out the door. Utilization is the share of possible rental-days you actually sold: rental-days out, divided by fleet size times days open. It is the one number that tells you whether to buy more adult skis, sell off the kids' boards, or leave the fleet alone.
340 adult-ski rental-days from a 60-pair fleet over a 7-day week is 340 of 420 possible — 81% utilization.
The example
One holiday week, three fleets. The adult skis are nearly maxed out; the kids' skis have room.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Fleet | Pairs | Days open | Rental-days | Utilization |
| 2 | Adult skis | 60 | 7 | 340 | 81.0% |
| 3 | Snowboards | 35 | 7 | 190 | 77.6% |
| 4 | Kids skis | 40 | 7 | 168 | 60.0% |
The formula
Available rental-days in the denominator, sold rental-days in the numerator:
How it works
The formula is a simple ratio; the definitions are where shops go wrong:
B2*C2is the maximum rental-days you could have sold: 60 pairs times 7 days is 420. That is the ceiling.D2is rental-days actually sold. A 3-day rental counts as 3, not 1 — count days out, not tickets.- Divide, and format the cell as a percentage. 340 of 420 is 0.8095, shown as 81.0%.
- Compare across fleets. The kids' skis at 60% are carrying 16 idle pairs on an average day.
Multi-day rentals sit out on days the shop is closed too. If you are closed midweek, either count those days as open in C2 or exclude them from the rental-day count — just be consistent.
Try it: interactive demo
Enter the fleet size, days in the period and rental-days sold.
Variations
Idle pairs on an average day
The fleet minus the average pairs out. This is the number that tells you how many pairs you could sell off.
Fleet size for a target utilization
Working backwards: rental-days you expect, divided by days and by the utilization you want, rounded up to whole pairs.
Pitfalls & errors
Peak-week utilization and season utilization are different numbers. A fleet sized for 80% in Christmas week will run 30% in March. Decide which one you are sizing for.
Track by size band as well as by type. Total adult-ski utilization can look fine while 170 cm is sold out every morning and 190 cm never leaves the rack.
Do not count tickets in D2. One 5-day rental is 5 rental-days. Counting it as 1 will show a fleet at 20% that is actually fully booked.
Practice workbook
Frequently asked questions
What utilization should a rental shop aim for?
Should I include demo or shop-use skis in the fleet count?
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