Loading...
2014-09-02 Council Workshop PacketCITY OF MENDOTA HEIGHTS ,. CITY COUNCIL WORKSHOP AGENDA September 2, 2014 — 5:30 pm Mendota Heights City Hall 1. Call to Order 2. Roll Call 3. 2015 Budget Review 4. Adjourn page 2 1101 Victoria Curve I Mendota Heights, MN 55118 651.452.1850 phone 1 651.452.8940 fax www.rnendota-hei ghts.corn s CITY OF MENDOTA HEIGHTS DATE: September 2, 2014 TO: Mayor and City Council FROM: Justin Miller, City Administrator SUBJECT: 2015 Draft Budget — Revisions Based on August 19th Workshop BACKGROUND On August 19th the city council held a budget workshop where the draft 2015 budget was reviewed. The council reviewed each departmental budget and asked staff to return on September 2nd with more information on the following: • Budget impact of adding a fourth police department sergeant and filling subsequent vacancy with another patrol officer The attached summary sheets and police department budget account for adding a fourth sergeant mid -year and backfilling this position with a patrol officer, also for half of the year. The mid -year proposal is to allow for adequate time for recruitment of a new officer and to allow for newly hired officers to complete their field training. Adding these personnel increases the overall tax levy from the 4.34% proposed on August 19th to 5.01%. • Continued discussion on a proposed gas and electric franchise fee The same materials presented during the last workshop are attached to this memo. The budget impacts of various proposals are also shown in the tax calculations below. Council also asked for what surrounding cities charge for their franchise fees. Of Dakota County cities, only West St. Paul (5%) and South St. Paul (3%) charge a fee. Hastings does as well, but it is tied to their hydroelectric plant. The cities of Farmington and Inver Grove Heights are discussing such a fee but have not adopted one yet. • Continued discussion on a proposed contribution to the West St. Paul ice arena rehabilitation project As was discussed on August 19th, the City of West St. Paul and ISD 197 are considering a three-way partnership (along with a State of Minnesota grant application) to rehab the existing West St. Paul ice arena. If the costs were to be split equally among the three parties, it is estimated that the City of Mendota Heights' share would be roughly $555,000. In order to meet the State of Minnesota grant deadline, a commitment would need to be made by October 1st. On August 25th, the West St. Paul city council voted to proceed with a grant application with the State of Minnesota but only if all three partners page 3 shared equally in the project and they also indicated their desire to add locker rooms to the project costs. BUDGET IMPACT The median valued home in Mendota Heights increased 5.15% between 2014 and 2015. A 4.3490; 5.01% levy increase will have the following impact on a median valued home in Mendota Heights: Median Home Value Total City Tax City Tax Rate Increase (5.15% increase) 2014 $302,700 $1,098.77 34.737 2015 $318,300 $1,146.29 334.506 $47.52 $1,153.96 34.747 $55.19 If the council wishes to implement a gas and electric franchise fee, and dedicate the revenue generated towards existing debt (thus lowering the levy), scenarios could look as follows: RECOMMENDATION Staff recommends that the Mendota Heights City Council review the draft 2015 budget and provide feedback to staff. The preliminary levy will need to be approved at the September 16th city council meeting. Proposed Levy with Levy with 1% Levy with 2% no Franchise Fee Franchise Fee Franchise Fee Levy $6,934,762 $6,934,762 $6,934,762 Franchise Fee $213,021 $442,002 Net Levy (with $6,934,762 $6,721,741 $6,492,760 franchise fee going 5.01% Increase 1.79% Increase -1.68% Decrease towards existing debt Tax on Median $1,153.96 $1,117.01 $1,077.32 Valued Home Average Annual $21.00 $45.00 Franchise Fee Total Tax + Franchise $1,153.96 $1,138.01 $1,122.32 Fee Difference if - ($15.95) ($31.64) Franchise Fee Implemented RECOMMENDATION Staff recommends that the Mendota Heights City Council review the draft 2015 budget and provide feedback to staff. The preliminary levy will need to be approved at the September 16th city council meeting. page 4 :ity of Mendota Height: Net Tax Caaacit Pay 2014 Pay 2015 Actual Preliminary Tax Capacity Value 20,019,099 20,953,527 4.67% Fiscal disparaties Contribution (2,600,263) (2,600,263) 0.00% Net Tax Capacity 17,418,836 18,353,264 5.36% Tax Capacity Rate 1% Franchise Fee 2% Franchise Fee Estimate Tax levy 6,306,012 6,633,875 5.20% 6,420,854 1.82% 6,191,873 -1.81% Fiscal disparities (256,684) (256,684) 0.00% (256,684) 0.00% (256,684) 0.00% Net tax levy 6,049,328 6,377,191 5.42% 6,164,170 1.90% 5,935,189 -1.89% Net Tax Capacity 17,418,836 18,353,264 5.36% 18,353,264 5.36% 18,353,264 5.36% Tax Capacity Rate 0.34737 0.34747 0.03% 0.33586 -3.31% 0.32339 -6.90% 2015 2015 2004 27.030 2005 Home Value Total 2014 Tax City Tax Referendum Total 2015 Tax Difference % Change $302,700 $1,098.77 24.142 2009 26.165 2010 $318,300 $1,106.00 $47.97 $1,153.96 $55.19 5.02% $318,300 $1,069.04 $47.97 $1,117.01 $18.24 1.66% $318,300 $1,029.35 $47.97 $1,077.32 -$21.45 -1.95% Tax Rates for Mendota Heights 2003 28.287 2004 27.030 2005 26.898 2006 28.027 2007 26.398 2008 24.142 2009 26.165 2010 28.061 2011 29.733 2012 32.057 2013 34.479 2014 34.737 2015 34.747 2015 33.586 1 % franchise fee 2015 32.339 2% franchise fee 0.000156197 2014 referendum rate 0.00015067 2015 referendum rate 1 % franchise fee 2% franchise fee page 5 page 6 Maturity *Bold numbers are estimates of the amount needed to levy for future street projects 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2006 issue $ 6,500 $ 3,400 2/1/2017 2007 issue $ 80,400 $ 79,100 $ 83,000 $ 83,700 $ 81,600 $ 79,500 $ 82,700 $ 80,300 $ 83,200 $ 85,800 2/1/2027 2008 issue $ 170,572 $ 173,517 $ 170,162 $ 172,058 $ 180,771 $ 176,470 $ 171,811 $ 172,403 $ 177,840 $ 177,576 2/1/2028 2009 issue $ 27,300 $ 26,999 $ 26,533 $ 26,067 $ 25,491 2/1/2020 2010 issue $ 41,241 $ 42,006 $ 42,457 $ 42,908 $ 43,043 $ 43,179 $ 45,632 $ 45,285 $ 44,720 $ 44,156 2/1/2030 2011 issue $ 205,946 $ 210,919 $ 215,224 $ 218,832 $ 221,719 $ 183,270 $ 154,603 $ 120,262 $ 118,109 $ 69,680 2/1/2031 2012 issue $ 91,067 $ 91,568 $ 86,820 $ 87,427 $ 88,034 $ 88,641 $ 188,998 $ 198,110 $ 194,140 $ 191,424 2/1/2032 2013 issue $ 119,619 $ 122,453 $ 119,933 $ 117,413 $ 125,393 $ 127,913 $ 123,661 $ 119,408 $ 120,406 $ 115,996 2/1/2033 2014 issue $ - $ 65,000 $ 65,000 $ 65,000 $ 65,000 $ 65,000 $ 65,000 $ 65,000 $ 65,000 $ 65,000 * 2/1/2034 2015 issue $ $ $ 65,000 $ 65,000 $ 65,000 $ 65,000 $ 65,000 $ 65,000 $ 65,000 $ 65,000 * 2/1/2035 2016 issue $ $ $ - $ 145,000 $ 145,000 $ 145,000 $ 145,000 $ 145,000 $ 145,000 $ 145,000 * 2/1/2036 2017 issue $ $ $ - $ $ 155,000 $ 1551000 $ 155,000 $ 1551000 $ 155,000 $ 155,000 2/1/2014 Equipment Certificates $ 55,065 $ 53,765 $ 52,253 $ 50,741 2/1/2018 Par 3 bonds $ 267,887 $ 265,367 $ 267,787 $ 264,532 $ 266,153 $ 267,341 $ 267,918 $ 268,055 2/1/2023 Total Debt Levies $ 1,065,595 $ 1,134,095 $ 1,194,170 $ 1,338,679 $ 1,462,205 $ 1,396,313 $ 1,465,323 $ 1,433,822 $ 1,168,415 $ 1,114,632 *Bold numbers are estimates of the amount needed to levy for future street projects page 7 CITY OF MENDOTA HEIGHTS 2015 BUDGET TAX LEVY SUMMARY 2014 2015 % CHANGE GENERAL FUND $5,454,959 $5,646,780 3.52% EMERGENCY PREPAREDNESS $25,000 $25,000 0.00% FIRE RELIEF $68,000 $90,000 32.35% 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,627,959 $5,841,780 3.80% IMPROVEMENT BONDS $621,689 $737,029 18.55% EQUIPMENT CERTIFICATES $56,364 $55,066 -2.30% TOTAL SPECIAL LEVY $678,053 $792,095 16.82% MARKET VALUE REFERENDUM LEVY $264,737 $267,887 1.19% STREETLIGHT TAXING DISTRICT $33,000 $33,000 0.00% TOTAL TAX LEVY $6,603,749 $6,934,762 5.01% page 8 GENERAL FUND FUND 01 REVENUE SOURCE 2013 ACTUAL 2014 BUDGET 2015 BUDGET % CHANGE TAXES CURRENT TAX LEVY $5,338,124 $5,454,959 $5,646,780 3.52% LICENSES AND PERMITS CIGARETTE LICENSES $1,200 $600 $600 0.00% RUBBISH LICENSES $1,455 $1,400 $1,400 0.00% DOG LICENSES $960 $750 $800 6.67% CONTRACTOR LICENSES $17,450 $17,000 $17,000 0.00% LIQUOR LICENSES $33,850 $21,000 $21,000 0.00% BUILDING PERMITS $270,716 $135,000 $180,000 33.33% HEATING PERMITS $38,313 $25,000 $30,000 20.00% PLUMBING PERMITS $9,048 $5,000 $7,000 40.00% WATER PERMITS $30 $50 $50 0.00% RIGHT OF WAY PERMITS $9,341 $5,000 $6,500 30.00% MASSAGE PERMITS $2,238 $1,800 $2,000 11.11% RENTAL LICENSES $4,283 $1,000 $3,500 250.00% TOTAL LICENSES AND PERMITS $388,885 $213,600 $269,850 26.33% FINES AND FORFEITS COURT FINES $62,250 $70,000 $68,000 -2.86% FALSE ALARMS FINES $2,600 $3,500 $3,500 0.00% DOG IMPOUNDING $402 $1,000 $1,000 0.00% TOTAL FINES AND FORFEITS $65,252 $74,500 $72,500 -2.68% CHARGES FOR SERVICES ACCIDENT REPORTS $0 $0 $0 #DIV/0! RECREATION PROGRAMS $36,263 $29,000 $32,000 10.34% PARK USE FEES $6,078 $7,000 $7,000 0.00% SOFTBALL LEAGUES $10,758 $11,000 $11,000 0.00% MAPS AND ORDINANCES $0 $0 $0 0.00% SURCHARGES ($10) $0 $0 0.00% PLANNING FEES $4,805 $6,500 $6,500 0.00% FIRE CONTRACTS $86,040 $83,877 $101,067 20.49% FIRE PERMITS $0 $0 $0 0.00% LILYDALE POLICING $212,856 $226,545 $229,883 1.47% MENDOTA POLICING $61,536 $65,514 $73,861 12.74% POLICE SECURITY (OFF DUTY OT) $16,628 $18,000 $18,000 0.00% FIRE CALLS $0 $0 $0 0.00% STREET MAINT. CHARGES $1,000 $1,000 $1,000 0.00% ASSESSMENT SEARCHES/SPLITS $15 $0 $0 0.00% STREET CHARGES $0 $0 $0 0.00% FILING FEES $0 $20 $0 LEASE MAINTENANCE CHARGES $3,051 $3,500 $3,500 0.00% TOTAL CHARGES FOR SERVICES $439,020 $451,956 $483,811 7.05% page 9 INTERFUND TRANSFERS PROJECT INTEREST TRANSFER $0 $0 $0 0.00% PROJECT REIMBURSEMENT $0 $0 $0 0.00% TOTAL INTERFUND TRANSFER $0 $0 $0 0.00% INTERGOVERNMENTAL MSA MAINTENANCE $132,131 $128,000 $130,000 1.56% POLICE STATE AID $123,053 $110,000 $115,000 4.55% SCHOOL RESOURCES OFFICER $99,414 $95,000 $97,000 2.11% FEDERAL AND STATE GRANTS $22,614 $6,000 $6,000 0.00% DAKOTA COUNTY GRANT $459 $10,000 $10,000 0.00% PERA AID $9,073 $9,070 $9,070 0.00% TOTAL INTERGOVERNMENTAL $386,744 $358,070 $367,070 2.51% MISCELLANEOUS REVENUE SUNDRY REVENUE $49,022 $5,000 $5,000 0.00% GRAVEL TAX $0 $0 $0 0.00% DONATIONS $17,220 $0 $0 0.00% INTEREST -$70,713 $35,000 $35,000 0.00% TOTAL MISCELLANEOUS -$4,470 $40,000 $40,000 0.00% DAKOTA COUNTY WASTE MANAGEMENT $13,800 $14,000 $14,000 0.00% TOTAL DAKOTA COUNTY $13,800 $14,000 $14,000 0.00% OTHER REVENUE UNAPPROPRIATED FUND TRANSFEF $109,250 $109,500 $99,500 -9.13% TOTAL OTHER REVENUE $109,250 $109,500 $99,500 -9.13% TOTAL GENERAL FUND REVENUE $6,736,604 $6,716,585 $6,993,511 4.12% page 10 GENERAL FUND FUND 01 DEPARTMENT 2013 ACTUAL 2014 BUDGET 2015 PRELIMINARY % CHANGE CITY COUNCIL $33,275 $34,096 $33,796 -0.88% ADMINISTRATION $808,656 $890,452 $891,414 0.11% ELECTIONS $28,692 $56,007 $41,088 -26.64% IT $131,216 $154,165 $138,437 -10.20% POLICE $2,974,335 $3,128,910 $3,337,183 6.66% FIRE $399,184 $442,048 $474,615 7.37% BUILDING OFFICIAL $158,532 $168,250 $133,050 -20.92% PUBLIC WORKS -STREETS $1,118,419 $944,644 $981,232 3.87% PUBLIC WORKS -PARKS $682,910 $694,495 $761,395 9.63% RECREATION $45,656 $45,350 $46,700 2.98% PLANNING $92,264 $111,115 $122,231 10.00% RECYCLING $25,028 $23,316 $24,370 4.52% ANIMAL CONTROL $5,914 $7,760 $8,000 3.09% TOTAL GENERAL FUND $6,504,079 $6,700,608 $65993,511 4.37% GENERAL FUND CONTINGENCY $80,456 $40,000 $40,000 0.00% page 11 CAT OBJ DESCRIPTION 2013 ACTUAL 2014 2015 % BUDGET PRELIMINARY CHANGE 4110 SALARIES-REGULAR/PATROL $911,270 $944,210 $895,311 -5.18% 4110 SALARIES-REGULAR/ADMINISTRATION $678,419 $662,211 $751,987 13.56% 4115 SALARIES-OVERTIME/PATROL $103,592 $85,490 $90,500 5.86% 4130 SALARIES -TEMPORARY $5,160 $10,400 $10,400 0.00% 4131 INSURANCE $292,525 $331,056 $383,328 15.79% 4133 WORKERS COMPENSATION $51,413 $59,500 $68,000 14.29% 4134 PERA/PATROL $141,987 $157,544 $150,829 -4.26% 4134 PERA/ADMINISTRATION $91,995 $93,210 $104,295 11.89% 4135 FICA/PATROL $15,125 $15,676 $15,090 -3.74% 4135 FICA/ADMINISTRATION $13,555 $14,643 $19,739 34.80% 4136 FLEX BENEFITS $0 $0 $0 0.00% TOTAL HUMAN RESOURCES $2,305,042 $2,373,940 $2,489,479 4.87% 4200 RENTALS AND LEASES $53,668 $56,084 $56,100 0.03% 4209 CITY HALL OCCUPANCY $72,460 $72,460 $72,460 0.00% 4210 TELEPHONE $15,767 $20,150 $19,700 -2.23% 4220 POST LICENSE RENEWALS $360 $720 $0 -100.00% 4220 ATTORNEY FEES $3,028 $5,000 $4,000 -20.00% 4220 OTHER PROFESSIONAL SERVICES $122 4222 PROSECUTIONS $66,057 $64,272 $67,500 5.02% 4223 OTHER CONTRACTUAL SERVICES DCC PUBLIC SAFETY BONDS $9,668 BCA DEPARTMENT ACCESS CHARGE $0 $1,080 $1,080 0.00% BCA MOBILE ACCESS CHARGE $2,880 $2,880 $2,880 0.00% DTSCP $0 $5,000 $0 -100.00% PRO PHOENIX RMS $14,216 $14,823 $21,296 43.67% AIRCARD/NETMOTION $3,679 $5,040 $3,000 -40.48% LOGIS-APS TICKET WRITER $0 $2,066 $2,139 3.53% LOGIS-APPLICATION SUPPORT $26,028 $16,058 $17,464 8.76% LOGIS-SYSTEM DEVELOPMENT $1,420 $1,492 $1,548 3.75% LOGIS INET $50 $9,147 $9,819 7.35% LOGIS ANY CONNECT/MAPS $0 $1,134 $1,650 45.50% LEASE LINE MN OFFICE TECH GROUP $1,510 $1,500 -100.00% CJIIN $9,131 $9,500 $9,750 2.63% INT. ASSOCIATION OF POLICE CHIEFS $0 $850 $850 0.00% AUTOMATED PAWN $204 $204 $204 0.00% LEXISNEXIS $618 $2,160 $2,200 1.85% LANGUAGE LINE - INTERPRETER SVCS $283 $400 OTHER CONTRACTUAL SERVICES $31 $4,000 $4,000 0.00% ELECTRONIC CRIMES TASK FORCE $15,000 4223 DCC ANNUAL RADIO FEE $8,061 $11,132 $12,380 11.21% 4275 DCC ANNUAL FEE $182,092 $202,014 $200,500 -0.75% RADIO MAINTENANCE AGREEMENT $1,094 $1,705 $0 -100.00% TOTAL CONTRACTUAL SERVICES $472,426 $510,471 $525,920 3.03% 4300 OFFICE SUPPLIES $4,252 $5,000 $5,000 0.00% 4301 COMPUTER SOFTWARE $1,293 $1,500 $46,894 3026.27% 4305 OPERATING SUPPLIES $7,481 $24,250 $3,000 -87.630/. page 12 4305 POLICE RESERVES $2,476 $7,500 $7,500 0.00% 4306 RECRUITMENT COSTS $55 $2,500 $2,500 0.00% 4318 POSTAGE $624 $1,000 $1,000 0.00% 4320 GAS AND OIL $60,004 $55,000 $60,000 9.09% 4330 EQUIPMENT REPAIR/GENERAL $15,711 $25,000 $30,000 20.00% 4330 EQUIPMENT REPAIR/COPIER $917 $2,000 $2,000 0.00% 4330 EQUIPMENT REPAIR/CAR SET UP $12,475 $10,000 $18,000 80.00% 4330 SOFTWARE MAINTENANCE $0 $9,250 $0 0.00% 4331 MISCELLANEOUS FURNITURE/EQUIP $2,419 $10,000 $17,000 70.00% TOTAL COMMODITIES $107,705 $153,000 $192,894 26.07% 4400 CONFERENCES AND SCHOOLS $38,174 $34,689 $34,000 -1.99% 4402 BOOKS AND SUBSCRIPTIONS $0 $500 $500 0.00% 4404 MEMBERSHIP DUES $6,190 $4,400 $6,900 56.82% 4410 CLOTHING AND EQUIPMENT $19,559 $18,700 $26,890 43.80% 4415 MILEAGE AND AUTO ALLOWANCE $1,500 $1,500 $1,500 0.00% 4430 CAR WASHES $3,741 $4,000 $5,000 25.00% 4490 SUNDRY EXPENSE $3,947 $4,000 $4,500 12.50% 4490 SHREDDING $444 $540 $600 11.11% TOTAL OTHER CHARGES $73,555 $68,329 $79,890 16.92% 4610 CAPITAL OUTLAY $15,606 $23,170 $49,000 0.00% TOTAL CAPITAL OUTLAY $15,606 $23,170 $49,000 0.00% TOTAL EXPENDITURES $2,974,335 $3,128,910 $3,337,183 6.66% CAPITAL OUTLAY ITEMS REQUESTED APPROVED DEFERRED INVESTIGATIONS VEHICLE $30,000 COPIER $9,000 BACKEND SQUAD CAMERAS $10,000 page 13 MENDOTA HEIGHTS HR CALCULATIONS 2015 BUDGET POLICE DEPARTMENT EMPLOYEE ANN DATE GRADE STEP 2014 SAL 2015 W1 2015 W2 2015 W3 2015 TOTAL PERA FICA MED INSURANCE TOTAL MIKE ASCHENBRENER x 5/12/2003 41 E $110,429 $112,638 $0 $0 $112,638 $17,234 $0 $1,633 $17,424 $148,929 SERGEANT x $94,268 $77,868 $9,344 $0 $87,212 $13,343 $0 $1,265 $17,424 $119,244 SERGEANT x $0 $77,868 $9,344 $0 $43,606 $6,672 $0 $632 $8,712 $59,622 L-12 BRIAN CONVERY (SGT) x 7/3/1995 $94,268 $85,860 $10,303 $0 $96,163 $14,713 $0 $1,394 $17,424 $129,695 E-12 ERIC PETERSON (SGT) x 1/18/2000 $94,268 $85,860 $10,303 $0 $96,163 $14,713 $0 $1,394 $17,424 $129,695 E-12 INVESTIGATOR x INV 36 $83,036 $73,956 $8,875 $4,020 $86,851 $13,288 $0 $1,259 $17,424 $118,822 L-9 CHAD WILSON x 1/19/2000 INV 36 $85,211 $73,956 $8,875 $4,020 $86,851 $13,288 $0 $1,259 $17,424 $118,822 E-12 KIM HENNING x 12/19/2005 12 E $51,501 $52,531 $0 $0 $52,531 $4,071 $3,257 $762 $17,424 $78,045 LISA BRANDT (0.5 FTE) x 3/7/2014 12 C/D $25,751 $31,931 $16,718 $0 $24,325 $1,885 $1,508 $353 $8,712 $36,783 TRISTA MILLER (0.5 FTE) x 1/16/2013 12 D $23,749 $50,155 $0 $0 $25,078 $1,944 $1,555 $364 $8,712 $37,651 SUE DONOVAN (.50) $0 $53,207 $27,933 $0 $40,570 $3,144 $2,515 $588 $8,712 $55,530 ROBERT LAMBERT x 6/25/1996 POL 36 $81,191 $73,956 $8,875 $0 $82,831 $12,673 $0 $1,201 $17,424 $114,129 E-12 JENNIFER LARRIVE x 12/19/2001 POL 36 $80,951 $73,956 $6,656 $1,935 $82,547 $12,630 $0 $1,197 $17,424 $113,798 E-9 JEFF VON FELDT x 1/23/2001 POL 36 $77,566 $73,956 $5,177 $0 $79,133 $12,107 $0 $1,147 $17,424 $109,812 L-7 PEYTON FLEMMING x 7/1/2007 POL 36 $81,191 $73,956 $8,875 $0 $82,831 $12,673 $0 $1,201 $17,424 $114,129 E-12 PATROL x POL 36 $79,016 $73,956 $6,656 $0 $80,612 $12,334 $0 $1,169 $17,424 $111,539 page 14 L-9 TODD ROSSE x 1/20/2000 POL 36 $77,566 $73,956 $5,177 $0 $79,133 $12,107 $0 $1,147 $17,424 $109,812 L-7 TANNER SPICER x 1/22/2001 POL 36 $77,566 $73,956 $5,177 $0 $79,133 $12,107 $0 $1,147 $17,424 $109,812 L-7 STEVE MEYER x 6/13/2005 POL 36 $81,191 $73,956 $8,875 $0 $82,831 $12,673 $0 $1,201 $17,424 $114,129 E-12 DENISE URMANN x 7/23/2005 POL 36 $79,016 $73,956 $6,656 $0 $80,612 $12,334 $0 $1,169 $17,424 $111,539 E-9 MICHAEL SHEPARD x 9/21/2006 POL 36 $76,117 $73,956 $3,698 $0 $77,654 $11,881 $0 $1,126 $17,424 $108,085 E-5 JOHN LARRIVE x 7/8/1996 POL 36 $79,016 $73,956 $6,656 $0 $80,612 $12,334 $0 $1,169 $17,424 $111,539 PATROL (1/2 YEAR) $28,230 $0 $0 $28,230 $4,319 $0 $409 $0 $32,959 STAFF ADJUSTMENTS -$94,111 -$14,399 $0 -$1,365 $34,848 -$75,027 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 $40,000 $40,000 $0 $0 $42,500 $6,503 $0 $616 $0 $49,619 DTF OVERTIME NA NA NA $15,990 $15,990 $0 $0 $18,500 $2,831 $0 $268 $0 $21,599 MAAG OVERTIME NA NA NA $7,500 $7,500 $0 $0 $7,500 $1,148 $0 $109 $0 $8,756 SOT OVERTIME NA NA NA $4,000 $4,000 $0 $0 $4,000 $612 $0 $58 $0 $4,670 OFF DUTY OVERTIME NA NA NA $18,000 $18,000 $0 $0 $18,000 $2,754 $0 $261 $0 $21,015 WORKERS COMPENSATION NA NA NA $59,500 $68,000 $0 $0 $68,000 $0 $0 $0 $0 $68,000 DC TRAFFIC SAFETY NA NA NA $5,000 $5,000 $0 $0 $5,000 $765 $0 $73 $0 $5,838 HOLIDAY PAY X NA NA NA $63,821 $63,264 $0 $0 $63,264 $9,679 $0 $917 $0 $73,861 COMP TIME PAYOUTS X NA NA NA $5,000 $5,000 $0 $0 $5,000 $765 $0 $73 $0 $5,838 page 15 TOTALS $1,816,198 $255,124 $9,480 $25,349 $383,328 $2,489,479 ALL DEPARTMENT $9,975 SAL -REG $1,647,298 INS CONT $1,452 SAL -OTHER $10,400 PERA $255,124 FICA $9,480 $2,489,479 MEDICARE $25,349 OT $90,500 INSURANCE $383,328 WORKCOMI $68,000 TOTAL $2,489,479 VERIFY $2,489,479 ADMINISTRATION SAL -REG $751,987 SAL -OTHER PERA $104,295 FICA $8,835 MEDICARE $10,904 OT INSURANCE $156,816 WORK COME $68,000 TOTAL $1,100,838 PATROL SAL -REG $895,311 SAL -OTHER $10,400 PERA $150,829 FICA $645 MEDICARE $14,445 OT $90,500 INSURANCE $226,512 WORK COMP TOTAL $1,388,642 ' Xcel Energy° RESPONSIBLE BY NATURE 3000 Maxwell Newport, MN 55055 City of Mendota Heights, MN Franchise Fee Estimates page 16 The following information is being provided to assist your community in discussions regarding franchise fees. Given market sensitivity to electric and gas rates, we strongly encourage the city to reach out to residents and businesses. • Information based on year ending December 31, 2013 • Franchise fee is applied as the same percentage to all customer classes and rounded to the nearest $0.25. • The tables below show the fee that would be reflected on a customer bill, and the revenue the community would collect annually. • 1 % and 2% fees are applied for illustrative purposes, 5% is the maximum applicable franchise fee. • Franchise fees must be applied equally to all public utilities. Xcel Energy retains no portion of a franchise fee. Franchise Fee: Electric Class Monthly Fee, 1% Equiv. Monthly Fee, 2% Equiv. Residential $1.00 $2.25 Small C&I Non Demand $1.00 $2.25 Small C&I Demand, Large C&I $27.00 $54.00 Public Streetlights $2.00 $4.00 Municipal Pumping $2.25 $4.25 Total (Annual) Revenue $149,781 $314,565 Franchise Fee: Gas Class Monthly Fee, 1% Equiv. Monthly Fee, 2% Equiv. Residential $0.75 $1.50 Commercial Non Demand $1.75 $3.75 Commercial Firm Demand $129.50 $259.00 Small Interruptible $22.50 $45.25 Medium and Large Interruptible $68.75 $137.75 Commercial — Large $10.25 $20.50 Total (Annual) Revenue $63,240 $127,437 Jake Sedlacek Manager, Community Relations and Economic Development jake.sedlacek@xcelenergy.com 651.458.1228 Ice Arena Facility Assessment Archetectural systems Low 200,000.00 High $ Roofing $ 50,000.00 $ 50,000.00 Exterior issues $ 60,000.00 $ 60,000.00 Interior Issues $ 36,000.00 $ 36,000.00 Structural Systems Mechanical Systems plumbing $ 39,000.00 $ 39,000.00 HVAC $ 250,000.00 $ 250,000.00 Electrical lighting $ 46,000.00 $ 46,000.00 Ice System concrete floor $ 525,000.00 $ 760,000.00 refridgeration $ 325,000.00 $ 625,000.00 total other NOT INCLUDED IN BUDGET additional lockerrooms Scoreboard Potential Funding Sources State of Minnesota West St Paul Mendota Heights ISD 197 Boosters $ 1,331,000.00 $ 1,866,000.00 $ 350,000.00 $ 20,000.00 $ 200,000.00 $ 200,000.00 $ 377,000.00 $ 555,333.00 $ 377,000.00 $ 555,333.00 $ 377,000.00 $ 555,333.00 z $ 1,331,000.00 $ 1,865,999.00 page 17 page 18 City Players District 197 % of Total Bloomongton 1 No 0.25% Eagan (Northern) 26 Yes 6.60% Hopkins 1 No 0.25% Inver Grove Heights 16 No 4.06% Mendota 6 Yes 1.52% Mendota Heights 219 Yes 55.58% Minneapolis 1 No 0.25% North Oaks 1 No 0.25% Saint Paul 17 No 4.31% South Saint Paul 6 No 1.52% Stillwater 1 No 0.25 Sunfish Lake 14 Yes 3.55% West Saint Paul 83 Yes 21.07% Woodbury 2 No 0.51% 2013-2014 Season 394 Total 100.00% WSP Ice Arena Operations Operating Revenue Operating Expenses Non -Operating Rev/Exp Debt Service Profit/(Loss) mg2011. �� 2010 3 � 2009 201,974 203,060 188,901 209,472 208,869 (255,413) (293,344) (249,110) (276,492) (267,950) 2,919 17,175 5,696 1,756 3,697 (115,550) (107,800) (109,600) (111,400) (111,375) (166,070) (180,909) (164,113) (176,664) (166,759) Supplemental Budget Questions Question: How much of the sanitary sewer payments that our residents pay stays in Mendota Heights vs. being paid to Metropolitan Council Environmental Services (MCES)? Answer: The projected 2015 sanitary sewer budget shows expenses of $1,674,884. Of that, $1,158,659 (69.2%) is paid to MCES. Youth Athletic Associations in Other Communities Most, if not all communities in the metropolitan area rely on youth athletic associations (YAA) to provide programs for youth. While the relationship between the individual communities and their associations can vary greatly, a simple survey shows some common themes: City Mendota Heights West St. Paul Population 11,138 19,708 2014 General Fund Budget $6,603,749 $11,641,547 Local Government Aid (LGA) $0 $1,153,343 Hockey Players (in SAYHA) 219 83 Y N Y Question: How much of the sanitary sewer payments that our residents pay stays in Mendota Heights vs. being paid to Metropolitan Council Environmental Services (MCES)? Answer: The projected 2015 sanitary sewer budget shows expenses of $1,674,884. Of that, $1,158,659 (69.2%) is paid to MCES. Youth Athletic Associations in Other Communities Most, if not all communities in the metropolitan area rely on youth athletic associations (YAA) to provide programs for youth. While the relationship between the individual communities and their associations can vary greatly, a simple survey shows some common themes: City YAA City contribution to YAA YAA provides regular reports to City YAA pays for facility use YAA participates in improvements Notes Apple Valley Y N Y N Y Facility fees for invitational tournaments only Burnsville Y N Y Y Y YAA pays fee to cit Eagan Y N N Y Y Edina Y N Y Y Y Eden Prairie Y N Y Y Y Inver Grove Heights Y N N Y Y Maplewood Y N Y Y Y Mendota Heights Y Y N N N Facility fees for invitational tournaments only Richfield Y N N Y Y West St. Paul Y N N Y Assumes 3.5% inflationary increases 2015 2016 2017 2018 2019 2020 2021 Levy with no franchise fee $ 6,934,762 $7,177,479 $ 7,428,690 $ 7,688,695 $ 7,957,799 $ 8,236,322 $ 8,524,593 Levy with 1% franchise fee $ 6,721,741 $6,957,002 $ 7,200,497 $ 7,452,514 $ 7,713,352 $ 7,983,320 $ 8,262,736 Levy with 2% franchise fee $ 6,492,760 $6,720,007 $ 6,955,207 $ 7,198,639 $ 7,450,591 $ 7,711,362 $ 7,981,260 Average home tax bill w/ no franchise fee $ 1,153.96 $ 1,194.35 $ 1,236.15 $ 1,279.42 $ 1,324.20 $ 1,370.54 $ 1,418.51 Average home tax bill w/ 1% franchise fee $ 1,117.01 $ 1,156.11 $ 1,196.57 $ 1,238.45 $ 1,281.79 $ 1,326.66 $ 1,373.09 Average home tax bill w/2% franchise fee $ 1,077.32 $ 1,115.03 $ 1,154.05 $ 1,194.44 $ 1,236.25 $ 1,279.52 $ 1,324.30 Annual franchise fee per house with no franchise fee $ - $ - $ - $ - $ - $ - $ - Annual franchise fee per house with 1% franchise fee $ 21.00 $ 21.74 $ 22.50 $ 23.28 $ 24.10 $ 24.94 $ 25.81 Annual franchise fee per house with 2% franchise fee $ 45.00 $ 46.58 $ 48.21 $ 49.89 $ 51.64 $ 53.45 $ 55.32 Total tax + franchise fees w/ no franchise fee $ 1,153.96 $ 1,194.35 $ 1,236.15 $ 1,279.42 $ 1,324.20 $ 1,370.54 $ 1,418.51 Total tax + franchise fees w/ 1% franchise fee $ 1,138.01 $ 1,177.84 $ 1,219.06 $ 1,261.73 $ 1,305.89 $ 1,351.60 $ 1,398.90 Total tax + franchise fees w/ 2% franchise fee $ 1,122.32 1 $ 1,161.60 1 $ 1,202.26 $ 1,244.34 $ 1,287.89 $ 1,332.96 $ 1,379.62