The URL can be used to link to this page

FiberNet Advisory Board Agenda Packet 11-10-2015AGENDA FIBERNET MONTICELLO ADVISORY BOARD MEETING Tuesday, November 10, 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 October Meeting Minutes 4. Approval of Meeting Minutes from 2014 • August 2014 • October 2014 • November 2014 5. Network update • IP Phone Change • Calix Compass City Council Decision • IRET 6. Business Office Update • October Subscriber Counts • Credits on Account 7. Financial Update 8. Management Update 9. Consideration of recommending a regulatory services vendor for 2016 10. Consideration of amending television prices for 2016 11. Consideration of amending long distance prices for 2016 12. Next Meeting — Tuesday, December 8, 2015 (Please note, this is the week before the normally scheduled meeting. The date change was approved at the September meeting.) 13. Adjourn MINUTES REGULAR MEETING — FIBERNET MONTICELLO ADVISORY BOARD Tuesday, October 13t'', 2015 Boom Island Room, Monticello Community Center Present: Brian Stumpf, Charlotte Gabler, Dennis Sullivan, Jon Morphew, Jacob Kramer Absent: Others: Jeff O'Neill, Rachel Leonard, Bryan Rabe, Joe Buttweiler 1. Call to Order Brian Stumpf called the meeting to order at 6:30 PM. 2. Additions to Agenda • Vaultas Agreement • New Fiber Drops 3. Approval of Meeting Minutes DENNIS SULLIVAN MOVED TO APPROVE THE SEPTEMBER 15TH, 2015 REGULAR MEETING MINUTES. JON MORPHEW SECONDED THE MOTION. MOTION CARRIED 5-0. 4. Network Update • Bryan Rabe provided an update on the speed test server and FiberNet presence on Speedtest.net. Allows customers to speed test on the network rather than go out onto the internet. Also an advertising opportunity for FiberNet. • Bryan Rabe also reported on the number of Calix GigaCenters in the field. Wayne Oberg asked if there would be another purchase of equipment before the end of the year. Mr. Rabe answered it is dependent on number of new installs, but he expects another purchase before 2016. 5. Business Office Update • Rachel Leonard provided the latest subscriber data. • Rachel Leonard provided a billing update after the price change in October. The price change increase internet revenue without heavily increasing disconnect rates. • Rachel Leonard provided an update on upcoming invoices from the billing company Source One. In 2014 the advisory board approved funds up to $5,000 for additional work after the initial conversion. As the work was completed over the last year, Source One did not invoice FiberNet. In October and November 2015 those payments will be added to the monthly bill. 6. Financial Update Wayne Oberg provided an update on financial reports ending 9/30/2015. Discussion regarding the budget for 2016 and potential rate adjustments for 2016. 7. Management Update • Jeff O'Neill provided a copy of the City Council agenda report calling for a FiberNet FiberNet Advisory Board Minutes: 10/13/15 workshop from the meeting on Monday, October 12tH • Jeff O'Neill reviewed potential management options with the board in anticipation of the workshop with City Council scheduled for October 26tH • The board continued to discuss the future of video service. 8. Television Undate • Rachel Leonard updated the board on upcoming television contract renewals and potential to consolidate some contracts for the next cycle. 9. Added Items • Jeff O'Neill outlined the termination of the Vaultas circuit. It was not terminated before an automatic renewal was initiated. By terminating after that date, the fee for the final year was required to be paid up front. • Rachel Leonard discussed the possibility of allocating funds to bring fiber into a commercial area where FiberNet currently does not provide service. Costs would be recovered over time, but there would be an initial capital investment. BRIAN STUMPF MOVED TO APPROVE FIBER DROPS TO THE COMMERCIAL AREA. JACOB KRAMER SECONDED THE MOTION. MOTION CARRIED 5-0. 10. Next Meeting The next meeting of the FiberNet Monticello Advisory Board is scheduled for November 10th, 2015 in the Boom Island Room at the Monticello Community Center. 11. Adiournment BRIAN STUMPF ADJOURNED THE MEETING AT 8:59 PM. Recorder: Rachel Leonard Approved: Attest: _ Jeff O'Neill, City Administrator MINUTES FIBERNET MONTICELLO ADVISORY BOARD MEETING Tuesday, August 1311, 2014 — 6 p.m. Boom Island Room, Monticello Community Center Present: Clint Herbst, Glen Posusta, and Jon Morphew Absent: Dennis Sullivan and Wayne Mayer Others: Jeff O'Neill, Rachel Leonard, Illeana Miller 1. Call to Order The meeting was called to order by Chair Clint Herbst at 6:00 p.m. 2. Additions to the Aeenda • Board member Wayne Mayer 3. Approval of Minutes JON MORPHEW MADE A MOTION TO APPROVE THE MEETING MINUTES FROM JUNE 10TH, 2014 AS PRESENTED. SECONDED BY GLEN POSUSTA. MOTION CARRIED 3-0. 4. Management Update Jeff O'Neill reported that an interim management arrangement is in place following Brian Estrem's resignation in July. Rachel Leonard is taking on more responsibility in the office and Bryan Rabe is taking on more responsibility at the headend. Both are reporting directly to Mr. O'Neill. Clint Herbst requested staff to look into the process for answering phones during an outage. Glen Posusta requested that businesses in particular should be able to call and get a live person rather than a recording. 5. Network Update • Jeff O'Neill provided a handout from headend technician regarding recent work on the network. Includes work on improving peering relationships so websites load faster for users. • Jeff O'Neill updated the board on the migration to a fiber feed for the video signals. • Jeff O'Neill provided an update on the 10 gig ring and the potential to increase speeds for existing customers with the bandwidth available. • Jeff O'Neill outlined information on additional option for television without set-top boxes. Glen Posusta requested that television be a lower priority than the changes to the internet. 6. Operations Update • Illeana Miller reported on recent new business accounts. • Rachel Leonard reported on greater participation in Monticello Chamber of Commerce events. FiberNet is hosting Good Morning Monticello in August and participating in 2014 Fall Harvest Expo. • Preliminary 2015 budget created by Finance Director Wayne Oberg and Brian Estrem (before his exit in July). Liquor store contribution expected again in 2015. FiberNet Advisory Board Minutes — August 13, 2014 Page 1 7. Miscellaneous • Jeff O'Neill provided an update on the Minnesota Public Broadband Alliance. The City of Monticello is acting as fiscal agent for the organization; they are currently looking to fill the position of executive director. • Jeff O'Neill informed the board that a response to Annandale's RFP was recently submitted. Interview dates to come. • Discussion of potential internet pricing changes in fall 2014. 8. Added Items • Jeff O'Neill reported on recent visit from economic development site selector. • Recommendation to remove Wayne Mayor from the board and advertise the opening. 9. Next Meeting The next meeting is scheduled for September 91", 2014 at 6 p.m. in the Boom Island Room, MCC. 10. Adiourn GLEN POSUSTA MADE A MOTION TO ADJOURN THE MEETING AT 6:56 P.M. SECONDED BY JON MORPHEW. MOTION CARRIED 3-0. Recorder: Rachel Leonard Approved: Attest: Jeff O'Neill, City Administrator FiberNet Advisory Board Minutes — August 13, 2014 Page 2 MINUTES FIBERNET MONTICELLO ADVISORY BOARD MEETING Tuesday, October 14th, 2014 — 6 p.m. Boom Island Room, Monticello Community Center Present: Clint Herbst, Jon Morphew, Glen Posusta, and Dennis Sullivan Absent: Others: Jeff O'Neill, Rachel Leonard, Lynne Dahl -Fleming 1. Call to Order The meeting was called to order by Chair Clint Herbst at 6:00 p.m. 2. Additions to the Agenda None 3. Auoroval of Minutes Previous meeting's minutes unavailable for approval. Tabled to November meeting. 4. Board Member Interview • Interview with candidate Jacob Kramer to fill the vacant board seat. JON MORPHEW MADE A MOTION TO RECOMMEND THAT THE CITY COUNCIL APPOINT JACOB KRAMER TO THE FIBERNET ADVISORY BOARD. DENNIS SULLIVAN SECONDED THE MOTION. MOTION CARRIED 4-0. 5. Network Update • Jeff O'Neill provided an update on testing in preparation for the upcoming C7 to E7 conversion. • Rachel Leonard provided an update on staffing levels. New technician hired, trained, and operating in the field. • Glen Posusta requested staff look at how drops are being buried and see if there is a more cost effective method. Mr. Posusta also recommended looking at contracts, particularly for people who need to have new drops. • Jeff O'Neill provided an update on the 10 gig ring construction. Trying to get it completed before freeze-up. Possible problem with limited availability of fiber. Glen Posusta asked about construction needed for the ring. Rachel Leonard reported that it is a physical connection between Monticello and Windom and possibly others. When complete it will increase bandwidth available and provide redundancy. • Jeff O'Neill reported on quote provided to Enventis for service from the tower to the headend. However, at this time, Verizon does not appear to be going with Enventis. 6. 2015 Budget Discussion • Jeff O'Neill provided a hand-out with budget information included. Same document was provided to City Council at the last meeting. • Draft budget created with input former General Manager Brian Estrem and Finance Director Wayne Oberg. FiberNet Advisory Board Minutes — October 14, 2014 Page 1 • Jeff O'Neill reviewed the budget items with explanations of how numbers were estimated for 2015. Recommendation from Mayor Herbst to budget with expectations for high costs. • Brief discussion of video service. More channels coming over the fiber feed rather than off of the satellite. Dennis Sullivan remarked he was unsatisfied with the previous video set-up at the headend. Mayor Herbst suggested next meeting should be at the headend to see the changes made since May 2014. 7. 2015 Strateeic Planning Discussion • Jeff O'Neill updated on strategic planning for 2015. Goal is to have a more in-depth look at the services and service mix. Includes possible changes to video. 8. Annandale RFP Update • Jeff O'Neill reported that Monticello was not selected to partner with Annandale for their potential network. Looking at additional ways to work with them in the future. 9. Added Items • Dennis Sullivan asked Rachel Leonard about the email server. Leonard reported staff is encouraging people to move off of FNMmail while also researching options for the future of the service. The email server is stable but continues to be problematic. • Jeff O'Neill reported on cause of an outage in previous weeks and the solution that was put in place. • Jeff O'Neill handed out a copies of 2 reports on municipal broadband and FiberNet Monticello. 10. Next Meeting The next meeting is scheduled for November 18th, 2014 at 6 p.m. in the Boom Island Room, MCC. (Moved one week due to a holiday.) 11. Adiourn GLEN POSUSTA MADE A MOTION TO ADJOURN AT 7:36 PM. SECONDED BY DENNIS SULLIVAN. MOTION CARRIED 4-0. Recorder: Rachel Leonard Approved: Attest: Jeff O'Neill, City Administrator FiberNet Advisory Board Minutes — October 14, 2014 Page 2 MINUTES REGULAR MEETING — FIBERNET MONTICELLO ADVISORY BOARD Tuesday, November 18th, 2014 Boom Island Room, Monticello Community Center Present: Clint Herbst, Dennis Sullivan, Jon Morphew, Jacob Kramer Absent: Others: Jeff O'Neill, Rachel Leonard, Bryan Rabe 1. Call to Order Clint Herbst called the meeting to order at 6:00pm 2. Additions to Agenda • Thank you to Mayor Herbst for his service by Dennis Sullivan 3. Approval of Meeting Minutes No meeting minutes to approve. Tabled to December meeting. 4. Network Update • Bryan Rabe provided an updated on Minnesota Internet Cooperative Exchange (MICE). FiberNet is now a participant; makes FiberNet's internet faster, particularly for Google and Netflix. Also reduced bandwidth costs. • Bryan Rabe updated the board on the upcoming C7 to E7 migration. Plan to test in the coming weeks before moving subscribers from one platform to the other. • Bryan Rabe reported a brief delay on the construction of the 10 gig ring due to equipment. After than waiting on work by other parties. 5. Business Office Update • Rachel Leonard updated the board on the upcoming retransmission renewals for local channels. New cycle is January 1, 2015- December 31, 2017. Also renewed several network channels through NTTC instead of directly and added new HD channels. • Rachel Leonard reported there is a new addendum to the current NBC Universal agreement for 2015 NASCAR races. Board members discussed how many subscribers are potentially fans in comparison to the added cost. Jon Morphew noted that NBC would be probably be willing to let FiberNet add the addendum later if the blackouts became a problem. JON MORPHEW MADE A MOTION TO TABLE ACTION ON THE NASCAR ADDENDUM TO THE NBC UNIVERSAL AGREEMENT. SECONDED BY JACOB KRAMER. MOTION CARRIED 4-0. • Bryan Rabe reported on the reduced number of channels coming off of the satellite dishes. Remaining channels could be affected by snow on the dishes during the winter. • Illeana Miller provided a report on business subscribers and new weekly meetings among staff. FiberNet Advisory Board Minutes: 10/13/15 • Staff reported on new process for change of service fees. • Rachel Leonard reported on that email service will be discontinued on January 5, 2015. Leonard also outlined a communication plan to inform customers about the change and help them migrate to a difference email provider as needed. • Rachel Leonard reported on updates to the handbook given to new subscribers. • Dennis Sullivan asked about channels with asterisks in the Expanded television package. Rachel Leonard explained that most channels in Expanded do not require a set-top box, but those with the asterisk do need a box. • Rachel Leonard initiated a discussion about whether FiberNet should engage in price matching with competitors or retain consistency of prices. Consensus was to keep pricing consistent and try to cover costs. • Rachel Leonard reported to the board on updated cold weather policy for winter installs. • Jeff O'Neill gave a brief update on interim management structure. O'Neill also updated the board on upcoming transfer from liquor store fund to FiberNet. 6. Consideration of conductiniz a FiberNet forum in January 2015 • Jeff O'Neill outlined that there is consensus to have a forum, but we need to determine the best time to hold it. Clint Herbst requested to discuss at the December meeting. 7. 2015 Strategic Planning Discussion • Tabled to December meeting. 8. Next Meeting The next meeting of the FiberNet Monticello Advisory Board is scheduled for December 9th, 2014. Clint Herbst requested to have it at the Headend. 9. Adjournment DENNIS SULLIVAN MADE A MOTION TO ADJOURN THE MEETING AT 7:27PM. MOTION SECONDED BY JON MORPHEW. MOTION CARRIED 4-0. Recorder: Rac el Leonard Approved: Attest: Jeff O'Neill, City Administrator Residential & Business Subscribers Service Jan Feb Phone Only 38 36 Internet Only 517 531 Television Only 89 85 Phone & Internet 171 167 Phone & Television 52 51 Internet & Television 351 345 Triple Play 321 317 Total Subscribers 1539 1532 Total Phone 582 571 Total Internet 1360 1360 Total Television 813 798 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 Mar Apr May Jun Jul Aug Sep Oct Nov 34 33 33 33 32 30 29 30 30 546 547 567 577 591 607 612 621 636 82 81 75 75 76 78 77 79 77 163 167 173 174 170 171 176 169 167 51 48 51 50 50 51 48 47 45 343 339 331 325 321 319 322 326 322 312 309 298 298 292 284 282 283 281 1531 1524 1528 1532 1532 1540 1546 1555 1558 560 557 555 555 544 536 535 529 523 1364 1362 1369 1374 1374 1381 1392 1399 1406 788 777 755 748 739 732 729 735 725 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov 8 8 8 8 9 9 9 8 8 9 10 27 32 35 30 33 34 34 36 35 36 36 3 3 4 4 3 3 3 2 2 2 1 78 78 72 75 75 73 70 70 73 71 70 1 1 1 1 1 1 1 1 1 1 1 5 5 6 5 2 2 2 2 2 2 3 16 16 14 14 14 13 14 14 14 14 14 138 143 140 137 137 135 133 133 135 135 135 103 103 95 98 99 96 94 93 96 95 95 126 131 127 124 124 122 120 122 124 123 123 25 25 25 24 20 19 20 19 19 19 19 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 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov 30 28 26 25 24 24 23 22 21 21 20 490 499 511 517 534 543 557 571 577 585 600 86 82 78 77 72 72 73 76 75 77 76 93 89 91 92 98 101 100 101 103 98 97 51 50 50 47 50 49 49 50 47 46 44 346 340 337 334 329 323 319 317 320 324 319 305 301 298 295 284 285 278 270 268 269 267 1401 1389 1391 1387 1391 1397 1399 1407 1411 1420 1423 479 468 465 459 456 459 450 443 439 434 428 1234 1229 1237 1238 1245 1252 1254 1259 1268 1276 1283 788 773 763 753 735 729 719 713 710 716 706 Fiber Net Schedule of Revenue and Expenses (Modified Accrual Basis) 10/31/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) (6,320) 63.2% 656-00000-341190 USF Fee (10,000) (10,000) (675) (679) (674) (697) (703) (704) (672) (673) (674) (655) (6,805) 68.1% 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) (13,966) --- 656-00000-362990 Other Miscellaneous Revenue (233) (4) (208) (8) (2) (2) (171) (36) (167) (646) (1,477) --- 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) (487,191) 86.2% 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) (497,734) 89.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) (117,753) 92.7% 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) (239,239) 75.9% 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) (13,515) --- 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 21,984 --- 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 36,467 --- 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) (17,247) 139.1% 656-00000-380558 Misc Charges -Non Taxable 45 (337) (54) (602) (125) (508) (13) (174) (110) (79) (1,957) --- 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) (1,354,301) 84.3% 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 91,817 102.3% 656-49870-410200 Salaries Full -Time OT 4,500 4,500 14 48 27 14 17 4 14 14 11 57 220 4.9% 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 18,929 62.9% 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 9,060 96.8% 656-49870-412200 Fica Contributions 8,051 8,051 736 860 713 664 659 683 987 663 635 653 7,253 90.1% 656-49870-412300 Medicare Contributions 1,883 1,883 172 201 167 155 154 160 231 155 148 153 1,696 90.1% 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 32,979 69.4% 656-49870-413300 Life Insurance Contributions - - 23 22 22 22 22 22 22 22 22 201 --- 656-49870-413400 Disability Ins Contributions 38 35 35 35 35 36 35 35 35 319 --- 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 15,981 110.2% 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 20,017 80.1% 656-49870-431970 Regulatory Professional Svcs 20,000 20,000 - 658 658 - - 1,975 1,979 - - 2,125 7,396 37.0% 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 40,454 168.6% 656-49870-432100 Telephone/Internet 2,640 2,640 150 - 156 306 313 8 909 8 8 - 1,858 70.4% 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 20,242 83.3% 656-49870-432200 Mail & Delivery Services - - 543 507 807 623 1,135 555 933 578 696 624 7,001 --- 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 14,150 83.3% 656-49870-443200 Write Offs 11,000 11,000 4,394 - (357) 3,493 1,459 790 760 703 4,016 1,467 16,725 152.0% 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 10,172 67.8% 656-49870-443990 Miscellaneous Other Exp 6,000 6,000 208 6 5 5 12,580 338 112 6 6 18 13,285 221.4% 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 387,035 85.9% Original Amended Account Number Description Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YTD Ytd% Budget Budget 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 177,847 96.1% 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 9,874 98.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 14,079 101.4% 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 11,296 93.4% 656-49877-412300 Medicare Contributions 2,829 2,829 217 265 257 252 250 256 380 254 253 258 2,641 93.4% 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 48,725 106.2% 656-49877-413300 Life Insurance Contributions - - 33 33 33 33 33 33 33 33 33 293 --- 656-49877-413400 Disability Ins Contributions - - 57 57 57 57 57 57 57 57 57 516 --- 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 2,111 21.1% 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 41,702 28.8% 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 25,325 72.4% 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 Agreements 110,000 110,000 63,536 2,077 406 - 4,165 - 70,184 63.8% 656-49877-431990 Miscellaneous Prof Services 15,000 15,000 - 641 871 91 9,028 455 (6,587) 658 771 658 6,587 43.9% 656-49877-432770 Gopher State Locates 5,000 5,000 50 31 20 71 240 - 172 323 131 153 1,191 23.8% 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 19,420 70.6% 656-49877-438200 Water/Sewer 2,000 2,000 - - 82 - - 451 - - 533 26.7% 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 10,725 107.3% 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 481,598 58.1% 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,136 55,602 73.2% 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 473,961 82.3% 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 165,576 97.4% 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 695,273 84.6% 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 1,563,906 74.4% 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) (209,605) 42.4% OPERATING - average monthly (loss) (37,423) (41,223) (20,960) 50.8% Months Year % 10 12 83.3% 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) (209,605) 42.4% 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) (375,000) 83.3% NET 928 (44,672) 35,799 33,189 23,468 (1,799) 26,478 47,589 3,482 32,567 (32,712) 8,063 176,125