A | B | C | D | E | F | G | H | I | J | K | L | M | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | There are three tables in this spreadsheet: 1) the Project Budget Table, 2) the Personnel Detail Table and 3) the Leverage Table. Please complete all three tables. | ||||||||||||
3 |
Project Budget Table Instructions: 1. This budget table includes cells for entering numbers and cells for entering text descriptions. 2. Each row represents a category of expense (cost). Costs can be entered for project timeframes of up to 5 years. For each type of expense, there are cells for costs and cells for a brief description about what the funds will pay for: Costs are provided in Columns C, E, G, I, and K and descriptions are provided in Columns D, F, H, J, and L. Description examples are provided in the row notes (Column M). 3. The cost cells for each expense category ask for the dollar amount requested of PCEF. Any costs paid for by another source will be reflected in the leverage table. For example, if your project includes the purchase of 100 trees and you are requesting $15 per tree from PCEF and you $10 per tree will be paid by another source, you would enter $1,500 as the cost (not $2,500). The $1,000 tree costs that are not part of your budget request show up in your leverage/match contribution. 4. Enter information in the clear cells for which your project has an expense. If your project does not have any expenses in a certain category leave that cell blank. Do not enter information into shaded cells. 5. Overhead expenses are capped as follows: 10% on contracts, travel, and equipment/supplies/material; 20% on personnel and other. 6. The personnel costs in the Project Budget Table should equal the total personnel costs in the Personnel Table (below); check to be sure this is correct. 7. The value for match resources will carry over from the total calculated in the Leverage Table (below); be sure to check that this value is correct. |
||||||||||||
5 | PROJECT BUDGET TABLE | ||||||||||||
6 | Total (C+E+G+I+K) | Year 1 Costs | Description of Year 1 project costs. Brief instructions are provided by row; examples can be found in the Application Guidance Document. | Year 2 Costs | Description of Year 2 project costs if applicable. Brief instructions are provided by row; examples can be found in the Application Guidance Document. | Year 3 Costs | Description of Year 3 project costs if applicable. Brief instructions are provided by row; examples can be found in the Application Guidance Document. | Year 4 Costs | Description of Year 4 project costs if applicable. Brief instructions are provided by row; examples can be found in the Application Guidance Document. | Year 5 Costs | Description of Year 5 project costs if applicable. Brief instructions are provided by row; examples can be found in the Application Guidance Document. | Explanations for rows. | |
7 | Personnel (staff of your organization working on the project) | $ - | $ - | $ - | This row describes the personnel from your organization that will be working on the project, broken out by year. The costs are calculated below in the personnel table. The description say what is being funded either as FTE (Full Time Equivalent) or total hours over the life of the project. For example, 0.5 FTE outreach coordinator (1040 hours), 0.25 FTE program manager (520 hours) Year One, 0.20 FTE outreach coordinator (416 hours), 0.40 FTE program manager (832 hours) Year Two. | ||||||||
8 | Travel | $ - | $ - | $ - | This row describes project-related travel expenses. Examples include travel to meetings or conferences, accommodations and per diem if the conference or meeting is out of the area. The description should include enough detail to understand the cost. For example, One round trip flight ($380), two nights hotel ($360), two per diem ($120), conference registration ($350), etc. | ||||||||
9 | Equipment, supplies and materials | $ - | $ - | $ - | This row describes purchases that are needed for the project. The description should provide enough detail to understand the cost. For example, room rental for three community meetings ($150 X 3 = $450), food and beverage for three meetings estimating around 50 people per meeting ($12/person X 50people X 3 meetings = $1,800), etc. | ||||||||
10 | Contracted work | $ - | $ - | $ - | This row describes payments to businesses or organizations to conduct work for the project. Examples might include nonprofit partners or for-profit businesses. The description should provide enough detail to understand the cost. For example, contract to weatherize 100 homes, estimating around $30,000 per home for $3 million total contract; facilitation consultant for three meetings total $5,000, etc. | ||||||||
11 | Other | $ - | $ - | $ - | This row describes costs that do not fit within one of the categories above. The description should include enough detail to understand the cost. | ||||||||
12 | Expense Category Subtotals | $ - | $ - | $ - | This row is automatically calculated. It is the total for rows 5-9. | ||||||||
13 | |||||||||||||
14 | Overhead/indirect | $ - | This row is for overhead costs such as rent, utilities, administration, insurance, websites, etc. These are sometimes called indirect costs or admin costs. Overhead costs on PCEF projects cannot exceed 10% for travel, material, and contract costs and cannot exceed 20% for other costs including personnel. | ||||||||||
15 | Fiscal sponsor fee (if applicable) | $ - | This row describes fees charged by your fiscal sponsor. Fiscal sponsor fees cannot exceed 10% of the project budget. | ||||||||||
16 | Percent total overhead/admin/fiscal sponsor fee | 0.0% | <--If RED, include justification for exceeding 25% cap | The combined overhead of projects with a fiscal sponsor may exceed 25% if justification is provided. | |||||||||
17 | PCEF Request | $ - | This figure is your request for PCEF funds. It includes your expense categories total, overhead, and fiscal sponsor charges (if applicable). | ||||||||||
18 | Match/leverage | $ - | This figure describes project funding from other sources (e.g., grants, donations, in-kind contributions). The figure entered here comes from the Leverage Worksheet. | ||||||||||
19 | Total Project Cost | $ - | This figure describes the project budget (total cost) and includes PCEF funds as well as other contributions to the project budget (e.g., grants, in-kind contributions). | ||||||||||
21 | PERSONNEL BUDGET TABLE | ||||||||||||
22 | The personnel budget table is for the cost of personnel (staff) from your (the applicant) organization that are working on the project. Column A asks for the title of the position; list one position per line. If multiple people occupy the position and earn the same wage and fringe, these positions can be consolidated. Column B asks for the hourly wage rate, this is the amount per hour that someone is paid. Column C asks for the hourly fringe rate which includes non-wage hourly costs such as health insurance, vacation, and taxes. This figure should not include overhead costs as those are included in another line. Column D asks for the estimated hours this person will work on the PCEF funded project and includes the total hours across the life of the project (all years). For example, if the person will work 20 hours per week in year 1 and 40 hours per week in years 2 and 3 you would include the hours for all three years. Column E is calculated for you based on the number of hours (Column D) times the total wage cost (B + C or hourly + fringe). Add rows if needed. NOTES: 1) The personnel costs entered here are only for staff of your organization. 2) All people working on PCEF funded projects must be paid at least 180% of minimum wage for the time they spend working on the PCEF project. | ||||||||||||
23 | Position Title | Hourly Wage Rate |
Hourly Fringe Rate (including Benefits & Payroll Taxes) |
Estimated Hours | Total Cost | ||||||||
24 | $ - | ||||||||||||
25 | $ - | ||||||||||||
26 | $ - | ||||||||||||
27 | $ - | ||||||||||||
28 | $ - | ||||||||||||
29 | $ - | ||||||||||||
30 | $ - | ||||||||||||
31 | $ - | ||||||||||||
32 | $ - | ||||||||||||
34 | LEVERAGE TABLE | ||||||||||||
35 | This table provides information about the non-PCEF resources that you will use to complete the proposed project. Non-PCEF resources might include grants, donations, and in-kind contributions. You are not required to have non-PCEF resources to apply for or receive a PCEF grant. Add additional lines to the table below as needed. | ||||||||||||
36 | Funding source (choose from list) | Name of funding source | Type of resource (choose from list) | Is resource secured or planned for? (choose from list) | Value of resource ($ or equivalent) | If in-kind please describe | |||||||
46 | Total leverage/match | $ - |
A | B | C | |
---|---|---|---|
2 | Government | Cash | Secured |
3 | Bank loan | In-Kind | Planned |
4 | Cash reserves | ||
5 | Other |