Dog Walking & Pet Sitting Business Math: Pricing, Group Walks, Routes & Capacity

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 fictional dog walker's paid minutes, driving, insurance and kit into a cost per visit and gross it up for the booking fee to find the lowest price that still pays.
• Price eight bookings from a service table and a day-type table with XLOOKUP, add the surcharge and the extra-dog fee, and measure how much of the week's revenue comes from surcharges.
• Work out how many groups Tuesday needs, compare the revenue per working hour of a full group with a solo walk and solve for the smallest group that beats a solo walk.
• Turn a Thursday route into arrival times, idle minutes before each booked visit (spotting the late one), the day's utilisation and the number of visits a working day can hold.
• Total next week's booked hours and visits per day with SUMIFS and COUNTIFS, turn them into a utilisation per day and calculate the pooled utilisation of the whole week.
• Count the nights of eight boarding stays, price them with a long-stay discount, measure October's occupancy against the places available and calculate the revenue per available place-night.
• Roll Tailwind's regular clients forward month by month, measure the monthly churn against the clients at the start of each month, value the client base as monthly recurring revenue and estimate a client's lifetime value.
• Build a monthly P&L for 10 to 45 regular clients, find the break-even number of clients and the number needed for a profit cushion, and chart revenue against total costs.