HomeMy WebLinkAbout3.B. Telecommunications 2005 Budget
# gg
CITY OF SHAKO PEE
2005 GENERAL FUND BUDGET
DIVISION: ADMINISTRATION - TELECOMMUNICATIONS
MISSION STATEMENT:
The mission of Telecommunications division is to provide
direction to the City Council and to study issues and recommend
solutions relating to the provision of telecommunication services
for the City, residents, and businesses of Shakopee.
ACTIVITY:
Telecommunications activities include: conducting and
recommending ordinance changes to the city council, renewal and
re-franchising, recommending a budget to the City Council,
provide direction to the City Council on new telecommunication
developments, INET oversight and development, and PEG channel and
studio operation and direction.
GOALS:
1) To increase programming for the public access channel.
2) To increase original government programming.
3) Convert government access programming and recording to
digital.
4) Monitor and expand the INET to new PW building and Fire
Station.
5) Complete phase II of the website upgrade.
6) Research wi-Fi options for the city and its residential and
business customers.
OBJECT DESCRIPTION: Description of line items:
Wages & Benefits:
Assistant to the City Administrator ($30,000) , Video
Production Specialist, Cable Technician(s) , clerical
support staff and new additional p-t staff for video
production and website maintenance ($15,000) .
Supplies & Services:
Minor equipment and maintenance for public and government
access studios $1,500, office supplies $1,000, $2,000 for
promotion.
Professional Services:
Legal counsel $1,500, $38,500 website upgrade phase II &
maintenance, $15,000 for consultants on Telecommunications
Projects.
Dues, Training, Traveling:
$1,400 MACTA & NAOTA membership, $650 MACTA Twin Cities
Conference for Asst. to the City Administrator & Television
Production Specialist, $3000 for travel for 2 individuals
to National Conferences.
Equipment:
$27,604 for Public Access upgrade to include new portable
studio camera equipment, new staff studio camera and
digital editing equipment. $30,000 for multi-media server
to convert VHS to digital playback for government access.
$75,000 for video streaming applications, $10,000 to
purchase equipment for VoIP for Vierling Fire Station,
$15,000 to expand INET to new PW building and $24,000 for
Wi-Fi and other new technology projects.
R5509BUD .001 CITY 6F i!iPEE 8/.15:58:18
Fiscal Period: 7 1 4 Budget Report Page - 1
Level Of R.ollu p 7
2001 2002 2003 7/31/2004 2004 2005 2005 2005
Actual Actual Actual YTD Final Requested Approved Final
Object Code 1 Description Amount Amount Amount Actual Budget Budget Budget Budget
02150 TELECOMMUNICATION
6000 EXPENDITURES
6001 WAGES & BENEFITS
6002 WAGES 19,892 42,254 29,163 56,800 85,740 85,740 85,740
6005 OVERTIME-FT 106 233
6015 WAGES - PART TIMEfTEMP 4,815 4,679 2,572
6002 WAGES 24,813 47,165 31,735 56,800 85,740 85,740 85,740
6100 BENEFITS
6122 PERA 1,359 2,608 1,755 3,150 4,740 4,740 4,740
6124 FICA 1,898 3,608 2,427 4,340 6,560 6,560 6,560
6135 HEALTH 1,650 4,121 2,942 4,150 4,660 4,660 4,660
6139 POST EMPLOYMENT HEALTH PLAN 158 349 223 300 300 300 300
6140 LIFE/LTD 82 212 143 70 260 260 260
6145 DENTAL 132 391 246 360 420 420 420
6170 WORKERS COMPENSATION 150 107 200 200 200 200
6180 COMPENSATED ABSENCES 683 246 2,000 2,000 2,000 2,000
6100 BENEFITS 5,962 11,684 7,843 14,570 19,140 19,140 19,140
6001 WAGES & BENEFITS 30,776 58,849 39,578 71,370 104,880 104,880 104,880
6200 SUPPLIES AND SERVICES
6201 SUPPLIES & SERVICES
6202 OPERATING SUPPLIES 10,126 16,938 29,460 84,100 84,100 84,100
6210 OFFICE SUPPLIES 4,231 2,191 2,854
6215 MATERIALS 500 1,000 1,000 1,000
6240 EQUIPMENT MAINTENANCE 1,000 1,500 1,500 1,500
6201 SUPPLIES & SERVICES 4,231 12,317 19,792 30,960 86,600 86,600 86,600
6300 PROFESSIONAL SERVICES
6310 ATTORNEY 13,769 8,671 5,586 2,000 1,500 1,500 1,500
6312 ENGINEERING CONSULTANTS 115
6316 EQUIPMENT MAINTENANCE 832 305
6327 OTHER PROF SERVICES 15,646 71,319 4,860 57,000 62,000 62,000 62,000
6300 PROFESSIONAL SERVICES 30,362 80,295 10,446 59,000 63,500 63,500 63,500
6330 COMMUNICATIONS
6332 POSTAGE 30 250 100 100 100
6334 TELEPHONE 85 185 92 250 100 100 100
6336 PRINTING/PUBLISHING 217 128 85 500 500 500 500
R5509BUD LOGIS001 CITY OF SHAKOPEE 812312004 15:58:18
Fiscal Period: 7 I 4 Budget Report Page - 2
Level Of Rollup 7
2001 2002 2003 7/31/2004 2004 2005 2005 2005
Actual Actual Actual YTD Final Requested Approved Final
Object Code 1 Description Amount Amount Amount Actual Budget Budget Budget Budget
6338 ADVERTISING 60 500 2,000 2,000 2,000
6330 COMMUNICATIONS 362 343 177 1,500 2,700 2,700 2,700
6350 INSURANCE
6352 LIABILITY 241 2,024 1,556 1.560 1,560 1,560
6350 INSURANCE 241 2,024 1,556 1,560 1,560 1,560
6400 RENTALS
6430 BUILDING RENT (IS FUND) 12,000 12,000 12,000 12,000
6400 RENTALS 12,000 12,000 12,000 12,000
6470 DUES/TRAINING/TRAVEL
6472 CONFERENCE/SCHOOL/TRAINING 1,640 605 650 1,000 1,000 1,000
6475 TRAVEUSUBSISTENCE 2,297 235 173 3,000 3.000 3,000
6480 DUES 1,365 1,710 1,300 2,050 2,050 2,050
6470 DUES/TRAINING/TRAVEL 3,937 2.205 1,883 1,950 6,050 6,050 6.050
6200 SUPPLIES AND SERVICES 39,132 97,183 33,855 105,410 172,410 172,410 172,410
6500 DEPRECIATION
6600 MISCELLANEOUS
6700 CAPITAL OUTLAY
6740 EQUIPMENT 122,511 8,405 65,000 105,000 105,000 105,000
6760 IMPROVEMENTS 106,289
6700 CAPITAL OUTLAY 106,289 122,511 8,405 65,000 105,000 105,000 105,000
6800 DEBT SERVICE
6000 EXPENDITURES 176,196 278,543 81,838 241,780 382,290 382,290 382,290
02150 TELECOMMUNICATION 176,196 278,543 81,838 241,780 382,290 382,290 382,290
. . .
R5509BUD LOGIS001 CITY OF SHAKOPEE 8/23/2004 15:58:18
Fiscal Period: 7 / 4 Budget Report Page- 2
Level Of Rollup 7
2001 2002 2003 7/31/2004 2004 2005 2005 2005
Actual Actual Actual YTD Final Requested Approved Final
Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget
6338 ADVERTISING 60 500 2.000 2,000 2,000
6330 COMMUNICATIONS 362 343 177 1,500 2.700 2,700 2,700
6350 INSURANCE
6352 LIABILITY 241 2,024 1,556 1,560 1,560 1,560
6350 INSURANCE 241 2,024 1,556 1.560 1,560 1,560
6400 RENTALS
6430 BUILDING RENT (IS FUND) 12,000 12,000 12,000 12,000
--~~
6400 RENTALS 12,000 12,000 12,000 12,000
6470 DUESfTRAININGfTRAVEL
6472 CONFERENCElSCHOOUTRAINING 1,640 605 650 1,000 1,000 1,000
6475 TRAVEUSUBSISTENCE 2,297 235 173 3,000 3,000 3,000
6480 DUES 1,365 1,710 1,300 2,050 2,050 2,050
6470 DUESfTRAININGfTRAVEL 3,937 2,205 1,883 1,950 6,050 6,050 6,050
6200 SUPPLIES AND SERVICES 39,132 97,183 33,855 105,410 172,410 172,410 172,410
6500 DEPRECIATION
6600 MISCELLANEOUS
6700 CAPITAL OUTlAY
6740 EQUIPMENT 122,511 8,405 65,000 105,000 105,000 105,000
6760 IMPROVEMENTS 106,289
6700 CAPITAL OUTLAY 106,289 122,511 8,405 65,000 105,000 105,000 105,000
6800 DEBT SERVICE
6000 EXPENDITURES 176,196 278,543 81,838 241,780 382,290 382,290 382,290
02150 TELECOMMUNICATION 176,196 278,543 81.838 241,780 382,290 382,290 382,290
Telecommunications
2005 Budget
2150 2151 Budget
Object # Description Benefits Management Total 2004 Diff
6002 Wages FT - Reg. - 85,740 85,740 56,800 28,940
6005 Wages OT - Reg. - -
6122 PERA - 4,740 4,740 3,150 1,590
6124 FICA - 6,560 6,560 4,340 2,220
6135 Health 4,660 4,660 4,150 510
6139 PEHP 300 300 300 -
6140 Life 260 260 70 190
6145 Dental 420 420 360 60
6170 Workers Comp 200 200 200 -
6180 Compensated Absences 2,000 2,000 2,000 -
6190 Retirement Benefit - -
Total Personnel 7,840 97,040 104,880 71,370 33,510 46.95%
6210 Operating Supplies 84,100 84,100 29,460 54,640
6215 Materials 1,000 1,000 500 500
6240 Equipment Maintenance 1,500 1,500 1,000 500
6300 Professional Services 62,000 62,000 62,000
631 0 Attorney 1,500 1,500 2,000 (500)
6327 Other Prof Services - 57,000 (57,000)
6332 Postage 100 100 250 (150)
6334 Telephone 100 100 250 (150)
6336 Printing/Publishing 500 500 500 -
6338 Advertising 2,000 2,000 500 1,500
6352 Liability Insurance 1,560 1,560 1,560
6400 Rentals - - -
6420 Equipment Rent - -
6430 Building Rent (IS FUND) 12,000 12,000 12,000 -
6435 Other Rent - - -
6472 Conf / School/ Training 1,000 1,000 650 350
6475 Travel/Subsistence 3,000 3,000 3,000
6480 Dues 2,050 2,050 1,300 750
6490 Subscriptions/Publications - -
Total Supplies & Services - 172,410 172,410 105,410 67,000 63.56%
6740 Capital Expenditures 105,000 105,000 65,000 40,000
Total $ 7,840 $ 374,450 $ 382,290 $241,780 $140,510 58.11 %
2005 BUDGET
Est. 2005 Pay
2005 With COl Inc
Title/Description Step 3.0% FICA PERA
TV Prod Specialist B $ 40,743 $ 3,117 $ 2,253
Charge in Management N/A $ 30,000 $ 2,295 $ 1,659
Charge in IT N/A 15,000 1,148 830
Total Telecommunications $ 85,743 $ 6,560 $ 4,742
CITY OF SHAKOPEE
TELECOMMUNICATIONS FUND
2005 BUDGET
TELECOMMUNICATIONS FUND BUDGET SUMMARY ,
2002 2003 2004 2005
Actual Actual Budget Proposed
Revenue
Taxes $ - $ - $ -
Licenses and Permits 202,406 191,223 185,000 185,000
Intergovernmental
Charges for Service 967
Interest 14,975 14,823 500 5,000
Miscellaneous 370,899 16,593
Total Revenue 588,280 223,606 185,500 190,000
Expenditures
Personal Services 30,775 58,850 71,370 104,880
Supplies & Services 39,132 97,183 105,410 172,410
Capital Equipment 106,289 122,511 65,000 105,000
Total Expenditures 176,196 278,544 241,780 382,290
Excess (Deficiency) Of Revenues
over Expenditures 412,084 (54,938) (56,280) (192,290)
Fund Balance December 31 $ 412,084 $ 357,146 $ 300,866 $ 108,576
3,5,
City of Shako pee
Memorandum
TO: Mayor, City Council
Mark McNeill, City Administrator
FROM: Tracy Schaefer, Assistant to the City Administrator
SUBJECT: Telecommunications Commission - 2005 Budget & Goals
MEETING DATE: August 31, 2004
Introduction
Telecommunications Commission has developed a recommended budget and goals for
2005.
Background
Attached are the 2005 Telecommunications goals and objectives that list, in more detail,
other goals like keeping policies up to date and monitoring the INET that do not have a
budget impact. The goals were broken into three main categories: 1) Public Access 2)
Government Access 3) Telecommunications (website, phone system, INET).
PUBLIC ACCESS
The Community Center is currently the home to the public access studio where Shakopee
and Township residents can check out, free of charge, video cameras and video
production equipment and receive assistance and training on how to edit their program
and properly use video equipment. In return for use of this equipment, studio, and
resources, the users submit video productions like Shakopee Football garnes, Derby Days
Parade to be shown on cable channel 15.
In 2005, the Commission recommends spending $27,604 on Public Access:
1) Add a 2nd multi-media computer that can be used for digital editing for volunteers
and part-time city staff and serve as back up for website maintenance and updates.
2) Purchase a second camera for city staffthat can also be used for government
access productions like the election video. Currently, only one camera exists and
is 2 years old and many productions like open houses require more than one
camera.
3) Purchase portable studio equipment. This will replace the 10+-year-old
equipment that is used by volunteers from everything from football to hockey
games. City staff will also be able to use this equipment.
1
GOVERNMENTACCESS
Government Access programming is shown on cable channel 16 to educate and inform
the public about day-to-day activities ofthe city. For example, city council, planning
commission and other meetings are televised live and rebroadcast.
In 2005, the Commission recommends spending $34,000:
1) Replace the remainder of the equipment from the. 2004 City Council Chambers
upgrade. A few pieces were not upgraded, but are now on their "last leg."
2) Install a digital playback system for the government and potentially public access
studios. Currently, city staff is limited to the number ofDVD players to replay
City Council meetings and evening and weekend programming. To stay in line
with Council's goals of increasing public awareness, staff is recommending
purchasing a multi-media server that will allow 24/7 playback and more options
for exciting playback that also results in less staff time as well.
TELECOMMUNICATIONS
With ever changing telecommunications advancements andless general fund money, the
Telecommunications Commission recommends spending more money on general
telecommunications items than in past years. Areas such as phase II of the website,
online Parks & Recreation software for online registration and expanding the !NET to the
new PW building have been top recommendations from the Telecommunications
Commission.
In 2005, the Commission recommends spending $175,500:
1) Complete VOIP (phone system) to Vierling Fire Station.
2) Implement Phase II ofthe website to include Parks & Recreation online
registration, an intranet and more e-commerce applications.
3) Monies were also set aside for new technologies like Wi-Fi and for assistance
from outside consultants. Due to the demanding and changing nature of
telecommunications, the commission felt it was too difficult to know every new
technology application they should take advantage of for the city.
4) A significant sum of money, $75,000, was also set aside to assist the city with
moving forward with video streaming (viewing city meetings on the web) efforts
to allow more than just cable customers to watch city meetings.
5) Funds have been set aside to expand the !NET to the new PW building and
general maintenance and upkeep of the !NET.
6) Add an additional part-time position to assist with either taping of city meetings
or website maintenance.
7) In April, I recommended to the Telecommunications Commission to increase my
salary allocation from $16,000 to $30,000 from the Telecommunications Fund to
cover my time that I spend in the Telecommunications area. However, with my
recent announcement that I will be leaving the city, Mark McNeill and I would
recommend that the amount be changed back to $16,000.
2
Budget Impact
100% of all recommendations from the Telecommunications Commission will be funded
from the Telecommunication Fund, not the General Fund. City staff is estimating with
the recent changes to the cable franchise that the city will receive roughly $185,000 in
revenues. However, the Telecommunications Commission also has a balance of about
$250,000. Some of the balance was a result of staff being extremely conservative in
2004 with spending funds, since we did not know the outcome of the franchise until July
2004.
Staff also established an "equipment replacement fund," where a certain amount is saved
each year for major equipment upgrades like the City Council. The current balance is
$50,000.
Action Requested
Accept the 2005 recommended Telecommunications budget.
3
2005 Goals & Objectives - Telecommunications Commission
Telecommunications
Goal Goal Details Public Benefit Implementation Timeframe
INET Expansion Examine other city More efficient & effective public City Staff time, 2005 Ongoing
facilities for hook-up. service equipment
Like New PW, Parks,
fire substations, etc.
Test INET Mock loss of equipment Public safety & services City staff time, maybe a Winter 2005
Redundancy or power to test backup consultant
sources.
VOIP Fire Station No. Install new VOIP Will be on citywide phone system City staff time and Feb. 2005
51 phones, once fiber is and will have more advance consultant
connected. features to increase public safety
and efficiency.
Extend fiber to new $6 million PW facility Citywide network will continue. Consultant & staff time. 2005/06
Public Works Facility will need to be
connected to the city's
network. It will be
located on the "SPUC
site."
Implement Wi-Fi for Will allow PO, PW and Better customer service Staff time, equipment, Spring 2005
city staff use Building and other city consultant (?)
staff to access city
network while in the
"field." Could purchase
a monthly/yearly plan
from provider
Develop Wireless Wireless technologies The cheapest broadband internet Unknown - Perhaps Unknown
Internet Service are now capable of service available thru the city in involves public-private
available to all broadband delivery at which you live. A great bonus for partnerships in SLA
residents and dial-up prices. living in a particular city. agreements.
businesses city-wide Chaska.net is rolling it
out for residents this
June.
Telecommunications
Goal Goal Details Public Benefit Implementation Timeframe
Purchase laptops for See attached memo Better customer service Staff time, equipment Feb-April 2005
PO squads
Continue Website Phase II with more text 24-7 customer service Staff time, equipment, Ongoing
Expansion (online information and pursue software, consultant and
packets with digital more e-commerce potentially p-t staff
imaging) applications, online city person.
council & commission
meeting packets.
Purchase Park & 24-7 customer service Staff time, equipment, Winter 2005
Recreation Online software
Reg. Software
Webstreaming City Council and City 24-7 customer service Staff, consultants, Ongoing
meetings could be equipment
streamed.
Expand city staff Purchase laptops, Better customer service. Due to Staff time and Ongoing
network notebooks for staff to increase growth and more equipment
use remotely and in the citizens demands, projects from
"field." PD to PW would be more efficient
if we could have laptops in
vehicles and remotely.
Further Expand GIS More applications of More efficient customer service. Staff time, consultant, Ongoing
applications development maps, equipment
etc. Using GIS.
Possible GPS type
units for citv vehicles. .
Surveying Residents Continue to do city Would allow for better decision
via the Web surveys online for items making process for elected,
like business retention appointed officials and city staff.
to gain information for
decision makers.
Telecommunications
Goal Goal Details Public Benefit Implementation Timeframe
Evaluate Telecomm Does our infrastructure Ensuring a better and stable Staff time to research Ongoing
Needs Public support the future? future. current infrastructure.
Evaluate Telecomm Survey Departments for Staff time Ongoing
Needs Gov telecomm needs. c
Inform public of safety Cable channels, press
issues regarding home releases, public safety
VOIP and 911 office
Develop citywide Develop uniform press Better communication and Staff time Summer 2005
communication plan release for public use, information delivery to public.
including streamline citywide policies for
internal city communications needs,
communication with wants and uses.
public
2005 Goals & Objectives - Telecommunications Commission
Public Access
Goal Goal Details Public Benefit Implementation Timeframe
New Portable Studio Convert portable studio 3-camera on-location shoots Research competing Summer 2005
w/remote control to remote-controlled DV can be handled by one models & vendors.
capabilities cameras competent operator Purchase.
New In-Studio Even without new studio Better and more versatile Research competing Spring 2005
Character Generator cameras, new CG is titling/credits for productions models & vendors.
needed for edit suite 1, Purchase.
productions.
Allow for longer Move playback to DVD. Better picture, audio quality, Staff time, equipment Fall 2005
periods of unattended more programming during "off
plavback hours," less stafftime.
Stream Public Access Live streaming of public Non-cable subscribers can be Staff, consultant, Nov. 2005
Channel access videos educated and informed equipment, hiring
throuQh the web. additional staff.
Stream Public Access Put programming on city 24-7 viewing. Encoding computer, Summer 2005
Programs on Web website, with links for server, staff and
plavback. maybe consultant
Test Picture Quality of Test with proper signals, Channel more viewable Staff time???? July 2005, then
uplink from public uplink to the headend ongoing.
access studio and evaluate at Monthly, 1/4Iy.
subscriber point.
Review Public Access Make sure policies Better customer service. Staff time. Spring 2005
Policies reflect technology
chanoes.
Review Grant Include or not include That is the question... is there Staff time Spring 2005
Proaram lorant proqram a public benefit???
Continue Channel Public campaign, similar Increase public education & Staff time, flyers, Ongoing
Awareness to gov. access, to make awareness. some advertisements
viewers aware.
2005 Goals & Objectives - Telecommunications Commission
Government Access
Goal Goal Details Public Benefit Implementation Timeframe
Increase Begin to tape Park & Ree, Increased awareness and Staff time. May need Jan. 2005
Government EAC and maybe EDA education of city business to hire an additional
Programming meetings staff.
Increased Gov. Continue to expand the Increases citizen Staff time ongoing
Programming video library. Include video awareness of city
Library from every dept. services.
Finish Gov. Access MX50 switcher needs to be Current Switcher has no Research competing Jan-05
Upgrade replaced backup and is out of date. models and vendors.
Purchase.
Increase Gov. Put all live commission and Non-cable residents can Live encoding Fall 2005
channel playback council meetings on the stay informed of city computer
web. business
Stream Gov. Implement DVD unattended Ability to see more Unsure ?
Access Programs playback. oroaramminq 24-7.
Develop more :00 meeting Give viewers a guide to Text generator? Fall 2005
consistent hourly announcements, :05 getting info. on the
schedule for text ordinance info., :10 public channel
display safety, :15 park & rec
Increase channel Introduce Q&A, theatre Increased awareness and Staff time. Jan. 2005
awareness style, so people stay and education of city business
watch screens longer.
Test Picture quality Test with proper signals, Makes channel more July 05, then
of uplink from city uplink to head end and viewable ongoing
hall on regular evaluate at a subscriber
basis. point. Monthly - quarterly,
Review Gov. Stay current with latest Better customer service. Staff time Spring 2005
Access Policies technology and make sure
qoals coincide.
Commissioner Produce short video to be Better viewing for Staff time February 2005
Orientation Video given to each new audience and at home
appointee explaining how viewers and "smoother"
to participate in meetings, meetings.