Imaging Center Economics: Scanner Capacity, Exam Mix, Revenue per Exam, Technologist Staffing, No-Shows & Scanner Payback
Run the business side of a fictional imaging center: scanner hours and slots by exam type, utilisation, payer-mix revenue per exam, staffing per shift, cost per scan, no-shows and the payback of a new scanner, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
This course covers the business side of a fictional imaging center in a spreadsheet, with no clinical content. You turn opening hours and slot lengths into bookable slots with XLOOKUP and INT, measure booked and completed utilisation and idle time per hour band with COUNTIFS, price exams from a fictional payer rate table with INDEX/MATCH and SUMPRODUCT, and compare revenue per exam with revenue per scanner hour. You staff shifts with ROUNDUP and minimum rules, split fixed and variable cost to find the break-even volume, value no-shows and build a cautious overbooking rule with IF, track report turnaround with PERCENTILE.INC, and finish with a new-scanner case using NPV, IRR, payback and a chart.
Lessons
- Scanner Capacity: Opening Hours, Slot Lengths & Bookable Slots Pro
- Utilisation: Booked vs Completed Slots & Idle Time by Hour Pro
- Exam Mix & Revenue: Payer Rates, Revenue per Exam & per Scanner Hour Pro
- Staffing: Technologists & Front Desk per Shift and Staff Cost per Exam Pro
- Cost per Scan: Fixed vs Variable Costs & Break-Even Exams Pro
- No-Shows & Overbooking: Rates by Weekday, Lost Margin & an Overbooking Rule Pro
- Report Turnaround: Hours from Scan to Signed Report, Median, p90 & Target Pro
- New Scanner Case: Added Volume, Cash Flows, NPV, IRR, Payback & a Chart Pro