Loading...
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