21-Manor ISD PvC 9.2023-12.2025.xlsx

XLSX spreadsheet 35 KB Posted

Attached to
Manor ISD - 2026 Medical RFP
Solicitation number
26-008RFP
Issued by
Travis County, Texas

About this file

This is a loss ratio analysis report for Manor Independent School District's self-funded medical and pharmacy plan covering the 28-month period from September 2023 through December 2025. The report documents the financial performance of the District's health plan, which serves approximately 1,045 to 1,174 medical subscribers and 1,207 to 1,571 total medical members during the analysis period.

The report reveals significant claims activity and loss ratio volatility throughout the contract term. Total medical and pharmacy premiums collected during the 28-month period amounted to $17,672,798.72, with total paid claims of $22,583,108.26, resulting in an overall loss ratio of 127.8%. Medical paid claims totaled $14,586,755.72 while pharmacy paid claims reached $7,932,557.48. Monthly loss ratios fluctuated considerably, ranging from a low of 36.0% in September 2023 to a high of 200.4% in December 2023, with the plan consistently operating above break-even (100% loss ratio) in most months, indicating claims exceeded premiums collected. Notable spikes in claims relative to premiums occurred in December 2023 (200.4%), December 2024 (190.2%), and July 2025 (192.1%), suggesting significant seasonal or catastrophic claim events during these periods. The data demonstrates the District's financial experience under its self-funded arrangement and provides critical baseline metrics for evaluating proposal responses for the 2026 Medical RFP solicitation.

View the file

Other files

File Type Posted
12-Manor Independent School District TX370294 BA0002 HSA Final SBC 09012025.pdf PDF
19-Manor ISD Large Claim Reporting 9.2023-12.2025.xlsx XLSX spreadsheet
15-Manor ISD HSA SPD 09012025.pdf PDF
13-Manor Independent School District TX370294 BA0004 HMO Final SBC 09012025.pdf PDF
4-FORM A – COMPANY INFORMATION.pdf PDF
7-Vendor Certification Form.pdf PDF
23-26-008RFP Manor ISD - 2026 Medical RFP.docx DOCX document
3-EDGAR CERTIFICATIONS FORM rev 11.17.2020.pdf PDF
14-Manor ISD HMO SPD 09012025.pdf PDF
10-PAST PERFORMANCE QUESTIONNAIRE.pdf PDF
9-FORM C - Manor ISD - Medical RFP Workbook.xlsx XLSX spreadsheet
22-Manor Professional Provider 2025.xlsx XLSX spreadsheet
17-Manor ISD - Medical Census 02012026.xlsx XLSX spreadsheet
1-ACKNOWLEDGEMENT OF ADDENDA.pdf PDF
2-CIQ (CONFLICT OF INTEREST QUESTIONAIRE).pdf PDF
6-W9.pdf PDF
18-Manor ISD Inpatient Provider 2025.xlsx XLSX spreadsheet
5-FORM B – PRICING AND SERVICE AFFIRMATION.pdf PDF
20-Manor ISD Medical Enrollment by Month 9.2023-12.2025.xlsx XLSX spreadsheet
8-26-008RFP MANOR ISD - 2026 MEDICAL RFP - advertisement.docx DOCX document
11-Manor Independent School District TX370294 BA0001 PPO Final SBC 09012025.pdf PDF
16-Manor ISD PPO SPD 09012025.pdf PDF
Show all 22

On GovTribe

Work with this file

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

Text version

Sheet1 Manor ISD Loss Ratio

Run Date: 1/29/2026

Metrics:(Medical and Pharmacy Premium, Medical Paid Claims, Pharmacy Paid Claims, Medical and Pharmacy Total Paid, Medical and Pharmacy Loss Ratio, Medical Subscribers Months, Medical Members Months)
Rows:(Paid Month)
Columns:(Metrics)
Paid Month:Last 28 Months [Sep 2023 - Dec 2025]
Coverage:Exclude (Dental)
Database:(MANOR INDEPENDENT SCHOOL DISTRICT: ALL)
Funding Type:(PREM)
Plan:(Texas)
Paid MonthMedical and Pharmacy PremiumMedical Paid ClaimsPharmacy Paid ClaimsMedical and Pharmacy Total PaidMedical and Pharmacy Loss RatioMedical Subscribers MonthsMedical Members Months
Sep 2023$595,509.31$160,470.62$54,205.01$214,675.6336.0%1,1481,535
Oct 2023$603,160.41$415,045.43$148,335.51$563,380.9493.4%1,1581,555
Nov 2023$611,015.91$491,835.35$238,296.16$731,672.37119.7%1,1741,570
Dec 2023$605,197.56$853,338.98$357,674.59$1,212,756.51200.4%1,1641,547
Jan 2024$601,996.23$386,419.21$126,712.51$514,930.1585.5%1,1591,542
Feb 2024$610,392.62$279,273.47$262,928.34$544,009.7189.1%1,1751,569
Mar 2024$610,811.74$87,838.47$204,314.12$293,984.5548.1%1,1751,571
Apr 2024$610,762.28$299,242.04$244,462.73$545,550.8089.3%1,1731,566
May 2024$604,468.42$405,356.91$311,342.07$718,544.97118.9%1,1611,546
Jun 2024$604,618.16$512,408.62$283,870.30$798,138.02132.0%1,1611,547
Jul 2024$593,295.40$588,067.94$310,875.47$900,804.69151.8%1,1421,515
Aug 2024$546,777.78$444,386.76$265,745.89$711,989.00130.2%1,0561,391
Sep 2024$648,834.24$423,071.63$256,945.99$681,621.27105.1%1,1341,480
Oct 2024$647,344.32$434,298.46$244,402.77$681,434.21105.3%1,1281,474
Nov 2024$647,278.40$476,782.36$456,154.99$936,132.29144.6%1,1301,472
Dec 2024$645,457.20$910,336.39$313,891.26$1,227,504.16190.2%1,1291,470
Jan 2025$637,562.20$424,635.25$304,437.68$732,531.59114.9%1,1171,453
Feb 2025$637,720.10$566,187.96$315,129.25$884,822.56138.7%1,1171,455
Mar 2025$673,697.66$551,473.77$344,647.34$899,598.07133.5%1,1091,447
Apr 2025$678,277.27$408,924.13$366,047.63$778,545.91114.8%1,1141,453
May 2025$672,186.02$562,576.42$348,787.69$914,942.67136.1%1,1061,440
Jun 2025$666,821.48$758,147.85$378,452.01$1,140,201.90171.0%1,0971,428
Jul 2025$651,658.37$1,005,944.65$242,705.42$1,252,119.82192.1%1,0711,397
Aug 2025$565,826.89$471,037.16$336,765.05$810,804.85143.3%9231,207
Sep 2025$692,521.98$629,583.79$294,654.33$926,806.60133.8%1,0791,408
Oct 2025$674,245.49$672,687.83$330,048.44$1,004,920.06149.0%1,0501,376
Nov 2025$670,565.95$682,172.69$308,010.52$991,461.49147.9%1,0511,371
Dec 2025$664,795.33$685,211.58$282,714.41$969,223.47145.8%1,0451,358
Total: Selected Filter(s)$17,672,798.72$14,586,755.72$7,932,557.48$22,583,108.26127.8%31,24641,143

&G &G

Page &P of &N image1.jpeg

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