January -14
<br />February -14
<br />March -14
<br />2014 Plan Experience
<br />AM
<br />Subs
<br />Medical
<br />Pharmacy
<br />Combined
<br />Medical Claims
<br />PPO Plan
<br />Claims Per Sub
<br />Per Month
<br />Total
<br />Administration
<br />778
<br />776
<br />$141,278
<br />$291,097
<br />$68,600
<br />$102,181
<br />$209,878.21
<br />$393,278.39
<br />$269.77
<br />$506.80
<br />$104,360.92
<br />$104,092.64
<br />776
<br />$625,686.00
<br />$136,455.00
<br />$762,141.00
<br />$982.14
<br />$104,092.64
<br />2,330
<br />$1,058,061.53
<br />$307,236.07
<br />$1,365,297.60
<br />$585.96
<br />$312,546.20
<br />HSA Plan
<br />Subs
<br />Medical
<br />PharmacJ$74,814.30
<br />Combined
<br />edical Claims
<br />Claims Per Sub
<br />Per Month
<br />Total
<br />Administration
<br />201
<br />$17,242
<br />$265
<br />$17,507.01
<br />$87.10
<br />$26,962.14
<br />204
<br />$73,041
<br />$1,774
<br />$543,924.09
<br />$366.74
<br />$27,364.56
<br />198
<br />$232,235.00
<br />$1,114.0233,349.00
<br />1
<br />$382,426.28
<br />$1,178.53
<br />$26,559.72
<br />603
<br />$322,517.72
<br />$3,152.59
<br />1 $325,670.31
<br />$540.08
<br />$80,886.42
<br />Combined
<br />$1,068,431.55
<br />Subs
<br />Medical
<br />Pharmacy
<br />Combined
<br />Medical Claims
<br />Claims Per Sub
<br />Per Month
<br />Total
<br />Administration
<br />979
<br />$158,520.44
<br />$68,864.78
<br />$227,385.22
<br />$232.26
<br />$131,323.06
<br />980
<br />$364,137.81
<br />$103,954.88
<br />$468,092.69
<br />$477.65
<br />$131,457.20
<br />974
<br />$857,921.00
<br />$137,569.00
<br />$995,490.00
<br />$1,022.06
<br />$130,652.36
<br />3 $1,380,579.25 $310,388.66 $1,690,967.91 $576.53 $393,432.62
<br />Rx Per Sub $105.83 Change 89.04%
<br />Change 86.54% i
<br />Total Cost
<br />Stop -loss
<br />Credits
<br />Net Costs
<br />County
<br />Budgeted
<br />$314,239.13
<br />$0.00
<br />$314,239.13
<br />$634,038.88
<br />$497,371.03
<br />$0.00
<br />$497,371.03
<br />$632,408.96
<br />$866,233.64
<br />$81,074.81
<br />$785,158.83
<br />$632,408.96
<br />X1,677,843.80
<br />$81,074.81
<br />$1,596,768.99
<br />$1,898,856.8(
<br />Total Cost
<br />Stop -loss
<br />Credits
<br />Net Costs
<br />County
<br />Budgeted
<br />$68,187.15
<br />$0.00
<br />$68,187.15
<br />$181,308.03
<br />$126,250.86
<br />$0.00
<br />$126,250.86
<br />$184,014.12
<br />$283,272.72
<br />$0.00
<br />$283,272.72
<br />$178,601.94
<br />$477,710.73
<br />L $0.00
<br />$477,710.73
<br />$543,924.09
<br />Total Cost
<br />Stop -loss
<br />Credits
<br />Net Costs
<br />County
<br />Budgeted
<br />$382,426.28
<br />$0.00
<br />$382,426.28
<br />$815,346.91
<br />$623,621.89
<br />$0.00
<br />$623,621.89
<br />$816,423.08
<br />1,149,506.361
<br />$81,074.81 1
<br />$1,068,431.55
<br />$811,010.90
<br />155,554.531 $81,074.81 $2,074,479.72 $2,442,780.89
<br />31.41% 1 $368,301.17
<br />9
<br />
|