The Per-Patient Budget: Visit Schedule Grids, Payment per Visit & Margin per Patient
This lesson is part of the course
In this lesson
You turn the sponsor's visit schedule into a payment for every visit with SUMPRODUCT, total the payment per completed patient, compare it with the site's cost visit by visit and find the margin per patient.
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