Agenda 09/13/2016 R Item #16F 4 16.F.4
09/13/2016
EXECUTIVE SUMMARY
Recommendation to authorize budget amendments appropriating approximately $377,007,918.64
of unspent FY 2016 grant and capital project budgets into fiscal year 2017.
OBJECTIVE: Board of County Commissioners'approval of budget amendments which will increase the
FY2017 budget by approximately$377,007,918.64 in the various Capital projects, Grant and Grant donor
matching funds.
CONSIDERATIONS: During fiscal year 2016, 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 2017 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 2017 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 2017 budget as a budget amendment.
Section 129.06, Florida Statute,mandates that any increase in a Fund by the recognition of Carryforward
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 27).
The $377,007,918.64 is the amount of unspent budget (amended budget of $557,116,489.54 less
expenditures of$180,108,570.90) as of August 23, 2016. 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$377,007,918.64 depending on the activity within the remaining 38
days before September 30. Additional moneys will be spent when invoices are processed and/or the
Board may authorize budget amendments on September 13' and September 27th 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 11
days. This will mean that over $129 million in open purchase orders cannot roll into FY 2017; venders
Packet Pg. 2728
16.F.4
09/13/2016
and employees will not receive any form of payment until after the October 11"'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 $377,007,918.64. The categories are listed from most restricted to
least restricted in terms of various legislature, statutory,legal, policy,program or regulatory constraints.
Unspent budgets as of 8/23/2016
Grant Funds $68,511,915.95
Donor Funds Providing Grant Match Money $1,026,657.09
Impact Fees Capital Projects Funds $75,021,377.35
User Fees Capital Projects Funds $146,324,849.57
Gas Tax Capital Projects Fund $46,553,846.01
Ad Valorem Supported Capital Projects Funds $39,569,272.67
Total $377,007,918.64
FISCAL IMPACT: Budget amendments in the approximate amount of$377,007,918.64 are needed in
FY 2017 to re-appropriate unspent (FY 2016) 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 23, 2016. 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
$377,007,918.64, depending on the activity over the remaining 38 days in the fiscal year. This roll of
unspent funds does not affect the adopted FY 2017 budget which the Board will approve on September
22, 2016.
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
$377,007,918.64 to re-appropriate unspent (FY2016) budget and carry forward into fiscal year 2017 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
ATTACHMENT(S)
1. carryforward of unspent project budgets into FY 2017 (PDF)
Packet Pg.2729
16.F.4
09/13/2016
COLLIER COUNTY
Board of County Commissioners
Item Number: 16.F.4
Item Summary: Recommendation to authorize budget amendments appropriating approximately
$377,007,918.64 of unspent FY 2016 grant and capital project budgets into fiscal year 2017.
Meeting Date: 09/13/2016
Prepared by:
Title: Operations Coordinator—Office of Management and Budget
Name: Valerie Fleming
08/23/2016 3:23 PM
Submitted by:
Title: Division Director-Corp Fin &Mgmt Svc—Budget and Management Office
Name: Mark Isackson
08/23/2016 3:23 PM
Approved By:
Review:
Office of Management and Budget Valerie Fleming Level 3 OMB Gatekeeper Review Completed 08/23/2016 3:25 PM
Office of Management and Budget Susan Usher Level 3 OMB 1st Reviewer 1-4 Completed 08/23/2016 4:34 PM
County Attorney's Office Jeffrey A.Klatzkow Level 3 County Attorneys Office Review Completed 08/23/2016 6:07 PM
Budget and Management Office Mark Isackson Level 3 OMB 2nd Reviewer Completed 08/25/2016 9:05 AM
County Manager's Office Nick Casalanguida Level 4 County Manager Review Completed 08/28/2016 11:15 AM
Board of County Commissioners MaryJo Brock Meeting Pending 09/13/2016 9:00 AM
Packet Pg. 2730
16.F.4.a
Estimate of the Unspent 2016 Project Budgets to be Added to FY 2017 Budget Exhibit A
(As of 8/23/2016)
Grants: ti
Economic Development Fund(007) 1,636,606.06 C
Supervisor of Elections Grant Fund(081) 6,759.61
as
Sheriff's Grants Fund(115) 230,900.35 a>
Miscellaneous Grants Fund(116) 439,464.26 ra
Natural Resources Grant(117) 103,362.02 N
Community Development Block Grants Fund(121) 2,121,612.65 0
Services for Seniors-County Aging Program Fund(123) 297,206.21 C
MPO Grants Fund(128) 27,722.41 N
r
Library Grants Fund(129) 457,034.02
E911 Wireless Emergency Phone System Fund(189) 2,589.94 c
Public Utilities Grant Fund(416) 375,000.00
4.
Collier Area Transit(CAT)Grant Fund(424) 9,768,063.58 ami
Collier Area Transit(CAT)Grant Match Fund(425) 1,109,192.74 2
0.
Collier Area Transit(CAT)Enhancements Fund(426) 2,126,243.36 -a
Transportation Disadvantaged Fund(427) 786,009.92 as
as
Transportation Disadvantaged Grant Fund(428) 956,559.64 C
cc
Transportation Disadvantaged Grant Match Fund(429) 140,621.34
EMS Grants Fund(493) 142,004.25 (p
EMS Grants Match Fund(494) 34,825.00 0
N
Airport Authority Capital Fund(496) 510,052.54 >.
um
Airport Authority-Immokalee Capital Improvements Fund(497) 415,362.53
=
Airport Authority Grant Fund(498) 802,790.35
at
Airport Authority Grant Match Fund(499) 174,433.86 y
Specialized Grant Fund(701) 2,669,555.01 e
Housing Grant Fund(705) 3,362,377.95
Housing Grant Match Fund(706) 103,327.85 ca
00
Human Services Grant Fund(707) 2,442,638.80
Human Services Grant Match Fund(708) 37,660.13 t•-
Public
`Public Services Grant Fund(709) 646,599.75 e
N
Public Services Grant Match Fund(710) 73,512.82 >-
u-
Transportation Grant Fund(711) 22,756,278.00 o
Transportation Grant Match Fund(712) 6,260,978.68 a
County Managers Agency Grant Fund(713) 1,966,287.56 u)
County Managers Agency Grant Match Fund(714) 92,073.40 rn
Immokalee CRA Grant Fund(715) 76,200.00 0
Bayshore CRA Grant Fund(717) 13,008.39
ARRA Grant Fund(726) 500.00 aa)
State Housing Incentive Partnership Grant Fund(791) 5,346,500.97 2
$ 68,511,915.95
E.
a)
a
Donor Funds Providing Match Money to Grants: c
General Fund(001) 611,120.42 =
MSTU Unincorporated General Fund(111) 35,859.82 0
Conservation Collier Maintenance Fund(174) 14,082.36 as
Immokalee Redevelopment(186) 192,708.02
EMS(490) 34,825.00 O
Sheriff s Confiscated Property Trust Fund(602) 57,745.73icii
Crime Prevention Trust Fund(603) 80,315.74 U
$ 1,026,657.09 C
a>
E
v
Zi
Packet Pg.2731
16.F.4.a
Estimate of the Unspent 2016 Project Budgets to be Added to FY 2017 Budget Exhibit A
(As of 8/23/2016)
R
Impact Fee Capital Projects:
a
Road Impact Fee-District 1 Fund(331) 17,286,592.56 N
L
Road impact Fee-District 2 Fund(333) 5,513,052.04 ii
as
Road Impact Fee-District 3 Fund(334) 1,135,544.58 >
Road Impact Fee-District 4 Fund(336) 15,912,974.87 v
Road Impact Fee-District 6 Fund(338) 4,434,368.90 to
Road Impact Fee-District 5 Fund(339) 5,041,948.89 0
Regional Park Impact Fee Fund(345) 199,523.48 •E'
to
Community and Regional Parks Impact Fee-Unincorporated Area Fd(3z 15,964,211.36 y
EMS Impact Fee Fund(350) 187,337.13CD
-a
Library Impact Fee Fund(355) 682,913.20 =
Parks Community Park Impact Fee Fund-Naples&Urban Area(368) 840.70 v
Ochopee Fire Control District Impact Fee Fund(372) 5,002.56N
O
Isle of Capri Impact Fee Fund(373) 4,549.88 `
Correctional Facilities Impact Fee Fund(381) 1,553,604.87 -0
C
Law Enforcement Impact Fee Fund(385) 3,214,172.79 cia
Government Facilities Impact Fee Fund(390) 1,149,022.87 4.4
L
Water Impact Fees Capital Projects Fund(411) 1,398,302.41
County Sewer System Development Capital Fund(413) 1,337,414.26 co
$ 75,021,377.35 c
N
User Fees Capital Projects: uu..
Pine Ridge Industrial Park MSTU(132) 68,300.75 Sp Assessment c
Naples Production Park MSTD(138) 1,047,178.33 Sp Assessment Q
Conservation Collier Capital Fund(179) 170,953.23 Conserv Comer tax G
Court Maintenance Fund(181) 1,899,111.89 Court Fines&Fees
TDC Beach Park Facilities Fund(183) 3,692,325.24 TDC tax tD
0
TDC-Beach Renourishment and Pass Maintenance Fund(195) 6,670,902.74 TDC tax ao
44,
Florida Boating Improvement Fund(303) 1,000,000.00 Vessel Registration Fees
n
ATV Settlement(305) 2,983,573.62 Settlement from SFWMD c
(TDC)Museum Capital Projects Fund(314) 847,452.80 TDC tax N
Clam Bay Restoration Capital Fund(320) 108,484.98 Sp Assessment u.
Pelican Bay Irrigation and Landscape Capital Fund(322) 1,060,440.79 Sp Assessment .2
Water-Sewer Motor Pool Capital Recovery Fund(409) 21,735.26 Water-Sewer User Fees .—
CfS
Water User Fees Capital Projects Fund(412) 39,829,776.88 water User fees 4'
a)
Sewer User Fee Capital Projects Fund(414) 76,022,103.57 Sewer User feesa
0
Solid Waste Motor Capital Recovery Fund(472) 20,407.92 Solid Waste fees .0
Solid Waste Capital Projects Fund(474) 10,149,766.55 Solid Waste fees w
Information Technology Capital Fund(506) 464,526.04 Internal Service Charges •p
Motor Pool Capital Recovery Fund(523) 267,808.98 User Fees a.
$ 146,324,849.57 c
Gas Taxes Capital Projects: N
Road construction-Gas Tax Capital Fund(313) $ 46,553,846.01 Gas Taxes C
0
4-
0
Ad Valorem Capital Projects: 1.5
MSTD Landscaping Projects Fund(112) 56,936.50 as
County-wide Capital Projects Fund(301) 14,258,583.90
42
Parks and Recreation Capital Projects Fund(306) 2,092,760.34
Transportation Road&Bridge Capital Fund(310) 6,555,225.11 as
Stormwater Capital Projects Fund(325) 11,449,782.83 ;
EMS Capital Fund(491) 5,155,983.99 aa)
$ 39,569,272.67 E
s
U
cz
Grand Total 8 377,007,918.64 ::)."-i
Packet Pg.2732