Equipment List Template.xlsx
XLSX spreadsheet 24 KB Posted
- Opportunity number
- DHS-USCG-STATE-2026
About this file
The file is an Equipment List Template for the State Recreational Boating Safety (RBS) Grant Program administered by the U.S. Coast Guard. The template provides detailed instructions for itemizing equipment necessary for RBS activities, with specific guidance on completing the spreadsheet, including how to add rows, calculate subtotals, and apply proration percentages. The example equipment list includes various vessels, vehicles, and communication devices across three categories: Education, Law Enforcement, and Navigation Aids, with items such as trailers, boats, outboard motors, patrol vehicles, and portable and mobile radios.
The equipment list demonstrates a comprehensive inventory of items with associated costs, quantities, and funding allocations, totaling $696,333.00. Notable items include 18-19 foot patrol boats, utility pickup trucks, Mercury outboard motors, and Motorola APX radios, with prorated funding ranging from 18% to 100% for different equipment. The template is part of the Boating Safety Financial Assistance program (CFDA 97.012), which provides cooperative agreements to designated state agencies to enhance recreational boating safety, with the goal of minimizing loss of life, personal injury, and property damage on waterways.
Equipment List Template
View the file
Other files
| File | Type | Posted |
|---|---|---|
| NOFO Addendum State RBS FY 2026.pdf | ||
| FY26 State RBS NOFO (2025-10-17).pdf | ||
| Program Narrative Bullet Points.docx | DOCX document | |
| FY 2026 Estimated Allocation Memo to the States.pdf | ||
| COMDTPUB 16755.3B STATE GUIDE 03012022.pdf | ||
| CGHQ_3923 Exp 08-31-2026.pdf | ||
| BudgetTool2026.xls | XLS spreadsheet | |
| BudgetTool2026.xls | XLS spreadsheet | |
| Blank PRPII v2014.xlsx | XLSX 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 .