Attachment A - Pricing Spreadsheet v8.26.xlsx

XLSX spreadsheet 51 KB Posted Aug 27, 2020

Attached to: Airport Pavement Consultants Support
Solicitation number: 692M15-20-R-00021
Issued by: Department of Transportation Federal Aviation Administration Technical Center

View the file

Other files

File	Type	Posted
Attachment A - Pricing Spreadsheet v8.26.xlsx	XLSX spreadsheet	Aug 27, 2020
Amendment 001 SIR 692M15-20-R-00021.pdf	PDF	Aug 27, 2020
Pavement Support SIR QA v8.27.docx	DOCX document	Aug 27, 2020
ATTACHMENT C - Past Performance Evaluation Data Form.docx	DOCX document	Aug 17, 2020
692M15-20-R-00021.pdf	PDF	Aug 17, 2020
ATTACHMENT B - LABOR CATEGORY DESCRIPTIONS.pdf	PDF	Aug 17, 2020
Attachment A - Pricing Spreadsheet v8.17..xlsx	XLSX spreadsheet	Aug 17, 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.

Price Proposal; CONTRACT YEAR 1

Attachment A: Pricing Spreadsheet
Solicitation No. 692M15-20-R-00021
	CONTRACT YEAR ONE
Airport Pavement Support

	Period of Performance = three years
Labor Category

		Hours	Direct Labor Rate	Direct Labor Cost	Fringe	Fringe Cost	Overhead Rate	Overhead Cost	G&A Rate	G&A Cost	Profit Rate	Profit Cost	Fully Burdened Rate	Total Cost
Labor		(Estimate)
Program Manager*	off-site	1880		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Construction Manager*	on-site	650		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Civil Engineer 1	on-site	950		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Civil Engineer 1	off-site	950		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Civil Engineer 2	off-site	1880		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Civil Engineer 3	off-site	1880		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Civil Engineer 4*	off-site	940		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Electrical Engineer	on-site	150		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Electrical Engineer	off-site	150		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Electronics Engineer	on-site	560		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Instrumentation Engineer	on-site	560		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Mechanical Engineer	on-site	300		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Mechanical Engineer	off-site	300		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Senior Software Engineer 1	on-site	75		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Senior Software Engineer 1	off-site	75		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Senior Software Engineer 2	off-site	1250		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Senior Software Engineer 3	off-site	620		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Senior Software Engineer 4*	off-site	620		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Structural Engineer 3	off-site	280		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Airport Ops Research Analyst 3	off-site	160		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Computer Programmer/Web Developer	off-site	650		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Co-Op Student/Intern	on-site	238		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Co-Op Student/Intern	off-site	0		$0.00		$0.00		$0.00		$0.00		$0.00	ERROR:#DIV/0!	$0.00
Electro-Mechanical Technician	on-site	650		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Electronics Technician	off-site	1250		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
LabVIEW Programmer	off-site	310		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Land Surveyor	on-site	10		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Research Statistician	off-site	0		$0.00		$0.00		$0.00		$0.00		$0.00	ERROR:#DIV/0!	$0.00
Survey Technician	on-site	310		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Survey Data Specialist	on-site	940		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Scheduler	off-site	310		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Subject Matter Expert	off-site	150		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
System Network Administrator	off-site	310		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Technical Writer/Editor 1	off-site	310		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Technical Writer/Editor 2	off-site	310		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Database Programmer/Administrator	off-site	620		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00

Subtotal	20598	$0.00	$0.00
* = Key Personnel

Travel	$50,000.00
G&A on travel	$0.00
Travel Subtotal (Sheet 2)	$50,000.00

Materials	$100,000.00
MHX	$0.00
G&A on MHX	$0.00
Materials Subtotal	$100,000.00
		TOTAL CONTRACT VALUE FOR 3 YEAR CONTRACT
TOTALS	$150,000.00		$450,000.00

CONTRACT YEAR 2

Attachment A: Pricing Spreadsheet
Solicitation No. 692M15-20-R-00021
	CONTRACT YEAR TWO
Airport Pavement Support

Labor Category

		Hours	Direct Labor Rate	Direct Labor Cost	Fringe	Fringe Cost	Overhead Rate	Overhead Cost	G&A Rate	G&A Cost	Profit Rate	Profit Cost	Fully Burdened Rate	Total Cost
Labor		(Estimate)
Program Manager*	off-site	1880		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Construction Manager*	on-site	1260		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Civil Engineer 1	on-site	1880		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Civil Engineer 1	off-site	1880		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Civil Engineer 2	off-site	3800		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Civil Engineer 3	off-site	3800		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Civil Engineer 4*	off-site	1260		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Electrical Engineer	on-site	310		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Electrical Engineer	off-site	310		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Electronics Engineer	on-site	1260		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Instrumentation Engineer	on-site	1260		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Mechanical Engineer	on-site	630		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Mechanical Engineer	off-site	630		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Senior Software Engineer 1	on-site	160		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Senior Software Engineer 1	off-site	160		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Senior Software Engineer 2	off-site	2500		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Senior Software Engineer 3	off-site	1260		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Senior Software Engineer 4*	off-site	1260		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Structural Engineer 3	off-site	580		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Airport Ops Research Analyst 3	off-site	310		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Computer Programmer/Web Developer	off-site	1260		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Co-Op Student/Intern	on-site	238		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Co-Op Student/Intern	off-site	238		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Electro-Mechanical Technician	on-site	1260		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Electronics Technician	off-site	2520		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
LabVIEW Programmer	off-site	630		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Land Surveyor	on-site	310		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Research Statistician	off-site	310		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Survey Technician	on-site	630		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Survey Data Specialist	on-site	1260		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Scheduler	off-site	940		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Subject Matter Expert	off-site	310		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
System Network Administrator	off-site	630		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Technical Writer/Editor 1	off-site	630		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Technical Writer/Editor 2	off-site	630		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Database Programmer/Administrator	off-site	1260		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00

Subtotal	39446	$0.00	$0.00
* = Key Personnel

Travel	$50,000.00
G&A on travel	$0.00
Travel Subtotal (Sheet 2)	$50,000.00

Materials	$100,000.00
MHX	$0.00
G&A on MHX	$0.00
Materials Subtotal	$100,000.00

TOTALS $150,000.00

CONTRACT YEAR 3

Attachment A: Pricing Spreadsheet
Solicitation No. 692M15-20-R-00021
	CONTRACT YEAR THREE
Airport Pavement Support

Labor Category

		Hours	Direct Labor Rate	Direct Labor Cost	Fringe	Fringe Cost	Overhead Rate	Overhead Cost	G&A Rate	G&A Cost	Profit Rate	Profit Cost	Fully Burdened Rate	Total Cost
Labor		(Estimate)
Program Manager*	off-site	1880		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Construction Manager*	on-site	1880		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Civil Engineer 1	on-site	2820		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Civil Engineer 1	off-site	2820		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Civil Engineer 2	off-site	5640		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Civil Engineer 3	off-site	5640		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Civil Engineer 4*	off-site	1880		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Electrical Engineer	on-site	470		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Electrical Engineer	off-site	470		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Electronics Engineer	on-site	1880		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Instrumentation Engineer	on-site	1880		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Mechanical Engineer	on-site	940		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Mechanical Engineer	off-site	940		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Senior Software Engineer 1	on-site	235		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Senior Software Engineer 1	off-site	235		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Senior Software Engineer 2	off-site	3760		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Senior Software Engineer 3	off-site	1880		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Senior Software Engineer 4*	off-site	1880		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Structural Engineer 3	off-site	870		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Airport Ops Research Analyst 3	off-site	470		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Computer Programmer/Web Developer	off-site	1880		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Co-Op Student/Intern	on-site	238		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Co-Op Student/Intern	off-site	238		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Electro-Mechanical Technician	on-site	1880		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Electronics Technician	off-site	3760		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
LabVIEW Programmer	off-site	940		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Land Surveyor	on-site	470		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Research Statistician	off-site	470		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Survey Technician	on-site	940		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Survey Data Specialist	on-site	1880		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Scheduler	off-site	940		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Subject Matter Expert	off-site	470		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
System Network Administrator	off-site	940		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Technical Writer/Editor 1	off-site	940		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Technical Writer/Editor 2	off-site	940		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00
Database Programmer/Administrator	off-site	1880		$0.00		$0.00		$0.00		$0.00		$0.00	0.0	$0.00

Subtotal	57276	$0.00	$0.00
* = Key Personnel

Travel	$50,000.00
G&A on travel	$0.00
Travel Subtotal (Sheet 2)	$50,000.00

Materials	$100,000.00
MHX	$0.00
G&A on MHX	$0.00
Materials Subtotal	$100,000.00

TOTALS $150,000.00

Materials

Attachment B: Pricing Spreadsheet

Solicitation No. 692M15-20-R-00021

Airport Pavement Consultants

Materials Estimate	PRICE	QTY		TOTAL
				$0.00
				$0.00
				$0.00
				$0.00
				$0.00
				$0.00
				$0.00
				$0.00
				$0.00
				$0.00
				$0.00
				$0.00
				$0.00
				$0.00
				$0.00
			TOTAL:	$0.00

Travel

Attachment B: Pricing Spreadsheet
Solicitation No. 692M15-20-R-00005
Aircraft Rescue and Fire Fighting (ARFF) Technical Support	Total =	$0.00

TRAVEL - TRAVEL - TRAVEL -

Origin	Origin	Origin
Destination	Destination	Destination
Duration Days	Duration Days	Duration Days
Number of Travelers	Number of Travelers	Number of Travelers
Number of Trips	Number of Trips	Number of Trips

Private Vehicle (per trip)			Private Vehicle (per trip)			Private Vehicle (per trip)
	100 miles per trip @ $0.51 per mile	$0.00		100 miles per trip @ $0.51 per mile	$0.00		100 miles per trip @ $0.51 per mile	$0.00

Airport Parking	0	0	Airport Parking	0	0	Airport Parking	0	0
Air Fare (per trip)		$0.00	Air Fare (per trip)		$0.00	Air Fare (per trip)		$0.00
Rental Car ($60/day)	0	$0.00	Rental Car ($60/day)	0	$0.00	Rental Car ($60/day)	0	$0.00

Travel subtotal $0.00 Travel subtotal $0.00 Travel subtotal $0.00

Per Diem

Lodging/day

Meals/day

Per Diem

Lodging/day

Meals/day

Per Diem

Lodging/day

Meals/day

per person per trip

$0.00

per person per trip

$0.00

per person per trip

$0.00

Per Diem cost per person per trip $0.00 Per Diem cost per person per trip $0.00 Per Diem cost per person per trip $0.00

Per Diem subtotal $0.00 Per Diem subtotal $0.00 Per Diem subtotal $0.00

Total Travel: $0.00 Total Travel: $0.00 Total Travel: $0.00

TRAVEL - TRAVEL - TRAVEL -

Origin	Origin	Origin
Destination	Destination	Destination
Duration Days	Duration Days	Duration Days
Number of Travelers	Number of Travelers	Number of Travelers
Number of Trips	Number of Trips	Number of Trips

Private Vehicle (per trip)			Private Vehicle (per trip)			Private Vehicle (per trip)
	100 miles per trip @ $0.51 per mile	$0.00		100 miles per trip @ $0.51 per mile	0.00		100 miles per trip @ $0.51 per mile	$0.00

Airport Parking	0	0.00	Airport Parking	0	0.00	Airport Parking	0	0
Air Fare (per trip)		$0.00	Air Fare (per trip)		$0.00	Air Fare (per trip)		$0.00
Rental Car ($60/day)		$0.00	Rental Car ($60/day)	0	$0.00	Rental Car ($60/day)	0	$0.00

Travel subtotal $0.00 Travel subtotal $0.00 Travel subtotal $0.00

Per Diem

Lodging/day

Meals/day

Per Diem

Lodging/day

Meals/day

Per Diem

Lodging/day

Meals/day

per person per trip

$0.00

per person per trip

$0.00

per person per trip

$0.00

Per Diem cost per person per trip $0.00 Per Diem cost per person per trip $0.00 Per Diem cost per person per trip $0.00

Per Diem subtotal $0.00 Per Diem subtotal $0.00 Per Diem subtotal $0.00

Total Travel: $0.00 Total Travel: $0.00 Total Travel: $0.00

File details come from the government source that posted it. Updated Aug 27, 2020.