Exam Mix & Revenue: Payer Rates, Revenue per Exam & per Scanner Hour
This lesson is part of the course
In this lesson
You look up fictional payer rates with INDEX/MATCH, turn last month's exams by payer into revenue with SUMPRODUCT, pool the revenue per exam correctly and find the exam type that earns the most per hour of scanner time.
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
- Scanner Capacity: Opening Hours, Slot Lengths & Bookable Slots Locked
- Utilisation: Booked vs Completed Slots & Idle Time by Hour Locked
- Exam Mix & Revenue: Payer Rates, Revenue per Exam & per Scanner Hour Locked
- Staffing: Technologists & Front Desk per Shift and Staff Cost per Exam Locked
- Cost per Scan: Fixed vs Variable Costs & Break-Even Exams Locked
- No-Shows & Overbooking: Rates by Weekday, Lost Margin & an Overbooking Rule Locked
- Report Turnaround: Hours from Scan to Signed Report, Median, p90 & Target Locked
- New Scanner Case: Added Volume, Cash Flows, NPV, IRR, Payback & a Chart Locked