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

File Type Posted
3-EDGAR CERTIFICATIONS FORM rev 11.17.2020.pdf PDF
4-FORM A – COMPANY INFORMATION.pdf PDF
10-Manor Independent School District TX370294 BA0004 HMO Final SBC 09012025.pdf PDF
8-Manor Independent School District TX370294 BA0001 PPO Final SBC 09012025.pdf PDF
27-FORM C - Manor ISD - Medical RFP Workbook.xlsx XLSX spreadsheet
9-Manor Independent School District TX370294 BA0002 HSA Final SBC 09012025.pdf PDF
11-Manor ISD HMO SPD 09012025.pdf PDF
13-Manor ISD PPO SPD 09012025.pdf PDF
12-Manor ISD HSA SPD 09012025.pdf PDF
18-Manor Professional Provider 2025.xlsx XLSX spreadsheet
24-Manor ISD - 2026 Medical RFP - Addendum No. 1 - 3-2-26pdf (1).pdf PDF
20-26-010RFP - RE-ISSUED MANOR ISD - 2026 MEDICAL RFP - advertisement.pdf PDF
6-W9.pdf PDF
25-Manor ISD Large Claim Reporting - 9.2025-3.2026.xlsx XLSX spreadsheet
22-Manor ISD - Top 20 HCC 50K - 1.2025-12.2025 (1).pdf PDF
19-PAST PERFORMANCE QUESTIONNAIRE.pdf PDF
1-ACKNOWLEDGEMENT OF ADDENDA.pdf PDF
15-Manor ISD Large Claim Reporting 9.2023-12.2025.xlsx XLSX spreadsheet
5-FORM B – PRICING AND SERVICE AFFIRMATION.pdf PDF
7-Vendor Certification Form.pdf PDF
16-Manor ISD Medical Enrollment by Month 9.2023-12.2025.xlsx XLSX spreadsheet
21-Manor ISD - Medical Census 02012026v2 (1).xlsx XLSX spreadsheet
17-Manor ISD PvC 9.2023-12.2025.xlsx XLSX spreadsheet
14-Manor ISD Inpatient Provider 2025.xlsx XLSX spreadsheet
2-CIQ (CONFLICT OF INTEREST QUESTIONAIRE).pdf PDF
23-Manor ISD - NDC Claim Summary 2024-2025 (1).xlsx XLSX spreadsheet
28-26-010RFP - RE-ISSUED Manor ISD - 2026 Medical RFP.docx DOCX document
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 MonthBenefit PackageMedical and Pharmacy PremiumMedical Paid ClaimsPharmacy Paid ClaimsTotal Paid Claims
Sep 2025BLUE ESS HMO 2$1,278.35$59,422.08$87,729.20$147,342.29
Sep 2025BLUE ESS HMO 3000$328,442.82$83,136.05$117,273.64$201,755.66
Sep 2025BLUECH HDHP PPO 3400$212,725.15$178,433.77$47,923.87$226,987.29
Sep 2025BLUECH PPO 1400$148,443.99$308,591.89$41,727.62$350,721.36
Oct 2025BLUE ESS HMO 2$0.00$24,613.90$1,175.18$25,791.35
Oct 2025BLUE ESS HMO 3000$324,238.58$177,094.95$144,174.86$322,515.95
Oct 2025BLUECH HDHP PPO 3400$203,332.05$192,897.78$98,447.24$291,822.56
Oct 2025BLUECH PPO 1400$145,723.35$278,081.20$86,251.16$364,790.20
Nov 2025BLUE ESS HMO 2$0.00$16,991.28$3,716.15$20,707.43
Nov 2025BLUE ESS HMO 3000$324,123.44$153,001.02$168,814.39$322,160.60
Nov 2025BLUECH HDHP PPO 3400$199,336.99$44,725.62$78,985.89$124,195.09
Nov 2025BLUECH PPO 1400$146,154.01$467,454.77$56,494.09$524,398.37
Dec 2025BLUE ESS HMO 2$0.00-$26,907.29$121.73-$26,756.36
Dec 2025BLUE ESS HMO 3000$322,897.92$431,674.76$123,040.38$555,044.27
Dec 2025BLUECH HDHP PPO 3400$197,060.09$55,421.75$102,439.86$158,344.69
Dec 2025BLUECH PPO 1400$144,793.69$225,022.36$57,112.44$282,590.87
Jan 2026BLUE ESS HMO 2$0.00-$72.40-$67.75
Jan 2026BLUE ESS HMO 3000$322,604.82$204,142.17$67,546.89$273,092.30
Jan 2026BLUECH HDHP PPO 3400$197,532.72$51,975.60$64,840.47$117,379.24
Jan 2026BLUECH PPO 1400$140,272.23$83,039.26$50,011.13$133,573.75
Feb 2026BLUE ESS HMO 2$197.27$197.27
Feb 2026BLUE ESS HMO 3000$324,469.66$182,483.62$80,318.12$264,215.22
Feb 2026BLUECH HDHP PPO 3400$192,993.69-$6,486.49$61,048.81$55,126.03
Feb 2026BLUECH PPO 1400$144,602.69$85,465.89$33,196.20$119,197.17
Mar 2026BLUE ESS HMO 2-$550.24-$550.24
Mar 2026BLUE ESS HMO 3000$326,046.25$164,703.27$63,100.58$229,280.32
Mar 2026BLUECH HDHP PPO 3400$192,485.39$58,520.00$118,945.43$178,026.30
Mar 2026BLUECH 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 MonthBenefit PackagePlan Coverage TierMedical Member MonthsMedical Subscriber Months
Sep 2025BLUE ESS HMO 2SUBSCRIBER AND CHILD21
Sep 2025BLUE ESS HMO 3000SUBSCRIBER ONLY463463
Sep 2025BLUE ESS HMO 3000SUBSCRIBER AND SPOUSE126
Sep 2025BLUE ESS HMO 3000SUBSCRIBER AND CHILD5427
Sep 2025BLUE ESS HMO 3000SUBSCRIBER AND CHILDREN13034
Sep 2025BLUE ESS HMO 3000SUBSCRIBER AND FAMILY348
Sep 2025BLUECH HDHP PPO 3400SUBSCRIBER ONLY316316
Sep 2025BLUECH HDHP PPO 3400SUBSCRIBER AND SPOUSE42
Sep 2025BLUECH HDHP PPO 3400SUBSCRIBER AND CHILD3819
Sep 2025BLUECH HDHP PPO 3400SUBSCRIBER AND CHILDREN6721
Sep 2025BLUECH HDHP PPO 3400SUBSCRIBER AND FAMILY256
Sep 2025BLUECH PPO 1400SUBSCRIBER ONLY132132
Sep 2025BLUECH PPO 1400SUBSCRIBER AND SPOUSE42
Sep 2025BLUECH PPO 1400SUBSCRIBER AND CHILD4020
Sep 2025BLUECH PPO 1400SUBSCRIBER AND CHILDREN5415
Sep 2025BLUECH PPO 1400SUBSCRIBER AND FAMILY337
Oct 2025BLUE ESS HMO 3000SUBSCRIBER ONLY457457
Oct 2025BLUE ESS HMO 3000SUBSCRIBER AND SPOUSE126
Oct 2025BLUE ESS HMO 3000SUBSCRIBER AND CHILD4824
Oct 2025BLUE ESS HMO 3000SUBSCRIBER AND CHILDREN13836
Oct 2025BLUE ESS HMO 3000SUBSCRIBER AND FAMILY358
Oct 2025BLUECH HDHP PPO 3400SUBSCRIBER ONLY303303
Oct 2025BLUECH HDHP PPO 3400SUBSCRIBER AND SPOUSE42
Oct 2025BLUECH HDHP PPO 3400SUBSCRIBER AND CHILD3618
Oct 2025BLUECH HDHP PPO 3400SUBSCRIBER AND CHILDREN6420
Oct 2025BLUECH HDHP PPO 3400SUBSCRIBER AND FAMILY215
Oct 2025BLUECH PPO 1400SUBSCRIBER ONLY128128
Oct 2025BLUECH PPO 1400SUBSCRIBER AND SPOUSE42
Oct 2025BLUECH PPO 1400SUBSCRIBER AND CHILD4020
Oct 2025BLUECH PPO 1400SUBSCRIBER AND CHILDREN5415
Oct 2025BLUECH PPO 1400SUBSCRIBER AND FAMILY337
Nov 2025BLUE ESS HMO 3000SUBSCRIBER ONLY461461
Nov 2025BLUE ESS HMO 3000SUBSCRIBER AND SPOUSE126
Nov 2025BLUE ESS HMO 3000SUBSCRIBER AND CHILD5025
Nov 2025BLUE ESS HMO 3000SUBSCRIBER AND CHILDREN13535
Nov 2025BLUE ESS HMO 3000SUBSCRIBER AND FAMILY358
Nov 2025BLUECH HDHP PPO 3400SUBSCRIBER ONLY299299
Nov 2025BLUECH HDHP PPO 3400SUBSCRIBER AND SPOUSE42
Nov 2025BLUECH HDHP PPO 3400SUBSCRIBER AND CHILD3417
Nov 2025BLUECH HDHP PPO 3400SUBSCRIBER AND CHILDREN6119
Nov 2025BLUECH HDHP PPO 3400SUBSCRIBER AND FAMILY215
Nov 2025BLUECH PPO 1400SUBSCRIBER ONLY131131
Nov 2025BLUECH PPO 1400SUBSCRIBER AND SPOUSE42
Nov 2025BLUECH PPO 1400SUBSCRIBER AND CHILD3819
Nov 2025BLUECH PPO 1400SUBSCRIBER AND CHILDREN5716
Nov 2025BLUECH PPO 1400SUBSCRIBER AND FAMILY307
Dec 2025BLUE ESS HMO 3000SUBSCRIBER ONLY463463
Dec 2025BLUE ESS HMO 3000SUBSCRIBER AND SPOUSE126
Dec 2025BLUE ESS HMO 3000SUBSCRIBER AND CHILD4623
Dec 2025BLUE ESS HMO 3000SUBSCRIBER AND CHILDREN13736
Dec 2025BLUE ESS HMO 3000SUBSCRIBER AND FAMILY317
Dec 2025BLUECH HDHP PPO 3400SUBSCRIBER ONLY299299
Dec 2025BLUECH HDHP PPO 3400SUBSCRIBER AND SPOUSE42
Dec 2025BLUECH HDHP PPO 3400SUBSCRIBER AND CHILD3417
Dec 2025BLUECH HDHP PPO 3400SUBSCRIBER AND CHILDREN6119
Dec 2025BLUECH HDHP PPO 3400SUBSCRIBER AND FAMILY174
Dec 2025BLUECH PPO 1400SUBSCRIBER ONLY130130
Dec 2025BLUECH PPO 1400SUBSCRIBER AND SPOUSE42
Dec 2025BLUECH PPO 1400SUBSCRIBER AND CHILD3618
Dec 2025BLUECH PPO 1400SUBSCRIBER AND CHILDREN5716
Dec 2025BLUECH PPO 1400SUBSCRIBER AND FAMILY297
Jan 2026BLUE ESS HMO 3000SUBSCRIBER ONLY462462
Jan 2026BLUE ESS HMO 3000SUBSCRIBER AND SPOUSE126
Jan 2026BLUE ESS HMO 3000SUBSCRIBER AND CHILD5025
Jan 2026BLUE ESS HMO 3000SUBSCRIBER AND CHILDREN13736
Jan 2026BLUE ESS HMO 3000SUBSCRIBER AND FAMILY286
Jan 2026BLUECH HDHP PPO 3400SUBSCRIBER ONLY299299
Jan 2026BLUECH HDHP PPO 3400SUBSCRIBER AND SPOUSE42
Jan 2026BLUECH HDHP PPO 3400SUBSCRIBER AND CHILD3417
Jan 2026BLUECH HDHP PPO 3400SUBSCRIBER AND CHILDREN6119
Jan 2026BLUECH HDHP PPO 3400SUBSCRIBER AND FAMILY174
Jan 2026BLUECH PPO 1400SUBSCRIBER ONLY128128
Jan 2026BLUECH PPO 1400SUBSCRIBER AND SPOUSE42
Jan 2026BLUECH PPO 1400SUBSCRIBER AND CHILD3417
Jan 2026BLUECH PPO 1400SUBSCRIBER AND CHILDREN5716
Jan 2026BLUECH PPO 1400SUBSCRIBER AND FAMILY266
Feb 2026BLUE ESS HMO 3000SUBSCRIBER ONLY458458
Feb 2026BLUE ESS HMO 3000SUBSCRIBER AND SPOUSE126
Feb 2026BLUE ESS HMO 3000SUBSCRIBER AND CHILD5427
Feb 2026BLUE ESS HMO 3000SUBSCRIBER AND CHILDREN14338
Feb 2026BLUE ESS HMO 3000SUBSCRIBER AND FAMILY286
Feb 2026BLUECH HDHP PPO 3400SUBSCRIBER ONLY292292
Feb 2026BLUECH HDHP PPO 3400SUBSCRIBER AND SPOUSE42
Feb 2026BLUECH HDHP PPO 3400SUBSCRIBER AND CHILD3417
Feb 2026BLUECH HDHP PPO 3400SUBSCRIBER AND CHILDREN5818
Feb 2026BLUECH HDHP PPO 3400SUBSCRIBER AND FAMILY174
Feb 2026BLUECH PPO 1400SUBSCRIBER ONLY131131
Feb 2026BLUECH PPO 1400SUBSCRIBER AND SPOUSE42
Feb 2026BLUECH PPO 1400SUBSCRIBER AND CHILD3618
Feb 2026BLUECH PPO 1400SUBSCRIBER AND CHILDREN6117
Feb 2026BLUECH PPO 1400SUBSCRIBER AND FAMILY266
Mar 2026BLUE ESS HMO 3000SUBSCRIBER ONLY461461
Mar 2026BLUE ESS HMO 3000SUBSCRIBER AND SPOUSE126
Mar 2026BLUE ESS HMO 3000SUBSCRIBER AND CHILD5427
Mar 2026BLUE ESS HMO 3000SUBSCRIBER AND CHILDREN14338
Mar 2026BLUE ESS HMO 3000SUBSCRIBER AND FAMILY286
Mar 2026BLUECH HDHP PPO 3400SUBSCRIBER ONLY291291
Mar 2026BLUECH HDHP PPO 3400SUBSCRIBER AND SPOUSE42
Mar 2026BLUECH HDHP PPO 3400SUBSCRIBER AND CHILD3417
Mar 2026BLUECH HDHP PPO 3400SUBSCRIBER AND CHILDREN5818
Mar 2026BLUECH HDHP PPO 3400SUBSCRIBER AND FAMILY174
Mar 2026BLUECH PPO 1400SUBSCRIBER ONLY134134
Mar 2026BLUECH PPO 1400SUBSCRIBER AND SPOUSE42
Mar 2026BLUECH PPO 1400SUBSCRIBER AND CHILD3618
Mar 2026BLUECH PPO 1400SUBSCRIBER AND CHILDREN6117
Mar 2026BLUECH PPO 1400SUBSCRIBER AND FAMILY266
Total: Selected Filter(s)9,5917,365

&G &G

Page &P of &N image1.jpeg

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