Equipment & Event Rental Business: Utilisation, Day–Week–Month Rate Ladders, Availability Calendars, Damage Waivers & Item Payback
Run a fictional tool and party rental shop with numbers: time and money utilisation, day, weekend, week and 4-week rates, the cheapest rate combination, availability for overlapping bookings, damage waivers and deposits, delivery zones, turnaround days and item payback, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
This course runs a fictional tool and party rental shop with numbers. You measure time and financial utilisation per item and pool them per category with SUMIFS and SUMPRODUCT, build weekend, week and 4-week rates from the day rate with ROUND and MROUND, and bill any rental length at the cheapest fair combination with INT, MOD and MIN. You turn overlapping bookings into an availability calendar with COUNTIFS and SUMIFS, test damage waivers and deposits, price delivery zones with XLOOKUP, count turnaround days and finish with payback months, fleet decisions with IFS and a revenue chart. Every cell is checked as you go.
Lessons
- Time vs Financial Utilisation: How Hard Each Item Works and What It Earns Pro
- Rate Ladders: Day, Weekend, Week & 4-Week Rates and the Effective Price per Day Pro
- The Billing Calculator: the Cheapest Mix of 4-Week Blocks, Weeks and Days Pro
- The Availability Calendar: Overlapping Bookings, Units Booked per Day & Overbooking Flags Pro
- Damage Waivers & Deposits: Waiver Income vs Damage Absorbed, Loss Ratios and Deposit Holds Pro
- Delivery & Setup: Distance Zones, Crew Hours and Minimum Order Values Pro
- Turnaround & Maintenance: Cleaning and Check Days, Lost Rental Days and Cost per Rental Pro
- Item Payback & Fleet Decisions: Payback Months, Buy-Another Triggers and the Retire List Pro