Loading...
HomeMy WebLinkAboutSupplemental Attachments - 2/25/19K:\USERS\MICHELLE-1MBudget FYE20\FY20 BUDGET_Published.xlsx\ Comparison to FYE19 2/25/2019 2:56 PM UVV+Y\ --43 >1V• l A B C D E F G H I J K 2 City of Waterloo Prepared By KBahr 2/25/19 3 FYE2020 General Fund 4 Published Budget Change in Cost From FY19 5 % of Total 6 Amount Change From Prior Year Tax Levy 7 8 Property Taxes FYE2019 (Excl. Debt Svc & Lib, Incl. Excise Tax, Grout) 31,645,356 23,526 1 cent on the levy raises this much u 10 General Fund Personal Services increases (decreases): 11 Salaries & longevity 412,696 1.31% Includes avg 2.75% raises, step increases, longevity 12 Remove hiring delays included in FYE19 Certified Budget 190,041 0.60% 13 Add 1 police officer 69,946 0.22% 14 Add 1 mechanic 59,322 0.19% 15 Add 1 planner 101,270 0.32% 16 Increase in Personnel Costs Charged to Grants (52,702) -0.17% 17 Increase Overtime 16,000 0.05% 18 Increase Part Time Labor (5,138) -0.02% 19 Police & fire overtime, doubletime & bonus pay 95,000 0.30% 20 Misc, overtime, doubletime & bonus pay 0.00% 21 Payroll taxes 73,630 0.23% 22 Employee sick and casual payouts 6,373 0.02% 23 Retirement payouts 26,709 0.08% 24 Other misc personnel increases (decreases) 0 25 Health insurance 494,086 3.18% 1,995,552 0.84822 Personnel increases excl. 26 Retiree health insurance 42,017 fire & police pension 27 Reduce use of health insurance fund balance 466,302 1,002,405 28 Police Pension (92,429) 29 Fire Pension (80,780) (173,209) -0.55% 1,822,343 0.7746 Total personnel increases 30 Subtotal - Personnel Increases 1,822,343 5.76% 31 32 33 34 JJ K:\USERS\MICHELLE-1MBudget FYE20\FY20 BUDGET_Published.xlsx\ Comparison to FYE19 2/25/2019 2:56 PM K:\USERS\MICHELLE-W\Budget FYE20\FY20 BUDGET_Published.xlsx\ Comparison to FYE19 2/25/2019 2:56 PM A B C D E F G H I J K 2 City of Waterloo Prepared By KBahr 2/25/19 3 FYE2020 General Fund 4 Published Budget Change In Cost From FY19 5 % of Total 6 Amount Change From 7 Prior Year Tax Levy 36 Contractual Services and Commodities: 37 Airport - 22,236 0.07% 38 Attorney - Increase in Legal Services 200,000 0.63% 39 Building Insp - decrease expenses (127) 0.00% 40 Clerk Finance - Elections 60,000 0.19% 41 Cultural Arts - !ncrease Expense 12,000 0.04% 42 Fire - Increase 113,237 0.36% 43 Fire - Training Center 1,500 0.00% 44 INRCOG Dues 1,368 0.00% 45 Library - 0 0.00% 46 Health Services - Contract Cancelled (75,000) -0.24% 47 Human Rights - 0 0.00% 48 Human Resources - 0 0.00% 49 Leisure Services - Univ Ave 17,000 0.05% 50 Leisure Services Golf - Decrease in Sales Tax (2,716) -0.01% 51 Leisure Services - Sports & Youth - Decrease Expenses (394) 0.00% 52 Leisure Services Young Arena - Decrease 0 0.00% 53 MET - Increase in Requested Funding 71,603 0.23% 54 Mayor - Increase 10,000 0.03% 55 MIS 0 0.00% 56 Planning 15,744 0.05% 57 Police - Increase Expenses 61,635 0.19% 58 Various Depts - Decrease In Other Expenses 0 0.00% 59 0.00% UV 61 Subtotal - Contractual Services and Commodities Increases 508,086 1.59% 2,330,429 0.99057 Total all expense increases 62 UL K:\USERS\MICHELLE-W\Budget FYE20\FY20 BUDGET_Published.xlsx\ Comparison to FYE19 2/25/2019 2:56 PM K:\USERS\MICHELLE-W\Budget FYE20\FY20 BUDGET_Published.xlsx\ Comparison to FYE19 2/25/2019 2:56 PM A B C 1 D E F G H I J K 2 City of Waterloo Prepared By KBahr 2/25/19 3 FYE2020 General Fund 4 Published Budget Change In Cost From FY19 5 % of Total 6 Amount Change From 7 Prior Year Tax Levy 83 Revenue: 84 Airport - Increase (30,000) -0.09% 85 Building Inspection - Increases' (11,400) -0.04% 86 Clerk/Finance - Increase 0.00% 87 Clerk/Finance - Decrease 99 0.00% 88 Cultural/Arts - Increased Fees (12,000) -0.04% 89 Human Rights - 0.00% 90 Fire- Decreased Revenue 1,380 0.00% 91 Fire -Increase Ambulance Revenue (3,000) -0.01% 92 Fire - Increase Training Center Revenue (15,000) -0.05% 93 Garage - 0.00% 94 Health Services - Remove Sanitaton Funding for Cancelled Contract 75,000 0.24% 95 Leisure Services Parks - 0.00% 96 Leisure Services - Young Arena - Increase (6,500) -0.02% 97 Leisure Services Youth Services - Decrease 850 0.00% 98 Leisure Services Golf - Decrease 34,892 0.11% 99 Library - Decrease Fine revenue 9,000 0.03% 100 Planning - Increased Rent (1,201) 0.00% 101 Police Increase Revenue (15,664) -0.05% 102 Public Access Studio - 0.00% 103 No use of fund balance 710,000 2.25% Iut 105 Subtotal - Revenue Net (Increases) Decreases 736,456 2.33% 0.31304 Total all revenue changes IVU 110 111 Total Increases (Decreases) 3,066,885 9.68% 112 0.00% 113 Property Taxes Required (Excl Debt Service, Library Levy, 114 Grout Levy) 34,712,241 1IJ 119 120 Total change in taxes - formula check 3,066,885 121 122 Variance - property taxes required 0 123 124 Increase in Debt Service Levy 105,950 125 Increase in Grout Taxes 22,542 126 Increase in Library Levy 22,542 127 128 Total Additional Taxes 3,217,919 129 0 K:\USERS\MICHELLE-W\Budget FYE20\FY20 BUDGET_Published.xlsx\ Comparison to FYE19 2/25/2019 2:56 PM FYE2019 CERTIFIED AND FYE2020 PROPOSED BUDGET COMPARISON - CITY OF WATERLOO GENERAL FUND Published Budget 2/20/19 K:\USERS\MICHELLE-W\Budget FYE20\FY20 BUDGET_Published.xlsx 1 2/25/2019 2:51 PM A B D I E F G H I J K L M 1 CERT FY 2019 BUDGET FY 2020 BUDGET % FY2019 BUDGET FY 2020 BUDGET FY2019TAXES FY2020TAXES $ 18.18879 4.20% LEVIED 2 3 BUDGET CODE ACTIVITIES -GENERAL FUND BUDGET] CERTIFIED PUBLISHED CHANGE CERTIFIED PUBLISHED LEVIED $ 17.45595 $ AMOUNT LINE EXPENSE EXPENSE REVENUE REVENUE CHANGE CHANGE 4 5 6 PUBLIC SAFETY 010-11-1100 POLICE OPERATIONS 1C 13,558,539 14,095,890 3.96% 233,000 248,664 13,325,539 13,847,226 521,687 3.91% 7 010-11-1105 POLICE COMPUTER SERVICE 1C 213,780 224,276 4.91% 0 0 213,780 224,276 10,496 4.91% 8 010-11-1200 PUBLIC SAFETY ADMINISTRATION 1C 158,806 2,445,158 545,113 0 236,500 5,500 100,595 162,181 2,352,729 598,715 0 236,500 5,500 94,675 2.13% 0 _ 0 158,806 162,181 3,375 2.13% -3.78% 0.00% 0.00% 0.00% 0.00% -5.88% 9 200-11-1140 POLICE PENSION 1D -3.78% 983% 0.00% 0.00% 0.00% -5.88% 0 0 545,113 598,715 0 0 236,500 236,500 5,500 5,500 0 0 2,445,158 ` , 0 .y., 0 0 0 100,595 2,352,729 0 0 0 0 94,675 (92,429) 0 0 0 0 (5,920) 10 010-11-1150 POLICE GRANTS 1C 11 010-11-1150 POLICE GRANTS (DISCR H/M) 1C 12 010-11-1160 LAW ENFORCEMENT PROGRAMS 1C 13 010-11-1165 POLICE TOBACCO ENFORCEMENT 1C 14 010-01-1700 B.H. COUNTY EMA/SIREN MAINTENANCE 3C 15 010-12-1400 FIRE RESCUE 5C 9,097,263 9,465,370 4.05% 63,974 62,594 9,033,289 9,402,776 � 359,487 4.09% 16 010-18-1405 FIRE -GARAGE PARTS & SERVICE 5C 190,918 1,652,882 25,305 163,707 0 2,170,273 1 193,708 1589,530 25,305 179,358 0 2,242,861 1.46% 0 0 190,918 ! 193,708 2,790 1.46% 17 200-12-1420 FIRE PENSION 5D -3.83% 0.00% 9.56% 0.00% 3.34% 0 25,305 150,300 0 1,915,000 0 "25,305 165,300 0 1,818,000 1,652,832 0 13,407 0 255,273 1,589,530 0 14,058 0 324,861 (63,352) 0 651 0 69,588 -3.83% 0.00 4.86% 0.00% 27.26% 18 010-12-1412 FIRE RESTRICTED PROGRAMS 5C 19 010-12-1415 HAZARDS REGIONAL RESPONSE TRG PROG 5C 20 010-12-1425 FIRE SAFER GRANT 5C 21 010-12-1410 FIRE AMBULANCE SERVICE 6C 22 200-12-1410 FIRE AMBULANCE SERVICE PENSION 359,706 342,278 359,706 342,278 (17,428) -4.85% 23 010-18-1411 AMBULANCE -GARAGE PARTS & SERVICE 6C 38,500 38,500 0.00% 0 0 38,500 38,500 0 0.00% 24 010-22-5100 BUILDING INSPECTION 7C 1,179,327 1,203,684 2.07% 1,615,609 1,627,009 (436,282) (423,325) 12,957 -2.97% 25 26 TOTAL -PUBLIC SAFETY 11C 32,141,872 33,051,060 2.83% 4,790,301 4,887,587 27,351,571 28,163,473 811,902 2.97% 27 Less Fund 200 (4,457,746) (4,284,537) - - - 28 TOTAL -GENERAL FUND 27,684,126 28,766,523 29 PUBLIC WORKS 30 010-07-7650 SIDEWALKS 12C 215,000 215,000 0.00% 215,000 215,000 0 0 0 0.00% 31 010-17-7910 PARKING FACILITY MAINTENANCE 13C 15,900 17,580 10.57% 0 0 15,900 17,580 1,680 10.57% 32 010-22-7930 PARKING OPERATIONS 113C 533,500 533,500 0.00% 533,500 533,500 0 0 0 0.00% 33 010-29-7700 AIRPORT OPERATIONS 19C 1,045,407 1,088,266 4.10% 1,045,407 1,075,407 0 12,859 12,859 NEW 34 010-01-7800 MET TRANSIT AUTHORITY 21C 1,414,374 354,367 530,000 1,485,977 478,853 530,000 5.06% 0 0 1,414,374 1,485,977 71,603 5.06% 35 010-18-7950 CENTRAL GARAGE 21C 35.13% 84,800 84,800 269,567 394,053 124,486 46.18% 36 010-18-7952 CENTRAL GARAGE - CHARGEBACKS 21C 0.00% 530,000 530,000 0 0 0 0.00% 37 010-18-7955 MOTOR POOL -PASS THROUGH ACCOUNT 21C 1,935,768 1,935,768 0.00% 1,956,859 1,956,859 (21,091) (21,091) 0 0.00% 38 39 TOTAL -PUBLIC WORKS 22C 6,044,316 6,284,944 3.98% 4,365,566 4,395,566 1,678,750 1,889,378 210,628 12.55% 40 _ - _ 41 HEALTH & SOCIAL SERVICES 42 43 010-01-2200 BLACK HAWK COUNTY HEALTH DEPT. 26C 75,000 260,422 45,000 0 0 , _, 0 -100.00% 75,000 0 0 0 0 0.00% 010-27-2500 HUMAN RIGHTS COMMISSION 29C 267,783 45,000 0 0 0 2.83% 0.00% 0.00% 0.00% OQO%a..." 0 45,000 0 0 Q,,y 0 45,000 0 0 y t D 260,422 0 0 0 - 0 267,783 e 0 0 :' 0 S„ 0 7,361 0 0 .: 0 0 2.83% 0.00% `''.0.00% ; 0.00% 0.00% 44 45 010-27-2505 EEOC CONTRACT 29C 010-27-2510 FAIR HOUSING ENFORCEMENT 29C 46 010-27-2510 FAIR HOUSING PARTNERSHIP GRANT 29C 47 48 010-27-2520 HUMAN RIGHTS PROJECTS 29C -. 49 TOTAL -HEALTH & SOCIAL SERVICES 30C 380,422 312,783 -17.78% 120,000 45,000 260,422 267,783 , 7,361 2.83% K:\USERS\MICHELLE-W\Budget FYE20\FY20 BUDGET_Published.xlsx 1 2/25/2019 2:51 PM FYE2019 CERTIFIED AND FYE2020 PROPOSED BUDGET COMPARISON - CITY OF WATERLOO GENERAL FUND Published Budget 2/20/19 K:\USERS\MICHELLE-W\Budget FYE20\FY20 BUDGET_Published.xlsx 2 2/25/2019 2:51 PM A B D E F G H I J K L M 1 1 CERT FY 2019 BUDGET FY 2020 BUDGET % FY2019 BUDGET FY 2020 BUDGET FY2019TAXES $ FY2020TAXES 18.18879 4.20% LEVIED 2 BUDGET CODE ACTIVITIES -GENERAL FUND BUDGET CERTIFIED PUBLISHED CHANGE CERTIFIED PUBLISHED LEVIED $ 17.45595 $ AMOUNT % 3 LINE EXPENSE EXPENSE REVENUE REVENUE CHANGE CHANGE 4 50 CULTURE & RECREATION 51 010-01-4405 CEMETERY OPERATIONAL SUBSIDY 35C 50,000 50,000 659,430 409,585 0.00% 0 0 50,000 50,000 635,208 315,285 0 0.00% 52 010-01-4220 GROUT MUSEUM 32C 638,064 3.35% 25,398 24,222 612,666 22,542 3.68% 53 010-26-4208 YOUTH PAVILION 32C 431,446 -5.07% 88,300 94,300 343,146 (27,861) -8.12% 54 010-26-4250 CENTER FOR THE ARTS 32C 719,599 734,805 2.11% 135,579 141,579 584,020 593,226 9206 1.58% 55 010-26-4251 RIVERLOOP EVENT FACILITIES 32C 13,068 35,000 0 0 1,735,081 18,417 3`,000 51,865 20,000 4,120 84,884 14,350 35,000 0 ' ' 0 18,643 1837 384 18,417 +' i,000 51865 5 000 4120 73083 10,000 1,666,960 950,000 22,000 0 0 9.81 % 0 00% 0.00°A NEW 5.90% 0 00% ; 0 00°la 0.00% -7S 00% 000% 1390% ' 0.00% 4.06% 20,000 35,000 0 0 36 000 18,417 3,000 51,865 20,000 4,120 )^ 84,884 ,- - . =` 10,000 39,737 20,000 35;000 0 18 643' 27,000 1$ 417 "3 000 51865 51700 4120 730$3 10,000 39,737 (6,932) 0 0 .. 0 1,699,081 0 ;0 0 1 0 0 7 00 ;0 1,562,152 0 0 0 '2 (5,650) 0 0 "'x0 1 810 384 0 ' 0 1 0q 0 0 =0 1,627,223 1,282 0 0 0: 1 111,303 = 0{ * 0 0 0 .'. 0' 0 1j 0 65,071 -18.49% 0.00% 0.00% 0.00%' 6 55% = 0;00% "0.00% 0.00% 0.00% o.00% 0.00% '0.00% 4.17% 56 010-26-4265 C&A GRANTS & PROJECTS 32C 57 010-26-4265 CENTER FOR THE ARTS (H/M) 32C 58 010-26-4265 CENTER FOR THE ARTS (DISCR H/M) 32C 59 010-33-3100 LIBRARY SERVICES 31 C+levy 60 010-33-3110 LIBRARY - ENRICH IOWA GRANT 31C 61 010-33-3150 LIBRARY OPEN ACCESS PLUS 31C 62 010-33-3160 LIBRARY GRANTS 31C 63 010-33-3180 LIBRARY GIFT & MEMORIAL 31C 64 010-33-3190 IOWA LIBRARY SERVICE 31C 65 010-33-3200 COUNTY LIBRARY 31C 66 010-33-3210 LIBRARY OPEN ACCESS 31C 10.000° 1,601,889 950,000 22,000 0 0 67 010-37-4100 LEISURE SERVICES - PARKS 33C 68 010-37-4102 LEISURE SERVICES - PARKS - CHARGEBACK 33C 0.00% ',6:00r% 0.00% 0.00% 950,000 : _ 22,000 0 0 950,000 22,0000 0 0 0 0 0 0 0 0 0 0 0.00% 0.00% :" 0.00% o.00% 69 010-37-4105 LEISURE SERVICES PROJECTS 33C 70 010-37-4105 LEISURE SERVICES PROJECTS (H/M) 33C 71 010-37-4106 LEISURE SERVICES - SOUTH HILL PARK 33C 72 010-37-4110 LEISURE SERVICES - DOWNTOWN MTCE 33C 380,516 409,362 7.58% 0 0 380,516 409,362 28,846 7.58% 73 010-37-4120 GOLF COURSES 34C 1,148,796 9,466. 1,417,000 624,413 774,768 1,176,638 9,253 40,000 620,906 783,472 2.42% °% 225,466 1.62% -0.56% 1.12% 968,045 ,`9 7,417000 283,250 692,500 933,153 .k+°, 9253',.''0 14400p0 282,400 699,000 180,751 00".0 341,163 82,268 243,485 0 338,506 84,472 62,734 *` 0 (2,657) 2,204 34.71% 0.00% '0.00% -0.78% 2.68% 74 010-37-4125 GOLF COURSE IMPROVEMENTS-SURCHARGI34C 75 010-37-4180 SPORTSPLEX 34C 76 010-37-4200 SPORTS & YOUTH SERVICES 34C 77 010-37-4500 YOUNG ARENA 36C 78 79 TOTAL-CULTURE&RECREATION 38C 10,743,392 11,003,273 2.42% 4,914,561 4,901,772 5,828,831 6,101,501 272,670 4.68% 80 - - - 81 COMMUNITY & ECONOMIC DEVELOPMENT 82 010-08-5700 PLANNING & ZONING 42C 633,720 813,603 28.39% 445,155 443,155 188,565 370,448 181,883 96.46% 83 010-08-5750 RECREATION AREA DEVELOPMENT 43C 0 700 NEW 45,200 45,200 (45,200) (44,500) 700 -1.55% 84 010-08-5885 CITY PROPERTY MANAGEMENT 43C 110,983 121,200 9.21% 0 0 110,983 121,200 10,217 9.21% 85 010-01-5710 INRCOG MEMBERSHIP 43C 32,835 34,203 4.17% 0 102,633 0 000 8p 000 600,000 25 $5 •3 a 1,820,473 0 105,834 0 ° 240`000 1 rBQ ODOR 600,000 287 $35 0 44050 1,826,074 32,835 34,203 1,368 4.17% 86 010-08-6100 PLANNING & ZONING -ECONOMIC DEVEL 40C 102,633 0 240,000 80,000 600,000 267,835 0 105,834 0" 240,000` 80 000 "600;000, 267,835 0 3.12% 0.00% 0.00%240 0.00% 0.00% 0.00% 0.00% 11.10% 9.48% 0 0 0 a 0 1 0 0 0 0 0 287,183 v y " 0 0 0 0 1 0 s ' 0 0 0, 0 481,351 0 0 0 % 0 0 4 D $.,. 0 0 0 194,168 0.00% '< o.00% 0.00% 0.00% 0.00% 0.00% ," 0.00% 0.00% 0.00% 67.61 87 010-08-6105 ECONOMIC DEVELOP -SPECIAL PROJECTS 40C 88 010-01-6650 TOURISM PROMOTION -VARIOUS GRTS (H/M) 40C 89 010-01-6660 TOURISM PROMOTION -VARIOUS DISCR (H/M) 40C 90 010-01-6920 CONVENTION & VISITORS BUREAU (H/M) '40C 91 010-22-6860 SULLIVAN CENTER MAINTENANCE 43C 92 010-32-5850 COMM DEVEL-ADMINISTRATIVE 41C 93 010-32-5861 COMM DEVEL-LHAP HOUSING POOL 41C 39,65044,050 94 95 TOTAL -COMMUNITY & ECONOMIC DEV 45C 2,107,656 2,307,425 96 - - - K:\USERS\MICHELLE-W\Budget FYE20\FY20 BUDGET_Published.xlsx 2 2/25/2019 2:51 PM FYE2019 CERTIFIED AND FYE2020 PROPOSED BUDGET COMPARISON - CITY OF WATERLOO GENERAL FUND Published Budget 2/20/19 K:\USERS\MICHELLE-W\Budget FYE20\FY20 BUDGET_Published.xlsx 3 2/25/2019 2:51 PM A B D E F G H I J I K L M 1 CERT FY 2019 BUDGET FY 2020 BUDGET % FY2019 BUDGET FY 2020 BUDGET FY2019TAXES FY2020TAXES $ 18.18879 4.20% LEVIED 2 BUDGET CODE ACTIVITIES -GENERAL FUND BUDGET CERTIFIED PUBLISHED CHANGE CERTIFIED PUBLISHED LEVIED $ 17.45595 $ AMOUNT 3 LINE EXPENSE EXPENSE REVENUE REVENUE CHANGE CHANGE 4 97 98 GENERAL GOVERNMENT 99 010-01-8200 MAYOR'S OFFICE 46C 274,226 308,575 12.53% 0 0 274,226 308,575 34,349 12.53% 100 010-01-8280 COMMUNICATIONS 46C 10,891 377,832 40,000 10,891 391,951 40,000 0.00% 0 0 10,891 10,891 0 0.00% 101 010-01-8220 ADMIN SERVICES/MIS 46C 3.74%1 1,445 1,445 376,387 390,506 14,119 3.75% 102010-01-8222 ADMIN SERVICES/MIS - CHARGEBACKS 46C 0.00% 40,000 40,000 0 0 0 0.00% 103 010-02-8100 CITY COUNCIL 46C 72,948 1,294,004 0 74,175 1,337,862 00.00% 1.68% 0 5,962,125 0 0 5,962,026 0 72,948 74,175 1,227 1.68% 104 010-03-8400 CITY CLERK AND FINANCE 47C 3.39% (4,668,121) (4,624,164) 43,957 -0.94% 105 010-03-8400 CITY CLERK AND FINANCE - ELECTION COST 48C 0 0 0 i 0.00% 106 010-03-8402 CITY CLERK AND FINANCE - CHARGEBACKS 47C 77,500 77,500 0.00% 77,500 77,500 0 0 0 0.00% 107 010-06-8600 CITY ATTORNEY 49C 256,627 1,293,908 500,000 475,921 1,329,685 500,000 85.45% 0 0 256,627 475,921 219,294 85.45% 108010-03-8900 LIABILITY INSURANCE 51C 2.77% 0 0 1,293,908 1,329,685 35,777 2.77% 109 010-03-8902 LIABILITY INSURANCE - CHARGEBACKS 51C 0.00% 500,000 500,000 0 0 0 0.00% 110 010-03-8905 HEALTH/LIFE INSURANCE 0 0 0.00% 0 0 3,472,295 250,000 0 0 0 527,457 0 0.00% 111 010-03-8950 SELF FUNDED HEALTH INSURANCE 52C 2,646,545 3,472,295 , 31.20% 3,112,847 (466,302) 466,302 -100.00% 112 010-03-8960 SELF FUNDED WORK COMP 52C 777,457 777,457 0.00% 250,000 527,457 0 0.00% 113 010-03-8150 PUBLIC ACCESS STUDIO 52C 156,104 159,971 2.48% 30,750 30,750 125,354 129,221 3,867 3.08% 114 010-03-8970 PRINT SHOP 52C 46,000 46,000 0.00% 0 0 46,000 46,000 0 0.00% 115 010-09-2600 EAP SUBSTANCE ABUSE PROGRAM 52C 14,500 388,580 32,500 14,500 399,548 32,500 0.00% 0 0 14,500 14,500 0 0.00% 116 010-09-8250 HUMAN RESOURCES 52C 2.82% 0 0 388,580 399,548 10,968 2.82% 117 010-09-8252 HUMAN RESOURCES - CHARGEBACKS 52C 0.00% 32,500 32,500 0 0 0 0.00% 118 010-09-8255 SAFETY COMMITTEE 52C 17,500 17,500 _ 0.00% 0 0 17,500 17,500 0 0.00% 119 010-22-8800 CITY HALL/FACILITIES MAINTENANCE 50C 575,123 567,861 5 085 8,815 -1.26% 0.00% 0.00% 0 e r 0 0 a_ 0 575,123 �"„,. 0 8,815 567,861 "..b 8,815 (7,262) 0 0 -1.26% ° ;0:00/0 0.00% 120 010-22-8820 CITY FACILITIES RESTRICTED PROJECTS 50C ;,5,085 8,815 121 010-22-8850 VETERANS MEMORIAL HALL 50C 122 200-09-8980 UNEMPLOYMENT FUND 52D 17,472 17,472 0.00% 0 0 17,472 17,472 0 0.00% 123 _ 124 125 TOTAL -GENERAL GOVERNMENT 53C 8,883,617 10,065,564 13.30% 10,012,252 10,371,601 (1,128,635) (306,037) 822,598 -72.88% - - _ 126 127 TRANSFERS 0 127,000 127 000 127,000 0 00% 0.00% 0 00°/” 0.00% 0 12' 00 127,000 000 127,000 0 0 0 0 k ' t 0 s0 J L 0 0 0,00% 0.00% 0.00% 128 010-03-9050 HOTEUMOTEL DEBT SERVICE TRANSFER 75C 129 010-03-9050 TIF ECONOMIC DEV TRANSFER (INTERNAL TI 76C 130 010-08-9050 PLANNING & ZONING TRANSFER (TIF) 131 TOTAL -TRANSFERS 77C 127,000 132 1,310,100 710,000 0 1,250,000 0 0 133 STATE REPLACEMENT FUNDS (COMM/IND ROLLBACK) 0 (1,310,100) (1,250,000) 60,100 -4.59% 134 010-03-8400 PROPOSED USE OF FUND BALANCE 0 0.00% (710,000) 0 710,000 -100.00% 135 BACKFILL ADJUSTMENT 0 0.00% 0 0 0 0.00% 136 137 TOTAL CITY BUDGET -GENERAL FUND 60,428,275 63,152,049 4.51% 28,170,253 27,804,600 32,258,022 35,347,449 3,089,427 9.58% K:\USERS\MICHELLE-W\Budget FYE20\FY20 BUDGET_Published.xlsx 3 2/25/2019 2:51 PM FYE2019 CERTIFIED AND FYE2020 PROPOSED BUDGET COMPARISON - CITY OF WATERLOO GENERAL FUND Published Budget 2/20/19 A B D E F I G H I J K L M 1 I CERT FY 2019 BUDGET FY 2020 BUDGET % FY2019 BUDGET 1 FY 2020 BUDGET FY2019TAXES I FY2020TAXES $ 18.18879 4.20% LEVIED 2 BUDGET CODE I ACTIVITIES -GENERAL FUND BUDGET CERTIFIED PUBLISHED CHANGE CERTIFIED I PUBLISHED LEVIED $ 17.45595 $ AMOUNT % 3 LINE EXPENSE EXPENSE REVENUE REVENUE CHANGE CHANGE 4 I 138 - 139 TAXABLE VALUATION FYE2019 FYE2020 Increase % Increase 140 (In Thousands) (In Thousands) (Decrease) (Decrease) 141 [Taxable valuation - including TIF but excluding gas & electric utility values 2,449,148 2,539,331 90,183 3.68% 142 Taxable valuation - excluding TIF & gas & electric utility values 2,185,860 2,271,362 85,502 3.91 % 143 ,Taxable valuation - including TIF and electric utility values i 2,532,423 2,634,856 102,433 4.04% 144 Taxable valuation - excluding TIF but including gas & electric utility values 2,269,135 2,352,623 83,488 3.68% 145 Commercial/Industrial Property Rollback 96,974 105,541 8,567 8.83% 146 Commercial/Industrial Property Rollback for Debt Service 106,110 125,097 18,987 17.89% 147 Taxable valuation - Ag Land 13,846 14,264 418 3.02% 148 Tax Askings per One Cent of Levy 22,691 23,526 835 3.68% 149 85.00% 150 PROPERTY TAX LEVY ANALYSIS: FY2019 TAX FY2019 TAX FY2020 TAX STATE BACKFILL FY2020 TAX $ AMOUNT 151 LEVY RATE LEVY CORP ROLLBACK 261,188 163,377 RATE CHANGE 152 DEBT SERVICE LEVY 7,567,577 $ 2.98828 7,673,527 $ 2.91231 $ 105,950 153 POLICE & FIRE PENSION SYSTEM 4,457,746 $ 1.96451 4,284,537 $ 1.82117 $ (173,209) _ 154 EMERGENCY MGMT COMMISSION LEVY 100,595 $ 0.04433 94,675 3,610 $ 0.04024 $ (5,920) 155 TRANSIT LEVY 1,414,374 $ 0.62331 1,485,977 56,664 $ 0.63163 $ 71,603 156 TORT INSURANCE LEVY 1,293,908 $ 0.57022 1,329,685 50,703 $ 0.56519 $ 35,777 157 FICN:PERS LEVY 1,996,545 $ 0.87987 2,067,966 5,170,173 527,457 78,855 $ 0.87900 $ 71,421 158 HEALTH INSURANCE LEVY 2,803,012 $ 1.23528 197,148 $ 2.19762 $ 2,367,161 159 WORKERS COMP. INSURANCE LEVY 527,457 $ 0.23245 20,113 $ 0.22420 $ - 160 LUNEMPLOYMENT LEVY 17,472 $ 0.00770 17,472 666 $ 0.00743 $ - 161 LIBRARY VOTED LEVY 612,666 $ 0.27000 635,208 24,222 $ 0.27000 $ 22,542 162 EMERGENCY LEVY 612,666 $ 0.27000 635,208 24,222 $ 0.27000 $ 22,542 163 GROUT LEVY 612,666 $ 0.27000 635,208 24,222 $ 0.27000 $ 22,542 164 AG LAND LEVY 41,588 42,845 $ 1,257 165 GENERAL FUND $8.10 LEVY 18,379,993 $ 8.10000 19,056,246 726,651 $ 8.10000 $ 676,253 167 TOTAL PROPERTY TAX LEVY $ 40,438,265 $ 17.45594 $ 43,656,184 $ 1,631,641 $ 18.18879 $ 3,217,919 $ 3,172,835 168 ROLLBACK REPLACEMENT- GENERAL LEW NCLUDING EMPLOYEE BENEFITS LEW, EXCL DEBT SERVICE $ 1,322,009 $ - 1 69 ROLLBACK REPLACEMENT- GENERAL LEVY $ 886,072 170 ROLLBACK REPLACEMENT - EMPLOYEE BENEFITS LEVY $ 8,400,804 $ 484,381 171 AMOUNT CHANGE IN TAX LEVY $ 3,217,919 ' $ 0.73 ® % CHANGE 7.96% 0 19,056,246 4.20% 173 AMOUNT (OVER) UNDER $8.10 LEVY LIMIT $ - 174 ADJUSTED TOTAL PROPERTY TAX LEVY (AT GF $8.10 LEVY LIMIT) $ 18.18879 175 176 GENERAL FUND $8.10 LEVY INCREASE (DECREASE) 676,253 177 TOTAL PROPERTY TAX COLLECTION INCREASE 7.96% I K:\USERS\MICHELLE-W\Budget FYE20\FY20 BUDGET_Published.xlsx 4 2/25/2019 2:51 PM FYE2019 CERTIFIED AND FYE2020 PROPOSED BUDGET COMPARISON - CITY OF WATERLOO GENERAL FUND Published Budget 2/20/19 K:\USERS\MICHELLE-W\Budget FYE20\FY20 BUDGET_Published.xlsx 5 2/25/2019 2:51 PM A B D E F G H I J I K L M 1 CERT FY 2019 BUDGET FY 2020 BUDGET % j FY2019 BUDGET CERTIFIED FY 2020 BUDGET PUBLISHED FY2019TAXES LEVIED $ 17.45595 i FY2020TAXES $ 18.18879 4.20% LEVIED 2 BUDGET CODE ACTIVITIES -GENERAL FUND BUDGET CERTIFIED PUBLISHED CHANGE $ AMOUNT 3 LINE I EXPENSE EXPENSE REVENUE REVENUE CHANGE CHANGE 4 178 179 Residential Tax Askings Home Value Avg Revaluation Adj Value Rollback Tax Incr (Decr) Monthly Change % Change lou $ 18.18879 $ 17.45595 181 FYE2020 152234 152,234 0.56918 1,576.04 97.97 8.16 6.63% 182 FYE2019 152,234 Ind reval 152,234 0.556209 1,478.07 (47.52) (3.96) -3.11% 183 $ 17.60000 FYE2018 152,234 152,234 0.569391 1,525.58 34.74 2.90 2.33% 184 $ 17.60522 FYE2017 147,973 2.88% 152,234 0.556259 1,490.84 25.86 2.16 1.77% 185 $ 17.76370 FYE2016 147,973 154,138 -4% 147,973 147,973 0.557335 0.544002 1,464.98 1,445.06 19.92 20.93 1.66 1.74 1.38% 1.47% 186 $ 17.95159^FYE2015 187 $ 17.49319 FYE2014 154,138 154,138 0.528166 1,424.13 (0.01) (0.00) 0.00% 188 $ 18.20505 FYE2013 154,138 154,138 0.507518 1,424.14 37.79 3.15 2.73% 189 $ 18.53335 FYE2012 154,138 154,138 0.485299 1,386.35 65.76 5.48 4.98% 190 $ 18.26406 FYE2011 154,138 154,138 0.469094 1,320.59 34.15 2.85 2.65% 191 $ 18.30689 FYE2010 154,138 154,138 0.455893 1,286.43 38.51 3.21 3.09% 192 $ 18.36687 FYE2009 144,054 7% 154,138 0.440803 1,247.93 16.26 1.36 1.32% 193 $ 18.76669 FYE2008 144,054 144,054 0.455596 1,231.67 (17.04) (1.42) -1.36% 194 $ 18.84580 FYE2007 132,160 9% 144,054 0.45996 1,248.71 34.44 2.87 2.84% 195 196 $ 19.15566 FYE2006 132,160 132,160 0.479642 1,214.27 10.97 0.91 0.91% $ 18.78999 FYE2005 118,000 12% 132,160 0.484558 1,203.30 56.70 4.72 4.95% 197 $ 18.90914 FYE2004 118,000 118,000 0.513874 1,146.60 26.52 2.21 2.37% 198 $ 18.37162 FYE2003 100,000 18% 118,000 0.516676 0.5626511 1,120.08 1,001.56 118.52 96.99 9.88 8.08 11.83% 10.72% 199 $ 17.80075 FYE2002 100,000 N/A 100,000 200 $ 16.49097 FYE2001 100,000 100,000 0.548525 904.57 LVI 202 Commercial Tax Askings Property Value Avg. Revaluation Adj Value Rollback Tax Incr (Decr) Monthly Change % Change $ 18.18879 $ 17.45595 204 FYE2020 752,427 752,427 0.90 12,317.16 496.27 41.36 4.20% 205 FYE2019 752,4271 752,427 0.90 11,820.90 (97.55) (8.13) -0.82% 206 $ 17.60000 FYE2018 752,427 752,427 0.90 11,918.44 (3.53) (0.29) -0.03% 207 $ 17.60522 FYE2017 752,427 752,427 0.90 11,921.98 (107.32) (802.60) (8.94) -0.89% (66.88) -6.25% 208 $ 17.76370 FYE2016 752,427 752,427 0.90 12,029.30 209 $ 17.95159 FYE2015 752,427 752,427 0.95 12,831.90 (330.45) (27.54) -2.51% 210 $ 17.49319 FYE2014 752427 752,427 1 13,162.35 (535.62) (44.64), -3.91% 211 $ 18.20505 FYE2013 752,427 752,427 1 13,697.97 (247.02) (20.59) -1.77% 212 $ 18.53335 FYE2012 752,427 752,427 1 13,944.99 202.62 16.89 1.47% 213 $ 18.26406 FYE2011 752,427 752,427 1 13,742.37 (32.23) (2.69) -0.23% 214 $ 18.30689 FYE2010 752,427 752,427 _ 1 13,774.60 (7.98) 1 (0.67) -0.06% 215 $ 18.36687 FYE2009 690,300 9% 752,427 0.997312 13,782.58 827.94 68.99 6.39% 216 $ 18.76669 FYE2008 690,300 N/A 690,300 1 12,954.65 55.85 4.65 0.43% 217 $ 18.84580 FYE2007 690,300 N/A 690,300 0.991509 12,898.79 (324.36) (27.03) -2.45% 218 $ 19.15566 FYE2006 690,300 N/A 690,300 1 13,223.15 348.79 29.07 2.71% 219 $ 18.78999 FYE2005 585,000 18% 690,300 0.99257 12,874.36 1,812.51 151.04 16.39% 220 $ 18.90914 FYE2004 585,000 N/A 585,000 1 11,061.85 554.11 46.18 5.27% 221 $ 18.37162 FYE2003 585,000 N/A 585,000 0.977701 10,507.74 94.30 7.86 0.91% 222 $ 17.80075 FYE2002 585,000 N/A 585,000 1 10,413.44 766.221 63.85 7.94% 223 $ 16.49097 FYE2001 500,000 17% 585,000 1 9,647.22 WI- K:\USERS\MICHELLE-W\Budget FYE20\FY20 BUDGET_Published.xlsx 5 2/25/2019 2:51 PM FYE2019 CERTIFIED AND FYE2020 PROPOSED BUDGET COMPARISON - CITY OF WATERLOO GENERAL FUND Published Budget 2/20/19 K:\USERS\MICHELLE-\\Budget FYE20\FY20 BUDGET_Published.xlsx 6 2/25/2019 2:51 PM A B D E F G H I J K L M 1 CERT FY 2019 BUDGET FY 2020 BUDGET % FY2019 BUDGET i FY 2020 BUDGET FY2019TAXES I FY2020TAXES $ 18.18879 4.20% LEVIED 2 BUDGET CODE ACTIVITIES -GENERAL FUND BUDGET CERTIFIED PUBLISHED CHANGE CERTIFIED PUBLISHED LEVIED $ 17.45595 $ AMOUNT 3 LINE EXPENSE EXPENSE REVENUE REVENUE CHANGE CHANGE 4 225 _ Industrial Tax Askings Adj Value Rollback Tax Incr (Decr) Monthly Change % Change $ 18.18879 $ 17.45595 227 FYE2020 1,000,000 N/A 1,000,000 0.90 16,369.91 659.56 54.96 4.20% 228 FYE2019 1,000,000 N/A 1,000,000 0.90 15,710.36 (129.65) (10.80) -0.82% 229 $ 17.60000 FYE2018 1,000,000 N/A 1,000,000 0.90 15,840.00 (4.70) (0.39) -0.03% 230 $ 17.60522 FYE2017 1,000,000 N/A 1,000,000 0.90 15,844.70 (142.63) (11.89) -0.89% 231 $ 17.76370 FYE2016 1,000,000 N/A 1,000,000 0.90 15,987.33 (1,066.68) (88.89) -6.25% 232 $ 17.95159 FYE2015 1,000,000 N/A 1,000,000 0.95 17,054.01 (439.18) (36.60) -2.51% 233 $ 17.49319 FYE2014 1,000,000 N/A 1,000,000 1 17,493.19 (711.86) (59.32) -3.91% 234 $ 18.20505 FYE2013 1,000,000 N/A 1,000,000 1 18,205.05 (328.30) (27.36) -1.77% 235 $ 18.53335 FYE2012 1,000,000 N/A 1,000,000 1 18,533.35 269.29 22.44 1.47% 236 $ 18.26406 FYE2011 1,000,000 N/A 1,000,000 1 18,264.06 (42.83) (3.57) -0.23% 237 $ 18.30689 FYE2010 1,000,000 N/A 1,000,000 1 18,306.89 (59.98) (5.00) -0.33% 238 $ 18.36687 FYE2009 1,000,000 N/A 1,000,000 1 18,366.87 (399.82) (33.32) -2.13% 239 $ 18.76669 FYE2008 1,000,000 ,N/A 1,000,000 1 18,766.69 (79.11) (6.59) -0.42% 240 $ 18.84580 FYE2007 1,000,000 N/A 1,000,000 1 18,845.80 (309.86) (25.82) -1.62% 241 $ 19.15566 FYE2006 1,000,000 N/A 1,000,000 1 19,155.66 365.67 30.47 1.95% 242 $ 18.78999 FYE2005 1,000,000 N/A 1,000,000 1 18,789.99 (119.15) (9.93) -0.63% 243 $ 18.90914 FYE2004 1,000,000 N/A 1,000,000 1 18,909.14 537.52 44.79 2.93% 244 $ 18.37162 FYE2003 1,000,000 N/A 1,000,000 1 18,371.62 570.87 47.57 3.21% 245 $ 17.80075 FYE2002 1,000,000 N/A 1,000,000 1 17,800.75 1,309.78 109.15 7.94% 246 $ 16.49097 FYE2001 1,000,000 N/A 1,000,000 1 16,490.97 247 248 zas Multi -Residential Tax Askings Adj Value Rollback Tax Incr (Decr) Monthly Change % Change $ 18.18879 $ 17.45595 250 FYE2020 500,000 N/A 500,000 0.7500 6,820.80 (52.48) (4.37) -0.76% 251 FYE2019 500,000 N/A 500,000 0.7875 6,873.28 (386.72) (32.23) -5.33% 252 $ 17.60000 FYE2018 500,000 ,N/A 500,000 0.8250 7,260.00 (332.25) (27.69) -4.38% 253 $ 17.60522 FYE2017 500,000 N/A 500,000 0.8625 7,592.25 (401.41) (33.45) -5.02% 254 $ 17.76370 FYE2016 500,000 N/A 500,000 0.9000 7,993.67 (533.34) (44.45) -6.25% 255, $ 17.95159 FYE2015 500,000 N/A 500,000 0.9500 8,527.01 (219.59) (18.30) -2.51% 256 $ 17.49319 FYE2014 500,000 N/A 500,000 1 I 8,746.60 K:\USERS\MICHELLE-\\Budget FYE20\FY20 BUDGET_Published.xlsx 6 2/25/2019 2:51 PM