Loading...
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: