Spreadsheet: 220ee8d6-1865-48ac-b421-82d9a6e5b9d2
Sheet: 20130816 MHC by Region

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Collapse
 |  |  |  |  |  |  |  |  | Claims  Report* |  | % of Year Complete |  |  |  |  | 2013-07-01 00:00:00
 | Mental Health Court Expenditures as of 8/16/2013 |  |  |  |  |  |  |  | 2013-08-16 00:00:00
 | Insurer | Client Count  (YTD) | Sum of Paid  Plus Incentive |  | % GF | GF | Med |  | GF Budget | Med Budget | % of GF Budget |  | Projected EOY Total GF Spending | Amount Over (Under) GF Budget
 | Region 1,    Mental Health Court | 6 | 3687.290000000001 |  | 1 |  |  |  |  |  |  |  |  |  |  | 51000 |  |  |  | Client Address Region | Insurer | Count of Sum of Paid Plus Incentive | Sum of Sum of Paid Plus Incentive |  |  | Client Address Region | Insurer | Count of Sum of Paid Plus Incentive | Sum of Sum of Paid Plus Incentive
 | Mental Health Court - Medicaid | 14 | 12692.92 |  | 0.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | DHW - PSC - Mental Health Court | 6 | 3687.290000000001 |  |  | 1 | DHW - PSC - Mental Health Court | 6 | 3687.290000000001
 | Region 2,    Mental Health Court |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 37400 |  |  |  |  | DHW - PSC - Mental Health Court - Medicaid | 14 | 12692.92 |  |  |  | DHW - PSC - Mental Health Court - Medicaid | 14 | 12692.92
 | Mental Health Court - Medicaid |  |  |  | 0.3
 | Region 3,    Mental Health Court | 1 | 2534.600000000001 |  | 1 |  |  |  |  |  |  |  |  |  |  | 61200
 | Mental Health Court - Medicaid | 1 | 471.5 |  | 0.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | DHW - PSC - Mental Health Court | 1 | 2534.600000000001 |  |  | 3 | DHW - PSC - Mental Health Court | 1 | 2534.600000000001
 | Region 4,    Mental Health Court | 18 | 16508.24 |  | 1 |  |  |  |  |  |  |  |  |  |  | 68000 |  |  |  |  | DHW - PSC - Mental Health Court - Medicaid | 1 | 471.5 |  |  |  | DHW - PSC - Mental Health Court - Medicaid | 1 | 471.5
 | Mental Health Court - Medicaid | 2 | 2072.76 |  | 0.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | DHW - PSC - Mental Health Court | 18 | 16508.24 |  |  | 4 | DHW - PSC - Mental Health Court | 18 | 16508.24
 | Region 5,    Mental Health Court | 6 | 5023.189999999999 |  | 1 |  |  |  |  |  |  |  |  |  |  | 34000 |  |  |  |  | DHW - PSC - Mental Health Court - Medicaid | 2 | 2072.76 |  |  |  | DHW - PSC - Mental Health Court - Medicaid | 2 | 2072.76
 | Mental Health Court - Medicaid | 2 | 1056.55 |  | 0.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | DHW - PSC - Mental Health Court | 6 | 5023.189999999999 |  |  | 5 | DHW - PSC - Mental Health Court | 6 | 5023.189999999999
 | Region 6,    Mental Health Court | 7 | 4273.589999999999 |  | 1 |  |  |  |  |  |  |  |  |  |  | 27200 |  |  |  |  | DHW - PSC - Mental Health Court - Medicaid | 2 | 1056.55 |  |  |  | DHW - PSC - Mental Health Court - Medicaid | 2 | 1056.55
 | Mental Health Court - Medicaid |  |  |  | 0.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | DHW - PSC - Mental Health Court | 7 | 4273.589999999999 |  |  | 6 | DHW - PSC - Mental Health Court | 7 | 4273.589999999999
 | Region 7,    Mental Health Court | 2 | 130 |  | 1 |  |  |  |  |  |  |  |  |  |  | 61200
 | Mental Health Court - Medicaid | 4 | 13072.2 |  | 0.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | DHW - PSC - Mental Health Court | 2 | 130 |  |  | 7 | DHW - PSC - Mental Health Court | 2 | 130
 | Grand Total | 63 | 61522.84 |  |  |  |  |  | 300000 |  |  |  |  |  |  |  |  |  |  |  | DHW - PSC - Mental Health Court - Medicaid | 4 | 13072.2 |  |  |  | DHW - PSC - Mental Health Court - Medicaid | 4 | 13072.2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total |  | 63 | 61522.84 |  |  | Grand Total |  | 63 | 61522.84
 | GF
 | Medicaid
 | GF Plus Medicaid
 | V:\BPA Invoices New\2014\20140816\Claims Reports\DHW SR056_SFY14_6-7-13 - 8-15-13_Claims Report_20130816(2).xlsx
 | Note: Percent of year complete on this tab is based on the number of the days of the fiscal year (329) included in the Claims Report used as the source for this table.
 | Original
 | [NAME] | 2 | 827.92 |  |  |  |  |  | 340000
 | State Hospital | 83 | 133749.8099999999 |  |  |  |  |  | 250000
 | [NAME]
 | Grand Total | 6196 | 3871765.830000111 |  | 0.786960501172644 | 3046926.778000006 | 824839.0519999991 |  | 7182150.000000001 | 2830000 | 0.4242360265380151 |  | 7493792.886432447 | 311642.8864324456
 | GF |  |  |  |  | 3046926.778000006 |  |  | 7182150.000000001 |  | 0.4242360265380151 |  | 7493792.886432447 | 311642.8864324456
 | Medicaid |  |  |  |  |  | 824839.0519999991 |  |  | 2830000 | 0.2914625625441693 |  | 2028658.208972971 | -801341.7910270293
 | GF Plus Medicaid |  | 3871765.830000005 |  |  |  |  |  |  | 10012150 | 0.3867067343178043 |  | 9522451.095405417 | -489698.9045945834
 |  | 6196 | 3871765.830000005 |  |  |  |  |  | 7182150.000000001 |  |  |  | 7423408.469135149 | 241258.469135149
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Region
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | Percentage
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total: | 0.15 | Amount | # of Clients
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.11 | 51000 | 22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.18 | 37400 | 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.2 | 61200 | 26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1 | 68000 | 29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.08 | 34000 | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.18 | 27200 | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 61200 | 26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 340000 | 144