ATTACHMENT D 2025 Opioid Needs Assessment Budget Template.xlsx

XLSX spreadsheet 19 KB Posted Jan 31, 2025

Attached to: South Dakota Opioid Needs Assessment
Solicitation number: 25RFP13180
Issued by: Beadle County, South Dakota

About this file

Written by GovTribe AI · Feb 10, 2025

This file is a budget template spreadsheet (Attachment D) for a 2025 Opioid Needs Assessment. The template is structured to capture detailed financial planning across three main categories: Treatment, Prevention, and Other Strategies. The Treatment category encompasses OUD treatment, intervention services, recovery support, criminal justice-involved persons' needs, and services for pregnant women. The Prevention category covers prescribing practices, misuse prevention, and harm reduction. Other Strategies includes first responders, leadership/coordination, training, and research components.

The budget template requires detailed breakdowns of Personnel (including a mandatory Principal Evaluator position), Benefits, Travel, Supplies, Other Expenses, and Indirect Costs. The template includes automated calculations and requires justifications for each cost category. Organizations must provide specific staffing details, fringe benefit calculations, travel purposes and costs, supply needs, and other expenses. Indirect costs can be calculated using either a 10% de minimis rate or another justified rate based on the organization's structure. The template includes safeguards to ensure budget totals match across different sections and categories.

View the file

Other files

File	Type	Posted
Response to Offeror Questions document.pdf	PDF	Feb 21, 2025
ATTACHMENT D 2025 Opioid Needs Assessment Budget Template.xlsx	XLSX spreadsheet	Feb 21, 2025
Exhibit 1 SD Opioid Settlement MOA with Exhibit A.pdf	PDF	Feb 21, 2025
RFP Document.pdf	PDF	Feb 21, 2025
Exhibit 1 SD Opioid Settlement MOA with Exhibit A.pdf	PDF	Jan 31, 2025
RFP Document.pdf	PDF	Jan 31, 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.

Summary Page Offeror: [insert organization name]

Summary	Total from Detailed Budget
Personnel	$ - 0	Do Not Edit These Boxes
Benefits	$ - 0	Only Edit These Boxes
Travel	$ - 0
Supplies	$ - 0
Other	$ - 0
Indirect	$ - 0
Budget Totals	$ - 0
Estimate Totals	$ - 0	Fix Estimates to match Budget
Budget Estimates by Category and Topic Area (Required)
$ - 0	Treatment
	A. Treatment for Opioid Use Disorder (OUD)
	B. Connect People Who need Help to The Help They Need (Intervention)
	C. Support People in Treatment and Recovery and Reduce Stigma
	D. Address the Needs of Criminal Justice-Involved Persons
	E. Address the Needs of Women Who Are or May Become Pregnant
$ - 0	Prevention
	A. Prevent Over-Prescribing and Ensure Proper Prescribing of Opioids
	B. Prevent Misuse of Opioids
	C. Prevention Overdose Deaths and Other Harms (Harm Reduction)
$ - 0	Other Strategies
	A. First Responders
	B. Leadership, Planning and Coordination
	C. Training
	D. Research

Detailed Budget Offeror: [insert organization name]

Budget Category	Budget Totals
Personnel	$ - 0
Benefits	$ - 0
Travel	$ - 0
Supplies	$ - 0
Other	$ - 0
Indirect	$ - 0
Total Budget for Topic A	$ - 0

	Personnel	Person	Hours or FTE	Hourly Rate or Salary	Total
	Project Role	Named personnel must include the Principal Evaluator at minimum. If support personnel are planned but not yet known or hired (e.g., summer intern or graduate assistant) then TBD is acceptable.	Enter whole numbers for hourly. Enter decimal number for FTE. (one full time employee = 1;
one half time = .5, etc.)	Enter rate of pay for this individual. It will be calculated with the "Hours or FTE" value to generate the total	This total is the product of the "Hours or FTE" x "Hourly Rate or Salary".
	Principal Evaluator				$ - 0
	Position 2				$ - 0
	Position 3				$ - 0
	Position 4				$ - 0
	Position 5				$ - 0
				Total Personnel	$ - 0

	Please provide a brief description of position and planned work for the position including areas of focus as they relate to this Topic Area.
	Principal Evaluator
	Position 2
	Position 3
	Position 4
	Position 5
	Benefits	Personnel Cost	Fixed / Lump Sum Fringe Amount	Total Fringe Rate (%)	Calculated Fringe Cost	Total Fringe Benefit Cost
	Instructions
Enter the applicable benefits that would be paid for by this grant. If the "Hourly Rate or Salary" totals include benefits then you will need to explain the benefits breakdown in the "brief descption" portion of the Personnel section	Value auto-filled from Personnel section.	Insert any fixed amount of fringe benefit, pro-rated to FTE or hours budgeted, if applicable.	Insert total fringe benefit rate as applicable.	This total is the product of the "Personnel Cost" x "Total Fringe Rate %".	This total is thesum of "Fixed / Lump Sum Fringe Amount" + "Calculated Fringe Cost".
	Principal Evaluator	$ - 0			$ - 0	$ - 0
	Position 2	$ - 0			$ - 0	$ - 0
	Position 3	$ - 0			$ - 0	$ - 0
	Position 4	$ - 0			$ - 0	$ - 0
	Position 5	$ - 0			$ - 0	$ - 0
					Total Benefits	$ - 0
	[insert fringe beneift cost justification here; if the personnel rates are fully loaded and fringe benefits are not requested separately this section may be left blank and noted as such]
	Travel	Purpose of Travel	Cost Element for trip	Applicable Units	Cost per Unit	Element Total	Travel Total
	Instructions
Enter the travel required for this project. Multiple trips for the same purpose can be combined in one travel line and must be explained in the description section.	Insert travel destination and purpose.	Include the specific cost element for this trip. Options can include: Hotel, Mileage, Per Diem, etc.	Enter the the number of units that will be applied to this "Cost Element".	Enter the cost per each unit.	This total is the product of the "Applicable Units" X "Cost per Unit". If you choose to manually overwrite this calculated value it must be lower than what is calculated	This total is the summed total for each trip. If you choose to manually overwrite this calculated value it must be lower than or equal to what is calculated.
	Travel 1					$ - 0	$ - 0
						$ - 0
						$ - 0
						$ - 0
	Travel 2					$ - 0	$ - 0
						$ - 0
						$ - 0
						$ - 0
	Travel 3					$ - 0	$ - 0
						$ - 0
						$ - 0
						$ - 0
					Total Travel	$ - 0
	Please provide a description of the planned travel.
	Travel 1
	Travel 2
	Travel 3
	Supplies	Item		Cost per Unit	Number of Units	Total
	Instructions: Enter the applicable supplies needed to be directly support the project proposal. If charging an indirect or F&A rate then only supplies that would not be covered by indirect can be included here.			Provide the actual costs of the supply.	Enter the number of units of the listed supply.	This total is the product of the "Cost per Unit" X "Number of Units".
	Supply 1					$ - 0
	Supply 2					$ - 0
	Supply 3					$ - 0
	Supply 4					$ - 0
	Supply 5					$ - 0
					Total Supplies	$ - 0
	[insert Supplies cost justification here]
	Other Expenses	Expense Type		Cost per Unit	Number of Units	Total
	Instructions: Enter all other costs needed for the project to this category. Contractors or consultants may be entered here; use the justification area to explain fee structures and any included travel, as applicable.					This total is the product of the "Cost per Unit" x "Number of Units".
	Other 1					$ - 0
	Other 2					$ - 0
	Other 3					$ - 0
					Total Supplies	$ - 0
	[insert Other Expenses cost justification here]
	Indirect Rate
	Instructions

Enter the applicable Indirect Rate being requested with this application

Base Budget for Indirect		Enter the allowable base amount in alignment with the rate you are charging.
Indirect Rate		Enter the percent (%).
Calculated Indirect Total	$ - 0	This total is the product of the "Base Budget" x "Indirect Rate".
Please provide an explanation of the base budget for indirect used. A justification of the rate is required unless a 10% de minimis rate is being used.

Simply enter "De Minimus" in the explanation if the rate is 10%.

File details come from the government source that posted it. Updated Feb 10, 2025.