Spreadsheet: 036d92b6-2e0b-4521-9425-37e4494a4202
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Collapse | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | Unnamed: 29 | Unnamed: 30 | Unnamed: 31 | Unnamed: 32
 |  |  |  |  |  | Claims  Report* | % of Year Complete |  |  |  |  | 2013-07-01 00:00:00
[NAME] as of 9/30/2013 |  |  |  |  |  | 2013-09-30 00:00:00 | 0.25
 |  |  |  |  |  |  |  |  |  |  |  | 91 |  | Paste Reduction Table Here- If it matches |  |  |  |  | Rection Table |  |  |  | Paste Claims PT Here
Insurer | Client Count  (YTD) | Sum of Paid  Plus Incentive | %  of Non-Medicaid | Non-Medicaid Total | Medicaid Total | Budget | % of Budget |  | Projected EOY Total GF Spending | Amount Over (Under) GF Budget |  | 6.5 |  | Row Labels | Count of Sum of Paid Plus Incentive | Sum of Sum of Paid Plus Incentive |  |  | Row Labels | Count of Sum of Paid Plus Incentive | Sum of Sum of Paid Plus Incentive |  | Row Labels | Count of Sum of Paid Plus Incentive | Row Labels | Sum of Sum of Paid Plus Incentive |  |  | Row Labels | Count of Sum of Paid Plus Incentive | Row Labels | Sum of Sum of Paid Plus Incentive
DHW - IDHW - ATR-III - Administrative | 58 | 2912.049999999999 | 1 | 2912.049999999999 | 0 |  |  |  |  |  |  |  |  | DHW - IDHW - Adolescent - Medicaid | 1 | 14578.98000000002 |  |  | DHW - IDHW - Adolescent - Medicaid | 1 | 14578.98000000002 |  | DHW - IDHW - Adolescent - Medicaid | 1 | DHW - IDHW - Adolescent - Medicaid | 14578.98000000002 |  |  | DHW - IDHW - Adolescent - Medicaid | 1 | DHW - IDHW - Adolescent - Medicaid | 14578.98000000002
DHW - IDHW - ATR-III Adolescent Benefit | 28 | 3062.789999999998 | 1 | 3062.789999999998 | 0 |  |  |  |  |  |  |  |  | DHW - IDHW - Adult | 24 | 25185.86 |  |  | DHW - IDHW - Adult | 24 | 25185.86 |  | DHW - IDHW - Adult | 24 | DHW - IDHW - Adult | 25185.86 |  |  | DHW - IDHW - Adult | 24 | DHW - IDHW - Adult | 25185.86
DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 27 | 5818.170000000001 | 0.3 | 1745.451 | 4072.719000000001 |  |  |  |  |  |  |  |  | DHW - IDHW - Adult - Medicaid | 1 | 2781.259999999998 |  |  | DHW - IDHW - Adult - Medicaid | 1 | 2781.259999999998 |  | DHW - IDHW - Adult - Medicaid | 1 | DHW - IDHW - Adult - Medicaid | 2781.259999999998 |  |  | DHW - IDHW - Adult - Medicaid | 1 | DHW - IDHW - Adult - Medicaid | 2781.259999999998
DHW - IDHW - ATR-III Military Benefit | 192 | 130712.67 | 1 | 130712.67 | 0 |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III - Administrative | 58 | 2912.049999999999 |  |  | DHW - IDHW - ATR-III - Administrative | 58 | 2912.049999999999 |  | DHW - IDHW - ATR-III - Administrative | 58 | DHW - IDHW - ATR-III - Administrative | 2912.049999999999 |  |  | DHW - IDHW - ATR-III - Administrative | 58 | DHW - IDHW - ATR-III - Administrative | 2912.049999999999
DHW - IDHW - ATR-III Military Benefit - Medicaid | 27 | 27229.47 | 0.3 | 8168.840999999999 | 19060.629 |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Adolescent Benefit | 28 | 3062.789999999998 |  |  | DHW - IDHW - ATR-III Adolescent Benefit | 28 | 3062.789999999998 |  | DHW - IDHW - ATR-III Adolescent Benefit | 28 | DHW - IDHW - ATR-III Adolescent Benefit | 3062.789999999998 |  |  | DHW - IDHW - ATR-III Adolescent Benefit | 28 | DHW - IDHW - ATR-III Adolescent Benefit | 3062.789999999998
DHW - IDHW - ATR-III Misdemeanor | 913 | 504659.5099999992 | 1 | 504659.5099999992 | 0 |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 27 | 5818.170000000001 |  |  | DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 27 | 5818.170000000001 |  | DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 27 | DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 5818.170000000001 |  |  | DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 27 | DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 5818.170000000001
DHW - IDHW - ATR-III Misdemeanor - Medicaid | 102 | 62189.90999999998 | 0.3 | 18656.97299999999 | 43532.93699999999 |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Military Benefit | 192 | 130712.67 |  |  | DHW - IDHW - ATR-III Military Benefit | 192 | 130712.67 |  | DHW - IDHW - ATR-III Military Benefit | 192 | DHW - IDHW - ATR-III Military Benefit | 130712.67 |  |  | DHW - IDHW - ATR-III Military Benefit | 192 | DHW - IDHW - ATR-III Military Benefit | 130712.67
ATR Total | 1347 | 736584.5699999993 |  | 669918.2849999991 | 66666.28499999999 | 2724921 | 0.2458486998338664 |  | 2679673.139999996 | -45247.86000000359 |  |  |  | DHW - IDHW - ATR-III Military Benefit - Medicaid | 27 | 27229.47 |  |  | DHW - IDHW - ATR-III Military Benefit - Medicaid | 27 | 27229.47 |  | DHW - IDHW - ATR-III Military Benefit - Medicaid | 27 | DHW - IDHW - ATR-III Military Benefit - Medicaid | 27229.47 |  |  | DHW - IDHW - ATR-III Military Benefit - Medicaid | 27 | DHW - IDHW - ATR-III Military Benefit - Medicaid | 27229.47
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Misdemeanor | 913 | 504659.5099999992 |  |  | DHW - IDHW - ATR-III Misdemeanor | 913 | 504659.5099999992 |  | DHW - IDHW - ATR-III Misdemeanor | 913 | DHW - IDHW - ATR-III Misdemeanor | 504659.5099999992 |  |  | DHW - IDHW - ATR-III Misdemeanor | 913 | DHW - IDHW - ATR-III Misdemeanor | 504659.5099999992
[NAME] | 24 | 25185.86 | 1 | 25185.86 | 0 |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Misdemeanor - Medicaid | 102 | 62189.90999999998 |  |  | DHW - IDHW - ATR-III Misdemeanor - Medicaid | 102 | 62189.90999999998 |  | DHW - IDHW - ATR-III Misdemeanor - Medicaid | 102 | DHW - IDHW - ATR-III Misdemeanor - Medicaid | 62189.90999999998 |  |  | DHW - IDHW - ATR-III Misdemeanor - Medicaid | 102 | DHW - IDHW - ATR-III Misdemeanor - Medicaid | 62189.90999999998
Adult-Medicaid | 1 | 2781.259999999998 | 0.3 | 834.3779999999995 | 1946.881999999999 |  |  |  |  |  |  |  |  | DHW - IDHW - Child Protection Drug Court | 0 | 0 |  |  | DHW - IDHW - Child Protection Drug Court | 0 | 0
Adult Total | 25 | 27967.12 |  | 26020.238 | 1946.881999999999 | 100000 | 0.2602023800000001 |  | 2836123.718047921 | 2736123.718047921 |  |  |  | DHW - IDHW - CP/SUD | 242 | 152060.1499999998 |  |  | DHW - IDHW - CP/SUD | 242 | 152060.1499999998 |  | DHW - IDHW - CP/SUD | 242 | DHW - IDHW - CP/SUD | 152060.1499999998 |  |  | DHW - IDHW - CP/SUD | 242 | DHW - IDHW - CP/SUD | 152060.1499999998
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - CP/SUD - Medicaid | 77 | 43211.89 |  |  | DHW - IDHW - CP/SUD - Medicaid | 77 | 43211.89 |  | DHW - IDHW - CP/SUD - Medicaid | 77 | DHW - IDHW - CP/SUD - Medicaid | 43211.89 |  |  | DHW - IDHW - CP/SUD - Medicaid | 77 | DHW - IDHW - CP/SUD - Medicaid | 43211.89
Adolescent |  |  | 1 | 0 | 0 |  |  |  |  |  |  |  |  | DHW - IDHW - DV Court Misdemeanant | 143 | 128426.07 |  |  | DHW - IDHW - DV Court Misdemeanant | 143 | 128426.07 |  | DHW - IDHW - DV Court Misdemeanant | 143 | DHW - IDHW - DV Court Misdemeanant | 128426.07 |  |  | DHW - IDHW - DV Court Misdemeanant | 143 | DHW - IDHW - DV Court Misdemeanant | 128426.07
Adolescent-Medicaid | 1 | 14578.98000000002 | 0.3 | 4373.694000000006 | 10205.28600000001 |  |  |  |  |  |  |  |  | DHW - IDHW - DV Court Misdemeanant - Medicaid | 22 | 20862.99 |  |  | DHW - IDHW - DV Court Misdemeanant - Medicaid | 22 | 20862.99 |  | DHW - IDHW - DV Court Misdemeanant - Medicaid | 22 | DHW - IDHW - DV Court Misdemeanant - Medicaid | 20862.99 |  |  | DHW - IDHW - DV Court Misdemeanant - Medicaid | 22 | DHW - IDHW - DV Court Misdemeanant - Medicaid | 20862.99
Adolescent Total | 1 | 14578.98000000002 |  | 4373.694000000006 | 10205.28600000001 | 100000 | 0.04373694000000006 |  | 1210.408307962904 | -399744.5916920371 |  |  |  | DHW - IDHW - IVDU | 440 | 201548.1299999996 |  |  | DHW - IDHW - IVDU | 440 | 201548.1299999996 |  | DHW - IDHW - IVDU | 440 | DHW - IDHW - IVDU | 201548.1299999996 |  |  | DHW - IDHW - IVDU | 440 | DHW - IDHW - IVDU | 201548.1299999996
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - IVDU - Medicaid | 53 | 71174.32999999999 |  |  | DHW - IDHW - IVDU - Medicaid | 53 | 71174.32999999999 |  | DHW - IDHW - IVDU - Medicaid | 53 | DHW - IDHW - IVDU - Medicaid | 71174.32999999999 |  |  | DHW - IDHW - IVDU - Medicaid | 53 | DHW - IDHW - IVDU - Medicaid | 71174.32999999999
CP-SUD | 242 | 152060.1499999998 | 1 | 152060.1499999998 |  |  |  |  |  |  |  |  |  | DHW - IDHW - Medicaid Only | 912 | 477522.6099999988 |  |  | DHW - IDHW - Medicaid Only | 912 | 477522.6099999988 |  | DHW - IDHW - Medicaid Only | 912 | DHW - IDHW - Medicaid Only | 477522.6099999988 |  |  | DHW - IDHW - Medicaid Only | 912 | DHW - IDHW - Medicaid Only | 477522.6099999988
CP-SUD - Medicaid | 77 | 43211.89 | 0.3 | 12963.567 | 30248.323 |  |  |  |  |  |  |  |  | DHW - IDHW - PWWC | 146 | 175584 |  |  | DHW - IDHW - PWWC | 146 | 175584 |  | DHW - IDHW - PWWC | 146 | DHW - IDHW - PWWC | 175584 |  |  | DHW - IDHW - PWWC | 146 | DHW - IDHW - PWWC | 175584
CP-SUD Total | 319 | 195272.0399999998 |  | 165023.7169999998 | 30248.323 | 750000 | 0.2200316226666664 |  | 2398275.157073902 | 1648275.157073902 |  |  |  | DHW - IDHW - PWWC - Medicaid | 154 | 211809.66 |  |  | DHW - IDHW - PWWC - Medicaid | 154 | 211809.66 |  | DHW - IDHW - PWWC - Medicaid | 154 | DHW - IDHW - PWWC - Medicaid | 211809.66 |  |  | DHW - IDHW - PWWC - Medicaid | 154 | DHW - IDHW - PWWC - Medicaid | 211809.66
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - State Hospital | 79 | 79558.02999999997 |  |  | DHW - IDHW - State Hospital | 79 | 79558.02999999997 |  | DHW - IDHW - State Hospital | 79 | DHW - IDHW - State Hospital | 79558.02999999997 |  |  | DHW - IDHW - State Hospital | 79 | DHW - IDHW - State Hospital | 79558.02999999997
DV Court | 143 | 128426.07 | 1 | 128426.07 | 0 |  |  |  |  |  |  |  |  | DHW - IDHW - State Hospital - Medicaid | 24 | 16324.93 |  |  | DHW - IDHW - State Hospital - Medicaid | 24 | 16324.93 |  | DHW - IDHW - State Hospital - Medicaid | 24 | DHW - IDHW - State Hospital - Medicaid | 16324.93 |  |  | DHW - IDHW - State Hospital - Medicaid | 24 | DHW - IDHW - State Hospital - Medicaid | 16324.93
DV Court- Medicaid | 22 | 20862.99 | 0.3 | 6258.897 | 14604.093 |  |  |  |  |  |  |  |  | DHW - IDHW - Unknown / Ineligible | 1192 | 16074.39999999997 |  |  | DHW - IDHW - Unknown / Ineligible | 1192 | 16074.39999999997 |  | DHW - IDHW - Unknown / Ineligible | 1192 | DHW - IDHW - Unknown / Ineligible | 16074.39999999997 |  |  | DHW - IDHW - Unknown / Ineligible | 1192 | DHW - IDHW - Unknown / Ineligible | 16074.39999999997
DV Court Misdemeanant Total | 165 | 149289.06 |  | 134684.967 | 14604.093 | 429000 | 0.313950972027972 |  | 3421966.386597733 | 2992966.386597733 |  |  |  | DHW - PSC - Mental Health Court | 44 | 45181.5 |  |  | DHW - PSC - Mental Health Court | 44 | 45181.5 |  | DHW - PSC - Mental Health Court | 44 | DHW - PSC - Mental Health Court | 45181.5 |  |  | DHW - PSC - Mental Health Court | 44 | DHW - PSC - Mental Health Court | 45181.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DHW - PSC - Mental Health Court - Medicaid | 29 | 44343.25999999999 |  |  | DHW - PSC - Mental Health Court - Medicaid | 29 | 44343.25999999999 |  | DHW - PSC - Mental Health Court - Medicaid | 29 | DHW - PSC - Mental Health Court - Medicaid | 44343.25999999999 |  |  | DHW - PSC - Mental Health Court - Medicaid | 29 | DHW - PSC - Mental Health Court - Medicaid | 44343.25999999999
IVDU | 440 | 201548.1299999996 | 1 | 201548.1299999996 |  |  |  |  |  |  |  |  |  | Grand Total | 4930 | 2462812.619999997 |  |  | Grand Total | 4930 | 2462812.619999997 |  | Grand Total | 4930 | Grand Total | 2462812.619999997 |  |  | Grand Total | 4930 | Grand Total | 2462812.619999997
IVDU - Medicaid | 53 | 71174.32999999999 | 0.3 | 21352.299 | 49822.03099999999
IVDU Total | 493 | 272722.4599999996 |  | 222900.4289999996 | 49822.03099999999 | 1000000 | 0.2229004289999996 |  | 2429544.239564431 | 1429544.239564431
PWWC | 146 | 175584 | 1 | 175584
PWWC - Medicaid | 154 | 211809.66 | 0.3 | 63542.89800000001 | 148266.762
PWWC Total | 300 | 387393.66 |  | 239126.898 | 148266.762 | 450000 | 0.5313931066666666 |  | 5792016.94244496 | 5342016.94244496
State Hospital | 79 | 79558.02999999997 | 1 | 79558.02999999997
State Hospital - Medicaid | 24 | 16324.93 | 0.3 | 4897.479000000001 | 11427.451
State Hospital Total | 103 | 95882.95999999998 |  | 84455.50899999998 | 11427.451 | 325000 | 0.2598631046153845 |  | 2832425.723566633 | 2507425.723566633
Mental Health Court | 44 | 45181.5 | 1 | 45181.5
Mental Health Court - Medicaid | 29 | 44343.25999999999 | 0.3 | 13302.978 | 31040.28199999999
Mental Health Court Total | 73 | 89524.75999999998 |  | 58484.478 | 31040.28199999999 | 300000 | 0.19494826 |  | 2124874.43034984 | 1824874.43034984
Misdemeanant PSC |  |  | 1 | 0
Misdemeanant PSC - Medicaid |  |  | 0.3 | 0 | 0
Misdemeanant PSC Total | 0 | 0 |  | 0 | 0 | 275000 | 0
Medicaid Only | 912 | 477522.6099999988 | 0.3 | 143256.7829999996 | 334265.8269999992
Medicaid Only Total | 912 | 477522.6099999988 |  | 143256.7829999996 | 334265.8269999992 | 916667 | 0.1562800700799741 |  | 1703403.379369573 | 786736.3793695727
Unknown / Ineligible / Reserve | 1192 | 16074.39999999997 | 1 | 16074.39999999997 |  | 546455
Non-Medicaid Total |  |  |  | 1764319.397999998 |  | 7917043 | 0.2228508040186213 |  | 7057277.591999992 | -859765.4080000082
Medicaid Total |  |  |  |  | 698493.2219999991 |  |  |  | 0 | 0
Grand Total | 4930 | 2462812.619999997 |  |  | 2462812.619999997 | 7917043 | 0.3110773327870011 |  | 9851250.47999999 | 1934207.479999989
V:\BPA Invoices New\2014\20130927\Claims Reports\DHW SR056_SFY14_6-7-13 - 9-26-13_Claims Report_20130927.xlsx
[NAME] | 0 | 0 | 0 | 0 | 0 | 0
Grand Total | 6196 | 3871765.830000111 | 0.786960501172644 | 3046926.778000006 | 824839.0519999991 | 7182150.000000001 | 0.4242360265380151 |  | 7493792.886432447 | 311642.8864324456
GF |  |  |  | 3046926.778000006 |  | 7182150.000000001 | 0.4242360265380151 |  | 7493792.886432447 | 311642.8864324456
Medicaid |  |  |  |  | 824839.0519999991 |  | 0.2914625625441693 |  | 2028658.208972971 | -801341.7910270293
GF Plus Medicaid |  | 3871765.830000005 |  |  |  |  | 0.3867067343178043 |  | 9522451.095405417 | -489698.9045945834
 | 6196 | 3871765.830000005 |  |  |  | 7182150.000000001 |  |  | 7423408.469135149 | 241258.469135149
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0