Jan - Sep 11 Budget $ Over Budget Ordinary Income/Expense
Income
City of Iowa City 165,284.26 163,850.99 1,433.27 Contributions & Fundraising 1,101.00 7,500.01 -6,399.01
Memberships fees 1,325.00 1,125.00 200.00
Workshop Fees 1,000.00 1,080.00 -80.00
Other/Miscellaneous Income
Miscellaneous 152.94
Tapes/Dubs 244.00 760.00 -516.00
Total Other/Miscellaneous Income 396.94 760.00 -363.06 Building/Space Income
Rental 14,400.00 16,200.00 -1,800.00
Parking Spaces 1,000.00 450.00 550.00
Total Building/Space Income 15,400.00 16,650.00 -1,250.00
CDBG Funds 0.00 15,000.00 -15,000.00
Interest & Dividend Income 969.30 750.01 219.29
Total Income 185,476.50 206,716.01 -21,239.51
Expense
Payroll Expenses
Salary - Director 33,923.00 33,923.00 0.00
Wages - Production Staff 74,864.65 73,076.90 1,787.75
Payroll Taxes 8,322.25 10,769.24 -2,446.99
Total Payroll Expenses 117,109.90 117,769.14 -659.24 Staff Benefits
Health Insurance Premiums 12,243.93 11,850.00 393.93 Dental Insurance Premiums 1,190.90 1,125.00 65.90 Cable TV Reimbursements 130.88 225.00 -94.12 Total Staff Benefits 13,565.71 13,200.00 365.71 Production Equipment & Supplies
DVD/Blank Media 1,102.02 1,350.00 -247.98
Equipment Maintenance & Repairs 533.93 2,100.01 -1,566.08
Studio Supplies 995.34 750.01 245.33
Tape Stock 1,060.40 2,100.01 -1,039.61
Jan - Sep 11 Budget $ Over Budget General & Administrative
Bank Service Charge 33.44 149.99 -116.55
Bottled Water 70.00
Computer
Computer On Line Services 1,367.55 1,260.00 107.55
Computer Hardware 0.00 750.01 -750.01
Computer Repairs 370.00
Computer Software 54.00 300.01 -246.01
Total Computer 1,791.55 2,310.02 -518.47
Finance Charges 58.00
Late Fees and Penalties 18.68
Meeting Expense 28.05 149.99 -121.94
Garbage Pick Up 392.96 450.00 -57.04
Insurance
Insurance - Other 8,961.00 6,600.01 2,360.99
Total Insurance 8,961.00 6,600.01 2,360.99
Memberships & Dues 200.00 149.99 50.01
Office Equipment 0.00 374.99 -374.99
Office Supplies 1,322.95 1,499.99 -177.04
Postage & Shipping 272.82 599.99 -327.17 Professional Fees
Accounting - CPA 0.00 900.00 -900.00
Bookkeeping Fees 2,598.00 2,700.00 -102.00
Legal Fees 0.00 750.01 -750.01
Total Professional Fees 2,598.00 4,350.01 -1,752.01 Promotions and Marketing 498.85 1,499.99 -1,001.14
Security System 180.00 900.00 -720.00
Staff Development
Annual Conference 2,567.38
Staff Development - Other 0.00 1,499.99 -1,499.99 Total Staff Development 2,567.38 1,499.99 1,067.39
Storage Unit 450.00 450.00 0.00
Telephone - Service
Telephone - Service - Other 1,621.59 1,650.01 -28.42 Total Telephone - Service 1,621.59 1,650.01 -28.42 Travel - Local & Parking 0.00 149.99 -149.99 Utilities - G&E, Water 2,850.58 4,500.00 -1,649.42
Vehicle Expenses 0.75
Volunteer Recognition 59.09 149.99 -90.90
Jan - Sep 11 Budget $ Over Budget Building Expense
CDBG Expenses 0.00 15,000.00 -15,000.00
Mortgage Interest 6,592.96 15,151.22 -8,558.26 Maintenance & Repairs 694.78 900.00 -205.22 Total Building Expense 7,287.74 31,051.22 -23,763.48
Total Expense 165,630.73 195,755.34 -30,124.61
Net Ordinary Income 19,845.77 10,960.67 8,885.10
Ordinary Income/Expense Income
City of Iowa City
Contributions & Fundraising Memberships fees Workshop Fees
Other/Miscellaneous Income Miscellaneous
Tapes/Dubs
Total Other/Miscellaneous Income Building/Space Income
Rental Parking Spaces Total Building/Space Income CDBG Funds
Interest & Dividend Income Total Income
Expense
Payroll Expenses Salary - Director Wages - Production Staff Payroll Taxes
Total Payroll Expenses Staff Benefits
Health Insurance Premiums Dental Insurance Premiums Cable TV Reimbursements Total Staff Benefits
Production Equipment & Supplies DVD/Blank Media
Equipment Maintenance & Repairs Studio Supplies
Tape Stock
Total Production Equipment & Supplies
% of Budget 100.88% 14.68% 117.78% 92.59% 32.11% 52.23% 88.89% 222.22% 92.49% 0.0% 129.24% 89.73% 100.0% 102.45% 77.28% 99.44% 103.32% 105.86% 58.17% 102.77% 81.63% 25.43% 132.71% 50.5% 58.6%
Ordinary Income/Expense General & Administrative
Bank Service Charge Bottled Water Computer
Computer On Line Services Computer Hardware Computer Repairs Computer Software Total Computer Finance Charges Late Fees and Penalties Meeting Expense Garbage Pick Up Insurance
Insurance - Other Total Insurance Memberships & Dues Office Equipment Office Supplies Postage & Shipping Professional Fees
Accounting - CPA Bookkeeping Fees Legal Fees Total Professional Fees Promotions and Marketing Security System Staff Development
Annual Conference Staff Development - Other Total Staff Development Storage Unit
Telephone - Service
Telephone - Service - Other Total Telephone - Service Travel - Local & Parking Utilities - G&E, Water Vehicle Expenses Volunteer Recognition Total General & Administrative
% of Budget 22.3% 108.54% 0.0% 18.0% 77.56% 18.7% 87.32% 135.77% 135.77% 133.34% 0.0% 88.2% 45.47% 0.0% 96.22% 0.0% 59.72% 33.26% 20.0% 0.0% 171.16% 100.0% 98.28% 98.28% 0.0% 63.35% 39.4% 87.39%
Ordinary Income/Expense Building Expense
CDBG Expenses Mortgage Interest Maintenance & Repairs Total Building Expense Total Expense
Net Ordinary Income Net Income % of Budget 0.0% 43.51% 77.2% 23.47% 84.61% 181.06% 181.06%