Staffing per Shift: Workload Minutes, Staff Needed & Cost per Test
This lesson is part of the course
In this lesson
You turn test volumes per shift into hands-on workload minutes with SUMPRODUCT, convert them into staff with ROUNDUP and a minimum rule, price the shifts with premiums and compare the staff cost per test of day and night.
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
- Test Volumes: Samples by Department, Weekday & Hour and the Peak Locked
- Cost per Reportable Result: Reagents, Controls, Calibrators & Labour Locked
- Batch vs Continuous Runs: Controls per Run, Cost per Result & Waiting Time Locked
- Instrument Capacity: Throughput, Peak Utilisation & When a Second Analyser Is Needed Locked
- Turnaround Times: Receipt to Result, Median, p90 & the Late Share Locked
- Staffing per Shift: Workload Minutes, Staff Needed & Cost per Test Locked
- Send-Out vs In-House: Cost per Test, Break-Even Volume & a Volume Table Locked
- Test Menu Profitability: Margin per Test, Ranking, Loss Makers & a Chart Locked