Loading...
FiberNet Advisory Board Agenda Packet 03-10-2015AGENDA FIBERNET MONTICELLO ADVISORY BOARD MEETING Tuesday, March 10, 2015 — 6 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 Meeting Minutes 4. Network update. • E7 Migration • Golden West • Television Service • Technology Presentation & Discussion (David Russell) 5. Business Office Update • E7 Audit Results • Latest Subscriber Data 6. Financial Update 7. Management Update 8. Recommendation on charging service fee for changes to subscriber accounts 9. Recommendation regarding pricing adjustment for premium channel packages 10. Review & discuss FiberNet Advisory Board responsibilities as specified by operational guidelines. 11. Next Meeting — Tuesday, April 14th, 2015 12. Adjourn Residential & 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 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 Jan Feb Mar 38 36 34 517 531 546 89 85 82 171 167 163 52 51 51 351 345 343 321 317 312 1539 1532 1531 582 571 560 1360 1360 1364 813 798 788 Jan Feb Mar 30 28 26 490 499 511 86 82 78 93 89 91 51 50 50 346 340 337 305 301 298 1401 1389 1391 4791 468 465 1234 1229 1237 788 773 763 Jan Feb Mar 8 8 8 27 32 35 3 3 4 78 78 72 1 1 1 5 5 6 16 16 14 138 143 140 103 103 95 126 131 127 25 25 21 Fiber Net Schedule of Revenue and Expenses 2/28/2015 Account Number Description Budget Beg Balance Debt Credit Balance Ytd% REVENUE 656-00000-341180 PEG Access Fee $ (10,000) $ (659) $ - $ 644 $ (1,303) 13.0% 656-00000-341190 USF Fee (10,000) (675) - 679 (1,354) 13.5% 656-00000-362400 Sale of City Property - (500) - - (500) --- 656-00000-362900 Refunds and Reimbursements - (222) - - (222) --- 656-00000-362920 Services - Misc - (1,515) - 1,515 (3,029) --- 656-00000-362990 Other Miscellaneous Revenue - (11) 4 8 (15) --- 656-00000-380510 Television Services (565,284) (45,118) - 50,974 (96,092) 17.0% 656-00000-380520 Internet Services (554,256) (47,631) - 47,524 (95,156) 17.2% 656-00000-380522 Equipment Rental/Purch (127,044) (10,681) - 11,363 (22,044) 17.4% 656-00000-380530 Phone Services (315,000) (17,886) - 25,088 (42,974) 13.6% 656-00000-380540 CABS Revenue (57,600) (3,266) 1,363 4,512 (6,415) 11.1% 656-00000-380542 Late Fees - (1,480) - 1,535 (3,015) --- 656-00000-380545 Discounts Offered -Taxable - 2,224 2,170 - 4,395 --- 656-00000-380546 Discounts Offered -Non Taxable - 3,855 3,782 - 7,637 --- 656-00000-380557 Miscellaneous Charges (12,400) (620) - 470 (1,089) 8.8% 656-00000-380558 Misc Charges -Non Taxable - 45 - 337 (291) --- 656-00000-392000 Operating Transfer In (450,000) (37,500) - 37,500 (75,000) 16.7% REVENUE Totals: (2,101,584) (161,639) 7,320 182,149 (336,468) 16.0% EXPENSE Dept 49870 General & Administration 656-49870-410100 Salaries Full -Time Reg 89,749 (879) 10,244 - 9,366 10.4% 656-49870-410200 Salaries Full -Time OT 4,500 14 48 - 61 1.4% 656-49870-410300 Salaries Part -Time Reg 30,101 3,164 3,955 - 7,119 23.7% 656-49870-410310 Salaries Part -Time. OT 500 - - - - 0.0% 656-49870-410400 Salaries Temporary -Reg 5,000 - 61 - 61 1.2% 656-49870-412100 Pera Contributions 9,364 911 1,069 - 1,979 21.1% 656-49870-412200 Fica Contributions 8,051 736 860 - 1,597 19.8% 656-49870-412300 Medicare Contributions 1,883 172 201 - 373 19.8% 656-49870-413100 Health Insurance Contributions 47,508 - 3,695 - 3,695 7.8% 656-49870-413300 Life Insurance Contributions - - 23 - 23 --- 656-49870-413400 Disability Ins Contributions - - 38 - 38 --- 656-49870-414200 UC Benefit Payments - - - - - --- 656-49870-420300 Printed Forms And Paper - - 337 - 337 --- 656-49870-420990 Office Supplies - - 179 - 179 --- 656-49870-421990 Gen Operating Supplies 14,500 103 3,290 62 3,330 23.0% 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 - - 900 - 900 --- Account Number Description Budget Beg Balance Debt Credit Balance Ytd% 656-49870-430700 Salaries Full -Time OT 10,000 Management Services (GM) 120,000 - 23.8% - - 0.0% 656-49870-431970 Regulatory Professional Svcs 20,000 - 658 - 658 3.3% 656-49870431990 - Miscellaneous Prof Services - 2,617 1,930 - 4,547 --- 656-49870-432100 0.0% 656-49877-412100 Telephone Internet 2,640 150 1,417 - 150 5.7% 656-49870-432150 Fica Contributions 12,097 Internal IT Services 24,291 2,024 2,024 - 4,048 16.7% 656-49870-432200 217 265 Mail & Delivery Services - 543 7 - 550 --- 656-49870-432500 5,205 11.3% Cable/Network Services - - 128 - 128 --- 656-49870-433200 656-49877-413400 Disability Ins Contributions Training/Conferences - - 12 - 12 --- 656-49870-434600 5,000 Marketing 1,500 - - - - 0.0% 656-49870-436100 - LPV Insurance 9,514 6,730 - - 6,730 70.7% 656-49870-440100 0.0% 656-49877-421200 Repair and Maint-Buildings - - 1,199 - 1,199 --- 656-49870-441200 Fiber Optic Supplies 85,000 Building/Room Rental 16,980 1,415 1,415 - 2,830 16.7% 656-49870-443200 Write Offs 11,000 4,394 - - 4,394 39.9% 656-49870-443300 - 0.0% Dues Membership and Subscrip 1,500 400 - - 400 26.7% 656-49870-443700 656-49877-421990 Gen Operating Supplies Licenses And Permits 1,500 - - - - 0.0% 656-49870-443980 5,000 - Bank Charges 15,000 852 922 - 1,774 11.8% 656-49870-443990 - - - Miscellaneous Other Exp 10,000 208 6 - 214 2.1% 656-49870-472030 Operating Transfer Out - - - - - --- 656-49870 EXPENSE TotalS: 450.431 23.554 33.228 62 56.720 12.6% Dept 49870 Field Operations 656-49877-410100 Salaries Full -Time Reg 165,118 13,994 17,678 31,672 19.2% 656-49877-410200 Salaries Full -Time OT 10,000 1,167 1,211 2,379 23.8% 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 1,137 1,417 2,554 18.4% 65649877-412200 Fica Contributions 12,097 926 1,134 2,060 17.0% 65649877-412300 Medicare Contributions 2,829 217 265 482 17.0% 656-49877413100 Health Insurance Contributions 45,882 5,205 5,205 11.3% 656-49877-413300 Life Insurance Contributions 33 33 --- 656-49877-413400 Disability Ins Contributions 57 57 --- 656-49877-414200 LIC Benefit Payments 5,000 - 0.0% 656-49877-415100 Work Comp Ins Premiums 13,000 - 0.0% 656-49877-421110 Clothing Supplies 5,000 - 0.0% 656-49877-421200 Motor Fuels 10,000 157 157 1.6% 656-49877-421800 Fiber Optic Supplies 85,000 8,717 762 9,479 11.2% 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 - 501 - 501 1.4% 656-49877-422500 Landscaping Materials 5,000 - - - - 0.0% 656-49877-422990 Misc Repair and Maint Supplies 2,160 - - - - 0.0% Account Number Description 656-49877-424100 Small Tools ($500-$9999) 656-49877-431900 Maintenance Agreements 656-49877-431990 Miscellaneous Prof Services 656-49877-432770 Gopher State Locates 656-49877-433100 Travel Expense 656-49877-433200 Training/Conferences 656-49877-438100 Electric 656-49877-438200 Water/Sewer 656-49877-438400 Refuse 656-49877-440100 Repair and Maint-Buildings 656-49877-440440 Repair & Maint-Mach & Equip 656-49877-440500 Repair and Maint-Vehicles 656-49877-443990 Miscellaneous Other Exp 656-49877-458010 Other Equipment 656-49877-472030 Operating Transfer Out 656-49877 EXPENSE Totals: Dept 49879 Cost of Goods Sold 656-49879-430910 Voice -Technical Services 656-49879-430920 Video -Technical Services 656-49879-430930 Data -Technical Services 656-49879-443720 Video -Licenses and Permits 656-49879 EXPENSE Totals: EXPENSE Totals: Net Average loss per month Budget Beg Balance Debt Credit Balance Ytd% 25,000 - - - - 0.0% 110,000 63,536 - - 63,536 57.8% 15,000 - 641 - 641 4.3% 5,000 50 31 - 81 1.6% 2,000 - - - - 0.0% 5,000 - - - - 0.0% 27,500 - - - - 0.0% 2,000 - - - - 0.0% 500 - - - - 0.0% 10,000 - - - - 0.0% 5,000 - - - - 0.0% 5,000 - - - - 0.0% 6,255 - - - - 0.0% 120,000 - - - - 0.0% 828,225 89,743 29,093 - 118,837 14.3% 76,000 5,581 6,240 11,820 15.6% 576,000 98,216 98,216 17.1% 170,000 9,849 18,649 28,497 16.8% 67 67 --- 822,000 15,429 123,171 - 138,600 16.9% 2.100.656 128.727 185.492 62 314.157 15.0% 928 32,912 (192,812) (182,211) 22,311 (26,345) Months Year % 2 12 16.7%