The URL can be used to link to this page

FiberNet Advisory Board Agenda Packet 07-14-2015AGENDA FIBERNET MONTICELLO ADVISORY BOARD MEETING Tuesday, July 14, 2015 — 6:30 p.m. Academy Room, City Hall Members: Brian Stumpf, Charlotte Gabler, Jon Morphew, Dennis Sullivan, Jacob Kramer Others: Jeff O'Neill, Dan Olsen, Rachel Leonard, Bryan Rabe 1. Call to Order 2. Additions to Agenda 3. Approval of June Meeting Minutes 4. Comdesco Presentation 5. Minnesota Public Broadband Alliance Update 6. Network update • 10 Gig Ring Conversion • Gigacenter Update 7. Business Office Update • July Subscriber Data • Golden West Update 8. Additional Updates • Business Manager Hiring Process • 2016 Budget • Construction Updates (IRET, Sunset Ponds) • Possible Public Camera Project 9. Review of outage procedure and network maintenance notification process 10. Review of new Calix product 11. Consideration of updating ordinance language from General Manager to Business Manager 12. Next Meeting — Tuesday, August 11th, 2015 13. Adjourn 0 zz °n x P M 0 10 m m H H X X� 13 13 O r i rim w< n oc m Mg m g0 f z 0 N m Z O O 3 Z 3 O A N rt 'd O O� N N 3 N O 3 rt CU ~ ,G c n Cd M 3 01 CU UQ (A M m fA 0u 0 3 O o. OO 3 m m m 3 d `5 0 X O < 3 r n N (D c of < c -a M •* O (mD M O 0 N (D O CL cu a MCD e O k.3 0 3 a n O .3r N d D) N N a or m CL d CL 7 S _ 3 :_i Q 3 N M (D 0J � DJ C � Q — (D 3 .N•r• N C p.r fD d N (D N m o -I i O 4 O :� S 3 (D (MD c3D (D N T ) 0 N O a C rr 7 O e�h C `G 0 o < m n `n d N� _r+„ A Q O �1 M 0 3 (D C6 ..ti C (D N O 0 rr �• n O -C (D (D N (p O m 3 (n r 0 c o m O ° 3 rr < (D 7 cu 7 O_ vi F d M r 0 N 3 G O 3 c3 N CL 3 ((DD ,^ O fD O-Qcu �. � CD Ncr rt O 2L �= CL oai a CL 0 < 3 A 3 0(D iU D1 N C m m W G . O Q OED0 M d (D CL N N N 3 o, w ° E 2 @ g 00 / ƒ \ / \ $ ƒ 9 2 C )Z ± m f ° / G Z � J = � / r+ 0 i ] 2 ƒ ( ¥ (A r+ M r+ g 6, ° G6 \ 0 § \ 2 \ / o \ CL c / M. r E o w = 2 Ln o o - g f \ M o k \ f $ CL J 7 . a - . / §\< M / m 06) 2 c A 0 -• G e \ 3 .z\ ■ n 7 7 - � r \ / / / § 7 e o 2 ° 2 \ / \ : % 2 a- o < o 0 \ 2 \ \ ƒ \ K / / D rCA , 0- R nn C: C LA M " \ f $ M r CL M \ �\ E2 ` r 3 =rD /\� ( \ \ \ § g cu LA ) c % I / R / 2 M r+ Ln M 0 C n 0- M q o /2 /2 e ± Q vi / / % � w ° E 2 @ g 00 \ $ ƒ 9 2 E2k�dkE G M 0.7 d / / r+ 0 ] (A r+ M § g 6, =r g § / 2 E o ■ CL - M. E o w 6 n c o o - g g & M k CL J 7 . a - M 3 06) 2 c 0 r 0 ° G @ J ■ - � Z m 0 z CD 9 0 � $ L U. P+ cr c (D t (n 0 c_ 0 m Cl) D Z cn 0 zz 0 F rDA p0 Z O A zq rD T a, N v N n O O 7 (D 7 r -F O h O C C r+ T' (D m N N Ott O d4 d C� Z (D O m v Ott m N z (D O Z m r+ m x x O 3 cu N O O (D O -n r+ S m S d _7 N 3 r+ O 3 (D r+ d a O O r+ m r+ S m 7 m 7 O (D O_ a) N N m r+ N v (D CU m. y. N � O1 Ott O \ O_ O (D S 7 (D N � O ON r+ m S (D rt N � n N r+ Q �G 'p 3 O O 0- (D m Oq Q S Z Q (D rNr O Z h r° m d m n X m n N O ' 3 (D o� VY 1+ J m < rr+ C nl (D N m G 6J r+ O N . N N r* m N � d � < (D SU 0 C m rD Q N Q. m W O_ m O 3 0 -O < O Q 3 rD m O O nO r+ (A S �� m z fD m O Z v M r+ O 7 m -h Q v � 7 rN+ fl_ C N c m rte+ n C C fD m F. n� m CU LA CU N = m m r+ 3 O m Z � m r+ O V � O N 0 "a N 0 3 0. rm+ v 7� D O OZ Gm O O C N (D a)N Q rt Q S Cu (D m 3 41 O (D rt C n m Q N S Q o, 3 rt (fD p3j C m N rD O_ rte+ rD 3' S r -F rF O rt fll S - O O z —^ m e' O S Z m m < Crt cu < X cr m Ocu 3 N N Q rm+ (y N r+ CU W Cr m m < m 7 O O CD' Q Lrw: 0 m INFRASTRUCTURE MANAGEMENT SUMMARY Monticello retains ownership and control of its property. Monticello's sites are inventoried and actively marketed to carriers. Monticello will be given access to the database we develop of its sites. Monticello's wireless communication sites are evaluated and a rate structure will be developed and assigned to all viable sites. Monticello can also make its fiber available for sale or lease under the IMA. Monticello may include its existing wireless assets (towers, etc.) in the list of assets subject to the IMA. Specific Terms in the IMA • AUDIT RIGHTS: Owner may audit financials upon notice • AGREEMENT REGISTRATION: Owner retains the right but not the obligation to review and approve all registered templates, agreements, sub -leases or licenses in their original, non -redacted form • APPROVALS: Owner has the right but not the obligation to review and approve agreements, business terms, construction standards or deviations from standards, site exhibits, site and construction plans and drawings and scheduling of work • FINANCIAL REPORTING: Open book, summaries included with monthly rent payments • INDEMNIFICATION: Mutual, Tenants, Contractors and Subcontractors primarily liable • TERMINATION: For Convenience: Yes, accompanied by pre -determined buy out For Cause: Yes For Events of Default or Uncured Breach: Yes • SPECIAL PROVISIONS: Embedded remedy in the event of Monetary Default We surrender and assign all contracts and contracts in process directly to Owner Eliminates risk of loss, ensures consistent operation for tenants and Owners retention of revenue stream Residential & Business Subscribers (Customer Counts) Jan Feb Mar Service Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YTD I CHG % Phone Only 38 36 34 33 33 33 32 --- --- --- --- --- -6 -15.8% Internet Only 517 531 546 547 567 577 591 --- --- --- --- --- 74 14.3% (Television Only 89 85 82 81 75 75 76 --- --- --- --- --- -13 -14.6% Phone & Internet 171 167 163 167 173 174 170 --- --- --- --- --- -1 -0.6% Phone & Television 52 51 51 48 51 50 50 --- --- --- --- --- -2 -3.8% Internet & Television 351 345 343 339 331 325 321 --- --- --- --- --- -30 -8.5% Triple Play 321 317 312 309 298 298 292 --- --- --- --- --- -29 -9.0% Total Subscribers I 1539 I 1532 I 1531 I 1524 I 1528 I 1532 I 1532 I 0 0 I 0 I 0 I 0 I -7 -0.5% Total Phone 582 571 560 557 555 555 544 --- --- --- --- --- -38 -6.5% Total Internet 1360 1360 1364 1362 1369 1374 1374 --- --- --- --- --- 14 1.0% Total Television 813 798 788 777 755 748 739 --- --- --- --- --- -74 -9.1% Total Services 2755 2729 2712 2696 2679 2677 2657 -98 -3.6% Residential & Business Subscribers (Percentage of Customers) Service Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Phone Only 2.5% 2.3% 2.2% 2.2% 2.2% 2.2% 2.1% --- --- --- --- --- Internet Only 33.6% 34.7% 35.7% 35.9% 37.1% 37.7% 38.6% --- --- --- --- --- Television Only 5.8% 5.5% 5.4% 5.3% 4.9% 4.9% 5.0% --- --- --- --- --- Phone & Internet 11.1% 10.9% 10.6% 11.0% 11.3% 11.4% 11.1% --- --- --- --- --- Phone & Television 3.4% 3.3% 3.3% 3.1% 3.3% 3.3% 3.3% --- --- --- --- --- Internet & Television 22.8% 22.5% 22.4% 22.2% 21.7% 21.2% 21.0% --- --- --- --- --- Triple Play 20.9% 20.7% 20.4% 20.3% 19.5% 19.5% 19.1% --- --- --- --- --- Total Subscribers 1100.0% 1100.0% 1100.0% 1100.0% 1100.0% 1100.0% 1100.0% I 0.0%_1 0.0% I 0.0% I 0.0% I 0.0% Total Phone 21.1% 20.9% 20.6% 20.7% 20.7% 20.7% 20.5% --- --- --- --- --- Total Internet 49.4% 49.8% 50.3% 50.5% 51.1% 51.3% 51.7% --- --- --- --- --- Total Television 29.5% 29.2% 29.1% 28.8% 28.2% 27.9% 27.8% --- --- --- --- --- Total Services 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 1 100.0% 1 -- -- -- --- Residential Subscribers (Customer Counts) Service Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Phone Only 30 28 26 25 24 24 23 Internet Only 490 499 511 517 534 543 557 Television Only 86 82 78 77 72 72 73 Phone &Internet 93 89 91 92 98 101 100 Phone & Television 51 50 50 47 50 49 49 Internet & Television 346 340 337 334 329 323 319 Triple Play 305 301 298 295 284 285 278 Total Subscribers 1401 1389 1391 1387 1391 1397 1399 0 0 0 0 0 Total Phone 479 468 465 459 456 459 450 0 0 0 0 0 Total Internet 1234 1229 1237 1238 1245 1252 1254 0 0 0 0 0 Total Television 788 773 763 753 735 729 719 0 0 0 0 0 Total Services 2501 2470 2465 2450 2436 2440 2423 0 0 0 0 0 Residential (Percentage of Customers) Service Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Phone Only 2.1% 2.0% 1.9% 1.8% 1.7% 1.7% 1.6% --- --- --- --- --- Internet Only 35.0% 35.9% 36.7% 37.3% 38.4% 38.9% 39.8% --- --- --- --- --- Television Only 6.1% 5.9% 5.6% 5.6% 5.2% 5.2% 5.2% --- --- --- --- --- Phone & Internet 6.6% 6.4% 6.5% 6.6% 7.0% 7.2% 7.1% --- --- --- --- --- Phone & Television 3.6% 3.6% 3.6% 3.4% 3.6% 3.5% 3.5% --- --- --- --- --- Internet & Television 24.7% 24.5% 24.2% 24.1% 23.7% 23.1% 22.8% --- --- --- --- --- Triple Play 21.8% 21.7% 21.4% 21.3% 20.4% 20.4% 19.9% --- --- --- --- --- Total Subscribers 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 0.0% 0.0% 0.0% 0.0% 0.0% Total Phone 19.2% 18.9% 18.9% 18.7% 18.7% 18.8% 18.6% --- --- --- --- --- Total Internet 49.3% 49.8% 50.2% 50.5% 51.1% 51.3% 51.8% --- --- --- --- --- Total Television 31.5% 31.3% 31.0% 30.7% 30.2% 29.9% 29.7% --- --- --- --- --- Total Services 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% --- --- --- --- --- YTD I CHG % -7 -23.3% 67 13.7% -13 -15.1% 7 7.5% -2 -3.9% -27 -7.8% -27 -8.9% -2 -0.1% -29 -6.1% 20 1.6% -69 -8.8% -78 -3.1% Business Subcribers (Customer Counts) Service Jan Feb Mar Apr I May Jun Jul Aug Sep Oct Nov Dec YTD CHG Phone Only 8 8 8 8 9 9 9 25.6% --- Television Only 2.2% 2.1% 2.9% 1 12.5% Internet Only 27 32 35 30 33 34 34 54.1% 52.6% --- Phone & Television 0.7% 0.7% 7 25.9% Television Only 3 3 4 4 3 3 3 1.5% 1.5% 1.5% --- Triple Play 11.6% 0 0.0% Phone & Internet 78 78 72 75 75 73 70 100.0% 100.0% 100.0% 100.0% 0.0% Total Phone -8 -10.3% Phone & Television 1 1 1 1 1 1 1 51.4% 50.4% 51.0% 51.5% 51.3% --- 0 0.0% Internet & Television 5 5 6 5 2 2 2 100.0% 100.0% 100.0% 100.0% 100.0% -3 -60.0% Triple Play 16 16 14 14 14 13 14 -2 -12.5% Total Subscribers 138 143 140 137 137 135 133 0 0 0 0 0 -5 -3.6% Total Phone 103 103 95 98 99 96 94 0 0 0 0 0 -9 -8.7% Total Internet 126 131 127 124 124 122 120 0 0 0 0 0 -6 -4.8% Total Television Total Services 25 25 25 24 20 19 20 0 0 0 0 0 -5 -20 -20.0% -7.9% 254 259 247 246 243 237 234 0 0 0 0 0 Business Subscribers (Percentage of Customers) Service Jan Feb Mar Apr May Jun Jul Aug Phone Only 5.8% 5.6% 5.7% 5.8% 6.6% 6.7% 6.8% --- Internet Only 19.6% 22.4% 25.0% 21.9% 24.1% 25.2% 25.6% --- Television Only 2.2% 2.1% 2.9% 2.9% 2.2% 2.2% 2.3% --- Phone & Internet 56.5% 54.5% 51.4% 54.7% 54.7% 54.1% 52.6% --- Phone & Television 0.7% 0.7% 0.7% 0.7% 0.7% 0.7% 0.8% --- Internet & Television 3.6% 3.5% 4.3% 3.6% 1.5% 1.5% 1.5% --- Triple Play 11.6% 11.2% 10.0% 10.2% 10.2% 9.6% 10.5% --- Total Subscribers 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 0.0% Total Phone 40.6% 39.8% 38.5% 39.8% 40.7% 40.5% 40.2% --- Total Internet 49.6% 50.6% 51.4% 50.4% 51.0% 51.5% 51.3% --- Total Television 9.8% 9.7% 10.1% 9.8% 8.2% 8.0% 8.5% --- Total Services 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% --- Sep Oct Nov Dec 0.0% 0.0% 0.0% 0.0% C4 Calix ACCESS INNOVATION FAST FACTS Compass Calix is a leading global provider of broadband communications access systems and software - the largest telecommunications vendor in the world focused solely on the access space. Leveraging its role as a key strategic partner to many of the most innovative service providers around the world, Calix offers its customers an award-winning suite of software -as -a -service applications that accelerate the ability of service providers to transform their networks to meet emerging broadband demands. This applications suite, called Compass, is widely deployed by hundreds of service providers, who find it essential in providing the actionable data, insights, and tools that drive company initiatives, such as the identification of new revenue streams, network resource optimization, customer satisfaction improvement, and service delivery cost reduction. ACCELERATING BUSINESS TRANSFORMATION Compass applications are used every day by network planners, marketers, and customer service representatives within forward-looking broadband providers to command the broadband experience of their subscribers. These applications, capable of monitoring IP traffic carried across third party network equipment but optimally deployed in conjunction with Calix systems and complemented by Calix consulting services, closely monitor Internet traffic flows, application use, and home and business network traffic and health - monitoring nearly five petabytes of data every month. From this data, service providers draw insight that allows them to manage the home network, accurately anticipate network capacity challenges, manage SLAB, target market, and provide superior service planning and technical support. The result: increased revenues, lower CAPEX and OPEX, lower churn, and more satisfied customers. Target Functional Area Compass applications furnish broadband providers with the visibility and control they need to deliver an exceptional broadband experience. Broadband traffic analysis, TR -069 device management and Service Level Agreement (SLA) management are key uses for the Compass application suite and they impact every facet of the service provider business. Examples of how Compass is used on a daily basis include: Marketing 4 Define service tiers 4 Identify top users Define CE 2.0 SLA metrics Network Operations COMMAND Center 41, CMS consumer 7 Flow Service CONNECT ANALYZE G VERIFY Customer Support 4 Remedy slow Internet issues 1 Troubleshoot home networks 4 Identify DSL performance issues Finance and Management Identify network investment needs 4 SLA reports and reconciliation TR -069 device upgrades A Traffic usage and accounting Service Activation Tests (SAT) '0111 Fair usage policies 1035 N McDowell Blvd., Petaluma, CA 94954 1 877 462 2549 1 www.calix.com I'2014 Calix 11Q2014 --a- !� Customer Network Marketing Service Operations COMMAND Center 41, CMS consumer 7 Flow Service CONNECT ANALYZE G VERIFY Customer Support 4 Remedy slow Internet issues 1 Troubleshoot home networks 4 Identify DSL performance issues Finance and Management Identify network investment needs 4 SLA reports and reconciliation TR -069 device upgrades A Traffic usage and accounting Service Activation Tests (SAT) '0111 Fair usage policies 1035 N McDowell Blvd., Petaluma, CA 94954 1 877 462 2549 1 www.calix.com I'2014 Calix 11Q2014 COMPASS APPLICATION SUITE: Software Tools that Accelerate Business Transformation Compass is a suite of software -as -a -service (SaaS) applications that give broadband experience providers the visibility and control needed to command the broadband experience. Compatible with an extensive collection of network architectures but most powerful when deployed in conjunction with Calix access systems and consulting services, Compass applications deliver network efficiency through automation. Through traffic analysis device management, and SLA contracts, Compass is also used to identify and exploit new revenue opportunities. C.4 Calix ACCESS INNOVGTION C O M PA S S by Calix The Command Center is an intuitive user interface that abstracts data from the individual applications and presents actionable information to all functional roles within the broadband provider's organization. Through a collection of dashboards, interactive informational widgets and data correlation, the Command Center is the only interface needed to interact with all Compass applications. Flow Analyze is a non -intrusive broadband traffic and network utilization application that monitors, analyzes and reports on a per -flow, per -subscriber, per -location, and per -network basis. This sophisticated yet easy-to-use application can also be used to establish Flow Analyze allows the correlation fair -use policies, diagnose customer of endpoint to application 61100 g complaints related to broadband R► D.I. Ceore, performance, and even identify I .192166.1101 just -in -time network investments. Go SIC 661111 1P \ `• 1921681189 The Consumer Connect application enables service providers to become `• 14=.I661AN A a virtual technician in the home by remotely activating broadband devices and managing home networks utilizing TR -069. Consumer Connect provides extensive device diagnostics, firmware management, and Wi-Fi home network configuration capabilities from an easy -to -navigate interface. The latest addition to the Compass suite is Service Verify — a comprehensive SLA management application. Service Verify equips CE 2.0 providers with the tools to identify key performance indicators, define SLAB, establish SAT birth certificates, monitor performance, and create periodic SLA reports. Service Verify also includes a customizable customer portal that gives visibility to those who need it most— businesses, enterprises, mobile backhaul, and financial customers. The Colbr Management System (CMS) delivers superior tools and features to install and maintain multiservice copper and fiber networks built from the Calix Unified Access portfolio. Service providers can manage and operate broadband networks that scale from hundreds to millions of broadband subscribers. CMS handles all provisioning, maintenance, and troubleshooting functions across Calix network equipment. For more information on the Compass suite of applications, visit the Calix website: http://www.colix.dom/softwore/composs/ 1035 N. McDowell Blvd., Petaluma, CA 94954 1 877 462 2549 1 www.calix.corn I CcJ2014 Calix I 1 Q2014 Fiber Net Schedule of Revenue and Expenses (Modified Accrual Basis) 6/30/2015 Account Number Description REVENUE 656-00000-341180 PEG Access Fee $ 656-00000-341190 USF Fee 656-00000-362900 Refunds and Reimbursements 656-00000-362920 Services - Misc 656-00000-362990 Other Miscellaneous Revenue 656-00000-380510 Television Services 656-00000-380520 Internet Services 656-00000-380522 Equipment Rental/Purch 656-00000-380530 Phone Services 656-00000-380540 CABS Revenue 656-00000-380542 Late Fees 656-00000-380545 Discounts Offered -Taxable 656-00000-380546 Discounts Offered -Non Taxable 656-00000-380557 Miscellaneous Charges 656-00000-380558 Misc Charges -Non Taxable OPERATING REVENUE Totals: EXPENSE Dept 49870 General & Administration 656-49870-410100 Salaries Full -Time Reg 656-49870-410200 Salaries Full -Time OT 656-49870-410300 Salaries Part -Time Reg 656-49870-410310 Salaries Part -Time. OT 656-49870-410400 Salaries Temporary -Reg 656-49870-412100 Pera Contributions 656-49870-412200 Fica Contributions 656-49870-412300 Medicare Contributions 656-49870-413100 Health Insurance Contributions 656-49870-413300 Life Insurance Contributions 656-49870-413400 Disability Ins Contributions 656-49870-414200 UC Benefit Payments 656-49870-420300 Printed Forms And Paper 656-49870-420990 Office Supplies 656-49870-421990 Gen Operating Supplies 656-49870-422100 Equipment Repair Parts 656-49870-422110 Vehicle Repair Parts 656-49870-430100 Professional Services -Audit 656-49870-430400 Legal Fees 656-49870-430700 Management Services (GM) 656-49870-431800 Professional Services -Billings 656-49870-431970 Regulatory Professional Svcs 656-49870-431990 Miscellaneous Prof Services Orig. Budget Amended Beg Balance Debit Credit Balance Ytd% (10,000) $ (10,000) $ (3,196) $ $ 632 $ (3,828) 38.3% (10,000) (10,000) (3,428) 704 (4,132) 41.3% (222) - (222) --- (7,359) 1,340 (8,699) --- (233) 2 (235) --- (565,284) (565,284) (244,823) 49,280 (294,103) 52.0% (554,256) (554,256) (241,447) 49,854 (291,301) 52.6% (127,044) (127,044) (58,270) 11,237 (69,507) 54.7% (315,000) (315,000) (117,935) 25,206 (143,141) 45.4% (57,600) (12,000) (11,114) 3,673 600 (8,041) 67.0% (6,810) - 1,510 (8,320) --- 10,944 2,218 - 13,162 --- 18,705 3,716 - 22,421 --- (12,400) (12,400) (5,811) - 2,088 (7,899) 63.7% (1,073) - 508 (1,581) --- (1,651,584) (1,605,984) (672,071) 9,607 142,961 (805,425) 50.2% 89,749 89,749 38,322 9,987 - 48,309 53.8% 4,500 4,500 120 4 124 2.7% 30,101 30,101 11,863 1,453 13,316 44.2% 500 500 - - - 0.0% 5,000 5,000 425 - 425 8.5% 9,364 9,364 4,511 858 5,369 57.3% 8,051 8,051 3,632 683 4,315 53.6% 1,883 1,883 849 160 1,009 53.6% 47,508 47,508 14,665 3,653 18,318 38.6% - - 90 22 112 --- 143 35 178 --- 337 - 337 --- - - 734 50 784 --- 14,500 14,500 12,740 1,031 13,771 95.0% - - 27 27 --- 5,350 5,350 - - - 0.0% - - 13,095 75 13,170 --- 100,000 75,000 8,835 1,690 10,525 14.0% - 25,000 10,173 2,045 12,218 48.9% 20,000 20,000 1,317 1,975 3,292 16.5% 24,000 24,000 15,358 2,558 17,916 74.6% Account Number Description Orig. Budget Amended Beg Balance Debit Credit Balance Ytd% 656-49870-432100 Telephone/Internet 2,640 2,640 925 8 933 35.3% 656-49870-432150 Salaries Part -Time Reg Internal IT Services 24,291 24,291 10,121 2,024 12,145 50.0% 656-49870-432200 Mail & Delivery Services - - 3,615 555 4,170 --- 656-49870-432500 - Cable/Network Services - 2,280 - 2,280 --- 656-49870-433200 6,610 Training/Conferences - - 12 Fica Contributions 12 --- 656-49870-434600 1,099 Marketing 1,500 1,500 259 2,829 259 17.3% 656-49870-436100 1,496 LPV Insurance 9,514 9,514 6,730 45,882 6,730 70.7% 656-49870-440100 58.8% Repair and Maint-Buildings - - 1,502 - 1,502 --- 656-49870-441200 656-49877-413400 Building/Room Rental 16,980 16,980 7,075 1,415 8,490 50.0% 656-49870-443200 LIC Benefit Payments Write Offs 11,000 11,000 8,989 790 9,779 88.9% 656-49870-443300 13,000 Dues Membership and Subscrip 1,500 1,500 1,295 - 1,295 86.3% 656-49870-443700 5,000 Licenses And Permits 1,500 1,500 164 - 164 10.9% 656-49870-443980 803 Bank Charges 15,000 15,000 5,272 953 6,225 41.5% 656-49870-443990 21 Miscellaneous Other Exp 6,000 6,000 12,805 338 13,143 219.0% 656-49870-472030 - Operating Transfer Out - - - - - --- 0.0% 656-49870 EXPENSE Tota IS: 450,431 450,431 198,280 32,362 230,642 51.2% Dept 49870 Field Operations 656-49877-410100 Salaries Full -Time Reg 165,118 185,118 83,104 17,187 100,291 54.2% 656-49877-410200 Salaries Full -Time OT 10,000 10,000 5,018 1,121 6,139 61.4% 656-49877-410300 Salaries Part -Time Reg 10,000 - - - --- 656-49877-410310 Salaries Part -Time OT 656-49877-410400 Salaries Temporary -Reg 10,000 - - - --- 656-49877-412100 Pera Contributions 13,884 13,884 6,610 1,373 7,983 57.5% 65649877-412200 Fica Contributions 12,097 12,097 5,303 1,099 6,402 52.9% 65649877-412300 Medicare Contributions 2,829 2,829 1,240 256 1,496 52.9% 656-49877413100 Health Insurance Contributions 45,882 45,882 21,525 5,440 26,965 58.8% 656-49877-413300 Life Insurance Contributions 130 33 163 --- 656-49877-413400 Disability Ins Contributions 229 57 286 --- 656-49877-414200 LIC Benefit Payments 5,000 5,000 - - 0.0% 656-49877-415100 Work Comp Ins Premiums 13,000 13,000 3,792 - 3,792 29.2% 656-49877-421110 Clothing Supplies 5,000 5,000 - - - 0.0% 656-49877-421200 Motor Fuels 10,000 10,000 803 302 1,105 11.0% 656-49877-421800 Fiber Optic Supplies 85,000 85,000 14,897 21 14,918 17.6% 656-49877-421820 Telcom/Phone Supplies 10,000 10,000 - - 0.0% 656-49877-421830 Video/Digital TV Supplies 30,000 30,000 0.0% 656-49877-421840 Data/Intemet Supplies 20,000 20,000 0.0% 656-49877-421990 Gen Operating Supplies 35,000 35,000 11,099 3,126 14,225 40.6% 656-49877-422500 Landscaping Materials 5,000 5,000 - - - 0.0% 656-49877-422990 Misc Repair and Maint Supplies 2,160 2,160 123 123 5.7% 656-49877-424100 Small Tools ($500-$9999) 25,000 25,000 - - - 0.0% 656-49877-431900 Maintenance Agreements 110,000 110,000 65,613 406 66,019 60.0% 656-49877-431990 Miscellaneous Prof Services 15,000 15,000 10,631 455 11,086 73.9% 656-49877-432770 Gopher State Locates 5,000 5,000 412 - 412 8.2% 656-49877-433100 Travel Expense 2,000 2,000 - - 0.0% 656-49877-433200 Training/Conferences 5,000 5,000 0.0% Account Number Description Orig. Budget Amended Beg Balance Debit Credit Balance Ytd% 656-49877-438100 Electric 27,500 27,500 10,767 1,489 12,256 44.6% 656-49877-438200 Water/Sewer 2,000 2,000 82 - 82 4.1% 656-49877-438400 Refuse/Recycling Services 500 500 411 137 548 109.7% 656-49877-440100 Repair and Maint-Buildings/Systems 10,000 10,000 - - - 0.0% 656-49877-440440 Repair & Maint-Mach & Equip 5,000 5,000 0.0% 656-49877-440500 Repair and Maint-Vehicles 5,000 5,000 0.0% 656-49877-443990 Miscellaneous Other Exp 6,255 6,255 0.0% 656-49877-458010 Other Equipment 120,000 120,000 0.0% 656-49877-472030 Operating Transfer Out - - --- 656-49877 EXPENSE Totals: 828,225 828,225 241,789 32,502 274,291 33.1% Dept 49879 Cost of Goods Sold 656-49879-430910 Voice -Technical Services 76,000 76,000 28,061 5,298 33,359 43.9% 656-49879-430920 Video -Technical Services 576,000 576,000 222,422 51,654 274,076 47.6% 656-49879-430930 Data -Technical Services 170,000 170,000 71,244 16,949 88,193 51.9% 656-49879-443720 Video -Licenses and Permits 67 - 67 --- 656-49879 EXPENSE Totals: 822,000 822,000 321,794 73,901 395,695 48.1% OPERATING EXPENSE Totals: 2,100,656 2,100,656 761,863 138,765 900,628 42.9% OPERATING LOSS (449,072) (494,672) (89,792) (148,372) (142,961) (95,203) 19.2% OPERATING - average monthly (loss) (37,423) (41,223) (15,867) Months Year % 6 12 50.0% SUMMARY OPERATING LOSS (449,072) (494,672) (89,792) (148,372) (142,961) (95,203) 19.2% NONOPERATING (REV)/EXP: 656-00000-362400 Sale of City Property (19,400) 15,500 (34,900) --- 656-00000-392000 Operating Transfer In (450,000) (450,000) (187,500) 37,500 (225,000) 50.0% NET 928 (44,672) 117,108 (148,372) (195,961) 164,697