Fiscal Year 2018 Second Budget Amendment Copyrighted
March 5, 2018
City of Dubuque Items to be set for Public Hearing # 2.
ITEM TITLE: Fiscal Year 2018 Second Budget Amendment
SUMMARY: City Manager recommending the second Fiscal Year 2018
Budget Amendment be set for public hearing for March 19,
2018.
RESOLUTION Setting the Date for the Public Hearing on
Amendment No. 2 to the Fiscal Year 2018 Budget for the
City of Dubuque
SUGGESTED DISPOSITION: Suggested Disposition: Receive and File; Adopt
Resolution(s), Set Public Hearing for March 19, 2018
ATTACHMENTS:
Description Type
NNM Memo City Manager Memo
Staff Memo Staff Memo
Resolution Resolutions
Notice of Public Hearing Supporting Documentation
Council Detail Supporting Documentation
Dubuque
THE CITY OF �
DT T� r, 11-AmericaCit�
u t� I IQ
Masterpiece on the Mississippi I I
2009•2012•2013•2019
TO: The Honorable Mayor and City Council Members
FROM: Michael C. Van Milligen, City Manager
SUBJECT: Fiscal Year 2018 Second Budget Amendment
DATE: February 27, 2018
Budget Director Jennifer Larson is recommending the second Fiscal Year 2018 Budget
Amendment be set for public hearing for March 19, 2018.
I concur with the recommendation and respectFully request Mayor and City Council
approval.
��� ��//����
Michael C. Van Milligen
MCVM/jml
Attachment
cc: Crenna Brumwell, City Attorney
Cori Burbach, Assistant City Manager
Teri Goodmann, Assistant City Manager
Jennifer Larson, Budget Director
Dubuque
THE CITY OF �
DT T� r, 11-AmericaCit�
u t� I IQ
Masterpiece on the Mississippi I I
2009.2p12•21R3.2019
TO: Michael C. Van Milligen, City Manager
FROM: Jennifer Larson, Budget Director
SUBJECT: Fiscal Year 2018 Second Budget Amendment
DATE: February 27, 2018
The purpose of this memorandum is to present a summary of the action items approved by
City Council throughout the year subject to a future budget amendment and to set the
public hearing date for the formal budget amendment process as required by Section
384.16 of the Code of lowa.
This budget amendment includes items, which have been authorized by City Council since
the first amendment to the Fiscal Year 2018 budget was adopted in September 2017 and
adjustments to reflect the amended Community Development Annual Plan. This
amendment also reflects reappropriations of completed or canceled projects to fund
increased operating and capital expenses. An increase of interfund transfers of$1,842,944
is also included.
The amendment totals $14,825,889 in increased appropriation authority and an increase in
resources of$14,591,827.
Additional revenues added in this amendment with offsetting appropriations are:
• Stormwater General Obligation Bond Refunding Series 2018A ($1,833,948),
• Engineering General Obligation Bond Refunding Sales Tax Series 2018A
($1,792,537),
• Water General Obligation Bond Refunding Series 2018A ($1,672,483),
• Greater powntown Tax Increment Financing General Obligation Bond Refunding
Series 2018A ($1,637,053),
• Sanitary General Obligation Bond Refunding Series 2018A ($1,554,297),
• West Rural Water Purchase State Revolving Loan Funds ($1,139,135),
• lowa Finance Authority Caradco Loan Additional Principal Payment from Developer
($1,000,000),
• Parking General Obligation Bond Refunding Series 2018A and 2018B ($423,264),
• Building General Obligation Bond Refunding Series 2018B ($395,930),
• Dubuque Industrial Center West Tax Increment Financing General Obligation Bond
Refunding Series 2018A and 2018B ($366,685),
• Parks General Obligation Bond Refunding Sales Tax Series 2018A ($197,501),
• Library General Obligation Bond Refunding Sales Tax Series 2018A ($124,199),
• Police General Obligation Bond Refunding Sales Tax Series 2018A ($188,715),
• Refuse General Obligation Bond Refunding Series 2018A ($27,665),
• Recreation General Obligation Bond Refunding Sales Tax Series 2018A ($10,842),
• Federal Aviation Administration Entitlement for Airport Roads and Parking
($1 ,202,827),
• Customer Facility Charge for Airport Rental Car Lot ($280,583),
• State Grant for Grandview Signal Reconstruction ($259,357),
• REAP Grant Appropriation for Eagle Point Park Environmental ($180,000),
• Investment Earnings allocated to Local Option Sales Tax shortfall ($145,097),
• Commercial Air Service Vertical Infrastructure Grant Appropriation for Airport Sign
($124,400),
• Historic Federal Building Post Office Lease ($107,751) allocated to Fire Motor
Vehicle Maintenance Outsourced and Overtime,
• Continuum Care Grant Appropriation ($78,691), and
• Community Development Block Grant ($44,224) for lead service line replacements.
Reduced revenues reflected in this amendment with offsetting reductions in appropriations
include Local Option Sales Tax (-$197,114) based on actual year-to-date receipts and
estimates from the State of lowa. This shortfall is covered by unbudgeted investment
earnings.
The Jule has experienced unexpected engine issues in the medium duty buses. Six of the
medium duty buses are recommended for engine repair and six of the medium duty buses
are recommended for replacement with used Gillig buses ($289,047). This amendment
removes funding from Mini Bus replacement (-$29,175), Bus Stop Improvements (-
$20,000), Driver Shuttle Replacement (-$22,500), Eagle Point Park Walkway (-$34,687),
and Eagle Point Park Paint Pavilion (-$22,685) to partially fund the bus repairs and
replacements. In addition, there is the future sale of two trolleys ($50,000) and sale of
retired buses pending FTA approval ($60,000) that will also support the medium bus
expenditures. The remaining $50,000 for the bus repairs and replacements is allocated
from DRA distribution received in FY 2018.
An appraisal of all city buildings was completed during Fiscal Year 2018. Property
insurance is now allocated to departments based on the appraised value of the building
and square footage used by each department. The building appraisal has resulted in
property insurance savings of$65,001 in Fiscal Year 2018. In addition, a new contract was
negotiated for general liability insurance which resulted in savings of$39,310.
This amendment includes $103,945 in appropriation for expenditures made from the
Library General Gift Trust, of which $69,500 has been spent to-date on consulting services
including marketing.
2
Appropriations from previously issued bond proceeds include Utility Franchise Fee
Settlement ($605,500), Five Flags Arena Roof($285,759), Five Flags Replace Marquee
($100,000), and Five Flags Arena Light Fixtures ($173,359). These are projects that were
missed in the first amendment to be carried over from Fiscal Year 2017 to Fiscal Year
2018.
The action step is for City Council to adopt the attached resolution setting the public
hearing date for the formal budget amendment process as required by State law. The
attached resolution authorizes the City Clerk to publish notification for a public hearing to
be held March 19, 2018.
Attachments
JML
3
RESOLUTION NO. 55-18
SETTING THE DATE FOR THE PUBLIC HEARING ON AMENDMENT NO. 2 TO THE
FISCAL YEAR 2018 BUDGET FOR THE CITY OF DUBUQUE
Whereas, Iowa Code Section 384.16 provides that the City Council shall set a time and
place for a public hearing on amendments to the budget and publish notice before the hearing
as provided in Iowa Code Section 362.3.
NOW THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF
DUBUQUE, IOWA:
Section 1. That the City Council shall conduct a public hearing on proposed Amendment No.
2 to the Fiscal Year 2018 budget for the City of Dubuque at the City Council Chambers at the
Historic Federal Building, 350 West 6th Street, Dubuque, Iowa, on Monday, March 19, 2018,
beginning at 6:00 p.m.
Section 2. That the City Clerk be and is hereby authorized and directed to publish notice of
the public hearing, according to law, together with the required budget information.
Passed, approved and adopted this 5th day of March 2018.
Attest:
Kevin
Firnstah , City Ierk
D
Roy D. Buol, Mayor
Jun-05
NOTICE OF PUBLIC HEARING
Fo,m esaci AMENDMENT OF FY2017-2018 CITY BUDGET
The City Council of Dubuque in DUBUc]UE County, lowa
will meet at Historic Federal Building 350 West 6th St
at 6:00 p.m. on 3/19/2017
(hou�J (DeteJ
,for the purpose of amending the current budget of the city for the fiscal year ending June 30, 2018
r�an
by changing estimates of revenue and expenditure appropriations in the following functions for the reasons given.
Additional detail is available at the city clerk's office showing revenues and expenditures by fund type and by activity.
Total Budget Total Budget
as certified Current after Current
orlastamended Amendment Amendment
Revenues&O[her Financinq Sources
Taxes Levied on Properry 1 25,062,297 25,062,297
Less:UncollectedPropertyTaxes-LevyYear 2 0 0
NetCurrentProperry7axes 3 25,062,297 0 25,062,297
Delinquent Property Taxes 4 0 0
TIF Revenues 5 11,903,432 11,903,432
OtherCiryTaxes 6 18,061,248 -197,114 17,864,134
Licenses&Permits 7 1,529,906 -23,874 1,506,032
Use of Money and Properry 8 12,553,589 1,416,720 13,970,309
Intergovernmental 9 76,756,897 1,679,277 78,436,174
ChargesforServices 10 42,881,139 42,881,139
Special Assessments 11 30,000 30,000
Miscellaneous 12 8,133,059 242,564 8,375,623
OtherFinancingSources 13 9,424,132 11,474,254 20,898,386
Transfers In 14 31,751,321 1,842,944 33,594,265
7otalRevenuesantlOthersources 15 238,087,020 16,434,771 254,521,791
Expendi[ures&O[her Financinq Uses
PublicSafety 16 29,607,185 179,961 29,787,146
PublicWorks 17 14,123,592 -142,099 13,981,493
Health and Social Services 18 943,516 943,516
CultureandRecreation 19 12,750,234 96,100 12,846,334
Communityand Economic Development 20 14,580,550 96,274 14,676,824
General Gwernment 21 9,585,753 2,082 9,587,835
DeMService 22 10,873,974 5,713,462 16,587,436
CapitalProjects 23 69,423,034 1,723,952 71,146,986
Total GwernmentActivities 6cpenditures 24 161,887,838 7,669,732 169,557,570
BusinessType/Enterprises 25 77,268,489 7,156,157 84,424,646
7otalGovActivities&BusinessExpentlitures 26 239,156,327 14,825,889 253,982,216
TransfersOut 27 31,751,321 1,842,944 33,594,265
7otalExpentlitureslttansfersOut 28 270,907,648 16,668,833 287,576,481
Excess Revenues&O[her Sources Over
(untler)Expentlituresl7ransfers out Fiscal Year 29 -32,820,628 -234,062 -33,054,690
Beginning Fund Balance July 1 30 73,150,947 0 73,150,947
EntlingFuntlBalanceJune30 31 40,330,319 -234,062 40,096,257
Explanation of increases or decreases in revenue estimates, appropriations, or available cash:
This amendment adds additional revenue from grants received, private funding, bond proceeds, and the appropriation
to spend the monies.Adjustments to reflectthe amended Community DevelopmentAnnual Plan budget are included
along with savings from completed or cancelled projects and available cash balance is used to fund increased
operations.
There will be no increase in tax levies to be paid in the current fiscal year named above related to the proposed
budget amendment. Any increase in expenditures set out above will be met from the increased non-property tax
revenues and cash balances not budgeted or considered in this current budget.
Jennifer M. Larson
City qerk/Finance Offcer Name
FISCAL YEAR 2018 AMENDMENT #2 CITY COUNCIL
27-Feb-18
FY 18 FY 18
Expense Revenue
Department Program Description Amount Amount Fund Activity/CIP Account Explanation
GENERALFUND
City-Wide 0 Gas Franchise Fee (981,929) 100 10010100 42340 Shiftto Finance 10074100
City-Wide 0 Electric Franchise Fee (3,496,117) 100 10010100 42345 Shift to Finance 10074100
City-Wide 0 Maquoketa Valley Electric Franchise Fee (74,579) 100 10010100 42335 Shift to Finance 10074100
City-Wide 0 Investment Earnings 145,097 100 10010100 43110 Adjust to Actual
City-Wide 0 Local Option Sales Tax (145,097) 100 10010100 41530 Adjust to Actual
City-Wide 0 M&C Replacement 11,421 100 10010100 45781 Adjust to Actual
Emergency Communi� 1 O Emergency Comm Center - General Liability Insurance (1,737) 100 10012100 62208 Adjust to Actual
Fire 1 O Fire Suppression - Property Insurance (620) 100 10013400 62206 Adjust to Actual
Fire 1 O Fire Suppression - General Liability Insurance (10,896) 100 10013400 62206 Adjust to Actual
Fire 1 O Fire Suppression - Overtime 11,516 100 10013400 61050 Adjust to Actual
Fire 10 Ambulance - General Liability Insurance (1,115) 100 10013300 62208 Adjust to Actual
Fire 10 Ambulance - Overtime 1,115 100 10013300 61050 Adjust to Actual
Fire 1 O Fire Administration - Other Medical 69,967 100 10013100 61665 Adjust to Actual
Fire 1 O Fire Suppression - Overtime 40,000 100 10013400 61050 Adjust to Actual
Fire 1 O Fire Suppression - Overtime 22,526 100 10013400 61050 Adjust to Actual
Fire 1 O Fire Suppression - Overtime 11,421 100 10013400 61050 Adjust to Actual
Fire 1 O Fire Suppression - Motor Vehicle Maintenance Outsourced 37,784 100 10013400 62528 Adjust to Actual
Engineering 2C Wharfage Lease 40,000 100 10055100 43320 Adjust to Actual
Airport 20 Airport Operations - Property Insurance (1,817) 100 10051400 62206 Adjust to Actual
Airport 20 Terminal Building - Property Insurance (1,068) 100 10051700 62206 Adjust to Actual
Airport 20 Airport Operations - General Liability Insurance (8,847) 100 10051400 62208 Adjust to Actual
Airport 20 Airport Administration - General Liability Insurance (1,245) 100 10051100 62208 Adjust to Actual
Airport 20 Airport Operations - Farmland Rent 22,526 100 10051400 43242 Adjust to Actual
Engineering 20 Project Engineering - General Liability Insurance 2,862 100 10055400 62208 Adjust to Actual
Engineering 20 Engineering Admin - General Liability Insurance 1,837 100 10055100 62208 Adjust to Actual
Engineering 20 Traffic Engineering - General Liability Insurance 877 100 10055700 62208 Adjust to Actual
Parks 4C EPP Environmental - REAP Grant 180,000 100 1002643 45707 New Grant Appropriation
Parks 4C EPP Environmental - Consulting 180,000 100 1002643 62716 New Grant Appropriation
Parks 4C Valentine - Restroom Building - Private Participant 27,129 100 1001560 53102 Adjust to Actual
Parks 4C Valentine - Restroom Building - Construction 27,129 100 1001560 73210 Adjust to Actual
Parks 40 Park Areas & Maintenance - Property Insurance (2,169) 100 10030400 62206 Adjust to Actual
Parks 40 Park Areas & Maintenance - General Liability Insurance (1,755) 100 10030400 62208 Adjust to Actual
Civic Center 40 Civic Center Administration - Property Insurance (1,809) 100 10032100 62206 Adjust to Actual
Conference Center 40 Conf Center Operations - Property Insurance (2,288) 100 10033300 62206 Adjust to Actual
Library 40 Maintenance Services - Property Insurance (3,209) 100 10036300 62206 Adjust to Actual
Library 40 Adult Services - E-Books 1,849 100 10036200 62605 Lost Book Revenue
Library 40 Youth Services -Library Books 1,536 100 10036400 62651 Lost Book Revenue
Library 40 Adult Services - Reimbursements 1,849 100 10036200 53620 Lost Book Revenue
Library 40 Youth Services -Reimbursements 1,536 100 10036400 53620 Lost Book Revenue
Economic Developme 5C IFA DT Housing - Reimbursement 1,000,000 100 1002279 43405 Principal on Loans
Housing 5C Continuum Care Grant - Federal Pass Thru 78,691 100 1002180 45771 New Grant Appropriation
Housing 5C Continuum Care Grant - Construction 78,691 100 1002180 73210 New Grant Appropriation
Economic Developme 50 Economic Development - Property Insurance (671) 100 10060700 62206 Adjust to Actual
Housing 50 Federal Building Maintenance - Property Insurance (1,915) 100 10061150 62206 Adjust to Actual
Housing 50 Section 8 Voucher - General Liability Insurance (1,140) 100 10061600 62208 Adjust to Actual
Housing 50 Housing Inspections - New Rental Fee (3,200) 100 10061700 42162 Adjust to Actual
Housing 50 Housing Inspection - Dwelling Unit Inspection Fee (21,624) 100 10061700 42322 Adjust to Actual
Page 1
FISCAL YEAR 2018 AMENDMENT #2 CITY COUNCIL
27-Feb-18
FY 18 FY 18
Expense Revenue
Department Program Description Amount Amount Fund Activity/CIP Account Explanation
Housing 50 Housing Inspection - Complaint Inspection Fee 950 100 10061700 42324 Adjust to Actual
Housing 50 Housing Inspection - lowa District Court Fines 9,439 100 10061700 53403 Adjust to Actual
Housing 50 Housing Inspection - Inspection Penalty 14,435 100 10061700 53408 Adjust to Actual
Building Services 60 Ice Arena - Property Insurance (1,199) 100 10057550 62206 Adjust to Actual
Housing 60 Federal Building - Leases 107,751 100 10061150 43310 Adjust to Actual
Finance 60 Gas Franchise Fee 981,929 100 10074100 42340 Shiftfrom10010100
Finance 60 Electric Franchise Fee 3,496,117 100 10074100 42345 Shift from10010100
Finance 60 Maquoketa Valley Electric Franchise Fee 74,579 100 10074100 42335 Shift from10010100
Finance 60 Finance Plus Upgrade - Refunds 3,895 100 10074100 53201 Adjust to Actual
Finance 60 Accounting - Software 4,000 100 10074100 71123 Laserfiche Connector
Information Services 60 Information Services - Property Insurance (719) 100 10077100 62206 Adjust to Actual
Engineering 2C Utility Franchise - Bond Investment Earnings 30 102 1021857 43110 Adjust to Actual
Engineering 2C Utility Franchise - Consulting 30 102 1021857 62716 Adjust to Actual
Finance 2C Utility Franchise Analysis 605,500 102 1021857 62716 Final Payout
Parks 4C Comiskey Repair Siding - Bond Investment Earnings 4 102 1021151 43110 Adjust to Actual
Parks 4C Comiskey Repair Siding - Construction 4 102 1021151 73211 Adjust to Actual
Parks 4C Comiskey Playground - Bond Investment Earnings 515 102 1022292 43110 Adjust to Actual
Parks 4C Comiskey Playground - Consultant Services 515 102 1022292 62716 Adjust to Actual
Finance 6C Finance Plus Upgrade - Software (1,440) 102 1022166 71123 Shift to Laserfiche Connector
Information Services 6C Fire - Mobile Laptops 11,467 102 1021069 71124 Shift from Air Mask Replacement
TOTAL GENERAL FUND 1,064,967 1,475,347
TRANSIT FUND
Transit Division 70 Transit Admin - General Liability Insurance (3,144) 600 60053100 62208 Adjust to Actual
Transit Division 8C Replace Mini Buses - Equipment Acquisition (29,175) 600 6001222 73411 Shift to Fixed Route 6001224
Transit Division 8C Replace Fixed Route Buses - Sale of Trolleys 50,000 600 6001224 54109 Adjust to Actual
Transit Division 8C Replace Fixed Route Buses - Sale of Buses 60,000 600 6001224 54109 Adjust to Actual
Transit Division 8C Replace Fixed Route Buses - Reimbursements 700 600 6001224 53620 Adjust to Actual
Transit Division 8C Replace Fixed Route Buses - Heavy Equipment 289,047 600 6001224 71318 Adjust to Actual
Transit Division 8C Bus Stop Improvements - Equipment (7,000) 600 6002235 73410 Shift to Fixed Route 6001224
Transit Division 8C Bus Stop Improvements - Construction (13,000) 600 6002235 73211 Shift to Fixed Route 6001224
Transit Division 8C Bus Storage Facility - Reimbursements 9,093 600 6002446 53620 Adjust to Actual
Transit Division 80 Transit Administration - Vehicle Replacement (22,500) 600 60053100 71312 Shift to Fixed Route 6001224
TOTAL TRANSIT FUND 214,228 119,793
DOWNTOWN LOAN POOL - TIF FUND
Economic Developme 5C Downtown Rehab Grant - Bond Investment Earnings 231 241 2411942 43110 Adjust to Actual
Economic Developme 5C Downtown Rehab Grant - Grants 231 241 2411942 62765 Adjust to Actual
Economic Developme 5C Downtown Rehab Grant Prog - Grants 298,506 241 2411942 62765 Shift from 3602438
TOTAL DOWNTOWN LOAN POOL-TIF FUND 298,737 231
ROAD USE TAX FUND
Public Works 2C Asphalt Milling Program - Construction (10,750) 250 2501230 73211 Move to Overage on Truck Purchase
Public Works 2C Dump Truck Replacement - Heavy Equipment (5,748) 250 2502539 71318 Move to Overage on Truck Purchase
Engineering 2C City-Wide Security Camera - Equipment Acquisition 4,530 250 2502676 73410 From Cancelled POs
Engineering 2C Grandview Ave Light Poles - Construction 50,000 250 2501210 73211 From Cancelled POs
Engineering 2C Traffic Ops Ctr Video Software - Servers 75,000 250 2502422 71125 From Cancelled POs
Engineering 2C Brunskill Rd Bridge Replacement - Fed Pass Thru State (62,201) 250 2501077 45771 Finished Project Under Budget
Page 2
FISCAL YEAR 2018 AMENDMENT #2 CITY COUNCIL
27-Feb-18
FY 18 FY 18
Expense Revenue
Department Program Description Amount Amount Fund Activity/CIP Account Explanation
Engineering 2C Brunskill Rd Bridge Replacement -Construction (75,508) 250 2501077 73211 Finished Project Under Budget
Engineering 2C Railroad Crossing Improvement - Construction (36,031) 250 2502026 73211 SRF Green Alley Coverage
Public Works 20 Street Maintenance - Property Insurance (1,743) 250 25054400 62206 Adjust to Actual
Public Works 20 Street Maintenance - General Liability Insurance (2,860) 250 25054400 62208 Adjust to Actual
Public Works 20 Snow& Ice Control - General Liability Insurance (1,086) 250 25054420 62208 Adjust to Actual
Public Works 20 Street Cleaning - General Liability Insurance (1,039) 250 25054410 62208 Adjust to Actual
Engineering 20 Project Engineering - Software License Expense (77,000) 250 25055400 62663 Cancelled PO from FY 17
Engineering 20 Project Engineering - Traffic Control Equipment (4,770) 250 25055400 71411 Cancelled PO from FY 17
Engineering 20 Project Engineering - Mach/Equip Maintenance (26,700) 250 25055400 62611 Cancelled PO from FY 17
Engineering 20 Project Engineering - Servers (12,000) 250 25055400 71125 Cancelled PO from FY 17
Engineering 20 Project Engineering - Peripherals, Computer (7,500) 250 25055400 71120 Cancelled PO from FY 17
TOTAL ROAD USE TAX FUND (133,205) (62,201)
CUSTOMER FACILITY CHARGE FUND
Airport 2C Restricted Terminal Project - Construction 280,583 252 2522447 73210 Rental Car Lot
TOTAL CUSTOMER FACILITY CHARGE FUND 280,583 -
COMMUNITY DEVELOPMENT BLOCK GRANT FUND
Housing 5C Residential Rehab Program - Construction (100,000) 260 2601065 73211 CDBG FY 18 Amend #2
Housing 5C Residential Rehab Program - Construction (60,000) 260 2601065 73210 CDBG FY 18 Amend #2
Housing 5C Residential Rehab Program - Loans 60,000 260 2601065 62764 CDBG FY 18 Amend #2
Housing 5C Residential Rehab Program - Construction (187,586) 260 2601065 73211 CDBG FY 18 Amend #2
Housing 5C Residential Rehab Program - Loans 187,586 260 2601065 62764 CDBG FY 18 Amend #2
Housing 5C Lead Service Line Replacement - Loans 44,224 260 2602767 62764 CDBG FY 18 Amend #2
Housing 5C Lead Paint Abatement Prog - Grants (85,200) 260 2602767 62765 CDBG FY 18 Amend #2
Housing 5C Lead Paint Abatement Prog - Loans 85,200 260 2602767 62764 CDBG FY 18 Amend #2
Housing 50 Lead Paint Abatement Prog - Grants 100,000 260 26061200 62765 CDBG FY 18 Amend #2
TOTAL COMMUNITY DEVELOPMENT BLOCK FUND 44,224 -
HUD RESILIENCY GRANT FUND
Engineering 2C HUD Resiliency Engineering - Construction 3,031,430 264 2642769 73211 From HUD Resiliency
Engineering 2C HUD Resiliency - Construction (3,031,430) 264 2642690 73211 Move to HUD Resiliency Engineering
Housing 5C HUD Resiliency - HUD Payments (14,700,000) 264 2642690 44310 Move to Fed Pass Thru State
Housing 5C HUD Resiliency - Fed Pass Thru State Grant 14,700,000 264 2642690 45771 From HUD Payments
TOTAL HUD RESILIENCY GRANT FUND - -
HOUSING TRUST FUND
Housing 5C Housing Trust Fund - Loans (100) 268 2681021 62764 Adjust to Actual
TOTAL HOUSING TRUST FUND (100) -
STATE RENTAL REHAB FUND
Housing 5C Housing LHAP Grant- Loans 1,570 270 27061320 62764 Adjust to Actual
TOTAL STATE RENTAL REHAB FUND 1,570 -
VETERANS MEMORIAL FUND
Parks 4C Veterans Memorial Pavers 20,000 293 29330405 53102 Adjust to Actual
Parks 4C Veterans Memorial Pavers 20,000 293 29330405 73211 Adjust to Actual
TOTAL VETERANS MEMORIAL FUND 20,000 20,000
Page 3
FISCAL YEAR 2018 AMENDMENT #2 CITY COUNCIL
27-Feb-18
FY 18 FY 18
Expense Revenue
Department Program Description Amount Amount Fund Activity/CIP Account Explanation
LIBRARY TRUST FUND
Library 40 General Gift Trust - Library Books 354 295 29536480 62651 Lost Book Revenue
Library 40 James Mutschler Trust - Consulting Services 69,500 295 29536496 62716 Library Marketing
Library 40 General Gift Trust - Printing & Binding 5,638 295 29536480 62090 Adjust to Actual
Library 40 General Gift Trust - Speakers/Programs 4,981 295 29536480 62734 Adjust to Actual
Library 40 General Gift Trust - Library Books 4,239 295 29536480 62651 Adjust to Actual
Library 40 General Gift Trust - Software 3,303 295 29536480 71123 Adjust to Actual
Library 40 General Gift Trust - Misc. Equipment 3,230 295 29536480 71150 Adjust to Actual
Library 40 General Gift Trust - Computer 3,035 295 29536480 71124 Adjust to Actual
Library 40 General Gift Trust - E-Books 3,011 295 29536480 62605 Adjust to Actual
Library 40 General Gift Trust - OFfice Supplies 1,654 295 29536480 62010 Adjust to Actual
Library 40 General Gift Trust - Video Materials 826 295 29536480 62659 Adjust to Actual
Library 40 General Gift Trust - Promotion 756 295 29536480 62140 Adjust to Actual
Library 40 General Gift Trust - Periodicals 264 295 29536480 62653 Adjust to Actual
Library 40 General Gift Trust - Postage & Shipping 14 295 29536480 62030 Adjust to Actual
Library 40 Makers Space Operations - Video Equipment 1,245 295 29536500 72416 Adjust to Actual
Library 40 Makers Space Operations - Program Supplies 1,193 295 29536500 62668 Adjust to Actual
Library 40 Makers Space Operations - OFfice Supplies 402 295 29536500 62010 Adjust to Actual
Library 40 Makers Space Operations - Computer 300 295 29536500 71124 Adjust to Actual
TOTAL LIBRARY TRUST FUND 103,945 -
STREET CONSTRUCTION FUND
City-Wide 0 Street Construction - Interest Earnings 4,795 300 30010300 43110 Adjust to Actual
City-Wide 0 Street Construction - Local Option Sales Tax (24,697) 300 30010300 41530 Adjust to Actual
Public Works 2C Dump Truck Replacement - Truck Replacement 1,600 300 3002039 71314 Overage on purchase of truck
Public Works 2C Dump Truck Replacement - Heavy Equipment 14,898 300 3002539 71318 Overage on purchase of truck
Public Works 2C Floodwall Post Flood Repair- Construction 15,917 300 3001445 73211 From Mooring Dolphin 3502605
Public Works 2C MSC LED Lighting - Reimbursements 19,902 300 3002541 53620 Adjust to Actual
Engineering 2C Grandview Signal Reconstruction - Construction 293,156 300 3002559 73211 Total Project Cost
Engineering 2C Grandview Signal Reconstruction - State Grant 259,357 300 3002559 45701 State Grant Funded Portion
Engineering 2C Signalization Program - Construction (4,102) 300 3001011 73211 Grandview Overage
Engineering 2C LED Re-Lamp - Equip Acquisition (17,100) 300 3001916 73410 Move to City-Wide Cameras 3002676
Engineering 2C Crosswalk Warning Devices - Construction (31,000) 300 3002246 73211 To ITS and Univ& Asbury Overage
Engineering 2C ITS Traffic Control Equipment - Traffic Control Equip 20,000 300 3002253 71411 From Crosswalk Devices 3002246
Engineering 2C Traffic Signal Controller Replacement - Equip Acquisition (52,978) 300 3001274 73410 Move to City-Wide Cameras 3002676
Engineering 2C City-Wide Security Camera - Equipment Acquisition 149,466 300 3002676 73410 Funding from other traffic Activities
Engineering 2C Kerper Blvd Fiber and Camera - Construction 34,904 300 3002674 73211 Utility Contribution
Engineering 2C Kerper Blvd Fiber and Camera - Reimbursement 34,904 300 3002674 53620 Utility Contribution
Engineering 2C University& Asbury Intersection - Fed Pass Thru State (117,355) 300 3002324 45771 Finished Project Under Budget
Engineering 2C University& Asbury Intersection - Construction (68,713) 300 3002324 73211 Finished Project Under Budget
Engineering 2C Traffic Consultant Services - Consultant Services (4,875) 300 3001815 62716 Univ & Asbury Overage
Engineering 2C Safe Routes to School - Construction (5,000) 300 3001922 73211 Univ & Asbury Overage
Engineering 2C Accessibility Barriers - Construction (17,333) 300 3001034 73211 Univ & Asbury/Grandview Overage
Engineering 2C ROW Management - Construction (30,551) 300 3002613 73211 SRF Green Alley Coverage
Engineering 2C Street Construction General - Construction (19,133) 300 3002142 73211 SRF Green Alley Coverage
Engineering 2C NW Arterial Turn Lane - Construction (31,161) 300 3002695 73211 SRF Alley Coverage/Uni & Asbury
Engineering 2C St Light/Signal Knockdown - Insurance Claims 34,682 300 3002252 53610 Adjust to Actual
Page 4
FISCAL YEAR 2018 AMENDMENT #2 CITY COUNCIL
27-Feb-18
FY 18 FY 18
Expense Revenue
Department Program Description Amount Amount Fund Activity/CIP Account Explanation
Engineering 2C St Light/Signal Knockdown - Traffic Controller 34,682 300 3002252 71411 Adjust to Actual
Engineering 2C Pavement Marking - State Reimbursement (1,363) 300 3002245 45733 Adjust to Actual
Engineering 2C Pavement Marking - Construction (1,363) 300 3002245 73211 Adjust to Actual
2C Street Lighting Replacement - Equip Acquisition (52,960) 300 3001549 73410 Move to City-Wide Cameras 3002676
2C New St Lights City-Wide - Construction (16,428) 300 3002672 73211 Move to City-Wide Cameras 3002676
2C Washington Neighborhood Street Lights - Equipment (10,000) 300 3002615 71517 Move to City-Wide Cameras 3002676
TOTAL STREET CONSTRUCTION FUND 201,926 210,225
SALES TAX INCREMENT CONSTRUCTION FUND
Engineering 2C Flood Control Maintenance Facil - Consulting Engineers (200,000) 340 3402609 62712 Miscoded
Engineering 2C HUD Resiliency - Construction 439,645 340 3402690 73211 From Bee Branch Creek Restoration
Engineering 2C Bee Branch Creek Restoration - Construction (439,645) 340 3401654 73211 Move to HUD Resiliency
TOTAL SALES TAX INCREMENT CONSTRUCTION FUND (200,000) -
SALES TAX FUND (20%)
City-Wide 0 Sales Tax 20% Investment Earnings 27,320 350 35010350 43110 Adjust to Actual
City-Wide 0 Sales Tax 20% - Local Option Sales Tax (27,320) 350 35010350 41530 Adjust to Actual
Fire 1 C Ambulance Replacement - Bond Investment Earnings 91 350 3502507 43110 Adjust to Actual
Fire 1 C Ambulance Replacement - Heavy Equipment 91 350 3502507 71318 Adjust to Actual
Fire 1 C Fire Air Mask Replacement - Equipment (11,467) 350 3501553 72110 Shift to Mobile Computers
Public Works 2C Mooring Dolphin Install - Eng Division Services (15,917) 350 3502605 62811 Move to Floodwall 3001445
Engineering 2C Accessibility Barriers - Construction (18,170) 350 3501034 73210 Grandview Overage
Engineering 2C Trails/Complete Streets - REAP (124,278) 350 3502430 45707 Shift to Fed Pass thru
Engineering 2C Trails/Complete Streets - Fed Pass thru 124,278 350 3502430 45771 Shift to Fed Pass thru
Engineering 2C Riverfront Leases - State Grant 3,500 350 3501053 45701 New Grant Appropriation
Engineering 2C Riverfront Leases - Consulting Engineers 3,500 350 3501053 62712 New Grant Appropriation
Parks 4C Comiskey New entry- Bond Investment Earnings 109 350 3501544 43110 Adjust to Actual
Parks 4C Comiskey New Entry - Construction 109 350 3501544 73210 Adjust to Actual
Parks 4C Comiskey Park Amenities - Bond Investment Earnings 215 350 3501578 43110 Adjust to Actual
Parks 4C Comiskey Park Amenities - Construction 215 350 3501578 73211 Adjust to Actual
Parks 4C Flora Park Restrooms - Bond Investment Earnings 510 350 3501767 43110 Adjust to Actual
Parks 4C Flora Park Restrooms - Construction 510 350 3501767 73210 Adjust to Actual
Parks 4C Flora Park Playground - Bond Investment Earnings 110 350 3502377 43110 Adjust to Actual
Parks 4C Flora Park Playground - Construction 110 350 3502377 73410 Adjust to Actual
Parks 4C Skate Park - Bond Investment Earnings 282 350 3502461 43110 Adjust to Actual
Parks 4C Skate Park - Construction 282 350 3502461 73210 Adjust to Actual
Parks 4C EPP Riverfront - Bond Investment Earnings 352 350 3502508 43110 Adjust to Actual
Parks 4C EPP Riverfront - Construction 352 350 3502508 73210 Adjust to Actual
Parks 4C EPP Replace Walkway - Construction (34,687) 350 3501453 73211 Shift to Transit Buses
Parks 4C EPP Paint Pavilion - Contractor Services (21,985) 350 3502358 62710 Shift to Transit Buses
Civic Center 4C Theater - Tuckpointing - Construction 39,152 350 3501708 73210 Transfer from 3501212
Civic Center 4C Ham House Improvements - Construction (39,152) 350 3501212 73210 Transfer Bond Proceeds to 3501708
Civic Center 4C Five Flags Arena Roof - Construction 285,759 350 3502378 73210 Carryover
Civic Center 4C Five Flags Arena Light Fixtures - Construction 173,359 350 3502379 73210 Carryover
Civic Center 4C Five Flags Replace Marquee - Signage 100,000 350 3502736 71227 Shift from Arena Roof 3502378
Civic Center 4C Theatre Tuckpointing - Bond Investment Earnings 31 350 3501708 43110 Adjust to Actual
Civic Center 4C Theatre Tuckpointing - Construction 31 350 3501708 73210 Adjust to Actual
Engineering 6C Federal Building - Bond Investment Earnings 1,907 350 3501841 43110 Adjust to Actual
Page 5
FISCAL YEAR 2018 AMENDMENT #2 CITY COUNCIL
27-Feb-18
FY 18 FY 18
Expense Revenue
Department Program Description Amount Amount Fund Activity/CIP Account Explanation
Engineering 6C Federal Building - Construction 1,907 350 3501841 73210 Adjust to Actual
Building 6C City Hall Remodeling - Bond Investment Earnings 484 350 3501045 43110 Adjust to Actual
Building 6C City Hall Remodeling - Construction 484 350 3501045 73210 Adjust to Actual
TOTAL SALES TAX FUND 464,483 7,591
GENERAL CONSTRUCTION FUND
Engineering 2C N Cascade Road - Consulting Engineers (206,000) 360 3602021 62712 Adjust to Actual
Engineering 2C N Cascade Road - Construction (200,000) 360 3602021 73110 Adjust to Actual
Engineering 2C 18th St Wall - Bond Investment Earnings 20 360 3602481 43110 Adjust to Actual
Engineering 2C 18th St Wall - Construction 20 360 3602481 73211 Adjust to Actual
Engineering 2C Wash St 8th to 9th - Bond Investment Earnings 1,395 360 3602552 43110 Adjust to Actual
Engineering 2C Wash St 8th to 9th - Construction 1,395 360 3602552 73211 Adjust to Actual
Engineering 2C 11th St Stairs Recon - Bond Investment Earnings 11 360 3602554 43110 Adjust to Actual
Engineering 2C 11th St Stairs Recon - Construction 11 360 3602554 73211 Adjust to Actual
Parks 4C Replace Park Signs - Signage (10,000) 360 3601774 71227 Shift to Chavenelle Reconstruction
Economic Developme 5C DIC McFadden Signs - Signage (50,000) 360 3602725 71227 Rebudgeted in FY 2023
Economic Developme 5C Downtown Housing - Bond Investment Earnings 352 360 3602267 43110 Adjust to Actual
Economic Developme 5C Downtown Housing - Grants 352 360 3602267 62765 Adjust to Actual
Economic Developme 5C Wash Neigh DT Incent - Bond Investment Earnings 243 360 3602438 43110 Adjust to Actual
Economic Developme 5C Wash Neigh DT Incent - Grants 243 360 3602438 62765 Adjust to Actual
Economic Developme 5C Future Industrial Acquisitions - Land Acquisition (82,308) 360 3602437 73110 Shift to Chavenelle
Economic Developme 5C Downtown Housing Incentives - Grants (27,711) 360 3602436 62765 Shift to 2411942
Economic Developme 5C Washington Neigh Business Incentive - Grants 45,000 360 3602436 62765 Shift from 3602438
Economic Developme 5C Washington Neighborhood Downtown Incentive - Grants (45,000) 360 3602438 62765 Shift to 3602436
Economic Developme 5C Washington Neighborhood Downtown Incentive - Grants (90,795) 360 3602438 62765 Shift to 2411942
Housing 5C Homeownership Grants - Bond Investment Earnings 1,371 360 3601595 43110 Adjust to Actual
Housing 5C Homeownership Grants - Construction 1,371 360 3601595 73210 Adjust to Actual
Building 6C Multicultural Family Center - Bond Investment Earnings 457 360 3601976 43110 Adjust to Actual
Building 6C Multicultural Family Center - Construction 457 360 3601976 73210 Adjust to Actual
Parking Division 8C Millwork District Parking - Bond Investment Earnings 4,189 360 3602250 43110 Adjust to Actual
Parking Division 8C Millwork District Parking - Construction 4,189 360 3602250 73211 Adjust to Actual
Transit Division 8C Bus Storage Facility - Bond Investment Earnings 73 360 3602446 43110 Adjust to Actual
Transit Division 8C Bus Storage Facility - Construction 73 360 3602446 73211 Adjust to Actual
TOTAL GENERAL CONSTRUCTION FUND (658,703) 8,111
AIRPORT CONSTRUCTION FUND
Airport 2C New Terminal Facility Roads - Consultant Services 63,081 390 3902316 62716 Original Bond Proceeds 2016C
Airport 2C New Terminal Facility Roads - FAA 923,000 390 3902316 44105 FAA Receipt
Airport 2C New Terminal Parking - Construction 279,827 390 3902475 73211 FAA Funded Portion
Airport 2C New Terminal Parking - FAA 279,827 390 3902475 44105 FAA Receipt
Airport 2C New Terminal Entrance Sign - Construction 124,400 390 3902716 73211 State Grant Funded Portion
Airport 2C New Terminal Entrance Sign - State Grant 124,400 390 3902716 45701 CSVI Grant
Airport 2C Terminal Sitework - Bond Investment Earnings 857 390 3902009 43110 Adjust to Actual
Airport 2C Terminal Sitework - Damage Claims 857 390 3902009 62221 Adjust to Actual
Airport 2C Terminal Utilities - Bond Investment Earnings 2,233 390 3902010 43110 Adjust to Actual
Airport 2C Terminal Utilities - Consultant Engineers 2,233 390 3902010 62712 Adjust to Actual
Airport 2C ADF Containment - Bond Investment Earnings 120 390 3902448 43110 Adjust to Actual
Airport 2C ADF Containment - Consultant Services 120 390 3902448 62716 Adjust to Actual
Page 6
FISCAL YEAR 2018 AMENDMENT #2 CITY COUNCIL
27-Feb-18
FY 18 FY 18
Expense Revenue
Department Program Description Amount Amount Fund Activity/CIP Account Explanation
Airport 2C New Term Parking - Bond Investment Earnings 949 390 3902475 43110 Adjust to Actual
Airport 2C New Term Parking - Construction 949 390 3902475 73211 Adjust to Actual
Airport 2C New Term Furnish Equip - Bond Investment Earnings 638 390 3902531 43110 Adjust to Actual
Airport 2C New Term Furnish Equip - Construction 638 390 3902531 71110 Adjust to Actual
TOTALAIRPORTCONSTRUCTION FUND 472,105 1,332,024
DEBT SERVICE FUND
Police 70 Police Debt Service - Bond Proceeds 188,715 400 40011800 54210 2018 Refunding Debt
Police 70 Police Debt Service - Principal Payment 185,850 400 40011800 74111 2018 Refunding Debt
Police 70 Police Debt Service - Bond Issuance Fees 2,865 400 40011800 62721 2018 Refunding Debt
Parks 70 Park Debt Service - Bond Proceeds 110,832 400 40030600 54210 2018 Refunding Debt
Parks 70 Park Debt Service - Principal Payment 109,150 400 40030600 74111 2018 Refunding Debt
Parks 70 Park Debt Service - Bond Issuance Fees 1,682 400 40030600 62721 2018 Refunding Debt
Parks 70 Parks Debt Service - Bond Proceeds 86,669 400 40030600 54210 2018 Refunding Debt
Parks 70 Parks Debt Service - Principal Payment 85,353 400 40030600 74111 2018 Refunding Debt
Parks 70 Parks Debt Service - Bond Issuance Fees 1,316 400 40030600 74111 2018 Refunding Debt
Recreation 70 Recreation Debt Service - Bond Proceeds 10,842 400 40034700 54210 2018 Refunding Debt
Recreation 70 Recreation Debt Service - Principal Payment 10,677 400 40034700 74111 2018 Refunding Debt
Recreation 70 Recreation Debt Service - Bond Issuance Fees 165 400 40034700 62721 2018 Refunding Debt
Library 70 Library Debt Service - Bond Proceeds 124,199 400 40036240 54210 2018 Refunding Debt
Library 70 Library Debt Service - Principal Payment 122,314 400 40036240 74111 2018 Refunding Debt
Library 70 Library Debt Service - Bond Issuance Fees 1,885 400 40036240 62721 2018 Refunding Debt
Engineering 70 Engineering Debt Service - Bond Proceeds 1,014,865 400 40055400 54210 2018 Refunding Debt
Engineering 70 Engineering Debt Service - Principal Payment 999,459 400 40055400 74111 2018 Refunding Debt
Engineering 70 Engineering Debt Service - Bond Issuance Fees 15,406 400 40055400 74111 2018 Refunding Debt
Engineering 70 Engineering Debt Service - Bond Proceeds 777,672 400 40055400 54210 2018 Refunding Debt
Engineering 70 Engineering Debt Service - Principal Payment 765,867 400 40055400 74111 2018 Refunding Debt
Engineering 70 Engineering Debt Service - Bond Issuance Fees 11,805 400 40055400 62721 2018 Refunding Debt
Building 70 Building Services Debt Service - Bond Proceeds 395,930 400 40057300 54210 2018 Refunding Debt
Building 70 Building Services Debt Service - Principal Payments 384,110 400 40057300 74111 2018 Refunding Debt
Building 70 Building Services Debt Service - Bond Issuance Cost 11,820 400 40057300 62721 2018 Refunding Debt
Economic Developme 70 TIF Greater powntown - Bond Proceeds 1,637,053 400 40060910 54210 2018 Refunding Debt
Economic Developme 70 TIF Greater powntown - Principal Payment 1,612,202 400 40060910 74111 2018 Refunding Debt
Economic Developme 70 TIF Greater powntown - Bond Issuance Fees 24,851 400 40060910 62721 2018 Refunding Debt
Economic Developme 70 TIF DICW- Bond Proceeds 124,691 400 40060930 54210 2018 Refunding Debt
Economic Developme 70 TIF DICW- Principal Payment 122,798 400 40060930 74111 2018 Refunding Debt
Economic Developme 70 TIF DICW- Bond Issuance Fees 1,893 400 40060930 62721 2018 Refunding Debt
Economic Developme 70 DICW Debt Service - Bond Proceeds 241,994 400 40060930 54210 2018 Refunding Debt
Economic Developme 70 DICW Debt Service - Principal Payments 234,769 400 40060930 74111 2018 Refunding Debt
Economic Developme 70 DICW Debt Service - Bond Issuance cost 7,225 400 40060930 62721 2018 Refunding Debt
Economic Developme 70 Economic Development - Principal Payments 1,000,000 400 40060400 74111 IFAAdvance Payment
TOTAL DEBT SERVICE FUND 5,713,462 4,713,462
SANITARY OPERATING FUND
W&RRC 80 Sanitary- Bond Proceeds 516,127 610 61043100 54210 2018 Refunding Debt
W&RRC 80 Sanitary Debt Service - Bond Proceeds 1,038,170 610 61043100 54210 2018 Refunding Debt
W&RRC 80 Sanitary Debt Service - Principal Payment 1,022,410 610 61043100 74111 2018 Refunding Debt
Page 7
FISCAL YEAR 2018 AMENDMENT #2 CITY COUNCIL
27-Feb-18
FY 18 FY 18
Expense Revenue
Department Program Description Amount Amount Fund Activity/CIP Account Explanation
W&RRC 80 Sanitary Debt Service - Bond Issuance Fees 15,760 610 61043100 62721 2018 Refunding Debt
Engineering 80 Sanitary- Principal Payment 508,292 610 61043100 74111 2018 Refunding Debt
Engineering 80 Sanitary- Bond Issuance Fees 7,835 610 61043100 62721 2018 Refunding Debt
WRRC 80 Plant Operations - Property Insurance (7,293) 610 61043400 62206 Adjust to Actual
WRRC 80 Plant Operations - General Liability Insurance (2,446) 610 61043400 62208 Adjust to Actual
WRRC 80 Plant Operations - Polymer (20,000) 610 61043400 62638 Adjust to Actual
WRRC 80 Plant Operations - Utility Expense Electricity 29,739 610 61043400 62411 Adjust to Actual
Public Works 80 Sanitary Sewer Maint - General Liability Insurance (1,149) 610 61054300 62208 Adjust to Actual
TOTAL SANITARY OPERATI NG FUND 1,553,148 1,554,297
STORMWATER OPERATING FUND
Engineering 80 Stormwater - Bond Proceeds 105,819 620 62055620 54210 2018 Refunding Debt
Engineering 80 Stormwater - Principal Payment 104,213 620 62055620 74111 2018 Refunding Debt
Engineering 80 Stormwater - Bond Issuance Fees 1,606 620 62055620 62721 2018 Refunding Debt
Engineering 80 Stormwater Debt Service - Bond Proceeds 1,728,129 620 62055620 54210 2018 Refunding Debt
Engineering 80 Stormwater Debt Service - Principal Payment 1,701,895 620 62055620 74111 2018 Refunding Debt
Engineering 80 Stormwater Debt Service - Bond Issuance Fees 26,234 620 62055620 62721 2018 Refunding Debt
Public Works 80 Storm Sewer Maintenance - General Liability Insurance (1,389) 620 62054310 62208 Adjust to Actual
Engineering 80 Stormwater Utility O&M - Construction 40,000 620 62055620 73211 Maus Lake Culvert Repair
Engineering 80 Stormwater Utility O&M - Insurance Claims 40,000 620 62055620 53610 Maus Lake Culvert Repair
TOTAL STORMWATER OPERATING FUND 1,872,559 1,873,948
PARKING OPERATING FUND
Parking Division 80 Parking Debt Service - Bond Proceeds 45,876 630 63046310 54210 2018 Refunding Debt
Parking Division 80 Parking Debt Service - Principal Payment 45,180 630 63046310 74111 2018 Refunding Debt
Parking Division 80 Parking Debt Service - Bond Issuance Fees 696 630 63046310 62721 2018 Refunding Debt
Parking Division 80 Parking Debt Service - Bond Proceeds 377,388 630 63046350 54210 2018 Refunding Debt
Parking Division 80 Parking Debt Service - Principal Payments 366,121 630 63046350 74111 2018 Refunding Debt
Parking Division 80 Parking Debt Service - Bond Issuance Cost 11,267 630 63046350 62721 2018 Refunding Debt
Parking Division 80 Intermodal Facility- Property Insurance (592) 630 63046370 62206 Adjust to Actual
Parking Division 80 Port of Dbq Ramp - Property Insurance (2,248) 630 63046350 62206 Adjust to Actual
Parking Division 80 lowa Street Ramp - Property Insurance (916) 630 63046310 62206 Adjust to Actual
Parking Division 80 Five Flags Ramp - Property Insurance (898) 630 63046330 62206 Adjust to Actual
Parking Division 80 5th Street Ramp - Property Insurance (898) 630 63046320 62206 Adjust to Actual
Parking Division 80 10th & Central Ramp - Property Insurance (889) 630 63046360 62206 Adjust to Actual
Parking Division 80 Locust Street Ramp - Property Insurance (772) 630 63046300 62206 Adjust to Actual
TOTAL PARKING OPERATING FUND 416,051 423,264
WATER OPERATING FUND
Water 80 Water - Bond Proceeds 507,394 640 64042100 54210 2018 Refunding Debt
Water 80 Water - Principal Payment 499,692 640 64042100 74111 2018 Refunding Debt
Water 80 Water - Bond Issuance Fees 7,702 640 64042100 62721 2018 Refunding Debt
Water 80 Water Debt Service - Bond Proceeds 1,165,089 640 64042100 54210 2018 Refunding Debt
Water 80 Water Debt Service - Principal Payment 1,147,403 640 64042100 74111 2018 Refunding Debt
Water 80 Water Debt Service - Bond Issuance Fees 17,686 640 64042100 62721 2018 Refunding Debt
Water 80 Plant Operations & Maintenance - Property Insurance (5,927) 640 64042400 62206 Adjust to Actual
Water 80 Water Distribution System - Property Insurance (681) 640 64042700 62206 Adjust to Actual
Water 80 Plant Operations & Maintenance - General Liability Insuranc (1,611) 640 64042400 62208 Adjust to Actual
Page 8
FISCAL YEAR 2018 AMENDMENT #2 CITY COUNCIL
27-Feb-18
FY 18 FY 18
Expense Revenue
Department Program Description Amount Amount Fund Activity/CIP Account Explanation
Water 80 Water Distribution System - General Liability Insurance (1,158) 640 64042700 62208 Adjust to Actual
Water 80 Water Distribution - GPS Collector 6,750 640 64042700 72415 Replacement GPS Collector
Water 80 Water Distribution - Tablets 2,700 640 64042700 71120 Additional tablets
Water 80 Water Distribution - Virtual Computer 300 640 64042700 71124 Additional Virtual PC
TOTAL WATER OPERATING FUND 1,672,856 1,672,483
REFUSE OPERATING FUND
Public Works 80 Refuse Debt Service - Bond Proceeds 27,665 670 67054100 54210 2018 Refunding Debt
Public Works 80 Refuse Debt Service - Principal Payment 27,245 670 67054100 74111 2018 Refunding Debt
Public Works 80 Refuse Debt Service - Bond Issuance Fees 420 670 67054100 62721 2018 Refunding Debt
Public Works 80 Refuse Collection - General Liability Insurance (1,566) 670 67054500 62208 Adjust to Actual
Public Works 80 Refuse Collection - Carts 11,500 670 67054500 71221 Use additional from Truck Replaceme
Public Works 80 Yard Waste Collection - Carts 1,984 670 67054510 71221 Use additional from Truck Replaceme
Public Works 80 Recycling Collection Program - Recycling Containers 13,191 670 67054530 72818 Use additional from Truck Replaceme
Public Works 80 Refuse Collection - Truck Replacement (26,675) 670 67054500 71314 Move to Cart Purchases
TOTAL REFUSE OPERATING FUND 26,099 27,665
SANITARY SEWER CONSTRUCTION FUND
WRRC 8C Methane Gas System - Consulting Engineers 25,000 710 7102698 62712 BRD Contribution for Engineering
WRRC 8C Methane Gas System - Private Participant 25,000 710 7102698 53102 BRD Contribution for Engineering
WRRC 8C Level 4 Agreement - Construction 25,000 710 7102700 73211 From Clarifier Realign 7102598
WRRC 8C Clarifier Realign/Repair - Construction (25,000) 710 7102598 73210 To Level 4 Agreement 7102700
WRRC 8C Frack Tank - Equipment Acquisition 6,593 710 7102730 73410 Temporary HS Waste Storage
WRRC 8C HS Waste Storage - Construction (6,593) 710 7102701 73211 To Frack Tank 7102730
W&RRC 8C HS Waste Receive and Store - Bond Investment Earnings 487 710 7102701 43110 Adjust to Actual
W&RRC 8C HS Waste Receive and Store - Construction 487 710 7102701 73211 Adjust to Actual
Engineering 8C Sewer Ext New Develop - Bond Investment Earnings 106 710 7101350 43110 Adjust to Actual
Engineering 8C Sewer Ext New Develop - Construction 106 710 7101350 73211 Adjust to Actual
Engineering 8C Sewer Lining - Bond Investment Earnings 1,093 710 7101637 43110 Adjust to Actual
Engineering 8C Sewer Lining - Construction 1,093 710 7101637 73211 Adjust to Actual
Engineering 8C Reloc 30" Main - Bond Investment Earnings 1,826 710 7102413 43110 Adjust to Actual
Engineering 8C Reloc 30" Main - Construction 1,826 710 7102413 73211 Adjust to Actual
Engineering 8C Wash Sanitary 7th to 9th - Bond Investment Earnings 872 710 7102547 43110 Adjust to Actual
Engineering 8C Wash Sanitary 7th to 9th - Construction 872 710 7102547 73211 Adjust to Actual
Engineering 8C Cedar/Term Assessments - Bond Investment Earnings 1,622 710 7102606 43110 Adjust to Actual
Engineering 8C Cedar/Term Assessments - Construction 1,622 710 7102606 73211 Adjust to Actual
Engineering 8C Kerper Sanitary- Bond Investment Earnings 2,034 710 7102663 43110 Adjust to Actual
Engineering 8C Kerper Sanitary- Construction 2,034 710 7102663 73211 Adjust to Actual
Engineering 8C 30th & Jackson Sanitary - Bond Investment Earnings 284 710 7102720 43110 Adjust to Actual
Engineering 8C 30th & Jackson Sanitary - Construction 284 710 7102720 73211 Adjust to Actual
Engineering 8C Coates Sanitary - Bond Investment Earnings 211 710 7102728 43110 Adjust to Actual
Engineering 8C Cotes Sanitary - Construction 211 710 7102728 73211 Adjust to Actual
TOTAL SANITARY SEWER CONST FUND 33,535 33,535
STORMWATER CONSTRUCTION FUND
Engineering 8C Flood Control Maintenance Facil - Consulting Engineers 200,000 720 7202609 62712 Miscoded
Engineering 8C Avoca Storm - Bond Investment Earnings 5 720 7202667 43110 Adjust to Actual
Engineering 8C Avoca Storm - Construction 5 720 7202667 73211 Adjust to Actual
Page 9
FISCAL YEAR 2018 AMENDMENT #2 CITY COUNCIL
27-Feb-18
FY 18 FY 18
Expense Revenue
Department Program Description Amount Amount Fund Activity/CIP Account Explanation
Engineering 8C SW Arterial Storm - Bond Investment Earnings 8 720 7202670 43110 Adjust to Actual
Engineering 8C SW Arterial Storm - Construction 8 720 7202670 73211 Adjust to Actual
TOTAL STORM WATER CONST FUND 200,013 13
WATER CONSTRUCTION FUND
Water 8C West Rural Water Purchase - Pay to Other Agency 1,139,135 740 7402703 62761 CIWA Payment
Water 8C West Rural Water Purchase - State Revolving Loan Funds 1,139,135 740 7402703 54230 SRF Funding for CIWA Payment
Water 8C Rural Water English Pump 967,896 740 7402734 73211 Move from 7402703
Water 8C West Rural Water Purchase/Improvements - Const (967,896) 740 7402703 73211 Move to 7402734
Water 8C Roosevelt Road Water Tower- Bond Investment Earn 5,140 740 7401672 43110 Adjust to Actual
Water 8C Roosevelt Road Water Tower- Construction 5,140 740 7401672 73211 Adjust to Actual
Water 8C Online Process Analyzer - Bond Investment Earn 97 740 7402524 43110 Adjust to Actual
Water 8C Online Process Analyzer- Construction 97 740 7402524 73410 Adjust to Actual
Water 8C Generator- Bond Investment Earnings 850 740 7402527 43110 Adjust to Actual
Water 8C Generator- Construction 850 740 7402527 73211 Adjust to Actual
Water 8C SW Arterial Main Ext - Bond Investment Earnings 1,765 740 7402594 43110 Adjust to Actual
Water 8C SW Arterial Main Ext- Construction 1,765 740 7402594 73211 Adjust to Actual
Water 8C Creek Crossing Restore - Bond Investment Earnings 303 740 7402595 43110 Adjust to Actual
Water 8C Creek Crossing Restore- Construction 303 740 7402595 73211 Adjust to Actual
Water 8C Main Relocate Sewer Manhole - Bond Investment Earnings 130 740 7402596 43110 Adjust to Actual
Water 8C Main Relocate Sewer Manhole- Construction 130 740 7402596 73211 Adjust to Actual
Water 8C Water Main Replace Consent- Bond Investment Earnings 1,620 740 7402658 43110 Adjust to Actual
Water 8C Water Main Replace Consent- Construction 1,620 740 7402658 73211 Adjust to Actual
Water 8C Timber Ridge Water Main- Bond Investment Earnings 1,323 740 7402704 43110 Adjust to Actual
Water 8C Timber Ridge Water Main- Construction 1,323 740 7402704 73211 Adjust to Actual
Water 8C Grandview/Loras- Bond Investment Earnings 387 740 7402705 43110 Adjust to Actual
Water 8C Grandview/Loras- Construction 387 740 7402705 73211 Adjust to Actual
Engineering 8C SRF Green Alley - Construction (2,742) 740 7402625 73211 SRF Green Alley Coverage
Information Services 8C Water Distribution - Mobile Laptops 40,761 740 7401069 71124 Replacement laptops
TOTAL WATER CONSTRUCTION FUND 1,188,769 1,150,750
ENGINEERING INTERNAL SERVICE FUND
Engineering 80 Project Engineering - General Liability Insurance (8,886) 800 80055400 62206 Adjust to Actual
Engineering 80 Engineering Admin - General Liability Insurance (2,621) 800 80055400 62208 Adjust to Actual
TOTAL ENGINEERING INTERNAL SERVICE FUND (11,507) -
GARAGE INTERNAL SERVICE FUND
Public Works 80 Garage - Property Insurance (64� 810 81054600 62206 Adjust to Actual
Public Works 80 Garage - General Liability Insurance (1,483) 810 81054600 62208 Adjust to Actual
TOTAL GARAGE INTERNAL SERVICE FUND (2,130) -
LANDFILL FUND
Public Works 80 Landfill - Property Insurance (4,231) 940 94054200 62206 Adjust to Actual
Public Works 80 Landfill - General Liability Insurance (6,079) 940 94054200 62208 Adjust to Actual
Public Works 80 Household Haz Mat RCC - General Liability Insurance (1,416) 940 94054220 62208 Adjust to Actual
Public Works 9C Short-Term Facilities - Bond Investment Earnings 3,982 940 9402685 43110 Adjust to Actual
Public Works 9C Short-Term Facilities - Consultant Services 3,982 940 9402685 62716 Adjust to Actual
Public Works 9C Cell 9 Phase 3 - Bond Investment Earnings 27,307 940 9402702 43110 Adjust to Actual
Page 10
FISCAL YEAR 2018 AMENDMENT #2 CITY COUNCIL
27-Feb-18
FY 18 FY 18
Expense Revenue
Department Program Description Amount Amount Fund Activity/CIP Account Explanation
Public Works 9C Cell 9 Phase 3 - Construction 27,307 940 9402702 73211 Adjust to Actual
TOTAL LANDFILL FUND 19,563 31,289
TRANSFERS Transfer Out Transfer In
Engineering Trans1 Transfer from Sales Tax 20% Fund to Stormwater Fund (125,876) 620 62055620 59350 Transfer funds
Engineering Trans1 Transfer from General Fund to Stormwater Fund 125,876 620 62055620 59102 Transfer funds
Airport Trans2 Transfer from Sales Tax 20% Fund to Airport Const. 226,291 350 35010350 91390 Transfer funds
Economic Developme Trans3 Transfer from General Fund to Debt Service Fund 1,000,000 100 1002279 91400 Transfer funds
Economic Developme Trans3 Transfer from General Fund to Debt Service Fund 1,000,000 400 40060400 59100 Transfer funds
Transit Division Trans4 Transfer to General construction from Transit Fund 257,993 600 6002446 91360 Transfer funds
Transit Division Trans4 Transfer to General construction from Transit Fund 257,993 360 3602446 59600 Transfer funds
Library Trans5 Transfer from General Gift Trust to Makers Space 5,000 295 29536480 91295 Makers Space Operations
Library Trans5 Transfer from General Gift Trust to Makers Space 5,000 295 29536500 59295 Makers Space Operations
Economic Developme Trans6 Transfer from GDTIF Fund to DT Revolving Loan Fund 180,000 240 24060240 91241 Transfer Funds
Economic Developme Trans6 Transfer from GDTIF Fund to DT Revolving Loan Fund 180,000 241 2411942 59240 Transfer Funds
Economic Developme Trans7 Transfer from General Const Fund to DT Revolving Fund 90,795 360 36010360 91241 Transfer Funds
Economic Developme Trans7 Transfer from General Const Fund to DT Revolving Fund 90,795 241 2411942 59360 Transfer Funds
Economic Developme Trans8 Transfer from General Const Fund to DT Revolving Fund 27,711 360 36010360 91241 Transfer Funds
Economic Developme Trans8 Transfer from General Const Fund to DT Revolving Fund 27,711 241 2411942 59360 Transfer Funds
W&RRC Trans9 Transfer from N Cascade TIF to Sanitary Sewer Fund 302,030 710 71010710 59215 Transfer funds
W&RRC Trans9 Transfer from N Cascade TIF to Sanitary Sewer Fund 302,030 215 21560215 91710 Transfer funds
Transit Division Trans10 Transfer from Sales Tax Const. to Transit Fund (29,175) 600 6001222 59350 Transfer funds
Transit Division Trans10 Transfer from Sales Tax Const. to Transit Fund 29,175 600 6001224 59350 Transfer funds
Transit Division Trans11 Transfer from Sales Tax Const. to Transit Fund (20,000) 600 6002235 59350 Transfer funds
Transit Division Trans11 Transfer from Sales Tax Const. to Transit Fund 20,000 600 6001224 59350 Transfer funds
Transit Division Trans12 Transfer from General Fund to Transit Fund 50,000 102 10210102 91600 Transfer funds
Transit Division Trans12 Transfer from General Fund to Transit Fund 50,000 600 6001224 59102 Transfer funds
Transit Division Trans13 Transfer from Sales Tax Const. to Transit Fund 56,672 350 35010350 91600 Transfer funds
Transit Division Trans13 Transfer from Sales Tax Const. to Transit Fund 56,672 600 6001224 59350 Transfer funds
Transit Division Trans14 Transfer from Sales Tax Const. to Transit Fund (95,000) 600 6002604 59350 Transfer funds
Transit Division Trans14 Transfer from Sales Tax Const. to Transit Fund (95,000) 350 35010350 91600 Transfer funds
Engineering Trans15 Transfer from N Cascade TIF to General Const Fund (406,000) 215 21560215 91360 Transfer funds
Engineering Trans15 Transfer from N Cascade TIF to General Const Fund (406,000) 360 3602021 59215 Transfer funds
Engineering Trans16 Transfer from DICW TIF to General Const Fund (82,308) 210 21060210 91360 Transfer funds
Engineering Trans16 Transfer from DICW TIF to General Const Fund (82,308) 360 3602551 59210 Transfer funds
Public Works Trans17 Transfer from Road Use Tax to Street Const Fund 16,498 250 25010250 91300 Transfer funds
Public Works Trans17 Transfer from Road Use Tax to Street Const Fund 5,748 300 3002539 59250 Transfer funds
Public Works Trans17 Transfer from Road Use Tax to Street Const Fund 9,150 300 3002539 59250 Transfer funds
Public Works Trans17 Transfer from Road Use Tax to Street Const Fund 1,600 300 3002039 59250 Transfer funds
Public Works Trans18 Transfer from Sales Tax 20% to Street Const Fund 15,917 350 35010350 91300 Transfer funds
Public Works Trans18 Transfer from Sales Tax 20% to Street Const Fund 15,917 300 3001445 59350 Transfer funds
Engineering Trans19 Transfer from Sales Tax 20% to Street Const Fund 18,170 350 35010350 91300 Transfer funds
Engineering Trans19 Transfer from Sales Tax 20% to Street Const Fund 18,170 300 3002559 59350 Transfer funds
Housing Trans20 Transfer from General Fund to Section 8 Fund 179,175 100 10010100 91280 Transfer funds
Housing Trans20 Transfer from General Fund to Section 8 Fund 179,175 280 28010280 59100 Transfer funds
TOTAL TRANSFERS 1,842,944 1,616,653
Page 11