EPA-R-HQ-SFA-23-01 - Template - Attachment E Budget Table.xlsx
XLSX spreadsheet 73 KB Posted
- Attached to
- SOLAR FOR ALL
- Opportunity number
- EPA-R-HQ-SFA-23-01
- Issued by
-
Environmental Protection Agency
About this file
This document provides an optional budget table template for applicants to the EPA's Solar for All grant opportunity under Assistance Listing Number 66.959, the Greenhouse Gas Reduction Fund Section 134(a)(1) Zero Emission Technologies grant program. The template details how applicants can demonstrate their budget is efficient and ensures at least 80% of costs go toward direct financial assistance. Applicants may fill in itemized costs by category for each of up to five years, with totals by year and in total. The template also specifies whether each cost is considered financial assistance. Instructions provide guidance on completing the template to meet the grant program requirements.
Attachment E - Budget Table
View the file
Other files
| File | Type | Posted |
|---|---|---|
| EPA-R-HQ-SFA-23-01 Revised 2023 08 31.pdf | ||
| EPA-R-HQ-SFA-23-01 - Template - Attachment D Timeline & Workplan.xlsx | XLSX spreadsheet | |
| EPA-R-HQ-SFA-23-01 - Template - Attachment D Timeline & Workplan (rev 7.5.23).xlsx | XLSX spreadsheet | |
| EPA-R-HQ-SFA-23-01 - Residential Distributed Solar Resources.xlsx | XLSX spreadsheet | |
| EPA-R-HQ-SFA-23-01.pdf |
On GovTribe
Work with this file
- 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 with relevant information for their program in black, non-italicized text |
Introduction:
This Excel Workbook is an optional template for applicants to fill in and submit as Attachment E: Budget Table as described in Section 2.1 Budget Narrative of the Application Materials for the Greenhouse Gas Reduction Fund - Solar for All competition. This is an optional template and applicants will not be penalized if they do not use these materials. If you do use these materials, you may upload the file as an Excel titled per the instructions in the Notice of Funding Opportunity.
This template details how an applicant can demonstrate that the budget is efficient as well as how the applicant will ensure the budget achieves the target minimum allocation of costs to financial assistance described in the table below.
Please see the Notice of Funding Opportunity for guidance on how to create this budget table. In particular, refer to Appendix B. Program Budget for detailed guidance on how each of the cost categories detailed in column C of the template.
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 B. Program Budget
- In columns D through H, fill in the cost for the line item per year, including subtotals for each budget category - personnel, fringe benefits, travel, equipment, installation, or labor supplies, contractual costs, and other direct costs (i.e., subawards, participant support costs), and indirect costs (note: the template examples only have year 1 values included, yet applicants must fill in costs for every year the program operates)
- In column J, calculate the total cost for the line item for the entire program, including subtotals for each budget category - personnel, fringe benefits, travel, equipment, installation, or labor supplies, contractual costs, and other direct costs (i.e., subawards, participant support costs), and indirect costs
- In column L, fill in for each itemized cost if the cost is financial assistance; this column is to help applicants demonstrate that the budget follows the program guidance on share of funds used for financial assistance; at the bottom of the table, please calculate the share of costs in each activity bucket (currently row 57 in the template)
2.1 Budget Table Template
| Detailed Budget Table |
| An OPTIONAL template for applicants to fill in and submit in the Application Materials, Attachment E: Budget Table described in in Section 2.1 of the Program Narrative |
| BUDGET BY YEAR | TOTAL BUDGET BY ACTIVITY BUCKET | |||||||
| COST-TYPE | CATEGORY | YEAR 1 | YEAR 2 | YEAR 3 | YEAR 4 | YEAR 5 | TOTAL | FINANCIAL ASSISTANCE |
| Direct Costs | Personnel | |||||||
| 3 FTE Program Manager @ $110,000/yr | $330,000 | $330,000 | ||||||
| 1 FTE Outreach Coordinator @ $70,000/yr | $75,000 | $75,000 |
| TOTAL PERSONNEL | $405,000 | $405,000 |
| Fringe Benefits | ||
| Program Managers @ 20% of salary | $66,000 | $66,000 |
| Outreach Coordinator @ 20% of salary | $15,000 | $15,000 |
| TOTAL FRINGE BENEFITS | $81,000 | $81,000 |
| Travel | ||
| Travel for 2 staff to attend DOE technical assistance workshops | ||
| Airfare: 2 @ $600 round trip | $1,200 | $1,200 |
| Per Diem: 2 staff X 4 days @ $60/day | $480 | $480 |
| Hotel: 2 staff X 3 nights @ $250/night | $1,500 | $1,500 |
| Local Mileage | ||
| Outreach Coordinator, 100 mi/mo @ $.54/mi x 12 mo | $648 | $648 |
| TOTAL TRAVEL | $3,828 | $3,828 |
| Equipment | ||
| Data Server | $75,000 |
| TOTAL EQUIPMENT | $0 | |
| Supplies | ||
| Office and related supplies to support outreach meetings, trainings, etc | $10,000 | $10,000 |
| TOTAL SUPPLIES | $10,000 | $10,000 |
| Contractual | ||
| Program planning technical assistance - National Lab tools and services | $150,000 | $150,000 |
| Translation services for community meetings | $10,000 | $10,000 |
| Energy system modeling services | $200,000 | $200,000 |
| TOTAL CONTRACTUAL | $22,360,000 | $22,360,000 | |
| OTHER | |||
| Subgrant to Municipality A | $2,000,000 | $2,000,000 | $1,500,000 |
| Subgrant to Municipality B | $2,000,000 | $2,000,000 | $1,500,000 |
| Subgrant to Program Administrator | $22,000,000 | $22,000,000 | $22,000,000 |
| Subgrant for workforce development training program | $2,000,000 | $2,000,000 | |
| Printing and publication services | $600 | $600 |
| TOTAL OTHER | $6,000,600 | $6,000,600 |
| TOTAL DIRECT | $28,860,428 | $28,860,428 |
| Indirect Costs | Indirect Costs | |
| Indirect costs on financial assistance direct costs | ||
| Indirect costs on other direct costs | ||
| TOTAL INDIRECT | $0 |
| TOTAL FUNDING | $28,860,428 | $28,860,428 | $23,000,000 |
| Share of funding by activity | 80% |
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 |
image1.png
File details come from the government source that posted it. Updated .