Dog Walking & Pet Sitting Business Math: Pricing, Group Walks, Routes & Capacity
Price walks and sitting visits from their real cost, fill a weekly schedule and a day route, measure boarding occupancy and churn and see how many regular clients make the business pay, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
In this intermediate course you plan a fictional one-person dog-walking and pet-sitting business in a spreadsheet. You build the cost of one visit from paid minutes, driving, insurance and kit and gross it up for booking fees, price bookings with XLOOKUP surcharges and add-ons, and compare group and solo walks per working hour, including the break-even group size. You time a day route with arrival and idle minutes, measure weekly utilisation with SUMIFS and COUNTIFS, calculate boarding nights, occupancy and revenue per available place-night, track churn, MRR and client lifetime value, and finish with a monthly P&L and the break-even number of regular clients.
Lessons
- Cost per Visit: Time, Travel, Insurance and Kit → a Minimum Price Pro
- The Price List: Solo vs Group, Add-ons and Weekend & Holiday Surcharges with XLOOKUP Pro
- Group Walks: Dogs per Walker, Revenue per Working Hour and the Break-even Group Size Pro
- The Day Route: Arrival Times, Idle Minutes, Utilisation and Visits per Day Pro
- The Weekly Schedule: Booked vs Available Hours and Utilisation by Day Pro
- House Sitting & Boarding: Nights, Long-Stay Discounts, Occupancy and Revenue per Available Night Pro
- The Client Base: Recurring Clients, Churn and Monthly Recurring Revenue Pro
- Capstone: Monthly P&L and the Break-even Number of Regular Clients Pro