Attachment 0003 _Zone 2_Pricing Attachment.XLSX

XLSX spreadsheet 1 MB Posted Mar 12, 2020

Attached to: AWSM Zone 2 Solicitation - Amendment 0004 Federal contract opportunity
Solicitation number: W56HZV-20-R-L806
Issued by: Department of the Army Materiel Command TACOM Life Cycle Management Command

About this file

Written by GovTribe AI · Dec 29, 2023

This document contains a pricing model template for a federal solicitation seeking maintenance services on U.S. Army vessels in Zone 2 outside the continental United States. The Army Contracting Command - Detroit Arsenal issues Request for Proposal number W56HZV-20-R-L806 to provide modifications, modernizations, and on-condition cyclic maintenance for the Army watercraft fleet. The pricing model requires offerors to input fully burdened labor rates by labor category for the base year and five option years, with escalation rates for future years, as well as proposed overhead and profit rates to apply to a government-provided material cost estimate. Labor hours by category are provided to calculate extended prices. The total evaluated price will be used for evaluation.

View the file

Other files for this federal contract opportunity

Other files attached to AWSM Zone 2 Solicitation - Amendment 0004, newest first.
File	Type	Posted
W56HZV-20-R-L806 Amd 0004 Conformed.pdf	PDF	May 13, 2020
SF 30 W56HZV-20-R-L806 Amd 0004.pdf	PDF	May 13, 2020
Attachment 0003 _Zone 2_Pricing Attachment Rev 01.xlsx	XLSX spreadsheet	May 13, 2020
W56HZV-20-R-L806 Amd 0003 Conformed.pdf	PDF	May 5, 2020
SF 30 W56HZV-20-R-L806 Amd 0003.pdf	PDF	May 5, 2020
SF 30 W56HZV-20-R-L806 Amd 0001.pdf	PDF	Apr 23, 2020
SF 30 W56HZV-20-R-L806 Amd 0002.pdf	PDF	Apr 23, 2020
W56HZV-20-R-L806 Amd 0002 Conformed.pdf	PDF	Apr 23, 2020
Attachment 0002 Past Performance Questionnaire rev 01.docx	DOCX document	Mar 27, 2020
Attachment 0001 Army Watercraft System- Rev 01.pdf	PDF	Mar 27, 2020
Amendment 0001 Zone 2 Conformed.pdf	PDF	Mar 27, 2020
Attachment 0001 Army Vessel Fleet.pdf	PDF	Mar 12, 2020
Attachment 0007 SBP-Certification-Subcontractor.docx	DOCX document	Mar 12, 2020
Exhibit A- AWSM CDRLS.pdf	PDF	Mar 12, 2020
Attachment 0006 SBP-WorkbookInstructions (27 Mar 2019).pdf	PDF	Mar 12, 2020
Attachment 0005 SBP-Workbook (27 Mar 2019).xlsx	XLSX spreadsheet	Mar 12, 2020
Attachment 0002 Past Performance Questionnaire.docx	DOCX document	Mar 12, 2020
W56HZV-20-R-L806-Zone 2 OCONUS RFP.pdf	PDF	Mar 12, 2020
Attachment 0004 - Use of Existing Government-Furnished Property (002).xlsx	XLSX spreadsheet	Mar 12, 2020

Show all 19

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.

GFPM Cover

GOVERNMENT FORMAT PRICING MODEL

(GFPM)

SOLICITATION NO. W56HZV-20-R-806

ZONE 2 - OCONUS

Offeror:

Cage:

Instruction to Offerors

Solicitation W56HZV-20-R-L806 (OCONUS)

Attachment 0003 - GFPM Zone 2

INSTRUCTION TO OFFERORS

GFPM COVER:
	Cells that require inputs are highlighted in Yellow
	Each offeror is required to input its legal business entity name and Cage Code

INSTRUCTION TO OFFERORS:
	*No Offeror inputs are required on this tab
	Each Offeror is required to read the Instruction to Offerors

SUMMARY:
	*No Offeror inputs are required on this tab
	Do not adjust formulas or otherwise manipulate any of the non yellow cells
	The Tab calculates the Total Evaluated Price

Hours & Ceiling Rates:
	*No Offeror inputs are required on this tab
	Do not adjust formulas or otherwise manipulate any of the non yellow cells
	This tab applies the Fully Burdened Labor Rates proposed by the offeror against the Government provided labor hours to calculate the labor costs for the Total Evaluated Price
	This tab calculates the time and materials composite ceiling labor rate by dividing the total labor dollars by total labor hours
	These time and material composite contract ceiling labor rates will be incorporated to the MA IDIQ resultant contract via attachment.

Labor Rate Input:
	Cells that require inputs are highlighted in Yellow
	Do not adjust formulas or otherwise manipulate any of the non yellow cells
	Each offeror is required to input its Fully Burdened Labor Rate (FBLR) for each labor category
	The FBLR is inclusive of all direct labor, subcontract labor, indirect cost, labor uplifts (as applicable), and profit.
	Each offeror is required to input its proposed escalation rates
	Ordering Years 2-6 will calculate the FBLR based on a calculation of the previous ordering year FBLR and the proposed escalation factor
	The escalation factor is intended to capture costs associated with increases in wages and industry inflation

If the offer has determined that labor costs in future periods will decrease the offeror may input 0% or a negative percentage.

Mat+ODC:
	Cells that require inputs are highlighted in Yellow
	Do not adjust formulas or otherwise manipulate any of the non yellow cells
	For evaluation purposes only, the Government has provided an estimated cost for direct material and ODCs
	Each Offeror is required to input proposed ceiling Indirect Cost and Profit rates
	The proposed indirect ceiling cost rate will be applied to the Government provided material estimate which calculates total indirect costs by year.
	The proposed profit ceiling rate will be applied to both, the Government provided material estimate and the proposed indirect cost dollars to calculate total profit by year.

Summary

Solicitation W56HZV-20-R-L806 (OCONUS)

Attachment 0003 - GFPM Zone 2

Summary - Total Evaluated Price

Offeror: 0

Ordering Year	Fully Burdened Labor Cost	Fully Burdened Material/ODCs	Total
Ordering Year 1	- 0	$ 4,799,727.19	$ 4,799,727.19
Ordering Year 2	$ - 0	$ 4,408,668.68	$ 4,408,668.68
Ordering Year 3	$ - 0	$ 5,222,835.79	$ 5,222,835.79
Ordering Year 4	$ - 0	$ 3,546,802.90	$ 3,546,802.90
Ordering Year 5	$ - 0	$ 1,103,887.57	$ 1,103,887.57
Ordering Year 6 (6 Month Option)	$ - 0	$ 1,908,192.00	$ 1,908,192.00

Zone 2 Total Evaluated Price $ 20,990,114.13

Hours & Ceiling Rates

Solicitation W56HZV-20-R-L806 (OCONUS)
Attachment 0003 - GFPM Zone 2
Zone 2 Labor Costs
Offeror:	0
	Labor Category	Labor Hours	FBLR	Extended Price	Time and Materials Composite Labor Rates
	Supervisor	2,257	$ - 0	$ - 0
	Outside Machinist	9,402	$ - 0	$ - 0
	Inside Machinist	9,402	$ - 0	$ - 0
	Pipefitter	8,462	$ - 0	$ - 0
	Shipfitter	7,522	$ - 0	$ - 0
	Welder	10,257	$ - 0	$ - 0
	Blaster/Painter	31,732	$ - 0	$ - 0
	General Laborer	58,359	$ - 0	$ - 0
	Electrician	8,907	$ - 0	$ - 0
	Shipboard Electronics Technician	1,935	$ - 0	$ - 0
	HVAC Technician	1,128	$ - 0	$ - 0
	Hydraulics Technician	13,539	$ - 0	$ - 0
	Carpenter	2,184	$ - 0	$ - 0
	Dockmaster	4,469	$ - 0	$ - 0
	Rigger	11,544	$ - 0	$ - 0
	Firewatch	9,644	$ - 0	$ - 0
	Production Support	11,773	$ - 0	$ - 0
	Total Ordering Year 1 Labor	202,516		- 0	$ - 0	Contract Ceiling Rate for Year 1
	Labor Category	Labor Hours	FBLR	Extended Price
	Supervisor	2,032	$ - 0	$ - 0
	Outside Machinist	8,467	$ - 0	$ - 0
	Inside Machinist	8,467	$ - 0	$ - 0
	Pipefitter	7,620	$ - 0	$ - 0
	Shipfitter	6,773	$ - 0	$ - 0
	Welder	9,237	$ - 0	$ - 0
	Blaster/Painter	28,576	$ - 0	$ - 0
	General Laborer	52,553	$ - 0	$ - 0
	Electrician	8,021	$ - 0	$ - 0
	Shipboard Electronics Technician	1,742	$ - 0	$ - 0
	HVAC Technician	1,016	$ - 0	$ - 0
	Hydraulics Technician	12,192	$ - 0	$ - 0
	Carpenter	1,966	$ - 0	$ - 0
	Dockmaster	4,024	$ - 0	$ - 0
	Rigger	10,396	$ - 0	$ - 0
	Firewatch	8,684	$ - 0	$ - 0
	Production Support	10,602	$ - 0	$ - 0
	Total Ordering Year 2	182,368		- 0	$ - 0	Contract Ceiling Rate for Year 2

Labor Category	Labor Hours	FBLR	Extended Price
Supervisor	2,497	$ - 0	$ - 0
Outside Machinist	10,402	$ - 0	$ - 0
Inside Machinist	10,402	$ - 0	$ - 0
Pipefitter	9,362	$ - 0	$ - 0
Shipfitter	8,322	$ - 0	$ - 0
Welder	11,348	$ - 0	$ - 0
Blaster/Painter	35,108	$ - 0	$ - 0
General Laborer	64,567	$ - 0	$ - 0
Electrician	9,855	$ - 0	$ - 0
Shipboard Electronics Technician	2,141	$ - 0	$ - 0
HVAC Technician	1,248	$ - 0	$ - 0
Hydraulics Technician	14,980	$ - 0	$ - 0
Carpenter	2,416	$ - 0	$ - 0
Dockmaster	4,944	$ - 0	$ - 0
Rigger	12,772	$ - 0	$ - 0
Firewatch	10,670	$ - 0	$ - 0
Production Support	13,026	$ - 0	$ - 0
Total Ordering Year 3	224,060		- 0	$ - 0	Contract Ceiling Rate for Year 3

Labor Category	Labor Hours	FBLR	Extended Price
Supervisor	2,314	$ - 0	$ - 0
Outside Machinist	9,641	$ - 0	$ - 0
Inside Machinist	9,641	$ - 0	$ - 0
Pipefitter	8,677	$ - 0	$ - 0
Shipfitter	7,713	$ - 0	$ - 0
Welder	10,517	$ - 0	$ - 0
Blaster/Painter	32,538	$ - 0	$ - 0
General Laborer	59,840	$ - 0	$ - 0
Electrician	9,134	$ - 0	$ - 0
Shipboard Electronics Technician	1,984	$ - 0	$ - 0
HVAC Technician	1,157	$ - 0	$ - 0
Hydraulics Technician	13,883	$ - 0	$ - 0
Carpenter	2,239	$ - 0	$ - 0
Dockmaster	4,582	$ - 0	$ - 0
Rigger	11,837	$ - 0	$ - 0
Firewatch	9,888	$ - 0	$ - 0
Production Support	12,072	$ - 0	$ - 0
Total Ordering Year 4	207,657		- 0	$ - 0	Contract Ceiling Rate for Year 4

Labor Category	Labor Hours	FBLR	Extended Price
Supervisor	2,020	$ - 0	$ - 0
Outside Machinist	8,416	$ - 0	$ - 0
Inside Machinist	8,416	$ - 0	$ - 0
Pipefitter	7,575	$ - 0	$ - 0
Shipfitter	6,733	$ - 0	$ - 0
Welder	9,182	$ - 0	$ - 0
Blaster/Painter	28,406	$ - 0	$ - 0
General Laborer	52,240	$ - 0	$ - 0
Electrician	7,973	$ - 0	$ - 0
Shipboard Electronics Technician	1,732	$ - 0	$ - 0
HVAC Technician	1,010	$ - 0	$ - 0
Hydraulics Technician	12,120	$ - 0	$ - 0
Carpenter	1,955	$ - 0	$ - 0
Dockmaster	4,000	$ - 0	$ - 0
Rigger	10,334	$ - 0	$ - 0
Firewatch	8,633	$ - 0	$ - 0
Production Support	10,539	$ - 0	$ - 0
Total Ordering Year 5	181,284		- 0	$ - 0	Contract Ceiling Rate for Year 5
Labor Category	Labor Hours	FBLR	Extended Price
Supervisor	1,112.00	$ - 0	$ - 0
Outside Machinist	4,633.00	$ - 0	$ - 0
Inside Machinist	4,633.00	$ - 0	$ - 0
Pipefitter	4,170.00	$ - 0	$ - 0
Shipfitter	3,706.00	$ - 0	$ - 0
Welder	5,041.00	$ - 0	$ - 0
Blaster/Painter	15,636.00	$ - 0	$ - 0
General Laborer	28,756.00	$ - 0	$ - 0
Electrician	4,389.00	$ - 0	$ - 0
Shipboard Electronics Technician	954.00	$ - 0	$ - 0
HVAC Technician	556.00	$ - 0	$ - 0
Hydraulics Technician	6,671.00	$ - 0	$ - 0
Carpenter	1,076.00	$ - 0	$ - 0
Dockmaster	2,202.00	$ - 0	$ - 0
Rigger	5,688.00	$ - 0	$ - 0
Firewatch	4,751.83	$ - 0	$ - 0
Production Support	5,801.00	$ - 0	$ - 0
Total Ordering Year 6 (6 Month Option)	99,776		- 0	$ - 0	Contract Ceiling Rate for Year 6
					(6 Month Option)

Labor Rate Input

Solicitation W56HZV-20-R-L806 (OCONUS)
Attachment 0003 - GFPM Zone 2
Fully Burdened Labor Rates
Offeror:	0
	Labor Category	Escalation
		OY 1	OY 2	OY 3	OY 4	OY 5	OY 6 (6 Month Option
		FBLR	FBLR	FBLR	FBLR	FBLR	FBLR
	Supervisor	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Outside Machinist	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Inside Machinist	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Pipefitter	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Shipfitter	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Welder		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Blaster/Painter	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	General Laborer	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Electrician	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Shipboard Electronics Technician	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	HVAC Technician	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Hydraulics Technician	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Carpenter	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Dockmaster	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Rigger	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Firewatch	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Production Support	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		.

Mat+ODC

Solicitation W56HZV-20-R-L806 (OCONUS)
Attachment 0003 - GFPM Zone 2
Zone 2 Fully Burdened Material & ODC
Offeror:	0

		Material & Other Direct Costs (ODC)	OY 1	OY 2	OY 3	OY 4	OY 5	OY 6 (6 Month Option)
			Government Provided
Material Cost Estimate	Government Provided
Material Cost Estimate	Government Provided
Material Cost Estimate	Government Provided
Material Cost Estimate	Government Provided
Material Cost Estimate	Government Provided

Material Cost Estimate $ 4,799,727.19 $ 4,408,668.68 $ 5,222,835.79 $ 3,546,802.90 $ 1,103,887.57 $ 1,908,192.00

Indirect Cost $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Profit	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Total Material Cost by Year	$ 4,799,727.19	$ 4,408,668.68	$ 5,222,835.79	$ 3,546,802.90	$ 1,103,887.57	$ 1,908,192.00

Overhead Ceiling Rate

Profit Ceiling Rate

2 2 2 2 2 2 image1.png

File details come from the government source that posted it. Updated Mar 12, 2020.