Spreadsheet: 046fd268-e5b4-43af-8729-df4122ece850
Sheet: SFY 2014 Budget for 20140328

 |  |  |  |  |  |  |  |  |  |  |  | Collapse
 |  |  |  |  |  | Claims  Report* | % of Year Complete |  |  |  |  | 2013-07-01 00:00:00
[NAME] as of 3/28/2014 |  |  |  |  |  | 2014-03-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 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 |  |  |  | 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 |  |  |  |  |  |  |  |  |  | Row Labels
DHW - IDHW - ATR-III - Administrative |  |  | 1 |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - Adolescent - Medicaid | 1 | 14578.98000000002 |  |  | DHW - IDHW - Adolescent - Medicaid |  |  |  | DHW - IDHW - Adolescent - Medicaid | 1 | DHW - IDHW - Adolescent - Medicaid | 14578.98000000002 |  |  |  | DHW - IDHW - Adolescent - Medicaid | 1 | 14578.98000000002 |  |  |  |  |  |  |  | DHW - IDHW - Adolescent - Medicaid | 1 | 14578.98000000002
DHW - IDHW - ATR-III Adolescent Benefit |  |  | 1 |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - Adult | 56 | 75177.19000000002 |  |  | DHW - IDHW - Adult |  |  |  | DHW - IDHW - Adult | 56 | DHW - IDHW - Adult | 75177.19000000002 |  |  |  | DHW - IDHW - Adult | 56 | 75177.19000000002 |  |  |  |  |  |  |  | DHW - IDHW - Adult | 56 | 75177.19000000002
DHW - IDHW - ATR-III Adolescent Benefit - Medicaid |  |  | 0.3 |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - Adult - Medicaid | 1 | 2781.259999999998 |  |  | DHW - IDHW - Adult - Medicaid |  |  |  | DHW - IDHW - Adult - Medicaid | 1 | DHW - IDHW - Adult - Medicaid | 2781.259999999998 |  |  |  | DHW - IDHW - Adult - Medicaid | 1 | 2781.259999999998 |  |  |  |  |  |  |  | DHW - IDHW - Adult - Medicaid | 1 | 2781.259999999998
DHW - IDHW - ATR-III Military Benefit |  |  | 1 |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III - Administrative | 99 | 4101.939999999995 |  |  | DHW - IDHW - ATR-III - Administrative |  |  |  | DHW - IDHW - ATR-III - Administrative | 99 | DHW - IDHW - ATR-III - Administrative | 4101.939999999995 |  |  |  | DHW - IDHW - ATR-III - Administrative | 99 | 4101.939999999995 |  |  |  |  |  |  |  | DHW - IDHW - ATR-III - Administrative | 99 | 4101.939999999995
DHW - IDHW - ATR-III Military Benefit - Medicaid |  |  | 0.3 |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Adolescent Benefit | 113 | 88558.09999999998 |  |  | DHW - IDHW - ATR-III Adolescent Benefit |  |  |  | DHW - IDHW - ATR-III Adolescent Benefit | 113 | DHW - IDHW - ATR-III Adolescent Benefit | 88558.09999999998 |  |  |  | DHW - IDHW - ATR-III Adolescent Benefit | 113 | 88558.09999999998 |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Adolescent Benefit | 113 | 88558.09999999998
DHW - IDHW - ATR-III Misdemeanor |  |  | 1 |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 28 | 6021.910000000001 |  |  | DHW - IDHW - ATR-III Adolescent Benefit - Medicaid |  |  |  | DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 28 | DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 6021.910000000001 |  |  |  | DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 28 | 6021.910000000001 |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 28 | 6021.910000000001
DHW - IDHW - ATR-III Misdemeanor - Medicaid |  |  | 0.3 |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Military Benefit | 328 | 306980.7199999999 |  |  | DHW - IDHW - ATR-III Military Benefit |  |  |  | DHW - IDHW - ATR-III Military Benefit | 328 | DHW - IDHW - ATR-III Military Benefit | 306980.7199999999 |  |  |  | DHW - IDHW - ATR-III Military Benefit | 328 | 306980.7199999999 |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Military Benefit | 328 | 306980.7199999999
ATR Total |  |  |  |  |  | 2724921 |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Military Benefit - Medicaid | 27 | 27229.47 |  |  | DHW - IDHW - ATR-III Military Benefit - Medicaid |  |  |  | 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 | 27229.47 |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Military Benefit - Medicaid | 27 | 27229.47
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Misdemeanor | 1667 | 1472997.710000003 |  |  | DHW - IDHW - ATR-III Misdemeanor |  |  |  | DHW - IDHW - ATR-III Misdemeanor | 1667 | DHW - IDHW - ATR-III Misdemeanor | 1472997.710000003 |  |  |  | DHW - IDHW - ATR-III Misdemeanor | 1667 | 1472997.710000003 |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Misdemeanor | 1667 | 1472997.710000003
[NAME] |  |  | 1 |  | 0 |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Misdemeanor - Medicaid | 107 | 63029.94999999998 |  |  | DHW - IDHW - ATR-III Misdemeanor - Medicaid |  |  |  | DHW - IDHW - ATR-III Misdemeanor - Medicaid | 107 | DHW - IDHW - ATR-III Misdemeanor - Medicaid | 63029.94999999998 |  |  |  | DHW - IDHW - ATR-III Misdemeanor - Medicaid | 107 | 63029.94999999998 |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Misdemeanor - Medicaid | 107 | 63029.94999999998
Adult-Medicaid |  |  | 0.3 |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - Child Protection Drug Court | 41 | 55641.69 |  |  | DHW - IDHW - Child Protection Drug Court | 41 | 55641.69
Adult Total |  |  |  |  |  | 100000 |  |  |  |  |  |  |  | DHW - IDHW - CP/SUD | 512 | 662215.7799999998 |  |  | DHW - IDHW - CP/SUD |  |  |  | DHW - IDHW - CP/SUD | 512 | DHW - IDHW - CP/SUD | 662215.7799999998 |  |  |  | DHW - IDHW - CP/SUD | 512 | 662215.7799999998 |  |  |  |  |  |  |  | DHW - IDHW - CP/SUD | 512 | 662215.7799999998
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - CP/SUD - Medicaid | 80 | 43829.51000000001 |  |  | DHW - IDHW - CP/SUD - Medicaid |  |  |  | DHW - IDHW - CP/SUD - Medicaid | 80 | DHW - IDHW - CP/SUD - Medicaid | 43829.51000000001 |  |  |  | DHW - IDHW - CP/SUD - Medicaid | 80 | 43829.51000000001 |  |  |  |  |  |  |  | DHW - IDHW - CP/SUD - Medicaid | 80 | 43829.51000000001
Adolescent |  |  | 1 |  | 0 |  |  |  |  |  |  |  |  | DHW - IDHW - DV Court Misdemeanant | 274 | 348633.3199999998 |  |  | DHW - IDHW - DV Court Misdemeanant |  |  |  | DHW - IDHW - DV Court Misdemeanant | 274 | DHW - IDHW - DV Court Misdemeanant | 348633.3199999998 |  |  |  | DHW - IDHW - DV Court Misdemeanant | 274 | 348633.3199999998 |  |  |  |  |  |  |  | DHW - IDHW - DV Court Misdemeanant | 274 | 348633.3199999998
Adolescent-Medicaid |  |  | 0.3 |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - DV Court Misdemeanant - Medicaid | 22 | 20925.06 |  |  | DHW - IDHW - DV Court Misdemeanant - Medicaid |  |  |  | DHW - IDHW - DV Court Misdemeanant - Medicaid | 22 | DHW - IDHW - DV Court Misdemeanant - Medicaid | 20925.06 |  |  |  | DHW - IDHW - DV Court Misdemeanant - Medicaid | 22 | 20925.06 |  |  |  |  |  |  |  | DHW - IDHW - DV Court Misdemeanant - Medicaid | 22 | 20925.06
Adolescent Total |  |  |  |  |  | 100000 |  |  |  | -399744.5916920371 |  |  |  | DHW - IDHW - IVDU | 773 | 965146.2300000002 |  |  | DHW - IDHW - IVDU |  |  |  | DHW - IDHW - IVDU | 773 | DHW - IDHW - IVDU | 965146.2300000002 |  |  |  | DHW - IDHW - IVDU | 773 | 965146.2300000002 |  |  |  |  |  |  |  | DHW - IDHW - IVDU | 773 | 965146.2300000002
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - IVDU - Medicaid | 54 | 76883.58000000005 |  |  | DHW - IDHW - IVDU - Medicaid |  |  |  | DHW - IDHW - IVDU - Medicaid | 54 | DHW - IDHW - IVDU - Medicaid | 76883.58000000005 |  |  |  | DHW - IDHW - IVDU - Medicaid | 54 | 76883.58000000005 |  |  |  |  |  |  |  | DHW - IDHW - IVDU - Medicaid | 54 | 76883.58000000005
CP-SUD |  |  | 1 |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - Medicaid Only | 925 | 480467.0099999987 |  |  | DHW - IDHW - Medicaid Only |  |  |  | DHW - IDHW - Medicaid Only | 925 | DHW - IDHW - Medicaid Only | 480467.0099999987 |  |  |  | DHW - IDHW - Medicaid Only | 925 | 480467.0099999987 |  |  |  |  |  |  |  | DHW - IDHW - Medicaid Only | 925 | 480467.0099999987
CP-SUD - Medicaid |  |  | 0.3 |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - PWWC | 276 | 451231.6800000001 |  |  | DHW - IDHW - PWWC |  |  |  | DHW - IDHW - PWWC | 276 | DHW - IDHW - PWWC | 451231.6800000001 |  |  |  | DHW - IDHW - PWWC | 276 | 451231.6800000001 |  |  |  |  |  |  |  | DHW - IDHW - PWWC | 276 | 451231.6800000001
CP-SUD Total |  |  |  |  |  | 750000 |  |  |  |  |  |  |  | DHW - IDHW - PWWC - Medicaid | 156 | 216396.0699999999 |  |  | DHW - IDHW - PWWC - Medicaid |  |  |  | DHW - IDHW - PWWC - Medicaid | 156 | DHW - IDHW - PWWC - Medicaid | 216396.0699999999 |  |  |  | DHW - IDHW - PWWC - Medicaid | 156 | 216396.0699999999 |  |  |  |  |  |  |  | DHW - IDHW - PWWC - Medicaid | 156 | 216396.0699999999
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - State Hospital | 178 | 244443.23 |  |  | DHW - IDHW - State Hospital |  |  |  | DHW - IDHW - State Hospital | 178 | DHW - IDHW - State Hospital | 244443.23 |  |  |  | DHW - IDHW - State Hospital | 178 | 244443.23 |  |  |  |  |  |  |  | DHW - IDHW - State Hospital | 178 | 244443.23
DV Court |  |  | 1 |  | 0 |  |  |  |  |  |  |  |  | DHW - IDHW - State Hospital - Medicaid | 26 | 18509.69 |  |  | DHW - IDHW - State Hospital - Medicaid |  |  |  | DHW - IDHW - State Hospital - Medicaid | 26 | DHW - IDHW - State Hospital - Medicaid | 18509.69 |  |  |  | DHW - IDHW - State Hospital - Medicaid | 26 | 18509.69 |  |  |  |  |  |  |  | DHW - IDHW - State Hospital - Medicaid | 26 | 18509.69
DV Court- Medicaid |  |  | 0.3 |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - Unknown / Ineligible | 1352 | 17127.52 |  |  | DHW - IDHW - Unknown / Ineligible |  |  |  | DHW - IDHW - Unknown / Ineligible | 1352 | DHW - IDHW - Unknown / Ineligible | 17127.52 |  |  |  | DHW - IDHW - Unknown / Ineligible |  |  |  |  |  |  |  |  |  | DHW - IDHW - Unknown / Ineligible | 1334 | 18458.93000000002
DV Court Misdemeanant Total |  |  |  |  |  | 429000 |  |  |  |  |  |  |  | DHW - PSC - Mental Health Court | 82 | 100747.77 |  |  | DHW - PSC - Mental Health Court |  |  |  | DHW - PSC - Mental Health Court | 82 | DHW - PSC - Mental Health Court | 100747.77 |  |  |  | DHW - PSC - Mental Health Court | 82 | 100747.77 |  |  |  |  |  |  |  | DHW - PSC - Mental Health Court | 82 | 100747.77
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DHW - PSC - Mental Health Court - Medicaid | 29 | 44719.39999999999 |  |  | DHW - PSC - Mental Health Court - Medicaid |  |  |  | DHW - PSC - Mental Health Court - Medicaid | 29 | DHW - PSC - Mental Health Court - Medicaid | 44719.39999999999 |  |  |  | DHW - PSC - Mental Health Court - Medicaid | 29 | 44719.39999999999 |  |  |  |  |  |  |  | DHW - PSC - Mental Health Court - Medicaid | 29 | 44719.39999999999
IVDU |  |  | 1 |  |  |  |  |  |  |  |  |  |  | DHW - PSC - Misdemeanor / DUI Court | 152 | 109269.24 |  |  | DHW - PSC - Misdemeanor / DUI Court |  |  |  | DHW - PSC - Misdemeanor / DUI Court | 152 | DHW - PSC - Misdemeanor / DUI Court | 109269.24 |  |  |  | DHW - PSC - Misdemeanor / DUI Court | 152 | 109269.24 |  |  |  |  |  |  |  | DHW - PSC - Misdemeanor / DUI Court | 152 | 109269.24
IVDU - Medicaid |  |  | 0.3 |  |  |  |  |  |  |  |  |  |  | DHW - PSC - Misdemeanor / DUI Court - Medicaid | 0 | 0 |  |  | DHW - PSC - Misdemeanor / DUI Court - Medicaid |  |  |  | DHW - PSC - Misdemeanor / DUI Court - Medicaid |  | DHW - PSC - Misdemeanor / DUI Court - Medicaid |  |  |  |  | Unknown |  |  |  |  |  |  |  |  |  | Unknown | 18 | -1331.41
IVDU Total |  |  |  |  |  | 1000000 |  |  |  |  |  |  |  | Grand Total | 7318 | 5862002.320000002 |  |  | Grand Total |  |  |  | Grand Total | 7318 | Grand Total | 5862002.320000002 |  |  |  | Grand Total | 7318 | 5862002.320000001 |  |  |  |  |  |  |  | Grand Total | 7318 | 5862002.320000001
PWWC |  |  | 1
PWWC - Medicaid |  |  | 0.3
PWWC Total |  |  |  |  |  | 450000
State Hospital |  |  | 1
State Hospital - Medicaid |  |  | 0.3
State Hospital Total |  |  |  |  |  | 325000
Mental Health Court |  |  | 1
Mental Health Court - Medicaid |  |  | 0.3
Mental Health Court Total |  |  |  |  |  | 300000
Misdemeanant PSC |  |  | 1
Misdemeanant PSC - Medicaid |  |  | 0.3
Misdemeanant PSC Total |  |  |  |  |  | 275000
Medicaid Only |  |  | 0.3
Medicaid Only Total |  |  |  |  |  | 916667
Unknown / Ineligible / Reserve |  |  | 1 |  |  | 546455
Direct Client Treatment Delivery Services |  | 312859 |  |  |  | 546455
Non-Medicaid Total
Medicaid Total
Grand Total
V:\BPA Invoices New\2014\20140328\Claims Reports\DHW SR056_SFY14_6-7-13 - 3-13-14_Claims Report.xlsx
[NAME]
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