Trent Radio YE98 Budget Revision 18 Feb 98 / jkm PREAMBLE: It is prudent to constrain spending until the full hour of Brokered Programming develops as anticipated. COMMENTARY Cash receipts: $1,000 net from the proposed April 98 Casino Rama Event $1,200 net from Local Sponsorship for the summer season [Added $270 o/s Mshps and $200 for Mshps for the Summer of 98] $350 from t-shirt sales $5,000 advance on the 1998-9 levy There is also an allocation for 22wks of federal SCP funding, which is offset under Employment expense. Also see OWSP detail TRadio pays 25% of the $5,042.38 total Assets: Spending to be curtailed until the the next fiscal year or if new revenues found. Liability: The amount charged to Natl Trust shows the principle portion of the $450 monthly payment. The charge to CTS is optional but not payable until Sep98. Expense: GM to be laid off 27Feb98, with a $70/wk honorarium to year-end. PD to 15May and called back 10Aug98 Historian to end of 24Apr98 Radio Drama Artistic ($750) and Tech Ops ($300) Error: Add $250 for Radio Drama Director's last payement. (fixed) Provision of year-end clean up fees $1,000 SCP 14wks Prg Co-ordinator & 8 wks Physical Plant & Tech Person - 22 wks total. Compare YE97 20wks R&M includes amount for paint and cleaning materials. R&M Upper is to replace the front window. Of full wish list will be available for the next BoD meeting. Volunteer Expense for Archiving parties &c The final cash position of $1,299 to provide a contigency buffer. [end] from bud9802.wks Trent Radio Budget: Year end 1998; 18FEB98 / jkm Approved YTD 9801 9802 9803 9804 9805 9806 9807 9808 YTD+BUD98 Y/E 97 RECIEPTS Prior YTD A/R Collected 766 225 150 225 1,366 1998-9 Levy Advance 5000 5,000 Grants 0 0 0 3,782 0 4,822 0 1,206 9,810 5,480 Donations 0 0 0 0 0 0 0 0 0 1,145 Memberships - Student 55,364 0 0 0 0 0 0 0 55,364 57,286 Memberships - Other 695 0 270 0 0 200 0 0 1,165 1,005 Special Events 976 0 0 1,000 0 0 0 0 1,976 (806) Fundraising (762) 30 30 60 60 60 60 60 (402) 1,574 Rental Income 2,485 497 497 497 497 497 497 497 5,964 5,866 Sponsorship & Other Earned 2,795 670 830 670 2,030 670 670 830 9,165 1,470 Miscellaneous Revenue 49 5 5 5 5 5 5 5 84 812 61,602 1,968 1,857 6,164 2,817 6,254 1,232 7,598 89,491 73,833 EXPENDITURE YTD 9801 9802 9803 9804 9805 9806 9807 9808 YTD+BUD98 Y/E 97 Asset Office Equipment 834 834 558 Technical Equipment 8,689 8,689 5,823 Technical Renovations 0 0 15,996 Total Asset 9,523 0 0 0 0 0 0 0 9,523 22,377 Liabiility YTD 9801 9802 9803 9804 9805 9806 9807 9808 YTD+BUD98 Y/E 97 Commision Payable 850 Trent U - CTS Department 417 83 83 83 83 83 83 83 1,000 1,000 National Trust 1,477 302 305 307 309 312 314 317 3,643 3,321 Mbanx Demand Loan Shown as Interest until Y/E--------------------------------------------- 0 2,014 Total Liability 1,894 386 388 390 393 395 397 400 4,642 6,335 Expense YTD 9801 9802 9803 9804 9805 9806 9807 9808 YTD+BUD98 Y/E 97 Employment & Contract 23,399 4,867 2,189 7,781 2,614 1,562 3,052 4,667 50,130 42,150 Publicity, Postage & Offic 486 85 85 85 85 85 85 215 1,211 1,720 Telephone & Utilities 1,845 315 315 315 315 315 315 315 4,050 4,454 Broadcast Line & Eq Rental 562 115 115 115 115 115 115 115 1,367 2,172 Programming & Licence 752 800 100 100 100 100 100 100 2,152 1,737 Repair & Maintenance 790 50 50 50 50 50 600 1,000 2,640 5,645 Audit & Legal 0 0 0 0 0 0 0 0 0 1,395 Insurance 2,032 0 0 0 0 0 0 0 2,032 2,115 Volunteer & Travel 588 120 120 200 200 100 100 100 1,528 829 Interest, Bank Chrgs & Mis 3,817 675 623 627 624 615 651 686 8,317 3,267 Total Expense 34,270 7,027 3,597 9,273 4,103 2,942 5,018 7,197 73,426 65,484 Total Expenditure 45,687 7,412 3,985 9,663 4,495 3,337 5,415 7,597 87,592 94,196 Receipts - Expenditure 15,915 (5,444) (2,128) (3,499) (1,678) 2,918 (4,183) 0 1,899 (20,363) Culmulative Cash Position 15,534 10,090 7,961 4,462 2,784 5,701 1,518 1,519 1,725 .. # Income Detail YTD 9801 9802 9803 9804 9805 9806 9807 9808 YTD+BUD98 409 Federal Grants 0 4,822 1,206 6,028 416 Provincial Grants 0 3,782 3,782 418 Municipal Grants 0 0 422 Corporations 0 0 423 Foundations 0 0 424 Private 0 0 425 Leadership 0 0 427 Donations "In Kind" 0 0 431 Trent Student Memberships 55,364 55,364 433 Commercial & Non-profit 75 150 225 434 Individual Memberships 620 0 120 200 940 435 Discretionary M'ship Exp 0 0 441 Special Events 1,332 1,500 2,832 443 Special Events Expense (357) (500) (857) 445 Fundraising 160 30 30 60 60 60 60 60 520 446 Fundraising Expense (922) (922) # Income Detail YTD 9801 9802 9803 9804 9805 9806 9807 9808 YTD+BUD98 461 ON AIR Sponsorship 4,458 2,000 6,458 462 ON AIR Sponsorship Expense (1,663) (800) (2,463) Brokered Programming 670 830 670 830 670 670 830 5,170 465 "RADIO PAPER" Advertising 0 0 466 "RADIO PAPER" Expense 0 0 469 Net Other Sponsorship 0 0 470 Tape Sales 0 0 472 Tape Sales Expense 0 0 475 Rental Income 2,485 497 497 497 497 497 497 497 5,964 477 Net Misc Sales & Services 0 0 478 Refunds & Discounts Given 0 0 483 Interest Income 49 5 5 5 5 5 5 5 84 485 Discounts Taken 0 0 497 Micellaneous Revenue 0 0 # Income Detail YTD 9801 9802 9803 9804 9805 9806 9807 9808 YTD+BUD98 501 Programming Wage 8,781 1,785 1,785 1,785 1,360 85 85 1,628 17,294 OWSP 5,042 5,042 Radio Drama Artistic 750 250 1,000 Radio Historian 50 100 100 250 SCP Prg Co-ord 880 1,173 1,466 586 4,105 503 Technical Wage: SCP 0 1,173 1,173 2,345 506 Publicity Wage 0 0 507 Administrative Wage 11,193 2,258 13,451 508 Benefits 1,479 1,479 512 Programming Fees 1,225 1,225 514 Technical Fees 0 1,000 1,000 Radio Drama Technical Ops 300 300 516 Publicity Fees 150 150 517 Administrative Fees 570 570 Bookkeeping Fees 24 24 24 24 24 48 168 GM Honorarium 280 280 350 280 280 280 1,750 536 Publicity & Promotions 132 132 548 Equipment Rental 0 0 550 Line Rental 532 115 115 115 115 115 115 115 1,337 552 Rental Other 30 30 554 Postage & Delivery 9 15 15 15 15 15 15 15 114 556 Office Supplies 345 70 70 70 70 70 70 200 965 # Income Detail YTD 9801 9802 9803 9804 9805 9806 9807 9808 YTD+BUD98 558 Telephone 565 115 115 115 115 115 115 115 1,370 560 Utilities 1,280 200 200 200 200 200 200 200 2,680 562 Programming & Licence 752 800 100 100 100 100 100 100 2,152 564 Building R & M 376 50 50 50 50 50 600 600 1,826 566 Building R & M Upper Apt 0 400 400 568 Technical R & M 414 414 572 Professional Fees 0 0 573 CROP Equipment 0 0 574 Insurance 2,032 2,032 576 Travel 0 100 100 578 Volunteer Expense 588 120 120 200 100 100 100 100 1,428 586 Bank Charges 57 5 5 5 5 5 5 5 92 588 Mbanx Loan Interest 2,090 418 418 418 418 418 418 418 5,016 590 Mortgage Interest & Chrgs 773 148 145 143 141 138 136 133 1,757 594 Depreciation 0 0 595 GST Paid 898 104 55 61 61 54 92 129 1,452 596 Bad Debts 0 0 598 Miscellaneous 0 0