Trent Radio Yearend 1999 Budget Presentation - prepared 14Sep98 / jkm with bat Mission The provision of radio production equipment and related training, direction and facilities in support of radio programming activities and programmer development. And, general support for the artistic, research and administrative activities by those involved in the organisation. In carrying out that mission the following responsibilities are performed: The operation and maintenance of 715 George Street which houses, an archive, two radio studios, associated meeting areas, offices, storage facilities, and a revenue producing residential rental apartment. The operation and maintenance of a licenced 250 watt radio transmission facility at Television Road. The provision of salaried and contracted programming personnel with the specific charge to provide direction, support, and inspiration to volunteer programmers. Caveat: This budget relies upon new monies from an increase in brokered programming (from 30mins per day to a full hour). While indications are good there is no guarantee that this will happen. Recommendation: That the Board approve this budget subject to review in December 1999. Overview: This budget reflects on-going and project priorities established over the last three years, as well as moving towards making things manageable without resort to lay-offs. a) the purchase of a new transmitter and related equipment - $22,000 in 1997 with loan payments of $5,000 this year b) the purchase 715 George Street - mortgage payments of $5,400 this year c) the establishment of a Spoken Word Archive - $4,500 (OWSP) labour & other costs d) the production of exceptional Radio Drama pursuant to seeking future funding - $2,500 for scripts, direction and production e) production and distribution of publicity (Trout Rodeo & guides) - $750 f) support for the development of radio art pursuant to seeking future funding - $750 g) support of the Radio Salon series to promote the power and potential of radio - $500 h) on-going maintenance of the music archive - $800 i) general on-going programme direction - $29,000 j) general day-today administrative and technical direction and support - $22,500 k) related office, building & technical overhead - $16,500 Detailed explanation of Line Items - see attached; Revenue - Grants 99Proj 1998 409 Federal Grants (SCP) 8,220 3,836 Estimate for the Summer of '99 30wks @ $6.85/hr 416 Provincial Grants (OWSP) 5,000 Actual award. Represents 75% share of wage and benefit expense 418 Municipal Grants The City has provided some project funding to local groups for non-operational projects. Revenue - Donations 422 - 427 This has yielded up to $750 is past years, and could be investigated further $250 Revenue - Memberships 431 Trent Student Memberships 55,575 56,415 Reflects an anticipated decline of 1.5% 433 Commercial & Non-profit 300 300 434 Individual Memberships 800 800 Represents 5 NPOs and 40 Individual members 441 Special Events 1,250 1,251 2 Casino Rama Trips & a Radio Marathon 444 Fundraising Net 300 147 Sale of T-Shirts and Postcards Revenue - Earned 463 ON AIR Sponsorship Net 4,000 4,698 This conservative estimate reflects a change in personnel 465 "RADIO PAPER" Advertising 250 0 An untapped resource 469 Net Other Sponsorship 14,190 5,903 Brokered programming - anticipated going from 30mins to a full hour on 1st Jan 1999. WARNING: This is not a done deal, see recommendation below. 470 Tape Sales 240 0 The sale of cassette tape is to be controlled with limited inventory and a locked cash box in the Operators room 475 Rental Income 6,079 5,964 Shows a rent increase of 2.9% (to $512/month) commencing 1st Jan 1999 477 Net Misc Sales & Services 500 650 In 1998: March $450 & TSW usage $200 Expense - Regular Staff 501 PD Salary & Benefit 19,434 17,126 This represents a forty week contract with an increase for the provision of a self directed health and pension benefit. 507 Admin Salary & Benefit 19,601 14,961 517 GM Contract 1,200 1,680 This represents 34wks of regular salary (was 26wks in 98) with a 2.5% overall increase & 16wks honorarium @ $75wk Expense - Contract & Grant Personnel 501 SCP - Salary & Benefit 10,272 4,237 The amount shown for 1999 shows a wage of $8/hr. HRDC has indicated they will give more merit to applications which pay more than the $6.85 SCP subsidy. TRadio's share is $2,050 512 PD Support 0 750 Support for the PD during the first weeks of the Fall Season. Covered by OWSP in 1999 512 RDrama Total 1,750 1,575 Same as 1998 with a little more for paid post-production work. A $250 honoraium was paid in recognition of about 250 hours work in 1998. 512 RArtist Total 750 0 New initiative: $500 fee + $250 artistic expense 512 RSalons Total 500 150 Fees for guest seminar leaders 512 RDay Fees 200 75 four radio days with a $50 honorarium. 512 RHistorian 600 600 Jeff Stewart 512 OWSP Burden 6,666 3,816 Total cost of OWSP work. TRadio's share is $1,666, see Provincial grants above 517 Bookkeeping 500 500 Same as 1998 Expense - Supply & Overhead 536 Publicity & Promotions 500 213 Provision for publication of "Trout Rodeo", operational and self-help guides, and other "literature" 548 Equipment Rental 100 0 Provision for renting technical equipment 550 Line Rental 1,250 1,461 Broadcast lines to CHEX the alarm signal line has been replaced 552 Rental Other 60 30 Public Library Orientation Sessions 554 Postage & Delivery 550 441 Postage and e-mail accounts 556 Office Supplies 500 460 558 Telephone 1,800 1,756 3 telephone lines 560 Utilities 3,000 3,054 PUC and Consumers Gas 562 Programming & Licence 1,750 1,547 SOCAN Licencing Fee and programme acquisition costs 564 Building R & M 750 1,594 566 Building R & M Upper Apt 750 0 Installation of replacement storm window & other maintenance. 568 Technical R & M 1,000 1,530 Regular and annual maintenance - a little low 572 Professional Fees 1,750 2,148 < unusual $700 Financial Review & Legal costs per "Board Education" 574 Insurance 2,100 2,032 576 Travel 100 0 578 Volunteer Expense 1,000 1,319 Mainly food and refreshment for Archiving parties, Operator meetings, Open House events and Socials. 586 Bank Charges 125 128 588 MBanx Loan Interest 1,335 1,693 < Interest Onl 590 Mortgage Interest & Chrgs 1,405 1,757 < Interest Onl The interest portion of loan and mortgage payments 594 Depreciation 11,500 11,500 Estimate only & not an outlay of cash. 595 GST Paid 790 789 596 Bad Debts 150 0 Portion of Accounts Receivable forgiven SUMMARY & CAPITAL 99Proj 98Proj Revenue 97,079 81,931 Expense (94,238) (79,820) -------- -------- Revenue/Expense 2,842 2,111 ADD Depreciation - non cash outlay 11,500 A/R Collected 3,200 Brokered & SCP prior to Y/E 1998 Sale of Assets 0 old transmitter LESS A/P & Accrued Paid (5,650) Fin Review, TrentU &c Portion of Long Term Debt (7,676) The portion of loan and mortgage payements which reduce debt in the current year Purchase of Assets (2,000) Prov for new telephone/connectivity equipment & purchase of security system and hard disk capacity for spoken word archive -------- Change in Cash Position 2,216 Projected Bank Balance @ 31Aug99 Major Changes from 98 to 99 Brokered Revenue 8,290 R&M Decrease 625 Loan fund exhausted (3,345) Radio Artist & Soirees (1,250) Staff Salaries (6,950) --------- (2,630) Budget Line Items: Budget Y/E99 - prepared 12Sep98 jkm /w bat 99Proj 1998 REVENUE 409 Federal Grants (SCP) 8,220 3,836 416 Provincial Grants (OWSP) 5,000 1,851 418 Municipal Grants 0 Total Government Grants 13,220 5,687 422 Corporations 0 423 Foundations 0 424 Private 250 0 425 Leadership 0 427 Donations "In Kind" 0 431 Trent Student Memberships 55,575 56,415 433 Commercial & Non-profit 300 300 434 Individual Memberships 800 800 435 Discretionary M'ship Exp 0 441 Special Events 1,250 1,251 444 Fundraising Net 300 147 Membership & Fundraising Totl 58,475 58,913 463 ON AIR Sponsorship Net 4,000 4,698 465 "RADIO PAPER" Advertising 250 0 469 Net Other Sponsorship 14,190 5,903 470 Tape Sales 240 0 475 Rental Income 6,079 5,964 477 Net Misc Sales & Services 500 650 478 Refunds & Discounts Given 0 0 483 Interest Income 125 115 485 Discounts Taken 0 0 497 Micellaneous Revenue 0 0 Earned & Misc Total 25,384 17,330 TOTAL REVENUE 97,079 81,931 EXPENSE 501 PD Salary & Benefit 19,434 17,126 501 SCP - Salary & Benefit 10,272 4,237 Programming Wage Total 29,706 21,363 503 Technical Wage 0 0 506 Publicity Wage 0 0 507 Admin Salary & Benefit 19,601 14,961 512 PD Support 0 750 512 RDrama Total 1,750 1,575 512 RArtist Total 750 0 512 RSalons Total 500 150 512 RDay Fees 200 75 512 RHistorian 600 600 512 OWSP Burden 6,666 3,816 Programming Fees Total 10,466 6,966 514 Technical Fees 250 749 516 Publicity Fees 250 150 517 GM Contract 1,200 1,680 517 Bookkeeping 500 500 517 Admin Fees Total 1,700 2,180 Salary & Fees Total 61,973 46,369 536 Publicity & Promotions 500 213 548 Equipment Rental 100 0 550 Line Rental 1,250 1,461 552 Rental Other 60 30 554 Postage & Delivery 550 441 556 Office Supplies 500 460 558 Telephone 1,800 1,756 560 Utilities 3,000 3,054 562 Programming & Licence 1,750 1,547 564 Building R & M 750 1,594 566 Building R & M Upper Apt 750 0 568 Technical R & M 1,000 1,530 572 Professional Fees 1,750 2,148 574 Insurance 2,100 2,032 576 Travel 100 0 578 Volunteer Expense 1,000 1,319 586 Bank Charges 125 128 588 MBanx Loan Interest 1,335 1,693 590 Mortgage Interest & Chrgs 1,405 1,757 594 Depreciation 11,500 11,500 595 GST Paid 790 789 596 Bad Debts 150 0 598 Miscellaneous 0 0 Supply & Expense 32,265 33,451 Total Expense 94,238 79,820 SUMMARY & CAPITAL 99Proj 98Proj Revenue 97,079 81,931 Expense (94,238) (79,820) -------- -------- Revenue/Expense 2,842 2,111 ADD Depreciation - non cash outlay 11,500 A/R Collected 3,200 Sale of Assets 0 LESS A/P & Accrued Paid (5,650) Portion of Long Term Debt (7,676) Purchase of Assets (2,000) -------- Change in Cash Position 2,216 Cash at Year begin (1,675) -------- Cash at Year end 541 ========