Attch 1-Sample Budget Spreadsheet 7Jul18.xlsx

XLSX spreadsheet 41 KB Posted Jul 31, 2020

Attached to: Commercial Domestic Production of Moly-99 without the Use of Highly Enriched Uranium
Opportunity number: DE-FOA-0002303
Issued by: Department of Energy National Nuclear Security Administration

About this file

From the source

Sample Excel Budget Spreadsheet

View the file

Other files

File	Type	Posted
PKG00262847-instructions.docx	DOCX document	Jul 31, 2020
Assurances for Construction SF-424D.pdf	PDF	Jul 31, 2020
FOA-0002303.docx	DOCX document	Jul 31, 2020
Attch 3 Environmental Questionnaire Guidance.docx	DOCX document	Jul 31, 2020
Attach 2 NEPA - Copy.docx	DOCX document	Jul 31, 2020

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.

CFY SUMMARY - Tbl 1

SAMPLE BUDGET DETAIL SPREADSHEET--TABLE 1

COST ELEMENT SUMMARY		Contractor Fiscal Year (CFY) 1			CFY 2			CFY 3		TOTAL ALL YEARS		APPLICANT	NNSA
COST ELEMENT	BASE	RATE	AMOUNT	BASE	RATE	AMOUNT	BASE	RATE	AMOUNT	BASE	AMOUNT	SHARE	SHARE	TOTAL
DIRECT LABOR	Hours			Hours			Hours
LABOR CATEGORY 1/INDIVIDUAL	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$0	$0	$0
LABOR CATEGORY 2/INDIVIDUAL	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$0	$0	$0
LABOR CATEGORY 3/INDIVIDUAL	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$0	$0	$0
LABOR CATEGORY 4/INDIVIDUAL	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$0	$0	$0
ETC.	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$0	$0	$0
TOTAL DIRECT LABOR	0		$ - 0	0		$ - 0	0		$ - 0	0	$ - 0	$0	$0	$0
	Indir Base			Indir Base			Indir Base
FRINGE BENEFITS	$ - 0	0.0%	$ - 0	$ - 0	0.0%	$ - 0	$ - 0	0.0%	$ - 0		$ - 0	$0	$0	$0
LABOR OVERHEAD	$ - 0	0.0%	$ - 0	$ - 0	0.0%	$ - 0	$ - 0	0.0%	$ - 0		$ - 0	$0	$0	$0
TOTAL INDIRECT LABOR EXPENSE			$ - 0			$ - 0			$ - 0		$ - 0	$0	$0	$0

SUBCONTRACTS/CONSULTANTS/INTERCOMPANY
SUB 1 (See Sub CFY Cost Summaries)	$ - 0	$ - 0	$ - 0	$ - 0	$0	$0	$0
SUB 2 (See Sub CFY Cost Summaries)	$ - 0	$ - 0	$ - 0	$ - 0	$0	$0	$0
CONSULTANT 1 (See Consultant Agreement)	$ - 0	$ - 0	$ - 0	$ - 0	$0	$0	$0
CONSULTANT 2 (See Consultant Agreement)	$ - 0	$ - 0	$ - 0	$ - 0	$0	$0	$0
TOTAL SUB/CONSULTANTS/INTERCO	$ - 0	$ - 0	$ - 0	$ - 0	$0	$0	$0

MATERIALS/SUPPLIES/	$ - 0	$ - 0	$ - 0	$ - 0	$0	$0	$0
CONSTRUCTION COSTS PER YEAR
EQUIPMENT	$ - 0	$ - 0	$ - 0	$ - 0	$0	$0	$0

OTHER DIRECT COSTS
TRAVEL (See Travel Tab--Table 3)	$ - 0	$ - 0	$ - 0	$ - 0	$0	$0	$0
ODC - List separately	$ - 0	$ - 0	$ - 0	$ - 0	$0	$0	$0
ODC - List separately	$ - 0	$ - 0	$ - 0	$ - 0	$0	$0	$0
TOTAL ODCS	$ - 0	$ - 0	$ - 0	$ - 0	$0	$0	$0

SUBTOTAL			$ - 0			$ - 0			$ - 0	$ - 0	$0	$0	$0
	Indir Base			Indir Base			Indir Base
G&A or F&A as Appropriate	$ - 0	0.00%	$ - 0	$ - 0	0.00%	$ - 0	$ - 0	0.00%	$ - 0	$ - 0	$0	$0	$0
TOTAL BUDGET			$ - 0			$ - 0			$ - 0	$ - 0	$0	$0	$0

TABLE 1

CONTRACTOR

COST ELEMENT SUMMARY

WARNING: LABOR CATEGORIES, SUBCONTRACTS, TYPES OF COSTS, BASE AMOUNTS AND RATES IN THIS SAMPLE ARE FOR ILLUSTRATION PURPOSES ONLY. PROPOSE ALL COSTS IN ACCORDANCE WITH YOUR ESTABLISHED ACCOUNTING AND ESTIMATING PRACTICES.

Notes:

1. Offeror should propose using its contractor fiscal year, given rates normally change by the contractor fiscal year. If the RFP periods do not align exactly with the Offeror's fiscal year, please adjust the periods in this spreadsheet to match your fiscal year (FY). This may require partial years for the first and last periods. The "BASE" column should include direct productive labor hours, indirect base amounts, or fee base amounts as applicable.

2. If subcontractors and ODCs are proposed, please link amounts from the associated tabs to the Top Summary sheet. In accordance with the Budget Justification Instructions, "For each subcontractor with total project costs of $100,000 or more, a separate SF-424A budget and budget justification form must be submitted along with a separate, completed, Sample Budget Detail Spreadsheet."

3. If subcontracts were competed, provide a summary of the competition (number solicited, amounts, selection criteria, etc.).

4. Keep all formulas (links) intact and do not protect any of the cells.

5. Material, Equipment, and Travel shown on this Summary sheet should be linked back to the detailed associated tabs in this workbook.

6. Recipients are solely responsible for the accuracy of all formulas, links and amounts within this workbook.

7. Assume a January 1, 2019 award date for budget purposes.

SUB-IOTs - Tbl 2

TABLE 2

SUBCONTRACT/INTERORGANIZATIONAL TRANSFERS

PRICE SUMMARY

SUBCONTRACTOR NAME SUBCONTRACT TASKS* SUBCONTRACT CONTRACT TYPE SUBCONTRACTOR QUOTED PRICE SUBCONTRACT PRICE PROPOSED BY PRIME

TOTAL AMOUNTS

*Identify Statement of Work or Work Breakdown Structure or provide a narrative explanation as an addendum.

TRAVEL - Tbl 3

TABLE 3
TRAVEL SUMMARY
	(Develop a table for each CFY)
FROM ___________
	Number	Number	Number	Number		Per Diem	Per Diem	Car
	TRIPS	TRVLRS	DAYS	NIGHTS	AIR	MEALS	LODGING	Rental	MISC.	TOTAL
Destination 1	0	0	0	0	$0	$0	$0	$0.00
	trip costs				$0	$0	$0	$0	$0	$0
Destination 2	0	0	0	0	$0	$0	$0	$0.00
	trip costs				$0	$0	$0	$0	$0	$0
Destination 3	0	0	0	0	$0	$0	$0.00	$0.00
	trip costs				$0	$0	$0	$0	$0	$0
Destination 4	0	0	0	0	$0	$0	$0.00	$0.00
	trip costs				$0	$0	$0	$0	$0	$0
Destination 5	0	0	0	0	$0	$0	$0.00	$0.00
	trip costs				$0	$0	$0	$0	$0	$0
Destination 6	0	0	0	0	$0	$0	$0.00	$0.00
	trip costs				$0	$0	$0	$0	$0	$0
Destination 7	0	0	0	0	$0	$0	$0.00	$0.00
	trip costs				$0	$0	$0	$0	$0	$0
Destination 8	0	0	0	0	$0	$0	$0.00	$0.00
	trip costs				$0	$0	$0	$0	$0	$0
Destination 9	0	0	0	0	$0	$0	$0.00	$0.00
	trip costs				$0	$0	$0	$0	$0	$0
Destination 10	0	0	0	0	$0	$0	$0.00	$0.00
	trip costs				$0	$0	$0	$0	$0	$0
TOTAL										$0

TABLE 3

TRAVEL SUMMARY

MATERIAL - Tbl 4

TABLE 4
BILL OF MATERIALS
	(Develop a table for each CFY)
Item	WBS/Task #	Description of Material	Qty	Unit Price	Total Price	Vendor/Source	Basis of Estimate	Currency of Estimate
1	If	Self Explantory	#	$0.00	ERROR:#VALUE!	Company Name	Purchase Order	Date of Purchase Order,
2	Applicable		#	$0.00	ERROR:#VALUE!	Website URL	Quote	Quote, Catalog, Invoice,
3			#	$0.00	ERROR:#VALUE!	Etc.	Engineering Estimate	etc. (Explain how price
4			#	$0.00	ERROR:#VALUE!		Catalog Price	was derived if not same
5			#	$0.00	ERROR:#VALUE!		Invoice	as catalog, invoice, etc.)
6			#	$0.00	ERROR:#VALUE!		Etc.
7			#	$0.00	ERROR:#VALUE!
8			#	$0.00	ERROR:#VALUE!
9			#	$0.00	ERROR:#VALUE!
10			#	$0.00	ERROR:#VALUE!
11			#	$0.00	ERROR:#VALUE!
12			#	$0.00	ERROR:#VALUE!
13			#	$0.00	ERROR:#VALUE!
14			#	$0.00	ERROR:#VALUE!
15			#	$0.00	ERROR:#VALUE!
16			#	$0.00	ERROR:#VALUE!
17			#	$0.00	ERROR:#VALUE!
18			#	$0.00	ERROR:#VALUE!
19			#	$0.00	ERROR:#VALUE!
20			#	$0.00	ERROR:#VALUE!
21			#	$0.00	ERROR:#VALUE!

Subtotal Materials ERROR:#VALUE!

TABLE 4

MATERIALS

EQUIPMENT - Tbl 5

TABLE 5
EQUIPMENT
	(Develop a table for each CFY)
Item	WBS/Task #	Description of Material	Qty	Unit of Issue	Unit Price	Total Price	Vendor/Source	Basis of Estimate	Currency of Estimate
1	If	Self Explantory	#	ea.	$0.00	ERROR:#VALUE!	Company Name	Purchase Order	Date of Purchase Order,
2	Applicable		#	hrs	$0.00	ERROR:#VALUE!	Website URL	Quote	Quote, Catalog, Invoice,
3			#		$0.00	ERROR:#VALUE!	Etc.	Engineering Estimate	etc. (Explain how price
4			#		$0.00	ERROR:#VALUE!		Catalog Price	was derived if not same
5			#		$0.00	ERROR:#VALUE!		Invoice	as catalog, invoice, etc.)
6			#		$0.00	ERROR:#VALUE!		Etc.
7			#		$0.00	ERROR:#VALUE!
8			#		$0.00	ERROR:#VALUE!
9			#		$0.00	ERROR:#VALUE!
10			#		$0.00	ERROR:#VALUE!
11			#		$0.00	ERROR:#VALUE!
12			#		$0.00	ERROR:#VALUE!
13			#		$0.00	ERROR:#VALUE!
14			#		$0.00	ERROR:#VALUE!
15			#		$0.00	ERROR:#VALUE!
16			#		$0.00	ERROR:#VALUE!
17			#		$0.00	ERROR:#VALUE!
18			#		$0.00	ERROR:#VALUE!
19			#		$0.00	ERROR:#VALUE!
20			#		$0.00	ERROR:#VALUE!
21			#		$0.00	ERROR:#VALUE!

Subtotal Materials ERROR:#VALUE!

TABLE 4

MATERIALS

File details come from the government source that posted it.