Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
FiberNet Advisory Board Agenda Packet 12-08-2015
AGENDA FIBERNET MONTICELLO ADVISORY BOARD MEETING Tuesday, December 8, 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, Rachel Leonard, Bryan Rabe 1. Call to Order 2. Additions to Agenda 3. Approval of November Meeting Minutes 4. Approval of March 2014 Meeting Minutes 5. Network update 6. Business Office Update 7. Financial Update 8. Management Update 9. Consideration of recommending FiberNet budget to City Council for approval 10. Consideration of amending equipment prices for 2016 11. Next Meeting — Tuesday, January 12, 2016 12. Adjourn MINUTES REGULAR MEETING — FIBERNET MONTICELLO ADVISORY BOARD Tuesday, November 1011, 2015 Boom Island Room, Monticello Community Center Present: Brian Stumpf, Charlotte Gabler, Dennis Sullivan, Jacob Kramer Absent: Jon Morphew Others: Jeff O'Neill, Rachel Leonard, Bryan Rabe, Wayne Oberg 1. Call to Order Brian Stumpf called the meeting to order at 6:30 PM. 2. Additions to Agenda • 2016 Draft Budget 3. Avoroval of October Meeting Minutes DENNIS SULLIVAN MOVED TO APPROVE THE OCTOBER 13TH, 2015 REGULAR MEETING MINUTES. CHARLOTTE GABLER SECONDED THE MOTION. MOTION CARRIED 4-0. 4. Avoroval of 2014 Meeting Minutes JACOB KRAMER MOVED TO APPROVE THE AUGUST 13TH, 2014 REGULAR MEETING MINUTES. CHARLOTTE GABLER SECONDED THE MOTION. MOTION CARRIED 4-0. JACOB KRAMER MOVED TO APPROVE THE OCTOBER 14TH, 2014 REGULAR MEETING MINUTES. CHARLOTTE GABLER SECONDED THE MOTION. MOTION CARRIED 4-0. JACOB KRAMER MOVED TO APPROVE THE NOVEMBER 18TH, 2014 REGULAR MEETING MINUTES. DENNIS SULLIVAN SECONDED THE MOTION. MOTION CARRIED 4-0. 5. Netyyork Update • Bryan Rabe updated the board on an IP phone change being tested. If successful, it will help prevent future phone hackings. • Bryan Rabe updated the board on the November 9th City Council decision to continue using Calix Compass on a month-to-month basis. • Jeff O'Neill updated the board on the need to determine the cost to wire the apartment building being built in Monticello. DENNIS SULLIVAN MOVED TO RECOMMEND THE USE OF FUNDS FOR A COST STUDY ON PROVIDING SERVICE TO UPCOMING 200 UNIT APARTMENT BUILDING NOT TO EXCEED $4,500. JACOB KRAMER SECONDED THE MOTION. MOTION CARRIED 4-0. 6. Business Office Update • Rachel Leonard provided the latest subscriber data. FiberNet Advisory Board Minutes: 11/10/15 • Jeff O'Neill initiated a discussion about a policy giving credit for subscriber issues. Rachel Leonard outlined the current process and cautioned against a policy that is too rigid since each case is different. Consensus was to continue allowing staff to review and provide credit where appropriate. Brian Stumpf requested a monthly report of any credits given the previous month. 7. Financial Update • Wayne Oberg provided an update on financial reports ending 10/31/2015. 8. Management Update • Rachel Leonard reviewed the decision at the October 26, 2015 City Council workshop for staff to work with Joanne Johnson, executive director of the Minnesota Public Broadband Alliance to create a Request for Proposals (RFP) for management services. After initial meetings, Ms. Johnson recommended the city first go through the process of a Request for Qualifications (RFQ). The RFQ document is expected to go before City Council for approval at the November 23rd meeting. 9. Consideration of recommending a regulatory services vendor for 2016 • Rachel Leonard introduced the options for regulatory services vendor in 2016. CHARLOTTE GABLER MADE A MOTION TO USE INTERSTATE TELCOM COMPANY, INC. FOR REGULATORY SERVICES IN 2016. JACOB KRAMER SECONDED THE MOTION. MOTION PASSED 4-0. 10. Consideration of amending television prices for 2016 • Rachel Leonard stated in 2015 FiberNet covered the cost of television programming through the price for the TV packages. Programming costs will increase at the beginning of 2016; if FiberNet would like to cover costs again, the rates will need to increase at the beginning of the year. BRIAN STUMPF MADE A MOTION TO INCREASE THE PRICE OF THE PACKAGES TO COVER 2016 PROGRAMMING COSTS. DENNIS SULLIVAN SECONDED THE MOTION. MOTION PASSED 4-0. 11. Consideration of amending long distance prices for 2016 • Rachel Leonard requested to update long distance pricing to align it with current costs when it is charged in 2016. Option to raise the per minute charge or offer packages with a certain number of minutes. JACOB KRAMER MADE A MOTION TO ADJUST PRICES TO COVER COSTS AT STAFF'S DISCRETION ON THE TYPE OF CHARGE. BRIAN STUMPF SECONDED THE MOTION. MOTION PASSED 4-0. 12. Added Items • Jeff O'Neill and Wayne Oberg presented a draft version of the 2016 budget. Discussion during preliminary review of the document. The decision to recommend the draft budget to City Council will be at the December 8, 2015 meeting. FiberNet Advisory Board Minutes: 11/10/15 • During the budget discussion Dennis Sullivan asked about the monthly cost for the Prairie Conference Center. Staff confirmed FiberNet pays monthly rent for the building where the business office is located. It's possible to downsize, but there is currently no alternative location for office staff. • Jeff O'Neill facilitated a brief discussion of positive public relations. 13. Next Meeting The next meeting of the FiberNet Monticello Advisory Board is scheduled for December 8t', 2015 in the Boom Island Room at the Monticello Community Center. Please note this is one week earlier than the usual schedule. 11. Adiournment DENNIS SULLIVAN MOVED TO ADJOURN THE MEETING. BRIAN STUMPF SECONDED THE MOTION. MOTION CARRIED 4-0 AND MEETING ADJOURNED AT 8:25PM. Recorder: Rachel Leonard Approved: Attest: Jeff O'Neill, City Administrator MINUTES FIBERNET MONTICELLO ADVISORY BOARD MEETING Tuesday, March 1111, 2014 — 6 p.m. Boom Island Room, Monticello Community Center Present: Clint Herbst, Jon Morphew, and Dennis Sullivan Absent: Glen Posusta and Wayne Mayer Others: Jeff O'Neill, Brian Estrem, Rachel Leonard 1. Call to Order The meeting was called to order by Chair Clint Herbst at 6:00 p.m. 2. Additions to the Agenda Nothing formally added to the agenda. 3. Annroval of Minutes Tabled to next meeting. 4. Management Update • Since the previous meeting in January, former General Manager Mark Pultusker of FiberConnect resigned his position. The City utilized Brian Estrem as interim General Manager with technical assistance from Dan Olsen. • Jeff O'Neill provided a brief summary of City Council workshop prior to the regular meeting on March 10, 2014. Council heard presentations from Mark Pultusker of FiberConnect as well as the team of Brian Estrem and Dan Olsen. Due to time constraints, a formal decision about which to select for FiberNet management was not made. Estrem will continue to function in his capacity as interim General Manager with input from Olsen until a formal decision at the March 24, 2014 City Council meeting. • Jeff O'Neill provided a spreadsheet to the board showing a cost breakdown between management services by FiberConnect vs. management services from Brian Estrem and Dan Olsen. • Discussion regarding the use of Estrem and Olsen as consultants rather than city employees. Estrem stated he's happy to operate as a consultant until the city feels comfortable hiring him as a regular employee. Jon Morphew asked if the city should be looking more widely for a replacement manager. Clint Herbst responded the remainder of the year is a good trial period. The City can evaluate the need for additional candidates at the end of the initial term in December 2014. • Discussion of the billing system. At the City Council meeting on March 10, 2014 the councilmembers voted to authorize city staff to purchase a pared down version of the GLDS software used by FiberConnect. Jeff O'Neill highlighted the anticipated savings from reducing the features and anticipates finalizing that purchase this week. Dennis Sullivan commented he thinks the GLDS bill is easy to read and works well. • Discussion among the board and with Brian Estrem about the direction of FiberNet Monticello services and offerings. FiberNet Advisory Board Minutes — March 11, 2014 Page 1 5. Next Meeting The next meeting was originally scheduled for May 13, 2014. Advisory board agreed by consensus to begin meeting monthly again. Next meeting now scheduled for April 15, 2014. 6. Adiourn DENNIS SULLIVAN MOVED TO ADJOURN. JON MORPHEW SECONDED THE MOTION. MEETING ADJOURNED AT 7:10 PM. Recorder: Rachel Leonard Approved: Attest: Jeff O'Neill, City Administrator FiberNet Advisory Board Minutes — March 11, 2014 Page 2 Residential & Business Subscribers (Customer Counts) Service Jan Feb Mar Apr May Jun Phone Only 38 36 34 33 33 33 Internet Only 517 531 546 547 567 577 Television Only 89 85 82 81 75 75 Phone &Internet 171 167 163 167 173 174 Phone & Television 52 51 51 48 51 50 Internet & Television 351 345 343 339 331 325 Triple Play 321 317 312 309 298 298 Total Subscribers 1539 1532 1531 1524 1528 1532 Total Phone 582 571 560 557 555 555 Total Internet 1360 1360 1364 1362 1369 1374 Total Television 813 798 788 777 755 748 Total Services 2755 2729 2712 2696 2679 2677 Jul Aug Sep Oct Nov Dec YTD I CHG % 32 30 29 30 30 31 -7 -18.4% 591 607 612 621 636 646 129 25.0% 76 78 77 79 77 77 -12 -13.5% 170 171 176 169 167 169 -2 -1.2% 50 51 48 47 45 45 -7 -13.5% 321 319 322 326 322 323 -28 -8.0% 292 284 282 283 281 278 -43 -13.4% 1532 1540 1546 r 1555 1558 1569 30 1.9% 544 536 535 529 523 523 -59 -10.1% 1374 1381 1392 1399 1406 1416 56 4.1% 739 732 729 735 725 723 -90 -11.1% 2657 2649 2656 2663 2654 2662 -93 -3.4% Residential & Business Subscribers (Percentage of Customers) Service Jan Feb Mar Apr May Jun Jul Aug Sep Phone Only 2.5% 2.3% 2.2% 2.2% 2.2% 2.2% 2.1% 1.9% 1.9% Internet Only 33.6% 34.7% 35.7% 35.9% 37.1% 37.7% 38.6% 39.4% 39.6% Television Only 5.8% 5.5% 5.4% 5.3% 4.9% 4.9% 5.0% 5.1% 5.0% Phone & Internet 11.1% 10.9% 10.6% 11.0% 11.3% 11.4% 11.1% 11.1% 11.4% Phone & Television 3.4% 3.3% 3.3% 3.1% 3.3% 3.3% 3.3% 3.3% 3.1% Internet & Television 22.8% 22.5% 22.4% 22.2% 21.7% 21.2% 21.0% 20.7% 20.8% Triple Play 20.9% 20.7% 20.4% 20.3% 19.5% 19.5% 19.1% 18.4% 18.2% Total Subscribers 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% Total Phone 21.1% 20.9% 20.6% 20.7% 20.7% 20.7% 20.5% 20.2% 20.1% Total Internet 49.4% 49.8% 50.3% 50.5% 51.1% 51.3% 51.7% 52.1% 52.4% Total Television 29.5% 29.2% 29.1% 28.8% 28.2% 27.9% 27.8% 27.6% 27.4% Total Services 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% Residential and Business Service Participation (Percentage of Customers) Oct Nov Dec 1.9% 1.9% 2.0% 39.9% 40.8% 41.2% 5.1% 4.9% 4.9% 10.9% 10.7% 10.8% 3.0% 2.9% 2.9% 21.0% 20.7% 20.6% 18.2% 18.0% 17.7% 100.0% 100.0% 100.0% 19.9% 19.7% 19.6% 52.5% 53.0% 53.2% 27.6% 27.3% 27.2% 100.0% 100.0% 100.0% Service I Jan I Feb I Marl Apr l May l Jun I Jul l Aug l Sep I Oct I Nov l Dec l YTD CHG % Phone 38% 37% 37% 37% 36% 36% 36% 35% 35% 34% 34% 33% -4% -12% TV 53% 52% 51% 51% 49% 49% 48% 48% 47% 47% 47% 46% -7% -13% Internet 88% 89% 89% 89% 90% 90% 90% 90% 90% 90% 90% 90% 2% 2% Residential Subscribers (Customer Counts) Service Jan I Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YTD CHG % Phone Only Internet Only 30 28 26 25 24 24 23 22 21 21 20 21 -9 122 -30.0% 24.9% 490 499 511 517 534 543 557 571 577 585 600 612 Television Only Phone & Internet 86 82 78 77 72 72 73 76 75 77 76 76 -10 4 -11.6% 4.3% 93 89 91 92 98 101 100 101 103 98 97 97 Phone & Television Internet & Television 51 50 50 47 50 49 49 50 47 46 44 44 -7 -29 -13.7% -8.4% 346 340 337 334 329 323 319 317 320 324 319 317 Triple Play 305 301 298 295 284 285 278 270 268 269 267 264 -41 -13.4% Total Subscribers 1401 1389 1391 1387 1391 1397 1399 1407 1411 1420 1423 1431 30 2.1% Total Phone Total Internet 479 468 465 459 456 459 450 443 439 434 1 428 426 -53 56 -11.1% 4.5% 1234 1229 1237 1238 1245 1252 1254 1259 1268 1276 1283 1290 Total Television Total Services 788 773 763 753 735 729 719 713 710 716 706 701 -87 I -84 -11.0% -3.4% 2501 2470 2465 2450 2436 2440 2423 2415 2417 2426 2417 2417 Residential (Percentage of Customers) Service Jan Feb Mar Apr May Phone Only 2.1% 2.0% 1.9% 1.8% 1.7% Internet Only 35.0% 35.9% 36.7% 37.3% 38.4% Television Only 6.1% 5.9% 5.6% 5.6% 5.2% Phone & Internet 6.6% 6.4% 6.5% 6.6% 7.0% Phone & Television 3.6% 3.6% 3.6% 3.4% 3.6% Internet & Television 24.7% 24.5% 24.2% 24.1% 23.7% Triple Play 21.8% 21.7% 21.4% 21.3% 20.4% Total Subscribers 100.0% 100.0% 100.0% 100.0% 100.0% Total Phone 19.2% 18.9% 18.9% 18.7% 18.7% Total Internet 49.3% 49.8% 50.2% 50.5% 51.1% Total Television 31.5% 31.3% 31.0% 30.7% 30.2% Total Services 100.0% 100.0% 100.0% 100.0% 100.0% Jun 1.7% 38.9% 5.2% 7.2% 3.5% 23.1% 20.4% 100.0% 18.8% 51.3% 29.9% 100.0% Jul Aug Sep 1.6% 1.6% 1.5% 39.8% 40.6% 40.9% 5.2% 5.4% 5.3% 7.1% 7.2% 7.3% 3.5% 3.6% 3.3% 22.8% 22.5% 22.7% 19.9% 19.2% 19.0% 100.0% 100.0% 100.0% Residential Service Participation (Percentage of Customers) Oct 18.6% 18.3% 1 18.2% 51.8% 52.1% 52.5% 29.7% 29.5% 29.4% 100.0% 100.0% 100.0% Residential Service Participation (Percentage of Customers) Oct Nov Dec 1.5% 1.4% 1.5% 41.2% 42.2% 42.8% 5.4% 5.3% 5.3% 6.9% 6.8% 6.8% 3.2% 3.1% 3.1% 22.8% 22.4% 22.2% 18.9% 18.8% 18.4% 100.0% 100.0% 100.0% Service I Jan 17.9% 17.7% 17.6% 52.6% 53.1% 53.4% 29.5% 29.2% 29.0% 100.0% 100.0% 100.0% Service I Jan I Feb I Marl Apr l May l Jun I Jul l Aug l Sep I Oct I Nov I Dec I YTD I CHG% l Phone 34% 34% 33% 33% 33% 33% 32% 31% 31% 31% 30% 30% -4% -13% TV 56% 56% 55% 54% 53% 52% 51% 51% 50% 50% 50% 49% -7% -13% Internet 88% 88% 89% 89% 90% 90% 90% 89% 90% 90% 90% 90% 2% 2% Business Subcribers (Customer Counts) Service Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YTD CHG % Phone Only 8 8 8 8 9 9 9 8 8 9 10 10 2 25.0% Internet Only 27 32 35 30 33 34 34 36 35 36 36 34 7 25.9% Television Only 3 3 4 4 3 3 3 2 2 2 1 1 -2 -66.7% Phone & Internet 78 78 72 75 75 73 70 70 73 71 70 72 -6 -7.7% Phone & Television 1 1 1 1 1 1 1 1 1 1 1 1 0 0.0% Internet & Television Triple Play 5 5 6 5 2 2 2 2 2 2 3 6 1 -2 20.0% -12.5% 16 16 14 14 14 13 14 14 14 14 14 14 Total Subscribers 138 143 140 137 137 135 133 133 135 135 135 138 0 0.0% Total Phone Total Internet 103 103 95 98 99 96 94 93 96 95 95 97 -6 0 -5.8% 0.0% 126 131 127 124 124 122 120 122 124 123 123 126 Total Television Total Services 25 25 25 1 24 20 1 19 20 19 19 19 19 22 -3 I -9 -12.0% -3.5% 254 259 247 1 246 243 1 237 234 234 239 237 237 245 Business Subscribers (Percentage of Customers) Service Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Phone Only 5.8% 5.6% 5.7% 5.8% 6.6% 6.7% 6.8% 6.0% 5.9% 6.7% 7.4% 7.2% Internet Only 19.6% 22.4% 25.0% 21.9% 24.1% 25.2% 25.6% 27.1% 25.9% 26.7% 26.7% 24.6% Television Only 2.2% 2.1% 2.9% 2.9% 2.2% 2.2% 2.3% 1.5% 1.5% 1.5% 0.7% 0.7% Phone & Internet 56.5% 54.5% 51.4% 54.7% 54.7% 54.1% 52.6% 52.6% 54.1% 52.6% 51.9% 52.2% Phone & Television 0.7% 0.7% 0.7% 0.7% 0.7% 0.7% 0.8% 0.8% 0.7% 0.7% 0.7% 0.7% Internet & Television 3.6% 3.5% 4.3% 3.6% 1.5% 1.5% 1.5% 1.5% 1.5% 1.5% 2.2% 4.3% Triple Play 11.6% 11.2% 10.0% 10.2% 10.2% 9.6% 10.5% 10.5% 10.4% 10.4% 10.4% 10.1% Total Subscribers 100.0% 100.0°/% 100.0% 100.0% 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% 40.2% 40.1% 40.1% 39.6% Total Internet 49.6% 50.6% 51.4% 50.4% 51.0% 51.5% 51.3% 52.1% 51.9% 51.9% 51.9% 51.4% Total Television 9.8% 9.7% 10.1% 9.8% 8.2% 8.0% 8.5% 8.1% 7.9% 8.0% 8.0% 9.0% Total Services 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% Business Service Participation (Percentage of Customers) Service I Jan I Feb I Marl Apr l May l Jun I Jul l Aug l Sep I Oct I Nov l Dec l YTD I CHG % l Phone 75% 72% 68% 72% 72% 71% 71% 70% 71% 70% 70% 70% -4% -6% TV 18% 17% 18% 18% 15% 14% 15% 14% 14% 14% 14% 16% -2% -12% Internet 91% 92% 91% 91% 91% 90% 90% 92% 92% 91% 91% 91% 0% 0% Fiber Net Schedule of Revenue and Expenses (Modified Accrual Basis) 11/30/2015 Original Amended Account Number Description Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YTD Ytd% Budet g Bud et g REVENUE 656-00000-341180 PEG Access Fee $ (10,000) $ (10,000) (659) (644) (639) (635) (619) (632) (628) (618) (620) (627) (612) (6,932) 69.3% 656-00000-341190 USF Fee (10,000) (10,000) (675) (679) (674) (697) (703) (704) (672) (673) (674) (655) (631) (7,437) 74.4% 656-00000-362920 Services - Misc (1,515) (1,514) (1,503) (1,489) (1,339) (1,340) (1,330) (1,307) (1,315) (1,315) (1,315) (15,281) --- 656-00000-362990 Other Miscellaneous Revenue (233) (4) (208) (8) (2) (2) (171) (36) (167) (646) (8) (1,485) --- 656-00000-380510 Television Services (565,284) (565,284) (45,118) (50,974) (50,021) (49,778) (48,932) (49,280) (48,493) (47,985) (48,215) (48,394) (47,209) (534,400) 94.5% 656-00000-380520 Internet Services (554,256) (554,256) (47,631) (47,524) (48,462) (48,396) (49,433) (49,854) (49,924) (50,256) (50,918) (55,336) (55,454) (553,187) 99.8% 656-00000-380522 Equipment Rental/Purchase (127,044) (127,044) (10,681) (11,363) (10,987) (10,878) (14,361) (11,237) (13,327) (11,595) (10,708) (12,615) (11,336) (129,089) 101.6% 656-00000-380530 Phone Services (315,000) (315,000) (17,886) (25,088) (25,151) (25,458) (24,352) (25,206) (24,424) (24,678) (22,301) (24,694) (24,685) (263,924) 83.8% 656-00000-380540 CABS Revenue (57,600) (12,000) (3,266) (3,149) (3,348) 11,792 (13,142) 3,073 - (1,506) (9,547) 79.6% 656-00000-380542 Late Fees (1,480) (1,535) (1,215) (1,350) (1,230) (1,510) (1,215) (1,335) (1,355) (1,290) (1,555) (15,070) --- 656-00000-380545 Discounts Offered -Taxable 2,224 2,170 2,129 2,128 2,292 2,218 2,205 2,196 2,184 2,237 2,165 24,149 --- 656-00000-380546 Discounts Offered -Non Taxable 3,855 3,782 3,786 3,606 3,676 3,716 3,570 3,496 3,509 3,472 3,383 39,850 --- 656-00000-380557 Miscellaneous Charges (12,400) (12,400) (620) (470) (986) (1,574) (2,161) (2,088) (2,498) (2,349) (2,293) (2,208) (1,879) (19,126) 154.2% 656-00000-380558 Misc Charges -Non Taxable 45 (337) (54) (602) (125) (508) (13) (174) (110) (79) 5 (1,952) --- OPERATING REVENUE Totals: (1,651,584) (1,605,984) (123,639) (137,329) (137,334) (123,340) (150,431) (133,354) (136,920) (135,315) (134,488) (142,152) (139,129) (1,493,430) 93.0% EXPENSE Dept 49870 General & Administration 656-49870-410100 Salaries Full -Time Reg 89,749 89,749 (879) 10,244 9,402 9,773 9,781 9,987 14,283 9,672 9,799 9,755 10,203 102,020 113.7% 656-49870-410200 Salaries Full -Time OT 4,500 4,500 14 48 27 14 17 4 14 14 11 57 71 291 6.5% 656-49870-410300 Salaries Part -Time Reg 30,101 30,101 3,164 3,955 2,136 1,350 1,258 1,453 2,171 1,433 859 1,150 892 19,821 65.8% 656-49870-410310 Salaries Part -Time. OT 500 500 - - - - - - - - - - - - 0.0% 656-49870-410400 Salaries Temporary -Reg 5,000 5,000 - 61 364 - - - - - - - - 425 8.5% 656-49870-412100 Pera Contributions 9,364 9,364 911 1,069 867 835 829 858 1,235 834 800 822 837 9,897 105.7% 656-49870-412200 Fica Contributions 8,051 8,051 736 860 713 664 659 683 987 663 635 653 666 7,918 98.4% 656-49870-412300 Medicare Contributions 1,883 1,883 172 201 167 155 154 160 231 155 148 153 156 1,852 98.3% 656-49870-413100 Health Insurance Contributions 47,508 47,508 - 3,695 3,657 3,657 3,657 3,653 3,697 3,664 3,657 3,644 3,664 36,642 77.1% 656-49870-413300 Life Insurance Contributions - - 23 22 22 22 22 22 22 22 22 22 223 --- 656-49870-413400 Disability Ins Contributions 38 35 35 35 35 36 35 35 35 35 355 --- 656-49870-414200 UC Benefit Payments - - - - - - - - - - - 656-49870-420300 Printed Forms And Paper - 337 - - - 337 --- 656-49870-420990 Office Supplies - - 179 - 195 360 50 - - - - - 784 --- 656-49870-421990 Gen Operating Supplies 14,500 14,500 103 3,228 1,937 4,756 2,717 1,031 440 2,143 (766) 393 226 16,207 111.8% 656-49870-430100 Professional Services -Audit 5,350 5,350 - - - - - - - - - - - 0.0% 656-49870-430400 Legal Fees - - 900 11,115 525 555 75 150 986 3,593 1,748 19,646 --- 656-49870-430700 Management Services (GM) 100,000 75,000 - 6,235 1,885 715 1,690 2,015 - - - - 12,540 16.7% 656-49870-431800 Professional Services -Billings - 25,000 - - - - 10,173 2,045 2,016 2,030 2,173 1,580 4,530 24,547 98.2% 656-49870-431970 Regulatory Professional Svcs 20,000 20,000 - 658 658 - - 1,975 1,979 - - 2,125 364 7,760 38.8% 656-49870-431990 Miscellaneous Prof Services 24,000 24,000 2,617 1,955 3,565 7,271 (50) 2,558 6,612 4,062 5,813 6,052 (12,128) 28,327 118.0% 656-49870-432100 Telephone/Internet 2,640 2,640 150 - 156 306 313 8 909 8 8 - 17 1,875 71.0% 656-49870-432150 Internal IT Services 24,291 24,291 2,024 2,024 2,024 2,024 2,024 2,024 2,024 2,024 2,024 2,024 2,024 22,267 91.7% 656-49870-432200 Mail & Delivery Services - - 543 507 807 623 1,135 555 933 578 696 624 564 7,565 --- 656-49870-432500 Cable/Network Services - 128 - 2,024 128 - 1,901 - - 1,867 - 6,048 --- 656-49870-433200 Training/Conferences - - - 12 - - - - - 383 395 --- 656-49870-434600 Marketing 1,500 1,500 - - 220 39 5 289 289 - 842 56.1% 656-49870-436100 LPV Insurance 9,514 9,514 6,730 - - - - - 3,819 10,549 110.9% 656-49870-440100 Repair and Maint-Buildings - - - 1,199 304 - - - - 1,357 - - - 2,859 --- 656-49870-441200 Building/Room Rental 16,980 16,980 1,415 1,415 1,415 1,415 1,415 1,415 1,415 1,415 1,415 1,415 1,415 15,565 91.7% 656-49870-443200 Write Offs 11,000 11,000 4,394 - (357) 3,493 1,459 790 760 703 4,016 1,467 529 17,254 156.9% 656-49870-443300 Dues Membership and Subscrip 1,500 1,500 400 - - 895 - - - - - - 1,295 86.3% 656-49870-443700 Licenses And Permits 1,500 1,500 - - 139 - 25 - 1,293 - 102 - - 1,559 103.9% 656-49870-443980 Bank Charges 15,000 15,000 852 922 1,246 1,301 951 953 950 981 1,028 988 941 11,113 74.1% 656-49870-443990 Miscellaneous Other Exp 6,000 6,000 208 6 5 5 12,580 338 112 6 6 18 10 13,296 221.6% 656-49870-472030 Operating Transfer Out - - - - - - - - - - - - - - --- 656-49870 EXPENSETotaIS: 450,431 450,431 23,554 33,664 46,640 42,549 51,846 32,362 46,192 33,074 40,181 36,973 15,039 402,074 89.3% Original Amended Account Number Description Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YTD Ytd% Budet g Bud et g Dept 49870 Field Operations 656-49877-410100 Salaries Full -Time Reg 165,118 185,118 13,994 17,678 17,058 17,201 17,172 17,187 25,513 17,172 17,187 17,684 17,430 195,277 105.5% 656-49877-410200 Salaries Full -Time OT 10,000 10,000 1,167 1,211 1,224 755 661 1,121 1,281 949 828 677 1,196 11,070 110.7% 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 1,137 1,417 1,371 1,347 1,338 1,373 2,009 1,359 1,351 1,377 1,397 15,476 111.5% 656-49877-412200 Fica Contributions 12,097 12,097 926 1,134 1,097 1,077 1,069 1,099 1,625 1,087 1,081 1,102 1,118 12,415 102.6% 656-49877-412300 Medicare Contributions 2,829 2,829 217 265 257 252 250 256 380 254 253 258 262 2,903 102.6% 656-49877-413100 Health Insurance Contributions 45,882 45,882 - 5,205 5,440 5,440 5,440 5,440 5,440 5,440 5,440 5,440 5,440 54,165 118.1% 656-49877-413300 Life Insurance Contributions - - 33 33 33 33 33 33 33 33 33 33 325 --- 656-49877-413400 Disability Ins Contributions - - 57 57 57 57 57 57 57 57 57 57 573 --- 656-49877-414200 UC Benefit Payments 5,000 5,000 - - - - - - - - - - - 0.0% 656-49877-415100 Work Comp Ins Premiums 13,000 13,000 3,792 - 1,461 5,253 40.4% 656-49877-421110 Clothing Supplies 5,000 5,000 - - - - - - 1,640 18 - 1,658 33.2% 656-49877-421200 Motor Fuels 10,000 10,000 - 157 249 126 271 302 260 342 247 157 160 2,271 22.7% 656-49877-421800 Fiber/Video/Phone Supplies 145,000 145,000 8,717 762 4,775 328 315 21 14,015 1,834 9,625 1,309 5,677 47,379 32.7% 656-49877-421990 Gen Operating Supplies 35,000 35,000 - 501 21 4,735 5,841 3,126 452 4,008 5,240 1,400 (2,237) 23,088 66.0% 656-49877-422500 Landscaping Materials 5,000 5,000 - - - - - - 36 - - 36 0.7% 656-49877-422990 Misc Repair and Maint Supplies 2,160 2,160 121 2 - 123 5.7% 656-49877-424100 Small Tools ($500-$9999) 25,000 25,000 - - - - - - - 0.0% 656-49877-431900 Maintenance & Support Services 110,000 110,000 63,536 2,077 406 - 4,165 - 20,986 91,170 82.9% 656-49877-431990 Miscellaneous Prof Services 15,000 15,000 - 641 871 91 9,028 455 (6,587) 658 771 658 658 7,245 48.3% 656-49877-432770 Gopher State Locates 5,000 5,000 50 31 20 71 240 - 172 323 131 153 119 1,310 26.2% 656-49877-433100 Travel Expense 2,000 2,000 - - - - - - - - - - - 0.0% 656-49877-433200 Training/Conferences 5,000 5,000 - - - - - - - - - - 0.0% 656-49877-438100 Electric 27,500 27,500 4,397 4,424 1,946 1,489 1,795 1,900 1,694 1,775 1,948 21,369 77.7% 656-49877-438200 Water/Sewer 2,000 2,000 - - 82 - - 451 - - 82 616 30.8% 656-49877-438400 Refuse/Recycling Services 500 500 137 137 137 137 137 274 137 - 1,097 219.4% 656-49877-440100 Repair and Maint-Buildings/Systems 10,000 10,000 - - - - 6,630 3,900 - 195 7,358 18,083 180.8% 656-49877-440440 Repair & Maint-Mach & Equip 5,000 5,000 - 943 65 - - 1,008 20.2% 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 - 28,800 28,800 460.4% 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 89,743 29,093 40,798 38,272 43,882 32,502 53,787 41,021 49,807 62,693 61,685 543,283 65.6% Dept 49879 Cost of Goods Sold 656-49879-430910 Voice -Technical Services 76,000 76,000 2,694 6,240 3,641 10,158 5,329 5,298 5,921 5,103 6,083 5,1361 24,6821 80,284 105.6% 656-49879-430920 Video -Technical Services 576,000 576,000 - 53,928 46,837 59,811 61,847 51,654 50,790 49,435 50,094 49,566 49,516 523,476 90.9% 656-49879-430930 Data -Technical Services 170,000 170,000 9,849 18,649 14,249 14,249 14,249 16,949 14,249 11,549 34,366 17,220 17,420 182,996 107.6% 656-49879-443720 Video -Licenses and Permits - - - 67 - - - - - 67 - - - 134 --- 656-49879 EXPENSE Totals: 822,000 822,000 12,542 78,883 64,727 84,218 81,425 73,901 70,959 66,153 90,542 71,922 91,618 786,890 95.7% OPERATING EXPENSE Totals: 2,100,656 2,100,656 125,840 141,640 152,165 165,039 177,153 138,765 170,938 140,248 180,530 171,588 168,342 1,732,247 82.5% OPERATING (LOSS) (449,072) (494,672) (2,201) (4,311) (14,832) (41,699) (26,722) (5,411) (34,018) (4,933) (46,041) (29,437) (29,213) - (238,818) 48.3% OPERATING - average monthly (loss) (37,423) (41,223) (21,711) 52.7% Months Year % 11 12 91.7% Note: Some December 2015 (CoGS) content, which is paid in January 2016, will need to be accrued at year-end. Amended SUMMARY Description Orig. Budget Budget Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YTD Ytd% OPERATING (LOSS) (449,072) (494,672) (2,201) (4,311) (14,832) (41,699) (26,722) (5,411) (34,018) (4,933) (46,041) (29,437) (29,213) (238,818) 48.3% NONOPERATING (REV)/EXP: USAC receivable w/o - - 24,170 24,170 656-00000-362400 Sale of City Property (500) (800) (2,400) (15,700) (15,500) - (34,900) --- 656-00000-392000 Operating Transfer In (450,000) (450,000) (37,500) (37,500) (37,500) (37,500) (37,500) (37,500) (37,500) (37,500) (37,500) (37,500) (37,500) (412,500) 91.7% NET 928 (44,672) 35,799 33,189 23,468 (1,799) 26,478 47,589 3,482 32,567 (32,712) 8,063 8,287 184,412 Evaluation Criteria Points Experience with partnership structure/CLECs 25 Understanding Scope of Work/Muni rules 15 Professional and Tech Competence/Staffing 15 Network Operation Center Capability 20 Locally Based Operations/MN Company 15 Complicance with RFQ Requirements 5 Absence of Conflicts of Interest 5 Totals 100 Arvig CTC FC MABB Fiber Net 2016 Budget - Draft 11/10/2015 Dept 49870 General & Administration 2015 2015 2016 Draft Account Number Description Salaries Full -Time Reg 89,749 111,415 162,000 656-49870-410200 Amended Estimate Budget REVENUE 656-49870-410300 Salaries Part -Time Reg 30,101 656-00000-341180 18,000 656-49870-410310 PEG Access Fee $ (10,000) (7,559) (7,435) 656-00000-341190 - 656-49870-410400 USF Fee (10,000) (8,153) (8,083) 656-00000-362920 - 656-49870-412100 Services - Misc (16,596) (15,776) 656-00000-362990 13,560 656-49870-412200 Other Miscellaneous Revenue (1,811) (2,001) 656-00000-380510 11,160 656-49870-412300 Television Services (565,284) (583,621) (578,581) 656-00000-380520 2,640 656-49870-413100 Internet Services (554,256) (607,569) (659,011) 656-00000-380522 50,640 656-49870-413300 Equipment Rental/Purchase (127,044) (139,170) (128,502) 656-00000-380530 300 656-49870-413400 Phone Services (315,000) (283,842) (267,617) 656-00000-380540 600 656-49870-414200 CABS Revenue (12,000) (12,559) (6,000) 656-00000-380542 - 656-49870-421990 Late Fees (16,225) (16,260) 656-00000-380545 17,088 656-49870-430100 Discounts Offered -Taxable 26,353 26,213 656-00000-380546 - 656-49870-430400 Discounts Offered -Non Taxable 43,485 42,107 656-00000-380557 9,600 656-49870-430700 Miscellaneous Charges (12,400) (21,834) (27,520) 656-00000-380558 - 656-49870-431800 Misc Charges -Non Taxable - (2,177) (1,320) 26,831 26,400 656-49870-431970 OPERATING REVENUE Totals: (1,605,984) (1,631,277) (1,649,785) EXPENSE 9,600 656-49870-431970 CSR - Support Services - Dept 49870 General & Administration 656-49870-410100 Salaries Full -Time Reg 89,749 111,415 162,000 656-49870-410200 Salaries Full -Time OT 4,500 241 600 656-49870-410300 Salaries Part -Time Reg 30,101 20,646 18,000 656-49870-410310 Salaries Part -Time. OT 500 - - 656-49870-410400 Salaries Temporary -Reg 5,000 425 - 656-49870-412100 Pera Contributions 9,364 10,660 13,560 656-49870-412200 Fica Contributions 8,051 8,522 11,160 656-49870-412300 Medicare Contributions 1,883 1,993 2,640 656-49870-413100 Health Insurance Contributions 47,508 40,293 50,640 656-49870-413300 Life Insurance Contributions - 245 300 656-49870-413400 Disability Ins Contributions 390 600 656-49870-414200 UC Benefit Payments - - - 656-49870-421990 Gen Operating Supplies 14,500 337 17,088 656-49870-430100 Professional Services -Audit 5,350 784 - 656-49870-430400 Legal Fees - 18,981 9,600 656-49870-430700 Management Services (GM) 75,000 - - 656-49870-431800 Professional Services -Billings 25,000 26,831 26,400 656-49870-431970 Regulatory Professional Svcs 20,000 12,540 9,600 656-49870-431970 CSR - Support Services - 24,363 12,000 656-49870-431990 Miscellaneous Prof Services 24,000 7,396 12,000 656-49870-432100 Telephone/Internet 2,640 52,080 1,800 656-49870-432150 Internal IT Services 24,291 1,875 26,928 656-49870-432200 Mail & Delivery Services - 24,291 8,400 656-49870-432500 Cable/Network Services 8,393 8,600 656-49870-433200 Training/Conferences - 6,048 1,200 656-49870-434600 Marketing 1,500 395 1,800 656-49870-436100 LPV Insurance 9,514 1,420 9,180 656-49870-440100 Repair and Maint-Buildings - 10,549 2,400 656-49870-441200 Building/Room Rental 16,980 2,859 16,980 656-49870-443200 Write Offs 11,000 16,980 21,600 656-49870-443300 Dues Membership and Subscrip 1,500 20,725 1,300 656-49870-443700 Licenses And Permits 1,500 1,295 1,625 656-49870-443980 Bank Charges 15,000 1,762 12,000 656-49870-443990 Miscellaneous Other Exp 6,000 12,228 6,000 656-49870-472030 Operating Transfer Out - 13,298 - 656-49870 EXPENSE TotaIS: 450,431 460,259 466,001 Account Number Description 2015 Amended 2015 Estimate 2016 Draft Budget Dept 49877 Field Operations 76,000 67,768 68,280 656-49877-410100 Salaries Full -Time Reg 190,118 220,221 249,000 656-49877-410200 Salaries Full -Time OT 10,000 11,530 12,000 656-49877-410300 Salaries Part -Time Reg - - - 656-49877-410310 Salaries Part -Time OT 822,000 893,924 - 656-49877-410400 Salaries Temporary -Reg - - 6,000 656-49877-412100 Pera Contributions 13,884 16,781 20,040 65649877-412200 Fica Contributions 12,097 13,457 2,400 65649877-412300 Medicare Contributions 2,829 3,146 360 656-49877-413100 Health Insurance Contributions 45,882 59,605 75,000 656-49877-413300 Life Insurance Contributions - 358 600 656-49877-413400 Disability Ins Contributions 630 1,200 656-49877-414200 UC Benefit Payments - - - 656-49877-415100 Work Comp Ins Premiums 13,000 8,253 6,600 656-49877-421110 Clothing Supplies 5,000 1,658 1,800 656-49877-421200 Motor Fuels 10,000 2,605 3,600 656-49877-421800 Fiber/Video/Phone Supplies 145,000 53,302 72,000 656-49877-421990 Gen Operating Supplies 35,000 33,325 30,000 656-49877-422500 Landscaping Materials 5,000 36 - 656-49877-422990 Misc Repair and Maint Supplies 2,160 123 - 656-49877-424100 Small Tools ($500-$9999) 25,000 - 12,000 656-49877-431900 Maintenance/Support Services 110,000 80,184 108,000 656-49877-431990 Miscellaneous Prof Services 15,000 8,129 12,000 656-49877-432770 Gopher State Locates 5,000 1,453 1,800 656-49877-433100 Travel Expense 2,000 - - 656-49877-433200 Training/Conferences 5,000 - - 656-49877-438100 Electric 27,500 22,808 24,000 656-49877-438200 Water/Sewer 2,000 533 900 656-49877-438400 Refuse/Recycling Services 500 1,347 1,200 656-49877-440100 Repair and Maint-Buildings/Systems 10,000 10,725 28,000 656-49877-440440 Repair & Maint-Mach & Equip 5,000 1,137 4,800 656-49877-440500 Repair and Maint-Vehicles 5,000 575 4,800 656-49877-443990 Miscellaneous Other Exp 6,255 28,800 6,000 656-49877-458010 Other Equipment 120,000 - - 656-49877-472030 Operating Transfer Out - - - 656-49877 EXPENSE Totals: 828,225 580,722 684,100 Dept 49879 Cost of Goods Sold 656-49879-430910 Voice -Technical Services 76,000 67,768 68,280 656-49879-430920 Video -Technical Services 576,000 624,148 618,000 656-49879-430930 Data -Technical Services 170,000 201,874 159,300 656-49879-443720 Video -Licenses and Permits - 134 - 656-49879 EXPENSE Totals: 822,000 893,924 845,580 OPERATING EXPENSE Totals: 2,100,656 1,934,904 1,995,681 OPERATING (LOSS) (494,672) (303,627) (345,895) OPERATING - average monthly (loss) (41,223) (25,302) (28,825)