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
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 Month | 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 |
| Sep 2023 | $595,509.31 | $160,470.62 | $54,205.01 | $214,675.63 | 36.0% | 1,148 | 1,535 |
| Oct 2023 | $603,160.41 | $415,045.43 | $148,335.51 | $563,380.94 | 93.4% | 1,158 | 1,555 |
| Nov 2023 | $611,015.91 | $491,835.35 | $238,296.16 | $731,672.37 | 119.7% | 1,174 | 1,570 |
| Dec 2023 | $605,197.56 | $853,338.98 | $357,674.59 | $1,212,756.51 | 200.4% | 1,164 | 1,547 |
| Jan 2024 | $601,996.23 | $386,419.21 | $126,712.51 | $514,930.15 | 85.5% | 1,159 | 1,542 |
| Feb 2024 | $610,392.62 | $279,273.47 | $262,928.34 | $544,009.71 | 89.1% | 1,175 | 1,569 |
| Mar 2024 | $610,811.74 | $87,838.47 | $204,314.12 | $293,984.55 | 48.1% | 1,175 | 1,571 |
| Apr 2024 | $610,762.28 | $299,242.04 | $244,462.73 | $545,550.80 | 89.3% | 1,173 | 1,566 |
| May 2024 | $604,468.42 | $405,356.91 | $311,342.07 | $718,544.97 | 118.9% | 1,161 | 1,546 |
| Jun 2024 | $604,618.16 | $512,408.62 | $283,870.30 | $798,138.02 | 132.0% | 1,161 | 1,547 |
| Jul 2024 | $593,295.40 | $588,067.94 | $310,875.47 | $900,804.69 | 151.8% | 1,142 | 1,515 |
| Aug 2024 | $546,777.78 | $444,386.76 | $265,745.89 | $711,989.00 | 130.2% | 1,056 | 1,391 |
| Sep 2024 | $648,834.24 | $423,071.63 | $256,945.99 | $681,621.27 | 105.1% | 1,134 | 1,480 |
| Oct 2024 | $647,344.32 | $434,298.46 | $244,402.77 | $681,434.21 | 105.3% | 1,128 | 1,474 |
| Nov 2024 | $647,278.40 | $476,782.36 | $456,154.99 | $936,132.29 | 144.6% | 1,130 | 1,472 |
| Dec 2024 | $645,457.20 | $910,336.39 | $313,891.26 | $1,227,504.16 | 190.2% | 1,129 | 1,470 |
| Jan 2025 | $637,562.20 | $424,635.25 | $304,437.68 | $732,531.59 | 114.9% | 1,117 | 1,453 |
| Feb 2025 | $637,720.10 | $566,187.96 | $315,129.25 | $884,822.56 | 138.7% | 1,117 | 1,455 |
| Mar 2025 | $673,697.66 | $551,473.77 | $344,647.34 | $899,598.07 | 133.5% | 1,109 | 1,447 |
| Apr 2025 | $678,277.27 | $408,924.13 | $366,047.63 | $778,545.91 | 114.8% | 1,114 | 1,453 |
| May 2025 | $672,186.02 | $562,576.42 | $348,787.69 | $914,942.67 | 136.1% | 1,106 | 1,440 |
| Jun 2025 | $666,821.48 | $758,147.85 | $378,452.01 | $1,140,201.90 | 171.0% | 1,097 | 1,428 |
| Jul 2025 | $651,658.37 | $1,005,944.65 | $242,705.42 | $1,252,119.82 | 192.1% | 1,071 | 1,397 |
| Aug 2025 | $565,826.89 | $471,037.16 | $336,765.05 | $810,804.85 | 143.3% | 923 | 1,207 |
| Sep 2025 | $692,521.98 | $629,583.79 | $294,654.33 | $926,806.60 | 133.8% | 1,079 | 1,408 |
| Oct 2025 | $674,245.49 | $672,687.83 | $330,048.44 | $1,004,920.06 | 149.0% | 1,050 | 1,376 |
| Nov 2025 | $670,565.95 | $682,172.69 | $308,010.52 | $991,461.49 | 147.9% | 1,051 | 1,371 |
| Dec 2025 | $664,795.33 | $685,211.58 | $282,714.41 | $969,223.47 | 145.8% | 1,045 | 1,358 |
| Total: Selected Filter(s) | $17,672,798.72 | $14,586,755.72 | $7,932,557.48 | $22,583,108.26 | 127.8% | 31,246 | 41,143 |
&G &G
Page &P of &N image1.jpeg
File details come from the government source that posted it. Updated .