9.d Lakes Area Television 2017 budget
Staff Report
Date of Meeting:
To: City Council
From: Neil Soltis, Administrator
Re: Lakes Area Television 2017 budget
Background: The Forest Lake Cable Commission proposed a 2017 Budget for approval by its members.
The budget and assumptions were agreed by the Board members present at its July 19th meeting. Per
the Joint Powers Agreement, this draft submission is due to the cities on or before August 1st and to
become effective, requires approval by resolution of the City Councils within 45 days or written
objections to the Commission within the 45 day period.
Issue: Should the City Council take action on the 2017 LATV budget
Proposal Details: The budget was prepared based on the renewal of the lease for the existing
facilities for 2 years. Changes from 2016 include an increase in franchise fee revenues, a 50%
increase in revenue from dvd sales, and an increase of equipment purchases from $30,000 in
2016 to $75,000 in 2017. Note that PEG Access fees, which are budgeted at $52,200 f or 2017,
are restricted to be used for equipment purchases. Based on the budget the projected ending
cash balance (excluding a cash reserve of $20,000) will decrease from $111,210 at 12/31/2016
to $78,985 at 12/31/2017.
Options:
1. Approve by resolution the 2017 Lakes Area Television budget
2. Submit written objections to the budget
3. Take no action which by default will give City consent to the budget as proposed by the
LATV Board.
Recommendation: Option 3
1
Neil Soltis
From:Dianne Halfen <dhalfen@midco.net>Sent:Friday, July 29, 2016 2:52 PMTo:Mike Freer; Ben Winnick; Ed Eigner; Richard Weber; Mark Daly; jefflpd@yahoo.com; Jeff Duraine; Ben Winnick; Bill Krebs; Denny Peterson; Chris Ness; Jim Schneider; Dan Lee; Bob HeglandCc:Stev Stegner; Aaron Parrish; Dan Undem; Dave Povolny; cityadministrator@ci.columbus.mn.us; Neil Soltis; r.simonson@ci.scandia.mn.usSubject:FLCC - Proposed Budget 2017Attachments:FLCC Budget.1 - 2017.xlsx
Dear All, Please find attached the Forest Lake Cable Commission proposed 2017 Budget for your approval. The budget and assumptions were agreed by the Board members present at its July 19 th meeting. The FLCC members for each city are able to discuss the details of this budget. I am also available to answer any questions. Per the JPA, this draft submission is due to you on or before August 1st and to become effective, requires approval by resolution of the City Councils within 45 days or written objections to the Commission within the 45 day period. Thanks so much for your time to review! Best Regards, Dianne Halfen, Chairman Forest Lake Cable Commission dhalfen@midco.net H: 651.462.3433 C: 612.978.4344
FOREST LAKE CABLE COMMISSION2017 DRAFT BUDGET - A
FY2014 ACTUAL FY2015 ACTUAL FY2016 BUDGET 6.30.16 ACTUAL % of Budget FY2017 BUDGET-A
DISBURSEMENTS:Acc't # NET WAGES - STAFF 100 $42,476 $41,745 $51,300 $22,476 43.8%$52,070 NET WAGES - EXEC DIRECTOR 101 $13,420 $13,573 $14,100 $6,306 44.7%$14,100 NET WAGES - FILM MAKERS 102 $10,224 $12,383 $14,000 $5,925 42.3%$14,210 NET WAGES - EDITING 103 $0 $0 $3,700 $287 7.8%$1,820 PERA Employee+Employer 121 $10,545 $10,703 $12,200 $5,488 45.0%$12,330 FICA, Medicare, Withholding 122 $21,927 $21,176 $21,000 $9,597 45.7%$21,000 STATE Withholding 125 $3,140 $2,633 $4,100 $1,341 32.7%$3,500 WORKERS COMP INSURANCE 150 $378 $526 $550 $0 0.0%$550Employee Expense Sub-total:$102,110 $102,738 $120,950 $51,419 42.5%$119,579 OFFICE SUPPLIES 200 $1,648 $1,468 $1,500 $497 33.1%$1,500 OPERATING SUPPLIES 210 $1,734 $1,483 $3,200 $1,003 31.3%$2,000 POSTAGE 215 $226 $435 $400 $266 66.5%$550 REPAIR & MAINT SUPPLIES 220 $129 $71 $200 $35 17.3%$200 SMALL TOOLS/MINOR EQUIP 240 $398 $148 $300 $18 6.1%$300Supplies Sub-total:$4,134 $3,605 $5,600 $1,819 32.5%$4,550
AUDITING / ACCOUNTING SERVICES 300 $1,200 $5,500 $8,600 $4,836 56.2%$8,100 MINNESOTA SALES TAX 301 $591 $672 $750 $774 103.2%$875 LEGAL 304 $0 $0 $1,000 $0 0.0%$0 MISCELLANEOUS EXPENSE 305 $327 $30 $500 $20 4.0%$300 TRAINING 310 $50 $480 $600 $0 0.0%$600 INDEP CONTRACTOR-PROD SERVICES $510 $0 $0 $0 $0 TELEPHONE 321 $1,287 $1,267 $700 $284 40.5%$700 INDEP CONTRACTOR-GOVT MTGS 324 $200 $0 $0 $0 $0 MILEAGE, PARKING 331 $170 $226 $250 $43 17.0%$250 PROMOTIONS, MARKETING & WEB 350 $1,061 $1,852 $2,000 $335 16.7%$2,000 GENERAL LIABILITY INSURANCE 361 $2,021 $2,484 $2,700 $2,770 102.6%$2,853 ELECTRIC SERVICE 381 $2,753 $2,703 $3,200 $1,302 40.7%$2,750 REFUSE COLLECTION 384 $314 $326 $350 $163 46.7%$350Operating Expense Sub-total:$10,485 $15,540 $20,650 $10,527 51.0%$18,778 EQUIPMENT REPAIR 404 $47 $34 $200 $0 0.0%$200 BUILDING RENTAL 412 $25,200 $25,200 $25,200 $12,600 50.0%$25,200 DUES & SUBSCRIPTIONS 433 $550 $550 $675 $550 81.5%$675 OFFICE FURNITURE / EQUIP 570 $100 $291 $500 $0 0.0%$500 NEW EQUIPMENT 590 $26,827 $28,337 $30,000 $769 2.6%$75,000 LEASEHOLD IMPROVEMENTS 599 $0 $1,269 $1,000 $0 0.0%$0Facilities / Equip Sub-total:$52,724 $55,680 $57,575 $13,919 24.2%$101,575 REFUNDS AND REIMBURSEMENTS 810 $1,086 $1,041 $1,500 $456 30.4%$1,500 FRANCHISE RESERVE - CASH 800 $0 $10,007 $5,000 $5,000 100.0%$5,000Reserves Sub-total:$1,086 $11,048 $6,500 $5,456 100.0%$6,500TOTAL DISBURSEMENTS:$170,539 $188,611 $211,275 $83,140 118.8%$250,983
REVENUE: DVD SALES 36200 $9,423 $10,859 $9,000 $7,632 84.8%$15,263 GOVERNMENT MEETINGS 36220 $1,200 $0 $0 $650 $0 SPONSORSHIP REVENUE 36235 $1,675 $1,800 $2,000 $500 25.0%$2,000 FL ADDITIONAL FRANCHISE FEES 31812 $6,000 $6,000 $6,000 $0 0.0%$6,000 REFUNDS / REIMBURSEMENT 36240 $87 $238 $250 $335 134.0%$1,000
FRANCHISE FEES 31810 $132,794 $142,755 $138,325 $71,027 51.3%$142,295 ACCESS FEES - PEG 31811 $46,597 $52,550 $52,000 $26,130 50.3%$52,200 INTEREST EARNED 36210 $0 $7 $0 $6 $0TOTAL REVENUE:$197,775 $214,209 $207,575 $106,279 51.2%$218,758Audit Threshhold:$204,000 $207,000 $210,000 est.$213,000CASH BALANCE: (excludes franchise reserve)$89,312 $114,910 $111,210 $138,049 $78,985
7/29/2016 3:49 PM 1
C:\Users\Neil\AppData\Local\Microsoft\Windows\INetCache\Content.Outlook\7XSTDXSR\FLCC Budget 1 - 2017.xlsxBudget-A]