Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Council Packet - 3/25/2021
THE CITY COUNCIL OF THE CITY OF WATERLOO, IOWA, SPECIAL MEETING TO BE HELD AT Schoitz Room at Waterloo Center for the Arts. Zoom information for the meeting is also available at https:Hcityofwaterlooiowa.com/register. Thursday, March 25, 2021 5:30 PM CITY OF WATERLOO GOALS 1. Support the creation of new,livable wage jobs through a balanced economic development approach of assisting existing businesses,fostering start-ups,attracting new employers and cultivating an adequate workforce. 2. Implement a Community Policing strategy that creates a safe environment in Waterloo. 3. Reduce the City's property tax levies through a responsible balance of cost reduction in City operations and increases in taxable property valuations to ensure that Waterloo is a competitive,affordable,and livable city. 4. Enhance the image of Waterloo and the City to residents and businesses inside and outside of the community. ELECTRONIC CITY COUNCIL MEETINGS At this time,all meetings of the Waterloo City Council will be electronic because meeting in person is impossible or impractical due to the spread of COVID-19. Iowa Code Section 21.8,Governor Reynolds'Disaster Emergency Proclamations allow cities to hold electronic meetings and Mayor Hart has issued Civil Emergency Proclamations calling for electronic meetings. Electronic meetings will be held utilizing Zoom video conferencing. Zoom meeting information is available on the city website at httpsl/cityofwaterlooiowa.com/register. You may also call the City Clerk's Office at 319-291-4323 or email clerks@waterloo- ia.org to receive the meeting information. Individuals speaking during the electronic regular session or planning session meetings are required to follow the rules for public participation. GENERAL RULES FOR PUBLIC PARTICIPATION SPECIAL SESSION AGENDA A Iowa Code Chapter 21 gives the public the right to attend council meetings,but it does not require cities to allow public participation except during public hearings.The public is required to follow the rules listed in this article when speaking during any meeting of the city council. R At the presiding officer's discretion,individuals may address the presiding officer by stepping to the podium,and after recognition by the presiding officer,shall state their name,address and group affiliation,if appropriate,and speak clearly into the microphone. C. Comments shall be germane and refrain from personal,impertinent,or slanderous remarks. D. Cell phones and electronic devices shall be set to silent prior to the start of the meeting. Roll Call. Agenda, as proposed or amended. Presentation on the FYE2022 budget. A. Motion to approve the following: PUBLIC HEARINGS 1. Public Hearing to adopt the FYE 2022 budget. Motion to receive and file proof of publication of notice of public hearing. Page 1 of 28 HOLD HEARING -No comments on file. Motion to close hearing and receive and file comments. Resolution approving the FYE 2022 budget with a total tax levy rate of$18.63188 and property tax askings in the amount of$44,640,549. Submitted By: Michelle Weidner, Chief Financial Officer ADJOURNMENT Motion to adjourn. Kelley Felchle City Clerk Page 2 of 28 CITY OF WATERLOO Council Communication Presentation on the FYE2022 budget. City Council Meeting: 3/25/2021 Prepared: REVIEWERS: Department Reviewer Action Date Finance Felchle, Kelley Approved 3/24/2021 - 6:17 PM SUBJECT: Presentation on the FYE2022 budget. Submitted by: Submitted By: Michelle Weidner, Chief Financial Officer Page 3 of 28 CITY OF WATERLOO Council Communication Public Hearing to adopt the FYE 2022 budget. City Council Meeting: 3/25/2021 Prepared: 3/24/2021 REVIEWERS: Department Reviewer Action Date Finance Felchle, Kelley Approved 3/24/2021 - 6:15 PM Clerk Office Felchle, Kelley Approved 3/24/2021 - 6:15 PM ATTACHMENTS: Description Type ❑ FY22 Budget Proposed Revisions Print Copy Backup Material ❑ Budget Fact Sheet FY22 Proposed Revisions Backup Material ❑ Potential Hiring Delays and Furloughs FYE22 Backup Material ❑ Breakout of Staff Budget Requests with Changes Backup Material 3.24.21 ❑ Public Comments Backup Material Motion to receive and file proof of publication of notice of public hearing. HOLD HEARING -No comments on file. SUBJECT: Motion to close hearing and receive and file comments. Resolution approving the FYE 2022 budget with a total tax levy rate of $18.63188 and property tax askings in the amount of$44,640.549. Submitted by: Submitted By: Michelle Weidner, Chief Financial Officer Summary Statement: The annual budget is required to be adopted and certified with Black Hawk County and the State of Iowa by March 31, 2021. According to the State Department of Management, if the budget isn't certified by March 31, 2021, the state would set the city's property taxes at Alternative: the same amount of property tax dollars as were certified for the current year ($42,422,199 plus utility excise taxes of$1,445,550). There would likely be an audit finding regarding noncompliance with state law regarding budget deadlines also. Page 4 of 28 FYE2021 CERTIFIED AND FYE2022 PROPOSED BUDGET COMPARISON - CITY OF WATERLOO Proposed Budget GENE RAL FUND 3/24/21 A B E F G H I J K L M O 1 FY 2021 BUDGET FY 2022 BUDGET % FY 2021 BUDGET FY 2022 BUDGET FY2021TAXES FY2022TAXES LEVIED SUBTOTALS 2 BUDGET CODE ACTIVITIES-GENERAL FUND CERTIFIED PROPOSED CHANGE CERTIFIED PROPOSED LEVIED $ 18.63188 $AMOUNT % PORTION OF 3 EXPENSE EXPENSE REVENUE REVENUE $ 18.44026 1.04% CHANGE CHANGE TAX LEVY 4 5 PUBLIC SAFETY 6 010-11-1100 POLICE OPERATIONS 14,705,497 16,059,416 9.219/6 720,876 1,128,642 13,984,621 14,930,774 946,153 6.779/6 7 010-11-1105 POLICE COMPUTER SERVICE 242,968 259,968 7.00% 0 0 242,968 259,968 17,000 7.009/6 8 010-11-1200 PUBLIC SAFETY ADMINISTRATION 171,035 0 -100.00% 0 0 171,035 0 (171,035) -100.00% 9 200-11-1140 POLICE PENSION 2,515,650 2,650,353 5.35% 0 0 2,515,650 2,650,353 134,703 5.35% $ 7.59918 10 010-11-1150 POLICE GRANTS 615,526 744,735 20.99 615,526 744,735 0 IV 0 0 0.00% 11 010-11-1150 POLICE GRANTS(DISCR H/M) 0 0 0.00% 0 0 0 0 0 0.00% 12 010-11-1160 LAW ENFORCEMENT PROGRAMS 895,000 963,483 7.65% 895,000 963,483 0 0 0 0.00% 13 010-11-1165 POLICE TOBACCO ENFORCEMENT 5,500 5,§QQ 0. 5,500 ,500 0 0 0 0.00° 14 010-01-1700 B.H.COUNTY EMA/SIREN MAINTENANCE 96,012 96,187 0.18% 0 0 96,012 96,187 175 0.18% $ 0.04097 15 010-12-1400 FIRE RESCUE 9,972,101 10,529,861 5.59% 61,850 62,850 9,910,251 10,467,011 556,760 5.629/6 16 010-12-1402 FIRE RESCUE CHARGEBACKS 34,169 36,107 5.679/6 34,169 36,107 0 0 0 0.00% 17 010-18-1405 FIRE-GARAGE PARTS&SERVICE 197,672 183,764 -7.04% 0 0 197,672 183,764 (13,908) -7.04% 18 200-12-1420 FIRE PENSION 1,750,706 1,903,964 8.75% 0 0 1,750,706 1,903,964 153,258 8.75% 19 010-12-1412 FIRE RESTRICTED PROGRAMS 305 20 010-12-1415 HAZARDS REGIONAL RESPONSE TRG FROG 181,357 187,873 3.59% 166,50073,608,500 500 14,857 21,373 6,516 43.86% 211010-12-1425 FIRE SAFER GRANT 284,192 92 0.004 22 010-12-1410 FIRE AMBULANCE SERVICE 2,363,384 3,230,171 36.68% 2,258,000 105,384 (378,329) (483,713) -459.00% 23 200-12-1410 FIRE AMBULANCE SERVICE PENSION 377,032 398,980 377,032 398,980 21,948 5.82% 24 010-18-1411 AMBULANCE-GARAGE PARTS&SERVICE 38,500 38,500 0.00% 00 38,500 38,500 0 0.00% $ 5.38182 25 010-22-5100 BUILDING INSPECTION 1,237,379 1,188,997 -3.91% 1,526,713 1,518,965 (289,334) (329,968) (40,634) 14.04% $ (0.14055) 26 010-22-5102 BLDG INSPECTION CHARGEBACKS(OUT) 112,296 120,044 6.909/6 112,296 120,044 0 0 0 0.00% 27 010-22-5102 BLDG INSPECTION CHARGEBACKS(IN) 11,768 12,001 1.989/6 11,768 12,001 0 0 0 0.00% 28 29 TOTAL-PUBLIC SAFETY 35,548,857 38,919,401 9.48% 6,433,503 8,676,824 29,115,354 30,242,577 1,127,223 3.87% $ 12.88142 30 Less Fund 200 (4,643,388) (4,953,297) - - - 31 TOTAL-GENERAL FUND 30,905,469 33,966,104 32 PUBLIC WORKS 33 010-07-7650 SIDEWALKS 215,000 215,000 0.00% 215,000 215,000 0 0 0 0.00% $ - 34 010-17-7910 PARKING FACILITY MAINTENANCE 18,960 9,300 -50.95% 0 0 18,960 9,300 (9,660) -50.95% $ 0.00396 35 010-22-7930 PARKING OPERATIONS 527,500 515,000 -2.37% 527,500 515,000 0 0 0 0.00% $ - 36 010-29-7700 AIRPORT OPERATIONS 1,148,707 1,132,997 -1.37% 1,148,707 1,132,997 0 0 0 0.00% $ - 37 010-01-7800 MET TRANSIT AUTHORITY 1,462,588 1,462,588 0.00% 0 0 1,462,588 1,462,588 0 0.00% $ 0.62297 38 010-18-7950 CENTRAL GARAGE 511,285 484,844 -5.17% 85,300 85,300 425,985 399,544 (26,441) -6.21% 39 010-18-7952 CENTRAL GARAGE-CHARGEBACKS 530,000 530,000 0.00% 530,000 530,000 0 0 0 0.00% 40 010-18-7955 MOTOR POOL-PASS THROUGH ACCOUNT 2,048,468 2,048,468 0.00% 2,069,559 2,069,559 (21,091) (21,091) 0 0.00% $ 0.16120 41 42 TOTAL-PUBLIC WORKS 6,462,508 6,398,197 -1.00% 4,576,066 4,547,856 1,886,442 1,850,341 (36,101) -1.91% $ 0.78813 43 - - - 44 HEALTH&SOCIAL SERVICES 45 010-27-2500 HUMAN RIGHTS COMMISSION 278,760 294,554 5.67% 0 0 278,760 294,554 15,794 5.67% $ 0.12546 46 010-27-2505 EEOC CONTRACT 45,000 0.00% 0 0.00% 47 010-27-2510 FAIR HOUSING ENFORCEMENT 0 0.00% 0 0.00% 48 010-27-2510 FAIR HOUSING PARTNERSHIP GRANT 0 0.00% 0 0.00% 49 010-27-2520 HUMAN RIGHTS PROJECTS 0 0.00% 0 0.00°/ 50 51 TOTAL-HEALTH&SOCIAL SERVICES 323,760 339,554 4.88%1 45,000 1 45,000 278,760 294,554 15,794 1 5.67%1 $ 0.12546 K:\USERS\MICHELLE-W\Budget FYE22\FY22 BUDGET—Proposed Revisions Print Copy.xlsx 1 Page 5 of 28 3/25/2021 3:51 PM FYE2021 CERTIFIED AND FYE2022 PROPOSED BUDGET COMPARISON - CITY OF WATERLOO Proposed Budget GENE RAL FUND 3/24/21 A B E F G H I J K L M O 1 FY 2021 BUDGET FY 2022 BUDGET % FY 2021 BUDGET FY 2022 BUDGET FY2021TAXES FY2022TAXES LEVIED SUBTOTALS 2 BUDGET CODE ACTIVITIES-GENERAL FUND CERTIFIED PROPOSED CHANGE CERTIFIED PROPOSED LEVIED $ 18.63188 $AMOUNT % PORTION OF 3 EXPENSE EXPENSE REVENUE REVENUE $ 18.44026 1.04% CHANGE CHANGE TAX LEVY 4 52 CULTURE&RECREATION 53 010-01-4405 CEMETERY OPERATIONAL SUBSIDY 50,000 60,000 20.00% 0 0 50,000 60,000 10,000 20.00% $ 0.02556 54 010-01-4220 GROUT MUSEUM 652,746 655,956 0.499/. 22,571 22,850 630,175 633,106 2,931 0.479/6 $ 0.26966 55 010-26-4208 YOUTH PAVILION 415,106 409,935 -1.259/. 105,600 90,000 309,506 319,935 10,429 3.379/6 56 010-26-4250 CENTER FOR THE ARTS 811,271 826,942 1.93% 160,000 160,000 651,271 666,942 15,671 2.419/6 57 010-26-4251 RIVERLOOP EVENT FACILITIES 15,958 15,958 0.00% 17,500 17,500 (1,542) (1,542) 00.00% $ 0.41969 58 010-26-4265 C&A GRANTS&PROJECTS 94,000 94,000 0.00% 94,000 94,000 0 0.00% 60 010-26-4265 CENTER FOR THE ARTS(DISCR H/M) 19,191 19,581 2.03% 19,191 19,581 0 0 0.00% 61 010-33-3100 LIBRARY SERVICES 1,894,3771 1,938,9551 2.35%1 18,5601 8,0001 1,875,817 1,930,9551 55,1381 2.94% $ 0.82246 62 010-33-3110 LIBRARY-ENRICH IOWA GRANT 18,417 19,184 4.16% 18,417 19,184 0 0 0.00% 63 010-33-3150 LIBRARY OPEN ACCESS PLUS 3,000 4,000 33.33% 3,000 4,000 0 0 0 0.00% 64 010-33-3160 LIBRARY GRANTS 51,865 53,065 2.31% 51,865 53,065 0 0 0 0.00% 65 010-33-3180 LIBRARY GIFT&MEMORIAL 5,000 5,000 0.00% 5,000 5,000 0 0 0 0.00% 66 010-33-3190 IOWA LIBRARY SERVICE 4,120 4,120 0.00% 4,120 4,120 0 0 0 0.00% 67 010-33-3200 COUNTY LIBRARY 69,633 70,940 1.88% _ 69,633 70,940 0 0 0 0.00% 68 010-33-3210 LIBRARY OPEN ACCESS 10,000 10,000 0.00% 10,000 10,000 0 i 0 0 0.00% 69 010-37-4100 LEISURE SERVICES-PARKS 1,767,705 1,867,797 5.66% 39,737 39,737 1,727,968 1,828,060 100,092 5.79% 70 010-37-4102 LEISURE SERVICES-PARKS-CHARGEBACK 950,000 950,000 0.00% 950,000 950,000 0 0 0 0.00% 711010-37-4105 LEISURE SERVICES PROJECTS 73 010-37-4110 LEISURE SERVICES-DOWNTOWNMTCE 405,225 422,728 4.32% 0 0 405,225 422,728 17,503 4.32% 74 010-374120 GOLF COURSES 1,196,006 1,178,418 1.47% 838,782 837,779 357,224 340,639 (16,585) 4.64% 75 010-37-4125 GOLF COURSE IMPROVEMENTS-SURCHARGI 8,504 8,188 -3.72% 8,504 8,188 0 0.00° 76 010-37-4180 SPORTSPLEX 1.437, 1,437,500 0.00° 1,437,500 1,4 7 0 0.0 ° 77 010-37-4200 SPORTS&YOUTH SERVICES 638,187 653,246 2.36% 282,400 282,400 355,787 370,846 15,059 4.239% 78 010-37-4500 YOUNG ARENA 818,771 837,020 2.23% 719,000 719,000 99,771 118,020 18,249 18.29% $ 1.31201 79 80 TOTAL-CULTURE&RECREATION 11,343,582 11,549,533 1.82% 4,882,380 4,859,844 6,461,202 6,689,689 228,487 3.54% $ 2.84938 81 1 - - - 82 COMMUNITY&ECONOMIC DEVELOPMENT 83 010-08-5700 PLANNING&ZONING 680,512 712,475 4.70% 258,155 447,155 422,357 265,320 (157,037) -37.18% 84 010-08-5702 PLANNING&ZONING CHARGEBACKS 21,151 22,907 8.30% 21,151 22,907 0 0 0 0.00% 85 010-08-5750 RECREATION AREA DEVELOPMENT 700 700 0.00% 53,000 53,000 (52,300) (52,300) 0 0.00% 86 010-08-5885 CITY PROPERTY MANAGEMENT 145,200 145,200 0.00% 0 0 145,200 145,200 0 0.00% $ 0.15258 87 010-01-5710 INRCOG MEMBERSHIP 34,887 35,572 1.96% 0 0 34,887 35,572 685 1.96% $ 0.01515 88 010-08-6100 PLANNING&ZONING-ECONOMIC DEVEL 121,108 123,796 2.22 121,108 123,796 1w 0 W 0 �0 0.00% 89 010-08-6105 ECONOMIC DEVELOP-SPECIAL PROJECTS 0 0 0.00% 0 0 0 0 0 0.00% 90 010-01-6650 TOURISM PROMOTION-VARIOUS GRTS(H/M) 270,000 270,000 0.00% 270,000 270,000 0 0 0 0.00% 91 010-01-6660 TOURISM PROMOTION-VARIOUS DISCR(H/M) 130,000 130,000 0.00% 130,000 130,000 0 0 0 0.00% 92 010-01-6920 CONVENTION&VISITORS BUREAU(H/M) 675,000 675,000 0.00% 675,000 675,000 0 0 0 0.00% 93 010-22-6860 SULLIVAN CENTER MAINTENANCE 0 0 0.00% 507,482 507,482 (507,482) (507,482) 0 0.00% 94 010-01-6860 SULLIVAN CENTER OPERATIONS 2,779,493 2,779,493 0.00% 2,272,011 2,272,011 507,482 507,482 0 0.00% 95 010-32-5850 COMM DEVEL-ADMINISTRATIVE 0 0 0.00% 0 0 0 0 0 0.00% 96 010-32-5861 COMM DEVEL-LHAP HOUSING POOL 62,440 0.00% 62,440 0 0 0 0.00% 97 1 0 0 0 0.00 98 TOTAL-COMMUNITY&ECONOMIC DEV 4,920,491 4,957,583 0.75%1 4,370,347 4,563,791 1 550,144 1 393,792 1 (156,352) -28.42% $ 0.16773 99 K:\USERS\MICHELLE-W\Budget FYE22\FY22 BUDGET-Proposed Revisions Print Copy.xlsx 2 Page 6 of 28 3/25/2021 3:51 PM FYE2021 CERTIFIED AND FYE2022 PROPOSED BUDGET COMPARISON - CITY OF WATERLOO Proposed Budget GENE RAL FUND 3/24/21 A B E F G H I J K L M O 1 FY 2021 BUDGET FY 2022 BUDGET % FY 2021 BUDGET FY2022BUDGETI FY2021TAXES FY2022TAXES LEVIED SUBTOTALS 2 BUDGET CODE ACTIVITIES-GENERAL FUND CERTIFIED PROPOSED CHANGE CERTIFIED PROPOSED I LEVIED $ 18.63188 $AMOUNT % PORTION OF 3 EXPENSE EXPENSE REVENUE REVENUE $ 18.44026 1.04% CHANGE CHANGE TAX LEVY 4 100 101 IGENERAL GOVERNMENT 102010-01-8200 MAYOR'S OFFICE 364,043 549,311 50.899/6 0 0 364,043 549,311 185,268 50.899/6 $ 0.23397 1031010-01-8280 COMMUNICATIONS 10,891 10,891 0.00% 0 0 10,891 10,891 0 0.00% $ 0.00464 1041010-01-8220 ADMIN SERVICES/MIS 418,049 381,473 -8.75% 13,445 3,445 404,604 378,028 (26,576) -6.57% $ 0.16102 105010-01-8222 ADMIN SERVICES/MIS-CHARGEBACKS 126,178 131,429 4.169/6 126,178 131,429 0 0 0 0.00% $ 106010-02-8100 CITY COUNCIL 78,499 79,085 0.75% 0 0 78,499 79,085 586 0.759/6 $ 0.03369 1071010-03-8400 CITY CLERK AND FINANCE 1,352,795 1,417,892 4.819/6 6,175,236 5,917,686 (4,822,441) (4,499,794) 322,647 -6.69% $ (1.91663) 1081010-03-8400 CITY CLERK AND FINANCE-ELECTION COST 0 60,000 NEW 0 0 0 60,000 60,000 NEW $ 0.02556 1091010-03-8402 CITY CLERK AND FINANCE-CHARGEBACKS 77,500 161,437 108319/6 155,627 161,437 (78,127) 0 78,127 -100.009/6 $ - 110 010-06-8600 CITY ATTORNEY 353,135 321,597 -8.93% 0 0 353,135 321,597 (31,538) -8.93% $ 0.13698 1111010-03-8900 LIABILITY INSURANCE 1,431,858 1,630,969 13.91% 0 0 1,431,858 1,630,969 199,111 113919/6 $ 0.69469 112010-03-8902 LIABILITY INSURANCE-CHARGEBACKS 500,000 500,000 0.00% 500,000 500,000 0 0 0 0.00% $ 1141010-03-8950 SELF FUNDED HEALTH INSURANCE 3,883,241 2,770,000 -28.679/6 3,883,211 2,770,000 30 0 (30) -100.00% $ - 115 010-03-8960 SELF FUNDED WORK COMP 777,457 837,457 7.721/6 100,000 100,000 677,457 737,457 60,000 8.869/o $ 0.31411 1161010-03-8150 PUBLIC ACCESS STUDIO 160,849 169,934 5.651/6 30,750 30,350 130,099 139,584 9,485 7.299/o $ 0.05945 117010-03-8970 PRINT SHOP 46,000 46,000 0.00% 0 0 46,000 46,000 0 0.00% $ 0.01959 1181010-09-2600 EAP SUBSTANCE ABUSE PROGRAM 14,500 14,500 0.00% 0 0 14,500 14,500 0 0.00% $ 0.00618 1191010-09-8250 HUMAN RESOURCES 422,232 447,739 6.041/6 0 0 422,232 447,739 25,507 6.049/o $ 0.19071 1201010-09-8252 HUMAN RESOURCES-CHARGEBACKS 32,500 32,500 0.00% 32,500 32,500 0 0 0 0.00% $ 1211010-09-8255 SAFETY COMMITTEE 17,500 15,000 -14.29% 0 0 17,500 15,000 (2,500) -14.29% $ 0.00639 1221010-22-8800 CITY HALUFACILITIES MAINTENANCE 678,051 700,217 3.27% 25,000 25,000 653,051 675,217 22,166 3.39% $ 0.28760 1231010-22-8820 CITY FACILITIES RESTRICTED PROJECTS 5,085 5,085 124 010-22-8850 VETERANS MEMORIAL HALL 8,815 8,815 0.00% 0 1 0 8,815 8,815 0 0.00% $ 0.00375 125 200-09-8980 UNEMPLOYMENT FUND 17,472 17,472 0.00% 0 0 17,472 17,472 0 0.00% $ 0.00744 126 127 TOTAL-GENERAL GOVERNMENT 10,776,650 10,308,803 -4.34% 11,047,032 9,676,932 (270,382) 631,871 902,253 -333.70% $ 0.26914 128 - - 129 130 TRANSFERS 131 010-03-9050 HOTEL/MOTEL DEBT SERVICE TRANSFER 0 0.00o/-�w 0 0.00% 132 010-03-9050 TIF ECONOMIC DEV TRANSFER(INTERNAL TI 127,000 147,000-IW 15.75% 127,000 147,000 0 0.00% 133 010-08-9050 PLANNING&ZONING TRANSFER(TIF) 134 TOTAL-TRANSFERS 127,000 147,000 15.75% 127,000 147,000 0 0 0 0.00% 135 136 STATE REPLACEMENT FUNDS(COMM/IND R( 0 1,250,000 1,250,000 (1,250,000) (1,250,000) 0 0.00% $ (0.53242) 137 010-03-8400 PROPOSED USE OF FUND BALANCE 0 0.00% 750,000 2,447,505 (750,000) (2,447,505) (1,697,505) 226.33% $ (1.04248) 138 BACKFILL ADJUSTMENT 0 0.00% 0 0 0 0 0 0.00% $ - 139 0 1401 ITOTAL CITY BUDGET-GENERAL FUND 69,502,848 1 72,620,071 4.49%1 33,481,328 1 36,214,752 1 36,021,520 1 36,405,319 1 383,799 1 1.07%1 $ 15.50636 K:\USERS\MICHELLE-W\Budget FYE22\FY22 BUDGET-Proposed Revisions Print Copy.xlsx 3 Page 7 of 28 3/25/2021 3:51 PM FYE2021 CERTIFIED AND FYE2022 PROPOSED BUDGET COMPARISON - CITY OF WATERLOO Proposed Budget GENE RAL FUND 3/24/21 A B E F G H I J K L M O 1 FY 2021 BUDGET FY 2022 BUDGET % FY 2021 BUDGET FY2022BUDGETI FY2021TAXES FY2022TAXES LEVIED SUBTOTALS 2 BUDGET CODE ACTIVITIES-GENERAL FUND CERTIFIED PROPOSED CHANGE CERTIFIED PROPOSED I LEVIED $ 18.63188 $AMOUNT % PORTION OF 3 EXPENSE EXPENSE REVENUE REVENUE $ 18.44026 1.04% CHANGE CHANGE TAX LEVY 4 141 - - (0) 1421 TAXABLE VALUATION FYE2021 FYE2022 Increase %Increase 143 (In Thousands) (In Thousands) (Decrease) (Decrease) 1441 Taxable valuation-including TIF but excluding gas&electric utility values 2,539,996 2,588,994 48,998 1.93% 1451 Taxable valuation-excluding TIF&gas&electric utility values 1 2,255,590 2,271,583 15,993 0.71 1461 Taxable valuation-including TIF and electric utility values 1 2,618,388 2,662,248 43,860 1.68% 1471 Taxable valuation-excluding TIF but including gas&electric utility values 2,333,982 2,344,837 10,855 0.47% 1481 Commercial/Industrial Property Rollback 107,173 112,840 5,667 5.29% 1491 Commercial/Industrial Property Rollback for Debt Service 111,833 112,840 1,007 0.90% 1501 Taxable valuation-Ag Land 14,891 15,138 247 1.66% 1511 Tax Askings per One Cent of Levy 23,340 23,448 108 0.46% 1521 78.00% 75.001/6 1531 PROPERTY TAX LEVY ANALYSIS: FY2021 TAX FY2021 TAX FY2022 TAX STATE BACKFILL FY2022 TAX $AMOUNT 1541 LEVY RATE LEVY CORP ROLLBACK RATE CHANGE 1551 DEBT SERVICE LEVY 7,216,045 $ 2.75591 7,602,100 241,663 $ 2.85552 $ 386,055 1561 POLICE&FIRE PENSION SYSTEM 4,643,388 $ 1.98947 4,953,297 178,775 $ 2.11243 $ 309,909 1571 EMERGENCY MGMT COMMISSION LEVY 96,012 $ 0.04114 96,187 3,472 $ 0.04102 $ 175 1581 TRANSIT LEVY 1,462,588 $ 0.62665 1,462,588 52,788 $ 0.62375 $ - 1591 TORT INSURANCE LEVY 1,431,858 $ 0.61348 1,630,969 58,865 $ 0.69556 $ 199,111 1601 FICA/IPERS LEVY 2,141,677 $ 0.91761 2,178,526 78,627 $ 0.92907 $ 36,849 1611 HEALTH INSURANCE LEVY 5,340,740 $ 2.28825 5,024,002 181,327 $ 2.14258 $ (316,738) 1621 WORKERS COMP.INSURANCE LEVY 677,457 $ 0.29026 737,457 26,616 $ 0.31450 $ 60,000 1631 UNEMPLOYMENT LEVY 17,472 $ 0.00749 17,472 631 $ 0.00745 $ - 164 LIBRARY VOTED LEVY 630,175 $ 0.27000 633,106 22,850 $ 0.27000 $ 2,931 165 EMERGENCY LEVY 630,175 $ 0.27000 633,106 22,850 $ 0.27000 $ 2,931 166 GROUT LEVY 630,175 $ 0.27000 633,106 22,850 $ 0.27000 $ 2,931 167 AG LAND LEVY 44,729 45,470 $ 741 168 GENERAL FUND$8.10 LEVY 18,905,254 $ 8.10000 18,993,177 685,503 $ 8.10000 $ 87,923 170 TOTAL PROPERTY TAX LEVY $ 43,867,745 $ 18.44025 $ 44,640,563 $ 1,576,817 $ 18.63188 $ 772,818 $ 171 ROLLBACK REPLACEMENT-GENERAL LEVY NCLUDING EMPLOYEE BENEFITS LEVY,EXCL DEBT SERVICE $ 1,289,454 $ - 1 72 ROLLBACK REPLACEMENT-GENERALLEVY $ 1,048,584 173 ROLLBACK REPLACEMENT-EMPLOYEE BENEFITS LEVY $ 8,573,091 $ 286,570 174 AMOUNT CHANGE IN TAX LEVY $ 772,818 $ 0.19 175 %CHANGE 1.76% 1.04% 176 AMOUNT(OVER)UNDER $8.10 LEVY LIMIT 0 $ - 1771 ADJUSTED TOTAL PROPERTY TAX LEVY(AT GF$8.10 LEVY LIMIT) 18,993,177 $ 18.63188 178 179 GENERAL FUND$8.10 LEVY INCREASE(DECREASE) 87,923 180 TOTAL PROPERTY TAX COLLECTION INCREASE 1.76% 181 182 Maximum Levy under 384.15A 35,346,625 $ 15.14434 38,259,206 $ 16.31637 183 K:\USERS\MICHELLE-W\Budget FYE22\FY22 BUDGET-Proposed Revisions Print Copy.xlsx 4 Page 8 of 28 3/25/2021 3:51 PM FYE2021 CERTIFIED AND FYE2022 PROPOSED BUDGET COMPARISON - CITY OF WATERLOO Proposed Budget GENE RAL FUND 3/24/21 A B E F G H I J K L M O 1 FY 2021 BUDGET FY 2022 BUDGET % FY 2021 BUDGET FY 2022 BUDGET FY2021TAXES FY2022TAXES LEVIED SUBTOTALS 2 BUDGET CODE ACTIVITIES-GENERAL FUND CERTIFIED PROPOSED CHANGE CERTIFIED PROPOSED LEVIED $ 18.63188 $AMOUNT % PORTION OF 3 EXPENSE EXPENSE REVENUE REVENUE $ 18.44026 1.04% CHANGE CHANGE TAX LEVY 4 184 Residential Tax Askings Home Value Avg Revaluation Adj Value Rollback Tax Incr(Decr) Monthly Change %Change IOU 186 $ 18.63188 FYE2022 152,234 152,234 0.564094 1,600.00 53.93 4.49 3.49% 187 $ 18.44026 FYE2021 152,234 Ind reval 152,234 0.550743 1,546.07 25.56 2.13 1.68% 188 $ 17.54799 FYE2020 152,234 152,234 0.56918 1,520.51 42.44 3.54 2.87% 189 $ 17.45595 FYE2019 152,234 Ind reval 152,234 0.556209 1,478.07 (47.52) (3.96) -3.11% 190 $ 17.60000 FYE2018 152,234 152,234 0.569391 1,525.58 34.74 2.90 2.33% 191 $ 17.60522 FYE2017 147,973 2.88% 152,234 0.556259 1,490.84 25.86 2.16 1.77% 192 $ 17.76370 FYE2016 147,973 147,973 0.557335 1,464.98 19.92 1.66 1.38% 193 $ 17.95159 FYE2015 154,138 4% 147,973 0.544002 1,445.06 20.93 1.74 1.47% 194 $ 17.49319 FYE2014 154,138 154,138 0.528166 1,424.13 (0.01) (0.00) 0.00% 195 $ 18.20505 FYE2013 154,138 154,138 0.507518 1,424.14 37.79 3.15 2.73% 196 $ 18.53335 FYE2012 154,138 154,138 0.485299 1,386.35 65.76 5.48 4.98% 197 $ 18.26406 FYE2011 154,138 154,138 0.469094 1,320.59 34.15 2.85 2.65% 198 $ 18.30689 FYE2010 154,138 154,138 0.455893 1,286.43 38.51 3.21 3.09% 199 $ 18.36687 FYE2009 144,054 7% 154,138 0.440803 1,247.93 16.26 1.36 1.32% 200 $ 18.76669 FYE2008 144,054 144,054 0.455596 1,231.67 (17.04) (1.42) -1.36% 201 $ 18.84580 FYE2007 132,160 9% 144,054 0.45996 1,248.71 34.44 2.87 2.84% 202 $ 19.15566 FYE2006 132,160 132,160 0.479642 1,214.27 10.97 0.91 0.91% 203 $ 18.78999 FYE2005 118,000 12% 132,160 0.484558 1,203.30 56.70 4.72 4.95% 204 $ 18.90914 FYE2004 118,000 118,000 0.513874 1,146.60 26.52 2.21 2.37% 205 $ 18.37162 FYE2003 100,000 18% 118,000 0.516676 1,120.08 118.52 9.88 11.83% 206 $ 17.80075 FYE2002 100,000 N/A 100,000 0.562651 1,001.56 96.99 8.08 10.72% 207 $ 16.49097 FYE2001 100,000 100,000 0.548525 904.57 209 Commercial Tax Askings Property Value Avg.Revaluation Adj Value Rollback Tax Incr(Decr) Monthly Change %Change 211 $ 18.63188 FYE2022 752,427 752,427 0.90 12,617.22 129.76 10.81 1.04% 212 $ 18.44026 FYE2021 752,427 752,427 0.90 12,487.45 604.23 50.35 5.08% 213 $ 17.54799 FYE2020 752,427 752,427 0.90 11,883.22 62.33 5.19 0.53% 214 $ 17.45595 FYE2019 752,427 752,427 0.90 11,820.90 (97.55) (8.13) -0.82% 215 $ 17.60000 FYE2018 752,427 752,427 0.90 11,918.44 (3.53) (0.29) -0.03% 216 $ 17.60522 FYE2017 752,427 752,427 0.90 11,921.98 (107.32) (8.94) -0.89% 217 $ 17.76370 FYE2016 752,427 752,427 0.90 12,029.30 (802.60) (66.88) -6.25% 218 $ 17.95159 FYE2015 752,427 752,427 0.95 12,831.90 (330.45) (27.54) -2.51% 219 $ 17.49319 FYE2014 752,427 752,427 1 13,162.35 (535.62) (44.64) -3.91% 220 $ 18.20505 FYE2013 752,427 752,427 1 13,697.97 (247.02) (20.59) -1.77% 221 $ 18.53335 FYE2012 752,427 752,427 1 13,944.99 202.62 16.89 1.47% 222 $ 18.26406 FYE2011 752,427 752,427 1 13,742.37 (32.23) (2.69) -0.23% 223 $ 18.30689 FYE2010 752,427 752,427 1 13,774.60 (7.98) (0.67) -0.06% 224 $ 18.36687 FYE2009 690,300 9% 752,427 0.997312 13,782.58 827.94 68.99 6.39% 225 $ 18.76669 FYE2008 690,300 N/A 690,300 1 12,954.65 55.85 4.65 0.43% 226 $ 18.84580 FYE2007 690,300 N/A 690,300 0.991509 12,898.79 (324.36) (27.03) -2.45% 227 $ 19.15566 FYE2006 690,300 N/A 690,300 1 13,223.15 348.79 29.07 2.71% 228 $ 18.78999 FYE2005 585,000 18% 690,300 0.99257 12,874.36 1,812.51 151.04 16.39% 229 $ 18.90914 FYE2004 585,000 N/A 585,000 1 11,061.85 554.11 46.18 5.27% 230 $ 18.37162 FYE2003 585,000 N/A 585,000 0.977701 10,507.74 94.30 7.86 0.91% 231 $ 17.80075 FYE2002 585,000 N/A 585,000 1 10,413.44 766.22 63.85 7.94% 232 $ 16.49097 IFYE2001 1 500,000 1 17% 585,000 1 1 9,647.22 K:\USERS\MICHELLE-W\Budget FYE22\FY22 BUDGET-Proposed Revisions Print Copy.xlsx 5 Page 9 of 28 3/25/2021 3:51 PM FYE2021 CERTIFIED AND FYE2022 PROPOSED BUDGET COMPARISON - CITY OF WATERLOO Proposed Budget GENE RAL FUND 3/24/21 A B E F G H I J K L M O 1 FY 2021 BUDGET FY 2022 BUDGET % FY 2021 BUDGET FY 2022 BUDGET FY2021TAXES FY2022TAXES LEVIED SUBTOTALS 2 BUDGET CODE ACTIVITIES-GENERAL FUND CERTIFIED PROPOSED CHANGE CERTIFIED PROPOSED LEVIED $ 18.63188 $AMOUNT % PORTION OF 3 EXPENSE EXPENSE REVENUE REVENUE $ 18.44026 1.04% CHANGE CHANGE TAX LEVY 4 2341 Industrial Tax Askings Adj Value Rollback Tax Incr(Decr) Monthly Change %Change IOU 236 $ 18.63188 FYE2022 1,000,000 N/A 1,000,000 0.90 16,768.69 172.46 14.37 1.04% 237 $ 18.44026 FYE2021 1,000,000 N/A 1,000,000 0.90 16,596.23 803.04 66.92 5.08% 238 $ 17.54799 FYE2020 1,000,000 N/A 1,000,000 0.90 15,793.19 82.84 6.90 0.53% 239 $ 17.45595 FYE2019 1,000,000 N/A 1,000,000 0.90 15,710.36 (129.65) (10.80) -0.82% 240 $ 17.60000 FYE2018 1,000,000 N/A 1,000,000 0.90 15,840.00 (4.70) (0.39) -0.030/6 241 $ 17.60522 FYE2017 1,000,000 N/A 1,000,000 0.90 15,844.70 (142.63) (11.89) -0.890/6 242 $ 17.76370 FYE2016 1,000,000 N/A 1,000,000 0.90 15,987.33 (1,066.68) (88.89) -6.250/6 243 $ 17.95159 FYE2015 1,000,000 N/A 1,000,000 0.95 17,054.01 (439.18) (36.60) -2.511/6 244 $ 17.49319 FYE2014 1,000,000 N/A 1,000,000 1 17,493.19 (711.86) (59.32) -3.911/6 245 $ 18.20505 FYE2013 1,000,000 N/A 1,000,000 1 18,205.05 (328.30) (27.36) -1.770/6 246 $ 18.53335 FYE2012 1,000,000 N/A 1,000,000 1 18,533.35 269.29 22.44 1.47% 247 $ 18.26406 FYE2011 1,000,000 N/A 1,000,000 1 18,264.06 (42.83) (3.57) -0.230/6 248 $ 18.30689 FYE2010 1,000,000 N/A 1,000,000 1 18,306.89 (59.98) (5.00) -0.330/6 249 $ 18.36687 FYE2009 1,000,000 N/A 1,000,000 1 18,366.87 (399.82) (33.32) -2.130/6 250 $ 18.76669 FYE2008 1,000,000 N/A 1,000,000 1 18,766.69 (79.11) (6.59) -0.420/6 251 $ 18.84580 FYE2007 1,000,000 N/A 1,000,000 1 18,845.80 (309.86) (25.82) -1.620/6 252 $ 19.15566 FYE2006 1,000,000 N/A 1,000,000 1 19,155.66 365.67 30.47 1.95% 253 $ 18.78999 FYE2005 1,000,000 N/A 1,000,000 1 18,789.99 (119.15) (9.93) -0.630/6 254 $ 18.90914 FYE2004 1,000,000 N/A 1,000,000 1 18,909.14 537.52 44.79 2.93% 255 $ 18.37162 FYE2003 1,000,000 N/A 1,000,000 1 18,371.62 570.87 47.57 3.21% 256 $ 17.80075 FYE2002 1,000,000 N/A 1,000,000 1 17,800.75 1,309.78 109.15 7.94% 257 $ 16.49097 FYE2001 1,000,000 N/A 1,000,000 1 16,490.97 258 259 Multi-Residential Tax Askings Adj Value Rollback Tax Incr(Decr) Monthly Change %Change 261 $ 18.63188 FYE2022 500,000 N/A 500,000 0.6750 6,288.26 (281.08) (23.42) -4.28% 262 $ 18.44026 FYE2021 500,000 N/A 500,000 0.7125 6,569.34 (11.15) (0.93) -0.17% 263 $ 17.54799 FYE2020 500,000 N/A 500,000 0.7500 6,580.50 (292.78) (24.40) -4.26% 264 $ 17.45595 FYE2019 500,000 N/A 500,000 0.7875 6,873.28 (386.72) (32.23) -5.33% 265 $ 17.60000 FYE2018 500,000 N/A 500,000 0.8250 7,260.00 (332.25) (27.69) -4.38% 266 $ 17.60522 FYE2017 500,000 N/A 500,000 1 0.8625 7,592.25 (401.41) (33.45) -5.02%1 1 267 $ 17.76370 FYE2016 500,000 N/A 500,000 0.9000 7,993.67 (533.34) (44.45) -6.25% 268 $ 17.95159 FYE2015 500,000 N/A 500,000 0.9500 8,527.01 (219.59) (18.30) -2.51% 269 $ 17.49319 FYE2014 500,000 N/A 500,000 1 1 8,746.60 K:\USERS\MICHELLE-W\Budget FYE22\FY22 BUDGET-Proposed Revisions Print Copy.xlsx 6 Page 10 of 28 3/25/2021 3:51 PM FY2021 CERTIFIED AND FY2022 PROPOSED Proposed Budget BUDGET COMPARISON -CITY OF WATERLOO 3/24/21 ALL OTHER FUNDS A B C D E F G H I J K L M N O P Q 1 PROJECT CERT FY2021 BUDGET FY2022 BUDGET % FY2021 BUDGET FY2022 BUDGET FY2021 FY2021 FY2022 FY2022 FY2021 FY2022 $AMOUNT % 2 BUDGET CODE ACTIVITIES-OTHER FUNDS CODE BUDGET CERTIFIED PROPOSED CHANGE CERTIFIED PROPOSED TRANSFERS TRANSFERS TRANSFERS TRANSFERS LEVIED LEVIED CHANGE CHANGE 3 LINE EXPENSE EXPENSE REVENUE REVENUE (IN) OUT (IN) OUT 4 PUBLIC SAFETY 5 200-11-1140 POLICE PENSION SYSTEM 1D 2,515,650 2,650,353 5.359/6 0 0 2,515,650 2,650,353 134,703 5.359/6 6 200-12-1420 FIRE PENSION SYSTEM 5D 2,127,738 2,302,944 8.23% 0 0 2,127,738 2,302,944 175,206 8.23% 7 8 TOTAL-PUBLIC SAFETY 111) 4,643,388 4,953,297 6.67% 0 0 0 0 0 0 4,643,388 4,953,297 309,909 6.67% 9 10 11 PUBLIC WORKS 12 205-07-7400 BRIDGE MAINTENANCE-LOCAL OPTION 12D 0 0 0.00% 0 0 0 0 0.00% 13 205-07-7500 STREET CONSTRUCTION-LOCAL OPTION 12D 8,479,047 8,634,505 1.839/6 10,245,000 10,507,000 (1,765,953) (1,872,495) (106,542) 6.03% 14 205-07-7830 ENGINEERING-LOCAL OPTION TAX 12D 735,500 776,974 5.64% 0 0 735,500 776,974 41,474 5.64% 15 205-19-7110 SEAL COATING-LOCAL OPTION 12D 1,030,453 1,095,521 6.319/6 0 0 1,030,453 1,095,521 65,068 6.31% 16 266-07-7830 ROAD USE TAX REVENUE 0 0 0.00% 7,637,010 7,616,935 (7,637,010) (7,616,935) 20,075 -0.26% 17 266-07-7300 BRIDGE REPLACEMENT-ROAD USE TAX 12D 750,000 750,000 0.00% 0 333,165 750,000 416,835 (333,165) -44.42% 18 266-07-7500 STREET CONST-ROAD USE TAX 12D 7,464,909 4,000,000 -46.42% 7,500,000 4,000,000 (35,091) 0 35,091 -100.00% 19 266-07-7830 ENGINEERING-ROAD USE TAX FUND 12D 1,083,720 1,178,356 8.739/6 49,050 49,050 1,034,670 1,129,306 94,636 9.15% 20 266-07-7832 ENGINEERING-CHARGEBACKS(OUT) 12D 133,047 133,047 0.00% 133,047 133,047 0 0 0 0.00% 21 266-07-7832 ENGINEERING-CHARGEBACKS(IN) 12D 50,000 50,000 0.00% 50,000 50,000 0 0 0 0.00% 22 266-17-7105 STREET LIGHTING UTIL-ROAD USE TAX 14D 518,000 523,180 1.00% 0 0 518,000 523,180 5,180 1.00% 23 266-17-7120 TRAFFIC SAFETY-ROAD USE TAX FUND 15D 1,536,158 1,594,024 3.779/6 27,350 27,350 1,508,808 1,566,674 57,866 3.84% 24 266-17-7122 TRAFFIC SAFETY-CHARGEBACKS(OUT) 15D 32,000 32,000 0.00% 32,000 32,000 0 0 0 0.00% 25 266-17-7125 TRAFFIC SAFETY-RESTRICTED PROJ 17TRF DSCV 15D 100 100 0.00% 100 100 0 0 0 0.00% 26 266-17-7161 TRAFFIC SIGNALS UTIL-ROAD USE TAX 15D 48,000 48,000 0.00% 0 0 48,000 48,000 0 0.00% 27 266-19-7100 STREET MTCE-ROAD USE TAX FUND 12D 1,965,631 2,085,948 6.129/6 550 550 1,965,081 2,085,398 120,317 6.12% 28 266-19-7102 STREET MTCE-CHARGEBACKS(OUT) 12D 158,500 158,500 0.00% 158,500 158,500 0 0 0 0.00% 29 266-19-7200 SNOW REMOVAL 16D 1,855,542 1,855,542 0.00% 81000 8,000 1,847,542 1,847,542 0 0.00% 30 266-37-7902 ROW FORESTRY&MOWING 12D 900,000 900,000 0.00% 900,000 900,000 0 0 0 0.00% 31 291-29-7750 AIRPORT FEDERAL PROJECTS 29AIP mm 19D 634,528 1,100,000 73.36% 634,528 1,100,000 0 0 0 0.00% 32 291-29-7755 AIRPORT PASSENGER FACILITY CHARGES 29AIP mm 19D 96,881 1 100,000 3.22% 96,881 100,000 1 1 0 1 0 0 0.00% 33 291-29-7760 AIRPORT STATE PROJECTS 29PRO Vim 19D 177,000 173,000 -2.26% 177,000 173,000 0 0 0 0.00% 34 35 TOTAL-PUBLIC WORKS 22D 27,649,016 25,188,697 -8.90% 27,649,016 25,188,697 0 0 0 0 0 0 0 0.00% 36 37 38 CULTURE&RECREATION 39 204-33-3100 LIBRARY-TAX LEVY 31C 669,779 707,414 5.62% 17,033 51,458 652,746 655,956 3,210 0.49% 40 41 TOTAL-CULTURE&RECREATION 669,779 707,414 5.62% 17,033 51,458 0 0 0 0 652,746 655,956 3,210 0.49% 42 43 44 COMMUNITY&ECONOMIC DEVELOPMENT 45 224-32-5850 COMM.DEVELOPMENT-BLOCK GRANT VARIOUS 41D 1,646,384 1,646,384 0.00% 1,646,384 1,646,384 0 0 0 0.00% 46 224-32-5853 COMM.DEVELOPMENT-LEAD PAINT GRANT 41D 1,378,918 1,359,093 -1.44% 1,378,918 1,359,093 0 0 0 0.00% 47 224-32-5854 COMM.DEVELOPMENT-NEW CONSTRUCT! 32NC4 xxxx 41D 0 0 0.00% 0 0 0 0 0 0.00% 48 224-32-5870 COMM.DEVELOPMENT-FEDERAL HOME VARIOUS 41D 1,361,742 1,361,742 0.00% 1,361,742 1,361,742 0 0 0 0.00% 49 224-32-6800 NEIGHBORHOOD SERVICES BG0050016 41D 85,173 90,000 5.67% 85,173 90,000 0 0 0 0.00% 51 283-13-5450 HOUSING-RIDGEWAY TOWERS 41D 262,000 264,000 0.76% 262,000 264,000 0 0 0 0.00% 52 283-13-5451 HOUSING-CAPITAL FUNDS(C/O) 13CAP FY- 41D 65,000 70,000 7.69% 65,000 70,000 0 0 0 0.00% 53 283-13-5452 HOUSING-SECTION 8 41D 5,672,200 5,834,300 2.86% 5,672,200 5,834,300 0 0 0 0.00% 54 283-13-5453 HOUSING-FAMILY SELF SUFFICIENCY 41D 20,000 20,000 0.00% 20,000 20,000 0 0 0 0.00% 55 283-13-5455 HOUSING-DOWNPAYMENT ASSISTANCE 41D 50,000 50,000 0.00% 50,000 50,000 0 0 0 0.00% 56 283-13-5861 HOUSING-LHAP HOUSING POOL 41D 0 0 0.00% 0 0 0 0 0 0.00% 57 58 TOTAL-COMMUNITY&ECONOMIC DEV 45D 10,541,417 10,695,519 1.46% 10,541,417 10,695,519 0 0 0 0 0 0 0 0.00% 59 60 K:\USERS\MICHELLE-W\Budget FYE22\FY22 BUDGET_Proposed Revisions Print Copy.xlsx 7 Page 11 of 28 3/25/2021 3:51 PM FY2021 CERTIFIED AND FY2022 PROPOSED Proposed Budget BUDGET COMPARISON -CITY OF WATERLOO 3/24/21 ALL OTHER FUNDS A B C D E F G H I J K L. M N O P Q 1 PROJECT CERT FY2021 BUDGET FY2022 BUDGET % FY2021 BUDGET FY2022 BUDGET FY2021 FY2021 FY2022 FY2022 FY2021 FY2022 E AMOUNT 2 BUDGET CODE ACTIVITIES-OTHER FUNDS CODE BUDGET CERTIFIED PROPOSED CHANGE CERTIFIED PROPOSED TRANSFERS TRANSFERS TRANSFERS TRANSFERS LEVIED LEVIED CHANGE CHANGE 3 LINE EXPENSE EXPENSE REVENUE REVENUE (IN) OUT (IN) OUT 61 GENERAL GOVERNMENT 62 200-09-8980 UNEMPLOYMENTFUND 52D 17,472 17,472 0.00% 0 0 17,472 17,472 0 0.00% 63 64 TOTAL-GENERAL GOVERNMENT 53D 17,472 17,472 0.00% 0 0 0 0 0 0 17,472 17,472 0 0.00% 65 66 67 SPECIAL REVENUES CAPITAL PROJECTS 68 290-07-5300 STORM WATER PUMP STATIONS-COMM 64.:07FLD 5007 55D 0 0 0.00% 0 0 0 0 0 0.00% 69 290-07-5300 STORM WATER PUMP STATIONS-COMM 35.E 07FLD D078 55D 0 0 0.00% 0 0 0 0 0 0.00% 70 290-07-7300 STREETS-W PARK 11TH BRIDGE REPLACEMENTS 55D 0 6,000,000 NEW 0 6,000,000 0 0 0 0.00% 71 290-07-7355 STREETS-SHAULIS RD TRAIL 08BKE.TAP766 55D 0 200,000 NEW 0 200,000 0 0 0 0.00% 72 290-07-7500 STREETS-LAPORT/HESS RD 07STR.SWAP7E 55D 5,043,543 250,000 -95.049/6 5,043,543 250,000 0 0 0 0.00% 73 290-07-7500 STREETS-SHAULIS RD RECONSTSTRUCTIOI 07STR.RM772 55D 0 4,600,000 NEW 0 4,600,000 0 0 0 0.00% 74 290-07-7520 US 63 55D 0 1,500,000 NEW 0 1,500,000 0 0 0 0.00% 08BKE RT734 75 1290-08-6100 BROWNSFIELD 08BKE TAP741 55D 200,000 0 -100.00% 200,000 0 0 0 0 0.00% 76 290-17-7161 TRAFFIC-ANSB TO BLACK HAWK 17TRF STP757 55D 300,000 0 -100.00% 300,000 0 0 0 0 0.00% 77 290-17-7161 TRAFFIC-VISION ZERO 17TRF xxxx 55D 5,000 0 -100.00% 5,000 0 0 0 0 0.00% 78 290-17-7161 TRAFFIC IMPR-GREYHOUND&RIDGEWAY 17TRF xxxx 55D 310,000 0 -100.00% 310,000 0 0 0 0 0.00% 79 290-17-7161 TRAFFIC DOWNTOWN CAMERA&FIBER 17TRF xxxx 55D 550,000 400,000 -27.27% 550,000 400,000 0 0 0 0.00% 80 290-17-7161 TRAFFIC W 9TH/SOUTH ROUNDABOUT 17TRF xxxx 55D 0 385,000 NEW 0 385,000 0 0 0 0.00% 81 290-17-7161 TRAFFIC SAFETY CAMPAIGN 17TRF xxxx 55D 40,000 30,000 -25.00% 40,000 30,000 0 0 0 0.00% 82 290-17-7161 TRAFFIC US 63 TRAFFIC ADAPTIVE PROJ 17TRF XXU 55D 0 145,000 NEW 0 145,000 0 0 0 0.001/. 83 290-17-7161 TRAFFIC-RIDGEWAYAVE 17TRF xxxx 55D 700,000 0 -100.00% 700,000 0 0 0 0 0.00% 84 290-17-7161 TRAFFIC-PARK AVE BICYCLE SIGNAL PROJ 17TRF XXU 55D 72,000 100,000 38.899/6 72,000 100,000 0 0 0 0.00% 85 290-17-7161 TRAFFIC IMPR-5TH&6TH STREETS 17TRF xxxx 55D 0 0 0.00% 0 0 0 0 0 0.00% 86 290-37-4100 GREENBELT LAKE IMPROVEMENTS 371MP.GRNBLTI 55D 200,000 200,000 0.00% 200,000 200,000 0 0 0 0.001/. 87 290-37-4105 BOATHOUSE AREA IMPROVEMENTS 55D 0 0 0.00% 0 0 0 0 0 0.00% 88 290-37-4700 RIVERVIEW REC AREA TRAIL EXTENSION 08RECTRL13 55D 0 0 0.00% 0 0 0 0 0 0.00% 89 290-32-5856 NEIGHBORHOOD STABILIZATION 32NS3 xxxx 55D 130,000 130,000 0.00% 130,000 130,000 1 0 0 0 0.00% 90 207- IA REINVESTMENT DISTRICT 300 150 50.00% 220,300 125,150 200,000 100,000 (20,000) (25,000) (5,000) 25.00% 91 92 TOTAL-SPECIAL REVENUES CAPITAL PROJECTS 57D 7,550,843 13,940,150 84.62% 7,770,843 14,065,150 0 200,000 0 100,000 (20,000) (25,000) (5,000) 25.00% 93 94 Subtotal-200 Series Funds-Less Library Levy 50,402,136 54,795,135 45,961,276 49,949,366 0 200,000 0 100,000 5,293,606 5,601,725 308,119 5.82% 95 96 97 BUSINESS TYPE ACTIVITIES 98 520-14-5200 WATER POLLUTION CONTROL PLANT 601 7,834,707 8,076,099 3.08% 13,536,940 13,460,940 (5,702,233) (5,384,841) 317,392 -5.57% 99 520-14-5202 WATER POLLUTION-CHARGEBACKS 601 692,000 692,000 0.00% 692,000 692,000 0 0 0 0.00 100 520-14-5280 SEWER REVENUE PLANT SRF 711 14,340,000 6,650,000 53.63% 14,340,000 6,650,000 0 0 0 0.00% 101 520-14-5375 SEWER REVENUE COLLECTION SRF 711 11,800,000 10,211,000 -13.47% 11,800,000 10,211,000 0 0 0 0.00% 102520-14-8980 SEWER REVENUE DEBT SERVICE 701 1,015,750 1,148,179 13.04% 0 0 1,015,750 1,148,179 132,429 13.04% 103 520-14-9050 SEWER GO BOND DEBT SERVICE 751 0 0 0.00% 0 0 2,427,130 2,294,701 2,427,130 2,294,701 (132,429) -5.46% 104 520-22-5335 FOOTING DRAIN DISCONNECTIONS 601 138,347 147,368 6.52% 0 0 138,347 147,368 9,021 6.52% 105 521-14-5310 STORM SEWER MAINTENANCE 601 715,632 763,687 6.72% 0 0 715,632 763,687 48,055 6.72% 106521-19-5500 STREET CLEANING 601 358,884 383,374 6.82% 0 0 358,884 383,374 24,490 6.82% 1071521-07-7830 ENGINEERING-STORM WATER ADMIN 601 453,853 483,924 6.63% 2,417,950 2,748,450 (1,964,097) (2,264,526) (300,429) 15.30% 108 521-07-7832 ENG-STORM WATER ADMIN CHARGEBACKS 601 7,050 7,050 0.00% 7,050 7,050 0 0 0 0.001/6 109 521-07-5300 STORM WATER CAPITAL PROJECTS 711 1,050,000 1,260,000 20.00% 160,419 142,535 889,581 1,117,465 227,884 25.62% 110 521-07-5375 STORM WATER SRF PROJECTS 711 0 1,400,000 NEW 0 1,400,000 889,581 0 (889,581) -100.00% 111 520-14-5320 SEWER SYSTEM IMPROVEMENTS 711 2,121,006 1,794,593 -15.39% 0 2,121,006 1,794,593 (326,413) -15.39% 112 617-14-53201898(l SEWER GO BOND PROJECTS 711 1,000,000 0 -100.00% 1,000,000 0 (1,000,000) -100.00% 113 SUBTOTAL-SEWER FUND 41,527,229 33,017,274 -20.49% 42,954,359 35,311,975 0 2,427,130 2,294,701 1,889,581 0 (1,889,581) -100.00% 114 K:\USERS\MICHELLE-W\Budget FYE22\FY22 BUDGET_Proposed Revisions Print Copy.xlsx 8 Page 12 of 28 3/25/2021 3:51 PM FY2021 CERTIFIED AND FY2022 PROPOSED Proposed Budget BUDGET COMPARISON -CITY OF WATERLOO 3/24/21 ALL OTHER FUNDS A B C D E F G H I J K L M N O P Q 1 PROJECT CERT FY2021 BUDGET FY2022 BUDGET % FY2021 BUDGET FY2022 BUDGET FY2021 FY2021 FY2022 FY2022 FY2021 FY2022 E AMOUNT 2 BUDGET CODE ACTIVITIES-OTHER FUNDS CODE BUDGET CERTIFIED PROPOSED CHANGE CERTIFIED PROPOSED TRANSFERS TRANSFERS TRANSFERS TRANSFERS LEVIED LEVIED CHANGE CHANGE 3 LINE EXPENSE EXPENSE REVENUE REVENUE (IN) OUT (IN) OUT 115 525-15-5400 SANITATION 641 4,741,923 4,740,252 -0.04% 5,236,759 1 5,466,764 (494,836) (726,512) (231,676) 46.82% 116 525-15-5402 SANITATION-CHARGEBACKS 641 376,500 376,500 0.00% 451,500 451,500 (75,000) (75,000) 0 0.00% 117525-15-5125 SANITATION-CODE ENFORCEMENT 641 548,471 595,241 8.53% 81,080 58,318 467,391 536,923 69,532 14.88% 118525-17-2400 SANITATION-ANIMAL CONTROL 641 362,689 377,969 4.219/6 111,700 113,380 250,989 264,589 13,600 5.42% 1191 SUBTOTAL-SANITATION FUND 6,029,583 6,089,962 1.00% 5,881,039 6,089,962 0 148,544 0 (148,544) -100.00% 120 121 TOTAL-BUSINESS TYPE ACTIVITIES 731 47,556,812 39,107,236 -17.77% 48,835,398 41,401,937 0 2,427,130 2,294,701 1,148,544 (2,038,125) -100.00% 122 123 124 DEBT SERVICE 125 100 GEN.OBLIGATION BOND DEBT SERVICE 54F 13,157,973 13,403,500 1.87% 497,367 462,935 (5,444,561) (5,338,465) 7,216,045 7,602,100 386,055 5.35% 126 101 TIF ECONOMIC DEV&REBATES 43E 2,610,938 21673,698 2.40% 9,398,510 10,709,761 (127,000) 6,914,572 (147,000) 7,914,560 (268,503) (268,503) NEW 127 101 TAX INCREMENT DEBT SERVICE 54E 0 0 0.00% 0 0 0 0 0.00% 128 129 TOTAL-DEBT SERVICE 15,768,911 16,077,198 1.96% 9,895,877 11,172,696 (5,571,561) 6,914,572 (5,485,465) 7,914,560 7,216,045 7,333,597 117,552 1.63% 130 131 132 CAPITAL PROJECTS 133 419/420-8980 G.O.BOND PROCEEDS 55G 11,000,000 11,000,000 0.00% 11,000,000 11,000,000 0 0 0 0.00% 134 416/417/418/419 G.O.BOND/CAPITAL PROJECTS 55G 51000,000 51000,000 0.00% 0 5,000,000 5,000,000 0 0.001% 1351417/418/419 G.O.BOND/CAPITAL PROJECTS—TIF 56G 0 0 0.00% 0 0 0 0 0.00% 136 417 G.O.BOND/CAPITAL PROJECTS—TECHWORKS IRD 55G 0 0 0.00% 0 0 0 0 0.001% 138426-07-7400 CAP IMPR-BRIDGES 55G 750,000 0 -100.00% 750,000 0 0 0 0 0.00% 139426-07-7355 CAP IMPR-UNIVERSITY AVENUE 55G 265,000 0 -100.00% 265,000 0 0 0 0 0.00% 140 426-07-7610 CAP IMPR-RIVERFRONT IMPR 55G 50,000 11000,000 1900.00% 50,000 11000,000 0 0 0 0.00% 141 426-07-7650 CAP IMPR-COMMERCIAL STREETSCAPE 55G 0 500,000 0.00% 0 500,000 0 0 0 0.00% 142 426-37-0105 CAP IMPR- 55G 179,489 0 -100.00% 179,489 0 0 0 0 0.00% 143.426-37-4202 CAP IMPR-BALL DIAMOND IMPROVEMENTS 37SPT FLDLGH 55G 0 0 0.00% 0 0 0 0 0 0.00% 144 426-37-0105 CAP IMPR-LINCOLN PARK PROJECT 37LINC GAME 55G 0 0 0.00% 0 0 0 0 0 0.00% 145 426-37-4207 CAP IMPR-BOAT HOUSE AREA IMPR 55G 0 0 0.00% 0 0 0 0 0 0.00% 146 426-08-6205 CAP IMPR-SAN MARNAN TIF PROJ 56G 15,000 1,000,000 6566.67% 0 0 (15,000) (1,000,000) 0 0 0 0.00% 147 426-08-6210 CAP IMPR-RATH TIF PROJECTS 56G 300,000 300,000 0.00% 0 0 (300,000) (300,000) 0 0 0 0.00% 148 426-08-6220 CAP IMPR-NE SITE TIF PROJECTS 56G 0 0 0.00% 0 0 0 0 0 0 0 0.00% 149 426-08-6250 CAP IMPR-MARTIN RD TIF PROJECTS 56G 1 196,000 0 -100.00% 0 0 (196,000) 0 0 0 0 0.00% 1501426-08-6260 CAP IMPR-MIDPORT TIF PROJECTS 56G 2,048,033 1,400,000 -01.64% 0 0 (2,048,033) (1,400,000) 0 0 0 0.00% 151 426-08-6270 CAP IMPR-DOWNTOWN TIF PROJECTS 56G 40,000 750,000 1775.00% 0 0 (40,000) (750,000) 0 0 0 0.00% 152 426-08-6280 CAP IMPR-NORTH CROSSING 56G 1,250,000 0 -100.00% 0 0 (1,250,000) 0 0 0 0.00% 153426-08-6280 CAPIMPR-LOGAN 56G 0 1,250,000 NEW 0 0 (1,250,000) 0 0 0 0.00% 154 155 TOTAL-CAPITAL PROJECTS 57G 21,093,522 22,200,000 5.25%1 12,244,489 12,500,000 1 (3,849,033) 0 (4,700,000) 0 5,000,000 5,000,000 01 0.00% 156 157 158TOTAL CITY BUDGET-OTHER FUNDS 135,491,160 132,886,983 -1.92% 116,954,073 115,075,457 9,420,594 9,541,702 10,185,465 10,309,261 18,658,195 17,935,322 1,612,454 K:\USERS\MICHELLE-W\Budget FYE22\FY22 BUDGET_Proposed Revisions Print Copy.xlsx 9 Page 13 of 28 3/25/2021 3:51 PM Proposed Budget 3/25/21 A B C D E F G H I J K 2 City of Waterloo 3 FYE2022 General Fund 4 Proposed Budget Change In Cost From FY21 5 %of Total 6 Amount Change From 7 Prior Year Tax Levy 8 Property Taxes FYE2021 (Excl. Debt Svc& Lib, Incl. Excise Tax, Grout) 35,391,350 23,448 1 cent on the levy raises this much 10 General Fund Personal Services increases (decreases): 11 Salaries& longevity 818,142 2.31% Includes avg 2.0% raises, 3.0%for Police and Fire, 12 0 0.00% step increases, longevity 13 Add 1 Chief of Staff 176,616 0.50% 14 Add 4 SAFER-regular salary only 21,716 0.06% 15 Hiring Delays (527,629) -1.49% 16 Finance- Reduce Salaries (15,000) -0.04% 17 Fire/Ambulance- Reduce Overtime (96,000) -0.27% 18 Garage- Reduce Position (97,217) -0.27% 19 Cultural Arts- Reduce Part time (5,478) -0.02% 20 Leisure Services- Reorganization (32,608) -0.09% 21 Increase in Personnel Costs Charged to Police Grants 8,457 0.02% 22 Increase in Personnel Costs Charged to SAFER Grants 208,356 0.59% 23 Decrease Part Time Labor (28,053) -0.08% 24 Misc, overtime, double time, and bonus pay 15,336 0.04% 25 Police&fire overtime, doubletime& bonus pay 47,410 0.13% 26 Payroll taxes 60,265 0.17% 27 Employee sick and casual payouts 9,546 0.03% 28 Retirement payouts 96,951 0.27% 29 Reduce Retirement Payouts (34,092) 30 Health insurance 489,859 4.88% 2,353,270 1.0036 Personnel increases excl. 31 Retiree health insurance 18,482 fire& police pension 32 Reduce use of health insurance fund balance 1,218,211 1,726,552 33 Police Pension 134,703 34 Fire Pension 175,206 309,909 0.88% 2,663,179 1.13576 Total personnel increases 35 Subtotal - Personnel Increases 2,663,179 7.62% 36 37 38 39 KAUSERS\MICHELLE-MBudget FYE22\FY22 BUDGET_Proposed Revisions Print Copy.xlsx\Comparison to FYE21 Page 14 of 28 3/25/2021 3:51 PM Proposed Budget 3/25/21 A B C D E F G H I J K 2 City of Waterloo 3 FYE2022 General Fund 4 Proposed Budget Change In Cost From FY21 5 %of Total 6 Amount Change From 7 Prior Year Tax Levy 41 Contractual Services and Commodities Expense Changes: 42 Airport- Decrease Advertising, etc (59,945) -0.17% 43 BH County EMA- Increase Exp 175 0.00% 44 Building Inspections-Software 21,836 0.06% 45 Clerk Finance-Software, Misc 5,500 0.02% 46 Clerk Finance- Elections 60,000 0.17% 47 Cultural Arts-Decrease Utilities, Misc (16,800) -0.05% 48 Communications- Increase Newsletter 0 0.00% 49 Fairview Cemetery Association 10,000 0.03% 50 Fire- Decrease software, dispatch (1,148) 0.00% 51 Fire-Ambulance- Increase billing, training, repairs, equipment 766,950 2.17% 52 Garage- Utilities 160 0.00% 53 INRCOG Dues 685 0.00% 54 Leisure Services Golf- Decrease in Sales Tax (65) 0.00% 55 Leisure Golf Course Improvements Decrease (316) 0.00% 56 Leisure Sportsplex Decrease (11,897) -0.03% 57 Liability Insurance 195,200 0.55% 58 Library- Increase Grant Funded Expenses 2,200 0.01% 59 Mayor- Increase telephone 60 0.00% 60 MET- No change in Requested Funding 0 0.00% 61 Parking - Decrease Expenses (12,500) -0.04% 62 Planning-Software Expenses 45 0.00% 63 Police- Increase health services, uniforms, travel, misc 45,344 0.13% 64 Police- Increase for Axon contract 407,766 1.15% 65 Police- Increase Grant Expenses 137,469 0.39% 66 Police- Increase ATE Expenses 24,856 0.07% 67 Self Funded Workers Compensation 60,000 0.17% 68 Attorney- Decrease Expenses (40,000) -0.11% 69 Safety Committee- Decrease Expenses (2,500) -0.01% 70 Garage- Reduce Expenses (20,000) -0.06% 71 Leisure- Reduce Expenses (14,000) -0.04% 72 Mayor- Decrease Expenses (15,000) -0.04% 73 0.00% 74 0 0.00% 75 77 Subtotal -Contractual Services and Commodities Increases 1,544,075 4.37% 4,207,254 1.79426 Total all expense increases 78 JV KAUSERS\MICHELLE-MBudget FYE22\FY22 BUDGET_Proposed Revisions Print Copy.xlsx\Comparison to FYE21 Page 15 of 28 3/25/2021 3:51 PM Proposed Budget 3/25/21 A B C D E F G H I J K 2 City of Waterloo 3 FYE2022 General Fund 4 Proposed Budget Change In Cost From FY21 5 %of Total 6 Amount Change From 7 Prior Year Tax Levy 99 Revenue(Increase)/Decrease: 100 Airport- Decrease 15,710 0.04% 101 Building Inspection - Increase Dept Charges (233) 0.00% 102 Clerk/Finance- Decreases 154,393 0.45% 103 Cultural/Arts- Decreased Revenue 15,210 0.04% 104 Fire- Grant Increases (284,192) -0.80% 105 Fire Ambulance- Increases (1,350,500) -3.82% 106 Fire- Increased Revenue (2,938) -0.01% 107 Leisure Golf Course Improvements Decrease 316 0.00% 108 Leisure Services Golf- Decrease 1,003 0.00% 109 Library- Decrease Fine revenue 10,560 0.03% 110 Library Increase Grant Funding (4,274) -0.01% 111 MIS- Decrease 4,749 0.01% 112 Parking Revenue- Decrease 12,500 0.04% 113 Planning- Increase in Revenue (193,444) -0.55% 114 Police Operations Budget- Increased ATE revenue released to operations (407,766) -1.15% 115 Police-ATE Project Increased Revenue (945,498) -2.67% 116 Police-Amount of ATE released 920,642 2.60% 117 Police- Increase Grant Revenue (172,836) -0.49% 118 Public Access Fees 400 0.00% 119 Use of State Covid Money received in 2021 (1,600,155) -4.52% 121 Subtotal - Revenue Net(Increases) Decreases (3,826,353) -10.81% -1.63182 Total all revenue changes 127 Total Increases (Decreases) 380,901 1.18% 128 0.00% 129 Property Taxes Required (Excl Debt Service, Library Levy, 130 Grout Levy) 35,772,251 136 Total change in taxes-formula check 380,901 138 Variance- property taxes required 0 139 140 Increase in Debt Service Levy 386,055 141 Increase in Grout Taxes 2,931 142 Increase in Library Levy 2,931 143 144 Total Additional Taxes 772,818 1451 0 KAUSERS\MICHELLE-MBudget FYE22\FY22 BUDGET_Proposed Revisions Print Copy.xlsx\Comparison to FYE21 Page 16 of 28 3/25/2021 3:51 PM WATERLOO ■ ■ , BUDGET ■ ENDING 1 2022 Expenditures Expenditures Increase Increase FYE22 FYE21 (Decrease) (Decrease) General Fund Budget Including Employee Benefits $ 77,573,368 $ 74,456,145 4.19% $ 3,117,223 Other Operating Budgets $ 38,477,589 $ 37,487,903 2.64% $ 989,686 Capital Budget $ 76,035,125 $ 80,184,424 (5.17)% $ (4,149,299) Debt Service Budget $ 13,403,500 $ 13,157,973 1.87% $ 245,527 Total Budget-All Funds $ 205,489,582 $ 205,286,445 0.10% $ 203,137 City Property Tax Askings - General $ 36,405,357 $ 36,021,525 1.08% $ 383,832 City Property Tax Askings - Library Levy $ 633,106 $ 630,175 0.47% $ 2,931 City Property Tax Askings - Debt Service $ 7,602,100 $ 7,216,045 5.35% $ 386,055 City Property Tax Askings -Total $ 44,640,563 $ 43,867,745 1.76% $ 772,818 City Tax Rate $ 18.63188 $ 18.44026 1.04% $ 0.19162 Total Assessed Valuation - Excluding TIF $ 3,777,035,159 $ 3,763,924,237 0.35% $ 13,110,922 Total Taxable Valuation - Excluding TIF $ 2,344,836,606 $ 2,333,982,000 0.47% $ 10,854,606 Tax Increment Valuation (assessed) $ 317,411,512 $ 302,239,147 5.02% $ 15,172,365 City Taxes Impact Increase on Property Owners FYE22 FYE21 (Decrease) Residential 3.49% 1.68% 1.81% Commercial/Industrial 1.04% 5.08% (4.04)% Multi - Residential (4.28)% (4.42)% .14% Full-time Equivalent Budgeted 557.97 552.895 0.92% Positions Add 4 Fire Grant; 1 Chief of Staff; .08 Communications Manager FYE22 FYE21 General Levies General Levies Percentage of Property (Excluding Debt (Excluding Debt Increase Tax Funding Service Levy) Service Levy) (Decrease) Public Safety 83.23% 82.05% 1.18% Public Works 5.65% 5.33% 0.32% Health & Social Services 0.79% 0.79% 0.00% Culture & Recreation 16.92% 16.48% 0.44% Community& Economic Dev. 1.06% 1.55% (0.49)% General Government 2.03% -0.54% 2.57% Use of Fund Balance/state replacement funds -9.68% -5.66% 4.02% Total 100.00% 100.00% Michelle Weidner, CPA,Chief Financial Officer 1 319-291-4323 1 Michelle.Weidner@Waterloo-IA.org Page 17 of 28 Personnel Worksheet-FYE2022 Published Level Budget % =cell/formula override # =position in hiring process-to be filled before June 30,2021 @ =position already delayed in budget adjustments worksheet =info needs update,review or follow-up Current Potential 60 90 120 Current or Expected Employee Vacancies Vacancies Days Days Days Employee Name FY20 Position Subtotal Expected Expected Savings Savings Savings Savings Savings CLERK/FINANCE 010 03 8400 1 VACANT-JOB POSTED Fin.Analyst 129,539 129,539 21,294 31,941 42,588 # 1 TOTAL CLERK/FINANCE 129,539 129,539 - 21,294 31,941 42,588 MAYOR'S OFFICE 01001 8200 1 NEW POSITION REQUEST-FY22 Budget Chief of Staff 176,338 176,338 28,987 43,481 57,974 1 TOTAL MAYOR'S OFFICE 176,338 176,338 - 28,987 43,481 57,974 ADMINISTRATIVE SVCS/MIS 01001 8220 1 VACANT- GIS Coordinator/Anal 107,697 107,697 17,704 26,555 35,407 1 VACANT- POSITION POSTED Programmer/Analyst-[ 117,468 117,468 19,310 28,965 38,620 # 2 TOTAL ADMIN SVCS/MIS 225,165 225,165 - 37,014 55,520 74,027 CENTRAL GARAGE 010 18 7950 1 VACANT- Mechanic-2nd Shift 97,217 97,217 15,981 23,971 31,962 @ 1 TOTAL CENTRAL GARAGE 97,217 97,217 - 15,981 23,97LJ 31,962 FACILITIES MAINTENANCE 010 18 7950 1 VACANT- Mntc.Plumber 100,686 100,686 16,551 24,827 33,102 # 1 TOTAL CENTRAL GARAGE 100,686 100,686 - 16,551 24,827 1 33,102 �CULTURALARTS 010 18 7950 1 VACANT- Digital Arts Manager 61,040 61,040 10,034 15,051 20,068 1 TOTAL CULTURAL ARTS 61,040 61,040 - 10,034 15,051 20,068 77 LEISURE SERVICES-PARKS 010 37 4100 1 VACANT- Asst.Director 137,157 137,157 22,546 33,820 45,093 # 1 VACANT- PM II Forestry 93,065 93,065 15,298 22,948 30,597 @ 1 VACANT- PM II Forestry 93,065 93,065 1 15,298 1 22,948 1 30,597 3 TOTAL LEISURE SERVICES-PARKS 323,287 323,287 - 1 53,142 1 79,716 1 106,287 LEISURE SERVICES-GOLF 010 37 4125 1 VACANT- Golf Maint.11 98,024 98,024 16,114 24,170 32,227 1 POTENTIAL RETIREE(expected 1/1/2022)Golf Maint.III 104,252 52,126 8,569 12,853 17,137 1 VACANT- Golf Maint.11 98,024 98,024 16,114 24,170 32,227 3 TOTAL LEISURE SERVICES-GOLF 300,300 196,048 52,126 40,797 61,193 81,591 LEISURE SERVICES-SPORTSPLEX 010 37 4180 0.65 VACANT-JOB POSTED Member Svcs Special 62,058 62,058 10,201 15,302 20,403 # 0.65 TOTAL LEISURE SERVICES-SPORTSPLEX 62,0581 62,058 - 10,201 15,302 20,403 LEISURE SERVICES-SPORTS 1010374200 0.35 VACANT-JOB POSTED Member Svcs Special 44,340 44,340 7,289 10,933 14,578 # 0.35 TOTAL LEISURE SERVICES-SPORTS 44,3401 44,340 7,289 10,933 14,578 LIBRARY-GENERAL 010 33 3100 0.69 VACANT- Community Outreach 78,727 78,727 12,941 19,412 25,883 0.51 VACANT-(75%) Libr.Asst.-PT 30,451 30,451 5,006 7,508 10,011 0.35 VACANT(50%) Libr.Asst.-PT 21,011 21,011 3,454 5,181 6,908 1.55 TOTAL LIBRARY SERVICES 130,189 130,189 - 21,401 32,101 42,802 LIBRARY TAX LEVY 204 33 3100 0.31 VACANT- Community Outreach 35,369 35,369 5,814 8,721 11,628 0.22 VACANT-(75%) Libr.Asst.-PT 13,680 13,680 2,249 3,373 4,498 K1USERS\MICHELLE-MBudget FYE22\Personnel Worksheets FYE22_Published MayonProposed.xlsx Rage 4:8 of 28 Personnel Worksheet-FYE2022 Published Level Budget Current Potential 60 90 120 Current or Expected Employee Vacancies Vacancies Days Days Days Employee Name FY20 Position Subtotal Expected Expected Savings Savings Savings Savings Savings 0.16 VACANT(50%) Libr.Asst.-PT 9,208 9,208 1,514 2,270 3,027 0.69 TOTAL LIBRARY TAX LEVY 58,257 58,257 - 9,577 14,364 19,153 POLICE DEPARTMENT 01011 1100 1 POT VACANT(anticipated 1/10/22) 1st Yr Officer 98,025 40,844 6,714 10,071 13,428 1 POT VACANT(anticipated 4/19/22) Captain 172,994 16,338 16,338 16,338 16,338 % 1 VACANT- Clerk) 87,021 87,021 14,305 21,457 28,610 1 POT VACANT(anticipated 7/12/21) Sergeant-L1 129,588 118,789 16,114 24,171 32,227 1 POT VACANT(anticipated 3/28/22) Sergeant-1-1 129,588 32,397 16,114 24,171 24,171 1 POT VACANT(anticipated 8/7/21) 1st Yr Officer 98,025 81,688 13,428 20,142 26,856 1 VACANT- 1st Yr Officer 98,025 98,025 16,114 24,171 32,227 1 POT VACANT(anticipated 6/29/21) 1st Yr Officer 98,025 98,025 16,114 24,171 32,227 1 POT VACANT(anticipated 4/19/22) 1st Yr Officer 98,025 16,338 16,338 16,338 16,338 1 VACANT-(scheduled 3/26/21) 1 st Yr Officer 98,025 98,025 16,114 24,171 32,227 10 TOTAL POLICE DEPARTMENT 1,107,341 283,071 404,419 147,693 205,201 254,649 FIRE RESCUE 010 12 1400 1 Knox,Matthew J.-potential retiree FY22 8th Yr.FF 114,264 91,551 15,049 22,574 30,099 # 1 VACANT- calc at first year Fire Marshal 144,482 91,551 15,049 22,574 30,099 % 1 VACANT- calc at first year Fire LT. 10 Yr.-24 Hr. 126,130 91,551 15,049 22,574 30,099 % 1 POT VACANT(anticipated 3/1/22) Fire LT. 10 Yr.-24 Hr. 126,130 42,043 6,911 10,367 13,822 % 4 TOTAL FIRE/RESCUE 511,006 91,551 225,145 52,058 78,089 104,119 AMBULANCE 010 12 1410 1 POT VACANT(anticipated 1/1/22) 8th Yr.PM 122,953 51,230 8,421 12,632 16,843 1 TOTAL AMBULANCE 122,953 - 51,230 8,421 12,632 16,843 ENGINEERING-SALES TAX 205 07 7830 1 VACANT- Eng.Tech. 97,925 97,925 16,097 24,146 32,195 1 TOTAL ENG.SALES TAX LOCAL#177 97,925 97,925 - 16,097 24,146 32,195 ENGINEERING-ROAD USE 266 07 7830 1 VACANT- Assoc.Engineer-L3 114,707 114,707 18,856 28,284 37,712 1 TOTAL ENGINEERING-RUT 114,707 114,707 - 18,856 28,284 37,712 TRAFFIC OPERATIONS-RUT 266 17 7120 0.93 POT VACANT-(anticipated 12/31/21) Superintendent 112,466 56,233 9,244 13,866 18,488 0.93 TOTAL TRAFFIC OPERATIONS-RUT 112,466 56,233 9,244 13,866 18,488 TRAFFIC-ANIMAL CONTROL(SANITATIC 525 17 2400 0.07 POT VACANT-(anticipated 12/31/21) Superintendent 8,466 4,233 696 1,044 1,392 0.48 VACANT- Animal Control Office) 20,003 20,003 3,288 4,932 6,576 0.55 TOTAL ANIMAL CONTROL 28,469 20,003 4,233 3,984 5,976 7,968 STREET CLEANING-STORM WATER 283 13 5452 1 VACANT- EO2 93,849 93,849 15,427 23,141 30,854 11 TOTAL STREET CLEANING-STORM WATER 93,849 93,849 - 15,427 23,141 30,854 WASTE MGMT-SANITATION 525 14 5400 1 POT VACANT-(anticipated 12/31/21) Adm.Secretary 88,293 44,147 1 7,257 1 10,886 1 14,514 1 VACANT- Solid Waste Technici, 93,166 93,166 15,315 22,972 30,630 # 1 VACANT- Solid Waste Technicit 93,166 93,166 15,315 22,972 30,630 # 1 POT VACANT-(anticipated 7/31/21) Solid Waste Technick93,065 85,310 14,024 21,035 28,047 4 TOTAL WATER POLLUTION CONTROL 367,690 186,332 129,457 51,911 77,865 103,821 WASTE MGMT-WATER POLLUTION 520 14 5200 K:\USERS\MICHELLE-W\Budget FYE22\Personnel Worksheets FYE22_Published Mayo2Proposed.x1sx Rage 4:9 of 28 Personnel Worksheet-FYE2022 Published Level Budget Current Potential 60 90 120 Current or Expected Employee Vacancies Vacancies Days Days Days Employee Name FY20 Position Subtotal Expected Expected Savings Savings Savings Savings Savings 1 VACANT- Director 170,032 170,032 27,950 41,926 55,901 1 POT VACANT-(anticipated 4/1/22) Operations Superviso 139,016 34,754 5,713 8,569 11,426 1 VACANT- Waste Water Operatc 93,801 93,801 15,419 23,129 30,839 1 POT VACANT-(anticipated 4/1/21) Waste Water Operatc 93,801 93,801 15,419 23,129 30,839 1 POT VACANT-(anticipated 4/1/21) Mechanic 97,326 97,326 15,999 23,998 31,998 1 POT VACANT-(anticipated 4/1/22) Instrument Tech. 97,326 24,332 4,000 6,000 8,000 1 VACANT- Sewer Mntc. 93,065 93,065 15,298 22,948 30,597 7 TOTAL WATER POLLUTION CONTROL 784,367 356,898 250,213 99,798 1 149,699 199,600 WASTE MGMT-STORM SEWER MTCE 521 145310 1 VACANT- Sewer Mntc. 93,065 93,065 15,298 22,948 30,597 1 POT VACANT-(anticipated 4/1/22) Sewer Mntc. 93,065 23,266 3,825 5,737 7,649 2 TOTAL STORM SEWER MAINTENANCE 186,130 93,065 23,266 19,123 28,685 38,246 47.72 GRAND TOTALS TOTALS BY FUND: 29.55 General Fund 1,744,191 732,920 441,876 646,477 843,019 0.69 Special Library Levy Fund 58,257 - 9,577 14,364 19,153 1.00 Local Option Sales Tax 97,925 - 16,097 24,146 32,195 1.93 Road Use 114,707 56,233 28,100 42,150 56,200 - Comm Development Block Grant - - - - - Housing Programs - - - - - 7.00 Sanitary Sewer Fund 449,963 273,479 118,921 178,384 237,846 3.00 Storm Water Fund 93,849 - 15,427 23,141 30,854 4.55 Sanitation Fund 206,335 133,690 55,895 83,841 111,789 47.72 2,765,227 1,196,322 685,893 1,012,503 1,331,056 GENERAL FUND OPTIONS: Remove positions already in hiring process 1,152,943 732,920 344,685 500,689 648,635 Remove positions already listed as delayed in budget adjustments worksheet 962,661 732,920 313,406 453,770 586,076 Don't fill Chief of Staff position and delay remaining positions listed above 962,661 732,920 518,731 673,589 820,388 Don't add new Natural Resources Technician position 81,291 81,291 81,291 81,291 81,291 FURLOUGHS: 1 Day 2 Days 3 Days 4 Days 5 Days Furloughs-General Fund 109,397 218,794 1 328,191 437,588 546,985 This calculation includes the elected officials-research needs to be done to determine whether that can be applied to elected officials This calculations include salaried emplloyees-research needs to be done to determine whether that can be done for periods less than one week K:\USERS\MICHELLE-W\Budget FYE22\Personnel Worksheets FYE22_Published MayoriProposed.xlsx Rage 12:01 of 28 3/25/20212:59 PM FYE2022 Budget General Fund Staff Requests with Changes as of March 24,2021 Expenses Revenue Addition (Addition) (Reduction) Reduction Fairview Expense Adjustments Fairview Revenue Adjustments 1393 Contributions (10,000.00) (Decr)/Incr Expenses (10,000.00) (Decr)/Incr Revenue MET Expense Adjustments MET Revenue Adjustments 1393 Contributions (43,877.00) (Decr)/Incr Expenses (43,877.00) (Decr)/Incr Revenue Mayor Expense Adjustments Mayor Revenue Adjustments 1344 Telephone 1390 Other Contractual (15,000.00) 8280-Communications 1335 Public Info (5,000.00) (Decr)/Incr Expenses (20,000.00) (Decr)/Incr Revenue Finance Expense Adjustments Finance Revenue Adjustments 1520 Computer Software 1,600,000.00 1780 Election Costs 1111 Salaries (15,000.00) 1319 Prof Fees (11,500.00) (Decr)/Incr Expenses (26,500.00) (Decr)/Incr Revenue 1,600,000.00 Planning Expense Requests Planning Revenue Adjustments 1319 Other Prof Sery 3620 Rent 1520 Software 3622 Sale of Property (Decr)/Incr Expenses (Decr)/Incr Revenue City Attorney Expense Adjustments City Attorney Revenue Adjustments 1317 Legal Fees (40,000.00) (Decr)/Incr Expenses (40,000.00) (Decr)/Incr Revenue K:\USERS\MICHELLE-W\Budget FYE22\Breakout of Staff Budget Requests with ChangesRAt6211x6f 28 Adj V 3 Corr Page 1 of 4 3/25/20212:59 PM FYE2022 Budget General Fund Staff Requests with Changes as of March 24,2021 Expenses Revenue Addition (Addition) (Reduction) Reduction Police Expense Adjustments Police Revenue Adjustments 1100 1128 Retirement Pay-outs (23,590.00) 1314 Health Services 1345 Travel 1346 Training 1377 Radio Maintenance 1390 Other Contractual 1579 Uniforms 1319 Other Prof (4,000.00) 1325 Crime Prevention (500.00) 1344 Telephone (3,100.00) 1352 Photocopies (500.00) 1579 New Uniforms for all 78,440.00 3.34527465 (78,440.00) 1105 1321 Data Processing 1520 Computer Software (Decr)/Incr Expenses (31,690.00) (Decr)/Incr Revenue Fire Expense Requests Fire Revenue Adjustments 1400 1400 1130 Empl Benefit Reimb 3416 Commercial Fire 1377 Radio Repair 3721 Service Charges 1390 Other Contractual 3515 False Alarms 1520 Computer Software 1344 Phone (1,000.00) OT was incr for FYE20 to keep 1114 Overtime (78,000.00) station 6 open. Reduce due to SAFER grant 1410 1410 1116 Holiday Bonus 3414 Ambulance Fee 100,000.00 1130 Empl Benefit Reimb 3721 Service Charges - 1311 Accounting Software 1315 Educational Training 1319 Other Prof Services 1378 Other Equip Repair 1390 Other Contractual K:\USERS\MICHELLE-W\Budget FYE22\Breakout of Staff Budget Requests with ChangesRAt6212KO 28 Adj V 3 Corr Page 2 of 4 3/25/20212:59 PM FYE2022 Budget General Fund Staff Requests with Changes as of March 24,2021 Expenses Revenue Addition (Addition) (Reduction) Reduction 1391 Dues&Memberships 1551 Drugs,medicine supplies 1785 Refunds 2116 Medical/Lab Equipment 1344 Telephone (1,000.00) 1114 Overtime (18,000.00) 2116 Remove equipment purchases (100,000.00) (Decr)/Incr Expenses (198,000.00) (Decr)/Incr Revenue 100,000.00 Garage Fire/Ambulance Expense Adjustments Garage Revenue Adjustments 1500 Parts (20,000.00) (Decr)/Incr Expenses (20,000.00) (Decr)/Incr Revenue - Garage Expense Adjustments Garage Revenue Adjustments 1100's Personnel (97,217.00) (Decr)/Incr Expenses (97,217.00) (Decr)/Incr Revenue Safety Committee Expense Adjustments Safety Committee Revenue Adjustments 1315 Training Materials (2,500.00) (Decr)/Incr Expenses (2,500.00) (Decr)/Incr Revenue Airport Expense Adjustments Airport Revenue Adjustments 1328 Retirement Pay-outs (9,754.96) 1569 Vehicle Parts 1571 Machinery Parts CARES Act revenue (100,596.04) Bring tax levy to zero (Decr)/Incr Expenses (110,351.00) (Decr)/Incr Revenue Cultural&Arts Expense Adj Cultural&Arts Revenue Adjustments 1112 P-T Salaries (1,560.00) 10 to 11 Wed-Fri-Members Only Access 1112 P-T Salaries (3,120.00) Open reception Desk at 11 instead of 10 am Tues-Fri 3620 Add Rent from World's Window 1,200.00 (Decr)/Incr Expenses (4,680.00) (Decr)/Incr Revenue 1,200.00 K:\USERS\MICHELLE-W\Budget FYE22\Breakout of Staff Budget Requests with ChangesRAt62&6f 28 Adj V 3 Corr Page 3 of 4 3/25/20212:59 PM FYE2022 Budget General Fund Staff Requests with Changes as of March 24,2021 Expenses Revenue Addition (Addition) (Reduction) Reduction Library Expense Adjustments Library Revenue Adjustments Salaries 3100 Materials 3470 Library Fees (Decr)/Incr Expenses (Decr)/Incr Revenue Leisure Expense Adjustments Leisure Revenue Adjustments 4100-Parks 1111 Delay hiring one Forestry positior (13,368.00) 1111 Salary savings-Reorganization (14,480.00) 1533 Fuel (3,000.00) 4110-Downtown Area Maintenance 1371 (4,000.00) 4120-Golf Golf 1300's (4,000.00) 3472 Golf Revenue - 4200-Sports 1300's (3,000.00) (Decr)/Incr Expenses (41,848.00) (Decr)/Incr Revenue 0.01 Totals General Fund (646,663.00) 1,701,200.01 General Fund Combined Revenue and Expense Changes (2,347,863.01) Residential Commercial Tax Rate Increase Increase Total Changes from Above (2,347,863.01) 18.88182 4.88% 2.39% Add Hiring Delays 120 days (586,076.00) Total Reductions (2,933,939.01) 18.63188 3.49% 1.04% K:\USERS\MICHELLE-W\Budget FYE22\Breakout of Staff Budget Requests with ChangesRAt6214x6f 28 Adj V 3 Corr Page 4 of 4 KELLEY FELCHLE From: LEANN EVEN Sent: Thursday, March 25, 2021 1:43 PM To: KELLEY FELCHLE Subject: FW: Public Comment- Tonight -----Original Message----- From: Bill Kammeyer <bgkmeyer@hotmail.com> Sent: Thursday, March 25, 2021 12:47 PM To: LEANN EVEN <LEANN.EVEN@WATERLOO-IA.ORG> Subject: Public Comment- Tonight Please confirm receipt. I will not be able to attend tonight's public forum on the city budget nor can I use zoom. Please read my comments at tonight's meeting so that council and the public can hear: Good evening council, I am not able to attend tonight as I'm still being careful with COVID. I am watching on TV, however. I am very concerned with this budget for many reasons but most of all because of the enormous expense being requested by the mayor for a chief of staff. In all my years in Waterloo I have never seen such an absurd budget request. We pay the mayor a great salary, and just gave him a raise. At a time when taxes in Waterloo are again going up and many are suffering due to the pandemic I find it insulting for council to approve such a request. To me this position is saying that the mayor needs help with his job. I appreciate the honesty but putting an additional expense on the taxpayers is not the answer. 1 ask you to search your hearts tonight and really think before approving this. Approving such a frivolous expense is a slap in the face to every city department that has requested and been denied additional staff and more importantly a slap in the face to the taxpayers who will foot the bill. I am no longer concerned for myself rather my children and grandchildren. The bright young minds of Waterloo have little incentive to stay in the city when taxes go up year after year and all we have to show for it is a fancy assistant for the mayor. Please amend this budget and remove this position. Bill Kammeyer 526 Home Park Blvd Waterloo, IA 50701 i Page 25 of 26�) KELLEY FELCHLE From: Agnes Kress Sent: Thursday, March 25, 2021 11:28 AM To: Kendra Wyatt; KELLEY FELCHLE Subject: FW: FW: Website Contact Request Please see below website comment form. Agnes From: Agnes Kress Sent:Thursday, March 25, 202111:28 AM To: 'Dorothy Wright'<dorothywright112@gmail.com> Subject: RE: FW: Website Contact Request Thank you Dorothy- I will forward your message onto the Mayor's office and also the City Clerk. Agnes From: Dorothy Wright<dorothywright112@gmail.com> Sent:Thursday, March 25,202111:24 AM To:Agnes Kress<Agnes.Kress@WATERLOO-IA.ORG> Subject: Re: FW: Website Contact Request Yes!I just wanted to voice my concern about hiring an executive assistant for the mayor. On Thu, Mar 25, 2021 at 11:13 AM Agnes Kress <Agnes.Kressgwaterloo-ia.org> wrote: Good afternoon Dorothy- There was no comments in your form that was submitted. Is there something I can help you with? Agnes Kress Digital Production Assistant GtV of Waterloo • 715 Mulberry Street •Waterloo, Iowa 50703 CAN: 319.291.4568 Asia 1 Page 26 of 28 From: noreply@revize.com <noreply@revize.com> Sent:Wednesday, March 24, 20215:40 PM To: Subscribers<subscribers@waterloo-ia.org> Subject:Website Contact Request Name = Dorothy Wright Address = 4750 Clover Lane City Town= Waterloo Stat Prov= IA Phone = 3192361103 Email = dorothywri hg tl 12@gmail.com Comments= Client IP = 173.16.207.143 2 Page 27 of 28 KELLEY FELCHLE From: Don Miller <tcydb22@yahoo.com> Sent: Thursday, March 25, 2021 1:51 PM To: KELLEY FELCHLE Subject: Comment for tonights council meeting request that this statement be read at the March 25, 2021 council meeting. Thank you. Don Miller 707 Stone Quarry Rd. 319-234-4176 Mr. Mayor and Councilmembers, I favor retaining the director of administrative services funding for only one reason: it is the nascent step that should conclude with the city adopting the council/manager form of city government, also referred to as council/administrator form. The information I have found places Waterloo, previously in fifth place, in ninth place as Iowa's most populous city. There are many reasons for this decline; however, one stands above the others: our form of city government. The eight more populated cities have one significant advantage: Council/Manager governing structure. The significant advantage is that the elected council hires a college/university educated, work experience individual to manage the cities' day-to-day machinery efficiently. Efficiency equals money saved, and studies show council/manager cities operate more efficiently. The city manager serves at the council's pleasure. The manager is responsible for presenting the council with the city budget for their alteration/approval. On March 11, 2021, 1 contacted the city clerks in the following cities with this question " On what date was the budget presented for council consideration?"The replies were: Davenport-Jan. 16, Ankeny-Jan. 22, Des Moines- Feb. 3, Cedar Rapids- Feb. 8, Ames - Feb. 23. Waterloo, not yet. There are too many advantages to council/manager government to discuss here; however, I urge our mayor and council to engage the mayors and councils of the eight cities in conference to learn their experiences, appraisal, and recommendations. The wheel has been invented. We need to attach it. Respectfully, Don Miller i Page 28 of 28 Motion to Amend Motion to Amend: Resolution approving the FYE 2022 Budget with a total tax levy rate of 18.65409 and property tax askings in the amount of $44,693,610. These are my changes to the 5 page Document entitled " General Fund Staff Requests with Changes as of March 15,2021" I am working off everything above and pages before the 18.91507 Tax Rate. #1.) Mayor Department: Activity 8200 Additional Cut of$211,000: $176,000 from lines 1111 thru 1131 and another $35,000 from line 1390 #2.)Finance: a.) add an additional $150,000 from Co-vid 19 American Rescue Act Funds to total $1,750,000 b.) add $50,000 more to revenue from General Fund Balance-Total $800,000 C.) #3.) Police: a.) move uniforms $78,440 to be paid out of CIP b.) cut additional $94,500 from Total Budget amount Fire: Cut additional $89,000 from total Budget #4.) Garage: Add back in the Mechanic Loss at$48,608 into General Revenue Budget and $48,608 into either Road Use or Local Option Sales Tax #5.) Leisure: Delete the Delay in Hiring of the Forestry Worker at $13,368 SUMMARY Cuts of: $211,000 Mayor $94,500 Police $78,440 Police Uniforms moved to CIP $89,000 Fire $48,608 to RUT or LOST for part of pay for Garage Mechanic Total $ in Cuts = $521,548 Revenue Additions of: $150,000 expected use of American Rescue Act Funds $50,000 additional Fund Balance Total added Revenue= $200,000 Cuts and Revenue= $721,548 Put Backs into Budget Expense: $97,217 for Garage Mechanic $13,368 by deleting Hiring Delay for Leisure Forestry Total= $110,585 REVENUE/CUTS minus PUT BACKS = $610,963 = @.26056 Rate Tax Rate adjustment: from 18.91507 Tax Rate to 18.65409 IA-03 State and Local Government Aid in the American Rescue Plan The American Rescue Plan provides a total of$360 billion of direct aid to state, local, tribal, and territorial governments. Allocations; • $195.3 billion for state (and DC)governments. o Iowa is estimated to receive $1.39 billion here, which is allocated based on a state's share of unemployed people. o Funds can be used for COVID costs, economic recovery, loss of revenue, or infrastructure, but can NOT be used to offset state action to cut taxes or be deposited in pension funds. • $130.2 billion for local governments, evenly divided between Cities and Counties. $65.1 billion for counties is allocated based on population. o $65.1 billion for cities using a modified Community Development Block Grant(CDBG) formula. $45.6 billion is for cities above 50,000 people, $19.5 billion for smaller cities. o Iowa's counties are expected to get $612 million, larger cities $335 million, and smaller cities $216 million. For example, Des Moines projects for $95 million. o Smaller cities cannot receive more than 75% of their most recent budget as of 1/27/2020(and excess funds revert to Treasury). • $10 billion to States for Capital Projects, focused on infrastructure directly enabling work, education, and health monitoring. Each state gets at least $100m, with additional funding allocated based on population, rural population, and population below 150% of the poverty line. Iowa should receive another$150m here. Process: • States, all Counties, and larger cities will receive their funds directly from the Treasury Dept. • Smaller Cities will get funds through the State, but will have a dedicated allocation. • States must certify their need for the funds and that they'll use the funds for approved purposes. • Treasury will distribute funds within 60 days of receiving that certification, or for local governments, the first tranche within 60 days of enactment. o For local governments, funds will be split in two equal tranches,with the second to follow 12 months later. o For smaller cities, the State should receive funds from Treasury within 60 days, then has 30 days to distribute to the cities(with some ability to extend that if the timeline is unworkable). • Reporting requirements to Treasury, and recoupment if funds are not used properly do apply. Use of Funds: • Funds can be used for COVED costs, economic recovery, loss of revenue, premium pay for essential workers, or infrastructure, but cannot be deposited in pension funds. In addition, State funds cannot be used to offset lower taxes through either law or administrative action. • Governments will have some transfer authority with nonprofits, public benefit corporations, or special purpose governments(and local governments can, but do not have to, transfer funds to the state).