Get documents about "budget worksheet
Document Sample
Start
A B C D E F G H I
1 Mi-MEC
2 PLANNING BUDGET PROCESS
3 Welcome to the Mi-MEC Buget Planning Process. By moving through each of the
4 worksheets in this notebook, an actual budget and annualized budget (a budget that
5 assumes a full year of operation) for an organization will be generated. Once the
6 information has been entered, it is possible to go back and forth between the worksheets
7 and change different estimates to determine their effect on the total budget.
8
9 This version is in test form, please call, fax or E-mail the Mitchell Cohen to answer any
10 questions or report any difficulties. Phone: E-mail: Mitchell@pchealth.org.
11
Let's get started. Go to Basic definitions by moving cursor to the gray button to the right
12
and clicking with the left button.
13
14
15
16
17 Worksheet: Each tab at the bottom of this page represents one worksheet.
Page 1
Basic definitions
A B C D E F G H
1 #1 COLOR CODES are used throughout the budget sheets. IF YOU CANNOT SEE
2 Blue indicates predefined categories. You can't change them. THE ENTIRE SHEET
3 Yellow indicates an area for entering information. change the zoom
control to 75% and
4 Light green is reserved for directions. use only the
5 Red represents interactive buttons that request information. "standard" tool bar.
6 Gray represents titles that you can redefine in your own words.
7 Tourquioise and purple boxes show calculations based on your entries.
8
9 Enter the requested information below in Box #1 in the yellow areas. SAVE YOUR WORK
10 #2 SOME BASIC INFORMATION FREQUENTLY BY
11 Name of the Linking Organization: Partnership for Communty Health PRESSING
"CONTROL S"
12 Country: US
13 Budget Year: 1997
14 Local Currency: $
15 Exchange rate: US$ 1 = 1
16 Months of operation in this budget yr 12
17 Now click on the gray button to move to information about grants. You can go
18 back and forth between sheets by clicking on the bottom tabs
Page 2
Funding stream
A B C D E F G H I J
1 FUNDING STREAM INFORMATION
2 In the worksheet under “Funding streams” specify the size and number of different funding streams in
3 your organization. Typically they are broad categories that represent different ways you bring in funds,
4 and are divided between development sources and services. However, you may wish use different
substantive areas, such as prevention and care. Or you may do both, and define small and large
5 prevention services and small and large care services. Deciding on the types of funding streatms is one
6 of the most important decisions you make. It will greatly affect the budget, review process, and staffing.
7 You can enter up to 5 funding streams. Presently they are given the generic names “Category A -
8 Category E”. For example, you might have three categories of services and events where “Category A”
9 is retitled case management and average $1200 per "client". Category B might be “Education and
prevention services” with an average project of $2500. Category C might be ”Corporate grants”averaging
10 $12,000. After deciding the funding streams, label them by clicking on the red buttons.
11
12 In the Funding Stream worksheet, for each category, specify the average amount for each category. In
13 the next column project the the number of things in each category for a full year. If this budget is for
14 less than full year, estimate how many of each funding stream would be projected if it were a full year.
(This is used to create an annualized budget.)
15
16 In Columns titles "Q1" -" Q4" enter the actual number for each funding stream you expect to receive in
17 each quarter. For example, if organization will start case management in the third and fourth quarter of
18 the budget year, place the number of clients to be provided services in columns "Q3" and "Q4". (This is
19 used to create the actual budget.)
20
NOTE: The total this Yr will not equal the sum of all the quarters if the funding streams are not given for a
21 full year. This is likely to be the case for the first year of operation.
22
23 At the bottom of the Funding Stream worksheet there will be a purple and turquoise box. This is
24 produced by the program and shows the annualized and actual funding streams. Make sure these
number make sense before going to the TA sheet.
25
26
27
28
Page 3
Funding sources
A B C D E F G H I J K L M N
1 FUNDING STREAMS
2 Specify the size of number of funding streams for your organization. First click on the red buttons in Box #1 to name each fu nding stream, then in Box #2
3 indicate the average amount for each service or income source, and the number of services or events you expect to be given in a full year. Last, fill in
4 the number of services or events you plan for each quarter. For instructions see the Funding stream tab. The turquoise box at the end of the funding
5 stream box and below show the total number of actual services and events and is filled in automatically. Check to see it matc hes your expectations.
6
7
8 NOTE: Unless you are operating for a full year the total number of grants for 1 year will be more than the total of the grants you enter for
9 the quarters.
10
# SERVICE TYPES
11 #2 REVENUE
NAME SERVICE TYPES BY
12 To name click Av Amt Total # for 1 yr Q1 Q2 Q3 Q4 Total this yr
CLICKING ON BAR BELOW
13 red box above loc cur Annual Actual # of grants per quarter Actual Detail
14 SERVICE TYPE A Direct TA to CBOs 9500 20 4 5 5 5 19 Direct TA to CBOs $180,500
15 SERVICE TYPE B
Contracts 30000 8 1 1 2 2 6 Contracts $180,000
16 Writing/editing/proposal writing5000 8 2 2 0 2 6 $30,000
Writing/editing/proposal writing
17 SERVICE TYPE C Sales 500 20 0 4 5 9 Sales $4,500
18 Fund raising/Grants 2524 132 30 33 63 Major gifts $6,000
SERVICE TYPE D
19 Project grants $30,000
20 SERVICE TYPE E #2 ARE THESE THE special events $0
21 AMOUNTS EXPECTED? mail solicitations/ind $9,000
22 REVENUE corporate gifts $15,000
23 Annualized $813,168 $455,000
24 Actual $455,000
25 per # TOTAL
26 Major gifts $3,000 2 $6,000
27 Project grants $30,000 1 $30,000
28 speciaql events $15,000 0 $0
mail
29 solicitations/ind $300 30 $9,000
30 corporate gifts $3,000 5 $15,000
31 TOTAL 38 $60,000
Page 4
TA
A B C D E F G H I J K L M N O P
1 STAFF AND CONSULTANT TECHNICAL ASSISTANCE
2 In Box #1, first define the technical assistance needs to support the services and events. Program Assistance,
3 Management Assistance, and Monitoring & Evaluation are pre-defined TA categories. If these are insufficient
4 to support the grants, up to 3 more types of TA can be included. Name these additional types of TA by clicking
5 in the gray boxes labeled "TA1" , "TA2" and "TA3" and replacing these generic titles with more descriptive
6
titles. Next, decide on what staff TA positions are needed to support the grants, and the number of staff in
7
8
each position.
9 The worksheet allows up to 15 #1 TA STAFF SUPPORT
staff positions, but in most # per- Mon & Sales Devel TA3
10 instances there will be no sons Prog Mgmt Eval
11 more than 4 or 5. Label the TA STAFF Enter % of staff time in each functional area
12 positions by clicking on the Senior Analyst 1 75% 15% 10%
13 gray Position TA1-15 and re- Jr. Systems 1 60% 35% 5%
14 titling the generic title. The Systems Analyst 1 90% 10%
15 only pre-defined position is Software designer 0 50% 50%
16 "Director of Program ". For Admin Assit / jr. analyst 1 50% 40% 10%
17 each position note the number Sales 1 10% 90%
18 of persons filling that position. Senior Partner 1 25% 25% 50%
19 Last enter the percent of time Analyst 0 75% 15% 10%
20 each position will spend under Bookkeeper 1 45% 50% 5%
21 each TA category. Go to Box Research analyst 1
22 # 2. Position TA11
23 Position TA12
24 Position TA13
25 Position TA14
26 Position TA15
27 Consultants are often needed to
28 supplement staff and provide #2 NATIONAL CONSULTANT TECHNICAL ASSISTANCE
29 expertise. In Box #2 enter the Average consultant rate/day 500
average consultant's fee per day
30 and the average consultant per Average Per Diem for consultant 0
31 diem. Technical assistance #2 GRANT CONSULTANT DAYS
consulting will be distributed under Prog Mgmt Mon & Sales Devel TA3
32 the same functional areas as other Eval
TA. For each type of grant, enter
33 days per grant
the average number of days of
34 Direct TA to CBOs 8
consulting expected. This box
35 refers to only TA consulting for Contracts 6
36 services and events. Writing/editing/proposal writing 1
37 Organizational support is Sales
38 entered in the "Office" Fund raising/Grants 0
worksheet.
39
40 CHECK BOX #3! The cost #3 CHECK THE SPREADSHEET BELOW. MAKE SENSE?
you have estimated for CONSULTANT Mon & Sales Devel TA3 Mon & Sales Devel TA3
41 each of the consultant COST Prog Mgmt Eval Prog Mgmt Eval
42 Annualized Actual
categories is shown in the
43 Direct TA to CBOs 80000 0 0 0 0 0 76000 0 0 0 0 0
44 purple box to the right. Contracts 24000 0 0 0 0 0 18000 0 0 0 0 0
45 Total TA consultant Writing/editing/proposal writing4000 0 0 0 0 0 3000 0 0 0 0 0
46 expenditures are shown in Sales 0 0 0 0 0 0 0 0 0 0 0 0
47 Turquoise. Do they make Fund raising/Grants 0 0 0 0 0 0 0 0 0 0 0 0
48 sense? Move to defining TOTAL 108000 0 0 0 0 0 97000 0 0 0 0 0
49 staff needs by clicking on
50 the gray button or on the
51 "Staff" tab.
52
Page 5
Staff
A B C D E F G H I J K L M N O P Q R S
1 ADMINISTRATIVE STAFF & SALARIES
2 Much of the information needed in this budget sheet has been entered in the prior worksheet and is shown below in
3 blue. Now, name the Administrative positions by changing, if necessary, the generic titles in Box #1 (in gray) and
4 enter the number of persons holding those positions (yellow). For all positions enter an estimated annual salary and
5
the number of months you expect that position to be filled this budget year. For example if they are working the whole
6
7
year enter “12”, if they are working half a year enter “6”, etc. Be sure to make a note (Insert, Note) for anything that
8 needs explanation.
9 In Box 2 enter the percentage of time each position works in each functional area. You can't enter numbers in the
10 dark green areas. For example, the executive director may work 75% in Admin and 25% in fundraising or the
11 secretary might work 40% in Admin and 20% in Prog Assist, 20% Mgmt Assist and 20% Mon & Eval.
12
13 STAFFING AND SALARIES
14 #1 SALARY #2 % TIME FUNCTIONAL AREA
15 Enter % of staff time in each functional area
Positions (enter # of Annual Actual # Admin Fund Prog Mgmt Mon & Sales Devel TA3
Months
names) persons Salary Raising Eval
16 Working
17 Executive Director 1 80000 12 10% 20% 40% 20% 10%
18 Accountant 1 24000 12 100%
19 Secretary 0 26000 12 100%
20
21 Senior Analyst 1 50000 12 75% 15% 10% 0% 0% 0%
22 Jr. Systems 1 24000 6 60% 35% 5% 0% 0% 0%
23 Systems Analyst 0 70000 5 90% 10% 0% 0% 0% 0%
24 Software designer 0 60000 0 50% 0% 0% 50% 0% 0%
25 Admin Assit / jr. analyst 0 28000 12 50% 40% 10% 0% 0% 0%
26 Sales 0 50000 5 0% 10% 0% 90% 0% 0%
27 Senior Partner 1 70000 6 25% 25% 0% 0% 50% 0%
28 Analyst 0 50000 3 75% 15% 10% 0% 0% 0%
29 Bookkeeper 0 25000 6 45% 50% 5% 0% 0% 0%
30 Research analyst 1 24000 6 0% 0% 0% 0% 0% 0%
31 Position TA11 0 0% 0% 0% 0% 0% 0%
32 Position TA12 0 0% 0% 0% 0% 0% 0%
33 Position TA13 0 0% 0% 0% 0% 0% 0%
34 Position TA14 0 0% 0% 0% 0% 0% 0%
35 Position TA15 0 0% 0% 0% 0% 0% 0%
36 In Box 3, estimate the percentage of time each position is likely to be traveling in -country and the per diem and
37 monthly transportaion costs for each position. As this will be unique for each position, be sure to note how it
38 was derived in a note box. Box 4 and 5 are self -explanatory. Check the purple and turquoise boxes 6 an 7 at the
39
bottom to see if they look realistic. Then move to the Office by clicking on the tab.
40
41
42 #3 TRAVEL #4 BENEFITS #5 BOARD HONORARIA
Positions Estimate Per Trans per
43 % of time diem mo % Social Security 8% # local members 5
44 Executive Director 10% 100 100 % Benefits 19% # visiting members 5
45 Accountant 0% # vacation days 14 # mtgs per yr 4
46 Secretary 5% 100 15 # Holidays 10 # mtgs this year 3
47 0 Average Sick days 5 Honoraria per visit 0
48 Senior Analyst Travel for meetings 50
49 Jr. Systems Per diem 0
50 Systems Analyst
51 Software designer
52 Admin Assit / jr. analyst
53 Sales
54 Senior Partner
55 Analyst
56 Bookkeeper
57 Research analyst
58 Position TA11
59 Position TA12
60 Position TA13
61 Position TA14
62 Position TA15
63
64 `
65 #6 CHECK THE SPREADSHEET BELOW. DO THESE MAKE SENSE?
66 Salary Annualized Actual
Annual Admin Fund Prog Mgmt Mon & Sales Devel TA3 Actual Admin Fund Prog Mgmt Mon & Sales Devel TA3
67 Salary Raising Eval salary Raising Eval
68 Executive Director 80000 8000 16000 32000 16000 8000 0 0 0 80000 8000 16000 32000 16000 8000 0 0 0
69 Accountant 24000 24000 0 0 0 0 0 0 0 24000 24000 0 0 0 0 0 0 0
70 Secretary 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
71 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
72 Senior Analyst 50000 0 0 37500 7500 5000 0 0 0 50000 0 0 37500 7500 5000 0 0 0
73 Jr. Systems 24000 0 0 14400 8400 1200 0 0 0 12000 0 0 7200 4200 600 0 0 0
74 Systems Analyst 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
75 Software designer 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
76 Admin Assit / jr. analyst 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
77 Sales 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
78 Senior Partner 70000 0 0 17500 17500 0 0 35000 0 35000 0 0 8750 8750 0 0 17500 0
79 Analyst 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
80 Bookkeeper 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
81 Research analyst 24000 0 0 0 0 0 0 0 0 12000 0 0 0 0 0 0 0 0
82 Position TA11 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
83 Position TA12 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
84 Position TA13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
85 Position TA14 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
86 Position TA15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
87 TOTAL 272000 32000 16000 101400 49400 14200 0 35000 0 213000 32000 16000 85450 36450 13600 0 17500 0
88
89
90 # 7 Travel Annualized Actualized
Per Diem Admin Prog Mgmt Mon & Sales Devel TA3 Admin Prog Mgmt Mon & Sales Devel TA3
91 Assist Eval Eval
92 Executive Director 231 924 462 231 0 0 0 231 924 462 231 0 0 0
93 Accountant 0 0 0 0 0 0 0 0 0 0 0 0 0 0
94 Secretary 1155 0 0 0 0 0 0 1155 0 0 0 0 0 0
95 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
96 Senior Analyst 0 0 0 0 0 0 0 0 0 0 0 0 0 0
97 Jr. Systems 0 0 0 0 0 0 0 0 0 0 0 0 0 0
98 Systems Analyst 0 0 0 0 0 0 0 0 0 0 0 0 0 0
99 Software designer 0 0 0 0 0 0 0 0 0 0 0 0 0 0
100 Admin Assit / jr. analyst 0 0 0 0 0 0 0 0 0 0 0 0 0 0
101 Sales 0 0 0 0 0 0 0 0 0 0 0 0 0 0
102 Senior Partner 0 0 0 0 0 0 0 0 0 0 0 0 0 0
103 Analyst 0 0 0 0 0 0 0 0 0 0 0 0 0 0
104 Bookkeeper 0 0 0 0 0 0 0 0 0 0 0 0 0 0
105 Research analyst 0 0 0 0 0 0 0 0 0 0 0 0 0 0
106 Position TA11 0 0 0 0 0 0 0 0 0 0 0 0 0 0
107 Position TA12 0 0 0 0 0 0 0 0 0 0 0 0 0 0
108 Position TA13 0 0 0 0 0 0 0 0 0 0 0 0 0 0
109 Position TA14 0 0 0 0 0 0 0 0 0 0 0 0 0 0
110 Position TA15 0 0 0 0 0 0 0 0 0 0 0 0 0 0
111 TOTAL 1386 924 462 231 0 0 0 1386 924 462 231 0 0 0
Page 6
Office
A B C D E F G H I J K L M N O P Q
1 OFFICE
2 #1 OFFICE In Box 1, note the number of months the LO will be
3 How many months will the office be open this year? 12 working in this budget year. In Box 2, capital costs
4 are detailed. The categories in blue are fixed. You
5 #2 EQUIPMENT can add up to three additional capital categories by
Unit Cost Mainten- How moving the cursor over the gray xxx's and enter a
6 ance/mo. many? new category of capital costs. For each entry add the
7 local currency unit cost and maintenance cost per month for each
8 Computer / automation 3500 0 3 unit. Finally, enter the number of units to be
9 Printer 500 20 0 purchased.
10 Typewriter 300 5 0
11 Copier 0 260 1
12 Telephones 0 275 1
13 Fax 500 0 1 CHECK HERE: DO THESE MAKE
14 xxx SENSE?
15 xxx Cost Cost
16 Vehicle 100 Equipment 18920 Vehicle 1200
17 Furniture 2000 0 NA Furniture 2000
18 In Box 3 and 4 indicate the start-up and ongoing costs for recurring and non recurring costs. On-going costs can be
19 distributed across functional area with the exception of those in dark green. Most of the categories are fixed. However,
20
for both recurring and non recurring costs two categories (shown in gray) can be added. For any cost that cannot be
21
22
noted on a monthly basis, make a note how the cost was derived (Insert, Note). Consultant costs, other than TA
23 consultants, are accounted for on the last line of non-recurring costs. Check Box 5 after you are done to see if
24 the total make sense.
25 #3 RECURRING OFFICE COSTS
Start-up Admin Fund Mon & Sales Devel TA3
26 Raising Prog Mgmt Eval
27 Monthly Costs Enter local currency per month
28 Rent 2400 1200
29 Utilities 100
30 Insurance 100
31 Cleaning, Maint. & Repairs 100
32 Bank Charges 25
33 Postage, Phone, Fax, Courier,On-line 200
34 Printing, Stationery & Supplies 100
35 Hospitality (Coffee & Tea) 100
36
37 xxx
38
39 #4 NON-RECURRING OFFICE COSTS
Start-up Admin Fund Mon & Sales Devel TA3
40 Raising Prog Mgmt Eval
41 Non-monthly cost Enter local currency and attach notes about payment
42 Training Materials/Books 100 100 100
43 Subscriptions 500
44 Advertising 1200 3000 6000
45 Professional fees 6000
46 Moving fees / setup 8000
47 Consultancy Fee 3000
48 Host Institution Support
49
50 #5 DO THESE TOTALS LOOK RIGHT?
51 ANNUALIZED ACTUAL
52 Admin Prog Assist Mgmt Assst Mon&Eval Sales Devel TA3 Start-up Admin Prog Assist Mgmt AssstMon&Eval Sales Devel TA3
53 Rent 14400 0 0 0 0 0 0 Rent 2400 14400 0 0 0 0 0 0
54 Utilities 1200 0 0 0 0 0 0 Utilities 0 1200 0 0 0 0 0 0
55 Insurance 1200 0 0 0 0 0 0 Insurance 0 1200 0 0 0 0 0 0
56 Cleaning, Maint. & Repairs 1200 0 0 0 0 0 0 Clean etc 0 1200 0 0 0 0 0 0
57 Bank Charges 300 0 0 0 0 0 0 Bank Charges 0 300 0 0 0 0 0 0
58 Postage, Phone, Fax, Courier 2400 0 0 0 0 0 0 Postage 0 2400 0 0 0 0 0 0
59 Printing, Stationery & Supplies 1200 0 0 0 0 0 0 Printing 0 1200 0 0 0 0 0 0
60 Hospitality (Coffee & Tea) 1200 0 0 0 0 0 0 Hospitality (Coffee & Tea) 0 1200 0 0 0 0 0 0
61 0 0 0 0 0 0 0 0 Professional fees 0 0 0 0 0 0 0 0
62 xxx 0 0 0 0 0 0 0 Moving fees / setup 0 0 0 0 0 0 0 0
63 Non-monthly cost Non-monthly cost
64 Training Materials/Books 0 100 100 100 0 0 0 Training Materials/Books 0 0 100 100 100 0 0 0
65 Subscriptions 500 0 0 0 0 0 0 Subscriptions 0 500 0 0 0 0 0 0
66 Advertising 1200 0 0 0 6000 0 0 Advertising 0 1200 0 0 0 6000 0 0
67 Professional fees 6000 0 0 0 0 0 0 Professional fees 0 6000 0 0 0 0 0 0
68 Moving fees / setup 8000 0 0 0 0 0 0 Moving fees / setup 0 8000 0 0 0 0 0 0
69 Consultancy Fee 3000 0 0 0 0 0 0 Consultancy Fee 0 3000 0 0 0 0 0 0
70 Host Institution Support 0 0 0 0 0 0 0 Host Institution Support 0 0 0 0 0 0 0 0
71 After checking the figures click on the button and go to the Workshops and International Travel worksheet
Page 7
Wrkshps - intl travel
A B C D E F G H I J K L M
1 WORKSHOP AND INTERNATIONAL TRAVEL
2 In Box 1 estimate workshop costs. The rows represent the types of workshops and the columns represent workshop
3 costs. The row titled "other" can be used to make a rough estimate if there is no time or information available to make NOTE: FOR
4 TOTAL TO
a more detailed estimate. YOU MUST FILL IN "NUMBER OF WKSHOPS."
5 REGISTER
6 # 1 WORKSHOPS AND CONFERENCES FILL IN NO.
7 Number Preparation (enter currency) Presenters Participants Other OF WRKSHPS
of wkshps Materials Space Food Publicity Speaker Per Diems Travel Per Diems Travel
8 rental fees TOTAL
9 Admin 1 600 600
10 Fund Raising 1 500 500
11 Prog 1 500 500
12 Mgmt 1 500 500
13 Mon & Eval 0 0
14 Sales 0
15 Devel 1 400 400
16 TA3 0
17 TOTALS 5 0 0 0 0 0 0 0 0 0 2500
18 In Box 2 enter the details of international travel. There are two pre-defined categories: "Conferences" and "Intl site
19
visits". You can define up to 3 more categories. Move across the columns and fill in the appropriate information.
20
21
Use NOTE INSERTS to specify conference names. Check to totals to see if they look right.
22
23 #2 INTERNATIONAL TRAVEL
# Days Av Per Airfare Admin Fund Prog Mgmt Mon & Eval Sales Devel TA3
24 Diem Raising
25 How many are going from each functional area?
26 Conferences 0 100 0 1
27 Intl Site Visits
28 xxxx
29 xxxx
30 xxxx
31 TOTAL COST 0 0 0 0 0 0 0 0
32 THAT'S IT! Now click on the gray button to check on how your entries have been translated into an actual and
33 annualized budget. It will be useful to print out these budgets to see them as a whole. SAVE THE WORKSHEETS
34
BY USING PRESSING F12 and saving the spreadsheet under a new name.
35
36
37 If you find any areas that do not look right, or the percentages for the categories do not approximate the Alliance
38 guidelines, go back to the worksheet in that areas and redo some of the assumptions.
39
40 DO NOT CHANGE FIGURES DIRECTLY IN THE BUDGET SPREADSHEETS!! GO BACK TO THE WORKSHEET
41 WITH THE RELEVANT ASSUMPTIONS AND CHANGE THEM. THE CHANGES WILL BE REFLECTED IN THE
42 ACTUAL AND ANNUALIZED BUDGET.
43
Page 8
PCH BUDGET ESTIMATE 1997
ACTUAL Name of the LO Partnership for Communty Health NOTES: Printed 10/3/2012
BUDGET Country: US
Budget Year: $1,997
1997 Local Currency: $
Exchange rate: US$ 1 = $1
A B C D E
START- ADMINISTRATION TECHNICAL ASSISTANCE REVENUE EXPENSES
UP COSTS Admin Brd Mtngs Fund TOTAL Prog Mgmt Mon & Eval Sales Devel TA3 TOTAL Local curr
Costs Raising
Expenditures
Human Resources
Salaries $32,000 $16,000 $48,000 $85,450 $36,450 $13,600 $0 $17,500 $0 $153,000 $201,000
Benefits $6,080 $3,040 $9,120 $16,236 $6,926 $2,584 $0 $3,325 $0 $29,070 $38,190
Social Security $2,560 $1,280 $3,840 $6,836 $2,916 $1,088 $0 $1,400 $0 $12,240 $16,080
Honoraria $0 $0 $0
Consultancy Fees $0 $0 $0 $0 $97,000 $0 $0 $0 $0 $0 $97,000 $97,000
Travel & Transport $0
Per Diem & Accommodation $1,386 $0 $1,386 $924 $462 $231 $0 $0 $0 $1,617 $3,003
Vehicle expenses $1,200 $1,200
In-country Travel $1,380 $1,500 $2,880 because ta staff positions not assigned functions, just total is shown $0 $2,880
International Travel $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Workshop Cost $600 $500 $1,100 $500 $500 $0 $0 $400 $0 $1,400 $2,500
Host Institution Support $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Office Facilities
Rent $2,400 $14,400 $14,400 $16,800
Utilities $0 $1,200 $1,200 $1,200
Cleaning, Maint. & Repairs $0 $1,200 $1,200 $1,200
Furniture $2,000 $2,000
Equipment $18,920 $18,920
Insurance $0 $1,200 $1,200 $1,200
Office Functions
Postage, Phone, Fax, Courier,On-line $0 $2,400 $2,400 $0 $0 $0 $0 $0 $0 $0 $2,400
Printing, Stationery & Supplies $0 $1,200 $1,200 $0 $0 $0 $0 $0 $0 $0 $1,200
Training Materials/Books $0 $1,200 $1,200 $100 $100 $100 $0 $0 $0 $300 $1,500
Subscriptions $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Advertising $0 $0 $0 $0 $0 $0 $6,000 $0 $0 $6,000 $6,000
Hospitality (Coffee & Tea) $0 $1,200 $1,200 $0 $0 $0 $0 $0 $0 $0 $1,200
Bank Charges $0 $300 $300 $300
Other $0 $14,000 $14,000 $0 $0 $0 $0 $0 $0 $0 $14,000
Grants to NGOs / CBOs $455,000
Total excluding cont & float $24,520 $82,306 $1,500 $20,820 $104,626 $207,046 $47,354 $17,603 $6,000 $22,625 $0 $300,627 $455,000 $429,773
Contingencies $2,469.18 $45.00 $624.60 $3,139 $6,211.37 $1,420.61 $528.09 $180.00 $678.75 $0.00 $9,019 $12,158
Total Excluding Float $84,775 $1,545 $21,445 $107,765 $213,257 $48,774 $18,131 $6,180 $23,304 $0 $309,646 $455,000 $441,931
Float
TOTAL EXPENDITURE $24,520 $84,775 $1,545 $21,445 $107,765 $213,257 $48,774 $18,131 $6,180 $23,304 $0 $309,646 $455,000 $441,931
Percent of total 5.5% 19.2% 0.3% 4.9% 24.4% 48.3% 11.0% 4.1% 1.4% 5.3% 0.0% 70.1% 103.0% 100.0%
Page 9
Annualized
A B C D E F G H I J K L M N O P Q
1 ANNUALIZED Name of the LO Partnership for Communty Health NOTES: Printed 10/3/2012
2 BUDGET Country: US
3 Budget Year: 1997
4 1997 Local Currency: $
5 Exchange rate: US$ 1 = 1
6 A B C D E F
7 START- ADMINISTRATION TECHNICAL ASSISTANCE REVENUE EXPENSES EXPENSES
UP COSTS Admin Brd Mtngs Fund TOTAL Prog Mgmt Mon & Sales Devel TA3 TOTAL Local curr US$
8 Costs Raising Eval
9 Expenditures
10 Human Resources
11 Salaries 32000 16000 48000 101400 49400 14200 0 35000 0 200000 248,000 $248,000
12 Benefits 6080 3040 9120 19266 9386 2698 0 6650 0 38000 47,120 $47,120
13 Social Security 2560 1280 3840 8112 3952 1136 0 2800 0 16000 19,840 $19,840
14 Honoraria 0 0 0 0 $0
15 Consultancy Fees 3000 0 3000 108000 0 0 0 0 0 108000 111,000 $111,000
16 Travel & Transport 0 $0
17 Per Diem & Accommodation 1386 0 1386 924 462 231 0 0 0 1617 3,003 $3,003
18 Vehicle Purchase 0 $0
19 In-country Travel 1380 2000 3380 because ta staff positions not assigned functions, just total is shown 0 3,380 $3,380
20 International Travel 0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
21 Other Workshop Cost 600 500 $1,100 $500 $500 $0 $0 $400 $0 $1,400 $2,500 $2,500
22 Host Institution Support 0 0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
23 Office Facilities
24 Rent 14400 $14,400 $14,400 $14,400
25 Utilities 1200 $1,200 $1,200 $1,200
26 Cleaning, Maint. & Repairs 1200 $1,200 $1,200 $1,200
27 Furniture $0 $0
28 Equipment $0 $0
29 Insurance 1200 $1,200 $1,200 $1,200
30 Office Functions
31 Postage, Phone, Fax, Courier,On-line 2400 $2,400 $0 $0 $0 $0 $0 $0 $0 $2,400 $2,400
32 Printing, Stationery & Supplies 1200 $1,200 $0 $0 $0 $0 $0 $0 $0 $1,200 $1,200
33 Training Materials/Books 1200 $1,200 $100 $100 $100 $0 $0 $0 $300 $1,500 $1,500
34 Subscriptions 0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
35 Advertising 0 $0 $0 $0 $0 $6,000 $0 $0 $6,000 $6,000 $6,000
36 Hospitality (Coffee & Tea) 1200 $1,200 $0 $0 $0 $0 $0 $0 $0 $1,200 $1,200
37 Bank Charges 300 $300 $300 $300
38 Other 14000 $14,000 $0 $0 $0 $0 $0 $0 $0 $14,000 $14,000
39 Grants to NGOs / CBOs $813,168 $0
40 Total excluding cont & float 85306 2000 20820 $108,126 $238,302 $63,800 $18,365 $6,000 $44,850 $0 $371,317 $813,168 $479,443 $479,443
41 Contingencies 8530.6 200 2082 $10,813 $23,830 $6,380 $1,837 $600 $4,485 $0 $37,132 $47,944 $47,944
42 Total Excluding Float 93837 2200 22902 $118,939 $262,132 $70,180 $20,202 $6,600 $49,335 $0 $408,449 $813,168 $527,387 $527,387
43 Float
44 TOTAL EXPENDITURE 93837 2200 22902 $118,939 $262,132 $70,180 $20,202 $6,600 $49,335 $0 $408,449 $813,168 $527,387 $527,387
45 Percent of total 18% 0% 4% 23% 50% 13% 4% 1% 9% 0% 77% 170% 100% 100%
Page 10
bud est
A B C
1 TWO YEAR BUDGET ESTIMATE
2
3 INCOME 1996 1997
4 Direct TA to CBOs (including proposal writing) $210,500.00 $230,000.00
5 Contracts (Govt. & Proj Grants) $210,000.00 $240,000.00
6 Sales $4,500.00 $10,000.00
7 Mail Solicitations/Individual contributions/gifts $15,000.00 $333,168.00
8 Special events $0.00
9 Corporate Gifts $15,000.00
10 TOTAL INCOME $455,000.00 $813,168.00
11
12 EXPENSES
13 Events $0.00 $9,000.00
14 Utilities $1,200.00 $1,200.00
15 Printing $1,200.00 $1,200.00
16 Postage, Phone, Fax, Courier,On-line $2,400.00 $3,600.00
17 Professional Fees (accounting, legal, writing, etc.) $14,000.00 $17,000.00
18 Office supplies (including start-up furniture etc.) $2,000.00 $1,000.00
19 Travel $5,883.00 $6,383.00
20 Rent $16,800.00 $14,400.00
21 Equipment (computers, fax, printers, etc.) $18,920.00 $5,000.00
22 Miscellaneous (administrative, adversting, etc.) $12,700.00 $12,700.00
23 Other projects (consultancy fees) $97,000.00 $108,000.00
24 Staff Salaries and Benefits $255,270.00 $314,960.00
25 TOTAL EXPENSES (including 10% contingency except startup) $468,274.30 $543,887.30
26 EXCESS -$13,274.30 $269,280.70
Page 11
pchbud
A B C D E F G H I J K L M
1 ACTUAL
2 BUDGET PCH Expenses - 1997
3
4 1997
5 Office Functions
5%
6 Office Facilities
9%
7 ESTIMATED
8 EXPENSES Total Travel &
9 Expenditures Transport
6%
10 Human Resources Human Resources
11 Salaries $201,000 Salaries $277,167
Consultancy
12 Benefits $38,190 Benefits $69,292 Fees
13 Social Security $16,080 Social Security $27,717 9% Salaries
14 Honoraria $0 53%
15 Consultancy Fees $97,000 Consultancy Fees $44,000
Social Security
16 Travel & Transport Travel & Transport $27,883 5%
17 Per Diem & Accommodation $3,003
18 Vehicle Purchase $1,200
19 In-country Travel $2,880 Benefits
20 International Travel $0 13%
21 Other Workshop Cost $2,500
22 Host Institution Support
23 Office Facilities Office Facilities $48,320
24 Rent $16,800
25 Utilities $1,200
26 Cleaning, Maint. & Repairs $1,200
27 Furniture $2,000
28 Equipment $18,920
29 Insurance $1,200
30 Office Functions Office Functions $26,600
31 Postage, Phone, Fax, Courier,On-line $2,400
32 Printing, Stationery & Supplies $1,200
33 Training Materials/Books $1,500
34 Subscriptions $0
35 Advertising $6,000
36 Hospitality (Coffee & Tea) $1,200
37 Bank Charges $300
38 Other (professsional) $14,000
39 Grants to NGOs / CBOs $0
40 Total excluding cont & float $429,773 $0
41 Contingencies $12,158
42 Total Excluding Float $441,931
43 Float $0
44 TOTAL EXPENDITURE $441,931
45 Percent of total 100%
Page 12
PCH EXPENSES - 1997 Estimate
Devel
Sales 6%
Mon & Eval 2%
Admin Costs
4%
20%
Mgmt
12%
Brd Mtngs
0%
Fund Raising
5%
Prog
51%
Office Functions
Office Facilities 5%
9%
Travel &
Transport
6%
Consultancy
Fees
9% Salaries
53%
Social Security
5%
TOTAL EXPENSES
Benefits $569,924
13%
PCH REVENUE 1997
mail solicitations/ind corporate gifts
special events 2% 3%
0%
Project grants
7%
Major gifts
1%
Sales
1%
Writing/editing/proposa
l writing
7%
Direct TA to CBOs
40%
2a65ef87-42c8-42a4-9887-575b24f4d0d0.xls 10/3/2012
40%
Contracts
39%
TOTAL REVENUE - $596,512
2a65ef87-42c8-42a4-9887-575b24f4d0d0.xls 10/3/2012
