FY15 GRANT RECONCILIATION F222F217ADMINADJ.XLSX

FY 2015 Budget Maintenance - Supporting Documentation
Grant Summary Worksheet - Object Code 615 Detail
Dept: 220
Fund: 222 If new grant
put in "0" X Y Formula Formula
FY 2015 Grant Amount Indirect Exp
Expended FY 2015 FY 2015 Direct Exp FY
Grant Source Grant Start Date End Date Rptg Cat Activity Total Award Adopted Remaining for Recoverable Indirect Rate Comment
Thru FY 2014 Available Forecast 2015
Budget Future Years FY 2015
Federal Head Start FY15 7/1/2014 6/30/2015 FE15/FC15 CDEV 22,701,903 - 22,701,903 22,701,903 22,448,889 - 20,827,556 1,874,347 18.4%
Federal Head Start FY14 Unobligated 7/1/2014 6/30/2015 FE15/FC15 CDEV 6,998 - 6,998 6,998 - 6,998 - 18.4% Carryover of unobligated balance rolled into FY15 total funding
Federal Head Start FY15 Supplemental Funding 7/1/2014 6/30/2015 FC15 CDEV 61,500 - 61,500 61,500 - 61,500 - 18.4% No personnel to collect indirect from
State CACFP Meals 7/1/2014 6/30/2015 CE15/CF15CDEV 260,828 - 260,828 260,828 250,000 - 260,828 - 0.0% No indirect allowed
CDEV TOTAL 23,031,229 - 23,031,229 23,031,229 22,698,889 - 21,156,882 1,874,347 2210
State Weatherization - Governor's Office 7/1/2014 6/30/2015 DE15 WTHR 1,215,468 - 1,215,468 1,215,468 1,588,238 - 1,195,145 20,323 18.4%
Other Weatherization - ACAA URRD 7/1/2014 6/30/2015 UR25 WTHR 355,132 - 355,132 355,132 - 355,132 - 18.4% No personnel costs
Other Weatherization - ACAA SRP 5/1/2014 3/30/2015 SR25 WTHR 264,220 - 264,220 264,220 - 264,220 - 18.4% No personnel costs
Other Weatherization - APS 1/1/2015 12/31/2015 AP14 WTHR 343,234 - 171,617 171,617 - 171,617 171,617 - 18.4% No personnel costs
WTHR TOTAL 2,178,054 - 2,006,437 2,006,437 1,588,238 171,617 1,986,114 20,323 2299
Federal HUD Emergency Shelter Grant FY14 7/1/2013 6/30/2015 ES24 EHSN 164,046 98,428 65,618 65,618 - 65,618 - 18.4% No personnel
Federal HUD Emergency Shelter Grant FY15 7/1/2014 6/30/2016 ES25 EHSN 210,396 - 144,778 144,778 160,167 65,618 144,778 - 18.4% No personnel
EHSN TOTAL 374,442 98,428 210,396 210,396 160,167 65,618 210,396 - 0
State Area Agency on Aging - SAIL program 7/1/2014 6/30/2015 SG15 SAIL 1,373,172 - 1,373,172 1,373,172 1,473,172 - 1,001,683 371,489 18.4%
SAIL TOTAL 1,373,172 - 1,373,172 1,373,172 1,473,172 - 1,001,683 371,489 2245
State DES Voucher LIHEAP 7/1/2014 6/30/2015 VI15 FAST 2,608,767 - 2,608,767 2,608,767 1,946,977 - 2,608,767 - 0.0% No personnel costs/ no indirects allowed
State DES Voucher Neighbors Helping Neighbors (NHN) 7/1/2014 6/30/2015 VH15 FAST 5,897 - 5,897 5,897 - - 5,897 - 0.0% No personnel costs/ no indirects allowed
State DES Voucher TANF 7/1/2014 6/30/2015 VA25 FAST 557,179 - 557,179 400,000 - 157,179 400,000 - 0.0% No personnel costs/ no indirects allowed
FAST TOTAL 3,171,843 - 3,171,843 3,014,664 1,946,977 157,179 3,014,664 - 0
State DES - Case management and vouchers CSBG 7/1/2014 6/30/2015 COAA 1,050,751 1,050,751 1,050,751 1,710,020 - 975,942 74,809 18.4%
State DES - Case management and vouchers SSBG 7/1/2014 6/30/2015 COAA 847,600 847,600 847,600 - - 759,866 87,734 18.4%
State DES - Qwest 7/1/2014 6/30/2015 QW15 COAA 16,852 16,852 16,852 - - 16,852 - 18.4% No personnel charged to this grant
COAA TOTAL 1,915,203 - 1,915,203 1,915,203 1,710,020 - 1,752,660 162,543 2205
Federal WIA IGA PY13-FY14 7/1/2013 6/30/2015 var-SEEK SEEK 9,800,802 3,647,966 6,152,836 6,152,836 2,737,780 - 5,259,129 893,707 18.4% 2 year award
Federal WIA IGA PY14-FY15 7/1/2014 6/30/2016 var-SEEK SEEK 9,615,476 - 4,807,738 4,807,738 8,047,708 4,807,738 4,807,738 - 18.4% No personnel charged to this grant
SEEK TOTAL 19,416,278 3,647,966 10,960,574 10,960,574 10,785,488 4,807,738 10,066,867 893,707 2270
Federal WIA IGA PY13-FY14 4/1/2013 6/30/2015 var-YOUT YOUT 3,556,931 938,809 2,618,122 2,618,122 1,110,960 - 2,491,969 126,153 18.4% 2 year award
Federal WIA IGA PY14-FY15 4/1/2014 6/30/2016 var-YOUT YOUT 3,572,000 - 1,786,000 1,786,000 2,845,545 1,786,000 1,786,000 - 18.4% No personnel charged to this grant
YOUT TOTAL 7,128,931 938,809 4,404,122 4,404,122 3,956,505 1,786,000 4,277,969 126,153 2270
TOTAL GRANT REVENUE 58,589,152 4,685,203 47,072,976 46,915,797 44,319,456 6,988,152 43,467,235 3,448,562 SPPT

FY 2015 Budget Maintenance - Supporting Documentation
Grant Summary Worksheet - Object Code 615 Detail
Dept: 220
Fund: 217 If new grant
put in "0" Formula Formula
FY 2015 Grant Amount Indirect Exp
Expended Thru FY FY 2015 FY 2015 Direct Exp FY
Grant Source Grant Start Date End Date Rptg Cat Activity Total Award Adopted Remaining for Recoverable Indirect Rate Comment
2014 Available Forecast 2015
Budget Future Years FY 2015
Federal CDBG Year 34 1/0/1900 2,366,616 2,340,781 25,835 25,835 - - 25,835
Federal CDBG Year 35 12/1/2012 6/30/2015 QJ01 CDBG 3,257,880 2,922,262 335,618 335,618 - - 335,618 - 18.4% No personnel to collect indirect from
Federal CDBG Year 36 7/1/2013 6/30/2018 QJ42 CDBG 2,909,376 1,008,982 1,900,394 1,900,394 - - 1,900,394 - 18.4% No personnel to collect indirect from
Federal CDBG Year 37 7/1/2014 6/30/2016 1440 CDBG 2,706,760 - 2,706,760 2,706,760 5,170,003 - 2,603,728 103,032 18.4%
CDBG TOTAL 11,240,632 6,272,025 4,968,607 4,968,607 5,170,003 - 4,865,575 103,032
Federal HOME 08/09 7/1/2008 6/30/2015 QK08 HMAD 798,800 656,085 142,715 142,715 - - 142,715 - 18.4% No personnel to collect indirect from
Federal HOME 09/10 7/1/2009 6/30/2015 QF72 HMAD 3,210,972 2,449,539 761,433 761,433 - - 761,433 - 18.4% No personnel to collect indirect from
Federal HOME 10/11 7/1/2010 6/30/2015 QF46 HMAD 3,182,223 2,314,120 868,103 868,103 - - 868,103 - 18.4% No personnel to collect indirect from
Federal HOME 11/12 7/1/2011 6/30/2015 QI48 HMAD 4,059,635 2,419,402 1,640,233 1,640,233 - - 1,640,233 - 18.4% No personnel to collect indirect from
Federal HOME 12/13 7/1/2012 6/30/2015 QJ41 HMAD 3,124,848 1,085,414 2,039,434 2,039,434 - - 2,039,434 - 18.4% No personnel to collect indirect from
Federal HOME 13/14 7/1/2013 6/30/2015 QK03 HMAD 3,114,227 309,173 2,805,054 2,805,054 - - 2,805,054 - 18.4% No personnel to collect indirect from
Federal HOME 14/15 7/1/2014 6/30/2015 1420 HMAD 3,354,308 - 3,354,308 3,354,308 11,109,186 - 3,309,078 45,230 18.4%
State Disabled Vet Housing 7/1/2014 6/30/2015 DV15 HMAD 624,900 - 624,900 624,900 - - 614,177 10,723 18.4%
HMAD TOTAL 21,469,913 9,233,733 12,236,180 12,236,180 11,109,186 - 12,180,227 55,953
TOTAL GRANT REVENUE 32,710,545 15,505,758 17,204,787 17,204,787 16,279,189 - 17,045,802 158,985