Staffing Document - Final.xlsx

XLSX spreadsheet 45 KB Posted

Attached to
RFP DOC Correctional Health ServicesBid Documents State and local contract opportunity
Solicitation number
27-87787
Issued by
Hendricks County, Indiana

About this file

This is a staffing document matrix outlining personnel requirements for Indiana's correctional and juvenile facilities under a contract arrangement. The document details full-time equivalent (FTE) staffing allocations across 23 facilities, including adult correctional institutions, work release centers, and juvenile detention facilities. The staffing matrix encompasses 47 distinct position types spanning clinical, administrative, and support roles, with a total contract requirement of 885.34 FTEs when including regional office positions. Positions include medical professionals such as physicians, nurse practitioners, and dentists; nursing staff including registered nurses, licensed practical nurses, and nursing assistants; behavioral health specialists and mental health professionals; addiction recovery specialists and professionals; administrative and clerical personnel; and specialized positions such as optometrists, psychiatrists, and psychologists. The matrix breaks down staffing requirements by facility and shift (day, evening, and night), with the largest concentration of personnel allocated to facilities such as Stark County Indiana State Prison (87.90 FTEs), Logansport (72.75 FTEs), and Pendleton Correctional Facility (94.48 FTEs).

The document indicates a regional office component requiring 31.00 FTEs to support statewide operations, with positions including a Vice President of Operations, Regional Medical Director, Regional Director of Nursing, Regional Behavioral Health Director, and various coordinators and managers. The staffing allocation reflects differentiated clinical needs across facilities, with some institutions requiring minimal staffing (such as Edinburg Correctional Facility at 6.80 FTEs) while others maintain significantly larger teams. Administrative support is distributed across all facilities with positions such as administrative assistants, medical records clerks, and mental health clerks. The matrix demonstrates a comprehensive healthcare and behavioral health delivery model integrated throughout Indiana's correctional system, with nursing staff representing the largest category of personnel across all shifts.

View the file

Other files for this state and local contract opportunity

Other files attached to RFP DOC Correctional Health ServicesBid Documents, newest first.
File Type Posted
Att I - Vespa Group.docx DOCX document
CENTRAL REGION Assets Line 183.xlsx XLSX spreadsheet
Q3 2025 HS Audit Deficiencies Line 11 Line 74.pdf PDF
MOU with FSSA Line 116.pdf PDF
Att G - Q&A - posted 9.17.26.xlsx XLSX spreadsheet
Addendum #3 - RFP 27-87787.docx DOCX document
Att I - Ready_and_Willing_2_Help_Healthcare.docx DOCX document
Bidders Library as of 8.12.26-rtp.zip ZIP file
Att I - 22nd Century Technologies.docx DOCX document
Att K - Scope of Work - updated by agency 8.17.26 (1).docx DOCX document
Q1 2024 HS Audit Deficiences Line 11 Line 74.pdf PDF
Q2 2025 HS Audit Deficiencies Line 11 Line 74.pdf PDF
01-07-101 Case Management Line 85.pdf PDF
Q4 2024 HS Audit Deficiencies Line 11Line 74.pdf PDF
Att I - Axon Advisors.docx DOCX document
Att I - Bravia.docx DOCX document
Att D Cost Proposalv2-27-87787 (1).xlsx XLSX spreadsheet
RFP Boilerplate-rtpv2.docx DOCX document
Addendum 1 - 27-87787.docx DOCX document
Addendum 4 updated.docx DOCX document
Att I - Harsha Behavioral Center.docx DOCX document
Att I - VitalCore.docx DOCX document
Att K - Scope of Work -v2.docx DOCX document
Att B2 - IOT-PaaS.docx DOCX document
IN performance measures.xlsx XLSX spreadsheet
IDOC Health Services Manuals.zip ZIP file
2025 MEDICAL CLAIMS Query.xlsx XLSX spreadsheet
ARS Utilization 9-2025 (1).pdf PDF
Att K - Scope of Work - rtp.docx DOCX document
Facility Security Levels 3-2023.pdf PDF
Infrastructure Overview-rtp.docx DOCX document
Att B - Sample Contract.docx DOCX document
HSRMaster Dec-June 2026.zip ZIP file
Att I - Pre-Proposal Network Form-rtp.docx DOCX document
2024 MEDICAL CLAIMS Query.xlsx XLSX spreadsheet
Restrictive Housing and Isolation Rooms.docx DOCX document
CAA Provisions.pdf PDF
Fiscal Year 2027 Baseline hourly rates.docx DOCX document
Facility Addresses.docx DOCX document
Att B1 - IOT-IaaS.docx DOCX document
Artificial Intelligence - Technical Proposal Questions.docx DOCX document
Fiscal Year 2027 Baseline hourly rates.pdf PDF
Att F Technical Proposal-rtp.docx DOCX document
Att J - Attestation Form-rtp.docx DOCX document
Att D Cost Proposal-rtp.xlsx XLSX spreadsheet
Att G - Q&A Template-rtp.xlsx XLSX spreadsheet
Manuals.zip ZIP file
HCSDs and Manuals (1).zip ZIP file
Att H - Reference Check Form-rtp.docx DOCX document
Att B3 - IOT-SaaS.docx DOCX document
Show all 50

RFP DOC Correctional Health ServicesBid Documents has more files on GovTribe.

On GovTribe

Work with this file on GovTribe

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Matrix By Facility

PositionTotal Contract FTE (s)Branchville (BCF)Chain O' Lakes (COL)Correctional Industrial Facility (CIF)Edinburg Correctional Facility (ECF)Stark CountyIndiana State Prison (ISP)Indiana Women's Prison (IWP)Parole Liaisons (Vendor)Madison Correctional Facility (MCU)Miami Correctional Facility (MCF)New Castle Correctional Facility (NCCF)Pendleton Correctional Facility (ISR)Plainfield Correctional Facility (IYC)Putnamville (ISF)Reception Diagnostic Center (RDC)Rockville Correctional Facility (RCF)South Bend Work Release (SBWR)Wabash Valley Correction Facility (WVCF)Westville (WCC)Laporte (LPJ)Logansport (LJCF)Pendleton Juvenile (PJCF)Heritage Trails (HTCF)
Day Shift
Addiction Recovery Specialist66.0005.000.003.000.000.007.002.000.004.003.006.002.006.005.000.004.000.006.007.001.002.001.002.00
Addiction Recovery Professional13.0001.000.001.000.000.002.000.000.000.001.000.002.002.001.000.000.000.001.002.000.000.000.000.00
Administrative Assistant21.5001.000.001.000.000.002.001.000.001.002.002.001.003.001.001.001.000.501.001.000.000.001.001.00
Behavioral Health Specialist40.0001.000.001.000.000.002.002.000.000.001.009.0010.001.001.000.501.000.005.002.000.001.002.000.50
Certified Medication Aide41.0000.000.002.400.000.003.601.800.003.005.604.503.603.602.000.002.700.003.603.600.000.000.001.00
Clerk7.5000.000.000.000.000.001.000.000.000.001.002.000.000.000.001.001.000.000.001.000.000.000.000.50
Dental Assistant21.8001.000.101.000.200.002.000.600.000.502.001.801.001.002.001.001.000.102.003.000.200.200.300.80
Dentist20.0001.000.101.000.200.001.500.500.000.401.751.751.001.501.001.001.400.102.002.400.200.200.200.80
Director of Nursing14.0001.000.001.000.000.001.001.000.001.001.001.001.001.001.001.001.000.001.001.000.000.000.000.00
Director-Addiction Recovery23.0001.000.201.001.000.502.001.000.001.001.001.002.001.001.001.002.000.301.002.000.001.001.001.00
Health Services Administrator17.0001.000.101.000.200.001.001.000.001.001.001.001.001.001.001.001.000.101.001.000.300.501.000.80
Limsnet Coordinator0.6000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.600.000.000.000.000.000.000.000.00
LPN48.9001.400.002.601.000.000.001.400.003.6011.806.303.802.200.802.402.300.003.504.000.000.401.400.00
Medical Assistant28.5002.000.001.000.000.001.001.000.001.002.002.502.001.003.004.002.000.002.003.000.000.000.001.00
Medical Director13.8501.000.001.000.000.001.001.000.000.400.751.001.001.001.001.001.000.001.001.000.000.500.200.00
Medical Records Clerk22.4001.000.001.001.000.001.501.000.001.002.002.001.502.001.001.001.500.001.502.400.500.000.500.00
Mental Health Clerk/ Psychiatry19.5001.000.001.000.000.001.001.000.001.000.002.003.001.001.001.502.000.002.001.000.500.000.000.50
Mental Health Intern1.0000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.001.000.000.000.000.000.00
Mental Health Nurse Practitioner7.3250.080.000.750.000.000.000.000.000.000.001.601.401.000.501.001.000.000.000.000.000.000.000.00
Mental Health Professional61.5002.000.002.000.000.003.002.000.002.006.008.507.003.003.004.003.000.006.004.001.002.003.000.00
Nurse Practitioner22.6800.500.080.400.200.002.000.500.001.002.752.501.002.501.002.002.000.152.001.000.100.000.001.00
Nursing Assistant22.5000.000.000.000.000.000.000.000.000.001.405.400.002.806.000.002.700.001.402.800.000.000.000.00
Optometrist0.3850.030.000.030.000.000.050.000.000.000.050.030.000.030.050.000.030.000.050.050.000.000.000.00
Psychiatrist7.2000.000.000.000.000.001.001.000.000.150.600.600.000.000.201.000.200.001.000.500.150.400.400.00
Psychologist25.0001.000.001.000.000.002.001.000.000.502.003.003.001.001.002.001.000.003.001.000.501.001.000.00
RN71.6002.801.000.801.000.003.403.600.002.008.005.003.606.207.403.004.201.806.503.601.402.201.402.70
Staff Physician2.0000.000.000.000.000.000.000.000.000.001.000.000.000.000.000.000.000.000.001.000.000.000.000.00
Substance Abuse Clerk7.0000.000.001.000.000.001.000.000.000.001.000.001.001.000.000.000.000.001.001.000.000.000.000.00
Transitional Health Care Facilitator13.0000.000.001.001.000.000.001.000.001.001.001.000.001.001.001.001.001.000.001.000.000.001.000.00
Transitional Health Care Liaison10.0000.000.000.000.000.000.000.0010.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Quality Assurance Cooridnator1.0000.000.000.000.000.000.000.000.000.001.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Total Day Shift670.7425.811.5826.985.800.5042.0525.4010.0025.5561.7071.4852.9046.8342.9532.0040.034.0555.5553.355.8511.4015.4013.60670.76
000000000000000000000000
LPN46.402.400.003.601.000.003.202.800.002.704.804.502.304.002.801.503.200.002.004.600.000.001.000.00
Nursing Assistant13.400.000.000.000.000.000.000.000.000.002.404.500.001.400.000.001.900.001.401.800.000.000.000.00
RN40.501.400.001.800.000.003.801.900.001.602.004.002.801.802.801.401.000.003.804.201.401.401.402.00
Total Evening Shift100.303.800.005.401.000.007.004.700.004.309.2013.005.107.205.602.906.100.007.2010.601.401.402.402.00
Night Shift000000000000000000000000
LPN40.301.400.001.400.000.003.800.400.001.8010.103.601.402.402.801.401.400.002.804.200.001.400.000.00
Nursing Assistant10.100.000.000.000.000.000.000.000.000.001.403.600.001.400.000.001.900.000.001.800.000.000.000.00
RN32.901.400.001.400.000.001.801.400.001.405.502.801.401.801.401.401.800.002.802.801.400.001.401.00
Total Night Shift83.302.800.002.800.000.005.601.800.003.2017.0010.002.805.604.202.805.100.005.608.801.401.401.401.0083.30
Total All Shifts854.3432.41.5835.186.800.5054.6531.9010.0033.0587.9094.4860.8059.6352.7537.7051.234.0568.3572.758.6514.2019.2016.60
Regional office31.00
Total Including Regional Office885.34

Regional

Regional Staff PositionFTE Final
Vice President of Operations1.00
Regional Medical Director1.00
Associate Regional Medical Director1.00
Regional Director of Nursing1.00
Education/Training RN0.00
UM Case Manager1.00
Regional Utilization Manager (RN)-OP1.00
IC Coordinator1.00
CQI Coordinator1.00
Women/Youth/Infant Services Coordinator1.00
Regional Behavioral Health Director (PsyD/PhD)1.00
Regional Director of Psychiatry1.00
Regional Mental Health Director1.00
Regional Director-Addiction Recovery1.00
Asso. Regional Dir. of Addiction Recovery Services0.00
Regional Director of Transitional Health1.00
Regional Dental Director0.50
Regional Manager3.00
Grievance/Correspondence Coordinator1.00
Director of Telehealth1.00
Administrative Assistant IOT/NextGen Coord1.00
Administrative Assistant Office Manager1.00
Physical Therapist3.00
X-Ray Technician (vendor)4.50
MAT Coordinator2.00
Regional Clinical Pharmacist0.00
Total Regional31.00
31.00

File details come from the government source that posted it. Updated .