ACME Agency-wide Budget
Fiscal Year 2012
October 1, 2011 to September 30, 2012
FUND TOTAL CSBG LIHEAP WAP DOE Adams County
Budget Period Oct-Sep Oct - Sep Oct-Apr Apr-Sep Oct-June June-Sep
REVENUE
Federal 3,315,000 675,000 540,000
State 1,580,000 350,000 1,230,000
Local, public 60,000 45,000 15,000
Local, private 20,000
Allocations to Admin Pool
Other 17,000
TOTAL REVENUE 4,992,000 1,580,000 1,215,000 60,000
EXPENSES 1,328,502 139,835 64,571 156,327 278,209 2,639 880
Personnel 340,640 30,878 11,856 63,578 63,578 1,989 663
Fringe benefits (SMPU) 118,133 4,972 11,856 10,236 63,578 320 107
Charge to Admin Pool 131,363 3,088 413 23,732 23,732 15 5
Percent 10.0% 3.5% 37.3% 37.3% 0.8% 0.8%
Payroll Expenses 53,906 4,887 1,876 10,061 10,061 315 105
Federal withholding 19,587 1,776 682 3,656 3,656 114 38
Medicare 6,302 571 219 1,176 1,176 37 12
State withholding 11,071 1,004 385 2,066 2,066 65 22
Unemployment 6,728 610 234 1,256 1,256 39 13
Workers Compensation 10,219 926 356 1,907 1,907 60 20
Facilities 304,500 34,000 18,000 12,500 26,000 0 0
Space 162,500 25,000 12,500 5,000 15,000
Utilities 80,000 6,000 3,500 3,500 7,000
Maintenance 21,000 2,000 1,000 1,500 1,500
Repairs 41,000 1,000 1,000 2,500 2,500
Communication 38,040 4,440 8,400 3,900 3,900 0 0
Phones 15,600 2,400 3,600 1,800 1,800
Postage 5,640 240 1,200 900 900
Copies, printing 16,800 1,800 3,600 1,200 1,200
Equipment 195,750 8,500 1,500 25,500 75,250 0 0
Vehicles 112,500 7,500 0 25,000 0
Furniture 8,250 1,000 1,500 500 250
Weatherization 75,000 75,000
IT 44,900 7,000 8,000 1,500 5,000 0 0
IT network 7,400 1,500 2,500 500 500
Hardware 16,500 2,000 2,000 3,000
Software 5,000 1,000 1,000 500
Tech support 7,000 1,500 1,500 500 500
ACME Agency-wide Budget
Fiscal Year 2012
October 1, 2011 to September 30, 2012
FUND TOTAL CSBG LIHEAP WAP DOE Adams County
Budget Period Oct-Sep Oct - Sep Oct-Apr Apr-Sep Oct-June June-Sep
Internet 9,000 1,000 1,000 500 500
Supplies 41,170 4,020 5,920 3,120 3,060 0 0
Cleaning 4,500 500 500 250 250
Paper goods 7,500 500 500 250 250
Clerical 1,470 120 120 120 60
14,000
Copy machine, printer cartridges 2,400 3,600 1,000 1,000
Copy paper 13,700 500 1,200 1,500 1,500
Travel 46,300 8,900 4,000 2,900 7,500 0 0
Mileage reimbursement 21,200 2,400 1,800 2,500 2,500
Lodging 13,200 3,000 900 300 3,000
Per diem 4,400 1,000 300 100 1,000
Transportation 7,500 2,500 1,000 1,000
Participant expenses 46,850 30,750 250 300 550 0 0
Stipends 20,000 15,000 0 0 0
Tuition 9,000 5,000 0 0 0
Fees 5,750 750 250 250
Educational/training materials12,100 10,000 0 300 300
Insurance 6,500 1,900 500 500 1,000 0 0
General liability 3,000 500 500 500
Hazard 1,500 500 500
Professional 800 200
Directors and Officers 1,200 1,200
Memberships/Dues/Subs 5,350 3,500 0 0 0 0 0
State CAA association 1,500 1,500
CAP 1,500 1,500
CAPLAW 500 500
State HS Association 1,500
Harvard Business Rev 350
This publication was created by Meliora Partners, Inc., in the performance of the U.S. Department of Health and Human Services,
Administration for Children and Families, Office of Community Services Grant Number 90ET0430. Any opinion, findings, conclusions, or
recommendations expressed in this material are those of the author(s) and do not necessarily reflect the views of the U.S. Department of
Health and Human Services, Administration for Children and Families.
Rental Admin
FUND Jefferson United Way Head Start Income Pool
Budget Period Oct-Dec Jan-Sep Oct-Jan Feb-Sep Oct - Sep
REVENUE
Federal 850,000 1,250,000
State
Local, public
Local, private 5,000 15,000
Allocations to Admin Pool 131,363
Other 17,000
TOTAL REVENUE 20,000 2,100,000 17,000 131,363
EXPENSES 880 2,639 190,341 491,831 0 219,091
Personnel 663 1,989 55,094 110,353 188,407
Fringe benefits (SMPU) 107 320 8,870 17,767 30,334
Charge to Admin Pool 5 15 26,759 53,598 0 0
Percent 0.8% 0.8% 48.6% 48.6%
Payroll Expenses 105 315 8,719 17,463 0 0
Federal withholding 38 114 3,168 6,345
Medicare 12 37 1,019 2,042
State withholding 22 65 1,791 3,586
Unemployment 13 39 1,088 2,179
Workers Compensation 20 60 1,653 3,311
Facilities 0 0 62,000 152,000 0 0
Space 35,000 70,000
Utilities 20,000 40,000
Maintenance 5,000 10,000
Repairs 2,000 32,000
Communication 0 0 5,800 11,600 0 0
Phones 2,000 4,000
Postage 800 1,600
Copies, printing 3,000 6,000
Equipment 0 0 500 84,500 0 0
Vehicles 0 80,000
Furniture 500 4,500
Weatherization
IT 0 0 5,800 17,600 0 0
IT network 800 1,600
Hardware 2,000 7,500
Software 2,500
Tech support 1,000 2,000
Rental Admin
FUND Jefferson United Way Head Start Income Pool
Budget Period Oct-Dec Jan-Sep Oct-Jan Feb-Sep Oct - Sep
Internet 2,000 4,000
Supplies 0 0 8,350 16,700 0 0
Cleaning 1,000 2,000
Paper goods 2,000 4,000
Clerical 350 700
Copy machine, printer cartridges 2,000 4,000
Copy paper 3,000 6,000
Travel 0 0 7,500 15,500 0 0
Mileage reimbursement 4,000 8,000
Lodging 1,500 4,500
Per diem 500 1,500
Transportation 1,500 1,500
Participant expenses 0 0 6,750 8,250 0 0
Stipends 2,500 2,500
Tuition 2,000 2,000
Fees 1,500 3,000
Educational/training materials 750 750
Insurance 0 0 0 2,600 0 0
General liability 1,500
Hazard 500
Professional 600
Directors and Officers
Memberships/Dues/Subs 0 0 0 1,500 0 350
State CAA association
CAP
CAPLAW
State HS Association 1,500
Harvard Business Rev 350
This publication was created by Meliora Partners, Inc., in the performance of the U.S. Department of Health and Human Services,
Administration for Children and Families, Office of Community Services Grant Number 90ET0430. Any opinion, findings, conclusions, or
recommendations expressed in this material are those of the author(s) and do not necessarily reflect the views of the U.S. Department of
Health and Human Services, Administration for Children and Families.
Projection and Distribution of Personnel Costs
List each employee with Revise this list with Only non- As appro-
All Exempt
job title correct job titles exempt priate
CONTROL Admin Pool CSBG LIHEAP WAP DOE
Name Position Hourly Annual Increase TOTAL % Amount % Amount % Amount % Amount % Amount
Angela Baker Executive Director $ 69,852 101% $ 70,551 100% $ 70,551 100% $ 70,551 $ - $ - $ -
Cindy Davis Finance Director $ 53,658 101% $ 54,195 100% $ 54,195 100% $ 54,195 $ - $ - $ -
Ellen Folkes HR Director $ 46,555 101% $ 47,021 100% $ 47,021 100% $ 47,021 $ - $ - $ -
Gaylee Howard Family Services $ 48,629 101% $ 49,116 100% $ 49,116 $ - 40% $ 19,646 $ - $ -
Ida Jackson EHS/HS Director $ 51,685 101% $ 52,202 100% $ 52,202 $ - $ - $ - $ -
Kevin Lynch Housing Director $ 33,335 101% $ 33,669 100% $ 33,669 $ - $ - $ - 100% $ 33,669
Marian Newton Teacher $ 25,325 103% $ 26,085 100% $ 26,085 $ - $ - $ - $ -
Orlando Palmer Teacher Assistant $ 11.00 $ 22,880 103% $ 23,567 100% $ 23,567 $ - $ - $ - $ -
Quinella Ransom Teacher Aide $ 8.50 $ 17,680 103% $ 18,211 100% $ 18,211 $ - $ - $ - $ -
Steve Traynor House inspector $ 15.15 $ 31,512 105% $ 33,088 100% $ 33,088 $ - $ - $ - 100% $ 33,088
Udell Vickers Crew leader $ 14.50 $ 30,160 105% $ 31,668 100% $ 31,668 $ - $ - $ - 100% $ 31,668
Wayne Xavier Wx Technician $ 12.25 $ 25,480 105% $ 26,754 100% $ 26,754 $ - $ - $ - 100% $ 26,754
Yolanda Zenith Intake Worker $ 9.50 $ 19,760 100% $ 19,760 100% $ 19,760 $ - 30% $ 5,928 60% $ 11,856 10% $ 1,976
Abby Baker FD Specialist $ 12.75 $ 26,520 100% $ 26,520 100% $ 26,520 $ - 20% $ 5,304 $ - $ -
Christa Dodd Receptionist $ 8.00 $ 16,640 100% $ 16,640 100% $ 16,640 100% $ 16,640 $ - $ - $ -
$ 519,671 $ 529,047 $ 188,407 $ 30,878 $ 11,856 $ 127,155
computed Increase $ 9,376
Fringe Benefits (SMPU) 16.1% $ 85,178 $ 30,334 $ 4,972 $ 1,909 $ 20,472
$ 85,184
Non-Admin salary and wages $ 340,640
Admin allocation as % of salary and wages 10.0% 3.5% 37.3%
This publication was created by Meliora Partners, Inc., in the performance of the U.S. Department of Health and Human Services, Administration for
Children and Families, Office of Community Services Grant Number 90ET0430. Any opinion, findings, conclusions, or recommendations expressed in this
material are those of the author(s) and do not necessarily reflect the views of the U.S. Department of Health and Human Services, Administration for
Children and Families.
Projection and Distribution of Personnel Costs
List each employee with
job title
Adams County Jefferson UW Head Start Rental Income Fund Name Fund Name
Name % Amount % Amount % Amount % Amount % Amount % Amount
Angela Baker $ - $ - $ - $ -
Cindy Davis $ - $ - $ - $ -
Ellen Folkes $ - $ - $ - $ -
Gaylee Howard $ - $ - 60% $ 29,470 $ -
Ida Jackson $ - $ - 100% $ 52,202 $ -
Kevin Lynch $ - $ - $ - $ -
Marian Newton $ - $ - 100% $ 26,085 $ -
Orlando Palmer $ - $ - 100% $ 23,567 $ -
Quinella Ransom $ - $ - 100% $ 18,211 $ -
Steve Traynor $ - $ - $ - $ -
Udell Vickers $ - $ - $ - $ -
Wayne Xavier $ - $ - $ - $ -
Yolanda Zenith $ - $ - $ - $ -
Abby Baker 10% $ 2,652 10% $ 2,652 60% $ 15,912 $ -
Christa Dodd $ - $ - $ - $ -
$ 2,652 $ 2,652 $ 165,447 $ -
$ 427 $ 427 $ 26,637
0.8% 0.8% 48.6%
This publication was created by Meliora Partners, Inc., in the performance of the U.S. Department of Health and Human Services, Administration for
Children and Families, Office of Community Services Grant Number 90ET0430. Any opinion, findings, conclusions, or recommendations expressed in this
material are those of the author(s) and do not necessarily reflect the views of the U.S. Department of Health and Human Services, Administration for
Children and Families.
Agency-Wide Budget Workbook Computed Fringe Beyond the Basics Webinar
COMPUTED FRINGE BENEFIT COSTS
ENTER the health plans offered
ENTER the pension and
by your CAA in the left column.
unemployment rates for your
ENTER the annual CAA cost for
CAA in the right column, below. each plan in the right column.
Soc Security (S) 7.65% Health Insurance (annual)
Medicare (M) 1.85% Employee only $350
Pension (P) 4.75% Empl +spouse $450
Unemployment (U) 1.85% Employee + 2 $750
SMPU 16.10% Family $850
The cost of the correct Health
The SMPU total percentage will
Insurance plan must be
transfer to the table below (D15)
entered below for each
and be applied to all employees.
enrolled employee.
Workers Comp Health
These columns are linked to the Hourly& Annual tab. Extend
SMPU ENTER the correct Insurance
the lists and formulas down far enough to include all
This rate rate for each ENTER per
employees.
applies to all employee position. employee
Name Position TOTAL 16.10% Rate Amount 1.12%
Angela Baker Executive Director $ 70,551 $ 11,359 2% $1,411 $850
Cindy Davis Finance Director $ 54,195 $ 8,726 2% $1,084 $0
Ellen Folkes HR Director $ 47,021 $ 7,571 2% $940 $750
Gaylee Howard Family Services $ 49,116 $ 7,908 2% $982 $0
Ida Jackson EHS/HS Director $ 52,202 $ 8,405 2% $1,044 $750
Kevin Lynch Housing Director $ 33,669 $ 5,421 4% $1,347 $850
Marian Newton Teacher $ 26,085 $ 4,200 2% $522 $350
Orlando Palmer Teacher Assistant $ 23,567 $ 3,795 2% $471 $350
Quinella Ransom Teacher Aide $ 18,211 $ 2,932 2% $364 $0
Steve Traynor House inspector $ 33,088 $ 5,328 4% $1,324 $850
Udell Vickers Crew leader $ 31,668 $ 5,099 4% $1,267 $450
Wayne Xavier Wx Technician $ 26,754 $ 4,308 4% $1,070 $0
Yolanda Zenith Intake Worker $ 19,760 $ 3,182 3% $593 $0
Abby Baker FD Specialist $ 26,520 $ 4,270 3% $796 $750
Christa Dodd Receptionist $ 16,640 $ 2,680 2% $333 $0
$ 529,047 $ 85,184 $ 13,547 $ 5,950
Total Fringe $104,681
Fringe Rate 19.79%
This publication was created by Meliora Partners, Inc., in the performance of the U.S. Department of Health and Human Services,
Administration for Children and Families, Office of Community Services Grant Number 90ET0430. Any opinion, findings, conclusions, or
recommendations expressed in this material are those of the author(s) and do not necessarily reflect the views of the U.S. Department of
Health and Human Services, Administration for Children and Families.