Cable TV Division FY19 Budget Presentation-171-
Cable TV Division
-172-
This page intentionally left blank.
-173-
CABLE TV DIVISION
Budget Highlights
FY 2017
Actual
FY 2018
Budget
FY 2019
Requested
% Change
From FY 2018
Budget
Expenses
Employee Expense 212,804 221,241 222,015 0.3%
Supplies and Services 26,525 79,048 55,857 -29.3%
Machinery and Equipment 19,789 15,000 15,000 0.0%
Legal Services —573 —0.0%
Total Cable TV Division Budget 259,118 315,862 292,872 -7.3%
Public Information Office 244,790 291,334 294,056 0.9%
Total Expenses 503,908 607,196 586,928 -3.3%
Resources
Franchise Fees & Misc. Rev 583,125 595,983 577,884 -3.0%
Annual Operating Balance 79,217 (11,213)(9,044)2,169
Beginning Cash Balance 423,994 503,211 491,998
Ending Cash Balance 503,211 491,998 482,954
Personnel - Authorized FTE 2.25 2.25 2.25
Improvement Package Summary
1 of 2
This improvement package provides for the addition of a full-time Video Producer (GE-30A) at 40 hours
per week (2,080 hours annually). A second Video Producer in the Cable TV Division will result in an
increased level of original local programming on CityChannel Dubuque. The Cable TV Division has
reached the limit of the amount of video production two people can generate. As a result, opportunities
to produce programming to inform the public are lost. In addition, the Cable TV Division is increasingly
being asked to document City projects and produce videos for purposes other than airing on the
government’s cable access channel. A second Video Producer also provides much-needed backup, so
vacation, ill-health, and injury will not have such an adverse effect on our day-to-day operations and
program output. This position will primarily work afternoons and evenings, enabling the Cable TV
Division to record video and events without occurring overtime costs. Because the Cable TV Division
partners with other City departments and divisions, our work supports most of the Council’s goals and
priorities. We primarily support the Sustainability Principle of Community Knowledge. The additional
programming generated by a second video producer will only enable us to be able to present more
information to residents. Non-recurring items include computer, advertising for the position and office
supplies.
-174-
Related Cost:$69,912 Tax Funds Recurring Recommend - No
Related Cost:$2,936 Tax Funds Non-Recurring
Total Cost:$72,848
Property Tax Impact:$0.0291 0.27%
Activity: Cable TV Division
2 of 2
This improvement package provides for non-live closed captioning of select CityChannel Dubuque
programming which will make many of the city’s locally produced programs accessible to the hearing
impaired. In a work flow that can be accommodated by a two-person department, on-air programs,
DVDs, and online video archives will be captioned for display on viewers’ TV screens and computers.
City Council meetings will be captioned at more expensive rush rates; other locally produced programs
will be subject to standard rates. Although transcription/caption charges are expensive, the ongoing
availability of online archives and captioned DVDs helps justify the cost beyond captioning that could be
viewed only on the City’s government cable access channel. Nonrecurring cost includes the purchase
of software.
Related Cost:$27,400 Tax Funds Recurring Recommend - No
Related Cost:$5,000 Tax Funds Non-Recurring
Total Cost:$32,400
Property Tax Impact:$0.013 0.12%
Activity: Cable TV Division
Significant Line Items
Employee Expense
1. FY 2019 employee expense reflects a 1.5% wage package increase.
2. The Iowa Public Employee Retirement System (IPERS) City contribution increased from 8.93%
in FY 2018 to 9.44% in FY 2019. This resulted in an increase of City IPERS expense of $777 in
the Cable TV Division. The employee contribution increased from 5.95% in FY 2018 to 6.29% in
FY 2019.
3. The City portion of health insurance expense decreased from $1,325 in FY 2018 to $1,193 in FY
2019 per month per contract which results in annual cost savings of -$3,180 or -10.00%.
4. Overtime expense is unchanged from $4,000 in FY 2018 to $4,000 in FY 2019. FY 2017 Actual
was $3,636.
Supplies & Services
5. Legal Services is decreased from $25,000 in FY 2018 to $5,000 in FY 2019. This line item
represents outside legal services used for potential telecommunication issues.
-175-
6. Internet Services increased from $17,046 in FY 2017 to $17,904 in FY 2019 based on a 5%
increase. This line item represents encoding, hosting online content and live streaming for City
Council meetings on the City's website through Granicus. In addition, it includes making the
online content mobile device friendly and providing the live stream in high-definition.
7. Consultant Services is unchanged from $5,000 in FY 2018 to $5,000 in FY 2019. This line item
represents consultant services required for engineering or drone oversight, operation and
training.
Machinery & Equipment
8. Purchase of equipment for FY 2019 includes:
$15,000 for replacement of the TV production and transmission equipment, audiovisual
equipment and computer equipment.
Revenue
9. Franchise fee revenue decreased from $593,000 in FY 2018 to $575,000 in FY 2019 based on
year-to-date receipts of $284,759 and FY 2017 actual of $580,420.
-176-
This page intentionally left blank.
-177-
PUBLIC INFORMATION OFFICE
CABLE TV DIVISION
The Cable TV Division embraces the Sustainability Principle of Community Knowledge by
producing video programs on City initiatives for distribution to the community via the local
government access cable channels or the City’s website. The Cable TV Division also supports
the local access community through coordination of the various access origination sites and
working with the Cable TV Commission to disseminate funding through the Capital Grant for
Access Equipment and Facilities. The Cable TV Division also acts as a liaison between local
cable subscribers and the cable company.
SUCCESS IS ABOUT PLANNING, PARTNERSHIPS AND PEOPLE
LEADING TO OUTCOMES
-178-
PUBLIC INFORMATION OFFICE
CABLE TV DIVISION
Cable TV is supported by 2.25 full-time equivalent employees, which accounts for 75.81% of the
department expense as seen below. Overall, the departments’ expenses are expected to decrease by
-7.28% in FY 2019 compared to FY 2018.
Expenditures by Category by Fiscal Year
-179-
PUBLIC INFORMATION OFFICE
CABLE TV DIVISION
Overview
The Cable TV Division operates two local government access channels available to local cable
subscribers. The primary channel, CityChannel Dubuque, is also streamed live to the Internet
via the City’s website.
Besides providing coverage of City Council, Zoning Advisory Commission, and County Board
of Supervisors meetings, CityChannel Dubuque produces a variety of informational and
cultural programming about local government and Dubuque.
CityChannel Graphics provides 24/7 access to the graphic
announcements seen in between scheduled video programs on
CityChannel Dubuque, including frequently updated weather
information and important announcements such as winter parking
restrictions. The audio for this channel is a feed from NOAA weather
radio station WXL64 serving Dubuque, providing round-the-clock
weather information and severe weather alerts.
Both channels are based in the TV Control Room at City Hall Annex with digital editing facilities
and automated playback of programming. In addition, the Media Room at the Historic Federal
Building houses a production facility for broadcasting live meetings and a small studio for
recording interviews and announcements
The Cable TV Division acts as a liaison between the Cable Company and local cable
subscribers. It works with the Cable TV Commission to oversee requests for funding from the
Capital Grant for Access Equipment and Facilities to provide local organizations with
equipment with which to produce programming for the local community. The Cable TV Division
also monitors legal and regulatory matters pertaining to telecommunications that may impact
the community.
Position Summary
FY 2019
Cable Television Coordinator 1.00
Video Producer 1.00
Intern Video Producer 0.25
Total FT Equivalent Employees 2.25
-180-
PUBLIC INFORMATION OFFICE
CABLE TV DIVISION
Highlights of the Past Year
• HD Facilities/Digital Delivery. With the April 2017 installation of the new wide
projector screen in the City Council Chambers, the Cable TV Division completed the
three-year upgrade to be able to originate all productions in high definition (HD) and
deliver the two city channels digitally to cable subscribers in Dubuque. In September
2016 the four public, educational, and governmental (PEG) access origination sites
replaced their old analog modulators with new encoders to send true digital signals to
the cable company’s head for delivery to local cable subscribers. This upgrade
significantly improved the quality of the pictures and sound.
• Drone Implementation. The Cable TV
Division is working with UASolutions Group,
an aviation consultant, to get the City of
Dubuque properly certified to fly drones under
a public Certificate of Authority (COA) and
under new Federal regulations for using
drones (Part 107). In September 2017,
employees of the Cable TV Division, the
Police and Fire Departments, Engineering,
and the City’s Senior Counsel received two
days of ground-school training to pass the
Federal Aviation Administration’s (FAA) Part
107 exam. In the ensuing weeks many of
these employees took and passed that exam
and received their remote pilot certificates. As
of November 2017, those employees holding
such certificates are able to fly drones for City
business. Authority from the FAA to fly under
the public COA is pending.
Ground-school training for FAA Part 107 exam
•
• Monthly Construction Updates. The Cable TV Division continued to produce monthly
construction updates for the Bee Branch Watershed Flood Mitigation Project and the
Southwest Arterial/US52 Project. Bee Branch updates ended with the opening of the
Upper Bee Branch Creek Greenway in July 2017. Southwest Arterial updates continued
through November 2017 when work went on hiatus for the winter months.
• Equipment Upgrades. In FY 2017 the Cable TV Division replaced its two editing
systems to powerful new computers that have
-181-
PUBLIC INFORMATION OFFICE
CABLE TV DIVISION
Future Initiatives
• Best Use of PEG Channel Capacity. Mediacom’s state franchise to provide cable
service in Dubuque calls for five PEG channels. We will continue to work with the Cable
TV Commission to ensure that these are being used in the best possible way to serve
the community.
• The Sunset of the Capital Grant for Access Equipment & Facilities. As the end of
the term of Mediacom’s first state franchise for Dubuque approaches, we will look to
maximize the benefit of the funding we receive.
• Supporting City Council Goals & Priorities. By airing City Council meetings,
recording civic events, and producing programs that help City departments tell their
stories, we will continue to support City Council goals & priorities by helping keep the
community informed about what’s happening in City government.
Performance Measures
Cable TV - Activity Statement
Provide information on City services and initiatives to citizens and visitors to Dubuque through
local cable access and the internet and remain current on legal and regulatory trends in
telecommunications.
Goal: Experiences and Activities
Outcome #1: Remain a key source of information regarding City initiatives to citizens
and visitors by producing programs distributed through the City’s government access
cable channel, featured videos and online video archives.
Produced in FY 2017:
43 City Council meetings
9 Zoning Advisory Commission meetings
9 Civic events (Parades, groundbreakings,
ribbon cuttings, awards ceremonies, the State
of the City Address, and other events)
Numerous short videos, promos, and public
service announcements to inform and inspire
local residentsNumerous short videos,
promos, and public service announcements to
inform and inspire local residents
Bee Branch Creek Greenway
Celebration
Various programs in partnership with other City departments & divisions to help tell their
stories.
Programs in partnership with community organizations, such as the League of Women
Voters candidate forums.
-182-
PUBLIC INFORMATION OFFICE
CABLE TV DIVISION
Recycling PSA
To view a listing of all videos follow the link
below to the Cable TV website and click on
Videos
www.cityofdubuque.org/media
Maximize the City’s cable channels as key sources of information about the City.
CityChannel Dubuque and CityChannel Graphics run 24 hours a day, seven days a week on the cable
system in Dubuque and is streamed live on the City’s website. To keep people tuning in, there must be
fresh programming and information.
CityChannel Graphics utilizes a bulletin board graphics
system that cycles through a series of City-related
announcements with a background of NOAA weather
radio station audio. These same graphics are seen in
between programs on CityChannel Dubuque:
Commission meeting notices
Holiday closings
Road construction notices
Library events
Public meetings
Winter parking restrictions
CityChannel Graphics
Program guide – CityChannel Dubuque program
listings are automated and update every 10
minutes to show upcoming programs.
Downtown weather data – This information comes
from a weather station atop City Hall Annex with
new data displayed on the air every five minutes,
resulting in more than 100,000 notices per year.
-183-
PUBLIC INFORMATION OFFICE
CABLE TV DIVISION
DID YOU KNOW?
Weather data from the City Hall Annex weather station is also available online at
www.wunderground.com? Since October 2011 this data has been uploaded every couple of minutes,
creating a valuable and informative data archive.
Goal: Connected Community
Use the City’s website as a means of extending CityChannel Dubuque and the City’s
video programs to non-cable subscribers as well as a worldwide audience.
The online streaming upgrade to include mobile devices continues to pay dividends as more
and more people are accessing our videos on devices other than computers. In FY 17 we
had:
36,922 total page views
15,133 total visits
14,015 total unique visitors
Access breakdown: 52% desktop, 48% mobile
Supporting the Sustainability Principle of Community Knowledge
With Community Knowledge as our mission, the ultimate outcome is an informed citizenry.
Through our on-air programming and online archives, we are a prime source of information for
city residents about many issues that affect them directly. Secondarily, we hope to foster a
small amount of civic pride as we attempt to showcase some of the reasons why Dubuque is
such a great place to live, work, and raise a family. CityChannel Dubuque is the best place to
see Dubuque on television.
Flashing yellow light education campaign
-184-
PUBLIC INFORMATION OFFICE
CABLE TV DIVISION
Outcome #2: Facilitate the production of local access programming by working with the
Cable TV Commission to distribute funds to local non-profit organizations through the
Capital Grant for Access Equipment and Facilities.
The City’s 2005 municipal cable television franchise agreement with Mediacom calls for an annual
grant program to purchase equipment with which to produce local public, educational, and
governmental programming. Qualified organizations – those with a principal place of business within
City limits or a principal regular meeting place within City limits – may apply for funding from this
program.
In FY2017, $316,758 was distributed to purchase equipment for the following organizations:
HD equipment for the Historic Federal Building City Council meetings
Video storage for the Cable TV Division
Digital routing equipment for the PEG origination facilities at Loras College & Dubuque
Community Schools.
-185-
Recommended Operating Revenue Budget - Department Total
75 - CABLE TV DIVISION
Fund Account Account Title
FY16 Actual
Revenue
FY17 Actual
Revenue
FY18 Adopted
Budget
FY19 Recomm'd
Budget
290 42350 CABLE FRANCHISE FEE 591,784 580,420 593,000 575,000
42 - LICENSES AND PERMITS 591,784 580,420 593,000 575,000
290 43110 INVESTMENT EARNINGS 2,623 2,485 2,600 2,485
290 43234 RENT, FIBER HUB W 3RD 300 0 300 300
43 - USE OF MONEY AND PROPERTY 2,923 2,485 2,900 2,785
290 53605 MISCELLANEOUS REVENUE 30 170 50 50
290 53620 REIMBURSEMENTS-GENERAL 33 49 33 49
53 - MISCELLANEOUS 63 219 83 99
75 - CABLE TV DIVISION TOTAL 594,770 583,124 595,983 577,884
-186-
Recommended Operating Expenditure Budget - Department Total
75 - CABLE TV DIVISION
Fund Account Account Title
FY16 Actual
Expense
FY17 Actual
Expense
FY18 Adopted
Budget
FY 19 Recomm'd
Budget
290 61010 FULL-TIME EMPLOYEES 145,892 151,749 151,682 154,512
290 61030 SEASONAL EMPLOYEES 0 0 6,536 6,635
290 61050 OVERTIME PAY 3,339 3,636 4,000 4,000
290 61071 HOLIDAY PAY-OVERTIME 105 0 0 0
290 61310 IPERS 13,336 13,876 13,902 14,964
290 61320 SOCIAL SECURITY 10,627 11,025 12,410 12,634
290 61410 HEALTH INSURANCE 32,275 31,800 31,800 28,620
290 61415 WORKMENS' COMPENSATION 575 589 608 520
290 61416 LIFE INSURANCE 129 129 303 130
61 - WAGES AND BENEFITS 206,278 212,804 221,241 222,015
290 62010 OFFICE SUPPLIES 1,393 1,414 1,421 1,414
290 62030 POSTAGE AND SHIPPING 104 19 104 71
290 62061 DP EQUIP. MAINT CONTRACTS 3,859 3,997 4,166 4,530
290 62090 PRINTING & BINDING 0 0 250 250
290 62110 COPYING/REPRODUCTION 21 50 21 50
290 62130 LEGAL NOTICES & ADS 0 0 400 0
290 62140 PROMOTION 0 195 195 195
290 62170 SUBSCRIPTIONS-BOOKS-MAPS 0 0 2,500 2,500
290 62190 DUES & MEMBERSHIPS 705 730 719 730
290 62206 PROPERTY INSURANCE 4,595 3,883 4,003 386
290 62208 GENERAL LIABILITY INSURAN 1,514 1,550 1,626 1,431
290 62212 TECH/OTHER EQUIP INSURANC 0 0 0 750
290 62310 TRAVEL-CONFERENCES 0 0 2,000 2,000
290 62320 TRAVEL-CITY BUSINESS 0 0 200 200
290 62340 MILEAGE/LOCAL TRANSP 0 0 100 100
290 62360 EDUCATION & TRAINING 400 280 2,500 2,500
290 62420 INET EXPENSE 0 1,500 2,500 1,500
290 62421 TELEPHONE 1,217 1,375 1,224 1,375
290 62436 RENTAL OF SPACE 801 948 817 948
290 62511 FUEL, MOTOR VEHICLE 413 482 413 492
290 62521 MOTOR VEHICLE MAINT.689 289 703 295
290 62528 MOTOR VEH. MAINT. OUTSOUR 0 0 100 100
290 62611 MACH/EQUIP MAINTENANCE 0 139 500 500
290 62659 LIBRARY VIDEO MATERIALS 160 600 1,500 1,000
290 62663 SOFTWARE LICENSE EXP 42 51 1,243 1,843
290 62664 LICENSE/PERMIT FEES 1,271 1,293 1,297 1,293
290 62667 INTERNET SERVICES 21,580 7,730 17,046 17,904
290 62713 LEGAL SERVICES 5,000 0 25,000 5,000
290 62716 CONSULTANT SERVICES 0 0 5,000 5,000
290 62747 MACH/EQUIPMENT RENTAL 0 0 1,500 1,500
62 - SUPPLIES AND SERVICES 43,764 26,525 79,048 55,857
290 71123 SOFTWARE 117 430 0 0
290 71124 MICRO-COMPUTER 0 3,094 0 0
290 71312 VAN/PICKUP/WAG REPL 0 300 0 0
290 72412 CABLE TV RELATED EQUIP 20,636 15,603 15,000 15,000
290 72418 TELEPHONE RELATED 0 362 0 0
71 - EQUIPMENT 20,753 19,789 15,000 15,000
290 91100 TO GENERAL 573 0 573 0
91 - TRANSFER TO 573 0 573 0
75 - CABLE TV DIVISION TOTAL 271,368 259,118 315,862 292,872
-187-
Recommended Expenditure Budget Report by Activity & Funding Source
75 - CABLE TV DIVISION
CABLE TV - 75100
FUNDING SOURCE: CABLE TV
Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget
EQUIPMENT 19,789 15,000 15,000
SUPPLIES AND SERVICES 26,525 79,048 55,857
TRANSFER TO —573 —
WAGES AND BENEFITS 212,804 221,241 222,015
CABLE TV 259,118 315,862 292,872
CABLE TV DIVISION TOTAL $259,118.02 $315,862.00 $292,872.00
-188-
C I T Y O F D U B U Q U E , I O W A
DEPARTMENT DETAIL - PERSONNEL COMPLEMENT
75 CABLE TV
FY 2017 FY 2018 FY 2019
FD JC WP-GR JOB CLASS FTE BUDGET FTE BUDGET FTE BUDGET
61010 Full Time Employee Expense
290 8300 GE-37 CABLE TELEVISION COORDINATOR 1.00 $88,299 1.00 $90,076 1.00 $91,971
290 8725 GE-30 VIDEO PRODUCER 1.00 $60,630 1.00 $61,606 1.00 $62,541
TOTAL FULL TIME EMPLOYEES 2.00 $148,929 2.00 $151,682 2.00 $154,512
61030 Seasonal Employee Expense
290 2875 NA-38 INTERN VIDEO PRODUCER 0.25 $6,562 0.25 $6,536 0.25 $6,635
TOTAL SEASONAL EMPLOYEES 0.25 $6,562 0.25 $6,536 0.25 $6,635
TOTAL CABLE TV 2.25 $155,491 2.25 $158,218 2.25 $161,147
-189-
CITY OF DUBUQUE, IOWA
ACTIVITY PERSONNEL COMPLEMENT SUMMARY
FY 2017 FY 2018 FY 2019
ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET
Cable TV-FT
29075100 61010 290 8300 GE-37
CABLE FRANCHISE
COORDINATOR 1.00 $88,299 1.00 $90,076 1.00 $91,971
29075100 61010 290 8725 GE-30 VIDEO PRODUCTION ASSISTANT 1.00 $60,630 1.00 $61,606 1.00 $62,541
Total 2.00 $148,929 2.00 $151,682 2.00 $154,512
Cable TV-Seasonal
29075100 61030 290 2875 NA-38 INTERN VIDEO PRODUCER 0.25 $6,562 0.25 $6,536 0.25 $6,635
Total 0.25 $6,562 0.25 $6,536 0.25 $6,635
TOTAL CABLE TV DIVISION 2.25 $155,491 2.25 $158,218 2.25 $161,147
-190-
This page intentionally left blank.
Copyrighted
February 7, 2018
City of Dubuque Public Hearings # 5.
IT EM T IT LE:Cable TV Division FY2019 Budget Presentation
SUM MARY:
SUGGEST ED DISPOSIT ION: