Q&A Attachment 11 - Validation Report for Facility Sample.xlsx

This validation report is a sample worksheet provided by the Idaho Department of Correction (IDOC) to demonstrate how facility staffing hours and costs are calculated and reconciled for medical and mental health services contracting purposes. The report illustrates the methodology for tracking contracted hours versus actual hours paid across multiple clinical and administrative positions, including physicians, nurses, mental health professionals, dental staff, and support personnel. The example shows how vacant hours are managed, hour transfers between positions are documented, overage calculations are determined, and payback obligations are computed based on contracted rates.

The validation report demonstrates IDOC's approach to monitoring contractor compliance with staffing level commitments and identifying financial adjustments when actual hours exceed or fall short of contracted amounts. The sample data indicates positions with significant overages requiring payback, such as the Midlevel Practitioner (285.50 hours overage at $69/hour = $19,699.50 payback) and Dentist (77.00 hours overage at $98/hour = $7,546.00 payback), as well as positions with sufficient hours that required internal transfers to balance allocations. The report format establishes the administrative framework for validating contractor performance and calculating financial reconciliations, with total contracted hours of 10,546.40 and total service hour repayment obligations of $2,562.50 in this illustrative example. This validation methodology would apply to the statewide medical and mental health services RFP across all IDOC facilities.