FY2015 BUD PREP SUPPORTING DOC.PDF

FY 2015 Budget Preparation - Supporting Documentation
Grant Summary Worksheet - Object Code 615 Detail
Dept: 860 - Public Health
Fund: 532 - Grant Fund If new grant
6/30/2015 put in "0" Formula
Grant
FY 2015 Amount
Grant Expended FY15 FY 2015
Grant Start Date End Date Rptg Cat Activity Total Award Adopted Remaining
Source Thru FY 2014 Available Forecast
Budget for Future
Years
Federal Performance 9/30/2013 9/29/2014 DC14 OPIP 300,000 176,076 123,924 123,924 75,000 -
Federal Performance 9/30/2014 9/29/2015 DC15 OPIP - - - - 225,000 -
Other Perf Improvem 4/15/2013 1/14/2015 RJ13 OPIP 236,053 122,127 113,926 113,926 145,742 -
Federal Office of Prep 7/1/2013 9/30/2014 EM55 EMRT 2,691,759 2,543,690 148,069 148,069 - -
Federal Office of Prep 7/1/2014 6/30/2015 EM65 EMRT 1,914,190 - 1,914,190 1,914,190 2,691,759 -
Federal Office of Prep 7/1/2014 6/30/2015 EM65 EPIR 403,001 - 403,001 403,001 - -
Federal Office of Prep 7/1/2014 6/30/2015 EM65 SCII 419,960 - 419,960 419,960 - -
Federal Syndromic Su 11/1/2013 8/31/2014 SS14 EPIR 47,436 33,301 14,135 14,135 9,487 -
Other Childcare Hea 7/1/2014 6/30/2015 C15A CCHC 1,033,670 - 1,033,670 1,033,670 1,042,541 -
Other CCHC Technic 7/1/2014 6/30/2015 CC15 CCHC 55,000 - 55,000 55,000 55,000 -
Federal Empower Plus 7/1/2014 6/30/2015 EP15 CCHC 83,880 - 83,880 83,880 69,899 -
Federal Immunization 1/1/2014 12/31/2014 CL39 CHIM 1,436,592 586,527 850,065 850,065 884,200 -
Federal Immunization 1/1/2015 12/31/2015 FL15 CHIM 116,651 - 116,651 116,651 - -
Federal Immunization 1/1/2015 12/31/2015 CM39 CHIM 1,548,677 - 1,548,677 774,338 884,200 774,339
Federal Immunization 7/1/2014 6/30/2015 IROL CHIM 680,000 - 680,000 680,000 680,000 -
Federal Hansen's Dise 4/1/2014 3/31/2015 PJ84 HANS 40,305 22,940 17,365 17,365 30,229 -
Federal Hansen's Dise 4/1/2015 3/31/2016 PK84 HANS 40,740 - 40,740 10,076 10,076 30,664
Federal TB Research 9/29/2013 9/28/2014 TR03 TBIN 359,158 292,506 66,652 66,652 89,789 -
Federal TB Research 9/29/2014 9/28/2015 TR04 TBIN 359,158 - 359,158 269,369 269,369 89,789
State TB Control - S 7/1/2014 6/30/2015 PQ89 TBTE 281,650 - 281,650 281,650 281,650 -
Federal TB/HIV - Fede 1/1/2014 12/31/2014 TF14 TBTE 355,991 162,094 193,897 193,897 177,996 -
Federal TB/HIV - Fede 1/1/2015 12/31/2015 TF15 TBTE 355,991 - 355,991 177,995 177,995 177,996
Other Bashas Vouch 7/1/2014 6/30/2015 TB15 TBTE 3,000 - 3,000 3,000 3,000 -
Federal Refugee RMA 7/1/2014 6/30/2015 RF15 HERF 1,250,000 - 1,250,000 1,250,000 1,250,000 -
Federal Refugee Gran 7/1/2014 6/30/2015 RM15 HERF 167,342 - 167,342 167,342 167,342 -
Other Non-cash HIV 7/1/2014 6/30/2015 P993-NEW STEX 20,000 - 20,000 20,000 20,000 -
Federal HIV Counselin 7/1/2014 6/30/2015 HV15 STEX 798,299 - 798,299 798,299 798,299 -
Federal HIV Surveillan 1/1/2014 12/31/2014 SH14 STSV 115,808 43,688 72,120 72,120 72,083 -
Federal HIV Surveillan 1/1/2015 12/31/2015 SH15 STSV 115,808 - 115,808 57,904 57,904 57,904
Federal STD Control 1/1/2014 12/31/2014 ST14 STSV 390,120 171,573 218,547 218,547 178,502 -
Federal STD Control 1/1/2015 12/31/2015 ST15 STSV 354,698 - 354,698 177,350 177,350 177,348

Federal Healthcare fo 11/1/2013 10/31/2014 H433 HCHL 2,681,588 1,678,936 1,002,652 901,293 860,076 -
Federal Healthcare fo 11/1/2014 10/31/2015 H533 HCHL 2,580,229 - 2,580,229 1,720,153 1,720,153 860,076
Other Healthcare fo 11/1/2013 10/31/2014 HK29 HCHL 353,500 104,258 249,242 115,742 140,000 -
Other Healthcare fo 11/1/2014 10/31/2015 HL29 HCHL 420,000 - 420,000 280,000 280,000 140,000
Other HCH - Non-cas 7/1/2014 6/30/2015 H705 HCHL 150,000 - 150,000 50,000 150,000 -
Federal Community H 1/1/2014 12/31/2014 CH14 PHPD 300,000 150,705 149,295 149,295 150,000 -
Federal Community H 1/1/2015 12/31/2015 CH15 PHPD 300,000 - 300,000 150,000 150,000 150,000
Federal Chronic Disea 4/1/2014 3/31/2015 PY15 PHPD 299,000 47,188 251,812 251,812 309,278 -
Federal Chronic Disea 4/1/2015 3/31/2016 PY16 PHPD 299,000 - 299,000 74,750 103,092 224,250
Federal Population He 4/1/2014 3/31/2015 PP15 PHPD 398,900 46,475 352,425 352,425 299,175 -
Federal Population He 4/1/2015 3/31/2016 PP16 PHPD 398,900 - 398,900 99,725 99,725 299,175
Other Gila River Indi 10/1/2013 10/20/2014 GR14 PHPD 50,000 21,891 28,109 28,109 20,000 -
Other Tohono O'odh 7/1/2013 10/31/2014 TE14 PHPD 50,000 30,902 19,098 19,098 20,000 -
Federal Safe Routes to 1/1/2013 12/31/2013 SR13 CCSS 45,000 26,260 18,740 18,740 15,500 -
Other South Phx Pre 7/1/2014 6/30/2015 FP15 FHPT 300,000 - 300,000 300,000 300,000 -
Federal Dietetic Intern 10/1/2013 9/30/2014 AD14 DTIN 93,930 64,026 29,904 29,904 23,082 -
Federal Dietetic Intern 10/1/2014 9/30/2015 AD15 DTIN 93,327 - 93,327 69,245 69,245 24,082
Federal AZNN - SNAP- 10/1/2013 9/30/2014 SE14 SCNT 3,070,940 1,408,118 1,662,822 1,441,882 767,735 -
Federal AZNN - SNAP- 10/1/2014 9/30/2015 SE15 SCNT 3,070,940 - 3,070,940 2,303,205 2,303,205 767,735
Federal Public Health 1/1/2014 12/31/2014 DH14 SCNT 100,000 - 100,000 100,000 - -
Federal Public Health 1/1/2015 6/30/2015 DH15 SCNT 50,000 - 50,000 50,000 - -
State Smoke-Free C 7/1/2014 6/30/2015 SF15 SFAZ 904,613 - 904,613 904,613 904,613 -
State Tobacco Use P 7/1/2014 6/30/2015 CE15 TUPV 2,123,000 - 2,123,000 2,123,000 1,993,634 -
State Hypertension/ 5/1/2014 12/31/2014 HP14 TUPV 97,184 - 97,184 97,184 - -
State Hypertension/ 1/1/2015 6/30/2015 HP15 TUPV 85,000 - 85,000 85,000 - -
Other Delta Dental o 7/1/2014 6/30/2015 DD14 DTSL 88,374 - 88,374 88,374 88,374 -
Other FTF Health Ed 7/1/2014 6/30/2015 DP15 DTSL 400,000 - 400,000 400,000 400,000 -
Other Fluoride Varn 7/1/2014 6/30/2015 FV15 DTSL 179,749 - 179,749 179,749 265,338 -
Federal Dental Sealan 1/1/2014 12/31/2014 D588 DTSL 337,986 98,393 239,593 182,587 168,993 -
Federal Dental Sealan 1/1/2015 12/31/2015 D688 DTSL 337,986 - 337,986 168,993 168,993 168,993
Other FTF Oral Healt 7/1/2014 6/30/2015 DF05 DTSL 726,484 - 726,484 726,484 726,484 -
State Oral Health To 7/1/2014 6/30/2015 CE93 TUTR 88,225 - 88,225 88,225 65,043 -
Federal Breastfeeding 10/1/2013 9/30/2014 BF14 WICC 475,000 344,027 130,973 130,973 118,750 -
Federal Breastfeeding 10/1/2014 9/30/2015 BF15 WICC 475,000 - 475,000 356,250 356,250 118,750
Federal Women, Infan 10/1/2013 9/30/2014 WN14 WICC 10,828,155 7,600,818 3,227,337 3,105,337 2,707,039 -
Federal Women, Infan 10/1/2014 9/30/2015 WN15 WICC 10,828,155 - 10,828,155 7,512,765 8,121,116 3,315,390
Federal WIC Farmers 10/1/2013 9/30/2014 FM14 WICC 4,374 4,374 - - 869 -
Federal WIC Farmers 10/1/2014 9/30/2015 FM15 WICC 3,476 - 3,476 2,607 2,607 869
Federal Healthy Start 2/1/2014 1/31/2015 HS98 HEED 378,880 159,385 219,495 219,495 221,013 -
Federal Healthy Start 2/1/2015 1/31/2016 HS98-NEW HEED - - - - 157,867 -
Federal Donation-Bab 9/1/2014 6/30/2015 BW15 HEED 2,500 - 2,500 2,500 - -
Other FTF-PHX Nort 7/1/2014 6/30/2015 CP60 HEED 399,986 - 399,986 399,986 399,994 -
Other FTF Prenatal O 7/1/2014 6/30/2015 SP60 HEED 399,806 - 399,806 399,806 400,461 -

Federal Lead Hazard 1/1/2012 12/31/2014 L415 LHZR 352,750 282,087 70,663 70,663 120,658 -
Federal Neonatal Inte 7/1/2014 6/30/2015 NL15 NEWB 466,221 - 466,221 466,221 468,001 -
Other FTF Nurse Fam 7/1/2014 6/30/2015 N710 NFAM 579,599 - 579,599 579,599 602,734 -
Federal Nurse Family 10/1/2013 9/30/2014 NF14 NFAM 1,594,246 1,022,821 571,425 563,520 396,584 -
Federal Nurse Family 10/1/2014 9/30/2015 NF15 NFAM 1,586,341 - 1,586,341 1,189,756 1,189,757 396,585
Other FTF Preventio 7/1/2014 6/30/2015 PE60 CCSS 850,000 - 850,000 850,000 850,000 -
Other FTF- Find Help 7/1/2014 6/30/2015 FH15 CCSS 100,000 - 100,000 100,000 - -
Other Virginia Piper 10/14/2013 10/13/2014 VP14 CCSS 50,000 2,700 47,300 47,300 12,500 -
Other Virginia Piper 10/14/2014 10/13/2015 VP15 CCSS 50,000 - 50,000 37,500 37,500 12,500
Federal Ryan White D 3/1/2014 2/28/2015 D973 DTIS 1,318,250 239,161 1,079,089 1,079,089 560,691 -
Federal Ryan White D 3/1/2015 2/28/2016 D973-NEW DTIS 894,207 - 894,207 340,787 340,787 553,420
State Teen Pregnan 1/1/2014 12/31/2014 PR96 TNPP 229,837 92,518 137,319 137,319 114,919 -
State Teen Pregnan 1/1/2015 12/31/2015 PR96-NEW TNPP 229,837 - 229,837 114,918 114,918 114,919
Federal Adolescent He 9/1/2013 8/31/2014 PF14 TNPP 943,226 652,771 290,455 290,455 157,204 -
Federal Adolescent He 9/1/2014 8/31/2015 PF15 TNPP 859,620 - 859,620 716,350 716,350 143,270
Other Cost Pool Indi HROL 1,736,374 - 1,736,374 - 54,223 1,736,374
TOTAL GRANT REVENUE 72,084,632 18,232,336 53,852,296 42,775,158 41,308,942 10,334,428
615 Grants 40,715,942
638 Patient Services - Program Income 420,000
650 Misc. Revenue - Non-Cash 173,000
41,308,942

Formula
Indirect
Direct Exp Exp Indirect
Comment
FY 2015 Recoverabl Rate
e FY 2015
107,760 16,164 15.00%
- - 0.00% terminated
101,720 12,206 12.00%
128,756 19,313 15.00% carry forward
1,667,413 246,777 14.80%
351,046 51,955 14.80%
365,819 54,141 14.80%
12,291 1,844 15.00%
939,700 93,970 10.00%
50,000 5,000 10.00%
73,066 10,814 14.80%
739,187 110,878 15.00%
101,436 15,215 15.00%
674,510 99,828 14.80%
592,334 87,666 14.80%
15,100 2,265 15.00%
8,777 1,299 14.80%
57,958 8,694 15.00%
234,642 34,727 14.80%
245,340 36,310 14.80%
168,606 25,291 15.00%
155,048 22,947 14.80%
3,000 - 0.00%
1,088,850 161,150 14.80%
145,768 21,574 14.80%
20,000 - 0.00%
712,464 85,835 14.80% Indirect on payroll only 579963
65,019 7,101 15.00% Indirect on payroll only
50,897 7,007 14.80% Indirect on payroll only
190,041 28,506 15.00%
154,486 22,864 14.80%

790,690 110,603 15.00%
1,512,143 208,010 14.80% pass thru 160,000
100,645 15,097 15.00% right size
243,902 36,098 14.80%
50,000 - 0.00%
129,822 19,473 15.00%
130,662 19,338 14.80%
241,290 10,522 15.00% personnel only
71,243 3,507 15.00% personnel only
306,457 45,968 15.00%
86,868 12,857 14.80%
28,109 - 0.00% request date extension
19,098 - 0.00% request date extension
16,296 2,444 15.00%
272,727 27,273 10.00%
26,003 3,901 15.00%
60,318 8,927 14.80%
1,328,106 113,776 15.00% pass thru 569,603
2,106,234 196,971 14.80% pass thru 775,353
86,957 13,043 15.00%
43,554 6,446 14.80%
787,990 116,623 14.80%
1,927,086 195,914 15.00% personnel only 1306093
86,722 10,462 15.00% 15% of salaries79,740
74,538 10,462 15.00% personnel 69,749
76,981 11,393 14.80%
363,636 36,364 10.00%
163,408 16,341 10.00%
158,771 23,816 15.00%
147,206 21,787 14.80%
660,440 66,044 10.00% pass thru $44,000
77,106 11,119 15.00% personnel only 74125
113,890 17,083 15.00%
310,322 45,928 14.80%
2,700,293 405,044 15.00%
6,544,220 968,545 14.80% will be reduced
- - 15.00%
2,271 336 14.80%
199,541 19,954 10.00%
- - 10.00% will not be funded
2,500 - 0.00%
363,624 36,362 10.00%
363,460 36,346 10.00%

60,551 10,112 16.70%
406,116 60,105 14.80%
526,908 52,691 10.00%
504,691 58,829 15.00% less pass thru 112500
1,079,883 109,873 14.80% less pass thru 337500
772,727 77,273 10.00%
90,909 9,091 10.00%
41,130 6,170 15.00%
32,666 4,834 14.80%
1,068,192 10,897 10.00% indirect on admin cost
338,611 2,176 10.00%
119,408 17,911 15.00%
100,103 14,815 14.80%
262,566 27,889 15.00% pass thru $76,638
656,228 60,122 14.80% pass thru $250,000
- -
38,056,852 4,718,306