Loading...
9.1. SR 08-15-2016 Eclty1� ,.,�� Request for Action River To Item Number Mayor and City Council 9.1 Agenda Section Meeting Date Prepared by Work Session August 15, 2016 Lori Ziemer,Interim Finance Director Item Description Reviewed by 2017 Budget Cal Portner, City Administrator Reviewed by Action Requested Continue review of 2017 budget. Background/Discussion Following is an overview of the Storm Water, Garbage,Municipal Liquor,Wastewater Enterprise Budgets, and Equipment Replacement Fund. Attached are the proposed budget worksheets for those departments along with the proposed 2017 department/division goals. Let staff know if you would like more detail. Enterprise Budgets (proposed Storm Water—This fund is established to account for storm water activities to ensure compliance with our storm water permit. We currently have over 300 ponds that over time will need maintenance and repairs. No change in the fee rate structure is proposed for 2017. Garbage—This fund accounts for city garbage collection service and the city-wide organics program. The garbage rate structure is a project University of St. Thomas students and staff will evaluate this fall. The baste Disposal line item reflects the GRE tipping fee. The Contractual Services line item is based on customer count and container choice. Included is a one-page summary of the Garbage Budget for 2017. The Environmental Technician position is allocated among the following budgets: 2016 2017 Environmental Tech. Environmental Tech. Environmental 45% 30% Energy City 15% 30% Landfill 10% 10% Garbage 30% 30% Total 100% 100% Municipal Liquor— Overall, Northbound and Westbound liquor store expenditures are consistent with 2016. In 2018, the Capital Outlay expense includes a roof replacement at Northbound. In the cash flow analysis,we still anticipate the $850,000 advance for the quiet zone improvements. Wastewater - As part of the updated long-range plan, staff recommends a 3 percent utility rate adjustment for 2017 which is consistent with prior year's projections. Also provided is the updated financial model for the Wastewater Fund for the next several years. Personal Services — Consistent with 2016 budget. Supplies —The Operating Supplies line item remains the same due to anticipated use of ferric chloride which will be needed for the new permit requirements. Other Services and Charges —The increase is mainly related to projected utilities associated with the plant expansion and operation in 2017. Capital Outlay—Includes the replacement of a pickup truck and lift station improvements in 2017. Equipment Replacement Fund (2017-2021) The Equipment Replacement Fund is a section of the Capital Improvement Plan (CIP). The fund covers replacement of wheeled equipment and vehicles and was established to provide funding and long-range planning for the replacement of equipment. The fund is replenished on an annual basis through charges paid by each general fund department through their operating budgets. The amount charged to each department is allocated on the estimated replacements over the next 10 years and updated annually. In addition, the fund receives a portion of the payment in Lieu of Tax (PILOT) from Elk River Municipal Utilities, Local Government Aid (LGA),interest earnings, and auction proceeds. The fund maintains a significant fund balance,but is necessary given the sufficient variability as we utilize cash reserves when several costly vehicles are replaced in the same year. The replacement cycle is continuously evaluated, based on costs and department use over the next several years to determine the optimal time to replace vehicles. If the Council would like any more information on any specific piece of equipment being requested please let Suzanne Fischer (Fleet Committee Chair) know. The city's Fleet Committee is actively involved in the long-range planning of the replacement of the city's fleet and financial condition of the Equipment Replacement Fund. Financial Impact N/A Attachments ■ Department worksheets Divisions Performance Measures & Goals for 2017 Division: Stormwater Completed by: Brandon Wisner Date: May 31, 2016 Performance Measure 2015 Actual 2016 Estimated 2017 Projected Active Projects Reviewed 11 16 20 Completed Projects 8 13 16 Inspections Related to Water Quali Protection 190 205 215 %of Active Site Inspections Considered in Compliance 70% 70% 70% Stormwater Basin Cleaned Out to Original Construction 2 3 3 Stormwater Basin % Performance <70%-Needs Considerable Maintenance 7 5 5 70-80%- Needs Notable Maintenance 17 17 15 80-90%- Needs Some Maintenance 93 93 92 >90%- Needs Little to No Maintenance 196 199 207 5 Social Media Postings, 4 Current Articles, 100 100 New Resident Public Education Outreach(Current, Expo, New Resident Stormwater Utility FAQ,2 4 Current Articles, 2 Stormwater Utility FAQ TMDL Education Mailings, etc.) Public Events,and added and 6 Lake Orono Meetings, 1 Green Roof reporting function on Improvement Association Installation for Public website. Meetings. Education. 1 Installation and 50 Visitors(MS4 Permit Green Roof Installation at WWTP Facility 0 Feasibility Education Division Goal Related Goal Objective TMDL Waste Load Reduction-Construct stormwater management projects that reduce nutrients entering Lake Orono Cartegraph Support- Electronically track stormwater assets,conditions and track potential illicit discharges Continue Stormwater Program Guide Updates and Implementation- required Maintain Municipal Separate Storm Sewer System (MS4)Permit and improve Water Quality Green Roof Installation at WWTP Facility-Achieve MS4 education requirement Permit compliance-ensure that all construction sites obtain required permits Apply for water quality grants- Reduce the financial impact on the stormwater fund for future projects CITY OF ELK RIVER STORM WATER MANAGEMENT updated 819116 Actual Budget Estimate Estimate 2015 2016 2017 2018 Beginning Cash Balance - 188,638 361,838 152,938 Sources of Funds Impact Fee 22,440 51,500 53,000 54,500 Charges for Services 294,109 420,000 445,000 445,000 Misc. 361 - 0 0 Transfer- In(close-out previous fund) 280,763 - - - Interest 6,170 1,500 4,000 4,000 Total Sources of f=unds 603,843 473,000 502,000 503,500 Expenditures Personal 77,050 80,650 85,700 90,650 Supplies 1,747 7,000 2,000 2,000 Engineering services 7,860 18,000 - - Audit Fees - 3,300 3,300 3,300 Professional Services 11,950 30,000 32,000 32,000 Telephone 1,167 1,100 1,100 1,100 Equipment Rental - 5,000 - - Dues and subscriptions 965 5,250 5,300 5,300 Miscellaneous/Training 1,008 2,500 1,500 1,500 Equipment 27,821 - - - Contractual Services: 135,637 Pond Cleaning 64,000 160,000 150,000 Storm Sewer Repairs 50,000 40,000 40,000 TMDL BMP Improvement - 200,000 100,000 Storm water improvements 20,000 - - Misc. items(sediment testing etc.) 8,000 15,000 8,000 Transfer Out Street Projects(storm water components 150,000 - 150,000 75,000 Equipment Replacement(sweeper) - - - 20,000 General Fund - 5,000 15,000 15,000 Total Uses of Funds 415,205 299,800 710,900 543,850 Ending Cash Balance 188,638 361,838 152,938 112,588 Depreciation 448,000 448,000 � � E O O O 1f7 d!1 li1 I!1 W in Is7 d� d' ISl T m M M W H Q C7 N �' SIS m O O a a m w 0 0 O P O O 0 0 0 0 0 0 O O O o 0 0 o q o O W E � rh C�WJ7 a a� a yam, uMi omi o 0 m Ln a m a m as m r� m m o w w o a n M M p 6, N air W W uoi uoi n U1 N M M i H 0 N � 0 4 O d PO 0 0 0 0 0 0 O O Win 1O .fC737 ri ri o rt 14 t+l rh N m F F F U W w w w r i w H N rl 45 m tlh w C o '�' 06 v [N 60 N M rf .d N w m Po' 9 F C N M M a E P F M SN V O N M O H N N N M N M H W r•t SG PO W p t] O O 0 0 0 o O 4 O d O d O P Q W N 5 W W o E rn H Us U R P O O O b 0 0 0 0 O O O O O a o N N U 11 a W F U a y m E m U U r u a m u ti s4 F E N 10 l4 U co m 5c 3 a H m m a w +C u m a C E E C A N W N 4m P.< r> U u H N m {1 H p r- cn H a cn cn E U fr a H a No (d Ln a Ij cil r•I m W HH - N 14 W W m N F m $ cA © F H a m w u a w a F h a m m K} W M K a M a 7 M 4 M M r4 w N If o etl m i p, L'i aJ , 11S H i 1 14 H a1 P H m o to a o 0 0 o cn o o E o >W ry ul 3 ii o H o � a o � o o N o o Wa' o H �C � P+ E H cn M pp S4 M •-� W l' n a 3 H U r E a i F a H F i E- x a O Q 0 0 0 0 0 0 O O O 0 P P p 0 O P 0 O O O 0 0 0 O O II O II N p m 0 m m O Ill 0 0 O 0 0 0 0 0 0 0 0 0 O O O m m II m II ❑ h m 0 m m M w O O M O H m 0 O M N O O 0 0 0 W m II M II WEA it n W w W d' d' d' m O N N M N H rE m m 1 m m m ❑ lta m ri r9 11 rb tl [W[� H 0 �o P4pI m M m W m h h p N V h II II L a w n P. u u II n 0 0 0 0 0 0 0 0 0 0 0 0 a 0 0 0 0 0 0 0 0 0 Co 0 0 0 o IY o 0 0 0 0 0 0 0 0 o O 0 0 0 Co 0 0 o O 0 O O ❑ 0 II 0 If ❑ o VP m m ri M h O o M o.-, m o O M N O O 0 0 m m II m II W E p M m m N N M N H .i in 00 m w 6 C In m m m 11 k0 I! M I••i W Q in m H H m m I! m 13 O W ❑ C b' m .-I H .� H II m li Ix 111 N O II O. II II II II II � II -1 -* M 0 0 h h N O 0 0 0 p 0 O p O p 0 00 0 0 0 0 N Nit m II w N H m m w .l 0 m m 10 101 o II ❑ .] M N .d M M r o M M II ICa it I 4 II it F ❑ M H m N W 16 I I N I I r F u n > U r A: II II I II II r II II II II 16 '^ H O N O O O 0 0 0 0 0 O O o Q O O o O O o 0 0 O O O o 0 4 O It O II F m o m m m m m 0 0 O o 0 0 0 0 0 m m 0 o Q m m Ik m If M Ifl N N N W O 0 M O P rl ICI Il m II I Ix h sp M -1 0 17- h M m O H N m m M m 1p 0t m m li Wit N 00 rM M ['1 C'S M N N li m II r U n n II II II II I II II t0 i 0 m m N M N m m h h O O N 00 h 0 m m ma O 0 0 0 N II Ho 11 N � m h h Ya F0% m dr h i0 40 16 M m m O M 00 W w H H H II o O II m H ri 00 l0 '+D 1 N m h h 1 h C C 10 m m 0 V' C II m II 0 ❑ W E O F d' N M N .-1 .i h M H .-0 Ill .d N m l0 II m II F N FC m m rl .4 M v 100 IM^ r II O II H w M p' ✓;� II ri II p� II H P w a W ❑ W 0 4 0 0 0 0 0 0 ❑ o 0 b 0 O O O O O O P P P P P O I{ P II O a •• ili ii Rr W 0 n 4 O N ii ii H CCI U � II II II II O O Q O O O O o O o 0 0 0 0 0 0 o 0 o O ❑ - o p o O II o II tl I I I II M II II 0 3 II II F N U IZC u II 31 II II 11 II II m O H a7 G u 0 rt G U w y m m Is U rt a O S U m Q G +s fk G U m Cq .H 47 U Q U qa 124 47 U -rH 11yyi -H m m 2 pUCI N 4L N to F�+ 41 ani -A 4pa 471 t4 .7 v CL ❑ rH w W 4a G U a 7,7 C IFi T E to bI rd R .i Ix O m U as m G G O Id -A G W U W aj 41 U 41 Ol N , O 41 U P a-I w .ai 41 I I W w IV U U G m. Iv la •M C +I G N la al, t•1 PC N G m •H .y 4/ 4. m m 0 - U N -H m fll ?. d7 N rd ad 0 4a 4I v m 70 4 Id E U In 47 S IC w W u W .-I L4 O Sa N Id 14 U G 4Y a IU k1 CAI QI U O r-i m m aa v .I G X IO j Cn T1 m iI vD ✓u bs O .w Id G P, N 4L rt m ad w 0. v w H u w G o a U ',} G 4i m N O N 0 pbi m y7 U1 W m P: W W O £ H ,'� r-1 0 m A, W [4 F E+ U W C) A N H E E kl Id Q IHa a U r1 .0 m 10 h m m m ..mi 16.H M m .� H m m O Mo o ICU o —i w. 7w w r 0 0 0 0 0 0 0 O s m o N M O N M k M 17 N N m F i H ' H m NP, m M M M M M d' d' d' d' 01 Id m -H . h h G u \ 4 en 7 V d d P 9 C c a s o �r r r a a a a 4G H u d 4 w w rt o a s w v I I I I l r r d r r r m Ic m v7 o O p O p o p m a co 9 0 0 0 0 0 0 0 0 0 0 ;:1o U0 a E m [,I H £ 11 t7 M H .d r1 r-1 rl H H FaI H r[ r1 r1 W H H N H O H m H H CL O N 0 F m m m m m m M .] m M ..77 QI M M M M M M M M M ,3 M .4 }I M m m m M 5{ m 4 47 m r{ ap m m m m m m m m m Ia, r1 rj 41 W P7 � N E p � r r I r r r r E •�+ r E I r i r I � r I r {� N r F. w r r E F a H LI W ooh F rl ep F ep d+ w a a+ m w .n ar CJ H 0 0 0 0 0 0 0 0 h N 1- r F 3 m o u }y' 47 0 0 0 0 0 0 0 O 0 0 0 0 0 O O o O Q IQ O 3a O O Q w w UI W CL In u7 In w Ia W w m W O W w In w w u Io In m U e E m m E a Division Performance Measures & Goals for 2017 Division: Garba a/Or anics/Rec clin Completed by: Kristin Mroz Date: May 31, 2016 Performance Measure 2015 Actual 2016 Estimated 2017 Projected Residential Recycling Participants(%) 88.33 88.5 88.6 Fibers(tons) 951.27 1000 1050 Containers(tons)(glass, plastic, metal) 670.58 700 750 Organics(tons) 41.72 45 55 Event Recycling 1 2 5 Division Goal Related Goal Objective Promote and increase amount of organic recycling Increase marketing and education Decrease amout of waste going to a landfill or Restructure residential rates to discourage large amounts of waste waste-to-energy facility. Maintain Fix-It Clinic and Clean Up Day participation rates Create a customer friendly approach to waste and recycling disposal services Promote and increase amount of organic recycling Promote and increase amount of recycled materials Increase recycled material to grow niche Restructure residential rates to encourage recycling and organics recycling industries Increase marketing and education Work with EDA to encourage business growth in recycled material industry City of Elk River Garbage Fund Actual Actual Actual 2013 2014 2015 2016B 2017B 2018F Operating Revenues: Charges for services 1,272,297 1,290,451 1,308,816 1,310,000 1,366,000 1,400,000 Delinquency collections 10,034 11,422 10,529 13,000 10,500 10,500 Grants - - - - - - Other 2,807 2,877 1,957 3,500 2,500 2,500 Total operating revenues 1,285,138 1,304,750 1,321,302 1,326,500 1,379,000 1,413,000 Operating Expenses: Personal services 19,811 20,388 33,545 22,900 24,350 25,350 Supplies 7,077 3,080 1,537 26,400 21,400 23,400 Contractual services 1,224,532 1,280,475 1,347,807 1,380,700 1,457,200 1,489,200 Total operating expenses 1,251,420 1,303,943 1,382,889 1,430,000 1,502,950 1,537,950 Operating Income(loss) 33,718 807 (61,587) (103,500) (123,950) (124,950) Investment income (25,161) 32,394 8,830 6,250 8,000 8,000 Transfer in(out) (11,755) (34,968) (8,366) (8,400) (1,550) (1,150) Change in net assets (3,198) (1,767) (61,123) (105,650) (117,500) (118,100) Beginning net assets 618,673 615,475 613,708 552,585 446,935 329,435 Ending net assets 615,475 613,708 552,585 446,935 329,435 211,335 Fund Cash Position Beginning cash 591,503 606,857 606,357 551,393 450,743 338,243 Cash flow: Operating income(loss) 33,718 807 (61,587) (103,500) (123,950) (124,950) Change in rev/exp acounts 19,122 609 6,159 5,000 5,000 5,000 Investment income (25,731) 33,052 8,830 6,250 8,000 8,000 Transfers (11,755) (34,968) (8,366) (8,400) (1,550) (1,150) Ending cash 606,857 606,357 551,393 450,743 338,243 225,143 0 0 0 0 o a a v v o 0 ❑ vt ua o 0 o v �n vi In W E m m W 4 p m m o o m N N W N Lx � ❑ r� .y .-i CL O O O v 0 0 O O O O p p p p o 0 0 0 0 0 0 q ur ui o 0 0 o in ut In o 0 W E h m Cil O o m m o a N N m m � © te a .y N m N N O � ❑ � � � 0. In M N W m m v W 1n to N a) W u) Ln Ln N -& w no- N m m n r ❑ o o m m 7 U m m m t � 0 N � 0 0 cr 0 p p o 0 0 0 0 E o o us m o o �n o 0 0 0 W W c c N N 0 o N V7 W v o M tR 6 0 � U m m o 0 m m n n m m Ln m n r- 0 m U) w_ w -0 w w h m m m m o O P4 N O E 0 0 m m N N ri rl N m W F N U ri r-I N H W E arum se PP a a« W N N 9' w w m r r N N N N m m of m.m m r r m m PM Q .7 W'd' FI f'i o0 m m m m Ifl.ufl O CK d KG FL a •-I ra N N N N N N n r h h /j 0 N LU N N Cf U Fj' Oi o m m m as m p 0 6 p Oc-I rl W tl� r� m m m m m Z O 6 m N N 0 N fry n N N m O E rl r-I M N In N N H N N U N N N Q ri En to W 4J L Iffi b D U U a fa m E E a E i a o m o M u C m o m to y H U G U E u rt r+ to m N r-I a1 > m m > ro > > ro N u m 11 G A (U Ui U G .Ci a Im u ah 4 > a x m ro ul N r+ H Kms. C7 Id a 1.J 0 rE H H 4-1 i11 N mm.m U W UY m t 6Y h 6YIC H a{11 a1 N a1 G7 m m h a1 w G G +S H A GG G C G m m m m m m l >U >i o o Q o fa la N N > 0 p o m M N t7 G n > v Li m II > al N N.] N .d N cX W m P o .to .{ eKo o u -a u O P: m u u o a rnI� m m [7II 4s -rl r� O k ri Q m ri E [ a F ii n�i ai C IG6 n a)i v M OE v s+� a w ,A I[ QS U E m E 4l t I!Y 3 '4 PJ m O U II J,1 J; (5 1.11 a 41 9 Ln r-1 1l} m 0 W b n G o A o N F v N w u G +1 t+ sv u G m w [7 n H m m 0 m m m E rx 11 H O E» 0 11 w 0 m m m p p p p N Q o 0 N O m ti d 0 [s7 C7 N v c 'r w 0 o O O 0 0 0 0 w E h 0 W V° V' M m o D C7 a M o w p❑ ❑ c N O W 0 p R W t6 m F ❑ w w E N Y+ U to i i 0 N o o O o F2 W w �+Ni W io to o rn lTl M U lD .7 m m N N N N Lj N N Q! r O N N O N N M N U E N � tY1 M N M M w E M m R a W 7 N N C iP ? h m m IV N 6 a a R •� •-� m M w •• N m w ao N a w o N U N a � ro M [fj U R{ T V' ul N �••+ m M N M N N a rl H N W a i� v w F' H Ile Sr f1i E 4+ N 03 N m U N u m ti r W 14 m M F ? � w m � a c� z Mo w a O crt 0 sn E d F ao o W s. o E O 0 o a o a Q o 0 o O p o 0 0 0 0 o O O o mto W Ol H N N Ln H H H r H o In In W H O N H Ncl 01 W l!} N 0 pa N ri a 0 0 0 0 0 0 0 Q 0 o o 0 o o a a o o cl 0 Ln Ln O O Ln in O O O Q o O O o ICI N O N O O ry H H O w E r U1 W 0+ Ho I!7 d' SD w w a W H H a O w N �P 1 W dr p m n w H e Ll w m r o o o In I E-I m H N H Ill m m N N m N I I E H M In U N w r I � H Q N Q 0 0 0 0 0 0 O O a a 0 0 0 0 0 0 D O O F F In In o In ul o a o o a ca 0 0 0 0 0 0 0 Q Q m o o ui ui c �1' H N p In a m no c I Cr, H H O a1 N W O h w O O Idl H O h m VI O d' o 0 O w a m O H m M N M H H w m N M N N tCl m m m O H (L' N O � H H H lf1 N f'1 H O I'�I Qt Ill ftl M N a H 4 d4 f0 a ar7+ W r7 r a v m o p rt r o ca to m. c7 s!Y t- M 4 stn o Q ry Q mw w n m m H n res . w In In ul a H r w w o H w r r H q mm m a f: o f H N M w u a Ed U N � M m N M H [fl H M u d M N w O Afi N H m W t'] r O N In w O h O O w h H H H Q H 6 N m KI O O w a w H a N an m W H n N m r c Q Rn N U M m H N H H 00 G m O -2 m U - U C En Q U fi C u) W G U m q+ yU W u G G k to N N Ox -� k H N 4¢ S4 w �l � ou r6 -H m N w O GL Iy 4) U F7 a u m m rn m © U m G G L4 w 4lU U G m W N •.� i) b Y4 S+ a' FrG -N rI al a a dl - p U H m 4) d It l$ 1ol to itH o W V r-I S-I v Sa rd i+ " NM 0 (D �+ 41 U m G a s (a -.I m > 4J U o m Vl 4t .0 V .ti:', m M m G m 7 Id U O W H S U E m E Ln U H G' 4l3 w Y- m F m -.A � H m N H Vr m 0 � H w W •.i p o n O O o o H H m O H N l m 0 dr H N to In 7 H H H H rl H N N ¢r N m fel m M m tlr d' v Lt t- o o cq LI a '1 w a w w1 t+ w s�, v m a a m a d' .0 7 d' m 1+ W W 4y , I I I I r v I •a r I I I I ,.I U I tI rt w C7 Ul o v a 0 o P a 0 Ol S O o 0 o Q o Q p o f ED O H N N N N N N W N a d/ N N N N N N NI-7 N a N 91 a N m m m m m m Ql an d V1 en m m m m m m y m d 1 d1 qz I I I 4 I , F '•'1 I F , [•+ E m C7 N W O I tfa a t4 ut .n ,n ul t In F N E ,C vt to In Iit In m In Id m N E w 4 U 9 X a w v o 0 0 0 0 0 G 0 aJ 0 Q o 0 0 o Q - o w W w m w w w w nl O w w w w w w w F m 00 o o o O opt P n I!1 Q' Q Q O o o O Ik G VI O O o •-I If .-i FI w E-I - II II W H D C7 R fV 1•V �N b" � ul tl � YI C7 a Qe «meq pF II II II II 0 0 UOV 0 Oil O II o a n o 0 o n o n q H H O o ri ri II N II r ul 0 o m m m vi r' ii H Q ry O .7 11 II LK W � II U f1 II d II II II y II N N r O r Ir rn II Ill II r m m N N C �n II m II I y.l D t'- II H II I ff; II II I II II I le n le n H 0 N 00 coo 4 o II o fl F• F o0 0 0 0 o n ut bl W .-I .�-I O O 13 H o 11 1a dl W C9 - W - it I a q 0 o m N 0 0 in Ln sl [e ❑ N N m a w h u o a 7 IA G 13 M 91 U II II H II it lY II II II r r mom o oil G n m m N v' n m m N n m m II H n o + n n �GaK7 N o f H H N N m b 41 H II 9 €-+ N � in in HW F N !y' (h N r-I II IP m II II W �] O O Doo o mil 'r: j I�']] m m tp C Q5 II 40 II o O s7 Q Q m v1 N �D o II r II D W N ❑ m m M9 N m h II H II 11 W o f tV N n n m m N O tfs N in o II m [I li7 Oi m to N II 05 tl c c N p r r m m � m la m fil o f N N m r tl 31 N U N II II ,y II u H II II II II II II m N N W � m wwi O 4 U P, bi v �s W r IA •rl ecf 0. lice m x is '-I au w IN co L}WI 0 1A u 3 S U] ul W ❑ m QI W vl U H m ..I c o •CI In m r k Ir F o rn a u .Ij ai q ro ItcW�4� w0.' o t 1 ? o o .0 0 xW N AG a HqHq N m Svl+ N a W m C7 G z - ; O >~ w c D In o 01 Dw4 a F ami o o F F b W ac D W th m Q in m F a Division Performance Measures & Goals for 2017 Division. Finance/Liquor Completed by: Dave Potvin Date: July 25, 2016 Performance Measure 2015 Actual 2016 Estimated 2817 Projected Customer count 281,968 282,000 283,000 Average sale $24.72 $24.75 $25.10 Gross Profit 29.60% 29% 29% Labor cost as% of sales 9.50% 10% 10% Division Goal Related Goal Objective Increase use of social media. Promote value of liquor operation to the community. Maintain current level of fund transfers. Prepare operation for future staff retirements. Succession planning and staff development. Municipal Liquor Stores updated 08!9!16 2013 2014 2015 20168 2017F 2018F Sales 6,753,521 6,823,719 6,972,614 6,932,700 7,004,150 7,101,300 Cost of Sales 4,705;979 4,750,195 4,905,302 4,957,300 5,008,100 5,032,100 Gross Profit 2,047,542 30 2,073,524 30"4 2,067,312 3o a, 1,975,400 26 1,996,050 28';: 2,069,200 291 Operating revenues: Other 3,060 1,623 1,722 3,000 1,700 1,700 Total Operating Revenues 3,060 1,623 1,722 3,000 1,700 1,700 Operating expenses: Personal services 628,933 634,571 661,659 659,850 661,350 681,450 Supplies 26,507 57,604 31,542 53,700 20,700 20,700 Other service charges 220,584 209,746 225,221 231,950 241,500 250,250 Depreciation 124,757 124,757 121,402 123,000 125,000_ 125,000 Total Operating Expenditures 1,000,781 1,026,678 1,039,824 1,068,500 1,048,550 1,077,400 Operating income(loss) 1,049,821 1,048,469 1,029,210 909,900 949,200 993,500 Nonoperating rev(exp) Interest income (87,003) 105,639_ 35,687 25,000 35,000 35,000 Total nonoperating rev(exp) (87,003) 105,639 35,687 25,000 35,000 35,000 Income before contributions and transfers 962,818 1,154,108 1,064,897 934,900 984,200 1,028,500 Transfer(Out) General Fund (330,000) (361,850) (399,050) (438,950) (482,850) (531,150) Park Improvement Fund (250,289) (282,519) (290,668) (280,000) (280,000) (280,000) Other Projects (92,000) (40,690)- Total (672,289) (685,059) (689,718) (718,950) (762,850) (811,150) Change in net assets 290,529 469,049 375,179 215,950 221,350 217,350 Beginning net assets 4,486,806 4,777,335 4,767,280 5,142,459 5,358,409 5,579,759 Ending net assets 4,777,335 5,246,384 5,142,459 5,358,409 5,579,759 5,797,109 `Beginning net asset restated due to GASB 68 implementation Gash Flow Operating income(loss) 1,049,821 1,048,469 1,029,210 909,900 949,200 993,500 Depreciation 124,757 124,757 121,402 123,000 125,000 125,000 Other changes 24,174 5,451 (50,000) (50,000) (50,000) Interfund Loan - - - - (850,000) 96,400 investment Income (89,759) 106,310 35,687 25,000 35,000 35,000 Transfers (672,289) (685,059) (689,718) (718,950) (762,850) (811,150) Capital - - - - (100,000) Net Cashflow 436,704 599,928 496,581 288,950 (553,650) 288,750 Beginning Cash 1,555,676 1,992,380 2,592,308 3,088,889 3,377,839 2,824,189 Ending cash 1,992,380 2,592,308 3,088,889 3,377,839 2,824,189 3,112,939 Target cash reserve amount(notel) 876,024 901,921 918,422 945,500 923,550 952,400 Cash over(under)minumum cash balance 1,116,356 1,690,387 2,170,467 2,432,339 1.900,639 2,160,539 Notes: Note 1:Target cash reserve equals 1 year of operating City of Elk River expenses,plus 100%of next year's debt Liquor Fund Cash Reserves S4.000.000 , 5.1,090-000 $1,500,000 11 9 2013A 1". 2017F 1 0 0 o v o n n n a n a a a b o p o o 0 0 0 0 N p p n b b b O N b o O N N O O O O N O Q bo o a .r rP mLa �a m N Mor ,-Irl-Iw m En CFiI N N N ri M m 61 � O .-� .-I e-I 00 h LI LO W� O~ SJ N M M M >d 61 h p M m m m m N w Csa q Lrr N m .a m m w O M Oa O 6 6 0 0 0 0 0 0 0 0 0 0 0 O O P O n n n 4 O O O O O N Lf1 O N N O O n b b a N O O q FI O O O W e} h C11 M rF h LO � � M M m P N dl h U} r,+�W�+1, In m m h P m w f+l H ri H kn N 0 O Q M M M u1 r'I W Q M h r h O q a m ri ni v + a 0 0 O q r LO M n m O P h m m o m N N N LD r h r M m N .i O1 Q P h P 'd1 [p rl P m N m N N LO L 61 M G1 Lp IR m N I �+ r r r t+a ri m L'1 N ur v. o r N N N a r M N M V' V' P N m N Q I H N N I LD N O N 0 0 O O O 0 0 0 0 0 0 0 0 O n n 4 a O b O O O O O O O N 161 O 0 N O m N O O N 111 N O I 'Ii W o 0 o C' 'tl1 N N W N M LO M P m M a m O 1 I W - LO Q1 m to N rl ri L11 ri OL tT (1; PI N N N N ri m M H H r h Q O m 4}Or� .-1 N W d1 N I r 1p la ft] m m N w'� Ol V1 m m�t w m P ri N w w O ID W W W p d" N N. •J' P ao m d� r-I W M N f� d1 d' N W .a N a N O N m m w LII 01 m N N 111 rl r1. W P N m F N M M m N N m (A N m P LD p M N M [WJ C d C }G C4 � YL (pil 01 m m O O O� N �' H N 4 W m .I rl O v d1 o N m Ln I ��11 M m - �. h V' w a t6 w P M m N N Ln P N Q W O O W ••0 N N N Ln r� ] W O [UI O O O M m � d1 r P 10 W N dl �i O � rP r-I rl N .-I m ID to Lfl O M H co M M M O O N ga. O M r) m N Lf7 m m b 0 Lfr O N 411 0 0 O O O h LLnm rl r m M P y1 [♦+ NN N N O N h o m m LA 1 O m M e-I m 1 T N N N b N h o F• m m m m O0 P m cr v n Ln N P w N 4S +# Lp O m @ as @ C C m 4 C > w to N @ ri 41 re x > > @ 4 Fri = N � O p~ F a 0 U ; H7f a 0 R 41 r [1 C 14 41 ,tl of .0 LI - u C N N 11 0 m 4r 41 0 k C sl@ C a w m N � IU C 9 O II Ax C w II a wH N O II N 01 ri N M <Y' ry w II N Fa m m m m m m m 45 @ O II N N w m m m m m 41 IO @ w N II QI LD q1 P r r r P'� P r r@ rl II N m Lp 41 h r P P L` 1 0 77 II � I yl i I I a 4} p 0 b' '6 n N n 0 b 4 o 0 0 H H H v7 L>$ 0 11 > 0 0 0 O O O o .-I 0 b , H a H �t H H H p o r u } N N N N Ln Ln o c [11 41 O a `0 II @ r1 rY H '-1 N rF N rF N -y Z Ss' II 91 .-! ri d 0) 0) N d a O � O II a m � � a+ � v. � a+ � � � Cw 7 n a m m � m m m rn w m 0 @ m. m m m m m M m © k a A II LI M M O @ M M M M ~ m ii r1O k II m O W -rl 11 41 n F Q II #i bb o 0 0 0 0 0 0 0 u F N I3 i� O O 16 0 0 o n w a .4 II O Lo Z u O La N w W La La La Lo Ln Lar O ME 0 — La Lr1 Ln Lo Lo La 0 0 0 0 0 O a N (] N C C r P M a [L` f17 N N n a C 6 Q O C) O m O Po Ln N Q m r w m W W F o G q ~ N N o N C} +X m CV N r M O Ifl N W N m I m N N N m N VI I p o c r r w r N M M o I1' r-S H M N O ry O P P b b O O w C m 4 m N N N m U I N h w N O N tll N N N a I.a Ln IT N M N r ry .i w FC r7 m .r In a n H p +X N O F n w o F N "y N N H Imi o H W F N N r W 'F7 m0 0 0 m N h H w N 4� O w O .4 O a s b F N n N M ly 0 N d N N m H Cn N N U IC, m o .r mm m W w N o r N M r M I� N 3 sr> M d^ m P F N �i 1R w N U N N w N N w N -1 16 U1 Q E d 4j E H C m V] N O N N C'. L4 C, 3 s4 F PS O o 7 o H C z° m° u to .a m 2s N w N N C W ma, t- m 7 t[o7 M '6 U �7 I I I I YIs N {R N 4li N co a V; Q) N OI W m m m m eq w a Y H I I I i E-I bl M M A W O Tr7 O O O O w w w w w 0 F Q 00 0 Q 0 0 0 U1 o o N o 0 0 0 La of m o H 0 0 En o .a U� m FL 2 CA W�l Im m r! W G1 14 F- MWW M C N O ww 2 cP N N 0 1:4 'a v w m r m 0 a 7 1� r� m N N N N N MMw " C-4 -W RC ti 0 ol 0 0 0 CT C7 v N N O k� m N N 0 E- C, m O N w r: w ED to ❑ C) U) m h N w Lo W W 10 M CA Ch m Clq N N I�i N1+ M1� 0 w .. *, co H n -i m PW 0 El m h h m N N CA 0 4 0 ri N Ln N U IV N w 0 Ir v N N an N E-) 0 s4 01 a) li E)-4 440 4 al 3 Eil w W 4) :j 0a La 0 - C14 M LO -. N v) m m n H 03 M CN N a 91 m Bl 11 v V U VI 9 1 H C,41 ri W En am m 4, m 0 0 w Z 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O O p O O m m N.O 6n o o to O 0 o 0 0 0 0 0 0 0 0 o O O N O N O W F r w 4 N w 0 C 1l] W M w O m Ifl w 0 C i z C C C 0 d' O 1 C C H O N m m cf1 W w C w H N Io w m 0 a O N fs m N N V' 10 cM H .H H M N I11 w O O O M m N H r N 6 J ❑ N H N lfl N w u] a g O q p q 0 0 0 0 0 0 0 0 0 O O O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 N O 0 N 0 N N N x15 N p g N O O 0 0 0 0 0 0 0 0 0 0 N O N to A H w C N 1 m 1 M O M w O m w C 1 N C O O 1 " O m w 0 m w W H r U1 [�W}1 O N N N C 0 40 h H H H M H H O 0 W O M M ! N O Nco 'o n N C_7 �J ❑ N N N f�1 MH VI� H H H M H H f� GA a H o w H M o m r N m H w N m 0 M 0 r N w m v 0 0 w m w 0 0 n o o O m N W .r M o o w O o w N H w 0 0 N w a o H a H N w a I A � W q H H W N N H m w lSl M m O W N ll3 N H If! w w m N m I �+ A N n cr N N m w w w n an w H M w erl m N m a r k }+ U H N N C r O r Q H w 0 N w g p q q q 0 0 0 0 0 d O O d d d d d 4 6 0 0 d 0 o a p 0 O 4l O O N M N 0 0 0 0 115 N O 0 O I!} p q 0 q 0 1!) O N p g p Q p q N N N z N N fR O m 1 w W 171 d� M 1 C m M N O O C C n O n � O 1 O m Ili m W U' dI m N N M N rn M H M H tl' w W W M H w H [� m lf7 m H N CV N N m M r N H o r o w H dI w Ln H h O w Ift O O w O O w M w �] ill M u7 w w 01 O M N N M H I' m n w O N H M m m w r N N w In H m H ul a N d' p 1!y cn m o1 w h Ifi N L1 If1 N O N H N W) m d M m N h w O H f[1�'N O wdI O w N N N H w m M H O m O M O M N n O m m h 3 E N CCC N m A N N M @ H H H M Ifl w H H Nm Ch w C14 M w 1 w w F a � w a � _ W W m O C e-1 n N n H M O H w m w O p O O rn N n m lfl N w ry w O O N 0 O N dI �7] N W v m W m m H O N N dl r h 6t M W 1Il m w m w M n N O w Ln M w N 1 m w m d' w1� r N 1 If1 N H 1 1 w N Ifs a •• H '.7 n H N O 0 yt VI c11 -zv H w m N N V m M H m M m N H H M N a (6 O m N N H rn O N N M H b' m h H w h m N U� N dv .-/ M M w N U rt H w 0 0 m m N w 0 m H g H H N h m p ul 115 H y+ yI m N M N m 0 0 m O d m O w o H m I r m N m m w n r4 m w H m H m H m M m N M m q w M M Q w 1 w H M 1 w m N N 1 If6 N 1 a N m H M m 1I1 n M r N O N 1 H M N m w dI H V r H tl' w N N d' m H N W M r 1R N O N H m O F M m N H M p H H M N h V M r r N U N aT H M M w N R H m O m U 1 A l W a L .4 rn C O G r N m U C U U ul a) O m -.r C Q -H> a! m U m C © m m W Sa of U •H 17 ?G }-I 00 In QI •n H N C G' H v H •1U {L dl 97 Q1 O ro 40 d1 m RI t+ ro •., m v P s4 ti m S4 vU m � C Ft O G m •H O m U •O U of dl dY -H ro a H D m H m O R ro -' » v C3 A 4s a m i d1 U W rl Q of W W U -d m m (] 4-f .7 ro � d1 N 0 v E v m u u c m v G m u m w ro of U E s4 w u k H E •A g S4 r m -.1 a E .H d} W O d! -H C � [x: -H 1Y M m >. d/ d7 07 dl M -H aj of edu > H y1 .G m H u J of U of v S ro w w w G m H if I $4 U S4 U LI m U toFo is a 16 d5 I-I 1-e -H a W t -A U D a-I 19 0) m ; O � to Is v 'W !4 v r4 w 14 ro -H d1 of 7 m N 'C7 W 14 uy q Fi G o O ; ro W t+ 41 0) r. U W 7 C d U N O p 2] C a�-I 4) =1 7 N Sm-I E O Ski 1�a Froa m G m b m a 0 a a p. O M H •.; H W A O m rt H m H 6 +-� '7 W A A E U 4 1 H H H F+ N 7 H S4 U H N M d' N w r m m G N h m aH rl ri N W m rl m T O M r w N O fd 0 H O W d) -H 0 0 © 0 0 0 0 0 0 6 H H H H m O N N M d' w W O N M M M 34 M L N N rn m H H m N N N {]I m M M m M M M M ]' .T er V' V' N ro Ln -H 33 n r r IJ 0 D [1I iI •a d' d' C V' V° 'm V' v H v W L'1 U VI -0 v° V' VI 4 v q 4 H 10 c3, Ql a w n s W m I I I I I I + I U r I s a -H I I I I r I I I I I I I u L I td U D I N O w N 'Q {y Vj N N N N N N N N N Rr N N N M N N N N N N N N N N N N l7 '� N U •W N H .4 N OI O r1 m m m m m m m m m m v m m m of m m m m m m m m m m m m I'�y H m v v m m m H ❑ C I I I i I I I I I F -H I I I F I I I I I I l I I I I I F ro 1 F En ti; I I I H N rn k a N M M M M M M M M M M M M L M M M M M rn M M M M M M rn A ro M M m 0 0 X u d o a 0 o w w o p O ','� O O JJ O O O O O O Q o 0 0 0 O IC o m 5-I O C 0 0 a w 'z W w w w w w w w w w cof w w w O w w w w w w w w w w w w U w ❑ H w w w O O O O O O O O N O N N O O O O O m EhW r I61 c r N rl rl (n 4 rvO q wwroNui ~ � ua°i a a w a a a o o a o o o o a o N N o o O O O W x n 0 W +-I O tx m m h ep m H .-r o R: P7 H H o a N O O N m H H n h m N C In 9 F w M P d' M M m N n O O N M M I ?+ U I I O N O O O Q O O O O F o o N N o Q Q 0 W C' 161 M N N O O N m w (.7Y. m to m i0 W n rl .-I m W P N N N I [J ri H I h M H N M m m co o O H N sf� N P m M H H N O H O 0.' N p F•1 N T Q M O O M F N Q w m ro w 1°n H W E+ F77n k6 P4 W W F7 m h Eli N N NN v m N .-i m M m O+ N O H J H N M v N m m N a W o f rr m M w m o ?+ a O N U F Rt H IlS H rl 10 tl' H m rf N N l[3 M vj � °Q N m O (ll 01 tl1 +"I r`i- m m Ol .d Ot Ql OE 1 d m U Ql V] i H f [l1 m U O £ m N A mm (D m 4 a -r E to N N N M N ,i N O Li N N N N '-E 34 j2 W m N N N N " c M w 13 o O u) w m IF R, >> v m F4 4 N O 0 qHq N m rn m m cn mpp4 1 N a F F V M m a M M M M 4 M m o y y,' O O O o 4JO m $ W rb) us w w w 0 lv 0 0 0 0 0 0 0 0 0 0 o O o 0 o 0 0 0 o 0 0 0 0 0 0 0 0 0 o O 11 O II ID O O m O O m O N.m m O O m O O O O O O O O m O O N N W m II m II L) N m N N F F C N m N 10 W 1 N 1 O O N O O O 1 m' O N b �➢ II N II w _ , m [ll W H h ql d N m r1 Wd lD m M d d P m m d N i!1 P h 11 4 II ry d N d h mh H dl II 01 II Re W (17 r n 11 d u n n n n n 0 0 0 0 o 0 o o o o o o 0 0 0 o o o 0 o o o o o a p p 0 o u o II P P m m p p P O P m o P O m P P p P P m P P Ill O P P N p II m II Q 1! m 1.1 O 10 h a m N O o 1 m O O 1 "I O h h m II M H W F+ 91 71 r m WOl r C H N m M H 1➢ W t"1 H H O 'A F 1 N H O O o H II H 31 H O U�1ai VI W H H N N N N H r I'1 r O H II N II N 0 .7 Q N dl m II N II .7 - II II w IP II 16 II 11 I} r0 o O F N o w -1 o 111 H o o H O M O W N w O O o m m m O O m M n l9 N O m H Ill III H o m m H Ol N M o l"1 w H N w m w Ot 19 N 11 ❑ tO N o W N m m F Oe N W O 1 q' m H N II d 1] Y (•�a a' m m w .i M N m M I+a M .a .-i In 10 Ile' in m n m n dl' d^H d W i- h 11 N H II C.J H N II M II i•1 41 11 I II II H bi II P N P P p p P P 0 p p p p p p 0 p p P p P P p o p p P P P P P 1I p II [-� [-+' m O m O 111 O m p O N O O m O O O O O m O O o O O O m O Ill II m II 1y {s7 N N M 1 x dl h 1 1' 11 O C (15 1 1 1 f1 O IO Q+ 161 o O 16 d� O N Ifl 1 II d1 II I W {J r F I'Y H N r M C N O N fR H H O m r !`] N H Ct m d' I of m .--f H d r1 N N H N H r N w N m n M II I ;p N d q� F II N II f U - II II 10 II 11 I I P I I{ II N O m N v 41 fi➢ \O 111 O O1 m o r es O 1D N 01 H d' M O N O F m O O m tl' II F II 10 r7 o N N N r r t7 N h H d w m r 171 r1 F 1D d� +P II F II d' 61 01 F m N N 0 p N N W M N P H P o P h v'I pr m m rh m II H II aW N O U w m m O N N l0 M O ri M d O l9 h h d d in m N W II 171 N U YI 7 H T 03 H H H MN H H H H H N F N H 11 M b rx u U) k � W ✓ N d m m h O1 O d d CI' c7^ m o O m N w M ry h m m h [h rF M II m II hhhh m 05 O [ O 10 5O l0 O tD O1 1• N O5 m W m £n !f1 H F t0 F M Ot N N N m IP C II w 0 C1 m 171 r m C ¢f C\ 11 m N N N 61 Ol H m 1 N m H C11 Il O II a a w u an d N n ni o ri n IN a r' m n cv v a a v + r m r a a n N 'i< q• Q N U N ti C dl II E+ Il � � • II 1! II II 0 O F M O M VI w d t5 O -ir H m ['•- m P h M N m N h m m v O O H O n m II Ln V 111 m m h w v m d O m m d v N i 0 h W m w 0 dl m dl N II r7 m 614 N H F I+1 N 1 1 N m m N T m H m H P1 1 1 M F 1p NC 61 m II .�-I o �+' T m d d d N d N N h N lfl o h II Ol II N U ry d dl M II N II a' II II LD � 11 If II 11 C W •� O m 7 U ii F+ a w tai rd T E w ¢ 11 w 1+ C w sd m F ?. 197 m sy a 0 7 w ' k1 C O a A C H W C D1 •'1 O m U b U O Q w a a -y w U al .C] Q Cn a a u -.Ci a m PI u .] m i in U w w Id SIJ U 41 rd a �4 E - M 14 C Ip - + E '+ Cl w O • ." C - Ix -.7 7 m N S4 X re -.f ij Id m 14 'y Si 4a ,C .-1 sl Ief y U 11 4. v w 4d a w r-1 J I La V N w 7-I m Q 115 1J y til a 41 4i -.I (fir a m � QI g m "6, "y� s4 b va, v °1 a 'a m `" a, m o o a 4 (C3 a S re W H LI a C O RI U 7 a w 'O C 1-I ro k 7-I al rn wanaww0EHm w a s � � EE yH ❑ wC laE+ caN F w w H re U H N o W m o o m [11 G N r •" H H M 61 rl W W -H 0 0 0 0 0 0 0 o O O H H R H w o N I'1 m '•D m O N 'r 1.1 I'1 1-I T N m R H m a y d d .� d H H d d d m N N N GL a I'T N N r^7 N N a' CI d' 'C' d' a re N h C a-1 H O p1 [q 1a VI C dl V' d' W W �' d' Sa d' W VI (� U aT C •d' d' d' d' C d' C A '-I a 'ql 10 m R' O W 01 I 1 1 I t I I Y a I I I •� -M I I I I I I I I I I I J.l 11 U I 1i aFa 10 La N N N N N N N N [V N W N N N m N N N N N N N N N N N Q N d O •Id ul m m N m N Ln to m m In m N N m m m m N m N N N a S m N W O O L'i d rd d d d d .-I .-I .-I d ..7 m H ri d a d d d d d d H H H d H >•! N H �7 >.] X N4 a A m m m m m I rn m m rn KC a m m m t/1 01 m m m rn m m m m m m y .-I a a Q+ �Y Q w �7 H 0 O ❑ 4 .] •O d I i! W w I I I I a I I I I Fi t I F a I a I [ 1 I I I I i I Fres ♦J G I f-' Nm GM S.I MM M C M C1 M M o M 0 M M M 0 m p a X a o 0 o 0 0 0 0 0 0 0 o o 10 u 0 0 0 0 0 0 0 0 0 0 o Id a F+ o O W m 3 W W W ww 10 W m w w is irz m w 10 a 1D w 10 w w ca w +a w w u+ U q H m H Ix Division Performance Measures & Goals for 2017 Division: Wastewater Completed by: Matt Stevens Date: June 1, 2016 Performance Measure 2015 Actual 2016 Estimated 2017 Projected Flow Rate (MGD) 1.27 1.3 1.35 Tons of land applied Bio-solids 118.38 1000 300 #of Pump Station Failures/ 43 25 25 #of Pump Stations 21 21 21 Compliance Monitoring Measures 364 365 365 (#days permit parameters are maintained consistent w/NPDE-S permit) Division Goal Related Goal Objective Oversee completion of upgrade -ongoing communication with City Engineer, Bolton Menk and contractor - monthly project meetings Preventative maintenance program Maintain efficient plant operations - inspect 21 lift stations monthly -clean 21 lift station 2 times/year -Quality Flow annual lift station inspection -ongoing inspection of sanitary sewer system -jet 50% of city sewer lines/year Quarterly inspection program-visit major grease producers in the city Coordinate with Building permits- review information on new/remodel FSE's Public outreach Reduce FOG violations -web page -workshops -community groups 08/10/2016 Sewer Fund Actual Budget Budget Estimate 2013 2014 2015 2016 2017 2018 Operating Revenues Usage Fee 1,604,673 1,689,080 1,812,117 1,860,000 1,915,000 1,970,000 Other 8,603 45,061 6,359 3,300 4,000 4,000 Total Operating Revenues 1,613,276 1,734,141 1,818,476 1,863,300 1,919,000 1,974,000 Operating Expenses(including depreciation) Personal Services 500,867 464,622 453,554 532,650 553,550 571,850 Supplies 130,128 136,169 108,816 217,800 206,800 209,300 Depreciation 977,931 977,931 1,017,240 1,424,350 1,425,000 1,425,000 Other Services&Charges 689,168 460,139 461,914 517,200 552,000 589,150 Total Operating Expenses 2,298,094 2,038,861 2,041,524 2,692,000 2,737,350 2,795,300 Net Operations(including depreciation) (684,818) (304,720) (223,048) (828,700) (818,350) (821,300) Non-operating revenues(expenses) Connection Charges 629,092 560,580 748,936 492,700 500,000 500,000 Investment income (232,971) 297,200 90,135 80,000 80,000 80,000 Other income(expense) - - 1,718,360 800,000 - - Total non operating revenue(expenses) 396,121 857,780 2,557,431 1,372,700 580,000 580,000 Cash Available for Capital Outlay Net operations including depreciation(line 20) (684,818) (304,720) (223,048) (828,700) (818,350) (821,300) Add non operating revenues(line 29) 396,121 857,780 2,557,431 1,372,700 580,000 580,000 Add back depreciation(line 16 ) 977,931 977,931 1,017,240 1,424,350 1,425,000 1,425,000 Other Reconciliations to income (215,111) 5,790 (325,539) Transfers In(out) (115,000) (118,650) 880,000 (100,000) (125,000) (125,000} Total Cash Available for Capital Outlay 359,123 1,418,131 3,906,084 1,868,350 1,061,650 1,058,700 Cashflows from Capital Activities Capital(from CIP and Operating Budgets) - (1,929,636) (10,820,930) (5,012,000) (100,500) - Bond Proceeds 9,984,625 - Existing Debt(P&I) (200,293) (571,659) - - - - Debt(P&I)-2014 Bonds(20 Yr Term at 2.96%) - (261,49 66772,,400 (669,350) (671,150) Total Cashflow from Capital Activities (200,293) 7,483,330 (11,082,429) (5,684,400) (769,850) (671,150) Cash Flow 158,830 8,901,461 (7,176,345) (3,816,050) 291,800 387,550 Beginning Cash 5,287,842 5,446,672 14,348,133 7,171,788 3,355,738 3,647,538 Ending Cash balance 5,446,672 14,348,133 7,171,788 3,355,738 3,647,538 4,035,088 Target cash reserve amount(note 1) 1,720,706 1,280,930 1,693,162 2,015,350 2,039,825 2,065,455 Total Cash Available(line 55-Line 58) 3,725,966 13,067,204 5,478,626 1,340,388 1,607,713 1,969,633 Capital outlay coverage 1.79 (0.19) 0.35 0.33 1.38 1.58 O O 0 0 0 O O O O O O O O b 0 O a O O O b o C 0 C 0 C 0 0 W 0 w 0 L7 N m m n o n n dNO R m In •r v7 a a' fi7 ti N N a P a o o P P P 0 0 0 o O P P o 0 0 0 0 0 0 p a p b o P o 0 ❑ p P P O O O Q O O W F h N W N N O N N 0 O Ill01-1 0 14 Ch 01 O a ❑ m m Ill dr O N O a (p N N N a O U1 H Ill w o o o Ot 01 O O r 41 r O P m N N N I ❑ W O N N C' a Ill N N O O O - F N N .4 n rn til m r!1 I Ln 11 I!1 r m m In In M ;n rn r1 m In v1 In a 10 d 0 N 0 0 O P p O P a O a O o 0 0 0 O P O P O F O D P P o 0 0 0 o O P o w rh M o 0 o O r r P P O o I W . N N O N N O N N lD Q O O 1 R m m m Lo co m m I U N N N I w v Y6 Ill H r O r O p W 1G n o 0 r r 0 0 [- � � ra rl r1 N tl� rl r m to w N m � r! rt o o r N In rE rl N N W rl N l+l lit 1D w r1 rl av m O O N a r 0.' N p N N W m N Nh m m O! T O O N U m N N i°1 Ln .-I .4 V' rf mO O N In 10 r r o o r W U)) .4 N N ri ri rl rl N 13 W cl7 .-I .-1 QI o m O H rr o om 10 O P 6 a rl LA N ® N O] w W tR a P HNN rl � �L d N O N T P U1 W wmw O N N N h N �+ m o m m m O a s O F 01 C r+l m m g a r1 n1 m '✓� IQ' d N U N M �➢ li1 N N ri h H Ul Q r N N U R 6l Ol. '-I ep h f'11 N Lf} O O O O C` O O O O a b O h h n N W r Q1 l0 N N 1 1 M 1 O'.r M N ri rl N r In V' m M Ol o M N o N M o N U N N 10 10 N a rl N N m La 03 m N G fD > w L it Jqd U v IK O to m 9 m aml O m ¢�1 4J 7U4 tai C7 w O U) E m V .13 E U a U >1 m a3 C. O O 41 w6 C u m U} m (" 14 m y C O to O G 4JIt rl N F E a.1 m � O rl Q1 U E L u la N H m m .. c1 u m m GN u m ❑ m a) W m m W N W m - m m @ m O w > -'I f1} >a y N sJ U O 0 41 C Ul > toE lr O m G m L 11 m O m m U C a) m u a G •.+ N i, m m a C 9 H O r� C 11 P: m 2) m as to m 3 3 O N 1Ca F P4 aj QIpYY m •I a fs7 m 11 as a4 G N m O -A q m m w N G 9 t m m fK E II .4 C W N a rn En ttl ❑ -.f u H is '+ O 7 N m F Sa G .i N Ip 11 1.1 E o m N N 1 N N m N o O W J3 11 O tj1 rl ri W w II G m N -N N N N G i } h m m G II G rW L N F N m N W 14 11 61 m w U m 10 1p N h h 11 -A m 0 rn C $ O II m m W 0 w c91 m G W ri F F li E N rn 0) 7 Nl rn r1 m ri O In ,C C m 4s a rn x C r.l m 4 li C m 1 a f, 1 1 L 1 r m C ♦+ H 1 14 a.1 m n C I C G 1 11 1 Sa a w 3 fa n N m o ql w o o d o o al m 0 0 o f m C 11 F1 o ff m o d o E- 0 F rt w v If m R o } o a p o q o m o m m n m 10 > a m m S O o ,.] it O 3 II > 0 a 0 0 s] S1 P .] N o Z a n N •N r+r p H rh rl a n m m1 F N mmL Ne N O F N mmG NmaI 0{-• O o w n C m o P u o >4 w Q 1 11 H W 0 10 10 to Nm4FH w O 10 F W II rs m O w F m p N W UJW V' W y O 0 N ul w N a w N a Q O CQ 6 E- U) Vy W Qs N O fY, P4 N w N I Q F o a i r-I v� .-I 0 N O I H F C? Z W 9 I W - I a � m I m N I U m a N cn I� m LWL' N Cg F N ? H N a m W E ui � w a W q a W p r 7 h + P4 °a - w • N D o w W o F 4 o N a h N C!f N u 4 r rn .n a M � rn 0 0 N � Q N U7 W Q w W a' F w' V1 N W W ,1 ey 3 H W Q F U1 W N ] W X a ] o � z .a Q W o �+ a F 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O O O O M Ill In 111 In in O V1 00 O O Ill lO 0 0 0 0 0 0 00 m O O O p m 01 h m m H m p b In 0 d' N W m W O@ 0 O H H O O O co W F W H W N w Ill N H m U1 N N Ill w I!1 m H H N -1 Ily w H IO m W H O N 01 H MN -1 H N 10 N W d No P,[} W A H a a a N w H N H H M LL a w H H N Pv 0 0 0 0 6 P 0 0 o b P o 0 P 0 0 A b b a O O b o 0 0 0 b 0 0 0 O In In O O O In m O O O O w m 0 0 0 O O O P IO 3!} P P 0 ❑ O 1 IO M H r 1 O O 1 /1 C 111 N O 1 1 O@ ti0 O M m O O H W E r 0: W m 10 IO H N N O N N 1/1 IP lO m H H 4IP 0\ v0 01 Il} An w H O C7 0 4 w w N N r O P+ R ❑ N O 7 d H N H O H m m 01 H H O O O O r M w O O W O O 0 0 a O O a 0 0 0 W 16 h H H ry N IO N N W O1 w H ry w h 0 O M m O O w F �➢ M N m m O a 4' N H H @ O M M O O r F @ r H O N N O O O I d I 19 H O N 0 0 0 0 0 0 0 0 O O 0 0 o P 0 0 0 0 0 P 0 F P o O P O P b 4 b b mO O O 0O O O O O 6 0 0 0 0 0 L] O lO O O O O O IO + W 1 m N Cti N 1 m In N O O 1 tO M O nl w w 1 @ a 1 C 1 W N N N In ti0 +31 M H N@ r O N N O O w I PrJ� m H H N N V' 4 r r b D Vw ^ CL rl W V' a N w H H m I U H H N i 10 m �+ w o w m a 1a w 10 o a o m a m H w o o h O In o o ul o 0 o w w m m M a w a O r VI V1 b w N r H to a@ m W 41 O b 0 O H LL'1N H In O O N M h r o H p FK N O E O1 w@ H H M Ol N a In lO H N h m w r 0 0 0 m W N U h H H H m r ry O N N a Qi H O O N N H r-i 1n H W E P rHn w N ry ry d' v N Ill H r r m O h 0 m w a O 01 a H In m O m O 1l1 O1 0 0 0 O w m m@ H H r W m m W m w H r 0 w r w m m N W m O r w m O m N Q h N m a 0 r m m 10 10 @ Oi O N aT H H IO N O i 1 N Ot N W m 1 1 O w H H 'J 10 tl1 w N o m w H H a@ a m N@ H H H h H H In r co O m m PI r. O F ry H O M1 ri O H H m N H I!} fh H W m N i!1 m W M r O O O IO O M1 w w h In w w H m m O h m O m O O O 01 m d\ W Ot ry m m m ry ry W m O Ili H m m w m m MI � a O a O O O w ra h N H H Ot r r Os r r Ol N O N d' W O O O M , H `y7 dl 111 eM sT W m h -0 1'r m m m H H c+ N N N CJ In 1n W O ((J ry O et H r N N N O H H 19 N � H H O1 ed M N m H H G W O H -rt m 4 m U G U C u m [3 m u U N H to w © w mW > Wk u m +1 C C -.-1 yl w O H w uCi ami uwl N 0 Sw1 & -QI �G1 CJ N En E -H C. Cl W a) LI 0 w w �1 H m w k P U A U F L C 14 04 Ol 01 w C -rt O m U C w w O [1) Id -r1 O C. w O Ot Id •rt m m U' p -rt a: 41 w U W 7 w .+ w -H V w U C F.zl 1f H w � 1 al w w U U Ul W w is w S4 k C I w N U) w a) w W k k rt k r4 k C W -rt w C. w W w fl+ O w - A IX -rt Q W W 4u m w w k W u1 115 Oj k H k V k w F-I V LI k +1 w W W O W c� r� w rt 7 -V w -H b -rt -rl b -.+ w w 11 ,� H .H k W -.+ p w q 'G V C D •a £ d G 91 tK 6 2 '0 m V, W w A V 01 to Zn.tiff H 07 rt 0, w •H w w C -Hy � ea C LL W O w w t•+ L w C U w U � fa w C tl w 0 W r w Wk N a A09 k m m - W F - W d' W G. O £ w 3 © K W .7 w O F a+ E W p U Ql S. F F a vE H Q(i U H a In w r W N [i H -H H m@ m !T H N H 41 4 0 m H H H m Pn N O W a k -d o O P 0 0 0 0 0 0 H m 0 O b H H N N M to o N m k O H N N N m W N W , >7 ,1 rl .-i H H H H W N ¢¢,� w M M M M m M M m M a a a w W 10 W W 1-1 it r h (. N H E W U1 Fa a V' a a w a a k @ CL U a a a a a a a 7@@ Iz S 'A W w I i i I 1 ! I w I p -rt' I 1 1 1 I 1 I I I I I L V I ! 1 a7 O I 1 k to . . . . 0 0 0 -rt 0 0 0 0 ❑ O o F H H N i17 a H 6a 01 Ol D1 01 al 01 Ot � a1 4ti r.G U] O1 Ol S31 QI m OS Ol D1 m 01 01 61 � w 01 Q7 Qt 61 f7. w Q1 1T a I C, waI w p O cwkN N N N N N N F F N FFF F .G N N N N N N N N N N N N A N N N N N N F W O "h" wO P P P O P P O J-10 o O 0 0 b 0 0 0 0 0 O yy O o O O T410 O w W PI 10 w w w w w to Cn w 0 w w w w w w w w tp w 1Q 1p p.1p w w 1p F 10 w 0 0 0 0 0 0 0 0 a 0 0 6 0 0 0 0 0 0 0 0 O O O N O O O O O a N N ❑ ri O Q O 1 0 m m N N M O W N O Q 1 0 O N 1 9 1l N W F rZ N U ❑ M N N Fn o LL w a a 0 0 a a a a O O O a 0 0 0 0 0 0 0 0 O O O N Q O o o Q N o O Q d Q a o o O Q o o o O O O A N o m M r-I h N v N M o m o 0 o w o N b r 00 as W F r N W N Ol N v d , O M W " w v Q N N v d N w 1p N N N O 0 iz m HN N N NN M N ld N H +-I N w N 6 e Q N d' H N N M iY IA A. f l0 lip m O n Ol M r M M O r r N ra da N tli r m M f ❑ to N N ri N I+1 1 m M C d' W M E u1 d1 V' M O N h r rl r W r rr ri d� c M w sT P I N r-I r-I r-I N N rl N m N r-I to ri d N O d a O d d a 0 a d a d a 0 a a 0 a d 0 0 0 O N p I[I I!1 N o 0 o p o 6 0 0 0 6 o a o p N I z W(7 r o m w W N d' M o m o m o 0 0 o a In os st o n In O Ot N M d' O O M N ri N N ri N N r Q N N r r-E N H N NH � m w N N � N I � I k0 C N r O m r M r m N Q N v 0 Ir Ir r l0 m O O N In m a ri o a w r W M rn M r N r N Hw a o w ri N N r a Q kD lQ N r O M M r 4: V' d1 l➢ m N d C ql O i Pi N O r-I r y� O N M m O N O r 01 Qi d' M N O 5!1 l0 M M F N N N N M M M W H w E C4 ul m � fn W ❑ ..1 w .7 m q� a to m y� r-t ri ,-6 M 6 rn N o W N 'gyp r-I p op 00 m r> 7 I*1 o h- m O h ri v h N M r-I r N m M w m r r N P4 o r k4 r N lO C 1 r O rW - r N I t lh +'?m N l0 d ri d G4 O d° N ri r! eN N m r-1 r-I r-I r-I o N N ri Win' N Q N M ri r-I h r+ to N m o In ri [• ri altm M �. M N N p N N W o Q N Nm d M m.M m h m N m N m m N N Q 1 O r N M m O M lO r pl 1 t N M ri .7 O V' 1p M M M N N m ri Q F N r-1 .-I rd M p N M w N t0 Q N N U .yamy FD N cn ElW N C u 0 r" rq v H ed m ld r ad fn N :j fd SA 14 1J N z W m P. O .+ .-I C U U F ar E w u u C m uEn m U a [ Z S4 E -� w C w �i -rI 6l vl C ❑ .� a U E .ri W u ? fd -rl a.l N rd a.I E b5 Id N m k4 N E rt ri yD I Q u lr1 w Id PL I'. F4 v -r4 !� }l 0 W U a N ani � c5 b m M mar v fU m m G -moi X u c w a > 6 w r, v c a u c b , car o m �r a w F N P4 O Pr W G4 g I-+ W 6 W N I-+ @ 1 v 0 M G/w k0 U N w y rd ri rf N r-t N N U1 NN N [1e N m M M M <p ' G' fC N -M UI wi E f1] S1 w al W W d� w sa w VI W 61 U 0 V' i i a a a .0 �-i a a F +S w y . I I . I . . f , I g -ro . r . r . a.I u 1 -n 3 knm Q Q o Q o d Q a O d o m S d a o Q o d o 6 o V r'I w C. N N N N N N N N N N 44ss N N N N N N N N o E rd n to .d ti f6 m w m. m m al y m cr rn ,cC m m m M a. M m I Ia crI Er w ,-I I m 0Nkc. 3S )wS E- F- W4N N N n N N N N N N N N ra o 0 o 0 o 0 o a o L. ww m a s p Q m p w F ko In w U I kp 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 N o 0 o O o 0 0 W W O W O N N M W E- m m CO) W rl N M M t7 r O a0 § A N N N $ N O a a m a o p o o g o 0 0 0 0 o a o 0 0 Q Q O q o O o Q W q W q N N M W E r 0 W N N o o O C7 R N N N O 'FJ7 0.'i Rl a I 0 0 0 0 0 0 0 N O N M O O M P I Cl J; d' W N N to I '+ U I � W N Q I W N O N c 0. O N W N M N O N N n W N N N I U 0 0 0 0 0 0 0 B] N O W O O W m N rl tl' O N M Ol N n O 5 WW N N r�xWnI F � J M .tis W a a+ W 0 0 0 0 0 0 0 0 0 o P M o n r h m io m m. o n M O aN In Q .1 W a C. O E r Y+ A, 0 Q N U E rG H [fj U rt w �D M tD m W r N c7 N O N .i d P^ N M M rs .y rl M N N rl M i`Y W 01 d' N W N U to w w N V U -yamy .yd a) fa m v cn m N 16 C w w F •.a w v 0 w o m v rn (31 a u m 0 N a w u b „ O R a x z s4 E � 0 ""� -Hi v (D a s w rW M Id lJ Iy� U k 4a 16 L4 H L4 P, w U aj G+Y Lo 7 W tU C W LL 6 air � m � O W O a r. $ a`+ O W m O W H w r-I "3v a Lo U H N v N r W 0 m W -M m P f a' L1 -.1 Q Q Q o o Q O +--f N ri w rl o M S4 �. (YI W O "J r-I rl rl rl r-I +-i W N N L71 G1 M d' d' a iC d11 N E L M LI P C P P P P SI ft f6 W 1 t I Q1 ID 3 i+ N o 0 0 0 0 o a o o w y o 0 o p �--I W O M M M M M M M M Sad M M M o H i o o W 0 0 0 .7 N C!7 H N ON m m m m m F( m Oi x� Ea T R a G H I p S W W 60 "I �r as a w sr N N NN N N N ,q NN0 0 0 0 0 0 O O Y) O O OW aW W w w ww � w O �n w w U. O O O O O O O b 6 0 0 0 O O d uor n o Idn or a tou m fR W v1 ul p V' N N r Q N WO w a w a O O O b O O g 0 4 0 0 0 O O O b b p 0 00 0 ® If1 1 O O h h h W F h 0 H N H W m d' N c0 o W A •+ N N N M N O a P4 a 0 0 0 0 0 0 0 0 m r W N n r m I Q � Itl N m M m N F N + m m m F N N M � r U i ry 0 N 0 0 0 0 0 0 0 0 O O O q P P O F o 0 0 o d b o W 1> of o C 0 0 d W . In m a i® <m w o 14 cq I U 1 iD ..7 W N b Ifl lfi N O ry � 10 M O P P O N W F N IV a � m c4 O da' d° Q Ifl C M M M M 4O PI rl dl M W b P w W F-I to U Q w mor ut In w In m In m .� .-I .a N m rn. o M to rl r w o M r N N o H N O ko r N r d 10 1 m N U Q In N u .H`� �1 N W l .Prh i N m a w rt 5+ >+ rt W A [q � .� U bL Ip IC 'd -A a m E• r+ U I u 6 a $I a U y w W m > m W .+ y r a s u U7 Q'i O FL W C4 H rl G. d W W W C u H N n C 4 r m P N S H -.Hi � � N A: O " o d o O d b b 0 H H N '-I W o t4 ?. 'FI N I .-a H H m N N N f-L Gl d° 01 Id N Q la W aJ I I I I t t Qy I i I •A I 1J L QI �n W k [Y. cry d o 0 0 o p p G o O d Ui 7 o O wrl W G} b ' a V' w W d' VI d' dl d� !a 'd� d F a F ,.a N U] Q H Id 1 N N N F N N N m O 91 'f. tJl O O O d o © p '.� 0 0 0 o o W Ul W LL l5 �10 6p 10 w w wIq t0o 1p0 t0o QN Wp U o a o a o 0 0 0 0 0 0 0 0 0 0 0 0 h a o o a o o a o O N O O N O N Ill t� m co W N N m N Ln 0 a N W .-I O 0 aN O ❑ .-I .-1 .i a a m a o a o o a o a 0 0 0 0 0 0 0 0 0 0 a a o 6 a a o o a o ❑ N P P N p lel Ill NV� N Cil F h UI CI N N m N N N h m m m •-a O t') GG N Ill O Ill 11l lil N P: GO a i o o o o o o a o m m.m N a m a o tD N ISi d� N m h ID m F L7 N M m dl t"1 W I a P N 0 0 0 0 0 0 0 o a o F O O o 0 0 ao P P P o P P P P G7 O Vr ID O O 1e1 lel alt W U P' M N M m N o h I � ❑ rl H 111 I U i Ln 0 0 0 0 0 0 0 M C M O M M �D O O Ill lD r7 1D ID N d' ri Ill ID O o m N le] lf9 M C• lD a h C a N OU N C A m {{�77 N Ln N ✓ 07] W A W N h� o P a O 5 m N m m Cl N . da C N m N N N lD m ei GL a tr o f w m M M E. A', Q k � U Q N lD M N h O N ID .i N O m v [p 16 s-� N rf O Ib M Ill m N en m ID m m m N M .i W N N ri M M N r1 ID O m rl a ID a F N r"b .i ek I[1 p dl N U d tl3 SU L1 ..I SI Ol C.7 W L N •Ci 4) EO fu ol q u £ C11 �v m R b F4 .roc > m u� a � u cn re - ro ro � �. ., Q u (,0 . m ea R, N -�+ GL u c a C >•I a IS •N v re i. •w Iti •A •N - a� 0 w v > w H a U' S a u Fs '� a ." m F m a o T W s� W O w v '7 W En°a) W 3%l rl U N N v 4 h m !; N m H -rl m y a ro Vl •d a o a a o a 0 H H N N CO W a FI 4D L N W m ri rl N .-i H rl N N N N d N M tl' N ro Ih -H U N E en c w m w a s, w w w a u w X; a 0, w Q Q Ql f I I I fU I P f w 3 u] o 0 0 0 0 o a o a a r > o o O o U .] .� w 1J try uT In art m m IA N w fa m m O itl N UI L H ro m m m m m m r.� y m m m ry' co K� U! ❑ C I a I JrrIr <r I I E" •M 1c* a J 1 I� of u m vi w a' w p wF m 4 N WP, la N N N N N N N N' N k' d) O a o 0 o 0 o a o 1J O O EC O m .] W a ,D W b wID W U) lDP aD IRo O m ID U lD 0 0 0 0 a o a o u a n m In fl Ill Ii q d' II T If w F II II m Lll w rl II h II [w7 0 R q umi ii o ii I¢ No � II u cl, x w ri n ri n a n n II TI 0 0 0 0 00 0 0 u a u a II O !1 q N 11 N EI W °cl II it h En N II M q o 2 � ❑ 'I) II N O P n n II II I m of m m m 04 N m 1 w II I m mN N N N a' m n m II I ❑ t.7 h 1 r N o C 1 N N m if F r In Isl LO M a ii m if k{ n N rf N M II N A I II 19 N N 0 0 0 0 0 0 o p u p n FI F O C C O O o II 6 II I w W O I O O O 11 a II o O 0 C- 11 4' fl CQ p p p iN II N II U + N ll 111 90 II I!7 II i II it II 91 0 0 0 0 00 O h II m II ca to p: N o f m Iv h n �✓ F N � � ii m ii N W F 11 II AL G9 N II N II .d 6 II M w a a o a rn R n n �I W b F h [I Ifl II E 4 O N Q Iv iu � ii F-4 SR N II II U A,' II II I I N h II M II r� .7 Itl II w II p F r� II N n Q n n N II II II 14 it U di L C O uF U 4) aj U] UU ..y m ®)m 41 U7 4 tL k Ol Q a W F V] L, Uri C 0). U G -N 7 ul W W m4i 0 16 w . L 1 N z Q } 5aF O 15U) $W m ice. W W U a) I"IPA N M M m a +6 W Ix 0 4) 0 N o w N w 0 Gl +� I+'. a m n1 Ira •'I CL H t ca u w a .[ ,-r a F 2 a In G w M o © 0 0 o U W rl W mf W O 0 F PI F N a o p 0 .7 x N N 5C N u] m m m rl m 1 W N w 0 w Im a 3 X L o o a F Itl a F F O W w 3 w 0 to w ko U w F m CITY OF ELK RIVER EQUIPMENT REPLACEMENT PLAN 2017-2021 1■ 1 r=fes INTRODUCTION AND PURPOSE BACKGROUND The Equipment Replacement Plan is a ten year forecast of equipment replacements in the City of EIk River. It is intended to inform and plan for the equipment needs in the next ten years, with a primary focus on the next five years to align with our capital improvement plan (CII'). The first year of the plan becomes an adopted equipment budget and will be funded out of the equipment replacement fund. The remaining nine years represent an estimate of equipment needs and funding capabilities of the City and are adjusted accordingly. Funding requirements vary from year to year. In order to maintain a fairly consistent levy, the ten year plan is projected with a 2%inflation factor. The cash flow requirements to fund the equipment needs in the equipment fund will experience some ups and downs over the next ten years given the projected equipment needs and a 2% inflation rate. The goal for the equipment plan is to reevaluate at least annually the requested or needed equipment and maintain financial viability of the equipment fund over the long-terra. to Ifs kr)O 00 r+y 0 N rti r( Ui Ot 10 CN Q d d C a O ' cn a o ^ N on SCJ l- u i �l 1 A Ca M N 00 Cit CJ rq N M ON kn vn m O fV00 W � � M N N N a n N M 000 M M C "o 0 N N N O Q _ 't kr n C C) tME + p O ' b , 4 W W � g g � o Q Cl o C n r- r; C 000 N vNi QC C Q N N !-�. tokn •r F N rr {l1 tn kf) ON 00 tell W p C, C cp ill bit qt, Ilj IyD 0000 Q r- V1 V1 M r ti � N � r ,^ O 4D O O L t0 V) N 00 M c+1 CV ,�- 00 W3 N M oD %& 0000 N M U N 00 --� t C A W H � 3 t�S _ CZ > w M U © 0-4 0 E4 u F* Z o 0 0 0 0 0 0 0 0 0 0 8 \ S S 0 0 2 a 0 8 8 11 \ ¢ ¢¢ / \ g LU ®ƒ � � � � � e / \ ) > > > > R / 0 / / m < © / 0 # 0 » w ¢ \ \ / / \ > > o 0 0 ; e > \ / E / J ® / / -2 / § k E U) £ i ) J ` ) § oLo ° \ _ 2 § 3 § 0 - E o § § \ \ § Z > A 4 \ § 0 S 0 2 n 5 E § c ƒ 0) \ \ \ # £ k \ 2 2 o k 2 « $ . IL 0 \ } 0-\ g U- } . CL a a- a) - [ § 2 % ) ` 2 \ 2 § $ \ k k ) _ a o 7 = _ _ CD� � e f / / § \ � / / } E a il CLƒ ) to m / 2 § _ \ W 1 3 J _ . � f g 't r- a 2 c 2 = z a a \ » \ CL a . § k ) ; o o b § r § o u o 2 £ £ £ ° k § E = m = m m ¥ o / LL 0 0 0 = w 0 0 2 � G » 2 2 e k LL 3 § £ J A / i = n 2 r o e � C / \ R § \ \ \ \ ƒ o Cl) c # < w < a y -,r / ' k g G E 2 2 2 r z % k . & 0F- ,n . m $ J z Cny of �, lk1% Mechanics Vehicle Evaluation Form 11LVe!r Date: Vehicle#: —7 Year: Make:T Model- Miles/Hours: Current Score Forecasted Score Future use by what dept, ry ot,Auction? oyc�) Age cr'C�) o� Usage =2- Type of Service 3 Condition / r� �k°-�`lo►V Repair Costs cc� Total C� Point Ranges: Under 21 points Condition I Excellent 21-25 points Condition ll Good 25 —30 points Condition III Qualifies for replacement 31 points and above Condition 111 Requites immediate consideration Relia i 'ty (Mechanic's Evaluation): Iw � Pwrnp r.f-w( 5 x:%/1 �crjn� vim_v ,4 b 6 UNCI ae-- L- L1,4 yo 01 fj . a PCL) Evaluated by: `-it "7 of Mechanics Vehicle Evaluation Form Date: I `J,, ss���� Vehicle #: / Year: Ofk:43 3 MAe:t✓f11 I Model: Miles/Hours: 00 Current Score Forecasted Score Future use by who dept, or,ruction? e USW r7 Tm of service J)) Condition r ! Re Air Costs / Total L1 Point Ranges: Under 21 points Condition l Excellent 21-25 points Condition II Good 25—30 points Condition II] Qualifies for replacement 31 points and above Condition IV Requires immediate consideration Reliability (Mechanic's Evaluation): Evaluated by: f � 2d �r City of _ Mechanics Vehicle Evaluation Form .0 ver Date: '`>��`q- 14, Vehicle#: � Yen: AC3�- Make: �l,f Modek le Miles/Hours: C3U Current Score Forecasted Score Future use by wbat dept, o4 Auchan? Age 13 1 y USW fd 9 7. --.-) Type of Service S� Condition 1 Repair Costs Total ! • Point Ranges: Under 21 points Condition I Excellent 21-25 points Condition II Good 25-30 points Condition III Qualifies for replacement 31 points and above Condition N Requires immediate consideration Reliability (Mechanic's valuation): Evaluated 6y. � ����� �� �•� C+s4� f _ Mechanics Vehicic Evaluation Form `ver Date: Vehicle#: . 1Year.pad Macke:tk[2 ModeI: C' Miles/Hours: Currant Score Forecasted Score Future ust by what dept, o Auction? Age Tyw of Service I Condition / ! t�3�3•a Repair Costs Total 1 R j Point Ranges: Under 21 points Condition I Excellent 21-25 points Condition Ii Good 25—30 points Condition III Qualifies for replacement 31 points and above Condition IV Requires immediate consideration Reliability (Mechanic's Evaluation,): Evaluated by: ) City of Mechanics vehlkle Evaluation Form Irl Dept: V8/_i River Dater/10/no Vehicle #: Miles/Hrs: `� c3v Year: c_ O/Q Make: VC_P_Q Model: L Y, Curamt Pr(gvctcd future (7rher � Cy de scare scom DLpt or flu ..+' Age7 11 jp Usage ?. , Type of Service r v� Condition Repair Costs f To r Repair Costs: $ 3 70 Al, Purchase Price: Specialties (decals, computers,accessories, etc.) $ Projected Mileage: 6 7 O Reliability (Mechanic's Evaluation): Flag File Yes ❑ No ❑ n L- meAeA Gond P6� ?-k r 4-1n Evaluated by: Point Ranges: Under 21 points Condition I Excellent 21 - 25 points Condition II Good 25 - 30 points Condition HI Qualifies for replacement 31 points and up Condition IV Requires immediate consideration Completed form due to Fleet Chair by May 31 City a EMechanics Vehicle Evaluation Form River Date: Vehicle#: Year. Make: ��� Model: f'� Miles/Hours:A 4 o 22 Cuirew Score Forecasted Score Future use by what dept, ox,Auction? /r/ I / vac Usage Type of Service Condition `7 Repair Costs Total Point Ranges: Under 21 points Condition I Ezccllent 21-25 points Condition II Good 25—30 points Condition III Qualifies for replacement 31 points and above Condition IV Requires immediate consideration Reliability(Mechanic's Evaluation):. Evaluated by: l` Z" Cityof Mechanics Vehicle Evaluation Form E��r Dept: PA12 ' River Date: Vehicle#: �c� Miles/Hrs: _ Year: bC3 Make:6k4'LO Model: 5&-Ldle Current Projected Future-Odter Score Score D or h on. Age Usage Type of Service Condition Repair Costs Total ' Repair Costs: 8 0;130©. 00 Purchase Price: $ (P54.2.00 Specialties (decals, computers,accessories, etc.) $ Projected Mileage: • � ,U Reliability (Mechanic's Evaluation): Flag File Yes No 17 aceta ; f4<e & ! 1n,�c �ecA+rti►�cnc� e P l t*'mtnT Evaluated by: Point Ranges: Under 21 points Condition 1 Excellent 21 - 25 points Condition 11 Good 25 - 30 points Condition Ill Qualifies for replacement 31 points and up Condition N Requires immediate consideration Completed Form due to Fleet Chair by May 31 L City Of Mechanics vehicle Evaluation Form Elk Dept: River _ Date6 /,2,0/16 Vehicle #: 7Zy Miles Hrs - �� Year. �o// Make: 70'-a Model: ]/d Current Projected Future-Other Score Score 22t os Auction-' Age Usage 1r//•S / 3 Type of Service S� Condition j Repair Costs f Total Repair Costs: $ ' y�2 Purchase Price: $ ��/-� . •+� Specialties (decals, computers,accessories,etc,) $ Projected Mileage: Reliabilit7,?1 echanic's Evaluation): 1 / lFlag File Yes ❑ No ❑ C O 6e qi C'�'i!l /7 c� 9 /�G G�>r' do el Evaluated by: Point Ranges: Under 21 points Condition 1 Excellent 21 - 25 points Condition 11 Good 25 - 30 points Condition 111 Qualifies far replacement 31 points and up Condition N Requires irnrnediate consideration Completed form due to Fleet Chair by May 31 tr � I 0 0 0 0o a o tl tl o a o o o " 0 c O O O 0 0 O O O O N N O O O O N O c O O O 0 Iti N In c O N 0 r 00 N m h N O Q O iq m C N Qi N 0) N N oN M NN O NNLo 'IN,F � N 0 � 0 r r r 00 0 Q 0 0 0 0 0 0 0 " O 0 0 ' 0 " 0 ' O 0 0 0 0 O c O O O O O O N N cc o O O N O O O ' a . v, tl a O a O O N N e 0 O O a a p ¢7�a C n N O KS P O iff i0 r M Ln 0 0) O N o co N �� N N O r 10 r +! W 0 — r n N tl C, r N r r r N d r QI N o p O N O N 0 00 O OCC O 000 . 00 0 0 0 0 ' ' ' 1 0 N O O O V O d O co O 0 0 0 O 0 0 0 cc OCCO 0 0 0 0 N O N 0 O 0 Q Q Q O O 0 0 0 O O n c N O N N 01 I!1 N V O O N Lr; N 0 Ori 0 N CO N N &0 0 M M [D r V m r 0WMNNN -- M a N10O M nor N Nr r N r p r r M N r 'a N r r ip r r t0 N T cc N N O O 0 o 00 0 0 o 0 0 0 ' O ' CC N 00 e} O 00 O 00 0 0 OOOO 0 O o O OOpi YCi r 067 O co O P 0 R N o N n O N NQ N M N r N r co fn r n N N M 0 V n r a n M M r M N n r 00 r p r r T T N r N a N ,r O O O 00 O a O O O O 00 O O O tl O O O O a a O N O N N N ' o O O O a O i0 tD n n a I[i r:r: N n o c co co m 4 co to 0 r fV M N N N V V r r {0 0 r r 01 N N p T r r T r N N 0 0 0 vo a o 0 o O O Q o 0 0 o Q o Q Q o 0 0 o o OCOCCO 000000000 y coo m O co 00 00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O O o 0 0 o O O O O O 0 0 0 0 NOOOOIn I<iN tla rN u1. OT 00000000000 00r SO r oov NanOoN v 018Nr0 P�: f•r NN N Mn N4+ a N D NNO NN 6 000r NN 07 1pNr Nlfl OOr00 r Omov NO NN NN b r NMr 00ONP- 1- i n 40ov r- l— M 0 T H N r r r Oi r N 'Q N N N MIt r r 0 N r r N N N r N U 3 N ■ 0 0 0 0 W 0 0 0 C y O N C y L 9 i+ C C c E 4mi U t y cWi a 3 m ro E 2E W c m CL m m m `c 3 m a w y Q ` d m � am t E p ro Q,, 0 m ro m W 0 a tEo m t 0 m p _ p p y m m z W p Q N A U L _c : Q� M lO N N w � � V V G 0 m Q E C N m L m m 0 L ♦- Q tY CA p O N r V M :+ Q y W m Q 0 y y g y m Ili m V d N Q' i0 L r m y m o f m a 1 L ro L 4 E ` m > 6 m 5 •%. pa ° 1Z'.5 ° � t YCL: CD M T � Em � ° a mEO � C � � m � � mc = rorz`_ nEy m 31� = WE ?s �; 3 � zuIr((n £ w > 00 > (3 ii � 0, Dwoaw 900 0 � � 3 � � w c 0 � C m m C 0 t m E u a W E t m L e0+i 11 m w U LL N a i i N N N edoloo .� O cr W C� °0° N � Imo+ N 0 g 00 lD d N O Op tD d N VIP- volo ilk ih th t/1� tl� if l�