Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
FiberNet Advisory Board Agenda Packet 06-09-2015
AGENDA FIBERNET MONTICELLO ADVISORY BOARD MEETING Tuesday, June 9, 2015 — 6:30 p.m. Boom Island Room, Monticello Community Center 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 May Meeting Minutes 4. Special Meeting Follow -Up • Decisions made at special meeting on 6/3/15 • Council action on 6/8/15 related to special meeting topics 5. Network update 6. Business Office Update • Latest Subscriber Data • Business Manager Update 7. Consideration of establishing minimum criteria for notifying customers of maintenance activity and associated potential for an outage 8. Consideration of authorizing staff to create temporary promotional pricing program 9. Consideration of continuing service with Golden West 10. Consideration of updating ordinance language from General Manager to Business Manager 11. Review concept of utilizing a third party to facilitate lease of fiber and antenna space supporting small cell applications. 12. Public Broadband Alliance Update 13. Next Meeting — Tuesday, July 14th, 2015 14. Adjourn Residential & Business Subscribers Service Jan Phone Only 38 Internet Only 517 Television Only 89 Phone & Internet 171 Phone & Television 52 Internet & Television 351 Triple Play 321 Total Subscribers 1539 Total Phone 582 167 Total Internet 1360 173 Total Television 813 51 Residential Subscribers Service Phone Only Internet Only Television Only Phone & Internet Phone & Television Internet & Television Triple Play Total Subscribers Total Phone Total Internet Total Television Business Subscribers Service Phone Only Internet Only Television Only Phone & Internet Phone & Television Internet & Television Triple Play Total Subscribers Total Phone Total Internet Total Television Feb Mar Apr May 1 Jun 36 34 33 33 33 531 546 547 567 577 85 82 81 75 75 167 163 167 173 174 51 51 48 51 50 345 343 339 331 325 317 312 309 298 298 1532 1531 1524 1528 1532 571 560 557 555 555 1360 1364 1362 1369 1374 798 788 777 755 748 Jan Feb Mar Apr May Jun 30 28 26 25 24 24 490 499 511 517 534 543 86 82 78 77 72 72 93 89 91 92 98 101 51 50 50 47 50 49 346 340 337 334 329 323 305 301 298 295 284 285 1401 1389 1391 1387 1391 1397 479 468 465 459 456 459 1234 1229 1237 1238 1245 1252 788 773 763 753 735 729 Jan Feb Mar Apr May Jun 8 8 8 8 9 9 27 32 35 30 33 34 3 3 4 4 3 3 78 78 72 75 75 73 1 1 1 1 1 1 5 5 6 5 2 2 16 16 14 14 14 13 138 143 140 137 137 135 103 103 95 98 99 96 126 131 127 124 124 122 25 25 25 24 20 19 Fiber Net Schedule of Revenue and Expenses 5/31/2015 Account Number Description Budget Beg Balance Debit Credit Balance Ytd% REVENUE 656-00000-341180 PEG Access Fee $ (10,000) $ (2,577) $ - $ 619 $ (3,196) 32.0% 656-00000-341190 USF Fee (10,000) (2,725) - 703 (3,428) 34.3% 656-00000-362400 Sale of City Property - (3,700) - 15,700 (19,400) --- 656-00000-362900 Refunds and Reimbursements - (222) - - (222) --- 656-00000-362920 Services - Misc - (6,021) - 1,338 (7,359) --- 656-00000-362990 Other Miscellaneous Revenue - (231) - 2 (233) --- 656-00000-380510 Television Services (565,284) (195,891) - 48,932 (244,823) 43.3% 656-00000-380520 Internet Services (554,256) (192,014) - 49,433 (241,447) 43.6% 656-00000-380522 Equipment Rental/Purch (127,044) (43,909) - 14,361 (58,270) 45.9% 656-00000-380530 Phone Services (315,000) (93,583) - 24,352 (117,935) 37.4% 656-00000-380540 CABS Revenue (57,600) 2,028 121 13,263 (11,114) 19.3% 656-00000-380542 Late Fees - (5,580) - 1,230 (6,810) --- 656-00000-380545 Discounts Offered -Taxable - 8,652 2,292 - 10,944 --- 656-00000-380546 Discounts Offered -Non Taxable - 15,029 3,676 - 18,705 --- 656-00000-380557 Miscellaneous Charges (12,400) (3,650) - 2,161 (5,811) 46.9% 656-00000-380558 Misc Charges -Non Taxable - (948) - 125 (1,073) --- 656-00000-392000 Operating Transfer In (450,000) (150,000) - (150,000) 33.3% REVENUE Totals: (2,101,584) (675,341) 6,089 172,219 (841,471) 40.0% EXPENSE Dept 49870 General & Administration 656-49870-410100 Salaries Full -Time Reg 89,749 28,541 9,781 - 38,322 42.7% 656-49870-410200 Salaries Full -Time OT 4,500 103 17 - 120 2,7% 656-49870-410300 Salaries Part -Time Reg 30,101 10,605 1,258 - 11,863 39.4% 656-49870-410310 Salaries Part -Time. OT 500 - - - - 0.0% 656-49870-410400 Salaries Temporary -Reg 5,000 425 - - 425 8.5% 656-49870-412100 Pera Contributions 9,364 3,682 829 - 4,511 48.2% 656-49870-412200 Fica Contributions 8,051 2,973 659 - 3,632 45.1% 656-49870-412300 Medicare Contributions 1,883 695 154 - 849 45.1% 656-49870-413100 Health Insurance Contributions 47,508 11,008 3,657 - 14,665 30.9% 656-49870-413300 Life Insurance Contributions - 68 22 - 90 --- 656-49870-413400 Disability Ins Contributions - 108 35 - 143 --- 656-49870-414200 UC Benefit Payments - - - - - --- 656-49870-420300 Printed Forms And Paper - 337 - - 337 --- 656-49870-420990 Office Supplies - 374 360 - 734 --- 656-49870-421990 Gen Operating Supplies 14,500 10,023 2,921 204 12,740 87.9% 656-49870-422100 Equipment Repair Parts - - - - - --- 656-49870-422110 Vehicle Repair Parts - 27 - - 27 --- 656-49870-430100 Professional Services -Audit 5,350 - - - - 0.0% 656-49870-430400 Legal Fees - 12.540 555 - 13,095 --- Account Number Description Budget Beg Balance Debit Credit Balance Ytd% 656-49870-430700 Salaries Full -Time OT 10,000 Management Services (GM) 100,000 8.120 715 - 8,835 8.8% 656-49870-431800 - Professional Services -Billings - - 10,173 - 10,173 --- 656-49870-431970 - --- Regulatory Professional Svcs 20,000 1.317 - - 1,317 6.6% 656-49870-431990 656-49877-412100 Pera Contributions Miscellaneous Prof Services 24,000 15,408 8,091 8,141 15,358 64.0% 656-49870-432100 12,097 4,234 Telephone/Internet 2,640 612 313 - 925 35.0% 656-49870-432150 250 1,240 Internal IT Services 24,291 8,097 2,024 - 10,121 41.7% 656-49870-432200 46.9% 656-49877-413300 Mail & Delivery Services - 2,480 1,135 - 3,615 --- 656-49870-432500 Disability Ins Contributions Cable/Network Services - 2,152 128 - 2,280 --- 656-49870-433200 - Training/Conferences - 12 - - 12 --- 656-49870-434600 3,792 29.2% Marketing 1,500 220 39 - 259 17.3% 656-49870-436100 656-49877-421200 Motor Fuels LPV Insurance 9,514 6,730 - - 6,730 70.7% 656-49870-440100 85,000 14,582 Repair and Maint-Buildings - 1,502 - - 1,502 --- 656-49870-441200 - Building/Room Rental 16,980 5,660 1,415 - 7,075 41.7% 656-49870-443200 0.0% 656-49877-421840 Write Offs 11,000 7,530 1,459 - 8,989 81.7% 656-49870-443300 Gen Operating Supplies 35,000 Dues Membership and Subscrip 1,500 400 895 - 1,295 86.3% 656-49870-443700 - - Licenses And Permits 1,500 139 25 - 164 10.9% 656-49870-443980 Bank Charges 15,000 4,321 951 - 5,272 35.1% 656-49870-443990 Miscellaneous Other Exp 6,000 225 12,580 - 12,805 213.4% 656-49870-472030 Operating Transfer Out - - - - - --- 656-49870 EXPENSE TotalS: 450.431 146.434 60.191 8.345 198.280 44.0% Dept 49870 Field Operations 656-49877-410100 Salaries Full -Time Reg 165,118 65,932 17,172 83,104 50.3% 656-49877-410200 Salaries Full -Time OT 10,000 4,357 661 5,018 50.2% 656-49877-410300 Salaries Part -Time Reg 10,000 - - 0.0% 656-49877-410310 Salaries Part -Time OT - - --- 656-49877-410400 Salaries Temporary -Reg 10,000 - - 0.0% 656-49877-412100 Pera Contributions 13,884 5,272 1,338 6,610 47.6% 65649877-412200 Fica Contributions 12,097 4,234 1,069 5,303 43.8% 65649877-412300 Medicare Contributions 2,829 990 250 1,240 43.8% 656-49877413100 Health Insurance Contributions 45,882 16.085 5,440 21,525 46.9% 656-49877-413300 Life Insurance Contributions 98 33 130 --- 656-49877-413400 Disability Ins Contributions 172 57 229 --- 656-49877-414200 UC Benefit Payments 5,000 - - 0.0% 656-49877-415100 Work Comp Ins Premiums 13,000 3.792 - 3,792 29.2% 656-49877-421110 Clothing Supplies 5,000 - - - 0.0% 656-49877-421200 Motor Fuels 10,000 532 271 803 8.0% 656-49877-421800 Fiber Optic Supplies 85,000 14,582 315 14,897 17.5% 656-49877-421820 Telcom/Phone Supplies 10,000 - - 0.0% 656-49877-421830 Video/Digital TV Supplies 30,000 - - 0.0% 656-49877-421840 Data/Intemet Supplies 20,000 - - 0.0% 656-49877-421990 Gen Operating Supplies 35,000 5.258 5,841 - 11,099 31.7% 656-49877-422500 Landscaping Materials 5,000 - - - - 0.0% Account Number Description Budget Beg Balance Debit Credit Balance Ytd% 656-49877-422990 Misc Repair and Maint Supplies 2,160 121 2 - 123 5.7% 656-49877-424100 Small Tools ($500-$9999) 25,000 - - - - 0.0% 656-49877-431900 Maintenance Agreements 110,000 65,613 - 65,613 59.6% 656-49877-431990 Miscellaneous Prof Services 15,000 1,603 9,028 - 10,631 70.9% 656-49877-432770 Gopher State Locates 5,000 172 240 - 412 8.2% 656-49877-433100 Travel Expense 2,000 - - - - 0.0% 656-49877-433200 Training/Conferences 5,000 - - - - 0.0% 656-49877-438100 Electric 27,500 8,821 1,946 - 10,767 39.2% 656-49877-438200 Water/Sewer 2,000 - 82 - 82 4.1% 656-49877-438400 Refuse/Recycling Services 500 274 137 - 411 82.3% 656-49877-440100 Repair and Maint-Buildings 10,000 - - - - 0.0% 656-49877-440440 Repair & Maint-Mach & Equip 5,000 - - - - 0.0% 656-49877-440500 Repair and Maint-Vehicles 5,000 - - - - 0.0% 656-49877-443990 Miscellaneous Other Exp 6,255 - - - - 0.0% 656-49877-458010 Other Equipment 120,000 - - - - 0.0% 656-49877-472030 Operating Transfer Out - - - - - --- 656-49877 EXPENSE Totals: 828,225 197,907 43,882 - 241,789 29.2% Dept 49879 Cost of Goods Sold 656-49879-430910 Voice -Technical Services 76,000 22,732 5,329 28,061 36.9% 656-49879-430920 Video -Technical Services 576,000 160.575 61,847 222,422 38.6% 656-49879-430930 Data -Technical Services 170,000 56,995 14,249 71,244 41.9% 656-49879-443720 Video -Licenses and Permits 67 - 67 --- 656-49879 EXPENSE Totals: 822,000 240,369 81,425 - 321,794 39.1% EXPENSE Totals: 2,100,656 584,710 185,498 8,345 761,863 36.3% Net 928 90,631 (191,587) (180,564) 79,608 Average loss per month (14,078) Months Year % 5 12 41.7%