BudgetTool2027.xls

POC

Seth.M.Wagner@uscg.mil Seth.M.Wagner@uscg.mil Gary.S.Jensen@uscg.mil Kristin.A.Williams@uscg.mil Cynthia.M.Dudzinski@uscg.mil Jack.Roberts@uscg.mil Gary.S.Jensen@uscg.mil Seth.M.Wagner@uscg.mil Brian.M.Moore@uscg.mil Brian.M.Moore@uscg.mil Brian.M.Moore@uscg.mil Brian.M.Moore@uscg.mil Brian.M.Moore@uscg.mil Seth.M.Wagner@uscg.mil Brian.M.Moore@uscg.mil Seth.M.Wagner@uscg.mil Seth.M.Wagner@uscg.mil Brian.M.Moore@uscg.mil Brian.M.Moore@uscg.mil Brian.M.Moore@uscg.mil Brian.M.Moore@uscg.mil Kristin.A.Williams@uscg.mil Kristin.A.Williams@uscg.mil Kristin.A.Williams@uscg.mil Brian.M.Moore@uscg.mil Seth.M.Wagner@uscg.mil Kristin.A.Williams@uscg.mil Kristin.A.Williams@uscg.mil Seth.M.Wagner@uscg.mil Brian.M.Moore@uscg.mil Kristin.A.Williams@uscg.mil Seth.M.Wagner@uscg.mil Brian.M.Moore@uscg.mil Brian.M.Moore@uscg.mil Brian.M.Moore@uscg.mil Seth.M.Wagner@uscg.mil Kristin.A.Williams@uscg.mil Seth.M.Wagner@uscg.mil Kristin.A.Williams@uscg.mil Seth.M.Wagner@uscg.mil Seth.M.Wagner@uscg.mil Seth.M.Wagner@uscg.mil Kristin.A.Williams@uscg.mil Kristin.A.Williams@uscg.mil Kristin.A.Williams@uscg.mil Brian.M.Moore@uscg.mil Kristin.A.Williams@uscg.mil Kristin.A.Williams@uscg.mil Seth.M.Wagner@uscg.mil Kristin.A.Williams@uscg.mil Kristin.A.Williams@uscg.mil Kristin.A.Williams@uscg.mil Brian.M.Moore@uscg.mil Brian.M.Moore@uscg.mil Brian.M.Moore@uscg.mil Seth.M.Wagner@uscg.mil Seth.M.Wagner@uscg.mil Seth.M.Wagner@uscg.mil Brian.M.Moore@uscg.mil Cynthia.M.Dudzinski@uscg.mil Cynthia.M.Dudzinski@uscg.mil Cynthia.M.Dudzinski@uscg.mil Cynthia.M.Dudzinski@uscg.mil Cynthia.M.Dudzinski@uscg.mil Cynthia.M.Dudzinski@uscg.mil Cynthia.M.Dudzinski@uscg.mil Cynthia.M.Dudzinski@uscg.mil Gary.S.Jensen@uscg.mil Gary.S.Jensen@uscg.mil Gary.S.Jensen@uscg.mil Gary.S.Jensen@uscg.mil Gary.S.Jensen@uscg.mil Gary.S.Jensen@uscg.mil Gary.S.Jensen@uscg.mil Gary.S.Jensen@uscg.mil Gary.S.Jensen@uscg.mil Gary.S.Jensen@uscg.mil Gary.S.Jensen@uscg.mil Gary.S.Jensen@uscg.mil Gary.S.Jensen@uscg.mil Gary.S.Jensen@uscg.mil Jack.Roberts@uscg.mil Jack.Roberts@uscg.mil Jack.Roberts@uscg.mil Jack.Roberts@uscg.mil Vonda.L.Matthews@uscg.mil Jack.Roberts@uscg.mil Jack.Roberts@uscg.mil Jack.Roberts@uscg.mil Jack.Roberts@uscg.mil Jack.Roberts@uscg.mil Jack.Roberts@uscg.mil Jack.Roberts@uscg.mil Jack.Roberts@uscg.mil Jack.Roberts@uscg.mil Jack.Roberts@uscg.mil Jack.Roberts@uscg.mil Jack.Roberts@uscg.mil Jack.Roberts@uscg.mil Cynthia.M.Dudzinski@uscg.mil Gary.S.Jensen@uscg.mil Gary.S.Jensen@uscg.mil Jack.Roberts@uscg.mil Cynthia.M.Dudzinski@uscg.mil Gary.S.Jensen@uscg.mil Jack.Roberts@uscg.mil Cynthia.M.Dudzinski@uscg.mil Jack.Roberts@uscg.mil Jack.Roberts@uscg.mil Cynthia.M.Dudzinski@uscg.mil Jack.Roberts@uscg.mil Seth.M.Wagner@uscg.mil Kristin.A.Williams@uscg.mil Seth.M.Wagner@uscg.mil Jeffrey.E.Decker@uscg.mil Brian.M.Moore@uscg.mil Cynthia.M.Dudzinski@uscg.mil Gary.S.Jensen@uscg.mil Vonda.L.Matthews@uscg.mil Jack.Roberts@uscg.mil UPDATE POCs

Introduction

COAST GUARD RBS GRANT

BUDGET TOOL 2027

This tool is designed to assist you with creating the Budget Information Sheet (SF-424a) that will be submitted with your application for federal financial assistance associated with the State Recreational Boating Safety Grant Program. The Equipment List has been removed from this version. The Equipment List is now a stand alone document that can be accessed via Grants.gov when you download your RBS Grant Application Package. Please disregard the portion of the training video that pertains to the Equipment List.

Start by completing the information below:

Enter your carryover amount here.

Enter your State or Territory here.

Enter your application amount here.

This figure should be the amount of NEW federal money that you are applying for. In many cases it is the amount of the federal allocation for the current fiscal year. You can obtain this figure from the published allocation table or from your Coast Guard Grant Coordinator.

Click to Continue Training Video Available Run-Time - 25 Minutes

Equipment List SF-424 Page 2A

Equipment List (SF-424 Page 2A)

Item descriptions must be complete. If you are buying boats please provide length (may be approximate if still in planning stage), type of propulsion, whether or not trailer(s) is/are included, whether or not LE package (i.e. light bar, etc.) is included. For vehicles provide pertinent information.

Good example: 24 FT Patrol Vsl, Twin 150 HP O/B's, w/ LE Pkg and Trailer. Bad example: 24 FT Boat Good example: Chev Tahoe, 4x4, w/tow Pkg and Light Bar Bad example: SUV Click to Continue Do you need another sheet?

Click here

Budget info SF-424a pg 1

Gary S. Jensen:

This cell will self adjust as you make changes to Column e.

Gary S. Jensen:

This cell will self adjust as you make changes to Column e.

Gary S. Jensen:

This cell will self adjust as you make changes to Column e.

Gary S. Jensen:

This cell will self adjust as you make changes to Column e.

Gary S. Jensen:

This cell will self adjust as you make changes to Column e.

Gary S. Jensen:

This cell will self adjust as you make changes to Column e.

Gary S. Jensen:

This cell will self adjust as you make changes to Column e.

Gary S. Jensen:

This cell will self adjust as you make changes to the other rows in column e.

Gary S. Jensen:

This cell will self adjust as you make changes in Section B.

Gary S. Jensen:

This cell will self adjust as you make changes in Section B.

Gary S. Jensen:

This cell will self adjust as you make changes in Section B.

Gary S. Jensen:

This cell will self adjust as you make changes in Section B.

Gary S. Jensen:

This cell will self adjust as you make changes in Section B.

Gary S. Jensen:

This cell will self adjust as you make changes in Section B.

Gary S. Jensen:

This cell will self adjust as you make changes in Section B.

Gary S. Jensen:

This cell will self adjust as you make changes in Section B.

Gary S. Jensen:

This cell will self adjust as you make changes in Section B.

Gary S. Jensen:

This cell will self adjust as you make changes in Section B.

Gary S. Jensen:

This cell will self adjust as you make changes in Section B.

Gary S. Jensen:

This cell will self adjust as you make changes in Section B.

Gary S. Jensen:

This cell will self adjust as you make changes in Section B.

Gary S. Jensen:

This cell will self adjust as you make changes in Section B.

Gary S. Jensen:

This cell will self adjust as you make changes to the other rows in column c.

Gary S. Jensen:

This cell will self adjust as you make changes in Column c.

Gary S. Jensen:

This cell will self adjust as you make changes in Column c.

Gary S. Jensen:

This cell will self adjust as you make changes to Column e.

Gary S. Jensen:

This cell will self adjust as you make changes in Section B.

Gary S. Jensen:

This cell will self adjust as you make changes in Section B.

Gary S. Jensen:

This cell will self adjust as you make changes to the other rows in column c.

Gary S. Jensen:

This cell will self adjust as you make changes in Column c.

Gary S. Jensen:

This cell will self adjust as you make changes to the other rows in column e.

Gary S. Jensen:

This cell will self adjust as you make changes to Column e.

Gary S. Jensen:

This cell will self adjust as you make changes in Section B.

Gary S. Jensen:

This cell will self adjust as you make changes in Section B.

Gary S. Jensen:

This cell will self adjust as you make changes in Column c.

Gary S. Jensen:

This cell will self adjust as you make changes to Column e.

Gary S. Jensen:

This cell will self adjust as you make changes in Section B.

Gary S. Jensen:

This cell will self adjust as you make changes in Section B.

Gary S. Jensen:

This cell will self adjust as you make changes in Column c.

Gary S. Jensen:

This cell will self adjust as you make changes to Column e.

Gary S. Jensen:

This cell will self adjust as you make changes in Section B.

Gary S. Jensen:

This cell will self adjust as you make changes in Section B.

Gary S. Jensen:

This cell will self adjust as you make changes in Column c.

Gary S. Jensen:

This cell will self adjust as you make changes to Column e.

Gary S. Jensen:

This cell will self adjust as you make changes in Section B.

Gary S. Jensen:

This cell will self adjust as you make changes in Section B.

Gary S. Jensen:

This cell will self adjust as you make changes in Column c.

Gary S. Jensen:

This cell will self adjust as you make changes to Column e.

Gary S. Jensen:

This cell will self adjust as you make changes in Section B.

Gary S. Jensen:

This cell will self adjust as you make changes in Section B.

Gary S. Jensen:

This cell will self adjust as you make changes in Column c.

Gary S. Jensen:

This cell will self adjust as you make changes to Column e.

Gary S. Jensen:

This cell will self adjust as you make changes in Section B.

Gary S. Jensen:

This cell will self adjust as you make changes in Section B.

Gary S. Jensen:

This cell will self adjust as you make changes in Column c.

Gary S. Jensen:

This cell will self adjust as you make changes in Column c.

Gary S. Jensen:

This cell will self adjust as you make changes in Column c.

Gary S. Jensen:

This cell will self adjust as you make changes in Column c.

Gary S. Jensen:

This cell will self adjust as you make changes in Column c.

Gary S. Jensen:

This cell will self adjust as you make changes in Column c.

Compensation of employees for their time and efforts devoted specifically for State RBS activities. Many States have personnel whose duties are not limited to the State RBS program. For example, State RBS duties may be performed by Fish and Game or Conservation personnel who enforce State RBS laws as well as hunting or fishing laws. Title 2 C.F.R. § 200.430 requires that the salaries and wages of such personnel be supported by appropriate time distribution records that equitably distribute the time and effort.

Fringe benefits are allowances and services provided by employers to their employees as compensation in addition to regular salaries and wages. Fringe benefits include, but are not limited to, the costs of leave (vacation, family-related, sick or military), employee insurance, pensions, and unemployment benefit plans.

Travel costs are the expenses for transportation, lodging, subsistence, and related items incurred by employees who are in travel status on official RBS business.

Equipment means tangible personal property (including information technology systems) having a useful life of more than one year and a per-unit acquisition cost which equals or exceeds the lesser of the capitalization level established by the State for financial statement purposes, or $5,000.

All tangible personal property other than those described in the definition of equipment.

Contracts and sub-grants for professional services may be reported under contractual. Maintenance contracts for equipment or building upkeep are good examples. Be consistent from year to year on the items that you consider contractual.

Public access projects are the most common construction costs. Costs are allowable only for those public access sites that are identified in RBS applications approved by the USCG. RBS funds may also be used to build or repair boathouses and/or docks to accomodate RBS patrol vessels. The costs for development and construction of facilities designed for multiple use will be allocated among the various programs that receive benefits from the facility. If the non-RBS program purposes are incidental to the primary use, costs need not be allocated.

Direct costs that do not fit any of the aforementioned categories. Please be consistant from year to year on what you are reporting as "other". If costs in this category exceed 10% of the total amount budgeted for a particular RBS activity, you will be asked to provide a list of the items that you consider "other".

If your State has an approved indirect cost rate and you wish to apply it to this grant, a copy of the indirect cost agreement signed by the issuing Federal agency must be attached to the grant application.

Includes most of the fiscal and record-keeping functions of the program, as well as other items, including planning, legislative and regulatory functions, waterway management initiatives, and subgrant administration and auditing.

Along with traditional vessel equipment inspections, boating safety stops, and search and rescue operations, boating enforcement may include other functions such as incident investigations, stolen vessel investigations, and vessel assistance.

Costs associated with boater education, including on-line courses and materials associated with boating safety classes whether in person or virtual.

Costs associated with establishment and/or upkeep of State maintained buoys, signs and other waterway markers.

Costs associated with the registration and titling of recreational vessels within the State. These costs are allowable even if your agency is not responsible for the vessel registration/titling process. If the agency that is responsible can provide you with accurate expenditures, you may report the costs under the RBS grant.

A public access site is defined as a facility provided for the ingress and egress of the recreational boater to the body of water for the purposes of recreation, to include boat ramps, wharfs, dry storage facilities with launch capabilities, and marinas. State RBS public access sites will have objectives related to the following:

a. Elimination of overcrowding and congestion of waterways to enhance the safety of recreational boaters.

b. Equitable access to waters of the State for various forms of recreational boating, such as, cruising, water-skiing, fishing, hunting, or use of personal watercraft, and will address the needs of the handicapped.

c. Developing or improving areas to enhance use and enjoyment of water resources by recreational boaters.

d. Providing for the protection and safety of the facilities and the users of the facilities.

Note: You need to adjust figures in columns c and e of Section A so that no negative values are displayed. But FIRST make all of your entries in Section B.

This text block and others on this page will not show up when printed.

Complete section B FIRST To change this value click on the dollar sign.

Check for errors and submit form.

Construction Budget Form(s) (SF-424C) Available Here If adjusting figures in columns c and e cannot remedy negative values there are 2 other solutions. 1) Add more money to Section B or 2) Reduce the amount in cell E13.

Return to Budget Training Video Available Run-Time - 30 Minutes $0 $0 $ - 0 $ - 0

Error Check

Section A must not contain any negative values.

SUBMIT

Total from Section A must equal total from Section B.

ERROR CHECK

Result Required Action Fix Budget Sheet Federal share must not exceed non-federal share.

ADDITIONAL FORMS OR INFORMATION REQUIRED

Program Requirements Construction Budget Form(s) (SF-424C) Available Here

Submit

INSTRUCTIONS

FOR SUBMITTING YOUR BUDGET INFORMATION SHEET

Submissions are being done through Grants.gov

Submit this file (in Excel format) as an attachment to your application in Grants.gov. Do NOT complete the optional SF-424A in Grants.gov. Using this "BudgetTool" is the preferred method and takes the place of the on-line form.

Additionally, please e-mail this file in Excel format to your Coast Guard Grant Management Specialist.

USCG Use Only

&R&F &A &D

Const Budget (SF-424C)

Use unhide command to unhide additional sheets as needed. You need a seperate form for each project.

Return to Error Check Return to Budget Sheet Overview Help for unhiding sheets is available here.

Const Budget (SF-424C) (2)

Use unhide command to unhide additional sheets as needed. You need a seperate form for each project.

Return to Error Check Return to Budget Sheet Overview

Const Budget (SF-424C) (3)

Use unhide command to unhide additional sheets as needed. You need a seperate form for each project.

Return to Error Check Return to Budget Sheet Overview

Const Budget (SF-424C) (4)

Use unhide command to unhide additional sheets as needed. You need a seperate form for each project.

Return to Error Check Return to Budget Sheet Overview

Const Budget (SF-424C) (5)

Use unhide command to unhide additional sheets as needed. You need a seperate form for each project.

Return to Error Check Return to Budget Sheet Overview

Const Budget (SF-424C) (6)

Use unhide command to unhide additional sheets as needed. You need a seperate form for each project.

Return to Error Check Return to Budget Sheet Overview

Const Budget (SF-424C) (7)

Use unhide command to unhide additional sheets as needed. You need a seperate form for each project.

Return to Error Check Return to Budget Sheet Overview

Const Budget (SF-424C) (8)

Use unhide command to unhide additional sheets as needed. You need a seperate form for each project.

Return to Error Check Return to Budget Sheet Overview

Const Budget (SF-424C) (9)

Use unhide command to unhide additional sheets as needed. You need a seperate form for each project.

Return to Error Check Return to Budget Sheet Overview

Const Budget (SF-424C) (10)

Use unhide command to unhide additional sheets as needed. You need a seperate form for each project.

Return to Error Check Return to Budget Sheet Overview

Const Budget (SF-424C) (11)

Use unhide command to unhide additional sheets as needed. You need a seperate form for each project.

Return to Error Check Return to Budget Sheet Overview

Const Budget…