Spreadsheet: 220ee8d6-1865-48ac-b421-82d9a6e5b9d2
Sheet: 20131011 CPSUD by Region

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Collapse
 |  |  |  |  |  |  |  |  | Claims  Report* |  | % of Year Complete |  |  |  |  | 2013-07-01 00:00:00
 | CP SUD Expenditures as of 10/11/2013 |  |  |  |  |  |  |  | 2013-10-11 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 |  |  |  |  |  | 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 |  |  |  | Client Address Region | Insurer | Count of Sum of Paid Plus Incentive | Client Address Region | Insurer | Sum of Sum of Paid Plus Incentive
 | Region 1,    CP/SUD | 60 | 43512.17999999997 |  | 1 |  |  |  |  |  |  |  |  |  |  | 51000 |  |  |  | 1 | DHW - IDHW - CP/SUD | 60 | 43512.17999999997 |  | 1 | DHW - IDHW - CP/SUD | 60 | 43512.17999999997 |  |  |  | 1 | DHW - IDHW - CP/SUD | 60 | 1 | DHW - IDHW - CP/SUD | 43512.17999999997
 | CP/SUD - Medicaid | 24 | 11012.32 |  | 0.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - CP/SUD - Medicaid | 24 | 11012.32 |  |  | DHW - IDHW - CP/SUD - Medicaid | 24 | 11012.32 |  |  |  |  | DHW - IDHW - CP/SUD - Medicaid | 24 |  | DHW - IDHW - CP/SUD - Medicaid | 11012.32
 | Region 2,   CP/SUD | 27 | 20284.58 |  | 1 |  |  |  |  |  |  |  |  |  |  | 37400 |  |  |  | 2 | DHW - IDHW - CP/SUD | 27 | 20284.58 |  | 2 | DHW - IDHW - CP/SUD | 27 | 20284.58 |  |  |  | 2 | DHW - IDHW - CP/SUD | 27 | 2 | DHW - IDHW - CP/SUD | 20284.58
 | CP/SUD - Medicaid | 11 | 718.49 |  | 0.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - CP/SUD - Medicaid | 11 | 718.49 |  |  | DHW - IDHW - CP/SUD - Medicaid | 11 | 718.49 |  |  |  |  | DHW - IDHW - CP/SUD - Medicaid | 11 |  | DHW - IDHW - CP/SUD - Medicaid | 718.49
 | Region 3,    CP/SUD | 49 | 53121.87 |  | 1 |  |  |  |  |  |  |  |  |  |  | 61200 |  |  |  | 3 | DHW - IDHW - CP/SUD | 49 | 53121.87 |  | 3 | DHW - IDHW - CP/SUD | 49 | 53121.87 |  |  |  | 3 | DHW - IDHW - CP/SUD | 49 | 3 | DHW - IDHW - CP/SUD | 53121.87
 | CP/SUD - Medicaid | 15 | 13804.37 |  | 0.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - CP/SUD - Medicaid | 15 | 13804.37 |  |  | DHW - IDHW - CP/SUD - Medicaid | 15 | 13804.37 |  |  |  |  | DHW - IDHW - CP/SUD - Medicaid | 15 |  | DHW - IDHW - CP/SUD - Medicaid | 13804.37
 | Region 4,    CP/SUD | 42 | 31904.39999999999 |  | 1 |  |  |  |  |  |  |  |  |  |  | 68000 |  |  |  | 4 | DHW - IDHW - CP/SUD | 42 | 31904.39999999999 |  | 4 | DHW - IDHW - CP/SUD | 42 | 31904.39999999999 |  |  |  | 4 | DHW - IDHW - CP/SUD | 42 | 4 | DHW - IDHW - CP/SUD | 31904.39999999999
 | CP/SUD - Medicaid | 16 | 12621.53 |  | 0.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - CP/SUD - Medicaid | 16 | 12621.53 |  |  | DHW - IDHW - CP/SUD - Medicaid | 16 | 12621.53 |  |  |  |  | DHW - IDHW - CP/SUD - Medicaid | 16 |  | DHW - IDHW - CP/SUD - Medicaid | 12621.53
 | Region 5,    CP/SUD | 38 | 17348.61 |  | 1 |  |  |  |  |  |  |  |  |  |  | 34000 |  |  |  | 5 | DHW - IDHW - CP/SUD | 38 | 17348.61 |  | 5 | DHW - IDHW - CP/SUD | 38 | 17348.61 |  |  |  | 5 | DHW - IDHW - CP/SUD | 38 | 5 | DHW - IDHW - CP/SUD | 17348.61
 | CP/SUD - Medicaid | 2 | 656.3199999999999 |  | 0.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - CP/SUD - Medicaid | 2 | 656.3199999999999 |  |  | DHW - IDHW - CP/SUD - Medicaid | 2 | 656.3199999999999 |  |  |  |  | DHW - IDHW - CP/SUD - Medicaid | 2 |  | DHW - IDHW - CP/SUD - Medicaid | 656.3199999999999
 | Region 6,    CP/SUD | 22 | 13121.12 |  | 1 |  |  |  |  |  |  |  |  |  |  | 27200 |  |  |  | 6 | DHW - IDHW - CP/SUD | 22 | 13121.12 |  | 6 | DHW - IDHW - CP/SUD | 22 | 13121.12 |  |  |  | 6 | DHW - IDHW - CP/SUD | 22 | 6 | DHW - IDHW - CP/SUD | 13121.12
 | CP/SUD - Medicaid | 9 | 4897.98 |  | 0.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - CP/SUD - Medicaid | 9 | 4897.98 |  |  | DHW - IDHW - CP/SUD - Medicaid | 9 | 4897.98 |  |  |  |  | DHW - IDHW - CP/SUD - Medicaid | 9 |  | DHW - IDHW - CP/SUD - Medicaid | 4897.98
 | Region 7,    CP/SUD | 15 | 3261.44 |  | 1 |  |  |  |  |  |  |  |  |  |  | 61200 |  |  |  | 7 | DHW - IDHW - CP/SUD | 15 | 3261.44 |  | 7 | DHW - IDHW - CP/SUD | 15 | 3261.44 |  |  |  | 7 | DHW - IDHW - CP/SUD | 15 | 7 | DHW - IDHW - CP/SUD | 3261.44
 | CP/SUD - Medicaid |  |  |  | 0.3
 | Grand Total | 330 | 226265.21 |  |  |  |  |  | 750000 |  |  |  |  |  |  |  |  |  |  | Grand Total |  | 330 | 226265.21 |  | Grand Total |  | 330 | 226265.21 |  |  |  | Grand Total |  | 330 | Grand Total |  | 226265.21
 | GF
 | Medicaid
 | GF Plus Medicaid
 | V:\BPA Invoices New\2014\20131011\Claims Reports\DHW SR056_SFY14_6-7-13 - 10-10-13_Claims Report_20131011.xlsx
 | .
 | 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