1305M325R0002 - Attachment 4 - Cost and Price Breakdown.xlsx

XLSX spreadsheet 237 KB Posted Dec 5, 2024

Attached to: Phased Array Radar (PAR) Test Article Federal contract opportunity
Solicitation number: 1305M325R0002
Issued by: Department of Commerce National Oceanic and Atmospheric Administration

About this file

Written by GovTribe AI · Dec 5, 2024

This is a pricing template spreadsheet (Attachment 4) for solicitation 1305M325R0002 that provides detailed cost breakdown tables for contractors to complete. The template includes sections for Cost and Price Detail covering CLINs 1001-3001 (CPFF contract type) and 5101-5501 (T&M contract type), with pre-populated values showing $9.8M total for the T&M support/maintenance option periods across 5 years ($800K-$2.4M per year).

The spreadsheet contains detailed cost element breakdowns for direct labor rates, indirect costs, materials, subcontracts, and other costs across three contract years, with sections for fringe benefits, overhead, G&A, and fee calculations. It includes separate tabs for historical/proposed rates and indirect expense schedules. The template requires offerors to adjust cost elements and formulas to match their accounting systems and proposed costs for the Phased Array Radar Test Article project.

View the file

Other files for this federal contract opportunity

Other files attached to Phased Array Radar (PAR) Test Article, newest first.
File	Type	Posted
NOAA RFP 1305M325R0002 PAR SOLICITATION QA Additional Questions.pdf	PDF	Mar 10, 2025
1305M325R0002 - Attachment 1 - PAR Performance Work Statement Amendment 6 REDLINES.pdf	PDF	Mar 10, 2025
1305M325R0002 - Attachment 4 - Cost and Price Breakdown - Amendment 6.xlsx	XLSX spreadsheet	Mar 10, 2025
1305M325R0002 Amd 0006.pdf	PDF	Mar 10, 2025
1305M325R0002 - Amendment 6 CLEAN.pdf	PDF	Mar 10, 2025
1305M325R0002 - Amendment 6 REDLINES.pdf	PDF	Mar 10, 2025
1305M325R0002 - Attachment 1 - PAR Performance Work Statement Amendment 6 CLEAN.pdf	PDF	Mar 10, 2025
1305M325R0002 Amd 0005.pdf	PDF	Feb 25, 2025
FINAL NOAA RFP 1305M325R0002 PAR SOLICITATION QA 3RD ROUND.pdf	PDF	Feb 24, 2025
1305M325R0002 Amd 0004.pdf	PDF	Feb 24, 2025
1305M325R0002 - Amendment 4 CLEAN.pdf	PDF	Feb 24, 2025
1305M325R0002 - Attachment 6 - DCAA Preaward Survey of Prospective Contractor Accounting System Checklist.pdf	PDF	Feb 24, 2025
1305M325R0002 - Attachment 1 - PAR Performance Work Statement Amendment 4 CLEAN.pdf	PDF	Feb 24, 2025
1305M325R0002 - Attachment 1 - PAR Performance Work Statement Amendment 4 REDLINES.pdf	PDF	Feb 24, 2025
1305M325R0002 - Amendment 4 REDLINES.pdf	PDF	Feb 24, 2025
1305M325R0002 Amd 0003.pdf	PDF	Feb 7, 2025
1305M325R0002 Amendment 3 CLEAN.pdf	PDF	Feb 7, 2025
1305M325R0002 Amendment 3 REDLINES.pdf	PDF	Feb 7, 2025
1305M325R0002 Amd 0002.pdf	PDF	Jan 31, 2025
1305M325R0002 Amendment 2 REDLINES.pdf	PDF	Jan 31, 2025
1305M325R0002 - Attachment 1 - PAR Performance Work Statement CLEAN.pdf	PDF	Jan 31, 2025
1305M325R0002 Amendment 2 CLEAN.pdf	PDF	Jan 31, 2025
1305M325R0002 - Attachment 1 - PAR Performance Work Statement REDLINES.pdf	PDF	Jan 31, 2025
NOAA RFP 1305M325R0002 - PAR SOLICITATION - Q and A 2ND ROUND.pdf	PDF	Jan 31, 2025
1305M325R0002 Amendment 1 CLEAN.pdf	PDF	Dec 13, 2024
1305M325R0002 Amendment 1 REDLINES.pdf	PDF	Dec 13, 2024
1305M325R0002 Amd 0001.pdf	PDF	Dec 13, 2024
Solicitation 1305M325R0002.pdf	PDF	Dec 5, 2024
1305M325R0002 - Attachment 1a - PWS Appendix A - Site Information.pdf	PDF	Dec 5, 2024
1305M325R0002 - Attachment 6 - SF1408-14f.pdf	PDF	Dec 5, 2024
1305M325R0002 - Attachment 5 - Supply Chain Risk Assessment Information Questionnaire.pdf	PDF	Dec 5, 2024
1305M325R0002 - Attachment 1 - PAR Performance Work Statement.pdf	PDF	Dec 5, 2024
1305M325R0002 - Attachment 2 - PAR Site Soil Sample Report - Project No. 731-23076.pdf	PDF	Dec 5, 2024
1305M325R0002 - Attachment 3 - Construction Wage Rate Requirements - Wage Determination OK20230042.pdf	PDF	Dec 5, 2024
1305M325R0002 - Attachment 7 - SOFTWARE Self Attestation Common Form.docx	DOCX document	Dec 5, 2024

Show all 35

On GovTribe

Work with this file on GovTribe

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.

Table of Contents 1305M325R0002 - Attachment 4 - Cost and Price Breakdown

Cost and Price Detail

Table of Contents

TAB NAME	EXHIBIT TITLE
Total Proposed Cost/Price	Summary of Total Proposal
Total of Cost CLINs	CLIN Cost Element Breakdown
CLIN 1001	Cost breakdown for CLIN 1001
CLIN 2001	Cost breakdown for CLIN 2001
CLIN 3001	Cost breakdown for CLIN 3001
Task Five (CLIN 5X0X) Labor Rates	Labor Rates for Optional T&M CLINs
Exhibit 001	Historical/Proposed Rates Summary Schedule
Exhibit 002	Indirect Expense Schedules

Attachment 5 - Cost Sheet

TOTAL PROPOSED COSTPRICE

Total Proposed Price (All CLINs)

CLIN	Task	Task	Period of Performance	Contract Type	Fixed Fee	Cost/Price
1001	One (1)	RTA	Three (3) year base period	CPFF	$ - 0	$ - 0
2001	Two (2)	RTF (including construction)		CPFF	$ - 0	$ - 0
3001	Three (3)	Installation and Integration of RTA		CPFF	$ - 0	$ - 0
4001	Four (4)	Documentation & Training		FFP		$ - 0
5101	Five (5)	Support and Maintenance - Option Period One	Five (5) one-year options	T&M		$ 800,000.00
5201	Five (5)	Support and Maintenance - Option Period Two				$ 2,100,000.00
5301	Five (5)	Support and Maintenance - Option Period Three				$ 2,200,000.00
5401	Five (5)	Support and Maintenance - Option Period Four				$ 2,300,000.00
5501	Five (5)	Support and Maintenance - Option Period Five				$ 2,400,000.00
				Total Price		$ 9,800,000.00

Total of Cost CLINs

Total Proposal Contract Value Summary (CLINs 1001, 2001, 3001)

ELEMENT OF COST	CY01			CY02			CY03			TOTAL
	Labor Hours	Rate	Dollars	Labor Hours	Rate	Dollars	Labor Hours	Rate	Dollars	Labor Hours	Rate	Dollars
DIRECT LABOR
Direct Labor Rate 1	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Direct Labor Rate 2	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Direct Labor Rate 3	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Total Direct Labor	0		$0.00	0		$0.00	0		$0.00	0		$0.00

INDIRECT COSTS
Fringe	0%	$0.00	0%	$0.00	0%	$0.00	0%	$0.00
Labor Overhead 1	0%	$0.00	0%	$0.00	0%	$0.00	0%	$0.00
Labor Overhead 2	0%	$0.00	0%	$0.00	0%	$0.00	0%	$0.00
Labor Overhead 3	0%	$0.00	0%	$0.00	0%	$0.00	0%	$0.00
Total Indirect		$0.00		$0.00		$0.00		$0.00

MATERIAL
Direct Material		$0.00		$0.00		$0.00		$0.00
Direct Material Escalation	0%		0%		0%		0%
Total Material		$0.00		$0.00		$0.00		$0.00

SUBCONTRACTS
Subcontractor 1	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Subcontractor 2	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Subcontractor 3	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Subcontractor 4	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Subcontractor 5	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Subcontractor 6	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Total Subcontracts	0		$0.00	0		$0.00	0		$0.00	0		$0.00

OTHER COSTS
Other Direct Costs	$0.00	$0.00	$0.00	$0.00
Total Other Costs	$0.00	$0.00	$0.00	$0.00

SubTotal Costs $0.00 $0.00 $0.00 $0.00

G&A 0% $0.00 0% $0.00 0% $0.00 0% $0.00

Subtotal Fee Bearing Cost $0.00 $0.00 $0.00 $0.00

FCCOM 0% $0.00 0% $0.00 0% $0.00 0% $0.00

Total FCCOM $0.00 $0.00 $0.00 $0.00

Total Estimated Cost Less Fee $0.00 $0.00 $0.00 $0.00

Fixed Fee (See Solicitation Section L) 0.000% $0.00 0.000% $0.00 0.000% $0.00 0.000% $0.00

Total Fee $0.00 $0.00 $0.00 $0.00

Total Hours 0 0 0 0

GRAND TOTAL Price $0.00 $0.00 $0.00 $0.00

NOTES:

The Offeror must adjust the specific cost elements and its formulas to reflect their accounting system and proposed costs.

CLIN 1001

Cost Sheet - CLIN 1001 Cost Element Breakdown

CLIN 1001
ELEMENT OF COST	CY01			CY02			CY03			TOTAL
	Labor Hours	Rate	Dollars	Labor Hours	Rate	Dollars	Labor Hours	Rate	Dollars	Labor Hours	Rate	Dollars
DIRECT LABOR
Direct Labor Rate 1	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Direct Labor Rate 2	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Direct Labor Rate 3	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Total Direct Labor	0		$0.00	0		$0.00	0		$0.00	0		$0.00

INDIRECT COSTS
Fringe	0%	$0.00	0%	$0.00	0%	$0.00	0%	$0.00
Labor Overhead 1	0%	$0.00	0%	$0.00	0%	$0.00	0%	$0.00
Labor Overhead 2	0%	$0.00	0%	$0.00	0%	$0.00	0%	$0.00
Labor Overhead 3	0%	$0.00	0%	$0.00	0%	$0.00	0%	$0.00
Total Indirect		$0.00		$0.00		$0.00		$0.00

MATERIAL
Direct Material		$0.00		$0.00		$0.00		$0.00
Direct Material Escalation	0%		0%		0%		0%
Total Material		$0.00		$0.00		$0.00		$0.00

SUBCONTRACTS
Subcontractor 1	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Subcontractor 2	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Subcontractor 3	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Subcontractor 4	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Subcontractor 5	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Subcontractor 6	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Total Subcontracts	0		$0.00	0		$0.00	0		$0.00	0		$0.00

OTHER COSTS
Other Direct Costs	$0.00	$0.00	$0.00	$0.00
Total Other Costs	$0.00	$0.00	$0.00	$0.00

SubTotal Costs $0.00 $0.00 $0.00 $0.00

G&A 0% $0.00 0% $0.00 0% $0.00 0% $0.00

Subtotal Fee Bearing Cost $0.00 $0.00 $0.00 $0.00

FCCOM 0% $0.00 0% $0.00 0% $0.00 0% $0.00

Total FCCOM $0.00 $0.00 $0.00 $0.00

Total Estimated Cost Less Fee $0.00 $0.00 $0.00 $0.00

Fixed Fee (See Solicitation Section L) 0.000% $0.00 0.000% $0.00 0.000% $0.00 0.000% $0.00

Total Fee $0.00 $0.00 $0.00 $0.00

Total Hours 0 0 0 0

GRAND TOTAL Price $0.00 $0.00 $0.00 $0.00

NOTES:

The Offeror must adjust the specific cost elements and its formulas to reflect their accounting system and proposed costs.

CLIN 2001

Cost Sheet - CLIN 2001 Cost Element Breakdown

CLIN 2001
ELEMENT OF COST	CY01			CY02			CY03			TOTAL
	Labor Hours	Rate	Dollars	Labor Hours	Rate	Dollars	Labor Hours	Rate	Dollars	Labor Hours	Rate	Dollars
DIRECT LABOR
Direct Labor Rate 1	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Direct Labor Rate 2	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Direct Labor Rate 3	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Total Direct Labor	0		$0.00	0		$0.00	0		$0.00	0		$0.00

INDIRECT COSTS
Fringe	0%	$0.00	0%	$0.00	0%	$0.00	0%	$0.00
Labor Overhead 1	0%	$0.00	0%	$0.00	0%	$0.00	0%	$0.00
Labor Overhead 2	0%	$0.00	0%	$0.00	0%	$0.00	0%	$0.00
Labor Overhead 3	0%	$0.00	0%	$0.00	0%	$0.00	0%	$0.00
Total Indirect		$0.00		$0.00		$0.00		$0.00

MATERIAL
Direct Material		$0.00		$0.00		$0.00		$0.00
Direct Material Escalation	0%		0%		0%		0%
Total Material		$0.00		$0.00		$0.00		$0.00

SUBCONTRACTS
Subcontractor 1	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Subcontractor 2	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Subcontractor 3	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Subcontractor 4	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Subcontractor 5	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Subcontractor 6	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Total Subcontracts	0		$0.00	0		$0.00	0		$0.00	0		$0.00

OTHER COSTS
Other Direct Costs	$0.00	$0.00	$0.00	$0.00
Total Other Costs	$0.00	$0.00	$0.00	$0.00

SubTotal Costs $0.00 $0.00 $0.00 $0.00

G&A 0% $0.00 0% $0.00 0% $0.00 0% $0.00

Subtotal Fee Bearing Cost $0.00 $0.00 $0.00 $0.00

FCCOM 0% $0.00 0% $0.00 0% $0.00 0% $0.00

Total FCCOM $0.00 $0.00 $0.00 $0.00

Total Estimated Cost Less Fee $0.00 $0.00 $0.00 $0.00

Fixed Fee (See Solicitation Section L) 0.000% $0.00 0.000% $0.00 0.000% $0.00 0.000% $0.00

Total Fee $0.00 $0.00 $0.00 $0.00

Total Hours 0 0 0 0

GRAND TOTAL Price $0.00 $0.00 $0.00 $0.00

NOTES:

The Offeror must adjust the specific cost elements and its formulas to reflect their accounting system and proposed costs.

CLIN 3001

Cost Sheet - CLIN 3001 Cost Element Breakdown

CLIN 3001
ELEMENT OF COST	CY01			CY02			CY03			TOTAL
	Labor Hours	Rate	Dollars	Labor Hours	Rate	Dollars	Labor Hours	Rate	Dollars	Labor Hours	Rate	Dollars
DIRECT LABOR
Direct Labor Rate 1	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Direct Labor Rate 2	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Direct Labor Rate 3	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Total Direct Labor	0		$0.00	0		$0.00	0		$0.00	0		$0.00

INDIRECT COSTS
Fringe	0%	$0.00	0%	$0.00	0%	$0.00	0%	$0.00
Labor Overhead 1	0%	$0.00	0%	$0.00	0%	$0.00	0%	$0.00
Labor Overhead 2	0%	$0.00	0%	$0.00	0%	$0.00	0%	$0.00
Labor Overhead 3	0%	$0.00	0%	$0.00	0%	$0.00	0%	$0.00
Total Indirect		$0.00		$0.00		$0.00		$0.00

MATERIAL
Direct Material		$0.00		$0.00		$0.00		$0.00
Direct Material Escalation	0%		0%		0%		0%
Total Material		$0.00		$0.00		$0.00		$0.00

SUBCONTRACTS
Subcontractor 1	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Subcontractor 2	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Subcontractor 3	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Subcontractor 4	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Subcontractor 5	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Subcontractor 6	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00	0	$0.00	$0.00
Total Subcontracts	0		$0.00	0		$0.00	0		$0.00	0		$0.00

OTHER COSTS
Other Direct Costs	$0.00	$0.00	$0.00	$0.00
Total Other Costs	$0.00	$0.00	$0.00	$0.00

SubTotal Costs $0.00 $0.00 $0.00 $0.00

G&A 0% $0.00 0% $0.00 0% $0.00 0% $0.00

Subtotal Fee Bearing Cost $0.00 $0.00 $0.00 $0.00

FCCOM 0% $0.00 0% $0.00 0% $0.00 0% $0.00

Total FCCOM $0.00 $0.00 $0.00 $0.00

Total Estimated Cost Less Fee $0.00 $0.00 $0.00 $0.00

Fixed Fee (See Solicitation Section L) 0.000% $0.00 0.000% $0.00 0.000% $0.00 0.000% $0.00

Total Fee $0.00 $0.00 $0.00 $0.00

Total Hours 0 0 0 0

GRAND TOTAL Price $0.00 $0.00 $0.00 $0.00

NOTES:

The Offeror must adjust the specific cost elements and its formulas to reflect their accounting system and proposed costs.

Task Five (CLIN 5X0X) Labor Rat

Labor Category	Labor Category Description	On-Site Hourly Labor Rates					Off-Site Hourly Labor Rates
		Option Period 1	Option Period 2	Option Period 3	Option Period 4	Option Period 5	Option Period 1	Option Period 2	Option Period 3	Option Period 4	Option Period 5

Exhibit 001

Cost Sheet - Exhibit 001: Historical/Proposed Rates Summary Schedule

RATE						Proposed Rate
	GFY 2020	GFY 2021	GFY 2022	GFY 2023	GFY 2024	GFY 2025	GFY 2026	GFY 2027	GFY 2028

Direct Labor	$0	$0	$0	$0	$0	$0	$0	$0	$0
Direct Labor Escalation	0%	0%	0%	0%	0%	0%	0%	0%	0%
Fringe	0%	0%	0%	0%	0%	0%	0%	0%	0%
Overhead	0%	0%	0%	0%	0%	0%	0%	0%	0%
G&A	0%	0%	0%	0%	0%	0%	0%	0%	0%
Material Burden	0%	0%	0%	0%	0%	0%	0%	0%	0%
Subcontractor Burden	0%	0%	0%	0%	0%	0%	0%	0%	0%
FCCOM	0%	0%	0%	0%	0%	0%	0%	0%	0%
Material Escalation	0%	0%	0%	0%	0%	0%	0%	0%	0%

NOTES:

The Offeror must add and/or adjust specific rate categories to reflect their accounting system and proposed costs.

Exhibit 002

Cost Sheet- Exhibit 002: Indirect Expense Schedules

INDIRECT RATE	Historical Indirect Expense Schedules					Proposed Indirect Expense Schedules
	CFY 2020	CFY2021	CFY2022	CFY 2023	CFY 2024	CFY 2025	CFY 2026	CFY 2027	CFY 2028

Indirect Expense 1

Expense Categories:

Total Expenses: $0 $0 $0 $0 $0 $0 $0 $0 $0

Distribution Base:

Amount

Name of Base

Indirect Rate % 0% 0% 0% 0% -100% 0% 0% 0% 0%

NOTES:

Offeror to replicate cost exhibit 002 template and submit separate exhibits for each indirect expense proposed, providing detail and basis of calculation IAW accounting system.

File details come from the government source that posted it. Updated Dec 5, 2024.