|
i
<br />HSA Plan
<br />Date
<br />Subs
<br />Mbrs
<br />Premium
<br />Medical
<br />Pharmacy
<br />Capitation
<br />Combined
<br />Medical Claims
<br />Claims Per Sub
<br />Per Month
<br />Loss Ratio
<br />January -13
<br />212
<br />390
<br />$162,620.27
<br />$50,871.77
<br />$2,083.01
<br />$4,361.12
<br />$57,315.90
<br />$270.36
<br />35.25%
<br />February -13
<br />209
<br />391
<br />$161,350.00
<br />$37,112.00
<br />$2,042.00
<br />$4,384.00
<br />$43,538.00
<br />$208.32
<br />26.98%
<br />March -13
<br />210
<br />392
<br />$161,860.15
<br />$136,181.99
<br />$2,065.05
<br />$4,394.84
<br />$142,641.89
<br />$679.25
<br />88.13%
<br />April -13
<br />206
<br />383
<br />$158,880.89
<br />$57,726.66
<br />$5,333.90
<br />$4,316.16
<br />$67,376.72
<br />$327.07
<br />42.41%
<br />May -13
<br />207
<br />386
<br />$159,957.00
<br />$74,496.00
<br />$7,300.00
<br />$4,350.00
<br />$86,146.00
<br />$416.16
<br />53.86%
<br />June-13
<br />206
<br />384
<br />$160,013.41
<br />$24,155.00
<br />$10,519.03
<br />$4,327.40
<br />$39,001.43
<br />$189.33
<br />24.37%
<br />July-13
<br />209
<br />387
<br />$162,110.12
<br />$177,976.62
<br />$9,258.79
<br />$4,361.12
<br />$191,596.53
<br />$916.73
<br />118.19%
<br />August -13
<br />207
<br />383
<br />$160,207.27
<br />$44,748.25
<br />$8,418.69
<br />$4,316.16
<br />$57,483.10
<br />$277.70
<br />35.88%
<br />September -13
<br />207
<br />382
<br />$160,911.28
<br />$25,177.42
<br />$8,300.03
<br />$4,304.92
<br />$37,782.37
<br />$182.52
<br />23.48%
<br />October -13
<br />211
<br />385
<br />$162,635.59
<br />$51,424.32
<br />$11,943.56
<br />$4,327.40
<br />$67,695.29
<br />$320.83
<br />41.62%
<br />November -13
<br />212
<br />383
<br />$161,559.18
<br />$71,041.87
<br />$16,723.54
<br />$4,304.92
<br />$92,070.33
<br />$434.29
<br />56.99%
<br />December -13
<br />212
<br />382
<br />$161,243.00
<br />$83,601.00
<br />$17,403.00
<br />$4,294.00
<br />$105,298.00
<br />$496.69
<br />65.30%
<br />Total
<br />2,508
<br />4,628 1
<br />$1,933,348.16 1
<br />$834512.91 1
<br />8101,390.60
<br />552,042.04 1
<br />$987,945.56
<br />$393.92
<br />51.10%
<br />PPO Plan
<br />Date
<br />Subs
<br />Mbrs
<br />Premium
<br />Medical
<br />Pharmacy
<br />Capitation
<br />Combined
<br />Medical Claims
<br />Claims Per Sub
<br />Per Month
<br />Loss Ratio
<br />January -13
<br />793
<br />1270
<br />$658,202.86
<br />$413,768.21
<br />$128,819.17
<br />$14,151.16
<br />$556,738.54
<br />$702.07
<br />84.58%
<br />February -13
<br />785
<br />1254
<br />$656,871.00
<br />$526,142.00
<br />$101,875.00
<br />$14,117.00
<br />$642,134.00
<br />$818.01
<br />97.76%
<br />March -13
<br />781
<br />1252
<br />$654,106.50
<br />$490,533.16
<br />$117,996.66
<br />$14,072.48
<br />$622,602.31
<br />$797.19
<br />95.18%
<br />April -13
<br />782
<br />1251
<br />$655,198.46
<br />$425,139.55
<br />$113,863.00
<br />$14,094.96
<br />$553,097.50
<br />$707.29
<br />84.42%
<br />May -13
<br />787
<br />1247
<br />$653,715.00
<br />$477,339.00
<br />$109,433.00
<br />$14,039.00
<br />$600,811.00
<br />$763.42
<br />91.91%
<br />June -13
<br />790
<br />1251
<br />$656,713.28
<br />$270,417.84
<br />$103,850.88
<br />$14,094.96
<br />$388,363.68
<br />$491.60
<br />59.14%
<br />July-13
<br />August -13
<br />795
<br />805
<br />1254
<br />1274
<br />$656,662.74
<br />$661,074.72
<br />$404,477.45
<br />$441,628.08
<br />$119,256.79
<br />$114,516.61
<br />$14,106.20
<br />$14,241.08
<br />$537,840.44
<br />$570,385.77
<br />$676.53
<br />$708.55
<br />81.91%
<br />86.28%
<br />September -13
<br />799
<br />1261
<br />$657,918.82
<br />$348,069.93
<br />$112,611.29
<br />$14,184.88
<br />$474,866.10
<br />$594.33
<br />72.18%
<br />October -13
<br />802
<br />1265
<br />$659,433.64
<br />$457,286.77
<br />$116,096.62
<br />$14,196.12
<br />$587,579.51
<br />$732.64
<br />1 89.10%
<br />November -13
<br />804
<br />1260
<br />$657,476.94
<br />$746,131.28
<br />$112,374.53
<br />$14,106.20
<br />$872,612.01
<br />$1,085.34
<br />132.72%
<br />December -13
<br />803
<br />1259
<br />$658,739.00
<br />$411,300.00
<br />$119,551.00
<br />$14,129.00
<br />$544,980.00
<br />$678.68
<br />82.73%
<br />Total
<br />9,526
<br />1 15,098
<br />$7,886,112.96
<br />$5,412,233.28
<br />$1,370,244.55
<br />$169,533.04
<br />$6,952,010.87
<br />$729.79
<br />88.16%
<br />Combined Plans
<br />Date
<br />Subs
<br />Mbrs
<br />Premium
<br />Medical
<br />Pharmacy
<br />Capitation
<br />Combined
<br />Medical Claims
<br />Claims Per Sub
<br />Per Month
<br />Loss Ratio
<br />January -13
<br />1,005
<br />1,660
<br />$820,823.13
<br />$464,639.98
<br />$130,902.18
<br />$18,512.28
<br />$614,054.44
<br />$611.00
<br />74.81%
<br />February -13
<br />March -13
<br />994
<br />991
<br />1,645
<br />1,644
<br />$818,221.00
<br />$815,966.65
<br />$563,254.00
<br />$626,715.16
<br />$103,917.00
<br />$120,061.72
<br />$18,501.00
<br />$18,467.32
<br />$685,672.00
<br />$765,244.19
<br />$689.81
<br />$772.19
<br />83.80%
<br />93.78%
<br />April -13
<br />May -13
<br />June -13
<br />988
<br />994
<br />996
<br />1,634
<br />1,633
<br />1,635
<br />$814,079.35
<br />$813,672.00
<br />$816,726.69
<br />$482,866.21
<br />$551,835.00
<br />$294,572.85
<br />$119,196.90
<br />$116,733.00
<br />$114,369.91
<br />$18,411,12
<br />$18,389.00
<br />$18,422.36
<br />$620,474.22
<br />$668,568.00
<br />$408,942.76
<br />$628.01
<br />$672.60
<br />$410.59
<br />76.22%
<br />82.17%
<br />50.07%
<br />my -13
<br />August -13
<br />September -13
<br />October -13
<br />November -13
<br />December -13
<br />1,004
<br />1,012
<br />1,006
<br />1,013
<br />1,016
<br />1,015
<br />1,641
<br />1,657
<br />1,643
<br />1,650
<br />1,643
<br />1,641
<br />$818,772.86
<br />$821,281.99
<br />$818,830.10
<br />$822,069.23
<br />$819,036.12
<br />$819,982.00
<br />$582,454.08
<br />$486,376.33
<br />$373,247.35
<br />$508,711.09
<br />$817,173.15
<br />$494,901.00
<br />$128,515.58
<br />$122,935.30
<br />$120,911.32
<br />$128,040.19
<br />$129,098.07
<br />$136,954.0
<br />$18,467.32
<br />$18,557.24
<br />$18,489.80
<br />$18,523.52
<br />$18,411.12
<br />$18,423.00
<br />$710,969.65
<br />$609,311.64
<br />$494,158.67
<br />$636,751.28
<br />$946,271.22
<br />$631,855.00
<br />$708.14
<br />$602.09
<br />$491.21
<br />$628.58
<br />$931.37
<br />$622.52
<br />86.83%
<br />74.19%
<br />60.35%
<br />77.46%
<br />115.530
<br />77.06%
<br />otal
<br />12,034
<br />19,726
<br />$9,819,461.12
<br />$6,246,746.19
<br />$1,471,635.16
<br />$221,575.08
<br />$7,792,273.07
<br />$647.52
<br />79.36%
<br />$122.29
<br />113.89%
<br />
|