Budget Information Non-Construction Programs SF-424A Template.xlsx
Standard Form XLSX spreadsheet 110 KB Posted
- Opportunity number
- DE-FOA-0003495
About this file
This is a Budget Information Non-Construction Programs SF-424A template spreadsheet provided by the Department of Energy (DOE) for use with federal grant applications, specifically for a carbon conversion technology development funding opportunity (DE-FOA-0003495). The template contains multiple worksheets for detailed budget planning across three budget periods, including sections for personnel, fringe benefits, travel, equipment, supplies, contractual costs, construction, and other direct/indirect charges.
The template requires applicants to provide comprehensive cost breakdowns for both federal (DOE) and non-federal (cost share) portions, with specific instructions for calculating personnel hours, fringe benefit rates, travel expenses, and equipment purchases over $5,000. All costs must comply with 2 CFR 200 administrative requirements and applicable cost principles. The template includes automated calculations and formulas, with blue cells containing instructions and white cells for data entry. Notably, all subrecipient, contractor, and FFRDC costs must be entered under the contractual section, and the template includes the standard SF-424A government forms required for budget submissions.
Budget Information Non-Construction Programs SF-424A Template
View the file
Other versions and copies of SF 424A
Show all 20
Who attaches SF 424A
| State | Files |
|---|---|
| Massachusetts | 6 |
| California | 1 |
| Virginia | 1 |
Other files
Show all 19
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
Instructions and Summary Budget Justification (3 BPs) (February 2024) Instructions and Summary
| Award Number: | Date of Submission: | |
| Award Recipient: | Form submitted by: | |
| (May be award recipient or sub-recipient) | ||
| Please read the instructions on each worksheet tab before starting. If you have any questions, please ask your DOE contact! |
Do not modify this template or any cells or formulas!
1. If using this form for award application, negotiation, or budget revision, fill out the blank white cells in workbook tabs a. through j. with total project costs.
2. Blue colored cells contain instructions, headers, or summary calculations and should not be modified. Only blank white cells should be populated.
3. Enter detailed support for the project costs identified for each Category line item within each worksheet tab to autopopulate the summary tab.
4. The total budget presented on tabs a. through i. must include both Federal (DOE) and Non-Federal (cost share) portions.
5. All costs incurred by the preparer's sub-recipients, contractors, and Federal Research and Development Centers (FFRDCs), should be entered only in section f. Contractual. All other sections are for the costs of the preparer only.
6. Ensure all entered costs are allowable, allocable, and reasonable in accordance with the administrative requirements prescribed in 2 CFR 200, and the applicable cost principles for each entity type: FAR Part 31 for For-Profit entities; and 2 CFR Part 200 Subpart E - Cost Principles for all other non-federal entities.
7. Add rows as needed throughout tabs a. through j. If rows are added, formulas/calculations may need to be adjusted by the preparer. Do not add rows to the Instructions and Summary tab. If your project contains more than three budget periods, consult your EERE contact before adding additional budget period rows or columns.
8. ALL budget period cost categories are rounded to the nearest dollar.
SUMMARY OF BUDGET CATEGORY COSTS PROPOSED
The values in this summary table are from entries made in subsequent tabs, only blank white cells require data entry
| Section A - Budget Summary | ||||||
| Federal | Cost Share | Total Costs | Cost Share % | Proposed Budget Period Dates | ||
| Budget Period 1 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | Example!!! 01/01/2024 - 12/31/2024 | |
| Budget Period 2 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| Budget Period 3 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| Total | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| Section B - Budget Categories | ||||||
| CATEGORY | Budget Period 1 | Budget Period 2 | Budget Period 3 | Total Costs | % of Project | Comments (as needed) |
| a. Personnel | $0 | $0 | $0 | $0 | 0.00% | |
| b. Fringe Benefits | $0 | $0 | $0 | $0 | 0.00% | |
| c. Travel | $0 | $0 | $0 | $0 | 0.00% | |
| d. Equipment | $0 | $0 | $0 | $0 | 0.00% | |
| e. Supplies | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| f. Contractual | ||||||
| Subrecipient | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Contractor | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| FFRDC | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Total Contractual | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| g. Construction | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| h. Other Direct Costs | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Total Direct Costs | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| i. Indirect Charges | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Total Costs | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
Additional Explanation (as needed):
a. Personnel
| Detailed Budget Justification |
| a. Personnel |
| INSTRUCTIONS - PLEASE READ!!! |
1. List project costs solely for employees of the entity completing this form. All personnel costs for subrecipients and contractors must be included under f. Contractual.
2. All personnel should be identified by position title and not employee name. Enter the amount of time (e.g., hours or % of time) and the base hourly rate and the total direct personnel compensation will automatically calculate. Rate basis (e.g., rate negotiated for each hour worked on the project, labor distribution report, state civil service rates, etc.) must also be identified.
3. If loaded labor rates are utilized, a description of the costs the loaded rate is comprised of must be included in the Additional Explanation section below. DOE must review all components of the loaded labor rate for reasonableness and unallowable costs (e.g. fee or profit).
4. If a position and hours are attributed to multiple employees (e.g. Technician working 4000 hours) the number of employees for that position title must be identified.
5. Each budget period is rounded to the nearest dollar.
| SOPO Task # | Position Title | Budget Period 1 | Budget Period 2 | Budget Period 3 | Project Total Hours | Project Total Dollars | Rate Basis | |||||||
| Time | ||||||||||||||
| (Hrs) | Hourly Rate | |||||||||||||
| ($/Hr) | Total Budget Period 1 | Time | ||||||||||||
| (Hrs) | Hourly Rate | |||||||||||||
| ($/Hr) | Total Budget Period 2 | Time | ||||||||||||
| (Hrs) | Hourly Rate | |||||||||||||
| ($/Hr) | Total Budget Period 3 | |||||||||||||
| 1 | Sr. Engineer (EXAMPLE!!!) | 2000 | $85.00 | $170,000 | 200 | $50.00 | $10,000 | 200 | $50.00 | $10,000 | 2400 | $190,000 | ||
| 2 | Technicians (2) | 4000 | $20.00 | $80,000 | 0 | $0.00 | $0 | 0 | $0.00 | $0 | 4000 | $80,000 | ||
| $0 | $0 | $0 | 0 | $0 | ||||||||||
| $0 | $0 | $0 | 0 | $0 | ||||||||||
| $0 | $0 | $0 | 0 | $0 | ||||||||||
| $0 | $0 | $0 | 0 | $0 | ||||||||||
| $0 | $0 | $0 | 0 | $0 | ||||||||||
| $0 | $0 | $0 | 0 | $0 | ||||||||||
| $0 | $0 | $0 | 0 | $0 | ||||||||||
| $0 | $0 | $0 | 0 | $0 | ||||||||||
| $0 | $0 | $0 | 0 | $0 | ||||||||||
| $0 | $0 | $0 | 0 | $0 | ||||||||||
| $0 | $0 | $0 | 0 | $0 | ||||||||||
| $0 | $0 | $0 | 0 | $0 | ||||||||||
| $0 | $0 | $0 | 0 | $0 | ||||||||||
| $0 | $0 | $0 | 0 | $0 | ||||||||||
| $0 | $0 | $0 | 0 | $0 | ||||||||||
| $0 | $0 | $0 | 0 | $0 | ||||||||||
| $0 | $0 | $0 | 0 | $0 | ||||||||||
| $0 | $0 | $0 | 0 | $0 | ||||||||||
| $0 | $0 | $0 | 0 | $0 | ||||||||||
| $0 | $0 | $0 | 0 | $0 | ||||||||||
| $0 | $0 | $0 | 0 | $0 | ||||||||||
| $0 | $0 | $0 | 0 | $0 | ||||||||||
| $0 | $0 | $0 | 0 | $0 | ||||||||||
| $0 | $0 | $0 | 0 | $0 | ||||||||||
| TOTAL PERSONNEL | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 |
Additional Explanation (as needed):
a. Personnel Page &P of &N
a. Personnel Page &P of &N
a. Personnel Page &P of &N
a. Personnel Page &P of &N
a. Personnel Page &P of &N
a. Personnel Page &P of &N
b. Fringe
| Detailed Budget Justification |
| b. Fringe Benefits |
| INSTRUCTIONS - PLEASE READ!!! |
1. Fill out the table below by position title. If all employees receive the same fringe benefits, you can show "Total Personnel" in the Labor Type column instead of listing out all position titles.
2. The rates and how they are applied should not be averaged to get one fringe cost percentage. Complex calculations should be described/provided in the Additional Explanation section below.
3. The fringe benefit rates should be applied to all positions, regardless of whether those funds will be supported by Federal Share or Recipient Cost Share.
4. Each budget period is rounded to the nearest dollar.
| Labor Type | Budget Period 1 | Budget Period 2 | Budget Period 3 | Total Project | ||||||
| Personnel Costs | Rate | Total | Personnel Costs | Rate | Total | Personnel Costs | Rate | Total | ||
| EXAMPLE!!! Sr. Engineer | $170,000 | 20% | $34,000 | $10,000 | 20% | $2,000 | $10,000 | 20% | $2,000 | $38,000 |
| $0 | $0 | $0 | $0 | |||||||
| $0 | $0 | $0 | $0 | |||||||
| $0 | $0 | $0 | $0 | |||||||
| $0 | $0 | $0 | $0 | |||||||
| $0 | $0 | $0 | $0 | |||||||
| TOTAL FRINGE | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| A federally approved fringe benefit rate agreement, or a proposed rate supported and agreed upon by DOE for estimating purposes is required at the time of award negotiation if reimbursement for fringe benefits is requested. Please check (X) one of the options below and provide the requested information if not previously submitted. |
| ______ A fringe benefit rate has been negotiated with, or approved by, a federal government agency. A copy of the latest rate agreement is/was included with the project application.* |
______ There is not a current federally approved rate agreement negotiated and available.**
*Unless the organization has submitted an indirect rate proposal which encompasses the fringe pool of costs, please provide the organization’s benefit package and/or a list of the components/elements that comprise the fringe pool and the cost or percentage of each component/element allocated to the labor costs identified in the Budget Justification.
**When this option is checked, the entity preparing this form shall submit an indirect rate proposal in the format provided in the Sample Rate Proposal at https://netl.doe.gov/sites/default/files/2024-01/Negotiated-Indirect-Cost-Rate-Agreement-and-Rate-Proposal-Guidance-1-0.pdf, or a format that provides the same level of information and which will support the rates being proposed for use in the performance of the proposed project.
Additional Explanation (as necessary): Please use this box (or an attachment) to list the elements that comprise your fringe benefits and how they are applied to your base (e.g. Personnel) to arrive at your fringe benefit rate.
b. Fringe Benefits
b. Fringe Benefits
b. Fringe Benefits
b. Fringe Benefits
b. Fringe Benefits
b. Fringe Benefits
c. Travel
| Detailed Budget Justification |
| c. Travel |
| INSTRUCTIONS - PLEASE READ!!! |
1. Identify Foreign and Domestic Travel as separate items. Examples of Purpose of Travel are subrecipient site visits, DOE meetings, project mgmt. meetings, etc. Examples of Basis for Estimating Costs are past trips, travel quotes, GSA rates, etc.
2. All listed travel must be necessary for performance of the Statement of Project Objectives.
3. Only travel that is directly associated with this award should be included as a direct travel cost to the award. 4. Federal travel regulations are contained within the applicable cost principles for all entity types. 5. Travel costs should remain consistent with travel costs incurred by an organization during normal business operations as a result of the organizations written travel policy. In absence of a written travel policy, organizations must follow the regulations prescribed by the General Services Administration.
6. Columns E, F, G, H, I, J, and K are per trip. 7. The number of days is inclusive of day of departure and day of return. 8. Recipients should enter City and State (or City and Country for International travel) in the Depart from and Destination fields. 9. Each budget period is rounded to the nearest dollar.
| SOPO Task # | Purpose of Travel | Depart From | Destination | No. of Days | No. of Travelers | Lodging per Traveler | Flight per Traveler | Vehicle per Traveler | Per Diem Per Traveler | Cost per Trip | Basis for Estimating Costs |
| Domestic Travel | Budget Period 1 | ||||||||||
| 1 | EXAMPLE!!! Visit to PV manufacturer | 2 | 2 | $250 | $500 | $100 | $80 | $2,520 | Current GSA rates | ||
| $0 | |||||||||||
| $0 | |||||||||||
| $0 | |||||||||||
| $0 | |||||||||||
| International Travel | |||||||||||
| $0 | |||||||||||
| Budget Period 1 Total | $0 | ||||||||||
| Domestic Travel | Budget Period 2 | ||||||||||
| $0 | |||||||||||
| $0 | |||||||||||
| $0 | |||||||||||
| $0 | |||||||||||
| International Travel | |||||||||||
| $0 | |||||||||||
| Budget Period 2 Total | $0 | ||||||||||
| Domestic Travel | Budget Period 3 | ||||||||||
| $0 | |||||||||||
| $0 | |||||||||||
| $0 | |||||||||||
| $0 | |||||||||||
| International Travel | |||||||||||
| $0 | |||||||||||
| Budget Period 3 Total | $0 |
TOTAL TRAVEL $0
Additional Explanation (as needed):
c. Travel Page &P of &N
c. Travel Page &P of &N
c. Travel Page &P of &N
c. Travel Page &P of &N
c. Travel Page &P of &N
c. Travel Page &P of &N
d. Equipment
| Detailed Budget Justification |
| d. Equipment |
| INSTRUCTIONS - PLEASE READ!!! |
1. Equipment means tangible personal property (including information technology systems) having a useful life of more than one year and a per-unit acquisition cost which equals or exceeds the lesser of the capitalization level established by the non-Federal entity for financial statement purposes, or $5,000. Please refer to the applicable Federal regulations in 2 CFR 200 for specific equipment definitions and treatment.
2. List all equipment below, providing a basis of cost (e.g. contractor quotes, catalog prices, prior invoices, etc.). Briefly justify items as they apply to the Statement of Project Objectives. If it is existing equipment, provide logical support for the estimated value shown.
3. During award negotiations, provide a contractor quote for all equipment items over $50,000 in price. If the contractor quote is not an exact price match, provide an explanation in the additional explanation section below. If a contractor quote is not practical, such as for a piece of equipment that is purpose-built, first of its kind, or otherwise not available off the shelf, provide a detailed engineering estimate for how the cost estimate was derived.
4. Each budget period is rounded to the nearest dollar.
| SOPO Task # | Equipment Item | Qty | Unit Cost | Total Cost | Basis of Cost | Justification of need |
| Budget Period 1 | ||||||
| 3,4,5 | EXAMPLE!!! Thermal shock chamber | 2 | $70,000 | $140,000 | Contractor Quote - Attached | Reliability testing of PV modules- Task 4.3 |
| $0 | ||||||
| $0 | ||||||
| $0 | ||||||
| $0 | ||||||
| $0 | ||||||
| $0 | ||||||
| Budget Period 1 Total | $0 | |||||
| Budget Period 2 | ||||||
| $0 | ||||||
| $0 | ||||||
| $0 | ||||||
| $0 | ||||||
| $0 | ||||||
| $0 | ||||||
| Budget Period 2 Total | $0 | |||||
| Budget Period 3 | ||||||
| $0 | ||||||
| $0 | ||||||
| $0 | ||||||
| $0 | ||||||
| $0 | ||||||
| $0 | ||||||
| Budget Period 3 Total | $0 |
TOTAL EQUIPMENT $0
Additional Explanation (as needed):
d. Equipment Page &P of &N
d. Equipment Page &P of &N
d. Equipment Page &P of &N
d. Equipment Page &P of &N
d. Equipment Page &P of &N
d. Equipment Page &P of &N
SF-424A Cost Categories
| Applicant Name: | 0 | Award Number: | 0 | |||
| BUDGET INFORMATION - Non-Construction Programs | OMB Number: 4040-0006 | |||||
| Expiration Date: 02/28/2025 | ||||||
| SECTION A - BUDGET SUMMARY | ||||||
| Grant Program Function or Activity | Catalog of Federal Domestic Assistance Number | Estimated Unobligated Funds | New or Revised Budget |
| Federal | Non-Federal | Federal | Non-Federal | Total | |||
| (a) | (b) | (c) | (d) | (e) | (f) | (g) | |
| 1. | Budget Period 1 | $0.00 | |||||
| 2. | Budget Period 2 | $0.00 | |||||
| 3. | Budget Period 3 | $0.00 | |||||
| 4. | |||||||
| 5. | Totals | $0.00 | $0.00 | $0.00 | |||
| Standard Form 424A (Rev. 7- 97) | |||||||
| Prescribed by OMB (Circular A -102) Page 1 | |||||||
| SECTION B - BUDGET CATEGORIES | |||||||
| 6. | Object Class Categories | Grant Program, Function or Activity | Total | ||||
| (1) | (2) | (3) | (4) | (5) | |||
| Budget Period 1 | Budget Period 2 | Budget Period 3 | |||||
| a. Personnel | $0.00 | ||||||
| b. Fringe Benefits | $0.00 | ||||||
| c. Travel | $0.00 | ||||||
| d. Equipment | $0.00 | ||||||
| e. Supplies | $0.00 | ||||||
| f. Contractual | $0.00 | ||||||
| g. Construction | $0.00 | ||||||
| h. Other | $0.00 | ||||||
| i. Total Direct Charges (sum of 6a-6h) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| j. Indirect Charges | |||||||
| k. TOTALS (sum of 6i-6j) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 7. | Program Income | $0 | ||||
| Authorized for Local Reproduction | Standard Form 424A (Rev. 7- 97) | |||||
| Prescribed by OMB (Circular A -102) Page 1A | ||||||
| SECTION C - NON-FEDERAL RESOURCES | ||||||
| (a) Grant Program | (b) Applicant | (c) State | (d) Other Sources | (e) Totals | ||
| 8. | $0 | |||||
| 9. | $0 | |||||
| 10. | $0 | |||||
| 11. | $0 | |||||
| 12. | TOTAL (sum of lines 8 - 11) | $0 | $0 | $0 | $0 | |
| SECTION D - FORECASTED CASH NEEDS | ||||||
| Total for 1st Year | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th quarter | ||
| 13. | Federal | $0 | ||||
| 14. | Non-Federal | $0 | ||||
| 15. | TOTAL (sum of lines 13 and 14) | $0 | $0 | $0 | $0 | $0 |
| SECTION E - BUDGET ESTIMATES OF FEDERAL FUNDS NEEDED FOR BALANCE OF THE PROJECT | ||||||
| (a) Grant Program | Future Funding Periods (Years) | |||||
| (b) First | (c ) Second | (d) Third | (e) Fourth | |||
| 16. | ||||||
| 17. | ||||||
| 18. | ||||||
| 19. | ||||||
| 20. | TOTAL (sum of lines 16-19) | $0 | $0 | $0 | $0 | |
| SECTION F - OTHER BUDGET INFORMATION | ||||||
| 21. Direct Charges | 22. Indirect Charges |
23. Remarks
| Authorized for Local Reproduction | Standard Form 424A (Rev. 7- 97) |
| Prescribed by OMB (Circular A -102) Page 2 |
File details come from the government source that posted it. Updated .