Screen Failures & Early Withdrawals: Capped Payments, Partial Visits & Revenue Impact
This lesson is part of the course
In this lesson
You apply a fictional cap on paid screen failures with MIN and INT, pay withdrawn patients only for the visits they attended with SUMIFS, measure the revenue lost through withdrawals and total what the site has really earned.
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
- Cost per Visit: Staff Minutes, Loaded Hourly Costs & Overhead Locked
- The Per-Patient Budget: Visit Schedule Grids, Payment per Visit & Margin per Patient Locked
- Start-Up & Close-Out Costs: Fixed Fees, Training, Archiving & the Gap to the Sponsor Offer Locked
- Enrolment Forecast: Screened, Enrolled & Completed Patients and Months to Target Locked
- Screen Failures & Early Withdrawals: Capped Payments, Partial Visits & Revenue Impact Locked
- Invoiceable Items: Logging Extras, Not-Yet-Invoiced Amounts & Ageing Locked
- Holdbacks & Payment Timing: Payable Amounts, Working-Day Terms, Cash vs Earned Locked
- Study P&L & Dashboard: Revenue vs Cost by Category, Break-Even Enrolment & a Chart Locked