Client Hours: Visits, Durations, Minimum Visit Lengths & Billable Hours
This lesson is part of the course
In this lesson
From one week of visits you apply a minimum billable visit length with MAX, count visits and scheduled hours per weekday with COUNTIFS and SUMIFS, and total the hours the agency can bill.
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
- Client Hours: Visits, Durations, Minimum Visit Lengths & Billable Hours Locked
- Pay vs Bill Rates: Gross Margin per Hour by Service & Weekend Uplifts Locked
- Caregiver Scheduling: Demand vs Availability, Coverage Gaps & Caregivers Needed Locked
- Travel Time & Mileage: Paid vs Billable Hours and Utilisation Locked
- Overtime: Weekly Threshold, Premium Cost & Rebalancing the Rota Locked
- Billing & Cash: Invoice Cycles, Payer Terms, Receivables & the Cash Gap Locked
- Turnover & Recruiting: Leavers, Cost per Hire, Onboarding Hours & Turnover Cost Locked
- Agency P&L & Dashboard: Margin by Service, Break-Even Hours & a Margin Chart Locked