The Weekly Schedule: Booked vs Available Hours and Utilisation by Day
This lesson is part of the course
In this lesson
You 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.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Cost per Visit: Time, Travel, Insurance and Kit → a Minimum Price Locked
- The Price List: Solo vs Group, Add-ons and Weekend & Holiday Surcharges with XLOOKUP Locked
- Group Walks: Dogs per Walker, Revenue per Working Hour and the Break-even Group Size Locked
- The Day Route: Arrival Times, Idle Minutes, Utilisation and Visits per Day Locked
- The Weekly Schedule: Booked vs Available Hours and Utilisation by Day Locked
- House Sitting & Boarding: Nights, Long-Stay Discounts, Occupancy and Revenue per Available Night Locked
- The Client Base: Recurring Clients, Churn and Monthly Recurring Revenue Locked
- Capstone: Monthly P&L and the Break-even Number of Regular Clients Locked