The URL can be used to link to this page

2015-08-18 Council Workshop-Budget44 CITY COUNCIL WORKSHOP AGENDA CITY OF MENDOTA HEIGHTS August 18 2015 5'00 g — pm Mendota Heights City Hall 1. CaII to Order 2. Roll CaII 3. 2016 Budget Review 4. Adjourn Budget Workshop August 18, 2015 1.Call to Order 2.Roll Call 3.FY 2016 Operating Budget Review  Overview McNeill/Schabacker  Draft Operating Budget Review Line Items/Improvement Packages General Fund Mayor/City Council o Administration, including HR, Finance, City Clerk o IT o Planning o Public Works/ Parks/ Engineering/Building Official o Police o Fire o st 4.Direction for Sept. 1 Workshop, including Enterprise Funds/ Recreation 5.Adjourn Budget Discussion Index Operating Budget Improvement Packages Mayor/City Council 14 Administration 15-6 #5 p. 73 City Hall Safety HR #1 p. 68 Job Eval System #2 p. 69 City Hall Color Copier #3 p. 70 Pilot Knob Restoration Finance City Clerk 17 #4 p. 71-2 Laserfiche Scanning IT 18-9 #9 p. 78 Laserfiche Training #10 p. 79-80 Extra IT staffing #11 p. 81 City Hall Telephones #12 p. 82 Server Room Fire Planning/Recycling 30-1 #7 p. 75-6 Comp Plan Study #8 p. 77 Res area Code Study Public Works/ Streets 25-6 #23 p. 94 Dump Truck/Snow Plow #25 p. 96 Plow Quick Release / Parks 27-8 #24 p. 95 Turf Truckster Engineering 34-5 Building Official 24 Police 20-1 #6 p. 74 Cell Phone Amplifier #14 p. 85 Added Captain Position #15 p. 86 Firearms Replacement #16 p. 87 Protective Equipment #17 p. 88 Reserve Squad Purchase #18 p. 89 Taser Replacement #19 p. 90 Investigator Car #20 p. 91 AED Replacement Fire 22-3 #13 p. 83 Fire IT Needs #21 p. 92 Portable Pump #22 p. 93 Aerial Truck Repairs � CITY OF MENDOTA HEIGHTS page 2 1101 Victoria Curve I Mendota Heights, MN 55118 651.452.1850 phone 1 651.452.8940 fax www.mendota-heights.com DATE: August 18, 2015 TO: Mayor and City Council FROM: Mark McNeill, City Administrator SUBJECT: Preliminary FY 2016 Budget COMMENT: INTRODUCTION: At a workshop meeting on August 18th, the City Council will discuss staff recommendations for the proposed General Fund Operating and Capital Budgets for FY 2016. This is the first of two scheduled budget workshops; the second is September 1st. The preliminary budget must be certified by September 30th this year; this is 15 days later than have been previous certifications. This means that the preliminary budget should be adopted at the September 15th Council meeting, This preliminary budget should be considered the maximum levy; the Council has the ability to reduce it after the September adoption. It may not, however, increase it. As in previous years, the Council will hold a hearing in December to provide for public input. I recommend this be part of the regular City Council meeting on December 1st. The final budget must be adopted by December 28th BACKGROUND: In preparation for this budget, staff was instructed to prepare its FY16 budget request to provide for the same level of service as is being provided in 2015. This will be termed the Base Budget. With only a few exception, it is the same budget as was approved for 2015. However, some operating line items were increased if it looked like they have been consistently under - budgeted (overspent) in previous years. page 3 However, in order for the City Council to be fully informed on needs, any projects or expenditures which would be services above what has been provided previously were instructed to be listed on an Improvement Package request. Many of these qualify as capital expenditures, but others, like Comprehensive Plan updates or some IT expenditures, don't meet the traditional definition of Capital Expenditures. However, they should be considered to be major considerations. Some others of the improvement packages are being recommended for funding, either this year, or in FY 2016. However, the majority of them are not able to be funded if the tax rate to be kept at an acceptable level. However, the Council should be aware of the unmet needs. Tax Levy vs. Bond Rating Mendota Heights is justifiably proud of its AAA bond rating, and every effort should be made to retain it. One of the factors is the healthy General Fund balance which the City has built over the years. However, many expenditures which recently have not been able to be adequately provided for in the operating or capital budgets have had to be taken from the General Fund balance. As a result, the GF balance has been reduced from 98% in 2012 (relative to the General Fund Budget) to a current 80%. While there are no hard and fast rules as to the minimum that should be maintained to keep the current bond rating, we should be concerned if it drops below 75%. Therefore, a balance must be sought between under -budgeting so as to keep the tax rate down; reducing the General Fund balance, or finding services to cut. Base Budget: Without looking at any additional spending for 2016, the proposed Base -level budget is increased by $207,394 over 2015. This is due to the following: • Wages. As is typical in most municipal budgets, wages and benefits account by far for the largest portion of the overall expenditures. The proposed base budget assumes a 2% COLA, which is consistent with recent annual increases. It should be remembered, however, that all three of the City's labor contracts expire at the end of 2015. • Worker Comp Insurance. The City was notified this year that 2016's premiums will see a 25% increase, based on unfavorable experience. This accounts for $46,000 of the increase. Staff recommends a levy increase of $34,000, with the balance to come from a dedicated Workers Comp reserve. • Fund 13 Depletion. The purchase of the remaining Bourn Lane property took place in August, which nearly depletes that fund. In previous years, however, that fund was the source of a $40,000 annual transfer to the General Fund as a way to keep property taxes low. In 2016, however, that will not be available. • City Hall Rent. All departments housed in City Hall had their share of "rent" (depreciation) increased by 5%. That generates $10,000, but should be considered for an increase in the near future for needed upkeep. On a positive note, the City has learned that there will be a slight decrease in employee health insurance premiums for 2016. page 4 Reductions assumed: Staff is recommending the following changes in the Base Budget for FY16: • Delete 2015 New Patrol Position. In order to keep the 2016 levy increase down, the budgeted (but still unfilled) additional 2015 police patrol position is recommended to be removed from the 2016 budget. As a result, he number of sworn positions will remain at 17. • Employee Tuition Reimbursement. The City should examine the current tuition reimbursement rates (currently $5250 annually) for employees pursuing college degrees. YEAR TO YEAR DEPARTMENTAL COMPARISON: The following increases are proposed for each department. Note that, for the most part, they do NOT include capital expenditures. The exceptions are two IT servers for $16,000, and the election equipment in the City Clerk's budget which must be purchased prior to the 2016 election. The Base Level budgets 2015 to 2016 are: Department % Increase /Decrease Notes City Council 179.07 Increase of $60,000 in Contingency for city- wide expenditures Administration 2.52 Elections 78.33 Presidential election year; Purchase of required upgraded election equipment Information Technology 5.59 Equipment purchases Police Department 1.73 Fire Department --3.37 Building Official 12.33 More Inspection Activity anticipated due to Lemay development Streets 4.13 Prior year history on equipment repair, and sand/salt. Added tree cost (Emerald Ash Borer) Parks --3.45 Includes increase in tree maintenance (EAB) Recreation 3.64 Planning 3.46 Recycling 14.09 Increased Clean up day costs Animal Control 12.50 Anticipated Dog Park expenses page 5 The percentage increases or decreases may not reflect accurate impacts, due to the relative differences in size of budgets, and that for the most part, capital expenditures are not factored into the 2016 comparison numbers. IMPROVEMENT PACKAGES/CAPITAL EXPENDITURES: Staff submitted a total of 25 total improvement packages. The majority of these have previously been classified as Capital Expenditures. Individual sheets with more detailed explanations are in the attachments. There are 13 Improvement Packages which are recommended for funding in FY 2016. The total cost of those will be $158,027. If all are approved, it would add 2.26% to the levy. Three other Improvements Packages are recommended for funding, from sources other than the 2016 General Levy TAX IMPACT: Each 1% increase in the levy generates $70,000. The Base Level budget increase of 2.94%, but the overall levy increase is higher—currently proposed at 3.72%. The overall levy includes such things as: • Debt Service • Emergency Preparedness • Fire Relief • Infrastructure • Equipment reserve (currently, only police radios) With the proposed overall levy, and adding the Improvements Packages as recommended, it would mean a total levy increase of 5.98% for FY16. Translated to dollars, that is a levy increase of $418, 721. AS shown on the attached sheet, the property tax rate with these changes, would go from 34.594 in FY15, to 35.127. The page also shows the impact of the levy increase on three homes in Mendota Heights, valued at $334,863; $500,000; and $700,000. NON -GENERAL FUND BUDGETS If time permits at the August 18th workshop, staff will present the portions of the budget which are enterprise funds, or do not otherwise impact the general levy—the utility funds, engineering, Par 3, and the like. The rest of the levy must be certified by September 30th; these other funds don't need to be finalized before the end of the year. page 6 SUMMARY At the August 18th workshop, the Council should discuss and give direction on the preliminary FY16 Budget. Feedback will be incorporated into a more definite version for consideration at the scheduled September 1st workshop. Mark McNeill City Administrator page 7 TAX LEVY SUMMARY CITY OF MENDOTA HEIGHTS 2016 BUDGET TAX LEVY SUMMARY 2016 2016 % CHANGE GENERAL FUND $5,711,992 $6,056,054 6.02% EMERGENCY PREPAREDNESS $25,000 $25,000 0.00% FIRE RELIEF $90,000 $90,000 0.00% INFRASTRUCTURE/FACILITY RESERVE $20,000 $20,000 0.00% EQUIPMENT RESERVE $20,000 $20,000 0.00% LEGAL AND CONTINGENCY $40,000 $40,000 0.00% GENERAL FUND LEVY $5,906,992 $6,251,054 5.82% IMPROVEMENT BONDS $737,029 $828,509 12.41% EQUIPMENT CERTIFICATES $55,066 $53,765 -2.36% TOTAL SPECIAL LEVY $792,095 $882,274 11.38% MARKET VALUE REFERENDUM LEVY $267,887 $265,367 -0.94% STREETLIGHT TAXING DISTRICT $33,000 $20,000 -39.39% TOTAL TAX LEVY $6,999,974 $7,418,695 5.98% CITY OF MENDOTA HEIGHTS 2016 PRELIMINARY BUDGET BASE BUDGET W/IMPROVEMENTS BASE BUDGET sImma z o a o 0 0 � o OC) C\i CO r jr - CO N Cr r f: N 'Cr lf) N (0 (0 C] (0 CO O e 1 cv) N Cs) CV 0 • N CO Co Is.. CO T C) to CO C}' CO r^" N 00 LO O ✓ to O) Q O O 6 O .8 o 0 (Ni N a r r CO ▪ C r r - (Y) (�4 (o (d N 6ri C� d co r" 1 E 1 KO CO T ` 0tai ' w T cu tf) to cri N a cato co›, U O N CO CC Q N T a. C O '._ .0 -J 4 00 •� cc$ ca as 0 a cn - as U Cl (CS _D as ca _• u) N Z h 1!. Z w 0) E (0 LU r• to T d' CON to '1' (Q CO CO r• r ~ 0) ()N � rn CO tdf N Vt C) O LO LS co 0) as _ U [� (6 x.. Q O 0 0 0) > x CCS Q) (7S ea F— 0 as • 0 a) (0 H it. Z Z H page 8 Market Value for Residential Properties increased 5.17% from 2015 to 2016 CD ( o Q C) d a o (p co�O O c c 09 M .0 0) r') M .f,: to sn '0 0 0 e e 0 6 rn co C Lei 0i a) 0) lcl)) n 0 69 69 69 3 Total 2016 Tax CD (0 0) (t7 CD N co (o Y tl) co O 6969 E Lo O O 3 LO O -at Cs -a- co i Ea 69 04 t N cc '0 +n co X (1) co co co aj ui (Ni © v CV - 0 64 64 69 Total 2015 Tax 0 10 0) 1 CcNi 0"5o 0) ry CD c COCD H3 Total 2016 Tax l() (f) O) 0) 07 N c) t; co N N s() (V as 60 r-- r n3 64 64 ft7 (t) G7 O co co <t 0) 1'3 r-: r O r C CD CP o M9 w w r U C7 (n Cs) NI" co co 6 06 1.0 U) .-- N-..., '4 EH x c co ti F- 0) 0 h CO 0) N (D 0) i. N (V Ncl 69 69 69 (%} (H 69 11 C W 0 00 O O > 0) co O `o 6 O 2 [Y d O C0 O CS M. 0)O C) 6!3 69 64 69 69 4 p} D O N 000 CA 9 O (V 00 w 51:0 (0 14) '4) = ....... 0) (f) (f) E to 69 m E 6969. 01 0 0 0 En COS Tax Rates for Mendota Heights page 9 m E E G G m ay a) m a) 0) 11) CO O O N N " ID v) yr COS O O O O O h CLD N (() r (n F` CD N- 'd C) F- N 05,r (A (O M Ul 0) U) 04 CD 09 C) O'4 t (()M ('O ({1 V (t) 006 N0)0Y" 4 N NNNNN ('0 (0 M P70, V7(7 0) (D H CO 60 CS r N M it ([') (D (D O O O 0 - 1 r t- r e-- Y- y - CD CS C) C) C) O CD CD O O OO N N (V N N CV CV N N N (V N page 10 CITY OF MENDOTA HEIGHTS 2016 BUDGET TAX LEVY SUMMARY 2015 2016 % CHANGE GENERAL FUND $5,711,992 $5,898,027 3.26% EMERGENCY PREPAREDNESS $25,000 $25,000 0.00% FIRE RELIEF $90,000 $90,000 0.00% INFRASTRUCTURE/FACILITY RESERVE $20,000 $20,000 0.00% EQUIPMENT RESERVE $20,000 $20,000 0.00% LEGAL AND CONTINGENCY $40,000 $40,000 0.00% GENERAL FUND LEVY $5,906,992 $6,093,027 3.15% IMPROVEMENT BONDS $737,029 $828,509 12.41% EQUIPMENT CERTIFICATES $55,066 $53,765 -2.36% TOTAL SPECIAL LEVY $792,095 $882,274 11.38% MARKET VALUE REFERENDUM LEVY $267,887 $265,367 -0.94% STREETLIGHT TAXING DISTRICT $33,000 $20,000 -39.39% TOTAL TAX LEVY $6,999,974 $7,260,668 3.72% page 11 GENERAL FUND FUND 01 DEPARTMENT 2013 ACTUAL 2014 ACTUAL 2015 BUDGET 2016 PRELIMINARY % CHANGE CITY COUNCIL $33,275 $34,277 $33,796 $94,315 179.07% ADMINISTRATION $808,656 $851,456 $956,626 $980,768 2.52% ELECTIONS $28,692 $52,932 $41,088 $73,272 78.33% IT $131,216 $157,854 $138,437 $146,171 5.59% POLICE $2,973,890 $2,973,890 $3,337,183 $3,394,910 1.73% FIRE $399,204 $1,013,549 $474,615 $458,625 -3.37% BUILDING OFFICIAL $158,532 $130,852 $133,050 $149,455 12.33% PUBLIC WORKS -STREETS $1,421,938 $1,206,889 $981,232 $1,021,778 4.13% PUBLIC WORKS -PARKS $682,910 $725,979 $761,395 $735,157 -3.45% RECREATION $45,656 $56,559 $46,700 $48,400 3.64% PLANNING $96,321 $118,141 $122,231 $126,462 3.46% RECYCLING $25,028 $23,257 $24,370 $27,804 14.09% ANIMAL CONTROL $5,914 $4,862 $8,000 $9,000 12.50% TOTAL GENERAL FUND $6,811,231 $7,350,497 $7,058,723 $7,266,117 2.94% GENERAL FUND CONTINGENCY $65,872 $11,149 $40,000 $40,000 0.00% page 12 GENERAL FUND FUND 01 REVENUE SOURCE 2014 ACTUAL 2014 BUDGET 2015 BUDGET 2016 BUDGET % CHANGE TAXES CURRENT TAX LEVY $5,379,652 $5,454,959 $5,711,992 $5,898,027 3.26% LICENSES AND PERMITS CIGARETTE LICENSES $0 $600 $600 $600 0.00% RUBBISH LICENSES $1,415 $1,400 $1,400 $1,400 0.00% DOG LICENSES $1,115 $750 $800 $1,000 25.00% CONTRACTOR LICENSES $16,550 $17,000 $17,000 $17,000 0.00% LIQUOR LICENSES $31,363 $21,000 $21,000 $28,500 35.71% BUILDING PERMITS $336,441 $135,000 $180,000 $200,000 11.11% HEATING PERMITS $27,701 $25,000 $30,000 $32,000 6.67% PLUMBING PERMITS $11,171 $5,000 $7,000 $8,000 14.29% WATER PERMITS $60 $50 $50 $50 0.00% RIGHT OF WAY PERMITS $11,161 $5,000 $6,500 $10,000 53.85% MASSAGE PERMITS $2,096 $1,800 $2,000 $2,000 0.00% RENTAL LICENSES $4,425 $1,000 $3,500 $4,000 14.29% TOTAL LICENSES AND PERMITS $443,497 $213,600 $269,850 $304,550 12.86% FINES AND FORFEITS COURT FINES $57,234 $70,000 $68,000 $65,000 -4.41% FALSE ALARMS FINES $737 $3,500 $3,500 $3,000 -14.29% DOG IMPOUNDING $1,100 $1,000 $1,000 $1,000 0.00% TOTAL FINES AND FORFEITS $59,071 $74,500 $72,500 $69,000 -4.83% CHARGES FOR SERVICES ACCIDENT REPORTS $0 $0 $0 $0 0.00% RECREATION PROGRAMS $40,043 $29,000 $32,000 $38,000 18.75% PARK USE FEES $4,113 $7,000 $7,000 $5,000 -28.57% SOFTBALL LEAGUES $10,684 $11,000 $11,000 $11,000 0.00% MAPS AND ORDINANCES $29 $0 $0 $0 0.00% SURCHARGES $34 $0 $0 $0 0.00% PLANNING FEES $11,406 $6,500 $6,500 $10,000 53.85% FIRE CONTRACTS $85,217 $83,877 $101,067 $108,000 6.86% FIRE PERMITS $0 $0 $0 LILYDALE POLICING $223,512 $226,545 $229,883 $235,800 2.57% MENDOTA POLICING $67,356 $65,514 $73,861 $75,800 2.63% POLICE SECURITY (OFF DUTY OT) $11,313 $18,000 $18,000 $18,000 0.00% FIRE CALLS $0 $0 $0 $0 0.00% STREET MAINT. CHARGES $1,250 $1,000 $1,000 $1,000 0.00% ASSESSMENT SEARCHES/SPLITS $60 $0 $0 $0 0.00% STREET CHARGES $0 $0 $0 $0 0.00% FILING FEES $40 $20 $0 $20 100.00% LEASE MAINTENANCE CHARGES $2,257 $3,500 $3,500 $3,000 -14.29% TOTAL CHARGES FOR SERVICES $457,314 $451,956 $483,811 $505,620 4.51% page 13 INTERGOVERNMENTAL MSA MAINTENANCE $137,287 $128,000 $130,000 $136,000 4.62% POLICE STATE AID $129,472 $110,000 $115,000 $118,000 2.61% SCHOOL RESOURCES OFFICER $99,303 $95,000 $97,000 $99,000 2.06% FEDERAL AND STATE GRANTS $15,987 $6,000 $6,000 $6,000 0.00% DAKOTA COUNTY GRANT $656 $10,000 $10,000 $10,000 0.00% PERA AID $9,073 $9,070 $9,070 $9,070 0.00% TOTAL INTERGOVERNMENTAL $391,777 $358,070 $367,070 $378,070 3.00% MISCELLANEOUS REVENUE SUNDRY REVENUE $27,936 $5,000 $5,000 $5,000 0.00% GRAVEL TAX $100 $0 $0 $100 100.00% DONATIONS $20,706 $0 $0 $0 0.00% INTEREST $115,322 $35,000 $35,000 $35,000 0.00% TOTAL MISCELLANEOUS $164,064 $40,000 $40,000 $40,100 0.25% DAKOTA COUNTY WASTE MANAGEMENT $15,000 $14,000 $14,000 $15,000 7.14% TOTAL DAKOTA COUNTY $15,000 $14,000 $14,000 $15,000 7.14% OTHER REVENUE UNAPPROPRIATED FUND TRANSFEF $109,500 $109,500 $99,500 $55,750 -43.97% TOTAL OTHER REVENUE $109,500 $109,500 $99,500 $55,750 -43.97% TOTAL GENERAL FUND REVENUE $7,019,876 $6,716,585 $7,058,723 $7,266,117 2.94% page 14 CAT OBJ DESCRIPTION 2013 2014 2015 2016 ACTUAL ACTUAL BUDGET PRELIMINARY CHANGE CITY COUNCIL 4110 SALARIES -REGULAR $22,592 $22,592 $22,500 $22,500 0.00% 4133 WORKERS COMPENSATION $50 $78 $75 $94 25.33% 4135 FICA $1,728 $1,728 $1,721 $1,721 0.00% TOTAL HUMAN RESOURCES $24,370 $24,398 $24,296 $24,315 0.08% 4400 CONFERENCES AND SCHOOLS $1,283 $850 $1,500 $1,500 0.00% 4480 CONTINGENCY $0 $0 $0 $60,000 4490 HALLOWEEN BONFIRE $1,277 $1,902 $1,500 $1,500 0.00% 4490 FIREWORKS $4,000 $4,000 $4,000 $4,000 0.00% 4490 SUNDRY EXPENSES $2,344 $3,127 $2,500 $3,000 20.00% TOTAL OTHER CHARGES $8,904 $9,878 $9,500 $70,000 636.84% $0 4600 CAPITAL OUTLAY $0 $0 $0 0.00% TOTAL CAPITAL OUTLAY $0 $0 $0 $0 0.00% TOTAL EXPENDITURES $33,275 $34,277 $33,796 $94,315 179.07% CAPITAL OUTLAY ITEMS REQUESTED APPROVED page 15 CAT OBJ DESCRIPTION 2013 2014 2015 2016 ACTUAL ACTUAL BUDGET PRELIMINARY CHANGE ADMINISTRATION 4110 SALARIES -REGULAR $411,360 $428,269 $427,608 $454,683 6.33% 4115 SALARIES -OVERTIME $0 $0 $0 $0 0.00% 4130 SALARIES -TEMPORARY $0 $0 $0 $0 0.00% 4131 INSURANCE $78,373 $74,601 $98,794 $98,794 0.00% 4133 WORKERS COMPENSATION $4,517 $5,431 $5,500 $6,875 25.00% 4134 PERA $29,270 $30,052 $33,140 $34,101 2.90% 4135 FICA $32,138 $32,515 $32,712 $34,783 6.33% 4137 EMPLOYEE ASSISTANCE PROGRAM $1,693 $1,693 $1,650 $1,700 3.03% 4136 FLEX BENEFITS $0 $0 $0 $0 0.00% TOTAL HUMAN RESOURCES $557,351 $572,560 $599,404 $630,936 1 5.26% 4200 RENTALS AND LEASES $267 $237 $500 $400 -20.00% 4209 CITY HALL OCCUPANCY $61,810 $61,810 $61,810 $64,900 5.00% 4210 TELEPHONE $6,375 $5,968 $5,500 $6,200 12.73% 4220 CITY ATTORNEY $5,389 $7,342 $15,000 $12,000 -20.00% 4220 AUDITOR $18,500 $18,750 $19,000 $19,570 3.00% 4220 CODIFIER -LINK TO CITY CODE $500 $500 $600 $600 0.00% 4220 CODIFICATION SERVICES $1,933 $2,182 $3,000 $2,500 -16.67% 4220 MNETACCESS $1,776 $1,369 $0 $0 0.00% 4220 STAFF TRAINING $1,350 $0 $2,250 $2,250 0.00% 4220 SAFETY TRAINING $250 $350 $2,400 $2,400 0.00% 4220 COUNCIL RECORDING SERVICES $2,494 $2,887 $3,000 $3,000 0.00% 4220 CHECK PROTECTION SERVICE $2,480 $2,490 $2,500 $0 -100.00% 4220 RECORDS MANAGEMENT $7,626 $11,783 $0 $0 0.00% 4220 MISCELLANEOUS $2,823.71 $1,337 $3,000 $3,000 0.00% 4221 RETAINER -CITY ATTORNEY $5,400 $4,700 $5,000 $5,000 0.00% 4221 RETAINER -CITY ENGINEER $13,500 $13,500 $13,500 $13,500 0.00% 4240 LEGAL PUBLICATIONS $1,727 $1,731 $1,700 $1,800 5.88% 4250 LIABILITY AND AUTO INSURANCE $65,510 $67,054 $83,750 $86,000 2.69% 4268 NEWSLETTER $4,469 $6,398 $9,000 $8,000 -11.11% TOTAL CONTRACTUAL SERVICES $204,180 $210,388 $231,510 $231,120 -0.17% 4300 OFFICE SUPPLIES $6,351 $6,209 $6,000 $6,500 8.33% 4301 COMPUTER SOFTWARE $0 $0 $0 $0 0.00% 4306 RECRUITMENT COSTS $55 $15 $0 $0 0.00% 4318 POSTAGE $2,145 $2,249 $2,100 $2,300 9.52% 4330 EQUIPMENT REPAIR $2,278 $1,935 $1,600 $2,000 25.00% 4330 SOFTWARE MAINTENANCE $2,007 $1,980 $0 $0 0.00% 4331 MISCELLANEOUS FURNITURE/EQUIP $0 $0 $1,000 $0 -100.00% TOTAL COMMODITIES ' $12,836 $12,388 $10,700 $10,800 0.93% page 16 4400 CONFERENCES AND SCHOOLS $9,763 $5,377 $11,000 $10,000 -9.09% 4402 BOOKS AND SUBSCRIPTIONS $0 $0 $100 $100 0.00% 4404 MEMBERSHIP DUES $15,030 $15,884 $17,500 $17,500 0.00% 4415 MILEAGE AND AUTO ALLOWANCE $2,480 $2,297 $3,000 $3,000 0.00% 4437 CREDIT CARD FEES $2,202 $2,626 $1,200 $2,600 116.67% 4480 CONTINGENCY $2,594 $26,729 $15,000 $7,500 -50.00% WSP ICE ARENA CONTRIBUTION $0 $0 $65,212 $65,212 0.00% 4490 SUNDRY EXPENSE $2,219 $3,207 $2,000 $2,000 0.00% TOTAL OTHER CHARGES J $34,289 $56,120 $115,012 $107,912 -6.17% $0 $0 $0 4600 CAPITAL OUTLAY $0 0.00% TOTAL CAPITAL OUTLAY $0 $0 $0 $0 0.00% TOTAL EXPENDITURES $808,656 $851,456 $956,626 $980,768 2.52% CAPITAL OUTLAY ITEMS REQUESTED APPROVED page 17 CAT OBJ DESCRIPTION 2013 2014 2015 2016 ACTUAL ACTUAL BUDGET PRELIMINARY CHANGE ELECTIONS 4110 SALARIES -REGULAR $19,873 $20,593 $21,482 $22,727 5.80% 4115 SALARIES -OVERTIME $0 $1,460 $0 $2,000 100.00% 4125 SALARIES -ELECTION JUDGES $0 $15,048 $0 $16,500 100.00% 4130 SALARIES -TEMPORARY $0 $0 $0 $0 0.00% 4131 INSURANCE $4,117 $3,631 $6,098 $6,098 0.00% 4134 PERA $1,436 $1,597 $1,665 $1,855 11.41% 4135 FICA $1,483 $1,644 $1,643 $1,892 15.16% TOTAL HUMAN RESOURCES $26,910 $43,973 $30,888 $51,072 65.35% 4220 CONSULTING FEES $0 $2,117 $0 $2,200 100.00% 4240 LEGAL PUBLICATIONS $0 $320 $0 $350 100.00% TOTAL CONTRACTUAL SERVICES 100.00% 4300 OFFICE SUPPLIES $0 $536 $0 $550 100.00% 4318 POSTAGE $0 $797 $0 $850 100.00% 4330 DAKOTA COUNTY SHARED EQUIPMENT $1,625 $1,665 $0 $2,700 100.00% TOTAL COMMODITIES $1,625 $2,997 1 $0 1 $4,100 100.00% 4415 MILEAGE AND AUTO ALLOWANCE $157 $223 $200 $250 25.00% 4490 SUNDRY EXPENSE $0 $3,302 $0 $2,300 100.00% 4490 10 NEW VOTING BOOTHS $0 $0 $0 $2,000 100.00% TOTAL OTHER CHARGES ilibi57 I AIIIIIMMIllkara 2175.00% 4600 CAPITAL OUTLAY $0 $0 $10,000 $11,000 10.00% TOTAL CAPITAL OUTLAY $10,000 $11,000 100.00% TOTAL EXPENDITURES $28,692 $52,932 $41,088 $73,272 78.33% CAPITAL OUTLAY ITEMS REQUESTED APPROVED ELECTION EQUIPMENT $11,000 page 18 CAT OBJ DESCRIPTION 2013 2014 2015 2016 ACTUAL ACTUAL BUDGET PRELIMINARY CHANGE INFORMATION TECHNOLOGY (IT) 4110 SALARIES -REGULAR $73,624 $75,643 $36,513 $39,105 7.10% 4115 SALARIES -OVERTIME $0 $0 $0 $0 0.00% 4131 INSURANCE $4,574 $8,432 $7,841 $7,841 0.00% 4134 PERA $5,220 $5,494 $2,830 $2,933 3.64% 4135 FICA $5,872 $5,727 $2,793 $2,992 7.12% 1 'TOTAL HUMAN RESOURCES $89,290 $95,296 $49,977 $52,871 5.79% 4210 TELEPHONE $0 $50 $0 $1,680 #DIV/0! 4220 WEBSITE COSTS - CIVIC PLUS $1,100 $1,150 $4,000 $0 -100.00% SECURITY AUDIT $0 $0 $1,000 $0 -100.00% CITY ENGINEER $0 $1,212 $2,000 $1,000 -50.00% LOGIS SUPPORT $891 $4,784 $2,000 $5,000 100.00% WEB SERVICES $230 $0 $1,500 $1,500 100.00% OTHER $0 $238 $0 $750 100.00% TOTAL CONTRACTUAL SERVICES $2,221 $7,434 $10,500 $8,250 ® -21.43% 4301 COMPUTER SOFTWARE AND HARDWARE $5,771 TREND LICENSES $3,553 $2,178 $2,500 $2,500 0.00% OFFICE SUBSCRIPTION/OFFICE 365 $8,479 $7,933 $14,000 $15,500 10.71% COMPUTERS - ADMIN $9,375 $7,155 $4,200 $4,500 7.14% COMPUTERS - PUBLIC WORKS $3,000 100.00% COMPUTERS - POLICE $1,212 $0 COMPUTER - FIRE/CAD $1,657 $0 WIRELESS CONTROLLER $6,000 100.00% SECURITY CAMERAS $10,000 100.00% BACKUPS/SOFTWARE $3,099 $5,315 $1,700 $3,500 105.88% AIRWATCH $4,140 $2,640 $2,700 100.00% MISC HARDWARE & SOFTWARE $7,043 $2,000 $1,000 100.00% LASERFICHE $1,809 $8,606 $9,300 100.00% ADDITIONAL LASERFICHE LICENSES $2,000 $1,600 100.00% BUILDING SECURITY SOFTWARE $1,491 $0 $0 0.00% COMPUTER SOFTWARE - ADMIN $2,100 $2,100 100.00% COMPUTER SOFTWARE - PUBLIC WORKS $1,500 100.00% ADOBE ACROBAT $500 100.00% PHOTOSHOP $200 100.00% ADMIN - PRINTER $600 $600 100.00% WINDOWS SERVER 2012/WINDOWS CAL $1,797 $2,100 $2,100 100.00% EXCHANGE GALS $0 $1,000 100.00% BATTERY BACKUPS $1,000 100.00% OTHER $2,000 100.00% SWITCH - FIRE & PUBLIC WORKS $8,000 CELL PHONES - ADMIN $2,500 CELL PHONES - PUBLIC WORKS $3,564 TOTAL COMMODITIES = $32,980 $39,028 $61,010 $66,100 8.34% 4400 CONFERENCES AND TRAINING $50 $609 $2,000 $2,000 0.00% 4402 BOOKS AND SUBSCRIPTIONS $85 $0 $600 $600 0.00% 4404 MEMBERSHIP DUES $0 $290 $0 $0 0.00% 4415 MILEAGE AND AUTO ALLOWANCES $64 $0 $350 $350 0.00% 4490 SUNDRY EXPENSE $476 $0 $0 $0 0.00% TOTAL OTHER CHARGES $676 $899 $2,950 1 $2,950 0.00% page 19 4600 CAPITAL OUTLAY $6,049 $15,198 $14,000 $16,000 14.29% TOTAL CAPITAL OUTLAY $6,049 $15,198 $14,000 $16,000 14.29% TOTAL EXPENDITURES $131,216 $157,854 $138,437 $146,171 5.59% CAPITAL OUTLAY ITEMS REQUESTED APPROVED page 20 CAT OBJ DESCRIPTION 2013 2014 2015 2016 ACTUAL ACTUAL BUDGET PRELIMINARY CHANGE POLICE 4110 SALARIES-REGULAR/PATROL $911,270 $946,241 $895,311 $936,429 4.59% 4110 SALARIES-REGULAR/ADMINISTRATION $678,419 $543,473 $751,987 $730,989 -2.79% 4115 SALARIES-OVERTIME/PATROL $103,592 $84,022 $90,500 $90,500 0.00% 4130 SALARIES -TEMPORARY $5,160 $7,014 $10,400 $10,400 0.00% 4131 INSURANCE $292,525 $283,267 $383,328 $374,616 -2.27% 4133 WORKERS COMPENSATION $51,413 $65,314 $68,000 $85,000 25.00% 4134 PERA/PATROL $141,987 $152,958 $150,829 $166,363 10.30% 4134 PERA/ADMINISTRATION $91,995 $77,403 $104,295 $105,387 1.05% 4135 FICA/PATROL $15,125 $15,568 $15,090 $15,686 3.95% 4135 FICA/ADMINISTRATION $13,555 $13,331 $19,739 $19,887 0.75% TOTAL HUMAN RESOURCES_ $2,305,042 $2,188,593 $2,489,479 $2,535,257 1.84% 4200 RENTALS AND LEASES $53,668 $52,556 $56,100 $63,812 13.75% 4209 CITY HALL OCCUPANCY $72,460 $72,460 $72,460 $76,083 5.00% 4210 TELEPHONE $15,767 $15,683 $19,700 $21,920 11.27% 4220 POST LICENSE RENEWALS $360 $585 $0 $180 100.00% 4220 ATTORNEY FEES $3,028 $4,937 $4,000 $4,000 0.00% 4220 OTHER PROFESSIONAL SERVICES $122 $9,309 4222 PROSECUTIONS $66,057 $64,272 $67,500 $70,692 4.73% 4223 OTHER CONTRACTUAL SERVICES DCC PUBLIC SAFETY BONDS $9,668 $735 $10,500 100.00% BCA DEPARTMENT ACCESS CHARGE $0 $0 $1,080 $1,080 0.00% BCA MOBILE ACCESS CHARGE $2,880 $2,880 $2,880 $2,880 0.00% DTSCP $0 $0 $0 $0 0.00% PRO PHOENIX RMS $14,216 $13,824 $21,296 $21,300 0.02% AIRCARD/NETMOTION $3,679 $3,346 $3,000 $3,000 0.00% LOGIS-APS TICKET WRITER $0 $0 $2,139 $2,134 -0.23% LOGIS-APPLICATION SUPPORT $26,028 $27,264 $17,464 $18,653 6.81% LOGIS-SYSTEM DEVELOPMENT $1,420 $1,492 $1,548 $1,548 0.00% LOGIS INET $50 $446 $9,819 $10,188 3.76% LOGIS ANY CONNECT/MAPS $0 $0 $1,650 $1,650 0.00% LEASE LINE MN OFFICE TECH GROUP $1,510 $1,504 $0 $3,360 100.00% CJIIN $9,131 $9,238 $9,750 $14,000 43.59% INT. ASSOCIATION OF POLICE CHIEFS $0 $0 $850 $850 0.00% AUTOMATED PAWN $204 $204 $204 $250 22.55% LEXISNEXIS $618 $718 $2,200 $2,200 0.00% LANGUAGE LINE - INTERPRETER SVCS $283 $55 $400 $500 25.00% OTHER CONTRACTUAL SERVICES $31 $345 $4,000 $4,000 0.00% LOGIS PS ASSESSMENT $0 $42,770 $0 $0 0.00% ELECTRONIC CRIMES TASK FORCE $0 $0 $15,000 $15,000 0.00% 4275 DCC ANNUAL RADIO FEE $8,080 $10,359 $12,380 $12,380 0.00% 4275 DCC ANNUAL FEE $182,092 $201,805 $200,500 $200,320 -0.09% RADIO MAINTENANCE AGREEMENT $1,075 $1,075 $0 $1,800 100.00% TOTAL CONTRACTUAL SERVICES i $472,426 $537,863 $525,920 $564,280 a 7.29% 4i. 4300 OFFICE SUPPLIES $4,252 $4,324 $5,000 $5,000 0.00% 4301 COMPUTER SOFTWARE $1,293 $5,526 $46,894 $25,684 -45.23% 4305 OPERATING SUPPLIES $6,606 $20,052 $3,000 $49,570 1552.33% page 21 4305 POLICE RESERVES $3,351 $3,805 $7,500 $3,000 -60.00% 4306 RECRUITMENT COSTS $55 $9,845 $2,500 $4,000 60.00% 4318 POSTAGE $624 $754 $1,000 $1,000 0.00% 4320 GAS AND OIL $60,004 $47,363 $60,000 $60,000 0.00% 4330 EQUIPMENT REPAIR/GENERAL $15,711 $26,230 $30,000 $25,000 -16.67% 4330 EQUIPMENT REPAIR/COPIER $917 $1,697 $2,000 $0 -100.00% 4330 EQUIPMENT REPAIR/CAR SET UP $12,475 $13,236 $18,000 $17,500 -2.78% 4330 SOFTWARE MAINTENANCE $0 $0 $0 $0 0.00% 4331 MISCELLANEOUS FURNITURE/EQUIP $2,419 $10,966 $17,000 $17,000 0.00% MGM 'TOTAL COMMODITIES $107,705 $143,799 $192,894 $207,754 7.70% 4400 CONFERENCES AND SCHOOLS $38,174 $22,413 $34,000 $39,000 14.71% 4402 BOOKS AND SUBSCRIPTIONS $0 $0 $500 $500 0.00% 4404 MEMBERSHIP DUES $6,190 $9,525 $6,900 $11,019 59.70% 4410 CLOTHING AND EQUIPMENT $19,559 $12,643 $26,890 $25,000 -7.03% 4415 MILEAGE AND AUTO ALLOWANCE $1,500 $1,567 $1,500 $1,500 0.00% 4430 CAR WASHES $3,741 $4,000 $5,000 $5,500 10.00% 4490 SUNDRY EXPENSE $3,503 $3,034 $4,500 $4,500 0.00% 4490 SHREDDING $444 $434 $600 $600 0.00% III TOTAL OTHER CHARGES $73,110 $53,615 $79,890 t $87,619 9.67% 4610 CAPITAL OUTLAY $15,606 $0 $49,000 $0 -100.00% j TOTAL CAPITAL OUTLAY IIIII $15,606 $0 ■ I $49,000 $0 -100.00% TOTAL EXPENDITURES $2,973,890 $2,923,870 $3,337,183 $3,394,910 1.73% CAPITAL OUTLAY ITEMS REQUESTED APPROVED page 22 CAT OBJ DESCRIPTION 2013 2014 2015 2016 ACTUAL ACTUAL BUDGET PRELIMINARY CHANGE FIRE 4110 SALARIES-REGULAR/ADMIN $39,953 $40,764 $69,537 $71,135 2.30% 4110 SALARIES-REGULAR/FIREFIGHTERS $143,697 $159,815 $145,176 $148,079 2.00% 4131 INSURANCE $4,350 $4,176 $5,227 $5,227 0.00% 4132 INSURANCE -LONG TERM DISABILITY $2,983 $2,936 $3,000 $3,000 0.00% 4133 WORKERS COMPENSATION $13,240 $20,706 $23,500 $29,375 25.00% 4134 PERA/ADMIN $2,906 $2,972 $3,511 $3,481 -0.85% 4135 FICA/ADMIN $3,041 $3,057 $5,319 $5,441 2.29% 4135 FICA/FIREFIGHTERS $3,508 $3,933 $2,105 $2,147 2.00% TOTAL HUMAN RESOURCES ,k $213,678 $238,359 $257,375 $267,885 4200 RENTALS AND LEASES $29 $26 $300 $300 0.00% 4210 TELEPHONE $3,613 $4,161 $3,850 $3,850 0.00% 4211 ELECTRICAL SERVICE $9,228 $8,435 $9,300 $9,300 0.00% 4212 GAS SERVICE $5,796 $7,320 $6,500 $7,200 10.77% PROFESSIONAL SERVICES 4220 AUDIT $5,500 $6,300 $5,000 $6,400 28.00% 4220 LEGAL $0 $249 $2,000 $2,000 0.00% 4220 OTHER PROFESSIONAL SERVICES $39 $0 $1,000 $1,000 0.00% 4244 MEDICAL EXAMS $5,071 $5,955 $5,000 $5,000 0.00% 4268 SNOWPLOW FIREFIGHTER DRIVEWAYS $8,478 $7,991 $6,500 $6,500 0.00% 4268 DEPARTMENT REPORT PRINTING $2,743 $2,823 $3,500 $3,500 0.00% 4268 SCBA MASK FIT TESTING $874 $713 $950 $950 0.00% 4268 AERIAL PUMP TESTING $225 $1,238 $1,500 $1,500 0.00% 4268 OTHER CONTRACT SERVICES $0 $0 $3,200 $3,200 0.00% 4275 DCC ANNUAL FEE $9,584 $6,635 $7,000 $7,000 0.00% 4275 DCC RADIO FEE $6,100 $7,839 $6,300 $6,700 6.35% 4280 RUBBISH COLLECTION $724 $561 $800 $800 0.00% TOTAL CONTRACTUAL SERVICES $58,005 $60,245 $62,700 IMIIMMWS 4300 OFFICE SUPPLIES $902 $970 $1,700 $1,700 0.00% 4301 COMPUTER SOFTWARE $1,031 $967 $3,040 $3,040 0.00% 4301 COMPUTER HARDWARE $300 $5,400 $5,400 0.00% 4305 OPERATING SUPPLIES BOOTS/BUNKERPANTS/COATS $16,916 $13,447 $16,000 $16,000 0.00% HOSE/NOZZELS/FITTINGS $7,596 $1,260 $6,000 $6,000 0.00% MISCELLANEOUS OPERATING SUPPLIES $17,179 $13,319 $15,300 $15,300 0.00% 4318 POSTAGE $293 $785 $600 $600 0.00% 4320 GAS AND OIL $6,223 $7,421 $7,500 $7,500 0.00% 4330 EQUIPMENT REPAIR COPIER MAINTENANCE $201 $517 $900 $900 0.00% RADIO REPAIRS AND MAINTENANCE $581 $945 $800 $800 0.00% APPARATUS REPAIRS AND MAINTENANCE $21,066 $26,867 $18,000 $18,000 0.00% SCBA SERVICE $0 $0 $3,500 $3,500 0.00% OTHER REPAIRS AND MAINTENANCE $623 $0 $1,800 $1,800 0.00% 4331 EQUIPMENT $750 $0 4335 BUILDING MAINTENANCE $12,683 $8,820 $16,200 $16,200 0.00% TOTAL COMMODITIES $86,045 $75,617 $96,740 $96,740 0.00% page 23 4400 CONFERENCES AND SCHOOLS $12,796 $9,551 $15,000 $15,000 0.00% 4402 BOOKS AND SUBSCRIPTIONS $1,173 $935 $1,400 $1,400 0.00% 4403 TRAINING EXPENSES TRAINING $4,899 $9,468 $4,000 $4,000 0.00% FIRE PREVENTION $3,595 $2,536 $3,000 $3,000 0.00% 4404 MEMBERSHIP DUES $1,142 $1,355 $1,400 $1,400 0.00% 4415 MILEAGE $207 $0 $500 $500 0.00% 4425 WATER SERVICE $1,776 $1,408 $2,500 $2,500 0.00% 4490 SUNDRY EXPENSE $882 $1,168 $1,000 $1,000 0.00% TOTAL OTHER CHARGES $26,470 $26,421 $28,800 $28,800 ' 0.00% 4630 CAPITAL OUTLAY $15,007 $612,907 $29,000 $0 -100.00% 1 TOTAL CAPITAL OUTLAY I $15,007 $612,907 $29,000 $0 100.00% TOTAL EXPENDITURES $399,204 $1,013,549 $474,615 $458,625 -3.37% CAPITAL OUTLAY ITEMS I REQUESTED APPROVED page 24 CAT OBJ DESCRIPTION 2013 2014 2015 2016 ACTUAL ACTUAL BUDGET PRELIMINARY CHANGE BUILDING OFFICIAL 4110 SALARIES -REGULAR $46,711 -$462 $0 $0 0.00% 4115 SALARIES -OVERTIME $0 $0 $0 $0 0.00% 4131 INSURANCE $16,631 $0 $0 $0 0.00% 4133 INSURANCE -WORKERS COMPENSATIOF $455 $570 $0 $0 0.00% 4134 PERA $3,367 $0 $0 $0 0.00% 4135 FICA $2,897 $0 $0 $0 0.00% TOTAL HUMAN RESOURCES $70,062 $108 $0 $0 0.00% 4209 CITY HALL OCCUPANCY COSTS $11,100 $11,100 $11,100 $11,655 5.00% 4210 TELEPHONE $5,212 $5,053 $4,250 $5,150 21.18% 4220 PROFESSIONAL SERVICES $2,132 $1,563 CITY ATTORNEY $668 $300 $500 $500 0.00% CITY ENGINEER/GOPHER ONE $38,340 $29,636 $35,000 $35,000 0.00% 4221 RETAINER -CITY ENGINEER $7,500 $7,500 $7,500 $7,500 0.00% 4231 CONTRACTED INSPECTIONS $18,745 $70,450 $71,500 $85,800 20.00% TOTAL CONTRACTUAL SERVICES $83,696 $125,602 $129,850 $145,605 12.13% 4300 OFFICE SUPPLIES $1,658 $1,242 $1,000 $1,250 25.00% 4305 OPERATING SUPPLIES $160 $332 $500 $350 -30.00% 4318 POSTAGE $856 $913 $325 $875 169.23% 4320 GAS AND OIL $653 $862 $0 $0 0.00% 4330 VEHICLE MAINTENANCE $286 $159 $0 $0 0.00% TOTAL COMMODITIES $3,613 $3,508 $1,825 [$2,475 35.62% 4400 CONFERENCES AND TRAINING $500 $0 $500 $500 0.00% 4402 BOOKS AND SUBSCRIPTIONS $0 $0 $250 $250 0.00% 4404 MEMBERSHIP DUES $125 $125 $125 $125 0.00% 4415 MILEAGE AND AUTO ALLOWANCES $116 $0 $0 $0 0.00% 4490 SUNDRY EXPENSES $420 $1,509 $500 $500 0.00% TOTAL OTHER CHARGES $1,161 $1,634 $1,375 $1,375 0.00% 4620 CAPITAL OUTLAY $0 $0 $0 $0 0.00% TOTAL CAPITAL OUTLAY $0 1 $0 1 $0 $0 0.00% TOTAL EXPENDITURES $158,532 $130,852 $133,050 $149,455 12.33% CAPITAL OUTLAY ITEMS REQUESTED APPROVED page 25 CAT OBJ DESCRIPTION 2013 2014 2015 2016 ACTUAL ACTUAL BUDGET PRELIMINARY CHANGE STREETS 4110 SALARIES -REGULAR $329,932 $308,189 $328,843 $326,758 -0.63% 4115 SALARIES -OVERTIME $22,898 $25,068 $22,375 $22,375 0.00% 4130 SALARIES -TEMPORARY $0 $0 $5,000 $5,000 0.00% 4131 INSURANCE $79,862 $73,537 $93,044 $93,044 0.00% 4133 WORKERS COMPENSATION $18,290 $25,512 $27,500 $34,375 25.00% 4134 PERA $24,606 $25,420 $27,219 $26,185 -3.80% 4135 FICA $28,063 $27,734 $27,251 $27,091 -0.59% 1111 TOTAL HUMAN RESOURCES $503,651 $485,460 $531,232 $534,828 _0.68% I 4200 RENTALS AND LEASES $5,230 $5,059 $5,500 $5,500 0.00% 4210 TELEPHONE $1,517 $1,674 $1,500 $1,500 0.00% 4211 ELECTRICAL -STREET LIGHTS $20,181 $20,061 $22,000 $22,000 0.00% 4211 ELECTRICAL -PUBLIC WORKS GARAGE $4,217 $4,458 $4,250 $4,250 0.00% 4211 ELECTRICAL -TRAFFIC SIGNALS $3,190 $3,512 $3,250 $3,500 7.69% 4212 GAS SERVICE $5,076 $7,747 $5,500 $7,750 40.91% 4220 PROFESSIONAL SERVICES $1,129 $614 $2,000 $1,200 -40.00% 4220 ENGINEERING FEES $18,146 $14,739 $10,000 $15,000 50.00% 4220 CITY ATTORNEY $451 $0 $600 $600 0.00% 4221 RETAINER -CITY ENGINEER $5,000 $5,000 $5,000 $5,000 0.00% 4224 LABOR NEGOTIATIONS $0 $0 $0 $0 0.00% 4240 LEGAL PUBLICATIONS $0 $69 $0 $0 0.00% 4280 RUBBISH REMOVAL $2,908 $2,902 $3,000 $3,000 0.00% TOTAL CONTRACTUAL SERVICES $67,046 $65,833 $62,600 $69,300 10.70% 4300 OFFICE SUPPLIES $503 $698 $600 $600 0.00% 4305 OPERATING SUPPLIES $12,275 $13,770 $10,000 $12,500 25.00% 4306 RECRUITMENT COSTS $0 $510 $0 $0 0.00% 4318 POSTAGE $30 $409 $50 $50 0.00% 4320 GAS AND OIL $35,300 $30,031 $35,500 $32,500 -8.45% 4330 EQUIPMENT REPAIR $41,621 $65,105 $29,000 $30,000 3.45% 4331 MISC OFFICE/COMPUTER EQUIPMENT $0 $0 $1,000 $1,000 0.00% 4335 PUBLIC WORKS GARAGE MAINTENANCE BUILDING MAINTENANCE $3,882 $2,048 $3,500 $3,000 -14.29% CUSTODIAL SERVICES $1,834 $1,451 $2,000 $1,750 -12.50% 4336 SNOW REMOVAL DAMAGE REPAIR $4,866 $1,614 $5,000 $5,000 0.00% lir TOTAL COMMODITIES $100,313 $115,636 $86,650 $86,400 -0.29% 4400 CONFERENCES AND SCHOOLS $240 $305 $1,200 $1,200 0.00% 4404 MEMBERSHIP DUES $139 $191 $150 $150 0.00% 4410 CLOTHING AND EQUIPMENT $1,882 $2,130 $1,800 $1,800 0.00% 4415 MILEAGE AND AUTO ALLOWANCE $105 $111 $100 $100 0.00% 4420 STREET SIGNS AND POSTS $6,646 $12,832 $7,000 $9,500 35.71% 4421 SAND AND SALT $203,824 $155,311 $120,000 $135,000 12.50% 4422 STREET MAINTENANCE MATERIAL $28,337 $18,806 $25,000 $25,000 0.00% 4423 CRACK SEALING/CHIP SEALING $102,218 $251,383 $100,000 $100,000 0.00% 4424 STREET SWEEPTING AND STRIPING $32,000 $31,110 $32,000 $32,000 0.00% 4425 WATER SERVICE -PUBLIC WORKS $255 $215 $250 $250 0.00% 4426 BONFIRE CLEAN UP $1,295 $1,049 $1,000 $1,000 0.00% 4490 SUNDRY EXPENSE $223 $488 $250 $250 0.00% 4500 TREE REMOVAL $13,973 $14,535 $12,000 $25,000 108.33% page 26 TOTAL OTHER CHARGES 1.1. $391,138 $488,466 $300,750 $331,250 10.14% 4620 CAPITAL OUTLAY $359,790 $51,494 $0 $0 0.00% • TOTAL CAPITAL OUTLAY 0.00% TOTAL EXPENDITURES $1,421,938 $1,206,889 $981,232 $1,021,778 4.13% CAPITAL OUTLAY ITEMS REQUESTED APPROVED page 27 CAT OBJ DESCRIPTION 2013 2014 2015 2016 ACTUAL ACTUAL BUDGET PRELIMINARY CHANGE PARKS 4110 SALARIES -REGULAR $249,015 $249,582 $253,123 $259,958 2.70% 4115 SALARIES -OVERTIME $11,173 $17,877 $10,000 $10,000 0.00% 4130 SALARIES -TEMPORARY $51,903 $57,529 $45,000 $45,000 0.00% 4131 INSURANCE $54,435 $58,205 $72,658 $72,658 0.00% 4133 WORKERS COMPENSATION $7,052 $10,114 $11,000 $13,750 25.00% 4134 PERA $18,664 $18,655 $20,392 $20,247 -0.71% 4135 FICA $25,829 $26,236 $23,572 $24,094 2.21% 4138 UNENPLOYMENT INSURANCE $7,696 $0 $0 $0 0.00% I TOTAL HUMAN RESOURCES $425,766 $438,199 $435,745 $445,707 2.29% 4200 RENTALS AND LEASES $8,633 $8,946 $8,500 $8,500 0.00% 4210 TELEPHONE $3,306 $3,383 $3,500 $3,500 0.00% 4211 ELECTRICAL-PW/WARMING HOUSES $4,217 $3,859 $4,000 $4,000 0.00% 4211 ELECTRICAL-COMF. STAT./AERATOR $5,650 $6,202 $5,000 $5,500 10.00% 4212 GAS SERVICE $6,747 $9,267 $7,000 $8,000 14.29% 4220 PROFESSIONAL SERVICES $285 $4,870 ENGINEERING $8,888 $7,032 $4,000 $7,500 87.50% CITY ATTORNEY $74 $75 $0 $0 0.00% HR TRAINING/TESTING $200 $525 $600 $500 -16.67% 4221 RETAINER -CITY ENGINEER $4,000 $4,000 $4,000 $4,000 0.00% 4268 OTHER CONTRACT SERVICES PARK MAINTENANCE $19,183 $20,731 $18,500 $20,000 8.11% CITY NEWSLETTER $2,459 $2,582 $3,000 $2,500 -16.67% 4280 RUBBISH REMOVAL $2,783 $2,440 $2,750 $2,500 -9.09% TOTAL CONTRACTUAL SERVICES $66,426 $73,913 $60,850 $66,500 9.29% 4300 OFFICE SUPPLIES $1,412 $1,084 $1,500 $1,250 -16.67% 4305 OPERATING SUPPLIES $12,286 $16,405 $12,000 $13,000 8.33% 4306 RECRUITMENT COSTS $220 $0 $0 $0 0.00% 4318 POSTAGE $437 $102 $150 $150 0.00% 4320 GAS AND OIL $20,564 $18,402 $21,000 $19,000 -9.52% 4330 EQUIPMENT REPAIRS AND MAINTENANCE EQUIPMENT REPAIRS/MAINTENANCE $29,845 $26,277 $30,000 $30,000 0.00% RECREATION ROCK $0 $1,249 $2,500 $2,500 0.00% WEED CONTROL $0 $2,609 $0 $0 #DIV/0! CHEMICALS AND FERTILIZER $12,673 $9,345 $14,000 $14,000 0.00% WARMING HOUSE/RINK MAINTENANCE $3,400 $842 $3,500 $3,500 0.00% VANDALISM REPAIR $2,630 $0 $3,000 $3,000 0.00% TREE AND LANDSCAPE PLANTINGS $413 $1,264 $2,000 $2,000 0.00% TREE REMOVAL $0 $6,220 $8,500 $15,000 76.47% TOP DRESS BALL FIELDS; NET/PAD INSTALL $0 $5,450 $7,000 $7,000 0.00% PARKS EQUIPMENT $6,487 $0 $10,000 $5,000 -50.00% PARK PLAY EQUIPMENT/REPAIR $706 $699 $2,000 $1,000 -50.00% PLAYGROUND WOOD CHIPS $4,305 $3,844 $10,000 $4,000 -60.00% PICNIC TABLES $0 $0 $500 $500 0.00% TRAIL SWEEPING $0 $0 $2,000 $2,000 0.00% TRAIL MAINTENANCE $8,211 $0 $10,000 $10,000 0.00% STRIPING PAINT/CHALK $2,960 $4,615 $3,000 $3,500 16.67% SPRINKLER REPAIR $3,645 $1,183 $3,500 $3,500 0.00% TENNIS COURT MAINTENANCE $0 $0 $4,000 $4,000 0.00% NURSERY TREES $638 $0 $1,500 $1,500 0.00% page 28 ERADICATE INVASIVE PLANTS $11,822 $10,000 $13,000 $11,000 -15.38% TOWN CENTRE LANDSCAPE MAINT. $0 $0 $3,000 $2,000 -33.33% PILOT KNOB RESTORATION $845 $0 $5,200 $10,050 93.27% ROGERS LAKE AERATION/MAINT. $0 $0 $1,000 $1,000 0.00% ROGERS LAKE WEED CONTROL $1,518 $1,518 $1,500 $3,500 133.33% SOIL/SAND/SEEDS $0 $3,069 $0 $0 0.00% OTHER REPAIRS AND MAINTENANCE $17,428 $2,267 $10,000 $10,000 0.00% 4331 MISC OFFICE/COMPUTER EQUIP $0 $0 $1,000 $1,000 0.00% 4335 BUILDING MAINTENANCE BUILDING MAINTENANCE $3,914 $2,556 $5,500 $3,000 -45.45% CUSTODIAL SERVICES $1,801 $913 $1,800 $1,800 0.00% 4336 DAMAGE REPAIR $13 $0 $0 $0 0.00% TOTAL COMMODITIES f $148,171 $119,911 $193,650 $188,750 -2.53% 4400 CONFERENCES AND SCHOOLS $3,930 $8,646 $9,450 $9,500 0.53% 4404 MEMBERSHIP DUES $474 $550 $500 $500 0.00% 4410 CLOTHING AND EQUIPMENT $1,110 $1,140 $1,100 $1,100 0.00% 4415 MILEAGE AND AUTO ALLOWANCE $220 $274 $250 $250 0.00% 4422 STREET MAINTENANCE MATERIAL $551 $0 $1,500 $1,500 0.00% 4425 WATER SERVICE PUBLIC WORKS $255 $215 $250 $250 0.00% PARKS $17,443 $14,487 $18,000 $18,000 0.00% 4490 SUNDRY EXPENSE $764 $867 $1,000 $1,000 0.00% 4490 COMMISSIONER PER DIEM $2,075 $1,725 $2,100 $2,100 0.00% 4500 TREE REMOVAL $1,671 $0 $0 $0 0.00% TOTAL OTHER CHARGES $28,493 $27,904 $34,150 $34,200 0.15% 4600 CAPITAL OUTLAY $14,054 $66,053 $37,000 $0 -100.00% TOTAL CAPITAL OUTLAY $14,054 $66,053 $37,000 $0 -100.00% TOTAL EXPENDITURES $682,910 $725,979 $761,395 $735,157 -3.45% CAPITAL OUTLAY ITEMS REQUESTED APPROVED page 29 CAT OBJ DESCRIPTION 2013 2014 2015 2016 ACTUAL ACTUAL BUDGET PRELIMINARY CHANGE RECREATION 4435 CHEER AMERICA/GYMNASTICS $0 $0 $0 $0 0.00% 4435 MHAAT-BALL $0 $1,155 $3,000 $1,200 -60.00% 4435 SOFTBALL LEAGUES $6,842 $7,219 $7,500 $7,000 -6.67% 4435 TENNIS LESSONS $2,216 $2,171 $2,500 $2,500 0.00% 4435 SUMMER CONCERTS $1,275 $1,500 $2,000 $3,000 50.00% 4435 SAFETY CAMP $675 $1,184 $1,500 $1,500 0.00% 4435 TENNIS TEAM $0 $496 $500 $500 0.00% 4435 SENIORS PROGRAMMING $0 $0 $1,000 $1,000 0.00% 4435 SUMMER PLAYHOUSE $1,122 $1,200 $1,500 $2,000 33.33% 4435 PROGRAM SUPPLIES/EQUIPMENT $0 $6 $1,000 $2,000 100.00% 4435 FIELD TRIPS $3,385 $5,702 $3,500 $4,000 14.29% 4435 SUMMER PLAYGROUND PROGRAM $1,273 $2,768 $3,000 $3,000 0.00% 4435 RECREATION OFFICE SUPPLIES $0 $0 $500 $1,000 100.00% 4435 KIDS FISHING DERBY $575 $982 $1,500 $1,500 0.00% 4435 MHAACONTRIBUTION $11,245 $10,000 $10,000 $10,000 0.00% 4435 YOUTH AND STAFF SHIRTS $0 $850 $500 $500 0.00% 4435 SKATEBOARD CAMPS/CLINICS $0 $2,775 $3,000 $3,000 0.00% 4435 BIKE RODEO $0 $150 $200 $200 0.00% PARK CELEBRATION $15,780 $17,107 $2,500 $3,000 20.00% MISCELLANEOUS $25 $0 $0 $0 0.00% 4436 ONLINE REGISTRATION FEES $1,243 $1,294 $1,500 $1,500 0.00% TOTAL RECREATION CHARGES $45,656 $56,559 $46,700 $48,400 3.64% page 30 CAT OBJ DESCRIPTION 2013 2014 2015 2016 ACTUAL ACTUAL BUDGET PRELIMINARY CHANGE PLANNING 4110 SALARIES -REGULAR $26,327 $43,864 $47,090 $50,433 7.10% 4115 SALARIES -OVERTIME $0 $0 $0 $0 0.00% 4130 SALARIES -TEMPORARY $0 $0 $0 $0 0.00% 4131 INSURANCE $3,119 $4,686 $13,939 $13,939 0.00% 4133 WORKERS COMPENSATION $0 $0 $0 $0 0.00% 4134 PERA $1,799 $3,186 $3,649 $3,782 3.64% 4135 FICA $2,145 $3,531 $3,603 $3,858 7.08% TOTAL HUMAN RESOURCES $33,390 $55,268 $68,281 $72,012 5.46% 4220 PROFESSIONAL SERVICES CITY PLANNER $0 $4,755 $7,000 $7,000 0.00% CITY ENGINEERING $3,833 $17,260 $8,500 $8,500 0.00% CITY ATTORNEY $4,347 $14,060 $4,000 $4,000 0.00% AIR NOISE CONSULTANT/RELATED $707 $770 $800 $800 0.00% DC RECORDER FEES $1,012 $506 $1,000 $1,000 0.00% PLANNING COMMISSIONER -MINUTES $864 $988 $1,800 $1,800 0.00% RESOLUTION FILING WITH COUNTY $1,317 $596 $1,600 $1,600 0.00% 4221 RETAINER CITY PLANNER $28,800 $0 $0 $0 0.00% CITY ENGINEER $16,000 $16,000 $16,000 $16,000 0.00% 4222 PROSECUTIONS $0 $0 $3,750 $3,750 0.00% 4240 LEGAL PUBLICATIONS $914 $1,707 $900 $900 0.00% TOTAL CONTRACTUAL SERVICES $57,794 $56,642 $45,350 $45,350 0.00% 4300 OFFICE SUPPLIES $982 $695 $1,200 $1,200 0.00% 4318 POSTAGE $317 $711 $1,000 $1,000 0.00% 4330 EQUIPMENT REPAIR - VEHICLE MNTCE $0 $0 $500 $500 0.00% TOTAL COMMODITIES $1,299 $1,407 $2,700 1 $2,700 0.00% 4400 CONFERENCES AND SCHOOLS $110 $725 $500 $1,000 100.00% 4402 BOOKS AND SUBSCRIPTIONS $0 $42 $100 $100 0.00% 4404 MEMBERSHIP DUES $50 $408 $400 $400 0.00% 4415 MILEAGE AND AUTO ALLOWANCES $159 $122 $300 $300 0.00% 4490 PLANNING COMMISSION PER DIEM $1,475 $1,650 $2,100 $2,100 0.00% 4490 ARC PER DIEM $1,800 $1,750 $2,100 $2,100 0.00% 4490 SUNDRY $243 $128 $400 $400 0.00% TOTAL OTHER CHARGES $3,837 $4,825 $5,900 $6,400 8.47% 4600 CAPITAL OUTLAY $0 $0 $0 $0 0.00% TOTAL CAPITAL OUTLAY 11 1 $0 _ $0 $0 1 $0 0.00% TOTAL EXPENDITURES $96,321 $118,141 $122,231 $126,462 3.46% CAPITAL OUTLAY ITEMS REQUESTED APPROVED page 31 CAT OBJ DESCRIPTION 2013 2014 2015 2016 ACTUAL ACTUAL BUDGET PRELIMINARY CHANGE RECYCLING 4110 SALARIES -REGULAR $13,601 $10,966 $11,772 $12,608 7.10% 4115 SALARIES -OVERTIME $0 $0 $0 $0 0.00% 4130 SALARIES -TEMPORARY $0 $0 $0 $0 0.00% 4131 INSURANCE $2,128 $3,154 $3,485 $3,485 0.00% 4133 WORKERS COMPENSATION $0 $0 $0 $0 0.00% 4134 PERA $895 $797 $912 $946 3.73% 4135 FICA $1,075 $883 $901 $965 7.10% TOTAL HUMAN RESOURCES $17,698 $15,800 $17,070 $18,004 5.47% 4220 COMMUNITY CLEAN UP DAY $6,297 $6,944 $5,000 $7,500 50.00% 4268 CITY NEWSLETTER $344 $482 $700 $700 0.00% TOTAL CONTRACTUAL SERVICES $6,641 $7,426 $5,700 IIIr $8,200 43.86% 4300 OFFICE SUPPLIES $0 $0 $0 $0 0.00% 4318 POSTAGE $0 $0 $1,000 $1,000 0.00% TOTAL COMMODITIES $0 $1,000 $1,000 0.00% 4415 MILEAGE AND AUTO ALLOWANCE $28 $0 $100 $100 0.00% 4490 SUNDRY $660 $31 $500 $500 0.00% TOTAL OTHER CHARGES $600 0.00% 4600 CAPITAL OUTLAY $0 $0 $0 $0 0.00% TOTAL CAPITAL OUTLAY $0 0.00% TOTAL EXPENDITURES $25,028 $23,257 $24,370 $27,804 14.09% CAPITAL OUTLAY ITEMS REQUESTED APPROVED NONE page 32 CAT OBJ DESCRIPTION 2013 2014 2015 2016 ACTUAL ACTUAL BUDGET PRELIMINARY CHANGE ANIMAL CONTROL 4110 SALARIES -REGULAR $0 $0 $0 $0 0.00% 4115 SALARIES -OVERTIME $0 $0 $0 $0 0.00% 4130 SALARIES -TEMPORARY $0 $0 $0 $0 0.00% 4131 INSURANCE $0 $0 $0 $0 0.00% 4133 WORKERS COMPENSATION $0 $0 $0 $0 0.00% 4134 PERA $0 $0 $0 $0 0.00% 4135 FICA $0 $0 $0 $0 0.00% TOTAL HUMAN RESOURCES $0 $0 $0 0.00% 4225 IMPOUNDING FEE $4,928 $4,793 $6,500 $6,500 0.00% TOTAL CONTRACTUAL SERVICES $4,928 $4,793 $6,500 $6,500 0.00% 4300 OFFICE SUPPLIES $0 $0 $500 $500 0.00% Mr TOTAL COMMODITIES $0 $0 $500 ® $500 0.00% 4490 SUNDRY $986 $69 $1,000 $2,000 100.00% TOTAL OTHER CHARGES $986 $69 $2,000 100.00% 4600 CAPITAL OUTLAY $0 $0 $0 $0 0.00% TOTAL CAPITAL OUTLAY $0 1 , $0 TOTAL EXPENDITURES $5,914 $4,862 $8,000 $9,000 12.50% CAPITAL OUTLAY ITEMS REQUESTED APPROVED NONE page 33 ENGINEERING FUND FUND 05 REVENUES REVENUE SOURCE 2013 ACTUAL 2014 ACTUAL 2014 BUDGET 2015 BUDGET 2016 PRELIMINARY % CHANGE CHARGES FOR SERVICES PUBLIC IMPROVEMENT PROJECTS $430,657 $363,708 $520,000 $480,000 $510,000 6.25% MISCELLANEOUS SERVICES $541 $243 $6,000 $6,000 $6,000 0.00% RIGHT OF WAY PERMITS $0 $0 $0 $0 $0 0.00% TOTAL LICENSES AND PERMITS $431,198 $363,951 $526,000 $486,000 $516,000 6.17% INTERFUND TRANSFERS GENERAL FUND RETAINER ADMINISTRATION $13,500 $13,500 $13,500 $13,500 $13,500 0.00% CODE ENFORCEMENT $7,500 $7,500 $7,500 $7,500 $7,500 0.00% ROAD AND BRIDGE $5,000 $5,000 $5,000 $5,000 $5,000 0.00% PARKS $4,000 $4,000 $4,000 $4,000 $4,000 0.00% PLANNING $16,000 $16,000 $16,000 $16,000 $16,000 0.00% GENERAL FUND FEES CODE ENF/FOOTING INSP/GIS $38,340 $29,636 $30,000 $35,000 $35,000 0.00% PLANNING FEES $3,833 $17,260 $8,500 $8,500 $8,500 0.00% OTHER FEES $26,177 $36,755 $14,000 $14,000 $14,000 0.00% IT FEES $0 $0 $2,000 $2,000 $2,000 0.00% UTILITY FUND FEES RETAINER $2,500 $2,500 $2,500 $2,500 $2,500 0.00% SSES $31,335 $53,080 $11,000 $11,000 $11,000 0.00% MISCELLANEOUS $0 $0 $0 $0 $0 0.00% STORM UTILITY RETAINER $1,000 $1,000 $1,000 $1,000 $1,000 0.00% STORM UTILITY FEES $28,045 $20,069 $30,000 $31,500 $35,000 11.11% CITY HALL FUND FEES $0 $0 $5,000 $5,000 $5,000 0.00% WMO FEES $0 $0 $0 $0 $0 0.00% SPECIAL PARK FUND MISC. $0 $0 $2,000 $2,000 $2,000 0.00% INTEREST INCOME $10,000 $10,000 $10,000 $10,000 $10,000 0.00% UNAPPROPRIATED FUND TRANSFEI -$8,200 -$8,200 -$8,200 -$8,200 -$8,200 0.00% TOTAL INTERFUND $179,030 $208,100 $153,800 $160,300 $163,800 2.18% TOTAL ENGINEERING FUND REV. $610,228 $572,050 $679,800 $646,300 $679,800 5.18% page 34 CAT OBJ DESCRIPTION 2013 2014 2015 2016 ACTUAL ACTUAL BUDGET PRELIMINARY CHANGE ENGINEERING 4110 SALARIES -REGULAR $341,175 $354,553 $368,888 $378,614 2.64% 4115 SALARIES -OVERTIME $12,599 $13,025 $10,000 $10,000 0.00% 4130 SALARIES -TEMPORARY $9,810 $6,192 $10,000 $10,000 0.00% 4131 INSURANCE $68,062 $68,562 $80,325 $80,325 0.00% 4133 WORKERS COMPENSATION $1,956 $2,737 $2,950 $3,688 25.02% 4134 PERA $25,320 $25,670 $29,364 $29,146 -0.74% 4135 FICA $27,247 $26,955 $29,750 $30,494 2.50% 4139 OPEB $5,712 $5,835 $0 $0 0.00% TOTAL HUMAN RESOURCES $491,882 $503,531 $531,277 $542,267 2.07% 4200 RENTALS AND LEASES $665 $850 $800 $800 0.00% 4209 CITY HALL OCCUPANCY $46,980 $46,980 $46,980 $49,329 5.00% 4210 TELEPHONE $3,920 $3,976 $4,000 $4,000 0.00% 4220 PROFESSIONAL SERVICES CITY AUDIT $3,025 $3,050 $3,050 $3,050 0.00% ASBUILT SCANNING $0 $0 $1,000 $1,000 0.00% OTHER PROFESSIONAL SERVICES $591 $777 $2,000 $2,000 0.00% 4250 LIABILITY AND AUTO INSURANCE $8,663 $8,737 $11,160 $11,160 0.00% TOTAL CONTRACTUAL SERVICES $63,845 $64,370 $68,990 $71,339 3.40% 4300 OFFICE SUPPLIES $1,728 $1,927 $2,500 $2,500 0.00% 4301 COMPUTER SOFTWARE $3,047 $3,241 $3,000 $3,000 0.00% 4305 OPERATING SUPPLIES $513 $735 $700 $700 0.00% 4318 POSTAGE $33 $21 $300 $300 0.00% 4320 GAS AND OIL $1,642 $1,394 $1,650 $1,650 0.00% 4330 EQUIPMENT REPAIR $297 $321 $1,500 $1,500 0.00% 4331 MISCELLANEOUS OFFICE/COMPUTER EQUIPMENT COMPUTER REPLACEMENT $2,947 $2,104 $3,000 $3,000 0.00% MISCELLANEOUS EQUIPMENT $1,179 $0 $1,250 $1,250 0.00% TOTAL COMMODITIES $11,384 $9,744 $13,900 $13,900 4400 CONFERENCES AND SCHOOLS $3,371 $3,824 $5,000 $5,000 0.00% 4402 BOOKS AND SUBSCRIPTIONS $139 $18 $250 $250 0.00% 4404 MEMBERSHIP DUES $344 $909 $800 $900 12.50% 4410 CLOTHING AND EQUIPMENT $233 $0 $250 $250 0.00% 4415 MILEAGE AND AUTO ALLOWANCE $803 $937 $800 $900 12.50% 4490 SUNDRY EXPENSE $165 $172 $250 $250 0.00% 4491 DEPRECIATION $4,559 $6,552 $4,550 $4,550 0.00% TOTAL OTHER CHARGES $9,614 $12,412 $11,900 $12,100 1.68% 4620 CAPITAL OUTLAY $0 $0 $40,000 $0 -100.00% TOTAL CAPITAL OUTLAY i 1 $0 $0 $40,000 $0 -100.00% TOTAL EXPENDITURES $576,725 $590,056 $666,067 $639,606 -3.97% CAPITAL OUTLAY ITEMS REQUESTED APPROVED page 35 UTILITY FUND FUND 15 REVENUES REVENUE SOURCE 2013 ACTUAL 2014 ACTUAL 2014 BUDGET 2015 BUDGET 2016 PRELIMINARY % CHANGE SEWER RENTAL $1,526,229 $1,594,422 $1,688,531 $1,772,978 $1,861,627 5.00% WATER SURCHARGE TRANSFER $25,000 $0 $25,000 $25,000 $25,000 0.00% SEWER PERMITS $200 $600 $100 $200 $200 0.00% LILYDALE LIFT STATION MAINT. $2,627 $2,500 $3,000 $3,000 $3,000 0.00% MISCELLANSOUS INCOME $11,839 $12,768 $10,000 $10,000 $10,000 0.00% INTERST INCOME $6,182 $10,000 $10,000 $10,000 $10,000 0.00% UNAPPROPRIATED TRANSFER -$11,150 $16,199 -$11,150 -$11,150 -$11,150 0.00% TOTAL UTILITY FUND REVENUE $1,560,927 $1,636,488 $1,725,481 $1,810,028 $1,898,677 4.90% page 36 CAT OBJ DESCRIPTION 2013 2014 2015 2016 ACTUAL ACTUAL BUDGET PRELIMINARY CHANGE UTILITY 4110 SALARIES -REGULAR $120,432 $122,675 $121,012 $125,157 3.43% 4115 SALARIES -OVERTIME $247 $135 $5,000 $5,000 0.00% 4130 SALARIES -TEMPORARY $6,329 $5,418 $5,500 $5,500 0.00% 4131 INSURANCE $21,754 $22,980 $32,931 $32,931 0.00% 4133 WORKERS COMPENSATION $4,504 $5,938 $6,300 $7,875 25.00% 4134 PERA $8,693 $8,408 $9,766 $9,762 -0.04% 4135 FICA $10,646 $10,223 $10,061 $10,378 3.15% 4139 OPEB -$428 $2,285 $0 0.00% TOTAL HUMAN RESOURCES $172,178 $178,062 $190,570 $196,603 3.17% 4200 RENTALS AND LEASES $7,164 $7,305 $7,000 $7,000 0.00% 4209 CITY HALL OCCUPANCY COSTS $0 $0 $6,575 $6,904 5.00% 4210 TELEPHONE $7,088 $6,460 $7,000 $7,000 0.00% 4211 ELECTRIC SERVICE PUBLIC WORKS GARAGE $4,217 $4,159 $4,250 $4,250 0.00% LIFT STATIONS $10,454 $11,955 $10,000 $10,500 5.00% 4212 GAS SERVICE PUBLIC WORKS GARAGE $5,260 $7,746 $5,250 $5,500 4.76% LIFT STATIONS $938 $1,257 $1,000 $1,000 0.00% 4214 SOFTWARE MAINTENANCE $0 $0 $5,000 $5,000 0.00% 4220 PROFESSIONAL SERVICES $6,725 $146 CITY ENGINEER $19,810 $19,950 $11,000 $11,000 0.00% CITY AUDIT $2,555 $2,600 $2,600 $2,600 0.00% IT MANAGER $0 $0 $1,500 $1,500 0.00% TRAINING $250 $350 $350 $350 0.00% 4221 RETAINER -CITY ENGINEER $2,500 $2,500 $2,500 $2,500 0.00% 4250 LIABILITY AND AUTO INSURANCE $6,587 $6,561 $7,000 $7,000 0.00% 4268 CITY NEWSLETTER $492 $689 $500 $550 10.00% 4280 RUBBISH REMOVAL $2,707 $2,662 $2,500 $2,500 0.00% TOTAL CONTRACTUAL SERVICES $76,747 $74,338 $74,025 $75,154 1.53% 4300 OFFICE SUPPLIES $2,096 $1,798 $2,000 $2,000 0.00% 4305 OPERATING SUPPLIES $6,014 $9,077 $4,000 $5,000 25.00% 4305 VOICEMAIL/PHONE UPGRADE $0 $0 $0 $0 -100.00% 4318 POSTAGE $4,822 $4,379 $4,500 $4,500 0.00% 4320 GAS AND OIL $5,096 $4,553 $5,000 $5,000 0.00% 4330 EQUIPMENT REPAIRS AND MAINTENANCE SEWER CLEANING/TELEVISING $32,670 $35,517 $62,000 $62,000 0.00% SEWER LINING $0 $0 $110,000 $110,000 0.00% ROOT CHEMICALS $3,808 $2,148 $4,000 $4,000 0.00% HYDRANT MARKERS $0 $639 $600 $600 0.00% SOFTWARE SUPPORT $806 $795 $2,000 $2,000 0.00% LIFT STATIONS MAINTENANCE $13,770 $17,344 $10,000 $10,000 0.00% MISCELLANEOUS EQUIPMENT REPAIRS $42,080 $21,072 $30,000 $30,000 0.00% 4331 FURNITURE/EQUIPMENT $0 $0 $1,200 $1,200 100.00% 4335 PUBLIC WORKS GARAGE MAINTENANCE BUILDING MAINTENANCE $3,910 $1,671 $3,750 $3,750 0.00% CUSTODIAL SERVICES $1,801 $1,491 $2,000 $2,000 0.00% TOTAL COMMODITIES 1 $116,873 $100,483 $241,050 1 $242,050 0.41% page 37 4400 CONFERENCES AND SCHOOLS $638 $1,412 $1,500 $2,500 66.67% 4404 MEMBERSHIP DUES $89 $91 $100 $100 0.00% 4410 CLOTHING AND EQUIPMENT $370 $380 $350 $350 0.00% 4415 MILEAGE AND AUTO ALLOWANCE $110 $326 $150 $250 66.67% 4425 WATER SERVICE $255 $215 $250 $250 0.00% 4437 CREDIT CARD FEES $727 $231 $750 $750 0.00% 4449 MWCC CHARGES $991,207 $1,034,517 $1,161,541 $1,225,458 5.50% 4490 SUNDRY EXPENSE $3,835 $6,965 $3,750 $3,750 0.00% 4491 DEPRECIATION $147,867 $161,272 $145,500 $145,500 0.00% 4492 BAD DEBT EXPENSE $13,248 $0 $0 $0 0.00% TOTAL OTHER CHARGES $1,158,345 $1,205,410 $1,313,891 $1,378,908 4.95% 4600 CAPITAL OUTLAY $0 $0 $50,000 $0 100.00% TOTAL CAPITAL OUTLAY $0 V $0 $50,000 $0 100.00% TOTAL EXPENDITURES $1,524,143 $1,558,293 $1,869,536 $1,892,715 1.24% CAPITAL OUTLAY ITEMS REQUESTED APPROVED page 38 STORM WATER UTILITY FUND 29 REVENUES REVENUE SOURCE 2013 ACTUAL 2014 ACTUAL 2014 BUDGET 2015 BUDGET 2016 PRELIMINARY % CHANGE STORM WATER UTILITY FEES $400,812 $402,911 $398,631 $398,631 $398,631 0.00% MISCELLANSOUS INCOME $550 $250,048 $0 $0 $0 0.00% INTEREST INCOME -$2,527 $5,142 $1,500 $1,500 $1,500 0.00% UNAPPROPRIATED TRANSFER -$9,650 -$196,109 -$9,650 -$9,650 -$9,650 0.00% TOTAL STORM UTILITY FUND REVEL $389,185 $461,992 $390,481 $390,481 $390,481 0.00% page 39 CAT OBJ DESCRIPTION 2013 2014 2015 2016 ACTUAL ACTUAL BUDGET PRELIMINARY CHANGE STORM WATER 4110 SALARIES -REGULAR $18,433 $18,823 $19,106 $19,797 3.62% 4115 SALARIES -OVERTIME $0 $0 $0 $0 0.00% 4130 SALARIES -TEMPORARY $0 $0 $0 $0 0.00% 4131 INSURANCE $3,444 $3,005 $5,401 $5,401 0.00% 4133 WORKERS COMPENSATION $0 $0 $0 $0 0.00% 4134 PERA $1,337 $1,366 $1,481 $1,485 0.27% 4135 FICA $1,367 $1,388 $1,462 $1,514 3.56% 4139 OPEB -$115 $113 HUMAN RESOURCES $24,465 - $24,695 $27,450 $28,197 2.72% H....TOTAL 4209 CITY HALL COSTS $6,575 $6,575 $6,575 $6,904 5.00% 4214 SOFTWARE MAINTENANCE $0 $0 $200 $200 0.00% 4220 PROFESSIONAL SERVICES CITY AUDIT $960 $975 $975 $975 0.00% WMO MEETINGS $0 $0 $6,000 $6,000 0.00% NPDES ENGINEERING FEES $31,335 $49,036 $31,500 $35,000 11.11% RAIN GARDEN DESIGN/CONSTRUCTION $0 $0 $3,500 $3,500 0.00% SURFACE WATER TREATMENT $0 $0 $5,000 $5,000 0.00% OTHER PROFESSIONAL SERVICES $15,009 $4,720 $2,000 $2,000 0.00% 4221 RETAINER -CITY ENGINEER $1,000 $1,000 $1,000 $1,000 0.00% 4240 LEGAL PUBLICATIONS $43 $105 $250 $250 0.00% TOTAL CONTRACTUAL SERVICES $54,922 $62,411 $57,000 $60,829 6.72% 4300 OFFICE SUPPLIES $0 $0 $250 $250 100.00% 4318 POSTAGE $1 $1 $25 $25 0.00% 4330 EQUIPMENT REPAIR $2,918 $5,350 $3,000 $3,000 0.00% 4337 STORM SEWER MAINTENANCE $24,700 $46,347 $45,000 $45,000 0.00% 4339 POND MAINTENANCE $4,030 $0 $80,000 $80,000 0.00% TOTAL COMMODITIES $31,649 $51,698 $128,275 $128,275 0.00% 4404 MEMBERSHIP DUES $13,519 $18,833 $13,500 $14,000 3.70% 4490 SUNDRY EXPENSE $474 $13 $475 $475 0.00% 4491 DEPRECIATION $31,833 $35,637 $32,000 $32,000 0.00% 1 TOTAL OTHER CHARGES $45,825 $54,482 $45,975 4600 CAPITAL OUTLAY $0 $0 $225,000 $0 -100.00% TOTAL CAPITAL OUTLAY $225,000 $0 -100.00% TOTAL EXPENDITURES $156,861 $193,286 $483,700 $263,776 -45.47% CAPITAL OUTLAY ITEMS REQUESTED APPROVED page 40 PAR 3 REVENUES REVENUE SOURCE 2013 ACTUAL 2014 ACTUAL 2014 BUDGET 2015 BUDGET 2016 PRELIMINARY % CHANGE GREEN FEES $93,202 $83,624 $105,000 $105,000 $110,000 4.76% RECREATION PROGRAMS $30,920 $37,328 $35,000 $35,000 $38,000 8.57% CONCESSIONS $19,773 $17,252 $21,000 $21,000 $22,000 4.76% SUNDRY REVENUE $12,581 $13,123 $100 $0 $0 0.00% INTEREST -$327 $614 $250 $250 $250 0.00% TOTAL PAR THREE FUND REVENUE $156,148 $151,941 $161,350 $161,250 $170,250 5.58% page 41 CAT OBJ DESCRIPTION 2013 2014 2015 2016 ACTUAL ACTUAL BUDGET PRELIMINARY CHANGE PAR 3 4110 SALARIES -ADMIN $22,253 $24,500 $25,043 $25,869 3.30% 4115 SALARIES -OVERTIME (HOLIDAY) $617 $15 $0 $0 0.00% 4110 SALARIES -CLUBHOUSE $26,574 $24,085 $30,000 $30,000 0.00% 4110 SALARIES - MAINTENANCE $0 $13,398 $18,000 $18,000 100.00% 4131 INSURANCE $5,225 $5,876 $7,144 $7,144 0.00% 4133 WORKERS COMPENSATION $974 $1,228 $1,250 $1,563 25.04% 4134 PERA $2,666 $2,977 $4,266 $4,190 -1.78% 4135 FICA $4,805 $4,338 $5,588 $5,651 1.13% 4138 UNEMPLOYMENT $3,390 $0 $0 $0 0.00% 4139 OPEB $1,037 $689 $0 $0 0.00% TOTAL HUMAN RESOURCES $67,541 $77,107 $91,291 $92,417 1.23% 4200 RENTALS AND LEASES $1,424 $2,583 $2,500 $2,600 4.00% 4210 TELEPHONE $1,606 $2,875 $2,000 $2,400 20.00% 4211 ELECTRIC SERVICE CLUBHOUSE $1,107 $707 $1,200 $900 -25.00% MAINTENANCE $3,745 $4,545 $4,000 $4,000 0.00% 4212 GAS SERVICE $639 $890 $700 $1,000 42.86% 4220 PROFESSIONAL SERVICES $25 $216 CITY AUDIT $2,390 $2,425 $2,500 $2,500 0.00% CITY ATTORNEY $102 $0 $0 $0 0.00% CONSULTANT FEE $0 $0 $0 $0 0.00% LIQUOR LICENSE FEES/COMPLIANCE $275 $332 $300 $350 16.67% 4250 LIABILITY AND AUTO INSURANCE $3,249 $3,263 $3,300 $3,500 6.06% 4268 CONTRACT SERVICES GROUNDS MAINTENANCE MGMT $6,000 $5,972 $6,000 $6,000 0.00% GROUNDS MAINTENANCE WAGES $13,355 $0 $0 $0 0.00% CITY NEWSLETTER $295 $413 $400 $400 0.00% 4280 RUBBISH REMOVAL $742 $560 $800 $900 12.50% TOTAL CONTRACTUAL SERVICES $34,953 $24,781 $23,700 $24,550 3.59% 4300 OFFICE SUPPLIES $241 $561 $500 $500 0.00% 4305 GOLF SUPPLIES $1,208 $772 $500 $500 0.00% 4306 RECRUITMENT COSTS $120 $0 $0 $0 0.00% 4310 CONCESSIONS FOOD $1,920 $2,936 $2,000 $2,500 25.00% POP $953 $1,110 $1,500 $1,000 -33.33% BEER $832 $636 $1,000 $1,000 0.00% 4320 GAS AND OIL $2,145 $1,735 $2,500 $2,500 0.00% 4330 REPAIRS AND MAINTENANCE GROUNDSKEEPING EQUIPMENT REPAIR $6,085 $1,275 $7,000 $5,000 -28.57% 4334 COURSE MAINTENANCE $451 $5,222 CHEMICALS AND FERTILIZER $5,004 $3,052 $5,000 $5,000 0.00% IRRIGATION SYSTEM REPAIR $1,254 $1,049 $1,000 $1,000 0.00% COURSE BEAUTIFICATION $64 $147 $1,000 $3,000 200.00% SOIL/SAND $406 $863 $500 $500 0.00% 4335 BUILDING MAINTENANCE $1,841 $5,222 $2,000 $2,000 0.00% TOTAL COMMODITIES $22,523 $24,579 $24,500 $24,500 0.00% page 42 4400 CONFERENCES AND SCHOOLS $49 $250 $100 $100 100.00% 4404 MEMBERSHIP DUES $165 $160 $300 $300 0.00% 4410 CLOTHING AND EQUIPMENT $0 $0 $200 $200 0.00% 4415 MILEAGE AND AUTO ALLOWANCE $125 $7 $200 $200 0.00% 4425 WATER SERVICE $450 $295 $500 $500 0.00% 4427 SEWER SERVICE $1,117 $1,137 $1,200 $1,200 0.00% 4436 ONLINE REGISTRATION FEE $689 $910 $700 $1,000 42.86% 4437 CREDIT CARD FEES $1,842 $1,813 $2,000 $2,000 0.00% 4490 SUNDRY EXPENSE $1,672 $2,067 $2,000 $2,000 0.00% 4480 CONTINGENCY $15,957 $14,770 $0 $0 0.00% 4491 DEPRECIATION $12,736 $10,081 $13,000 $11,000 -15.38% 4500 TREE REMOVAL $0 $0 $0 $0 0.00% TOTAL OTHER CHARGES $34,802 $31,488 $20,200 $18,500 -8.42% i 4620 CAPITAL OUTLAY $0 $0 I $0 I $10,000 0.00% TOTAL CAPITAL OUTLAY ( $0 1 $0 $10,000 J 0.00% TOTAL EXPENDITURES $159,820 $157,955 $159,691 $169,967 6.43% CAPITAL OUTLAY ITEMS REQUESTED APPROVED PURCHASE 4 USED GOLF CARTS $10,000 page 43 CITY OF MENDOTA HEIGHTS 2016 BUDGET 2016 REVENUE PROJECTIONS CITY HALL FUND NO. 8 FUND BALANCE 12/31/2015 $30,000 RENT $215,775 INTEREST $300 $246,075 page 44 CAT OBJ DESCRIPTION 2013 2014 2015 2016 ACTUAL ACTUAL BUDGET PRELIMINARY CHANGE CITY HALL 4110 SALARIES -REGULAR $57,541 $62,450 $58,434 $59,603 2.00% 4115 SALARIES -OVERTIME $0 $0 $0 $0 0.00% 4130 SALARIES -TEMPORARY $0 $0 $0 $0 0.00% 4131 INSURANCE $9,291 $9,350 $17,424 $17,424 0.00% 4133 WORKERS COMPENSATION $1,342 $2,716 $3,300 $4,125 25.00% 4134 PERA $3,997 $4,176 $4,529 $4,470 -1.30% 4135 FICA $4,795 $4,956 $4,470 $4,559 1.99% 4138 UNEMPLOYMENT $0 $0 $0 $0 0.00% 4139 OPEB $644 $793 $0 $0 0.00% TOTAL HUMAN RESOURCES $77,610 $84,442 $88,157 $90,181 2.30% 4210 TELEPHONE $0 $0 $0 $0 0.00% 4211 ELECTRIC SERVICE $24,659 $23,533 $24,500 $24,500 0.00% 4212 GAS SERVICE $8,668 $11,096 $10,000 $10,000 0.00% 4220 PROFESSIONAL SERVICES CITY ENGINEER $3,511 $9,755 $5,000 $5,000 0.00% OTHER PROFESSIONAL SERVICES $75 $0 $0 $0 0.00% 4250 LIABILITY AND AUTO INSURANCE $5,631 $5,684 $6,000 $6,000 0.00% 4280 RUBBISH SERVICE $2,141 $2,172 $2,000 $2,200 10.00% TOTAL CONTRACTUAL SERVICES $44,685 $52,239 $47,500 $47,700 0.42% 4305 COMPUTER $0 $0 $1,200 $1,200 100.00% 4335 BUILDING MAINTENANCE $32,860 $49,246 $45,000 $45,000 0.00% TOTAL COMMODITIES $32,860 $49,246 $46,200 O I 0.00% 4404 MEMBERSHIP DUES $50 $0 $50 $50 100.00% 4415 MILEAGE $392 $147 $400 $400 0.00% 4425 WATER SERVICE $3,647 $2,783 $4,000 $4,000 0.00% 4480 CONTINGENCY/RESERVE $0 $0 $10,000 $10,000 0.00% 4490 SUNDRY EXPENSES $156 $0 $250 $250 0.00% 4491 DEPRECIATION $58,772 $57,306 $60,000 $60,000 0.00% TOTAL OTHER CHARGES $63,017 $60,236 $74,700 $74,700 0.00% 4600 CAPITAL OUTLAY $0 $0 1 $67,000 $0 -100.00% TOTAL CAPITAL OUTLAY $0 $0 $67,000 $0 -100.00% TOTAL EXPENDITURES $218,172 $246,163 $323,557 $258,781 -20.02% CAPITAL OUTLAY ITEMS REQUESTED APPROVED page 45 CITY OF MENDOTA HEIGHTS 2016 BUDGET DEBT SUMMARY IMPROVEMENT BONDS 2015 LEVY 2016 LEVY END DATE 2006 $6,500 $3,400 2/1/2017 2007 $80,400 $0 2/1/2027 2008 $170,572 $173,517 2/1/2028 2009 $27,300 $26,999 2/1/2020 2010 $41,242 $42,007 2/1/2030 2011 $200,329 $205,946 2/1/2031 2012 $91,067 $91,568 2/1/2032 2013 $119,619 $122,453 2/1/2034 2014 Refunding $0 $83,254 2/1/2027 2014 $0 $79,365 2/1/1935 TOTAL $737,029 $828,509 EQUIPMENT CERTIFICATES 2015 LEVY 2016 LEVY END DATE FIRE TRUCK $55,066 $53,765 2/1/2020 PAR THREE BONDS 2015 LEVY 2016 LEVY END DATE PAR THREE $267,887 $265,367 2/1/2023 GRAND TOTAL $1,059,982 $1,147,641 page 46 CAT OBJ DESCRIPTION 2013 2014 2015 2016 ACTUAL ACTUAL BUDGET PRELIMINARY CHANGE STREETLIGHT MAINETANCE 4110 SALARIES -REGULAR $0 $0 $0 $0 0.00% 4115 SALARIES -OVERTIME $0 $0 $0 $0 0.00% 4130 SALARIES -TEMPORARY $0 $0 $0 $0 0.00% 4131 INSURANCE $0 $0 $0 $0 0.00% 4133 WORKERS COMPENSATION $0 $0 $0 $0 0.00% 4134 PERA $0 $0 $0 $0 0.00% 4135 FICA $0 $0 $0 $0 0.00% 4138 UNEMPLOYMENT $0 $0 $0 $0 0.00% TOTAL HUMAN RESOURCES $0 $0 0.00% 4211 ELECTRICAL SERVICES $14,955 $11,369 $17,500 $17,500 0.00% 4220 PROFESSIONAL SERVICES $0 $0 $500 $500 0.00% TOTAL CONTRACTUAL SERVICES $14,955 $11,369 $18,000 $18,000 0.00% 4330 REPAIRS AND MAINTENANCE $9,587 $13,197 $15,000 $15,000 0.00% TOTAL COMMODITIES $9,587 $13,197 $15,000 $15,000 0.00% 4490 SUNDRY EXPENSES $0 $0 $0 $0 0.00% TOTAL OTHER CHARGES $0 $0 $0 $0 0.00% 4620 CAPITAL OUTLAYi $0 $0 $0 $0 0.00% TOTAL CAPITAL OUTLAY $0 $0 $0 $0 0.00% TOTAL EXPENDITURES $24,542 $24,566 $33,000 $33,000 0.00% CAPITAL OUTLAY ITEMS REQUESTED APPROVED NONE page 47 MENDOTA HEIGHTS HR CALCULATIONS 2016 BUDGET CITY COUNCIL EMPLOYEE ANN DATE GRADE STEP 2015 SAL 2016 W1 2016 W2 2016 W3 2016 TOTAL PERA FICA MED INSURANCE TOTAL SANDRA KREBSBACH 1/1 $5,700 $5,700 $0 $0 $5,700 $0 $353 $83 $0 $6,136 ULTAN DUGAN 1/1 $4,200 $4,200 $0 $0 $4,200 $0 $260 $61 $0 $4,521 MIKE POVOLNY 1/1 $4,200 $4,200 $0 $0 $4,200 $0 $260 $61 $0 $4,521 LIZ PETSCHEL 1/1 $4,200 $4,200 $0 $0 $4,200 $0 $260 $61 $0 $4,521 STEVE NORTON 1/1 $4,200 $4,200 $0 $0 $4,200 $0 $260 $61 $0 $4,521 TOTALS $22,500 $0 $1,395 $326 $0 $24,221 CITY COUNCIL SAL -REG $22,500 PERA $0 FICA $1,395 MEDICARE $326 INSURANCE $0 TOTAL $24,221 page 48 MENDOTA HEIGHTS HR CALCULATIONS 2016 BUDGET ADMINISTRATION EMPLOYEE ANN DATE GRADE STEP 2015 SAL 2016 W1 2016 W2 2016 W3 2016 TOTAL PERA FICA MED INSURANCE TOTAL MARK MCNEILL $115,453 $20,000 $102,083 $0 $122,083 $9,156 $7,569 $1,770 $17,424 $158,003 LORRI SMITH 0.75 6/11/2012 24 D $47,931 $68,446 $0 $0 $51,335 $3,850 $3,183 $744 $13,068 $72,180 HRISTO GALIOV 0.8 9/21/2011 14 D/E $44,042 $56,154 $0 $0 $44,923 $3,369 $2,785 $651 $13,939 $65,668 TAMMY SCHUTTA 7/21/2011 34 C $74,133 $83,392 $0 $0 $83,392 $6,254 $5,170 $1,209 $17,424 $113,450 KRISTEN SCHABACKER 0.77 8/31/1998 39 E $76,657 $106,689 $0 $0 $82,151 $6,161 $5,093 $1,191 $13,416 $108,013 PAM DEEB 3/20/2006 10 E $50,774 $51,789 $0 $0 $51,789 $3,884 $3,211 $751 $17,424 $77,059 SHARON HINZE 0.25 4/24/2006 12 E $13,133 $53,582 $0 $0 $13,396 $1,005 $831 $194 $4,356 $19,781 NANCY BAUER 0.1 4/27/1987 14 E $5,505 $56,154 $0 $0 $5,615 $421 $348 $81 $1,742 $8,209 WORKERS COMP NA NA NA $5,500 $6,875 $0 $0 $6,875 $0 $0 $0 $0 $6,875 TOTALS $454,683 $34,101 $28,190 $6,593 $98,794 $629,237 ADMINISTRATION SAL -REG $454,683 INS CONT $1,452 PERA $34,101 FICA $28,190 MEDICARE $6,593 INSURANCE $98,794 WORK COME $6,875 TOTAL $629,237 page 49 MENDOTA HEIGHTS HR CALCULATIONS 2016 BUDGET ELECTIONS EMPLOYEE ANN DATE GRADE STEP 2015 SAL 2016 W1 2016 W2 2016 W3 2016 TOTAL PERA FICA MED INSURANCE TOTAL LORRI SMITH (.25) 6/11/2012 24 D $15,977 $68,446 $0 $0 $17,112 $1,283 $1,061 $248 $4,356 $24,060 NANCY BAUER (0.10) 4/27/1987 14 E $5,505 $56,154 $0 $0 $5,615 $421 $348 $81 $1,742 $8,209 ELECTION JUDGES NA NA NA $0 $16,500 $0 $0 $16,500 $0 $0 $0 $0 $16,500 STAFF OVERTIME NA NA NA $0 $2,000 $0 $0 $2,000 $150 $124 $29 $0 $2,303 TOTALS $41,227 $1,855 $1,533 $359 $6,098 $51,071 ELECTIONS SAL -REG $22,727 INS CONT $1,452 SAL -OT $2,000 SAL -TEMP $16,500 PERA $1,855 FICA $1,533 MEDICARE $359 INSURANCE $6,098 TOTAL $51,071 page 50 MENDOTA HEIGHTS HR CALCULATIONS 2016 BUDGET IT EMPLOYEE ANN DATE GRADE STEP 2015 SAL 2016 W1 2016 W2 2016 W3 2016 TOTAL PERA FICA MED INSURANCE TOTAL SUE DONOVAN 0.45 33 D/E $36,513 $56,983 $29,916 $0 $39,105 $2,933 $2,425 $567 $7,841 $52,870 TOTALS $39,105 $2,933 $2,425 $567 $7,841 $52,870 IT SAL -REG $39,105 INS CONT $1,452 PERA $2,933 FICA $2,425 MEDICARE $567 INSURANCE $7,841 TOTAL $52,870 page 51 MENDOTA HEIGHTS HR CALCULATIONS 2016 BUDGET POLICE DEPARTMENT EMPLOYEE ANN DATE GRADE STEP 2015 SAL 2016 W1 2016 W2 2016 W3 2016 TOTAL PERA FICA MED INSURANCE TOTAL MIKE ASCHENBRENER x 5/12/2003 41 E $112,638 $114,891 $0 $0 $114,891 $18,612 $0 $1,666 $17,424 $152,593 PEYTON FLEMING (SGT) x 7/1/2007 $87,212 $83,400 $10,008 $0 $93,408 $15,132 $0 $1,354 $17,424 $127,319 E-12 TANNER SPICER (SGT) x $43,606 $83,400 $7,506 $0 $90,906 $14,727 $0 $1,318 $17,424 $124,375 E-9 ROBERT LAMBERT (SGT) x 6/25/1996 $96,163 $36,405 $45,175 $9,790 $91,369 $14,802 $0 $1,325 $17,424 $124,920 E-12 ERIC PETERSON (SGT) x 1/18/2000 $96,163 $87,576 $10,509 $0 $98,085 $15,890 $0 $1,422 $17,424 $132,821 E-12 INVESTIGATOR x INV 36 $86,851 $0 $0 $4,020 $4,020 $651 $0 $58 $0 $4,730 L-12 CHAD WILSON x 1/19/2000 INV 36 $86,851 $75,432 $9,052 $4,020 $88,504 $14,338 $0 $1,283 $17,424 $121,549 E-12 KIM HENNING x 12/19/2005 12 E $52,531 $53,582 $0 $0 $53,582 $4,019 $3,322 $777 $17,424 $79,124 LISA BRANDT (0.5 FTE) x 3/7/2014 12 C/D $24,325 $34,105 $17,861 $0 $25,983 $1,949 $1,611 $377 $8,712 $38,631 TRISTA MILLER (0.5 FTE) x 1/16/2013 12 D $25,078 $53,582 $0 $0 $26,791 $2,009 $1,661 $388 $8,712 $39,562 SUE DONOVAN (.50) $40,570 $56,983 $29,916 $0 $43,450 $3,259 $2,694 $630 $8,712 $58,744 NICHOLAS GORGOS x POL 36 $82,831 $8,237 $61,814 $6,305 $76,355 $12,369 $0 $1,107 $17,424 $107,255 E-9 JENNIFER LARRIVE x 12/19/2001 POL 36 $82,547 $75,432 $6,789 $1,935 $84,156 $13,633 $0 $1,220 $17,424 $116,433 E-9 JEFF VON FELDT x 1/23/2001 POL 36 $79,133 $75,432 $5,280 $0 $80,712 $13,075 $0 $1,170 $17,424 $112,382 L-7 ROBIN NELSON x POL 36 $82,831 $46,674 $20,605 $6,055 $73,333 $11,880 $0 $1,063 $17,424 $103,700 E-9 PHILLIP MCCARTY x POL 36 $80,612 $24,710 $41,775 $2,089 $68,573 $11,109 $0 $994 $17,424 $98,100 page 52 E-5 TODD ROSSE x 1/20/2000 POL 36 $79,133 $75,432 $5,280 $0 $80,712 $13,075 $0 $1,170 $17,424 $112,382 L-7 STEVE HILYAR x POL 36 $79,133 $21,964 $44,718 $2,236 $68,918 $11,165 $0 $999 $17,424 $98,506 E-5 STEVE MEYER x 6/13/2005 POL 36 $82,831 $75,432 $9,052 $0 $84,484 $13,686 $0 $1,225 $17,424 $116,819 E-12 DENISE URMANN x 7/23/2005 POL 36 $80,612 $75,432 $6,789 $0 $82,221 $13,320 $0 $1,192 $17,424 $114,157 E-9 MICHAEL SHEPARD x 9/21/2006 POL 36 $77,654 $75,432 $3,772 $0 $79,204 $12,831 $0 $1,148 $17,424 $110,607 E-5 JOHN LARRIVE x 7/8/1996 POL 36 $80,612 $75,432 $6,789 $0 $82,221 $13,320 $0 $1,192 $17,424 $114,157 L-9 PATROL (1/2 YEAR) $28,230 $0 $0 $0 $0 $0 $0 $0 $0 $0 STAFF ADJUSTMENTS -$94,111 $0 $0 $0 $0 $34,848 $34,848 L-9 TEMPORARY SUPPORT NA NA NA $10,400 $10,400 $0 $0 $10,400 $0 $645 $151 $0 $11,196 OVERTIME NA NA NA $42,500 $40,000 $0 $0 $42,500 $6,885 $0 $616 $0 $50,001 DTF OVERTIME NA NA NA $18,500 $15,990 $0 $0 $18,500 $2,997 $0 $268 $0 $21,765 MAAG OVERTIME NA NA NA $7,500 $7,500 $0 $0 $7,500 $1,215 $0 $109 $0 $8,824 SOT OVERTIME NA NA NA $4,000 $4,000 $0 $0 $4,000 $648 $0 $58 $0 $4,706 OFF DUTY OVERTIME NA NA NA $18,000 $18,000 $0 $0 $18,000 $2,916 $0 $261 $0 $21,177 WORKERS COMPENSATION NA NA NA $68,000 $85,000 $0 $0 $85,000 $0 $0 $0 $0 $85,000 DC TRAFFIC SAFETY NA NA NA $5,000 $5,000 $0 $0 $5,000 $810 $0 $73 $0 $5,883 HOLIDAY PAY X NA NA NA $63,264 $65,541 $0 $0 $65,541 $10,618 $0 $950 $0 $77,109 COMP TIME PAYOUTS X NA NA NA $5,000 $5,000 $0 $0 $5,000 $810 $0 $73 $0 $5,883 page 53 TOTALS $1,853,318 $271,750 $9,933 $25,641 $374,616 $2,535,257 ALL DEPARTMENT $36,449 SAL -REG $1,667,418 INS CONT $1,452 SAL -OTHER $10,400 PERA $271,750 FICA $9,933 $2,535,257 MEDICARE $25,641 OT $90,500 INSURANCE $374,616 WORK COME $85,000 TOTAL $2,535,257 VERIFY $2,535,257 ADMINISTRATION SAL -REG $730,989 SAL -OTHER PERA $105,387 FICA $9,288 MEDICARE $10,599 OT INSURANCE $148,104 WORK COME $85,000 TOTAL $1,089,367 PATROL SAL -REG $936,429 SAL -OTHER $10,400 PERA $166,363 FICA $645 MEDICARE $15,041 OT $90,500 INSURANCE $226,512 WORK COMP TOTAL $1,445,890 page 54 MENDOTA HEIGHTS HR CALCULATIONS 2016 BUDGET FIRE EMPLOYEE ANN DATE GRADE STEP 2015 SAL 2016 W1 2016 W2 2016 W3 2016 TOTAL PERA FICA MED INSURANCE TOTAL JOHN MACZKO NA $17,325 $17,672 $0 $0 $17,672 $1,325 $1,096 $256 $0 $20,349 DAVE DREELAN NA $10,155 $10,358 $0 $0 $10,358 $777 $642 $150 $0 $11,927 NANCY BAUER 0.25 4/27/1987 14 E $13,763 $56,154 $0 $0 $14,039 $1,053 $870 $204 $4,356 $20,521 SUE DONOVAN 0.05 $4,057 $56,983 $29,916 $0 $4,345 $326 $269 $63 $871 $5,874 JIM LEE $24,237 $24,722 $0 $0 $24,722 $0 $1,533 $358 $0 $26,613 CAPTAINS (4) NA $6,528 $6,659 $0 $0 $6,659 $0 $0 $97 $0 $6,755 LIETENANTS (2) NA $1,433 $1,462 $0 $0 $1,462 $0 $0 $21 $0 $1,483 TRAINING OFFICER NA $3,585 $3,657 $0 $0 $3,657 $0 $0 $53 $0 $3,710 TRAINING ASSISTANT NA $1,433 $1,462 $0 $0 $1,462 $0 $0 $21 $0 $1,483 FIRE CALLS NA $59,439 $60,628 $0 $0 $60,628 $0 $0 $879 $0 $61,507 TRAINING/SPECIALS NA $47,298 $48,244 $0 $0 $48,244 $0 $0 $700 $0 $48,943 CLEAN UP NA $9,592 $9,784 $0 $0 $9,784 $0 $0 $142 $0 $9,926 MEETINGS NA $7,168 $7,311 $0 $0 $7,311 $0 $0 $106 $0 $7,417 FIRE PREVENTION NA $8,699 $8,873 $0 $0 $8,873 $0 $0 $129 $0 $9,002 WORKERS COMP NA $23,500 $29,375 $0 $0 $29,375 $0 $0 $0 $0 $29,375 DISABILITY/LIFE NA $3,000 $3,000 $0 $0 $3,000 $0 $0 $0 $0 $3,000 TOTALS $251,588 $3,481 $4,410 $3,179 $5,227 $267,885 page 55 FIRE DEPARTMENT SAL -REG $219,213 INS CONT $1,452 PERA $3,481 FICA $4,410 MEDICARE $3,179 VERIFY $267,885 INSURANCE $5,227 DIS/LIFE $3,000 WORK COM' $29,375 TOTAL $267,885 ADMIN SAL -REG $71,135 PERA $3,481 FICA $4,410 MEDICARE $1,031 INSURANCE $5,227 DIS/LIFE $3,000 WORK COMF $29,375 $117,660 STAFF SAL -REG $148,079 PERA $0 FICA $0 MEDICARE $2,147 INSURANCE $0 DIS/LIFE $0 WORK COMF $0 $150,226 $267,885 page 56 MENDOTA HEIGHTS HR CALCULATIONS 2016 BUDGET CODE ENFORCEMENT EMPLOYEE ANN DATE GRADE STEP 2015 SAL 2016 W1 2016 W2 2016 W3 2016 TOTAL PERA FICA MED INSURANCE TOTAL 5/1/1979 25 E $0 $0 $0 $0 $0 $0 $0 $0 WORKERS COMP NA NA NA $500 $500 $0 $0 $0 $0 $0 $0 $0 TOTALS $0 $0 $0 $0 $0 $0 CITY COUNCIL SAL -REG $0 INS CONT PERA $0 FICA $0 MEDICARE $0 INSURANCE $0 WORK COMI $0 TOTAL $0 page 57 MENDOTA HEIGHTS HR CALCULATIONS 2016 BUDGET STREETS EMPLOYEE ANN DATE GRADE STEP 2015 SAL 2016 W1 2016 W2 2016 W3 2016 TOTAL PERA FICA MED INSURANCE TOTAL TERRY BLUM 0.34 6/16/1976 34 D/E $28,608 $36,484 $53,631 $0 $30,639 $2,298 $1,900 $444 $5,924 $41,205 GEORGE NOACK 6/16/1976 LEAD $61,007 $62,227 $0 $0 $62,227 $4,667 $3,858 $902 $17,424 $89,078 NICK COURTEAU 6/18/2008 MECH $61,007 $62,227 $0 $0 $62,227 $4,667 $3,858 $902 $17,424 $89,078 RYAN CROULEY 8/6/2008 MAIN III $58,407 $39,586 $9,929 $0 $49,515 $3,714 $3,070 $718 $17,424 $74,441 JOHN AMBROSE 12/8/1997 MAIN III $58,407 $59,575 $0 $0 $59,575 $4,468 $3,694 $864 $17,424 $86,025 TIM OSTER 11/8/1995 MAIN III $58,407 $59,575 $0 $0 $59,575 $4,468 $3,694 $864 $17,424 $86,025 VARIABLE RATE $3,000 $3,000 $0 $0 $3,000 $225 $186 $44 $0 $3,455 OVERTIME $22,375 $22,375 $0 $0 $22,375 $1,678 $1,387 $324 $0 $25,765 SEASONAL STAFF $5,000 $5,000 $0 $0 $5,000 $0 $310 $73 $0 $5,383 WORKERS COMP NA NA NA $27,500 $34,375 $0 $0 $34,375 $0 $0 $0 $0 $34,375 TOTALS $354,133 $26,185 $21,956 $5,135 $93,044 $534,828 ADMINISTRATION SAL -REG $326,758 INS CONT $1,452 SAL -TEMP $5,000 OVERTIME $22,375 PERA $26,185 FICA $21,956 MEDICARE $5,135 INSURANCE $93,044 WORK CON $34,375 TOTAL $534,828 page 58 MENDOTA HEIGHTS HR CALCULATIONS 2016 BUDGET PARKS EMPLOYEE ANN DATE GRADE STEP 2015 SAL 2016 W1 2016 W2 2016 W3 2016 TOTAL PERA FICA MED INSURANCE TOTAL TERRY BLUM 0.33 6/16/1976 34 D/E $27,767 $36,484 $53,631 $0 $29,738 $2,230 $1,844 $431 $5,750 $39,993 JOHN BOLAND 6/16/1976 LEAD $61,007 $62,227 $0 $0 $62,227 $4,667 $3,858 $902 $17,424 $89,078 MIKE MACZKO 9/12/1983 MAIN III $58,407 $59,575 $0 $0 $59,575 $4,468 $3,694 $864 $17,424 $86,025 CLIFF KIRCHNER MAIN III $58,407 $59,575 $0 $0 $59,575 $4,468 $3,694 $864 $17,424 $86,025 SLOAN WALLGREN 0.84 $47,535 $58,147 $0 $0 $48,843 $3,663 $3,028 $708 $14,636 $70,879 OVERTIME $10,000 $10,000 $0 $0 $10,000 $750 $620 $145 $0 $11,515 SEASONAL STAFF (MNT) $15,000 $15,000 $0 $0 $15,000 $0 $930 $218 $0 $16,148 SEASONAL STAFF (PRK) $30,000 $30,000 $0 $0 $30,000 $0 $1,860 $435 $0 $32,295 WORKERS COMP NA NA NA $11,000 $13,750 $0 $0 $13,750 $0 $0 $0 $0 $13,750 TOTALS $314,958 $20,247 $19,527 $4,567 $72,658 $445,708 ADMINISTRATION SAL -REG $259,958 INS CONT $1,452 SAL -SEAS $45,000 SAL -OT $10,000 PERA $20,247 FICA $19,527 MEDICARE $4,567 INSURANCE $72,658 WORK COM $13,750 TOTAL $445,708 page 59 MENDOTA HEIGHTS HR CALCULATIONS 2016 BUDGET PLANNING EMPLOYEE ANN DATE GRADE STEP 2015 SAL 2016 W1 2016 W2 2016 W3 2016 TOTAL PERA FICA MED INSURANCE TOTAL NOLAN WALL (80%) 8/26/2013 20 D/E $47,090 $41,339 $21,703 $0 $50,433 $3,782 $3,127 $731 $13,939 $72,013 TOTALS $50,433 $3,782 $3,127 $731 $13,939 $72,013 CITY COUNCIL SAL -REG $50,433 INS CONT $1,452 PERA $3,782 FICA $3,127 MEDICARE $731 INSURANCE $13,939 TOTAL $72,013 page 60 MENDOTA HEIGHTS HR CALCULATIONS 2016 BUDGET RECYCLING EMPLOYEE ANN DATE GRADE STEP 2015 SAL 2016 W1 2016 W2 2016 W3 2016 TOTAL PERA FICA MED INSURANCE TOTAL NOLAN WALL (20%) 8/26/2013 20 D/E $11,772 $41,339 $21,703 $0 $12,608 $946 $782 $183 $3,485 $18,003 TOTALS $12,608 $946 $782 $183 $3,485 $18,003 CITY COUNCIL SAL -REG $12,608 INS CONT $1,452 PERA $946 FICA $782 MEDICARE $183 INSURANCE $3,485 TOTAL $18,003 page 61 MENDOTA HEIGHTS HR CALCULATIONS 2016 BUDGET ENGINEERING EMPLOYEE ANN DATE GRADE STEP 2015 SAL 2016 W1 2016 W2 2016 W3 2016 TOTAL PERA FICA MED INSURANCE TOTAL JOHN MAZZITELLO 8/18/2008 41 E $104,597 $106,689 $0 $0 $106,689 $8,002 $6,615 $1,547 $17,424 $140,276 RYAN RUZEK 8/9/2004 35 E $91,839 $93,676 $0 $0 $93,676 $7,026 $5,808 $1,358 $17,424 $125,292 ALMIN RAMIC $63,983 $24,474 $42,828 $0 $67,302 $5,048 $4,173 $976 $17,424 $94,922 BOBBY CRANE 8/3/2009 25 E $72,217 $73,661 $0 $0 $73,661 $5,525 $4,567 $1,068 $17,424 $102,245 NANCY BAUER 0.55 4/24/1987 14 E $30,279 $56,154 $0 $0 $30,885 $2,316 $1,915 $448 $9,583 $45,147 KRISTEN SCHABACKER 0.06 8/31/1998 39 E $5,973 $106,689 $0 $0 $6,401 $480 $397 $93 $1,045 $8,417 OVERTIME $10,000 $10,000 $0 $0 $10,000 $750 $620 $145 $0 $11,515 INTERN $10,000 $10,000 $0 $0 $10,000 $0 $620 $145 $0 $10,765 WORKERS COMP NA NA NA $2,950 $3,688 $0 $0 $3,688 $0 $0 $0 $0 $3,688 TOTALS $398,614 $29,146 $24,714 $5,780 $80,325 $542,266 ADMINISTRATION SAL -REG $378,614 INS CONT $1,452 SAL -SEAS $10,000 SAL -OT $10,000 PERA $29,146 FICA $24,714 MEDICARE $5,780 INSURANCE $80,325 WORK CON $3,688 TOTAL $542,266 page 62 MENDOTA HEIGHTS HR CALCULATIONS 2016 BUDGET UTILITY EMPLOYEE ANN DATE GRADE STEP 2015 SAL 2016 W1 2016 W2 2016 W3 2016 TOTAL PERA FICA MED INSURANCE TOTAL TERRY BLUM 0.33 6/16/1976 34 D/E $27,767 $36,484 $53,631 $0 $29,738 $2,230 $1,844 $431 $5,750 $39,993 RICHARD BURROWS 11/13/1995 LEAD $61,007 $62,227 $0 $0 $62,227 $4,667 $3,858 $902 $17,424 $89,078 SHARON HINZE 0.5 4/24/2006 12 E $26,266 $53,582 $0 $0 $26,791 $2,009 $1,661 $388 $8,712 $39,562 KRISTEN SCHABACKER 0.06 8/31/1998 39 E $5,973 $106,689 $0 $0 $6,401 $480 $397 $93 $1,045 $8,417 OVERTIME NA NA NA $5,000 $5,000 $0 $0 $5,000 $375 $310 $73 $0 $5,758 SEASONAL NA NA NA $5,500 $5,500 $0 $0 $5,500 $0 $341 $80 $0 $5,921 WORKERS COMP NA NA NA $6,300 $7,875 $0 $0 $7,875 $0 $0 $0 $0 $7,875 TOTALS $135,657 $9,762 $8,411 $1,967 $32,931 $196,603 ADMINISTRATION SAL -REG $125,157 INS CONT $1,452 SAL -SEAS $5,500 SAL -OT $5,000 PERA $9,762 FICA $8,411 MEDICARE $1,967 INSURANCE $32,931 WORK COME $7,875 TOTAL $196,603 page 63 MENDOTA HEIGHTS HR CALCULATIONS 2016 BUDGET STORM UTILITY EMPLOYEE ANN DATE GRADE STEP 2015 SAL 2016 W1 2016 W2 2016 W3 2016 TOTAL PERA FICA MED INSURANCE TOTAL SHARON HINZE 0.25 4/24/2006 12 E $13,133 $53,582 $0 $0 $13,396 $1,005 $831 $194 $4,356 $19,781 KRISTEN SCHABACKER 0.06 8/31/1998 39 E $5,973 $106,689 $0 $0 $6,401 $480 $397 $93 $1,045 $8,417 TOTALS $19,797 $1,485 $1,227 $287 $5,401 $28,198 ADMINISTRATION SAL -REG $19,797 INS CONT $1,452 SAL -SEAS $0 SAL -OT $0 PERA $1,485 FICA $1,227 MEDICARE $287 INSURANCE $5,401 WORK COME $0 TOTAL $28,198 page 64 MENDOTA HEIGHTS HR CALCULATIONS 2016 BUDGET PAR 3 EMPLOYEE ANN DATE GRADE STEP 2015 SAL 2016 W1 2016 W2 2016 W3 2016 TOTAL PERA FICA MED INSURANCE TOTAL SLOAN WALLGREN 0.16 E $9,054 $58,147 $0 $0 $9,304 $698 $577 $135 $2,788 $13,501 HRISTO GALIOV 0.20 9/21/2011 14 E $11,011 $56,154 $0 $0 $11,231 $842 $696 $163 $3,485 $16,417 KRISTEN SCHABACKER 0.05 8/31/1998 39 E $4,978 $106,689 $0 $0 $5,334 $400 $331 $77 $871 $7,014 CLUBHOUSE NA NA NA $30,000 $30,000 $0 $0 $30,000 $2,250 $1,860 $435 $0 $34,545 MAINTENANCE $18,000 $18,000 $0 $0 $18,000 $0 $1,116 $261 $0 $19,377 UNEMPLOYMENT NA NA NA $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 WORKERS COMP NA NA NA $1,250 $1,563 $0 $0 $1,563 $0 $0 $0 $0 $1,563 TOTALS $55,869 $4,190 $4,580 $1,071 $7,144 $92,417 ADMINISTRATION SAL -REG $25,869 INS CONT $1,452 SAL -SEAS $30,000 SAL - MAINT $18,000 SAL -OT $0 PERA $4,190 FICA $4,580 MEDICARE $1,071 INSURANCE $7,144 WORK COME $1,563 UNEMPLOY $0 TOTAL $92,417 page 65 MENDOTA HEIGHTS HR CALCULATIONS 2016 BUDGET CITY HALL EMPLOYEE ANN DATE GRADE STEP 2015 SAL 2016 W1 2016 W2 2016 W3 2016 TOTAL PERA FICA MED INSURANCE TOTAL TERRY SULLIVAN 6/20/2011 16 E $58,434 $59,603 $0 $0 $59,603 $4,470 $3,695 $864 $17,424 $86,057 WORKERS COMP NA NA NA $3,300 $4,125 0 0 $4,125 $0 $0 $0 $0 $4,125 TOTALS $63,728 $4,470 $3,695 $864 $17,424 $90,182 ADMINISTRATION SAL -REG $59,603 INS CONT $1,452 SAL -SEAS $0 SAL -OT $0 PERA $4,470 FICA $3,695 MEDICARE $864 INSURANCE $17,424 WORK COME $4,125 TOTAL $90,182 FY 2016 Improvement Packages Administration 1. Job Evaluation System Redesign and Compensation Study Update page 66 General Fund Requested Recommended $15,000 $ -0- 2. Color Copier Lease 5342 5342 3. Pilot Knob Area Restoration 2075 -0- 4. Laserfiche Scanning PT position 9360 -0- 5. City Hall Smoke Detectors/Security Improvements 20,000 20,000 6. City Hall Cellular Telephone Amplifier 16670 6000 Planning 7. Begin Comprehensive Planning Process 8. Code Amendment study for non-residential uses in R -zone Information Technology 9. Laserfiche Technical Service Support & Training 5000 5000 5000 -0- 7000 2000 10. Additional PT IT Staff position 38,651 Note: Assumes FT Status of Current Employee to PT 11. New City Hall Telephone System 40,000 Note: $25,000 recommended to come from Cable Fund 15,000 -0- page 67 12. Server Room Dry Fire Suppression 17,000 -0- Note: Critical; recommended for 2015 expenditure 13. Fire Technology Needs Assessment 35,000 15,000 Police 14. Additional Captain Position 164,800 -0- 15. Firearms replacement 23,000 23,000 16. Personal Protective Equipment 15,139 -0- Note: Fund through Civil Defense Fund in FY16 17. Purchase of Reserve Squad 12185 12185 18. Taser Replacement 20900 16,500 19. Replacement of Investigator Vehicle 38,500 -0- 20. Replacement AEDs 10500 -0- Fire 21. Portable Pump 7000 -0- 22. Aerial Truck Repairs 10000 10000 Public Works 23. 2.5 Ton Dump Truck/Snow Plow 200,000 -0- 24. Turf Truckster 23000 23000 25. Quick Connect 15000 15000 1 page 68 Package Number City of Mendota Heights Budget improvement Package Date: July 2, 2015 Prepared By: Tamara Schutta Department: Administration Description: Job Evaluation System Redesign and Update Compensation Plan. Rationale: The State of Minnesota Local Government Pay Equity Act requires cities to maintain a classification and compensation plan in order to maintain pay equity compliance. The city is using Control Data job evaluation system. Job classifications are assigned points based on "Benchmark Job Values" under this system. However, this job evaluation system was retired in the late 1980's and the city never replaced it with another job evaluation system. We have a responsibility to keep our job evaluation system updated to account for new employee classes and for any changes in factors affecting the comparable work value of existing classes. The city recently completed its pay equity report for 2014 and initial results indicate that we are in compliance. However, to be in compliance, the Finance Director position was reclassified from Grade 39 to Grade 41. The city's next pay equity report will be due January 31, 2018. Costs: To complete a job classification and compensation study it will cost approximately $15,000 to hire a consultant. $15,000 is requested for FY 16. Budget Impact: This would be funded through the General Fund, through property taxes. Impact of Funding/Not Funding This proposal: Not funding this decision package will reduce the likelihood of the City successfully being in compliance for Pay Equity. Desired Date of Implementation: January 2016, in time to complete the job evaluation and identify salary adjustments for FY 17. City Administrator Recommendation: The Pay Equity report will next need to be submitted in 2018, as part of a three-year cycle. Fund this study for FY17 City of Mendota Heights Budget Improvement Package 2 page 69 Date: July 2, 2015 Prepared By: Tamara Schutta Department: City Hall (City Council, Administration, Public Works/Engineer, Planning, Parks) Description: Lease Color Copier for City Hall. Rationale: The City of Mendota Heights currently owns the copier located within the Administration Department. This copier is over six years old and calls for maintenance are increasing. The maintenance and supplies for the copier is approximately $3,100.00 annually. Per the City's Purchasing Policy, it's been determined that we can lease a copier through the State of Minnesota Contract. Some of the benefits of leasing through the State of Minnesota Contract allows for upgrade/downgrade of equipment without penalty, maintenance is included in the lease, and hard drive security and cleansing. Leasing a copier also allows for us to keep up with emerging technology. Currently in order to make color copies, staff utilizes the Police Department's color copier. This isn't efficient for staff. Costs (Personnel, Supplies, and Capital): The annual amount for a 5 -year lease of a Ricoh Aficio MPC6502 copier is $544 a month. The maintenance costs are $135 for 15,000 black and white copies. Color copies are billed at $.067 as used. The annual amount for a 5 -year lease plus maintenance costs of a Ricoh Aficio MPC6502 copier is $8,400. We currently pay $3,058 for copier maintenance. An additional $5,342 is requested for FY 16 to lease a new copier. Budget Impact: This would be funded through the General Fund, through property taxes. Impact of FundinglNot Funding This proposal: The current copier is over six years old and calls for maintenance are increasing. Leasing a color copier allows for us to keep up with emerging technology, and send color copies electronically. Desired Date of Implementation: January 1, 2016. City Administrator Recommendation: Fund in 2016. There is much lost time in having police personnel make copies for the rest of the building. And the lease reduces the up -front cost of acquisition. Date: July 2, 2015 Department: Parks page 70 3 Package Number City of Mendota Heights Budget Improvement Package Prepared By: Tamara Schutta Description: Pilot. Knob Restoration Rationale: The City of Mendota Heights in partnership with Great River Greening implemented the Pilot Knob Hill Phase 11 Natural Resource Management Plan in November 2007. A summary of estimated costs by year were included through 2017. The restoration costs for 2016 are $10,050. Great River Greening is requesting an additional $2,075 for 2016 to cover the following items: • $675 — 8 hours and 5 round trips to monitor and close-out Hwy 55 roadside project • $900 — conduct 3 small group pollinator habitat restoration events: plugging forbs, seeding, and nesting habitat (cost share with Trust Fund). Pollinator habitat restoration events will be dovetailed with pollinator survey events (nlc for pollinator surveys, all Trust Fund). • $500 — Time and Materials NTE. Longer term solution for trail rutting and erosion; work with Public Works. Erosion control. Costs (Personnel, Supplies, and Capital): $2,075 is requested for FY 16. Budget Impact: This would be funded through the General Fund, through property taxes. Impact of Funding/Not Funding This proposal: Desired Date of Implementation: January 2016 City Administrator Recommendation: Do not fund. While worthy, the $10,050 which GRG is slated to receive from the City in the FY2016 budget is nearly double what the group received in 2015. page 71 4 Package Number City of Mendota Heights Budget Improvement Package Date: July 2, 2015 Prepared By: Lorri Smith Department: Administration Description: To provide for new, additional funding for a temporary part-time staff person to provide scanning services for our Laserfiche system. Rationale: The City has purchased Laserfiche software to maintain and preserve the records of the City. The records storage room is well over capacity and there is no more room for additional storage of paper records. The departments have slowly started to input their records into Laserfiche for retention purposes, but doing so is slow due to interruptions for their daily jobs. We need to start scanning more of the older records into the system to provide a more accurate records retention system and to reduce the number of paper records in the basement storage room areas. Costs: Estimates for one temporary part-time scanning technician at $12.00 per hour for 15 hours per week, total $9,360 for FY 16. No benefits would be paid to this position. The City of Mendota Heights pays benefits for part-time employees starting at 20 hours per week. Budget Impact: This would be funded through the General Fund, through property taxes. Impact of Funding/Not Funding This proposal: Not funding this decision package will slow down the progress of scanning the city documents into the Laserfiche system. page 72 By funding this proposal, we will make better use of our Laserfiche system and will increase staff efficiency. Staff will be able to quickly search through and retrieve more documents through Laserfiche. Public document requests will more easily be filled when staff can access the documents online. Desired Date of Implementation: January 1, 2016, in time to hire a part time staff person for the new year. City Administrator Recommendation: Do not fund. Investigate inputting into Laserfiche with existing staff. Date: 8/10/15 Department: Administration Description: Improvements to Building security and provide for smoke detectors Rationale: Council has previously discussed the need for security improvements, both specifically in the City Council Chambers and throughout City Hall. in addition, there are no smoke detectors throughout the building, meaning that by the time that the sprinklers go off, the fire is in an advanced state. Costs: $20,000 is requested for 2016 Budget Impact: General levy increase Impact of Funding/Not Funding This proposal: The first priority of this package would be to fund the installation of hard -wired smoke detectors (home -style battery models will not work— they must access a remote alarm). With only the sprinkler system as the indicator of a major fire, many irreplaceable city records would become waterlogged and destroyed. Also important are building security needs, including shielding, remote door locking, and a monitor camera in the entry area. Desired Date of Implementation: Budget for 2016; install as soon as possible thereafter. City Administrator Recommendation: Recommend $10,000 in 2016 to get started. page 73 Package Number City of Mendota Heights Budget Improvement Package Prepared By: Mark McNeill 6 page 74 Package Number City of Mendota Heights Budget improvement Package Date: 07-06-2015 Prepared By: Aschenbrener Department: Police Description: Cellular Coverage Enhancement Rationale: In late 2014 we finished a 1 year study of cellular coverage for the police department's technology. A decision was made to move to a single carrier, Verizon. One of the drawbacks is city hall has no cell signal in the lower level, and very weak coverage in the upper level of the building. It is essential to have cellular service as a back up to the land lines in the event of a problem. Multiple off the shelf products were tested without success. Costs: Capital: To'provide coverage for the building both voice and data open to both employees and the public the cost is $16,670. Budget Impact: This would be funded through General Fund property taxes. The estimated life expectancy would be ten years. Impact of Funding/Not Funding This proposal: Not funding this project will mean the inability of anyone to use cell phones in the lower level of city hall. Funding it would also improve the coverage of cell phones in the building's upper level. Desired Date of Implementation: 2016. City Administrator Recommendation: Budget $6000 for 2016, based on more current information. Date: July 6, 2015 Department: Planning Description (Provide a brief description of what is being requested): Budget expenditure to begin the comprehensive planning process. Rationale (Why is this necessary?): The comprehensive plan, including the critical area plan, has to be updated by the end of 2018. The process typically takes at least 12-18 months; staff would like to begin the process in late 2016. Costs (Personnel, Supplies, and Capital): Based on a total estimated project cost of $50,000, the following cost breakdown per budget year is proposed: FY 2016: $5,000 7 page 75 Package Number City of Mendota Heights Budget Improvement Package Prepared By: Nolan Wall FY 2017: 530,000 FY 2018: $15,000 Budget Impact: The $5,000 request would be funded through the General Fund, through property taxes. Impact of Funding/Not Funding This proposal: The City has historically hired a planning consultant to update the comprehensive plan at least once every 10 years. The planning process is elaborate and time-consuming, and would be difficult for staff to complete in addition to the normal workload. Staff would coordinate development of the plan and facilitation of the process, which may reduce the total cost. It is intended that staff completes the bulk of the work required to update the critical area plan. Desired Date of Implementation: page 76 Expenditures would be completed towards the end of 2016, after a formal proposal is approved by the Council for the project. City Administrator Recommendation: This is the first of a three-year process, which will provide a product when due to the Metropolitan Council in 2018. More expensive in later two years. Recommend funding in 2016 Date: page 77 8 Package Number City of Mendota Heights Budget Improvement Package July 6, 2105 Prepared By: Nolan Wall Department: Planning Description: Conduct a code amendment process concerning non-residential uses in residential areas Rationale: In the city there are numerous non-residential uses within residential zoning districts. As a result, the City has had to approve numerous variances for reasonable requests for these uses. By amending the code to better accommodate these uses, variances could be avoided and the review process forcertain improvements could be streamed Tined. Areas of the Code to address include signage, accessory structures, fences, etc. Costs: $5000 for consulting planner work Budget Impact: General fund Impact of Funding/Not Funding This proposal: If funded, staff would contract the bulk of this work to the planning consultant. If it is not funded, clue to the press of other business, this project would likely not be able to be accomplished in a timely manner by in-house staff. Desired Date of Implementation: Early 2106 City Administrator Recommendation: Do not fund. Try to find ways to do with planning staff. page 78 9 Package Number City of Mendota Heights Budget Improvement Package Date: 6/15/2015 Prepared By: Sue Donovan Department: Information Technology Description (Provide a brief description of what is being requested): Professional services support for Laserfiche and training of end users Rationale (Why is this necessary?): Laserfiche is being underutilized due to lack of end user training and support. Laserfiche features and functionality if used appropriately would allow us to automate routine processes and allow employee resources to be utilized elsewhere saving time and money. Examples of routine processes that could be automated are: • Agenda Management • Accounts Payable • Human Resources • Case Management • Permitting Laserfiche Quickfields will be need to upgraded at some point. Costs (Personnel, Supplies, and Capital): $7000 (40 hours @ $175 per hour) Budget Impact: This would be funded through the General Fund, through property taxes. Impact of Funding/Not Funding This proposal: Without additional training, this is a currently underutilized as only a document archive. Desired Date of Implementation: City Administrator Recommendation: Fund $2000 in 2016, and investigate alternative training options Date: 10 page 79 Package Number City of Mendota Heights Budget Improvement Package 6/22/2015 Prepared By: Sue Donovan Department: Information Technology Description: Additional IT Staff (IT Help Desk) Rationale: I am currently supporting 100+ hardware devices (including 10 servers, 70 workstations, 16 printers, etc.), as well as 50+ applications several of which are highly complex and require detailed knowledge to run and keep up-to-date. Some of these applications include: • Windows Active Directory (network authentication) • Microsoft Exchange Server (email) • Symantec Backup Exec (backup) • Airwatch Mobile Device Management (cellphones) • Laserfiche / SQL Server (document management) • Digital Ally (Squad Video) • Axis Camera Station (building Video) I am also providing end-user support for 56 regular employees, as well as 41 paid on-call, volunteer and legal staff that use our email system (this does not include council members or commission members). Most users have a basic to intermediate level of computer knowledge. Expectations are that IT provides all end-user application support. Costs: Please note the following two options (open to other suggestions): Option 1: Additional part-time IT Help Desk Specialist (20 hours per week, 4 hours per day). Salary = $23.67 - $29.59 hourly. With benefits estimated cost for 2016 = $38,651. *Based on $1,452 per mo. Benefits, 7.5% PERA, 7.65% FICA Option 2: Part-time Police Department IT Manager (20 hours per week). Salary = $40.66 per hour. With benefits estimated cost for 2016 = $57,404.79. Additional full-time City IT Help Desk Specialist. With benefits estimated cost for 2016 = $77,302. *1T Manager's estimated salary for 2016 = $114,809.58 page 80 *50% of IT Manager's salary is currently included in Police Department budget Budget Impact: This would be funded through the General Fund, through property taxes. Impact of Funding/Not Funding This proposal: • The city's network security, stability and BCA compliancy is at risk due to the lackof time needed to maintain the infrastructure (i.e. servers and workstations, backup storage, mobile devices, etc). • Employee inefficiency due to lack of time and cost for training and/or end-user support. • Inability to implement new technologies such as web development, Laserfiche workflow functionality, mobile device apps, etc. Desired Date of Implementation: City Administrator Recommendation: Current IT Manager has indicated a willingness to go to .8 time, if it means that additional staffing could be hired. Staff is exploring other Part-time IT staff options, including partnering with neighboring cities. Reduction of existing IT staffer, and adding $15,000 in new funding would provide $38,000 for alternative staffing. Recommend adding $15,000 in 2016 General Fund Date: 11 page 81 Package Number City of Mendota Heights Budget Improvement Package 6/24/2015 Prepared By: Sue Donovan Department: Information Technology & Administration Description (Provide a brief description of what is being requested): Per 2016 CIP - migration to IP telephone system Rationale: Outdated technology Costs: $25,000. This is to replace desk -top units; most of the other existing infrastructure is adaptable to the newer technology Budget Impact: This would be funded through the General Fund, through property taxes. Impact of Funding/Not Funding This proposal: Lost productivity; reduced security, and lessened ability of public to access staff members Desired Date of implementation: Second half of 2016 City Administrator Recommendation: This would replace the 1998 -era phone system, which is lacking. Fund from Cable Fund; could be done in 2015 if time permits. Date: page 82 City of Mendota Heights Budget Improvement Package 6/15/2015 Prepared By: Sue Donovan Package Number Department: Information Technology Description: Replacement of wet sprinkler head with dry system. Rationale: The room was never properly equipped for the purpose it is serving. Costs: Approximately $17,000. Budget Impact: This would be funded through the General Fund, through property taxes. Impact of Funding/Not Funding This proposal: If sprinkler should go off in server room, all equipment will be destroyed and the cost of replacement would be in excess of $200,000, not to mention the $19,000 per day loss in employee productivity Desired Date of Implementation: ASAP City Administrator Recommendation: Critical to be done immediately. Fund through 2015 budget. 13 page 83 Package Number City of Mendota Heights Budget Improvement Package Date: 6/30/2015 Prepared By: Sue Donovan Department: information Technology Description (Provide a brief description of what is being requested): Fire Department —Technology Needs Assessment Rationale (Why is this necessary?): With upcoming change in management structure it is an opportunity to assess emergency management processes and prepare a technology plan that utilizes current technology to provide efficient and readily available services to the city. Out -dated -technology is currently ineffective, costly and labor intensive. Additional IT resources needed to complete this assessment. The current issues include, but are not limited to: • Network switch replacement • Minimal video surveillance • Limited wireless network - unknown service provider, who's paying for it? • Unlicensed outdated software (FileMaker Pro) • Lack of training on fire -specific applications, basic computer skills and security policies • Desktop computers — Dave Dreelan and Dale Stein laptops are beyond warranty date. • Mobile computers. Current fire mobiles are well beyond their warranty date. It has also been determined that the fire mobiles are ineffective due to lack of use by fire personnel. Costs to maintain these mobiles are as follows: (1) $35.00 each per month for Verizon wireless Aircard and (20 IT resources to maintain operating system and software updates page 84 Costs (Personnel, Supplies, and Capital): ® 10 hours of professional services @ approximately $.99 per hour) **Anticipated cost upgrades to software and hardware = 535,000 - 550,000 Budget Impact: This would be funded through the General Fund, through property taxes. Impact of Funding/Not Funding This proposal: • Ineffective emergency management equipment m Inability to maximize use of personnel during an emergency Unnecessary Costs • Consequences for unlicensed software Desired Date of Implementation: January 1, 2016 City Administrator Recommendation: Fund $15,000 for the replacement of two "Toughbook" computers, and partial funding to begin addressing needs City of Mendota Heights Budget Improvement Package Date: 07-06-2015 Department: Police Description: Additional Position Captain page 85 Prepared By: Aschenbrener Rationale: Previous discussions with Council have relayed in detail the need to add supervisory personnel into the administrative structure of the police department. The process was started and agreed to in 2014 with the 2015 additional sergeant position. Step one put supervisors in the building most days from 0700 to 0300 hours. Additionally by restricting the supervisory personnel from taking time off at the same time we can cut the maximum number of days with no supervisory personnel to 3 days. With the addition of a captain we will be able to divide the duties and roles for supervision and verification between two people. Additionally the Chief and the Captain would coordinate so that only one is out of town at any given time. More documentation available on request. Costs: On going personnel cost is estimated to be approximately $128,000 starting in 2016 including benefits. One time set up costs estimated $36,800 for office space. Personnel costs gathered by human resources survey. The supplies, remodel, phone and IT costs based upon remodeling estimate of $160 per square foot from other city projects and feasibility studies. Budget Impact: There will be an on-going personnel cost funded through General Fund Property taxes. Impact of Funding/Not Funding This proposal: Funding: estimated first year cost of funding this position would be $164,800 and into the future costs would directly be related to personnel compensation. Not Funding: continued lack of time available to supervise and verify activities of staff. Desired Date of Implementation: January 1, 2016 City Administrator Recommendation: Needed, but not financially feasible. Do not fund for FY 15 Date: 07-06-2015 Department: Police Description: Firearms Replacement Rationale: Planned replacement of Handguns scheduled at the time of purchase were advised the most likely service life of the handguns for emergency services use would be 10 years. Over the past three ranges we have begun to see service related issues. 15 page 86 Package Number City of Mendota Heights Budget Improvement Package Prepared By: Aschenbrener Costs: Personnel: depending on purchase 4 to 12 hours of transition training if all off duty overtime maximum cost of $17,940 (it will not be all overtime) the mostly likely scenario would be a total training cost of Tess than $6,000. Supplies: 26 hand guns $18,000 minus trades (if authorized) estimated at $8,000, holsters $4140, magazine holders and Tights $3910 3,000 rounds of ammunition $1325 and range time included in annual training budget. The absolute maximum expenditure would be $37,315 with a Tow estimate depending upon committee recommendations at $23,000. Budget Impact: This would be a onetime impact on the general fund. Expect replacement again in 2026. Impact of Funding/Not Funding This proposal: Impact of funding this project would be increased reliability of the guns used every day. Impact of not funding is the increased down time for repairs and the potential to be nonfunctional on days other than range days. Desired Date of Implementation: Committee work reviewing best practices, state and national standards will be under way and a recommendation could come as early as January for options. City Administrator Recommendation: Fund for 2016 16 page 87 Package Number City of Mendota Heights Budget Improvement Package Date: O8-12-2015 Prepared By: Aschenbrener Department: Police Description: Personal Protective Equipment Rationale: In preparation for the 2008 Republican National Convention most all of our officers went through civil disturbance training. The Dakota County Domestic Preparedness Committee purchase 35 sets of gear for officers to use county wide. As events in the news have shown Minnesota law enforcement is not staff or equipped to handle an event like Baltimore or Ferguson both events had more officers present than would be working state wide. MHPD was last equipped with this equipment in the 1970's. Each officer should have a set of protective gear and be trained in its use. Costs: Supplies would include a helmet with two shields and a protective body suit. Each officer would cost $1200 dollars to equip or $15,139. Training will be incorporated into use force training throughout the year. Budget Impact: This would be funded through General Fund property taxes. The estimated life expectancy would be ten years. Impact of Funding/Not Funding This proposal: Impact of not funding this project: Inability to safely respond to a civil disturbance call. Desired Date of Implementation: January 2016 it will likely take 6 to 9 months for delivery. City Administrator Recommendation: Fund through Civil Defense Fund in 2015 Date: 07-06-2015 Department: Police Description: Reserve Squad Rationale: Replacement of the Reserve car, they are driving a 2008 Ford Crown Victoria that was a used squad purchase. The car see approximately 4000 hours of use annually. Costs: Supplies: purchase the 2012 Ford Police Interceptor Utility that the Sergeants are currently driving. The State of Minnesota Fleet Management anticipates we could purchase the vehicle for around $9,000 when the lease is up. The city mechanic has looked at the car and is recommending we move forward with the replacement. The car would need a new light bar and control head, for an additional $3185, for an overall price of $12,185 17 page 88 Package Number City of Mendota Heights Budget Improvement Package Prepared By: Aschenbrener Budget Impact: This would be a onetime impact on the general fund, with the total cost to be reduced by the trade-in value of the 2008 Ford sedan. Expect replacement again in 2026. Impact of Funding/Not Funding This proposal: Impact of funding this project would be increased reliability of the cars used daily by the volunteers. It will likely be three years before this opportunity presents its self. Desired Date of Implementation: May of 2016 after the lease is over. City Administrator Recommendation: Fund in 2016 page 89 t4 Package Number City of Mendota Heights Budget Improvement Package Date: 08-12-2015 Prepared By: Aschenbrener Department: Police Description: Taser Replacement Rationale: In early 2014 we learned that our existing Taser units, Electrical Conducting Weapons (ECW), were no longer going to be supported. In 2015 we began replacing units as new employees were hired and as the old ones quit working. In place of the X26 ECW, Taser has introduced the X26P. This new ECW is currently in use by our partnering agencies, with which we train, as well as by some of our own officers. Costs: Supplies: purchase new Taser X26P units for all officers and reserves at $1100 for the unit a battery pack and holster for 15 officers for a total cost of $16,500.00. Budget Impact: This would be a onetime impact on the general fund. Expect replacement again in 2023. Impact of Funding/Not Funding This proposal: Impact of not funding this project: We currently replacing units out of the repair and maintenance budget as they fail. This line item of the budget cannot sustain a $16,500 expense and service or repair the rest of our equipment. Desired Date of Implementation: 2016. Staff Recommendation: Purchase the Taser units before they all fail. City of Mendota Heights Budget Improvement Package Date: 07-06-2015 Department: Police Description: Vehicle Replacement 2008 SUV page 90 tc Package Number Prepared By: Aschenbrener Rationale: Replace the unit with a new SUV off the state contract. The police department began purchasing silver SUV's for investigative and specialty units a number of years ago. This unit has been scheduled for replacement a number of times. At this point it is not likely the mechanic will recommend this unit move to other city service. Costs: Capital: $33,000 based on 2015 order. Supplies: $5,500 based on the 2015 order. Supplies would include: lights, siren and rear storage investigative bins. Budget impact: This would be funded through General Fund property taxes. The estimated life expectancy would be four years. Impact of Funding/Not Funding This proposal: Impact of not funding this project: Inability to safely and efficiently to calls for service. Desired Date of Implementation: Spring of 2016 it will likely take three to six months for delivery. City Administrator Recommendation: Defer to 2017 Date: 07-06-2015 Department: Police page 91 Package Number City of Mendota Heights Budget Improvement Package Prepared By: Aschenbrener Description: Automatic External Defibrillator (AED) Replacement Rationale: In early 2015 we learned that our existing AEDs were no longer going to be supported. Shortly after that we learned that the AEDs were no longer downloadable, the cardiac event history cannot be sent to the hospital with the patient. Costs: Supplies: purchase new AED units for 7 black and white vehicles estimated at $10,500 if HealthEast Ambulance has good request for proposal responses. Budget Impact: This would be a onetime impact on the general fund. Expect replacement again in 2023. Impact of Funding/Not Funding This proposal: Impact of not funding this project: We currently can and will be able to administer shocks until such time as the units are no longer serviceable. We will not be able to provide information that could lead to better long term outcomes as related to cardiac events. Are available through HealthEast Medical services. Desired Date of Implementation: 2016. City Administrator Recommendation: Defer to future year City of Mendota Heights Budget Improvement Package Date: 8/12/15 Department: Fire Description: Portable 700 GPM Pump Rationale: This is a portable pump which is able to be carried by two people, and would enhance the fire department's ability to draw water in non -hydrant areas—lakes, rivers, swimming pools, etc. 21 page 92 Package Number Prepared By: Dreelan/McNeill Costs: $7000 Budget Impact: General Fund Impact of Funding/Not Funding This proposal: Not funding this will reduce the ability to fight fires in areas which are not on city water. Desired Date of Implementation: As soon as possible in 2016 City Administrator Recommendation: Do not fund in 2016. Will need to continue to rely on tanker truck and existing means for those occasions where ancillary water supplies are needed. Date: 22 page 93 Package Number City of Mendota Heights Budget Improvement Package 8/12/115 Prepared By: Dreelan/McNeill Department: Fire Description: Aerial Truck Repairs Rationale: The last inspection of the aerial ladder truck found problems with the water supply and turntable from which the ladder operates. It could cause a failure during an emergency which would cause the ladder to be unworkable. Costs: $10,000 Budget Impact: General Fund Impact of Funding/Not Funding This proposal: At some point, there will be a failure of the truck, and it could come at a critical time. Desired Date of Implementation: 2016. Repairs will take it out of service for a few days, to a week. City Administrator Recommendation: Fund in 2016 City of Mendota Heights Budget Improvement Package Date: August 18, 2015 Department: Public Works - Streets Description): Public Works is in need of a replacement dump truck with a snow plow attachment to take the place of the 2000 model year Sterling snow plow we currently have. Rationale: The 2000 model year Sterling snow plow is requiring more intensive maintenance with each passing year. During the 2014-2015 snow season, this truck wound up in the maintenance bay during each snowfall event with significant mechanical failures. This left the Public Works Department without a snow plow on one of the four main plow routes in the City. The truck would also do duty during the rest of the year in a normal general capacity as a 2.5 ton dump truck Costs: $200,000 estimated capitalized equipment Budget Impact: The Street Division is funded through the General Levy. A $200,000 purchase represents approximately 2.86% of a $7,000,000 levy. If equipment certificates were to be used for purchase, substantially smaller payments would be made over the next several years. Impact of Funding/Not Funding This proposal: The Public Works Department will continue to struggle with the maintenance of the existing plow. With no back-up snow plow (we have four plows for four routes), we will eventually lose the 2000 Sterling to a catastrophic mechanical failure, and the level of service we are currently capable of delivering would diminish. Desired Date of Implementation: The Public Works Department would like to order the plow as soon as possible with delivery in 2016. City Administrator Recommendation: Necessary, but do not fund in 2016, It is not practical to do with a single year levy. Need to explore other funding options, such as implementing an equipment reserve fund. Prepared By: John R. Mazzitello page 94 2g Package Number City of Mendota Heights Budget improvement Package Date: August 18, 2015 Department: Public Works - Parks Description): Public Works would like to purchase a replacement Turf Truckster (Kabota brand or approved equal). Rationale): The truckster is a light -weight ATV (non -street legal) type vehicle that is used to go through the parks, trails, and city owned property where larger pick-up trucks cannot go without doing damage to turf and other landscaping. Our current truckster is a 1999 model and has required increasing maintenance over the past several years, which has in -turn hindered park maintenance activity. Prepared By: John R. Mazzitello page 95 Package Number Costs: $23,000 estimated capitalized equipment Budget Impact: The Parks Maintenance Division is funded through the General Levy. A $23,000 purchase represents approximately 0.33% of a $7,000,000 levy. Impact of Funding/Not Funding This proposal: The Public Works Department utilizes the current truckster daily for parks maintenance. If not replaced, the maintenance activity required to keep the current truckster running will continue to increase, eventually leading to a catastrophic mechanical failure. Park maintenance (including sport field preparation) would suffer without one Desired Date of Implementation: The Public Works Department would like to order the Turf Truckster as soon as possible with delivery in 2016. City Administrator Recommendation: I recommend including in the 2016 budget page 96 as - Package Number City of Mendota Heights Budget Improvement Package Date: August 18, 2015 Prepared By: John R. Mazzitello Department: Public Works - Streets Description: Public Works would like to purchase a quick connect/release kit for the 2012 Cat950 Front End Loader. Rationale: One of the functions of the loader is to assist in snow plowing. The loader came with plow and attachments. The quick connect/release kit would allow Public Works staff to more efficiently change attachments on the loader. Costs (Personnel, Supplies, and Capital): $15,000 estimated capitalized equipment Budget Impact: The Street Division is funded through the General Levy. A $15,000 purchase represents approximately 0.21% of a $7,000,000 levy. Impact of Funding/Not Funding This proposal: The Public Works Department utilizes the Cat 950 Front End Loader as somewhat of a back-up snow plow. If the loader is needed during a snow emergency and is not already configured for snow removal, it can take a minimum of 2 personnel over an hour to configure the loader with the correct attachments. This cuts into time available for snow removal. Desired Date of Implementation: The Public Works Department would like to order the quick connect/release kit as soon as possible with delivery in 2016. Staff Recommendation: Staff recommends Council authorize the purchase of a quick connect/release kit for the Cat950 Front End Loader within the 2016 budget.