Loading...
Fiscal Year 2013 Budget Amendment No. 2Masterpiece on the Mississippi TO: The Honorable Mayor and City Council Members FROM: Michael C. Van Milligen, City Manager SUBJECT: Fiscal Year 2013 Second Budget Amendment DATE: April 25, 2013 Dubuque kital All- America City II 111! 2012 Budget Director Jennifer Larson is recommending approval of the second Fiscal Year 2013 Budget Amendment. This budget amendment includes items, which have been authorized by City Council since the first amendment to the Fiscal Year 2013 budget was adopted in September 2012 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 $581,563 is also included. The amendment totals $8,464,070 in increased appropriation authority and an increase in resources of $7,513,758. Additional revenues added in this amendment with offsetting appropriations are: • Bond Investment Earnings ($62,070) for various uncompleted projects, • Federal Aviation Administration Funds ($2,581,243) for Airport New Terminal Building, • General Obligation Borrowing paid from Airport Passenger Facility Charge ($1,989,722) for local match for Airport New Terminal Building, • Water Tower General Obligation Bond Refunding ($950,000), • Interfund Transfer from General Fund ($499,181) for Housing Section 8 Administrative Fee Reserve, • Edwin B. Lyons Trust ($450,000) for bequest to Park Division, • Community Development Block Grant ($91,466) for various programs due to uncommitted funds available, • Insurance Proceeds ($604,459) for Water & Resource Recovery Operations, and • Insurance Proceeds ($875,116) for Water & Resource Recovery Plant Upgrade. Reduced revenues reflected in this amendment with offsetting reductions in appropriations are: • Section 8 Administrative Fees (- $67,317) due to less Administrative Fee Income, • State Grant (- $100,000) for Bee Branch Restoration Project due to trail grant inadvertently included twice in the budget, and • Federal Pass Thru Grant (- $1,000,000) for Bee Branch Restoration Project due to trail grant inadvertently included twice in the budget. I concur with the recommendation and respectfully request Mayor and City Council approval. Michael C. Van Milligen MCVM:sv Attachment cc: Barry Lindahl, City Attorney Cindy Steinhauser, Assistant City Manager Teri Goodmann, Assistant City Manager Jennifer Larson, Budget Director 2 Masterpiece on the Mississippi April 22, 2013 TO: Michael C. Van Milligen, City Manager FROM: Jennifer Larson, Budget Director SUBJECT: Fiscal Year 2013 Second Budget Amendment Dubuque kital All- America City II 111! 2012 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 Iowa. This budget amendment includes items, which have been authorized by City Council since the first amendment to the Fiscal Year 2013 budget was adopted in September 2012 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 $581,563 is also included. The amendment totals $8,464,070 in increased appropriation authority and an increase in resources of $7,513,758. Additional revenues added in this amendment with offsetting appropriations are: • Bond Investment Earnings ($62,070) for various uncompleted projects, • Federal Aviation Administration Funds ($2,581,243) for Airport New Terminal Building, • General Obligation Borrowing paid from Airport Passenger Facility Charge ($1,989,722) for local match for Airport New Terminal Building, • Water Tower General Obligation Bond Refunding ($950,000), • Interfund Transfer from General Fund ($499,181) for Housing Section 8 Administrative Fee Reserve, • Edwin B. Lyons Trust ($450,000) for bequest to Park Division, • Community Development Block Grant ($91,466) for various programs due to uncommitted funds available, • Insurance Proceeds ($604,459) for Water & Resource Recovery Operations, and • Insurance Proceeds ($875,116) for Water & Resource Recovery Plant Upgrade. Reduced revenues reflected in this amendment with offsetting reductions in appropriations are: • Section 8 Administrative Fees (- $67,317) due to less Administrative Fee Income, • State Grant (- $100,000) for Bee Branch Restoration Project due to trail grant inadvertently included twice in the budget, and • Federal Pass Thru Grant (- $1,000,000) for Bee Branch Restoration Project due to trail grant inadvertently included twice in the budget. The action step is for City Council to adopt the attached resolution approving the FY 2013 second budget amendment. Attachments JML 31 -288 CITY BUDGET AMENDMENT AND CERTIFICATION RESOLUTION To the Auditor of DUBUQUE County, Iowa: The City Council of Dubuque in said County /Counties met on May 6, 2013 ,at the place and hour set in the notice, a copy of which accompanies this certificate and is certified as to publication. Upon taking up the proposed amendment, it was considered and taxpayers were heard for and against the amendment. The Council, after hearing all taxpayers wishing to be heard and considering the statements made by them, gave final consideration to the proposed amendment(s) to the budget and modifications proposed at the hearing, if any. thereupon, the following resolution was introduced. RESOLUTION No. 144 -13 A RESOLUTION AMENDING THE CURRENT BUDGET FOR THE FISCAL YEAR ENDING JUNE : 2013 (AS AMENDED LAST ON 09/17/2012 .) Be it Resolved by the Council of the City of Dubuque Section 1. Following notice published and the public hearing held, May 6, 2013 the current budget (as previously amended) is amended as set out herein and in the detail by fund type and activity that supports this resolution which was considered at that hearing: Passed this 6th (Day/ Signature City Clerk/Finance Officer day of 1 (Month/Year, 2 013 Signature Mayor Total Budget as certified or last amended Current Amendment Total Budget after Current Amendment Revenues & Other Financing Sources 2,0,300 207 _ 0 22,007,300 Taxes Levied on Property 1 Less: Uncollected Property Taxes -Levy Year 2 0 0 0 Net Current Property Taxes 3 22,007,300 0 22,007,300 Delinquent Property Taxes 4 0 0 0 TIF Revenues 5 10,289,639 0 10,289,639 Other City Taxes 6 14,922,012 0 14,922,012 Licenses & Permits 7 1,339,574 44,882 1,384,456 Use of Money and Property 8 12,365,425 76,773 12,442,198 Intergovernmental 9 91,084,091 1,658,315 92,742,406 Charges for Services 10 34,211,789 0 34,211,789 Special Assessments 11 1,843,814 0 1,843,814 Miscellaneous 12 8,549,468 2,176,254 10,725,722 Other Financing Sources 13 98,910,807 3,557,534 102,468,341 Total Revenues and Other Sources 14 295,523,919 7,513,758 303,037,677 Expenditures &Other her Financing 25,845,693 90,029 25,935,722 Public Safety 15 Public Works 16 12,447,988 0 12,447,988 Health and Social Services 17 1,136,053 39,497 1,175,550 Culture and Recreation 18 10,674,202 34,916 10,709,118 Community and Economic Development 19 13,064,372 72,186 13,136,558 General Government 20 7,586,919 0 7,586,919 Debt Service 21 6,994,075 0 6,994,075 Capital Projects 22 100,458,684 5,553,105 106,011,789 Total Government Activities Expenditures 23 178,207,986 5,789,733 183,997,719 Business Type / Enterprises 24 133,088,432 2,092,774 135,181,206 Total Gov Activities & Business Expenditures 25 311,296,418 7,882,507 319,178,925 Transfers Out 26 29,396,537 581,563 29,978,100 Total Expenditures/Transfers Out 27 340,692,955 8,464,070 349,157,025 Excess Revenues & Other Sources Over ( Under) Expenditures/Transfers Out Fiscal Year 28 - 45,169,036 - 950,312 - 46,119,348 :::: 29 ::::::::::::: �:::::::: ........... .......................... :::::ni €;i'i;i;;i'i'i €'ii;;i'i€ Beginning Fund Balance July 1 30 65,389,863 0 65,389,863 Ending Fund Balance June 30 31 20,220,827 - 950,312 19,270,515 Passed this 6th (Day/ Signature City Clerk/Finance Officer day of 1 (Month/Year, 2 013 Signature Mayor Fiscal Year 2013 Amendment #2 CITY COUNCIL Department Program Description FY 13 Expense Amount FY 13 Revenue Amount Fund Activity /CIP Account 4/9/13 Explanation GENERAL FUND Police Department 1C Police Department 1C Police Department 1C Police Department 1C Police Department 1C Police Department 1C Police Department 1C Police Department 1C Police Department 10 Police Department 10 Police Department 10 Police Department 10 Police Department 10 Police Department 10 Police Department 10 Police Department 10 Police Department 10 Police Department 10 Police Department 10 Police Department 10 Police Department 10 Police Department 10 Police Department 10 Police Department 10 Fire Department 1C Fire Department 1C Fire Department 1C Fire Department 1C Fire Department 1C Fire Department 1C Fire Department 1C Fire Department 1C Fire Department 1C Fire Department 1C Fire Department 1C Fire Department 1C Human Rights 30 Human Rights 30 Park Division 4C Park Division 4C Park Division 4C Park Division 4C Park Division 4C Park Division 4C Park Division 4C Park Division 4C Park Division 4C Park Division 4C Replace Police /CAD Software - Software Replace Police /CAD Software - Investment Earnings Replace Police /CAD Software - Bond Discount Replace Police /CAD Software - Bond Proceeds Police Historical Car Rehab - Private Participant Police Historical Car Rehab - Misc Revenue Police Historical Car Rehab - Reimbursements Police Historical Car Rehab - Vehicle Maint Police Bullet Proof Vest - OJP Grants Police Bullet Proof Vest - Body Armor Police Bullet Proof Vest - OJP Grants Police Bullet Proof Vest - Body Armor Police Meth Hot Spot Grant Police Meth Hot Spot Grant - Reimb OT Multijurisdictional Drug Law Enforcement - Federal Multijurisdictional Drug Law Enforcement - Reimb Multijurisdictional Drug Law- Pay to Other Agency Law Enforcement Block Grant - Federal Aid Law Enforcement Block Grant - Other Police Equip Police Safety Grant - Federal Aid Police Safety Grant- Reimb OT Occupant Protection Grant - Federal Grant Occupant Protection Grant - Reimb OT Police Patrol - Vehicle Sales Fire Ladder Truck, Pumper, Ambulance Replaceme Fire Ladder Truck, Pumper, Ambulance Replacement Protective Equipment Replacement Protective Equipment Replacement - Federal Grant Improvements to Station #4 Improvements to Station #4 - Investment Earnings Assistant Fire Fighter Grant - Video Conferencing Assistant Fire Fighter Grant - Video Conferencing Wireless Smoke Detectors - Federal Grant Wireless Smoke Detectors- Safety Equipment Detectors/Extinguishers - Safety Equipment Detectors /Extinguishers - Federal Grant Volunteer Generation Grant - Federal Pass Thru Volunteer Generation Grant - Education Westbrook - Bond Proceeds Westbrook - Bond Discount Westbrook- Investment Earnings Westbrook - Construction Not Building Dubuque Water Trail - Private Participant Dubuque Water Trail - Equipment Acquisition Urban Youth Corp Grant - Fed Pass Thru Urban Youth Corp Grant - Seasonal Employees Marshall School Play Unit - Bond Proceeds Marshall School Play Unit - Bond Discounts 2,118 7,208 5,785 903 935 25,767 37,320 1,409 17,910 507 (7,244) 138 36,200 (10,864) 46,953 233 1,000 18,460 101 123 101 132 101 1,863 101 250 100 6,790 100 168 100 100 5,785 100 100 903 100 100 935 100 100 25,077 100 690 100 100 37,320 100 100 1,409 100 100 17,910 100 100 10,556 100 101 507 101 101 (7,244) 101 101 138 101 (163,200) 100 163,200 100 36,200 101 101 101 (10,898) 101 46,953 100 100 212 101 11 101 10 101 101 1,000 100 100 17,203 100 100 444 101 30 101 1011167 1011167 1011167 1011167 1002280 1002280 1002280 1002280 10011702 10011702 10011703 10011703 10011319 10011319 10011320 10011320 10011320 10011753 10011753 10011771 10011771 10011772 10011772 10011700 1011016 1011016 1012286 1012286 1011444 1011555 1002356 1002356 1012453 1012453 1012345 1012345 10016500 10016500 1011582 1011582 1011582 1011582 1002277 1002277 1002343 1002343 1012363 1012363 71123 Adjust to Actual 43110 Bond Interest Earnings 54220 Bond Discount 54210 Additional Bond Proceeds 53102 Increased Fundraising for Project 53605 Increased Fundraising for Project 53620 Increased Fundraising for Project 62528 Fundraising Appropriation 44120 New Grant Appropriation 72218 New Grant Appropriation 44120 New Grant Appropriation 72213 New Grant Appropriation 45771 New Grant Appropriation 61051 New Grant Appropriation 44176 New Grant Appropriation 53201 New Grant Appropriation 62761 New Grant Appropriation 44125 New Grant Appropriation 72218 New Grant Appropriation 44125 New Grant Appropriation 61051 New Grant Appropriation 45771 New Grant Appropriation 61051 New Grant Appropriation 54107 Patrol Car Sales 71318 Adjust to Actual 43110 Bond Interest Earnings 72116 Adjust to Actual 44170 Reduce Grant to Actual 62716 Adjust to Actual 43110 Bond Interest Earnings 44405 Move to Correct Line Item 44170 Move to Correct Line Item 44170 New Grant Appropriation 72116 New Grant Appropriation 72116 Adjust to Actual 44170 Adjust to Actual 45771 New Grant Appropriation 62360 New Grant Appropriation 54210 Adjust to Actual 54220 Adjust to Actual 43110 Adjust to Actual 73211 Adjust to Actual 53102 Adjust to Actual 73411 Adjust to Actual 45771 Adjust to Actual 61030 Adjust to Actual 54210 Adjust to Actual 54220 Adjust to Actual Park Division Park Division Park Division Park Division Park Division Park Division Park Division Civic Center Civic Center Civic Center Public Works Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering 4C 4C 4C 4C 4C 4C 4C 4C 4C 4C 20 20 20 20 20 4C 2C 2C 2C Engineering 2C Engineering 2C Building Services 6C Building Services 6C Housing and Urban Develo SC Housing and Urban Develo5C Housing and Urban Develo50 Housing and Urban Develo50 Housing and Urban Develo50 Housing and Urban Develo50 Housing and Urban Develo50 Information Services 6C Information Services 6C Undistributed 90 TRANSIT FUND Transit Division Transit Division Transit Division Transit Division Transit Division Transit Division Transit Division GREATER DOWNTOWN Economic Development Economic Development Economic Development Economic Development Planning Planning Planning Planning Marshall School Play Unit - Equipment Creek Wood Park- Bond Proceeds Creek Wood Park- Bond Discount Creek Wood Park- Investment Earnings Creek Wood Park- Construction Not Building Edwin B. Lyons Trust - Private Participant Edwin B. Lyons Trust - Pay to Other Agency Ice Machine - Concession Equipment FF Entryway Renovation - Misc Equip Five Flags Lockers - Construction St. Signs & Markings - Sale of Signs and Markings Project Engineering - Subdivision Inspections Timber -Hyrst Phase III - Subdivision Inspections Project Engineering - Excavation Permits Project Engineering - Sidewalk Permit Library Renovation - Sale of Assets FEMA 2012 - Property Maintenance FEMA 2012 - FEMA FEMA 2012 - State Grants Flood Plain Buyout - Investment Earnings Flood Plain Buyout - Land Acquisition 18th Street Building - Investment Earnings 18th Street Building - Construction Neighborhood Stabilization - House Sale Neighborhood Stabilization - Construction Circles Program - Private Participant Circles Program - Private Participant Neighborhood Stabilization - Full -time employees Healthy Homes - Education Healthy Homes - Tablet Computer Replacements - Reimbursements Computer Replacements - Computers Undistributed Refunds TOTAL GENERAL FUND 8C Replace Fixed Route Buses - Consultant Services 8C Replace Fixed Route Buses - Salvage Sales 8C Intermodal Facility - Investment Earnings 8C Intermodal Facility - Consultant Services 8C Electronic Fare Boxes - Peripherals 8C Replace Fixed Route Buses - Consultant Services 80 Bus Operations - Motor Vehicle Maintenance TOTAL TRANSIT FUND TIF FUND 5C 5C 5C 5C 5C 5C 5C 5C Downtown Rehab Consultant Downtown Rehab Consultant Downtown Rehab Consultant Downtown Rehab Consultant Historic District Improvement - Historic District Improvement - Historic District Improvement - Historic District Improvement - 474 464 37 34 535 450,000 450,000 (10,112) (7,513) 24,570 34,338 209 132 74,602 12,727 1,847 250 2,100 13,777 101 1012363 101 1012375 101 1012375 101 1012375 101 1012375 100 1002493 100 1002493 100 1002304 101 1012283 100 1002452 16,907 100 10054435 13,912 100 10055400 19,321 100 10054419 11,351 100 10054400 298 100 10055400 (4,837) 100 1001141 100 1002073 3,976 100 1002073 30,362 100 1002073 209 100 1002419 100 1002419 132 102 1021975 102 1021975 74,602 100 1002180 100 1002180 12,727 100 10061922 100 10061922 100 10061130 100 10061135 100 10061135 13,777 101 1011069 101 1011069 52,241 100 10010100 - Investment Eamings - Bond Proceeds - Bond Discount - Loans Investment Earnings Bond Proceeds Bond Discount Construction TOTAL GDTIF FUND 782,674 889,990 23,050 600 6001224 23,050 600 6001224 9,253 600 6001614 9,253 600 6001614 (477,525) 600 6002321 477,525 600 6001224 (374,595) 600 60053400 (342,292) 32,303 579 119 51 706 (178) 13 150 (44) 698 698 2 240 2402157 240 2402157 240 2402157 240 2402157 240 2401010 240 2401010 240 2401010 240 2401010 73410 Adjust to Actual 54210 Adjust to Actual 54220 Adjust to Actual 43110 Adjust to Actual 73211 Adjust to Actual 53102 Bequest to City 62761 Bequest to City 72310 Shift to Five Flags Lockers 71550 Shift to Five Flags Lockers 73210 Shifted from other projects 54110 Adjust to Actua 42315 Adjust to Actua 42315 Adjust to Actua 42240 Adjust to Actua 42305 Adjust to Actua 54104 Adjust to Actua 62431 Adjust to Actua 44405 Adjust to Actua 45701 Adjust to Actua 43110 Adjust to Actua 73111 Adjust to Actua 43110 Adjust to Actua 62764 Adjust to Actua 53620 Adjust to Actua 73210 Adjust to Actua 53102 Adjust to Actua 62645 Adjust to Actua 61010 Adjust to Actua 62360 Adjust to Actua 71124 Adjust to Actua 53620 Adjust to Actua 71124 Adjust to Actua 53201 ICAP Refund 62716 Adjust to Actual 54109 Adjust to Actual 43110 Adjust to Actual 62716 Adjust to Actual 71120 Shift to Fixed Route Bus Replacements 62716 Shift to Fixed Route Bus Replacements 62521 Maintenance Over Budgeted Midtown /Nightrider 43110 Adjust to Actua 54210 Adjust to Actua 54220 Adjust to Actua 62764 Adjust to Actua 43110 Adjust to Actua 54210 Adjust to Actua 54220 Adjust to Actua 73210 Adjust to Actua DOWNTOWN LOAN POOL FUND Economic Development 5C Economic Development 5C Economic Development 5C Economic Development 5C Economic Development 5C ROAD USE TAX FUND Public Works 2C Public Works 2C Engineering 2C Engineering 2C Downtown Loan Pool - Loans Downtown Rehab Grant - Investment Earnings Downtown Rehab Grant - bond Proceeds Downtown Rehab Grant - bond Discount Downtown Rehab Grant - Grants TOTAL DOWNTOWN LOAN POOL FUND Asphalt Milling Program - Sale of Millings Asphalt Milling Program - Construction Fiber Optic Conduit - Investment Earnings Fiber Optic Conduit - Construction TOTAL ROAD USE TAX FUND COMMUNITY DEVELOPMENT BLOCK GRANT FUND Human Rights 30 Dubuque Dispute Resolution Center- Promotion Human Rights 30 Dubuque Dispute Resolution Center - Training Purchase of Services 30 Project Concern Child Care Referral - Pay to Other Economic Development 5C Economic Development 5C Housing and Urban Develo SC Housing and Urban Develo5C Housing and Urban Develo5C Housing and Urban Develo5C Housing and Urban Develo5C STATE RENTAL REHAB FUND Housing and Urban Develo50 Housing and Urban Develo50 SECTION 8 FUND Housing and Urban Develo50 Housing and Urban Develo50 Housing and Urban Develo50 Housing and Urban Develo50 Housing and Urban Develo50 Housing and Urban Develo50 Housing and Urban Develo50 Housing and Urban Develo50 Housing and Urban Develo50 Housing and Urban Develo50 Housing and Urban Develo50 ED Financial Assistance Program - Loans Commercial /Industrial Building Rehab Loans Rental Unit Rehab - Construction Rental Unit Rehab - Loans Residential Rehab - Loans Residential Rehab - Loans SW Upkeep Residential Rehab - Construction TOTAL CDBG FUND RRP Loan - Construction LHAP Loans TOTAL STATE RENTAL REHAB FUND Section 8 Voucher- HUD Payments Section 8 Voucher HAP - HUD Payments Section 8 Voucher- Administrative Fees Section 8 Voucher- NED Vouchers HAP Voucher HAP - NED Vouchers HAP Section 8 Voucher- Port Out Voucher HAP Voucher HAP - Port Out Voucher HAP Section 8 Voucher - Tenant Protect Assist Voucher HAP - Tenant Protect Assist Section 8 Voucher- HAP Payments Voucher HAP - HAP Payments TOTAL SECTION 8 FUND (72,200) 241 2411033 72 241 2411942 1,110 241 2411942 (268) 241 2411942 914 241 2411942 (71,286) 914 45,500 250 2501230 45,500 250 2501230 214 250 2501017 214 250 2501017 45,714 45,714 (696) (136) (6,624) 125,244 (117,948) (43,262) 43,262 (109,192) (5,000) 205,818 91,466 27,882 27,380 55,262 (132,000) 132,000 (3,000) 3,000 (3,120) 3,120 (3,643,428) 3,643,428 260 260 260 260 260 260 260 260 260 260 26016100 26016100 26079200 2601235 2601746 2601233 2601233 2601065 2601065 2601065 62764 Adjust to Actual 43110 Adjust to Actual 54210 Adjust to Actual 54220 Adjust to Actual 62765 Adjust to Actual 53620 Adjust to Actual 73211 Adjust to Actual 43110 Adjust to Actual 73211 Adjust to Actual 62140 CDBG Amendment 62360 CDBG Amendment 62761 CDBG Amendment 62764 CDBG Amendment 62764 CDBG Amendment 73210 CDBG Amendment 62764 CDBG Amendment 62764 CDBG Amendment 62766 CDBG Amendment 73210 CDBG Amendment 270 27061300 73210 Adjust to Actual 270 27061320 62764 Adjust to Actual (3,781,548) 280 3,781,548 280 (67,317) 280 280 280 280 280 280 280 280 280 (67,317) 28061600 28061601 28061600 28061600 28061601 28061600 28061601 28061600 28061600 28061600 28061601 44310 Shift to separate activity 44310 Shift to separate activity 44311 Reduced HUD Admin Fees 62608 Shift to separate activity 62608 Shift to separate activity 62609 Shift to separate activity 62609 Shift to separate activity 62689 Shift to separate activity 62689 Shift to separate activity 62694 Shift to separate activity 62694 Shift to separate activity LIBRARY GIFT TRUST FUND Library 40 Library 40 Library 40 Library Library Library Library Library Library Library 40 40 40 40 40 40 40 STREET CONSTRUCTION FUND Public Works 2C Public Works 2C Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering 2C 2C 2C 2C 2C 2C 2C 2C 2C 2C 2C 2C 2C SALES TAX FUND (20 %) Emergency Communicatior 1C Emergency Communicatior 1C Park Division Park Division Park Division Park Division Park Division Park Division Park Division Park Division Park Division Park Division Park Division Park Division Park Division Park Division Park Division Park Division Park Division Park Division Park Division Park Division Park Division 4C 4C 4C 4C 4C 4C 4C 4C 4C 4C 4C 4C 4C 4C 4C 4C 4C 4C 4C 4C 4C General Gift Trust - Sales Tax General Gift Trust - Miscellaneous General Gift Trust - Library Books General Gift Trust - Online Info Service General Gift Trust - Library Video Materials General Gift Trust - Speakers General Gift Trust - Software General Gift Trust - Shelving Robert Maher Trust- Shelving Robert Maher Trust- Promotion TOTAL GIFT TRUST FUND Street Sweeper Replacement - Insurance Claims Street Sweeper Replacement - Street Sweeper Brunskill Road Bridge - State Grants Brunskill Road Bridge - Fed Pass Thru Grant Southwest Arterial - Investment Earnings Southwest Arterial - Farmland Rent Southwest Arterial - Bond Discount Southwest Arterial - Bond Proceeds Southwest Arterial - Construction Central Ave Pavement - State Highway Central Ave Pavement - Construction Fiber Optic Conduit - Investment Earnings Fiber Optic Conduit - Construction Street Light Replacement - Equipment Street Light Replacement - Investment Earnings TOTAL STREET CONSTRUCTION FUND 407 250 7,649 2,865 479 12,635 1,800 831 6,500 1,500 34,916 32,500 22,827 30,135 152 96 295 295 295 295 295 295 295 295 295 295 32,500 300 300 (722,000) 300 722,000 300 1,257 300 14,703 300 478 300 6,389 300 300 30,135 300 300 152 300 300 300 96 300 Radio Equipment Tower Relocation - Radio Equip Radio Equipment Tower Relocation - Invest Earn Renovate Water System - Construction Renovate Water System - Investment Eamings Comiskey Park - Replace Door Comiskey Park- Replace Door- Investment Earnings Comiskey Park - Replace Door -GO Bond Proceeds Comiskey Park - Replace Door -Bond Discount Veterans Park 32nd St Storage - Construction Veterans Park 32nd St Storage - Bond Proceeds Veterans Park 32nd St Storage - Bond Discount Veterans Park 32nd St Storage - Bond Proceeds Comiskey New Entry - Bond Proceeds Comiskey New Entry - Discount Comiskey New Entry - Investment Earnings Comiskey New Entry - Construction Not Building Comiskey Amenities - Bond Proceeds Comiskey Amenities - Bond Discount Comiskey Amenities - Investment Eamings Comiskey Amenities - Construction Not Building Maint HQT Restroom - Bond Proceeds Maint HQT Restroom - Bond Discount Maint HQT Restroom - Investment Earnings 85,710 85,710 488 117 200 (65) 233 510 350 488 350 350 117 350 350 4 350 192 350 4 350 350 5 350 6 350 (76) 350 212 350 11 350 10 350 350 468 350 22 350 20 350 350 12 350 4 350 4 350 29536480 29536480 29536480 29536480 29536480 29536480 29536480 29536480 29536495 29536495 3001209 3001209 3001077 3001077 3001287 3001287 3001287 3001287 3001287 3002248 3002248 3001017 3001017 3001549 3001549 3502353 3502353 3501158 3501158 3501197 3501197 3501197 3501197 3501462 3501462 3501462 3501462 3501544 3501544 3501544 3501544 3501578 3501578 3501578 3501578 3502364 3502364 3502364 62210 Adjust to Actua 62240 Adjust to Actua 62651 Adjust to Actua 62655 Adjust to Actua 62659 Adjust to Actua 62734 Adjust to Actua 71123 Adjust to Actua 71225 Adjust to Actua 71225 Adjust to Actua 62140 Adjust to Actua 53610 Adjust to Actua 71321 Adjust to Actua 45701 Adjust to Actua 45771 Adjust to Actua 43110 Adjust to Actua 43242 Adjust to Actua 54220 Adjust to Actua 54210 Adjust to Actua 73211 Adjust to Actua 45725 Adjust to Actua 73211 Adjust to Actua 43110 Adjust to Actua 73211 Adjust to Actua 73410 Adjust to Actua 43110 Adjust to Actua 72410 Adjust to Actual 43110 Bond Interest Earnings 73211 Adjust to Actual 43110 Adjust to Actual 73210 Adjust to Actual 43110 Bond Interest Earnings 54210 Bond Proceeds 54220 Bond Discount 73210 Adjust to Actual 43110 Bond Interest Earnings 54220 Bond Discount 54220 Adjust to Actua 54210 Adjust to Actua 54220 Adjust to Actua 43110 Adjust to Actua 73211 Adjust to Actua 54210 Adjust to Actua 54220 Adjust to Actua 43110 Adjust to Actua 73211 Adjust to Actua 54210 Adjust to Actua 54220 Adjust to Actua 43110 Adjust to Actua Park Division 4C Park Division 4C Park Division 4C Park Division 4C Park Division 4C Park Division 4C Park Division 4C Civic Center 4C Civic Center 4C Civic Center 4C Conference Center 4C Conference Center 4C Recreation Division 4C Recreation Division 4C Library 4C Library 4C Library 4C Library 4C Library 4C Library 4C Library 4C Library 4C Library 4C Library 4C Library 4C Planning 5C Building Services 6C Building Services 6C Building Services 6C Building Services 6C Building Services 6C Building Services 6C GENERAL CONSTRUCTION FUND Engineering 2C Engineering 2C Engineering 2C Engineering 2C Park Division 4C Park Division 4C Park Division 4C Park Division 4C Park Division 4C Park Division 4C Park Division 4C Park Division 4C Recreation Division 4C Recreation Division 4C Recreation Division 4C Recreation Division 4C Recreation Division 4C Recreation Division 4C Recreation Division 4C Recreation Division 4C Maint HQT Restroom - Construction 20 Bunker Replc Roof Main - Investment Eam ings Bunker Replc Roof Main - Construction 129 Flora Playground Replc - Bond Proceeds Flora Playground Replc - Bond Discount Flora Playground Replc - Investment Earnings Flora Playground Replc - Equipment 233 Arena Roof- Investment Earnings Arena Roof- Construction 776 Theatre Exterior Lights - Construction (6,945) GRC Replace Outdoor Sign 125 GRC Replace Outdoor Sign - Investment Earnings Bunker Hill Windows - Investment Earnings Bunker Hill Windows - Construction 16 Library Exterior Improvements - Bond Proceeds Library Exterior Improvements - Bond Discount Library Exterior Improvements - Investment Eam ings Library Exterior Improvements - Const. Not Building 283 Library Renovation Repairs - Bond Proceeds Library Renovation Repairs - Bond Discount Library Renovation Repairs - Investment Eam ings Library Renovation Repairs - Construction 684 Repair & Replace Windows - Bond Proceeds Repair & Replace Windows - Bond Discount Repair & Replace Windows - Construction 229 Trails and Complete Streets - REAP grant City Hall Remodeling - Investment Earnings City Hall Remodeling - Construction 821 18th Street Building - Investment Earnings 18th Street Building - Construction 65 Smart Meters - Investment Earnings Smart Meters - Construction 108 350 129 350 350 212 350 11 350 10 350 350 776 350 350 350 350 125 350 16 350 350 263 350 10 350 10 350 350 590 350 49 350 45 350 350 224 350 5 350 350 (50,000) 350 821 350 350 65 350 350 108 350 350 TOTAL SALES TAX FUND (1,973) (45,028) 7th Street Improvements - Investment Earnings 7th Street Improvements - Construction 1 Way to 2Way Conversion - Investment Earnings 1 Way to 2Way Conversion - Construction Granger Creek Trail - Bond Proceeds Granger Creek Trail - Bond Discount Granger Creek Trail - Investment Earnings Granger Creek Trail - Construction Not Build McAleece Sidewalks - Bond Proceeds McAleece Sidewalks - Bond Discount McAleece Sidewalks - Investment Earnings McAleece Sidewalks - Construction Not Building MCIC Air Conditioning - Bond Proceeds MCIC Air Conditioning - Bond Discount MCIC Air Conditioning - Investment Earnings MCIC Air Conditioning - Construction MCIC Electrical Improvements - Bond Proceeds MCIC Electrical Improvements - Bond Discount MCIC Electrical Improvements - Investment Earnings MCIC Electrical Improvements - Construction 7,243 3,472 985 553 459 151 7,243 360 360 3,472 360 360 1,855 360 (926) 360 56 360 360 1,023 360 (500) 360 30 360 360 555 360 (134) 360 38 360 360 187 360 (51) 360 15 360 360 3502364 3502369 3502369 3502377 3502377 3502377 3502377 3502378 3502378 3502381 3502388 3502388 3501775 3501775 3501681 3501681 3501681 3501681 3502308 3502308 3502308 3502308 3502393 3502393 3502393 3502430 3501045 3501045 3501975 3501975 3502259 3502259 3602441 3602441 3602442 3602442 3602371 3602371 3602371 3602371 3602374 3602374 3602374 3602374 3602383 3602383 3602383 3602383 3602384 3602384 3602384 3602384 73210 Adjust to Actua 43110 Adjust to Actua 73210 Adjust to Actua 54210 Adjust to Actua 54220 Adjust to Actua 54220 Adjust to Actua 73410 Adjust to Actua 43110 Adjust to Actua 73210 Adjust to Actua 73210 Shift to Five Flags Lockers 73211 Adjust to Actua 43110 Adjust to Actua 43110 Adjust to Actua 73210 Adjust to Actua 54210 Adjust to Actua 54220 Adjust to Actua 43110 Adjust to Actua 73211 Adjust to Actua 54210 Adjust to Actua 54220 Adjust to Actua 43110 Adjust to Actua 73210 Adjust to Actua 54210 Adjust to Actua 54220 Adjust to Actua 73210 Adjust to Actua 45707 Adjust to Actua 43110 Adjust to Actua 73210 Adjust to Actua 43110 Adjust to Actua 73210 Adjust to Actua 43110 Adjust to Actua 73210 Adjust to Actua 43110 Adjust to Actua 73211 Adjust to Actua 43110 Adjust to Actua 73211 Adjust to Actua 54210 Adjust to Actua 54220 Adjust to Actua 54220 Adjust to Actua 73211 Adjust to Actua 54210 Adjust to Actua 54220 Adjust to Actua 43110 Adjust to Actua 73211 Adjust to Actua 54210 Adjust to Actua 54220 Adjust to Actua 43110 Adjust to Actua 73210 Adjust to Actua 54210 Adjust to Actua 54220 Adjust to Actua 43110 Adjust to Actua 73210 Adjust to Actua Recreation Division 4C MCIC Ice Decking - Bond Proceeds 404 360 3602385 54210 Adjust to Actua Recreation Division 4C MCIC Ice Decking - Bond Discount (90) 360 3602385 54220 Adjust to Actua Recreation Division 4C MCIC Ice Decking - Investment Earnings 26 360 3602385 43110 Adjust to Actua Recreation Division 4C MCIC Ice Decking - Construction 340 360 3602385 73210 Adjust to Actua Recreation Division 4C MCIC Generator - Construction 581 360 3602386 73210 Adjust to Actua Recreation Division 4C MCIC Generator- Bond Proceeds 697 360 3602386 54210 Adjust to Actua Recreation Division 4C MCIC Generator- Bond Discount (163) 360 3602386 54220 Adjust to Actua Recreation Division 4C MCIC Generator- Investment Earnings 47 360 3602386 43110 Adjust to Actua Recreation Division 4C MCIC Power Factor- Bond Proceeds 143 360 3602387 54210 Adjust to Actua Recreation Division 4C MCIC Power Factor- Bond Discount (18) 360 3602387 54220 Adjust to Actua Recreation Division 4C MCIC Power Factor- Investment Earnings 5 360 3602387 43110 Adjust to Actua Recreation Division 4C MCIC Power Factor- Construction 130 360 3602387 73210 Adjust to Actua Economic Development 5C South Siegert Farm - Investment Eamings 7,534 360 3602160 43110 Adjust to Actua Economic Development 5C South Siegert Farm - Reimbursements 504 360 3602160 53620 Adjust to Actua Economic Development 5C South Siegert Farm - Construction 8,038 360 3602160 73211 Adjust to Actua Economic Development 5C Millwork District Parking Improvements - Investment 3,827 360 3602250 43110 Adjust to Actua Economic Development 5C Millwork District Parking Improvements - Reimb 3,831 360 3602250 53620 Adjust to Actua Economic Development 5C Millwork District Parking Improvements - Constructi, 7,658 360 3602250 73211 Adjust to Actua Economic Development 5C Washington Neighborhood Incentives - Investment 144 360 3602436 43110 Adjust to Actua Economic Development 5C Washington Neighborhood Incentives - Bond Proceeds 2,220 360 3602436 54210 Adjust to Actua Economic Development 5C Washington Neighborhood Incentives - Bond Discount (536) 360 3602436 54220 Adjust to Actua Economic Development 5C Washington Neighborhood Incentives - Grants 1,828 360 3602436 62765 Adjust to Actua Economic Development 5C Future Land Acquisitions - Investment Earnings 43 360 3602437 43110 Adjust to Actua Economic Development 5C Future Land Acquisitions - Bond Proceeds 1,448 360 3602437 54210 Adjust to Actua Economic Development 5C Future Land Acquisitions - Bond Discount (719) 360 3602437 54220 Adjust to Actua Economic Development 5C Future Land Acquisitions - Consultant Services 772 360 3602437 62716 Adjust to Actua Economic Development 5C Washington Incentives - Investment Earnings 1,506 360 3602438 43110 Adjust to Actua Economic Development 5C Washington Incentives - Grants 1,506 360 3602438 62765 Adjust to Actua Economic Development 5C Downtown Housing Incentives - Investment Eamings 3,881 360 3602267 43110 Adjust to Actua Economic Development 5C Downtown Housing Incentives - Bond Proceeds 1,237 360 3602267 54210 Adjust to Actua Economic Development 5C Downtown Housing Incentives - Bond Discount (308) 360 3602267 54220 Adjust to Actua Economic Development 5C Downtown Housing Incentives - Grants 4,810 360 3602267 62765 Adjust to Actua Building Services 6C Multicultural Family Center - Investment Earnings 406 360 3601976 43110 Adjust to Actua Building Services 6C Multicultural Family Center - Bond Proceeds 13,351 360 3601976 54210 Adjust to Actua Building Services 6C Multicultural Family Center - Bond Discount (6,714) 360 3601976 54220 Adjust to Actua Building Services 6C Multicultural Family Center - Construction 7,043 360 3601976 73210 Adjust to Actua Building Services 6C ADA Assistance - Investment Earnings 13 360 3602424 43110 Adjust to Actua Building Services 6C ADA Assistance - Bond Proceeds 150 360 3602424 54210 Adjust to Actua Building Services 6C ADA Assistance - Bond Discount (44) 360 3602424 54220 Adjust to Actua Building Services 6C ADA Assistance - Construction 44 360 3602424 73211 Adjust to Actua Building Services 6C ADA Restroom - Investment Earnings 64 360 3602425 43110 Adjust to Actua Building Services 6C ADA Restroom - Bond Proceeds 2,043 360 3602425 54210 Adjust to Actua Building Services 6C ADA Restroom - Bond Discount (1,055) 360 3602425 54220 Adjust to Actua Building Services 6C ADA Restroom - construction 1,052 360 3602425 73210 Adjust to Actua Transit Division 8C Rail Platform - Investment Eamings 71 360 3602426 43110 Adjust to Actua Transit Division 8C Rail Platform - Bond Proceeds 2,376 360 3602426 54210 Adjust to Actua Transit Division 8C Rail Platform - Bond Discount (1,176) 360 3602426 54220 Adjust to Actua Transit Division 8C Rail Platform - Construction 1,271 360 3602426 73211 Adjust to Actua TOTAL GENERAL CONSTRUCTION FUND 47,936 48,011 AIRPORT CONSTRUCTION FUND Airport 2C Terminal Design and Building - FAA Funds 2,581,243 390 3902213 44105 Adjust to Actua Airport 2C Terminal Design and Building - Bond Proceeds 1,989,722 390 3902213 54210 Adjust to Actua Airport 2C Terminal Design and Building - Construction 4,570,965 390 3902213 73210 Adjust to Actua Airport 2C Terminal Sitework - Investment Earnings 19 390 3902009 43110 Adjust to Actua Airport 2C Terminal Sitework - Construction 19 390 3902009 73211 Adjust to Actua Airport 2C Onsite Water & Wastewater - Investment Earnings 44 390 3902011 43110 Adjust to Actua Airport 2C Onsite Water & Wastewater - Consulting Services 17,767 390 3902011 62712 Adjust to Actua Airport 2C Old Airline Terminal Assessment - Investment Earn 46 390 3902214 43110 Adjust to Actua Airport 2C Old Airline Terminal Assessment - Consulting 46 390 3902214 62712 Adjust to Actua Airport 2C Replace Runway Regulators - Investment Earnings 71 390 3902215 43110 Adjust to Actua Airport 2C Replace Runway Regulators - Construction 71 390 3902215 73211 Adjust to Actua Airport 2C New Terminal Roads & Apron - Investment Earnings 1,226 390 3902316 43110 Adjust to Actua Airport 2C New Terminal Roads & Apron - RISE Grant 33,863 390 3902316 45741 Adjust to Actua Airport 2C New Terminal Roads & Apron - Reimbursements 900 390 3902316 53620 Adjust to Actua Airport 2C New Terminal Roads & Apron - Construction 35,989 390 3902316 73211 Adjust to Actua Airport 2C HVAC Joint Use Building - Investment Earnings 81 390 3902403 43110 Adjust to Actua Airport 2C HVAC Joint Use Building - Construction 81 390 3902403 73210 Adjust to Actua Airport 2C ADF Containment - Investment Earnings 190 390 3902448 43110 Adjust to Actua Airport 2C ADF Containment - Consulting Services 94,949 390 3902448 62716 Adjust to Actua TOTAL AIRPORT CONSTRUCTION FUND 4,719,887 4,607,405 SANITARY SEWER OPERATING FUND W &RRC 80 W &RRC Plant Operations - Insurance Claims 604,459 610 61043400 53610 Insurance Claims W &RRC 80 W &RRC Plant Operations - Lift Station Maintenanc 604,459 610 61043400 62625 Insurance Claims TOTAL SANITARY SEWER OPERATING FUND 604,459 604,459 WATER OPERATING FUND Water 80 Water Bond Refunding - Bond Proceeds 950,000 640 64042100 54210 Bond Refunding Water 80 Water Bond Refunding - Principle Payment 950,000 640 64042100 74111 Bond Refunding TOTAL WATER OPERATING FUND 950,000 950,000 SANITARY SEWER CONSTRUCTION FUND Engineering 8C Nightengale Sanitary Sewer - Construction 489 710 7101301 73510 Adjust to Actua Engineering 8C Nightengale Sanitary Sewer- Investment Earnings 489 710 7101301 43110 Adjust to Actua Engineering 8C Sanitary Sewer Manhole Replace - Construction 5 710 7101335 73211 Adjust to Actua Engineering 8C Sanitary Sewer Manhole Replace - Investment Earnings 5 710 7101335 43110 Adjust to Actua Engineering 8C Southfork Interceptor Sewer - Construction 832 710 7101899 73211 Adjust to Actua Engineering 8C Southfork Interceptor Sewer- Investment Earnings 832 710 7101899 43110 Adjust to Actua Engineering 8C Green Alley Pilot Sanitary - Construction 200 710 7102044 73211 Adjust to Actua Engineering 8C Green Alley Pilot Sanitary - Investment Earnings 200 710 7102044 43110 Adjust to Actua Engineering 8C Millwork District Sanitary- Construction 462 710 7102129 73211 Adjust to Actua Engineering 8C Millwork District Sanitary- Investment Earnings 462 710 7102129 43110 Adjust to Actua Engineering 8C Brunswick Sanitary - Construction 163 710 7102232 73211 Adjust to Actua Engineering 8C Brunswick Sanitary - Investment Earnings 163 710 7102232 43110 Adjust to Actua Engineering 8C Hawthorne Sanitary- Construction 41 710 7102322 73211 Adjust to Actua Engineering 8C Hawthorne Sanitary- Investment Earnings 41 710 7102322 43110 Adjust to Actua Engineering 8C Knob Hill - Duggan Sanitary Sewer - Construction 232 710 7102323 73211 Adjust to Actua Engineering 8C Knob Hill - Duggan Sanitary Sewer - Investment 232 710 7102323 43110 Adjust to Actua Engineering 8C Fox Blackhawk Sanitary - Construction 191 710 7102406 73211 Adjust to Actua Engineering 8C Fox Blackhawk Sanitary - Investment Earnings 191 710 7102406 43110 Adjust to Actua Engineering 8C King Street Sanitary - Construction 102 710 7102407 73211 Adjust to Actua Engineering 8C King Street Sanitary - Investment Earnings 102 710 7102407 43110 Adjust to Actua Engineering 8C Granger Creek Sanitary - Construction 724 710 7102409 73211 Adjust to Actua Engineering 8C Granger Creek Sanitary - Investment Earnings 724 710 7102409 43110 Adjust to Actua Engineering Engineering Engineering Engineering Engineering Engineering W &RRC W &RRC W &RRC W &RRC W &RRC W &RRC 8C Green Alley SEP - Construction 8C Green Alley SEP - Investment Earnings 8C Cedar Lift Pump /Gen/Trailer- Construction 8C Cedar Lift Pump /Gen/Trailer- Investment Eamings 8C Relocation 30" Main Old Garage - Construction 8C Relocation 30" Main Old Garage - Investment Earnings 8C W &RRC Plan Upgrade - Insurance Proceeds 8C W &RRC Plan Upgrade - Construction 8C W &RRC Plan Upgrade - Construction 8C W &RRC Plan Upgrade - SRF GO Bond Proceeds 8C W &RRC Upgrade Mercury Spill - SRF GO Bond 8C W &RRC Upgrade Mercury Spill - Consultant TOTAL SANITARY SEWER CONST FUND 361 449 1,643 875,116 (280,447) 280,447 710 361 710 710 449 710 710 710 710 710 710 710 1,643 875,116 (280,447) 7102411 7102411 7102412 7102412 7102413 7102413 7101837 7101837 7101837 7101837 280,447 710 7101837A 710 7101837A 881,010 881,010 STORM WATER CONSTRUCTION FUND Engineering 8C Green Alley Pilot Project - Investment Eamings 67 Engineering 8C Green Alley Pilot Project - Construction Not Build 67 Engineering 8C Hesco Flood Control Units - Bond Proceeds (43,973) Engineering 8C Hesco Flood Control Units - Misc Equipment (43,973) Engineering 8C Bee Branch - State Grants (100,000) Engineering 8C Bee Branch - Federal Pass Thru Grant (1,000,000) Engineering 8C NPDES Post Construction - Federal Pass Thru Grant 24,500 Engineering 8C NPDES Post Construction - Consultant Services 24,500 Engineering 8C Millwork District Storm - Investment Earnings 179 Engineering 8C Millwork District Storm - Construction 179 Engineering 8C Iowa Street Storm - Investment Earnings 77 Engineering 8C Iowa Street Storm - Construction 77 Engineering 8C Kane Kaufrnan Storm - Investment Eamings 499 Engineering 8C Kane Kaufrnan Storm - Construction 499 Engineering 8C Peru Road Storm - Investment Earnings 40 Engineering 8C Peru Road Storm - Construction 40 Engineering 8C Lower Bee Branch Bridges - Investment Earnings 313 Engineering 8C Lower Bee Branch Bridges - Construction 313 Engineering 8C Windsor Storm - Investment Earnings 79 Engineering 8C Windsor Storm - Construction 79 Engineering 8C W 32nd Detention Basin - Investment Eamings 24 Engineering 8C W 32nd Detention Basin - Construction 24 Engineering 8C 7th St Storm Sewer- Investment Eamings 46 Engineering 8C 7th St Storm Sewer- Bond Proceeds 684 Engineering 8C 7th St Storm Sewer- Bond Discount 50 Engineering 8C 7th St Storm Sewer- Construction 780 Engineering 8C 14th St Storm Recon - Investment Earnings 400 Engineering 8C 14th St Storm Recon - Construction 400 TOTAL STORM WATER CONST FUND (17,015) (1,117,015) 720 720 720 720 720 720 720 720 720 720 720 720 720 720 720 720 720 720 720 720 720 720 720 720 720 720 720 720 7202044 7202044 7202335 7202335 7201654 7201654 7202065 7202065 7202131 7202131 7202132 7202132 7202133 7202133 7202134 7202134 7202281 7202281 7202414 7202414 7202416 7202416 7202417 7202417 7202417 7202417 7202418 7202418 73211 Adjust to Actua 43110 Adjust to Actua 73211 Adjust to Actua 43110 Adjust to Actua 73211 Adjust to Actua 43110 Adjust to Actua 53610 Adjust to Actua 73210 Adjust to Actua 73210 Shift to Mercury Spill 54230 Shift to Mercury Spill 54230 Shift from Plant Upgrade 62713 Shift from Plant Upgrade 43110 Adjust to Actua 73211 Adjust to Actua 54210 Adjust to Actua 71550 Adjust to Actua 45701 Adjust to Actua 45771 Adjust to Actua 45771 Adjust to Actua 62716 Adjust to Actua 43110 Adjust to Actua 73211 Adjust to Actua 43110 Adjust to Actua 73211 Adjust to Actua 43110 Adjust to Actua 73211 Adjust to Actua 43110 Adjust to Actua 73211 Adjust to Actua 43110 Adjust to Actua 73211 Adjust to Actua 43110 Adjust to Actua 73211 Adjust to Actua 43110 Adjust to Actua 73211 Adjust to Actua 43110 Adjust to Actua 54210 Adjust to Actua 54220 Adjust to Actua 73211 Adjust to Actua 43110 Adjust to Actua 73211 Adjust to Actua PARKING CONSTRUCTION FUND Parking Division 8C Parking Division 8C Parking Division 8C Parking Division 8C Parking Division Parking Division Parking Division Parking Division Parking Division Parking Division 8C 8C 8C 8C 8C 8C Port of Dubuque Parking Ramp - Private Participant Port of Dubuque Parking Ramp - Construction Fire Headquarters DT Ramp - Investment Earnings Fire Headquarters DT Ramp - Construction Fire Headquarters DT Ramp - Investment Earnings Fire Headquarters DT Ramp - Construction Locust Ramp Video Cameras - Investment Earnings Locust Ramp Video Cameras - Video Equipment Locust Ramp Video Cameras - Investment Earnings Locust Ramp Video Cameras - Video Equipment TOTAL PARKING CONSTRUCTION FUND WATER CONSTRUCTION FUND Water 8C EP Office /Lab Pump Room - Investment Earnings Water 8C EP Office /Lab Pump Room - Construction Water Water Water Water Water Water Water Water Water Water Water Water Water Water Water Water Water Water Water Water Water Water Water Water Water Water Water Water Water Water Water Water Water Water Water Water Water Water Water 1,199 2,380 367 7 203 1,199 730 730 2,380 730 730 367 730 730 7 730 730 203 730 730 4,156 4,156 107 8C Water Main Extensions - Bond Proceeds 8C Water Main Extensions - Bond Discount 8C Water Main Extensions - Investment Earnings 8C Water Main Extensions - Construction Not Build 50,260 8C Water Main Replacements - Bond Proceeds 8C Water Main Replacements - Bond Discount 8C Water Main Replacements - Investment Earnings 8C Water Main Replacements - Construction 3,993 8C Fire Hydrant Replacements - Investment Earnings 8C Fire Hydrant Replacements - Equipment 82 8C Main Extension Annexation - Construction (50,000) 8C Main Extension Annexation - Bond Proceeds 8C Main Extension Annexation - Investment Earnings 8C Main Extension Annexation - Construction 233 8C Bunker Hill Pump Station - Construction 1,138 8C Bunker Hill Pump Station - Investment Earnings 8C Roosevelt Road Main Extension - Construction 64 8C Roosevelt Road Main Extension - Investment Eamings 8C Green Alley Pilot Project - Bond Proceeds 8C Green Alley Pilot Project - Bond Discount 8C Green Alley Pilot Project - Investment Eamings 8C Green Alley Pilot Project - Construction Not Build 1,084 8C Millwork District Water Main - Construction 175 8C Millwork District Water Main - Investment Earnings 8C Drinking Water Study - Investment Earnings 8C Drinking Water Study - Consulting Engineers 45 8C Water Circ Sys Potable - Construction 47 8C Water Circ Sys Potable - Investment Eamings 8C Asbury Tank Painting - Construction 1,404 8C Asbury Tank Painting - Investment Eamings 8C Electric Usage Integrate - Investment Earnings 8C Electric Usage Integrate - Consultant Services 160 8C Ramp Utility Relocation - Construction 270 8C Ramp Utility Relocation - Investment Eamings 8C Well Field Electrical Upgrades - Construction 343 8C Well Field Electrical Upgrades - Investment Eamings 8C #7 Well House Structure Upgrade - Construction 24 8C #7 Well House Structure Upgrade - Investment Earnings 8C Water Ext - Airport - Bond Proceeds 107 740 740 50,232 740 19 740 9 740 740 2,244 740 158 740 1,591 740 740 82 740 740 740 (50,000) 740 233 740 740 740 1,138 740 740 64 740 984 740 62 740 38 740 740 740 175 740 45 740 740 740 47 740 740 1,404 740 160 740 740 740 270 740 740 343 740 740 24 740 1,277 740 7302162 7302162 7302179 7302179 7302179 7302179 7302427 7302427 7302427 7302427 7401397 7401397 7401399 7401399 7401399 7401399 7401405 7401405 7401405 7401405 7401409 7401409 7401411 7401411 7401411 7401411 7401422 7401422 7401672 7401672 7402044 7402044 7402044 7402044 7402145 7402145 7402147 7402147 7402202 7402202 7402204 7402204 7402210 7402210 7402261 7402261 7402310 7402310 7402313 7402313 7402395 53102 Adjust to Actua 73211 Adjust to Actua 43110 Adjust to Actua 73211 Adjust to Actua 43110 Adjust to Actua 73211 Adjust to Actua 43110 Adjust to Actua 72416 Adjust to Actua 43110 Adjust to Actua 72416 Adjust to Actua 43110 Adjust to Actua 73210 Adjust to Actua 54210 Adjust to Actua 54220 Adjust to Actua 43110 Adjust to Actua 73211 Adjust to Actua 54210 Adjust to Actua 54220 Adjust to Actua 43110 Adjust to Actua 73211 Adjust to Actua 43110 Adjust to Actua 73410 Adjust to Actua 73211 Shift to Water Main Extensions 54210 Shift to Water Main Extensions 43110 Adjust to Actua 73211 Adjust to Actua 73211 Adjust to Actua 43110 Adjust to Actua 73211 Adjust to Actua 43110 Adjust to Actua 54210 Adjust to Actua 54220 Adjust to Actua 43110 Adjust to Actua 73211 Adjust to Actua 73211 Adjust to Actua 43110 Adjust to Actua 43110 Adjust to Actua 62712 Adjust to Actua 73510 Adjust to Actua 43110 Adjust to Actua 73211 Adjust to Actua 43110 Adjust to Actua 43110 Adjust to Actua 62716 Adjust to Actua 73211 Adjust to Actua 43110 Adjust to Actua 73211 Adjust to Actua 43110 Adjust to Actua 73211 Adjust to Actua 43110 Adjust to Actua 54210 Adjust to Actua Water Water Water Water Water Water Water Water Water Water Water Water TRANSFERS 8C Water Ext - Airport - Bond Discount 8C Water Ext - Airport - Construction 8C North Softening Basin - Construction 8C North Softening Basin - Investment Earnings 8C McAleece Water Improvements - Construction 8C McAleece Water Improvements - Investment Earnings 8C EP - Treatment - Construction 8C EP - Treatment - Construction - Investment earnings 8C Water Usage and System Audit - Consulting 8C Water Usage and System Audit - Investment Earnings 8C N Plant Motor Upgrade - Construction 8C N Plant Motor Upgrade - Investment Earnings TOTAL WATER CONSTRUCTION FUND Civic Center Transi Civic Center Transi Civic Center Trans2 Civic Center Trans2 Transit Division Trans3 Transit Division Trans3 Housing and Urban Develo Trans4 Housing and Urban Develo Trans4 Housing and Urban DeveloTransS Housing and Urban DeveloTransS GRAND TOTAL AMENDMENT #2 Transfer from Sales Tax Fund to General Fund Transfer from Sales Tax Fund to General Fund Transfer from DRA Gaming Fund to General Fund Transfer from DRA Gaming Fund to General Fund Transfer from Transit Fund to Section 8 Fund Transfer from Transit Fund to Section 8 Fund Transfer from General Fund to Section 8 Fund Transfer from General Fund to Section 8 Fund Transfer from General Fund to Section 8 Fund Transfer from General Fund to Section 8 Fund TOTAL TRANSFERS GRAND TOTAL WITH TRANSFERS (240) 740 7402395 54220 Adjust to Actua 1,037 740 7402395 73211 Adjust to Actua 242 740 7402396 73211 Adjust to Actua 242 740 7402396 43110 Adjust to Actua 183 740 7402397 73211 Adjust to Actua 183 740 7402397 43110 Adjust to Actua 171 740 7402398 73210 Adjust to Actua 171 740 7402398 43110 Adjust to Actua 101 740 7402399 62712 Adjust to Actua 101 740 7402399 43110 Adjust to Actua 22 740 7402401 73211 Adjust to Actua 22 740 7402401 43110 Adjust to Actua 11,185 11,185 7,882,507 6,932,195 Transfer Out Transfer In 6,945 350 35010350 91100 Transfer Funds 6,945 100 1002452 59350 Transfer Funds 7,513 101 10110101 91100 Transfer Funds 7,513 100 1002452 59101 Transfer Funds 374,595 600 60010600 91280 Transfer Funds 374,595 280 28010280 59600 Transfer Funds 67,924 100 10010100 91280 Transfer Funds 67,924 280 28010280 59100 Transfer Funds 124,586 100 10010100 91280 Transfer Funds 124,586 280 28010280 59100 Transfer Funds 581,563 581,563 8,464,070 7,513,758 10 NOTICE OF PUBLIC HEARING AMENDMENT OF CURRENT CITY BUDGET Form 653.G1 The City Council of Dubuque in DUBUQUE County, Iowa 2013 will meet at City Council Chambers at the Historic at 6,30 pim. on May 6, 2013 Federal Building ending tune 30, (hour) (Date) ,for the purpose of amending the current budget of the city for the fiscal year by changing estimates of revenue and expenditure appropriations in the following given. Additional detail is available at the city clerk's o lice showing revenues and by activity. (year) programs for the reasons and expenditures by fund type Total Budget as certified or last amended Current Amendment Total Budget after Current Amendment Revenues 8( Other Financing Sources 22,007,300 0 22,007,300 Taxes Levied on Property 1 Less: Uncollected property Taxes -Levy Year 2 0 0 0 Net Current Property Taxes 3 Delinquent Property Taxes 4 22,007,300 0 0 0 22,007,300 0 TIF Revenues 5 10,289,639 0 10,289,639 Other ray Taxes 6 14,922,012 0 14;922,012 Licenses &' Permits 7 1,339,574 44,882 1,384,456 Use of Money and Property 8 Intergovernmental 9 12,365,425 91,084,091 76,773 1,658,3'15 12,442,198 92,742,406 Charges for Services 10 Special Assessments 11 34,211,789 1,843,814 0 0 34,211,789 1,843,814 Miscellaneous 12 8,549,468 2,176,254 10,725 722 Other Financing Sources 1:3 98,910,807 3,557,534 102,468,341 Total Revenues and Other Sources 14 295,523,919 7,513,758 303,037,677 Expenditures & Other Financing Uses ',25,845,603 90,029 25,935,722 Public Safety 15 Public Works 16 12,447,988 0 12,447,986 Health and Social Services 17 Culture and Recreation 18 1,136,053 10,674,202 39,497 34,916 1,175,550 10,709,118 Community and Economic Development 19 13,064,372 72,186 13,136,558 General Government 20 7,586,919 0 7';586,919 Debt Service 21 6,994,075 0 6,994,075 Capital Projects 22 100,458,684 5,553,1'05 1064011,789 Total Government Activities Expenditures 23 178,207,986 5,789,733 183,997 719 Business Type I Enterprises 24 Total Gov Activities & Business Expenditures 25 133,088,432 311,296,418 2,092,774 7,882,507 135;181,206 319,178,925 Transfers Out 26 29,396,537 .__ 581,563 ry 29,978,100' Total Expenditures lTrensfers Out 27 340,692,955 8,464,070 349,157,025 Excess Revenues & Other Sources Over (Under) Expenditures/Transfers Out for Fiscal 28 - 45,169,036 950,312 46,119,348 29 Beginning Fund Balance July 1 30 Ending Fund Balance June 30 31 65,389,863 20,220,827 0 950,312 65,389,863 19,270,515 Explanation increases decreases Irt'. revenue :estimate: pprop lions, 0 available ca This amendment adds additional revenue from grants received, private funding, bond proceeds, and the appropriation to pend the monies. Adjustments to reflect the amended Community Devetoprnent Annual 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, Any increase in expenditures set out above will be met from the increased not - property tax revenues and cash balances not budgeted or considered in this current budget. This welt provide for a balanced budget, -It 4/19 Kevin 5, Firnstahl, City Clerk! STATE OF IOWA {SS: DUBUQUE COUNTY CERTIFICATION OF PUBLICATION I, Suzanne Pike, a Billing Clerk for Woodward Communications, Inc., an Iowa corporation, publisher of the Telegraph Herald,a newspaper of general circulation published in the City of Dubuque, County of Dubuque and State of Iowa; hereby certify that the attached notice was published in said newspaper on the following dates: April 19, 2013, and for which the charge is $158.90. Subscribed to before me, a Notary Public in and for Dubuque County, Iowa, this day of # � ,20 /3 . Notary Public in and for Dubuque County, Iowa. i.AR'(K.VVESf , C it l:3510n , J '`;