The URL can be used to link to this page

Home My WebLink About3.C. Telecommuniations (Wilson) :3 A~~. . CITY OF SHAKOPEE 2007 TELECOMMUNICATION FUND BUDGET DIVISION: ADMINISTRATION - TELECOMMUNICATIONS MISSION STATEMENT: The mission of the Telecommunications Division is to study issues and recommend solutions to the City Council relating to the provision of telecommunication services for the City, residents, and businesses of Shako pee and to guide the operation of the City's Government and Public Access Television Channels. ACTIVITY: Telecommunications activities include: conducting and recommending ordinance changes to the city council, renewal and franchising, recommending a budget to the City Council, providing advice to the City Council on new telecommunication developments, INET oversight and development, and PEG channel and studio operation and direction. GOALS: 1. Utilize telecommunications to communicate city activities to residents 2. Continue research of city offered high speed internet 3. Continue to work with City Departments, increasing and improving on technology 4. Continue improving quality and scope of Government Access programming 5. Increase and improve Local-Origination programming for Public Access 6. Continue to improve Cable Studio and its functionality OBJECT DESCRIPTION: Description ofline items: Wages & Benefits: Telecommunications Coordinator, Share of Assistant to the City Administrator, Share ofIT Personnel, PT Cable Technician(s), Benefits and Taxes Supplies: Online Streaming of Gov Access Programming ($30,000), Video editing computers and software ($10,000), Research & Development Fund ($20,000), Wireless & Roundtable Microphones ($6,000) Cameras for Public Access Users ($8,000), Studio Improvements ($8,000), Studio & Office Supplies ($2,000) Professional Services: Legal counsel $5,000,High Speed Internet Research $40,000, I.,.net consultant and maintenance $20,000 Communications: Printing and Publishing $1,500, Advertising $3,000 Rent: Community Center $12,000, City Hall and Administrative Support $5,400 Dues, Training, Traveling: $2,000 MACTA & NAOTA membership, $4,500 for MACTA and NATOA conference registrations and other staff training, $1,500 for travel for 2 individuals to NA TOA Annual Conference R5509BUD LOGIS005 CITY OF SHAKO PEE 8/10/2006 11:48:01 Budget Report Page - 1 Fiscal Period: 6 / 06 Level Of Rollup 7 2003 2004 2005 6/30/2006 2006 2007 2007 2007 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 02150 TELECOMMUNICATION 12 CITY ADMINISTRATOR 6000 EXPENDITURES 6001 WAGES & BENEFITS 6002 WAGES 42,254 47,839 38,117 21,517 55,130 59,420 59,420 59,420 6005 OVERTIME-FT 233 6015 WAGES - PART TIMElTEMP 4,679 4,862 9,691 4,975 10,500 15,600 15,600 15,600 6002 WAGES 47,165 52,701 47,808 26,492 65,630 75,020 75,020 75,020 6100 BENEFITS 6122 PERA 2,608 2,914 2,462 1,544 3,940 4,690 4,690 4,690 6124 FICA 3,608 4,028 3,625 2,007 5,020 5,740 5,740 5,740 6135 HEALTH 4,121 4,981 3,495 2,730 5,920 4,580 4,580 4,580 6139 POST EMPLOYMENT HEALTH PLAN 349 371 262 139 300 300 300 300 6140 L1FElLTD 212 241 169 104 270 270 270 270 6145 DENTAL 391 415 270 170 480 540 540 540 6160 UNEMPLOYMENT 9,698 200 200 200 6170 WORKERS COMPENSATION 150 107 116 149 200 1,500 1,500 1,500 6180 COMPENSATED ABSENCES 246 1,325 317- 2,000 6100 BENEFITS 11,684 14,383 19,780 6,843 18,130 17,820 17 ,820 17,820 6001 WAGES & BENEFITS 58,849 67,084 67,587 33,335 83,760 92,840 92,840 92,840 6200 SUPPLIES AND SERVICES 6201 SUPPLIES & SERVICES 6202 OPERATING SUPPLIES 10,126 26,609 8,902 7,907 36,800 98,700 98,700 98,700 6210 OFFICE SUPPLIES 2,191 11,050 3,484 127 2,000 2,000 2,000 6240 EQUIPMENT MAINTENANCE 1,500 1,500 1,500 1,500 6201 SUPPLIES & SERVICES 12,317 37,659 12,386 8,034 38,300 102,200 102,200 102,200 6300 PROFESSIONAL SERVICES 631.0 ATTORNEY 8,671 7,647 2,611 774 5,000 5,000 5,000 5,000 6314 COMPUTER SERVICES 3,220 384 6316 EQUIPMENT MAINTENANCE 305 99 191 417 6327 OTHER PROF SERVICES 71,319 25,510 67,262 7,001 48,000 60,000 60,000 60,000 6300 PROFESSIONAL SERVICES 80,295 36,476 70,449 8,192 53,000 65,000 65,000 65,000 6330 COMMUNICATIONS 6332 POSTAGE 30 22 100 100 100 100 6334 TELEPHONE 185 190 100 100 100 100 R5509BUD LOGIS005 CITY OF SHAKO PEE 8/10/2006 11:48:01 Fiscal Period: 6 / 06 Budget Report Page - 2 Level Of Rollup 7 2003 2004 2005 6/30/2006 2006 2007 2007 2007 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 6336 PRINTING/PUBLlSHING 128 131 229 753 1,500 1,500 1,500 1,500 6338 ADVERTISING 853 3,000 3,000 3,000 3,000 6330 COMMUNICATIONS 343 321 1,105 753 4,700 4,700 4,700 4,700 6350 INSURANCE 6352 LIABILITY 2,024 1,556 1,966 2,122 1,600 2,400 2,400 2,400 6350 INSURANCE 2,024 1,556 1,966 2,122 1,600 2.400 2,400 2,400 6400 RENTALS 6430 BUilDING RENT (IS FUND) 17,400 6435 OTHER RENT 12,000 12,000 17,400 17,400 17,400 6400 RENTALS 12,000 12,000 17,400 17,400 17,400 17,400 6470 DUESITRAININGITRAVEl 6472 CONFERENCElSCHOOUTRAINING 605 295 680 1,200 4,500 4,500 4,500 6475 TRAVEUSUBSISTENCE 235 227 400 133 800 1,500 1,500 1,500 6480 DUES 1,365 1,710 1,735 1,735 1,400 2,000 2,000 2,000 6470 DUESITRAININGITRAVEL 2,205 2,232 2,815 1,868 3,400 8,000 8,000 8,000 6200 SUPPLIES AND SERVICES 97,183 90,246 100,721 20,968 118,400 199,700 199,700 199,700 6500 DEPRECIATION 6600 MISCELLANEOUS 6700 CAPITAL OUTLAY 6740 EQUIPMENT 122,511 61,706 13,916 68,119 187,600 6700 CAPITAL OUTLAY 122,511 61,706 13,916 68,119 187,600 6800 DEBT SERVICE 6000 EXPENDITURES 278,543 219,036 182,224 122,421 389,760 292,540 292,540 292,540 12 CITY ADMINISTRATOR 278,543 219,036 182,224 122,421 389,760 292,540 292,540 292,540 02150 TELECOMMUNICATION 278,543 219,036 182,224 122,421 389,760 292,540 292,540 292,540 CITY OF SHAKOPEE TELECOMMUNICATIONS FUND 2007 BUDGET TELECOMMUNICATIONS FUND BUDGET SUMMARY 2004 2005 2006 2007 Actual Actual Proposed Proposed Revenue Taxes $ - $ - $ - $ - Licenses and Permits 255,350 279,897 250,000 300,000 Intergovernmental Charges for Service Interest 8,118 10,536 8,000 8,000 Miscellaneous 454 420 Total Revenue 263,922 290,853 258,000 308,000 Expenditures Personal Services 67,084 67,587 83760 92,840 Supplies & Services 90,246 100,721 118400 199,700 Capital Equipment 61,706 13,916 187600 - Total Expenditures 219,036 182,224 389,760 292,540 Excess (Deficiency) Of Revenues over Expenditures 44,886 108,629 (131,760) 15,460 Transfers Out (6,500) Excess (Deficiency) Of Revenues over Expenditures & Transfers 44,886 108,629 (131,760) 8,960 Fund Balance December 31 $ 357,146 $ 465,775 $ 334,015 $ 342,975 Telecommunications 2007 Budget 2150 2151 Object # Description Benefits Management Total 6002 Wages FT - Reg. 59,420 59,420 6005 Wages OT - Reg. - 6015 Wages PT/Temp 15,600 15,600 6122 PERA 4,690 4,690 6124 FICA 5,740 5,740 6135 Health 4,580 4,580 6139 PEHP 300 300 6140 Life/L TD 270 270 6145 Dental 540 540 6170 Workers Comp 200 200 6180 Compensated Absences 1,500 1,500 6190 Retirement Benefit - Total Personnel - 92,840 92,840 6202 Operating Supplies 98,700 98,700 6210 Office Supplies 2,000 2,000 6240 Equipment Maintenance 1,500 1,500 6300 Professional Services - 6310 Attorney 5,000 5,000 6327 Other Prof Services 60,000 60,000 6332 Postage 100 100 6334 Telephone 100 100 6336 Printing/Publishing 1,500 1,500 6338 Advertising 3,000 3,000 6352 Liability Insurance 2,400 2,400 6400 Rentals - 6420 Equipment Rent - 6430 Building Rent (IS FUND) - 6435 Other Rent 17,400 17,400 6472 Conf / School/ Training 4,500 4,500 6475 Travel/Subsistence 1,500 1,500 6480 Dues 2,000 2,000 6490 Subscriptions/Publications - Total Supplies & Services - 199,700 199,700 6740 Capital Expenditures - Total $ - $ 292,540 $ 292,540 2007 BUDGET Est. 2007 Pay 2007 With COL Inc Title/Description Step 3.0% FICA PERA Telecom Coordinator 0 $ 48,915 $ 3,742 $ 3,057 Cable Tech - PT 5,100 390 319 Cable Tech - PT 10,500 803 656 Charge in Administration N/A 5,500 421 344 Charge in IT N/A 5,000 383 313 Total Telecommunications $ 75,015 $ 5,739 $ 4,689