26-Manor ISD PvC - 9.2025-3.2026.xlsx
XLSX spreadsheet 33 KB Posted
- Attached to
- Manor ISD - 2026 Medical RFP
- Solicitation number
- 26-010RFP – RE-ISSUED
- Issued by
- Travis County, Texas
About this file
This is a claims expense and enrollment report for Manor Independent School District's health insurance plans covering the period September 2025 through March 2026. The document provides detailed financial and enrollment data for four benefit packages offered to district employees and their dependents: BLUE ESS HMO 2, BLUE ESS HMO 3000, BLUECH HDHP PPO 3400, and BLUECH PPO 1400. The report shows total medical and pharmacy premiums of $4,686,201.05, total medical paid claims of $3,680,176.69, total pharmacy paid claims of $1,810,761.01, and combined total paid claims of $5,505,828.00 for the seven-month period. Medical enrollment remained relatively stable across the six-month reporting period, with total medical member months of 9,591 and total subscriber months of 7,365, indicating consistent participation in the district's health benefit programs.
The claims data demonstrates utilization patterns across different plan types, with the BLUECH PPO 1400 plan showing the highest total paid claims at $2,217,618.53 across the period, followed by the BLUE ESS HMO 3000 plan at $1,903,595.98. Monthly claims fluctuations are evident throughout the period, with notable variations in both medical and pharmacy claims. The funding type is identified as PREM (Premium), and the data was extracted from the district's claims database with a run date of April 13, 2026. This report serves as a historical record of the district's health plan performance and utilization metrics, which would be relevant to the district's ongoing medical and prescription drug plan procurement efforts referenced in the related RFP.
View the file
Other files
Show all 27
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
Total Claim Expense Total Claim Expense
Run Date: 4/13/2026
| Metrics: | (Medical Paid Claims, Pharmacy Paid Claims, Dental Paid Claims, VBC Payments, Total Paid Claims, ASO Recoveries, HCA Draft Amount, Capitation, Plan Access Fee, Group Liability, Blue Card Access Fee, Medical and Pharmacy Premium, Dental Premium) | ||||
| Rows: | (Paid Month, Benefit Package) | ||||
| Columns: | (Metrics) | ||||
| Paid Month: | (Sep 2025 - Mar 2026) | ||||
| Database: | (MANOR INDEPENDENT SCHOOL DISTRICT: ALL) | ||||
| Funding Type: | (PREM) | ||||
| Paid Month | Benefit Package | Medical and Pharmacy Premium | Medical Paid Claims | Pharmacy Paid Claims | Total Paid Claims |
| Sep 2025 | BLUE ESS HMO 2 | $1,278.35 | $59,422.08 | $87,729.20 | $147,342.29 |
| Sep 2025 | BLUE ESS HMO 3000 | $328,442.82 | $83,136.05 | $117,273.64 | $201,755.66 |
| Sep 2025 | BLUECH HDHP PPO 3400 | $212,725.15 | $178,433.77 | $47,923.87 | $226,987.29 |
| Sep 2025 | BLUECH PPO 1400 | $148,443.99 | $308,591.89 | $41,727.62 | $350,721.36 |
| Oct 2025 | BLUE ESS HMO 2 | $0.00 | $24,613.90 | $1,175.18 | $25,791.35 |
| Oct 2025 | BLUE ESS HMO 3000 | $324,238.58 | $177,094.95 | $144,174.86 | $322,515.95 |
| Oct 2025 | BLUECH HDHP PPO 3400 | $203,332.05 | $192,897.78 | $98,447.24 | $291,822.56 |
| Oct 2025 | BLUECH PPO 1400 | $145,723.35 | $278,081.20 | $86,251.16 | $364,790.20 |
| Nov 2025 | BLUE ESS HMO 2 | $0.00 | $16,991.28 | $3,716.15 | $20,707.43 |
| Nov 2025 | BLUE ESS HMO 3000 | $324,123.44 | $153,001.02 | $168,814.39 | $322,160.60 |
| Nov 2025 | BLUECH HDHP PPO 3400 | $199,336.99 | $44,725.62 | $78,985.89 | $124,195.09 |
| Nov 2025 | BLUECH PPO 1400 | $146,154.01 | $467,454.77 | $56,494.09 | $524,398.37 |
| Dec 2025 | BLUE ESS HMO 2 | $0.00 | -$26,907.29 | $121.73 | -$26,756.36 |
| Dec 2025 | BLUE ESS HMO 3000 | $322,897.92 | $431,674.76 | $123,040.38 | $555,044.27 |
| Dec 2025 | BLUECH HDHP PPO 3400 | $197,060.09 | $55,421.75 | $102,439.86 | $158,344.69 |
| Dec 2025 | BLUECH PPO 1400 | $144,793.69 | $225,022.36 | $57,112.44 | $282,590.87 |
| Jan 2026 | BLUE ESS HMO 2 | $0.00 | -$72.40 | -$67.75 | |
| Jan 2026 | BLUE ESS HMO 3000 | $322,604.82 | $204,142.17 | $67,546.89 | $273,092.30 |
| Jan 2026 | BLUECH HDHP PPO 3400 | $197,532.72 | $51,975.60 | $64,840.47 | $117,379.24 |
| Jan 2026 | BLUECH PPO 1400 | $140,272.23 | $83,039.26 | $50,011.13 | $133,573.75 |
| Feb 2026 | BLUE ESS HMO 2 | $197.27 | $197.27 | ||
| Feb 2026 | BLUE ESS HMO 3000 | $324,469.66 | $182,483.62 | $80,318.12 | $264,215.22 |
| Feb 2026 | BLUECH HDHP PPO 3400 | $192,993.69 | -$6,486.49 | $61,048.81 | $55,126.03 |
| Feb 2026 | BLUECH PPO 1400 | $144,602.69 | $85,465.89 | $33,196.20 | $119,197.17 |
| Mar 2026 | BLUE ESS HMO 2 | -$550.24 | -$550.24 | ||
| Mar 2026 | BLUE ESS HMO 3000 | $326,046.25 | $164,703.27 | $63,100.58 | $229,280.32 |
| Mar 2026 | BLUECH HDHP PPO 3400 | $192,485.39 | $58,520.00 | $118,945.43 | $178,026.30 |
| Mar 2026 | BLUECH PPO 1400 | $146,643.17 | $187,102.85 | $56,325.68 | $243,946.77 |
| Total: Selected Filter(s) | $4,686,201.05 | $3,680,176.69 | $1,810,761.01 | $5,505,828.00 |
&G &G
Page &P of &N
Medical Enrollment by Month Medical Enrollment by Month
Run Date: 4/13/2026
| Metrics: | (Medical Member Months, Medical Subscriber Months) | |||
| Rows: | (Enrollment Month, Benefit Package, Plan Coverage Tier) | |||
| Columns: | (Metrics) | |||
| Enrollment Month: | (Sep 2025 - Mar 2026) | |||
| Coverage Type: | (Medical) | |||
| Database: | (MANOR INDEPENDENT SCHOOL DISTRICT: ALL) | |||
| Enrollment Month | Benefit Package | Plan Coverage Tier | Medical Member Months | Medical Subscriber Months |
| Sep 2025 | BLUE ESS HMO 2 | SUBSCRIBER AND CHILD | 2 | 1 |
| Sep 2025 | BLUE ESS HMO 3000 | SUBSCRIBER ONLY | 463 | 463 |
| Sep 2025 | BLUE ESS HMO 3000 | SUBSCRIBER AND SPOUSE | 12 | 6 |
| Sep 2025 | BLUE ESS HMO 3000 | SUBSCRIBER AND CHILD | 54 | 27 |
| Sep 2025 | BLUE ESS HMO 3000 | SUBSCRIBER AND CHILDREN | 130 | 34 |
| Sep 2025 | BLUE ESS HMO 3000 | SUBSCRIBER AND FAMILY | 34 | 8 |
| Sep 2025 | BLUECH HDHP PPO 3400 | SUBSCRIBER ONLY | 316 | 316 |
| Sep 2025 | BLUECH HDHP PPO 3400 | SUBSCRIBER AND SPOUSE | 4 | 2 |
| Sep 2025 | BLUECH HDHP PPO 3400 | SUBSCRIBER AND CHILD | 38 | 19 |
| Sep 2025 | BLUECH HDHP PPO 3400 | SUBSCRIBER AND CHILDREN | 67 | 21 |
| Sep 2025 | BLUECH HDHP PPO 3400 | SUBSCRIBER AND FAMILY | 25 | 6 |
| Sep 2025 | BLUECH PPO 1400 | SUBSCRIBER ONLY | 132 | 132 |
| Sep 2025 | BLUECH PPO 1400 | SUBSCRIBER AND SPOUSE | 4 | 2 |
| Sep 2025 | BLUECH PPO 1400 | SUBSCRIBER AND CHILD | 40 | 20 |
| Sep 2025 | BLUECH PPO 1400 | SUBSCRIBER AND CHILDREN | 54 | 15 |
| Sep 2025 | BLUECH PPO 1400 | SUBSCRIBER AND FAMILY | 33 | 7 |
| Oct 2025 | BLUE ESS HMO 3000 | SUBSCRIBER ONLY | 457 | 457 |
| Oct 2025 | BLUE ESS HMO 3000 | SUBSCRIBER AND SPOUSE | 12 | 6 |
| Oct 2025 | BLUE ESS HMO 3000 | SUBSCRIBER AND CHILD | 48 | 24 |
| Oct 2025 | BLUE ESS HMO 3000 | SUBSCRIBER AND CHILDREN | 138 | 36 |
| Oct 2025 | BLUE ESS HMO 3000 | SUBSCRIBER AND FAMILY | 35 | 8 |
| Oct 2025 | BLUECH HDHP PPO 3400 | SUBSCRIBER ONLY | 303 | 303 |
| Oct 2025 | BLUECH HDHP PPO 3400 | SUBSCRIBER AND SPOUSE | 4 | 2 |
| Oct 2025 | BLUECH HDHP PPO 3400 | SUBSCRIBER AND CHILD | 36 | 18 |
| Oct 2025 | BLUECH HDHP PPO 3400 | SUBSCRIBER AND CHILDREN | 64 | 20 |
| Oct 2025 | BLUECH HDHP PPO 3400 | SUBSCRIBER AND FAMILY | 21 | 5 |
| Oct 2025 | BLUECH PPO 1400 | SUBSCRIBER ONLY | 128 | 128 |
| Oct 2025 | BLUECH PPO 1400 | SUBSCRIBER AND SPOUSE | 4 | 2 |
| Oct 2025 | BLUECH PPO 1400 | SUBSCRIBER AND CHILD | 40 | 20 |
| Oct 2025 | BLUECH PPO 1400 | SUBSCRIBER AND CHILDREN | 54 | 15 |
| Oct 2025 | BLUECH PPO 1400 | SUBSCRIBER AND FAMILY | 33 | 7 |
| Nov 2025 | BLUE ESS HMO 3000 | SUBSCRIBER ONLY | 461 | 461 |
| Nov 2025 | BLUE ESS HMO 3000 | SUBSCRIBER AND SPOUSE | 12 | 6 |
| Nov 2025 | BLUE ESS HMO 3000 | SUBSCRIBER AND CHILD | 50 | 25 |
| Nov 2025 | BLUE ESS HMO 3000 | SUBSCRIBER AND CHILDREN | 135 | 35 |
| Nov 2025 | BLUE ESS HMO 3000 | SUBSCRIBER AND FAMILY | 35 | 8 |
| Nov 2025 | BLUECH HDHP PPO 3400 | SUBSCRIBER ONLY | 299 | 299 |
| Nov 2025 | BLUECH HDHP PPO 3400 | SUBSCRIBER AND SPOUSE | 4 | 2 |
| Nov 2025 | BLUECH HDHP PPO 3400 | SUBSCRIBER AND CHILD | 34 | 17 |
| Nov 2025 | BLUECH HDHP PPO 3400 | SUBSCRIBER AND CHILDREN | 61 | 19 |
| Nov 2025 | BLUECH HDHP PPO 3400 | SUBSCRIBER AND FAMILY | 21 | 5 |
| Nov 2025 | BLUECH PPO 1400 | SUBSCRIBER ONLY | 131 | 131 |
| Nov 2025 | BLUECH PPO 1400 | SUBSCRIBER AND SPOUSE | 4 | 2 |
| Nov 2025 | BLUECH PPO 1400 | SUBSCRIBER AND CHILD | 38 | 19 |
| Nov 2025 | BLUECH PPO 1400 | SUBSCRIBER AND CHILDREN | 57 | 16 |
| Nov 2025 | BLUECH PPO 1400 | SUBSCRIBER AND FAMILY | 30 | 7 |
| Dec 2025 | BLUE ESS HMO 3000 | SUBSCRIBER ONLY | 463 | 463 |
| Dec 2025 | BLUE ESS HMO 3000 | SUBSCRIBER AND SPOUSE | 12 | 6 |
| Dec 2025 | BLUE ESS HMO 3000 | SUBSCRIBER AND CHILD | 46 | 23 |
| Dec 2025 | BLUE ESS HMO 3000 | SUBSCRIBER AND CHILDREN | 137 | 36 |
| Dec 2025 | BLUE ESS HMO 3000 | SUBSCRIBER AND FAMILY | 31 | 7 |
| Dec 2025 | BLUECH HDHP PPO 3400 | SUBSCRIBER ONLY | 299 | 299 |
| Dec 2025 | BLUECH HDHP PPO 3400 | SUBSCRIBER AND SPOUSE | 4 | 2 |
| Dec 2025 | BLUECH HDHP PPO 3400 | SUBSCRIBER AND CHILD | 34 | 17 |
| Dec 2025 | BLUECH HDHP PPO 3400 | SUBSCRIBER AND CHILDREN | 61 | 19 |
| Dec 2025 | BLUECH HDHP PPO 3400 | SUBSCRIBER AND FAMILY | 17 | 4 |
| Dec 2025 | BLUECH PPO 1400 | SUBSCRIBER ONLY | 130 | 130 |
| Dec 2025 | BLUECH PPO 1400 | SUBSCRIBER AND SPOUSE | 4 | 2 |
| Dec 2025 | BLUECH PPO 1400 | SUBSCRIBER AND CHILD | 36 | 18 |
| Dec 2025 | BLUECH PPO 1400 | SUBSCRIBER AND CHILDREN | 57 | 16 |
| Dec 2025 | BLUECH PPO 1400 | SUBSCRIBER AND FAMILY | 29 | 7 |
| Jan 2026 | BLUE ESS HMO 3000 | SUBSCRIBER ONLY | 462 | 462 |
| Jan 2026 | BLUE ESS HMO 3000 | SUBSCRIBER AND SPOUSE | 12 | 6 |
| Jan 2026 | BLUE ESS HMO 3000 | SUBSCRIBER AND CHILD | 50 | 25 |
| Jan 2026 | BLUE ESS HMO 3000 | SUBSCRIBER AND CHILDREN | 137 | 36 |
| Jan 2026 | BLUE ESS HMO 3000 | SUBSCRIBER AND FAMILY | 28 | 6 |
| Jan 2026 | BLUECH HDHP PPO 3400 | SUBSCRIBER ONLY | 299 | 299 |
| Jan 2026 | BLUECH HDHP PPO 3400 | SUBSCRIBER AND SPOUSE | 4 | 2 |
| Jan 2026 | BLUECH HDHP PPO 3400 | SUBSCRIBER AND CHILD | 34 | 17 |
| Jan 2026 | BLUECH HDHP PPO 3400 | SUBSCRIBER AND CHILDREN | 61 | 19 |
| Jan 2026 | BLUECH HDHP PPO 3400 | SUBSCRIBER AND FAMILY | 17 | 4 |
| Jan 2026 | BLUECH PPO 1400 | SUBSCRIBER ONLY | 128 | 128 |
| Jan 2026 | BLUECH PPO 1400 | SUBSCRIBER AND SPOUSE | 4 | 2 |
| Jan 2026 | BLUECH PPO 1400 | SUBSCRIBER AND CHILD | 34 | 17 |
| Jan 2026 | BLUECH PPO 1400 | SUBSCRIBER AND CHILDREN | 57 | 16 |
| Jan 2026 | BLUECH PPO 1400 | SUBSCRIBER AND FAMILY | 26 | 6 |
| Feb 2026 | BLUE ESS HMO 3000 | SUBSCRIBER ONLY | 458 | 458 |
| Feb 2026 | BLUE ESS HMO 3000 | SUBSCRIBER AND SPOUSE | 12 | 6 |
| Feb 2026 | BLUE ESS HMO 3000 | SUBSCRIBER AND CHILD | 54 | 27 |
| Feb 2026 | BLUE ESS HMO 3000 | SUBSCRIBER AND CHILDREN | 143 | 38 |
| Feb 2026 | BLUE ESS HMO 3000 | SUBSCRIBER AND FAMILY | 28 | 6 |
| Feb 2026 | BLUECH HDHP PPO 3400 | SUBSCRIBER ONLY | 292 | 292 |
| Feb 2026 | BLUECH HDHP PPO 3400 | SUBSCRIBER AND SPOUSE | 4 | 2 |
| Feb 2026 | BLUECH HDHP PPO 3400 | SUBSCRIBER AND CHILD | 34 | 17 |
| Feb 2026 | BLUECH HDHP PPO 3400 | SUBSCRIBER AND CHILDREN | 58 | 18 |
| Feb 2026 | BLUECH HDHP PPO 3400 | SUBSCRIBER AND FAMILY | 17 | 4 |
| Feb 2026 | BLUECH PPO 1400 | SUBSCRIBER ONLY | 131 | 131 |
| Feb 2026 | BLUECH PPO 1400 | SUBSCRIBER AND SPOUSE | 4 | 2 |
| Feb 2026 | BLUECH PPO 1400 | SUBSCRIBER AND CHILD | 36 | 18 |
| Feb 2026 | BLUECH PPO 1400 | SUBSCRIBER AND CHILDREN | 61 | 17 |
| Feb 2026 | BLUECH PPO 1400 | SUBSCRIBER AND FAMILY | 26 | 6 |
| Mar 2026 | BLUE ESS HMO 3000 | SUBSCRIBER ONLY | 461 | 461 |
| Mar 2026 | BLUE ESS HMO 3000 | SUBSCRIBER AND SPOUSE | 12 | 6 |
| Mar 2026 | BLUE ESS HMO 3000 | SUBSCRIBER AND CHILD | 54 | 27 |
| Mar 2026 | BLUE ESS HMO 3000 | SUBSCRIBER AND CHILDREN | 143 | 38 |
| Mar 2026 | BLUE ESS HMO 3000 | SUBSCRIBER AND FAMILY | 28 | 6 |
| Mar 2026 | BLUECH HDHP PPO 3400 | SUBSCRIBER ONLY | 291 | 291 |
| Mar 2026 | BLUECH HDHP PPO 3400 | SUBSCRIBER AND SPOUSE | 4 | 2 |
| Mar 2026 | BLUECH HDHP PPO 3400 | SUBSCRIBER AND CHILD | 34 | 17 |
| Mar 2026 | BLUECH HDHP PPO 3400 | SUBSCRIBER AND CHILDREN | 58 | 18 |
| Mar 2026 | BLUECH HDHP PPO 3400 | SUBSCRIBER AND FAMILY | 17 | 4 |
| Mar 2026 | BLUECH PPO 1400 | SUBSCRIBER ONLY | 134 | 134 |
| Mar 2026 | BLUECH PPO 1400 | SUBSCRIBER AND SPOUSE | 4 | 2 |
| Mar 2026 | BLUECH PPO 1400 | SUBSCRIBER AND CHILD | 36 | 18 |
| Mar 2026 | BLUECH PPO 1400 | SUBSCRIBER AND CHILDREN | 61 | 17 |
| Mar 2026 | BLUECH PPO 1400 | SUBSCRIBER AND FAMILY | 26 | 6 |
| Total: Selected Filter(s) | 9,591 | 7,365 |
&G &G
Page &P of &N image1.jpeg
File details come from the government source that posted it. Updated .