HomeMy WebLinkAbout1998-08-19 PACKET 04.Q.REQUEST OF CITY COUNCIL ACTIOfV COUNCIL AGENDA
MEETItVG ITE�
DATE 08/19/98
PREPARED BY: Administration Ryan Schroeder
OF2IGINA7ING D��'AF�T"tVI�NT STAF� AU7H01�
.�<.�.��<.�.�.w>�.������>����>���<���.«.<.�.�..�
COUNCIL ACTION REQUEST:
Receive 1999 South Washington County Telecommunications Commission Budget.
BUDGET IMPLICATION: $ $
BUDGETED AMOUNT ACTUAL AMOUNT FUNDING SOURCE
SUPPORTING DOCUMENTS
� MEMO/LETTER: Letter from Thomas D. Creighton
❑ RESOLUTION:
❑ ORDINANCE:
❑ ENGINEERING RECOMMEfVDATION:
❑ LEGAL RECOMMENDATION:
� OTHER: Budget
ADMINISTRATORS GOfUIMENTS
�
���� � � �
City Administrator Da�
...��,�x,�.<�.�.��.��,����.«�.�.�<«�>����.<�����.��
COUNCIL ACTION TAKEN: ❑ APPROVED ❑ DENIED ❑ OTHER
SOUTH WASHINGTON COUNTY TELECOMMUNICATIONS C�� � M
AFTON • COTTAGE GROVE • DENAAARK • GRF.Y CLOUD � NEWPORT • 51�: PAUL PA �.
� � ,��,
August 4, 1998
Mr. Ryan Schroeder
Administrator
City of Cottage Grov�
7516 80th Street South
Cottage Grove, h'iN SSC16
Y �',� �
Dear Mr. oeder:
In accordance with the South Washington County Telecommun-
ications Commission Joint and Cooperative Agreement £or the
administration of a cable television franchise, please find
enclosed the proposed 1999 budget of the South Washington County
Telecommunications Commission.
The city does not have to affirmatively approve the budget of
the Commission, but should review it for questions or concerns. If
no action is taken by the city by December 1, 1998, the budget will
be deemed approved by the city.
Enclosed is a line-item by line-item rationale of the
Commission budget. Please refer to this document, if there are any
questions. The Commission staff is ready to answer any questions
or concerns you may have about the budget which may not be answered
by the written explanation enclosed.
Please contact the Commission office if you have any
questions. Thank yot� for your cooperation.
Sincerely, ��
�
homas D. Creighton
Cable Administrator
TDC/fh
Enc.
445 BROADWAY AVENUE • ST. PAUL PARK, MINNESOTA 55071 •(612) 458-9241 • Fru (612) 459-6520
1999 TELECOMMUNICATIONS BUDGET
Proposed 6/98
FUNDS AVAILABLE
ACCOUNT NO.
1000
ESTIMATED
ACTUALS
1998 1998
PROPOSED
1999
CASH BALANCE AS OF JAN l $ 00 $ 00
$ 00
REVENUES
6010 Franchise Fees 312,000 (356,000) 356,000
8010 Interest 15,000 ( 19,000} 19,000
TOTAL FUNDS AVAILABLE 327,000 (375,000) 375,000
7220
7221
I222
7223
'I224
7225
7226
7230
7240
7250
7256
7260
7270
7280
7310
7315
EXPENSES
Assistant Administrator
Cablecasters
Production Assistant
Government Coordinator
Municipal Producer
Outside Technical Assistance
Outside Producers
PERA
FICA
Health Insurance
Auto Mileage
Public Officials Bond Ins.
E.O. & Liability Insurance
Workers' Comp. Insurance
Accounting/Auditing
Administrative Fees
31,415
8,000
19,055
33,475
21,115
4,000
4,200
5,442
8,649
8,823
2,500
185
5,701
504
4,000
20,850
(32,300)
( 6,325)
(20,000)
(34,775)
(19,000)
(2,000)
{00)
(5,495)
(8,879)
(9,830)
(2,500)
(185)
(5,805)
(504)
(4,500)
(20,850)
33,9i5
8,000
21,000
36,515
21,000
4,000
4,000
5,824
9,212
10,000
3,000
200
6,000
550
5,000
21,475
1999 PROPOSED TELECOMMUNICATZONS BUDGET
PAGE 2
ACCOUNT NO. EXPENSES, continue
7320 Legal Fees
7326 Professional Services
7330 Video Production Supplies
7410 Telephone/Long Distance
7415 Security System
7420 Postage
7430 Legal Notices
7510 Rent
7520 Office Supplies
7521 Cafeteria Supplies
7522 Music Lease
7530 Photocopy _
7535 Printing
7540 Repairs & Maintenance
7550 Membership/Dues/Subscription
7570 Seminars/Conferences
7571 Staff Development
7560 Misc. Expense
7583 Information Technology
7587 Commission Meetings
7585 Unallocated Contingency
2100 Furniture/Fixtures/Equipment
ESTIMATED
ACTUALS
1998 1998
10,000 (10,000)
17,000 (15,000)
3,500 (3,000)
2,500 (2,500)
900 (882)
1,600 (1,875)
00 (00)
10,600 (11,484)
1,500 (1,800)
200 (250)
600 (550)
1,000 (900)
1,000 (600)
4,000 (2,000)
1,500 (2,200)
6,000 (15,000)
4,500 (4,000)
300 (500)
5,000 (1,000)
1,000 (800)
37,886 (1,500)
38;500 (38,500)
$327,000 $287,289
1999
12,000
4,000
4,500
2,500
900
2,000
��
12,200
2,000
250
600
1,000
1,000
4,000
2,500
15,000
4,500
800
5,000
1,000
71,059
38,500
$375,000
1999 TELECOMMUNICATIONS COMMISSION BUDGET
Proposed 6-98
�• •�i.�
FUNDS AVAILABLE
ACCOUNT NO.
����
CASH BALANCE AS OF JAN 1
i ••:
��
1999
��
NOTE: The commission has in past years carried-over monies as a
budgeted itern for the capital upgrade of the video equipment
located in the city halls of the member cities. The accounting
system of the commission accumulates franchise fees which are
unexpended from year to year in the 4M reserve fund of the
commission. This budget takes the carry-over out of the operating
budget. Any expenditures which the commission makes in the
upgrade of city hall equipment will be handled on a case-by-case
basis and taken out of the 4M reserve fund, reported in the
Capital Access Upgrade Fund number 6110. This fund is accounted
for on the quarterly balance sheet of the commission.
REVENUES
6010 Franchise Fees 312,000 356,000
NOTE: Although an increase in franchise fees has been experienced
in each of the past years, the 1999 franchise fees are calculated
by multiplying the last quarterly payment by four. Increased
subscribers will increase franchise fees, however, a conservative
estimate is used here.
:� �
Interest
15,000
19,000
TOTAL FUNDS AVAILABLE
EXPENSES
7220
Assistant Administrator
327,000
31,415
375,000
33,915
NOTE: The 1999 budget includes an estimated 5$ salary increase
from the salaries all individuals were receiving at the end of
1998. The budgeted amount for 1998 does not reflect actuals.
7221 Cablecasters
8,000 8,000
NOTE: The 1999 reflects actual experience in 1998.
1999 PROPOSED TELECOMMiJNICATIONS COMMISSION
BUDGET RATIONALE
PAGE 2
7222 Production Assistant
19,055 21,000
NOTE: See note for 7220.
7223 Government Coordinator 33,475 36,515
NOTE: See note for 7220.
7224 Municipal Producer 21,115 21,000
NOTE: This position was filled with an entry level individual.
7225 Outside Technical Assistance 4,000 4,000
NOTE: This has been maintained since we anticipate the hiring of
a technical assistance consultant for ongoing city hall upgrade.
7226 Outside Producers 4,200 4,000
NOTE: This 'position was reinstated in 1996 and is maintained to
handle any increasing production demands of the cities, without
the necessity of hiring another full-time or part-time producer.
7230 PERA 5,442 5,824
NOTE: The PERA calculation is actual, based on budgeted salaries
subject to PERA payments.
7240 FICA 8,649 9,212
NOTE: The FICA calculation is actual, based on budgeted salaries
subject to FICA payments.
7250 Health Insurance 8,823 10,000
NOTE: Actual
7256
NOTE: Actual
7260
Auto Mileage
Public Officials Bond Ins
2,500
185
3,000
200
NOTE: Estimate
1999 PROPOSED TELECOMMUNICATIONS COMMISSION
BUDGET RATIONALE
PAGE 3
7270 E.O. & Liability Insurance
NOTE: Estimate
7280 Workers' Comp. Insurance
NOTE: Estimate
5,701
504
6,000
550
7310 Accounting/Auditing 4,000 5,000
NOTE: Actual estimated increase
7315 Administrative Fees 20,850 21,415
NOTE: Estimate 3$ increase consistent with past years
7320 Legal Fees 10,000 12,000
NOTE: Increased estimating renewal negotiations
7326 Professional Services 17,000 4,000
NOTE: This item has been decreased to reflect the conclusion of
the Needs Assessment.
7330 Video Production Supplies 3,500 4,500
NOTE: Increased based on additional tapes for cities.
7410
NOTE: Actual
7415
NOTE: Actual
7420
Telephone/Long Distance
Security System
Postage
2,500
:�•
1,600
2,500
•t�
2,000
NOTE: Reflects an estimated increase in postage costs.
7430 Legal Notices 00 00
NOTE: This account is not budgeted, but remains in case legal
notices are required.
1999 PROPOSED TELECOMMUNICATIONS COMMISSION
BUDGET RATIONALE
PAGE 4
7510 Rent 10,600 12,200
NOTE: Increased rent and addition of storage room at $50 per
month.
7520 Office Supplies 1,500 2,000
NOTE: Actual
7521 Cafeteria Supplies 200 250
NOTE: Actual
7522 Music Lease 600 600
NOTE: Actual
7530 Photocopy 1,000 1,000
NOTE: Actual
7535 Printing 1,000 1,000
NOTE: Actual
?540 Repairs & Maintenance 4,000 4,000
NOTE: Actual
7550 Membership/Dues/Subscription 1,500 2,500
NOTE: Actual estimated increases, including tape submission to
contests
7570 Seminars/Conferences 6,000 15,000
NOTE: Reflects additional attendance by city representatives
7571 Staff development 4,500 4,500
NOTE: Actual
7580 Misc. Expense 300 800
NOTE: Estimated increases in miscellaneous expenses
1999 PROPOSED TELECOMMUNZCATIONS COMMISSZON
BUDGET RATIONALE
PAGE 5
7583 Information Technology
5,000 5,000
NOTE: This account was added for the provision of Znternet
Access and training for the Commission office.
7587
NOTE: Actual
7585
Commission Meetings
Unallocated contingency
1,000
37,886
1,000
71,059
NOTE: Previous excess franchise fee revenue had previously been
placed in the now-closed capital access upgrade fund. With the
elimination of that fund from the operating budget of the
commission, such funds are now bndgeted in the unallocated
contingency so that unanticipated expenditures in 1999 will not
have to be taken from other line items and better accounted for
in a separate line item. Additionally, funds remaining in this
account at the end of the year are accumulated in the Commission
4M Fund from which, among other things, equipment is purchased
pursuant to the 5 year equipment replacement plan.
2100 Furniture/Fixtures/Equipment 38,500 38,500
NOTE: Reflects government access video/audio as approved by the
commission with the 5 year equipment replacement plan.
TOTAL $327,000 $375,000