Loading...
HomeMy WebLinkAbout06/2012COMPLETE COPY ON FILE IN TOWN CLERK'S OFFICE TOWN OF SOUTHOLD RECEIVED JUL 2 0 20R Southold Town Clerk BUDGET REPORT FOR THE MONTH ENDED JUNE 30; 2012 Prepared: July 20, 2012 Accounting & Finance Dept. **** TOWN OF SOUTNOLD **** EMPLOYEE HEALTH CARE PLAN ISLAND GROUP 7/ 9/12 CLAIM LAG REPORT - AMOUNT BILLED PLAN YEAR 7/ 1/11 - 6/30/12 CLAIMS All Units MONTH OF PAYMENT JUL 11 AUG 11 SEP 11 OCT 11 NOV 11 DEC 11 JAN 12 FEB 12 MAR 12 APR 12 MAY 12 JUN 12 ................................................................... MONTH OF SERVICE ................................................................... JUL 11 35448.18 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0,00 0.00 0.00 AUG 11 354657.80 104874.47 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 BEP 11 85459.38 372345.88 77408.51 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 OCT 11 65540.63 263419.46 390659.01 94155.15 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 NOV 11 4585.63 54258.46 101015.19 247656.30 99601.27 0.00 0.00 0.00 0.00 0.00 0.00 0.00 DEC 11 12235.24 4202.50 32032.99 123731.99 282202.92 72534.55 0.00 0.00 0.00 0.00 0.00 0.00 JAN 12 23400.86 19629.03 75189.53 100359.89 325468.10 439403.22 95280.02 0.00 0.00 0.00 0.00 0.00 FEB 12 8637.18 2613.43 17160.36 5364.54 23343.72 107699.19 49<2012.98 132461.93 0.00 0.00 0.00 0.00 MAR 12 367.55 1783.78 4189.15 1875.10 12007.00 16017.25 241252.32 360738.95 86614.42 0.00 0.00 0.00 APR 12 2623.33 2283.00 15956.91 4089.75 10689.05 13876.01 24498.49 125538.75 569600.33 131759.88 0.00 0.00 MAY 12 757.14 1561.70 8393.00 2585.00 10525.27 3489.46 21025.65 21643.25 148252.52 468785.43 144748.68 0.00 JUN 12 0.00 100.00 403.58 100.00 2946.55 1400.00 4427.78 14021.30 14928.50 25314.12 309500.30 96009.00 TOTAL 593712.92 827071.71 722408.23 579717.72 766783.88 654419.68 885497.24 654404.18 819395.77 623859.43 454248.98 96009.00 TOTAL 35448.18 459532.27 535213.77 813774.25 507116.85 526940.19 1078730.65 796293.33 724845.52 900915.50 831567.10 467151.13 7677528.74 RECEIVED JUL 2 5 2012 Southold Town Clerk **** TOWN OF SOUTHOLD EMPLOYEE HEALTH CARE PLAN ISLAND GROUP 7/ 9/12 CLAIM LAG REPORT - AMOUNT PAID PLAN YEAR 7/ 1/11 - 6/30/12 CLAIMS At[ Units MONTH OF PAYMENT JUL 11 AUG 11 OCT 11 NOV 11 DEC 11 JAN 12 FEB 12 MAR 12 APR 12 MAY 12 JUN 12 ................................................................... MONTH OF SERVICE ................................................................... JUL 11 AUG 11 SEP 11 OCT 11 NOV 11 DEC 11 JAN 12 FEB 12 MAR 12 APR 12 MAY 12 JUN 12 RET PAY TOTAL 15175.10 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 15175.10 203192.49 70930.28 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 166.00 273956.77 36976.26 122849.25 55467.84 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0,00 0.00 628.00 214665.35 7813.98 113856.62 187498.01 58681.13 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 545.00 367304.74 1569.34 5149.44 34083.23 138150.63 69159.01 0.00 0.00 0.00 0.00 0.00 0.00 0.00 954.92 247156.73 640.42 780.64 9948.56 32191.98 153172.52 54046.85 0.00 0.00 0.00 0.00 0.00 0.00 343.00 250437.97 5821.60 7236.35 6335.54 1946.95 30148.80 199542.41 59201.55 0.00 0.00 0.00 0.00 0.00 546.00 309687.20 3558.28 227.46 391.53 2647.26 7050.65 29064.58 2~905.71 89567.29 0.00 0.00 0.00 0.00 556.15 398856.61 171.20 849.76 208.77 118.56 3298.49 6435.27 57025.39 179980.70 61568.04 0.00 0.00 0.00 527.39 309128.79 539.20 1153.00 9542.19 246.44 5167.38 1234.87 4585.86 34861.08 316322.43 71332.81 0.00 0.00 654.37 444328.89 338.69 359.53 2976.82 1090.40 628.08 160.70 14621.83 4502.11 76041.39 281041.94 89554.25 0.00 312.90 471002.84 0.00 25.00 220.00 0.00 41.15 0.00 1575.81 6266.89 3262.20 11727.17 185708.59 68706.58 835.94 276697.45 TOTAL 275796.56 323417.33 306672.49 235073.35 268666.08 290484.68 403914.15 315178.07 457194.06 364101.92 275262.84 68706.58 6069.67 3578398.44 TOWN OF SOUTHOLD PROCEDURE FREQUENCY REPORT EMPLOYEE HEALTH BENEFIT PLANS ISLAND GROUP PROCESS DATES: 6/ 1/12 - 6/30/12 CLient TotaLs PAGE 1 BATE 7/ 9/12 PROC CATEGORY DESCRIPTION MUM SVCS TOT.BILLED 7054 DIAGNOSTIC 7055 XRAY 7151 OTHER 7189 MENTAL OR NE 7221 THERAPY 9000 OFFICE VISIT 9001 EMERGENCY RO 9002 AUDIT/CONSUL 9004 AUDIT/CONSUL 9005 PREVENTATIVE 9006 PREVENTATIVE 9007 MENTAL OR NE 9009 OFFICE VISIT 9010 DOCTOR SERVI 9011 HOSPITAL RO0 9012 SURGERY 9013 EMERGENCY RO 9014 MEDICAL SUPP 9015 XRAY 9019 LABORATORY S 9020 SURGERY 9025 DIAGNOSTIC 9026 OFFICE VISIT 9040 OTHER 9045 THERAPY 9050 AUDIT/COMSUL 9055 PRESCRIPTION 9070 DIAGNOSTIC 9080 XRAY 9081XRAY 6001 HOSPITAL RO0 BOSPITAL ROOM AND BOARD 6030 SURGERY SURGERY 6060 OFFICE VISIT PHYSICIAN OFFICE VISIT 7001 EMERGENCY RO PHYB TREATMENT MED EMERG MEDICAL TESTING XRAY INTERP DURABLE MED EQUIP M/N OFFICE VISIT PHYSIOTNERAPY PP OFFICE VISIT PP ER VISIT PP COB PP DIABETIC SUPPLIES IMMUNIZATIONS PP INJECTIONS PP M/N PP WELL CARE PP HOSPITAL VISIT PP HOSPITAL ROOM AND BOARD PP AMBULATORY OUT PATIENT SURGERY PP EMERGENCY TREATMENT MEDICAL EMERGENCY PP DURABLE MED EQUIP PP X-RAY OUT PATIENT PP LABORATORY OUT PATIENT PP SURGERY P P TESTING PP ALLERGY PP CHIROPRACTIC PP PHYSICAL THERAPY PP CONSULTATION RX PHARMACARE PP MAMMOGRAPHy PP RADIOLOGY PP XRAY INTERP 9085 DIAGNOSTIC PP EKG 9090 ANESTNEBIA PP ANESTHESIA 9095 LABORATORY S PP LAB 9099 MISCELLANEOU PP MISCELLANEOUS 9100 OTHER MULTIPLAN DISCOUNT FEE 9105 MIBCELLANEOU PSI HOSP DISCOUNT FEE 9108 AUDIT/CONSUL NYS SURCHARGE 9109 MISCELLANEOU NYS GME'S 9135 MISCELLANEOU PP IVF OFFICE VISIT 9180 MISCELLANEOU PP IVF RADIOLOGY 9195 MISCELLANEOU PP IVF LAB 9201 TNERAPY PP ACUPUNCTURE 9204 TBERAPY PP EPIDURALS 9207 THERAPY PP MRI AVE.BILLED TOT.PAID AVE.PAID 3 72977.40 24325.80 30571.00 10190.33 2 8500.00 4250.00 4897.39 2448.70 3 715.00 238.33 0.00 0.00 1 400.00 400.00 0.00 0.00 6 8617.00 1436.17 4571.38 761.90 1 -30.00 -30,00 -24.00 -24.00 3 570.00 190.00 30.32 10.11 8 1450.00 181.25 384.00 48.00 2 165,00 82,50 6,92 3.46 142 23288.76 164.01 11445.92 80.61 5 3370.00 674.00 1240,00 248.00 169 41447,46 245.25 3059.00 18.10 7 663.90 94.84 478.37 68.34 9 1045.00 116.11 481.00 53.44 18 1581.66 87.87 482.10 26.78 57 6845.00 120.09 3640.00 63.86 11 2730.00 248.18 1088.00 98.91 1 400,00 400,00 145.00 145.00 1 14135,10 14135.10 9686.46 9686.46 8 38660.33 4832.54 30149.36 3768.67 4 11006.77 2751.69 8421.16 2105.29 4 1279.80 319.95 815.97 203.99 6 10428.40 1738,07 8200.97 1366.83 15 7237.21 482.48 5544.67 369.64 31 17155.35 553.40 5844.00 188.52 38 8942.27 235.32 4739.00 124.71 29 1958.00 67.52 1289.00 44.45 11 539.00 49,00 180.00 16.36 24 2615.38 108.97 932.34 38.85 18 6137,09 340.95 3445.00 191.39 2 72282,46 36141.23 72202.46 36141.23 10 2275.00 227.50 925.00 92.50 29 9772.42 336.98 3746,00 129.17 26 4477.00 172.19 1110.41 42.71 16 1016.09 63.51 402.09 25.13 4 7420.00 1855.00 3272.80 818.20 293 29201.54 99.66 9781.43 33.38 7 1537.93 219.70 1187.93 169.70 19 1893.22 99.64 1893.22 99.64 13 13824.24 1063.40 13824.24 1063.40 I 20222.00 20222.00 20222.00 20222.00 1 2088.00 2088.00 2088.00 2088.00 5 520.00 104.00 246.00 49.20 5 1125.00 225.00 800.00 160.00 24 1405.00 58.54 722.50 30.10 6 953.00 155.50 678.00 113.00 4 3613.12 903.28 1124.00 281.00 1 1200.00 1200,00 635.00 635.00 CLIENT TOTALS 1103 469636.90 425.78 276685,41 250.85