Equipment & Event Rental Business: Utilisation, Day–Week–Month Rate Ladders, Availability Calendars, Damage Waivers & Item Payback

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Measure how many days each rental item was out and how much it earned compared with what it cost, per item and pooled per category.
• Build weekend, week and 4-week rates as multiples of each item's day rate, round them to tidy prices and see how much cheaper a long rental is per day.
• Split any rental length into 4-week blocks, weeks and extra days with INT and MOD, price it straight and then charge the customer the cheapest fair combination with MIN.
• Turn a list of marquee bookings into a daily calendar of bookings, units out and free units, flag overbooked days and check whether a new request fits.
• Check whether a fictional damage waiver earns more than the damage it covers, per category and in total, and set deposits with a minimum and a rounding rule.
• Price delivery by distance zone with XLOOKUP, charge setup crew hours, top small orders up to the minimum and total each order.
• Count the days items spend between rentals, the most rentals a unit can take in a year, the maintenance cost per rental and what a faster turnaround is worth.
• Work out how many months each item needs to pay for itself, flag items that deserve a second unit or should leave the fleet, and chart revenue against costs.