Loading...
HomeMy WebLinkAbout10/22/2015 - Meeting Materials (2) T � '� may.'� -�-. Advanced Smart Metering Solution _—at m i kWh Daily Usage . . . . . . . . . . . . . . ♦ ♦ r— ➢ Two way scheduled or on demand Meter Reading. ➢Street Lighting {! { 3 � sEnsus sEnsus The Measure of the Future —00 ' J� c�sT�Net Sensus Analyt 'ics SW - Component : Meter Insight 09/22/2014 51893 600 7592 active meters orphaned meters inactive meters 290 50 34 stale almost stale No Read Available - Up to date view of billing data readiness Tools Help J Google(3) F Snapshots Quilt-Along-F... 1❑Login Change quantities,delete... Public Utilities Intranet Ho_. Meter Reading Home(2) ® ® 0 halt Lake Ci , USLC@water o . ._ . ..- System Consumption Last updated Tue Oct 20 2015 10:23:39 R1 Select Group: I Time CUSTOM V Date From 8/1/2015 r TOr8/7/2015 a All Installed Meters . Unit Gallons • ERe Total Meters: 31 120,000 100,000 80.000 (� 60.000 40.000 20.000 0 08/01 08/02 08/03 08/04 08/05 08/06 Sa Su Mo Tu We Th Date • . 2015 . . - Technologies, . - - - . AMI Software ( RNI) D FlexNet:Meterinformati, x F }� https://nrtc4.flexnet.net/sensus-site/imip/Info.action?id=36809134 FlexNet ID: 36809134 Location: North Baltimore. OH Meter ID: 303200000108 Time Zone: America/New York Type: Electric Endpoint, IConAS TOU Integrated Display Position: 41.1423.-83.6694 Firmware Revision: Flexnet: R4.2.0, Metrology:R4.3.0 Connection Status: Unknown-DEFAULT Primary Group Address: Encryption: 9f Encryption is disabled. 0 key rotations Transmit Mode: mPass/NM(1:8) Load Profile: FlexNet load profile.automatic collection disabled.inactive Transmit Rate: 240 Minutes Endpoint State: INSTALL.Cycle Not Configured/Not Configured Summary Configuration Commands Load Profilej".Backfill Status 1Requests(Recerved) From: „ 12112015 Single Day o I - Readings Cha v Last Screen Refresh 2015M-21 16:31:03 4.00 -------------- ------- --------- -------- -------------------!...----- ----- ----- ----- ----- 3.J5 --------- ---------•------- ------------------- ..... ----- ----- ----- Refresh from Database I Refresh from EndPoint 3 5o I ----- ---- ---- ---- ------ >>LATEST READINGS l o i i i i i i i i i iVj = 3.25 -------+---------+- ----- ------- +---- ---F---------+----------+----------+---------- ---------�-----------+----------F-- � 3 1 00 R 3.00 r r + ---- ---- 2015 01 2 15. 7058 kWh a Peak Demand 6.638 kW 2.75 - -----T------ -------- - - ----- ------ ----- ------ v a ALARMS z.zs --- %-------------- - : �co Power Failed No current or valid value. o 1.75 --------------- ----- ----- ----- ----- -Power Restored 2014 08A5 10 45 39 cc W 1.50 ------- I ; ---- ---- ---- Failure Duration No current or valid value. 1.25 --------------------------------- --*-----..... .... ---- ---- ..... Tamper current r . ..:--. .-�.- -.1-- .. .. - .- Meter Ta No nt o valid value 1.00 + + ----- current r Power Theft No nt o valid value Low AC Volts No current or valid value. 02:00 04:00 06:00 01:00 10:00 12:00 14:00 16:00 11:00 20:00 22:00 00:00 Time POWER QUALITY Last Meter Voltage 2015-01-21 15:00:00 Access From Anywhere ,quo My App's R POR,M ate . at `--r T .I �i�i•� idb�YdmpWb� ��=tiWk Im zbF40h�fm Component : Alarm Dashboard - Historical view of alarms 104 1626 p - Single View of j Events �POat'4eWY-'E:E _ ti Tisve•-u Power Failure ;� Power Restore �!.'or ��,.aa..ot M 59 269 - RM� n Monitor Entire � We-aNWO&W-" 957 64 eMW�F--A �� System ti lewaeaaaar.a T—,e, „n Oiat :v 14 11 - User 395 19 -QA 19 pa Customized Meter Read Failure L4 RON Failure ;v Register Che ksum Error Layout 30 "9 37 % 4 3007 - Drill into Events Wier Pornr Fail 14 Reverse Porrer ;�,' High AC Volts - Trending of 250 pa 88 y� 75 �, Events Reverse Energy Alarm Leak Detected - Mapping of Events Component : Alert Manager Immediately notify individuals, teams or key customers for L= - Cut Wire •- - Leak c Hi Flow - BackFlow - occured on device 4 00'y:,?' II - Others. . , f Choose SMS/Text, e- mail and/or phone call In the Field : Water Insight - Evaluate customer GRIDGSASERVICE 11/19/2013 11/21/2013 usage demands Nov 19,2013,01:00 —HARBINWOOD S Identify loss if a HA OD SUB 4199.0000 zone has inflows ak Harb-TI b_T1: 1 261.0000 Harb_T2:907.0000 Harb_T3:1276.0000 3k 55.0000 and outflows . Harb_T4:7 metered - Spot Revenue A - Trends 11-19 it-1y ,2:°0 16°0 Segment Load '6 Profiles to better server customers 5E1'�5U5 welcomeKThompson: Home I Pay Bill I Support 1rlEnglish,4; Log Out", � • •�"� ��North Tahoe Water Basin Authority ' ' f - .n««.x: a�3 3+aazas-nag Current Balance Avg.Daffy Cost r; ••.� • K6Mln���� Due March 25,2015 11/2015-Present �� � � / •� Sensus Customer Portal lk Chnsirse File Edit Vieisr History Bookmarks Window People Help �q, 40 99%CB M KevinThompson Q 1E JIM 3C6 Great lake/e.: .+.rwa 3 _ Talwe,caaa+� s g138.2s $2.14 1 Dashboard !'% , �• Usage Om Current Billing Cycle Usage Alert Thres,hold Meter Activity Current Bill 1—as, Usage/Forecast seasonal Avg Alerts Current Meters Last As Thresholds !71.1 .�' i 3 r rk 6420 $ 1 +711 + +7 Benchmarks J... Account i�. • • +. Settings Alerts and Notifications;for this Billing Cycle Outdoor Watering How do I cornpare? Conservation Notifications >�� a ��� � tom• t .a . c � FebruaryMaurclis mbasinum— uke ` • 1� Iferts *10 lotifications 1 and Friday nights forasinglef-, horre as ©2015 Sansus All rights reserved Legal Secure Portal My Sensus Connection Terms and Conditions 12 `�` sEnsus 0 sEnsu5 Welcomel(Thppipson: Home I Pay Bill I Support I V Ehglish 1 Log Out North Tahoe Water Basin Authority 1 P t`• •Accowrt: a7331442-78-22-12 _ .�.� :j _os` ` i Kart���1 rch 25,2015 11/2015-r' sent 346Greattake Vew '-n: 3 Tahoe,CA 44130 3 S138.25 S2.14 _ r ' eO Meter 1 • Meter 1• •:' Cr' ~ low / SW 61M RM :,. NM 1AY N '.PM IDM ]PM FPM SPM fiPM )PA' c , I IPM 1AY 1AM W1 NM FRII. � � � � �� Aeter 1 • Galbts♦ �� I �• ' • , , ' ' 40 1 ©2015 Sensus All rights reserved Legal Secure Portal My Sensus Connection Terms and Conditions 13 sEnsus RF Coverage Map 4;* alrtake - FlexNet Design Propagation Analysis t '3p � Salt Lake City Public • Utilities •i► f. �♦ Salt Lake City. UT i { o R~dd R6scrroir • P� RF Engineer:Fred Shendan • • cam Date: 112312015 tiwn Version:8 • �. Water Design ..�• ~ ,per I. Summit Park • h ti✓ 10, Best Server Coverage • Victory Rd Reservoir • JVA5 (,.9tio"rarest Shop • • _ Flat lom Mesa Sandy City • Coverage Threshold: >-118 d8m Or ie�J FSK: 13 VQRloo Dom- orl ' Meter Type:'Hale- i. Meter Location:Fi:Set tuna. Wasn Range �. -� Atbr4a]Don••O14d dJe b m•b.10W[bn:::? • • M • • •- - •. C 1d'1 ►IN•R Silvac Fork C.—d MAO • � • • •• Na(me.ed t:• • � @ �•• reee.,•ew•eann..tasawe •e.tw SrCAMRES West)oroam .vl I � '•, Fla,Mr • BendyCily 6nahign LEGEND: ,+ •� ��; •n r1�la• • A o•s swm •0 4n *?- `•- t � • '.?nuntl�Si. � Cb..•witnedani IMYt S a d 1_ • - • Yr•L—", _ w1 i to city �J V bing rs 2019 Nokia tt'AND f�:2U15 IMiansaft Urparation Scab:1:167,400 ® 1 _ s 41 -Shop :, 1 oad T Flat Iron Mesa f Reservoir 49`{ ; Sand �t , y 15 sEnsus RF Design Summary Customer Name: Salt Lake City Public Utilities Date:1123J2015 RF Engineer: Fred Sheridan City State or Country: Salt Lake City.UT Meter Type:Water Version: 8 Number of Meters Analyzed: 86,720 Smart Point Location: PitSet FSK and Attenuation Value: 13 FSK Proposed Base Base Antenna Preferred Total Structure Height Antenna base Antenna T Base Antenna Antenna Covered Uncovered ype Antenna Mechanical Tilt BTS Name Latitude Longitude 3dBBeamwidth FPPd Centerline Azimuth Dow ntiltWDegrees Installation Meters Meters I:Feetl (Degrees) (Degrees) I_Ipriltl:-)Dwarees Azimuth L-116dBm) (<-116dBm) (Direction) Idount panel on Flat_lorn_Ilesa_Sandy_City 40.59671= -111. =CfT2 11rl..nc.;.^ LP--70F0--CF-ECIF,-0 ?C -0 the northeast 56,593 30,127 face of the tower. Idount panel on Shop_1 40.735943 -11 L 5_ ;. 70 LPA-70040-4CF-E-I. -C 0 the northeast face of the 43,276 43,444 tower. 1,1ount panel on Shop_2 40.735943 -111.89E-7C Ilr6nc, 70 LPA-70040-4CF-ECIr. 40 11E C the east face of 59,132 27,588 the tower. Idount panel on Shop_3 40.735943 111.89E.47 ;. 70 LPA-70060 SCF-ELL 60 C the west face of 30,949 55,771 the tower. Idount panel on Victory_Road_Reservoir 40.783833 -11189173E Unknown 30 LPA-70060-4CF-EDIN-6 60 ___ 0 the southwest 19,394 67,326 face of the tower. Best Server Coverage »»:»:==»»»»»»»»»»»»»»»»>Best Server Coverage is the Composite Coverage for all sites proposed»»»»»»»»»»»»»»»» 86,446 274 Meters Read @ Contract RIS Rate 85,149 Uncovered meters: 274 Salt Lake City Proposal Infrastructure Total M400 Basestation(5) $ 100,000.00 Installation/Project Mgmt(5) $ 120,000.00 Total Annual SaaS fee/Analytics Combined Total One time Costs 0-5k Services $ 18,240.00 $ 26,500.00 5000 $ 3.65 Per meter per year at 5000 5-10k Services $ 32,580.00 10000 $ 3.26 Per meter per year at 10000 10-25k Services $ 65,800.00 25000 $ 2.63 Per meter peryear at 25000 25-SOk Services $ 119,890.00 50000 $ 2.40 Per meter per year at 50000 50-100k Services $ 198,770.00 100000 $ 1.99 Per meter peryear at 100000 —There will be an additional$28,000 charged annually for Base Station maintenance($3500 per BS) Total $ 246,500.00 Breakout Annual SaaS fee RNI One time costs RNI RNI Set up Fee $ 7,500.00 RNI Training $ 5,000.00 0-5k Services $ 13,200.00 5-10k Services $ 22,500.00 10-25k Services $ 40,600.00 25-50k Services $ 49,400.00 50-100k Services $ 93,800.00 Verdeeco Annual SaaS fee Verdeeco One time costs "Device Access/Standard Reports System set up fee $ 2,250.00 Training $ 1,750.00 Custom Module and Integration $ 10,000.00 0-5k Services $ 5,040.00 5-10k Services $ 10,080.00 10-25k Services $ 25,200.00 25-50k Services $ 50,400.00 50-100k Services $ 100,800.00 IVerdeeco� Annual SaaS fee Verdeeco One time costs "Billing Integration Link ONLY System set up fee $ 2,250.00 Training $ 1,750.00 Custom Module and Integration $ 10,000.00 O-Sk Services $ 2,520.00 5-10k Services $ 5,040.00 10-25k Services $ 12,100.00 25-50k Services $ 25,200.00 50-100k Services $ 50,400.00 PUBLIC UTILITIES MONTHLY FINANCIAL SUMMARY FOR THE PERIOD JULY 1, 2015 TO SEPTEMBER 30,2015 MONTHLY YEAR-TO-DATE SEP SEP JUL-SEP JUL-SEP INC(DEC) 2014 2015 2014 2015 2015 ACTIVE P U ACCOUNTS RESIDENTIAL 13 5 75,149 75,206 57 INDUSTRIAL 4 1 224 227 3 COMMERCIAL (4) 4 8,793 8,844 51 MISCELLANEOUS 3 1 2,313 2,336 23 TOTAL SERVICE ACCOUNTS 16 11 86,479 86,613 134 WATER DELIVERED IN MG. 3,290 3,449 12,095 12,130 35 WATER CONSUMED IN MG. 3,223 3,524 10,962 11,299 337 CHARGES WATER $8,022,192 $9,154,252 $27,207,060 $29,306,382 $2,099,322 SEWER 1,803,787 2,078,616 5,184,589 5,609,856 425,267 STORM 693,819 742,616 2,051,307 2,065,950 14,643 STREET LIGHTING 267,305 277,458 802,538 811,632 9,094 GARBAGE 950,663 964,645 2,804,016 2,923,287 119,271 FRANCHISE 430,008 507,603 1,389,408 1,477,926 88,518 TOTAL CHARGES $12,167,774 $13,725,191 $39,438,918 $42,195,032 $2,756,114 COLLECTIONS WATER $9,618,619 $9,942,240 $26,692,045 $25,073,430 ($1,618,616) SEWER 1,683,313 1,707,079 5,199,462 5,739,247 539,785 STORM 691,471 656,874 2,130,985 2,264,620 133,635 STREET LIGHTING 261,766 262,148 829,865 869,333 39,468 GARBAGE 923,678 941,688 2,687,137 3,019,334 332,197 FRANCHISE 534,140 490,647 959,400 970,323 10,923 TOTAL COLLECTIONS $13,712,987 $14,000,676 $38,498,894 $37,936,287 ($562,607) ABATEMENTS SERVICE BREAKS $7,640 $23,024 $25,828 $43,936 $18,108 UNCOLLECTABLE (498) 8,283 $9,785 $15,219 5,434 TOTALABATEMENTS $7,142 $31,307 $35,613 $59,155 $23,542 ACCOUNTS RECEIVABLE AGING 01-30 DAYS OUTSTANDING $6,772,724 $8,597,057 $1,824,333 31-60 DAYS OUTSTANDING 1,013,376 947,140 (66,236) 61-90 DAYS OUTSTANDING 182,606 119,572 (63,034) 91-120 DAYS OUTSTANDING 61,014 10,998 (50,016) > 120 DAYS OUTSTANDING 203,608 24,763 (178,845) TOTAL RECEIVABLE $8,233,328 $9,699,530 $1,466,202 SALT LAKE CITY CORPORATION WATER UTILITY FUND BALANCE SHEET SEPTEMBER 30, 2015 SEP SEP ASSETS 2014 2015 Cash &Investments $ 54,381,724 $ 44,473,007 Restricted cash&temp.investments 6,881,532 7,922,525 Accounts receivable 8,595,182 10,487,624 Accrued interest and other investments 37,857 32,280 Inventory of supplies 2,518,918 2,747,475 Land and rights of way 48,356,550 48,601,862 Buildings 49,246,165 52,261,313 Improvements other than buildings 303,004,634 310,462,823 Machinery and equipment 27,392,806 28,216,294 Construction work in progress 6,953,863 12,549,637 Less accumulated depreciation (123,267,246) (129,265,090) Other assets(pension) - 1,394,665 Investment in water company stock at cost 1,579,962 1,579,962 Total assets $ 385,681,947 $ 391,464,377 LIABILITIES AND NET POSITION Liabilities: Accounts payable $ 4,710,962 $ 3,695,284 Current liabilities 338,632 511,353 Deposits 544,738 541,846 Defered revenues - - Bonds payable 13,972,309 11,770,367 Tanner Ditch Deferred Revenue 16,927,434 15,904,840 Obligation for compensation liability 6,668,261 9,649,752 Total liabilities 43,162,336 42,073,442 Net Position: Net investment in capital assets 297,714,463 312,451,137 Restricted 6,881,532 7,922,525 Unrestricted 37,923,616 29,017,273 Total net position 342,519,611 349,390,935 Total liabilities and net position $ 385,681,947 $ 391,464,377 UU) IT r- v O co N O 0) co U) co OM Ln o p N oO r O N Q Lt 't IT N v N m Cl) Cl) N N " r N If (o N r a 0Lo N (n O O Ln m Cl) O r O O Oo N 0 0 0 0 0 0 C) 0 Oo V O r p O r LO Ln N O O O O O O O O O O N m f- -T I` V M M r M O O O O O O O (O LL') N Q W M O O N Lr U) N M Ln N r U6 Lf) O CD Ln ui O O I� V M O N (O r (o O O O OM N I- U') O Oo O (0 N p 00 n Q Ln N U') N N W (M O r N O LO N M V r r M N r_ O cM N I-i Ln fLO - (o (D r r r V W EF, 61� � � W r CO) N (O O Cl) r r 'It LO Cl) IT IT N O (O O L) M l() (.o O CO tr r r I- M r O O O In F- M 7 d' O r- r O Ln N o0 O 00 V ti O V O (M M - cr H (n W Q O O I- O M N O N M N O M r0 (o rT, L N K) M Oo N r 00 (p O r Ln f- (o O N co O N N W H 0 A O (.0 r- (o N r N r A rT� N N N r U) Ef-} O V W ti O U') N r (o (o c) p U) M r U) W) O f- (fl L rT, r O O r r I- I,- N f- O I- Il- U) N O N r r F+1 w O O O r r (o N 0) 0) M IT Oo M N O OD (o (o Cl) � 0) N O A ^ O OD 00 Il- (o 04 I N M N Ln IO M N LO N CD N F i N 00 I 000 M M M r I- LA V LO 00 LO (p O � CIJj FBI F-1 O O f r MLO OO ^ Il- OD Co r N U �aI- W a N N N (A ICI F+1 I`,,' FLTI M N v co Co N f- 0 " r U) -V O f� r 00 co F+1 'j OD N O(O 00 O O (o r f� V f�U) V W F p ul CDr OD CD 0 000 M LO V Cl) O f� 1, O O M O M r OD v O r U) co M z O 00 LC) LO I- W r M LO N r (o V N ~ 00 r M N 00 It f1- O M M M r Lo N U) L O LO O LO I� LO � N N M LO I, r N U) (o M Cl) I•�.1 N � (o h (o � Ln lo N Ln r OD M N N M W r V V O I- 0 O 0 M Wl() O E M C) LO co � W LO m O U) I- 0 V- r- LO p V O M N O LO O W O OM (o CoN M r Ln r LO CV (O N U') r O U> 60- w O H ZU) U) c O W LCy C d V rd U) C U) A W = e w y Z y �+ m e U) E .� (p 4) C o) v d CD cx U) 0) o) U) y CD (0 d c 'a Cf Of y CZ rn ► C '_-� -' (fit C w C C y -co 3 ED %.. o i h y t m C iC U) U. O 0. d a Scavi o m 'o ego o U) -Ca _ 0 oa S o �o o a o �- F- c li -cca m C � F � F w o 0) 00 O O LC) N A U c= t N N N a O N o O F O O O O 000 O N (O r-� m cD r-N � ch �F� r (O N (j 00 M 649. w 00 N M CO 00 lA O LO N 00 N CO O u) O O W O 0 N MLO O o �, � N 0 It o-jZot- O w � � � Oo o M � W w M O (0 (0Cl) 4 O N VV00 � co� 4 CD O Q O N4 L60) LO 00 00 LO 00 O 1'� O M M 00 (O O co C> N O V 04 r'1 O zC14 6g 60- ~ W O M M `n 0 It OD LO It V W x a 00 C14 co (o M rn 0) cNi �o w 0 (O N � N L �I O N O NLO L V ✓ � Ef? 69 [- �..� W � (O (0 O N (M It 00 IT � f- (O O M It — M IT p 000 M v 0) c(i co W CA N NM N N N O 69 69 LO O d w � w ` N _ ` y L d Wo a c o N cts O O y d C C/) C H O C O 3 a) h d C O Oi C t0.1 O y N v Q Cf > > 4D CISd e e `m 0 At m 0 t C e0 O O v t 2 t0 G�i x 0 �O O G� C� ❑ F� SALT LAKE CITY CORPORATION SEWER UTILITY FUND BALANCE SHEET SEPTEMBER 30, 2015 SEP SEP ASSETS 2014 2015 Cash &Investments $ 25,930,403 $ 25,082,628 Restricted cash &temp.investments 8,721,179 3,935,577 Accounts receivable 2,250,339 2,058,710 Bond Receivable - - Prepaid - - Inventory ofsupplies 587,773 650,611 Land and rights of way 4,313,979 4,428,219 Buildings 88,171,909 90,804,232 Improvements other than buildings 130,644,502 138,840,237 Machinery and equipment 32,374,453 33,314,544 Construction work in progress 27,733,538 26,934,788 Less accumulated depreciation (87,790,165) (90,926,555) Other sssets(pension) 520,818 Total assets $232,937,910 $ 235,643,809 LIABILITIES AND NET POSITION Liabilities: Accounts payable $ 991,106 $ 1,419,293 Current liabilities 302,276 379,836 Defered Revenues - - Bonds payable 35,556,300 33,047,350 Obligation for compensation liability 1,224,815 3,090,201 Total liabilities 38,074,497 37,936,680 Net Position: Net Investment in capital assets 171,829,718 170,722,178 Restricted 8,721,179 3,935,577 Unrestricted 14,312,516 23,049,374 Total net position 194,863,413 197,707,129 Total liabilities and net position $232,937,910 $ 235,643,809 L u LO (D N Lr) LO N 00 I- r CDN 0 If) C) O p N (D 'ITr4W N — M N N N N M — U) N N N N N w Wa. O o A O O O O W 0 _O N m LO O O O O N O O O O 00 00 O O 00 M O O O O O (D 1;T O O O ' (D m O O L CC) r- O O U7 O O f- O O O 00 Q W N O Lr) (D Il- 00 (D LO N O 00 CD LO O — Il (D O O � LO O fl- O M LO O f- r- O N Cl) N Cl) 7 C7 LO N N O 00 Cl) 00 v N V CO � (D (D Q N cliCN 00 xi � W N N O N U9- vi V cOr) LO 00 — v f� I- v � 0) (D CD 00 p LO M CA It r- CA _ N N M CO O0 N 00 (D co O W CA O o0 rl� ('M N M I� O O I CA O — N M h C0 N O O V- CA � (D O W Q O N v 00 LO O CA 00 P- CA I- r- v Cl) O N h 00 N N — LC) N 00 N HzAH � o O cM LO LO LO M 00 Lr) O O O CA (D O O O 0) M (V 00 Cl) O 0) M N I- w w C7 ¢ � N M O v O O M O 1� N O M M N O O 00 r � CD 00 O 00 N O O M N Q O N 00 CO N CD O N 0-) N- f- LO Co rq L O M N (D CD a A ° N Lr LO Ncyi 0 (4 O J-I N ItLO r LO O CD CA Ln CD CD L CA � N (, w It (0 N (DLO M 00 co LO N oo — N 00 It L M 00 I� O fl N " N 0) N N 00 O a r O CA O m CD N CA I-i Ld V M CA NO — — 00 O N m N C') Cn CV N z AAA w w CO N O — P- v 0 Il- 'I- M (D O v CN Cl cM O rl- O (D C) CA N O (D N CD N V O Oo O N N N f� N O co N Cn O N LO Cn co W) CA I�t CO (D O I- N CA Cl) CD r1 LO — n COD O (D 00 Cl) Cl) h LO (V 00 GL.I p O w E� z w w Q o cc f/1 y C y C 2-1y C) v G a" y G E w d d y +. �o a °' o Q d C Gyi C�.t C y d y O O k CL C k V N v m .Q E m a a Z to c m > V m E m y tm rn rn d C C R y m y a C�,f Co � _ C co 1O e ` y c Q c w `�° ° V. °� = `° ,� a d c3i oQCnso 0 oao5aF= oUiQaCO)Im o ff z 0 LLl N \ \ o \ \ o \ U O Cl) O 00 l!') N I� w 0. 0 CN 0 A O O O O O O O O N O O O O M N O lO N C7 LO M N rl- co 000 O - COO co Q M M N M CO lI) � N N � � ER EA O co 0 N CO O H O N o 00 o o v i O C'i O ¢ ° ui LO C14 aS rS It ui O x o w z g4o A O) Cl) Otr) M 00 O w w L O N N Cli cc �y A O N O M M O Q N Cl) M O f� r- LO LO uz � � o � - N � �-4 04 64 6j. BTU O W 'r`T� O rl- co CO M M 00 00 � rJ FM�1I N M CD � N O ^FLj z W 0. 00 co It 0 00 0 0 00 N M Cn E`I W o L z N d3 w w CA 00 r` N v r fz, 00 � M v v M Cl) LO r- r- M 0 O O x w N0 co N N N N M COO O C' z ° w w w o H e a a c o ID � m o� to Uri w a c z km h d O C 'O C 1 O h d O h v t�f 7 N C V N Q > .�.. a �y U)N IL) O ONvii N > N Q N Q Q O mU co U o U U Q x 0 i 0 r- w SALT LAKE CITY CORPORATION STORMWATER UTILITY FUND BALANCE SHEET SEPTEMBER 30, 2015 SEP SEP ASSETS 2014 2015 Cash&Investments $ 7,962,071 $ 7,046,055 Restricted cash&temp. investments 1,010,426 1,213,156 Accounts receivable 847,607 614,520 Inventories and prepaid expenses - - Land and rights of way 1,742,681 2,026,021 Buildings 8,957,148 9,004,644 Improvements other than buildings 133,934,824 137,499,749 Machinery and equipment 3,786,096 3,969,668 Construction work in progress 5,598,669 3,538,894 Less accumulated depreciation (46,582,024) (47,622,118) Other assets(pension) - 153,533 Total assets $ 117,257,498 $ 117,444,122 LIABILITIES AND NET POSITION Liabilities: Accounts payable $ 367,117 $ 352,817 Current liabilities 8,108 6,817 Defered Revenues - - Bonds payable 10,703,700 9,912,650 Obligation for compensation liability 346,692 867,982 Total liabilities 11,425,617 11,140,266 Net Position: Net investment in capital assets 96,733,695 98,505,252 Restricted 1,010,426 1,213,156 Unrestricted 8,087,760 6,585,448 Total net position 105,831,881 106,303,856 Total liabilities and net position $ 117,257,498 $ 117,444,122 V U (D co ti (o O O N N Cn oOLO 0O CM Cl) A Li N N N N Ct7 N N V N N M �Q O O O O O 0) OLf) LO O O O O O I O Cl) N 00 N O C) 0 O CD O I` N O O O O O O 00 O O CC) CA O J F. O O O O I` L C (C O O O O o0 N D) - CM (D O C) O r- N CT CA O O to O (o V CD CC) 00 N v LO C) LO O 'It : CC) P- 00 N CC) (D Cl) Oo (DLn Q O N (D 00 N N N V V CD 00 Oo N CC) N en M V (D M 00 cM I` I` O LO OD Co V O I Cl) ' Ln O I` Fw- (D O N CA N CA N Cl) N O U'J O N O N 00 Cl) Cl) 00 W Q O M M (D 00 V N CA O CA O cc I` (O Ll N M Zj (n 0 O Il- O O CA M M CA N N N Cl) 00 I` Cl) W N M N M (D M U') iz M CM V 00 O �j �1j (D N 00 z W H- C) N N W Gi•I � } Nwo ER EA O W M Na) It 00 C) C) r- M 0 - O N N ' O O LO LLl m CC) M 0o I` O O f- O C) (D IT N LO Q O V � O o0 V 00 � LO O V Co a) Cl (o V W ^ I •� O O I- O Cn N CO m co Cl) O v N N CA N O F-1 1-1 N LO I,- 00 M I'- N (o CD It Cl) C) V 00 00 r� O IT - N rn VCV N H W W W N � � () O O � V 0 (D O OD cD O It O V O 00 (D ao LO V (D (D M IT C) It O N — 00 (D V O) O to Co LO LO N N O O w N o0_ LO O V L� d r Cl) V Oo M L N Ni CA N O N M 00 CA CA zr-I U) O Cl) n O Cl) v � N Ilr�--4� �jCC z N I,- LO CD M H N C) CD 00 C) LO N N V N V W IT C) Il- D) - 00 u) [I- - M C) (o M V Cl) M d7 N N CD O O LO I` Cl) I` Co O co D) Cl) d V Lo M O CA O O (D C'M pl W O L (D (D cl IF•��ii w •- N M (D Co M O N O N W W U) C) N (D N O z .� W U) C7 C 5 E CD +.. u 'yO�+ F W y 4) V� U) U) a U C U) C •d u) CO C1 C 4. W d E •� N U) ry d Q) .0 co C d C CX C G a V Q- �-1 G! C d a) d y v y .0 .0 d h d LV C CC7 d m m m h t rn m a o K d cc o C o o' c = 3 cx CD u m c cn (co c y c 3 a) j- d 6 CL i m F O. w _ 4h o r+ d r � p ( O coC Z , O U vi O � 04 04 N O Aa0o O O O O O O O Oo O O O � I O O M O Q O toct � CD N Cl)LU _ zz C7 to N M N O w N Q = H V wC 61) 60- Frj W O (O O M O N DWI Q O (( C NT EO M 0o0 (O O O Ln Oro ono N v N (O N Fo w } N Efl EA W 00 CN 0 O O 0 N O Ln W W V Q O v Ni L6 v o (D O A H z N O O LO � O N N N N O N 60- 6% H � W W O ' O ' O O M O M cl cl c CA O M r rT, � M a0 13� aO ^�itJj H a �jLU M 00MMO M N N 00 N C7 O 69)- 611 W a N N N Vr1 a! I- f- 00 LO Cl) w x U) N O Wf (A O 0 H z W = d y W [ CD N w C d a 42 C N Cf h dcn cn yj C ce y ! h 7 d O d h C1 C 0 :m C CI L' d d Q O a O ' O d > CX U Cctl Cw O 0 v m 1- 0 I_ w SALT LAKE CITY CORPORATION STREET LIGHTING UTILITY FUND BALANCE SHEET SEPTEMBER 30, 2015 SEP SEP ASSETS 2014 2015 Cash&Investments $ 739,829 $ 2,111,501 Restricted cash &temp. investments - - Accounts receivable 183,917 123,904 Inventories and prepaid expenses - - Improvements other than buildings 3,576,758 4,420,207 Machinery and equipment - - Construction work in progress 379,949 Less accumulated depreciation (466,850) (780,151) Other assets(pension) 6,200 Total assets $ 4,413,603 $ 5,881,661 LIABILITIES AND NET POSITION Liabilities: Accounts payable $ 139,518 $ 227,584 Current liabilities - - Defered Revenues Bonds payable - - Obligation for compensation liability 10,618 4,925 Total liabilities 150,136 232,509 Net Position: Net investment in capital assets 3,489,857 3,640,699 Restricted - - Unrestricted 773,610 2,008,453 Total net position 4,263,467 5,649,152 Total liabilities and net position $ 4,413,603 $ 5,881,661 H F � � o Z U O o 0 C 0 0 0 0 0 0 0 0 0 0 W m N o o O o 0 0 0 0 0 0 o a o 0 A U N O O (o (o � (o (o LO O 00 L. N - Cl N N O N N Cl) p N arq Cl O O O N O O O O O O ' ' LO r- Cl) O O O O I- O O O O O O N O O O O O O N O O O V O O Cl) O O F- O O N N N O O N Cl O (0 07 01 V N Cl) Cl) CO N N r- N f-LO N N N m Nz 0 M M CV ^ ¢ co Mto EA ^ W 00 N U) LO � V, Cl) N (O O 't Y-1 LO N O m M M M W C) I- C) LO Cl) Q O O O OO f� P- I't (o N O Il- O LO N f- LD V) N N 'T N LO O N Cl) 5 N m 't It N C*4 (O O (O P- o L6 (o f- M M �I } N Hi EA W W M O O O � N LO O to Lo m It N (o O 00 (o O N O O N W w/ V O 00 f-- (o N V- - qT M O C) Cl) N OQ O to � � - M f� N N O (o z N O N N 0) a) (o (o It P- V Q v N >4 z Z } N Hw � w Ul V) V o x co N C) C) � r (p C) ' ' ' ' N 00 ITI Lo - f- � N v I- O 00 LD U 1 F4 � N 00 � O N O L 0) P- -F a N - I� N U') CDLn � z W f- 0) co N N N N F, z LO (o N Cl) Cl) Cl) In O (O ti E-1 WW W O mt mt 0) Lo N f- - O O LO Cl) a. M N 00 M I� O 00 00 O (O I- W W M U) N N N N C O H w a) w h O to 0 �n 0) " „ vl U _ CD v Gs G a � d 0, d � Z y y C d C h IDy a = C 00 U) d 0 CL W CD co N d m U) T y ���. wC- O t f r� 01 C C C C = J w d C W y V J tCC O W cm of O Ac CD w d d C, i:. y �r ` ISO d 0 -m CD " w O H i wr0+ N p (n o f p a O � a ti �- o � Q a (n m � � o i z H �W 2vo V U W N , , o o w � o 0 A a0o al Vj o o r� o 0 0 o o Ca 60- 69- q O W Cl)M Q - o cn W Oui Cl) � C) } " a H W � wd � � LO rn rn (q O q C) o rn of ao N PI- O U 0 M CM � C7 C7 � o H � z � N � oxz 00 LO Z � N Ni Cl � zWz � LL� o d N N � M N W U) N �I CA w H O W O 0 N O t y W , w c t W o 'O � y aCl) O +el _+ 1O 1p yam" N d to > w O y m Fo a cc p 0 K V W