Loading...
FiberNet Advisory Board Agenda Packet 02-09-2016AGENDA FIBERNET MONTICELLO ADVISORY BOARD MEETING Tuesday, February 9, 2016 — 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 December 2015 Meeting Minutes 4. Business Office Update • Recent Rate Changes • Rate Changes Over Time • Subscriber Data 5. Financial Update 6. Management Update 7. IRET Update 8. Next Meeting — Tuesday, March 15, 2016 9. Adjourn MINUTES REGULAR MEETING — FIBERNET MONTICELLO ADVISORY BOARD Tuesday, December 811, 2015 Boom Island Room, Monticello Community Center Present: Brian Stumpf, Charlotte Gabler, Dennis Sullivan, Jon Morphew Absent: Jacob Kramer Others: Jeff O'Neill, Rachel Leonard, Bryan Rabe, Wayne Oberg, JoAnne Johnson, Tim Hennagir 1. Call to Order Brian Stumpf called the meeting to order at 6:30 PM. 2. Additions to Agenda No additions to the agenda. 3. Approval of October Meeting Minutes CHARLOTTE GABLER MOVED TO APPROVE THE NOVEMBER 10TH, 2015 REGULAR MEETING MINUTES. DENNIS SULLIVAN SECONDED THE MOTION. MOTION CARRIED 4-0. 4. Approval of March 2014 Meeting Minutes Charlotte Gabler requested additional text be added to clarify the sequence of events between the resignation of Mark Pultusker in February 2014 and Mr. Pultusker's presentation at a City Council workshop on March 10, 2014. CHARLOTTE GABLER MOVED TO APPROVE THE MARCH 11TH, 2014 REGULAR MEETING MINUTES WITH THE ADDITION OF CLARIFYING TEXT. JON MORPHEW SECONDED THE MOTION. MOTION CARRIED 4-0. 5. Network Update • Bryan Rabe updated the board on the number of GigaCenters in the field. Wayne Oberg asked how Mr. Rabe determines when to purchase additional inventory of the equipment. Mr. Rabe responded it's based on the number of installs. When the stock gets to a certain point, he re -orders. Mayor Stumpf asked about the slowness of his internet with the GigaCenter. Mr. Rabe responded the equipment, applications, and software being used all have an impact on speeds, and technical support is available if necessary. 6. Business Office Update • Rachel Leonard provided the latest subscriber data. • Rachel Leonard informed the board that long distance information was included in the December bills at zero cost. The bills show how many minutes of long distance were used and a bill message states the costs will begin in February 2016. The same format will be used for January's bills. 7. Financial Update FiberNet Advisory Board Minutes: 12/08/15 • Wayne Oberg provided an update on financial reports ending 11/30/2015. 8. Management Update Jeff O'Neill summarized the Request for Qualifications (RFQ) process to date: The City Council approved the document at the November 23, 2015 regular meeting. After approval, the RFQ for management services was posted on the city's website and sent directly to several industry contacts. The due date was December 81h at noon; the city received 4 responses. The responses came from Arvig, Consolidated Telecommunications Company, FiberConnect, and MidAtlantic Broadband. As part of the assistance in the RFQ process from JoAnne Johnson of the Minnesota Public Broadband Alliance, Ms. Johnson selected criteria to use to score the various responses. Staff was able to provide input on the criteria, but the scoring itself was done by Ms. Johnson. She presented the final evaluation criteria as well as a summary of her scoring to the advisory board. The highest score possible was 100 points and, based on that, Ms. Johnson determined that anything over 70 points would pass. Two companies scored above 70 points and two companies scored below 70 points. Jon Morphew expressed his satisfaction that this process has been more analytical and methodical than past selection processes. Jeff O'Neill informed the board they could make a recommendation to City Council about the next step in the selection process. During the discussion the board expressed interest in interviewing the respondents with the top two scores. Dennis Sullivan requested the third place respondent be kept as an alternate to be interviewed if neither of the top two were selected. Jeff O'Neill asked if the board would like to be included in the interview process if it is approved. Mayor Stumpf stated he would like board members participate in the interviews. DENNIS SULLIVAN MADE A MOTION TO INTERVIEW THE TOP TWO SCORING RESPONDENTS AND TO RESERVE THE THIRD PLACE RESPONDENT AS AN ALTERNATE IF NEITHER OF THE TOP TWO ARE SELECTED. CHARLOTTE GABLER SECONDED THE MOTION. MOTION CARRIED 4-0. 9. Consideration of recommending FiberNet budget to Citv Council for approval JON MORPHEW MADE A MOTION TO RECOMMEND THE BUDGET TO CITY COUNCIL FOR APPROVAL. DENNIS SULLIVAN SECONDED THE MOTION. MOTION PASSED 4-0. 10. Consideration of amending equipment prices for 2016 • Rachel Leonard brought forth two options for lowering equipment prices in 2016. One based on a lower purchasing cost for FiberNet and the other to help off -set an upcoming increase in television prices. Mayor Stumpf expressed his reluctance to make any changes to the equipment prices before a manager is selected. By consensus the board opted to keep equipment prices the same in 2016. FiberNet Advisory Board Minutes: 12/08/15 11. Next Meeting The next meeting of the FiberNet Advisory Board is scheduled for January 12, 2016 at 6:30pm in the Boom Island Room at the Monticello Community Center. 12. Adiournment DENNIS SULLIVAN MOVED TO ADJOURN THE MEETING. JON MORPHEW SECONDED THE MOTION. MOTION CARRIED 4-0 AND MEETING ADJOURNED AT 7:55PM. Recorder: Rachel Leonard Approved: Attest: Jeff O'Neill, City Administrator Residential & Business Subscribers (Customer Counts) Service Dec15 Jan Feb Mar Apr May Phone Only 31 32 31 --- --- --- Internet Only 646 664 678 --- --- --- Television Only 77 74 72 --- --- --- Phone & Internet 169 164 163 --- --- --- Phone & Television 45 44 43 --- --- --- Internet & Television 323 318 309 --- --- --- Triple Play 278 278 277 --- --- --- Total Subscribers 1569 1574 1573 0 0 0 Total Phone 523 518 514 --- --- --- Total Internet 1416 1424 1427 --- --- --- Total Television 723 714 701 --- --- --- Total Services 2662 2656 2642 --- --- --- Jun Jul Aug Sep Oct Nov Dec YTD I CHG % --- --- --- --- -- --- 0 0.0% --- --- --- --- --- --- --- 32 5.0% --- --- --- --- --- --- --- -5 -6.5% --- --- --- --- --- --- --- -6 -3.6% --- --- --- --- --- --- --- -2 -4.4% --- --- --- --- --- --- --- -14 -4.3% --- --- --- --- --- --- --- -1 -0.4% 'MMMM 0 0 0 0 4 0.3% --- --- --- --- --- --- --- -9 -1.7% -- --- --- --- --- --- 11 0.8% --- --- --- --- --- --- --- -22 -3.0% --- --- --- --- --- --- --- -20 -0.8% Residential & Business Subscribers (Percentage of Customers) Service Dec15 Jan Feb Mar Apr May Jun Phone Only 2.0% 2.0% 2.0% --- --- --- --- Internet Only 41.2% 42.2% 43.1% --- --- --- --- Television Only 4.9% 4.7% 4.6% --- --- --- --- Phone & Internet 10.8% 10.4% 10.4% --- --- --- --- Phone & Television 2.9% 2.8% 2.7% --- --- --- --- Internet & Television 20.6% 20.2% 19.6% --- --- --- --- Triple Play 17.7% 17.7% 17.6% --- --- --- --- Total Subscribers 100.0% 100.0% 100.0% 0.0% 0.0% 0.0% 0.0% Total Phone 19.6% 19.5% 19.5% --- --- --- --- Total Internet 53.2% 53.6% 54.0% --- --- --- --- Total Television 27.2% 26.9% 26.5% --- --- --- --- Total Services 100.0% 100.0% 100.0% --- --- --- --- Jul --- --- --- Aug --- --- --- Sep --- --- --- Oct --- --- --- Nov --- --- --- Dec --- --- --- --- --- --- --- 0.0% --- --- --- --- --- --- --- --- 0.0% --- --- --- --- --- --- --- --- 0.0% --- --- --- --- --- --- --- --- 0.0% --- --- --- --- --- --- --- --- 0.0% --- --- --- --- --- --- --- --- 0.0% --- --- --- --- Residential and Business Service Participation (Percentage of Customers) Service I Dec15 I Jan I Feb I Mar I Apr I May I Jun I Jul I Aug I Sep I Oct I Nov I Dec I YTD I CHG % Phone 33% 33% 33% -1% -2% TV 46% 45% 45% -2% -3% Internet 90% 90% 91% 0% 1% Residential Subscribers (Customer Counts) Service Dec15 Jan 16 Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YTD I CHG% Phone Only 21 22 21 0 0.0% Internet Only 612 627 640 28 4.6% Television Only 76 73 71 -5 -6.6% Phone &Internet 97 94 93 -4 -4.1% Phone & Television 44 43 42 -2 -4.5% Internet & Television 317 315 306 -11 -3.5% Triple Play 264 263 263 -1 -0.4% Total Subscribers 1431 1437 1436 0 0 0 0 0 0 0 0 0 0 5 0.3% Total Phone 426 422 419 0 0 0 0 0 0 0 0 0 0 -7 -1.6% Total Internet 1290 1299 1302 0 0 0 0 0 0 0 0 0 0 12 0.9% Total Television 701 694 682 0 0 0 0 0 0 0 0 0 0 -19 -2.7% Total Services 2417 2415 2403 0 0 0 0 0 0 0 0 0 0 -14 -0.6% Residential (Percentage of Customers) Service Dec15 Jan 16 Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Phone Only 1.5% 1.5% 1.5% --- --- --- --- --- --- --- --- -- Internet Only 42.8% 43.6% 44.6% --- --- --- --- --- --- --- --- --- --- Television Only 5.3% 5.1% 4.9% --- --- --- --- --- --- --- --- -- Phone & Internet 6.8% 6.5% 6.5% --- --- --- --- --- --- --- --- --- --- Phone & Television 3.1% 3.0% 2.9% --- --- --- --- --- --- --- --- -- Internet & Television 22.2% 21.9% 21.3% --- --- --- --- --- --- --- --- --- --- Triple Play 18.4% 18.3% 18.3% --- --- --- --- --- --- --- --- -- Total Subscribers 100.0% 100.0% 100.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% Total Phone 17.6% 17.5% 17.4% --- --- --- --- --- --- --- --- --- TotalInternet 53.4% 53.8% 54.2% --- --- --- --- --- --- --- --- --- --- Total Television 29.0% 28.7% 28.4% --- --- --- --- --- --- --- --- -- Total Services 100.0% 100.0% 100.0% --- --- --- --- --- --- --- --- --- --- Residential Service Participation (Percentage of Customers) Service Dec15 I Jan I Feb I Mar I Apr I May I Jun I Jul I Aug I Sep I Oct I Nov I Dec I YTD I CHG% Phone 30% 29% 29% -1% -2% TV 49% 48% 47% -1% -3% Internet 90% 90% 91% 1% 1% Business Subcribers (Customer Counts) Service Dec15 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YTD CHG % Phone Only 10 10 10 0 0.0% Internet Only 34 37 38 I 4 11.8% Television Only 1 1 1 I 0 0.0% Phone & Internet 72 70 70 I -2 -2.8% Phone & Television 1 1 1 I 0 0.0% Internet & Television 6 3 3 I -3 -50.0% Triple Play 14 15 14 0 0.0% Total Subscribers 138 137 137 0 0 0 0 0 0 0 0 0 0 -1 -0.7% Total Phone 97 96 95 0 0 0 0 0 0 0 0 0 0 -2 -2.1% Total Internet 126 125 125 0 0 0 0 0 0 0 0 0 0 I -1 -0.8% Total Television 22 20 19 0 0 0 0 0 0 0 0 0 0 -3 -13.6% Total Services 245 241 239 0 0 0 0 0 0 0 0 0 0 -6 -2.4% Business Subscribers (Percentage of Customers) Service Dec15 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Phone Only 7.2% 7.3% 7.3% --- --- --- --- --- --- --- --- --- --- Internet Only 24.6% 27.0% 27.7% --- --- --- --- --- --- --- --- --- --- Television Only 0.7% 0.7% 0.7% --- --- --- --- --- --- --- --- --- --- Phone & Internet 52.2% 51.1% 51.1% --- --- --- --- --- --- --- --- --- --- Phone & Television 0.7% 0.7% 0.7% --- --- --- --- --- --- --- --- Internet & Television 4.3% 2.2% 2.2% --- --- --- --- --- --- --- --- --- --- Triple Play 10.1% 10.9% 10.2% --- --- --- --- --- --- --- --- --- --- Total Subscribers 100.0% 100.0°/% 100.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% Total Phone 39.6% 39.8% 39.7% --- --- --- --- --- --- --- --- --- --- Total Internet 51.4% 51.9% 52.3% --- --- --- --- --- --- --- --- --- --- Total Television 9.0% 8.3% 7.9% --- --- --- --- --- --- --- --- --- --- Total Services 100.0% 100.0% 100.0% --- --- --- --- --- --- --- --- --- --- Business Service Participation (Percentage of Customers) Service Dec15 I Jan I Feb I Mar I Apr I May I Jun I Jul I Aug I Sep I Oct I Nov I Dec I YTD I CHG % Phone 70% 70% 69% -1% -1% TV 16% 15% 14% -2% -13% Internet 91% 91% 91% 0% 0% Fiber Net 2015 Schedule of Revenue and Expenses (Modified Accrual Basis) 12/31/2015 Account Number Description Original Budet g Amended Bud et g Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YTD Ytd% REVENUE 656-00000-341180 PEG Access Fee $ (10,000) $ (10,000) (659) (644) (639) (635) (619) (632) (628) (618) (620) (627) (612) (603) (7,534) 75.3% 656-00000-341190 USF Fee (10,000) (10,000) (675) (679) (674) (697) (703) (704) (672) (673) (674) (655) (631) (627) (8,064) 80.6% 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) (1,323) (16,604) --- 656-00000-362990 Other Miscellaneous Revenue (233) (4) (208) (8) (2) (2) (171) (36) (167) (646) (8) (35) (1,520) --- 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) (46,471) (580,871) 102.8% 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) (55,809) (608,997) 109.9% 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) (11,591) (140,680) 110.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) (24,685) (24,664) (288,588) 91.6% 656-00000-380540 CABS Revenue (57,600) (12,000) (3,266) (3,149) (3,348) 11,792 (13,142) 3,073 - (1,506) - (1,726) (11,273) 93.9% 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) (1,185) (16,255) --- 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 2,133 26,282 --- 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 3,307 43,157 --- 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) (1,914) (21,039) 169.7% 656-00000-380558 Misc Charges -Non Taxable 45 (337) (54) (602) (125) (508) (13) (174) (110) (79) 5 97 (1,855) --- 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) (140,412) (1,633,842) 101.7% 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 15,976 117,997 131.5% 656-49870-410200 Salaries Full -Time OT 4,500 4,500 14 48 27 14 17 4 14 14 11 57 71 110 401 8.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 892 2,504 22,325 74.2% 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 1,394 11,292 120.6% 656-49870-412200 Fica Contributions 8,051 8,051 736 860 713 664 659 683 987 663 635 653 666 1,136 9,054 112.5% 656-49870-412300 Medicare Contributions 1,883 1,883 172 201 167 155 154 160 231 155 148 153 156 236 2,088 110.9% 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 4,960 41,602 87.6% 656-49870-413300 Life Insurance Contributions - - 23 22 22 22 22 22 22 22 22 22 31 254 --- 656-49870-413400 Disability Ins Contributions 38 35 35 35 35 36 35 35 35 35 47 402 --- 656-49870-414200 UC Benefit Payments - - - - - - - - - - - - 656-49870-420300 Printed Forms And Paper 656-49870-420990 Office Supplies - - - - - - - - - - - - - - --- 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 675 16,882 116.4% 656-49870-430100 Professional Services -Audit 5,350 5,350 - - - - - - - - - - - - 0.0% 656-49870-430400 Legal Fees - - 9001 11,1151 525 555 75 150 986 31593 1,748 5,590 25,236 --- Bond lawsuit 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 2,030 26,578 106.3% 656-49870-431970 Regulatory Professional Svcs 20,000 20,000 - 658 658 - - 1,975 1,979 - - 2,125 364 256 8,016 40.1% 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) 2,824 31,151 129.8% 656-49870-432100 Telephone/Internet 2,640 2,640 150 - 156 306 313 8 909 8 8 - 17 1,808 3,683 139.5% 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 2,024 24,291 100.0% 656-49870-432200 Mail & Delivery Services - - 543 507 807 623 1,135 555 933 578 696 624 564 1,338 8,903 --- 656-49870-432500 Cable/Network Services - 128 - 2,024 128 - 1,901 - - 1,867 - - 6,048 --- 656-49870-433200 Training/Conferences - - - 12 - - - - - - 225 237 --- 656-49870-434600 Marketing 1,500 1,500 - - 220 39 5 289 289 383 - 1,225 81.7% 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 1,415 16,980 100.0% 656-49870-443200 Write Offs 11,000 11,000 4,394 - (357) 3,493 1,459 790 760 703 4,016 1,467 529 1,862 19,117 173.8% 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 - - 183 1,741 116.1% 656-49870-443980 Bank Charges 15,000 15,000 852 922 1,246 1,301 951 953 950 981 1,028 988 941 1,040 12,153 81.0% 656-49870-443990 Miscellaneous Other Exp 6,000 6,000 208 6 5 5 7 338 112 6 6 18 10 16 739 12.3% 656-49870-472030 Operating Transfer Out - - - - - - - - - - - - - - - --- 656-49870 EXPENSE TotaIS: 450,431 450,431 23,554 33,148 46,640 42,354 38,913 32,312 46,192 33,074 40,181 36,974 15,039 47,682 436,063 96.8% 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 29,599 224,876 121.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 1,074 12,144 121.4% 656-49877-410300 Salaries Part -Time Reg 10,000 - - - - - - - - - - - - - --- OPERATING - average monthly (loss) Note: Some December 2015 (CoGS) content, which is paid in January 2016, will need to be accrued at year-end. (26,869) --- Months Year % 12 12 100.0% Original Amended SUMMARY Description Orig. Budget Account Number Description Feb Mar Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YTD Ytd% (3,795) (14,832) Budget Budget (5,361) (34,018) (4,933) (46,041) (29,437) (29,213) (107,309) (322,434) 65.2% NONOPERATING (REV)/EXP: 656-49877-410310 Salaries Part -Time OT CABs receivable w/o - - - 656-49877-410400 Salaries Other -Reg 10,000 - - - - 12,573 --- - - - - - - -1 4,1461 4,146 --- PTO payout 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 2,300 17,777 128.0% 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 1,906 14,320 118.4% 656-49877-412300 Medicare Contributions 2,829 2,829 217 265 257 252 250 256 380 254 253 258 262 386 3,289 116.2% 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 7,509 61,674 134.4% 656-49877-413300 Life Insurance Contributions - - 33 33 33 33 33 33 33 33 33 33 47 372 --- 656-49877-413400 Disability Ins Contributions - - 57 57 57 57 57 57 57 57 57 57 79 652 --- 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 296 2,567 25.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 8,827 56,206 38.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 (2,237) 3,609 26,697 76.3% 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 5,115 96,285 87.5% 656-49877-431990 Miscellaneous Prof Services 15,000 15,000 - 641 871 91 9,028 455 (6,587) 658 771 658 658 1,317 8,562 57.1% 656-49877-432770 Gopher State Locates 5,000 5,000 50 31 20 71 240 - 172 323 131 153 119 115 1,425 28.5% 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 1,596 22,965 83.5% 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 - 366 1,463 292.5% 656-49877-440100 Repair and Maint-Buildings/Systems 10,000 10,000 - - - - 6,630 3,900 - 195 7,358 6,528 24,611 246.1% 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 - - - 466 1,041 20.8% 656-49877-443990 Miscellaneous Other Exp 6,255 6,255 - -1 28,8001 - 28,800 460.4% Vaultus exit fee 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 75,279 618,563 74.7% 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 6,910 87,194 114.7% Hack $19k 656-49879-430920 Video -Technical Services 576,000 576,000 - 53,928 46,837 59,811 51,847 51,654 50,790 49,435 50,094 49,566 49,516 97,730 611,206 106.1% 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 20,120 203,116 119.5% 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 71,425 73,901 70,959 66,153 90,542 71,922 91,618 124,760 901,650 109.7% OPERATING EXPENSE Totals: 2,100,656 2,100,656 125,840 141,124 152,165 164,844 154,220 138,715 170,938 140,248 180,530 171,589 168,342 247,721 1,956,275 93.1% OPERATING (LOSS) (449,072) (494,672) (2,201) (3,795) (14,832) (41,504) (3,789) (5,361) (34,018) (4,933) (46,041) (29,437) (29,213) (107,309) (322,434) 65.2% OPERATING - average monthly (loss) Note: Some December 2015 (CoGS) content, which is paid in January 2016, will need to be accrued at year-end. (26,869) --- Months Year % 12 12 100.0% 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) (3,795) (14,832) (41,504) (3,789) (5,361) (34,018) (4,933) (46,041) (29,437) (29,213) (107,309) (322,434) 65.2% NONOPERATING (REV)/EXP: CABs receivable w/o 12,573 - 12,573 --- 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) (37,500) (450,000) 100.0% NET 928 (44,672) 35,799 33,705 23,468 (1,604) 49,411 35,066 3,482 32,567 (32,712) 8,063 8,287 (69,809) 125,723