BUDGET TRUE-UP RE FY14 MCDPH .PDF

FY14 BUDGET APPROPRIATION ADJUSTMENT
Grant Summary Worksheet
Date FY ends 6/30/2014
Dept: 860 - Public Health
Fund: 532 - Grant Fund If new grant
put in "0" Formula Formula
Difference bet Grant Amount Indirect Exp
Grant Expended Thru FY FY 2014 Revised FY2014 Proposed Direct Exp FY Indirect Cost Comment
Agenda Item Grant Start Date End Date Rptg Cat Activity Total Award Revised and Remaining for Recoverable
Source 2013 Budget (ADOPTED) Changes 2014 Rate
Propsed Future Years FY 2014
Federal C-86-11-020-G-04 Grant 9/30/2012 9/29/2013 DC13 OPIP 300,000 222,032 75,000 77,968 2,968 - 67,330 10,638 15.80%
Federal C-86-11-020-G-04 Performance Improvement 9/30/2013 9/29/2014 DC14 OPIP 300,000 - 225,000 225,000 - 75,000 195,652 29,348 15.00%
Federal C-86-11-020-G-06 Performance Improvement Carryover 9/30/2012 9/29/2013 D12C OPIP 28,179 - - 28,179 28,179 - 24,334 3,845 15.80%
Other C-86-13-008-G-01 Quality Improvement NNPHI 12/1/2012 7/31/2013 PQ13 OPIP 5,000 2,497 - 2,503 2,503 - 2,503 - 0.00%
Other C-86-13-079-G-00 Robert Wood Johnson Foundation 4/15/2013 1/14/2015 RJ13 OPIP 237,845 2,431 - 145,742 145,742 89,672 130,127 15,615 12.00%
Federal C-86-12-021-3-08 Office of Preparedness and Response 7/1/2012 9/30/2013 EM45 EMRT 3,017,326 2,502,966 - 514,360 514,360 - 444,180 70,180 15.80%
Federal C-86-12-021-3-07 Office of Preparedness and Response 7/1/2013 6/30/2014 EM46 EMRT 250,000 - 250,000 250,000 - 250,000 - 0.00%
Federal C-86-12-021-3-08 Office of Preparedness and Response 7/1/2013 6/30/2014 EM55 EMRT 2,691,759 3,241,575 2,691,759 (549,816) - 2,340,660 351,099 15.00%
Other C-86-12-033-3-01 West Nile Virus Services 10/1/2011 11/30/2013 WV12 EPIR 83,000 47,554 - 35,446 35,446 - 30,610 4,836 15.80%
Other C-86-13-075-3-00 Syndromic Surveillance 3/1/2013 2/28/2014 SS13 EPIR 39,400 14,850 - 24,550 24,550 - 21,200 3,350 15.80%
Other FREE B - IFT Reimbursement 10/1/2013 9/30/2014 FB14 SCII 4,000 - - 4,000 4,000 - 4,000 - 0.00%
Other C-86-13-012-3-02 Children Health Consultation 7/1/2013 6/30/2014 CC15 CCHC 1,042,521 - 1,059,615 1,042,541 (17,074) - 947,765 94,776 10.00%
Other C-86-13-108-3-00 CCHC Health Champion Training 7/1/2013 6/30/2014 CC51 CCHC 55,000 167,596 55,000 (112,596) - 50,000 5,000 10.00%
Other C-86-14-026-3-00 Empower Plus Grant 9/1/2013 8/31/2014 EP14 CCHC 83,880 - 69,899 69,899 13,981 60,782 9,117 15.00%
Federal C-86-13-074-3-00 Immunization Program 1/1/2013 12/31/2013 CK39 CHIM 1,548,677 664,476 624,385 884,201 259,816 - 763,559 120,642 15.80%
Federal Immunization Program 1/1/2014 12/31/2014 CL39 CHIM 1,248,771 624,385 624,385 - 624,386 542,943 81,442 15.00%
Federal Immunization Fund Balance 7/1/2013 6/30/2013 IROL CHIM 680,000 680,000 680,000 - - 582,691 97,309 16.70%
Other Americare Non Monetary Donation 7/1/2013 6/30/2013 AC14 CHIM 841,500 841,500 841,500 - - 841,500 - 0.00%
Federal C-86-14-016-3-01 Hansens Disease 4/12/2012 9/12/2013 PG84 HANS 44,927 25,750 - 19,177 19,177 - 16,560 2,617 15.80%
Federal C-86-14-016-3-00 Hansens Disease 9/1/2013 12/31/2013 PH84 HANS 12,836 28,881 12,836 (16,045) - 11,162 1,674 15.00%
Federal Hansens Disease 1/1/2014 12/31/2014 PI84 HANS 40,305 9,629 9,629 - 30,676 8,373 1,256 15.00%
Federal C-86-12-028-3-00 TB Research 9/29/2012 9/28/2013 TR02 TBIN 300,141 164,101 75,035 136,040 61,005 - 117,478 18,562 15.80%
Federal C-86-12-028-3-01 TB Research 9/28/2013 9/28/2014 TR03 TBIN 359,158 238,475 180,976 (57,499) 178,182 157,370 23,606 15.00%
State C-86-14-002-3-00 TB Control State 7/1/2013 6/30/2014 PP89 TBTE 281,650 106 281,650 281,650 - - 244,913 36,737 15.00%
Federal C-86-13-076-3-00 TB-HIV Federal 1/1/2013 12/31/2013 TF13 TBTE 319,991 132,430 161,077 187,561 26,484 - 161,970 25,591 15.80%
Federal TB-HIV Federal 1/1/2014 12/31/2014 TF14 TBTE 322,155 161,078 138,078 (23,000) 184,077 120,068 18,010 15.00%
Other Basha's Voucher Donation 7/1/2013 6/30/2013 TB14 TBTE 3,000 3,000 3,000 - - 3,000 - 0.00%
Federal C-86-10-007-3-05 Refugee RMAP Fees 7/1/2013 6/30/2013 RF14 HERF 1,250,000 1,250,000 1,250,000 - - 1,086,957 163,043 15.00%
Federal C-86-10-007-3-05 Refugee 7/1/2013 6/30/2013 RM14 HERF 167,342 167,342 167,342 - - 145,515 21,827 15.00%
Federal C-86-10-120-3-08 STD Infertility Prevention Project 1/1/2013 12/31/2013 PP57 STEX 33,301 9,503 23,730 23,798 68 - 20,551 3,247 15.80%
Federal C-86-10-120-3-09 STD Infertility Prevention Project 1/1/2013 12/31/2013 P57P STEX 6,000 - - 6,000 6,000 - 5,217 783 15.00%
Federal STD Infertility Prevention Project 1/1/2014 12/31/2014 PP67 STEX 47,460 23,730 23,730 - 23,730 20,635 3,095 15.00%
Other C-86-11-062-3-00 Terros-Syphilis Lab Testing 9/1/2010 12/31/2013 T127 STEX 10,000 8,389 4,604 1,611 (2,993) - 1,377 234 17.00%
Other C-20-10-077-G-01 Gila River Indian Community STD 8/3/2011 7/25/2013 GR12 STSV 85,000 55,157 - 29,843 29,843 - 29,843 - 0.00%
Other C-20-10-077-G-01 Gila River Indian Community STD 8/3/2011 3/31/2014 GR13 STSV 65,000 - 36,945 29,860 (7,085) - 29,860 - 0.00%
Federal C-86-13-065-3-00 STD Control 1/1/2013 12/31/2013 ST13 STSV 354,698 133,098 177,349 178,502 1,153 - 154,147 24,355 15.80%
Federal STD Control 1/1/2014 12/31/2014 ST14 STSV 354,698 177,349 145,968 (31,381) 208,730 126,929 19,039 15.00%
Federal C-86-02-073-2-30 Healthcare for the Homeless 11/1/2012 10/31/2013 H33A HCHL 121,293 - - 121,293 121,293 - 105,472 15,821 15.00%
Federal C-86-02-073-2-29 Healthcare for the Homeless 11/1/2012 10/31/2013 H333 HCHL 2,536,437 1,626,683 845,479 909,754 64,275 - 792,902 116,852 15.80%
Federal C-86-02-073-2-32 Healthcare for the Homeless 11/1/2013 10/31/2014 H433 HCHL 2,580,229 1,690,958 1,690,958 - 889,271 1,484,311 206,647 15.00%
Other C-86-02-073-2-29 Healthcare for the Homeless-Program Income 11/1/2012 10/31/2013 HJ29 HCHL 200,000 43,314 66,667 36,654 (30,013) - 31,653 5,001 15.80%
Other Healthcare for the Homeless-Program Income 11/1/2013 10/31/2014 HK29 HCHL 200,000 133,333 104,816 (28,517) 95,184 91,144 13,672 15.00%
Other HCH-Pfizer Pharmaceutical 7/1/2013 6/30/2013 H704 HCHL 65,000 65,000 65,000 - - 65,000 - 0.00%
Other Non Cash HIV test Kits 7/1/2013 6/30/2013 P993 HICT 20,000 20,000 20,000 - - 20,000 - 0.00%
Federal C-86-13-050-3-01 HIV Counseling and Testing 7/1/2013 6/30/2013 HV14 HICT 798,299 798,299 798,299 - - 715,717 82,582 15.00%
Federal C-86-13-003-3-01 HIV Surveillance 1/1/2013 12/31/2013 SH13 HISV 115,808 43,725 57,904 72,083 14,179 - 64,678 7,405 15.00%
Federal HIV Surveillance 1/1/2014 12/31/2014 SH14 HISV 115,808 57,904 57,904 - 57,904 50,782 7,122 15.00%
Federal C-86-11-047-3-03 Community Health Grant 1/1/2013 12/31/2013 CH13 PHPD 300,000 149,817 150,000 150,183 183 - 129,692 20,491 15.80%
Federal Community Health Grant 1/1/2014 12/31/2014 CH14 PHPD 300,000 150,000 150,000 - 150,000 130,435 19,565 15.00%
Federal C-86-12-048-3-01 Chronic Disease Health Policy 2/12/2013 1/31/2014 PY13 PHPD 412,370 121,894 240,549 290,476 49,927 - 282,478 7,998 15.00%
Federal Chronic Disease Health Policy 2/12/2014 2/11/2015 PY14 PHPD 412,370 171,821 171,821 - 240,549 166,108 5,713 15.00%
Federal C-86-12-077-3-00 Population Health Policy 4/1/2012 3/31/2014 PP12 PHPD 398,900 317,165 - 81,735 81,735 - 70,583 11,152 15.80%
Federal C-86-12-077-3-01 Population Health Policy 4/1/2013 3/31/2014 PP13 PHPD 398,900 82,844 299,175 316,056 16,881 - 272,933 43,123 15.80%
Federal Population Health Policy 4/1/2014 3/31/2015 PP14 PHPD 398,900 99,726 99,726 - 299,174 86,718 13,008 15.00%
Other Tohono O'odham 7/1/2013 6/30/2014 TE14 PHPD 50,000 - 50,000 50,000 - 50,000 - 0.00%
Other Gila River Indian Community 7/1/2013 6/30/2014 GR14 PHPD 50,000 - 50,000 50,000 - 50,000 - 0.00%
Federal C-86-11-027-3-00 Safe Routes to School 1/1/2013 12/31/2013 SR38 CCSS 64,756 30,756 17,500 34,000 16,500 - 29,361 4,639 15.80%
Federal C-86-13-036-3-00 Safe Routes to School 1/1/2013 12/31/2013 SR13 CCSS 45,000 3,065 22,500 25,000 2,500 - 21,589 3,411 15.80%
Other C-86-13-102-3-00 South Phoenix Prevention Health Collaboration 7/1/2013 6/30/2013 FP14 FHPT 300,000 325,000 300,000 (25,000) - 272,727 27,273 10.00%
Federal C-86-11-064-3-02 Dietetic Internship 10/1/2012 9/30/2013 AD13 DTIN 93,930 60,188 23,483 14,334 (9,149) - 12,378 1,956 15.80%
Federal C-86-11-064-3-03 Dietetic Internship 10/1/2013 9/30/2014 AD14 DTIN 92,327 70,447 69,936 (511) 22,391 60,814 9,122 15.00%
Federal C-86-13-016-G-01 AZNN-SNAP ED 10/1/2012 9/30/2013 SE13 SCNT 2,312,156 1,089,367 770,719 619,903 (150,816) - 570,586 49,317 15.80%
Federal C-86-13-016-G-02 AZNN-SNAP ED 10/1/2013 9/30/2013 SE14 SCNT 3,071,075 2,312,155 2,379,395 67,240 - 2,170,172 209,223 15.00%
Federal Ryan White Planning Council 3/1/2013 3/1/2013 A920 RWPC - (41,516) - 41,516 - - - 10.00% moved to another dept
Federal Ryan White Planning Council 3/1/2014 3/1/2013 A921 RWPC - 57,085 - (57,085) - - - 10.00%
State C-86-12-086-3-01 Prop 201 Smoke Free Compliance 7/1/2013 6/30/2014 SF14 SFAZ 904,613 904,613 883,439 (21,174) - 768,208 115,231 15.00%
State C-86-10-001-3-05 Tobacco Use Prevention 7/1/2013 6/30/2014 CE14 TUPV 2,242,634 2,061,021 2,087,813 26,792 - 1,908,198 179,615 15.00%
Other Delta Dental of AZ Foundation 7/1/2013 6/30/2014 DD13 DTSL 148,108 148,108 102,759 (45,349) - 89,356 13,403 15.00%
Other C-86-13-109-3-00 FTF Oral Health Education-Central Phoenix 7/1/2013 6/30/2014 DP14 DTSL 400,000 - 400,000 400,000 - 363,636 36,364 10.00%
Other C-86-13-0204-3-01 Fluoride Varnish Services 9/1/2012 8/31/2013 FV13 DTSL 179,749 161,347 203,416 18,402 (185,014) - 16,729 1,673 10.00%
Other C-86-13-024-3-02 Fluoride Varnish Services 9/1/2013 8/31/2014 FV14 DTSL 179,749 - 179,749 179,749 - 163,408 16,341 10.00%

Federal C-86-13-064-3-01 Dental Sealant 1/1/2013 12/31/2013 D488 DTSL 311,990 105,705 169,108 206,285 37,177 - 189,961 16,324 10.00%
Federal Dental Sealant 1/1/2014 12/31/2014 D588 DTSL 338,216 169,108 169,108 - 169,108 158,352 10,756 10.00%
Other C-86-11-014-3-05 FTF Oral Health 7/1/2013 6/30/2014 DF04 DTSL 726,484 768,906 768,906 - - 699,005 69,901 10.00%
State C-86-10-001-3-05 Oral Health Tobacco 7/1/2013 6/30/2014 CE92 TUTR 65,043 56,974 65,043 8,069 - 57,837 7,206 15.00%
Federal C-86-11-004-3-05 Breastfeeding Peer Counseling 10/1/2012 9/30/2013 BF13 WICC 757,654 537,224 189,413 220,430 31,017 - 190,354 30,076 15.80%
Federal C-86-14-023-3-00 Breastfeeding Peer Counseling 10/1/2013 9/30/2014 BF14 WICC 475,000 568,241 356,250 (211,991) 118,750 309,783 46,467 15.00%
Federal C-86-11-004-3-05 Women Infants and Children 10/1/2012 9/30/2013 WN13 WICC 10,455,398 7,847,480 2,613,850 2,607,918 (5,932) - 2,252,088 355,830 15.80%
Federal C-86-11-023-3-00 Women Infants and Children 10/1/2013 9/30/2014 WN14 WICC 10,828,155 7,841,549 8,121,116 279,567 2,707,039 7,061,840 1,059,276 15.00%
Federal WIC Farmers Market 10/1/2013 9/30/2014 FM14 WICC 1,500 1,500 1,500 - - 1,304 196 15.00%
Federal C-86-02-165-2-21 Healthy Start 2/1/2013 1/31/2014 HS88 HEED 378,880 180,859 233,338 198,021 (35,317) - 180,019 18,002 10.00%
Federal Healthy Start 2/1/2014 1/31/2015 HS98 HEED 400,000 166,662 166,662 - 233,338 151,511 15,151 10.00%
Other C-86-13-110-3-00 Prenatal Outreach Central Phoenix 7/1/2013 6/30/2014 CP50 HEED 399,994 287,559 399,994 112,435 - 363,631 36,363 10.00%
Other C-86-13-013-3-01 Prenatal Outreach South Phoenix 7/1/2013 6/30/2014 SP50 HEED 400,461 400,461 400,461 - - 364,055 36,406 10.00%
Federal C-86-12-067-3-00 Lead Hazard 1/1/2012 12/31/2014 L415 LHZR 352,750 143,398 116,675 116,676 1 92,676 99,979 16,697 16.70%
Federal C-86-10-008-3-11 Neonatal Intensive Care 7/1/2012 6/30/2014 NL56 NEWB 490,740 476,897 - 13,843 13,843 - 11,954 1,889 15.80%
Federal C-86-10-008-3-11 Neonatal Intensive Care 7/1/2013 6/30/2014 NL57 NEWB 468,001 491,956 468,001 (23,955) - 406,957 61,044 15.00%
Other C-86-13-007-3-01 Nurse Family Partnership 7/1/2013 6/30/2014 N610 NFAM 559,837 559,837 559,837 - - 508,943 50,894 10.00%
Federal C-86-12-082-3-01 Nurse Family Partnership-Home Visit 10/1/2012 9/30/2013 NF13 NFAM 1,233,545 520,374 273,069 352,019 78,950 - 321,726 30,293 15.80%
Federal C-86-14-004-3-00 Nurse Family Partnership-Home Visit 10/1/2013 9/30/2014 NF14 NFAM 908,780 819,206 681,585 (137,621) 227,195 608,987 72,598 15.00%
Other C-86-12-072-3-00 SG Komen 4/1/2013 3/31/2014 SG04 WWHC 75,000 75,000 112,500 - (112,500) - - - 0.00%
Other SG Komen 4/1/2014 3/31/2015 SG05 WWHC - 37,500 - (37,500) - - - 0.00% cancelled
Other SG Komen 4/1/2013 3/31/2014 SG06 WWHC - 56,250 - (56,250) - - - 0.00% cancelled
Other SG Komen 4/1/2014 3/31/2015 SG07 WWHC - 18,750 - (18,750) - - - 0.00% cancelled
Federal C-86-10-131-3-02 Well Woman Health Check 7/1/2012 9/30/2013 CH61 WWHC 747,000 715,700 - 31,300 31,300 - 31,300 - 0.00%
Federal C-86-13-026-G-01 Well Woman Health Check 7/1/2013 12/31/2013 CH62 WWHC 259,250 825,000 259,250 (565,750) - 248,120 11,130 15.00% award till Dec 2013 only
Other C-86-12-084-3-01 Prevention and Education 7/1/2013 6/30/2014 PE50 CCSS 850,000 850,000 850,000 - - 772,727 77,273 10.00%
Other Virginia Piper-Find Help Phoenix 10/1/2013 9/30/2013 VP14 CCSS 50,000 - 33,334 33,334 - 28,986 4,348 15.00%
Federal PHA-1300 Ryan White Dental Insurance 3/1/2013 2/28/2014 D873 DTIS 894,207 333,516 927,280 560,691 (366,589) - 554,507 6,184 10.00%
Federal Ryan White Dental Insurance 3/31/2014 2/28/2015 D973 DTIS 1,384,000 461,333 461,333 - 922,667 456,136 5,197 10.00%
State C-86-13-046-3-00 Teen Pregnancy Prevention 1/1/2013 12/31/2013 PR95 TNPP 229,837 91,984 114,919 137,853 22,934 - 119,044 18,809 15.80%
State Teen Pregnancy Prevention 1/1/2014 12/31/2014 PR96 TNPP 229,837 114,919 114,919 - 114,918 99,930 14,989 15.00%
Federal C-86-11-018-3-03 Adolescent Health for Teen Pregnancy Prevention 9/1/2012 8/31/2013 PF13 TNPP 859,620 682,501 143,270 177,119 33,849 - 159,775 17,344 15.80%
Federal C-86-11-018-3-04 Adolescent Health for Teen Pregnancy Prevention 9/1/2013 8/31/2014 PF14 TNPP 859,620 716,350 716,350 - 143,270 655,522 60,828 15.00%
TOTAL GRANT REVENUE 72,013,730 19,426,143 42,185,759 42,589,926 404,167 7,911,868 37,933,862 4,656,064
615 Grants 41,214,946 404,167
638 Patient Service-Program Income 200,000
650 Miscellaneous-Non Cash 926,500
Requested 42,341,446
ADOPTED 42,185,759
Ryan White-Cut 155,687