Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
FiberNet Advisory Board Agenda Packet 08-11-2015
AGENDA FIBERNET MONTICELLO ADVISORY BOARD MEETING Tuesday, August 11, 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 July Meeting Minutes 4. Network update • 10 Gig Ring • Calix Compass • Gigacenter Trial 5. Business Office Update • August Subscriber Counts • Golden West • Data Requests 6. Business Manager Update 7. Yondoo Update 8. Consideration of removing legacy/loyalty pricing for residential internet to create consistent pricing for all internet customers. 9. Next Meeting — Tuesday, September 15th, 2015 10. Adjourn Residential & Business Subscribers (Customer Counts) Jan Feb Mar Apr 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 30 --- --- --- --- -8 -21.1% Internet Only 517 531 546 547 567 577 591 607 --- --- --- --- 90 17.4% (Television Only 89 85 82 81 75 75 76 78 --- --- --- --- -11 -12.4% Phone & Internet 171 167 163 167 173 174 170 171 --- --- --- --- 0 0.0% Phone & Television 52 51 51 48 51 50 50 51 --- --- --- --- -1 -1.9% Internet & Television 351 345 343 339 331 325 321 319 --- --- --- --- -32 -9.1% Triple Play 321 317 312 309 298 298 292 284 --- --- --- --- -37 -11.5% Total Subscribers I 1539 I 1532 I 1531 I 1524 I 1528 I 1532 I 1532 I 1540 I 0 I 0 I 0 I 0 I 1 0.1% Total Phone 582 571 560 557 555 555 544 536 --- --- --- --- -46 -7.9% Total Internet 1360 1360 1364 1362 1369 1374 1374 1381 --- --- --- --- 21 1.5% Total Television 813 798 788 777 755 748 739 732 --- --- --- --- -81 -10.0% Total Services 2755 2729 2712 2696 2679 2677 2657 2649 -106 -3.8% 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% 1.9% --- --- --- --- Internet Only 33.6% 34.7% 35.7% 35.9% 37.1% 37.7% 38.6% 39.4% --- --- --- --- Television Only 5.8% 5.5% 5.4% 5.3% 4.9% 4.9% 5.0% 5.1% --- --- --- --- Phone & Internet 11.1% 10.9% 10.6% 11.0% 11.3% 11.4% 11.1% 11.1% --- --- --- --- Phone & Television 3.4% 3.3% 3.3% 3.1% 3.3% 3.3% 3.3% 3.3% --- --- --- --- Internet & Television 22.8% 22.5% 22.4% 22.2% 21.7% 21.2% 21.0% 20.7% --- --- --- --- Triple Play 20.9% 20.7% 20.4% 20.3% 19.5% 19.5% 19.1% 18.4% --- --- --- --- Total Subscribers 1100.0% 1100.0% 1100.0% 1100.0% 1100.0% 1100.0% 1100.0% 1100.0% I 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% 20.2% --- --- --- --- Total Internet 49.4% 49.8% 50.3% 50.5% 51.1% 51.3% 51.7% 52.1% --- --- --- --- Total Television 29.5% 29.2% 29.1% 28.8% 28.2% 27.9% 27.8% 27.6% --- --- --- --- Total Services 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% Residential Subscribers (Customer Counts) Service I Jan I Feb I Mar I Apr Phone Only 30 28 26 25 Internet Only 490 499 511 517 Television Only 86 82 78 77 Phone & Internet 93 89 91 92 Phone & Television 51 50 50 47 Internet & Television 346 340 337 334 Triple Play 305 301 298 295 Total Subscribers 1401 1389 1391 1387 Total Phone 479 468 465 459 Total Internet 1234 1229 1237 1238 Total Television 788 773 763 753 Total Services 2501 2470 2465 2450 Residential (Percentage of Customers) May Jun Jul Aug Sep Oct Nov Dec YTD I CHG % 24 24 23 22 1.8% 1.7% 1.7% 1.6% -8 -26.7% 534 543 557 571 37.3% 38.4% 38.9% 39.8% 81 16.5% 72 72 73 76 5.6% 5.2% 5.2% 5.2% -10 -11.6% 98 101 100 101 6.6% 7.0% 7.2% 7.1% 8 8.6% 50 49 49 50 3.4% 3.6% 3.5% 3.5% -1 -2.0% 329 323 319 317 24.1% 23.7% 23.1% 22.8% -29 -8.4% 284 285 278 270 21.3% 20.4% 20.4% 19.9% -35 -11.5% 1391 1397 1399 1407 0 0 0 0 6 0.4% 456 459 450 443 0 0 0 0 -36 -7.5% 1245 1252 1254 1259 0 0 0 0 25 2.0% 735 729 719 713 0 0 0 0 -75 -9.5% 2436 2440 2423 2415 0 0 0 0 -86 -3.4% Service Jan Feb Mar Apr May Jun Jul Aug Sep Phone Only 2.1% 2.0% 1.9% 1.8% 1.7% 1.7% 1.6% 1.6% --- Internet Only 35.0% 35.9% 36.7% 37.3% 38.4% 38.9% 39.8% 40.6% --- Television Only 6.1% 5.9% 5.6% 5.6% 5.2% 5.2% 5.2% 5.4% --- Phone & Internet 6.6% 6.4% 6.5% 6.6% 7.0% 7.2% 7.1% 7.2% --- Phone & Television 3.6% 3.6% 3.6% 3.4% 3.6% 3.5% 3.5% 3.6% --- Internet & Television 24.7% 24.5% 24.2% 24.1% 23.7% 23.1% 22.8% 22.5% --- Triple Play 21.8% 21.7% 21.4% 21.3% 20.4% 20.4% 19.9% 19.2% --- Total Subscribers 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 0.0% Total Phone 19.2% 18.9% 18.9% 18.7% 18.7% 18.8% 18.6% 18.3% --- Total Internet 49.3% 49.8% 50.2% 50.5% 51.1% 51.3% 51.8% 52.1% --- Total Television 31.5% 31.3% 31.0% 30.7% 30.2% 29.9% 29.7% 29.5% --- Total Services 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% --- Oct Nov Dec 0.0% 0.0% 0.0% Business Subcribers (Customer Counts) Service Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YTD CHG % Phone Only Internet Only Television Only 8 8 8 8 9 9 9 8 25.2% 25.6% 27.1% Television Only 0 9 -1 0.0% 33.3% -33.3% 27 32 35 30 33 34 34 36 3 3 4 4 3 3 3 2 Phone & Internet 78 78 72 75 75 73 70 70 54.7% 54.1% 52.6% 52.6% -8 -10.3% Phone & Television 1 1 1 1 1 1 1 1 3.5% 4.3% 3.6% 1.5% 0 0.0% Internet & Television 5 5 6 5 2 2 2 2 10.5% Total Subscribers 100.0% 100.0% -3 -60.0% Triple Play 16 16 14 14 14 13 14 14 40.7% 40.5% 40.2% 39.7% -2 -12.5% Total Subscribers 138 143 140 137 137 135 133 133 0 0 0 0 -5 -3.6% Total Phone 103 103 95 98 99 96 94 93 0 0 0 0 -10 -9.7% Total Internet 126 131 127 124 124 122 120 122 0 0 0 0 -4 -3.2% Total Television Total Services 25 25 25 24 20 19 20 19 0 0 0 0 -6 -20 -24.0% -7.9% 254 259 247 246 243 237 234 234 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% 6.0% Internet Only 19.6% 22.4% 25.0% 21.9% 24.1% 25.2% 25.6% 27.1% Television Only 2.2% 2.1% 2.9% 2.9% 2.2% 2.2% 2.3% 1.5% Phone & Internet 56.5% 54.5% 51.4% 54.7% 54.7% 54.1% 52.6% 52.6% Phone & Television 0.7% 0.7% 0.7% 0.7% 0.7% 0.7% 0.8% 0.8% Internet & Television 3.6% 3.5% 4.3% 3.6% 1.5% 1.5% 1.5% 1.5% Triple Play 11.6% 11.2% 10.0% 10.2% 10.2% 9.6% 10.5% 10.5% Total Subscribers 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% Total Phone 40.6% 39.8% 38.5% 39.8% 40.7% 40.5% 40.2% 39.7% Total Internet 49.6% 50.6% 51.4% 50.4% 51.0% 51.5% 51.3% 52.1% Total Television 9.8% 9.7% 10.1% 9.8% 8.2% 8.0% 8.5% 8.1% Total Services 100.0% 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% Proposed Internet Price Change Sub Count Previous Current Current Price Proposed Price Increase Potential Revenue Legacy 434 20 MBPS 50 MBPS $34.95 $35.95 $1.00 $434.00 Loyalty 549 10 MBPS 50 MBPS $29.95 $35.95 $6.00 $3,294.00 Total 983 $3,728.00 As Is Monthly Increase = $3,728.00 4th Quarter Revenue Increase = $11,184.00 15% Subscriber Count Decline Monthly Increase = $3,165.00 4th Quarter Revenue Increase = $9,495.00 Promos Avg. Disc. Total Legacy 18 $5.61 $101.00 Loyalty 2 $5.50 $11.00 100M 1 $17.25 $17.25 21 $129.25 The proposed change to internet pricing contains 2 components: 1. Remove the prices "grandfathered in" when speeds were increased in fall 2014. All internet subs would pay the same rate of $35.95 for internet. 2. Remove the old internet promotions from subscriber accounts. They no longer apply to the current pricing structure. Fiber Net Schedule of Revenue and Expenses (Modified Accrual Basis) 7/31/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/Purchase 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,828) $ $ 628 $ (4,455) 44.6% (10,000) (10,000) (4,132) 672 (4,804) 48.0% (222) - (222) --- (8,699) 1,330 (10,029) --- (235) 171 (406) --- (565,284) (565,284) (294,103) 48,493 (342,596) 60.6% (554,256) (554,256) (291,301) 49,924 (341,224) 61.6% (127,044) (127,044) (69,507) 13,327 (82,834) 65.2% (315,000) (315,000) (143,141) 24,424 (167,565) 53.2% (57,600) (12,000) (8,041) - (8,041) 67.0% (8,320) 1,215 (9,535) --- 13,162 2,205 - 15,367 --- 22,421 3,570 - 25,991 --- (12,400) (12,400) (7,899) - 2,498 (10,397) 83.8% (1,581) - 13 (1,593) --- (1,651,584) (1,605,984) (805,425) 5,775 142,695 (942,345) 58.7% 89,749 89,749 48,309 14,283 - 62,592 69.7% 4,500 4,500 124 14 138 3.1% 30,101 30,101 13,316 2,171 15,487 51.5% 500 500 - - - 0.0% 5,000 5,000 425 - 425 8.5% 9,364 9,364 5,369 1,235 6,604 70.5% 8,051 8,051 4,315 987 5,303 65.9% 1,883 1,883 1,009 231 1,240 65.8% 47,508 47,508 18,318 3,697 22,015 46.3% - - 112 22 134 --- 178 36 214 --- 337 337 --- - - 784 - 784 --- 14,500 14,500 13,771 440 14,211 98.0% 5,350 5,350 - - - 0.0% - - 13,170 150 13,320 --- 100,000 75,000 10,525 2,015 12,540 16.7% - 25,000 12,218 2,016 - 14,234 56.9% 20,000 20,000 3,292 5,929 3,950 5,271 26.4% 24,000 24,000 17,916 6,612 - 24,528 102.2% Account Number Description Orig. Budget Amended Beg Balance Debit Credit Balance Ytd% 656-49870-432100 Telephone/Internet 2,640 2,640 933 909 1,842 69.8% 656-49870-432150 Internal IT Services 24,291 24,291 12,145 2,024 14,170 58.3% 656-49870-432200 Mail & Delivery Services - - 4,170 933 5,103 --- 656-49870-432500 Cable/Network Services 10,000 - 2,280 1,901 4,182 --- 656-49870-433200 Training/Conferences - - 12 - 12 --- 656-49870-434600 Marketing 1,500 1,500 259 5 264 17.6% 656-49870-436100 LPV Insurance 9,514 9,514 6,730 - 6,730 70.7% 656-49870-440100 Repair and Maint-Buildings - - 1,502 - 1,502 --- 656-49870-441200 Building/Room Rental 16,980 16,980 8,490 1,415 9,905 58.3% 656-49870-443200 Write Offs 11,000 11,000 9,779 760 10,539 95.8% 656-49870-443300 Dues Membership and Subscrip 1,500 1,500 1,295 - 1,295 86.3% 656-49870-443700 Licenses And Permits 1,500 1,500 164 1,293 1,457 97.1% 656-49870-443980 Bank Charges 15,000 15,000 6,225 950 7,175 47.8% 656-49870-443990 Miscellaneous Other Exp 6,000 6,000 13,143 112 13,255 220.9% 656-49870-472030 Operating Transfer Out - - - - - - --- 656-49877-421820 656-49870 EXPENSE TotaIS: 450,431 450,431 230,615 50,142 3,950 276,807 61.5% Dept 49870 Field Operations 656-49877-410100 Salaries Full -Time Reg 165,118 185,118 100,291 25,513 125,804 68.0% 656-49877-410200 Salaries Full -Time OT 10,000 10,000 6,139 1,281 7,421 74.2% 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 7,983 2,009 9,992 72.0% 65649877-412200 Fica Contributions 12,097 12,097 6,402 1,625 8,027 66.4% 65649877-412300 Medicare Contributions 2,829 2,829 1,496 380 1,876 66.3% 656-49877413100 Health Insurance Contributions 45,882 45,882 26,965 5,440 32,405 70.6% 656-49877-413300 Life Insurance Contributions 163 33 195 --- 656-49877-413400 Disability Ins Contributions 286 57 344 --- 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 1,105 260 1,365 13.6% 656-49877-421800 Fiber Optic Supplies 85,000 85,000 14,918 14,015 28,933 34.0% 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 14,225 1,039 587 14,677 41.9% 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 66,019 - - 66,019 60.0% 656-49877-431990 Miscellaneous Prof Services 15,000 15,000 11,086 3,949 10,536 4,499 30.0% 656-49877-432770 Gopher State Locates 5,000 5,000 412 172 - 584 11.7% 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 12,256 1,795 14,051 51.1% 656-49877-438200 Water/Sewer 2,000 2,000 82 - 82 4.1% 656-49877-438400 Refuse/Recycling Services 500 500 548 137 685 137.1% 656-49877-440100 Repair and Maint-Buildings/Systems 10,000 10,000 - 6,630 6,630 66.3% 656-49877-440440 Repair & Maint-Mach & Equip 5,000 5,000 - - 0.0% 656-49877-440500 Repair and Maint-Vehicles 5,000 5,000 575 575 11.5% 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 274,291 64,910 11,123 328,078 39.6% Dept 49879 Cost of Goods Sold 656-49879-430910 Voice -Technical Services 76,000 76,000 33,359 5,921 39,280 51.7% 656-49879-430920 Video -Technical Services 576,000 576,000 274,076 50,790 324,866 56.4% 656-49879-430930 Data -Technical Services 170,000 170,000 88,193 14,249 102,442 60.3% 656-49879-443720 Video -Licenses and Permits 67 - 67 --- 656-49879 EXPENSE Totals: 822,000 822,000 395,695 70,959 466,654 56.8% OPERATING EXPENSE Totals: 2,100,656 2,100,656 900,601 186,011 15,073 1,071,539 51.0% OPERATING (LOSS) (449,072) (494,672) (95,176) (191,786) (157,768) (129,194) 26.1% OPERATING - average monthly (loss) (37,423) (41,223) SUMMARY Description OPERATING (LOSS) NONOPERATING (REV)/EXP: 656-00000-362400 Sale of City Property 656-00000-392000 Operating Transfer In NET (18,456) Months Year 7 12 58.3% Orig. Budget AmendedBudgetBeg Balance Debit Credit Balance Ytd% (449,072) (494,672) (95,176) (191,786) (157,768) (129,194) 26.1% - (34,900) - (34,900) --- (450,000) (450,000) (225,000) 37,500 (262,500) 58.3% 928 (44,672) 164,724 (191,786) (195,268) 168,206