2-SCBOCC Experience Report Florida Blue Medical 202403.xlsx

XLSX spreadsheet 138 KB Posted

Attached to
Group Medical Benefits
Solicitation number
2026-10
Issued by
Seminole County, Florida

About this file

This is a Florida Blue Medical Experience Report for Suwannee County Board of County Commissioners (BOCC) covering the 12-month period from April 2023 through March 2024, detailing comprehensive health plan utilization and claims data for the county's employee and retiree group medical benefits program. The report presents monthly monitoring data across 13 months of service delivery, with enrollment fluctuating between 404 and 413 contracts covering 447 to 464 total members. The plan experienced a Medical Loss Ratio (MLR) averaging 75.33% across the measurement period, with significant monthly variations ranging from 47.24% in June 2023 to 118.51% in March 2024, indicating periods of both favorable and unfavorable claims experience relative to premium revenue.

The report demonstrates total medical and pharmacy claims of $2,881,732.03 across the 12-month period, with medical facility costs (inpatient and outpatient) totaling $1,371,867.32 and pharmacy expenses representing $855,074.83 of total claims. Professional services claims reached $625,940.22, reflecting an 18-month comparison with the prior year period that shows a 1.20% increase in grand total payments despite a 17.38% decrease in professional services costs and a 10.49% reduction in inpatient facility expenses. Key high-cost claims analysis identifies sepsis, femur fractures, malignant neoplasms, cardiac conditions, and chronic obstructive pulmonary disease as primary drivers of medical expenses. The plan maintained substantial brand-to-generic pharmaceutical ratio management with an 85.78% generic utilization rate, while per-member-per-month costs averaged $527.69 in total plan payments with pharmacy costs representing $156.57 of that amount.

View the file

Other files

File Type Posted
24-0.3 Guarantee Ltr of Commit Guarantee From.pdf PDF
29-1.1 Summary Form.pdf PDF
22-0.1 Information Instructions.pdf PDF
9-SCBOCC Monitoring Report FB DEC 2025 (1).xlsx XLSX spreadsheet
30-0.2 Scope of Work.pdf PDF
4-SCBOCC Claims MARCH 2026.xlsx XLSX spreadsheet
20-Participants.xlsx XLSX spreadsheet
16-Suwannee Cert P03160 10-1-25.pdf PDF
17-SCBOCC SBC PLAN 03559 Florida Blue Medical 20251001.pdf PDF
21-0.0 Advertisement.jpg JPG image
6-SCBOCC Experience Report Monitoring and HCC Florida Blue Medical 202312.xlsx XLSX spreadsheet
10-SCBOCC SBC PLAN 60 Florida Blue Medical 20251001.pdf PDF
14-Suwannee Cert P60 10-1-25.pdf PDF
12-SCBOCC Experience Report HCC Florida Blue Medical 202312.xlsx XLSX spreadsheet
13-SCBOCC SBC PLAN 03160 Florida Blue Medical 20251001.pdf PDF
1-Suwannee County Medical Census 3.19.2026.xlsx XLSX spreadsheet
25-1.4 Scope of Services Table.pdf PDF
28-1.3 Questionnaire.pdf PDF
18-SCBOCC SBC PLAN 03161 Florida Blue Medical 20251001.pdf PDF
19-Suwannee Renewal Negotiated Florida Blue Medical Final 20251001 (1).pdf PDF
23-0.4 Standard Contract Terms.pdf PDF
5-SCBOCC ExpRpt FMR BCBSFL Medical 2025.12 (1).pdf PDF
7-SCBOCC Experience Report Florida Blue Medical 202409.xlsx XLSX spreadsheet
3-Suwannee Cert P03559 10-1-25.pdf PDF
11-SCBOCC Monitoring Report Report July 2025.xlsx XLSX spreadsheet
26-1.5 Financial Response Forms.pdf PDF
15-Suwannee Cert P03161 10-1-25.pdf PDF
8-SCBOCC Experience Report Monitoring and HCC Florida Blue Medical 202309.xlsx XLSX spreadsheet
27-1.2 Required Forms.pdf PDF
Show all 29

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

S1 Monitoring by Utiliza Page1

Monitoring by Utilization and Enrollment - PAID
Company: SUWANNEE COUNTY BOCC TAX

Group: 15534 Current Paid Period: From 04/2023 to 03/2024

EnrollmentPremiumCapitationFee for Service Claims
Paid Year MonthContractsMembersPremiumPCPSpecialtyTotal CapitationValue Based
ProgramsInpatientOutpatientPhysicianOtherTotal MedicalPharmacyGrand TotalMLR
202304404447$301,164.35$0.00$1,573.75$1,573.75$781.47$8,300.47$182,444.01$32,615.82$21,360.72$244,721.02$41,474.48$288,550.7295.81%
202305406448$313,832.90$0.00$1,626.48$1,626.48$789.48$41,750.60$101,206.29$37,914.96$21,432.91$202,304.76$77,930.94$282,651.6690.06%
202306408449$307,694.62$0.00$1,670.06$1,670.06$849.60$0.00$39,089.98$24,749.18$14,252.09$78,091.25$64,729.82$145,340.7347.24%
202307407449$308,686.05$0.00$1,623.21$1,623.21$844.80$97,249.09$1,136.26$19,599.80$17,069.97$135,055.12$62,234.44$199,757.5764.71%
202308412454$304,641.55$0.00$1,639.93$1,639.93$864.00$39,457.73$33,917.48$21,104.08$16,082.23$110,561.52$109,823.60$222,889.0573.16%
202309410452$310,634.03$0.00$1,621.01$1,621.01$913.17$52,820.12$61,007.16$22,150.02$18,565.05$154,542.35$61,906.21$218,982.7470.50%
202310404447$339,143.98$0.00$1,687.82$1,687.82$888.22$0.00$54,893.07$37,314.45$48,053.49$140,261.01$72,301.87$215,138.9263.44%
202311411462$326,908.39$0.00$1,667.24$1,667.24$868.26$8,026.86$34,611.05$36,449.69$17,070.34$96,157.94$85,276.14$183,969.5856.28%
202312412463$329,710.34$0.00$1,691.68$1,691.68$0.00$112,159.92$76,656.37$33,200.41$16,508.32$238,525.02$73,362.45$313,579.1595.11%
202401413464$328,475.87$0.00$1,644.35$1,644.35$0.00$12,661.08$56,278.48$26,240.05$26,719.97$121,899.58$86,843.20$210,387.1364.05%
202402412463$326,239.79$0.00$1,718.65$1,718.65$1,025.12$48,734.32$55,885.92$33,206.21$15,569.97$153,396.42$54,955.71$211,095.9064.71%
202403412463$328,578.59$0.00$1,724.93$1,724.93$1,136.43$213,550.02$40,031.04$32,365.34$36,345.15$322,291.55$64,235.97$389,388.88118.51%
Total4,9115,461$3,825,710.46$0.00$19,889.11$19,889.11$8,960.55$634,710.21$737,157.11$356,910.01$269,030.21$1,997,807.54$855,074.83$2,881,732.0375.33%
Grouping Avg409455$318,809.21$0.00$1,657.43$1,657.43$746.71$52,892.52$61,429.76$29,742.50$22,419.18$166,483.96$71,256.24$240,144.3475.33%
Monthly Avg409455$318,809.21$0.00$1,657.43$1,657.43$746.71$52,892.52$61,429.76$29,742.50$22,419.18$166,483.96$71,256.24$240,144.3475.33%

Notes:

- Grand Total includes Medical FFS, Pharmacy FFS, Incentives and Capitation.

- Grouping Avg – Average of the distinct groupings chosen by the user.

- Monthly Avg – Average of a measure over Service/Paid time period.

- Enrollment is recast to reflect retroactive adjustments.

- FFS = Fee For Service.

- MLR = Medical Loss Ratio.

&"Arial,Regular"&8 This Florida Blue report is proprietary and confidential. Report Run: 04/16/2024 11:31 AM Page 1 of 2

S2 Monitoring by Utiliza Page2

Monitoring by Utilization and Enrollment - PAID
Paid Year MonthEmployee
OnlyEmployee &
SpouseEmployee &
ChildrenFamilySpouse OnlySpouse &
ChildrenChildren OnlyTotal
ContractsTotal

Members

20230437911122000404447
20230538211103000406448
20230638510103000408449
20230738311103000407449
20230838811103000412454
20230938611103000410452
20231038011103000404447
20231138611104000411462
20231238711104000412463
20240138811104000413464
20240238711104000412463
20240338711104000412463
Total4,618131122400004,9115,461
Grouping Avg38511103000409455
Monthly Avg38511103000409455
Notes:

- Enrollment is recast to reflect retroactive adjustments.

- Grouping Avg – Average of the distinct groupings chosen by the user.

- Monthly Avg – Average of a measure over Service/Paid time period.

&"Arial,Regular"&8 This Florida Blue report is proprietary and confidential. Report Run: 04/16/2024 11:31 AM Page 2 of 2

S3 High Cost Claims Summ Page1

High Cost Claims Summary - Rolling 12
Company: SUWANNEE COUNTY BOCC TAX

Group: 15534 Current Paid Period: From 04/2023 to 03/2024 Prior Paid Period: From 04/2022 to 03/2023 High Cost Claims Threshold: 50000

CURRENTInpatientOutpatientProfessionalPharmacyOther
RankDivRelationshipDiagnosis DescriptionDaysAdmitsPaid AmtVisitsPaid AmtServicesPaid Amt# of RxPaid AmtClaim CountPaid AmtTotal Paid AmtTotal Billed Amt
1012SUBSCRIBERCHRONIC OBSTRUCTIVE PULMONARY DISEASE, UNSPECIFIED; HYPERTENSIVE HEART AND CHRONIC KIDNEY DISEASE WITH HEART FAILURE AND STAGE 1 THROUGH STAGE 4 CHRONIC KIDNEY DISEASE, OR UNSPECIFIED CHRONIC KIDNEY DIS; CARDIAC ARREST, CAUSE UNSPECIFIED313$110,585.700$0.00141$31,010.3113$105.700$0.00$141,701.71$674,183.44
2011SUBSCRIBERUNSPECIFIED FRACTURE OF SHAFT OF RIGHT FEMUR, INITIAL ENCOUNTER FOR CLOSED FRACTURE; UNSPECIFIED FRACTURE OF SHAFT OF RIGHT FEMUR, SUBSEQUENT ENCOUNTER FOR CLOSED FRACTURE WITH ROUTINE HEALING; DISPLACED TRANSVERSE FRACTURE OF SHAFT OF RIGHT FEMUR, SUBSEQUENT ENCOUNTER FOR CLOSED FRACTURE WITH ROUTINE HEALING232$105,897.079$2,535.41108$7,782.2617$308.320$0.00$116,523.06$645,273.53
3012SUBSCRIBERMALIGNANT NEOPLASM OF UPPER LOBE, RIGHT BRONCHUS OR LUNG; OTHER PERSISTENT ATRIAL FIBRILLATION; MALIGNANT NEOPLASM OF UNSPECIFIED PART OF UNSPECIFIED BRONCHUS OR LUNG73$76,299.003$14,738.7853$19,034.2817$875.340$0.00$110,947.40$513,455.20
4012SUBSCRIBERPHARMACY RX; ENCOUNTER FOR SCREENING FOR MALIGNANT NEOPLASM OF COLON; OTHER DISEASES OF STOMACH AND DUODENUM00$0.002$1,165.1826$3,090.3850$95,863.700$0.00$100,119.26$142,755.23
5011SUBSCRIBEROTHER SPECIFIED NONINFLAMMATORY DISORDERS OF VAGINA; PHARMACY RX; LOW BACK PAIN, UNSPECIFIED11$32,177.0013$15,183.3889$18,189.1579$28,345.860$0.00$93,895.39$485,951.74
6R08SUBSCRIBERUNILATERAL PRIMARY OSTEOARTHRITIS, LEFT KNEE; POLYP OF COLON; UNSPECIFIED CHRONIC GASTRITIS WITHOUT BLEEDING00$0.009$53,520.5192$11,654.9924$231.660$0.00$65,407.16$169,651.76
7019SUBSCRIBERPHARMACY RX; PILONIDAL CYST WITH ABSCESS; CELLULITIS OF BACK [ANY PART EXCEPT BUTTOCK]00$0.002$2,249.1110$807.598$57,359.190$0.00$60,415.89$149,416.68
8011SUBSCRIBEROTHER SPONDYLOSIS WITH RADICULOPATHY, LUMBAR REGION; PHARMACY RX; HYPERTENSIVE EMERGENCY52$16,883.824$19,095.2682$12,620.4029$11,156.630$0.00$59,756.11$736,639.04
9011SUBSCRIBERATHEROSCLEROTIC HEART DISEASE OF NATIVE CORONARY ARTERY WITH UNSTABLE ANGINA PECTORIS; COMBINED FORMS OF AGE-RELATED CATARACT, RIGHT EYE; AGE-RELATED NUCLEAR CATARACT, LEFT EYE00$0.003$53,950.2528$1,917.2628$6.840$0.00$55,874.35$1,110,786.92
10004SUBSCRIBERPHARMACY RX; EFFUSION, LEFT KNEE; TYPE 2 DIABETES MELLITUS WITH HYPERGLYCEMIA00$0.001$1,430.0014$1,056.3233$53,309.270$0.00$55,795.59$119,311.14
Total6711$341,842.5946$163,867.88643$107,162.94298$247,562.510$0.00$860,435.92$4,747,424.68
PRIORInpatientOutpatientProfessionalPharmacyOther
RankDivRelationshipDiagnosis DescriptionDaysAdmitsPaid AmtVisitsPaid AmtServicesPaid Amt# of RxPaid AmtClaim CountPaid AmtTotal Paid AmtTotal Billed Amt
1008SUBSCRIBERSEPSIS, UNSPECIFIED ORGANISM; ALCOHOL INDUCED ACUTE PANCREATITIS WITHOUT NECROSIS OR INFECTION; OTHER MALAISE592$282,436.9013$8,061.52233$32,997.6541$397.390$0.00$323,893.46$1,405,019.56
2012SUBSCRIBERSEPSIS, UNSPECIFIED ORGANISM; ACUTE KIDNEY FAILURE, UNSPECIFIED; MALIGNANT NEOPLASM OF UPPER-INNER QUADRANT OF LEFT FEMALE BREAST124$87,919.804$11,543.61199$28,170.3215$303.710$0.00$127,937.44$520,373.85
3023SUBSCRIBERMALIGNANT MELANOMA OF RIGHT UPPER LIMB, INCLUDING SHOULDER; NEOPLASM OF UNCERTAIN BEHAVIOR OF SKIN; MALIGNANT MELANOMA OF LEFT LOWER EYELID, INCLUDING CANTHUS00$0.002$1,854.5341$107,629.126$87.580$0.00$109,571.23$263,533.80
4011SUBSCRIBERPAROXYSMAL ATRIAL FIBRILLATION; OTHER SPONDYLOSIS WITH RADICULOPATHY, LUMBAR REGION; PHARMACY RX61$63,785.293$12,811.7458$12,000.7240$7,321.070$0.00$95,918.82$394,165.79
5012SUBSCRIBERPHARMACY RX; TYPE 2 DIABETES MELLITUS WITHOUT COMPLICATIONS; OTITIS MEDIA, UNSPECIFIED, LEFT EAR00$0.000$0.0017$1,415.4551$93,203.430$0.00$94,618.88$135,673.86
6010SUBSCRIBERENCOUNTER FOR ANTINEOPLASTIC RADIATION THERAPY; ENCOUNTER FOR ANTINEOPLASTIC CHEMOTHERAPY; MALIGNANT NEOPLASM OF OROPHARYNX, UNSPECIFIED00$0.0041$71,710.4754$9,068.3830$347.830$0.00$81,126.68$230,268.85
7011SUBSCRIBERDYSPHAGIA, UNSPECIFIED; CEREBRAL INFARCTION, UNSPECIFIED; CEREBRAL INFARCTION DUE TO UNSPECIFIED OCCLUSION OR STENOSIS OF RIGHT CEREBELLAR ARTERY214$67,015.240$0.0067$9,584.1013$1,341.880$0.00$77,941.22$511,844.13
8011SUBSCRIBERPHARMACY RX; CALCULUS OF KIDNEY; CHEST PAIN, UNSPECIFIED00$0.0017$27,344.46124$12,739.0589$31,809.820$0.00$71,893.33$313,626.23
9012SPOUSEPHARMACY RX; ANXIETY DISORDER DUE TO KNOWN PHYSIOLOGICAL CONDITION; ESSENTIAL (PRIMARY) HYPERTENSION00$0.000$0.0013$547.0341$67,705.320$0.00$68,252.35$89,827.22
10007SUBSCRIBERDIVERTICULITIS OF LARGE INTESTINE WITHOUT PERFORATION OR ABSCESS WITHOUT BLEEDING; DIVERTICULOSIS OF LARGE INTESTINE WITHOUT PERFORATION OR ABSCESS WITH BLEEDING; RIGHT UPPER QUADRANT PAIN21$52,756.111$279.7110$5,879.334$0.000$0.00$58,915.15$214,022.75
11R07SUBSCRIBERPHARMACY RX; ENCOUNTER FOR SCREENING FOR MALIGNANT NEOPLASM OF COLON; OBSTRUCTIVE SLEEP APNEA (ADULT) (PEDIATRIC)00$0.000$0.0020$1,450.24106$52,597.620$0.00$54,047.86$77,465.75
Total10012$553,913.3481$133,606.04836$221,481.39436$255,115.650$0.00$1,164,116.42$4,155,821.79

&"Arial,Regular"&8 This Florida Blue report is proprietary and confidential. Report Run: 04/16/2024 11:31 AM Page 1 of 1

S4 High Cost Claims Summ Page1

High Cost Claims Summary - Plan YTD
Company: SUWANNEE COUNTY BOCC TAX

Group: 15534 Current Paid Period: From 10/2023 to 03/2024 Prior Paid Period: From 10/2022 to 09/2023 High Cost Claims Threshold: 50000

CURRENTInpatientOutpatientProfessionalPharmacyOther
RankDivRelationshipDiagnosis DescriptionDaysAdmitsPaid AmtVisitsPaid AmtServicesPaid Amt# of RxPaid AmtClaim CountPaid AmtTotal Paid AmtTotal Billed Amt
1012SUBSCRIBERCHRONIC OBSTRUCTIVE PULMONARY DISEASE, UNSPECIFIED; HYPERTENSIVE HEART AND CHRONIC KIDNEY DISEASE WITH HEART FAILURE AND STAGE 1 THROUGH STAGE 4 CHRONIC KIDNEY DISEASE, OR UNSPECIFIED CHRONIC KIDNEY DIS; CARDIAC ARREST, CAUSE UNSPECIFIED313$110,585.700$0.00134$30,794.156$17.000$0.00$141,396.85$672,096.73
2011SUBSCRIBERUNSPECIFIED FRACTURE OF SHAFT OF RIGHT FEMUR, INITIAL ENCOUNTER FOR CLOSED FRACTURE; UNSPECIFIED FRACTURE OF SHAFT OF RIGHT FEMUR, SUBSEQUENT ENCOUNTER FOR CLOSED FRACTURE WITH ROUTINE HEALING; DISPLACED TRANSVERSE FRACTURE OF SHAFT OF RIGHT FEMUR, SUBSEQUENT ENCOUNTER FOR CLOSED FRACTURE WITH ROUTINE HEALING232$105,897.079$2,535.41108$7,782.2617$308.320$0.00$116,523.06$645,273.53
3012SUBSCRIBERMALIGNANT NEOPLASM OF UPPER LOBE, RIGHT BRONCHUS OR LUNG; OTHER PERSISTENT ATRIAL FIBRILLATION; MALIGNANT NEOPLASM OF UNSPECIFIED PART OF UNSPECIFIED BRONCHUS OR LUNG73$76,299.003$14,738.7853$19,034.2817$875.340$0.00$110,947.40$513,455.20
4012SUBSCRIBERPHARMACY RX; ENCOUNTER FOR SCREENING FOR MALIGNANT NEOPLASM OF COLON; OTHER DISEASES OF STOMACH AND DUODENUM00$0.001$524.2920$2,445.3933$53,607.980$0.00$56,577.66$81,206.90
Total618$292,781.7713$17,798.48315$60,056.0873$54,808.640$0.00$425,444.97$1,912,032.36
PRIORInpatientOutpatientProfessionalPharmacyOther
RankDivRelationshipDiagnosis DescriptionDaysAdmitsPaid AmtVisitsPaid AmtServicesPaid Amt# of RxPaid AmtClaim CountPaid AmtTotal Paid AmtTotal Billed Amt
1008SUBSCRIBERSEPSIS, UNSPECIFIED ORGANISM; ALCOHOL INDUCED ACUTE PANCREATITIS WITHOUT NECROSIS OR INFECTION; PNEUMONIA, UNSPECIFIED ORGANISM592$282,436.9010$3,435.5459$7,085.1919$382.370$0.00$293,340.00$109,444.01
2011SUBSCRIBEROTHER SPECIFIED NONINFLAMMATORY DISORDERS OF VAGINA; PHARMACY RX; CALCULUS OF KIDNEY11$32,177.0019$31,980.84137$23,845.0585$28,221.880$0.00$116,224.77$665,930.86
3010SUBSCRIBERENCOUNTER FOR ANTINEOPLASTIC RADIATION THERAPY; ENCOUNTER FOR ANTINEOPLASTIC CHEMOTHERAPY; DYSPHONIA00$0.0049$94,950.1561$12,908.6023$137.080$0.00$107,995.83$285,283.30
4R08SUBSCRIBERUNILATERAL PRIMARY OSTEOARTHRITIS, RIGHT KNEE; UNILATERAL PRIMARY OSTEOARTHRITIS, LEFT KNEE; POLYP OF COLON00$0.0013$91,071.8474$14,933.6518$36.630$0.00$106,042.12$235,714.20
5012SUBSCRIBERPHARMACY RX; TYPE 2 DIABETES MELLITUS WITHOUT COMPLICATIONS; OTHER SPECIFIED DISORDERS OF TEETH AND SUPPORTING STRUCTURES00$0.001$640.8919$1,708.3140$91,491.350$0.00$93,840.55$130,974.17
6012SUBSCRIBERSEPSIS, UNSPECIFIED ORGANISM; IRON DEFICIENCY ANEMIA, UNSPECIFIED; MALIGNANT NEOPLASM OF UPPER-INNER QUADRANT OF LEFT FEMALE BREAST63$60,746.760$0.00128$13,014.389$274.600$0.00$74,035.74$358,174.62
7011SUBSCRIBEROTHER SPONDYLOSIS WITH RADICULOPATHY, LUMBAR REGION; BENIGN PAROXYSMAL VERTIGO, UNSPECIFIED EAR; HYPERTENSIVE EMERGENCY52$16,883.824$27,805.0073$12,194.8835$8,095.880$0.00$64,979.58$236,957.83
8002SUBSCRIBERCALCULUS OF KIDNEY; ABRASION OF RIGHT INDEX FINGER, INITIAL ENCOUNTER; ENCOUNTER FOR SCREENING FOR MALIGNANT NEOPLASM OF COLON00$0.007$57,375.7627$6,154.8117$169.160$0.00$63,699.73$358,543.22
9R07SUBSCRIBERPHARMACY RX; ENCOUNTER FOR SCREENING FOR MALIGNANT NEOPLASM OF COLON; OBSTRUCTIVE SLEEP APNEA (ADULT) (PEDIATRIC)00$0.000$0.0020$1,227.08114$53,867.320$0.00$55,094.40$98,522.55
10012SPOUSEPHARMACY RX; OTHER RHEUMATOID ARTHRITIS WITH RHEUMATOID FACTOR OF MULTIPLE SITES; CONTACT WITH AND (SUSPECTED) EXPOSURE TO COVID-1900$0.000$0.009$557.4236$53,687.080$0.00$54,244.50$72,551.84
11011SUBSCRIBERATHEROSCLEROTIC HEART DISEASE OF NATIVE CORONARY ARTERY WITH UNSTABLE ANGINA PECTORIS; OCCLUSION AND STENOSIS OF BILATERAL CAROTID ARTERIES; ATHEROSCLEROTIC HEART DISEASE OF NATIVE CORONARY ARTERY WITH UNSPECIFIED ANGINA PECTORIS00$0.001$51,523.0914$1,363.8012$0.000$0.00$52,886.89$651,021.00
Total718$392,244.48104$358,783.11621$94,993.17408$236,363.350$0.00$1,082,384.11$3,203,117.60

&"Arial,Regular"&8 This Florida Blue report is proprietary and confidential. Report Run: 04/16/2024 11:31 AM Page 1 of 1

S5 Monitoring by Utiliza Page1

Monitoring by Utilization and Enrollment - By Division
Company: SUWANNEE COUNTY BOCC TAX

Group: 15534 Current Paid Period: From 04/2023 to 03/2024

EnrollmentPremiumCapitationFee for Service Claims
Paid Year MonthDiv NumContractsMembersPremiumPCPSpecialtyTotal CapitationValue Based
ProgramsInpatientOutpatientPhysicianOtherTotal MedicalPharmacyGrand TotalMLR
20230400144$3,019.20$0.00$5.88$5.88$4.59$0.00$0.00$0.00$0.00$0.00$869.69$880.1629.15%
0021111$7,670.20$0.00$74.58$74.58$27.54$0.00$30,664.89$2,169.89$866.89$33,701.67$4,390.24$38,194.03497.95%
00422$1,534.04$0.00$13.56$13.56$4.59$0.00$0.00$0.00$184.15$184.15$3,416.43$3,618.73235.90%
0051111$7,548.00$0.00$14.70$14.70$30.88$0.00$0.00$1,339.54$1,505.60$2,845.14$106.92$2,997.6439.71%
0061516$12,326.06$0.00$108.48$108.48$27.54$0.00$2,021.22$1,052.46$925.86$3,999.54$127.67$4,263.2334.59%
0073335$24,817.86$0.00$51.45$51.45$18.36$0.00$0.00$1,432.32$158.52$1,590.84$6,784.22$8,444.8734.03%
0084748$36,853.43$0.00$325.44$325.44$151.47$0.00$17,234.10$4,712.62$2,032.48$23,979.20$3,579.69$28,035.8076.07%
0101212$9,204.24$0.00$81.36$81.36$32.13$0.00$1,363.92$967.46$402.61$2,733.99$884.57$3,732.0540.55%
0116067$49,884.78$0.00$99.96$99.96$68.85$8,300.47$61,257.67$6,954.41$5,251.94$81,764.49$5,364.16$87,297.46175.00%
012103104$76,755.74$0.00$691.56$691.56$302.94$0.00$25,834.73$7,407.71$3,339.00$36,581.44$11,876.45$49,452.3964.43%
01799$5,096.34$0.00$4.23$4.23$9.18$0.00$175.11$293.83$0.00$468.94$0.03$482.389.47%
01812$1,238.62$0.00$0.94$0.94$0.00$0.00$0.00$0.00$27.17$27.17$0.00$28.112.27%
0191717$10,758.94$0.00$7.99$7.99$9.18$0.00$125.68$1,029.52$1,076.05$2,231.25$1,473.10$3,721.5234.59%
020516$5,774.70$0.00$7.52$7.52$13.77$0.00$1,952.27$530.35$344.97$2,827.59$42.09$2,890.9750.06%
0235151$28,313.00$0.00$23.97$23.97$50.49$0.00$61.56$172.89$1,695.86$1,930.31$8.53$2,013.307.11%
0241130$12,760.10$0.00$14.10$14.10$20.78$0.00$0.00$14.77$498.54$513.31$1,390.28$1,938.4715.19%
R0744$3,019.20$0.00$5.88$5.88$0.00$0.00$0.00$0.00$3.39$3.39$24.59$33.861.12%
R0855$2,301.06$0.00$33.90$33.90$9.18$0.00$41,301.66$3,440.33$2,690.12$47,432.11$14.00$47,489.192063.80%
R1111$754.80$0.00$1.47$1.47$0.00$0.00$451.20$974.27$233.12$1,658.59$0.58$1,660.64220.01%
R1222$1,534.04$0.00$6.78$6.78$0.00$0.00$0.00$0.00$124.45$124.45$1,121.24$1,252.4781.65%
R2300$0.00$0.00$0.00$0.00$0.00$0.00$0.00$123.45$0.00$123.45$0.00$123.450.00%
Total404447$301,164.35$0.00$1,573.75$1,573.75$781.47$8,300.47$182,444.01$32,615.82$21,360.72$244,721.02$41,474.48$288,550.7295.81%
Avg1921$14,341.16$0.00$74.94$74.94$37.21$395.26$8,687.81$1,553.13$1,017.18$11,653.38$1,974.98$13,740.5195.81%
20230500144$3,019.20$0.00$5.88$5.88$4.59$0.00$0.00$74.36$0.00$74.36$2,528.25$2,613.0886.55%
0021111$9,204.24$0.00$74.58$74.58$22.95$0.00$1,615.03$1,757.30$537.53$3,909.86$3,432.00$7,439.3980.83%
00422$1,534.04$0.00$13.56$13.56$4.59$0.00$0.00$0.00$0.00$0.00$3,371.35$3,389.50220.95%
0051111$7,548.00$0.00$20.54$20.54$13.77$0.00$0.00$741.87$555.84$1,297.71$4,931.76$6,263.7882.99%
0061516$12,326.06$0.00$108.48$108.48$36.72$0.00$5,289.01$4,009.44$2,691.91$11,990.36$93.21$12,228.7799.21%
0073335$25,572.66$0.00$51.45$51.45$27.54$0.00$950.69$617.54$482.09$2,050.32$12,723.52$14,852.8358.08%
0084849$36,103.68$0.00$318.66$318.66$156.06$0.00$5,247.11$8,734.32$2,812.60$16,794.03$5,822.83$23,091.5863.96%
0101212$9,204.24$0.00$81.36$81.36$32.13$0.00$3,651.16$966.11$1,306.31$5,923.58$1,580.41$7,617.4882.76%
0116168$47,620.38$0.00$92.65$92.65$73.44$32,177.00$65,263.17$8,356.22$7,828.28$113,624.67$11,489.69$125,280.45263.08%
012104105$85,959.98$0.00$745.76$745.76$312.12$9,573.60$3,682.91$8,759.37$3,545.98$25,561.86$23,996.78$50,616.5258.88%
01400$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.000.00%
01788$5,096.34$0.00$4.23$4.23$9.18$0.00$58.37$799.66$251.67$1,109.70$53.57$1,176.6823.09%
01812$1,238.62$0.00$0.94$0.94$0.00$0.00$464.37$398.05$0.00$862.42$50.29$913.6573.76%
0191717$9,626.42$0.00$7.99$7.99$9.18$0.00$0.00$0.00$711.28$711.28$3,082.34$3,810.7939.59%
020517$6,472.10$0.00$7.99$7.99$13.77$0.00$0.00$30.79$0.00$30.79$117.02$169.572.62%
0235151$33,409.34$0.00$25.85$25.85$50.49$0.00$7,686.78$1,563.53$294.61$9,544.92$107.36$9,728.6229.12%
0241027$11,521.48$0.00$11.75$11.75$13.77$0.00$0.00$443.06$1.80$444.86$1,788.19$2,258.5719.60%
R0744$3,019.20$0.00$5.88$5.88$0.00$0.00$0.00$0.00$41.37$41.37$53.35$100.603.33%
R0855$3,835.10$0.00$33.90$33.90$9.18$0.00$2,104.69$0.00$204.78$2,309.47$72.35$2,424.9063.23%
R1111$754.80$0.00$1.47$1.47$0.00$0.00$5,193.00$435.94$115.55$5,744.49$67.55$5,813.51770.21%
R1233$767.02$0.00$13.56$13.56$0.00$0.00$0.00$227.40$51.31$278.71$2,569.12$2,861.39373.05%
Total406448$313,832.90$0.00$1,626.48$1,626.48$789.48$41,750.60$101,206.29$37,914.96$21,432.91$202,304.76$77,930.94$282,651.6690.06%
Avg1921$14,944.42$0.00$77.45$77.45$37.59$1,988.12$4,819.35$1,805.47$1,020.61$9,633.56$3,711.00$13,459.6090.06%
20230600144$3,019.20$0.00$5.88$5.88$4.80$0.00$0.00$0.00$184.06$184.06$13.43$208.176.89%
0021111$8,437.22$0.00$74.58$74.58$28.80$0.00$632.04$478.37$820.87$1,931.28$3,440.42$5,475.0864.89%
00422$1,534.04$0.00$13.56$13.56$4.80$0.00$0.00$144.07$0.00$144.07$5,960.20$6,122.63399.12%
0051111$13,586.40$0.00$16.17$16.17$19.20$0.00$1,520.00$745.34$141.88$2,407.22$1,824.67$4,267.2631.41%
0061516$12,326.06$0.00$108.48$108.48$38.40$0.00$240.76$501.51$69.28$811.55$161.27$1,119.709.08%
0073335$25,572.66$0.00$51.45$51.45$33.60$0.00$6,271.21$893.49$1,318.16$8,482.86$14,328.93$22,896.8489.54%
0084849$36,870.70$0.00$325.44$325.44$148.80$0.00$4,934.21$4,162.24$706.48$9,802.93$4,579.94$14,857.1140.30%
0101212$9,204.24$0.00$81.36$81.36$33.60$0.00$229.00$475.43$634.53$1,338.96$1,178.24$2,632.1628.60%
0116168$44,601.18$0.00$98.49$98.49$76.80$0.00$5,112.31$4,065.28$1,532.74$10,710.33$10,792.99$21,678.6148.61%
012105106$79,823.82$0.00$711.90$711.90$355.20$0.00$5,095.07$8,164.55$5,955.12$19,214.74$16,903.44$37,185.2846.58%
01400$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$19.84$19.84$0.00$19.840.00%
01788$4,530.08$0.00$3.29$3.29$4.80$0.00$3,576.22$418.26$395.78$4,390.26$950.39$5,348.74118.07%
01812$1,238.62$0.00$0.94$0.94$0.00$0.00$696.55$969.88$479.06$2,145.49$4.39$2,150.82173.65%
0191717$9,626.42$0.00$37.45$37.45$4.80$0.00$289.37$6.62$427.35$723.34$1,482.28$2,247.8723.35%
020517$6,472.10$0.00$7.99$7.99$19.20$0.00$0.00$0.00$517.98$517.98$7.92$553.098.55%
0235252$28,879.26$0.00$52.96$52.96$52.80$0.00$9,186.08$1,328.08$782.61$11,296.77$694.00$12,096.5341.89%
024925$10,729.18$0.00$11.75$11.75$14.40$0.00$0.00$267.33$33.92$301.25$296.25$623.655.81%
C2311$566.26$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$5.37$5.370.95%
R0744$3,019.20$0.00$5.88$5.88$0.00$0.00$0.00$124.75$3.39$128.14$93.21$227.237.53%
R0855$3,835.10$0.00$33.90$33.90$4.80$0.00$1,307.16$47.61$229.04$1,583.81$25.99$1,648.5042.98%
R1111$754.80$0.00$1.47$1.47$0.00$0.00$0.00$1,743.03$0.00$1,743.03$58.88$1,803.38238.92%
R1233$3,068.08$0.00$27.12$27.12$4.80$0.00$0.00$213.34$0.00$213.34$1,927.61$2,172.8770.82%
Total408449$307,694.62$0.00$1,670.06$1,670.06$849.60$0.00$39,089.98$24,749.18$14,252.09$78,091.25$64,729.82$145,340.7347.24%
Avg1920$13,986.12$0.00$75.91$75.91$38.62$0.00$1,776.82$1,124.96$647.82$3,549.60$2,942.26$6,606.4047.24%
20230700144$3,019.20$0.00$5.88$5.88$4.80$0.00$0.00$0.00$381.80$381.80$58.14$450.6214.93%
0021111$8,437.22$0.00$74.58$74.58$28.80$0.00$0.00$126.13$374.06$500.19$4,365.19$4,968.7658.89%
00422$1,534.04$0.00$13.56$13.56$4.80$0.00$0.00$0.00$77.57$77.57$3,377.78$3,473.71226.44%
0051213$8,302.80$0.00$16.17$16.17$19.20$0.00$0.00$132.43$340.87$473.30$581.63$1,090.3013.13%
0061617$12,326.06$0.00$108.48$108.48$33.60$0.00$117.84$680.38$437.24$1,235.46$17.05$1,394.5911.31%
0073335$25,572.66$0.00$51.45$51.45$38.40$0.00$10,458.68$1,844.24$1,973.35$14,276.27$9,934.77$24,300.8995.03%
0084950$36,870.70$0.00$332.22$332.22$153.60$0.00$6,364.77$1,615.19$4,181.20$12,161.16$10,205.08$22,852.0661.98%
0101212$9,204.24$0.00$81.36$81.36$33.60$0.00$9,665.52$2,159.51$494.98$12,320.01$1,074.16$13,509.13146.77%
0116067$49,129.98$0.00$101.43$101.43$72.00$8,583.35($39,504.84)$3,772.88$2,498.20($24,650.41)$6,840.67($17,636.31)-35.90%
012102103$83,658.92$0.00$718.68$718.68$355.20$27,244.67$12,129.18$4,867.79$1,444.20$45,685.84$13,697.76$60,457.4872.27%
01788$3,963.82$0.00$3.76$3.76$4.80$0.00$0.00$348.84$1,160.39$1,509.23$944.13$2,461.9262.11%
01812$1,238.62$0.00$0.94$0.94$0.00$0.00$0.00$58.18$777.13$835.31$199.67$1,035.9283.64%
0191616$9,060.16$0.00$7.52$7.52$4.80$0.00$0.01$480.18$833.28$1,313.47$2,282.17$3,607.9639.82%
020517$6,494.60$0.00$7.99$7.99$19.20$6,980.88$1,395.49$1,832.62$728.37$10,937.36$201.59$11,166.14171.93%
0235353$28,879.26$0.00$24.91$24.91$52.80$19,724.84$509.61$932.86$812.91$21,980.22$300.59$22,358.5277.42%
024925$10,506.02$0.00$11.75$11.75$9.60$0.00$0.00$8.09$199.81$207.90$732.53$961.789.15%
C2311$577.59$0.00$0.94$0.94$0.00$0.00$0.00$0.00$0.00$0.00$5,517.66$5,518.60955.45%
R0744$3,019.20$0.00$5.88$5.88$0.00$34,715.35$0.00$508.77$264.25$35,488.37$249.75$35,744.001183.89%
R0855$3,835.10$0.00$33.90$33.90$4.80$0.00$0.00$147.23$52.14$199.37$13.46$251.536.56%
R1111$754.80$0.00$1.47$1.47$0.00$0.00$0.00$0.00$0.00$0.00$540.98$542.4571.87%
R1233$2,301.06$0.00$20.34$20.34$4.80$0.00$0.00$84.48$38.22$122.70$1,099.68$1,247.5254.22%
Total407449$308,686.05$0.00$1,623.21$1,623.21$844.80$97,249.09$1,136.26$19,599.80$17,069.97$135,055.12$62,234.44$199,757.5764.71%
Avg1921$14,699.34$0.00$77.30$77.30$40.23$4,630.91$54.11$933.32$812.86$6,431.20$2,963.54$9,512.2764.71%
20230800155$3,019.20$0.00$7.35$7.35$4.80$0.00$0.00$300.76$366.39$667.15$2,559.42$3,238.72107.27%
0021111$8,437.22$0.00$74.58$74.58$28.80$0.00$0.00$900.17$252.01$1,152.18$3,728.18$4,983.7459.07%
00433$1,534.04$0.00$13.56$13.56$4.80$0.00$0.00$0.00$0.00$0.00$5,912.72$5,931.08386.63%
0051213$8,302.80$0.00$22.05$22.05$24.00$0.00$0.00$795.04$638.76$1,433.80$3,765.70$5,245.5563.18%
0061617$12,326.06$0.00$122.04$122.04$33.60$0.00$1,630.00$971.68$1,115.77$3,717.45$478.77$4,351.8635.31%
0073436$25,572.66$0.00$51.45$51.45$38.40$0.00$2,703.61$2,945.04$1,034.61$6,683.26$15,940.74$22,713.8588.82%
0084849$36,870.70$0.00$325.44$325.44$148.80$26,288.23$5,395.86$3,299.15$2,514.05$37,497.29$10,568.44$48,539.97131.65%
0101212$9,204.24$0.00$81.36$81.36$33.60$0.00$1,021.00$1,582.53($35.35)$2,568.18$901.37$3,584.5138.94%
0116168$49,990.46$0.00$94.08$94.08$76.80$22,743.10$5,528.53$3,835.98$3,438.84$35,546.45$8,034.97$43,752.3087.52%
012102103$76,500.07$0.00$698.34$698.34$360.00($9,573.60)$3,616.69$2,686.55$2,585.76($684.60)$14,045.76$14,419.5018.85%
01788$4,530.08$0.00$3.76$3.76$4.80$0.00$304.80$173.40$595.93$1,074.13$944.13$2,026.8244.74%
01812$1,238.62$0.00$0.94$0.94$0.00$0.00$0.00$293.34$0.00$293.34$573.65$867.9370.07%
0191616$9,060.16$0.00$28.08$28.08$4.80$0.00$2,249.11$237.10$1,386.78$3,872.99$33,841.40$37,747.27416.63%
020517$6,472.10$0.00$7.99$7.99$19.20$0.00$3,692.00$544.11$901.56$5,137.67$771.84$5,936.7091.73%
0235353$30,578.04$0.00$27.85$27.85$52.80$0.00$7,535.88$1,721.95$494.56$9,752.39$253.57$10,086.6132.99%
024925$10,506.02$0.00$12.22$12.22$14.40$0.00$0.00$4.02$91.00$95.02$7.73$129.371.23%
C2311$588.92$0.00$0.47$0.47$0.00$0.00$0.00$0.00$0.00$0.00$4,069.58$4,070.05691.10%
R0755$3,019.20$0.00$5.88$5.88$0.00$0.00$0.00$636.59$182.41$819.00$86.12$911.0030.17%
R0866$3,835.10$0.00$40.68$40.68$4.80$0.00$240.00$149.37$519.15$908.52$67.48$1,021.4826.64%
R1111$754.80$0.00$1.47$1.47$0.00$0.00$0.00$27.30$0.00$27.30$557.54$586.3177.68%
R1233$2,301.06$0.00$20.34$20.34$9.60$0.00$0.00$0.00$0.00$0.00$2,714.49$2,744.43119.27%
Total412454$304,641.55$0.00$1,639.93$1,639.93$864.00$39,457.73$33,917.48$21,104.08$16,082.23$110,561.52$109,823.60$222,889.0573.16%
Avg2022$14,506.74$0.00$78.09$78.09$41.14$1,878.94$1,615.12$1,004.96$765.82$5,264.83$5,229.70$10,613.7673.16%
20230900155$4,528.80$0.00$7.35$7.35$4.99$0.00$0.00$0.00$0.00$0.00$58.98$71.321.57%
0021111$8,437.22$0.00$74.58$74.58$34.93$0.00$0.00($218.45)$371.45$153.00$3,829.40$4,091.9148.50%
00433$1,534.04$0.00$13.56$13.56$4.99$0.00$0.00$0.00$384.78$384.78$3,377.78$3,781.11246.48%
0051213$12,990.12$0.00$19.11$19.11$24.95$0.00$0.00$421.52$1,041.77$1,463.29$1,599.97$3,107.3223.92%
0061617$14,627.12$0.00$115.26$115.26$34.93$0.00$16,876.94$490.75$572.81$17,940.50$106.07$18,196.76124.40%
0073335$25,572.66$0.00$47.04$47.04$39.92$0.00($708.64)$1,906.14$787.56$1,985.06$7,916.46$9,988.4839.06%
0084950$36,870.70$0.00$325.44$325.44$154.69$0.00$2,758.00$891.87$2,101.34$5,751.21$8,418.20$14,649.5439.73%
0101212$9,204.24$0.00$81.36$81.36$34.93$0.00$10,524.00$1,951.55$1,013.86$13,489.41$242.53$13,848.23150.45%
0116067$46,005.10$0.00$95.55$95.55$84.83$21,129.75$12,029.44$5,730.60$4,903.61$43,793.40$9,422.88$53,396.66116.07%
01299100$77,036.98$0.00$664.44$664.44$384.23$9,573.60$9,626.86$4,185.71$1,100.57$24,486.74$2,932.35$28,467.7636.95%
01788$4,530.08$0.00$3.76$3.76$4.99$0.00$119.12$1,284.35$1,378.03$2,781.50$2,761.65$5,551.90122.56%
01812$1,238.62$0.00$0.94$0.94$0.00$0.00$0.00$0.00$295.38$295.38$0.42$296.7423.96%
0191616$9,060.16$0.00$54.72$54.72$4.99$0.00$0.00$172.16$825.92$998.08$15,355.93$16,413.72181.16%
020517$6,458.60$0.00$7.99$7.99$9.98$0.00$273.75$292.62$262.80$829.17$1,358.07$2,205.2134.14%
0235454$30,011.78$0.00$24.91$24.91$54.89$22,116.77$5,474.69$2,906.96$2,190.37$32,688.79$1,029.49$33,798.08112.62%
024925$10,506.02$0.00$11.75$11.75$14.97$0.00$0.00$568.19$713.57$1,281.76$368.61$1,677.0915.96%
C2311$577.59$0.00$0.47$0.47$0.00$0.00$0.00$0.00$0.00$0.00$874.23$874.70151.44%
R0766$3,019.20$0.00$10.29$10.29$4.99$0.00$0.00$276.54$306.14$582.68$143.57$741.5324.56%
R0866$5,369.14$0.00$40.68$40.68$4.99$0.00$4,033.00$1,181.19$315.09$5,529.28$116.68$5,691.63106.01%
R1111$754.80$0.00$1.47$1.47$0.00$0.00$0.00$108.32$0.00$108.32$572.39$682.1890.38%
R1233$2,301.06$0.00$20.34$20.34$9.98$0.00$0.00$0.00$0.00$0.00$1,420.55$1,450.8763.05%
Total410452$310,634.03$0.00$1,621.01$1,621.01$913.17$52,820.12$61,007.16$22,150.02$18,565.05$154,542.35$61,906.21$218,982.7470.50%
Avg2022$14,792.10$0.00$77.19$77.19$43.48$2,515.24$2,905.10$1,054.76$884.05$7,359.16$2,947.91$10,427.7570.50%
20231000155$3,962.70$0.00$7.35$7.35$4.99$0.00$0.00$163.69$56.18$219.87$32.98$265.196.69%
0021111$8,859.18$0.00$74.58$74.58$34.93$0.00$249.00$232.10$461.49$942.59$3,495.79$4,547.8951.34%
00433$1,610.76$0.00$13.56$13.56$4.99$0.00$0.00$100.69$156.09$256.78$3,408.00$3,683.33228.67%
0051212$9,510.48$0.00$19.11$19.11$24.95$0.00$1,749.52$1,868.83$373.06$3,991.41$100.78$4,136.2543.49%
0061617$13,747.88$0.00$115.26$115.26$34.93$0.00$820.00$3,752.87$1,272.91$5,845.78$259.36$6,255.3345.50%
0073335$27,606.10$0.00$57.33$57.33$39.92$0.00$1,634.48$2,726.44$1,674.39$6,035.31$9,794.52$15,927.0857.69%
0084751$44,830.92$0.00$379.68$379.68$154.69$0.00$3,916.32$4,716.02$8,593.89$17,226.23$9,562.95$27,323.5560.95%
0101111$9,664.56$0.00$81.36$81.36$34.93$0.00$2,041.00$930.48$554.15$3,525.63$244.97$3,886.8940.22%
0116471$54,718.90$0.00$104.37$104.37$79.84$0.00$19,941.29$6,913.28$24,870.01$51,724.58$9,595.13$61,503.92112.40%
0129394$81,284.72$0.00$671.22$671.22$364.27$0.00$5,641.81$4,927.18$2,482.25$13,051.24$10,992.28$25,079.0130.85%
01788$4,756.64$0.00$3.76$3.76$4.99$0.00$243.94$1,017.96$669.68$1,931.58$823.44$2,763.7758.10%
01812$1,300.56$0.00$0.94$0.94$0.00$0.00$1,419.21$303.02$558.07$2,280.30$2,704.36$4,985.60383.34%
0191717$10,107.86$0.00$41.87$41.87$4.99$0.00$109.25$750.39$338.32$1,197.96$15,236.51$16,481.33163.05%
020517$6,795.72$0.00$7.99$7.99$9.98$0.00$0.00$79.80$477.73$557.53($465.56)$109.941.62%
0235151$32,673.58$0.00$25.38$25.38$54.89$0.00$16,526.29$6,865.28$3,039.46$26,431.03$94.45$26,605.7581.43%
024924$11,265.70$0.00$10.81$10.81$14.97$0.00$600.96$1.87$1,290.19$1,893.02$482.30$2,401.1021.31%
C2311$594.58$0.00$0.47$0.47$0.00$0.00$0.00$141.61$69.71$211.32$3,196.99$3,408.78573.31%
R0777$7,812.18$0.00$10.29$10.29$4.99$0.00$0.00$402.92$191.52$594.44$434.29$1,044.0113.36%
R0866$4,832.28$0.00$40.68$40.68$4.99$0.00$0.00$1,287.54$924.39$2,211.93$81.29$2,338.8948.40%
R1111$792.54$0.00$1.47$1.47$0.00$0.00$0.00$0.00$0.00$0.00$540.40$541.8768.37%
R1233$2,416.14$0.00$20.34$20.34$9.98$0.00$0.00$132.48$0.00$132.48$1,686.64$1,849.4476.55%
Total404447$339,143.98$0.00$1,687.82$1,687.82$888.22$0.00$54,893.07$37,314.45$48,053.49$140,261.01$72,301.87$215,138.9263.44%
Avg1921$16,149.71$0.00$80.37$80.37$42.30$0.00$2,613.96$1,776.88$2,288.26$6,679.10$3,442.95$10,244.7163.44%
20231100144$3,962.70$0.00$7.35$7.35$4.99$0.00$0.00$72.06$73.98$146.04$965.24$1,123.6228.35%
0021111$8,859.18$0.00$74.58$74.58$34.93$0.00$1,430.00$323.81$1,415.36$3,169.17($344.13)$2,934.5533.12%
00433$1,610.76$0.00$40.68$40.68$4.99$0.00$0.00$0.00$0.00$0.00$5,373.42$5,419.09336.43%
0051212$9,510.48$0.00$16.17$16.17$24.95$0.00$2,117.00$1,649.31$672.75$4,439.06$3,795.86$8,276.0487.02%
0061617$13,747.88$0.00$115.26$115.26$34.93$0.00$439.95$580.21$292.40$1,312.56$133.13$1,595.8811.61%
0073537$28,436.38$0.00$54.39$54.39$34.93$0.00$5,846.00$5,979.93$1,057.84$12,883.77$14,562.50$27,535.5996.83%
0084953$41,839.56$0.00$352.56$352.56$144.71$0.00$3,109.00$2,434.54$2,795.62$8,339.16$5,626.97$14,463.4034.57%
0101111$9,664.56$0.00$67.80$67.80$34.93$0.00$0.00$448.06$390.57$838.63$1,404.86$2,346.2224.28%
0116572$53,964.10$0.00$102.90$102.90$84.83$0.00$3,218.83$7,974.65$2,984.70$14,178.18$10,540.79$24,906.7046.15%
01296105$76,567.52$0.00$664.44$664.44$334.33$8,026.86$6,593.97$7,135.82$2,540.64$24,297.29$26,717.24$52,013.3067.93%
01788$4,756.64$0.00$3.76$3.76$4.99$0.00$7.06$80.43$88.36$175.85$321.47$506.0710.64%
01812$1,300.56$0.00$0.94$0.94$0.00$0.00$0.00$0.00$0.00$0.00$566.77$567.7143.65%
0191515$10,107.86$0.00$50.86$50.86$9.98$0.00$0.00$405.73$637.99$1,043.72$3,007.67$4,112.2340.68%
020517$6,795.72$0.00$7.99$7.99$9.98$0.00$8,334.96$1,995.39$1,150.54$11,480.89$1,530.08$13,028.94191.72%
0235353$30,323.58$0.00$22.56$22.56$64.87$0.00$2,082.67$6,303.54$1,604.66$9,990.87$2,509.13$12,587.4341.51%
024924$11,265.70$0.00$11.75$11.75$14.97$0.00$0.00$6.68$375.57$382.25$995.27$1,404.2412.46%
C2311$606.47$0.00$0.47$0.47$0.00$0.00$0.00$0.00$0.00$0.00$3,196.99$3,197.46527.22%
R0777$5,547.78$0.00$10.29$10.29$9.98$0.00$1,018.61$329.80$741.56$2,089.97$2,543.31$4,653.5583.88%
R0866$4,832.28$0.00$40.68$40.68$4.99$0.00$413.00$194.31$164.88$772.19$180.78$998.6420.67%
R1111$792.54$0.00$1.47$1.47$0.00$0.00$0.00$485.02$0.00$485.02$556.95$1,043.44131.66%
R1233$2,416.14$0.00$20.34$20.34$9.98$0.00$0.00$50.40$82.92$133.32$1,091.84$1,255.4851.96%
Total411462$326,908.39$0.00$1,667.24$1,667.24$868.26$8,026.86$34,611.05$36,449.69$17,070.34$96,157.94$85,276.14$183,969.5856.28%
Avg2022$15,567.07$0.00$79.39$79.39$41.35$382.23$1,648.15$1,735.70$812.87$4,578.95$4,060.77$8,760.4656.28%
20231200144$2,377.62$0.00$7.35$7.35$0.00$0.00$0.00$215.72$62.14$277.86$6,281.03$6,566.24276.17%
0021111$8,859.18$0.00$74.58$74.58$0.00$0.00$2,860.00$167.76$497.92$3,525.68$5,674.42$9,274.68104.69%
00433$5,560.96$0.00$20.34$20.34$0.00$0.00$0.00$50.96$0.00$50.96$2,358.90$2,430.2043.70%
0051313$9,510.48$0.00$17.64$17.64$0.00$0.00$0.00$1,215.60$49.05$1,264.65$198.41$1,480.7015.57%
0061516$12,942.50$0.00$115.26$115.26$0.00$0.00$0.00$438.75$241.39$680.14$172.17$967.577.48%
0073537$28,436.38$0.00$54.39$54.39$0.00$0.00$1,384.21$1,859.25$502.44$3,745.90$7,460.22$11,260.5139.60%
0084954$42,701.36$0.00$366.12$366.12$0.00$0.00$18,919.14$8,689.09$2,890.71$30,498.94$9,509.81$40,374.8794.55%
0101111$7,248.42$0.00$74.58$74.58$0.00$0.00$6,623.00$4,319.66$697.11$11,639.77$440.11$12,154.46167.68%
0116875$55,549.18$0.00$107.31$107.31$0.00$34,440.00$29,000.37$5,774.65$2,911.83$72,126.85$11,528.71$83,762.87150.79%
01293101$78,348.18$0.00$711.90$711.90$0.00$42,156.43$7,014.02$6,724.99$2,855.66$58,751.10$17,210.58$76,673.5897.86%
01788$4,756.64$0.00$3.76$3.76$0.00$35,563.49$0.00$228.29$1,544.56$37,336.34$706.99$38,047.09799.87%
01812$1,300.56$0.00$0.94$0.94$0.00$0.00$0.00$0.00$195.70$195.70$0.00$196.6415.12%
0191515$7,729.54$0.00$20.55$20.55$0.00$0.00$847.25$220.74$1,053.29$2,121.28$2,271.93$4,413.7657.10%
020517$6,809.22$0.00$7.99$7.99$0.00$0.00$251.00$627.60$484.87$1,363.47$568.91$1,940.3728.50%
0235454$32,107.32$0.00$24.44$24.44$0.00$0.00$5,877.13$1,631.22$1,786.15$9,294.50$2,273.18$11,592.1236.10%
024924$11,265.70$0.00$11.28$11.28$0.00$0.00$2,909.25$637.20$304.05$3,850.50$424.63$4,286.4138.05%
C2311$618.36$0.00$0.47$0.47$0.00$0.00$0.00$0.00$84.57$84.57$3,294.55$3,379.59546.54%
R0777$5,547.78$0.00$10.29$10.29$0.00$0.00$0.00$193.56$113.93$307.49$351.11$668.8912.06%
R0866$4,832.28$0.00$40.68$40.68$0.00$0.00$0.00$0.00$232.95$232.95$59.68$333.316.90%
R1111$792.54$0.00$1.47$1.47$0.00$0.00$971.00$288.70$0.00$1,259.70$567.49$1,828.66230.73%
R1233$2,416.14$0.00$20.34$20.34$0.00$0.00$0.00($83.33)$0.00($83.33)$2,009.62$1,946.6380.57%
Total412463$329,710.34$0.00$1,691.68$1,691.68$0.00$112,159.92$76,656.37$33,200.41$16,508.32$238,525.02$73,362.45$313,579.1595.11%
Avg2022$15,700.49$0.00$80.56$80.56$0.00$5,340.95$3,650.30$1,580.97$786.11$11,358.33$3,493.45$14,932.3495.11%
20240100144$3,170.16$0.00$2.66$2.66$0.00$0.00$0.00$0.00$0.00$0.00$1,756.32$1,758.9855.49%
0021010$8,053.80$0.00$74.58$74.58$0.00$0.00$0.00$754.55$406.49$1,161.04$8,320.85$9,556.47118.66%
00433$2,416.14$0.00$20.34$20.34$0.00$0.00$0.00$50.85$75.63$126.48$6,830.38$6,977.20288.77%
0051313$11,095.56$0.00$19.67$19.67$0.00$0.00$2,286.25$1,613.33$622.70$4,522.28$1,690.65$6,232.6056.17%
0061415$12,942.50$0.00$101.70$101.70$0.00$0.00$0.00$472.99$0.00$472.99$29.24$603.934.67%
0073739$29,228.92$0.00$53.20$53.20$0.00$0.00$4,301.52$909.63$1,583.02$6,794.17$10,671.41$17,518.7859.94%
0085055$40,285.22$0.00$372.90$372.90$0.00$0.00$19,502.41$5,616.28$5,868.77$30,987.46$11,174.47$42,534.83105.58%
0101111$8,859.18$0.00$74.58$74.58$0.00$0.00$1,430.00$214.93($52.14)$1,592.79$887.61$2,554.9828.84%
0116774$57,926.80$0.00$106.54$106.54$0.00($14,370.10)$8,528.06$3,204.67$5,141.23$2,503.86$12,317.01$14,927.4125.77%
01294102$75,752.32$0.00$664.44$664.44$0.00$27,031.18$14,178.03$10,882.31$8,870.63$60,962.15$26,390.68$88,017.27116.19%
01788$4,756.64$0.00$3.20$3.20$0.00$0.00($7.06)$3.58$597.84$594.36$271.02$868.5818.26%
01812$1,300.56$0.00$0.80$0.80$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.800.06%
0191414$8,324.12$0.00$39.05$39.05$0.00$0.00$246.27$519.77$1,310.01$2,076.05$1,618.44$3,733.5444.85%
020517$6,795.72$0.00$6.80$6.80$0.00$0.00$1,329.00$667.57$0.00$1,996.57$56.73$2,060.1030.31%
0235555$32,107.32$0.00$21.67$21.67$0.00$0.00$0.00$593.16$1,145.84$1,739.00$0.00$1,760.675.48%
024924$11,265.70$0.00$9.60$9.60$0.00$0.00$244.00($476.10)$553.86$321.76$465.83$797.197.08%
C2311$606.47$0.00$0.40$0.40$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.400.07%
R0777$5,547.78$0.00$9.80$9.80$0.00$0.00$0.00$135.84$149.79$285.63$1,992.43$2,287.8641.24%
R0866$4,832.28$0.00$40.68$40.68$0.00$0.00$4,240.00$853.82$446.30$5,540.12$99.59$5,680.39117.55%
R1111$792.54$0.00$1.40$1.40$0.00$0.00$0.00$222.87$0.00$222.87$310.58$534.8567.49%
R1233$2,416.14$0.00$20.34$20.34$0.00$0.00$0.00$0.00$0.00$0.00$1,959.96$1,980.3081.96%
Total413464$328,475.87$0.00$1,644.35$1,644.35$0.00$12,661.08$56,278.48$26,240.05$26,719.97$121,899.58$86,843.20$210,387.1364.05%
Avg2022$15,641.71$0.00$78.30$78.30$0.00$602.91$2,679.93$1,249.53$1,272.38$5,804.74$4,135.39$10,018.4364.05%
20240200144$3,170.16$0.00$5.60$5.60$5.96$0.00$0.00$0.00$86.61$86.61$1,864.12$1,962.2961.90%
0021010$8,053.80$0.00$64.42$64.42$41.72$0.00$1,163.91$756.85$540.60$2,461.36$5,460.18$8,027.6899.68%
00433$2,416.14$0.00$21.36$21.36$11.92$0.00$0.00$0.00$80.93$80.93$6,333.08$6,447.29266.84%
0051313$10,303.02$0.00$18.20$18.20$29.80$0.00$157.25$616.78$71.41$845.44$2,557.91$3,451.3533.50%
0061415$11,331.74$0.00$100.02$100.02$35.76$0.00$0.00$581.25$214.23$795.48$59.81$991.078.75%
0073537$28,436.38$0.00$51.80$51.80$29.80$0.00$98.88$726.52$1,346.25$2,171.65$8,375.32$10,628.5737.38%
0085055$42,701.36$0.00$391.60$391.60$178.80$0.00$20,485.79$5,211.95$3,786.32$29,484.06$4,632.43$34,686.8981.23%
0101111$8,859.18$0.00$78.32$78.32$47.68$0.00$746.00$607.43$449.23$1,802.66$1,122.48$3,051.1434.44%
0116673$57,134.26$0.00$99.40$99.40$119.20$71,457.07$6,605.72$2,024.01$2,042.87$82,129.67$10,600.04$92,948.31162.68%
01296104$74,890.52$0.00$733.19$733.19$369.52($22,722.75)$17,452.80$16,554.91$5,476.22$16,761.18$6,835.33$24,699.2232.98%
01788$4,756.64$0.00$3.20$3.20$5.96$0.00$3,520.41$2,132.15$230.31$5,882.87$865.91$6,757.94142.07%
01812$1,300.56$0.00$0.80$0.80$0.00$0.00$0.00$0.00$0.00$0.00$2.50$3.300.25%
0191414$8,324.12$0.00$36.06$36.06$11.92$0.00$0.00$840.94$999.43$1,840.37$1,662.43$3,550.7842.66%
020517$6,795.72$0.00$6.80$6.80$5.96$0.00$0.00$232.16$0.00$232.16$0.00$244.923.60%
0235353$31,512.74$0.00$21.20$21.20$83.44$0.00$4,057.16$1,022.23$99.74$5,179.13$0.00$5,283.7716.77%
024924$11,265.70$0.00$9.60$9.60$17.88$0.00$0.00$896.48$53.80$950.28$14.21$991.978.81%
C2311$606.47$0.00$0.40$0.40$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.400.07%
R0799$6,340.32$0.00$11.20$11.20$5.96$0.00$0.00$208.11$1.80$209.91$515.03$742.1011.70%
R0866$4,832.28$0.00$42.72$42.72$11.92$0.00$0.00$379.15$52.00$431.15$53.72$539.5111.16%
R1111$792.54$0.00$1.40$1.40$0.00$0.00$1,598.00$125.68$0.00$1,723.68$574.14$2,299.22290.11%
R1233$2,416.14$0.00$21.36$21.36$11.92$0.00$0.00$289.61$38.22$327.83$3,427.07$3,788.18156.79%
Total412463$326,239.79$0.00$1,718.65$1,718.65$1,025.12$48,734.32$55,885.92$33,206.21$15,569.97$153,396.42$54,955.71$211,095.9064.71%
Avg2022$15,535.23$0.00$81.84$81.84$48.82$2,320.68$2,661.23$1,581.25$741.43$7,304.59$2,616.94$10,052.1964.71%
20240300144$3,170.16$0.00$5.72$5.72$6.21$0.00$0.00$90.06($62.14)$27.92$4,147.33$4,187.18132.08%
0021010$8,053.80$0.00$69.80$69.80$37.26$0.00$0.00$208.48$248.44$456.92$961.52$1,525.5018.94%
00433$2,416.14$0.00$20.94$20.94$12.42$0.00$1,430.00$552.84$64.61$2,047.45$3,630.20$5,711.01236.37%
0051212$9,510.48$0.00$18.59$18.59$24.84$0.00$0.00$1,511.89$112.28$1,624.17$1,926.53$3,594.1337.79%
0061415$12,137.12$0.00$104.70$104.70$37.26$0.00$464.37$1,055.81$527.91$2,048.09$14.47$2,204.5218.16%
0073638$27,643.84$0.00$51.51$51.51$31.05$0.00$4,688.04$772.74$309.10$5,769.88$15,856.82$21,709.2678.53%
0085156$43,506.74$0.00$390.88$390.88$217.35$0.00$1,660.44$4,289.11$3,400.99$9,350.54$9,905.58$19,864.3545.66%
0101111$8,859.18$0.00$76.78$76.78$49.68$0.00$0.00$225.64$181.62$407.26$1,161.28$1,695.0019.13%
0116572$53,171.56$0.00$100.10$100.10$136.62$0.00$9,537.01$3,923.75$2,164.68$15,625.44$8,615.58$24,477.7446.04%
01296104$79,779.22$0.00$732.87$732.87$422.28$198,737.12$18,140.67$18,154.56$26,620.09$261,652.44$13,111.27$275,918.86345.85%
01788$4,756.64$0.00$3.20$3.20$6.21$0.00$0.00$503.74$104.00$607.74($148.74)$468.419.85%
01812$1,300.56$0.00$0.80$0.80$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.800.06%
0191414$8,324.12$0.00$32.92$32.92$6.21$0.00$0.00$72.98$541.30$614.28$1,662.43$2,315.8427.82%
020517$6,795.72$0.00$6.80$6.80$12.42$0.00$0.00$235.47$175.50$410.97$31.88$462.076.80%
0235353$32,107.32$0.00$20.80$20.80$86.94$14,812.90$3,659.31$252.65$1,178.69$19,903.55$750.84$20,762.1364.66%
024924$11,265.70$0.00$9.60$9.60$18.63$0.00$0.00$0.00$294.59$294.59$14.21$337.032.99%
C2311$606.47$0.00$0.40$0.40$0.00$0.00$0.00$0.00$0.00$0.00$1.64$2.040.34%
R0799$7,132.86$0.00$14.27$14.27$6.21$0.00$0.00$138.69$88.18$226.87$1,518.95$1,766.3024.76%
R0866$4,832.28$0.00$41.88$41.88$12.42$0.00$0.00$54.98$136.16$191.14$10.22$255.665.29%
R1111$792.54$0.00$1.43$1.43$0.00$0.00$451.20$159.06$259.15$869.41$489.52$1,360.36171.65%
R1233$2,416.14$0.00$20.94$20.94$12.42$0.00$0.00$162.89$0.00$162.89$574.44$770.6931.90%
Total412463$328,578.59$0.00$1,724.93$1,724.93$1,136.43$213,550.02$40,031.04$32,365.34$36,345.15$322,291.55$64,235.97$389,388.88118.51%
Avg2022$15,646.60$0.00$82.14$82.14$54.12$10,169.05$1,906.24$1,541.21$1,730.72$15,347.22$3,058.86$18,542.33118.51%
AllTotal4,9115,461$3,825,710.46$0.00$19,889.11$19,889.118960.55$634,710.21$737,157.11$356,910.01$269,030.21$1,997,807.54$855,074.83$2,881,732.0375.33%
Grouping Avg409455$318,809.21$0.00$1,657.43$1,657.43$746.71$52,892.52$61,429.76$29,742.50$22,419.18$166,483.96$71,256.24$240,144.3475.33%
Monthly Avg1922$15,121.39$0.00$78.61$78.6135.4171936759$2,508.74$2,913.66$1,410.71$1,063.36$7,896.47$3,379.74$11,390.2575.33%

Notes:

- Grand Total includes Medical FFS, Pharmacy FFS, Incentives and Capitation.

- Grouping Avg – Average of the distinct groupings chosen by the user.

- Monthly Avg – Average of a measure over Service/Paid time period.

- Enrollment is recast to reflect retroactive adjustments.

- FFS = Fee For Service.

- MLR = Medical Loss Ratio.

&"Arial,Regular"&8 This Florida Blue report is proprietary and confidential. Report Run: 04/16/2024 11:31 AM Page 1 of 2

S6 Monitoring by Utiliza Page2

Monitoring by Utilization and Enrollment - By Division
Paid Year MonthDiv NumEmployee
OnlyEmployee &
SpouseEmployee &
ChildrenFamilySpouse OnlySpouse &
ChildrenChildren OnlyTotal
ContractsTotal

Members

202304001400000044
002110000001111
004200000022
005110000001111
006141000001516
007320100003335
008461000004748
010120000001212
011563100006067
012102100000103104
017900000099
018010000012
019170000001717
0200041000516
023510000005151
02404610001130
R07400000044
R08500000055
R11100000011
R12200000022
Total37911122000404447
Avg191100002022
202305001400000044
002110000001111
004200000022
005110000001111
006141000001516
007320100003335
008471000004849
010120000001212
011573100006168
012103100000104105
017800000088
018010000012
019170000001717
0200032000517
023510000005151
02404510001027
R07400000044
R08500000055
R11100000011
R12300000033
Total38211103000406448
Avg191100002022
202306001400000044
002110000001111
004200000022
005110000001111
006141000001516
007320100003335
008471000004849
010120000001212
011573100006168
012104100000105106
017800000088
018010000012
019170000001717
0200032000517
023520000005252
0240351000925
C23100000011
R07400000044
R08500000055
R11100000011
R12300000033
Total38510103000408449
Avg180000001921
202307001400000044
002110000001111
004200000022
005111000001213
006151000001617

This is the start of the file's text. The full file is on GovTribe.

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