1
play

1 MCCOY Proposed Budget Year Ending 12/31/2018 Professional Fees - PDF document

Oct 17, 2022 •132 likes •185 views

MCCOY Proposed Budget Year Ending 12/31/2018 Ordinary Income/Expense Proposed 2018 Projected 2017 Change Income 410 Grant Income 412 Grant Income - Unrestricted 305,000 322,913 (17,913) 411 Grant Income - Restricted 330,000

  1. MCCOY Proposed Budget Year Ending 12/31/2018 Ordinary Income/Expense Proposed 2018 Projected 2017 Change Income 410 · Grant Income 412 · Grant Income - Unrestricted 305,000 322,913 (17,913) 411 · Grant Income - Restricted 330,000 957,678 (627,678) 410 · Grant Income - Other 15,000 - 15,000 Total 410 · Grant Income 650,000 1,280,591 (630,591) 420 · Contract Income 248,334 102,000 146,334 430 · Program Service Fees 35,000 48,300 (13,300) 440 · United Way 28,000 32,518 (4,518) 450 · Fund/Special Events Income - 452 · Sponsorship Income 21,000 13,400 7,600 Golf Outing & 25 Yr Event 450 · Fund/Special Events Income - Other 17,000 7,110 9,890 Golf Outing & 25 Yr Event Total 450 · Fund/Special Events Income 38,000 20,510 17,490 Contributions 462 · Contributions-Unrestricted 15,000 13,000 2,000 461 · Contributions - Restricted - - - 460 · Contributions - Board 10,000 6,000 4,000 463 · Contributions - Other - - - Total Contributions 25,000 19,000 6,000 465 · Miscellaneous 15,000 15,075 (75) 470 · In Kind Income 3,000 2,000 1,000 480 · Interest Income 750 1,000 (250) 490 · Loss on Disposal of Assets - - - Total Income 1,043,084 1,520,994 (477,910) Expense Personnel Expenses 501 · Salaries 401,150 382,836 18,314 3% Increase Payroll for Great Families (Caregivers) 41,600 - 41,600 505 · Payroll Taxes 31,608 30,247 1,361 510 · Benefits 71,511 59,726 11,785 15% Increase for insurance 785 · Insurance - WC 1,500 1,500 - 521 · Payroll Expenses 1,746 1,734 12 Total Personnel Expenses 549,115 476,043 73,072 Personnel Development 770 · Memberships 3,925 3,928 (3) 765 · Subscriptions/Resources 10,970 7,700 3,270 760 · Board Development 500 20 480 755 · Staff Development 3,500 5,161 (1,661) Total Personnel Development 18,895 16,809 2,086 Consultants and Contract Labor 605 · Contract Labor 156,000 746,622 (590,622) 635 · IT Consultants 7,500 - 7,500 · Technology Costs 1,800 615 · Consultant Fees 78,500 78,500 Consultants and Contract Labor - Other 13,400 13,400 Total Consultants and Contract Labor 257,200 746,622 (491,222) 1

  2. MCCOY Proposed Budget Year Ending 12/31/2018 Professional Fees 30,280 32,500 (2,220) Advertising Costs 805 · Advertising 11,400 12,500 (1,100) Advertising Costs - Other - - - Total Advertising Costs 11,400 12,500 (1,100) Occupancy Expenses 705 · Rent 37,540 36,615 925 708 · Janitorial 7,500 7,257 243 706 · Utilities 2,160 1,700 460 707 · Security 540 511 29 710 · Communications 5,160 5,950 (790) Total Occupancy Expenses 52,900 52,033 867 Supplies 715 · Office Supplies 3,400 3,000 400 840 · Program Supplies 63,974 47,000 16,974 725 · Postage 750 750 - Total Supplies 68,124 50,750 17,374 735 · Printing 6,663 11,790 (5,127) Insurance 780 · Insurance - GL/DO 3,600 3,000 600 Total Insurance 3,600 3,000 600 Travel and Meetings 830 · Meeting Expense 8,950 4,736 4,214 820 · Mileage 14,745 3,500 11,245 815 · Travel - 1,500 (1,500) Total Travel and Meetings 23,695 9,736 13,959 Fundraising Expenses 13,000 8,523 4,477 Other Expenses 995 · Miscellaneous 500 350 150 606 · Moving Expense - - - 940 · Service & Finance Charges 900 1,500 (600) Total Other Expenses 1,400 1,850 (450) 965 · In Kind Expenses 3,000 4,795 (1,795) Total Expense 1,039,272 1,426,951 (389,479) Net Ordinary Income 3,812 94,043 (88,431) Net Income 3,812 94,043 (88,431) 2

  3. MCCOY Proposed Budget Year Ending December 31, 2018 Youth Proposed Learning Youth Working 2018 Admin Fundraising Marketing Advocacy Community YAD Network SYP EIP Advocate Indy Income 410 · Grant Income 412 · Grant Income - Unrestricted 305,000 305,000 - - - - - - - - - - 411 · Grant Income - Restricted 330,000 - - - - - - - 235,000 28,334 - 95,000 410 · Grant Income - Other 15,000 15,000 - - - - - - - - - - Total 410 · Grant Income 650,000 320,000 - - - - - - 235,000 28,334 - 95,000 420 · Contract Income 248,334 - - - - - - - - 220,000 - - 430 · Program Service Fees 35,000 - - - - - - 35,000 - - - - 440 · United Way 28,000 28,000 - - - - - - - - - - 450 · Fund/Special Events Income - - - - - - - - - - 452 · Sponsorship Income 21,000 - 20,000 - - - - 1,000 - - - - 450 · Fund/Special Events Income - Other 17,000 - 17,000 - - - - - - - - - Total 450 · Fund/Special Events Income 38,000 - 37,000 - - - - 1,000 - - - - Contributions 462 · Contributions-Unrestricted 15,000 15,000 - - - - - - - - - - 460 · Contributions - Board 10,000 10,000 - - - - - - - - - - Total Contributions 25,000 25,000 - - - - - - - - - - 465 · Miscellaneous 15,000 15,000 - - - - - - - - - - 470 · In Kind Income 3,000 2,000 1,000 - - - - - - - - - 480 · Interest Income 750 750 - - - - - - - - - - Total Income 1,043,084 390,750 38,000 - - - - 36,000 235,000 248,334 - 95,000 Expense Personnel Expenses 501 · Salaries 401,150 36,104 52,150 48,138 64,184 20,058 8,023 32,092 56,161 76,219 4,012 4,012 Payroll for Great Family (Caregivers) 41,600 41,600 505 · Payroll Taxes 31,608 2,845 4,109 3,793 5,057 1,580 632 2,529 4,425 6,006 316 316 510 · Benefits 71,511 6,436 9,296 8,581 11,442 3,576 1,430 5,721 10,012 13,587 715 715 785 · Insurance - WC 1,500 135 195 180 240 75 30 120 210 285 15 15 521 · Payroll Expenses 1,746 157 227 210 279 87 35 140 244 332 17 17 Total Personnel Expenses 549,115 45,676 65,977 60,902 81,202 25,376 10,150 40,601 71,052 138,028 5,075 5,075 3

  4. Personnel Development 770 · Memberships 3,925 500 - 300 2,950 - - - - 175 - - 765 · Subscriptions/Resources 10,970 1,700 - 5,850 2,000 - - 420 1,000 - - - 760 · Board Development 500 500 - - - - - - - - - - 755 · Staff Development 3,500 2,000 - 500 500 - - 500 - - - - Total Personnel Development 18,895 4,700 - 6,650 5,450 - - 920 1,000 175 - - Consultants and Contract Labor 605 · Contract Labor 156,000 - 25,000 - - - 17,500 12,000 - 6,500 - 95,000 635 · IT Consultants 7,500 675 975 900 1,200 375 150 600 1,050 1,425 75 75 · Technology Costs 1,800 1,800 - - 615 · Consultant Fees 78,500 - - - - - 78,500 - - - Consultants and Contract Labor - Other 13,400 - - 4,400 - - - - - 9,000 - - Total Consultants and Contract Labor 257,200 675 25,975 5,300 1,200 375 17,650 14,400 79,550 16,925 75 95,075 Professional Fees 30,280 2,725 3,936 3,634 4,845 1,514 606 2,422 4,239 5,753 303 303 Advertising Costs 805 · Advertising 11,400 - - 2,400 - - - - 9,000 - - - Total Advertising Costs 11,400 - - 2,400 - - - - 9,000 - - - Occupancy Expenses 705 · Rent 37,540 3,379 4,880 4,505 6,006 1,877 751 3,003 5,256 7,133 375 375 708 · Janitorial 7,500 675 975 900 1,200 375 150 600 1,050 1,425 75 75 706 · Utilities 2,160 194 281 259 346 108 43 173 302 410 22 22 707 · Security 540 49 70 65 86 27 11 43 76 103 5 5 710 · Communications 5,160 464 671 619 826 258 103 413 722 980 52 52 Total Occupancy Expenses 52,900 4,761 6,877 6,348 8,464 2,645 1,058 4,232 7,406 10,051 529 529 Supplies 715 · Office Supplies 3,400 306 442 408 544 170 68 272 476 646 34 34 840 · Program Supplies 63,974 600 - 850 30 125 - 1,200 51,200 9,969 - - 725 · Postage 750 - 295 - 60 - 370 25 - - - - Total Supplies 68,124 906 737 1,258 634 295 438 1,497 51,676 10,615 34 34 735 · Printing 6,663 380 - 921 1,000 - 2,000 100 1,500 762 - - Insurance 780 · Insurance - GL/DO 3,600 324 468 432 576 180 72 288 504 684 36 36 Total Insurance 3,600 324 468 432 576 180 72 288 504 684 36 36 Travel and Meetings 830 · Meeting Expense 8,950 2,250 - 1,200 - 500 - 600 4,000 400 - - 820 · Mileage 14,745 300 - 1,500 1,160 240 120 80 2,000 9,345 - - 815 · Travel - - - - - - - - - - - - 4

  5. Total Travel and Meetings 23,695 2,550 - 2,700 1,160 740 120 680 6,000 9,745 - - Fundraising Expenses 13,000 - 13,000 - - - - - - - - - Other Expenses 995 · Miscellaneous 500 500 - - - - - - - - - - 940 · Service & Finance Charges 900 900 - - - - - - - - - - Total Other Expenses 1,400 1,400 - - - - - - - - - - 965 · In Kind Expenses 3,000 2,000 1,000 - - - - - - - - - Total Expense 1,039,272 66,098 117,970 90,544 104,531 31,125 32,094 65,141 231,927 192,738 6,052 101,052 3,812 324,652 (79,970) (90,544) (104,531) (31,125) (32,094) (29,141) 3,073 55,596 (6,052) (6,052) 3,812 324,652 (79,970) (90,544) (104,531) (31,125) (32,094) (29,141) 3,073 55,596 (6,052) (6,052) 0.09 0.13 0.12 0.16 0.05 0.02 0.08 0.14 0.19 1% 1% Allocation Percentages (Allocations based on estimated time spent on activities by each staff member.) 5

Recommend

More recommend