Appendix C. Equipment List Template.xlsx
XLSX spreadsheet 27 KB Posted
- Opportunity number
- DHS-USCG-STATE-2027
About this file
This is an equipment list template for the State Recreational Boating Safety (RBS) Grant Program administered by the Department of Homeland Security US Coast Guard under Assistance Listing 97.012. The template provides instructions for applicants to itemize and cost equipment necessary to conduct approved RBS activities, including vessels, vehicles, and personal equipment such as boats, motors, radios, and trailers. Applicants must categorize items into designated categories (Education, Law Enforcement, Navigation Aids, etc.) and calculate subtotals by multiplying quantity by cost per unit. The template includes a proration column to allocate the percentage of equipment costs attributable to RBS grant activities, with items used exclusively for RBS activities marked at 100% and shared-use equipment prorated accordingly; the example provided shows one state allocating only 18% of certain portable and mobile radios toward the grant.
The template contains worked examples of previously approved equipment requests totaling $696,333 in requested costs, including education trailers ($7,030–$11,677 each), law enforcement patrol boats ($55,000–$75,000 each with motors and trailers), dual-band portable and mobile radios ($6,200–$6,500 each), and utility pickup trucks ($25,000 each). Applicants must remove all examples before submitting their application and may add additional rows as needed while preserving formulas for automatic calculations. The template emphasizes that proration is critical for identifying how much of multi-function items are being charged to the RBS grant, requiring careful consideration of shared-use equipment across different operational functions.
Appendix C. Equipment List Template
View the file
Other files
| File | Type | Posted |
|---|---|---|
| FY27 State RBS NOFO Draft (2026-09-10).pdf | ||
| FY27 State RBS NOFO Draft (2026-09-10).pdf | ||
| FY27 Estimated Allocation Chart.pdf | ||
| CGHQ_3923 Exp 08-31-2026.pdf | ||
| BudgetTool2027.xls | XLS spreadsheet | |
| Blank PRPII v2014.xlsx | XLSX spreadsheet | |
| Appendix D Annual Performance Report Narrative Guidance.docx | DOCX document | |
| Appendix B. Program Narrative Template.docx | DOCX document | |
| Appendix A. FY27 Estimated Allocation Memo & Chart.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 .