Appendix C. Equipment List Template.xlsx

XLSX spreadsheet 27 KB Posted

Attached to
State Recreational Boating Safety (RBS) Grant Program
Opportunity number
DHS-USCG-STATE-2027
Issued by

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

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
1Review 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.
2Itemize 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.
3If 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
1Remember to remove the examples from the spreadsheet before submitting your application.
2If 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.'

3The 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.
4The 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

CategoryItem & DescriptionQTYCost Per UnitSubtotalProrationTotal
Education12'x7x6'' Box trailer with rear ramp for carrying paddlecraft1$7,030.00$7,030.00100%$7,030.00
Education60 HP Mercury Outboard w/steering components and install1$25,000.00$25,000.00100%$25,000.00
Education8.5'x20'x7' Box trailer with ramp door for carrying paddlecraft1$11,677.00$11,677.00100%$11,677.00
Law Enforcement18ft - 19ft fiberglass patrol boat, 225 hp motor and trailer1$65,000.00$65,000.00100%$65,000.00
Law Enforcement18ft aluminum patrol boat, 175 hp motor and trailer1$55,000.00$55,000.00100%$55,000.00
Law Enforcement20ft fiberglass patrol boat, 250 hp motor and trailer2$75,000.00$150,000.00100%$150,000.00
Law EnforcementAPX 8000 Dual band portable radios41$6,200.00$254,200.0018%$45,756.00
Law EnforcementAPX 8000 Dual band portable radios - river boats2$6,200.00$12,400.00100%$12,400.00
Law EnforcementAPX 8500 Dual band radios - boat25$6,500.00$162,500.00100%$162,500.00
Law EnforcementAPX 8500 Dual band radios - patrol vehicle41$6,500.00$266,500.0018%$47,970.00
Law EnforcementUtility pick-up truck with tow and LE package4$25,000.00$100,000.00100%$100,000.00
Nav AidsMotorola APX 8500 mobile radios, accessories, and installation2$7,000.00$14,000.00100%$14,000.00
$0.00100%$0.00
$0.00100%$0.00
$0.00100%$0.00
$0.00100%$0.00
$0.00100%$0.00
$0.00100%$0.00
$0.00100%$0.00
$0.00100%$0.00
$0.00100%$0.00
$0.00100%$0.00
$0.00100%$0.00
$0.00100%$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 .