The URL can be used to link to this page

08-08-16 CC WS Agenda CITY OF SHOREWOOD 5755 COUNTRY CLUB ROAD CITY COUNCIL WORK SESSION COUNCIL CHAMBERS MONDAY, AUGUST 8, 2016 6:00 P.M. AGENDA 1. CONVENE CITY COUNCIL WORK SESSION A. Roll Call Mayor Zerby _____ Labadie _____ Siakel _____ Sundberg _____ Woodruff _____ B. Review Agenda ATTACHMENTS 2. 2016-2025 CIP AND 2017 GENERAL FUND BUDGET Finance Director’s memo Public Safety Budgets - Recommended CIP Levy for 2017 - 3. ADJOURN #2 MEETING TYPE City of Shorewood Council Meeting Item Work Session Title / Subject: 2017 Capital Improvement Program & General Fund Budget Review Meeting Date: August 8, 2016 Prepared by: Bruce DeJong, Finance Director Attachments: 2016 -2020 Capital Improvement Program Review Sheets General Fund Budget Policy Consideration: How should the City of Shorewood prepare the General Fund Budget, Capital Improvement Program (CIP) and preliminary tax levy for 2017? Background: UP Staff has reviewed the street plan as suggested by Council. There really are a couple of anomalies, but they are in the rating system rather than the plan. Some of the streets are rated higher because of extensive patching and annual maintenance than the underlying conditions really warrant. Those short term fixes don't last long any more. That — and the need for drainage improvements - is the reason that Riviera, Mann, and Seaman's are on the schedule for reconstruction. If Council chooses to delay the reconstruction, we can avoid the immediate costs, but we will incur higher annual maintenance costs each year. This is the case with the reconstruction of Glen, Amlee and Manitou roads. They have been delayed because of cost — not reconstruction criteria. Similarly, Strawberry Lane& West 62nd Street reconstruction has been moved up in the schedule in order to coordinate with trail construction. This street would not be recommended for replacement at this time except for the necessary drainage improvements required to install a trail to the elementary school. The project was advanced in order to try to take advantage of the abatement possibility for the Minnetonka School District brought about by the new value to be added by new home construction on the Minnetonka Country Club site. The school district's willingness to participate has not yet been determined. Because of the large dollar amounts some of these street projects represent, the City Council has reviewed the streets both at the retreat and during the budget process for at least four years. The Council has directed staff to delay several streets on the basis of cost. This has happened on a regular basis because current funding sources are insufficient at some point in the maintenance cycle to cover all the streets that need attention. We have attempted to resolve some of the problem through modest annual increases in the amount transferred into the fund. However, the amount needed at the point of reconstruction some of the major cost streets will require either additional resources, probably through bonding, or decide on a street by street basis annually on which to reconstruct. The City Council needs to make a choice soon so that residents have some indication of when to expect maintenance activities on their road. This is the essence of good maintenance planning — that we know the basis on which we make decisions and that those plans are then carried out as presented. For discussion purposes, we have left all of the island street projects to 2017 to coordinate with the possible Minnetrista project on Enchanted Lane. Staff will present how this affects the fund balances through use of the Financial Management Plan spreadsheets. If we leave the projects in 2017 as discussed, then the deficit for the fund is about the cost of those island road projects which total $509,000. If they stay out in 2023 and 2024, then the fund is substantially in balance until 2021. We should have some indication if the Minnetrista project will proceed by September when they have asked for public input on the assessments associated with their financing plan. We have added two projects into the CIP for this year. They are in the Water and Sewer Funds for a new telemetry system. This is a similar system to Deephaven's and they are pleased with the performance. Our system has been patched together for several years, but can no longer be maintained properly. The phone line systems are not as reliable as newer cellular -based systems. Those costs are easily covered by the available fund balance in the respective funds. General Fund Budget Changes from July 25, 2016: Increased Permit Revenue $30,000 Increased Plan Check fees $10,000 Finance — Audit Services $1,400 Prof Services — Prosecution $4,000 Planning — Gen Supplies $150 Planning — Contractual Svcs ($85,000) Mun Buildings —Communications $4,000 Mun Buildings — Contractual Svcs $1,200 Police — Contractual Svcs $73,885 Police — Buildings ($16,000) Fire — Contractual Svcs $3,262 Fire — Buildings ($13,972) Inspections— Contractual Svcs $2,500 Public Works —Office Supplies $200 Public Works — Motor Fuels ($3,000) At the work session last month, there was a suggestion to transfer out $500,000 from the General Fund in 2016 to the Street Improvement Fund. Staff would like Council direction on that suggestion and will bring it forward for action if there is a consensus. Financial or Budget Considerations: This budget increases the tax levy by 2% for 2016. The amount of fund balance projected to be used is about $73,000. This is well within the parameters of the fund balance policy. If we need to fund the $85,000 Comp Plan costs there is sufficient money in the fund balance to make that happen. The City Council needs to determine if this is acceptable on a preliminary basis. Once the preliminary tax levy is set by September 30, the tax levy can only be decreased. The city council has the option of increasing the preliminary levy to any level desired up to a fully balanced budget. The tax levy could then be reduced at the point of final budget and levy adoption in December if the Council chooses to reduce expenditures or increase other revenues. _7_ Options: The City Council is encouraged to discuss the budget as presented and recommend changes to staff. Recommendation / Action Requested: Staff recommends that the City Council determine what amount of tax levy increase is necessary in order to provide a reasonable level of service for the next budget year. Next Steps and Timelines: The City Administrator and Finance Director intend to continue discussions regarding capital and budget items through the Truth -in- Taxation hearing in December. Connection to Vision / Mission: Adopting a prudent budget and tax levy contributes to sound financial management. WA O O 0 0 0 Iz, 0 o Q) o 0 Q> 0 0 0 0 0 0 cn, Iz, 0 0 0 Q> Q, (Z' 0 0 0 0 Z) 0 0 0 0 0 ci Qi ci 0t Qi Qi Qi 0 1 lz> Lo C, '1�1 C, 0t lzt c:l to Lo o �2 In oo c, 0 c) of C) C� CD C, rS <=I C> O =1 CD of 04 CD CD ,Q: CD I All rS Cl) C� C) O C) O O O C, C� aD O -4 cri C> al a) 0 (n C-4 C14 C14 el >1 Ci C) "qi Ci -t 4 O 10 al C:� C) C) C) 00 CD Ml MY it O O 0 0 0 Iz, 0 o Q) o 0 Q> 0 0 0 0 0 0 cn, Iz, 0 0 0 Q> Q, (Z' 0 0 0 0 Z) 0 0 0 0 0 ci Qi ci 0t Qi Qi Qi 0 1 lz> Lo C, '1�1 C, 0t lzt c:l to Lo o �2 In oo c, 0 c) of C) C� CD C, rS <=I C> O =1 CD of 04 CD CD ,Q: CD I All O 41 rS Cl) C� C) C) C, C� aD C> al a) Ci "qi Ci -t O 10 al C:� C) C) C) 00 CD Ml ,::i Ci r-_ co r- a) C> C) C) C CCi CD C = a� C� a LO a) C) C) 04 O to m C) cy) m cN iy C> (D C) cD C:. C) C) ID Lo �R Lc) Lo C) C> C) C=3 C) C, O C) P- to 2 E O (N a E u) 2 tm C-) ID o m m -cL ol a 7FD Lu u) cr) (D C) 0- (D D- C/) cc ca cc (D o • W -2 O CL z cu CL co M m (L cc CL 0 cc co Q_ m a cc co a CL o IL -a a- w L� o m o LL = a co co E a co a cu = cu t— pq Q� rL a- o o c', E E o- E E E So - Lan So 8 8 o- If, -.o Q) CD a) (D (D 'o cz -6 -a -a m > > > co cu LL u- LLJ LL u- LL m co m rn m m 2 C/) U) U) co w IL _j J O 41 Q, cz, C) I::, Q, 0 0 0 C> 0 Z> 0 O C, o 0 0 0 C, C, Q, c> 0 Q, Iz, <Zl 0 C, 0 0 C, 0 Z) 0 o 0 c) rS 6 c, z, c, ::) 0 'S 'S Z, 'S (S 'S 6 6 C> cS C, 0 CS CS (:S 'S 6 (S 0 ES 6 cz, Z) CS C� Q, (c� V- 03 qti Ci QCL Lri "I O O ICI O O a, O O N N 10 h � 10 C) C� cz, 1q. C� to oi �6 0, (ZS C� cn oi Z Q; P-7 16 lq� o6 N� IZ co 0) 171) 5 c6 of cs g g� g �3 'n cn 'It- lo - "I, co cc cn c� c� w) co VJ O cD cD "Imi cl� Lo to cN c�l cD c) cl� Ci cli cli r- to C) cD cD c) C> cz, ci r\-; C� ?-- cLo li C) C> c> c) C) Lri of t c:D m c C C D C D c D c cD OL cc (::� --L o ti C) cN r-_ c\j cD c> 0 M m <D O Cl O O c�l Cl C) cD c) �-i (q -ci ci OL LC) m a) c) co co C) cD cD O c) cD C) cD c� c) cD I=i Lq ci Lo c) c� cy) m ai 6 m cD cn cD C) O <D �-) C) 00 cl: c) i ccD cD q OIL Lr cD � C:i c� r- I- O V c) to O O cz) C> cD ti O ID C) OIL Ci tc� oo -t 04 04 c> 04 O cD o c> cD O C> C) C, C) C) cD lD cD c> cD cD cD O C) C) C) O cD cz� C:� cl) c� cq ti LQ c� c� c) zt Lo V co Lx) cl) (N oo cD O cN M oo Ir u") m 04 - - to - - - - - - - - fi � d, .o cl) co (D 2 co u co 'a cD cu (D w C') 2 < E acs m E ai co EL EL co u) 'El o co 2 0 Z (D = J. 'D 5 (D cO E Q. (D 2 , c, cn m :t-- o 3: ozs c, uj ca D M 'o a) LL c, c, *9 o -j Z5 Nrl 11 0 a) 2 a) m E E c-) 2 E -0 2 f -cL c, x . I (D N Z6 c M �5 o = R o E E en cL E c', ca E -om o D 2 c, 2 c) o :E om 2 2 cD o V1 H Lu u) m m co D- m co 0 C/) F-- (D (D 2 E E: 0 (D a, _j c/) m 0 U¢¢ a: 2 OR O O O C, C, C) C� 1=1 <:) CI lz� Q� <�, C� 1:1 C:> cz, C) C, C� cl Q, Q) cl Q, C� lz� Z> cl C) C, lz� Q�l Q� CD Cl C�� cz, Q, C�l C) C� lz� Q, C) Q) Z> :� lz� cz� lz� 1� Q) QD C�� (Z> Q> C�l Q> C, CD C, Q, Q� C) Q�� Q) lz:� cz, C� 1� Q) Q� C� �-L C� c, C) c, Z) c) :�� c� 'Z� (Z:) cz> C, c� C�> c, C> C, c� Z� C, c> cz, c, C:� c::) c, c, c� C:�, (Z� �14 N N 16 � g -: g 6 g (zs 6 r,' T g O In `4- ID 10 C� In 't 10 10 CN 0) O O O co "ql C� �o CI CD 0 <D CD CD CD C) 00 cq C 11, Cl O C:) C:) C:) C:) 'Zi I=i CL C C::i Cl) M Ci O CD C> CD CD CD C) C) C) CD C� C� t-: Ci a; c"i C) C) C) C, C> C> CD C) C) CD C) C) C:� (=i Ci C� lz� (=� C:3 CY) CN (D Cl) (1) CD CO CD CD C) CD C:) C) v o => CD CD C) Cl C� C�l C:) O C� C:) �-> CD CD C) C> O lzi Ci Cl Ci C� C� Ci CD C14 (3) CDC, C�l C�� C� CD C) C) CD C Ci C� o LO IG; C) - - - - in in - - - - - - - in in in in - - - - - in - in in - - — — - - - - in - O 'Awn - - — - - - — - - — - - - 41: L 6 6 6 6 2 2 2 C2 C-� `(2� -Q� C-� �a C-� -CL C-� ca -,L -L - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - O CD e) CO -es cc a C, al (D C15 C co 06 0 0 0 v5 U ca z 'cu u co _0 (3) CD a) 0 > a) M ui (D --j �q -j -j OL M -0 = = � w < 0 --J cu 0 M 0 _ ~ m 2 CO -J c E E C, 0 E 72 (D E a) E 0 C-- a) ca x 0 CU CZ M m (D i5 m o cf) < 2 2E Co (D -j LU W 0 w 0 m m 0 -1 C5 w m w m S U U U U w \0 O O O Q'I O O O O (Z' C5 Q, 'S Q) 'S O CS C, CS O CS C, C5 Iz, 6 1=1 'S I=> (S C, CS O Q) IZ3 O C.> O c� 'Z� cz� zt Q� Qt Q� C) C�, �o L6 to 16 Q, C� tllz- L6 c6 co co CN C� � cc O Lo c::, � ol Lo �q O 1:5, ^ <N 03 "zi- N M C4 I:zl C�l CN cD Lo ti 2 2 O r N M Z O 0 CD ° Cl C) C> cz, 2 -0 (a (D CN co :3 0- cl) cq 0 C) 1=1 I a) CD C� Cf) c m O 0 9 lz� cl Cli C�i ff� 0"- m W CS -0 (N CN co -0 1 m m LO co o 0 C-4 V CD CD 0 C) 0 0 0 C�5 CD C�l CD C�l C� (� 0) CZ a, C� 0- —C M 0) M 0 lzi Ci C� CD G (5 Lp 04 Cf) w g co 0 LU Cl) LU CD (f) o I-- LU > o u Cl) 0) 'd, C) c> C:) c�� CD CF) CIT CD CD C=. IT 0) r— C"i to C� CD C�, C> C, C> O 06 LO 00 OQ C) 0 CD C> CD ca� W co o 0 c=, CD 0 0 C> =) c:, CD C:) C, C=, CD <:, C:) Ci 0 1 C 0- 0 Q a� L'I :::i C� C4 <Y (N n rl- C C> O O 'T CN r-_ C. CD CD C�l CD C:) CD C=l N czi cl� rl C=) 04 m 't - - - - - - - - - - — ct 5, N N N rn cc cc U) 0 c 0 0 3 w E a) CD U LU 0 C5 a) 0 (D > 0 co C, a) 0 -o M cu U __j Of d) (40 co ) (D 1 0 E a 0 0 m CZ M U) -6 > 2 CO can 0 LU w ui co O Q'I O O O co C, O O Q) O O Q) C> Iz, O O Lo cn O O O Q, O Z) n O O 10 O O C\4 O N Lo ti Ld c- O N N L6 L6 16 O 0 tllz- p 'n � t c-I Lo co R Cl "t � cc O Lo c::, � ol Lo O cD Lo 0 0 CO Cli D C D CD C C C c C cZi r- Lq cz:� O� c\! O cl� co C� co M t— C� Lo m C) m co co O LO r-� Cl) m tD Ci LO 04 co O o C) CD 2 2 O r N M Z 0 2 -0 (a (D CN co :3 0- O Cf) 0 I a) Cf) c m O 0 9 m 0 2 �2 0"- m W CS -0 co -0 1 m 0 0 co (D __j 0 C) 0 0 0 C�5 0 0) CZ a, 0- —C M 0) M 0 ol -0 ��: ,, �o CD G (5 U- Cf) w g co 0 LU Cl) LU CD (f) o I-- LU > o u O O O lz:) Q, O O O Q� cz, C, C� C� C� QD C, C�l cz, C�l C�l C� C) C) Q, C� C> C.� lz� Q> (�L LO '14� Q> c) :3 :� Q> cz� Q�, c� 4-, Q> to Q, c� c> <:D ::) c� C> Lc> lz� 12:� cl Lo C, �-T C� L6 C, L6 Q, L6 lz� �6 C, Lo lz� L6 cz� L6 to cq (z3 (zs t cz� cl c:, Q� c� Q� Q� c�l Q) Lri C, Q! c:3 z� lz�� V' tl-� Lry Lo '3- t, a, (c m ol m N, O 7t cD CD 00 cD °o cD ° c) O cD cD cD O c--) O cD f.- O Cl m (D (D Ci = c_ Cl Iri lo ° C) cD Cl M = C) cD c, L cz! O (N Lo cli O cD c> cD tD c�l c� =� LO C� — w) lz:i O 04 C! O r- cz� C) Lo cD c) c�l w) Lo cD c�� In "ti ci (:::i C:� "It, "'t C:� :::i ci I:t C) cN Lo cli cD C) �D C) M cy) oo a) m to cN cD cD Ci O O r--• c:l Cl =� O (:D Ci C) cD Ci O c> p-:, O O c) O Ci C) cD :::i Cl cD Ci c> cD Ct c � O O of cD LC) LO oo cD C) N C) C) 04 r LO v (.o Cl) rn rl_ o) cl) CY i. -mm L. Eli cD 00 CD m co U) o 7t-- c, w cD c14 o I'D m c) In co > t— u� lz� m m (D cL •cEl o o o) $2 o .2 -zr ❑ 4) C-) C) E- (D �>- m I I w r1] cB -E Q O (D Le (D 0 m- E (D a) (D 'vo- Q3 ED E (D -o o D) cy) D) D) o- c) o W M c*-1 w cc EL 2 :E rL 1�5 m m D 2 o o Z - (A 2 E o F- w co 3: c) O n- (D ?: Ln U) U) 5) c) c) u m o Lu o Lu o c> cu V co 45 o 7j Z) ED ::D E , a m cf) m co m m U) 0 ZD 0' U) 5 xm _j -j . -1 3o: O O �ILLOJJ O ct O O O ri O 00 ti O O O Q, C C, Q Q, C C, I Iz, O O O O o o c cz, C C:, O O O O C C. lz� 1:2) C C�� C C�� Z Z) C C�l l lz� Q QD C C�� Z Z, Z Z, 0 00 0 0 m m IZT 06 L L6 c cl h h C 1� c co CIQ 2 1 0 I o I CD co -M co CO Ci m co °o °0 C, C:) C> I= ci C co Lo q. CD c::i Iri oo cn C) C> Lo cli cD cl c-_, c. cD C> c�l Ci I=i C�i O lC> c� cD 10 m N W) cN M cN I-i cD In I=i ci :::i m m co � N cN co O C) zi; M IT-0 yyy o 23" m. 2 > m 0 o -j 0 m C�5 a) 3:-j 'I) M-Omw 12 W- = 3: E 0- = 0 0 = -a 2 2 m E -Fz co 2 > E Vd o l O O CL IT-0 yyy o 23" m. 2 > m 0 o -j 0 m C�5 a) 3:-j 'I) M-Omw 12 W- = 3: E 0- = 0 0 = -a 2 2 m E -Fz co 2 > E Vd o l O O CL O O CL GENERAL FUND BUDGET SUMMARY M Requested Actual Actual Actual Budget YTD Budget Percent Dollar 2013 2014 2015 2016 2016 2017 Change Change REVENUES TAXES 4,764,472 4,864,671 4,949,125 5,079,408 1,843,200 5,180,996 2.0% 101,588 LICENSES & PERMITS 204,575 271,510 275,567 169,180 - 209,180 23.6% 40,000 INTERGOVERNMENTAL 96,549 122,606 103,795 90,751 80,455 90,751 0.0% - CHARGES FOR SERVICES 33,194 - 58,786 42,200 33,996 42,200 0.0% FINES & FORFEITURES 59,294 - 65,084 60,000 14,141 60,000 0.0% MISCELLANEOUS REVENUE 205,010 253,773 263,137 210,400 130,818 210,400 0.0% TRANSFERS 317,182 25,000 25,000 25,000 - 25,000 0.0% - TOTAL REVENUES 5,680,276 5,537,560 5,740,494 5,676,939 2,102,610 5,818,527 2.5% 141,588 EXPENDITURES CITY COUNCIL Personnel 16,794 16,794 22,176 22,600 11,088 22,600 0.0% - Materials and Supplies 2,035 1,014 1,751 2,000 676 2,000 0.0% Support Services and Charges 90,885 51,414 55,459 133,500 65,668 116,500 -12.7% (17,000) Transfers 91,700 369,170 70,000 70,000 - 70,000 0.0% Total City Council 201,414 438,392 149,386 228,100 77,432 211,100 -7.5% (17,000) Administration Personnel 240,032 249,927 247,462 414,154 119,660 402,154 -2.9% (12,000) Materials and Supplies 15,649 17,852 13,288 20,900 7,444 20,900 0.0% Support Services and Charges 134,401 140,953 143,038 42,550 69,302 42,550 0.0% Total City Administration 390,082 408,732 403,788 477,604 196,406 465,604 -2.5% (12,000) FINANCE Personnel 137,469 138,464 142,782 142,273 74,097 142,273 0.0% - Materials and Supplies 8,547 15,415 19,253 14,600 8,363 15,600 6.8% 1,000 Support Services and Charges 14,619 14,191 - 15,900 13,739 15,900 0.0% - Total Finance 160,635 168,070 162,035 172,773 96,199 173,773 0.6% 1,000 PROFESSIONAL SERVICES Support Services and Charges 199,042 207,153 200,096 226,400 90,628 232,400 2.7% 6,000 Total Professional Services 199,042 207,153 200,096 226,400 90,628 232,400 2.7% 6,000 PLANNING Personnel 181,143 182,641 183,568 178,797 94,594 178,797 0.0% - Materials and Supplies 292 303 423 300 407 300 0.0% Support Services and Charges 7,684 14,459 18,589 12,000 6,302 12,000 0.0% Total Planning 189,119 197,403 202,580 191,097 101,303 191,097 0.0% MUNICIPAL BUILDINGS Materials and Supplies 60,118 56,990 54,591 21,300 4,305 21,300 0.0% Support Services and Charges 141,227 86,857 100,370 174,800 120,027 174,800 0.0% Capital - - - - - - Transfers 100,450 103,950 101,513 104,313 - 104,313 0.0% Total Municipal Buildings 301,795 247,797 256,474 300,413 124,332 300,413 0.0% Total General Government 1,442,087 1,667,546 1,374,359 1,596,387 686,300 1,574,387 -1.4% (22,000) less transfers (192,150) (473,120) (171,513) (174,313) - (174,313) Net General Government 1,249,937 1,194,426 1,202,846 1,422,074 686,300 1,400,074 POLICE Materials and Supplies - - - - 2,086 - - SupportServices and Charges 1,018,680 1,051,134 1,082,129 1,106,165 - 1,180,050 6.7% 73,885 Capital 227,764 229,764 225,180 230,000 107,166 214,000 -7.05/. (16,000) Total Police 1,246,444 1,280,898 1,307,309 1,336,165 109,252 1,394,050 4.3% 57,885 M GENERAL FUND BUDGET SUMMARY FIRE Support Services and Charges Capital Total Fire PROTECTIVE INSPECTIONS Personnel Materials and Supplies Support Services and Charges Total Protective Inspections Total Public Safety CITY ENGINEER Personnel Materials and Supplies Support Services and Charges Total City Engineer PUBLIC WORKS SERVICES Personnel Materials and Supplies Support Services and Charges Capital Transfers Total Public Works Services SNOW AND ICE CONTROL Personnel Materials and Supplies Total Snow and Ice Control Total Streets & Highways less transfers Net Streets & Highways PARKS MAINTENANCE Personnel Materials and Supplies Support Services and Charges Total Parks Maintenance RECREATION Personnel Materials and Supplies Support Services and Charges Transfers Total Recreation Total Recreation less transfers Net Recreation GENERAL FUND TOTAL EXPENDITURES NET OVER /(UNDER) (Planned Use of Fund Balance) 460 - - 612 - - - - 68,690 72,181 91,100 89,725 11,280 89,725 0.0% 69,150 72,793 91,100 89,725 11,280 89,725 0.0% 434,212 344,742 381,502 516,365 160,972 Requested 0.0% 4,818 Actual Actual Actual Budget YTD Budget Percent Dollar 2013 2014 2015 2016 2016 2017 Change Change 772,500 800,000 830,000 860,000 - 890,000 3.5% 30,000 345,728 348,788 360,644 369,714 184,193 372,976 019% 3,262 287,655 278,423 276,156 270,620 135,310 256,648 -5.2% (13,972) 633,383 627,211 636,800 640,334 319,503 629,624 -1.7% (10,710) 123,411 117,530 126,299 126,299 67,029 126,299 0.0% - - 157 73 200 245 200 0.0% 30,000 6,813 6,176 9,887 8,050 2,736 8,050 0.0% (30,000) 130,224 123,863 136,259 134,549 70,010 134,549 0.0% - 2,010,051 2,031,972 2,080,368 2,111,048 498,765 2,158,223 2.2% 47,175 460 - - 612 - - - - 68,690 72,181 91,100 89,725 11,280 89,725 0.0% 69,150 72,793 91,100 89,725 11,280 89,725 0.0% 434,212 344,742 381,502 516,365 160,972 516,365 0.0% 4,818 141,763 132,205 103,882 163,000 48,783 163,000 0.0% 6,185 105,845 95,277 103,058 131,100 52,816 131,100 0.0% 42,000 772,500 800,000 830,000 860,000 - 890,000 3.5% 30,000 1,454,320 1,372,224 1,418,442 1,670,465 262,571 1,700,465 1.8% 30,000 56,862 61,363 26,537 61,465 18,407 61,465 0.0% - 44,835 34,444 16,229 44,000 4,179 44,000 0.0% 101,697 95,807 42,766 105,465 22,586 105,465 0.0% - 1,625,167 1,540,824 1,552,308 1,865,656 296,437 1,895,656 1.6% 30,000 (772,500) (800,000) (830,000) (860,000) - (890,000) 3.5% (30,000) 852,667 740,824 722,308 1,005,656 296,437 1,005,656 82,222 121,626 150,919 115,022 86,226 115,022 0.0% 18,908 15,610 17,907 23,300 13,436 23,300 0.0% 38,816 35,537 35,492 40,500 13,432 40,500 0.0% 139,946 172,773 204,318 178,822 113,094 178,822 0.0% 51,296 42,666 43,414 41,575 21,852 41,575 0.0% 4,818 7,496 5,739 7,700 1,354 7,700 0.0% 13,051 6,185 4,640 13,900 6,694 13,900 0.0% 42,000 42,000 42,000 42,000 - 42,000 0.0% 111,165 98,347 95,793 105,175 29,900 105,175 0.0% 251,111 271,120 300,111 283,997 142,994 283,997 0.0% (42,000) (42,000) (42,000) (42,000) - (42,000) 209,111 229,120 258,111 241,997 142,994 241,997 5,328,415 5,511,462 5,307,146 5,857,087 1,624,496 5,912,262 0.9% 55,175 351,860 26,098 433,348 (180,148) 478,114 (93,735) -48.0% 86,413 -10- GENERAL FUND REVENUE DETAIL TOTAL REVENUES 5,680,276 5,740,494 5,676,939 2,102,610 5,818,527 2.5% 141,588 - 11 - Requested Actual Actual Actual Budget YTD Budget Percent Dollar 2013 2014 2015 2016 2016 2017 Change Change REVENUES TAXES 3010 GENERAL PROPERTY TAX 4,617,654 4,700,227 4,783,935 5,079,408 1,843,200 5,180,996 2.0% 101,588 3011 DELINQUENT AD VALOREM TAXES 43,292 52,737 41,556 3100 FISCAL DISPARITIES 103,526 111,707 123,634 TOTAL TAXES 4,764,472 4,864,671 4,949,125 5,079,408 1,843,200 5,180,996 2.0% 101,588 LICENSES & PERMITS 3211 LIQUOR LICENSES 8,820 9,630 1,430 1,430 1,430 1,430 0.0% - 3212 TOBACCO LICENSES 1,250 1,250 1,250 500 100 500 0.0% 3215 REFUSE COLLECTION LICENSES 1,525 25 3216 TREE TRIMMING LICENSES 570 390 840 500 310 500 0.0% 3217 RENTAL HOUSING LICENSES 1,140 1,260 1,020 1,000 900 1,000 0.0% 3218 OTHER BUSINESS LICENSES AND PE 7,892 4,118 1,244 3,500 674 3,500 0.0% - 3221 BUILDING PERMITS 146,256 196,952 198,164 130,000 84,337 160,000 23.1% 30,000 3222 PLAN CHECK FEES 36,357 55,841 66,151 30,000 25,350 40,000 33.3% 10,000 3223 DOG LICENSES . 2,140 1,814 3,643 2,000 1,193 2,000 0.0% - 3224 FARM ANIMAL 150 255 300 250 125 250 0.0% - TOTAL LICENSES & PERMITS 204,575 271,510 275,567 169,180 209,180 23.6% 40,000 INTERGOVERNMENTAL 3314 BULLET -PROOF VEST GRANT 247 537 1,590 500 2,011 500 - 3316 FEMA STORM DISASTER AID - 3341 LOCAL PERFORMANCE AID 1,041 1,053 1,040 1,000 1,000 0.0% 3343 MKT VALUE CREDIT AID 26 44 49 3344 PERA AID 4,751 4,751 4,751 4,751 4,751 0.0% 3345 MUNICIPAL STATE AID FOR STREET 70,479 73,685 84,206 73,000 44,011 73,000 0.0% 3362 GRANTS 20,005 42,536 12,159 11,500 34,433 11,500 0.0% TOTAL INTERGOVERNMENTAL 96,549 122,606 103,795 90,751 80,455 90,751 0.0% CHARGES FOR SERVICES 3400 CHARGES FOR SERVICES - 3413 ZONING AND SUBDIVISION FEES 5,070 11,374 10,812 4,500 9,685 4,500 0.0% 3414 PASS -THRU CHARGES (9,034) 2,927 - 1,500 - 3415 SALE OF COPIES 220 376 311 500 66 500 0.0% 3417 SPECIAL ASSESSMENT SEARCHES 200 100 200 200 25 200 0.0% 3471 RECREATION RENTALS 1,524 29,504 33,925 1,500 18,503 1,500 0.0% 3472 TREE SALES - 6,957 1,925 3473 PARK PROGRAMS 32,844 1,741 404 32,000 1,073 32,000 0.0% 3474 ARCTIC FEVER /PRINCESS TEA 2,370 4,575 3,250 3,500 1,219 3,500 0.0% TOTAL CHARGES FOR SERVICES 33,194 58,786 42,200 33,996 42,200 0.0% FINES & FORFEITURES 3510 FINES & FORFEITS 59,294 64,289 65,084 60,000 14,141 60,000 0.0% TOTAL FINES & FORFEITURES 59,294 65,084 60,000 14,141 60,000 0.0% MISCELLANEOUS REVENUE 3620 INTEREST EARNINGS 12,902 50,487 18,897 35,000 27 35,000 0.0% 3623 CONTRIBUTIONS AND DONATIONS FR 700 300 300 3624 REFUNDS & REIMBURSEMENTS 46,838 29,797 62,507 10,000 62,305 10,000 0.0% 3626 DRY HYDRANT CHARGES 2,436 940 - - 3627 CELLULAR ANTENNA REVENUE 132,996 170,927 177,215 150,000 68,211 150,000 0.0% 3670 MISCELLANEOUS REVENUE 9,138 2,262 3,278 15,400 275 15,400 0.0% TOTAL MISCELLANEOUS REVENUE 205,010 253,773 263,137 210,400 130,818 210,400 0.0% TRANSFERS 3910 TRANSFERS FROM OTHER FUNDS 317,182 25,000 25,000 25,000 25,000 0.0% TOTAL TRANSFERS 317,182 25,000 25,000 25,000 - 25,000 0.0% TOTAL REVENUES 5,680,276 5,740,494 5,676,939 2,102,610 5,818,527 2.5% 141,588 - 11 - CITY COUNCIL General Coding: 101 -11- MATERIALS & SUPPLIES 4245 GENERAL SUPPLIES 2,035 1,014 1,751 2,000 676 Requested 0.0% TOTAL MATERIALS & SUPPLIES Actual Actual Actual Budget YTD Budget Percent Dollar PERSONAL SERVICES 2013 2014 2015 2016 2016 2017 Change Change 4103 PART -TIME 15,600 15,600 20,600 21,000 10,300 21,000 0.0% 4122 FICA CONTRIB - CITY SHARE 1,194 1,194 1,576 1,600 788 1,600 0.0% TOTAL PERSONAL SERVICES 16,794 16,794 22,176 22,600 11,088 22,600 0.0% MATERIALS & SUPPLIES 4245 GENERAL SUPPLIES 2,035 1,014 1,751 2,000 676 2,000 0.0% TOTAL MATERIALS & SUPPLIES 2,035 1,014 1,751 2,000 676 2,000 0.0% SUPPORT SERVICES /CHARGES 4302 CONSULTING FEES - 4331 TRAVEL, CONFERENCE & SCHOOLS 3,214 1,713 11,191 4,500 1,051 4,500 0.0% 4400 CONTRACTUAL SERVICES 41,176 750 655 50,000 46,801 - (50,000) 4433 DUES AND SUBSCRIPTIONS 41,495 48,951 43,613 52,000 17,816 52,000 0.0% - 4440 MISC SERVICES 5,000 - 27,000 60,000 122.2% 33,000 TOTAL SUPPORT SERVICES /CHARGES 90,885 51,414 55,459 133,500 65,668 116,500 -12.7% (17,000) TRANSFERS 4820 OPERATING TRANSFERS 91,700 369,170 70,000 70,000 70,000 0.0% TOTALTRANSFERS 91,700 369,170 70,000 70,000 70,000 0.0% TOTAL COUNCIL 201,414 438,392 149,386 228,100 77,432 211,100 -7.5% (17,000) -12- ADMINSTRATION General Coding: 101 -13- -13- Requested Actual Actual Actual Budget YTD Budget Percent Dollar PERSONAL SERVICES 2013 2014 2015 2016 2016 2017 Change Change 4101 FULL -TIME REGULAR 141,783 200,435 181,408.00 304,996 83,108 304,996 0.0% 4102 FULL -TIME OVERTIME - 4103 PART -TIME 29,170 10,585 5,258.00 25,000 4,099 13,000 -48.0% (12,000) 4121 PERA /iCMA CONTRIB - CITY SHARE 12,070 13,063 13,296.00 22,962 6,233 22,962 0.0% 4122 FICA CONTRIB - CITY SHARE 12,640 13,882 13,693.00 24,327 6,493 24,327 0.0% 4131 EMPLOYEE INSURANCE - CITY SHARE 29,993 11,131 32,604.00 36,869 18,869 36,869 0.0% 4141 UNEMPLOYMENT COMPENSATION 14,376 151 WORKERS COMPENSATION - 831 1,203.00 858 TOTAL PERSONAL SERVICES 240,032 249,927 247,462 414,154 119,660 402,154 -2.9% (12,000) MATERIALS & SUPPLIES 4200 OFFICE SUPPLIES 3,844 3,904 2,134.00 5,000 1,896 5,000 0.0% 4208 POSTAGE 10,857 11,306 7,901.00 11,000 5,184 11,000 0.0% 4221 MAINTENANCE OF EQUIPMENT - 2,121 2,785.00 4,000 348 4,000 0.0% 4245 GENERAL SUPPLIES 948 521 468.00 900 16 900 0.0% TOTAL MATERIALS & SUPPLIES 15,649 17,852 13,288 20,900 7,444 20,900 0.0% SUPPORT SERVICES /CHARGES 4321 COMMUNICATIONS - TELEPHONE 565 0.00 900 - 900 4331 TRAVEL, CONFERENCE & SCHOOLS 4,478 4,967 4,195.00 7,000 3,056 7,000 0.0% 4351 PRINTING AND PUBLISHING 794 2,271 1,319.00 2,000 371 2,000 0.0% 4400 CONTRACTUAL SERVICES 128,239 132,311 137,085.00 32,000 65,470 32,000 0.0% 4433 DUES AND SUBSCRIPTIONS 325 945 439.00 650 405 650 0.0% 4440 MISC SERVICES - 459 TOTAL SUPPORT SERVICES /CHARGES 134,401 140,953 143,038 42,550 69,302 42,550 0.0% CAPITAL OUTLAY 4240 MACHINERY & EQUIPMENT TOTAL CAPITAL OUTLAY - - - - - TOTAL ADMINISTRATION 390,082 408,732 403,788 477,604 196,406 465,604 -2.5% (12,000) -13- FINANCE General Coding: 101 -15- TOTAL FINANCE 160,635 168,070 162,035 172,773 96,199 173,773 0.6% 1,000 -14- Requested Actual Actual Actual Budget YTD Budget Percent Dollar PERSONAL SERVICES 2013 2014 2015 2016 2016 2017 Change Change 4101 FULL -TIME REGULAR 108,488 117,608 112,461 112,021 57,149 112,021 0.0% 4121 PERA CONTRIB - CITY SHARE 7,782 7,961 8,400 8,122 4,286 8,122 0.0% 4122 FICA CONTRIB - CITY SHARE 7,750 8,081 8,078 8,570 4,092 8,570 0.0% 4131 EMPLOYEE INSURANCE - CITY SHARE 13,449 4,288 13,067 13,560 8,242 13,560 0.0% 4151 WORKERS COMPENSATION 526 776 328 TOTAL PERSONAL SERVICES 137,469 138,464 142,782 142,273 74,097 142,273 0.0% MATERIALS & SUPPLIES 4200 OFFICE SUPPLIES 37 2,002 872 600 837 600 0.0% 4221 MAINTENANCE OF EQUIPMENT 8,078 13,413 18,381 14,000 7,526 15,000 7.1% 1,000 4245 GENERALSUPPLIES 432 - - - #DIV /0! TOTAL MATERIALS & SUPPLIES 8,547 15,415 19,253 14,600 8,363 15,600 6.8% 1,000 SUPPORT SERVICES /CHARGES 4301 AUDITING & ACCOUNTING SERVICES 2,066 5,880 10,520 3,600 3,600 0.0% - 4331 TRAVEL, CONFERENCE & SCHOOLS 4,440 2,343 1,706 4,000 1,168 4,000 0.0% 4351 PRINTING AND PUBLISHING 2,246 610 - 900 109 900 0.0% 4400 CONTRACTUAL SERVICES - - 1,000 8,775 1,000 0.0% 4330 DUES AND SUBSCRIPTIONS 220 247 280 400 220 400 0.0% 4440 MISCSERVICES - 52 4450 BANK SERVICE CHARGES 5,647 5,059 7,714 6,000 3,467 6,000 0.0% TOTAL SUPPORT SERVICES /CHARGES 14,619 14,191 15,900 13,739 15,900 0.0% TOTAL FINANCE 160,635 168,070 162,035 172,773 96,199 173,773 0.6% 1,000 -14- PROFESSIONAL SERVICES General Coding: 101 -16- TOTAL PROFESSIONAL SERVICES 199,042 207,153 200,096 226,400 90,628 232,400 2.7% 6,000 6M Requested Actual Actual Actual Budget YTD Budget Percent Dollar SUPPORT SERVICES /CHARGES 2013 2014 2015 2016 2016 2017 Change Change 4301 AUDITING & ACCOUNTING SERVICES 23,225 22,030 21,700 27,000 6,000 28,000 3.7% 1,000 4304 CIVIL LEGAL CONTRACT 40,000 36,090 - 44,400 44,400 0.0% - 4304 PROSECUTION CONTRACT 33,360 42,614 65,623 38,000 26,128 38,000 0.0% - 4400 CONTRACTUAL ASSESSOR SERVICES 102,457 106,419 112,773 117,000 58,500 122,000 4.3% 5,000 4440 MISC SERVICES - - TOTAL SUPPORT SERVICES /CHARGES 199,042 207,153 200,096 226,400 90,628 232,400 2.7% 6,000 TOTAL PROFESSIONAL SERVICES 199,042 207,153 200,096 226,400 90,628 232,400 2.7% 6,000 6M PLANNING General Coding: 101 -18- -16- Requested Actual Actual Actual Budget YTD Budget Percent Dollar PERSONAL SERVICES 2013 2014 2015 2016 2016 2017 Change Change 4101 FULL -TIME REGULAR 103,497 153,144 138,835 139,240 69,052 139,240 0.0% 4103 PART -TIME 37,719 - 4121 PERA CONTRIB - CITY SHARE 10,065 10,069 10,355 10,095 5,179 10,095 0.0% 4122 FICA CONTRIB - CITY SHARE 9,440 9,801 10,314 10,652 5,233 10,652 0.0% 4131 EMPLOYEE INSURANCE - CITYSHAR 20,422 8,851 22,885 18,810 14,706 18,810 0.0% 4151 WORKERS COMPENSATION - 776 1,179 424 TOTAL PERSONAL SERVICES 181,143 182,641 183,568 178,797 94,594 178,797 0.0% MATERIALS & SUPPLIES 4200 OFFICE SUPPLIES 292 234 7 4221 MAINTENANCE OF EQUIPMENT - - 400 400 4245 GENERALSUPPLIES - 69 23 300 300 0.0% TOTAL MATERIALS & SUPPLIES 292 303 423 300 407 300 0.0% SUPPORT SERVICES /CHARGES 4304 LEGAL FEES 5,402 13,863 4321 COMMUNICATIONS - CELLULARPHON 869 1,019 666 1,000 303 1,000 0.0% 4331 TRAVEL, CONFERENCE & SCHOOLS 1,770 2,868 1,803 4,200 1,107 4,200 0.0% 4351 PRINTING AND PUBLISHING 1,070 1,346 1,624 1,200 758 1,200 0.0% 4400 CONTRACTUAL SERVICES 2,850 2,830 - 4,400 3,466 4,400 0.0% 4433 DUES AND SUBSCRIPTIONS 1,125 994 633 1,200 668 1,200 0.0% TOTAL SUPPORT SERVICES /CHARGES 7,684 14,459 18,589 12,000 6,302 12,000 0.0% CAPITAL OUTLAY 4240 FURNITURE AND FIXTURES - - TOTAL CAPITAL OUTLAY - - - - - TOTAL PLANNING 189,119 197,403 202,580 191,097 101,303 191,097 0.0% -16- MUNICIPAL BUILDINGS General Coding: 101 -19- CAPITAL OUTLAY 4240 BUILDINGS & STRUCTURES 4240 MACHINERY & EQUIPMENT TOTAL CAPITAL OUTLAY TRANSFERS 4820 OPERATING TRANSFERS 100,450 103,950 101,513 104,313 104,313 0.0% TOTAL TRANSFERS 100,450 103,950 101,513 104,313 - 104,313 0.0% TOTAL MUNICIPAL BUILDINGS 301,795 247,797 256,474 300,413 124,332 300,413 0.0% -17- Requested Actual Actual Actual Budget YTD Budget Percent Dollar MATERIALS & SUPPLIES 2013 2014 2015 2016 2016 2017 Change Change 4221 MAINTENANCE OF EQUIPMENT 30,248 43,654 48,474 9,000 1,431 9,000 0.0% 4223 MAINTENANCE OF BUILDINGS 27,900 11,620 4,558 10,300 1,819 10,300 0.0% 4245 GENERAL SUPPLIES 1,970 1,716 1,559 2,000 1,055 2,000 0.0% TOTAL MATERIALS & SUPPLIES 60,118 56,990 54,591 21,300 4,305 21,300 0.0% SUPPORT SERVICES /CHARGES 4302 CONSULTING FEES 4321 COMMUNICATIONS - Warner Connect 38,592 5,747 3,670 38,000 19,167 38,000 0.0% 4331 TRAVEL, CONFERENCE & SCHOOLS 16 - - 4360INSURANCE 82,680 56,488 71,404 116,000 83,340 116,000 0.0% 4361 INSURANCE DEDUCTIBLE 3,373 7,500 4380 UTILITYSERVICES 8,601 7,954 7,045 10,000 10,576 10,000 0.0% 4400 CONTRACTUAL SERVICES 10,018 12,285 9,870 9,800 6,550 9,800 0.0% 4410 RENTALS 1,320 1,010 881 1,000 394 1,000 0.0% TOTAL SUPPORT SERVICES /CHARGES 141,227 86,857 100,370 174,800 120,027 174,800 0.0% CAPITAL OUTLAY 4240 BUILDINGS & STRUCTURES 4240 MACHINERY & EQUIPMENT TOTAL CAPITAL OUTLAY TRANSFERS 4820 OPERATING TRANSFERS 100,450 103,950 101,513 104,313 104,313 0.0% TOTAL TRANSFERS 100,450 103,950 101,513 104,313 - 104,313 0.0% TOTAL MUNICIPAL BUILDINGS 301,795 247,797 256,474 300,413 124,332 300,413 0.0% -17- POLICE General Coding: 101-21 - Requested Actual Actual Actual Budget YTD Budget Percent Dollar MATERIALS & SUPPLIES 2013 2014 2015 2016 2016 2017 Change Change 4245 GENERAL SUPPLIES 2086 TOTAL MATERIALS & SUPPLIES - - - - 2,086 - SUPPORT SERVICES /CHARGES 4380 UTILITY SERVICES 4400 CONTRACTUAL SERVICES 1,015,403 1,044,738 1,079,556 1,103,665 552,620 1,177,550 6.7% 73,885 4440 MISC SERVICES 3,277 6,396 2,573 2,500 1,083 2,500 0.0% - TOTAL SUPPORT SERVICES/CHARGES 1,018,680 1,051,134 1,082,129 1,106,165 1,180,050 6.7% 73,885 CAPITAL OUTLAY 4620 BUILDINGS & STRUCTURES 227,764 229,764 225,180 230,000 107,166 214,000 -7.0% (16,000) TOTAL CAPITAL OUTLAY 227,764 229,764 225,180 230,000 107,166 214,000 -7.0% (16,000) TOTAL POLICE PROTECTION 1,246,444 1,280,898 1,307,309 1,336,165 109,252 1,394,050 4.3% 57,885 FIRE General Coding: 101 -22- TOTAL FIRE PROTECTION 633,383 627,211 636,800 637,471 640,334 319,503 629,624 -1.7% (10,710) -19- Requested Actual Actual Actual Budget Budget YTD Budget Percent Dollar SUPPORT SERVICES /CHARGES 2013 2014 2015 2015 2016 2016 2017 Change Change 4400 Excelsior Fire 320,728 325,215 337,315 337,315 344,714 172,357 347,976 0.9% 3,262 4400 Mound Fire Contract 25,000 23,573 23,329 24,000 25,000 11,836 25,000 0.0% - TOTAL SUPPORT SERVICES/CHARGES 345,728 348,788 360,644 361,315 369,714 184,193 372,976 0.9% 3,262 CAPITAL OUTLAY 4620 BUILDINGS & STRUCTURES 287,655 278,423 276,156 276,156 270,620 135,310 256,648 -5.2% (13,972) TOTAL CAPITAL OUTLAY 287,655 278,423 276,156 276,156 270,620 135,310 256,648 -5.2% (13,972) TOTAL FIRE PROTECTION 633,383 627,211 636,800 637,471 640,334 319,503 629,624 -1.7% (10,710) -19- PROTECTIVE INSPECTIONS General Coding: 101 -24- TOTAL PROTECTIVE INSPECTIONS 130,224 123,863 136,259 134,549 70,010 134,549 0.0% -20- Requested Actual Actual Actual Budget YTD Budget Percent Dollar PERSONAL SERVICES 2013 2014 2015 2016 2016 2017 Increase Change 4101 FULL -TIME REGULAR 88,725 102,115 99,993 97,519 52,857 97,519 0.0% 4102 PART -TIME 6,468 4121 PERA CONTRIB - CITY SHARE 6,588 3,925 7,462 7,070 3,964 7,070 0.0% 4122 FICA CONTRIB - CITY SHARE 6,188 6,263 6,390 7,460 3,362 7,460 0.0% 4131 EMPLOYEE INSURANCE - CITY SHARE 15,442 4,500 11,400 14,250 6,500 14,250 0.0% 4151 WORKERS COMPENSATION 727 1,054 346 TOTAL PERSONAL SERVICES 123,411 117,530 126,299 126,299 67,029 126,299 0.0% MATERIALS & SUPPLIES 4200 OFFICE SUPPLIES - 157 4245 GENERALSUPPLIES - 73 200 245 200 0.0% TOTAL MATERIALS & SUPPLIES 157 73 200 245 200 0.0% SUPPORT SERVICES /CHARGES 4321 COMMUNICATIONS - CELLULAR PHONE - - 400 400 4331 TRAVEL, CONFERENCE & SCHOOLS 3,232 3,618 3,722 3,800 1,760 3,800 0.0% 4351 PRINTING AND PUBLISHING 161 263 210 200 66 200 0.0% 4400 CONTRACTUAL SERVICES 3,185 2,170 5,740 3,500 910 3,500 0.0% 4433 DUES AND SUBSCRIPTIONS 235 125 215 150 150 0.0% TOTAL SUPPORT SERVICES /CHARGES 6,813 6,176 9,887 8,050 2,736 8,050 0.0% TOTAL PROTECTIVE INSPECTIONS 130,224 123,863 136,259 134,549 70,010 134,549 0.0% -20- CITY ENGINEER General Coding: 101 -31- CAPITAL OUTLAY 4240 MACHINERY & EQUIPMENT TOTAL CAPITAL OUTLAY TOTAL CITY ENGINEER 69,150 72,793 91,100 89,725 11,280 89,725 0,0% -21- Requested Actual Actual Actual Budget YTD Budget Percent Dollar PERSONAL SERVICES 2013 2014 2015 2016 2016 2017 Change Change 4101 FULL -TIME REGULAR 406 4121 PERA CONTRIB - CITY SHARE 29 4122 FICA CONTRIB - CITY SHARE 25 4131 EMPLOYEE INSURANCE - CITY SHARE - TOTAL PERSONAL SERVICES 460 - MATERIALS & SUPPLIES 4200 OFFICE SUPPLIES - 612 4245 GENERALSUPPLIES - TOTAL MATERIALS & SUPPLIES - 612 - - - - SUPPORT SERVICES /CHARGES 4303 ENGINEERING FEES 21,817 22,734 43,100 38,625 3,280 38,625 0.0% 4321 COMMUNICATIONS - CELLULAR PHONE - - 4331 TRAVEL, CONFERENCE & SCHOOLS 130 4351 PRINTING AND PUBLISHING - - 4400 CONTRACTUAL SERVICES 45,110 49,447 48,000 49,500 8,000 49,500 0.0% 4410 RENTAL 57 - 4433 DUES AND SUBSCRIPTIONS 1,576 1,600 1,600 0.0% 4437 TAXES /LICENSES - - TOTAL SUPPORT SERVICES /CHARGES 68,690 72,181 91,100 89,725 11,280 89,725 0.0% CAPITAL OUTLAY 4240 MACHINERY & EQUIPMENT TOTAL CAPITAL OUTLAY TOTAL CITY ENGINEER 69,150 72,793 91,100 89,725 11,280 89,725 0,0% -21- PUBLIC WORKS General Coding: 101 -32- TOTAL PUBLIC WORKS 1,454,320 1,372,224 1,418,442 1,670,465 262,571 1,700,465 1.8% 30,000 -22- Requested Actual Actual Actual Budget WD Budget Percent Dollar PERSONAL SERVICES 2013 2014 2015 2016 2016 2017 Change Change 4101 FULL -TIME REGULAR 330,213 264,116 262,855 349,720 108,853 349,720 0.0% 4102 OVERTIME 2,607 4,985 2,040 2,500 1,172 2,500 0.0% 4103 PART -TIME 2,695 40,000 - 40,000 4105 STREET PAGER PAY 6,586 8,169 7,000 3,091 7,000 4121 PERA CONTRIB - CITY SHARE 23,811 18,329 20,408 28,255 8,484 28,255 0.0% 4122 FICA CONTRIB - CITY SHARE 23,911 18,358 19,467 30,540 8,472 30,540 0.0% 4131 EMPLOYEE INSURANCE - CITY SHARE 50,975 15,250 42,522 58,350 25,305 58,350 0.0% 4151 WORKERS COMPENSATION 17,118 26,041 5,595 TOTAL PERSONAL SERVICES 434,212 344,742 381,502 516,365 160,972 516,365 0.0% MATERIALS & SUPPLIES 4200 OFFICE SUPPLIES 26 862 633 300 235 300 0.0% 4212 MOTOR FUELS & LUBRICATION 46,760 48,703 26,634 51,000 8,542 51,000 0.0% 4221 MAINTENANCE OF EQUIPMENT 17,045 12,641 10,020 17,000 12,408 17,000 0.0% 4223 MAINTENANCE OF BUILDINGS 856 244 2,117 3,500 11 3,500 0.0% 4240 SMALL TOOLS AND MINOR EQUIPMENT 1,463 785 713 1,200 46 1,200 0.0% 4245 GENERALSUPPLIES 75,613 68,970 63,765 90,000 27,541 90,000 0.0% TOTAL MATERIALS & SUPPLIES 141,763 132,205 103,882 163,000 48,783 163,000 0.0% SUPPORT SERVICES /CHARGES 4303 ENGINEERING 2,525 4305 DRUG TESTING 904 491 50 1,800 50 1,800 0.0% 4321 COMMUNICATIONS - TELEPHONE 2,044 3,025 2,570 2,700 1,208 2,700 0.0% 4331 TRAVEL, CONFERENCE & SCHOOLS 3,208 95 150 6,500 741 6,500 0.0% 4380 UTILITY SERVICES 15,047 13,456 10,086 15,000 4,864 15,000 0.0% 4399 UTILITIES - STREETLIGHTS 41,846 41,348 40,180 43,000 15,105 43,000 0.0% 4400 CONTRACTUAL SERVICES 40,244 34,197 44,116 55,000 28,324 55,000 0.0% 4410 RENTALS 231 18 825 1,500 156 1,500 0.0% 4433 DUES AND SUBSCRIPTIONS 1,673 1,786 1,675 1,700 1,535 1,700 0.0% 4437 TAXES /LICENSES 529 789 534 900 833 900 0.0% 4440 MISC SERVICES 119 72 347 3,000 3,000 0.0% TOTAL SUPPORTS£RVICES /CHARGES 105,845 95,277 103,058 131,100 52,816 131,100 0.0% CAPITAL OUTLAY 4240 MACHINERY &EQUIPMENT - 4240 FURNITURE AND FIXTURES TOTAL CAPITAL OUTLAY TRANSFERS 4820 OPERATING TRANSFERS -EQUIPMENT 772,500 800,000 830,000 860,000 890,000 3.5% 30,000 TOTAL TRANSFERS 772,500 800,000 830,000 860,000 890,000 3.5% 30,000 TOTAL PUBLIC WORKS 1,454,320 1,372,224 1,418,442 1,670,465 262,571 1,700,465 1.8% 30,000 -22- ICE AND SNOW REMOVAL General Coding: 101 -33- 111040 Requested Actual Actual Actual Budget YTD Budget Percent Dollar PERSONAL SERVICES 2013 2014 2015 2016 2016 2017 Change Change 4101 FULL -TIME REGULAR 38,307 39,131 17,265 39,805 14,610 39,805 0.0% 410 OVERTIME 6,119 11,735 3,721 7,500 1,072 7,500 0.0% 4121 PERA CONTRIB - CITY SHARE 3,145 3,664 1,424 3,311 1,176 3,311 0.0% 4122 FICA CONTRIB - CITY SHARE 3,149 3,571 1,145 3,619 943 3,619 0.0% 4131 EMPLOYEE INSURANCE- CITY SHARE 6,142 255 2,982 7,230 606 7,230 0.0% 4151 WORKERS COMPENSATION 3,007 TOTAL PERSONAL SERVICES 56,862 61,363 26,537 61,465 18,407 61,465 0.0% MATERIALS & SUPPLIES 4245 GENERALSUPPLIES 44,835 34,444 16,229 44,000 4,179 44,000 0.0% TOTAL MATERIALS & SUPPLIES 44,835 34,444 16,229 44,000 4,179 44,000 0.0% TOTAL ICE & SNOW CONTROL 101,697 95,807 42,766 105,465 22,586 105,465 0.0% 111040 PARKS MAINTENANCE General Coding: 101 -52- - - 178 Requested 4321 COMMUNICATIONS - TELEPHONE Actual Actual Actual Budget YTD Budget Percent Dollar PERSONAL SERVICES 2013 2014 2015 2016 2016 2017 Change Change 4101 FULL -TIME REGULAR 62,036 87,817 98,959 74,119 61,174 74,119 0.0% 4102 OVERTIME - 187 8,206 2,500 4,421 2,500 0.0% 4103 PART -TIME 2,464 8,859 8,179 12,000 1,523 12,000 0.0% 4121 PERA CONTRIB - CITY SHARE 4,447 5,451 7,471 5,374 4,678 5,374 0.0% 4122 FICA CONTRIB - CITY SHARE 4,309 6,637 8,044 6,779 4,570 6,779 0.0% 4131 EMPLOYEE INSURANCE - CITY SHARE 8,966 7,363 20,141 14,250 11,656 14,250 0.0% 4151 WORKERS COMPENSATION 139,946 5,312 8,125 178,822 2,625 178,822 0.0% TOTAL PERSONAL SERVICES 82,222 121,626 150,919 115,022 86,226 115,022 0.0% MATERIALS & SUPPLIES 4208 POSTAGE - 19 4221 MAINTENANCE OF EQUIPMENT 5,469 4,383 6,000 456 6,000 0.0% 4223 MAINTENANCE OF BUILDINGS 6,208 421 2,530 7,000 3,457 7,000 0.0% 4240 SMALL TOOLS AND MINOR EQUIPMENT 932 512 546 800 121 800 0.0% 4245 GENERAL SUPPLIES 6,299 10,162 7,775 9,500 7,108 9,500 0.0% 4247 TREES PURCHASED 132 7,056 2,275 TOTAL MATERIALS & SUPPLIES 18,908 15,610 17,907 23,300 13,436 23,300 0.0% SUPPORT SERVICES /CHARGES 4303 ENGINEERING FEES - - 178 4321 COMMUNICATIONS - TELEPHONE 1,828 1,929 1,959 2,000 821 2,000 0.0% 4331 TRAVEL, CONFERENCE & SCHOOLS - 6 188 2,000 - 2,000 0.0% 4351 PRINTING AND PUBLISHING - 137 4380 UTILITY SERVICES 9,901 9,741 8,206 10,000 4,421 10,000 0.0% 4400 CONTRACTUAL SERVICES 14,895 15,532 17,904 16,500 3,636 16,500 0.0% 4410 RENTALS 9,267 8,329 7,195 10,000 4,239 10,000 0.0% 4440 MISC SERVICES 2,925 40 TOTAL SUPPORT SERVICES /CHARGES 38,816 35,537 35,492 40,500 13,432 40,500 0.0% TOTAL PARKS MAINTENANCE 139,946 172,773 204,318 178,822 113,094 178,822 0.0% -24- RECREATION General Coding: 101 -53- -25- Requested Actual Actual Actual Budget YTD Budget Percent Dollar PERSONAL SERVICES 2013 2014 2015 2016 2016 2017 Increase Change 4101 FULL -TIME REGULAR 30,872 23,856 27,531 23,168 12,651 23,168 0.0% 4102 OVERTIME 418 550 209 490 4103 PART -TIME 13,615 13,374 10,137 13,000 5,748 13,000 0.0% 4121 PERA CONTRIB - CITY SHARE 2,469 1,735 2,063 1,680 949 1,680 0.0% 4122 FICA CONTRIB - CITY SHARE 3,424 2,820 2,834 2,767 1,385 2,767 0.0% 4131 EMPLOYEE INSURANCE - CITY SHARE 498 178 434 960 272 960 0.0% 4151 WORKERS COMPENSATION 153 206 357 TOTAL PERSONAL SERVICES 51,296 42,666 43,414 41,575 21,852 41,575 0.0% MATERIALS & SUPPLIES 4245 GENERAL SUPPLIES 500 500 1,248 700 704 700 4246 PROGRAM EXPENSE 4,318 6,996 4,491 7,000 650 7,000 0.0% TOTAL MATERIALS & SUPPLIES 4,818 7,496 5,739 7,700 1,354 7,700 0.0% SUPPORT SERVICES /CHARGES 4321 COMMUNICATIONS - TELEPHONE - - 4331 TRAVEL, CONFERENCE & SCHOOLS 48 40 100 100 0.0% 4351 PRINTING AND PUBLISHING - - 382 #DIV /01 4400 CONTRACTUAL SERVICES 4,923 383 709 6,500 1,100 6,500 0.0% 4433 DUES AND SUBSCRIPTIONS 199 165 239 200 25 200 0.0% 4440 ARCTIC FEVER /PRINCESS TEA 7680 5559 3,692 7,000 5,187 7,000 0.0% 4450 BANK SERVICE CHARGES 201 38 100 100 TOTAL SUPPORT SERVICES /CHARGES 13,051 6,185 4,640 13,900 6,694 13,900 0.0% TRANSFERS 4820 OPERATING TRANSFERS 42,000 42,000 42,000 42,000 42,000 0.0% TOTAL TRANSFERS 42,000 42,000 42,000 42,000 - 42,000 0.0% TOTAL PARKS AND RECREATION 111,165 98,347 95,793 105,175 29,900 105,175 0.0% -25-