5. Budget Template.xlsx

XLSX spreadsheet 304 KB Posted May 1, 2025

Attached to: Nevada Substance Use Prevention Treatment Recovery Services Request for Application
Solicitation number: 40DHHS-S3333
Issued by: Nevada

About this file

Written by GovTribe AI · May 1, 2025

The file is a Budget Template Excel spreadsheet, which appears to be a standard budget narrative and budget summary form likely used for a state or local government grant or contract application. The template provides a comprehensive framework for detailing budget expenses across multiple categories including personnel, travel, operating costs, equipment, contractual services, training, and other expenses. While no specific project details are populated in the template, it is designed to capture extensive financial information with built-in formulas for calculating totals across various budget line items.

The budget template includes an 8% indirect cost rate, with sections for documenting funding sources, secured and requested funds, and a breakdown of expenses by category. The document allows for multiple funding sources to be recorded and provides extensive guidance for adding or removing employee and contractor rows, ensuring flexibility in budget preparation. Notably, the template requires detailed justification for each budget category, such as explaining the purpose of training, equipment purchases, and other significant expenditures, and includes instructions for how to properly complete the form using Excel formulas and cell manipulation techniques.

View the file

Other files

File	Type	Posted
3. NV SUPTRS RFA Application.docx	DOCX document	May 1, 2025
4. Scope Template.docx	DOCX document	May 1, 2025
2. SUPTRS RFA Announcement Informational Resource.pdf	PDF	May 1, 2025
Quote Instructions.pdf	PDF	May 1, 2025
6. Funding Acknowledgement Form.pdf	PDF	May 1, 2025

On GovTribe

Work with this file

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Budget Narrative

Applicant Name:

BUDGET NARRATIVE

(Form Revised July 2022)

		USE FORMULAS FOR ALL TOTALS
	Total Personnel Costs		including fringe		Total:		$ - 0
								*Do not delete this row. Grey row used to maintain range of total formulas when employee rows are added/deleted
	List staff, positions, percent of time to be spent on the project, rate of pay, fringe rate, and total cost to this grant.
		Annual Salary	Fringe Rate	% of Time	Months	Percent of Months worked Annual	Amount Requested	Click here to go to an example of how to add extra employee rows
	Name of Employee (if known, otherwise state new position),
Title of position & Position Control Number	$0.00	0.000%	25.000%	12	100.00%	$0
	*Insert details to describe position duties as it relates to the funding (specific program objectives)							Click here to go to an example of how to remove extra employee rows
		Annual Salary	Fringe Rate	% of Time	Months	Percent of Annual	Amount Requested
	Name of Employee (if known, otherwise state new position),
Title of position & Position Control Number	$0.00	0.000%	25.000%	12	100.00%	$0
	*Insert details to describe position duties as it relates to the funding (specific program objectives)
		Annual Salary	Fringe Rate	% of Time	Months	Percent of Annual	Amount Requested
	Name of Employee (if known, otherwise state new position),
Title of position & Position Control Number	$0.00	0.000%	25.000%	12	100.00%	$0
	*Insert details to describe position duties as it relates to the funding (specific program objectives)
		Annual Salary	Fringe Rate	% of Time	Months	Percent of Annual	Amount Requested
	Name of Employee (if known, otherwise state new position),
Title of position & Position Control Number	$0.00	0.000%	25.000%	12	100.00%	$0
	*Insert details to describe position duties as it relates to the funding (specific program objectives)
	*Insert new row for each position funded or delete this row.

				*Do not delete this row. Grey row used to maintain range of total formulas when employee rows are added/deleted
Total Fringe Cost	$0	Total Salary Cost:	$0
Total Budgeted FTE	1.00000

Travel				Total:		$0
Identify staff who will travel, the purpose, frequency and projected costs. Utilize GSA rates for per diem and lodging (go to www.gsa.gov) and State rates for mileage (62.5 cents) as a guide unless the organization's policies specify lower rates for these expenses. Out-of-state travel or non-standard fares require special justification.
Out-of-State Travel						$0	double check formula and revise as needed to include costs of multiple trips
Title of Trip & Destination such as CDC Conference: San Diego, CA	Cost	# of Trips	# of days	# of Staff
Airfare: cost per trip (origin & designation) x # of trips x # of staff	$0	0		0	$0
Baggage fee: $ amount per person x # of trips x # of staff	$0	0		0	$0
Per Diem: $ per day per GSA rate for area x # of trips x # of staff	$0	0	0	0	$0
Lodging: $ per day + $ tax = total $ x # of trips x # of nights x # of staff	$0	0	0	0	$0
Ground Transportation: $ per r/trip x # of trips x # of staff	$0	0	0	0	$0
Mileage: (rate per mile x # of miles per r/trip) x # of trips x # of staff	$0.000	0		0	$0
Parking: $ per day x # of trips x # of days x # of staff	$0	0	0	0	$0

Justification:

Who will be traveling, when and why, tie into program objective(s) or indicate required by funder.

In-State Travel						$0	double check formula and revise as needed to include costs of multiple trips
Origin & Destination	Cost	# of Trips	# of days	# of Staff
Airfare: cost per trip (origin & designation) x # of trips x # of staff	$0	0		0	$0
Baggage fee: $ amount per person x # of trips x # of staff	$0	0		0	$0
Per Diem: $ per day per GSA rate for area x # of trips x # of staff	$0	0	0	0	$0
Lodging: $ per day + $ tax = total $ x # of trips x # of nights x # of staff	$0	0	0	0	$0
Motor Pool:($ car/day + ## miles/day x $ rate per mile) x # trips x # days	$0.00	0	0		$0
Mileage: (rate per mile x # of miles per r/trip) x # of trips x # of staff	$0.000	0		0	$0
Parking: $ per day x # of trips x # of days x # of staff	$0	0	0	0	$0

Justification:

Who will travel and why

Operating				Total:		$0
List tangible and expendable personal property, such as office supplies, program supplies, etc. Unit cost for general items are not required. Listing of typical or anticipated program supplies should be included. If providing meals, snacks, or basic nutrition, include these costs here.
	Monthly expense	FTE	Number of Months		Total
Office supplies $ amount x # of FTE staff x # of mo.					$0.00
Rent: $ per/mo. x 12 months x # of FTE					$0.00
Communications					$0.00
Justification: Provide narrative to justify purchase of meals, snacks, large expense or unusual budget items. Include details how budget item supports deliverables of the project.
Equipment				Total:		$0
List Equipment purchase or lease costing $5,000 or more, and justify these expenditures. Also list any computers or computer-related equipment to be purchased regardless of cost. All other equipment costing less than $5,000 should be listed under Supplies.
	Quantity	Cost per each			Total
Describe equipment					$0.00
Justification: Provide narrative to justify purchase. Include details how budget item supports deliverables of the project.
Contractual						$0
							*Do not delete this row. Grey row used to maintain range of total formulas when contractor rows are added/deleted
Identify project workers who are not regular employees of the organization. Include costs of labor, travel, per diem, or other costs. Collaborative projects with multiple partners should expand this category to break out personnel, travel, equipment, etc., for each site. Sub-awards or mini-grants that are a component of a larger project or program may be included here, but require special justification as to the merits of the applicant serving as a "pass-through" entity, and its capacity to do so.							Click here to go to an example of how to add extra contractor rows
Name of Contractor or Subrecipient:			Total	$0
Method of Selection: explain, i.e. sole source or competitive bid							Click here to go to an example of how to remove extra contractor row
Period of Performance: June 30, 20xx - June 29, 20xx
Scope of Work: Define scope of work

What will be the specific services/tasks that will be completed and specific deliverables. How do deliverables relate to your goals and objectives, how will deliverables achieve your objective(s).

* Sole Source Justification: Define if sole source method, not needed for competitive bid
Budget
Personnel	$0.00	Click here to go to an example of how to add extra line items to a contractor
Travel	$0.00
Total Budget	$0.00
Method of Accountability:

Define - Describe how the progress and performance of the consultant will be monitored. Identify who is responsible for supervising the consultant's work.

*Do not delete this row. Grey row used to maintain range of total formulas when contractor rows are added/deleted

Training			Total:		$0
List all cost associated with Training, including justification of expenditures.
	Registration costs	FTE		Total
Describe training

Justification: Provide narrative to justify purchase. Include details how budget item supports deliverables of the project.
Other				Total:		$0
Identify and justify these expenditures, which can include virtually any relevant expenditure associated with the project, such as audit costs, car insurance, client transportation, etc. Stipends or scholarships that are a component of a larger project or program may be included here, but require special justification.
	Monthly expense	FTE	Number of Months		Total
Printing Services: $ amount/mo. x 12 months	$0				$0
Copier/Printer Lease: $ amount x 12 months	$0				$0
Property and Contents Insurance per year	$0				$0
Other Utilities: $ per quarter	$0				$0
Postage: $ per mo. x 12 months	$0				$0
State Phone Line: $ per mo. x 12 months x # 0f FTE	$0				$0
Voice Mail: $ per mo. x 12 months x # of FTE	$0				$0
Conference Calls: $ per mo. x 12 months	$0				$0
Long Distance: $ per mo. x 12 months	$0				$0
Email: $ per mo. x 12 months x # of FTE	$0				$0
Justification: Include narrative to justify any special budget line items included in this category, such as stipends, scholarships, marketing brochures or public information. Tie budget piece to project deliverable.

TOTAL DIRECT CHARGES $0

Indirect Charges	Indirect Rate:	8.000%	$0
Indirect Methodology: Explain how indirect is calculated (e.g. 8% of all direct expenses per Federally approved indirect agreement). If using a Federally approved indirect rate, be sure to include a copy of the agreement to DHHS staff.

TOTAL BUDGET Total: $0

Budget Summary

	Applicant Name:	Form 2
PROPOSED BUDGET SUMMARY

(Form Revised May 2019)

A. PATTERN BOXES ARE FORMULA DRIVEN - DO NOT OVERIDE - SEE INSTRUCTIONS

FUNDING SOURCES	Funding Source	Other Funding	Other Funding	Other Funding	Other Funding	Other Funding	Other Funding	Program Income	TOTAL
SECURED
ENTER TOTAL REQUEST	$0								$0

EXPENSE CATEGORY
Personnel	$0	$0
Travel	$0	$0
Operating	$0	$0
Equipment	$0	$0
Contractual/Consultant	$0	$0
Training	$0	$0
Other Expenses	$0	$0
Indirect	$0	$0

TOTAL EXPENSE $0 $0 $0 $0 $0 $0 $0 $0 $0

These boxes should equal 0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Total Indirect Cost	$0	Total Agency Budget	$0
		Percent of Subrecipient Budget	ERROR:#DIV/0!

B. Explain any items noted as pending:

C. Program Income Calculation:

&"Arial,Italic"&8&Z&F

Add-Remove Lines Examples

Add/Remove employee rows
	Add an employee
1.	Select/highlight the 3 rows of another employee currently in the budget (1st row is the header row of employee information [row 7 of screenshot], 2nd row is the employee information [row 8 of screenshot], 3rd is the employee narrative [row 9 of screenshot]).

Screenshot
2.	Copy the 3 highlighted rows. This can be done by pressing “CTRL” + “C” or right clicking the highlighted rows and left clicking copy on the menu.

Screenshot
3.	Right click 1 row below what you just copied (row 10 in screenshot below), and left click “Insert Copied Cells”. This will insert 3 rows of an exact copy of your previous 3 row selection. This ensures all formulas are exactly copied and pasted, plus ensures all sum or sumproduct formulas for personnel/fringe total expand WITH your new employee data.

Screenshot
4.	Screenshot below is example of the final result. Two employee sections of the same information and formulas that followed/expanded without any additional edits. Modify the second employee area to account for the name/position/pay etc… changes of the new employee area.

Screenshot
	Remove an employee
1.	Highlight the 3 rows of employee data you want to delete (1st row is the header row of employee information [row 10 of screenshot], 2nd row is the employee information [row 11 of screenshot], 3rd row is the employee narrative [row 12 of screenshot]).

Screenshot
2.	Press "CTRL" + "-" or right click the rows then left click “Delete”.
Screenshot
Add/Remove contractor rows
	Add a contractor
1.	Highlight/Select the row below the "Method of Accountability" row of the previous contractor (row 75 of screenshot). Add a new row by pressing "CTRL" + "+" or right clicking the highlighted row then and left clicking "Insert".

Screenshot
2.	Select/highlight the 10 rows of another contractor currently in the budget (1st row is the row with contractor name and "total" [row 65 of screenshot], 10th row is the "Method of Accountability" row [row 74 of screenshot]).

Screenshot
3.	Right click 1 row below the blank row you just added (row 76 of the screenshot) then right click "Insert Copied Cells". Update the information for the new contractor.

Screenshot
	Remove a contractor
1.	Select/highlight the 11 rows of the contractor (the 1st row is the blank row above the contractor's name [row 75 of screenshot], the 11th row is the "Method of Accountability" row [row 85 of screenshot]). Press "CTRL" + - or righ click the highlighted area and left click "Delete"

Screenshot
	Add contractor line item
1.	Highlight/select the row that says "Travel" (row 72 of screenshot). Add a new row by pressing "CTRL" + "+" or right click the highlighted area then left click "Insert"

Screenshot
2.	Highlight/Select the new blank row (row 72 of screenshot)
Screenshot
3.	Copy the data from the row above by pressing "CTRL" + "D"
Screenshot
4.	Update the category title and amount. Repeat as needed. Adding line items this way ensures that all sum formulas expand with the new data and all new line items retain the same format.

Screenshot

Internal Use Only

Budget Summary
Column	Col A	Col B	Col C	Col D	Col E	Col F	Col G	Col H	Col I	Col J	Total
Ideal width	24	11	11	11	11	11	11	11	11	11	123
Current	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Difference	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Result
ERROR:#VALUE!	Click on cell and press "F2" to ensure current width is recalculated
Budget Narrative
Column	Col A	Col B	Col C	Col D	Col E	Col F	Col G	Total
Ideal width	31	11	8	10	9	12	12	93
Current	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Difference	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Result
ERROR:#VALUE!	Click on cell and press "F2" to ensure current width is recalculated

image1.png image10.png image11.png image12.png image13.png image14.png image2.png image3.png image4.png image5.png image6.png image7.png image8.png image9.png

File details come from the government source that posted it. Updated May 1, 2025.