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

 |  |  |  |  |  |  |  |  |  |  |  | Collapse
 |  |  |  |  |  | Claims  Report* | % of Year Complete |  |  |  |  | 2013-07-01 00:00:00
[NAME] as of 7/15/2013 |  |  |  |  |  | 2013-07-15 00:00:00
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
DHW - IDHW - ATR-III - Administrative | 13 | 414.8200000000001 | 1 |  |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III - Administrative | 13 | 414.8200000000001
DHW - IDHW - ATR-III Adolescent Benefit | 8 | 802.04 | 1 |  |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Adolescent Benefit | 8 | 802.04
DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 12 | 1216.82 | 0.3 |  |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 12 | 1216.82
DHW - IDHW - ATR-III Military Benefit | 103 | 19840.07 | 1 |  |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Military Benefit | 103 | 19840.07
DHW - IDHW - ATR-III Military Benefit - Medicaid | 19 | 4543.88 | 0.3 |  |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Military Benefit - Medicaid | 19 | 4543.88
DHW - IDHW - ATR-III Misdemeanor | 480 | 83058.24999999984 | 1 |  |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Misdemeanor | 480 | 83058.24999999984
DHW - IDHW - ATR-III Misdemeanor - Medicaid | 56 | 10306.63 | 0.3 |  |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Misdemeanor - Medicaid | 56 | 10306.63
ATR Total |  |  |  |  |  | 2724921 |  |  |  |  |  | 3360000
[NAME] | 11 | 2156.5 | 1 |  | 0 |  |  |  |  |  |  | 340000 |  |  |  | DHW - IDHW - Adult | 11 | 2156.5
Adult-Medicaid | 1 | 500.8200000000001 | 0.3 |  |  |  |  |  |  |  |  | 340000 |  |  |  | DHW - IDHW - Adult - Medicaid | 1 | 500.8200000000001
Adult Total |  |  |  |  |  | 100000 |  |  |  |  |  | 3360000
Adolescent |  |  | 1 |  | 0 |  |  |  |  |  |  | 340000
Adolescent-Medicaid | 1 | 3012.179999999999 | 0.3 |  |  |  |  |  |  |  |  | 340000 |  |  |  | DHW - IDHW - Adolescent - Medicaid | 1 | 3012.179999999999
Adolescent Total |  |  |  |  |  | 100000 |  |  | 1210.408307962904 | -399744.5916920371 |  | 3360000
CP-SUD | 129 | 18570.75 | 1 |  |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - CP/SUD | 129 | 18570.75
CP-SUD - Medicaid | 49 | 10312.18 | 0.3 |  |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - CP/SUD - Medicaid | 49 | 10312.18
CP-SUD Total |  |  |  |  |  | 750000 |  |  |  |  |  | 3360000
DV Court | 81 | 16763.12 | 1 |  | 0 |  |  |  |  |  |  | 340000 |  |  |  | DHW - IDHW - DV Court Misdemeanant | 81 | 16763.12
DV Court- Medicaid | 12 | 2527.29 | 0.3 |  |  |  |  |  |  |  |  | 340000 |  |  |  | DHW - IDHW - DV Court Misdemeanant - Medicaid | 12 | 2527.29
DV Court Misdemeanant Total |  |  |  |  |  | 429000 |  |  |  |  |  | 3360000
IVDU | 189 | 23783.96000000003 | 1 |  |  |  |  |  |  |  |  | 600000 |  |  |  | DHW - IDHW - IVDU | 189 | 23783.96000000003
IVDU - Medicaid | 18 | 8197.150000000001 | 0.3 |  |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - IVDU - Medicaid | 18 | 8197.150000000001
IVDU Total |  |  |  |  |  | 1000000 |  |  |  |  |  | 3360000
PWWC | 65 | 33647.51000000001 | 1 |  |  |  |  |  |  |  |  | 650000 |  |  |  | DHW - IDHW - PWWC | 65 | 33647.51000000001
PWWC - Medicaid | 81 | 37437.8 | 0.3 |  |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - PWWC - Medicaid | 81 | 37437.8
PWWC Total |  |  |  |  |  | 450000 |  |  |  |  |  | 3360000
State Hospital | 36 | 10439.1 | 1 |  |  |  |  |  |  |  |  | 250000 |  |  |  | DHW - IDHW - State Hospital | 36 | 10439.1
State Hospital - Medicaid | 12 | 2192.55 | 0.3 |  |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - State Hospital - Medicaid | 12 | 2192.55
State Hospital Total |  |  |  |  |  | 325000 |  |  |  |  |  | 3360000
Mental Health Court | 33 | 7623.830000000001 | 1 |  |  |  |  |  |  |  |  | 340000 |  |  |  | DHW - PSC - Mental Health Court | 33 | 7623.830000000001
Mental Health Court - Medicaid | 20 | 7276.770000000001 | 0.3 |  |  |  |  |  |  |  |  |  |  |  |  | DHW - PSC - Mental Health Court - Medicaid | 20 | 7276.770000000001
Mental Health Court Total |  |  |  |  |  | 300000 |  |  |  |  |  | 3360000
Misdemeanant PSC |  |  | 1 |  |  |  |  |  |  |  |  | 340000
Misdemeanant PSC - Medicaid |  |  | 0.3
Misdemeanant PSC Total |  |  |  |  |  | 275000 |  |  |  |  |  | 3360000
Medicaid Only | 551 | 87316.58999999982 | 0.3 |  |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - Medicaid Only | 551 | 87316.58999999982
Medicaid Only Total |  |  |  |  |  | 916667 |  |  |  |  |  | 3360000
Unknown / Ineligible / Reserve | 179 | 2248.239999999996 | 1 |  |  | 546455 |  |  |  |  |  |  |  |  |  | DHW - IDHW - Unknown / Ineligible | 179 | 2248.239999999996
Non-Medicaid Total
Medicaid Total
Grand Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total | 2159 | 394188.8499999997
[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