Loading...
Fiscal Year 2020 Budget Amendment No. 2_Initiate Copyrighted October 21 , 2019 City of Dubuque Items to be set for Public Hearing # 1. ITEM TITLE: Fiscal Year 2020 BudgetAmendment No. 2 SUMMARY: City Manager recommending thatthe second Fiscal Year 2020 Budget Amendment be set for public hearing for November4, 2019. RESOLUTION Setting the date for the public hearing on Amendment No. 2 to the Fiscal Year 2020 Budget for the Cityof Dubuque SUGGESTED DISPOSITION: Suggested Disposition: Receive and File; Adopt Resolution(s), Set Public Hearing for November4, 2019 ATTACHMENTS: Description Type MVM Memo City Manager Memo Staff Memo Staff Memo Resolution Resolutions Amendment Detail Supporting Documentation Notice of Public Hearing Supporting Documentation Dubuque THE CITY OF � All-America City DuB E ;���� �, Maste iece on the MissTssT i zao�.zo12•zo13 YP PP �oi�*zoi9 TO: The Honorable Mayor and City Council Members FROM: Michael C. Van Milligen, City Manager SUBJECT: Fiscal Year 2020 Second Budget Amendment DATE: October 14, 2019 Director of Finance and Budget Jennifer Larson is recommending the second Fiscal Year 2020 Budget Amendment be set for public hearing for November 4, 2019. 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, Director of Finance and Budget Dubuque THE CITY OF � All-America City DuB E ;���� �, Maste iece on the MissTssT i zao�.zo12•zo13 YP PP �oi�*zoi9 TO: Michael C. Van Milligen, City Manager FROM: Jennifer Larson, Director of Finance and Budget SUBJECT: Fiscal Year 2020 Second Budget Amendment DATE: October 14, 2019 The purpose of this memorandum is to present a summary of the action items approved by City Council since the last budget amendment and to hold the public hearing 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 2020 budget was adopted in September 2019, appropriations from the Fiscal Year 2019 budget that were missed in the first amendment, and adjustments to reflect the Landfill budget. A decrease of interfund transfers of $223,095 is also included. This amendment totals $933,864 in increased appropriation authority and a decrease in resources of$313,783. In addition, this amendment includes Landfill fund expenses of $2,090,646 and resources of $735,068 that are not required by state law to be appropriated but are being included in order to simplify Landfill internal reporting. Additional revenues added in this amendment with offsetting appropriations include the State Fire Marshal Fireworks Grant for Fire Training ($19,155). Reduced revenues reflected in this amendment with offsetting reductions in appropriations include Lead Hazard Mitigation Lead Grant Revenue (-$5,000) due to close out of the previous grant, lowa Finance Authority Trust Grant Revenue (-$235,793) due to a duplication of the Fiscal Year 2020 budget, Eagle Point Park State Revolving Fund Loan Sponsorship Revenue (-$92,145) based on the reduced final loan for the Kerper Boulevard Sanitary Improvements State Revolving Fund Loan. This amendment includes the portion of the Fiscal Year 2020 revised budget recommendation that exceeded the state program amount published, which includes a portion of the Housing Inspector position vehicle ($9,628) and Five Flags Metal Detectors and Wands ($65,048). Appropriations from the Fiscal Year 2019 budget include Sanitary Sewer Maintenance Truck Replacement ($94,500), Valentine Park Demolition of Buildings ($24,934), Comiskey Park Building Alarm ($10,000), Comiskey Park New Entry ($30,497), Comiskey Park New Amenities ($60,286), Landfill Flare Equipment Maintenance ($14,000), Landfill Gas Field Operations ($16,000), and Bee Branch Gate and Pump Replacement ($484,963). These are projects that were missed in the first amendment to be carried over from Fiscal Year 2019 to Fiscal Year 2020. This amendment includes $196,200 for the acquisition of property at 6805 Pennsylvania Avenue for the future widening of Pennsylvania Avenue — Middle Road. The action step is for City Council to adopt the attached resolution approving the Fiscal Year 2020 second budget amendment. Attachments JML 2 Prepared by Jenny -Larson, -City Hall, -50 W. 13th St, -Dubuque; IA5200-17563-589-4322 Return to Kevin Firnstahl, City Clerk, 50 W. 13th St., Dubuque, IA 52001, 563-589-4100 RESOLUTION NO. 380-19 SETTING THE DATE FOR THE PUBLIC HEARING ON AMENDMENT NO. 2 TO THE FISCAL YEAR 2020 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 2020 budget for the City of Dubuque at the City Council Chambers at the Historic Federal Building, 350 West 6th Street, Dubuque, Iowa, on Monday, November 4, 2019, 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 14th day of October 2019. /Id Attest: K in S. Firnstah , Citi Clerk ?- Roy D. Buol, Mayor FISCAL YEAR 2020 AMENDMENT#2 CITY COUNCIL 14-Oct-19 FY20 FY20 Expense Revenue Departmen[ Program Descrip[ion Amoun[ Amoun[ Fund Ac[ivi[y/CIP Accoun[ Explana[ion GENERALFUND Fire 10 FireTraining-TrainingandEducation 19,155 100 10013700 62360 NewGrantAppropriation Fire 10 Fire Training-State Fire Marshal Fireworks Grant 19,155 100 10013700 45701 New Grant Parks 4C EPP Environmental-SRF Sponsorship (92,145) 100 1002643 54230 Adjust to Actual Parks 4C EPP Environmental-Consultant Services (92,145) 100 1002643 62716 Adjust to Actual Parks 4C Valentine Park-Demolition of Buildings 24,934 100 1001560 62741 Carryover Civic Center 4C Five Flags Metal Detedor and Wands-Sewrity Equipment 65,048 100 1002819 72321 Adjust to Actual Engineering 2C Riverwalk Sewrity Cameras-Cameras (2Q000) 100 1001963 72417 Correct Carryover Economic Developme 50 Economic Develpoment-Rental of Space 540 100 10060700 62436 Adjust to Actual Economic Developme 50 Arts and Cultural Affairs-Rental of Space 540 100 10072500 62436 Adjust to Actual HousingandCommur50 Administration-PaytoOtherAgency (25,000) 100 10061100 62761 AdjusttoActual Housing and Commur 50 Resiliency Grant-Copying 300 100 10061264 62110 Adjust to Actual HousingandCommur50 ResiliencyGrant-Telephone 1,400 100 10061264 62421 AdjusttoActual Housing and Commur 50 Resiliency Grant-Rental of Space 1,400 100 10061264 62436 Adjust to Actual Housing and Commur 50 Resiliency Grant-Data Services 1,000 100 10061264 62667 Adjust to Actual Housing and Commur 50 General Housing Inspections-Uniforms 400 100 10061700 62011 Adjust to Actual Housing and Commur 50 General Housing Inspections-Office Supplies 140 100 10061700 62010 Adjust to Actual Housing and Commur 50 General Housing Inspections-Miscellaneous Equipment 1,460 100 10061700 71550 Adjust to Actual Housing and Commur 50 General Housing Inspections-Vehicle 9,628 100 10061700 71310 Adjust to Actual Finance 60 Accounting-Full-Time Employees 6,920 100 10074100 61010 Adjust to Actual Finance 60 Accounting-Part-Time Employees 25,561 100 10074100 61020 Adjust to Actual Finance 60 Accounting-IPERS 3,066 100 10074100 61310 Adjust to Actual Finance 60 Accounting-Social Sewrity 2,485 100 10074100 61320 Adjust to Actual Finance 60 Budget-Full-TimeEmployees (9,363) 100 10074400 61010 AdjusttoActual Finance 60 Budget-IPERS (884) 100 10074400 61310 AdjusttoActual Finance 60 Budget-Social Sewrity (715) 100 10074400 61320 Adjust to Actual Finance 60 Accounting-Audit Services 26,025 100 10074100 62726 CAFR Consulting Finance 6C ERPSystemReplacement-Consulting 8,500 100 1001025 62716 AdjusttoActual Legal Services 60 Legal Services-Rental of Space 500 100 10076100 62436 Adjust to Actual Legal Services 60 Legal Services-Temporary Help Contract 12,136 100 10076100 62732 Adjust to Actual Parks 4C Comiskey Park Building Alarm-BurglarAlarm 1Q000 102 1022372 72420 Correct Carryover Parks 4C Eagle Point Park Improvements-Construction 47,000 102 1021866 72310 Shift from 3501158 Engineering 2C Riverwalk Sewrity Cameras-Cameras 2Q000 102 1021963 72417 Correct Carryover Information Services 6C Workstation/Chairs 5,797 102 1022683 71211 Correct Carryover TOTAL GENERAL FUND 145,828 (72,990) ROAD USE TAX FUND Engineering 2C Traffc SignalNideo Detedion-Construdion (4Q000) 250 2501816 73211 Correct Carryover Engineering 2C Traffc SignalNideo Detedion-Engineering (2,000) 250 2501816 62811 Correct Carryover TOTAL ROAD USE TAX FUND (42,000) - COMMUNITY DEVELOPMENT BLOCK GRANT FUND Housing and Commur SC Homeowner Rehab-Loans (613) 260 2601065 62764 Correct Carryover Housing and Commur 50 St.Mark's Tuckpointing-Pay to Other Agency (25,000) 260 26079240 62761 Encumbrance Correction TOTAL COMMUNITY DEVELOPMENT BLOCK FUND (25,613) - HOUSING TRUST FUND Housing and Commur SC IFA Housing Trust Grant-IFA Trust Grant (235,793) 268 2681021 45703 Adjust to Actual TOTAL HOUSING TRUST FUND - (235,793) LEAD PAINT ABATEMENT Page 1 FISCAL YEAR 2020 AMENDMENT#2 CITY COUNCIL 14-Oct-19 FY20 FY20 Expense Revenue Departmen[ Program Descrip[ion Amoun[ Amoun[ Fund Ac[ivi[y/CIP Accoun[ Explana[ion Housing and Commur SC Lead Hazard Mitigation-Lead Grant (5,000) 275 2752429 44310 Adjust to Actual TOTAL LEAD PAINTABATEMENT - (5,000) STREET CONSTRUCTION FUND Engineering 2C Traffc SignalNideo Detedion-Construdion 4Q000 300 3001816 73211 Correct Carryover Engineering 2C Traffc SignalNideo Detedion-Engineering 2,000 300 3001816 62811 Correct Carryover Engineering 2C LED Streetlight Retroft-Equipment (25,000) 300 3002484 73410 Correct Carryover TOTAL STREET CONSTRUCTION FUND 17,000 - SALES TAX FUND 120%1 Engineering 2C Downtown Streetlights-Equipment (25,956) 350 3501608 73410 Correct Carryover Parks 4C Comiskey Park New Entry-Construdion 3Q497 350 3501544 73211 Correct Carryover Parks 4C ComiskeyParkNewAmenities-Construction 6Q286 350 3501578 73211 CorrectCarryover Parks 4C Renovate Park Water System-Construction (47,000) 350 3501158 73211 Shift to 1021866 Information Services 6C Workstation/Chaire (5,797) 350 3502683 71211 Correct Carryover TOTAL SALES TAX FUND 12,030 - GENERALCONSTRUCTIONFUND Transit 2C Jule Operations and Training Center-Construction 24,000 360 3602446 73210 Correct Carryover Engineering 2C LED Streetlight Retroft-Equipment 25,000 360 3602484 73410 Correct Carryover Engineering 2C Downtown Streetlights-Equipment 25,956 360 3601608 73410 Correct Carryover Economic Developme SC Future Industrial Acquisitions-Land Acquisition 196,200 360 3602437 73110 Adjust to Actual Housing and Commur SC Homeownership Grants-Construdion (85,714) 360 3601595 73210 Shift to 3601595-62764 Housing and Commur SC Homeownership Grants-Loans 85,714 360 3601595 62764 Shift from 360159573210 TOTAL GENERAL CONSTRUCTION FUND 271,156 - TRANSIT FUND Transit 6C Jule Operations and Training Center-Construction (24,000) 600 6002446 73210 Correct Carryover TOTAL TRANSIT FUND (24,000) - SANITARY OPERATING FUND Public Works 2C Sanitary Sewer Maintenance-Truck Replacement 94,500 610 61054300 71314 Carryover TOTAL SANITARY OPERATING FUND 94,500 - STORMWATER OPERATING FUND Engineering 8C Bee Branch Gate and Pump Replacement-Construdion 484,963 720 7202608 73211 Adjust to Actual Engineering 8C General Storm lmprovements-Construction (9Q000) 720 7201066 73211 Shift to 7201666 Engineering 8C Amy Court Storm Improvements-Construction 90,000 720 7201666 73211 Shift from 7201066 TOTAL STORMWATER OPERATING FUND 484,963 - LANDFILL FUND Landfll 80 Landfll-GasFieldOperations 16,000 940 94054260 62712 AdjusttoActual Landfll 80 Landfll-FlareEquipmentMaintenance 14,000 940 94054260 62611 AdjusttoActual Landfll 9C Landfll-Environmental Management System/Comp Plan 8,000 940 9402268 62716 Adjust toActual Landfll 9C Landfll-LandfllCe119Phase2-Stone (11,068) 940 9402631 62620 AdjusttoActual Landfll 9C Landfll-LandfllCe119Phase2-ConsultingEngineere (226,879) 940 9402631 62712 AdjusttoActual Landfll 9C Landfll-LandfllCe119Phase2-Construction (2,382,496) 940 9402631 73211 AdjusttoActual Landfll 9C Landfll-Swiss Valley Land Acquisition (8,823) 940 9402770 73210 Adjust to Actual Landfll 9C Landfll-ShortTerm Facilities 756,167 940 9402821 62716 AdjusttoActual Landfll 9C Landfll-WaterMainExtension 431,250 940 9402821 73211 AdjusttoActual Landfll 9C Landfll-Ce119PhaselVExpansion 1,80Q918 940 9402820 73211 AdjusttoActual Landfll 90 Landfll-InvestmentEarnings 14,055 940 94082800 43110 AdjusttoActual Page 2 FISCAL YEAR 2020 AMENDMENT#2 CITY COUNCIL 14-Oct-19 FY20 FY20 Expense Revenue Departmen[ Program Descrip[ion Amoun[ Amoun[ Fund Ac[ivi[y/CIP Accoun[ Explana[ion Landfll 90 Landfll-StateGrants 3Q680 940 94082800 45701 AdjusttoActual Landfll 90 Landfll-IA DNR RCC Operation 27,567 940 94082800 45731 Adjust to Actual Landfll 90 Landfll-E-ScrapRecyclingFees (5,908) 940 94082800 51643 AdjusttoActual Landfll 90 Landfll-GasSales 6,000 940 94082800 51644 AdjusttoActual Landfll 90 Landfll-CustomerFees,HHMRCC 1Q692 940 94082800 51655 AdjusttoActual Landfll 90 Landfll-CashFees (533,639) 940 94082800 51675 AdjusttoActual Landfll 90 Landfll-ChargeFees (4,654,769) 940 94082800 51680 AdjusttoActual Landfll 90 Landfll-GateRate 688,050 940 94082800 51682 AdjusttoActual Landfll 90 Landfll-ContractRate 3,776,200 940 94082800 51683 AdjusttoActual Landfll 90 Landfll-TransferRate 768,661 940 94082800 51684 AdjusttoActual Landfll 90 Landfll-Compost (2,432) 940 94082800 51685 AdjusttoActual Landfll 90 Landfll-MRF (432) 940 94082800 51687 AdjusttoActual Landfll 90 Landfll-EventsRevenue 14,222 940 94082800 51965 AdjusttoActual Landfll 90 Landfll-PrivateParticipant (1,217) 940 94082800 53102 AdjusttoActual Landfll 90 Landfll-ReimbursementGeneral (11,282) 940 94082800 53620 AdjusttoActual Landfll 90 Landfll-SalesTaeCollection (2,368) 940 94082800 53630 AdjusttoActual Landfll 90 Landfll-SalesTar 901 940 94082800 53635 AdjusttoActual Landfll 90 Landfll-EquipmentSales (141) 940 94082800 54106 AdjusttoActual Landfll 90 Landfll-SpecialWastes 166,579 940 94082800 51676 AdjusttoActual Landfll 90 Landfll-ImpactedSoil 37,202 940 94082800 51677 AdjusttoActual Landfll 90 Landfll-BenefcialUse 40,000 940 94082800 51678 AdjusttoActual Landfll 90 Landfll-ASR 30Q000 940 94082800 51679 AdjusttoActual Landfll 90 Landfll-ShingleFees 21,000 940 94082800 51681 AdjusttoActual Landfll 90 Landfll-ApplianceFees 15,520 940 94082800 51681 AdjusttoActual Landfll 90 Landfll-TireRecycling 29,927 940 94082800 51688 AdjusttoActual Landfll 90 Landfll-Refunds (653) 940 94082800 62204 AdjusttoActual Landfll 90 Landfll-PropertyTax (99) 940 94082800 62211 AdjusttoActual Landfll 90 Landfll-ProgrammingPlanningExpenditure 3Q000 940 94082800 62669 AdjusttoActual Landfll 90 Landfll-ConsultingEngineere (2,874) 940 94082800 62712 AdjusttoActual Landfll 90 Landfll-OpsandFinancialAnalysis (8,429) 940 94082800 62721 AdjusttoActual Landfll 90 Landfll-WasteMinimizationGrants 4,913 940 94082800 62765 AdjusttoActual Landfll 90 Landfll-AirspaceSurvey/DirtUse/CompactionStudy (9,987) 940 94082800 62779 AdjusttoActual Landfll 90 Landfll-MechanicTruck 17Q000 940 94082800 71314 AdjusttoActual Landfll 90 Landfll-CrawlerpozerReplacement 354,106 940 94082800 71318 AdjusttoActual Landfll 90 Landfll-TrashCompador 925,000 940 94082800 71540 AdjusttoActual Landfll 90 Landfll-HookTruckTank 31,836 940 94082800 71550 AdjusttoActual Landfll 90 Landfll-WasteWizard 26,922 940 94082800 71550 AdjusttoActual Landfll 90 Landfll-3480JDGatorUTVReplacement 19,842 940 94082800 71619 AdjusttoActual Landfll 90 Landfll-CameraEquipmentReplacement 8,000 940 94082800 72417 AdjusttoActual Landfll 90 Landfll-Closure/PostClosurePayment 145,000 940 94082800 62603 AdjusttoActual TOTAL LANDFILL FUND 2,09Q646 735,068 TRANSFERS Transit Transl Transfer from GDTIF to General Construdion Fund (177,295) 240 24060240 91360 Transfer Funds Transit Transl Transfer from GDTIF to General Construdion Fund (177,295) 360 3602446 59240 Transfer Funds Economic Developme Trans2 Transfer from DICW to General Construdion Fund 196,200 210 21060210 91360 Transfer Funds Economic Developme Trans2 Transfer from DICW to General Construdion Fund 196,200 360 3602437 59210 Transfer Funds Economic Developme Trans3 Transfer from GDTIF to Parking Operating Fund (242,000) 240 24060240 91630 Transfer Funds Economic Developme Trans3 Transfer from GDTIF to Parking Operating Fund (242,000) 630 63046310 59240 Transfer Funds (223,095) (223,095) 2,801,415 198,190 Page 3 Jun-19 NOTICE OF PUBLIC HEARING Fo,ms�.a AMENDMENTOF FY2019-2020 CITY BUDGET TheCityCouncilof Dubuque in DUBUQUE County, lowa will meet at Historic Federal Building 350 West 6th St at 6:00 p.m. on 11/4/2019 (�ourJ (DeteJ ,forthepurposeofamendingthecurrentbudgetofthecityforthefiscalyearendingJune30, 2020 irea,i 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. TotalBudget TotalBudget as certified Current after Current orlastamended Amendment Amendment Revenues&Other Financinq Sources Taxes Levietl on Property 1 25,575,669 25,575,669 Less:Uncolletletl Property Tares-Levy Vear 2 0 0 NetCurrentProperry7axez 3 25,575,669 0 25,575,669 Delinquent Property Taxes 4 0 0 TIF Revenues 5 1 Q738,108 1 Q738,108 other Ciry Taxes 6 18,167,857 18,167,857 Licenses&Permits 7 1,904,123 1,904,123 Use ofMoneyantl Property 8 14,391,312 14,391,312 Intergwernmental 9 10Q34Q485 -221,638 10Q118,847 Chargesforservices 10 43,90Q588 43,90Q588 Special Assessmenis 11 3Q000 3Q000 Miscellaneous 12 11,461,791 11,461,791 otherFinancingsources 13 38,313,330 -92,145 38,221,185 Trensfersln 14 36,239,122 -223,095 36,016,027 7otalRevenuesantlOthersources 15 301,062,385 -536,878 30Q525,507 Expenditures&Other Financinq Uses Publicsafety 16 3Q896,479 19,155 3Q915,634 Public Works 17 14,384,293 14,384,293 Healih antl Social Services 18 1,313,039 1,313,039 CulWre antl Recreation 19 13,84Q099 13,84Q099 CommunityantlEconomicDevelopment 20 15,062,689 -33,192 15,029,497 GenerelGovemment 21 1Q629,268 65,731 1Q694,999 Debt Service 22 12,233,320 12,233,320 CapitalProjecis 23 88,849,020 421,207 89,27Q227 TotalGovemmentActivitiesExpentlitures 24 187,208,207 472,901 187,681,108 BusinessType/Enteryrises 25 94,509,645 490,963 95,OOQ608 7otalGovActivitiesffiBusinessE�entlitures 26 281,717,852 963,864 282,681,716 TrensFersout 27 36,239,122 -223,095 36,016,027 7otal Expentlituresmansfers out 28 317,956,974 74Q769 318,697,743 Excess Revenues&Other Sources Over (Untler�ExpentliturezrtransFersOutFiscalvear 29 -16,894,589 -1,277,647 -18,172,236 Beginning Funtl Balance July 1 30 82,384,365 82,384,365 EntlingFuntlBalaneeJune30 31 65,489,776 -1,277,647 64,212,129 Explanation of increases or decreases in revenue estimates,appropriations,or available cash: This amendment adds additional revenue from grants received and the appropriation to spend the monies, appropriations from the Fiscal Year 2019 budget that were missed in the frst amendment,to include the portion of the Fiscal Year 2020 revised budget recommendation that exceeded the state program amount published,and appropriation for property acquisition. 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 metfrom the increased non-propertytax revenues and cash balances not budgeted or considered in this current budget. Jennifer Larson, Director of Finance and Budget City Clerk/Finance Offcer Name