Loading...
FiberNet Advisory Board Agenda Packet 06-14-2016AGENDA FIBERNET MONTICELLO ADVISORY BOARD MEETING Tuesday, June 14, 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 May 2016 Meeting Minutes 4. Network Update 5. Business Office Update • June Subscriber Information • Prairie Center Building Update • Discussion of customer credits 6. Financial Update 7. Management Update • Introduction of Arvig • Contract status 8. IRET Update 9. Next Meeting — Tuesday, July 12, 2016 10. Adjourn MINUTES REGULAR MEETING — FIBERNET MONTICELLO ADVISORY BOARD Tuesday, May 1011, 2016 Boom Island Room, Monticello Community Center Present: Charlotte Gabler, Jon Morphew, Jacob Kramer, Dennis Sullivan Others: Jeff O'Neill, Rachel Leonard, Bryan Rabe, Wayne Oberg Absent: Brian Stumpf 1. Call to Order Charlotte Gabler called the meeting to order at 6:30 PM. 2. Additions to Agenda None 3. AwDroval of March 2016 Meeting Minutes JACOB KRAMER MOVED TO APPROVE THE MARCH 15TH, 2016 REGULAR MEETING MINUTES. JON MORPHEW SECONDED THE MOTION. MOTION CARRIED 4-0. 4. Network Update • Bryan Rabe reported on peak network usage and the number of new GigaCenter ONTs out in the field. • Bryan Rabe also reported that the FiberNet technicians have been assisting the Water Department with installation of radio readers on city water meters. • Charlotte Gabler asked about the time since the last major outage. Bryan Rabe reported it has been more than 6 months. He reiterated FiberNet does not guarantee up -time, but the system has been stable. 5. Business Office Update Rachel Leonard provided the latest subscriber data and clarified a point regarding the number of business subscribers. Report provided by the billing system doesn't work as well for businesses as it does for residents; this month decided to count manually. Resulted in a slightly lower number, but the results should be more accurate. Leonard will continue to provide business numbers this way rather than using the report. Rachel Leonard reported that the current billing company, Source One Solutions, has informed its customers that it has suspended work on an updated platform. Instead it will spend the next couple of years transitioning customers onto new systems. They have a preferred partner they recommend, but companies can selected the new billing company independently too. Rachel Leonard requested the advisory board review charges for additional wiring. The charges have been in place for several years and are noted on pricing forms, the website, and customer handbook. However, they have not been reviewed in several years. Leonard recommended the charges remain in place in their current form, but asked for input from board members. Consensus from the board was to keep charges at $69.95 per line. 6. Financial Update 0 Wayne Oberg provided the financial reports ending 4/30/16. Oberg noted FiberNet is on FiberNet Advisory Board Minutes: 05/10/16 target with its budget and patterns are emerging in both revenues and expenses. 7. Management Update Jeff O'Neill reported to the board that the small group made up of staff and two council members will meet this week to review the information submitted in the two proposals. The council members can request additional information or direct staff to set a workshop with the full council. Additionally, O'Neill reported that some council members, advisory board members, and citizens have been checking references for the two companies. Jacob Kramer, Dennis Sullivan, and Charlotte Gabler each summarized their reference calls. This information will be provided to council at the future workshop. 8. IRET Update Jeff O'Neill updated the board in the continued work with IRET for FiberNet to provide service to the new apartments in Monticello. The draft agreement between IRET and the city has been received and is being reviewed by the city attorney. Pending finalization of the costs necessary to provide service, the agreement will go before City Council for a decision at the regular meeting on May 23, 2016. Charlotte Gabler requested to know the total costs with assumptions of different take rates to determine the length of time to recover the costs. 9. 2016 Volunteer Appreciation Picnic The City of Monticello will host a volunteer Appreciation Picnic in June 2016 as a thank you to volunteers and their families. 10. Next Meeting The next meeting of the FiberNet Advisory Board is scheduled for June 14, 2016 at 6:30pm in the Boom Island Room at the Monticello Community Center. 11. Adiournment JON MORPHEW MOVED TO ADJOURN THE MEETING. JACOB KRAMER SECONDED THE MOTION. MOTION CARRIED 4-0 AND MEETING ADJOURNED AT 7:40 PM. Recorder: Rachel Leonard Approved: Attest: Jeff O'Neill, City Administrator Residential & Business Subscribers (Customer Counts) Service Dec15 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YTD I CHG% Phone Only 31 32 31 31 31 27 27 --- --- --- --- --- --- -4 -12.9% Internet Only 646 664 678 693 700 704 707 --- --- --- --- --- --- 61 9.4% Television Only 77 74 72 72 70 71 71 --- --- --- --- --- --- -6 -7.8% Phone & Internet 169 164 163 161 158 162 164 --- --- --- --- --- --- -5 -3.0% Phone & Television 45 44 43 43 43 42 42 --- --- --- --- --- --- -3 -6.7% Internet & Television 323 318 309 298 292 287 285 --- --- --- --- --- --- -38 -11.8% Triple Play 278 278 277 271 268 265 260 --- --- --- --- --- --- -18 -6.5% Total Subscribers 1569 1574 1573 1569 1562 1558 1556 0 0 0 0 0 0 -13 -0.8% Total Phone 523 518 514 506 500 496 493 --- --- --- --- --- --- -30 -5.7% Total Internet 1416 1424 1427 1423 1418 1418 1416 --- --- --- --- --- --- 0 0.0% Total Television 723 714 701 684 673 665 658 --- --- --- --- --- --- -65 -9.0% Total Services 2662 2656 2642 2613 2591 2579 2567 -95 -3.6% Residential & Business Subscribers (Percentage of Customers) Service Dec15 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Phone Only 2.0% 2.0% 2.0% 2.0% 2.0% 1.7% 1.7% --- --- --- --- --- --- Internet Only 41.2% 42.2% 43.1% 44.2% 44.8% 45.2% 45.4% --- --- --- --- --- --- Television Only 4.9% 4.7% 4.6% 4.6% 4.5% 4.6% 4.6% --- --- --- --- --- --- Phone & Internet 10.8% 10.4% 10.4% 10.3% 10.1% 10.4% 10.5% --- --- --- --- --- --- Phone & Television 2.9% 2.8% 2.7% 2.7% 2.8% 2.7% 2.7% --- --- --- --- --- --- Internet & Television 20.6% 20.2% 19.6% 19.0% 18.7% 18.4% 18.3% --- --- --- --- --- --- Triple Play 17.7% 17.7% 17.6% 17.3% 17.2% 17.0% 16.7% --- --- --- --- --- --- Total Subscribers 1100.0% 1100.0% 1100.0% 1100.0% 1100.0% 1100.0% 1100.0% I 0.0% I 0.0% I 0.0% I 0.0% I 0.0% I 0.0% Total Phone 19.6% 19.5% 19.5% 19.4% 19.3% 19.2% 19.2% --- --- --- --- --- --- Total Internet 53.2% 53.6% 54.0% 54.5% 54.7% 55.0% 55.2% --- --- --- --- --- --- Total Television 27.2% 26.9% 26.5% 26.2% 26.0% 25.8% 25.6% --- --- --- --- --- --- Total Services 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% -- Residential and Business Service Participation (Percentage of Customers) Service I Dec15 j 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% 32% 32% 32% 32% -2% -5% TV 46% 45% 45% 44% 43% 43% 42% -4% -8% Internet 90% 90% 91% 91% 91% 91% 91% 1% 1% Residential Subscribers (Customer Counts) Service Decl5j Jan 16 Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YTD CHG % Phone Only 21 22 21 21 21 19 18 Television Only 5.3% 5.1% 4.9% 5.0% 4.8% -3 -14.3% Internet Only 612 627 640 654 659 673 676 Phone & Television 3.1% 3.0% 2.9% 2.9% 2.9% 64 10.5% Television Only 76 73 71 71 69 70 70 Triple Play 18.4% 18.3% 18.3% 17.9% 17.8% -6 -7.9% Phone & Internet 97 94 93 95 94 94 95 Total Phone 17.6% 17.5% 17.4% 17.4% 17.4% -2 -2.1% Phone & Television 44 43 42 41 41 41 41 Total Television 29.0% 28.7% 28.4% 27.9% 27.7% -3 -6.8% Internet & Television 317 315 306 295 289 283 281 -36 -11.4% Triple Play 264 263 263 257 254 250 245 -19 -7.2% Total Subscribers 1431 1437 1436 1434 1427 1430 1426 0 0 0 0 0 0 -5 -0.3% Total Phone Total Internet 426 422 419 414 410 404 399 0 0 0 1 0 0 0 -27 7 -6.3% 0.5% 1290 1299 1302 1301 1296 1300 1297 0 0 0 0 0 0 Total Television Total Services 701 694 682 664 653 644 637 0 0 0 0 0 0 -64 -84 -9.1% -3.5% 2417 2415 2403 2379 2359 2348 2333 0 0 0 0 0 0 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% 1.5% 1.5% 1.3% 1.3% --- --- --- --- --- --- Internet Only 42.8% 43.6% 44.6% 45.6010 46.2% 47.1% 47.4% --- --- --- --- --- --- Television Only 5.3% 5.1% 4.9% 5.0% 4.8% 4.9% 4.9% --- --- --- --- --- --- Phone & Internet 6.8% 6.5% 6.5% 6.6% 6.6% 6.6% 6.7% --- --- --- --- --- --- Phone & Television 3.1% 3.0% 2.9% 2.9% 2.9% 2.9% 2.9% --- --- --- --- --- --- Internet & Television 22.2% 21.9% 21.3% 20.6% 20.3% 19.8% 19.7% --- --- --- --- --- --- Triple Play 18.4% 18.3% 18.3% 17.9% 17.8% 17.5% 17.2% --- --- --- --- --- --- Total Subscribers 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% Total Phone 17.6% 17.5% 17.4% 17.4% 17.4% 17.2% 17.1% --- --- --- --- --- Total Internet 53.4% 53.8% 54.2% 54.7% 54.9% 55.4% 55.6% --- --- --- --- Total Television 29.0% 28.7% 28.4% 27.9% 27.7% 27.4% 27.3% --- --- --- --- --- --- Total Services 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% --- --- --- --- --- --- Residential Service Participation (Percentage of Customers) Service I Dec15 j 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% 29% 29% 28% 28% -2% -6% TV 49% 48% 47% 46% 46% 45% 45% -4% -9% Internet 90% 90% 91% 91% 91% 91% 91% 1% 1% Business Subcribers (Customer Counts) Service Dec15 Jan Feb Mar Phone Only 10 10 10 10 Internet Only 34 37 38 39 Television Only 1 1 1 1 Phone & Internet 72 70 70 66 Phone & Television 1 1 1 2 Internet & Television 6 3 3 3 Triple Play 14 15 14 14 Total Subscribers 138 137 137 135 Total Phone 97 96 95 92 Total Internet 126 125 125 122 Total Television 22 20 19 20 Total Services 245 241 239 234 Apr I May I Jun I Jul I Aug I Sep I Oct I Nov I Dec I YTD I CHG % 10 8 9 Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 1 -1 -10.0% 41 31 31 7.4% 7.4% 6.3% 6.9% --- --- --- --- --- --- Internet Only I -3 -8.8% 1 1 1 30.4% 24.2% 23.8% --- --- --- --- --- --- Television Only 0.7% I 0 0.0% 64 68 69 0.8% 0.8% --- --- --- --- --- --- Phone & Internet 52.2% 51.1% I -3 -4.2% 2 1 1 53.1% --- --- --- --- --- --- Phone & Television 0.7% 0.7% 0.7% I 0 0.0% 3 4 4 Internet & Television 4.3% 2.2% 2.2% 2.2% I -2 -33.3% 14 15 15 10.1% 10.9% 10.2% 10.4% 10.4% 1 7.1% 135 128 130 0 0 0 0 0 0 -8 -5.8% 90 92 94 0 0 0 0 0 0 -3 -3.1% 122 118 119 0 0 0 0 0 0 I -7 -5.6% 20 21 21 0 0 0 0 0 0 -1 -4.5% 232 231 234 0 0 0 0 0 0 11 -4.5% 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% 7.4% 7.4% 6.3% 6.9% --- --- --- --- --- --- Internet Only 24.6% 27.0% 27.7% 28.9% 30.4% 24.2% 23.8% --- --- --- --- --- --- Television Only 0.7% 0.7% 0.7% 0.7% 0.7% 0.8% 0.8% --- --- --- --- --- --- Phone & Internet 52.2% 51.1% 51.1% 48.9% 47.4% 53.1% 53.1% --- --- --- --- --- --- Phone & Television 0.7% 0.7% 0.7% 1.5% 1.5% 0.8% 0.8% --- --- --- --- --- --- Internet & Television 4.3% 2.2% 2.2% 2.2% 2.2% 3.1% 3.1% --- --- --- --- --- --- Triple Play 10.1% 10.9% 10.2% 10.4% 10.4% 11.7% 11.5% --- --- --- --- --- --- Total Subscribers 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% Total Phone 39.6% 39.8% 39.7% 39.3% 38.8% 39.8% 40.2% --- --- --- --- --- --- Total Internet 51.4% 51.9% 52.3% 52.1% 52.6°/% 51.1% 50.9% --- --- --- --- --- --- Total Television 9.0% 8.3% 7.9% 8.5% 8.6% 9.1% 9.0% --- --- --- --- --- --- Total Services 100.0% 100.0% 100.0% 100.0% 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 % I Phone 70% 70% 69% 68% 67% 72% 72% 2% 3% TV 16% 15% 14% 15% 15% 16% 16% 0% 1% Internet 91% 91% 91% 90% 90% 92% 92% 0% 0% Fiber Net 2016 Schedule of Revenue and Expenses (Modified Accrual Basis - No Depreciation) 5/31/2016 Comments Original Amended Account Number Description Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YTD Ytd% Budget Budget REVENUE 656-00000-341180 PEG Access Fee $ 7,435 $ 7,435 $ 592 $ 569 $ 558 $ 558 $ 560 $ $ $ $ $ $ $ $ 2,838 38.2% 656-00000-341190 USF Fee 8,083 8,083 672 663 634 599 597 3,163 39.1% 656-00000-362920 Services - Misc 15,776 15,776 1,321 1,321 1,321 1,321 1,321 6,605 41.9% 656-00000-362990 Other Miscellaneous Revenue 2,001 2,001 15 7 5 4 14 44 2.2% 656-00000-380510 Television Services 619,082 619,082 45,996 48,729 47,450 47,591 47,611 237,377 38.3% 656-00000-380520 Internet Services 659,011 659,011 55,770 55,639 55,691 55,685 56,601 279,387 42.4% 656-00000-380522 Equipment Rental/Purchase 128,502 128,502 12,421 13,115 12,181 12,169 12,678 62,565 48.7% 656-00000-380530 Phone Services 267,617 267,617 24,424 24,177 23,491 22,465 22,076 116,634 43.6% 656-00000-380531 Long Distance - - 2,934 2,930 2,339 1,632 9,835 --- 656-00000-380540 CABS Revenue 6,000 6,000 - - 1,418 - - 1,418 23.6% 656-00000-380542 Late Fees 16,260 16,260 1,390 1,505 1,265 1,230 1,330 6,720 41.3% 656-00000-380545 Discounts Offered -Taxable (26,213) (26,213) (2,113) (2,027) (1,949) (1,956) (1,921) (9,967) 38.0% 656-00000-380546 Discounts Offered -Non Taxable (42,107) (42,107) (3,252) (3,164) (3,059) (3,057) (3,211) (15,743) 37.4% 656-00000-380557 Miscellaneous Charges 27,520 27,520 1,709 1,349 1,174 1,814 1,637 7,683 27.9% 656-00000-380558 Misc Charges -Non Taxable 1,483 1,483 (3) 138 21 220 145 521 35.2% OPERATING REVENUE Totals: 1,690,450 1,690,450 138,942 144,954 143,130 140,982 141,073 709,081 41.9% EXPENSE Dept 49870 General & Administration 656-49870-410100 Salaries Full -Time Reg 184,238 184,238 11,622 10,022 10,461 9,829 9,489 51,423 27.9% 656-49870-410200 Salaries Full -Time OT 600 600 36 18 26 8 11 100 16.7% 656-49870-410300 Salaries Part -Time Reg 18,000 18,000 1,238 1,316 1,430 1,200 1,364 6,548 36.4% 656-49870-410310 Salaries Part -Time. OT - - - - - - - - --- 656-49870-410400 Salaries Temporary -Reg - - - - - - - - --- 656-49870-412100 Pera Contributions 15,213 15,213 727 852 894 828 815 4,115 27.1% 656-49870-412200 Fica Contributions 15,517 15,517 710 828 869 802 789 3,999 25.8% 656-49870-413100 Health Insurance Contributions 56,421 56,421 3,663 3,663 3,788 3,801 3,774 18,690 33.1% 656-49870-413300 Life Insurance Contributions 300 300 17 25 25 25 25 118 39.4% 656-49870-413400 Disability Ins Contributions 600 600 24 35 35 35 35 165 27.5% 656-49870-415100 Workers Comp 644 644 - - - - - - 0.0% 656-49870-421990 Gen Operating Supplies 17,088 17,088 3,836 - 642 424 4,902 28.7% 656-49870-430400 Legal Fees 9,600 9,600 371 375 1,500 375 2,621 27.3% 656-49870-430700 Management Services (GM) - - - - - - - --- 656-49870-431800 Professional Services -Billings 26,400 26,400 2,059 2,000 2,000 2,000 2,000 10,060 38.1% 656-49870-431970 Regulatory Professional Svcs 9,600 9,600 - - 442 1,605 1,981 4,028 42.0% 656-49870-431990 Miscellaneous Prof Services 24,000 24,000 296 6,608 3,577 1,547 2,627 14,655 61.1% 656-49870-432100 Telephone/Internet 1,800 1,800 - - 8 8 8 25 1.4% 656-49870-432150 Internal IT Services 26,929 26,929 2,244 2,244 2,244 2,244 2,244 11,220 41.7% 656-49870-432200 Mail & Delivery Services 8,400 8,400 567 575 560 570 551 2,822 33.6% 656-49870-432500 Cable/Network Services 8,600 8,600 - - 1,835 1,746 - 3,581 41.6% 656-49870-433200 Training/Conferences 1,200 1,200 - - - - 0.0% 656-49870-434600 Marketing 1,800 1,800 - 334 334 18.6% 656-49870-436100 LPV Insurance 9,165 9,165 5,346 - - 5,346 58.3% 656-49870-440100 Repair and Maint-Buildings 2,400 2,400 - 190 - - - 190 7.9% 656-49870-441200 Building/Room Rental 16,980 16,980 1,415 1,415 1,415 1,415 1,415 7,075 41.7% 656-49870-443200 Write Offs 21,600 21,600 1,291 (186) 1,985 3,445 938 7,474 34.6% 656-49870-443300 Dues Membership and Subscrip 1,300 1,300 - 100 - - - 100 7.7% 656-49870-443700 Licenses And Permits 1,625 1,625 80 - 102 - - 182 11.2% 656-49870-443980 Bank Charges 12,000 12,000 803 959 39 959 1,114 3,874 32.3% 656-49870-443990 Miscellaneous Other Exp 6,000 6,000 5 (3) 34 125 16 176 2.9% 656-49870 EXPENSE Totals: 498,020 498,020 32,145 34,869 32,146 34,335 30,331 163,826 32.9% Dept 49870 Field Operations 656-49877-410100 Salaries Full -Time Reg 226,313 226,313 22,903 18,057 18,066 18,161 18,041 95,228 42.1% 656-49877-410200 Salaries Full -Time OT 12,000 12,000 852 1,810 1,466 1,044 290 5,461 45.5% 656-49877-410300 Salaries Part -Time Reg - - - - - - - - --- 656-49877-410310 Salaries Part -Time OT 656-49877-410400 Salaries Other -Reg - - - - - - - - --- 656-49877-412100 Pera Contributions 17,873 17,873 1,176 1,490 1,465 1,440 1,375 6,946 38.9% Comments Account Number Description 656-49877-412200 Fica Contributions 656-49877-412300 Medicare Contributions 656-49877-413100 Health Insurance Contributions 656-49877-413300 Life Insurance Contributions 656-49877-413400 Disability Ins Contributions 656-49877-414200 UC Benefit Payments 656-49877-415100 Work Comp Ins Premiums 656-49877-421110 Clothing Supplies 656-49877-421200 Motor Fuels 656-49877-421800 Fiber/Video/Phone Supplies 656-49877-421990 Gen Operating Supplies 656-49877-422500 Landscaping Materials 656-49877-422990 Misc Repair and Maint Supplies 656-49877-424100 Small Tools ($500-$9999) 656-49877-431900 Maintenance & Support Services (1)(2)(3) 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/Recycling Services 656-49877-440100 R&M-Buildings/Systems 656-49877-440440 R&M -Mach & Equip 656-49877-440500 R&M -Vehicles 656-49877-443990 Miscellaneous Other Exp 656-49877-458010 Other Equipment 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: OPERATING EXPENSE Totals: OPERATING (LOSS) Original Amended Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YTD Ytd% Budget Budget 18,231 18,231 1,163 1,471 1,442 1,417 1,350 6,842 37.5% 66,539 66,539 5,440 5,440 5,590 5,590 5,590 27,650 41.6% 600 600 23 37 37 37 37 172 28.7% 1,200 1,200 36 57 57 57 57 265 22.1% 5,896 5,896 4,384 4,384 74.4% 1,800 1,800 - - - - - - 0.0% 3,600 3,600 25 89 80 105 210 510 14.2% 73,000 73,000 - 7,523 - 7,519 7,526 22,569 30.9% 30,000 30,000 1,152 2,790 955 830 1,906 7,633 25.4% 6,000 6,000 - - - - - - 0.0% 108,000 108,000 13,619 24,221 6,551 16,301 23,192 I 83,885 77.7% 12,000 12,000 - 658 658 658 658 2,633 21.9% 1,800 1,800 77 24 62 181 344 19.1% 24,000 24,000 1,866 1,578 2,028 2,027 1,758 9,257 38.6% 900 900 - - - - - - 0.0% 1,200 1,200 - 109 109 - 218 18.2% 24,000 24,000 1,481 - - 5,108 6,590 27.5% 4,000 4,000 - - - - 0.0% 4,000 4,000 7 7 0.2% 6,000 6,000 1,000 - 1,000 16.7% 648,952 648,952 52,639 66,781 38,528 56,364 67,280 281,593 43.4% 68,280 68,280 5,512 4,994 6,030 5,463 5,417 27,416 40.2% 661,260 661,260 48,865 49,394 48,382 47,085 46,429 240,154 36.3% 159,300 159,300 17,819 17,870 17,870 17,851 17,852 89,262 56.0% - - - 67 - 67 --- 888,840 888,840 72,196 72,324 72,282 70,398 69,698 356,899 40.2% 2,035,812 2,035,812 156,980 173,974 142,956 161,098 167,309 802,317 39.4% $ (345,362) $ (345,362) $ (18,039) $ (29,020) $ 175 $ (20,117) $ (26,236) $ $ $ $ $ $ $ $ (93,236) 27.0% OPERATING - average monthly (loss) Notes: (1) Lump sum (i.e. annual, semi-annual, etc.) service payments will be re -distributed by months covered as the year progresses (amount remaining $17,500/7 or $2,500 monthly). (2) Unresolved CSI digital bill for $9750 STB licenses ($1.50 per settop box). Not on contract listing. (3) Metaswitch invoice for $27,852 is being distributed by month as year progresses (amount remaining $13,926/6 or $2,321 monthly). Description Orig. Amended Jan Feb Mar Apr May Jun Jul SUMMARY Budget Budget OPERATING (LOSS) $ (345,362) $ (345,362) $ (18,039) $ (29,020) $ 175 $ (20,117) $ (26,236) $ - $ - $ NONOPERATING (REV)/EXP: Investment Earnings Damage Claim Insurance Claim Reimbursement 656-00000-362400 Sale of City Property 656-00000-392000 Operating Transfer In NET (18,647) Months Year 5 12 Aug Sep Oct Nov Dec (25,665) 25,665 350,000 350,000 29,167 29,167 29,167 29,167 29,167 $ 4,638 $ 4,638 $ 11,128 $ 147 $ 29,342 $ 9,051 $ 2,931 $ $ $ $ $ $ $ YTD (93,236) 145,835 52,599 41.7% Ytd% 27.0% 41.7% Comments