Attachment 1 - Price Break Down Workbook KSA PSC.xls

XLS spreadsheet 145 KB Posted Aug 15, 2022

Attached to: AMD 0001: Saudi Personal Service Contract (PSC) for Monitoring Construction Projects
Solicitation number: W912ER22R0041
Issued by: Department of the Army Corps of Engineers Engineering District Middle East

View the file

Other files

File	Type	Posted
ProjNet Responses 20221011.pdf	PDF	Oct 13, 2022
Attachment 2 - CLIN Structure KSA PSC r1 A00001 corrected.xlsx	XLSX spreadsheet	Oct 13, 2022
Attachment 2 - CLIN Structure KSA PSC r1 A00001.xlsx	XLSX spreadsheet	Oct 6, 2022
W912ER22R0041 AMD 0001.pdf	PDF	Oct 6, 2022
Attachment 6 - KSA PSC PRS r1 Sep22.pdf	PDF	Oct 6, 2022
Attachment 4 - Project List A00001.pdf	PDF	Oct 6, 2022
Bidder inquiry 20220929.pdf	PDF	Oct 6, 2022
Attachment 1 - Labor Category Worksheet KSA PSC r1 A00001.xls	XLS spreadsheet	Oct 6, 2022
Attachment 4 - Project List.pdf	PDF	Aug 15, 2022
Solicitation W912ER22R0041.pdf	PDF	Aug 15, 2022
Attachment 7 - Position Duty Descriptions.pdf	PDF	Aug 15, 2022
Attachment 3 - Flat Rate (travel) by Region.xlsx	XLSX spreadsheet	Aug 15, 2022
Attachment 6 - KSA PSC PRS.pdf	PDF	Aug 15, 2022
Attachment 2 - CLIN Structure KSA PSC.xlsx	XLSX spreadsheet	Aug 15, 2022
Attachment 5 - Map of KSA by region.pdf	PDF	Aug 15, 2022

Show all 15

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.

Instructions

PROJECT: KSA PSC SUPPORT SERVICES

LOCATION: SAUDI ARABIA

1. Fill out Cost Breakdown Sheet "CB Saudi Personnel Services" Tab. Offerors are to provide input in cells with no fill. Cells with Green fill indicate formulas while cells with gray fill require no input.

2. For Base CLIN 0003 "Base Year Program Office Costs (PMO) in accordance with the contract documents" Include labor position titles expected at the PMO office under tab "Base Year PMO Labor CLIN 0003." Values inserted in the "Base Year PMO Labor CLIN 0003" tab will autopopulate into the Cost Breakdown Sheet tab "CB Saudi Personnel Services."

3. For Option CLIN 1002 "Option Year #1 Program Office Costs (PMO) in accordance with the contract documents" Include labor position titles expected at the PMO office under tab "Option Year PMO Labor CLIN 1002." Values inserted in the "Option Year PMO Labor CLIN 1002" tab will autopopulate into the Cost Breakdown Sheet tab "CB Saudi Personnel Services."

CB Saudi Personnel Services

	PRICE BREAKDOWN
	PROJECT: KSA PSC SUPPORT SERVICES										PROPOSER:
	LOCATION: SAUDI ARABIA										DATE:
	ITEM	DESCRIPTION	ESTIMATED TOTAL LABOR MAN-HOURS	DIRECT LABOR COST	DIRECT EQUIPMENT COST	DIRECT MATERIALS COST	SUB CONTRACTOR COST	TOTAL DIRECT COST	JOB OFFICE OVERHEAD	HOME OFFICE OVERHEAD	PROFIT	TOTAL PROPOSED COST	DAILY RATE PER POSITION
	0001	Phase In in accordance with the contract documents	N/A
	0001AA	Phase In in accordance with the contract documents		$ - 0	$ - 0	$ - 0	$ - 0	$ -	$ -	$ -	$ -	$ -
		Total Price CLIN 0001		$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -
	0002	Base Year Support Services in accordance with the contract documents	SEE COMMENT IN CELL
	0002AA	Lead Engineer Assistant (LEA)	2,088					$ -				$ -	$ -
	0002AB	Project Engineer Assistant Sr	2,088					$ -				$ -	$ -
	0002AC	Engineer Tech Asst Sr (Civil, Mech, Elec)	2,088					$ -				$ -	$ -
	0002AD	Engineer Tech Asst Mid (Civil, Mech, Elec)	2,088					$ -				$ -	$ -
	0002AE	Program Manager Sr	2,088					$ -				$ -	$ -
	0002AF	Program Manager Mid	2,088					$ -				$ -	$ -
	0002AG	Quality Assurance Rep Sr	2,088					$ -				$ -	$ -
	0002AH	Quality Assurance Rep Mid	2,088					$ -				$ -	$ -
	0002AJ	Quality Assurance Rep Jr	2,088					$ -				$ -	$ -
	0002AK	Cost Estimator	2,088					$ -				$ -	$ -
	0002AL	Safety Officer	2,088					$ -				$ -	$ -
	0002AM	Administator Assistant	2,088					$ -				$ -	$ -
	0002AN	Translator/Interpreter	2,088					$ -				$ -	$ -
	0002AP	Real Estate Specialist	2,088					$ -				$ -	$ -
	0002AQ	Scheduler	2,088					$ -				$ -	$ -
	0002AR	Administrative Assistant	2,088					$ -				$ -	$ -
	0002AS	Auditor	2,088					$ -				$ -	$ -
		Total Price (Items 0002AA - AS)	35,496	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	0
	0003	Base Year Program Office Costs (PMO) in accordance with the contract documents
	0003AA	Labor*		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	0003AB	Lodging		$ - 0	$ - 0	$ - 0	$ - 0	$ -	$ -	$ -	$ -	$ -
	0003AC	R&R Flights		$ - 0	$ - 0	$ - 0	$ - 0	$ -	$ -	$ -	$ -	$ -
	0003AD	Office Fees		$ - 0	$ - 0	$ - 0	$ - 0	$ -	$ -	$ -	$ -	$ -
	0003AE	Vehicles		$ - 0	$ - 0	$ - 0	$ - 0	$ -	$ -	$ -	$ -	$ -
	0003AF	Office Supplies		$ - 0	$ - 0	$ - 0	$ - 0	$ -	$ -	$ -	$ -	$ -
	0003AG	Other		$ - 0	$ - 0	$ - 0	$ - 0	$ -	$ -	$ -	$ -	$ -
		Total Price (Items 0003AA - AG)	0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	0004	Base Year Travel Costs in accordance with the contract documents (NTE)	.
	0004AA	Travel Costs										$ 225,000
		Total Price CLIN 0004										$ 225,000
	0005	Base Year Per Diem/Mileage Costs in accordance with the contract documents (NTE)
	0005AA	Per Diem/Mileage										$ 125,000
		Total Price CLIN 0005										$ 125,000
	0006	Base Year Contractor Manpower Reporting Costs in accordance with the contract documents
	0006AA	Contractor Manpower Reporting						$ -				$ -
		Total Price CLIN 0006	0	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -
	0007	Phase Out in accordance with the contract documents
	0007AA	Phase Out in accordance with the contract documents	N/A					$ -				$ -
		Total Price CLIN 0007		$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -
	Total Base Yr Bid Price (Items 0001-0007)			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ 350,000.00
	1002	Option Year Support Services in accordance with the contract documents	SEE COMMENT IN CELL
	1002AA	Lead Engineer Assistant (LEA)	2,496					$ -				$ -	$ -
	10022AB	Project Engineer Assistant Sr	2,496					$ -				$ -	$ -
	1002AC	Engineer Tech Asst Sr (Civil, Mech, Elec)	2,496					$ -				$ -	$ -
	1002AD	Engineer Tech Asst Mid (Civil, Mech, Elec)	2,496					$ -				$ -	$ -
	1002AE	Program Manager Sr	2,496					$ -				$ -	$ -
	1002AF	Program Manager Mid	2,496					$ -				$ -	$ -
	1002AG	Quality Assurance Rep Sr	2,496					$ -				$ -	$ -
	1002AH	Quality Assurance Rep Mid	2,496					$ -				$ -	$ -
	1002AJ	Quality Assurance Rep Jr	2,496					$ -				$ -	$ -
	1002AK	Cost Estimator	2,496					$ -				$ -	$ -
	1002AL	Safety Officer	2,496					$ -				$ -	$ -
	1002AM	Administator Assistant	2,496					$ -				$ -	$ -
	1002AN	Translator/Interpreter	2,496					$ -				$ -	$ -
	1002AP	Real Estate Specialist	2,496					$ -				$ -	$ -
	1002AQ	Scheduler	2,496					$ -				$ -	$ -
	1002AR	Administrative Assistant	2,496					$ -				$ -	$ -
	1002AS	Auditor	2,496					$ -				$ -	$ -
		Total Price (Items 1002AA - AS)	42,432	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	0
	1003	Option Year Program Office Costs (PMO) in accordance with the contract documents
	1003AA	Labor*		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	1003AB	Lodging		$ - 0	$ - 0	$ - 0	$ - 0	$ -	$ -	$ -	$ -	$ -
	1003AC	R&R Flights		$ - 0	$ - 0	$ - 0	$ - 0	$ -	$ -	$ -	$ -	$ -
	1003AD	Office Fees		$ - 0	$ - 0	$ - 0	$ - 0	$ -	$ -	$ -	$ -	$ -
	1003AE	Vehicles		$ - 0	$ - 0	$ - 0	$ - 0	$ -	$ -	$ -	$ -	$ -
	1003AF	Office Supplies		$ - 0	$ - 0	$ - 0	$ - 0	$ -	$ -	$ -	$ -	$ -
	1003AG	Other		$ - 0	$ - 0	$ - 0	$ - 0	$ -	$ -	$ -	$ -	$ -
		Total Price (Items 1003AA - AG)	0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	1004	Option Year Travel Costs in accordance with the contract documents (NTE)	.
	1004AA	Travel Costs										$ 250,000
		Total Price CLIN 1004										$ 250,000
	1005	Option Year Per Diem/Mileage Costs in accordance with the contract documents (NTE)
	1005AA	Per Diem/Mileage										$ 150,000
		Total Price CLIN 1005										$ 150,000
	1006	Option Year Contractor Manpower Reporting Costs in accordance with the contract documents
	1006AA	Contractor Manpower Reporting						$ -				$ -
		Total Price CLIN 1006	0	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -
	Total Option Year (CLINS 1002-1006)			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ 400,000.00
	2002	Ext of Services Option Support Services in accordance with the contract documents	SEE COMMENT IN CELL
	2002AA	Lead Engineer Assistant (LEA)	1,248					$ -				$ -	$ -
	2002AB	Project Engineer Assistant Sr	1,248					$ -				$ -	$ -
	2002AV	Engineer Tech Asst Sr (Civil, Mech, Elec)	1,248					$ -				$ -	$ -
	2002AD	Engineer Tech Asst Mid (Civil, Mech, Elec)	1,248					$ -				$ -	$ -
	2002AE	Program Manager Sr	1,248					$ -				$ -	$ -
	2002AF	Program Manager Mid	1,248					$ -				$ -	$ -
	2002AG	Quality Assurance Rep Sr	1,248					$ -				$ -	$ -
	2002AH	Quality Assurance Rep Mid	1,248					$ -				$ -	$ -
	2002AJ	Quality Assurance Rep Jr	1,248					$ -				$ -	$ -
	2002AK	Cost Estimator	1,248					$ -				$ -	$ -
	2002AL	Safety Officer	1,248					$ -				$ -	$ -
	2002AM	Administator Assistant	1,248					$ -				$ -	$ -
	2002AN	Translator/Interpreter	1,248					$ -				$ -	$ -
	2002AP	Real Estate Specialist	1,248					$ -				$ -	$ -
	2002AQ	Scheduler	1,248					$ -				$ -	$ -
	2002AR	Administrative Assistant	1,248					$ -				$ -	$ -
	2002AS	Auditor	1,248					$ -				$ -	$ -
		Total Price (Items 2002AA - AS)	21,216	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	0
	2003	Ext of Services Option Program Office Costs (PMO) in accordance with the contract documents
	2003AA	Labor*		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	2003AB	Lodging		$ - 0	$ - 0	$ - 0	$ - 0	$ -	$ -	$ -	$ -	$ -
	2003AC	R&R Flights		$ - 0	$ - 0	$ - 0	$ - 0	$ -	$ -	$ -	$ -	$ -
	2003aD	Office Fees		$ - 0	$ - 0	$ - 0	$ - 0	$ -	$ -	$ -	$ -	$ -
	2003AE	Vehicles		$ - 0	$ - 0	$ - 0	$ - 0	$ -	$ -	$ -	$ -	$ -
	2003AF	Office Supplies		$ - 0	$ - 0	$ - 0	$ - 0	$ -	$ -	$ -	$ -	$ -
	2003AG	Other		$ - 0	$ - 0	$ - 0	$ - 0	$ -	$ -	$ -	$ -	$ -
		Total Price (Items 2003AA - AG)	0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	2004	Ext of Services Option Travel Costs in accordance with the contract documents (NTE)	.
	2004AA	Travel Costs										$ 125,000
		Total Price CLIN 2004										$ 125,000
	2005	Ext of Services Option Per Diem/Mileage Costs in accordance with the contract documents (NTE)
	0005AA	Per Diem/Mileage										$ 75,000
		Total Price 2005										$ 75,000
	2006	Ext of Services Option Contractor Manpower Reporting Costs in accordance with the contract documents
	2006AA	Contractor Manpower Reporting						$ -				$ -
		Total Price CLIN 2006	0	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -
	Total Ext of Services Option (2002-0006)			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ 200,000.00
	Total Base Yr Bid Price (Items 0001-0007)			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ 350,000.00
	Total Option Yr Bid Price (1002-1006)			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ 400,000.00
	Total Ext of Services (ITEMS 2002 - 2006)			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ 200,000.00
	Total Base Year + all option (ITEMS 0001-0007, 1002-1006 & 2002-2006)			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ 950,000.00
*For Labor at PMO, Include Position Titles In PMO Labor Tabs

Warchola, Deetra C CIV USARMY CETAM (USA):

man hours calculated by 43.5 wks @ 48 hrs/wk Warchola, Deetra C CIV USARMY CETAM (USA):

man hours calculated by 52 wks @ 48 hrs/wk Warchola, Deetra C CIV USARMY CETAM (USA):

man hours calculated by 26 wks @ 48 hrs/wk

Base Year PMO Labor CLIN 0003

ITEM	DESCRIPTION	ESTIMATED TOTAL LABOR MAN-HOURS	DIRECT LABOR COST	DIRECT EQUIPMENT COST	DIRECT MATERIALS COST	SUB CONTRACTOR COST	TOTAL DIRECT COST	JOB OFFICE OVERHEAD	HOME OFFICE OVERHEAD	PROFIT	TOTAL PROPOSED COST	DAILY RATE PER POSITION
0003	Base Year Program Office Costs (PMO) in accordance with the contract documents	1 FTE = 2088 hrs for base year
	List Position Titles at the PMO Below:
Position #1	Program Manager (Expat)		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Position #2	Project Controls (Expat)		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Position #3	Contract Admin (Expat)		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Position #4	Quality Safety Manager (Expat)		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Position #5	Office Admin (LN)		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Position #6	Office Admin (LN)		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Position #7			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Position #8			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Position #9			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0003AA	Labor	0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

Option Year PMO Labor CLIN 1003

ITEM	DESCRIPTION	ESTIMATED TOTAL LABOR MAN-HOURS	DIRECT LABOR COST	DIRECT EQUIPMENT COST	DIRECT MATERIALS COST	SUB CONTRACTOR COST	TOTAL DIRECT COST	JOB OFFICE OVERHEAD	HOME OFFICE OVERHEAD	PROFIT	TOTAL PROPOSED COST	DAILY RATE PER POSITION
1003	Option Year Program Office Costs (PMO) in accordance with the contract documents	1 FTE = 2496 for option Year (52 wks)
	List Position Titles at the PMO Below:
Position #1	Program Manager (Expat)						$ - 0				$ - 0	$ - 0
Position #2	Project Controls (Expat)		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Position #3	Contract Admin (Expat)		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Position #4	Quality Safety Manager (Expat)		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Position #5	Office Admin (LN)		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Position #6	Office Admin (LN)		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Position #7			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Position #8			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Position #9			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
1003AA	Labor	0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

Ext of Srvc PMO Labor CLIN 2003

ITEM	DESCRIPTION	ESTIMATED TOTAL LABOR MAN-HOURS	DIRECT LABOR COST	DIRECT EQUIPMENT COST	DIRECT MATERIALS COST	SUB CONTRACTOR COST	TOTAL DIRECT COST	JOB OFFICE OVERHEAD	HOME OFFICE OVERHEAD	PROFIT	TOTAL PROPOSED COST	DAILY RATE PER POSITION
2003	Ext of Services Program Office Costs (PMO) in accordance with the contract documents	1 FTE = 1248 for option Year (26 wks)
	List Position Titles at the PMO Below:
Position #1	Program Manager (Expat)						$ - 0				$ - 0	$ - 0
Position #2	Project Controls (Expat)		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Position #3	Contract Admin (Expat)		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Position #4	Quality Safety Manager (Expat)		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Position #5	Office Admin (LN)		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Position #6	Office Admin (LN)		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Position #7			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Position #8			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Position #9			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
2003AA	Labor	0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

File details come from the government source that posted it. Updated Aug 15, 2022.