Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Supplemental Attachments - 3/16/2020
FYE2021 GENERAL FUND MAYOR -STAFF BUDGET ADJUSTMENTS - AS OF MARCH 15, 2020 Dept/Area/Program Account Revenue Increase (Decrease) Expense Decrease (Increase) Comment Net Activity $8.10 Subtotal Police/Fire Pension Employee Benefits Other Levies Total Cuts (Additions) BUILDING INSPECTIONS 1100 series $ 91,807.00 Don't add an inspector $ 61,984.00 $ 29,823.00 $ 91,807.00 11,768.00 $ 11,768.00 Charge 20% of secretary to RUT $ 11,768.00 0.00 103,575.00 73,752.00 0.00 29,823.00 0.00 103,575.00 HUMAN RIGHTS 1 1100 series $ 85,040.00 Don't add staff 56,139.00 28,901.00 85,040.00 10,000.00 Don't add outreach funding 10,000.00 10,000.00 0.00 95,040.00 66,139.00 0.00 28,901.00 0.00 95,040.00 PLANNING & ZONING 1 1100 Series 14,101.00 Alloc Noel Salary to RUT 14,101.00 14,101.00 1 1100 series 7,050.50 Alloc Noel Salary to Storm Water 7,050.50 7,050.50 0.00 0.00 21,151.50 21,151.50 0.00 0.00 0.00 21,151.50 CITY ATTORNEY 1 1100 series 82,517.00 Don't add new asst attorney position 53,997.00 28,520.00 82,517.00 0.00 82,517.00 53,997.00 0.00 28,520.00 0.00 82,517.00 MAYOR/COMM U NICATI ONS 1 1346 1,000.00 Reduce travel 1,000.00 1,000.00 0.00 0.00 0.00 0.00 0.00 1,000.00 1,000.00 0.00 0.00 0.00 1,000.00 INFORMATION TECHNOLOGY Revenue 86,178.10 Fund 85% of new position with LOT 86,178.10 86,178.10 2,000.00 1344 2,000.00 Reduce phone service 2,000.00 0.00 0.00 86,178.10 2,000.00 88,178.10 0.00 0.00 0.00 88,178.10 FYE2021 Budget Proposed Adjustments Mayor Mar 15.xlsx General Fund 1 3/16/2020 2:14 PM FYE2021 GENERAL FUND MAYOR -STAFF BUDGET ADJUSTMENTS - AS OF MARCH 15, 2020 Dept/Area/Program Account Revenue Increase (Decrease) Expense Decrease (Increase) Comment Net Activity $8.10 Subtotal Police/Fire Pension Employee Benefits Other Levies Total Cuts (Additions) CULTURAL & ARTS 1100 series 19,191.00 Fund a portion of new Digital Arts Mgr position with hotel/motel tax 19,191.00 19,191.00 1100 series 53,392.00 No additional pay increases over base 53,392.00 53,392.00 10,000.00 1337 10,000.00 Don't increase facilities repair account 10,000.00 0.00 82,583.00 82,583.00 0.00 0.00 0.00 82,583.00 AIRPORT 1 1100 series 87,043.00 Remove New FT Ops Specialist 57,928.00 - 29,115.00 87,043.00 1112 or 1351 (25,936.00), Add back funds to make property taxes zero - use either for PT staff or advertising (25,936.00), (25,936.00) 0.00 0.00 0.00 61,107.00 31,992.00 0.00 29,115.00 0.00 61,107.00 LIBRARY 1100 series 56,010.00 Don't add 1 position 36,319.00 19,691.00 56,010.00 50,000.00 (20 000.00) 19,986.00 50,000.00 Reduce add'' materials 50,000.00 (20,000.00J Add back a portion for materials (20,000.00) 1100 series 19,986.00 - Incr % to library levy by 1% 19,986.00 1100 series Hiring delays 0.00 0.00 0.00 105,996.00 86,305.00 0.00 19,691.00 0.00 105,996.00 HUMAN RESOURCES 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 POLICE Revenue 0.00 0.00 3581 182,509.00 Increase Released ATE Revenue 182,509.00 182 509.00 3581 175,856.00 175,856.00 175,856.00 00) (3,,269.269. ) 1100 series (3,269.00) Salary Adjustment (2,580.00 (615.00) (74.00) 1114 30,537.00 - Reduce Overtime Req 30,000.00 537.00 30,537.00 1377 Hiring Delays 0.00 0.00 0.00 0.00 358,365.00 27,268.00 385,785.00 (615.00)_ 463.00 0.00 385,633.00 FYE2021 Budget Proposed Adjustments Mayor Mar 15.xlsx General Fund 2 3/16/2020 2:14 PM FYE2021 GENERAL FUND MAYOR -STAFF BUDGET ADJUSTMENTS - AS OF MARCH 15, 2020 Dept/Area/Program Account Revenue Increase (Decrease) Expense Decrease (Increase) Comment Net Activity $8.10 Subtotal Police/Fire Pension Employee Benefits Other Levies Total Cuts (Additions) FIRE 1118 0.00 Don't increase bonus pay 0.00 0.00 0.00 0.00 1114 (96,378.00) Don't reduce overtime (95,000.00) (1,378.00) (96,378.00) 1100 series 106,299.00 Don't budget for safer grant - 25% 89,821.00 16,478.00 1100 series (318,896.00) 318,896.00 Don't budget for safer - 75% 106,299.00 1100 grant (49,437.00) 49,437.00 0.00 series - Hiring delays 0.00 0.00 0.00 0.00 (318,896.00) 328,817.00 _ (54,616.00) 65,915.00 (1,378.00) 0.00 .00 9,921.00 LEISURE - PARKS 1100 Series (5,436.00) Salary adjustments (4,618.00) 1100 Series (818.00) 5 436.00 () - Hiring delays 0.00 0.00 0.00 0.00 0.00 0.00 0.00 (5,436.00) (4,618.00) 0.00 (818.O0) 0.00 (5,436.00)_ I CLERK/FINANCE 3 3489 (15,000.00) Reduce cable franchise fee (15,000.00) (15,000.00) 3151 120,000.00 Increase estimated utility franchise fee 120,000.00 120,000.00 0.00 0.00 0.00 0.00 105,000.00 0.00 105,000.00 0.00 0.00 0.00 105,000.00 FACILITIES MAINTENANCE - R Revenue 25,000.00 Add chargebacks revenue to Conv Ctr 25,000.00 25,000.00 0.00 0.00 25,000.00 0.00 25,000.00 0.00 0.00 0.00 25,000.00 CENTRAL GARAGE 1 1100 series 91,123.00 Don't add add! mechanic 61,402.00 29,721.00 91,123.00 0.00 _ 0.00 0.00 0.00 0.00 0.00 0.00 91,123.00 61,402.00 0.00 29,721.00 0.00 91123.00 FYE2021 Budget Proposed Adjustments Mayor Mar 15.xlsx General Fund 3 3/16/2020 2:14 PM FYE2021 GENERAL FUND MAYOR -STAFF BUDGET ADJUSTMENTS - AS OF MARCH 15, 2020 Dept/Area/Program Account Revenue Increase (Decrease) Expense Decrease (Increase) Comment Net Activity $8.10 Subtotal Police/Fire Pension Employee Benefits Other Total Cuts Levies (Additions) =--=- 0.00 0.00 CENTRAL GARAGE - MOTOR POOL 0.00 0.00 . 0.00 0.00 0.00 0.00 0.00 AMBULANCE 0.00 0.00 - Hiring delays 0.00 0.00 250,000.00 Increase ambulance revenue 250,000.00 250,000.00 0.00 0.00 250,000.00 0.00 250,000.00 0.00 0.00 0.00 250,000.00 INSURANCE ADMIN 1359 0.00 0.00 1364 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 LEISURE - DOWNTOWN MTCE 1100 series - Hiring delays 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 COUNCIL 1346 (1,500.00) Increase council travel (1,500.00) 1344 . 0.00 (1,500.00) 0.00 0.00 (1,500.00 (1,500.00) 0.00 0.00 0.00 (1,500.00) BHC EMERGENCY MGMT AGENCY 1 1393 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Health Insurance Ad"ustments 0.00 0.00 Hiring Delays - Included above 0.00 0.00 Reduce Fund Balance to $760,000 (553,782.00) (553,782.00) (553,782 00) Debt Service Changes 0.00 0.00 MET Changes 72,000.00 72,000.00 72 000.00 FYE2021 Budget Proposed Adjustments Mayor Mar 15.xlsx General Fund 4 3/16/2020 2:14 PM FYE2021 PENERAL FUND MAYOR -STAFF BUDGET ADJUSTMENTS - AS OF MARCH 15, 2020 Dept/Area/Program Account Revenue Increase (Decrease) h.rpense Decrease (Increase) Comment Net Activity $8.10 Subtotal Police/Fire Pension Employee Benefits Other Levies Total Cuts (Additions) J I_ Rollback Replacement Change 0.00 0.00 Total Changes $ (48,134.90) $ 1,067,241.50 $ 789,768.60 $ 65,300.00 $ 164,038.00 $ - $ 1,019,106.60 Reductions Needed Adjusted Increase (Decrease) in Taxes 1,019,106.60 $ (789,768.60) $(65,300.00) $ (164,038.00) $ - $(1,019,106.60) Change in Tax Askings (9.33838)_ (0.02798) (0.07028) - (0,43673) Levy Rate - Prior Level 18.87699 Levy Rate - Current Level 18.44026 FYE2021 Budget Proposed Adjustments Mayor Mar 15.xlsx General Fund 5 3/16/2020 2:14 PM 3/16/2020 2:30 PM City of Waterloo FYE2021 Budget Sample Property Tax Collections and Property Tax Changes (Amounts and Percentages) FYE2021 FYE2020 FYE2019 FYE2018 Residential Rollback 55.0743% 56.9180% 55.6209% 56.9391% Commercial Rollback 90.0000% 90.0000% 90.0000% 90.0000% Multi -Residential 71.2500% 75.0000% 78.7500% 82.5000% Total Budgeted Property Tax Collections 42,065,175 40,438,265 41,101,136 State Commercial/Industrial Rollback Replacement 1,588,239 1,668,470 1,742,363 Total Property Taxes and Rollback Replacement Funds 43,653,414 42,106,735 42,843,499 Monthly Monthly Monthly Net Property Increase Increase Increase Tax Increase % Increase (Decrease) (Decrease) (Decrease) Property Tax Collections (Decrease) State Comm % Increase (Decrease) Residential Commercial Industrial Increase (Decrease) from Property Tax % Increase This Level Rollback (Decrease) Commercial ($100,000 ($500,000 ($1,000,000 FYE2020 Collections (Decrease) from Base Repl Funds Residential & Industrial Levy Rate Home) Property) Property) Option 1 - Base Level - Base level includes personnel ccontractual hanges only and use of $350,000 general fund balance - City is over $8.10 limit 2,265,352 44,330,527 5.39% 2,265,352 1,541,618 2.57% 6.01% $ 18.60191 $ 2.14 $ 39.52 $ 79.05 Option 2 - Additional Needs Level - This level includes personnel changes, other requests by departments and use of $1,287,246 general fund balance - City is at $8.10 limit 2,210,119 44,275,294 5.25% 2,210,119 1,566,127 2.64% 6.08% $ 18.61487 $ 2.20 $ 40.01 $ 80.02 Option 3 - Maximum Levy Hearing Level - This level includes all additional needs level requests and additional requests by council members and required the use of $1,303,782 general fund balance - City at $8.10 limit 2,821,877 44,887,052 6.71% 2,821,877 1,580,030 4.09% 7.57% $ 18.87699 $ 3.40 $ 49,84 $ 99.68 Option 4 - Proposed Budget Level as of March 12, 2020 This level includes most additional needs level changes and the use of $750,000 general fund balance 1,526,069 43,591,244 3.63% 1,526,069 1,533,620 1.03% 4.41% $ 18.32179 $ 0.86 $ 29.02 $ 58.04 Option 5 - Proposed Budget Level as of March 15, 2020 Budget changes not identified 1,802,562 43,867,737 4.29% 1,802,562 1,543,523 1.68% 5.08% $ 18.44026 $ 1.40 $ 33.46 $ 66.92 Option 6 - Levy Rate of $18.68097 Budget changes not identified 2,364,387 44,429,562 5.62% 2,364,387 1,571,652 3.01% 6.46% $ 18.68097 $ 2.50 $ 42.49 $ 84.98 Option 7 - Levy Rate of $17.95169 - Maximum Allowed that Wouldn't Require 5 Votes to Pass Maximum Levy hearing 611,495 42,676,670 1.45% (2,210,382) 1,510,688 -1.01% 2.30% $ 17.95169 $ (0.84) $ 15.14 $ 30.28 Option 8 - Prior Year Tax Dollars Budget changes not identified 0 42,065,175 0.00% 0 1,464,708 -2.58% 0.68% $ 17.66765 $ (2.15) $ 4.49 $ 8.98 Rate Impacts FVE21 Mar 15.xlsx Rate Impacts Mar 15 Page 1 of 1