DRAFT - Follow-On AWSM MA IDIQ - CONUS - Attachment 0003 - Zone 1 Pricing Attachment.xlsx

XLSX spreadsheet 44 KB Posted Dec 16, 2024

Attached to: Follow-On Army Watercraft Sustainment Maintenance (AWSM) Program - DRAFT Solicitation - ZONE 1 - CONUS
Solicitation number: W912CH-25-R-0001
Issued by: Department of the Army

About this file

Written by GovTribe AI · Dec 16, 2024

This is a draft pricing template spreadsheet for Zone 1 (CONUS) of the Army Watercraft Sustainment Maintenance (AWSM) Multiple Award IDIQ contract, solicitation number W912CH-25-R-L001. The template requires offerors to input fully burdened labor rates (FBLR) for 17 labor categories including supervisors, machinists, welders, electricians, and other trades across 6 ordering years (5 full years plus 6-month option).

The spreadsheet includes government-provided estimates for material and Other Direct Costs (ODCs) totaling approximately $48.3M across all years, with individual yearly estimates ranging from $3M to $13.5M. Labor hours are pre-populated for each category and year, totaling approximately 528,511 hours in Year 1, with similar levels in most subsequent years. Offerors must propose ceiling rates for indirect costs and profit, as well as escalation factors for labor rates in future ordering years. The template calculates total proposed price based on labor rates, material/ODC costs, and proposed indirect and profit rates.

View the file

Other files

File	Type	Posted
DRAFT - Follow-On AWSM MA IDIQ - CONUS - Section M.docx	DOCX document	Dec 16, 2024
DRAFT - Follow-On AWSM MA IDIQ - CONUS - Section L.docx	DOCX document	Dec 16, 2024
DRAFT - Follow-On AWSM MA IDIQ - CONUS - Attachment 0001 - Army Watercraft Systems.docx	DOCX document	Dec 16, 2024
DRAFT - Follow-On AWSM MA IDIQ - CONUS - Section C.docx	DOCX document	Dec 16, 2024

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.

GFPM Cover

Army Watercraft Sustainment Maintenance (AWSM)

GOVERNMENT FORMAT PRICING MODEL

(GFPM)

SOLICITATION NO. W912CH-25-R-L001

ZONE 1 - CONUS

Offeror:

Cage:

DRAFT

Instructions to Offerors

Solicitation Number: W912CH-24-R-L001 (CONUS)

Attachment: 0003 - Zone 1 Pricing Attachment

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
	This Tab calculates the Total Proposed Price

Hours & Ceiling Rates:
	*No Offeror inputs are required on this tab
	Do not adjust formulas or otherwise manipulate any cells
	This tab applies the Ceiling Fully Burdened Labor Rates proposed by the offeror against the Government provided labor hours to calculate the labor costs for the Total Proposed Price
	These ceiling FBLRs will be incorporated into the contract as ceiling rates for use on future TO’s containing Over and Above CLINS.

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 ceiling FBLR less profit for each labor category.
	The ceiling FBLR less profit is inclusive of all direct labor, subcontract labor, indirect cost, labor uplifts (as applicable).
	Each offeror is required to input its proposed profit ceiling rate.
	Each offeror is required to input its proposed escalation rates
	Ordering Years 2-6 will calculate the Ceiling FBLR based on a calculation of the previous ordering year Ceiling 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 ceilings for 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.

DRAFT

Summary

Solicitation Number: W912CH-24-R-L001 (CONUS)

Attachment: 0003 - Zone 1 Pricing Attachment

Summary - Total Proposed Price

Offeror: 0

Ordering Year	Fully Burdened Labor Cost	Fully Burdened Material/ODCs	Total
Ordering Year 1	$ - 0	$ 13,530,735.69	$ 13,530,735.69
Ordering Year 2	$ - 0	$ 11,268,452.96	$ 11,268,452.96
Ordering Year 3	$ - 0	$ 4,435,851.40	$ 4,435,851.40
Ordering Year 4	$ - 0	$ 8,021,648.90	$ 8,021,648.90
Ordering Year 5	$ - 0	$ 7,977,683.60	$ 7,977,683.60
Ordering Year 6 (6 Month Option)	$ - 0	$ 3,045,325.21	$ 3,045,325.21

Zone 1 Total Proposed Price $ 48,279,697.76

Hours & Ceiling Rates

Solicitation Number: W912CH-24-R-L001 (CONUS)
Attachment: 0003 - Zone 1 Pricing Attachment
Zone 1 Labor Costs
Offeror:	0

Labor Category	Labor Hours	FBLR	Extended Price
Supervisor	5,969.00	$ - 0	$ - 0
Outside Machinist	24,869.00	$ - 0	$ - 0
Inside Machinist	24,869.00	$ - 0	$ - 0
Pipefitter	22,383.00	$ - 0	$ - 0
Shipfitter	19,896.00	$ - 0	$ - 0
Welder	27,130.00	$ - 0	$ - 0
Blaster/Painter	83,934.00	$ - 0	$ - 0
General Laborer	154,362.00	$ - 0	$ - 0
Electrician	23,561.00	$ - 0	$ - 0
Shipboard Electronics Technician	5,117.00	$ - 0	$ - 0
HVAC Technician	2,984.00	$ - 0	$ - 0
Hydraulics Technician	31,211.00	$ - 0	$ - 0
Carpenter	3,220.00	$ - 0	$ - 0
Dockmaster	11,821.00	$ - 0	$ - 0
Rigger	30,536.00	$ - 0	$ - 0
Firewatch	25,508.00	$ - 0	$ - 0
Production Support	31,141.00	$ - 0	$ - 0
Total Ordering Year 1	528,511.00		- 0

Labor Category	Labor Hours	FBLR	Extended Price
Supervisor	5,906.00	$ - 0	$ - 0
Outside Machinist	24,606.00	$ - 0	$ - 0
Inside Machinist	24,606.00	$ - 0	$ - 0
Pipefitter	22,146.00	$ - 0	$ - 0
Shipfitter	19,685.00	$ - 0	$ - 0
Welder	26,843.00	$ - 0	$ - 0
Blaster/Painter	83,046.00	$ - 0	$ - 0
General Laborer	152,729.00	$ - 0	$ - 0
Electrician	23,311.00	$ - 0	$ - 0
Shipboard Electronics Technician	5,063.00	$ - 0	$ - 0
HVAC Technician	2,953.00	$ - 0	$ - 0
Hydraulics Technician	35,433.00	$ - 0	$ - 0
Carpenter	5,715.00	$ - 0	$ - 0
Dockmaster	11,696.00	$ - 0	$ - 0
Rigger	30,212.00	$ - 0	$ - 0
Firewatch	25,238.05	$ - 0	$ - 0
Production Support	30,811.00	$ - 0	$ - 0
Total Ordering Year 2	529,999.05		- 0

Labor Category	Labor Hours	FBLR	Extended Price
Supervisor	4,400.00	$ - 0	$ - 0
Outside Machinist	18,334.00	$ - 0	$ - 0
Inside Machinist	18,334.00	$ - 0	$ - 0
Pipefitter	16,501.00	$ - 0	$ - 0
Shipfitter	14,667.00	$ - 0	$ - 0
Welder	20,001.00	$ - 0	$ - 0
Blaster/Painter	61,877.00	$ - 0	$ - 0
General Laborer	113,798.00	$ - 0	$ - 0
Electrician	17,369.00	$ - 0	$ - 0
Shipboard Electronics Technician	3,773.00	$ - 0	$ - 0
HVAC Technician	2,200.00	$ - 0	$ - 0
Hydraulics Technician	26,401.00	$ - 0	$ - 0
Carpenter	4,258.00	$ - 0	$ - 0
Dockmaster	8,714.00	$ - 0	$ - 0
Rigger	22,511.00	$ - 0	$ - 0
Firewatch	18,804.75	$ - 0	$ - 0
Production Support	22,957.00	$ - 0	$ - 0
Total Ordering Year 3	394,899.75		- 0

Labor Category	Labor Hours	FBLR	Extended Price
Supervisor	6,327.00	$ - 0	$ - 0
Outside Machinist	26,363.00	$ - 0	$ - 0
Inside Machinist	26,363.00	$ - 0	$ - 0
Pipefitter	23,727.00	$ - 0	$ - 0
Shipfitter	21,091.00	$ - 0	$ - 0
Welder	28,760.00	$ - 0	$ - 0
Blaster/Painter	88,976.00	$ - 0	$ - 0
General Laborer	163,635.00	$ - 0	$ - 0
Electrician	24,976.00	$ - 0	$ - 0
Shipboard Electronics Technician	5,425.00	$ - 0	$ - 0
HVAC Technician	3,164.00	$ - 0	$ - 0
Hydraulics Technician	37,963.00	$ - 0	$ - 0
Carpenter	5,276.00	$ - 0	$ - 0
Dockmaster	12,321.00	$ - 0	$ - 0
Rigger	32,370.00	$ - 0	$ - 0
Firewatch	27,040.00	$ - 0	$ - 0
Production Support	33,011.00	$ - 0	$ - 0
Total Ordering Year 4	566,788.00		- 0

Labor Category	Labor Hours	FBLR	Extended Price
Supervisor	5,969.00	$ - 0	$ - 0
Outside Machinist	24,869.00	$ - 0	$ - 0
Inside Machinist	24,869.00	$ - 0	$ - 0
Pipefitter	22,383.00	$ - 0	$ - 0
Shipfitter	19,896.00	$ - 0	$ - 0
Welder	27,130.00	$ - 0	$ - 0
Blaster/Painter	83,934.00	$ - 0	$ - 0
General Laborer	154,362.00	$ - 0	$ - 0
Electrician	23,561.00	$ - 0	$ - 0
Shipboard Electronics Technician	5,117.00	$ - 0	$ - 0
HVAC Technician	2,984.00	$ - 0	$ - 0
Hydraulics Technician	31,211.00	$ - 0	$ - 0
Carpenter	3,220.00	$ - 0	$ - 0
Dockmaster	11,821.00	$ - 0	$ - 0
Rigger	30,536.00	$ - 0	$ - 0
Firewatch	25,508.00	$ - 0	$ - 0
Production Support	31,141.00	$ - 0	$ - 0
Total Ordering Year 5	528,511.00		- 0

Labor Category	Labor Hours	FBLR	Extended Price
Supervisor	3,016.60	$ - 0	$ - 0
Outside Machinist	12,568.80	$ - 0	$ - 0
Inside Machinist	12,568.80	$ - 0	$ - 0
Pipefitter	11,312.10	$ - 0	$ - 0
Shipfitter	10,055.20	$ - 0	$ - 0
Welder	13,711.50	$ - 0	$ - 0
Blaster/Painter	42,419.90	$ - 0	$ - 0
General Laborer	78,014.00	$ - 0	$ - 0
Electrician	11,907.00	$ - 0	$ - 0
Shipboard Electronics Technician	2,586.00	$ - 0	$ - 0
HVAC Technician	1,508.30	$ - 0	$ - 0
Hydraulics Technician	18,099.20	$ - 0	$ - 0
Carpenter	2,919.20	$ - 0	$ - 0
Dockmaster	5,974.20	$ - 0	$ - 0
Rigger	15,432.50	$ - 0	$ - 0
Firewatch	12,891.50	$ - 0	$ - 0
Production Support	15,738.30	$ - 0	$ - 0
Total Ordering Year 6 (6 Month Option)	270,723.10		- 0

Labor Rate Input

Solicitation Number: W912CH-24-R-L001 (CONUS)
Attachment: 0003 - Zone 1 Pricing Attachment
Fully Burdened Labor Rates (FBLR)
Offeror:	0

		Profit Ceiling Rate
Labor Category		Escalation
	OY 1	OY 1	OY 2	OY 3	OY 4	OY 5	OY 6 (6 Month Option)
	FBLR Less Profit	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	$ - 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

DRAFT

Mat + ODC

Solicitation Number: W912CH-24-R-L001 (CONUS)
Attachment: 0003 - Zone 1 Pricing Attachment
Zone 1 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/ODC Cost Estimate	Government Provided
Material/ODC Cost Estimate	Government Provided
Material/ODC Cost Estimate	Government Provided
Material/ODC Cost Estimate	Government Provided
Material/ODC Cost Estimate	Government Provided

Material/ODC Cost Estimate $ 13,530,735.69 $ 11,268,452.96 $ 4,435,851.40 $ 8,021,648.90 $ 7,977,683.60 $ 3,045,325.21

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

Profit	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Total Material Cost by Year	$ 13,530,735.69	$ 11,268,452.96	$ 4,435,851.40	$ 8,021,648.90	$ 7,977,683.60	$ 3,045,325.21

Indirect Ceiling Rate

Profit Ceiling Rate

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