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/22/2021
COUNCIL WORK SESSION March 22, 2021 Time indicated below Meeting will be held virtually via Zoom. Visit https://cityofwaterlooiowa.coni/register and register to receive the Zoom meeting information. Please contact the City Clerk's Office at 319-291-4323 with questions. 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 https://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. RULES FOR WORK SESSION PUBLIC COMMENT 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 city council shall not receive any public comment during a work session. Roll Call Agenda, as proposed or amended Approval of Minutes Minutes of March 15, 2021, as proposed. Motion approving Change Orders 6, 7, 8 and 9 from Cardinal Construction of Waterloo, Iowa for an increase of$20,755, in conjunction with the Five Sullivan Brothers Convention Center Addition and Lobby Renovation Project, and authorizing the Mayor to execute said documents. 5:30 p.m. Discussion of the Capital Improvements Plan. Submitted By:Noel Anderson,Community Planning and Development Director Approx. Discussion of the FYE2022 budget. 6:00 p.m. Submitted By:Michelle Weidner,Chief Financial Officer ADJOURNMENT Kelley Felchle City Clerk CITY OF WATERLOO Council Communication Minutes of March 15, 2021, as proposed. City Council Meeting: 3/22/2021 Prepared: REVIEWERS: Department Reviewer Action Date Clerk Office Higby, Nancy Approved 3/19/2021 - 11:20 AM ATTACHMENTS: Description Type ❑ Minutes of March 15, 2021 Backup Material COUNCIL WORK SESSION March 15, 2021 3:45 p.m. Meeting was held via Zoom. Members present: Boesen, Amos, Morrissey, Klein, Feuss, Grieder, and Juon. 159627 -Juon/Feuss that the Agenda, as proposed, be approved. Voice-vote Ayes: Six. Motion carried. 159628 -Juon/Feuss that the Minutes of March 1, 2021, as proposed, be approved. Voice-vote Ayes: Six. Motion carried. Mr. Amos joined at 3:52 p.m. Objective: Discussion on the Dunsmore House. Noel Anderson, Community Planning and Development Director, provided an overview of the Dunsmore House. Mardy Holst, Align Architecture and Planning, provided an overview of options for repairing the historic home and the potential uses for the site. These options included converting the structure to a small office, a home, a short-term rental like an Air B&B, and a museum. City council members and Mayor Hart discussed the options with Noel Anderson, Mr. Holst, and Billie Bailey with the Grout Museum. Council discussed going through an RFP/RFQ process to find someone interested in a private-public partnership to fix up the house that fits with one of the uses outlined by Mr. Holst. Objective: Discussion of the FYE2022 budget. Michelle Weidner, Chief Financial Officer,discussed options for the FYE2022 budget proposals with Mayor Hart and City Council members. 159629 -Juon/Grieder that the meeting be adjourned at 4:59 p.m. Voice-vote Ayes: Seven. Motion carried. Kelley Felchle City Clerk CITY OF WATERLOO Council Communication Motion approving Change Orders 6, 7, 8 and 9 from Cardinal Construction of Waterloo, Iowa for an increase of$20,755, in conjunction with the Five Sullivan Brothers Convention Center Addition and Lobby Renovation Project, and authorizing the Mayor to execute said documents. City Council Meeting: 3/22/2021 Prepared: 3/19/2021 REVIEWERS: Department Reviewer Action Date Clerk Office Higby, Nancy Approved 3/19/2021 - 12:14 PM ATTACHMENTS: Description Type Convention Center Addition and Lobby Change Orders Backup Material 6 thru 9 Motion approving Change Orders 6, 7, 8 and 9 from Cardinal Construction of Waterloo, Iowa for an increase of$20,755, in SUBJECT: conjunction with the Five Sullivan Brothers Convention Center Addition and Lobby Renovation Project, and authorizing the Mayor to execute said documents. Submitted by: Submitted By:Michelle Weidnerr, Chief Financial Officer Recommended Action: The contractor is making good progress with the lobby renovation and addition project. We have identified a few things that were not included in the contractor's original bid for the work that need to be completed. One of these is a critical item to be able to obtain Summary Statement: temporary occupancy for scheduled events so that the new ceiling allows the dividing walls in the first floor meeting rooms to work properly. We also need additional coiling doors for the addition to meet building codes. There are a few more old items that need to be demolished as well. Expenditure Required: Source of Funds: Policy Issue: Alternative: Background Information: - o Doc �J� nent0701 200 7 Change Order PROJECT: (Name and address) CONTRACT INFORMATION : CHANGE ORDER INFORMATION : Five Sullivan Brothers Convention Center Contract For: General Construction Change Order Number: 006 Addition and Renovation, Waterloo, IA. Project No : 20-23943 Date : September 08, 2020 Date: March 5, 2021 OWNER: (Name and address) ARCHITECT: (Name and address) CONTRACTOR: (Name and address) City of Waterloo I & S Group, Inc. (ISG) Cardinal Construction, Inc. 715 Mulbei7y Street 314 East 4th Street 1246 Martin Road Waterloo, IA 50703 Waterloo, IA 50703 Waterloo, IA 50701 THE CONTRACT IS CHANGED AS FOLLOWS: (Insert a detailed description of the change and, if applicable, attach or reference specific exhibits. Also include agreed upon adjustments attributable to executed Construction Change Directives.) A. COR 06 : Demo of two drain lines and plumbing for second floor drinking fountain that were inside of masonry walls called for demo (per PR 09)000 0 & 4 00 0 0 * & * & * 0 0 * 0 0 0 0 0 06 0 * 4 * * 0 * a 00 # a 0 & 4 * 0 1 6 00 0 0 * a 0 Add $795.00 TOTAL AMOUNT OF THIS CHANGE ORDER, ADD TO CONTRACT SUM $795 .00 . The original Contract Sum was $ 5,5161300.00 The net change by previously authorized Change Orders $ 1105629.06 The Contract Sum prior to this Change Order was $ 516267929.06 The Contract Sum will be increased by this Change Order in the amount of $ 795.00 The new Contract Sum including this Change Order will be $ 5,627,724.06 The Contract Time will be unchanged by Zero (0) days. The new date of Substantial Completion will be August 13 , 2021 , NOTE. This Change Order does not include adjustments to the Contract Sum or Guaranteed Maximum Price, or the Contract Time, that have been authorized by Construction Change Directive until the cost and time have been agreed upon by both the Owner and Contractor, in which case a Change Order is executed to supersede the Construction Change Directive. NOT VALID UNTIL SIGNED BY THE ARCHITECT, CONTRACTOR AND OWNER, I & S Group, Inc. (ISG) Cardinal Construction, Inc. City of Waterloo ARCRCH�ITTEECT (Firm name) I ACTOR (Firm name) OWNER (Finn name) /G - — SIGNATURE S ATURE SIGNATURE Nathan Compton, Architect Katy Susong, President Quentin Hart, Mayor PRINTED NAME AND TITLE PRINTED NAME AND TITLE PRINTED NAME AND TITLE March 5, 2021 March 8 , 2021 DATE DATE DATE AIA Document G701 " — 2017. Copyright © 1979, 19873 2000 , 2001 and 2017 by The American Institute of Architects. All rights reserved. The "American Institute of Architects," "AIA," the AIA Logo, and 'AIA Contract Documents" are registered trademarks and may not be used without permission. This document was produced by AIA software at 15:05:41 ET on 03/05/2021 under Order No.8114132283 which expires on 07/12/2021 , is not for resale, is licensed for one-time use only, and may only be used In accordance with the AIA Contract Documents® Terms of Service. To report copyright violations, e-mail copyright@aia.org. User Notes: (3139ADAM) A � .NDoc rf o ern ®r 701 r r 2017 Change Order PROJECT: (Name and address) CONTRACT INFORMATION : CHANGE ORDER INFORMATION : Five Sullivan Brothers Convention Center Contract For: General Construction Change Order Number: 007 Addition and Renovation, Waterloo, IA. Project No : 20-23943 Date: September 08, 2020 Date: March 8 , 2021 OWNER: (Name and address) ARCHITECT: (Name and address) CONTRACTOR: (Nanne and address) City of Waterloo I & S Group, Inc. (ISG) Cardinal Construction, Inc. 715 Mulberry Street 314 East 4th Street 1246 Martin Road Waterloo, IA 50703 Waterloo, IA 50703 Waterloo, IA 50701 THE CONTRACT IS CHANGED AS FOLLOWS: (Insert a detailed description of the change and, if applicable, attach or reference specific exhibits. Also include agreed upon adjustments attributable to executed Construction Change Directives.) A. COR 07 : Cost for addition coiling fire doors for the project, . . . . . . . . . . . . 4664 61 * 6 * 0401002 @@ * @too Add $ 12 ,546. 00 Note: Part of this cast will be paid by ISG, amount yet to be determined TOTAL AMOUNT OF THIS CHANGE ORDER, ADD TO CONTRACT SUM $12,546.00. The original Contract Sum was $ 5,516,300.00 The net change by previously authorized Change Orders $ 1115424.06 The Contract Sum prior to this Change Order was $ 5,6275724.06 The Contract Sum will be increased by this Change Order in the amount of $ 12,546.00 The new Contract Sum including this Change Order will be $ 5,640,270.06 The Contract Time will be unchanged by Zero (0) days. The new date of Substantial Completion will be August 13 , 2021 . NOTE: This Change Order does not include adjustments to the Contract Sum or Guaranteed Maximum Price, or the Contract Time, that have been authorized by Construction Change Directive until the cost and time have been agreed upon by both the Owner and Contractor, in which case a Change Order is executed to supersede the Construction Change Directive. NOT VALID UNTIL SIGNED BY THE ARCHITECT, CONTRACTOR AND OWNER. I & S Group, Inc. (ISG) C dint Construction, Inc. City of Waterloo ARCHITECT (Finn name) C ACTOR (Firm name) OWNER (Finn name) �� . SIGNATURE SIG TURE SIGNATURE Nathan Compton, Architect Katy Susong, President Quentin Hart, Mayor PRINTED NAME AND TITLE PRINTED NAME AND TITLE PRINTED NAME AND TITLE March 8, 2021 March 8 , 2021 DATE DATE DATE AIA Document G701 '" — 2017. Copyright © 1979, 1987, 2000 , 2001 and 2017 by The American Institute of Architects. All rights reserved. The "American Institute of Architects, "AIA," the AIA Logo, and "AIA Contract Documents" are registered trademarks and may not be used without permission. This document was produced by AIA software at 12:31 :47 ET on 03/08/2021 under Order No.8114132283 which expires on 07/12/2021 , is not for resale, is licensed for one-time use only, and may only be used in accordance with the AIA Contract Documents® Terms of Service. To report copyright violations, e-mail copyright@aia.org. User Notes: (3B9ADA3F) � � � � 7 o Document U701 L� Change Order PROJECT: (Name and address) CONTRACT INFORMATION : CHANGE ORDER INFORMATION : Five Sullivan Brothers Convention Center Contract For: General Construction Change Order Number: 008 Addition and Renovation, Waterloo, IA. Project No : 20-23943 Date: September 08 , 2020 Date: March 10, 2021 OWNER: (Name and address) ARCHITECT: (Naine and address) CONTRACTOR: (Nanne and address) City of Waterloo I & S Group, Inc. (ISG) Cardinal Construction, Inc. 715 Mulberry Street 314 East 4th Street 1246 Martin Road Waterloo, IA 50703 Waterloo, IA 50703 Waterloo, IA 50701 THE CONTRACT IS CHANGED AS FOLLOWS : (Insert a detailed description of the change and, if applicahle, attach or reference specie exhibits. AZso include agreed upon adjustments attributable to executed Construction Change Directives.) A . Per ASI 004 : Costs associated with added ceiling trim for lowered ceiling heights. . . . . . . . . . . . . . . . . . . . . . . . . Add $3 ,313 . 00 TOTAL AMOUNT OF THIS CHANGE ORDER, ADD TO CONTRACT SUM $3,313 .00 . The original Contract Sum was $ 5,5161300.00 The net change by previously authorized Change Orders $ 123 ,970 .06 The Contract Sum prior to this Change Order was $ 556403270.06 The Contract Sum will be increased by this Change Order in the amount of $ 31313 .00 The new Contract Sum including this Change Order will be $ 5,6435583 .06 The Contract Time will be unchanged by Zero (0) days. The new date of Substantial Completion will be August 13 , 2021 . NOTE: This Change Order does not include adjustments to the Contract Sum or Guaranteed Maximum Price, or the Contract Time, that have been authorized by Construction Change Directive until the cost and time have been agreed upon by both the Owner and Contractor, in which case a Change Order is executed to supersede the Construction Change Directive. NOT VALID UNTIL SIGNED BY THE ARCHITECT, CONTRACTOR AND OWNER. I & S Group, Inc. (ISG) trdinal Construction, Inc. City of Waterloo ARCHITECT (Firm name) CTOR (Firm name) OWNER (Finn name) SIGNATURE RE SIGNATURE Nathan Compton, Architect Katy Susong, President Quentin Hart, Mayor PRINTED NAME AND TITLE PRINTED NAME AND TITLE PRINTED NAME AND TITLE March 10, 2021 March 11 , 2021 DATE DATE DATE AIA Document G701W — 2017. Copyright © 1979, 1987, 2000 , 2001 and 2017 by The American Institute of Architects. All rights reserved. The "American Institute of Architects ," "AIA," the AIA Logo, and "AIA Contract Documents" are registered trademarks and may not be used without permission . This document was produced by AIA software at 17:29:25 ET on 03/10/2021 under Order No.8114132283 which expires on 07/12/2021 , is not for resale, is licensed for one-time use only, and may only be used in accordance with the AIA Contract Documents® Terms of Service. To report copyright violations, e-mail copyright@aia.org. User Notes: (3139ADA40) i 1A Document G701 - 2017 Change Order PROJECT: (Nance and address) CONTRACT INFORMATION : CHANGE ORDER INFORMATION : Five Sullivan Brothers Convention Center Contract For: General Construction Change Order Number: 009 Addition and Renovation, Waterloo, IA . Project No : 20-23943 Date: September 083 2020 Date: March 16, 2021 OWNER: (Nanne and address) ARCHITECT: (Name and address) CONTRACTOR: (Name mrd address) City of Waterloo I & S Group, Inc. (ISG) Cardinal Construction, Inc. 715 Mulberry Street 314 East 4th Street 1246 Martin Road Waterloo, IA 50703 Waterloo, IA 50703 Waterloo, IA 50701 THE CONTRACT IS CHANGED AS FOLLOWS: (Insert a detailed description of the change and, if applicable, attach or reference specific exhibits. Also include agreed upon adjustments attributable to executed Construction Change Directives) A. Per ASI 005 : Removal of existing high soffit lighting fixtures attached to beam on exterior of the building; demo back to closest junction, , , , , , , , , , , , , , , . 4 4 0 0* 4 1 0 4 4 V 4 V 6 # s 0 a a 4 a 0 4 4 g 0 9 1 0 8 0 6 9 0 0 d 1 6 8 @Add $43101 .00 TOTAL AMOUNT OF THIS CHANGE ORDER, ADD TO CONTRACT SUM $41101 . 00 . The original Contract Sum was $ 5 ,516,300.00 The net change by previously authorized Change Orders $ 1273283 .06 The Contract Sum prior to this Change Order was $ 516431583 .06 The Contract Sum will be increased by this Change Order in the amount of $ 4, 101 . 00 The new Contract Sum including this Change Order will be $ 516479684.06 The Contract Time will be unchanged by Zero (0) days. The new date of Substantial Completion will be August 13 , 2021 . NOTE: This Change Order does not include adjustments to the Contract Sum or Guaranteed Maximum Price, or the Contract Time, that have been authorized by Construction Change Directive until the cost and time have been agreed upon by both the Owner and Contractor, in which case a Change Order is executed to supersede the Construction Change Dncctive. NOT VALID UNTIL SIGNED BY THE ARCHITECT, CONTRACTOR AND OWNER. I & S Group, Inc. (ISG) Cardinal Construction, Inc. City of Waterloo ARCHITECT (Firnr none) CONTRAC OR (Finns name) OWNER (Finn name) SIGNATURE SIGNATURE SIGNATURE Nathan Compton, Architect Iaftt ettg,presieloat Quentin Hart, Mayor PRINTED NAME AND TITLE PRINTED NAME AND TITLE PRINTED NAME AND TITLE March 16, 2021 � lzo2 � DATE DATE DATE AIA Document G701 " — 2017. Copyright © 1979, 1987, 2000 , 2001 and 2017 by The American Institute of Architects. All rights reserved. The 'Amerlcan Institute of Architects ,' 'AIA,' the AIA Logo, and 'AIA Contract Documents' are registered trademarks and may not be used without permission . This document was produced by AIA software at 13:08:08 ET on 03116/2021 under Order No.8114132283 which expires on 07112/2021 , Is not for resale, is licensed for one-time use only, and may only be used In accordance with the AIA Contract Documents° Terms of Service. To report copyright violations, e-mail copyright@ala . org . User Notes: (3B9ADA40) CITY OF WATERLOO Council Communication Discussion of the Capital Improvements Plan. City Council Meeting: 3/22/2021 Prepared: 3/18/2021 REVIEWERS: Department Reviewer Action Date Clerk Office Felchle, Kelley Approved 3/18/2021 - 12:55 PM ATTACHMENTS: Description Type CIP Version No 6 on Mar 14 2021 MW Revisions Mar Backup Material 15 2021 Clean SUBJECT: Discussion of the Capital Improvements Plan. Submitted by: Submitted By:Noel Anderson, Community Planning and Development Director Recommended Action: Summary Statement: Expenditure Required: Source of Funds: Policy Issue: Alternative: Background Information: CITY OF WATERLOO Council Communication Discussion of the FYE2022 budget. City Council Meeting: 3/22/2021 Prepared: 3/3/2021 REVIEWERS: Department Reviewer Action Date Finance Felchle, Kelley Approved 3/3/2021 - 3:09 PM ATTACHMENTS: Description Type ❑ FY22 Budget Published March 15 Backup Material ❑ Rate Impacts FY22 March 14 Backup Material ❑ Breakout of Staff Budget Requests with Changes Backup Material March 15 ❑ Breakout of Staff Budget Reqeusts incr from 2021 - Backup Material March 15 ❑ Hiring Delays and Furlough Days Summary Backup Material SUBJECT: Discussion of the FYE2022 budget. Submitted by: Submitted By:Michelle Weidner, Chief Financial Officer Recommended Action: Summary Statement: Expenditure Required: Source of Funds: Policy Issue: Alternative: Background Information: FYE2021 CERTIFIED AND FYE2022 PUBLISHED BUDGET COMPARISON - CITY OF WATERLOO Published Budget GENERAL FUND 3/15/21 A B D E F G H I J K L M 1 CERT FY 2021 BUDGEI FY 2022 BUDGET % FY 2021 BUDGET FY 2022 BUDGET FY2021TAXES FY2022TAXES LEVIED 2 BUDGET CODE ACTIVITIES-GENERAL FUND BUDGET CERTIFIED PUBLISHED CHANGE CERTIFIED PUBLISHED LEVIED $ 19.24547 $ AMOUNT % 3 LINE EXPENSE EXPENSE REVENUE REVENUE $ 18.44026 4.370%,16 CHANGE CHANGE 4 5 PUBLIC SAFETY 6 010-11 -1100 POLICE OPERATIONS 1C 14,705,497 16,306,599 10.89% 720,876 1 ,128,642 13,984,621 15,177,957 1 ,193,336 8.53% 7 010-11 -1105 POLICE COMPUTER SERVICE 1C 242,966 259,968 7.00% 0 0 242,968 259,968 17,000 7.00% 8 010-11-1200 PUBLIC SAFETY ADMINISTRATION 1C 171 ,035 0 -100.00% 0 0 171 ,035 0 (171 ,035) -100.00% 9 200-11 -1140 POLICE PENSION ID 2 ,5151650 2 ,689 ,851 6.92% 0 0 21515,650 2,669,851_ 1741201 6.92% M1112 010-11 -1150 POLICE GRANTS 1C 615 ,526 744,735 20.99% 615,526 744,735 0 0 0 0.00% 010-11 -1150 POLICE GRANTS (DISCR H/M) 1C 0 0 0.00% 0 0 0 0 0 0,00% 010-11-1160 LAW ENFORCEMENT PROGRAMS 1C 895 ,000 963,483 7.65% 895,000 963,483 0 0 0 0.00% 13 010-11 -1165 POLICE TOBACCO ENFORCEMENT 1C 5,500 51500 0.00% 51500 5,500 0 0 0 0.00% 14 010-01-1700 B.H. COUNTY EMA/SIREN MAINTENANCE 3C 96,012 96, 187 0 . 18% 0 096,012 96, 187 175 0.18% 15 010-12-1400 FIRE RESCUE 5C 9,972,101 109697,952 7.28% 61 ,850 62,850 9,910,251 10,635,102 724,851 7.31 % 16 010-12-1402 FIRE RESCUE CHARGEBACKS 5C 34,169 36, 107 5.67% 34,169 36,107 0 0 0 0.00% 17 010-18-1405 FIRE-GARAGE PARTS & SERVICE 5C 1979672 203,764 3.08% 0 0 197,672 203,764 6,092 3.08% 18 200-12-1420 FIRE PENSION 5D 11750,706 1 ,920,123 9.68% 0 0 1 ,750,706 1 ,920,123 169,417 9.68% 19 010-12-1412 FIRE RESTRICTED PROGRAMS 5C 25,305 25,305 0.00% 25,305= _ 25,305 01 0 _ 0 0.00% 20 010-12-1415 HAZARDS REGIONAL RESPONSE TRG FROG 5C 181 ,357 187,873 3.59% 1 166,500 166,500 14,857 21 ,373 I _ 6,5_16 43.86% 21 010 12-1425 FIRE SAFER GRANT 5C 0 284, 192-NEW 0 284,192 0 0 _ _ _ 0 0.00% 38 22 010-12-1410 FIRE AMBULANCE SERVICE 6C 21363,384 3,3635485 42.32% 25258,000 31508,500 105, 4 (1459015) (250,399) -237.61 % 23 200.12-1410 FIRE AMBULANCE SERVICE PENSION 377,032 4019770 377,032 401 ,770 24,738 6.56 24 010-18-1411 AMBULANCE-GARAGE PARTS & SERVICE 6C 38,500 38,500 0.00% 0 0 38,500 38,500 0 0.00% 25 010-22-5100 BUILDING INSPECTION 7C 19237,379 1 ,188,997 -3.91 % 11526,713 1 ,518,965 (289,334) (329,968) (40,634) 14.04% 26 010-22-5102 BLDG INSPECTION CHARGEBACKS (OUT) 7C 112,296 120,044 6.90% 112,296 120,044429,115o354 0 0 0.00% 27 010-22-5102 BLDG INSPECTION CHARGEBACKS (IN) 7C 11 ,768 12,001 1 .98°k 11 ,768 12,001 0 0 0.00% 28 29 TOTAL-PUBLIC SAFETY 11C 35,548,857 39,546,436 11 .25% 6,433,503 8,576,82430,969,612 11854,258 6.37% 30 Less Fund 200 (4,6430388) (590115744) 31 TOTAL-GENERAL FUND 3099053469 34,534,692 32 PUBLIC WORKS 33 010-07-7650 SIDEWALKS 12C 2155000 215,000 0.00% 2153000 215,000 0 0 0 0.00% 34 010-17-7910 PARKING FACILITY MAINTENANCE 13C 18,960 9$ 00 -50.95% 0 0 18,960 91300 =439877 0.95% 35 010-22-7930 PARKING OPERATIONS 13C 527,500 515,000 -2.37% 527,500 515,000 0 00.00% 36 010-29-7700 AIRPORT OPERATIONS 19C 1 ,148,707 11143,499 -0.45% 1 ,148,707 11032,560 0 110,939NEW 37 010-01 -7800 MET TRANSIT AUTHORITY 21C 194620588 11506,465 3.00% 0 0 1 ,462,588 1 ,506,465 .00% 38 010-18-7950 CENTRAL GARAGE 21C 511 ,285 582,061 13.84% 85,300 85,300 425,985 496,761 .61 % 39 010-18-7952 CENTRALGARAGE - CHARGEBACKS 21C 530,000 530,000 0.00% 530,000 530,000 0 0 .00% 40 010-18-7955 MOTOR POOL-PASS THROUGH ACCOUNT 21C 2,048,468 2,0489468 0.00% 2,069,559 2,0693559 (211091 ) (21 ,091 ) 0 0.00% 41 42 TOTAL-PUBLIC WORKS 22C 61462,508 6,549,793 1 .35% 4,576,066 41447,419 11886,442 2,1021374 215,932 11 .45% 43 44 HEALTH & SOCIAL SERVICES 45 010-27-2500 HUMAN RIGHTS COMMISSION 29C 278,760 294,554 5.67% 0 0 278,760 294,554 15,794 5.67% 46 010-27-2505 EEOC CONTRACT 29C 451000 45,000 0.00% 45,000 452000 0 0 0 0.00% 47 010-27-2510 FAIR HOUSING ENFORCEMENT 29C 0 0 0.00% 0 0 0 0 0 0.00% 48 010-27-2510 FAIR HOUSING PARTNERSHIP GRANT 29C 0 0 0.00% 0 0 0 0 0 0.00% 49 010-27-2520 HUMAN RIGHTS PROJECTS 29C 0 0 0.00°/ 0 0 0 0 0 0.00% 50 51 TOTAL-HEALTH & SOCIAL SERVICES 30C 1 323,760 1 339,554 1 4,88% 1 45,000 1 459000 1 278,760 1 294,554 1 15,794 1 52 K :\USERS\MICHELLE-W\Budget FYE22\FY22 BUDGET_Published March 15 Print Copy.xlsx 1 3/15/2021 11 :55 AM FYE2021 CERTIFIED AND FYE2022 PUBLISHED BUDGET COMPARISON - CITY OF WATERLOO Published Budget GENERAL FUND 3/15/21 A B D E F G H I J K L I M 1 CERT FY 2021 BUDGE7 FY 2022 BUDGET % FY 2021 BUDGET FY 2022 BUDGET FY2021TAXES FY2022TAXES LEVIED 2 BUDGET CODE ACTIVITIES-GENERAL FUND BUDGET CERTIFIED PUBLISHED CHANGE CERTIFIED PUBLISHED LEVIED $ 19.24647 $ AMOUNT % 3 LINE EXPENSE EXPENSE REVENUE REVENUE $ 18.44026 4.37% CHANGE CHANGE 4 52 CULTURE & RECREATION 53 010-01 -4405 CEMETERY OPERATIONAL SUBSIDY 35C 50,000 709000 40.00% 0 0 501000 70,000 20,000 40.00% 54 010-01 -4220 GROUT MUSEUM 32C 652,746 655,955 0.49°k 22,571 22,850 630,175 633,106 2,931 0.47°h 55 010-26-4208 YOUTH PAVILION 32C 4159106 4119761 -0.81 % 105,600 88,800 309,506 322,961 13,455 4.35% 56 010-26-4250 CENTER FOR THE ARTS 32C 811 ,271 850,662 4.86% 160,000 160,000 651 ,271 690,662 39,391 6.05% 57 010-26-4251 RIVERLOOP EVENT FACILITIES 32C 15,958 15,958 0.00% 17,500 17 ,500 (1 ,542) (1 ,_542) 0 0.00% 58 010-26-4265 C&A GRANTS & PROJECTS 32G 94,000 94,000 0.00% 94 ,000 94 ,000 0 0 0 0,00% 59 010-26-4265 CENTER FOR THE ARTS (HIM) 32C 0 0 0.00% 0 0 0 0 0 0.00% 60 010-26-4265 CENTER FOR THE ARTS (DISCR H/M) 32C 19, 191 19,581 2.03% 19 , 191 190581 0 0 0 0,00% 61 010-33-3100 LIBRARY SERVICES 31C+levy 1 ,894,377 1 1 ,981 ,757 4.61 % 1 18,560 81000 1 ,875,817 1 ,973,757 1 97,940 5.22% 62 010-33-3110 LIBRARY - ENRICH IOWA GRANT 31C 18,417 19,184 4. 16% 18,417 19,184 0 0 0 0.00% 63 010-33-3150 LIBRARY OPEN ACCESS PLUS 31C 31000 41000 33.33% 31000 41000 0 0 0 0.00% 64 010-33-3160 LIBRARY GRANTS 31C 51 ,865 53,065 2.31 % 51 ,865 53,065 0 0 0 0.00% 65 010-33-3180 LIBRARY GIFT & MEMORIAL 31C 51000 51000 0.00% 51000 51000 0 0 0 0.00% 66 010-33-3190 IOWA LIBRARY SERVICE 31C 41120 41120 0.00% 41120 4,120 0 0 0 0.00% 67 010-33-3200 COUNTY LIBRARY 31C 69,633 70,940 1 .88% 69,633 70,940 0 0 0 0.00% 68 010-33-3210 LIBRARY OPEN ACCESS 31C 10,000 10,000 0.00% 10,000 10,000 0 0 0 0.00% 69 010-37-4100 LEISURE SERVICES - PARKS 33C 11767 ,705 1 ,934 ,002 9.41 % 39 ,737 39,737 1 ,727 ,968 1 ,894,265 j 166,297 9.62% 70 010-37-4102 LEISURE SERVICES - PARKS - CHARGEBACK 33C 950,000 950,000 0.00% 950,000 950,000 0 0 _ 0 0.00% 71 010-37-4105 LEISURE SERVICES PROJECTS 33C 7 ,000 7 ,000 0.00% 71000 lr — 79000 0 0 0 0.00% 72 010-37-4105 LEISURE SERVICES PROJECTS (H/M) 33C 0 0 0.00% 0 0 0 0 0 0.00°/ 73 010-37-4110 LEISURE SERVICES - DOWNTOWN MTCE 33C 405,225 4261728 5.31 % 0 0 405,225 426,728 21 ,503 5.31 % 74 010-37-4120 GOLF COURSES 34C 1 ,196,006 1 ,264,009 5.69% 838,782 837,779 357,224 426,230 69,006 19.32% - - -- - 75 010-37-4125 GOLF COURSE IMPROVEMENTS-SURCHARG 34C 81504 81188 -3.72% 81504 81188 0 0 0 0.00% 76 010-37-4180 SPORTSPLEX 34C 11437 ,500 11437,500 0.00% 1_34370500 _ 11437,500 0 0 0 0.00% 77 010-374200 SPORTS & YOUTH SERVICES 34C 6383187 656,246 2.83% 2822400 282 ,400 355,787 373,846 181059 5.080%/o 78 010-37-4500 YOUNG ARENA 36C 818,771 8370020 2.23% 719,000 7196000 99,771 E69928,033 ,020 18,249 18.29% 79 80 TOTAL-CULTURE & RECREATION 38C 1193439582 11 ,786,676 3.91 % 4,882,380 41858,644 69461 ,202 4669831 7.23% 81 82 COMMUNITY & ECONOMIC DEVELOPMENT 83 010-08-5700 PLANNING & ZONING 42C 6809512 7123475 4.70% 2581155 447,155 422,357 2659320 (157,037) -37.18% 84 010-08-5702 PLANNING & ZONING CHARGEBACKS 42C 21 ,151 22,907 8.30% 21 ,151 22,907 0 0 0 0.00% 85 010-08-5750 RECREATION AREA DEVELOPMENT 43C 700 700 0.00% 53,000 53,000 (52,300) (52,300) 0 0.00% 86 010-08-5885 CITY PROPERTY MANAGEMENT 43C 145,200 145,200 0.00% 0 0 145,200 145,200 0 0.00% 87 010-01-5710 INRCOG MEMBERSHIP 43C 34,887 35,572 1 .96% 0 _ 0 3.4_,887 35,572_ 685 1 .96% 88 010-08-6100 PLANNING & ZONING-ECONOMIC DEVEL 40C 121 , 108 1232796 2%22% 121 , 108 123,796 0 0 0 0.00% 89 010-08-6105 ECONOMIC DEVELOP-SPECIAL PROJECTS 40C o 0 0,00% 0 0 0 0 0 0.00% 90 010-01 -6650 TOURISM PROMOTION-VARIOUS GRTS (H/M) 40C 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) 40C 130 ,000 130,000 0.00°/ 130,000 130,000 0 0 0 0.00% 92 010-01 -6920 CONVENTION & VISITORS BUREAU (H/M) 40C 675 ,000 675,000 0.00% 675,000 675,000 0 0 0 0,00% 93 010-22-6860 SULLIVAN CENTER MAINTENANCE 43C 0 0 0.00% 507,482 507,482 (507,482) (507,482) 0 0.00% 94 010-01 -6860 SULLIVAN CENTER OPERATIONS 43C 21779,493 21779,493 0.00% 2,272,011 252720011 507,482 507,482 0 0.00% 95 010-32-5850 COMM DEVEL-ADMINISTRATIVE 41C 0 0 0.00% 0 0 0 0 0 0.00% 96 010-32-5861 COMM DEVEL-LHAP HOUSING POOL 41C 62 ,440 62,440 0.00% 62,440 62,440 0 0 0 0.00% 97 0 0 0 0.00% 98 TOTAL-COMMUNITY & ECONOMIC DEV 45C 419200491 41957,583 0,75% 40370,347 4,5630791 550,144 3930792 1 (1561352) -28.42% 99 K:\USERS\MICHELLE-1MBudget FYE22\FY22 BUDGET-Published March 15 Print Copy.xlsx 2 3/15/2021 11 :55 AM FYE2021 CERTIFIED AND FYE2022 PUBLISHED BUDGET COMPARISON - CITY OF WATERLOO Published Budget GENERAL FUND 3/15/21 A B D E F G H I J K L M 1 CERT FY 2021 BUDGET FY 2022 BUDGET % FY 2021 BUDGET FY 2022 BUDGET FY2021TAXES FY2022TAXES LEVIED 2 BUDGETCODEJ ACTIVITIES-GENERAL FUND BUDGET CERTIFIED PUBLISHED CHANGE CERTIFIEDPUBLISHED LEVIED $ 19.24547 $ AMOUNT 3 LINE EXPENSE EXPENSE REVENUE REVENUE $ 18 ,44026 4.37% CHANGE CHANGE 4 100 � 101 GENERAL GOVERNMENT f 102 010-01 -8200 MAYOR'S OFFICE 46C 364,043 564,311 55,01 % 0 0 364,043 564,311 200,268 55.01 % 103 010-01 -8280 COMMUNICATIONS 46C 10,891 15,891 45.91 % 0 0 10,891 15,891 53000 45.91 ° 104 010-01 -8220 ADMIN SERVICES/MIS 46C 418,049 416,880 -0.28% 13,445 33445 404,604 413,435 8,831 2. 18% 105010-01 -8222 ADMIN SERVICES/MIS 46C 126,178 131 ,429 4.16% 126, 178 131 ,429 0 0 0 0.00°/ 106 010-02-8100 CITY COUNCIL 46C 78,499 79,085 0.75% 0 0 78,499 79,085 586 0.75% 107 010-03-8400 CITY CLERK AND FINANCE 47C 11352,795 1 ,444,392 6.77% 61175,236 51917,686 (4,822,441 ) (41473,294) 349, 147 -7.24% 108 010-03-8400 CITY CLERK AND FINANCE - ELECTION COST 48C 0 60,000 NEW 0 0 0 601000 60,000 NEW 109010-03-8402 CITY CLERK AND FINANCE - CHARGEBACKS 147C 77,500 161 ,437 108.31 % 155,627 161 ,437 (78, 127) 0 78, 127 100.00% 110 010-06-8600 ICITY ATTORNEY 149C 353, 135 361 ,597 2.40% 0 0 353,135 361 ,597 81462 2.40% 111 010-03-8900 LIABILITY INSURANCE 151C 114319858 1 ,630,969 13.91 % 0 0 1 ,431 ,858 19630,969 199, 111 13.91 % 112010-03-8902 LIABILITY INSURANCE - CHARGEBACKS 51C 5003000 500,000 0.00% 500,000 5009000 0 0 0 0.00% 113 010-03-8905 HEALTH/LIFE INSURANCE 0 0 0.00% 0 0 0 0 0 0.00% 114 010-03-8950 SELF FUNDED HEALTH INSURANCE 52C 3,883,241 2,770,000 28.67% 3,883,211 2,770,00030 0 (30) -100.00% 115 010-03-8960 SELF FUNDED WORK COMP 52C 777,457 837,457 7.72% 100,000 100,000 677,457 737,457 609000 8.86% 116 010-03-8150 PUBLIC ACCESS STUDIO 52C 160,849 169,934 5.65% 30,750 30,350 130,099 139,584 9,485 7.29°/ 117010-03-8970 IPRINTSHOP 52C 46,000 46,000 0.00% 0 0 46,000 46,000 0 0.00% 118 010-09-2600 EAP SUBSTANCE ABUSE PROGRAM 52C 14,500 14,500 0.00% 0 0 14,500 14,500 0 0.00% 119 010-09-8250 HUMAN RESOURCES 52C 422,232 447,739 6.04% 0 0 422,232 447,739 25,507 6.04% 120 010-09-8252 HUMAN RESOURCES - CHARG 152C 32,500 32,500 0.00% 32,500 32,500 0 0 0 0.00% 121 010-09-8255 SAFETY COMMITTEE 52C17,500 17,500 0.00% 0 0 17,500 17,500 % NA0 0.00 122 010-22-8800 CITY HALUFACILITIES MAINTENCE 50C 678,051 700,217 3.27% 25,000 25,000 653,051 675,217 22, 166 I 3.39% 123 010-22-8820 CITY FACILITIES RESTRICTED PROJECTS 150C 5,0$5 5,085. % �0.00% 5,085 - 5,085 0 '' 0 0 0.00%' 124 010-22-8850 VETERANS MEMORIAL HALL 150C 89815 1 81815 0.00% 0 0 8,815 8,815 0 1 0.00% 125 200-09-8980 UNEMPLOYMENT FUND 52D 17,472 17,472 0.00% 0 0 17,472 17,472 0 0.00% 126 127 TOTAL-GENERAL GOVERNMENT 53C 10,776,650 10,433,210 -3.19% 11 ,047,032 93676,932 (270,382) 756,278 1 ,026,660 -379.71 % 128 129 130 TRANSFERS % ..- 131 010-03-9050 HOTEUMOTEL DEBT SERVICE TRANSFER 75C % % �11 % - 0 ,, % % . 0 . 000°h ,: , 0 -= , �. 0 ' 0' 0 0:00% 132 010-03-9050 TIF ECONOMIC DEV TRANSFER (INTERNAL TI 76C %% % 12%7;O0% 0 � '% - . % 11,000%, 15:75°/a >' " ' 127,000, =„ ,' 147,000 0 0' 0 0!00%' %% % % �, 133 010-08-9050 PLANNING & ZONING TRANSFER (TIF) % % 0;00%`. „ 134 TOTAL-TRANSFERS 77C 127,000 147,000 15.75% 127,000 147,000 0 0 0 0.00% 135 136 STATE REPLACEMENT FUNDS (COMM/IND ROLLBACK) 0 1 ,250,000 1 ,250,000 (1 ,250,000) (1 ,250,000) 0 0.00% 137 010-03-8400 PROPOSED USE OF FUND BALANCE 0 0.00% 750,000 21350,155 (750,000) (2 ,350, 155) (1 ,600, 155) 213.35% 138 BACKFILL ADJUSTMENT 0 0.00% 0 0 0 0 0 0.00% 139 0 140 TOTAL CITY BUDGET GENERAL FUND 69,502,848 73,760,252 6.13% 33,481 ,328 35,915,765 36,021 ,520 37,844,488 1 ,822,968 5.06% K:\USERS\MICHELLE-W\Budget FYE22\FY22 BUDGET—Published March 15 Print Copy.xlsx 3 3/15/2021 11 :55 AM FYE2021 CERTIFIED AND FYE2022 PUBLISHED BUDGET COMPARISON - CITY OF WATERLOO Published Budget GENERAL FUND 3/ 15/21 A B D E F G H I J K L M 1 CERT FY2021 BUDGET FY2022 BUDGET % FY 2021 BUDGET FY 2022 BUDGET FY2021TAXES IFY2022TAXES LEVIED 2 BUDGET CODE ACTIVITIES-GENERAL FUND BUDGET CERTIFIED PUBLISHED CHANGE CERTIFIED PUBLISHED LEVIED $ 19.24547 $ AMOUNT 3 LINE EXPENSE EXPENSE REVENUE REVENUE $ 18.44026 4.37°/ 4 CHANGE CHANGE 141 (o) 142 TAXABLE VALUATION FYE2021 FYE2022 Increase % Increase 143 (In Thousands) (In Thousands) (Decrease) (Decrease) 144 Taxable valuation - including TIF but excluding gas & electric utility values 2$ 39,996 20588,994 48,998 1 .93% 145 Taxable valuation - excluding TIF & gas & electric utility values 212555590 21271 ,583 15,993 0,71 % 146 Taxable valuation - including TIF and electric utility values 206180388 2,662,248 43,860 1 .68% 147 Taxable valuation - excluding TIF but including gas & electric utility values 21333,982 21344,837 101855 0.47% 148 Commercial/Industrial Property Rollback 107,173 1120840 51667 5.29% 149 CommerciaUlndustrial Property Rollback for Debt Service 111 ,833 112,840 1 ,007 0.90% 150 Taxable valuation - Ag Land 140891 15,138 247 1 .66% 151 Tax Askings per One Cent of Levy 238340 23,448 108 0.46% 152 78.00% 75.00% 153 PROPERTY TAX LEVY ANALYSIS: FY2021 TAX FY2021 TAX FY2022 TAX STATE BACKFILL FY2022 TAX $ AMOUNT 154 LEVY RATE LEVY CORP ROLLBACK RATE CHANGE 155 DEBT SERVICE LEVY 7,216,045 $ 2.75591 716019650 2411649 $ 2.85535 $ 385,605 156 POLICE & FIRE PENSION SYSTEM 416439388 $ 1 .98947 51011 ,744 180,884 $ 2.13735 $ 3689356 157 EMERGENCY MGMT COMMISSION LEVY 96,012 $ 0.04114 963187 38472 $ 0.04102 $ 175 158 TRANSIT LEVY 11462,588 $ 0.62665 1 $ 06,465 54,371 $ 0.64246 $ 43,877 159 TORT INSURANCE LEVY 1 ,431 ,858 $ 0.61348 11630,969 588865 $ 0.69556 $ 199,111 160 FICA/IPERS LEVY 21141 ,677 $ 0.91761 2,224,119 80,273 $ 0.94852 $ 82,442 161 HEALTH INSURANCE LEVY 50340,740 $ 2.28825 6$ 15,254 227,930 $ 2.69326 $ 974,514 162 WORKERS COMP, INSURANCE LEVY 677,457 $ 0.29026 737,457 26,616 $ 0.31450 $ 60,000 163 UNEMPLOYMENT LEVY 17,472 $ 0.00749 173472 631 $ 0.00745 $ 164 LIBRARY VOTED LEVY 630,175 $ 0.27000 6330106 22,850 $ 0.27000 $ 29931 165 EMERGENCY LEVY 630,175 $ 0.27000 633,106 221850 $ 0.27000 $ 21931 166 GROUT LEVY 630,175 $ 0.27000633,106 22,850 $ 0.27000 $ 2,931 167 AG LAND LEVY 44,729 459470 $ 741 168 GENERAL FUND $8.10 LEVY 18,9051254 $ 8.10000 18,993,177 6859503 $ 8.10000 $ 87,923 170 TOTAL PROPERTY TAX LEVY $ 43,867,745 1 $ 18.44025 $ 46,0791282 $ 19628,744 $ 19.24547 $ 292111537 $ 29205,675 171 ROLLBACK REPLACEMENT - GENERAL LEVY NCLLIDING EMPLOYEE BENEFITS LEVY, EXCL DEBT SERVICE $ 11341 ,395 $ 172 ROLLBACK REPLACEMENT - GENERAL LEVY $ 11052,276 173 ROLLBACK REPLACEMENT - EMPLOYEE BENEFITS LEVY $ 9,9090936 $ 3349819 174 AMOUNT CHANGE IN TAX LEVY $ 29211 ,537 $ 0.81 175 % CHANGE 5.04%b 4.37% 176 AMOUNT (OVER) UNDER $8.10 LEVY LIMIT 0 $ 177 ADJUSTED TOTAL PROPERTY TAX LEVY (AT GF $8.10 LEVY LIMIT) 189993,177 $ 19.24547 15.6164 178 $ 15.85012 1 .32905 179 GENERAL FUND $8.10 LEVY INCREASE (DECREASE) 87,923 180 TOTAL PROPERTY TAX COLLECTION INCREASE 5.046/6 181 182 Maximum Levy under 384. 15A 35,346,621 $ 15.14435 37,1659950 $ 15.85012 11819,329 5.15% K:\USERS\MICHELLE-lMBudget FYE22\FY22 BUDGET_Published March 15 Print Copy.xlsx 4 3/15/2021 11 :55 AM FYE2021 CERTIFIED AND FYE2022 PUBLISHED BUDGET COMPARISON - CITY OF WATERLOO Published Budget GENERAL FUND 3/15/21 A B D E F G H I J KI L M 1 CERT FY 2021 BUDGET FY 2022 BUDGET % FY 2021 BUDGET FY 2022 BUDGET FY2021TAXES FY2022TAXES LEVIED 2 BUDGET CODE ACTIVITIES-GENERAL FUND BUDGET CERTIFIED PUBLISHED CHANGE CERTIFIED PUBLISHED LEVIED $ 19.24547 $ AMOUNT % 3 LINE EXPENSE EXPENSE REVENUE REVENUE $ 18.440264,37% CHANGE CHANGE 4 183 2,912,591 11093,266 �Tm184 Residential Tax Askings Home Value Avg Revaluation Adj Value Rollback Tax Incr (Decr) Monthly Change % Change 186 $ 19,24547 FYE2022 152,234 152,234 0.564094 1 ,652.69 106.63 8.89 6.90% 187 $ 18.44026 FYE2021 152,234 152,234 0.550743 11546. 07 25.56 2. 13 1 .68% 188 $ 17.54799 FYE2020 1529234 152,234 0.56918 11520.51 42.44 3.54 2.87% 189 $ 17.45595 FYE2019 152,234 Ind reval 1523234 0.556209 18478.07 (47.52) (3.96) -3. 11 % 190 $ 17.60000 FYE2018 1521234 152,234 0.569391 11525.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 11464. 98 19.92 1 .66 1 .38% 193 $ 17.95159 FYE2015 154, 138 4% 147,973 0.544002 11445.06 20. 93 1 .74 1 .47% 194 $ 17.49319 FYE2014 154, 138 154, 138 0.528166 11424. 13 (0.01 ) (0.00) 0.00% 195 $ 18.20505 FYE2013 1543138 154, 138 0.507518 1 ,424. 14 37.79 3. 15 2.73% 196 $ 18.53335 FYE2012 154, 138 154, 138 0.485299 11386.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 1443054 0.455596 1 ,231 .67 (17.04) (1 .42) -1 .36% 201 $ 18. 84580 FYE2007 132, 160 9% 144,054 0.45996 19248.71 34.44 2.87 2 84% 202 $ 19. 15566 FYE2006 132, 160 132, 160 0.479642 11214.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 1183000 118,000 0.513874 11146.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 1009000 N/A 100,000 0.562651 1 ,001 .56 96.99 8.08 10.72% 207 $ 16.49097 FYE2001 1002000 100, 000 0.548525 904.57 209 Commercial Tax Askings Property Value Avg, Revaluation Adj Value Rollback Tax Incr n(97,55) (8, 13) % Change 211 $ 19.24547 FYE2022 752,427 7521427 0.90 13,032.73 4 4.37% 212 $ 18.44026 FYE2021 7523427 752,427 0.90 12,487.45 5 5. 08% 213 $ 17.54799 FYE2020 752,427 752,427 0. 90 11 ,883.22 9 0.53% 214 $ 17 .45595 FYE2019 752,427 752,427 0.90 11 ,820.90 . ) -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 7521427 0. 90 12,029.30 (802.60) (66.88) =-2,51 218 $ 17.95159 FYE2015 752,427 752,427 0.95 12,831 .90 (330.45) (27. 54)219 $ 17.49319 FYE2014 752,427 752,427 1 13, 162.35 (535.62) (44.64)220 $ 18.20505 FYE2013 752,427 752,427 1 13,697.97 (247.02) (20.59)221 $ 18.53335 FYE2012 752,427 752,427 1 13,944.99 202.62 16.89222 $ 18.26406 FYE2011 752,427 752,427 1 13,742.37 (32,23) (2.69) 223 $ 18.30689 FYE2010 7529427 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 6909300 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 6901300 N/A 6900300 1 13,223. 15 348.79 29.07 2.71 % 228 $ 18. 78999 FYE2005 5853000 18% 690, 300 0.99257 12,874.36 1 , 812.51 151 .04 16.39% 229 $ 18 .90914 FYE2004 5651000 N/A 585,000 1 11 ,061 .85 554. 11 46. 18 5.27% 230 $ 18.37162 FYE2003 5851000 N/A 585,000 0.977701 10,507.74 94.30 7.86 0.91 % 231 $ 17.80075 FYE2002 585,000 N/A 585,0001 10,413.44 766.22 63.85 7.94% 232 $ 16 .49097 FYE2001 500,000 17% 5859000 1 91647.22 K:IUSERS\MICHELLE-IMBudget FYE22XFY22 BUDGET_Published March 15 Print Copy.xlsx 5 3/15/2021 11 :55 AM FYE2021 CERTIFIED AND FYE2022 PUBLISHED BUDGET COMPARISON m CITY OF WATERLOO Published Budget GENERAL FUND 3/15/21 A B D E F G H I J K L M 1 CERT FY 2021 BUDGET FY 2022 BUDGET % FY 2021 BUDGET FY 2022 BUDGET FY2021TAXES FY2022TAXES LEVIED 2 BUDGET CODE ACTIVITIES•GENERAL FUND BUDGET ' CERTIFIED PUBLISHED CHANGE CERTIFIED PUBLISHED_) LEVIED $ 19.24547 $ AMOUNT % 3 LINE EXPENSE EXPENSE REVENUE REVENUE $ 18.44026 4.37% CHANGE CHANGE 4 234 Industrial Tax Askings Adj Value Rollback Tax Incr (Decr) Monthly Change % Change 236 $ 19. 24547 FYE2022 1 , 000, 000 N/A 11000,000 0.90 17, 320. 92 724.69 60.394. 370/ 237 $ 18 .44026 FYE2021 1 , 000, 000 N/A 110000000 0. 90 16,596.23 803 . 04 66. 92 5. 08% 238 $ 17 . 54799 FYE2020 11000, 000 N/A 110001000 0, 901 150793. 19 82.84 6. 90 0. 53% 239 $ 17.45595 FYE2019 1 , 000, 000 N/A 11000, 000 0. 90 15,710. 36 (129.65) (10. 80) -0.82% 240 $ 17 .60000 FYE2018 11000, 000 N/A 1 ,000, 000 0. 90 15, 840. 00 (4.70) (0. 39) 0. 03% 241 $ 17. 60522 FYE2017 1 ,000,000 N/A 11000, 000 0. 90 15,844.70 (142.63) (11 .89) 0. 89% 242 $ 17 . 76370 FYE2016 1 , 000, 000 N/A 1 , 0001000 0.90 15, 987. 33 (11066. 68) (88. 89) -6.25% 243 $ 17 . 95159 FYE2015 11000,000 N/A 1 , 000, 000 0. 95 17,054. 01 (439. 18) (36.60) 2. 51 % 244 $ 17 .49319 FYE2014 1 , 0001000 N/A 1 , 000,000 1 17,493. 19 (711 . 86) (59 . 32) -3. 91 % 245 $ 18 . 20505 FYE2013 1 , 000,000 N/A 1 , 000, 000 1 18, 205. 05 (328. 30) (27. 36) 1 .77% 1 246 $ 18 . 53335 FYE2012 E1 , 000, 000 N/A 11000, 000 1 18, 533 . 35 269.29 22.44 1 .47% 247 $ 18. 26406 FYE2011 11000,000 N/A 1 , 000, 000 1 18,264.06 (42. 83) (3. 57) 0.23% 248 $ 18 . 30689 FYE2010 110001000 N/A 1 ,000,000 1 18, 306 . 89 (59.98) (5. 00) 0.33% 249 $ 18 . 36687 FYE2009 1 ,000,000 N/A 1 , 0001000 1 18, 366.87 (399. 82) (33.32) 2. 13% 250 $ 18 . 76669 FYE2008 1 , 000, 000 N/A 11000, 000 1 18,766.69 (79. 11 ) (6.59) -0.42% 251 $ 18 . 84580 FYE2007 1 ,0002000 N/A 1 , 0001000 1 181845. 80 (309.86) (25. 82) 1 .620% 252 $ 19 . 15566 FYE2006 11000 , 000 N/A 11000, 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.63% 254 $ 18 . 90914 FYE2004 1 , 0001000 N/A 11000, 000 1 18,909. 14 537. 52 44.79 2. 93% 255 $ 18. 37162 FYE2003 1 ,0003000 N/A 13000, 000 1 18, 371 .62 570.87 47. 57 3.21 % 256 $ 17 . 80075 FYE2002 11000, 000 N/A 110001000 1 17,800.75 1 , 309.78 109. 15 7. 94% 257 $ 16 .49097 FYE2001 1 , 000, 000 N/A 110001000 1 16,490. 97 258 259 Multi-Residential Tax Askings Adj Value Rollback Tax Incr (Decr) Monthly Change % Change 261 $ 19. 24547 FYE2022 5001000 N/A 500, 000 0. 6750 6 ,495 . 35 11 (74.00) (6. 17) 1 . 13% 262 $ 18 .44026 FYE2021 5001000 NIA 5001000 0.7125 6,569. 34 (11 . 15} (0. 93) -0. 17% 263 $ 17 .54799 IFYE2020 500,000 N/A 5001000 0. 7500 6 , 580.50 (292. 78) (24.40) 4 . 26% 264 $ 17.45595 FYE2019 500, 000 NIA 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 0, 8625 7,592.25 (401 .41 ) (33.45) -5.02% 267 $ 17. 76370 FYE2016 5001000 N/A 5001000 0. 9000 71993.67 (533 . 34) (44.45) -6.25% 2681 $ 17 .95159 FYE2015 500, 000 N/A 5003000 0.9500 81527.01 (219.59) (18. 30) -2. 51 % 269 $ 17 .49319 FYE2014 5001000 N/A 500,000 1 8,746.60 K:\USERS\MICHELLE-W\Budget FYE22XFY22 BUDGET_Published March 15 Print Copy.xlsx 6 3/15/2021 11 :55 AM FY2021 CERTIFIED AND FY2022 PUBLISHED Published Budget BUDGET COMPARISON - CITY OF WATERLOO 3/15/21 ALL OTHER FUNDS - G H I J 2 L M N 2 - P % % FY2021 BUDGET FY2022 BUDGET FY2021 FY2021 FY2022 FY2022 FY2021 FY2022 $ AMOUNT B C D E F 1 PROJECT CERT FY2021 BUDGET FY20228UDGETI ___— _--- 1 _ _ CERTIFIED PUBLISHED 'i_ CHANGE CERTIFIED I _ _ PUBLISHED TRANSFERS TRANSFERS I TRANSFERS ', TRANSFERS LEVIED LEVIED '�. CHANGE CHANGE 2 BUDGET CODE ACTIVITIES•OTHER FUNDS CODE BUDGET ;, EXPENSE EXPENSE I! REVENUE REVENUE ---- - " 3 -__-_ LINE ---. - -_ _ — (IN) OUT - 4 PUBLIC SAFETY - - --_-- - - ___ (IN) OUT - ---_ -- - 5 200-17-1140 POLICE PENSION SYSTEM _ . 170 2,515,650 26899857 1 6.92% 0 01 2,515,6501 21689855 774,201 6.92_% 7IFIRE PENSION SYSTEM I - - -- --- - _- --_. - -- 2, 127,738 _- 2,327 ,893_1, 194, 155 9.72% 1 - >_ -__ _.- _ 7.93 /0 0 1 -_ _ _ _ 9. 12% 0 p .__ 8 200-72 1420 1 TOTAL PUBL C SAFETY - 1 D 4,643 388 _-_ _ 5 017 ,744 _-- -_-- - p — ---- p o " j --- --__—1 9 _ - - - ! -- - - -- � _ o j 0 4,643,388 5,o11 ,744 368,356_ 7.93% 10 11 PUBLIC WORKS ( II - -- 1 1 _ -- - - 12 205-077400 1 BRIDGE MAINTENANCE LOCAL OPTION. 12D _ 0.1. _ _ 0 0 - 0.00% ' _ _ 0 0.00% 0 O 1 _ 13 20507-75_00 STREET CONSTRUCTION - LOCAL OPTION 120 81479,047 c 10,507,0°0 (1 ,765,953) 1 (1 ,872,495) 1 (106,542) 6.03% 14 205-07-7830 - . _ 1 ENGINEERING LOCAL OPTION TAX - 12D 1 735,500 6 776,974 - - 5.64 /uj_. _ 10 245 00� - - 0 j T - --735,500 776t974 41 ,474 ' 5.64% 0 SE _ T__. - 1 _ 0 _. ..-_ -- �- 10304531 ."-- 1 ,095521 65.0681 6.31 % 16 266-07-7830 ROAD USE TAX REVENUE 0 1 ,095,521 6.37 % � 0 0 1 --_ — _ 15 205 19-7110 SEAL COATING - LOCAL OPTION 1120 1 ,030,453 0l_ 0.00 /L 7,637,010 7,616,935 --- (7,637,010 T7 266-07-7300 _ . - ROAD -. j_ . --_ 0.00% 1 _ _-. 0 1 333,165 _ ) _ (7,616,935) 1 2°.075 0.26% _ I. - 750,0001 - _ _ - -04.42% 18 266 07-7500 1ST EET CONST CE ROAD USE AAXUSE TAX 12D 7,464,909 1 4,000,000 -06.42% 1 7,500,000 4,000,000 j — 735,09° 476,8305 (333,165) c -- - --- -- . - -- __� ) 1 _ 35,091 . 100.°0 % 20 26607-7832. ENGINEERING - CHARGEBACKS (OUT) _ 120 j 133,0471 133,0471 0.00°/al 1330471 _ 490501 1 1 1 ,034,670 7 ,129,3061 94,636 ." 19 26607-7830 IENGINEERING ROAD USE TAX FUND 1120 1 ,083,720 1178,3561 _ 8.73 /0 _ 49,050 — 22 266-17-7105 STREET LIGHTING_UTIL - ROAD USE TAX T14D 518,000 1_ .. 0 0.00% �_ 523,180 " -- 133,047 21 266-07-7832 IENGINEERING - CHARGEBACKS IN - 1120 0 50,000 _. _. . ( -_ ) - I 500°0 50,00 0.00% 50,D0p� _ 0I 518,000 523,180 5,180 7 .00% O1 0 23 266 17-7120 ( TRAFFIC SAFETY ROAD USE TAX FUND i 750 , " . 7 .00 / __-. �_. __ _- - - ---- T_ --- — ---- -- _- -- - ..-- - 1 ,536,1581 1 ,594,024 3.77 /0 — �- 1. 1 ,508808 1 ,566,674 57,866 '' 3.84% 0 1 � 27,350 ; 27,350 24 26617-7122 ' TRAFFIC SAFETY - CHARGEBACKS (OUT) 15D 32,000 32,000 0.170% 32,000 3210001 - - - — 0 0 0 0.00% 25 266-17-7125 , TRAFFIC SAFETY_- RESTRICTED PROD , 17TRF DSCV 115D 1001 10� 0.00% 100 } --- -- -" - - �— _� 10� 4e 000 1 4a.00p OT 0.00% 26 266 17-7161 TRAFFIC SIGNALS UTIL - ROAD USETAX 150 48,000 48,000 O.OD% 0 0.00% 28 266-19-7102 STREETMTCE - CHARGEBA_ C_ KS (OUT) : 120 156,5001 7585001 0.0000/a _- " --- 550 ! _ " ._ _ 119657081 21085,398 720,317 1,. 6.12% _ _ _ 6.72% 550 - 27 266-19-7100 STREET MTCE - ROAD USE TAX FUND 1720 1 965,631 2,085,948 -- .- I{ 158,500 - 158,500 _ -- - - - - 1 ,847,542 - 1 ,847,542 0 0.00% 29 266-79-7200- SNOW REMOVAL L ._ _. 116D 1855,54 -_7 ,855,542 I . - o.0o% I 8,000 _ 8,00 _ 01 0.00_% 30 266-37-7902 1 ROW FORESTRY & MOWING 112D i- 900,000 1 900,000 _ 0.00% 1 900,000 900,000 j 1 0 0 IP xx� _ _ T - — t) 0.00% -: -_ ! 19D 1_-- _ _ 1 -- _ 0 p 01 0.00% 32 291 -29_7755 ( AIRPORT PASS31 291-29-7750 IAIRPORT ENGER PACT FACILITY CHARGES JECTS 129AIP xxxx. _ 1 -- 696,881 i 7 100,000 --- 73.22% 1 ---_ 696,881 1 7 100,000 1 -- _-- 1 - 1, 1 - 0 -- __- o _-. _ 0 0.00 33 e91-29-7760 773,000 z.2s% 1 177,000 173,°_°0 1 0 0 0 1 0.00% 34 - AIRPORT STATE PROJECTS 1 -. -- - - 1220 - 27,649,0161 1 - -- - 14 -- - _-- 35 _ ( TOTAL-PUBLIC WORKS --� -_ -- Izx 19D 177,000 25,188697 -8.90% 27,649016 25, 188,697 D 0 0 0 O1 0 01 000% ' 36 - 37 1 - - T 39 204-33-3100& RECREATION 38 CULTURE _ } � - 1- LIBRARY - TAX LEVY 1 _431C - 1 669,7791 7074141 5.62% 17,03311 51 ,459 1 652,7461 6559551 3,209 0.49% 1 _ 40 - - _ 41 - - - ( TOTAL-CULTURE & RECREATION - 1 _ -.--- _ _ 3,209 - .. -_ - 669779 707 414 _ - 0.49% - J _- �_ 5.62% 17,033 51 ,459 0 O 0 43 -- 852,746 1 655 955 44 COMMUNITY & ECONOMIC DEVELOPMENT T - - - -- -- - ` -- -- - - _ . -" 1 T _ 45 224-32-5850 COMM. DEVELOPMENT-BLOCK GRANT V VARIOUS j41D 1 ,64_6,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 ( 141D 1 ,378,918 1 ,359,093 -1 .440 1.,378,9181 1 ,359,093 ".. _. 11 T." -- , i .._ 01 0 .1 _ . 0.00% 47 _S 1 0- I o.00i o ; - �+ 0 'I of of 0.00% 48 224-32-5870 COMM. DEVELOPMENT-FEDERAL HOME TIO}VAR OUS x 141D 1 _.. 7 ,361 ,742 -� 1 ,361 ,742 1 - - 0.00% 1 -- 1 ,361 ,742 1 ,361 ,742 -__ '.; O - I o 0.00_ Oi 0 ' 49 224 32-6800 NEIGHBORHOOD SERVICES - IBGDDS 0077 1470 85,173 1 90,000 5.67% 857173 90,000 _ _ -. .. 0.00% 51 283-13-5450 HOUSING - RIDGEWAY TOWERS 41D0 _- 62,0001 52 283-13-5451 HOUSING - CAPITAL FUNDS Go . _ CAP FYxx 11410 265,0 0 _-- 270,000 7.69% 265,000 2fi0,o00 ---T --- -- ` -- - -- 0 01 000% ( ) _...__� 0 0 : _ 0.00_% , 53 283-13-5452 _ --1 HOUSING - SECTION 8 j41D 5,6.72,200 5T 11 ,834,30° 286% I 5,672,20 5,834,300 0 O 0 0.00% 54 283-13-5453 _ _ HOUSING - FAMILY SELF SUFFICIENCY 410 20,000 20,0°0 , _ 0.00°/a 20,000 1 20,000 0 0 0 0.00% 55 283-13-5455 HOUSING - 00WNPAYMENT ASSISTANCE � 41D 500000 1 50,000 0.00%1 50,0 0 50,000 T ° 0 1 _ 0 } _ 0.00% HOUS _ _ o 77 off _ o , 0.00 58 283-135861 TOTAL OMMUNITY &SING ECONOMIC DEV �4 _ T 5D �_- - 10,541 ,417 10,695519y ---- 1 D 0.46% .---- 10,541 ,4171 10,695,5191 60 - - - - p - - 0p - -I -- p -- �o - 0 1 -- 0.00 /59 - - KAUSERSWICHELLEAMBudget FYE22TY22 BUDGET_Published March 15 Print Copy.xisx 1 3/15/2021 11 :54 AM FY2021 CERTIFIED AND FY2022 PUBLISHED Published Budget BUDGET COMPARISON - CITY OF WATERLOO 3/15/21 ALL OTHER FUNDS A B C D I E F G H I J K L I M N O P q PROJECT 1 --__ iFY2022 BUDGET FY2021 FY2021 FY2022 FY2022 FY2021 FY2022 $ AMOUNT % 2 BUDGET CODE ACTIVITIES•OTHERFUN0S CODE BUDGET.. CERTIFIED PUBLISHED CHANGE FY2021 YCERTIFIEDET PUBLISHED . TRANSFERS TRANSFERS I TRANSFERS ' TRANSFERS LEVIED LEVIED '.. CHANGE CHANGE _ --. --_. (IN) OUT __ (IN) OUT __ E FY2022 - - 3 LINE EXPENSE EXPENSE REVENUE REVENUE 1 61 GENERAL GOVERNMENT - - - -- - -- - --- --- _ --. 0.00% � 0 __- - 0 0 _ -0.00% 62 200-09-8980 UNEMPLOYMENT FUND _-- 520 _. - _ 17,472 -_. 17,472 - - - - - _ _- -- _ --_ 179472 17,472 63 - - 64 TOTAL•GENERAL GOVERNMENT 153D 1 17,472 17,472 1 0.00% � 0 0 0 0 " 0 0 17,472 17,472 0 0.00% 65 - -- - 66 ---- - - 67 -2-90-0-7---5300-- PECIAL REVENUES CAPITAL PROJECTS _-. _ _ 07FLD 5007 _- 0.00% 0 _ - 0 0 0 - 68 290 07 5300 STORM WATER PUMP STATIONS-COMM 64 ' 07FLD 0078 550 - - 0 0 0.00 / i 0 1 O I -- _ - '1- 1 0 --- 0 0.00% I55D 0 -- 0 . O 69 290 07-5300 STORM WATER PUMP STATIONS-COMM 35.� 0 1 I - _ _ 0 0.00% 70 290-07-7300 STREETS - W _ _ 6,000,000 i. . . NEW 0 6,000,000 _ 0 000% 71 290-07-7355 I STREETSSHAULIS RD TRAIL 08BKE.TAP766 55D x'11 0 200,000 II NEWS_ p 200,0.00 _ - - - ... - - K IITH --. -- -- .. _--_ O ----- 0_; 0 0.00% 72 290-07-7500 STREETS-LAPORT HESS RD BRIDGE REPLACE 7STR.SWAP76 550 5,043,543 _ 95NEW.04% 51043,643 250,000_ 1 - -- __ -- 0 0 01 0.00% .- _ _ _ -_ ,_ -__-_ 0 4.600,000 1 _ NEW _. 0 496003000 1 I T -- - _ _.-_ 0 .__-._ 0 I 0 1 0.00_% 74 290---07-7520 US 63 07STR.RM772 SSD 0 - - - _-_- -_�55D 0 1500,000 NEW ! 0 1 ,500,000 --- -_-1 0 -- 0 0 0.00% :. 73 290-07-7500 STREETSSHAULIS RD RECONSTSTRUCTIOPI - - - 75 76 290 07160 _ T_RAFF C ANSB TO BLACKHAWK 17TRF STP757_ ! SSD _ 300,000 0 � _ -100.00% 200,000 , _ - 0 0 I 0 0.00% ( - - L OBBKE RT734._. 1 � --1 .. -100.00% I 300.000 O --_ --- �_-_. _ _� --_ 0 _ 0 ._ 0 00% 78 290-17-7161 ! TRAFFIC IMPR GREYHOUND & RIDGEWAY I17TRF zzxx I55D,_ 310,000 0 -1 oo.00% 310,000 0 p O , 0 0.00°% „. 77 29017-7161 _ ! TRAFFIC-VISION ZERO 17TRF xxzx 55D 5,000 _ 0� -100_._00% I 5,000 _ __ 0 _ " 79 290-17-7161 1 TRAFFIC DOWNTOWN CAMERA & FIBER 17TRF xxzx 1550 I_ . - 550,000 385,000 iI -- ---� -- --_ __ __ -- 0 000 /o _ _ - �_ __-- - -_ _--__ 27.2 550,0001 400,000 0 00+, 0I 000 /0 80 290-17 7161 TRAFFIC W 9TH/SOUTH ROUNDABOUT 17TRF zzxz 550 - 0 - NEW 0 385,000 0 0 0 0.00 _- - I ___ __ - _ _ _ - .- 0 00% 81 290-17-7161 TRAFFIC SAFETY CAMPAIGN 17TRF zzxz 550 40,000 1 30,000 25.00 % 40,000 30,000 0 p 1 0 82 290 17 7161 TRAFFIC US 63 TRAFFIC ADAPTIVE PROJ t7TRF xzzx 550 0 145,000 r NEW 0 145,000 _. _ -. .. _. . .__ _ 0.00% 83 290177161 - --- 1TRAFPIC-RIDGEWAY AVE_ 17TRF xxxz _ - S5D _ - !, 700,000 --___ 0 �_ _- -100.00% � ----- - 700,000 --_ -- _0._ I -- p , 000% ; 84 290 17-7161 TRAFFIC-PARK AVE BICYCLE SIGNAL PROJ 17TRF xxxz I55D 72,000 100,000 1 38,89% 72,000 100,000 _ 0 0 0 ! 0.00% - - 0-1 0.00%% 0p j-_ - O -.._ 0 0 85 29o-nats7 - 7 _ _ _ _ 0 0 o 000 86 290-374100 GREENBELT LAKE IMPROVEMENTS I371MP.GRNBLTi55D 200,0001, _ - 200,000 p -- 0.00% 200,000 1 000% 87 290-37AI05 88 _290-37-0700 RIOVERVOIEW REC AREA TRAIL EXTENSION 66REC TRL13 I55D _ 0 - - 0.00% 0 _ 0 _ 0 1 O 0 0.00% ' 17TRF xxxz 550 0 200 000 0 _- - - _� � . .. - - - - -- . O.00hI 0 � -- - r - . - . -_ 0.00% 0 0� 0 _ 150 ` 0.00 / - 130,000 130,000 - 20,000 25 000 0 !- 0 00% - 90 207- IIA REINVESTMENT DISTRICT 1 300 1 ) - - 1 - 130,000 -50.00% 220,300 125,1501 200000 � .. _ 100,000 j- 25.00% 91 _ - -- - -.- ---__ ( ) ( 0) I (5000 -__- - D STABILIZATION 32NS3 xxxz S5D - - 130,.000 1 - I - - -._-_ - ' _ 20.000 25.00% 100,000 94 Subtotal - 200 Series PLess LibraECIAL ry REVENUES CAPITAL PROJECTS 570 504028431 13940150 ,! 64.62%1 7770,6431 14,065,750 O ! 200,0001- 0 - (20,000) : (25,000)1- (5,000) rY__.Levy___ , 136 54,853,582 i _. 45,961 ,276 49,949,366 _. - 0 . 1- 200,000 0 100,000 5,293,606 5,660,177 I 366,565 6.92% _.... _-. -_ 1 ,- - __. - - - -__-- -_ - __ - __ _. -_ 95 - - - 96 - CTIVITIES 98 520-14-5200 1 WATER POLLUTION CONTROL PLANT 1 ! (5,702,233 (5,384,841 ) 1 97 BUSINESS TYPE 99 520-14-5202 WATER POLLUTION 1 3.08°/ 13,536,9401 13,460,940 )1.- _- 317,392 -5.57°/a 100520-14-528.0 SEWER REVENUE PLANTSRF _� 17.101 1430000 ' 6650000 0.00% 692,00-0 692,000 692,0001 - _ -_ 01 .. 0.00% _ _ _ 692,0001___ -. --- 0 -. 601 692,000 _- - _ __ -.10211 000 = 53.63% 14,340,000 1 6,650,000 0 0 -- 0 0 0 0.00% 101 520-14-5375 SEWER REVENUE COLLECTION SRF 711 11 80. 0,000 1 10 211 ,000 1. 3_.47 / 11 ,_800,000 10,211 ,000 _ �_ _ T O I_ 0 1 0 0.00% -._ _{ . . _�0 BOND DEBT SERVICE 751 j 0 I -.--_ 1 _ .__ L_ 1 I 1 �148.17� 132,429 - 13.04%103 520-14-9050 ! SEWER , 102520-148980 ( SEWER REVENUE DEBT SERVICE 1701 - - 1 ,015,750 - 1 ,748179 - - - - 13.04% - -- 0 _ 0� --- - 1 ,015,750 104 52G-22-5335 FOOTINGDRAIN DISCONNECTIONS _ 1601 138 147,368 6.52% fI p 0 'i --- -- - -- - - _ (732,429) -5.46% _. -_-- 0 _ --- -- 2,427,130 --_-- ! 2,294,701 _ 21715,632 130 1 2 294,701 1 -- - - i 147,368 -_ 91021 6.52% 105 521 -14-5310 ( STORM SEWER MAINTENANCE 601 715,632 763,687 6.72 / 1 - 0 - -- -- - 763,687 _ 6.72% _ _ 3 0 - 2s748,450 -- --- T 48 055 1 107521 -07-7830 106 521-19-5500 STREETCLEANING 601 358,884 383,374 6.82h 0 0 i -- " �I� _--1 ( , ) - (2,264,526) _-_ 24,490 5.30% 108521 -07-7832 IENG-STORM WATEERA MIN CHARG BACKS ! _ 1601 457,050 -- 487,0501 _ 0_00% I 2,417,050 7,050 -- -- 1964,09701 ) 1_ 15.30% ! ---- . -� ----- -- 356,884 383374 1 -_ , 711 --1 ,050,000 1 ,2600001 20.00% i 160,419 142,5351 1 -- --- - 1- 889,581 ! -- 1 ,117465 (_(227884 tI 0.00%. 109 521-07 5300 STORM WATER CAPITAL PROJECTS 25.62% .. _ - I I ! ---_ ---- ___ ..___ 0 ( ) 1 -100.0_0% - -JECTS 11711 _STORM WATER SRF PR _ 0 1 ,4.00,000 ---- _ 889,587 110520-04-5320 ( SEWER SYSTEM IMPROOVEME TS -- - 711 2,t27 ,O06j 1 .794,593_1 -1539%a � 0� _ -__ __---. -_-- --- ---2,020,0061 1 ,794,593 ' (326,473) 1, -15.39% 112 617-14-5320/898JSEWER GO BOND PROJECTS _ _ - _ 171I __ 7 ,_000,000 0 113 (SUBTOTAL - SEWER FUND 33,017,274 " . _ -20.49% i 42,954,359 35,311 ,9751 0 2,427,1301 ! 21294,7011 (7 ,889,581 100.00% ) I 93 -__ 41 ,527,229 1 ,889,581 0 114 K:\USERSWICHELLE-WtBudget FYE221FY22 BUDGET_Published March 15 Print Copy.xlsx 2 3/15/2021 11 :54 AM FY2021 CERTIFIED AND FY2022 PUBLISHED Published Budget BUDGET COMPARISON = CITY OF WATERLOO 3/15/21 ALL OTHER FUNDS A B I C I D I E F G H I I I J I K L M N O P Q 1 _ _ % FY2021 BUDGET ! FY2022 BUDGET I FY2021 FY2021 FY2022 FY2022 _ . FY2021 _ FY2022 $ AMOUNT 1 % _ _ _ FY2021 BUDGET I FY2022 BUDGET " 3 CERTIFIED PUBLISHED T CHANGE CERTIFIED PUBLISHED TRANSFERS I TRANSFERS 1 TRANSFERS 1. TRANSFERS LEVIED LEVIED CHANGE CHANGE 115 525-15-54000ODE ISANITAT ONTIVITIES-OTHER FUNDS CODE - - 64LI EET ; EX PENS 923 EX ENSE 52T 0.04% RE 5E23Q759 f RE 5ENUE764 _(IN) _ OUT (IN) OUT -- - I - 117525-15-5125 SANITATION - CODE EN525-15-5402 SANITATION - FORCEMENT ACKS 1641 - 376,500 376,500 : 0.00% I _.. _ - 451 ,500 '. 451 ,SOOi (75,000) 1 (75,000 (231676) 40,00% _. ),.. _ 0.00_% 641 _ _ 81 ,080 58,318 1 - - _ 467,391 - (536,923 69,532 14.88% 119 525-17-2400 SANITFATIISUBTOTAOINSANITMAL ATiON FUND 1641 - 362,689 _ _ _ 377,969 8.53h _ -. ,.--- -. -- T -..- -- - 4.21� _ 111 ,700 _ 113,380 .-- __ 250989_ 2646589 13,600 5.42% -. . __� _ 6,029,583 6089962 ,, 1_._00% I 5,881 ,039 6,089,9621 0 -- -- 120 _. _- _... .. -. - __. - _ 148,544 O T (148.544) 100.00% 1 1 ) 121 _ 1TOTAL-BUSINESS TYPE ACTIVITIES 731 47,556,812 39107236 17.77% 48,835398 41 ,401 ,937 0 2,427,130 1 2294,701 1 , 148,544 (2,038,125 -100.00% 122 - - 123 -_ T 124 DEBT SERVICE 1251o0 IGEN. OBLIGATION BOND DEBT SERVICE 54F 13,157,973 (5,444561 ) I� _(5338465) 1_ 71216,045 _ 7,601 ,650 126 tot TIF ECONOMIC DEV & REBATES -_ 43E 2,610,938 11 12 673,698 2.40% _ 9,398,510 463,385 1 (127 000) 6,914,572 (147,000 - 385,605 5.3_4% 128 I __ ) __. - p _._ (268.50301 268,500- _ 10,709,_7_61 7,914,560 _ NEW - _. 0 0.00% � __. 0 -_. ) ( ) 11 0.00% 127101 1TAX INCREMENT DEBT SERVICE 154E 0 129 - TOTAL-DEBT SERVICE -� -- - �- _ _- _-4 (5,571 ,561 � (5485,465 7,914,560 7,-216045 -7,333, 147 -- 117, 102 '; 1 .62% 130 _ I 1 .96% 9,895,877 11 , 173,146 I - ) 6,914,572 131 tsontsell � 133 419/420-8980 G.O. BOND PROCEEDS_ -- I55G - 11 ,000,000_ 11 ,000,0001 - - - --- , r -- -- - 1-- 132 CAPITAL PROJECTS 134 1 G.O. BONDICAPITAL PROJECTSf _ _. _ _ p _ 0.00% 135 417/418/419/419 LG.O. BOND/CAPITAL PROJECTS-TIF - -- - I56G 5,000,0000 1 _ 5 OOO OOOo I_ 0.00 % 0 __ . _. _ _ . . 51000,000 5t000lo0o -.. 0 1!, 0.00% -. 0.001 0 _ _ o 0.00% 11000,000 1 11 ,000,000 136 417 G.D. BOND/CAPITAL PROJECTS-TECHWORKS IBD 55G 1 0 0 0.00% 0 ! - - 0 0 I)- ' 1 _ - y - - i I_ - - _ - _ p 0 I 0.00% 138 426-07-7400 ( CAP IMPR BRIDGES - - I55G .750,0_00 1 _ . --- 1 - .. - .. -- -- - -. -- - O -� _ - 55G _ . -. - 265,000._ 1 _-- 0 1� 100.00 -.- 265.000 0 0 ~_ 0 ,` 0.00% 13942607-7355 CAP IMPR 1 - T 1 -. _ _ 0_ _ O 0 0.00% _ - � 55G 0 1 ,000,00 1900.00% f _ --- 50,000 1 ,Ooo,--000 .__ -_ _..-- -.... _ _ 0 0.00% 140 426-07-7650 CAP IMPR 426-07-7610 CAP IMPR -- COMMERCIAL ALNT IS T EETSCAPE55G 50,000 - I 0 1 _. 500,000 T 1 C - . 0 0 _. _ 500 000 0.00 %� 0 O 0.00%142 01 143 426-37-4202 _._ y- 0 _ 0 01_ __ 42637-0105 _,. ICAP IMPR - -ALL DIAMOND -- 37LINC GAME (55G 179,4801 _ O t00.00% � --- _ __ 179,4809 _ - -- -.� -._.-- 0I 01 0 i 0.00% 144426-37-4105 CAP IMPR -CAP IMPR BNCOLN PARK ROJEECTMENTS 37LIN FAME !: 55G 0 0 ! 0.00% 0 - __ 9 1 - 0.00% _ -__ -_. __ o 01 0 ' 145 426-37-0207 CAP IMPR - BOAT HOUSE AREA IMPR _ 155G _ 0 _ 0 I 0.00 / � _ 0 _0 10 01 0.00% 146 426-08-62_05 CAP IMPR - SAN MARNAN TIF PROF) 56G 151000 1 1 ,000,000 6566.67 / 0 0 ) _ O 0 0.00_% 14742608-6210 - ICAP IMPR - BATH TIF PROJECTS - 56G -._-_� U 300,00 0.00% _. Of _ 0 -_ _- _ ... ),I. 0 - - T 0 0.00_% t 300,000 1 - 148 426 06-6220 - CAP IMPR - NE SITE TIF PROJECTS _ 56G T 196,000 0 �I -100.00% 0-� - (300,000) 1 (1(300 000 5 OT 1 0.00% ., 56G CAP IMPR - MARTIN RD 150 426 OB-6260 ..149 426-08-6250 ICAP IMPR =M SPORT TIFIPROJOECTSTS 1 _ I56G �_ 2,0_48,033 .. -- 1 400 000 - ----- - 0 o ) -- - 0 0 0 64% 151 42608-6270 ICAP IMPR - DOWNTOWN TIF PROJECTS � 56G 1 40,000 750.0001 177500%T OI01 (2(048,033) 1 (1400000) 1 _ D 1 O 01 0.00% -__ _. _ ._ - ) _ _ )� p - - _ 0.00% _- - 0 0 (40�000)� .. 1 0 0 0 ° o (t ,z5o,0001 ,z5o.opo (750,000 152 .. i 0 0 0.00% - _ _ 56G 1 1 ,250,0001 0 100.00 / 153 426 08-6280 CAP IMPR - LOGAN I56G 0 1 ,250,000 __ NEW 0 0 _ 1 - 0.00% 155 ( TOTAL-CAPITAL PROJECTS - 1 154 - 0 p - ORTH CROSSING 157G 21 ,093,522 1 22,200,000 525 /0 12,244,489 12,500,000 3,849,033_ o - 1 157 - 1 - - - . T -_. _. I _. ( - ) (4,700000) 1 _ 0 5,000_,000 5,OOQ - - 0 0.00% _. ._. ..--_ _... 158 TOTAL CITY BUDGET - OTHER FUNDS 1 135,491 .160 132,945,430 -1 .88% � 116,954.07311 115,075,9081 9,420,594 9,541 ,702 10, 185,465 10,309,2611 18,658,195 17,993,3161 1 ,554,458 -3.56% KAUSERSWICHELLE-MBudget FYE221FY22 BUDGET-Published March 15 Print Copy.xisx 3 3/15/2021 11 :54 AM A B C I D E F G H I publis ed BudgOl 2 City of Waterloo 3/ 15/21 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) 351391 , 350 23 , 448 1 cent on the levy raises this much 10 General Fund Personal Services increases (decreases) : 11 Salaries & longevity 8191876 2 . 32 % Includes avg 2 . 0 % raises , 3 . 0 % for Police and Fire , 12 0 0 . 00 % step increases , longevity 13 Add 1 Chief of Staff 1761616 0 . 50 % 14 Add 4 SAFER - regular salary only 21 , 716 0 . 06 % 15 Increase in Personnel Costs Charged to Police Grants 81457 0 . 02 % 16 Increase in Personnel Costs Charged to SAFER Grants 2081356 0 . 59 % 17 Decrease Part Time Labor (28 , 053) - 0 . 08 % 18 Misc , overtime , double time , and bonus pay 151336 0 . 04 % 19 Police & fire overtime , doubletime & bonus pay 471410 0 . 13 % 20 Payroll taxes 60 , 265 0 . 17 % 21 Employee sick and casual payouts 91546 0 . 03 % 22 Retirement payouts 96 , 951 0 . 27 % 23 24 Health insurance 4891859 4 . 89 % 31163 , 028 1 . 34893 Personnel increases excl . 25 Retiree health insurance 181482 fire & police pension 26 Reduce use of health insurance fund balance 1 , 218 , 211 117261552 27 Police Pension 1741201 28 Fire Pension 194 , 155 368 , 356 1 . 04 % 31531 , 384 1 . 50603 Total personnel increases 29 Subtotal - Personnel Increases 3 , 531 , 384 9 . 98 % 30 31 232 KAUSERS\MICHELLE-W\Budget FYE22\FY22 BUDGET_Published March 15 Print Copy.xlsx\ Comparison to FYE21 3/ 15/2021 11 : 55 AM A B CD EI F G H I Bublis ed Budgjq 2 City of Waterloo 3/ 15/21 3 FYE2022 General Fund 4 Proposed Budget Change In Cost From FY21 5 % of Total 6 Amount Change From 7 Prior Year Tax Levy 35 Contractual Services and Commodities Expense Changes : 36 Airport - Decrease Advertising , etc (59 , 945) - 0 . 17 % 37 BH County EMA - Increase Exp 175 0 . 00 % 38 Building Inspections - Software 21 , 836 0 . 06 % 39 Clerk Finance - Software , Misc 17 , 000 0 . 05 % 40 Clerk Finance - Elections 60 , 000 0 . 17% 41 Cultural Arts - Decrease Utilities , Misc ( 16 , 800) -0 . 05 % 42 Communications - Increase Newsletter 51000 0 . 01 % 43 Fairview Cemetery Association 201000 0 . 06 % 44 Fire - Decrease software , dispatch ( 11148) 0 . 00 % 45 Fire - Ambulance - Increase billing , training , repairs , equipment 868 , 950 2 . 46 % 46 Garage - Utilities 160 0 . 00 % 47 INRCOG Dues 685 0 . 00 % 48 Leisure Services Golf - Decrease in Sales Tax (65) 0 . 00 % 49 Leisure Golf Course Improvements Decrease (316) 0 . 00 % 50 Leisure Sportsplex Decrease ( 11 , 897) -0 . 03 % 51 Liability Insurance 1951200 0 . 55 % 52 Library - Increase Grant Funded Expenses 21200 0401 % 53 Mayor - Increase telephone 60 0 . 00 % 54 MET - Increase in Requested Funding 43 , 877 0 . 12 % 55 Parking - Decrease Expenses ( 12 , 500) - 0 . 04 % 56 Planning - Software Expenses 45 0 . 00 % 57 Police - Increase health services , uniforms , travel , misc 531444 0 . 15 % 58 Police - Increase for Axon contract 4071766 1 . 15 % 59 Police - Increase Grant Expenses 137 , 469 0 . 39 % 60 Police - Increase ATE Expenses 243856 0 . 07% 61 Self Funded Workers Compensation 60 , 000 0 . 17 % 62 0 0 . 00 % 63 65 Subtotal - Contractual Services and Commodities Increases 1 , 816 , 052 5 . 13 % 51347 , 436 2 . 28052 Total all expense increases 66 K:\USERSWICHELLE-W\Budget FYE22\FY22 BUDGET_Published March 15 Print Copy.xlsx\ Comparison to FYE21 3/ 15/2021 11 : 55 AM A B C D E F G H I publis ed Budgol 2 City of Waterloo 3/ 15/21 3 FYE2022 General Fund 4 Proposed Budget Change In Cost From FY21 5 % of Total 6 Amount Change From 7 Prior Year Tax Levy 87 Revenue ( Increase )/Decrease : 88 Airport - Decrease 1161147 0 . 33 % 89 Building Inspection - Increase Dept Charges (233) 0 . 00 % 90 Clerk/Finance - Decreases 251743 0 . 71 91 Cultural/Arts - Decreased Revenue 16 , 410 0 . 05 % 92 Fire - Grant Increases (284 , 192) - 0 . 80 % 93 Fire Ambulance - Increases ( 11250 , 500) -3 . 53 % 94 Fire- Increased Revenue (21938 ) - 0 . 01 95 Leisure Golf Course Improvements Decrease 316 0 . 00 % 96 Leisure Services Golf - Decrease 11003 0 . 00 % 97 Library - Decrease Fine revenue 101560 0 . 03 % 98 Library Increase Grant Funding (41274) - 0 . 01 99 MIS - Decrease 41749 0 , 01 % 100 Parking Revenue - Decrease 12 , 500 0 . 04 % 101 Planning - Increase in Revenue ( 193 , 444) -0 . 55 % 102 Police Operations Budget - Increased ATE revenue released to operations (407 , 766) - 1 . 15 % 103 Police - ATE Project Increased Revenue (945 , 498) -2 . 67 % 104 Police - Amount of ATE released 9201642 2 . 60 % 105 Police - Increase Grant Revenue ( 172 , 836) -0 . 49 % 106 Public Access Fees 400 0 . 00 % 107 Use of State Covid Money received in 2021 ( 17600 , 155) -4 . 52 % 109 Subtotal - Revenue Net ( Increases) Decreases (31527 , 366) - 9 . 96 % - 1 . 50431 Total all revenue changes 114 115 Total Increases (Decreases) 1 , 820 , 070 5 . 15 % 116 0 . 00 % 117 Property Taxes Required ( Excl Debt Service , Library Levy, 118 Grout Levy) 371211 , 420 123 124 Total change in taxes - formula check 118201070 125 126 Variance - property taxes required (0) 127 128 Increase in Debt Service Levy 3851605 129 Increase in Grout Taxes 21931 130 Increase in Library Levy 21931 131 132 Total Additional Taxes 2 , 211 , 537 133 0 K:\USERS\MICHELLE-W\Budget FYE22\FY22 BUDGET—Published March 15 Print Copy.xisx\ Comparison to FYE21 3/ 15/2021 11 : 55 AM 3/14/20218:38 PM City of Waterloo FYE2022 Budget Sample Property Tax Collections and Property Tax Changes(Amounts and Percentages) FYE2022 FYE2021 FYE2020 FYE2019 Residential Rollback 56.4094% 55.0743% 56.9180% 55.6209% Commercial Rollback 90.0000% 90.0000% 90.0000% 90.0000% Multi-Residential 67.5000% 71.2500% 75.0000% 78.7500% Total Budgeted Property Tax Collections 43,867,749 42,065,175 40,438,265 State Commercial/Industrial Rollback Replacement 1,543,522 1,588,239 1,668,470 Total Property Taxes and Rollback Replacement Funds 45,411,271 43,653,414 42,106,735 Net Property Monthly Monthly Monthly Tax Increase Increase Increase Increase (Decrease)This %Increase (Decrease) (Decrease) (Decrease) Property Tax Collections Level from State Comm %Increase (Decrease) Residential Commercial Industrial Increase(Decrease)from Property Tax %Increase Staff Requests Rollback (Decrease) Commercial ($100,000 ($500,000 ($1,000,000 FYE2021 Collections (Decrease) Level Repl Funds Residential &Industrial Levy Rate Home) Property) Property) Option 1-Base Level - Base level includes personnel ccontractual changes only and use of$750,000 general fund balance 2,735,447 46,603,196 6.24% 2,735,447 1,650,156 8.25% 5.68% $ 19.48851 $ 6.98 $ 39.31 $ 78.62 Option 2-Staff Requests Level - This level includes requested changes and use of$750,000 general fund balance 3,812,118 47,679,867 8.69% 3,812,118 1,686,513 10.69% 8.07% $ 19.92807 $ 9.05 $ 55.79 $ 111.59 Option 3-Published Budget This level includes State Covid-19 grant funds to reduce the property tax levy 2,211,533 46,079,282 5.04% (1,600,585) 1,584,582 6.90% 4.37% $ 19.24546 $ 5.84 $ 30.20 $ 60.39 Option 4-4%Increase to Residential Budget changes not identified 977,383 44,845,132 2.23% (2,834,735) 1,584,582 4.00% 1.54% $ 18.72363 $ 3.38 $ 10.63 $ 21.25 Option 5- 3%Increase to Residential Budget changes not identified 557,383 44,425,132 1.27% (3,254,735) 1,569,423 3.00% 0.57% $ 18.54451 $ 2.54 $ 3.91 $ 7.82 Option 6-2%Increase to Residential Budget changes not identified 132,383 44,000,132 0.30% (3,679,735) 1,554,084 2.00% -0.42% $ 18.36326 $ 1.69 $ (2.89) $ (5.78) Option 7-Levy Rate of$18.44003(2.42%increase-equivalent to state increase in residential rollback) Budget changes not identified 312,383 44,180,132 0.71% (3,499,735) 1,571,652 2.42% 0.00% $ 18.44003 $ 2.05 $ (0.01) $ (0.02) Option 8-Levy Rate of$18.40693(2.24%increase) Budget changes identified plus 120 day hiring delays and 5 furlough days 245,290 44,113,039 0.56% (3,566,828) 1,557,779 2.24% -0.18% $ 18.40693 $ 1.90 $ (1.25) $ (2.50) Option 9-Levy Rate of$18.00313(no residential tax increase) (712,067) 43,155,682 -1.62% (4,524,185) 1,510,688 0.00% -2.37% $ 18.00313 $ (0.00) $ (16.39) $ (32.78) Rate Impacts FYE22 Mar 14.xlsx Rate Impacts Mar 14 2021 Page 1 of 1 3/15/20213:47 PM FYE2022 Budget General Fund Staff Requests with Changes as of March 15,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 (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 Changes 3 15 21.xlsx GF Pot Adj Version 3 Page 1 of 5 3/15/20213:47 PM FYE2022 Budget General Fund Staff Requests with Changes as of March 15,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 1105 1321 Data Processing - 1520 Computer Software - (Decr)/Incr Expenses 46,750.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 Changes 3 15 21.xlsx GF Pot Adj Version 3 Page 2 of 5 3/15/20213:47 PM FYE2022 Budget General Fund Staff Requests with Changes as of March 15,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 Utilities (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 (215,627.04) (Decr)/Incr Revenue 1,200.00 K:\USERS\MICHELLE-W\Budget FYE22\Breakout of Staff Budget Requests with Changes 3 15 21.xlsx GF Pot Adj Version 3 Page 3 of 5 3/15/20213:47 PM FYE2022 Budget General Fund Staff Requests with Changes as of March 15,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 (673,696.52) 1,701,200.01 General Fund Net Revenue Less Expense (2,374,896.53) Tax Rate Residential Comm Total Changes from Above (2,374,896.52) 18.91507 5.06% 2.57% Target to Cut to get to 2.42%increase 3,499,735.00 Balance remaining to 2.42%increase 1,124,838.47 Target to cut to get to 3%increase 3,254,735.00 Balance remaining to 3%increase 879,838.47 K:\USERS\MICHELLE-W\Budget FYE22\Breakout of Staff Budget Requests with Changes 3 15 21.xlsx GF Pot Adj Version 3 Page 4 of 5 3/15/20213:47 PM FYE2022 Budget General Fund Staff Requests with Changes as of March 15,2021 Expenses Revenue Addition (Addition) (Reduction) Reduction Target to cut to get to 4%increase 2,834,735.00 Balance remaining to 4%increase 459,838.47 Add Hiring Delays 120 days (586,076.00) Total Reductions (2,960,972.53) 18.66512 3.67% 1.22% Add Hiring Delays 120 days (586,076.00) Add 5 Furlough Days (546,985.00) Total Reductions (3,507,957.53) 18.43185 2.38% -0.05% K:\USERS\MICHELLE-W\Budget FYE22\Breakout of Staff Budget Requests with Changes 3 15 21.xlsx GF Pot Adj Version 3 Page 5 of 5 FYE2022 Budget General Fund Staff Requests Expense Revenue Changes Changes BH EMA Additional Expense Requests BH EMA Revenue Adjustments 1393 Contributions 175.00 (Decr)/Incr Expenses 175.00 (Decr)/Incr Revenue Grout Additional Expense Requests Grout Revenue Adjustments 1393 Contributions 3,210.00 (Decr)/Incr Expenses 3,210.00 (Decr)/Incr Revenue Fairview Additional Expense Requests Fairview Revenue Adjustments 1393 Contributions 20,000.00 (Decr)/Incr Expenses 20,000.00 (Decr)/Incr Revenue INRCOG Additional Expense Requests INRCOG Revenue Adjustments 1393 Contributions 685.00 (Decr)/Incr Expenses 685.00 (Decr)/Incr Revenue MET Additional Expense Requests MET Revenue Adjustments 1393 Contributions 43,877.00 (Decr)/Incr Expenses 43,877.00 (Decr)/Incr Revenue Mayor Additional Expense Requests Mayor Revenue Adjustments 1344 Telephone 60.00 8280 1335 Public Info 5,000.00 (Decr)/Incr Expenses 5,060.00 (Decr)/Incr Revenue Clerk Additional Expense Requests Clerk Revenue Adjustments 1520 Computer Software 17,000.00 1780 Election Costs 60,000.00 (Decr)/Incr Expenses 77,000.00 (Decr)/Incr Revenue K:\USERS\MICHELLE-W\Budget FYE22\Publis rials\Overall Budget Materials\Breakout of S ests with Changes 3 15 214 pm.xlsx Staff Requests-GF Only 3/16/20218:35 AM Page 1 of 5 FYE2022 Budget General Fund Staff Requests Expense Revenue Changes Changes Liability Insurance Additional Expense Requests Liability Insurance Revenue Adjustments 1359 Ins Claims 50,000.00 1361 Property Ins 45,200.00 1364 Tort Ins 100,000.00 (Decr)/Incr Expenses 195,200.00 (Decr)/Incr Revenue Work Comp Additional Expense Requests Work Comp Revenue Adjustments 1313 Legal 25,000.00 1360 Stop Loss Ins 10,000.00 1365 Work Comp Pmts 25,000.00 (Decr)/Incr Expenses 60,000.00 (Decr)/Incr Revenue - Planning Additional Expense Requests Planning Revenue Adjustments 1319 Other Proff Sery (205.00) 3620 Rent 9,000.00 1520 Software 250.00 3622 Sale of Property 180,000.00 (Decr)/Incr Expenses 45.00 (Decr)/Incr Revenue 189,000.00 Police Additional Expense Requests Police Revenue Adjustments 1100 1314 Health Services 4,000.00 1345 Travel 500.00 1346 Training 47,300.00 1377 Radio Maintenance 1,470.00 1390 Other Contractual (1,826.00) 1579 Uniforms 2,000.00 1105 1321 Data Processing 11,000.00 1520 Computer Software 6,000.00 (Decr)/Incr Expenses 70,444.00 (Decr)/Incr Revenue Fire Additional Expense Requests Fire Revenue Adjustments 1400 1400 1130 Empl Benefit Reimb 11,000.00 3416 Commercial Fire (3,000.00) K:\USERS\MICHELLE-W\Budget FYE22\Published Budget Materials\Overall Budget Materials\Breakout of Staff Budget Requests with Changes 3 15 214 pm.xlsx Staff Requests-GF Only 3/16/20218:35 AM Page 2 of 5 FYE2022 Budget General Fund Staff Requests Expense Revenue Changes Changes 1377 Radio Repair 424.00 3721 Service Charges 5,000.00 1390 Other Contractual (817.00) 3515 False Alarms (1,000.00) 1520 Computer Software (755.00) 1410 1410 1116 Holiday Bonus 3,500.00 3414 Ambulance Fee 1,250,000.00 1130 Empl Benefit Reimb 1,500.00 3721 Service Charges 500.00 1311 Accounting Software 12,000.00 1315 Educational Training 25,000.00 1319 Other Prof Services 680,000.00 1378 Other Equip Repair 2,000.00 1390 Other Contractual 15,000.00 1391 Dues&Memberships 1,950.00 1551 Drugs,medicine supplies 10,000.00 1785 Refunds 23,000.00 2116 Medical/Lab Equipment 100,000.00 (Decr)/Incr Expenses 883,802.00 (Decr)/Incr Revenue 1,251,500.00 (367,698.00) -29% Garage Additional Expense Requests Garage Revenue Adjustments 1400 Utilities 160.00 (Decr)/Incr Expenses 160.00 (Decr)/Incr Revenue Bldg Inspection Additional Expense Requests Bldg Inspection Revenue Adjustments 1520 Software 13,888.00 1555 Minor Equip/Supplies 200.00 (Decr)/Incr Expenses 14,088.00 (Decr)/Incr Revenue Cultural Arts Additional Expense Requests Cultural Arts Revenue Adjustments 4208 4208 1319 Other Prof Services (800.00) 3620 Rent (4,800.00) 1350 Exhibition Expense (2,000.00) 3487 Gift Shop (9,000.00) 1351 Advertising Expense (1,500.00) 3873 Reimbursement for Service (3,000.00) 1378 Other Equip Repair (1,000.00) 1504 Credit Card Fees (1,000.00) 1521 Electrical Supplies (500.00) 1553 Merchandise for Resale (5,000.00) K:\USERS\MICHELLE-W\Budget FYE22\Published Budget Materials\Overall Budget Materials\Breakout of Staff Budget Requests with Changes 3 15 214 pm.xlsx Staff Requests-GF Only 3/16/20218:35 AM Page 3 of 5 FYE2022 Budget General Fund Staff Requests Expense Revenue Changes Changes 1561 Office Supplies (500.00) 4250 1378 Other Equip Repair (1,000.00) 1390 Other Contractual Sery (1,000.00) 1400 Utilities (1,000.00) 1533 Fuel (300.00) 1539 Institutional Supplies (700.00) 1561 Office Supplies (500.00) (Decr)/Incr Expenses (16,800.00) (Decr)/Incr Revenue (16,800.00) Airport Additional Expense Requests Airport Revenue Adjustments 1315 Training (10,000.00) 3620 Rent/Prop Leases (25,000.00) 1319 Prof Services (6,500.00) 3449 Parking Lot (35,000.00) 1346 Travel (2,000.00) 3453 Landing Fee (28,500.00) 1351 Advertising (25,936.00) 1357 Prop Taxes (2,428.00) 3477 Sale of gas/oil (17,947.00) 1364 Tort Insurance 1,133.00 3481 Concession Rev (1,200.00) 1371 Building/Grounds Mntc 5,995.00 3873 Reimb for Service (8,500.00) 1384 Leased equip 8,000.00 1390 Other Contr Services (1,226.00) 1392 Subscriptions 200.00 1520 Computer Services 1,500.00 1533 Fuel (3,517.00) 1538 Fuel for Resale (9,066.00) 1553 Merchandise for Resale (2,100.00) 1569 Vehicle Parts (6,000.00) 1571 Machinery Parts (8,000.00) (Decr)/Incr Expenses (59,945.00) (Decr)/Incr Revenue (116,147.00) Library Additional Expense Requests Library Revenue Adjustments 3100 3470 Library Fees (10,560.00) (Decr)/Incr Expenses (Decr)/Incr Revenue (10,560.00) Leisure Additional Expense Requests Leisure Revenue Adjustments K:\USERS\MICHELLE-W\Budget FYE22\Published Budget Materials\Overall Budget Materials\Breakout of Staff Budget Requests with Changes 3 15 214 pm.xlsx Staff Requests-GF Only 3/16/20218:35 AM Page 4 of 5 FYE2022 Budget General Fund Staff Requests Expense Revenue Changes Changes 4100 1118 Bonus Pay 16,136.00 stand by pay for Forestry Golf Golf 1398 Sales Tax (65.00) 3472 Golf Revenue (1,003.00) (Decr)/Incr Expenses 16,071.00 (Decr)/Incr Revenue TOTAL GF 1,313,072.00 1,296,993.00 Net Increase 16,079.00 K:\USERS\MICHELLE-W\Budget FYE22\Published Budget Materials\Overall Budget Materials\Breakout of Staff Budget Requests with Changes 3 15 214 pm.xlsx Staff Requests-GF Only 3/16/20218:35 AM Page 5 of 5 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 N11 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 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-I 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 7CENTRAL 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,971 31,962 FACILITIES MAINTENANCE 010 187950 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 33,102 CULTURAL ARTS 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 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 15,298 22,948 30,597 3 TOTAL LEISURE SERVICES-PARKS 323,287 323,287 53,142 79,716 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 7 62,058 7 62,058 10,201 15,302 20,403 LEISURE SERVICES-SPORTS 010 37 4200 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,340 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 K:\USERS\MICHELLE-W\Budget FYE22\Personnel Worksheets FYE22_Published MayorlProposed.xlsx 3/14/2021 8:41 PM 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.22 VACANT-(75%) Libr.Asst.-PT 13,680 13,680 2,249 3,373 4,498 0.16 VACANT(50%) Libr.Asst.-PT 9,208 9,208 1 1,514 2,270 1 3,027 0.69 TOTAL LIBRARY TAX LEVY 58,257 L 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-L1 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 L 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 1 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 7,257 10,886 14,514 1 VACANT- Solid Waste Technici, 93,166 93,166 15,315 22,972 30,630 1 VACANT- Solid Waste Technici, 93,166 93,166 15,315 22,972 30,630 1 POT VACANT-(anticipated 7/31/21) Solid Waste Technicia 93,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 K:\USERS\MICHELLE-W\Budget FYE22\Personnel Worksheets FYE22_Published Mayo2Proposed.x1sx 3/14/20218:41 PM 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 WASTE MGMT-WATER POLLUTION 520 14 5200 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 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 1 TOTAL STORM SEWER MAINTENANCE 186,130 93,065 23,266 19,123 28,685 38,246 47.72 GRAND TOTALS K:\USERS\MICHELLE-W\Budget FYE22\Personnel Worksheets FYE22_Published Mayoi3Proposed.x1sx 3/14/2021 8:41 PM 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 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 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 Mayor4Proposed.xlsx 3/14/2021 8:41 PM