Loading...
HomeMy WebLinkAbout01/30/2017- FY18 budget discussionsCouncil Work Session January 30, 2017 Time indicated below Harold E. Getty Council Chambers Roll Call. Approval of Agenda, as proposed or amended. 5:30 p.m. Discussion of FY2018 budget. Submitted By: Michlele Weidner, Chief Financial Officer ADJOURNMENT Kelley Felchle City Clerk CITY OF WATERLOO Council Communication Discussion of FY2018 budget. City Council Meeting: 1/30/2017 Prepared: 1/25/2017 REVIEWERS: Department Finance Reviewer Felchle, Kelley ATTACHMENTS: Description D Budget Ideas Council Compensation D Budget Ideas Operations D Budget Ideas Neighborhood Safety/Community D Budget Idea Operations D Budget Idea New Revenue D Budget Ideas Garbage/Recycling SUBJECT: Submitted by: Recommended Action: Summary Statement: Expenditure Required: Source of Funds: Policy Issue: Alternative: Background Information: Action Approved Type Cover Cover Cover Cover Cover Cover Discussion of FY2018 budget. Memo Memo Memo Memo Memo Memo Date 1/25/2017 - 6:49 PM Submitted By: Michlele Weidner, Chief Financial Officer Share your ideas! Let us know your thoughts on addressing the budget. Your ideas will remain anonymous if you wish, but providing the information below will help us in tailoring our budget to our citizens and providing follow-up if desired. Click "Submit" to send your comments. Form Number 43 First Name Tom Last Name Steils Email Address tomfrancistom@hotmail.com Budget Category* Other Budget Idea* Eliminate compensation given to city council leaders. Just as Reserve Police Officers don't get compensation for gas while volunteering their services for free. Yes they do get compensated if they get hurt while on duty. They have their own jobs just like the city council does. should not receive anything as well. As it all started in the beginning it should be a privilege and an honor to serve our government without compensation. Date* 12/18/2016 Share your ideas! Let us know your thoughts on addressing the budget. Your ideas will remain anonymous if you wish, but providing the information below will help us in tailoring our budget to our citizens and providing follow-up if desired. Click "Submit" to send your comments. Form Number First Name Last Name Email Address 47 Jonathan Eastman jonathan.eastman@gmail.com Budget Category* Operations Budget Idea* Date* Maintaining well staffed police, fire, and ambulance services are essential to the health and safety of Waterloo citizens and visitors. Cuts to these services involve unacceptable risk. With ever increasing demand for service (as both a national and local trend), we should be considering a commensurate response in kind. 12/19/2016 Share your ideas! Let us know your thoughts on addressing the budget. Your ideas will remain anonymous if you wish, but providing the information below will help us in tailoring our budget to our citizens and providing follow-up if desired. Click "Submit" to send your comments. Form Number 57 First Name Donald Last Name Fleshner Email Address Budget Category* Neighborhood Safety and Community Concerns Budget Idea* Build a new fire station and get rid of firehouses 5 & 6. This should allow us to lower our number of firefighters and provide adequate service to the city. Regardless of what the firefighter union says less firefighters will not cause the city to go up in flames. If the taxes aren't lowered soon, lots of people will be moving. Date * 12/22/2016 Share your ideas! Let us know your thoughts on addressing the budget. Your ideas will remain anonymous if you wish, but providing the information below will help us in tailoring our budget to our citizens and providing follow-up if desired. Click "Submit" to send your comments. Form Number First Name Last Name Email Address 63 Jason Phillips jlkb69@yahoo.com Budget Category* Operations Budget Idea* My priorities would be Fire, EMS and Police. Every year my taxes go up and my services get cut. I live on Winghaven Dr. and hate when I drive by Fire Station 6 and see it closed. I think we have a great Fire Department but just like everything else they are being asked to do more with less. Date * 12/22/2016 Share your ideas! Let us know your thoughts on addressing the budget. Your ideas will remain anonymous if you wish, but providing the information below will help us in tailoring our budget to our citizens and providing follow-up if desired. Click "Submit" to send your comments. Form Number 71 First Name Last Name Email Address Budget Category* New Revenue Sources Budget Idea* The City should consider lobbying the state to be able to implement a local income tax, which would help make taxation more equitable. Currently, non-resident workers (that nonetheless use the city's resources and services) do not pay their fair share to support these services. A local income tax (based on place of employment) would serve to help mitigate this problem. Date * 12/27/2016 Share your ideas! Let us know your thoughts on addressing the budget. Your ideas will remain anonymous if you wish, but providing the information below will help us in tailoring our budget to our citizens and providing follow-up if desired. Click "Submit" to send your comments. Form Number 56 First Name ward Last Name williams Email Address gallawilli93@mchsi.com Budget Category* Garbage, Recycling, and Yardwaste Budget Idea* I pay extra for yard waste recycle pick up and tonite I did not have my blue cart emptied. This is the 2nd time this year this has happened.I abide by the rules (3 feet from vehicles and the time frames 6pm to 12 pm to remove) It is clearly missed!! I have not complained this year till now- last year it happened waste mgmt. said to set the cart out again and they sent a truck out to pick it up. I am NOT going to have a truck make a special trip to pick it up! What a waste of my tax payer dollars!! Forward this to Mr. Hart - I will follow up. THANKS Date* 12/21/2016 FYE2017 CERTIFIED AND FYE2018 PROPOSED BUDGET COMPARISON - CITY OF WATERLOO Base Budget GENERAL FUND 1130/2017 K:\USERS\MICHELLE-W\Budget FYE18\FY18 B U DG ET_Base 1 1/30/2017 5:02 PM A B E F G 11 1 J K L M 1 FY2017 BUDGET FY 2018 BUDGET % FY2017 BUDGET IFY2018 BUDGET FY2017TAXES '.. FYE2018 LEVY $ 17.52473 -0.46% RATE REQUESTED 2 BUDGET CODE ACTIVITIES -GENERAL FUND CERTIFIED BASE CHANGE CERTIFIED BASE LEVIED $ 17.60522 $ AMOUNT % 3 EXPENSE LEVEL REVENUE 1, LEVEL CHANGE CHANGE 4 5 PUBLIC SAFETY 13,216,372 '� 234,368 1.81% 6 010-11-1100 POLICE OPERATIONS 13,278004 13,512,372 1.77% 296,000 296,000 12,98 02 04 7 010-11-1105 POLICE COMPUTER SERVICE 189,816 189,816 0.00% 0 0 189,816 189,816 1 0 0.00% 8 010-11-1200 PUBLIC SAFETY ADMINISTRATION 153,602 2,297,066 156,173 2,364,408 549,655 0 266000 5500 1.67% 0 0 153,602 156,173 'i 2,571 1.67% 9 200-11-1140 POLICE PENSION 2.93% 1.11% -100.00% 0.00% 0.00% 0.00% 0 r 545613:. ! 40,000 266,000 5,500 0r 0 549,655 0''. 266,000 _ 5500'. 0 2,297,066 2,364,408 0 0 I:0 0 0 0 0 0 76,707 76,707 67,342 0 0 0 0 0 2.93% ':0.00% 0.00% 0.00% 0.00% 0.00% 10 010-11-1150 POLICE GRANTS i' 543613 40,000 11 010-11-1150 POLICE GRANTS (DISCR H/M) 12 010-11-1160 LAW ENFORCEMENT PROGRAMS 266,000 13 010-11-1165 POLICE TOBACCO ENFORCEMENT 5,500 14 010-01-1700 B.H. COUNTY EMA/SIREN MAINTENANCE 76,70 76707 15 010-12-1400 FIRE RESCUE 9248497 9,203,750 -0.48% 675071 67,507 9180,990 9136243 (44 747) -049% 16 010-18-1405 FIRE -GARAGE PARTS SERVICE 189,600 1,885330 330 189,856 1 945339 22,000 157,870 0.14% 0 0 189,600 189,856 256 014% 17 200-12-1420 FIRE PENSION 3.08% 0.00% 8.65% -47.07% 2.0454 0 22,000 145300 82,964 1,664000 0 22 000 145,300 43,911 '. 1,864,000 1,885330 '0 0 0 207,270 1,943 339 0 12,570 0 249567 58 009 0 12,570 0 42,297 358% 0.00% NEW 0 00%' 20.41% 18 010-12-1412 FIRE RESTRICTED PROGRAMS 22,000 19 010-12-1415 HAZARDS REGIONAL RESPONSE TRG PROG 145,300 20 010-12-1425 FIRE SAFER GRANT 82,964 43,911 21 010-12-1410 FIRE AMBULANCE SERVICE 2,071,270 2,113567 22 010-18-1411 AMULANCE-GARAGE PARTS & SERVICE 38,500 38,500 0.00% 0 0 38,500 38,500 0 0.00% 23 010-22-5100 BUILDING INSPECTION 1,249,864 1,154,507 -7.63% 1,598,833',' 1,598,833 (348,969) (444,326) (95,357) 0 0 27.33% 0.00% 0.00%' 24 010-17-2400 ANIMAL CONTROL 0 0 0 0.00% 0.00% 0 0 0 _ ..... 25 010-17-2450 ANIMAL CONTROL RESTRICTED DONATIONS 0 26 27 TOTAL -PUBLIC SAFETY 31,783,633 31,987,931 0.64% 4,931,717, 4,858,706 26,851,916 27,129,225 277,309 1.03% 28 29 30 PUBLIC WORKS 31 010-07-7650 SIDEWALKS 195,000 195,000 0.00% 195,000 195,000 0 0 0 0.00% 32 010-03-7940 PARKING FACILITY ADMINISTRATION 0 0 0.00% 0 ', 0 0 0 0 0.00% 33 010-17-7910 PARKING FACILITY MAINTENANCE 22,146 17,199 -22.34% 0', 0 22,146 17,199 (4,947) -22.34% 34 010-22-7930 PARKING OPERATIONS 523,500 525500 0.00% 525500'', 523,500 0 0 12,975 1,414,374 0 0.00% 35 010-29-7700 AIRPORT OPERATIONS 1,034,950 1,047,925 1.2554 1,034,950 1,034,950 0 12,975 NEW 36 010-01-7800 MET TRANSIT AUTHORITY 1,414,374 325,534 530,000 1,414,374 343,723 530,000 0.0054 0 0 1,414,374 0 0.0054 37 010-18-7950 CENTRAL GARAGE 5.59% 77,300 77,300 248,234 266,423 18,189 7.33% 38 010-18-7952 CENTRAL GARAGE - CHARGEBACKS 0.00% 530,000 530,000 0 0' 0 0.00% 39 010-18-7955 MOTOR POOL -PASS THROUGH ACCOUNT 1,935,768 1,935,768 0.00%1 1,956,859 1,956,859 (21,091) (21591)'.. 0 0.00% 40 41 1'TOTAL-PUBLIC WORKS 5,981,272 6,007,489 0.44% 4,317,609 4,317,609 1,663,663 1,689,880':. 26,217 1.58% 42 '1 - - 43 44 HEALTH & SOCIAL SERVICES 45 010-01-2200 BLACK HAWK COUNTY HEALTH DEPT. 75,000 75,000 0.00% 75000 75,000 0 0 0 0.00% 46 010-27-2500 HUMAN RIGHTS COMMISSION 262,954 ' 45,000 265,978 45,000 1.1554 0 0 262,954 0.00% 45,000 45,000 '- 0 265,978 3,024 0 0 1.15% 0.00% 47 010-27-2505 EEOC CONTRACT K:\USERS\MICHELLE-W\Budget FYE18\FY18 B U DG ET_Base 1 1/30/2017 5:02 PM FYE2017 CERTIFIED AND FYE2018 PROPOSED BUDGET COMPARISON - CITY OF WATERLOO Base Budget GENERAL FUND 1/30/2017 K:\USERS\MICHELLE-W\8udget FYE18\FYI8BUDGET_Base 2 1/30/2017 5:02 PM A B E F G H 1 J K L M 1 FY2017 BUDGET FY 2018 BUDGET % FY2017 BUDGET 1 FY2018 BUDGET: FY2017TAXES FYE2018 LEVY $ 17.52473 -0.46% RATE REQUESTED 2 BUDGET CODE ACTIVITIES -GENERAL FUND CERTIFIED BASE CHANGE CERTIFIED BASE LEVIED $ 17.60522 $ AMOUNT % 3 EXPENSE LEVEL '1 REVENUE LEVEL CHANGE CHANGE 4 48 010-27-2510 FAIR HOUSING ENFORCEMENT 45,000 0 0 45,000 0 0 0.00% 0.00% 0.00% 45,000 45,000 0 0 - 0 0 0 0 0 0 0 - 0 0 0 0 0.00% 0.00% 0.00% 49 010-27-2510 FAIR HOUSING PARTNERSHIP GRANT 50 010-27-2520 HUMAN RIGHTS PROJECTS 51 52 TOTAL -HEALTH & SOCIAL SERVICES 427,954 430,978 0.71% 165,000 ' 165,000 262,954 265,978 ' 3024 1.15% 53 -, - 54 55 CULTURE & RECREATION 56 010-01-3330 KBBG COMMUNICATIONS 0 0 , 0,00% 0 0 0 0 0 0.00% 57 010-01-4405 CEMETERY OPERATIONAL SUBSIDY 50,000 50,000! 0.00% 0'1 0 50,0001 50,0001 ' 619,364 0 11,031 0.00% 1.81% 58 010-01-4420 GROUT MUSEUM 634,334 645,809 !, 1.81% 26,001 26,445 608,333 59 010-26-4208 YOUTH PAVILION 430,315 442,028 2.72% 84,300 84,300 346,015 357,728 !, 11,713 3.39% 60 010-26-4250 CENTER FOR THE ARTS 818,818 786,258 ' -3.98% 117,800 117,800 701,018 I 668,458 1 (32,560) -4.64% 61 010-26-4251 RIVERLOOP EVENT FACILITIES 10,700 10,700 35,000 0 0 1,772,803 18,417 - 3,000 51,865 20,000 4,120 71,163 10,000 1,727,148 880,000 i 0.00% 0.00% 0.00% 0.00% -3.28% 0.00% 0.00% 0.00% 0.00% 0.00% 13.23% 0.00% 3.80% 12,000: 35,000 0 0 79,621 18,417 3,000 51,865 20,000 4,120 62,846 10,000 48,060 12,000(1,300)!1 35,000 0 0 _ 79,621 - 18,417 3,000 51,865 20,000 4,120 71,163 10,000 48,060 (1,300)' 0 0 0 0 0 0 1753,350 1,6931821 0 0 0 0 • 0 0 0 0 0 0 0 0 0 0 1,615,811 1,679,088 0 0 0 0 (60,168) 0 0 0 0 0 0 0 63,2771 0.00% 0.00% 0.00% 0.00% -3A3% - - 0.00% 0.00% 0.00% 0-00% 0.00% 0.0064 0.00% 3.92% 62 010-26-4265 C&A GRANTS & PROJECTS 35,000 63 010-26-4265 CENTER FOR THE ARTS (H/M) 0 0 1832,971 18,417 64 010-26-4265 '!CENTER FOR THE ARTS (DISCR H/M) 65 010-33-3100 LIBRARY SERVICES 66 010-33-3110 LIBRARY- ENRICH IOWA GRANT 67 010-33-3150 LIBRARY OPEN ACCESS PLUS 3,000 68 010-33-3160 LIBRARY GRANTS 51,865 20,000 4,120 62,846 10,000 1,663,871 860,000 69 010-33-3180 LIBRARY GIFT & MEMORIAL 70 010-33-3190 IOWA LIBRARY SERVICE 71 010-33-3200 COUNTY LIBRARY 72 010-33-3210 LIBRARY OPEN ACCESS 73 010-37-4100 LEISURE SERVICES - PARKS 74 010-37-4102 LEISURE SERVICES - PARKS - CHARGEBACKSI ", 0.00% 0.00% 0.00% !1..__..__17, 0.00% 880,000 22,000 0 0 880,000 22,000 0 0 0' 0 0 0 0 0 ...... 17,900 17,900 0!, 0.00% 0 0.00% 0 0.00% . 0 0.00% 75 010-37-4105 LEISURE SERVICES PROJECTS 22,000 22,000 _...__ 0 '. 17,900 PROJECTS _.. 17,900 77 010-37-4106 LEISURE SERVICES HILL PARK 78 010-37-4110 LEISURE SERVICES - DOWNTOWN MTCE 302,632 304,268 0.54% 0 0 302,632! 304,268 1,636' 0.54% 79 010-37-4120 GOLF COURSES 1,262,177 10,740 1,267,534 10,740 1,276,000 634,715 11 0.4264 0.00% 0.00% 0.38% 1,010,750 10,740 1,276000 307,175 1,010,750 10,740 1,276,000 307,175 251,427 0 0 325,119 ! 256,784 0 0 327,540 5,357 • 2.1364 6 0.00% 0 0.00% 2,421 0.74% 80 010-37-0125 GOLF COURSE IMPROVEMENTS -SURCHARGE 81 010-37-4180 SPORTSPLEX 1,276,000 82 010-37-4200 SPORTS &YOUTH SERVICES 632,294 83 010-37-4500 YOUNG ARENA 823,080 824,624 0.19% 765,960 765,960 57,120 58,664 1,544 2.70% 84 85 TOTAL -CULTURE & RECREATION 10,873,080 10,886,092 0.12%', 4,845,655 6,031,676 4,251 0.07% 86 - 87 88 COMMUNITY& ECONOMIC DEVELOPMENT 89 010-08-5700 PLANNING & ZONING 591,808 615,311 3.97%I 367,505 367,505 224,303 247,806 23,503 10.48% 90 010-08-5750 RECREATION AREA DEVELOPMENT 0 0 0.00%1 45,200 45,200 (45,200) (45,200) 0 0.00% K:\USERS\MICHELLE-W\8udget FYE18\FYI8BUDGET_Base 2 1/30/2017 5:02 PM FYE2017 CERTIFIED AND FYE2018 PROPOSED BUDGET COMPARISON - CITY OF WATERLOO GENERAL FUND Base Budget 1/30/2017 A B E F G H 1 J K L M 1 FY2017 BUDGET FY 2018 BUDGET % FY2017 BUDGET FY2018 BUDGET FY2017TAXES FYE2018 LEVY $ 17.52473 -0.4600/° RATE REQUESTED 2 BUDGET CODE ACTIVITIES -GENERAL FUND CERTIFIED BASE CHANGE CERTIFIED BASE LEVIED $ 17.60522 $ AMOUNT % 3 EXPENSE LEVEL REVENUE LEVEL CHANGE CHANGE 4 91 010-08-5885 CITY PROPERTY MANAGEMENT 110983 110983 32,151 0.00% 0.00% 01 0 1 100,000 0 240,000 80,000 600,000 '.. 249,569 5,000 35,617 0 0 110983 110,9831 32,151 32,151 0 0 0.00% 0.00% 92 010-01-5710 INRCOG MEMBERSHIP 32,151 93 010-08-6100 PLANNING & ZONING -ECONOMIC DEVEL 100000 0 103,493 0'. 240,000 80,000 600,000. 289,000 5000 35,617. 3.49% 0.00% 0.00% 0.00°% 0.0000% 15.80% 0.00% 0.00°°/ 103,493 0 240 000 80,000 600,000 289,000 5,000 35,617 0 0 0 0 0 "0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00% 0.0035 0100%' 0.00% 0.00°10 0.00%' 0.00%' 0.00 0.00% 94 010-08-6105 ECONOMIC DEVELOP -SPECIAL PROJECTS 95 010-01-6650 TOURISM PROMOTION -VARIOUS GRTS (H/M) 240,000 96 010-01-6660 TOURISM PROMOTION -VARIOUS DISCR (H/M) + 80,000 97 010-01-6920 CONVENTION & VISITORS BUREAU (H/M) 600,000 98 010-22-6860 SULLIVAN CENTER MAINTENANCE -: 249,569 5,000 35,617 99 010-32-5850 COMM DEVEL-ADMINISTRATIVE 100 010-32-5861 COMM DEVELHAPHOUSING POOL 101 102 TOTAL -COMMUNITY& ECONOMIC DEV 2,045,128 2,111,555 3.25% 1,722,891 1,765,815 322,237 345,740 23,503 7.29% 103 - - - 104 105 GENERAL GOVERNMENT 106 010-01-8200 MAYOR'S OFFICE 216,768 406,430 40,000 252,629 410,535 40,000 16.5435 0 0 216,768 252,629 35,861 16.54% 107 010-01-8220 ADMIN SERVICES/MIS 1.01% 1,445 1,445 404,985 409,090 4,105 1.01% 108010-01-8222 ADMIN SERVICES/MIS - CHARGEBACKS 0.00% 40,000 40,000 0 0 0 0.00% 109010-02-8100 CITY COUNCIL 70,299 71,493 1,382,870 1,405,696 0 0 1,70% 0 5,152,485 0 0 5,152,485 0 70,299 71,493 1,194 1.7035 110010-03-8400 CITY CLERK AND FINANCE 1.65% (3,769,615) (3,746,789) 22,826 -0.61% 111 010-03-8400 CITY CLERK AND FINANCE- ELECTION COSTS 0.00% 0 0 0 0.00% 112010-03-8402 CITY CLERK AND FINANCE -CHARGEBACKS 77,500 77,500 0.00% 77,500 77,500 0 0 0 0.00% 113010-06-8600 CITY ATTORNEY 331,811 1,384,312 500,000 334,406 1,392,988 500,000 0,7835 0 0 331,811 334,406 2,595 0.78% 114 010-03-8900 LIABILITY INSURANCE 0.630% 0 0 1,384,312 1,392,988 8,676 0.63% 115010-03-8902 LIABILITY INSURANCE -CHARGEBACKS 0.00% 500,000 500000 0 0 0 0.00% 116 010-03-8905 HEALTH/LIFE INSURANCE 0 0 0.00% 0 0 0 0 0 0.00% 117 010-03-8950 SELF FUNDED HEALTH INSURANCE 306,430 306,430 0.00% 1,932,974 1,932,974 (1,626,544) (1,626,544) 0 0.00% 118 010-03-8960 SELF FUNDED WORK COMP 677,457 677,457 0.00% 75,000 75,000 602,457 602457 0 0.0035 119 010-03-8150 PUBLIC ACCESS STUDIO 152,199 153,681 0.97% 65,750 65,750 86,449 87,931 1,482 1.71% 120010-03-8970 PRINT SHOP 46,000 46,000 0.00% 0 0 46,000 46,000 0 0.00% 121 010-09-2600 EAP SUBSTANCE ABUSE PROGRAM 14,500 308,159 32,500 14,500 403,823 32,500 0.00% 0 0 14,500 14,500 0 0.00% 122 010-09-8250 HUMAN RESOURCES 31.04% 0 0 308,159 403,823 95,664 31.04% 123010-09-8252 HUMAN RESOURCES - CHARGEBACKS 0.00% 32,500 32,500 0 0 0 0.00% 124 010-09-8255 SAFETY COMMITTEE 15,000 15,000 0.00% 0 0 15,000 15,000 0 0.00% 125 010-22-8800 CITY HALL/FACILITIES MAINTENANCE 550,063 575,583 5,085 8,815 4.64% 0.00% 0.00% 0 _ ,5 ,085 0 0 5,085 0 550063 '. 0 8,815 575,583 0 8,615 25,520 0 4.64% 0.00% 126 010-22-8820 CITY FACILITIES RESTRICTED PROJECTS 5,085 8,815 127 010-22-8850 VETERANS MEMORIAL HALL 128200-09-8980 UNEMPLOYMENT FUND 40,000 40,000 0.00%o 0 0 40,000 40,000 0 0.00% 129 130 TOTAL -GENERAL GOVERNMENT 6,566,198 6,764,121 3.01% ''.. 7,882,739 7,882,739 ', (1,316,541) (1,118,618) 197,923 -15.03% 131 32 133 TRANSFERS K:\USERS\MICHELLE-W\Budget FYE18\FY18BUDGET_Base 3 1/30/2017 5:02 PM FYE2017 CERTIFIED AND FYE2018 PROPOSED BUDGET COMPARISON - CITY OF WATERLOO Base Budget GENERAL FUND 1/30/2017 K:\USERS\MICHELLE-1MBudget FYE18\FY18BUDGET_Base 4 1/30/2017 5:02 PM A B E F 0 H 1 J K L M 1 FY2017 BUDGET FY 2018 BUDGET % FY2017 BUDGET '.. FY2018 BUDGET FY2017TAXES FYE2018 LEVY $ 17.52473 -0.46% RATE REQUESTED 2 BUDGET CODE ACTIVITIES -GENERAL FUND CERTIFIED BASE CHANGE CERTIFIED BASE LEVIED $ 17.60522 $ AMOUNT % 3 EXPENSE LEVEL REVENUE '� LEVEL CHANGE CHANGE 4 134010-03-9050HOTEL/MOTEL DEBT SERVICE TRANSFER 47250 t 127,000 174,250 0 127,000 127,000 -100.00% 47250 0.00% "127,000127000 0.000% -27.12% 174,250 0 127,000 ( 0 0 0 0 0 0 0.00% 0.00% 1355010-03-9050 '..TIF ECONOMIC DEV TRANSFER (INTERNAL TIF 136010-08-9050 ", PLANNING & ZONING TRANSFER (TIF) 137 TOTAL -TRANSFERS li 0 0 0 0.00% 138 `I r;: 010-03-8400 ;:1338,990 500000 0I 1358,885( 500,000 139 STATE REPLACEMENT FUNDS (COMM/IND ROI 0 0 (1238,990) (1,358,885) (19,895) 1.49% 140 PROPOSED USE OF FUND BALANCE 0 0 0.00% (500,000) (500,000) 0 0.00% 141 PERSONAL SERVICES INCREASES 0 0.00% 0 0 0 0 0.00% 142 143 TOTAL CITY BUDGET -GENERAL FUND 57,851,515 58,315,166 0.80% 25,878,851 25,830,170 31,972,664 32,484,996 512,332 1.60% 144- - - K:\USERS\MICHELLE-1MBudget FYE18\FY18BUDGET_Base 4 1/30/2017 5:02 PM FYE2017 CERTIFIED AND FYE2018 PROPOSED BUDGET COMPARISON - CITY OF WATERLOO Base Budget GENERAL FUND 1/30/2017 K:\USERS\MICHELLE-W\ Budget FYE18\FY18 B U DG ET_Base 5 1/30/2017 5:02 PM A B E F G H I J K L M 1 FY2017 BUDGET FY 2018 BUDGET % FY2017 BUDGET FY2018 BUDGET FY2017TAXES FYE2018 LEW $ 17.52473 -0.46% RATE REQUESTED 2 BUDGET CODE ACTIVITIES -GENERAL FUND CERTIFIED BASE CHANGE CERTIFIED BASE LEVIED $ 17.60522 $ AMOUNT % 3 EXPENSE LEVEL REVENUE LEVEL CHANGE CHANGE 4 145 TAXABLE VALUATION FYE2017 FYE2018 Increase % Increase 146 (In Thousands) 2,391,757 (In Thousands) 2,439,290 (Decrease) 47,533 (Decrease) 1.99% 147 Taxable valuation - including TIF but excluding gas & electric utility values 148 Taxable valuation - excluding TIF & gas & electric utility values 2,161,858 2,209,441 47,583 2.20% 149 Taxable valuation - including TIF and electric utility values 2,482,984 2,523,795 40,811 1.64% 150 Taxable valuation - excluding TIF but including gas & electric utility values 2,253,085 2,293,945 40,860 1.81% 151 Commercial/Industrial Property Rollback 96,301 97,939 1,638 1.70% 152 Taxable valuation - Ag Land 12,329 12,521 192 1.56% 153 Tax Askings per One Cent of Levy 22,531 22,939 409 1.81% 154 155 PROPERTY TAX LEVY ANALYSIS: FY2017 TAX FY2017 TAX FY2018 TAX STATE BACKFILL FY2018 TAX $ AMOUNT 156 LEVY RATE LEVY CORP ROLLBACK `, 324530 RATE CHANGE 157 DEBT SERVICE LEVY 7,848,809 $ 3.16104 7,848,809 $ 3.10992 $ - 158 POLICE & FIRE PENSION SYSTEM 4,182,396 $ 1.85630 4,307,747 183,918 $ 1.87788 $ 125,351 159 EMERGENCY MGMT COMMISSION LEVY 76,707 $ 0.03405 76,707 3,275 $ 0.03344 $ - 160 TRANSIT LEW 1,414,374 $ 0.62775 1,414,374 60,386 $ 0.61657 $ - 161 TORT INSURANCE LEW 1,384,312 $ 0.61441 1,392,988 59,473 $ 0.60725 $ 8,676 162 FICA/IPERS LEVY 1,894,763 $ 0.84096 1,946,611 2,846,818 602,457 83,110 $ 0.84859 $ 51,848 163 HEALTH INSURANCE LEVY 2,873,967 $ 1.27557 121,543 $ 1.24101 $ (27,149) 164 WORKERS COMP. INSURANCE LEVY 602,457 $ 0.26739 25,722 $ 0.26263 $ - 165 UNEMPLOYMENT LEVY 40,000 $ 0.01775 40,000 1,708 $ 0.01744 $ - 166 LIBRARY VOTED LEVY 608,333 $ 0.27000 619,365 26,444 26,444': $ 0.27000 $ 11,032 167 EMERGENCY LEW 608,333 $ 0.27000 619,365 $ 0.27000 $ 11,032 168 GROUT LEVY 608,333 $ 0.27000 619,365 26,444 $ 0.27000 $ 11,032 169 AG LAND LEVY 37,033 18,249,989 37,610 793 306' $ 577 -1r-70 GENERAL FUND $8.10 LEVY $ 8.10000 18,580,954 $ 8.10000 $ 330,965 172 TOTAL PROPERTY TAX LEVY $ 40,429,806 $ 17.60522 $ 40,953,170 $ 1,736,303 $ 17.52473 $ 523,364 173 ROLLBACK REPLACEMENT- GENERAL LEW EXCLUDING EMPLOYEE BENEFITS LEW $ 1,358,885 $ 174 ROLLBACK REPLACEMENT-GENERALLEW 1 $ 916,440 175 AMOUNT CHANGE IN TAX LEVY $ 523,364 $ (0.08) 176 %CHANGE 1.29% 1 18,580,955 -0.46% 177 AMOUNT (OVER) UNDER $8.10 LEVY LIMIT $ 0.00000 178 ADJUSTED TOTAL PROPERTY TAX LEVY (AT GF $8.10 LEVY LIMIT) $ 17.52473 179 180 GENERAL FUND $8.10 LEVY INCREASE (DECREASE) 330,966 181 TOTAL PROPERTY TAX COLLECTION INCREASE 1.29% K:\USERS\MICHELLE-W\ Budget FYE18\FY18 B U DG ET_Base 5 1/30/2017 5:02 PM FYE2017 CERTIFIED AND FYE2018 PROPOSED BUDGET COMPARISON - CITY OF WATERLOO Base Budget GENERAL FUND 1/30/2017 K:\USERS'MICHELLE-VV \Budget FYE18\FY18BUDGET_Base 6 1/30/2017 5:02 PM A B E F G H I J K L M 1 FY2017 BUDGET FY 2018 BUDGET % FY2017 BUDGET FY2018 BUDGET FY2017TAXES FYE2018 LEVY $ 17.52473 -0.46% RATE REQUESTED 2 BUDGET CODE ACTIVITIES -GENERAL FUND CERTIFIED BASE CHANGE CERTIFIED BASE LEVIED $ 17.60522 $ AMOUNT % 3 EXPENSE LEVEL REVENUE LEVEL I CHANGE CHANGE 4 182 183 Residential Tax Askings Home Value Avg Revaluation Adj Value Rollback Tax Incr (Decr) Monthly Change % Change IU4 $ 17.52473 $ 17.60522 185 FYE2018 147,973 147,973 0.569391 1,476.53 11.56 0.96 0.79% 186 FYE2017 147,973 2.88% 152,234 0.556259 1,490.84 25.86 2.16 1.77% 187 $ 17.76370 FY62016 147,973 147,973 0.557335 1,464.98 19.92 1.66 1.38% 188 $ 17.95159 FYE2015 154,138 -4% 147,973 0.544002 1,445.06 20.93 1.74 1.47% 189 $ 17.49319 FYE2014 154,138 154,138 0.528166 1,424.13 (0.01) (0.00) 37.79 3.15 0.00% 2.73% 190 $ 18.20505 FYE2013 154,138 154,138 0.507518 1,424.14 191 $ 18.53335 FYE2012 154,138 154,138 0.485299 1,386.35 65.76 5.48 4.98% 192 $ 18.26406 FYE2011 154,138 154,138 0.469094 1,320.59 34.15 2.85 2.65% 193 $ 18.30689 FYE2010 154,138 154,138 0.455893 1,286.43 38.51 3.21 3.09% 194 $ 18.36687 FYE2009 144,054 7% 154,138 0.440803 1,247.93 16.26 1.36 1.32% 195 $ 18.76669 FYE2008 144,054 144,054 0.455596 1,231.67 (17.04) (1.42) -1.36% 196 $ 18.84580 FYE2007 132,160 9% 144,054 0.45996 1,248.71 34.44 2.87 2.84% 197 $ 19.15566 FYE2006 132,160 N/A 132,160 0.479642 1,214.27 10.97 0.91 0.91% 198 $ 18.78999 FYE2005 118,000 12% 132,160 0.484558 1,203.30 56.70 4.72 4.95% 199 $ 18.90914 FYE2004 118,000 N/A 118,000 0.513874 1,146.60 26.52 2.21 2.37% 200 $ 18.37162 FY62003 100,000 18% 118,000 0.516676 1,120.08 118.52 9.88 11.83% 201 $ 17.80075 FYE2002 100,000 N/A 100,000 0.562651 1,001.56 96.99 8.08 10.72% 202 $ 16.49097 FYE2001 100,000 100,000 0.548525 904.57 <u� K:\USERS'MICHELLE-VV \Budget FYE18\FY18BUDGET_Base 6 1/30/2017 5:02 PM FYE2017 CERTIFIED AND FYE2018 PROPOSED BUDGET COMPARISON - CITY OF WATERLOO GENERAL FUND Base Budget 1/30/2017 K:\USERS\MICHELLE-W\ Budget FYE18\FY18BU DG ET_Base 7 1/30/2017 5:02 PM A B E F G H I J K L M 1 FY2017 BUDGET FY 2018 BUDGET % FY2017 BUDGET FY2018 BUDGET FY2017TAXES FYE2018 LEVY $ 17.52473 -0.46% RATE REQUESTED 2 BUDGET CODE ACTIVITIES -GENERAL FUND CERTIFIED BASE CHANGE CERTIFIED BASE LEVIED $ 17.60522 $ AMOUNT % 3 EXPENSE LEVEL REVENUE LEVEL CHANGE CHANGE 4 204 Commercial Tax Askings Property Value Avg. Revaluation Adj Value Rollback Tax Inv' (Decr) Monthly Change % Change WO $ 17.52473 $ 17.60522 206 FYE2018 752,427 752,427 752,427 0.90 0.90 11,867.47 11,921.98 (161.83) (107.32) (13.49) (8.94) -1.35% -0.89% 207 FYE2017 752,427 208 $ 17.76370 FYE2016 FYE2015 752,427 752,427 752,427 752,427 0.90 0.95 12,029.30 12,831.90 (802.60) (330.45) (66.88) (27.54) -6.25% -2.51% 209 $ 17.95159 210 $ 17.49319 FYE2014 752,427 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) (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.22 63.85 7.94% 223 $ 16.49097 FYE2001 500,000 17% 585,000 1 9,647.22 LLN K:\USERS\MICHELLE-W\ Budget FYE18\FY18BU DG ET_Base 7 1/30/2017 5:02 PM FYE2017 CERTIFIED AND FYE2018 PROPOSED BUDGET COMPARISON - CITY OF WATERLOO Base Budget GENERAL FUND 1/30/2017 K:\USERS\MICHELLE-W\Budget FYE18\FY18BUDGET Base 8 1/30/2017 5:02 PM A B E F G H 1 J K L M 1 FY2017 BUDGET FY 2018 BUDGET % FY2017 BUDGET FY2018 BUDGET FY2017TAXES FYE2018 LEVY $ 1752473 -0.46% RATE REQUESTED 2 BUDGET CODE ACTIVITIES GENERAL FUND CERTIFIED BASE CHANGE CERTIFIED BASE LEVIED $ 17.60522 $ AMOUNT 1 3 EXPENSE LEVEL REVENUE LEVEL CHANGE CHANGE 4 225 Industrial Tax Askings Adj Value Rollback Tax Incr (Decr) Monthly Change % Change $ 17.52473? 227 FYE2018 1,000,000 N/A 1,000,000 0.90 15,772.26 (215.07) (17.92) (11.89) -1.35% -0.89% 228 $ 17.60522 FYE2017 1,000,000 N/A 1,000,000 0.90 15,844.70 (142.63) 229 $ 17.76370 FYE2016 1,000,000 N/A 1,000,000 1,000,000 0.90 0.95 15,987.33 17,054.01 (1,066.68) 1 (439.18) (88.89) (36.60) -6.25% -2.51% 230 $ 17.95159 FYE2015 1,000,000 N/A 231 $ 17.49319 FYE2014 1,000,000 N/A 1,000,000 1 17,493.19 (711.86) (59.32) -3.91% 232 $ 18.20505 FYE2013 FYE2012 1,000,000 1,000,000 N/A N/A 1,000,000 1,000,000 1 1 18,205.05 18,533.35 (328.30) 269.29 (27.36) 22.44 -1.77% 1.47% 233 $ 18.53335 234 $ 18.26406 FYE2011 1,000,000 N/A 1,000,000 1 18,264.06 (42.83) (3.57) -0.23% 235 $ 18.30689 FYE2010 1,000,000 N/A 1,000,000 1 18,306.89 (59.98) (5.00) -0.33% 236 $ 18.36687 FYE2009 1,000,000 N/A 1,000,000 1 18,366.87 (399.82) (33.32) -2.13% 237 $ 18.76669 FYE2008 1,000,000 1,000,000 N/A N/A 1,000,000 1,000,000 1 1 18,766.69 18,845.80 (79.11) (309.86) (6.59) (25.82) -0.42% 238 $ 18.84580 FYE2007 -1.62% 239 $ 19.15566 FYE2006 1,000,000 N/A 1,000,000 1 19,155.66 365.67 30.47 1.95% 240 $ 18.78999 FYE2005 1,000,000 1,000,000 N/A N/A 1,000,000 1,000,000 1 1 18,789.99 18,909.14 (119.15) 537.52 (9.93) 44.79 -0.63% 2.93% 241 $ 18.90914 FYE2004 242 $ 18.37162 FYE2003 1,000,000 N/A 1,000,000 1 18,371.62 570.87 47.57 3.21% 243 $ 17.80075 FYE2002 1,000,000 N/A 1,000,000 1 17,800.75 1,309.78 109.15 7.94% 244 $ 16.49097 FYE2001 1,000,000 N/A 1,000,000 1 16,490.97 245 246 Multi -Residential Tax Askings Adj Value Rollback Tax Incr (Decr) Monthly Change % Change MIINIMININI 248 $ 17.52473 FYE2018 500,000 500,000 N/A N/A 500,000 500,000 0.8250 0.8625 7,228.95 7,592.25 (764.71) (401.41) (63.73) (33.45) (44.45) -9.57% -5.02% -6.25% 249 $ 17.60522 FYE2017 250 $ 17.76370 FYE2016 500,000 N/A 500,000 0.9000 7,993.67 (533.34) 251 $ 17.95159 FYE2015 500,000 N/A 500,000 0.9500 8,527.01 (219.59) (18.30) -2.51 % 252 $ 17.49319 FYE2014 500,000 N/A 500,000 • 8,746.60 K:\USERS\MICHELLE-W\Budget FYE18\FY18BUDGET Base 8 1/30/2017 5:02 PM