Revenue per Visit & Payer Mix with SUMPRODUCT
This lesson is part of the course
In this lesson
You calculate the payer mix, monthly revenue by payer and the weighted average revenue per visit, then test what a shift in the mix would do.
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
- Patient Volume, Capacity & Utilisation Locked
- Revenue per Visit & Payer Mix with SUMPRODUCT Locked
- Collections, Net Collection Rate & Days in A/R Locked
- No-Show Rate, Lost Revenue & Overbooking Locked
- Staffing Ratios & Staff Cost per Visit Locked
- Break-even Visits for a New Provider Locked
- Supply Cost per Procedure & Inventory Turns Locked
- Practice KPI Dashboard with a Chart Locked