Equipment List Template.xlsx
XLSX spreadsheet 24 KB Posted
- Opportunity number
- DHS-USCG-STATE-2025
About this file
This document is an Equipment List Template for the State Recreational Boating Safety (RBS) Grant Program, a federal grant opportunity from the Department of Homeland Security's U.S. Coast Guard. The template provides instructions and examples for applicants to itemize vessels, vehicles, and personal equipment necessary to conduct approved RBS activities, such as boats, motors, radios, and trailers. Applicants are instructed to include the quantity, cost per unit, subtotal, proration percentage, and total cost for each item. The template also includes prorated examples reflecting a state's policy of only charging 18% of the cost per unit towards the RBS grant. The related federal grant opportunity, Solicitation Number DHS-USCG-STATE-2025, is a cooperative agreement available to state governments under the Boating Safety Financial Assistance program (CFDA 97.012).
Equipment List Template
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Program Narrative Bullet Points.docx | DOCX document | |
| FY25 State RBS NOFO (2024-07-08).pdf | ||
| FY25 State RBS NOFO (2024-07-08).pdf | ||
| FY 2025 Estimated Allocation Chart.pdf | ||
| COMDTPUB 16755.3B STATE GUIDE 03012022.pdf | ||
| BudgetTool2025.xls | XLS spreadsheet | |
| Appendix A. Annual Performance Report Narrative Guidance.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
Instructions
| Instructions | |
| 1 | Review the examples in the template. Your equipment descriptions should provide a similar level of detail and/or specification. The example items are pulled from previously approved applications. |
| 2 | Itemize any vessels, vehicles, and personal equipment necessary to conduct approved RBS activities. Items may include, but are not limited to boats, motors, radios, and trailers. Select the appropriate category for each item. Always leave the last row blank. |
| 3 | If you need to add additional rows, take the following steps: |
1) Click on the row number of the blank row. If done correctly, it will select the entire row across the whole page.
2) Hold 'CTRL' then the letter 'C' to copy the entire row.
3) If adding to the bottom of the list, right click on the row number of the blank row. If adding an item within your list, right click on the row number below where you want to insert the item.
4) Select 'Insert Copied Cells' from the pop-up menu.
This should insert new rows while preserving the formulas and formatting.
4 Adjust the proration percentage as appropriate for each item requested. If the item will only be used for RBS activities, then its percentage should be 100%. The column should turn light grey whenever a value less than 100% is entered into the cell.
| Additional Guidance | |
| 1 | Remember to remove the examples from the spreadsheet before submitting your application. |
| 2 | If you accidentally delete the formulas: |
1) Column E 'Subtotal' = Column C 'QTY' multiplied by Column D 'Cost Per Unit.'
2) Column G 'Total' = Column E 'Subtotal' multiplied by Column F 'Proration.'
| 3 | The intent of Column F 'Proration' is to clearly identify how much of an item is being applied to the RBS grant. This is especially important for items that may have more than one function. |
| 4 | The prorated examples in the spreadsheet reflect a state's policy of only charging 18% of the cost per unit towards the RBS grant. |
&"Times New Roman,Bold"&14State RBS Equipment List Instructions
&P of &N
Equipment List
| Category | Item & Description | QTY | Cost Per Unit | Subtotal | Proration | Total |
| Education | 12'x7x6'' Box trailer with rear ramp for carrying paddlecraft | 1 | $7,030.00 | $7,030.00 | 100% | $7,030.00 |
| Education | 60 HP Mercury Outboard w/steering components and install | 1 | $25,000.00 | $25,000.00 | 100% | $25,000.00 |
| Education | 8.5'x20'x7' Box trailer with ramp door for carrying paddlecraft | 1 | $11,677.00 | $11,677.00 | 100% | $11,677.00 |
| Law Enforcement | 18ft - 19ft fiberglass patrol boat, 225 hp motor and trailer | 1 | $65,000.00 | $65,000.00 | 100% | $65,000.00 |
| Law Enforcement | 18ft aluminum patrol boat, 175 hp motor and trailer | 1 | $55,000.00 | $55,000.00 | 100% | $55,000.00 |
| Law Enforcement | 20ft fiberglass patrol boat, 250 hp motor and trailer | 2 | $75,000.00 | $150,000.00 | 100% | $150,000.00 |
| Law Enforcement | APX 8000 Dual band portable radios | 41 | $6,200.00 | $254,200.00 | 18% | $45,756.00 |
| Law Enforcement | APX 8000 Dual band portable radios - river boats | 2 | $6,200.00 | $12,400.00 | 100% | $12,400.00 |
| Law Enforcement | APX 8500 Dual band radios - boat | 25 | $6,500.00 | $162,500.00 | 100% | $162,500.00 |
| Law Enforcement | APX 8500 Dual band radios - patrol vehicle | 41 | $6,500.00 | $266,500.00 | 18% | $47,970.00 |
| Law Enforcement | Utility pick-up truck with tow and LE package | 4 | $25,000.00 | $100,000.00 | 100% | $100,000.00 |
| Nav Aids | Motorola APX 8500 mobile radios, accessories, and installation | 2 | $7,000.00 | $14,000.00 | 100% | $14,000.00 |
| $0.00 | 100% | $0.00 | ||||
| $0.00 | 100% | $0.00 | ||||
| $0.00 | 100% | $0.00 | ||||
| $0.00 | 100% | $0.00 | ||||
| $0.00 | 100% | $0.00 | ||||
| $0.00 | 100% | $0.00 | ||||
| $0.00 | 100% | $0.00 | ||||
| $0.00 | 100% | $0.00 | ||||
| $0.00 | 100% | $0.00 | ||||
| $0.00 | 100% | $0.00 | ||||
| $0.00 | 100% | $0.00 | ||||
| $0.00 | 100% | $0.00 | ||||
| $696,333.00 |
&"Times New Roman,Bold"&14State RBS Equipment List
&P of &N
File details come from the government source that posted it. Updated .