Agenda - 04-11-2013 - 2 - Laserfiche WebLink

Browse Search

N� 0 13 ■ HSA Plan Date Subs Mbrs Premium Medical Pharmacy Capitation Combined Claims Claims Per Sub Per Month Loss Ratio January -12 195 375 $142,356.71 $12,037.78 $2 $3,845.63 $15,884.91 $81.46 11.16% February-12 196 373 $141,405.73 $21,599.49 $699 $3,814.70 $26,113.07 $133.23 18.47% March -12 191 362 $139,684.00 $30,321.00 $1,091.00 $3,732.00 $35,144.00 $184.00 25.16% April -12 191 364 $140,868.00 $43,011.00 $1,695.00 $3,753.00 $48,459.00 $253.71 34.40% May -12 192 364 $140,688.00 $35,127.00 $2,641.00 $3,753.00 $41,521.00 $216.26 29.51% June-12 196 371 $143,540.68 $24,769.27 $2,544.50 $3,825 $31,138.78 $158.87 21.69% July-12 205 380 $148,181.47 $25,229.21 $5,333.99 $3,918 $34,481.00 $168.20 23.27% August -12 207 385 $150,507.00 $127,044.00 $4,992.00 $3,969.00 $136,005.00 $657.03 90.36% September -12 206 385 $150,145.00 $54,506.00 $5,373.00 $3,969.00 $63,848.00 $309.94 42.52% October -12 208 384 $149,798.00 $25,270.00 $7,335.00 $3,959.00 $36,564.00 $175.79 24.41% November -12 217 397 $154,425.00 $69,224.00 $8,584.00 $4,083.00 $81,891.00 $377.38 53.03% December -12 220 401 $155,851.00 $80,748.00 $11,558.00 $4,103.00 $96,409.00 $438.22 61.86% Total 2,424 4,541 $1,757,450.59 $548,886.74 $51,847.89 $46,724.14 $647,458.76 $267.10 36.84% PPO Plan Date Subs Mbrs Premium Medical Pharmacy Capitation Combined Claims Claims Per Sub Per Month Loss Ratio January -12 755 1,258 $601,086.67 $503,372.10 $72,164.17 $12,887.50 $588,423.77 $779.37 97.89% February -12 750 1,254 $602,793.53 $443,530.37 $86,572.58 $12,928.74 $543,031.69 $724.04 90.09% March -12 746 1,246 $599,131.00 $424,785.00 $105,977.00 $12,867.00 $543,629.00 $728.73 90.74% April -12 745 1245 $593,015.00 $573,611.00 $102,468.00 $12,763.78 $688,842.78 $924.62 116.16% May -12 753 1,252 $596,579.00 $417,265.00 $112,812.00 $12,867.00 $542,944.00 $721.04 91.01% June -12 752 1246 $592,685.50 $335,871.46 $82,049.64 $12,784.40 $430,705.50 $572.75 72.67% July -12 790 1286 $615,389.38 $376,251.09 $115,307.99 $13,268.97 $504,828.05 $639.02 82.03% August -12 784 1,272 $610,263.00 $408,789.00 $107,816.00 $13,125.00 $529,730.00 $675.68 86.80% September -12 777 1,264 $604,558.00 $451,349.00 $100,731.00 $12,991.00 $565,071.00 $727.25 93.47% October -12 779 1,260 $603,476.00 $363,443.00 $109,365.00 $12,980.00 $485,788.00 $623.60 80.50% November -12 777 1,259 $604,066.00 $409,725.00 $119,655.00 $13,001.00 $542,381.00 $698.05 89.79% December -12 775 1,252 $601,173.00 $426,124.00 $103,265.00 $12,918.00 $542,307.00 $699.75 90.21% Total 9,183 15,094 $7,224,216.08 $5,134,116.02 $1,218,183.38 $155,382.39 $6,507,681.79 $708.67 90.08% Combined Plans Date Subs Mbrs Premium Medical Pharmacy Capitation Combined Claims Claims Per Sub Per Month Loss Ratio January -12 950 1,633 $743,443.38 $515,409.87 $72,165.67 $16,733.13 $604,308.68 $636.11 81.29% February -12 946 1,627 $744,199.26 $465,129.86 $87,271.47 $16,743.44 $569,144.77 $601.63 76.48% March -12 937 1,608 $738,815.00 $455,106.00 $107,068.00 $16,599.00 $578,773.00 $617.69 78.34% April -12 936 1,609 $733,883.00 $616,622.00 $104,163.00 $16,516.78 $737,301.78 $787.72 100.47% May -12 945 1,616 $737,267.00 $452,392.00 $115,453.00 $16,620.00 $567,845.00 $600.89 77.02% June -12 948 1,617 $736,226.18 $360,640.73 $84,594.14 $16,609.41 $445,234.87 $469.66 60.48% July -12 995 1,666 $763,570.85 $401,480.30 $120,641.98 $17,186.77 $522,122.29 $524.75 68.38% August -12 991 1,657 $760,770.00 $535,833.00 $112,808.00 $17,094.00 $648,641.00 $654.53 85.26% September -12 983 1,649 $754,703.00 $505,855.00 $106,104.00 $16,960.00 $611,959.00 $622.54 81.09% October -12 987 1,644 $753,274.00 $388,713.00 $116,700.00 $16,939.00 $505,413.00 $512.07 67.10% November -12 994 1,656 $758,491.00 $478,949.00 $128,239.00 $17,084.00 $607,188.00 $610.85 80.05% December -12 995 1,653 $757,024.00 $506,872.00 $114,823.00 $17,021.00 $621,695.00 $624.82 82.12% Total 11,607 19,635 $8,981,666.67 $5,683,002.76 $1,270,031.27 $202,106.53 $7,019,626.38 $604.78 78.16% Trend 69.44%