|
J
<br />A P'
<br />PPO Plan
<br />Date
<br />Subs
<br />Medical
<br />Pharmacy
<br />Combined
<br />Medical Claims
<br />Claims Per Sub
<br />Per Month
<br />Total
<br />Administration
<br />Total Cost
<br />Stop -loss
<br />Credits
<br />Net Costs
<br />County
<br />Budgeted
<br />January-14
<br />778
<br />$141,278.45
<br />$68,599.76
<br />$209,878.21
<br />$269.77
<br />$104,360.92
<br />$314,239.13
<br />$0.00
<br />$314,239.13
<br />$634,038.88
<br />February -14
<br />776
<br />$291,097.08
<br />$102,181.31
<br />$393,278.39
<br />$506.80
<br />$104,092.64
<br />$497,371.03
<br />$0.00
<br />$497,371.03
<br />$632,408.96
<br />March -14
<br />776
<br />$625,686.29
<br />$136,454.90
<br />$762,141.19
<br />$982.14
<br />$104,092.64
<br />$866,233.83
<br />$134,831.00
<br />$731,402.83
<br />$632,408.96
<br />April -14
<br />777
<br />$419,131.65
<br />$154,741.65
<br />$573,873.30
<br />$738.58
<br />$104,226.78
<br />$678,100.08
<br />$125,351.00
<br />$552,749.08
<br />$633,223.92
<br />May -14
<br />779
<br />$401,845.21
<br />$152,229.33
<br />$554,074.54
<br />$711.26
<br />$104,495.06
<br />$658,569.60
<br />$13,128.00
<br />$645,441.60
<br />$634,853.84
<br />June-14
<br />780
<br />$460,061.79
<br />$151,610.53
<br />$611,672.32
<br />$784.20
<br />$104,629.20
<br />$716,301.52
<br />$44,024.00
<br />$672,277.52
<br />$635,668.80
<br />July-14
<br />776
<br />$544,000.00
<br />$280,000.00
<br />$824,000.00
<br />$1,061.86
<br />$104,092.64
<br />$928,092.64
<br />$10,944.00
<br />$917,148.64
<br />$632,408.96
<br />Total
<br />5,442
<br />$2,883,100.47
<br />$1,045,817.48
<br />$3,928,917.95
<br />$721.96
<br />$729,989.88
<br />$4,658,907.83
<br />$328,278.00
<br />$4,330,629.83
<br />$4,435,012.32
<br />HSA Plan
<br />Date
<br />Subs
<br />Medical
<br />Pharmacy
<br />Combined
<br />Medical Claims
<br />Claims Per Sub
<br />Per Month
<br />Total
<br />Administration
<br />Total Cost
<br />Stop -loss
<br />Credits
<br />Net Costs
<br />County
<br />Budgeted
<br />January-14
<br />201
<br />$17,241.99
<br />$265.02
<br />$17,507.01
<br />$87.10
<br />$26,962.14
<br />$68,187.15
<br />$0.00
<br />$68,187.15
<br />$181,308.03
<br />February -14
<br />204
<br />$73,040.73
<br />$1,773.57
<br />$74,814.30
<br />$366.74
<br />$27,364.56
<br />$126,250.86
<br />$0.00
<br />$126,250.86
<br />$184,014.12
<br />March -14
<br />198
<br />$232,234.95
<br />$1,114.45
<br />$233,349.40
<br />$1,178.53
<br />$26,559.72
<br />$283,273.12
<br />$0.00
<br />$283,273.12
<br />$178,601.94
<br />April -14
<br />208
<br />$31,793.11
<br />$2,077.61
<br />$33,870.72
<br />$162.84
<br />$27,901.12
<br />$86,315.84
<br />$0.00
<br />$86,315.84
<br />$187,622.24
<br />May -14
<br />206
<br />$79,143.40
<br />$2,603.32
<br />$81,746.72
<br />$396.83
<br />$27,632.84
<br />$133,687.56
<br />$0.00
<br />$133,687.56
<br />$185,818.18
<br />June-14
<br />204
<br />$37,252.57
<br />$2,929.53
<br />$40,182.10
<br />$196.97
<br />$27,364.56
<br />$91,618.66
<br />$0.00
<br />$91,618.66
<br />$184,014.12
<br />July-14
<br />205
<br />$80,909.00
<br />$3,891.00
<br />$84,800.00
<br />$413.66
<br />$27,498.70
<br />$136,488.70
<br />$0.00
<br />$136,488.70
<br />$184,916.15
<br />Total
<br />1,426
<br />$551,615.75
<br />$14,654.50
<br />$566,270.25
<br />$397.10
<br />$191,283.64
<br />$925,821.89
<br />$0.00
<br />$925,821.89
<br />$1,286,294.78
<br />Combined
<br />Date
<br />Subs
<br />Medical
<br />Pharmacy
<br />Combined
<br />Medical Claims
<br />Claims Per Sub
<br />Per Month
<br />Total
<br />Administration
<br />Total Cost
<br />Stop -loss
<br />Credits
<br />Net Costs
<br />County
<br />Budgeted
<br />January-14
<br />979
<br />$158,520.44
<br />$68,864.78
<br />$227,385.22
<br />$232.26
<br />$131,323.06
<br />$382,426.28
<br />$0.00
<br />$382,426.28
<br />$815,346.91
<br />February -14
<br />980
<br />$364,137.81
<br />$103,954.88
<br />$468,092.69
<br />$477.65
<br />$131,457.20
<br />$623,621.89
<br />$0.00
<br />$623,621.89
<br />$816,423.08
<br />March -14
<br />974
<br />$857,921.24
<br />$137,569.35
<br />$995,490.59
<br />$1,022.06
<br />$130,652.36
<br />$1,149,506.95
<br />$134,831.00
<br />$1,014,675.95
<br />$811,010.90
<br />April -14
<br />985
<br />$450,924.76
<br />$156,819.26
<br />$607,744.02
<br />$617.00
<br />$132,127.90
<br />$764,415.92
<br />$125,351.00
<br />$639,064.92
<br />$820,846.16
<br />May -14
<br />985
<br />$480,988.61
<br />$154,832.65
<br />$635,821.26
<br />$645.50
<br />$132,127.90
<br />$792,257.16
<br />$13,128.00
<br />$779,129.16
<br />$820,672.02
<br />June-14
<br />984
<br />$497,314.36
<br />$154,540.06
<br />$651,854.42
<br />$662.45
<br />$131,993.76
<br />$807,920.18
<br />$44,024.00
<br />$763,896.18
<br />$819,682.92
<br />July-14
<br />981
<br />$624,909.00
<br />$283,891.00
<br />$908,800.00
<br />$926.40
<br />$131,591.34
<br />$1,064,581.34
<br />$10,944.00
<br />$1,053,637.34
<br />$817,325.11
<br />August -14
<br />September -14
<br />October -14
<br />November -14
<br />December -14
<br />Total
<br />1 6,868
<br />1$3,434,716.221$1,060,471.981
<br />$4,495,188.20
<br />$654.51
<br />$921,273.52
<br />$5,584,729.72
<br />$328,278.00
<br />$5,256,451.72
<br />$5,721,307.10
<br />Change
<br />101.08%
<br />$464,855.38
<br />
|