Spreadsheet: 220ee8d6-1865-48ac-b421-82d9a6e5b9d2
Sheet: SFY 2014 Budget From 20130816

 |  |  |  |  |  |  |  |  |  |  |  | Collapse
 |  |  |  |  |  | Claims  Report* | % of Year Complete |  |  |  |  | 2013-07-01 00:00:00
[NAME] as of 8/16/2013 |  |  |  |  |  | 2013-08-16 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 | Count of Sum of Paid Plus Incentive | Row Labels | Sum of Sum of Paid Plus Incentive
DHW - IDHW - ATR-III - Administrative |  |  | 1 |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - Adolescent - Medicaid | 1 | 12461.01000000001 |  |  | DHW - IDHW - Adolescent - Medicaid |  |  |  | DHW - IDHW - Adolescent - Medicaid | 1 | DHW - IDHW - Adolescent - Medicaid | 12461.01000000001 |  |  | DHW - IDHW - Adolescent - Medicaid | 1 | DHW - IDHW - Adolescent - Medicaid | 12461.01000000001
DHW - IDHW - ATR-III Adolescent Benefit |  |  | 1 |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - Adult | 19 | 10883.58 |  |  | DHW - IDHW - Adult |  |  |  | DHW - IDHW - Adult | 19 | DHW - IDHW - Adult | 10883.58 |  |  | DHW - IDHW - Adult | 19 | DHW - IDHW - Adult | 10883.58
DHW - IDHW - ATR-III Adolescent Benefit - Medicaid |  |  | 0.3 |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - Adult - Medicaid | 1 | 2018.32 |  |  | DHW - IDHW - Adult - Medicaid |  |  |  | DHW - IDHW - Adult - Medicaid | 1 | DHW - IDHW - Adult - Medicaid | 2018.32 |  |  | DHW - IDHW - Adult - Medicaid | 1 | DHW - IDHW - Adult - Medicaid | 2018.32
DHW - IDHW - ATR-III Military Benefit |  |  | 1 |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III - Administrative | 34 | 2119.31 |  |  | DHW - IDHW - ATR-III - Administrative |  |  |  | DHW - IDHW - ATR-III - Administrative | 34 | DHW - IDHW - ATR-III - Administrative | 2119.31 |  |  | DHW - IDHW - ATR-III - Administrative | 34 | DHW - IDHW - ATR-III - Administrative | 2119.31
DHW - IDHW - ATR-III Military Benefit - Medicaid |  |  | 0.3 |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Adolescent Benefit | 24 | 2304.389999999999 |  |  | DHW - IDHW - ATR-III Adolescent Benefit |  |  |  | DHW - IDHW - ATR-III Adolescent Benefit | 24 | DHW - IDHW - ATR-III Adolescent Benefit | 2304.389999999999 |  |  | DHW - IDHW - ATR-III Adolescent Benefit | 24 | DHW - IDHW - ATR-III Adolescent Benefit | 2304.389999999999
DHW - IDHW - ATR-III Misdemeanor |  |  | 1 |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 26 | 4158.86 |  |  | DHW - IDHW - ATR-III Adolescent Benefit - Medicaid |  |  |  | DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 26 | DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 4158.86 |  |  | DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 26 | DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 4158.86
DHW - IDHW - ATR-III Misdemeanor - Medicaid |  |  | 0.3 |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Military Benefit | 161 | 83159.84999999995 |  |  | DHW - IDHW - ATR-III Military Benefit |  |  |  | DHW - IDHW - ATR-III Military Benefit | 161 | DHW - IDHW - ATR-III Military Benefit | 83159.84999999995 |  |  | DHW - IDHW - ATR-III Military Benefit | 161 | DHW - IDHW - ATR-III Military Benefit | 83159.84999999995
ATR Total |  |  |  |  |  | 2724921 |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Military Benefit - Medicaid | 26 | 19297.02 |  |  | DHW - IDHW - ATR-III Military Benefit - Medicaid |  |  |  | DHW - IDHW - ATR-III Military Benefit - Medicaid | 26 | DHW - IDHW - ATR-III Military Benefit - Medicaid | 19297.02 |  |  | DHW - IDHW - ATR-III Military Benefit - Medicaid | 26 | DHW - IDHW - ATR-III Military Benefit - Medicaid | 19297.02
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Misdemeanor | 786 | 313761.5899999989 |  |  | DHW - IDHW - ATR-III Misdemeanor |  |  |  | DHW - IDHW - ATR-III Misdemeanor | 786 | DHW - IDHW - ATR-III Misdemeanor | 313761.5899999989 |  |  | DHW - IDHW - ATR-III Misdemeanor | 786 | DHW - IDHW - ATR-III Misdemeanor | 313761.5899999989
[NAME] |  |  | 1 |  | 0 |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Misdemeanor - Medicaid | 90 | 42382.58000000001 |  |  | DHW - IDHW - ATR-III Misdemeanor - Medicaid |  |  |  | DHW - IDHW - ATR-III Misdemeanor - Medicaid | 90 | DHW - IDHW - ATR-III Misdemeanor - Medicaid | 42382.58000000001 |  |  | DHW - IDHW - ATR-III Misdemeanor - Medicaid | 90 | DHW - IDHW - ATR-III Misdemeanor - Medicaid | 42382.58000000001
Adult-Medicaid |  |  | 0.3 |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - Child Protection Drug Court | 39 | 33354.70999999999 |  |  | DHW - IDHW - Child Protection Drug Court |  |  |  | DHW - IDHW - Child Protection Drug Court | 39 | DHW - IDHW - Child Protection Drug Court | 33354.70999999999 |  |  | DHW - IDHW - Child Protection Drug Court | 39 | DHW - IDHW - Child Protection Drug Court | 33354.70999999999
Adult Total |  |  |  |  |  | 100000 |  |  |  |  |  |  |  | DHW - IDHW - CP/SUD | 197 | 86910.9999999999 |  |  | DHW - IDHW - CP/SUD |  |  |  | DHW - IDHW - CP/SUD | 197 | DHW - IDHW - CP/SUD | 86910.9999999999 |  |  | DHW - IDHW - CP/SUD | 197 | DHW - IDHW - CP/SUD | 86910.9999999999
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - CP/SUD - Medicaid | 70 | 32120.86 |  |  | DHW - IDHW - CP/SUD - Medicaid |  |  |  | DHW - IDHW - CP/SUD - Medicaid | 70 | DHW - IDHW - CP/SUD - Medicaid | 32120.86 |  |  | DHW - IDHW - CP/SUD - Medicaid | 70 | DHW - IDHW - CP/SUD - Medicaid | 32120.86
Adolescent |  |  | 1 |  | 0 |  |  |  |  |  |  |  |  | DHW - IDHW - DV Court Misdemeanant | 121 | 75441.35999999997 |  |  | DHW - IDHW - DV Court Misdemeanant |  |  |  | DHW - IDHW - DV Court Misdemeanant | 121 | DHW - IDHW - DV Court Misdemeanant | 75441.35999999997 |  |  | DHW - IDHW - DV Court Misdemeanant | 121 | DHW - IDHW - DV Court Misdemeanant | 75441.35999999997
Adolescent-Medicaid |  |  | 0.3 |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - DV Court Misdemeanant - Medicaid | 21 | 12424.92 |  |  | DHW - IDHW - DV Court Misdemeanant - Medicaid |  |  |  | DHW - IDHW - DV Court Misdemeanant - Medicaid | 21 | DHW - IDHW - DV Court Misdemeanant - Medicaid | 12424.92 |  |  | DHW - IDHW - DV Court Misdemeanant - Medicaid | 21 | DHW - IDHW - DV Court Misdemeanant - Medicaid | 12424.92
Adolescent Total |  |  |  |  |  | 100000 |  |  | 1210.408307962904 | -399744.5916920371 |  |  |  | DHW - IDHW - IVDU | 361 | 108110.9799999999 |  |  | DHW - IDHW - IVDU |  |  |  | DHW - IDHW - IVDU | 361 | DHW - IDHW - IVDU | 108110.9799999999 |  |  | DHW - IDHW - IVDU | 361 | DHW - IDHW - IVDU | 108110.9799999999
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - IVDU - Medicaid | 46 | 40703.10000000002 |  |  | DHW - IDHW - IVDU - Medicaid |  |  |  | DHW - IDHW - IVDU - Medicaid | 46 | DHW - IDHW - IVDU - Medicaid | 40703.10000000002 |  |  | DHW - IDHW - IVDU - Medicaid | 46 | DHW - IDHW - IVDU - Medicaid | 40703.10000000002
CP-SUD |  |  | 1 |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - Medicaid Only | 854 | 344394.619999999 |  |  | DHW - IDHW - Medicaid Only |  |  |  | DHW - IDHW - Medicaid Only | 854 | DHW - IDHW - Medicaid Only | 344394.619999999 |  |  | DHW - IDHW - Medicaid Only | 854 | DHW - IDHW - Medicaid Only | 344394.619999999
CP-SUD - Medicaid |  |  | 0.3 |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - PWWC | 118 | 119505.89 |  |  | DHW - IDHW - PWWC |  |  |  | DHW - IDHW - PWWC | 118 | DHW - IDHW - PWWC | 119505.89 |  |  | DHW - IDHW - PWWC | 118 | DHW - IDHW - PWWC | 119505.89
CP-SUD Total |  |  |  |  |  | 750000 |  |  |  |  |  |  |  | DHW - IDHW - PWWC - Medicaid | 140 | 153398.41 |  |  | DHW - IDHW - PWWC - Medicaid |  |  |  | DHW - IDHW - PWWC - Medicaid | 140 | DHW - IDHW - PWWC - Medicaid | 153398.41 |  |  | DHW - IDHW - PWWC - Medicaid | 140 | DHW - IDHW - PWWC - Medicaid | 153398.41
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - State Hospital | 65 | 49161.92 |  |  | DHW - IDHW - State Hospital |  |  |  | DHW - IDHW - State Hospital | 65 | DHW - IDHW - State Hospital | 49161.92 |  |  | DHW - IDHW - State Hospital | 65 | DHW - IDHW - State Hospital | 49161.92
DV Court |  |  | 1 |  | 0 |  |  |  |  |  |  |  |  | DHW - IDHW - State Hospital - Medicaid | 23 | 10941.78 |  |  | DHW - IDHW - State Hospital - Medicaid |  |  |  | DHW - IDHW - State Hospital - Medicaid | 23 | DHW - IDHW - State Hospital - Medicaid | 10941.78 |  |  | DHW - IDHW - State Hospital - Medicaid | 23 | DHW - IDHW - State Hospital - Medicaid | 10941.78
DV Court- Medicaid |  |  | 0.3 |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - Unknown / Ineligible | 723 | 9567.010000000046 |  |  | DHW - IDHW - Unknown / Ineligible |  |  |  | DHW - IDHW - Unknown / Ineligible | 723 | DHW - IDHW - Unknown / Ineligible | 9567.010000000046 |  |  | DHW - IDHW - Unknown / Ineligible | 723 | DHW - IDHW - Unknown / Ineligible | 9567.010000000046
DV Court Misdemeanant Total |  |  |  |  |  | 429000 |  |  |  |  |  |  |  | DHW - PSC - Mental Health Court | 39 | 32156.91 |  |  | DHW - PSC - Mental Health Court |  |  |  | DHW - PSC - Mental Health Court | 39 | DHW - PSC - Mental Health Court | 32156.91 |  |  | DHW - PSC - Mental Health Court | 39 | DHW - PSC - Mental Health Court | 32156.91
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DHW - PSC - Mental Health Court - Medicaid | 23 | 29365.92999999999 |  |  | DHW - PSC - Mental Health Court - Medicaid |  |  |  | DHW - PSC - Mental Health Court - Medicaid | 23 | DHW - PSC - Mental Health Court - Medicaid | 29365.92999999999 |  |  | DHW - PSC - Mental Health Court - Medicaid | 23 | DHW - PSC - Mental Health Court - Medicaid | 29365.92999999999
IVDU |  |  | 1 |  |  |  |  |  |  |  |  |  |  | Grand Total | 4008 | 1630105.909999997 |  |  | Grand Total |  |  |  | Grand Total | 4008 | Grand Total | 1630105.909999997 |  |  | Grand Total | 4008 | Grand Total | 1630105.909999997
IVDU - Medicaid |  |  | 0.3
IVDU Total |  |  |  |  |  | 1000000
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
Non-Medicaid Total
Medicaid Total
Grand Total
V:\BPA Invoices New\2014\20140816\Claims Reports\DHW SR056_SFY14_6-7-13 - 8-15-13_Claims Report_20130816(2).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