The file's text, extracted by GovTribe without its formatting.
Template_Blank
| Optional Exchange Network Budget Calculating Tool |
| Users Guide: This tool is intended to help calculate the project budget and correctly categorize costs. You can use the numbers generated by this sheet to input costs per budget category in the Budget Narrative Attachment Form, the |
SF424-A Form, and Project Narrative, Section 7 'Overview of Project Budget'. It is not intended to be used in place of any of these documents.
Highlighted cells are areas where you may enter information as needed. Additional rows are included for your convenience. All numbers entered are automatically rounded to the nearest whole dollar amount as required by the Exchange Network grant program.
| This tool will not allow you to delete rows. To hide unnecessary rows or to add rows, please follow the instructions below. |
| -To hide rows: Select unnecessary rows then right click the selection and choose 'Hide' which is the last of the listed options. To unhide previously hidden rows, select the whole sheet and right click to choose 'Unhide' from the menu options. |
| -To add rows: Click a row number above where you would like to insert the new row, copy the row as you normally would (right click to 'Copy' or use 'Ctrl+C'), then right click the selected row number and choose the 'insert copied cells' option. |
| A Note on Errors: This tool is designed to automatically round all amounts and calculate totals. Cells that do not require user input are locked to avoid formula errors. If one does occur, please refer to the common error code explanations below. |
| #VALUE!' indicates that needed information is missing or has been entered incorrectly. If you get this error please check that you have selected a budget option in cell E113. |
| #REF' indicates that a cell can no longer be referenced to complete the formula. If you get this error, please check that you have not deleted any columns or rows. Also check that you have inserted any new rows using the 'insert copied cells' option detailed above. |
Improper Percentages: If a number is entered and the percent displays incorrectly, try entering the number as a decimal. (15.8% = .158)
Feel free to contact the Exchange Network Grants Team at engrantprogram@epa.gov with any issues or questions regarding this form.
| #1. Personnel Costs | | | | | | |
| Staff Position (Project Role) | Staff Name (If Known) | Annual Salary | Percentage of Time | Annual Cost | Period of Performance (Years) | 3-Year Personnel Cost |
| Title 1 | Full Name | $ - 0 | | $ - 0 | 3 | $0 |
| Title 2 | Full Name | $ - 0 | | $ - 0 | 3 | $0 |
| Title 3 | Full Name | $ - 0 | | $ - 0 | 3 | $0 |
| Title 4 | Full Name | $ - 0 | | $ - 0 | 3 | $0 |
| | $ - 0 | | $ - 0 | 3 | $0 |
| | $ - 0 | | $ - 0 | 3 | $0 |
| | $ - 0 | | $ - 0 | 3 | $0 |
| | $ - 0 | | $ - 0 | 3 | $0 |
| Total Personnel Costs | | | | | | $0 |
| #2. Fringe Benefits | | | | | |
| Staff Position | Staff Name | 3-Year Personnel Cost | Fringe Benefit Rate | 3-Year Fringe Cost |
| Title 1 | Full Name | $0 | | $0 |
| Title 2 | Full Name | $0 | | $0 |
| Title 3 | Full Name | $0 | | $0 |
| Title 4 | Full Name | $0 | | $0 |
| 0 | 0 | $0 | | $0 |
| 0 | 0 | $0 | | $0 |
| 0 | 0 | $0 | | $0 |
| 0 | 0 | $0 | | $0 |
| Total Fringe Costs | | | | $0 |
| #3. Travel | | | | | | |
| Trip | Trip Item | Estimated Cost | Duration | # of Travelers | Total Travel Cost |
| | Airfare | $ - 0 | N/A | 0 | $ - 0 |
| | Per Diem | $ - 0 | | | $ - 0 |
| 1 | Rental Car | $ - 0 | | | $ - 0 |
| | Milage | $ - 0 | | | $ - 0 |
| | Other | $ - 0 | | | $ - 0 |
| Trip 1 Cost: | | | | | $0 |
| | Airfare | $ - 0 | N/A | | $ - 0 |
| | Per Diem | $ - 0 | | | $ - 0 |
| 2 | Rental Car | $ - 0 | | | $ - 0 |
| | Milage | $ - 0 | | | $ - 0 |
| | Other | $ - 0 | | | $ - 0 |
| Trip 2 Cost: | | | | | $0 |
| | Airfare | $ - 0 | N/A | | $ - 0 |
| | Per Diem | $ - 0 | 0 | | $ - 0 |
| 3 | Rental Car | $ - 0 | 0 | | $ - 0 |
| | Milage | $ - 0 | 0 | | $ - 0 |
| | Other | $ - 0 | 0 | | $ - 0 |
| Trip 3 Cost: | | | | | $0 |
| Total Travel Costs | | | | | $0 |
| #4. Equipment | NOTE: Price per Unit should = $5,000 or more, a unit costing less than $5,000 should be categorized under 'Supplies' (#5, below) | | | | |
| | Item | Quantity | Price per Unit | Total Equipment Cost |
| | Item Name 1 | | $ - 0 | $ - 0 |
| | Item Name 2 | | $ - 0 | $ - 0 |
| | Item Name 3 | | $ - 0 | $ - 0 |
| | | | $ - 0 | $ - 0 |
| | | | $ - 0 | $ - 0 |
| | | | $ - 0 | $ - 0 |
| | | | $ - 0 | $ - 0 |
| | | | $ - 0 | $ - 0 |
| | Total Equipment Cost | | | $0 |
| #5. Supplies | NOTE: Price per unit should be LESS THAN $5,000 | | | | | |
| | Supply Category | Item | Quantity | Price per Unit | Total Supplies Cost |
| | | Item 1 | | $ - 0 | $ - 0 |
| | | Item 2 | | $ - 0 | $ - 0 |
| | | Item 3 | | $ - 0 | $ - 0 |
| | | | | $ - 0 | $ - 0 |
| | | | | $ - 0 | $ - 0 |
| | | | | $ - 0 | $ - 0 |
| | | | | $ - 0 | $ - 0 |
| | Total Supplies Cost | | | | $0 |
| #6. Contractual | NOTE: $84.48 is the max hourly rate for an individual consultant. *For contract types that are single source, an explanation is required in the Budget Narrative* | | | | | |
| | Item | Hours | Hourly Rate | Procurement Method | Total Contractual Cost |
| | Select Contract Type | | $ - 0 | Select from Drop Down | $ - 0 |
| | | | | | $ - 0 |
| | 0 | | | | $ - 0 |
| | 0 | | | | $ - 0 |
| | 0 | | | | $ - 0 |
| | Total Contractual Cost | | | | $0 |
| #7. Other | | | | | |
| Category | Item | Quantity | Price per Unit | Total Other Cost |
| Select from Drop Down | | | $ - 0 | $ - 0 |
| | | | $ - 0 | $ - 0 |
| | | | $ - 0 | $ - 0 |
| 0 | | | $ - 0 | $ - 0 |
| 0 | | | $ - 0 | $ - 0 |
| | | | $ - 0 | $ - 0 |
| Total 'Other' Cost | | | | $0 |
| #8. Indirect Costs | NOTE: Rate must be valid until at least 9/30/2023. Tribal applicants may also charge indirect costs using their draft rate as submitted to the Department of Interior (DOI). | | | | | |
| | Effective Period | IDC Rate | Description of Base* | Base Amount** | Total Indirect Costs |
| | xx/xx/xxxx - xx/xx/xxxx | 0.00% | | $ - 0 | $0 |
| | *Description is not needed in this tool but must be included in Budget Narrative | | | **Add costs included in base using the formula =sum('blue rows in Column G') | |
| Total Budget | $0 |
| Select Assistance Type from Drop-Down List | ERROR:#N/A |
| Remaining Balance Against Funding Threshold | ERROR:#N/A |
Example
| Optional Exchange Network Budget Calculating Tool |
| Users Guide: This tool is intended to help calculate the project budget and correctly categorize costs. You can use the numbers generated by this sheet to input costs per budget category in the Budget Narrative Attachment Form, the |
SF424-A Form, and Project Narrative, Section 7 'Overview of Project Budget'. It is not intended to be used in place of any of these documents.
Highlighted cells are areas where you may enter information as needed. Additional rows are included for your convenience. All numbers entered are automatically rounded to the nearest whole dollar amount as required by the Exchange Network grant program.
| This tool will not allow you to delete rows. To hide unnecessary rows or to add rows, please follow the instructions below. |
| -To hide rows: Select unnecessary rows then right click the selection and choose 'Hide' which is the last of the listed options. To unhide previously hidden rows, select the whole sheet and right click to choose 'Unhide' from the menu options. |
| -To add rows: Click a row number above where you would like to insert the new row, copy the row as you normally would (right click to 'Copy' or use 'Ctrl+C'), then right click the selected row number and choose the 'insert copied cells' option. |
| A Note on Errors: This tool is designed to automatically round all amounts and calculate totals. Cells that do not require user input are locked to avoid formula errors. If one does occur, please refer to the common error code explanations below. |
| #VALUE!' indicates that needed information is missing or has been entered incorrectly. If you get this error please check that you have selected a budget option in cell E113. |
| #REF' indicates that a cell can no longer be referenced to complete the formula. If you get this error, please check that you have not deleted any columns or rows. Also check that you have inserted any new rows using the 'insert copied cells' option detailed above. |
| Improper Percentages: If a number is entered and the percent displays incorrectly, try entering the number as a decimal. (15.8% = .158) |
| Feel free to contact the Exchange Network Grants Team at engrantprogram@epa.gov with any issues or questions regarding this form. |
| #1. Personnel Costs | | | | | | |
| Staff Position (Project Role) | Staff Name (If Known) | Annual Salary | Percentage of Time | Annual Cost | Period of Performance (Years) | 3-Year Personnel Cost |
| Project Manager | Neal XXXX | $ 78,123 | 10% | $ 7,812 | 3 | $23,437 |
| IT Specialist | Diana XXXX | $ 64,322 | 15% | $ 9,648 | 3 | $28,945 |
| Environmental Specialist | Karen XXXX | $ 53,992 | 15% | $ 8,099 | 3 | $24,296 |
| Environmental Specialist | Carlos XXXX | $ 49,982 | 10% | $ 4,998 | 3 | $14,995 |
| | | | $ - 0 | 3 | $0 |
| | | | $ - 0 | 3 | $0 |
| | | | $ - 0 | 3 | $0 |
| | | | $ - 0 | 3 | $0 |
| Total Personnel Costs | | | | $ - 0 | | $91,673 |
| | | | $ - 0 | | |
| #2. Fringe Benefits | | | | 0 | | |
| | Staff Position | Staff Name | 3-Year Personnel Cost | Fringe Benefit Rate | 3-Year Fringe Cost |
| | Project Manager | Neal XXXX | $23,437 | 22.00% | $5,156 |
| | IT Specialist | Diana XXXX | $28,945 | 12.80% | $3,705 |
| | Environmental Specialist | Karen XXXX | $24,296 | 25.22% | $6,127 |
| | Environmental Specialist | Carlos XXXX | $14,995 | 17.15% | $2,572 |
| | 0 | 0 | $0 | | $0 |
| | 0 | 0 | $0 | | $0 |
| | 0 | 0 | $0 | | $0 |
| | 0 | 0 | $0 | | $0 |
| | Total Fringe Costs | | | | $17,560 |
| #3. Travel | | | | | | |
| Trip | Trip Item | Estimated Cost | Duration | # of Travelers | Total Cost |
| | Airfare | $550 | N/A | 2 | $ 1,100 |
| | Per Diem | $190 | 3 | 2 | $ 1,140 |
| 1 | Rental Car | $60 | 4 | 2 | $ 480 |
| | Milage | $40 | 4 | 2 | $ 320 |
| | Other | | | | $ - 0 |
| Trip 1 Cost: | | | | | $3,040 |
| | Airfare | $ - 0 | N/A | | $ - 0 |
| | Per Diem | $ - 0 | | | $ - 0 |
| 2 | Rental Car | $ - 0 | | | $ - 0 |
| | Milage | $ - 0 | | | $ - 0 |
| | Other | $ - 0 | | | $ - 0 |
| Trip 2 Cost: | | | | | $0 |
| | Airfare | $ - 0 | N/A | | $ - 0 |
| | Per Diem | $ - 0 | | | $ - 0 |
| 3 | Rental Car | $ - 0 | | | $ - 0 |
| | Milage | $ - 0 | | | $ - 0 |
| | Other | $ - 0 | | | $ - 0 |
| Trip 3 Cost: | | | | | $0 |
| Total Travel Costs | | | | | $3,040 |
| #4. Equipment NOTE: Price per Unit should = $5,000 or more, a per unit costing less than $5,000 should be categorized under 'Supplies' (#5, below) | | | | |
| Item | Quantity | Price per Unit | Total Cost |
| Pix4Dmapper, Perpetual License | 2 | $ 5,000 | $ 10,000 |
| SLEIS Software Upgrade and License | 1 | $ 6,135 | $ 6,135 |
| | | $ - 0 | $ - 0 |
| | | $ - 0 | $ - 0 |
| | | $ - 0 | $ - 0 |
| | | $ - 0 | $ - 0 |
| | | $ - 0 | $ - 0 |
| | | $ - 0 | $ - 0 |
| Total Equipment Cost | | | $ 16,135 |
| #5. Supplies | NOTE: Price/Unit should be LESS THAN $5,000 | | | | | |
| | Supply Category | Item | Quantity | Price per Unit | Total Cost |
| | Monitoring Supplies | Pressure Transducer | 2 | $ 723 | $ 1,446 |
| | Computing Device | Laptop Computer | 8 | $ 672 | $ 5,376 |
| | | | | $ - 0 | $ - 0 |
| | | | | $ - 0 | $ - 0 |
| | | | | $ - 0 | $ - 0 |
| | | | | $ - 0 | $ - 0 |
| | | | | $ - 0 | $ - 0 |
| | Total Supplies Cost | | | | $ 6,822 |
| #6. Contractual | NOTE: $84.48 is the max hourly rate for an individual consultant. *For contract types that are single source, an explanation is required in the Budget Narrative* | | | | | |
| | Item | Hours | Hourly Rate | Procurement Method | Total Cost |
| | Contractor | 110 | $ 107 | Competitive Proposals | $ 11,770 |
| | Individual Consultant | 50 | $ 75 | Single Source* | $ 3,750 |
| | 0 | | | | $ - 0 |
| | 0 | | | | $ - 0 |
| | 0 | | | | $ - 0 |
| | Total Contractual Cost | | | | $ 15,520 |
| #7. Other | | | | | |
| Category | Item | Quantity | Price per Unit | Total Cost |
| Light Food & Beverage | Coffee (Gallon) | 6 | $ 16 | $96 |
| Participant Support Costs | Training Fee for Community Members | 10 | $ 250 | $2,500 |
| Subaward | Subaward to EN Partner (Org Name) | 1 | $ 9,000 | $9,000 |
| 0 | | | $ - 0 | $0 |
| 0 | | | $ - 0 | $0 |
| | | | $ - 0 | $0 |
| Total 'Other' Cost | | | | $11,596 |
| #8. Indirect Costs | NOTE: Rate must be valid until at least 9/30/2023. Tribal applicants may also charge indirect costs using their draft rate as submitted to the Department of Interior (DOI). | | | | | |
| | Effective Period | IDC Rate | Description of Base* | Base Amount** | Total Indirect Costs |
| | 10/01/2023 - 9/30/2025 | 11.60% | Total Direct Costs excluding subawards | $ 147,816 | $ 17,147 |
| | *Description is not needed in this tool but must be included in Budget Narrative | | | **Add costs included in base using the formula =sum('blue row totals in Column G') | |
| Total Budget | $179,493 |
| Individual Assistance Agreement | ERROR:#N/A |
| Remaining Balance Against Funding Threshold | ERROR:#N/A |
Data Vali
| Contract Types | Other' Category Types | Supply' Category Types |
| Select from Drop Down | Select from Drop Down | Select from Drop Down |
| Competative Proposals | Rental and Lease Cost | Monitoring Supplies |
| Single Source* | Participant Support Costs | Computing Device |
| Unkown | Subaward | Testing Supplies |
| Other *Please Explain | Equipment Rental/Lease | Other *Please Explain |
| Internet Service | |
| Meeting Facilities | Contractual |
| Light Food & Beverage | Contractor |
| Other *Please Explain | Individual Consultant |
| | Select Contract Type |
| Select Assitance Type from Drop-Down List | $ - |
| Capacity Buildling with Mentorship | $ 315,000.00 |
| Individual Capacity Buildling | $ 300,000.00 |
| Individual Assitance Agreement | $ 300,000.00 |
| Partnership Assistance Agreement | $ 500,000.00 |
Environmental Protection Agency