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