Spreadsheet: 0473271e-59d8-45b9-9dd6-388605484b02
Sheet: Sheet1

Orange County HIV Planning Council Reallocations and Additional Allocations Based on Updated Part A Notice of Grant Award (NGA)  [NAME] by PSAP September 28,2011 Reallocations and Revised Part A Allocations Approved by Planning Council October 12, 2011 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 |  | FY 2011 Funding (8/30/11 NGA): | Total | Service Dollars |  | FY 2011 Funding (10/3/11 NGA): | Total | Service Dollars
 |  | Part A: | 5230538 | 4487430 |  | Part A: | 5609649 | 4815884.649999999
 |  | Part A Carryover $15,609 (Pending Approval): | 0 | 0 |  | Part A Carryover $15,609 (Pending Approval): | 0 | 0
 |  | Minority AIDS Initiative (MAI): | 366341 | 311389.85 |  | Minority AIDS Initiative (MAI): | 366341 | 311389.85
 |  | HOPWA: | 921133 | 860872 |  | HOPWA*: | 921133 | 860872
 |  | TOTAL | 6518012 | 5659691.85 |  | TOTAL | 6897123 | 5988146.499999999
 |  |  | Allocations based on Part A NGA received 8/30/11 |  |  | Allocations based on Part A NGA received 10/3/11*
A | B |  | C | D | E | F | G
FY11 | Service Category |  | FY 2011 Allocations Based on Awards  and Reallocations App'd by PC 8/24/11 | Reallocations  App'd by PSAP 9/28/11 App'd by PC 10/12/11 | FY 2011 Allocations Based on Awards and Reallocations  App'd by PSAP 9/28/11  App'd by PC 10/12/11 (C+D) | Additional Allocations based on Newly Identified Part A funding  App'd by PC 10/12/11 | FY 2011 Allocations Based on Revised Award and Reallocations  (E+F) | Rationale
CORE MEDICAL SERVICES
1 | Outpatient / Ambulatory Medical Care |  | 1989759 | 0 | 1989759 | 0 | 1989759
 | Ambulatory Care |  | 1575020 | 0 | 1575020 | 0 | 1575020
 | Specialty Care |  | 414739 | 0 | 414739 | 0 | 414739
 | Treatment Adherence Services |  | 0 | 0 | 0 | 0 | 0
3 | Case Management: Medical |  | 1234048 | 0 | 1234048 | 64883 | 1298931
 | Case Management: Medical |  | 955048 | 0 | 955048 | 60925 | 1015973 | Increase based on decrease scenario staging in addition to year-end projections.
 | Case Management: Medical-ASF |  | 639826 | 0 | 639826 | 57062 | 696888
 | Case Management: Medical-Shanti |  | 51222 | 0 | 51222 | 3863 | 55085
 | Case Management: Medical-HCA |  | 65000 | 0 | 65000 | 0 | 65000
 | Case Management: Medical-REACH |  | 199000 | 0 | 199000 | 0 | 199000
 | Case Management: MAI |  | 279000 | 0 | 279000 | 3958 | 282958
 | Case Management: ASF |  | 140000 | 0 | 140000 | 0 | 140000
 | Case Management: Delhi |  | 139000 | 0 | 139000 | 3958 | 142958
5 | Early Intervention Services |  | 50000 | -35000 | 15000 | 0 | 15000 | Decreased by PSAP during 9/28/11 reallocations due to late receipt of Part A award.
6 | Oral Health Care |  | 320883 | 5009 | 325892 | 93500 | 419392 | Correction to the amount reallocated by PSAP on 9/28/11 due to a formula error (see column D). Total increase is to address cost for program.  Without additional funding, services cannot continue at current level. Additional funding will provide services for an additional 149 clients.
7 | Home Health Care / Home and Community-Based Health Services / Hospice / Rehabilitation |  | 117500 | 0 | 117500 | 21076 | 138576
 | Home Health / Specialized Care / Professional |  | 117500 | 0 | 117500 | 21076 | 138576 | Increase based on decrease scenario staging. Year-end projected expenses $138,576.
 | Home Health / Para-Professional Care |  |  |  | 0 |  | 0
9 | Mental Health Services |  | 233399 | 0 | 233399 | 20188 | 253587 | Based on decrease scenario staging, this service gets restored to $236,274. Additional $17,313 allocated will serve an additional 15 clients with 200 units of service.
9 | Mental Health Services-ASF |  | 135399 | 0 | 135399 | 20188 | 155587 | Based on decrease scenario staging, this service gets restored to $236,274. Additional $17,313 allocated
9 | Mental Health Services-APAIT |  | 42000 | 0 | 42000 | 0 | 42000
9 | Mental Health Services-Shanti |  | 56000 | 0 | 56000 | 0 | 56000
12 | Substance Abuse Services: Outpatient |  | 6344 | 0 | 6344 | 0 | 6344
 | Narcotic Replacement Program |  | 6344 | 0 | 6344 | 0 | 6344
 | Core Medical Services Total |  | 3951933 | -29991 | 3921942 | 199647 | 4121589
SUPPORT SERVICES
2 | EFA: Medications / Health Insurance Premium and Cost Sharing Assistance/ADAP |  | 15000 | 5177 | 20177 | 1788 | 21965 | Increased by PSAP during 9/28/11 reallocations based on year-end projections. Additional $1,788 based on correct year-end projections. Increased funding will provide an additional 30 health care premium and/or medication payments.
3 | Case Management: Non-Medical |  | 290691 | 0 | 290691 | -51866 | 238825 | Decrease based on year-end projections. Spreadsheet approved by PC on 10/12/11 had a formula error indicating a $62,550 decrease to non-medical case management. This caused the overall allocations to be over by $10,684. In order to maintain service dollars, this difference was taken from QM.
 | Client Advocacy |  | 125691 | 0 | 125691 | -10684 | 115007
 | [NAME] |  | 97500 | 0 | 97500 | -11974 | 85526
 | [NAME] |  | 28191 | 0 | 28191 | 1290 | 29481
 | Benefits Counseling |  | 165000 | 0 | 165000 | -41182 | 123818
4 | Housing |  | 649827 | -2036 | 647791 | 8574 | 656365
 | Emergency Financial Assistance: Housing |  | 214798 | -10027 | 204771 | 0 | 204771 | Decreased by PSAP during 9/28/11 reallocations based on year-end projections.
 | Housing Coordination |  | 80000 | -2009 | 77991 | 0 | 77991 | Decreased by PSAP during 9/28/11 reallocations based on year-end projections.
 | Transitional Housing: General Population |  | 162344 | 10000 | 172344 | 8574 | 180918 | Increased by PSAP during 9/28/11 reallocations to contract for an additional 167 bed days based on projected need. Based on decrease scenario staging, service would be restored an additional $35,000 but only increased $8,574 based on year-end projected expenses of $180,918.
 | Transitional Housing: Substance Users |  | 192685 | 0 | 192685 | 0 | 192685
8 | Food Bank / Home Delivered Meals |  | 142000 | 0 | 142000 | 25575 | 167575
 | Food Bank |  | 99000 | 0 | 99000 | 13564 | 112564 | Increase based on decrease scenario staging. Year-end projected expenses are $120,145.
 | Home Delivered Meals |  | 43000 | 0 | 43000 | 12011 | 55011 | Increase based on decrease scenario staging. Year-end projected expenses are $55,011.
10 | Nutritional Supplements |  | 57584 | 0 | 57584 | 13258 | 70842 | Increase based higher costs for supplements.  Allocation will provide 103 additional supplement orders.
11 | Medical Transportation Services |  | 235000 | 0 | 235000 | 17514 | 252514 | Increase based on decrease scenario staging. Year-end projected expenses are $345,719. FY10 final expenditures were $256,268.
 | General Population |  | 151095 | 0 | 151095 | 11077 | 162172 | Increase based on decrease scenario staging. Year-end projected expenses are $255,377.
 | General Population-ASF |  | 146437 | 0 | 146437 | 11077 | 157514 | Increase based on decrease scenario staging. Year-end projected expenses are $255,377.
 | General Population-APAIT |  | 700 | 0 | 700 | 0 | 700
 | General Population-Delhi |  | 3958 | 0 | 3958 | 0 | 3958
 | Substance Users |  | 83905 | 0 | 83905 | 6437 | 90342
12 | Substance Abuse Services: Residential Services / Detox |  | 232764 | 26850 | 259614 | 10000 | 269614
 | Residential |  | 222764 | 22000 | 244764 | 10000 | 254764 | Increased by PSAP during 9/28/11 reallocations to contract for an additional 170 bed days based on projected need. Based on decrease scenario staging, this service gets restored to $248,264. Additional $6,500 allocated will cover one-time program expenses.
 | Detox Services |  | 10000 | 4850 | 14850 | 0 | 14850
13 | Legal Services |  | 74145 | 0 | 74145 | 1750 | 75895 | Increase based on decrease scenario staging. Year-end projected expenses are $75,895.
14 | Outreach Services |  | 0 | 0 | 0 | 0 | 0
15 | Independent Skills |  | 10750 | 0 | 10750 | 2214 | 12964 | Increase based on decrease scenario staging. Year-end projected expenses are $12,964.
16 | Prevention with Positives |  | 0 | 0 | 0 | 0 | 0
17 | Nutritional Counseling |  | 0 | 0 | 0 | 0 | 0
 | Support Services Total |  | 1707761 | 29991 | 1737752 | 28807 | 1766559
 | Total Service Dollars |  | 5659694 |  | 5659694 | 228454 | 5888148
 | [NAME] (10% of Part A and MAI, 7% HOPWA) |  | 619948 | 0 | 619948 | 30911.09999999998 | 650859.1 | Increase based on decrease scenario staging.
 | Quality Management (5% of Part A and MAI) |  | 238370 | 0 | 238370 | 12745.54999999999 | 251115.55 | Increase based on decrease scenario staging. Full amount based on decrease scenario staging was not restored in order to provide additional funding to direct services. Spreadsheet approved by PC on 10/12/11 had a formula error indicating a $62,550 decrease to non-medical case management, causing overall allocations to be over by $10,684. In order to maintain service dollars, this difference was taken from QM.
 | TOTAL |  | 6518012 | 0 | 6518012 | 272110.65 | 6790122.65
 |  |  | 0.8235214808967701 | 0 | 0.8172718221263469 |  | 0.8038554975390442 | Percent Part A and MAI Core Services (HRSA requirement is 75%)
*Based on approved staging of allocations, the total allocation for HOPWA is reduced to $814,133 (Service dollars: $760,872), which represents a savings of $107,000 from the FY11 HOPWA award of $921,133.
 |  |  |  |  |  |  |  | Revised 10/13/11
 | FY 2011 Funding (NGA 8/30/11): |  | Total | Service Dollars | [NAME] | QM
 | Part A: |  | 5230538 | 4487430 | 523053.8 | 220053.9 | WITH QM REDUCED BY $41,473 BASED ON DECREASE STAGING
 | Part A Carryover Request $15,609 (Pending Approval): |  | 0 | 0 | 0 | 0
 | Minority AIDS Initiative (MAI): |  | 366341 | 311390 | 36634.1 | 18317.05
 | HOPWA: |  | 921133 | 860872 | 60261.04000000001 | 0
 | TOTAL: |  | 6518012 | 5659692 | 619948.9400000001 | 238370.95
 |  |  | Total | Service Dollars | [NAME] | QM
 |  |  | 5609649 | 4809674.649999999 | 560964.9 | 239009.45 | WITH QM REDUCED BY $41,473 BASED ON DECREASE STAGING
 |  |  | 0 | 0 | 0 | 0
 |  |  | 366341 | 311390 | 36634.1 | 18317.05
 |  |  | 921133 | 860872 | 60261.04000000001 | 0
 |  |  | 6897123 | 5981936.649999999 | 657860.04 | 257326.5
 |  |  | 379111 | 322244.6499999994 | 37911.09999999998 | 18955.54999999999
 | FY 2011 Funding (NGA 9/12/11): |  | Total | Service Dollars | [NAME] | QM | WITH HOPWA SERVICE REDUCED BY $100,000 AND QM REDUCED BY $41,473
 | Part A: |  | 5609649 | 4809674.649999999 | 560964.9 | 239009.45
 | Part A Carryover Request $15,609 (Pending Approval): |  | 0 | 0 | 0 | 0
 | Minority AIDS Initiative (MAI): |  | 366341 | 311390 | 36634.1 | 18317.05
 | HOPWA: |  | 814133 | 760872 | 53261.04000000001 | 0
 | FY 2011 TOTAL: |  | 6790123 | 5881936.649999999 | 650860.04 | 257326.5
 | Difference from 8/30/11 NGA and 9/12/11 NGA : |  | 272111 | 222244.6499999994 | 30911.09999999998 | 18955.54999999999
 |  |  | Total | Service Dollars | [NAME] | QM | WITH HOPWA SERVICE REDUCED BY $100,000 AND QM REDUCED BY $36,999
 |  |  | 5609649 | 4815884.649999999 | 560964.9 | 232799.45
 |  |  | 0 | 0 | 0 | 0
 |  |  | 366341 | 311390 | 36634.1 | 18317.05
 |  |  | 814133 | 760872 | 53261.04000000001 | 0
 |  |  | 6790123 | 5888146.649999999 | 650860.04 | 251116.5 | 0.3500000000349246
 |  |  | 272111 | 228454.6499999994 | 30911.09999999998 | 12745.54999999999