worksheet 4 and 8 proposal writing class

profilewheone
worksheet_8.docx

WORKSHEET 8.1A

Revenue and Expense Budget

1. Use the filled-out Worksheet 8.1B as an example as you complete this budget

2.

CASH REQUIRED

IN-KIND CONTRIBUTIONS

TOTAL BUDGET

REVENUE

Foundations

Government

Corporations

Individual contributions

Donated printing and supplies

Volunteer services

Other (specify):

Total revenue

EXPENSES

Salaries (prorated if less than full time)

Payroll taxes and benefits (percentage of salaries)

Bookkeeping contractor

Other (specify):

Total personnel

Office rent

Supplies

Printing

Utilities

Telephone

Copy services

Postage

Travel

Membership dues

Other (specify):

Total nonpersonnel

Total expenses

WORKSHEET 8.1B

Revenue and Expense Budget

1. Use the filled-out worksheet as an example as you complete Worksheet 8.1A

2.

CASH REQUIRED

IN-KIND CONTRIBUTIONS

TOTAL BUDGET

EXPECTED REVENUE

Grants

Foundations

$130,000

$130,000

Government

83,000

83,000

Corporations

25,000

25,000

Individual contributions

50,000

50,000

Special events (net)

20,000

20,000

In-kind donations

$22,000

22,000

Total revenue

$308,000

$22,000

$330,000

EXPECTED EXPENSES

Salaries1

Program Coordinator

45,000

45,000

Social Worker I

40,000

40,000

Social Worker II

40,000

40,000

Administrative Assistant

30,000

30,000

Executive Director (part-time: $65,000 × 20%)

13,000

13,000

Benefits2 (20% of salaries)

33,600

33,600

Contract personnel

30,000

5,000

35,000

Program services

9,000

9,000

Total personnel

$231,600

$14,000

$245,600

Office rent3

10,000

10,000

Insurance

4,000

4,000

Printing

12,000

3,000

15,000

Equipment

20,000

5,000

25,000

Office supplies

4,000

4,000

Utilities

3,000

3,000

Telephone

2,000

2,000

Copy services

8,000

8,000

Postage

9,000

9,000

Travel4

4,000

4,000

Membership dues

500

500

Total nonpersonnel

$76,500

$8,000

$84,500

Total expenses

$308,100

$22,000

$330,100

3.

4. a A program coordinator is necessary to manage the program and ensure effective delivery of services. The salary is based on the county salary survey, which indicates that comparable positions are paid an average of $40,000 to $50,000 full-time equivalent (FTE) annually plus benefits. The social workers’ salaries assume that each person has an M.S.W. degree and experience working with elders. The county salary survey indicates that comparable positions are paid $35,000 to $45,000 FTE annually plus benefits.

5.

6. b Benefits includes employer-paid taxes, health insurance, dental insurance, and long-term disability insurance.

7.

8. c Office rent is calculated as 30% of total rent.

9.

10. d Two staff members attend the conference of the National Association of Social Workers in Minneapolis.