EPA-R-HQ-CCIA-23-01 - Template - Budget Table.xlsx
XLSX spreadsheet 41 KB Posted
- Attached to
- Clean Communities Investment Accelerator (CCIA) Federal grant opportunity
- Opportunity number
- EPA-R-HQ-CCIA-23
- Issued by
- Environmental Protection Agency
About this file
This document provides an optional budget table template for applicants to the Clean Communities Investment Accelerator (CCIA) federal grant opportunity issued by the Environmental Protection Agency under the Greenhouse Gas Reduction Fund: National Clean Investment Fund federal grant program. The template includes instructions and examples for applicants to itemize costs by budget category for each year and total for the period of performance. Applicants must ensure at least 80% of funds are allocated to capitalization funding passed through to community lenders and at least 90% to capitalization funding and technical assistance subawards combined. The due date is not provided.
EPA-R-HQ-CCIA-23-01 - Template - Budget Table
View the file
Other files for this federal grant opportunity
| File | Type | Posted |
|---|---|---|
| EPA-R-HQ-CCIA-23-01.v2.pdf | ||
| EPA-R-HQ-CCIA-23-01.pdf |
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Overview
| Legend | |
| Text | Example inputs - applicants should delete information in these cells and replace it with relevant information for their program in black, non-italicized text |
| Costs for capitalization funding and technical assistance subawards for different industry networks - applicants may disaggregate these costs to facilitate consideration of an application for partial funding, to the extent practicable and if proposing to serve multiple networks |
Introduction:
This Excel Workbook is an optional template for applicants to fill in and submit as the detailed budget table, which is described in Section 1.4.2 of the Narrative Proposal, for the Greenhouse Gas Reduction Fund - Clean Communities Investment Accelerator competition. This is an optional template, and applicants will not be penalized if they do not use the template. If you do use this template, you may upload the file as an Excel titled per the instructions in the Notice of Funding Opportunity.
Please see the Notice of Funding Opportunity for guidance on how to create this budget table. In particular, refer to Appendix D: Program Budget for detailed guidance.
Instructions:
Below is a description of the steps an applicant should complete to finish the template.
- In column C, add and subtract rows to detail itemized costs (and specific descriptions of costs) in each cost category per the guidance in Appendix D: Program Budget.
- In columns D through I, fill in the cost for the line item per year, including subtotals for each budget category - personnel, fringe benefits, travel, equipment, supplies, contractual, and other direct costs (e.g., subawards, participant support costs, other) as well as indirect costs (note: the template examples only have year 1 values included, yet applicants must fill in costs for every year of the applicant's proposed period of performance). As directed in Appendix D: Program Budget, ensure that costs are aggregated and separated from all other costs for two specific categories: (1) capitalization funding and (2) technical assistance subawards.
- In column K, calculate the total cost for the line item for the entire program, including subtotals for each budget category - personnel, fringe benefits, travel, equipment, supplies, contractual, and other direct costs (e.g., subawards, participant support costs, other) as well as indirect costs.
- At the bottom of the table (rows 66-67 of the template), calculate the share of funds passed through to community lenders in the form of capitalization funding (both the direct costs of funds passed through as well as associated indirect costs), which must be a minimum of 80% for the entire program, as well as the share of funds passed through to community lenders in the form of both for capitalization funding and technical assistance subawards (both the direct costs of funds passed through as well as associated indirect costs), which must be a minimum of 90% for the entire program.
Budget Table Template
| Budget Table Template |
| An OPTIONAL template for applicants to fill in and submit as the detailed budget table, which is described in Section 1.4.2 of the Narrative Proposal |
| BUDGET BY YEAR | ||||||||
| COST-TYPE | CATEGORY | YEAR 1 | YEAR 2 | YEAR 3 | YEAR 4 | YEAR 5 | YEAR 6 | TOTAL |
| Direct Costs | Personnel | |||||||
| 4 FTE Program Manager @ $110,000/yr (100% Assigned) | $440,000 | |||||||
| 3 FTE Outreach Coordinator @ $70,000/yr (50% Assigned) | $105,000 |
| TOTAL PERSONNEL | $545,000 |
| Fringe Benefits | |
| Program Managers @ 20% of salary | $88,000 |
| Outreach Coordinator @ 20% of salary | $21,000 |
| TOTAL FRINGE BENEFITS | $109,000 |
| Travel | |
| Travel for 2 staff to attend DOE technical assistance workshops | |
| Airfare: 2 @ $600 round trip | $1,200 |
| Per Diem: 2 staff X 4 days @ $60/day | $480 |
| Hotel: 2 staff X 3 nights @ $250/night | $1,500 |
| Local Mileage | |
| Outreach Coordinator, 100 mi/mo @ $.54/mi x 12 mo | $648 |
| TOTAL TRAVEL | $3,828 |
| Equipment | |
| Data server | $75,000 |
| TOTAL EQUIPMENT | $75,000 |
| Supplies | |
| Office and related supplies (e.g., paper, pens) | $10,000 |
| TOTAL SUPPLIES | $10,000 |
| Contractual | |
| Emissions data subscription | $250,000 |
| Financial data subscription | $125,000 |
| Contract with affordable housing decarbonization experts | $150,000 |
| Translation services for community meetings | $10,000 |
| Climate scenario analysis modeling services | $75,000 |
| TOTAL CONTRACTUAL | $610,000 |
| OTHER | |
| Insurance | $10,000 |
| Capitalization funding characterized as "subawards" (i.e., subgrants) | |
| Capitalization funding – industry network #1 (subawards) | $15,000,000 |
| Capitalization funding – industry network #2 (subawards) | $15,000,000 |
| Capitalization funding characterized as "participant support costs" (i.e., subsidies) | |
| Capitalization funding – industry network #1 (PSCs) | $15,000,000 |
| Capitalization funding – industry network #2 (PSCs) | $15,000,000 |
| Technical assistance subawards | |
| Technical assistance subawards – industry network #1 | $4,000,000 |
| Technical assistance subawards – industry network #2 | $4,000,000 |
| TOTAL OTHER | $68,010,000 |
| TOTAL DIRECT | $69,362,828 |
| Indirect Costs | Indirect Costs (Indirect Cost Rate) | 10% |
| Indirect costs on capitalization funding – industry network #1 | $30,000 | |
| Indirect costs on capitalization funding – industry network #2 | $15,000 | |
| Indirect costs on TA subawards – industry network #1 | $37,500 | |
| Indirect costs on TA subawards – industry network #2 | $25,000 | |
| Other indirect costs | $128,783 | |
| TOTAL INDIRECT | $236,283 |
| Total Funding ($) | $69,599,111 |
| Share for Capitalization Funding (%) | 86% |
| Share for Capitalization Funding and TA Subawards (%) | 98% |
Incomplete - Comment Log table
| Media: | NPM: | Regional Division: | EPA Goal: | EPA Objective: | Workplan Component | Commitment FY | Workplan Commitment | Commitment Comment | Outcome | Status | Status Comment | EPA Comment | State Comment | Comment Date | Target Completion |
| Air & Radiation | OAR | ARD | Goal 1 - Core Mission | Objective 1.1 – Improve Air Quality | Ozone, PM2.5, PM10, and CO | FY18 | Continue participation in EPA's AIRNOW program. Submit real-time pollutant data and provide forecasts and alerts. By March 1, 2018, work with EPA to enable Twitter and real-time notification features of EnviroFlash. Attend R1 air quality outreach and forecasting workshop, if held, either in person or remotely. Attend EPA's National Air Quality Conference. (FY'18-19 DRAFT OAR NPM Guidance: NAAQS, 2.1.1.3 Other, #1; and Ambient Air Monitoring for Criteria Pollutants, 2.4.1, #8) | ||||||||
| Air & Radiation | OAR | ARD | Goal 1 - Core Mission | Objective 1.1 – Improve Air Quality | Ozone, PM2.5, PM10, and CO | FY19 | |||||||||
| Air & Radiation | OAR | ARD | Goal 1 - Core Mission | Objective 1.1 – Improve Air Quality | Ozone, PM2.5, PM10, and CO | FY19 | For all future revisions to the SIP, work to implement the recommendations in the final Standard Operating Procedures document developed by EPA Region 1 and the New England states. | Complete | NH will implement these recommendations |
Standardized Terms
| Standardized Term | Definition | Also Known As | ||
| Workplan Component | A negotiated set or group of work plan commitments established in the grant agreement. A work plan may have one or more work plan components | Program Area | ||
| Workplan Commitment | The outputs and outcomes associated with each work plan component, as established in the grant agreement | Activity | Planned Accomplishments/Requirements | Output |
| Status | Short defined list of status options. Detailed status information can be captured in the comment field | |||
| Comment | ||||
| Subcomponent | a subgrouping of commitments under a larger workplan component | Related Measure |
File details come from the government source that posted it. Updated .