Agenda 09/09/2014 Item #16F4 9/9/2014 16.F.4.
r-� EXECUTIVE SUMMARY
Recommendation to authorize budget amendments appropriating approximately
$297,982,968.68 of unspent FY 2014 grant and capital project budgets into fiscal year
2015.
OBJECTIVE: Board of County Commissioners' approval of budget amendments which will
increase the FY 2015 budget by approximately $297,982,968.68 in the various Capital
projects,Grant and Grant donor matching funds.
CONSIDERATIONS: During fiscal year 2014, grants and capital projects were
contemplated and planned for in the adopted budget and/or budget amendments were
processed. Grants and Capital Projects do not necessarily "expire" at the end of the Board's
fiscal year, on September 30. The unspent portion of these budgets need to roll forward into
the next fiscal year to avoid disruption in the payment of venders and employees. This action
is considered customary and routine in accordance with budgetary practices and the
accounting associated with Capital and Grant Funds.
Grant awards are approved by the Board at various times during the year; many grants have
fiscal year cycles different than the County's fiscal year of Oct 1 —Sept 30. At year-end,the
accounting system SAP automatically calculates the unspent budget (amended budget less
expenditures)and posts this amount into fiscal year 2015 budget as a budget amendment.
Some grants require local matching funds. In the donor funds,match money is budgeted as a
transfer to the Grant Fund. As expenditures are incurred,Finance transfers the correct amount
of cash from the donor fund to the Grant Fund. If at year end, the grant is not completed,
committed match dollars sitting in the donor fund must be re-budgeted in fiscal year 2015 to
ensure that the grant is in compliance with the grant contract and match requirements.
Capital Projects are usually multi-year projects. Budgets are created during the budget
process and/or in the form of budget amendments. As professionals and contractors are hired,
purchase orders are opened and work is in progress,the closing down and starting up a fiscal
year should not disrupt the progress of a capital project. The accounting system SAP
automatically calculates the unspent budget(amended budget less expenditures)and posts this
amount into fiscal year 2015 budget as a budget amendment.
Section 129.06, Florida Statute, mandates that any increase in a Fund by the recognition of
Carryforward or Grant Revenues; and increasing the appropriations must be approved by
resolution of the Board of County Commissioners after an advertised public hearing. (The
resolution will be in the next BCC meeting on September 23). The $297,982,968.68 is the
amount of unspent budget (amended budget of $444,349,527.62 less expenditures of
$146,366,558.94)as of August 25,2014. On October 1, SAP will automatically calculate and
post the unspent budgets in each grant and capital project's fund. The actual amount of the
budget amendment may be more or less than $297,982,968.68 depending on the remaining
activity before September 30. Additional moneys will be spent when invoices are processed
H:\Executive Summary\Cazryforward of unspent project budget
Packet Page-2865-
9/9/2014 16.F.4.
and/or the Board may authorize budget amendments on September 9th and September 23rd
which was not contemplated in this executive summary.
If we wait until after the close of the fiscal year for Board approval on the budget amendments
to carryforward the unspent budgets, all the capital projects and grants will sit idle with no
budgets for 14 days. This will mean that over$93 million in open purchase orders cannot roll
into FY 2015; venders and employees will not receive any form of payment until after the
October 14th Board meeting.
Below is a recap of Exhibit A listing the primary categories of the estimated roll over amounts
in the Capital Projects and Grants totaling $297,982,968.68. The categories are listed from
most restricted to least restricted in terms of various legislative, statutory, legal, policy,
program or regulatory constraints.
Unspent budgets
as of 8/25/2014
Grant Funds $78,838,439.77
Donor Funds Providing Grant Match Money $13,055,513.53
Impact Fees Capital Projects Funds $26,318,614.47
User Fees Capital Projects Funds $125,999,407.43
Gas Tax Capital Projects Fund $30,540,046.53
Ad Valorem Supported Capital Projects Funds $23,230,946.95
Total $297,982,968.68
FISCAL IMPACT: Budget amendments in the approximate amount of$297,982,968.68 are
needed in FY 2015 to re-appropriate unspent (FY 2014) budget within each capital project,
grant and match funds and to recognize a like amount in Carryforward/Grant revenue.
Attached is Exhibit "A" listing each Fund and estimated dollar amount calculated as of
August 25, 2014. On October 1, the accounting system SAP will calculate and post the
precise amount of unspent budget and this amount may be more or less than$297,982,968.68,
depending on the activity over the remainder of the fiscal year. This roll of unspent funds
does not affect the adopted FY 2015 budget which the Board will approve on September 18,
2014.
GROWTH MANAGEMENT IMPACT: While there is no new growth management impact,
this carryforward funding request will ensure that there are no payments or contracting delays
for budgeted growth management projects.
LEGAL CONSIDERATIONS: This item was reviewed by the County Attorney, is
approved as to form and legality,and requires majority support for approval. -JAK.
RECOMMENDATION: Recommendation to authorize budget amendments totaling
approximately $297,982,968.68 to re-appropriate unspent (FY 2014) budget and carry
forward into fiscal year 2015 for capital projects, grants and match money.
PREPARED BY:
Susan Usher, Senior Budget Analyst, Office of Management and Budget
Mark Isackson, Corporate Financial Operations & Management Services, County Manager's
Office
H:\Executive Summary\Carryforward of unspent project budget
Packet Page-2866-
9/9/2014 16.F.4.
COLLIER COUNTY
Board of County Commissioners
Item Number: 16.16.F.16.F.4.
Item Summary: Recommendation to authorize budget amendments appropriating
approximately$297,982,968.68 of unspent FY 2014 grant and project budgets into fiscal year
2015.
Meeting Date: 9/9/2014
Prepared By
Name: Valerie Fleming
Title: Operations Coordinator, Office of Management&Bud
8/27/2014 8:43:06 AM
Submitted by
Title: Operations Coordinator, Office of Management&Bud
Name: Valerie Fleming
8/27/2014 8:43:07 AM
Approved By
Name: IsacksonMark
Title: Director-Corp Financial and Mngmt Svs, Office of Management&Budget
Date: 8/27/2014 1:08:36 PM
Name:UsherSusan
Title: Management/Budget Analyst, Senior, Office of Management&Budget
Date: 8/27/2014 1:21:22 PM
Name: KlatzkowJeff
Title: County Attorney,
Date: 9/2/2014 1:13:02 PM
Name: OchsLeo
Title: County Manager,County Managers Office
Date: 9/2/2014 2:32:39 PM
Packet Page-2867-
9/9/2014 16.F.4.
Breakdown of the Unspent 2014 Project Budgets to be Added to FY 2015 Budget Exhibit A
(As of 8/25/2014)
Grants:
Supervisor of Elections Grant Fund(081) 1,065.28
Sheriffs Grants Fund(115) 279,570.40
Miscellaneous Grants Fund(116) 238,229.02
Community Development Block Grants Fund(121) 2,694,706.04
Services for Seniors-County Aging Program Fund(123) 107,136.97
American Recovery&Reinvestment Act(ARRA)(125) 14,969.87
MPO Grants Fund(128) 21,288.52
Library Grants Fund(129) 108,518.30
E911 Wireless Emergency Phone System Fund(189) 569,537.19
State Housing Incentive Partnership Grant Fund(191) 317.43
Gordon River Greenway Park(306) 877,853.59
Public Utilities Grant Fund(416) 43,848.41
Public Utilities Grant Match Fund(417) 501,110.00
Collier Area Transit(CAT)Grant Fund(424) 5,054,788.55
Collier Area Transit(CAT)Grant Match Fund(425) 1,037,465.03
Collier Area Transit(CAT)Enhancements Fund(426) 1,469,968.94
Transportation Disadvantaged Fund(427) 1,236,158.07
Transportation Disadvantaged Grant Fund(428) 771,365.26
Transportation Disadvantaged Grant Match Fund(429) 130,274.99
EMS Grants Fund(493) 115,568.04
EMS Grants Match Fund(494) 39.75
Airport Authority Capital Fund(496) 204,021.49
Airport Authority-Immokalee Capital Improvements Fund(497) 109,670.43
Airport Authority Grant Fund(498) 2,145,422.26
Airport Authority Grant Match Fund(499) 125,008.00
Specialized Grant Fund(701) 3,259,285.00
Housing Grant Fund(705) 8,688,141.38
Human Services Grant Fund(707) 2,780,105.90
Human Services Grant Match Fund(708) 121,317.54
Public Services Grant Fund(709) 622,856.54
Public Services Grant Match Fund(710) 18,166.60
Transportation Grant Fund(711) 32,916,990.56
Transportation Grant Match Fund(712) 8,275,877.05
County Managers Agency Grant Fund(713) 194,263.38
Immokalee CRA Grant Fund(715) 2,523,847.50
Bayshore CRA Grant Fund(717) 210,690.00
ARRA Grant Match Fund(726) 32,808.00
State Housing Incentive Partnership Grant Fund(791) 1,336,188.49
$ 78,838,439.77
Donor Funds Providing Match Money to Grants:
General Fund(001) 201,044.38
MSTU Unincorporated General Fund(111) 30,713.74
Misc Grant Fund(116) 5,560.41
Services For Seniors(123) 52,979.48
Conservation Collier Maintenance Fund(174) 15,000.00
Road construction-Gas Tax Capital Fund(313) 3,826,746.90
Stormwater Capital Projects Fund(325) 172,004.00
Road Impact Fee-District 1 Fund(331) 1,413,930.00
Road impact Fee-District 2 Fund(333) 460,000.00
Road Impact Fee-District 4 Fund(336) 3,000,000.00
County Water Capital Projects Fund(412) 3,243,850.00
County Sewer Capital Projects Fund(414) 57,260.00
Collier Area Transit(CAT)Enhancements Fund(426) 444,143.75
Transportation Disadvantaged Fund(427) 20,599.49
Transportation Disadvantaged Grant Fund(428) 700.00
EMS(490) 39.75
H:\GovMax to SAP-Sept Oct\FY2015 GovMax to SAP\Car orward ca orward of unspent Packet Pale-2868-
ryF \ rryf pent Pa ct et P m n cuto.xg8-
9/9/2014 16.F.4.
Breakdown of the Unspent 2014 Project Budgets to be Added to FY 2015 Budget Exhibit A
(As of 8/25/2014)
Donor Funds Providing Match Money to Grants:(Continued)
Airport Authority-Capital Improvements Fund(496) 34,629.05
Airport Authority-hnmokalee Capital Improvements Fund(497) 11,152.58
Human Services Grant Fund(707) 65,160.00
$ 13,055,513.53
Impact Fee Capital Projects:
Road Impact Fee-District 1 Fund(331) 3,561,179.34
Road impact Fee-District 2 Fund(333) 2,021,625.73
Road Impact Fee-District 3 Fund(334) 466,286.10
Road Impact Fee-District 4 Fund(336) 4,511,307.22
Road Impact Fee-District 6 Fund(338) 7,410,592.49
Road Impact Fee-District 5 Fund(339) 1,351,718.55
Regional Park Impact Fee Fund(345) 49,523.48
Community and Regional Parks Impact Fee-Unincorporated Area Fd(346) 5,185,590.90
EMS Impact Fee Fund(350) 135,918.59
Library Impact Fee Fund(355) 97,606.82
Ochopee Fire Control District Impact Fee Fund(372) 2,427.49
Isle of Capri Impact Fee Fund(373) 2,249.88
Correctional Facilities Impact Fee Fund(381) 185,245.04
Law Enforcement Impact Fee Fund(385) 321,491.79
Government Facilities Impact Fee Fund(390) 223,162.79
Water Impact Fees Capital Projects Fund(411) 295,850.39
County Sewer System Development Capital Fund(413) 496,837.87
$ 26,318,614.47
User Fees Capital Projects:
Pine Ridge Industrial Park MSTU(132) 1,483,233.98 Sp Assessment
Naples Production Park MSTD(138) 1,538,019.83 Sp Assessment
Conservation Collier Capital Fund(179) 645,674.05 Consery Collier tax
Court Maintenance Fund(181) 257,007.94 Court Fines&Fees
TDC Beach Park Facilities Fund(183) 4,880,342.39 mc tax
TDC-Beach Renourishment and Pass Maintenance Fund(195) 2,196,879.55 me tax
ATV Settlement(305) 2,964,571.77 Settlement from SFWMD
(TDC)Museum Capital Projects Fund(314) 33,770.62 TDc tax
Community Development System Development Capital Fund(310) 75,000.00 CDES fees
Clam Bay Restoration Capital Fund(320) 109,254.27 Sp Assessment
Pelican Bay Irrigation and Landscape Capital Fund(322) 2,105,460.62 Sp Assessment
Water User Fees Capital Projects Fund(412) 42,010,991.79 Water User fees
County Sewer Capital Projects Fund(414) 56,065,900.54 Sewer User fees
Solid Waste Capital Projects Fund(474) 10,962,249.42 Solid Waste fees
Information Technology Capital Fund(506) 671,050.66 Internal Service Charges
$ 125,999,407.43
Gas Taxes Capital Projects:
Road construction-Gas Tax Capital Fund(313) $ 30,540,046.53
Ad Valorem Capital Projects:
MSTD Landscaping Projects Fund(112) 77,644.49
County-wide Capital Projects Fund(301) 9,314,524.73
Parks and Recreation Capital Projects Fund(306) 326,969.45
Stormwater Capital Projects Fund(325) 12,224,800.90
EMS Capital Fund(491) 1,287,007.38
$ 23,230,946.95
Grand Total $ 297,982,968.68
Packet Pale-2869-
H:\GovMax to SAP-Sept Oct\FY2015 GovMax to SAP\Carryforward\tarryforward of unspent prujees uuuseu m r,Luso.sfaxaneet3