Clinical Laboratory Operations: Test Volumes, Cost per Test, Batch Runs, Instrument Capacity, Turnaround Times & Send-Out Decisions
Manage the numbers of a fictional diagnostic lab: test volumes by hour, cost per reportable result including controls and calibrations, batch vs continuous runs, instrument capacity, turnaround percentiles and when to send tests out, 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 operations and business side of a fictional diagnostic laboratory in a spreadsheet, with no clinical interpretation. You summarise sample volumes by department, weekday and hour with COUNTIFS and SUMIFS and find the peak, count every test an analyser really performs to get the cost per reportable result, compare batch schedules on cost and waiting time, check analyser utilisation and the need for a second instrument with ROUNDUP, measure turnaround medians and p90 with PERCENTILE.INC, staff shifts from workload minutes, find the break-even volume for sending tests out, and finish with a ranked test-menu dashboard and chart.
Lessons
- Test Volumes: Samples by Department, Weekday & Hour and the Peak Pro
- Cost per Reportable Result: Reagents, Controls, Calibrators & Labour Pro
- Batch vs Continuous Runs: Controls per Run, Cost per Result & Waiting Time Pro
- Instrument Capacity: Throughput, Peak Utilisation & When a Second Analyser Is Needed Pro
- Turnaround Times: Receipt to Result, Median, p90 & the Late Share Pro
- Staffing per Shift: Workload Minutes, Staff Needed & Cost per Test Pro
- Send-Out vs In-House: Cost per Test, Break-Even Volume & a Volume Table Pro
- Test Menu Profitability: Margin per Test, Ranking, Loss Makers & a Chart Pro