Spreadsheet: 0c387165-d6e6-4837-8967-f8b33f20e127
Sheet: Active Claims History by Plan

City of Carrollton
Active Claims History-By Plan
December 2012
2012 |  | Red Plan ($500 Deductible) |  |  |  | White Plan ($1000 Deductible) |  |  |  | Blue Plan ($2500 Deductible) |  |  |  | High Dental |  |  | Low Dental
Period |  | Census | Medical | Prescription |  | Census | Medical | Prescription |  | Census | Medical | Prescription |  | Census | Dental |  | Census | Dental
January |  | 283 | 335378.66 | 57104.97 |  | 318 | 149684.3 | 27083.13 |  | 85 | 4802.29 | 5917.05 |  | 588 | 13186.03 |  | 99 | 18716.58
February |  | 283 | 336718.19 | 56356.98 |  | 313 | 102783.74 | 24547.64 |  | 86 | 13338.98 | 5683.35 |  | 588 | 20710.38 |  | 97 | 16977.78
March |  | 278 | 645044.4 | 51524.21 |  | 316 | 291534.67 | 67036.6 |  | 88 | 22263.09 | 7386.12 |  | 582 | 31052.2 |  | 100 | 20855.43
April |  | 280 | 212587.01 | 55285.88 |  | 317 | 81671.25 | 61355.97 |  | 87 | 8574.3 | 5474.51 |  | 581 | 27097.7 |  | 101 | 17175.69
May |  | 278 | 402622.74 | 58016.72 |  | 314 | 110561.13 | 109821.51 |  | 87 | 4733.08 | 5925.02 |  | 577 | 14193.86 |  | 101 | 12243.51
June |  | 272 | 536076.29 | 56102.27 |  | 314 | 103469.12 | 63151.75 |  | 87 | 52709.08 | 4876.82 |  | 574 | 14665.97 |  | 98 | 14616.22
July |  | 272 | 445414.85 | 49299.62 |  | 314 | 129100.1 | 64469.96 |  | 92 | 15941.55 | 4846.94 |  | 575 | 19228.75 |  | 100 | 17772.94
August |  | 271 | 299134 | 52289.84 |  | 320 | 90753.83 | 59715.47 |  | 92 | 19310.99 | 3913.46 |  | 578 | 19076.33 |  | 99 | 15501.6
September |  | 270 | 404704.81 | 65664.83 |  | 318 | 58724.4 | 62684.63 |  | 91 | 10632.55 | 5521.86 |  | 576 | 18715.69 |  | 98 | 15963.09
October |  | 268 | 291650.44 | 53342.73 |  | 318 | 113465.64 | 65518.28 |  | 90 | 27459.53 | 5903.98 |  | 573 | 25370.34 |  | 97 | 19182.55
November |  | 265 | 236382.14 | 52119.89 |  | 309 | 160080.63 | 65379.53 |  | 94 | 14149.28 | 9976.38 |  | 566 | 20357.99 |  | 98 | 10009.11
December |  | 260 | 392089.45 | 59315.76 |  | 308 | 73435.82 | 89324.18 |  | 94 | 30277.57 | 4893.16 |  | 558 | 27509.82 |  | 98 | 14102.34
Total
2011 |  | Advantage Plan ($500 Deductible) |  |  |  | Basic Plan ($1000 Deductible) |  |  |  | HRA Plan ($2500 Deductible) |  |  |  | High Dental |  |  | Low Dental
Period |  | Census | Medical | Prescription |  | Census | Medical | Prescription |  | Census | Medical | Prescription |  | Census | Dental |  | Census | Dental
January |  | 287 | 340083.79 | 33287.49 |  | 337 | 60176.65 | 19671.63 |  | 58 | 4122.52 | 3043.49 |  | 585 | 35769.42 |  | 105 | 15562.5
February |  | 282 | 227803.96 | 32273.46 |  | 336 | 81123.71 | 31659.79 |  | 57 | 1323.81 | 3615.87 |  | 580 | 20408.93 |  | 102 | 14516.97
March |  | 284 | 284240.96 | 48170.86 |  | 337 | 171884.43 | 24765.86 |  | 58 | 7878.51 | 4781.87 |  | 584 | 21006.37 |  | 103 | 14021.45
April |  | 283 | 154603.76 | 40468.66 |  | 334 | 250998.5 | 24082.51 |  | 55 | 6699.4 | 2577.74 |  | 580 | 18982.29 |  | 102 | 23136.84
May |  | 281 | 181877.04 | 37276.84 |  | 333 | 161078.96 | 35808.77 |  | 55 | 17868.4 | 3870.01 |  | 578 | 21856.33 |  | 100 | 23804.26
June |  | 277 | 234003.82 | 43884.72 |  | 345 | 123787.19 | 22601.91 |  | 54 | 7791.59 | 2497.82 |  | 582 | 17435.84 |  | 105 | 8616.71
July |  | 279 | 197986.33 | 34870.56 |  | 346 | 104302.93 | 26875.54 |  | 54 | 11928.58 | 2219.57 |  | 582 | 22006.52 |  | 107 | 17266.95
August |  | 277 | 357804.48 | 50640.46 |  | 348 | 232850.09 | 39278.85 |  | 54 | 11178.75 | 1680.66 |  | 580 | 25359.74 |  | 107 | 12122.55
September |  | 274 | 275164.17 | 49377.83 |  | 349 | 219967.72 | 25707.03 |  | 54 | 9300.01 | 2789.67 |  | 572 | 14467.71 |  | 108 | 16040.31
October |  | 272 | 172667.11 | 44924.6 |  | 349 | 272651.41 | 30189.83 |  | 54 | 20734.32 | 3151.63 |  | 570 | 16297.01 |  | 109 | 11337.65
November |  | 276 | 175241.85 | 48625.46 |  | 348 | 194571.13 | 42636.43 |  | 54 | 14345.69 | 2713.6 |  | 571 | 12409.2 |  | 110 | 22075.81
December |  | 276 | 421552.14 | 55956.29 |  | 347 | 195410.34 | 35748.4 |  | 56 | 16258.16 | 2863.1 |  | 572 | 25810.49 |  | 111 | 18237.84
Total
2010 |  | Advantage Plan ($0 Deductible) |  |  |  | Basic Plan ($1000 Deductible) |  |  |  | Catastrophic Plan ($2500 Deductible) |  |  |  | High Dental |  |  | Low Dental
Period |  | Med EE | Medical | Prescription |  | Med EE | Medical | Prescription |  | Med EE | Medical | Prescription |  | Census | Dental |  | Census | Dental
January |  | 478 | 249072.33 | 95018.21 |  | 230 | 47277.96 | 16293.29 |  | 16 | 12088.17 | 594.85 |  | 613 | 40007.6 |  | 108 | 12832.06
February |  | 472 | 503693.85 | 87706.1 |  | 229 | 48271.79 | 16635.23 |  | 15 | 1970.85 | 1413.01 |  | 607 | 40052.25 |  | 108 | 12203.45
March |  | 470 | 303709.59 | 87153.75 |  | 230 | 26905.36 | 21948.54 |  | 16 | 11.06 | 529.96 |  | 604 | 41137.48 |  | 108 | 10507.09
April |  | 471 | 232632.75 | 97659.12 |  | 232 | 23782.87 | 19095.8 |  | 16 | 16303.99 | 767.86 |  | 606 | 22557.41 |  | 109 | 15607.74
May |  | 470 | 229922.35 | 77605.2 |  | 230 | 29092.64 | 14715.19 |  | 16 | 1049.39 | 255.6 |  | 603 | 28867.43 |  | 108 | 14196.48
June |  | 466 | 298432.47 | 69088.59 |  | 229 | 33705.17 | 18270.82 |  | 15 | 0 | 828.93 |  | 599 | 32585.28 |  | 108 | 7416.45
July |  | 465 | 318259.49 | 79381.05 |  | 226 | 36964.82 | 16880.32 |  | 15 | 10571.7 | 379.27 |  | 602 | 29995.02 |  | 114 | 9740.55
August |  | 462 | 231923.75 | 79861.42 |  | 226 | 37454.94 | 15452.01 |  | 15 | 602.91 | 195.95 |  | 600 | 38589.27 |  | 114 | 7524.63
September |  | 455 | 223816.71 | 79604.09 |  | 224 | 65857.59 | 21038.87 |  | 15 | 3905.33 | 363.31 |  | 591 | 24453.2 |  | 113 | 6906.3
October |  | 453 | 215185.55 | 75635.52 |  | 222 | 30228.69 | 11627.12 |  | 16 | 4589.52 | 282.39 |  | 586 | 25287.53 |  | 115 | 12796.51
November |  | 451 | 163775.54 | 82630.82 |  | 220 | 49873.55 | 8144.44 |  | 16 | 1812.36 | 58.09 |  | 580 | 22803.23 |  | 115 | 6383.43
December |  | 449 | 258970.04 | 82813.24 |  | 224 | 41889.16 | 18247.08 |  | 17 | 7687.13 | 256.35 |  | 581 | 28282.05 |  | 118 | 6124.49
Total
2009 |  | Advantage Plan ($0 Deductible) |  |  |  | Basic Plan ($1000 Deductible) |  |  |  | Catastrophic Plan ($2500 Deductible) |  |  |  | High Dental |  |  | Low Dental
Period |  | Census | Medical | Prescription |  | Census | Medical | Prescription |  | Census | Medical | Prescription |  | Census | Dental |  | Census | Dental
January |  | 467 | 144464.2 | 74746.23 |  | 240 | 37137.33 | 16970.47 |  | 12 | 0 | 1003.37 |  | 609 | 36532.52 |  | 119 | 11349.94
February |  | 468 | 317533.81 | 70116.43 |  | 239 | 53953.24 | 10632.95 |  | 13 | 196.84 | 1103.34 |  | 611 | 31431.38 |  | 120 | 9181.63
March |  | 470 | 252595.6 | 71956.65 |  | 240 | 54448.97 | 16275.06 |  | 14 | 1075.15 | 2317.13 |  | 612 | 29748.49 |  | 121 | 10690.89
April |  | 471 | 320892.19 | 82717.03 |  | 242 | 193656.87 | 12879.23 |  | 18 | 2078.39 | 1054.9 |  | 614 | 29084.09 |  | 126 | 7026.96
May |  | 471 | 189235.47 | 69179.17 |  | 242 | 132396.92 | 12342.32 |  | 17 | 1348.72 | 1729.05 |  | 613 | 37583.66 |  | 126 | 10802.5
June |  | 474 | 267006.21 | 75992.5 |  | 240 | 29845.46 | 15695.17 |  | 18 | 216.83 | 663.44 |  | 615 | 25112.02 |  | 128 | 8508.89
July |  | 469 | 267755.92 | 71348.52 |  | 236 | 27057.18 | 13367.46 |  | 18 | 587.03 | 661.12 |  | 608 | 29204.02 |  | 128 | 11595.63
August |  | 471 | 224696.19 | 72597.5 |  | 237 | 27898.75 | 11626.42 |  | 18 | 3428.49 | 710.77 |  | 611 | 22766.37 |  | 128 | 5969.2
September |  | 469 | 316013.34 | 85452.7 |  | 232 | 44536.18 | 18423.07 |  | 18 | 3305.87 | 1989.53 |  | 606 | 26421.39 |  | 126 | 3561.2
October |  | 465 | 238312.03 | 95635.95 |  | 233 | 36100.78 | 7661.83 |  | 18 | 3808.41 | 232.91 |  | 604 | 28848.29 |  | 126 | 7097.57
November |  | 464 | 196181.76 | 78279.24 |  | 234 | 72125.83 | 15923.1 |  | 18 | 2731.47 | 926.04 |  | 603 | 29081.12 |  | 125 | 9359.42
December |  | 466 | 361516.7 | 90365.2 |  | 234 | 46882.53 | 17746.51 |  | 18 | 657.35 | 2347.9 |  | 604 | 27061.05 |  | 125 | 5818.83
Total