Spreadsheet: 220ee8d6-1865-48ac-b421-82d9a6e5b9d2
Sheet: SFY 2014 Reg 6 Budget For BP

 |  |  |  |  |  |  |  |  |  | Collapse
 |  |  |  | Claims  Report* | % of Year Complete |  |  |  |  | 2013-07-01 00:00:00
[NAME] as of 8/30/2013 | Region 6 |  |  | 2013-08-30 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 |  | 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 | 0 | 0 |  |  | DHW - IDHW - Adolescent - Medicaid
DHW - IDHW - ATR-III Adolescent Benefit |  |  | 1 |  |  |  |  |  |  |  |  | DHW - IDHW - Adult | 1 | 2311.96 |  |  | DHW - IDHW - Adult |  |  |  | DHW - IDHW - Adult | 1 | DHW - IDHW - Adult | 2311.96 |  |  | DHW - IDHW - Adult | 1 | DHW - IDHW - Adult | 2311.96
DHW - IDHW - ATR-III Adolescent Benefit - Medicaid |  |  | 0.3 |  |  |  |  |  |  |  |  | DHW - IDHW - Adult - Medicaid | 0 | 0 |  |  | DHW - IDHW - Adult - Medicaid
DHW - IDHW - ATR-III Military Benefit |  |  | 1 |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III - Administrative | 2 | 310.25 |  |  | DHW - IDHW - ATR-III - Administrative |  |  |  | DHW - IDHW - ATR-III - Administrative | 2 | DHW - IDHW - ATR-III - Administrative | 310.25 |  |  | DHW - IDHW - ATR-III - Administrative | 2 | DHW - IDHW - ATR-III - Administrative | 310.25
DHW - IDHW - ATR-III Military Benefit - Medicaid |  |  | 0.3 |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Adolescent Benefit | 0 | 0 |  |  | DHW - IDHW - ATR-III Adolescent Benefit
DHW - IDHW - ATR-III Misdemeanor |  |  | 1 |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 0 | 0 |  |  | DHW - IDHW - ATR-III Adolescent Benefit - Medicaid
DHW - IDHW - ATR-III Misdemeanor - Medicaid |  |  | 0.3 |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Military Benefit | 18 | 8735.22 |  |  | DHW - IDHW - ATR-III Military Benefit |  |  |  | DHW - IDHW - ATR-III Military Benefit | 18 | DHW - IDHW - ATR-III Military Benefit | 8735.22 |  |  | DHW - IDHW - ATR-III Military Benefit | 18 | DHW - IDHW - ATR-III Military Benefit | 8735.22
ATR Total |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Military Benefit - Medicaid | 0 | 0 |  |  | DHW - IDHW - ATR-III Military Benefit - Medicaid
 |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Misdemeanor | 67 | 31982.78 |  |  | DHW - IDHW - ATR-III Misdemeanor |  |  |  | DHW - IDHW - ATR-III Misdemeanor | 67 | DHW - IDHW - ATR-III Misdemeanor | 31982.78 |  |  | DHW - IDHW - ATR-III Misdemeanor | 67 | DHW - IDHW - ATR-III Misdemeanor | 31982.78
[NAME] |  |  | 1 |  | 0 |  |  |  |  |  |  | DHW - IDHW - ATR-III Misdemeanor - Medicaid | 6 | 2051.71 |  |  | DHW - IDHW - ATR-III Misdemeanor - Medicaid |  |  |  | DHW - IDHW - ATR-III Misdemeanor - Medicaid | 6 | DHW - IDHW - ATR-III Misdemeanor - Medicaid | 2051.71 |  |  | DHW - IDHW - ATR-III Misdemeanor - Medicaid | 6 | DHW - IDHW - ATR-III Misdemeanor - Medicaid | 2051.71
Adult-Medicaid |  |  | 0.3 |  |  |  |  |  |  |  |  | DHW - IDHW - Child Protection Drug Court | 0 | 0 |  |  | DHW - IDHW - Child Protection Drug Court
Adult Total |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - CP/SUD | 19 | 8761.180000000002 |  |  | DHW - IDHW - CP/SUD |  |  |  | DHW - IDHW - CP/SUD | 19 | DHW - IDHW - CP/SUD | 8761.180000000002 |  |  | DHW - IDHW - CP/SUD | 19 | DHW - IDHW - CP/SUD | 8761.180000000002
 |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - CP/SUD - Medicaid | 0 | 0 |  |  | DHW - IDHW - CP/SUD - Medicaid
Adolescent |  |  | 1 |  | 0 |  |  |  |  |  |  | DHW - IDHW - DV Court Misdemeanant | 17 | 12051.79 |  |  | DHW - IDHW - DV Court Misdemeanant |  |  |  | DHW - IDHW - DV Court Misdemeanant | 17 | DHW - IDHW - DV Court Misdemeanant | 12051.79 |  |  | DHW - IDHW - DV Court Misdemeanant | 17 | DHW - IDHW - DV Court Misdemeanant | 12051.79
Adolescent-Medicaid |  |  | 0.3 |  |  |  |  |  |  |  |  | DHW - IDHW - DV Court Misdemeanant - Medicaid | 2 | 2094.56 |  |  | DHW - IDHW - DV Court Misdemeanant - Medicaid |  |  |  | DHW - IDHW - DV Court Misdemeanant - Medicaid | 2 | DHW - IDHW - DV Court Misdemeanant - Medicaid | 2094.56 |  |  | DHW - IDHW - DV Court Misdemeanant - Medicaid | 2 | DHW - IDHW - DV Court Misdemeanant - Medicaid | 2094.56
Adolescent Total |  |  |  |  |  |  | 1210.408307962904 | -399744.5916920371 |  |  |  | DHW - IDHW - IVDU | 32 | 7002.970000000001 |  |  | DHW - IDHW - IVDU |  |  |  | DHW - IDHW - IVDU | 32 | DHW - IDHW - IVDU | 7002.970000000001 |  |  | DHW - IDHW - IVDU | 32 | DHW - IDHW - IVDU | 7002.970000000001
 |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - IVDU - Medicaid | 3 | 1991.99 |  |  | DHW - IDHW - IVDU - Medicaid |  |  |  | DHW - IDHW - IVDU - Medicaid | 3 | DHW - IDHW - IVDU - Medicaid | 1991.99 |  |  | DHW - IDHW - IVDU - Medicaid | 3 | DHW - IDHW - IVDU - Medicaid | 1991.99
CP-SUD |  |  | 1 |  |  |  |  |  |  |  |  | DHW - IDHW - Medicaid Only | 99 | 49805.95000000002 |  |  | DHW - IDHW - Medicaid Only |  |  |  | DHW - IDHW - Medicaid Only | 99 | DHW - IDHW - Medicaid Only | 49805.95000000002 |  |  | DHW - IDHW - Medicaid Only | 99 | DHW - IDHW - Medicaid Only | 49805.95000000002
CP-SUD - Medicaid |  |  | 0.3 |  |  |  |  |  |  |  |  | DHW - IDHW - PWWC | 19 | 19573.9 |  |  | DHW - IDHW - PWWC |  |  |  | DHW - IDHW - PWWC | 19 | DHW - IDHW - PWWC | 19573.9 |  |  | DHW - IDHW - PWWC | 19 | DHW - IDHW - PWWC | 19573.9
CP-SUD Total |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - PWWC - Medicaid | 8 | 2060.86 |  |  | DHW - IDHW - PWWC - Medicaid |  |  |  | DHW - IDHW - PWWC - Medicaid | 8 | DHW - IDHW - PWWC - Medicaid | 2060.86 |  |  | DHW - IDHW - PWWC - Medicaid | 8 | DHW - IDHW - PWWC - Medicaid | 2060.86
 |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - State Hospital | 15 | 7298.330000000001 |  |  | DHW - IDHW - State Hospital |  |  |  | DHW - IDHW - State Hospital | 15 | DHW - IDHW - State Hospital | 7298.330000000001 |  |  | DHW - IDHW - State Hospital | 15 | DHW - IDHW - State Hospital | 7298.330000000001
DV Court |  |  | 1 |  | 0 |  |  |  |  |  |  | DHW - IDHW - State Hospital - Medicaid | 7 | 2334.36 |  |  | DHW - IDHW - State Hospital - Medicaid |  |  |  | DHW - IDHW - State Hospital - Medicaid | 7 | DHW - IDHW - State Hospital - Medicaid | 2334.36 |  |  | DHW - IDHW - State Hospital - Medicaid | 7 | DHW - IDHW - State Hospital - Medicaid | 2334.36
DV Court- Medicaid |  |  | 0.3 |  |  |  |  |  |  |  |  | DHW - IDHW - Unknown / Ineligible | 96 | 1530.229999999999 |  |  | DHW - IDHW - Unknown / Ineligible |  |  |  | DHW - IDHW - Unknown / Ineligible | 96 | DHW - IDHW - Unknown / Ineligible | 1530.229999999999 |  |  | DHW - IDHW - Unknown / Ineligible | 96 | DHW - IDHW - Unknown / Ineligible | 1530.229999999999
DV Court Misdemeanant Total |  |  |  |  |  |  |  |  |  |  |  | DHW - PSC - Mental Health Court | 8 | 4684.759999999999 |  |  | DHW - PSC - Mental Health Court |  |  |  | DHW - PSC - Mental Health Court | 8 | DHW - PSC - Mental Health Court | 4684.759999999999 |  |  | DHW - PSC - Mental Health Court | 8 | DHW - PSC - Mental Health Court | 4684.759999999999
 |  |  |  |  |  |  |  |  |  |  |  | DHW - PSC - Mental Health Court - Medicaid | 0 | 0 |  |  | DHW - PSC - Mental Health Court - Medicaid
IVDU |  |  | 1 |  |  |  |  |  |  |  |  | Grand Total | 419 | 164582.8 |  |  | Grand Total |  |  |  | Grand Total | 419 | Grand Total | 164582.8 |  |  | Grand Total | 419 | Grand Total | 164582.8
IVDU - Medicaid |  |  | 0.3
IVDU Total
PWWC |  |  | 1
PWWC - Medicaid |  |  | 0.3
PWWC Total
State Hospital |  |  | 1
State Hospital - Medicaid |  |  | 0.3
State Hospital Total
Mental Health Court |  |  | 1
Mental Health Court - Medicaid |  |  | 0.3
Mental Health Court Total
Misdemeanant PSC |  |  | 1
Misdemeanant PSC - Medicaid |  |  | 0.3
Misdemeanant PSC Total
Medicaid Only |  |  | 0.3
Medicaid Only Total
Unknown / Ineligible / Reserve |  |  | 1
Non-Medicaid Total
Medicaid Total
Grand Total
V:\BPA Invoices New\2014\20140830\Claims Reports\DHW SR056_SFY14_6-7-13 - 8-29-13_Claims Report_20130830.xlsx
[NAME]
Grand Total | 6196 | 3871765.830000111 | 0.786960501172644 | 3046926.778000006 | 824839.0519999991 |  | 7493792.886432447 | 311642.8864324456
GF |  |  |  | 3046926.778000006 |  |  | 7493792.886432447 | 311642.8864324456
Medicaid |  |  |  |  | 824839.0519999991 |  | 2028658.208972971 | -801341.7910270293
GF Plus Medicaid |  | 3871765.830000005 |  |  |  |  | 9522451.095405417 | -489698.9045945834
 | 6196 | 3871765.830000005 |  |  |  |  | 7423408.469135149 | 241258.469135149