Running a Removals Company: Survey Volumes, Crew & Van Planning, Pricing per m³ and Hour, Storage, Claims and Seasonal Peaks

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.

• Turn a surveyor's item list into cubic metres with a volume table and XLOOKUP, add the furniture and the packed boxes into one move volume and split the furniture volume by room.
• Turn load space into usable cubic metres, find how many loads a move needs with ROUNDUP, measure how full the vans really are and compare two vans on one day with one van doing two trips.
• Turn the move volume into loading and unloading hours with fictional rates per mover, add the drive time, round the job up to quarter hours and pay the crew with a minimum per job.
• Price the same four moves three ways – by volume with a minimum charge, by the hour for crew and van, and as a fixed price with a distance surcharge and a risk buffer – and see where each model wins or loses.
• Cost and price the packing materials of one move, tell margin from markup, size the packing service from the number of boxes and put materials and service into one packing quote.
• Turn each customer's stored volume into whole storage containers, count the containers in use, measure the occupancy of the store and see what a part-empty container does to the revenue per m³.
• Measure the damage-claim rate per 100 moves, find the share of bookings that falls on Fridays, Saturdays and the last days of the month, cost the extra crews you have to buy in and colour the overbooked days.
• Find the contribution of each job type, turn the month into an operating profit after fixed overheads, measure how busy the crews were and chart revenue against direct cost per move.