5L3. Section L Attachment L3 Pricing Workbook.xlsx

XLSX spreadsheet 70 KB Posted Jul 17, 2020

Attached to: AN/TMQ-53 Tactical Meteorological Observing System (TMOS), Contractor Logistics Support (CLS) effort
Solicitation number: FA8730-20-R-0050
Issued by: Department of the Air Force Materiel Command Lifecycle Management Center Hanscom Air Force Base

About this file

Written by GovTribe AI · Dec 30, 2023

This request for proposal solicits proposals for contractor logistics support of the AN/TMQ-53 Tactical Meteorological Observing System. The Air Force Life Cycle Management Center seeks proposals by August 17, 2020 to provide a five-year base ordering period and one-year option for contractor logistics support of 225 systems. Support includes maintenance, repairs, engineering, and management. Pricing is requested on a firm fixed-price basis for transition phases, contractor logistics support by year and quantity, spare parts by part number, and labor rates by category. The solicitation is set aside for small businesses with a size standard of $16.5 million in annual receipts performing professional, scientific, and technical services. The resulting contract will have ordering periods of five years base with a one-year option and a six-month option to extend performance only.

View the file

Other files

File	Type	Posted
AMD 4 - TMQ 53 CLS Offeror Pre-bid Question Responses.pdf	PDF	Aug 14, 2020
5L3. Section L Attachment L3 Pricing Workbook (V2).xlsx	XLSX spreadsheet	Aug 14, 2020
AMD 3 - TMQ 53 CLS Offeror Pre-bid Question Responses.pdf	PDF	Aug 13, 2020
AMD 2 - TMQ 53 CLS Offeror Pre-bid Question Responses (Package).pdf	PDF	Aug 10, 2020
AMD 1 - TMQ 53 CLS Offeror Pre-bid Question Responses_1.pdf	PDF	Aug 3, 2020
2. TMOS Technical Requirements Document (TRD).pdf	PDF	Jul 17, 2020
7. TMOS CLS Quality Assurance Surveillance Plan (QASP).pdf	PDF	Jul 17, 2020
5. TMOS CLS Section L-Instructions to Offerors.pdf	PDF	Jul 17, 2020
1. Model K Contract TMQ-53 CLS.pdf	PDF	Jul 17, 2020
5L1. TMOS CLS Solicitation Section L Attachment L1 Cross Reference Matrix_Baseline.pdf	PDF	Jul 17, 2020
5L2. TMOS CLS Solicitation Section L Attachment L2 Roles and Responsibilities Wksht_Baseline.pdf	PDF	Jul 17, 2020
-RFP Cover Letter TMOS CLS Recompete.pdf	PDF	Jul 17, 2020
3. TMQ53 CLS PWS-RFP.pdf	PDF	Jul 17, 2020
8. GFP Inventory.xlsx	XLSX spreadsheet	Jul 17, 2020
6. TMOS CLS Section M- Evaluation Factors For Award.pdf	PDF	Jul 17, 2020
4. TMOS CLS CDRL Package (Exhibit A).pdf	PDF	Jul 17, 2020

Show all 16

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

Section L, Attachment L3 Pricing Workbook Instructions

The contractor shall only fill in the highlighted cells and not make any changes to any non-highlighted cells. All prices shall be proposed as firm fixed-price (FFP). All Best Estimated Quantities (BEQs) provided in these sheets are for evaluation purposes only; the Government is not bound to purchase these amounts.

CLIN 0001 - The contractor shall fill in the overall price for the Transition Phase-In effort, inclusive of all labor, material, indirect rates, profit, and any other costs necessary to perform the requirements of this CLIN, as stated in the PWS in Section 5.1.

CLIN 0002 - The contractor shall fill in the overall price for the Transition Phase-Out effort, inclusive of all labor, material, indirect rates, profit, and any other costs necessary to perform the requirements of this CLIN, as stated in the PWS in Section 5.2.

CLIN 0003 - The contractor does not need to fill in the price for this effort, as the Government will use a "plug number" for calculating the TEP for the proposal. This plug number will be for evaluation purposes only. The amount used for the plug number is $1.682M.

CLIN 0004 - The contractor shall fill in the Unit Price for performing CLS per system per month for each fiscal year and quantity (i.e. $10,000 for the first system in FY21, $500 for systems 2-100 in FY21, $11,000 for the first system in FY22, $600 for systems 2-100 in FY22, etc.) listed, inclusive of all labor, material, indirect rates, profit, and any other costs necessary to perform the requirements of this CLIN, as stated in the PWS in Sections 6, 7, 8, 9, and 10.

CLIN 0005 - The contractor shall fill in the Unit Price for the Spares/Repairs Part listed, inclusive of all labor, material, indirect rates, profit, and any other costs necessary to provide the spare/repaired parts to the Spares/Repairs Inventory, as stated in the PWS in Section 7. Data is based on historical usage per year, multiplied by number of months for that financial year divided by twelve months then rounded up, and then multiplied by 225 systems for this upcoming contract period and then divided by 346 for the previous contract period, and then rounded up.

CLIN 0006 - The contractor shall fill in the Rate for each labor category identified, inclusive of all indirect rates and profit necessary to perform the requirements of the CLIN, as stated in the PWS in Section 8.

CLIN 0007 - The contractor does not need to fill in the price for this effort, since this CLIN is Not Separately Priced (NSP) it will not be included in the TEP.

CLIN 0008 - The contractor does not need to fill in the price for this effort, as the Government will use a "plug number" for calculating the TEP for the proposal. This plug number will be for evaluation purposes only. The amount used for the plug number is $1.682M.

CLIN 0009 - The contractor shall fill in the Unit Price for performing CLS per system per month for each quantity (i.e. $10,000 for the first system, $500 for systems 2-100, etc.) listed, inclusive of all labor, material, indirect rates, profit, and any other costs necessary to perform the requirements of this CLIN, as stated in the PWS in Sections 6, 7, 8, 9, and 10.

CLINS 0001, 0002, & 0004

CLIN 0001 Transition Phase-In
Unit	Quantity	Price
Lot	1	$

CLIN 0002 Transition Phase-Out
Unit	Quantity	Price
Lot	1	$

CLIN 0004 CLS
YEAR	UNIT	QUANTITY (MONTHS)	QUANTITY (SYSTEMS)	UNIT PRICE PER QUANTITY (1)	UNIT PRICE PER QUANTITY (2-100)	UNIT PRICE PER QUANTITY (101-200)	UNIT PRICE PER QUANTITY (201-300)	UNIT PRICE PER QUANTITY (301 OR GREATER)	TOTAL
FY21	Month	10	225	$	$	$	$	$	$
FY22	Month	12	225	$	$	$	$	$	$
FY23	Month	12	225	$	$	$	$	$	$
FY24	Month	12	225	$	$	$	$	$	$
FY25	Month	12	225	$	$	$	$	$	$
FY26	Month	2	225	$	$	$	$	$	$
CLIN Total

CLIN 0005 Spares Repairs

CLIN 0005 Spares
		FY21			FY22			FY23			FY24			FY25			FY26
Part Number	Part Name	BEQ	Unit Price	Total	BEQ	Unit Price	Total	BEQ	Unit Price	Total	BEQ	Unit Price	Total	BEQ	Unit Price	Total	BEQ	Unit Price	Total	TOTAL
TMQ-53
4017	Back-up Battery for QMP201	14			16			16			16			16			3
16139	QMP202 Case Key	7			8			8			8			8			2
19558	Velcro Belts (Set of 10ea)	29			34			34			34			34			6
25925	Allen Wrench - 4mm	12			14			14			14			14			3
25926	Sledge Hammer	6			6			6			6			6			2
26222	International Adapter Kit	12			14			14			14			14			3
26271	Stubby Common Screwdriver - 5.5mm	10			11			11			11			11			2
A3LA-R	Iridium Modem	13			15			15			15			15			3
AC4pk	Iridium A/C Adapter Kit	7			8			8			8			8			2
ASM210283	QPD Mounting Bracket	19			23			23			23			23			4
AT-30023	UHF Whip Antenna (410-470)	26			30			30			30			30			6
AT-30028	VHF Whip Antenna (138-175)	12			14			14			14			14			3
AW100Af	VHF Modem (138-174 MHz)	23			28			28			28			28			5
AW400Af	UHF Modem (410-470 MHz)	28			33			33			33			33			6
CBL210103-5MA	QPD 120 VAC U.S. Mains Input Cable	6			7			7			7			7			2
CBL210104-5MA	QPD Output Cable	9			10			10			10			10			2
CBL210127-A	QPD Grounding Cable	7			8			8			8			8			2
CF-311TO35VM	Toughbook Computer	11			13			13			13			13			3
CF-AA1653AM	COMPUTER POWER SUPPLY	68			81			81			81			81			14
CF-K31HD5032	CF-31 Hard Disk Drive	32			38			38			38			38			7
CL31M	Ceilometer CL31M	18			21			21			21			21			4
CM-00212	Radio TMOS Cable	21			25			25			25			25			5
CM-00213	Radio Modem PC Cable	20			24			24			24			24			4
CM-10008	Programming Radio Modem Cable	17			19			19			19			19			4
CT25KAM	Ceilometer CT25KM	33			39			39			39			39			7
CT45298	DC Data Cable-CT25KAM	17			19			19			19			19			4
CT45300	Cable-CT25KAM, AC Power	10			11			11			11			11			2
HMP155	Probe,Temp/RH	34			40			40			40			40			8
HRC-24-7XA	IRIDIUM POWER SUPPLY	34			40			40			40			40			8
LMR400-50	Iridium Antenna Cable	17			21			21			21			21			4
MC-2 (19772)	Compass	10			12			12			12			12			2
PT-10003	RF Antenna Cable	40			47			47			47			47			8
PT-10008	PC Tripod Antenna Holder	30			35			35			35			35			6
PWD11A	Present Weather Detector-11A	14			16			16			16			16			3
PWD22M	Present Weather Detector-22M	56			67			67			67			67			12
QM30154-MEKASP	Telescopic Wind Mast	20			24			24			24			24			4
QM30176	Tripod, PC Antenna	12			14			14			14			14			3
QM30185	Tripod Antenna Arm - UHF	20			23			23			23			23			4
QM40142	Ground Pegs for CT25KAM	6			7			7			7			7			2
QM40287	Grounding Net & Pegs	20			24			24			24			24			4
QMA102M	Sensor Arm	47			56			56			56			56			10
QMASSY201M	Tripod, Processor	28			33			33			33			33			6
QMD102M	Handheld display	14			17			17			17			17			4
QML201T	Data Logger (Viasala NSN)	25			29			29			29			29			6
QMP202	Power Supply, Enhancement	14			16			16			16			16			3
QMP211US	Modem & HHD Power Supply	19			23			23			23			23			4
QMY103M	Ground Peg and Foot Pad, Tripod	8			9			9			9			9			2
QPD101	Power Distribution Unit	22			26			26			26			26			5
QPS102	Indoor Power Strip	23			28			28			28			28			5
QTR101SP	Case, Meteorological Equipment	4			5			5			5			5			2
QTR102SP	Case, Meteorological Equipment	23			28			28			28			28			5
QTR103SP	Case, Meteorological Equipment	4			4			4			4			4			1
QTR104SP	Case, Meteorological Equipment	18			21			21			21			21			4
QTR105SP	Case, Meteorological Equipment	10			12			12			12			12			2
SA20M	Lightning Detector	47			56			56			56			56			10
SAF5350-C	Iridium Antenna	13			15			15			15			15			3
SAT111	Tripod, SA20M	10			12			12			12			12			2
SDFP44	Iridium screwdriver	13			15			15			15			15			3
SYN-MNT-ANT	Iridium Antenna Tripod	13			15			15			15			15			3
TMOS-SAK	Support Arm Kit	9			10			10			10			10			2
TMOS-TMK	Tripod Maintenance Kit	8			10			10			10			10			2
USB-SER	USB to Serial converter cable	33			39			39			39			39			7
VSG76756	Allen Wrench - 3mm	14			15			15			15			15			3
YUBIKEY	YubiKey FIPS 140-2 USB-A (Non-nano)	21			25			25			25			25			5
WMS302M	Wind Speed/Direction Sensor	131			156			156			156			156			27
ZZ45113	Wind Sensor Cable	86			103			103			103			103			18
ZZ45114	Cable, Landline	28			33			33			33			33			6
ZZ45121-IP67	Cable, Enhancement Mains Input	5			6			6			6			6			2
ZZ45123	Cable, Enhancement Data	15			17			17			17			17			4
ZZ45202	Cable, PC/Handheld Data	14			16			16			16			16			3
ZZ45215	SA20M Data Cable	15			17			17			17			17			4

TOTAL

CLIN 0005 Repairs
		FY21			FY22			FY23			FY24			FY25			FY26
Part Number	Part Name	BEQ	Unit Price	Total	BEQ	Unit Price	Total	BEQ	Unit Price	Total	BEQ	Unit Price	Total	BEQ	Unit Price	Total	BEQ	Unit Price	Total	TOTAL
TMQ-53
A3LA-X or A3LA-R	IRIDIUM MODEM	5			6			4			4			6			2
AW100AF	VHF MODEM	2			2			2			2			2			1
AW400AF	UHF MODEM	19			22			15			15			22			4
CF30/31 or Equiv	LAPTOP	3			3			2			2			3			1
CL31 or CT25KAM	CEILOMETER	18			21			14			14			21			4
PWDXXX	PRESENT WEATHER DETECTOR	28			33			22			22			33			6
QMA102M	SENSOR ARM	17			19			13			13			19			4
QMASSY201M	TRIPOD, PROCESSOR	43			52			34			34			52			10
QMD102M	HANDHELD DISPLAY	8			9			6			6			9			2
QML201T	DATA LOGGER	10			12			8			8			12			2
QMP202	POWER SUPPLY, ENHANCEMENT	27			31			21			21			31			6
QPD101M	POWER DISTRIBUTION UNIT (PDU)	8			9			6			6			9			2
SA20M-MT	LIGHTNING DETECTOR	14			17			12			12			17			4
WMS302M	WINDSPEED/DIRECTION SENSOR	43			52			34			34			52			10
QTR101	TRANSIT CASE, BASIC SENSOR	8			10			10			10			10			2
QTR102	TRANSIT CASE, BASIC TRIPOD	8			10			10			10			10			2
QTR103	TRANSIT CASE, SPARES AND TOOL KIT	8			10			10			10			10			2
QTR104	TRANSIT CASE, CELIOMETER	8			10			10			10			10			2
QTR105	TRANSIT CASE, ENAHNCED POWER SUPPLY	8			10			10			10			10			2

TOTAL

CLIN 0006 Systems Engineering

CLIN 0006 Systems Engineering
	FY21			FY22			FY23			FY24			FY25			FY26
Labor Category	Rate	BEQ Hrs	Total	Rate	BEQ Hrs	Total	Rate	BEQ Hrs	Total	Rate	BEQ Hrs	Total	Rate	BEQ Hrs	Total	Rate	BEQ Hrs	Total	TOTAL
Program Manager	$	154	$	$	185	$	$	185	$	$	185	$	$	185	$	$	30	$
Configuration manager	$	70	$	$	84	$	$	84	$	$	84	$	$	84	$	$	14	$
Logistics Support Manager	$	0	$	$	0	$	$	0	$	$	0	$	$	0	$	$	0	$
Systems Engineer	$	489	$	$	587	$	$	587	$	$	587	$	$	587	$	$	96	$
Hardware Engineer	$	0	$	$	0	$	$	0	$	$	0	$	$	0	$	$	0	$
Senior Software Engineer	$	0	$	$	0	$	$	0	$	$	0	$	$	0	$	$	0	$
Software Engineer	$	0	$	$	0	$	$	0	$	$	0	$	$	0	$	$	0	$
Test Engineer	$	0	$	$	0	$	$	0	$	$	0	$	$	0	$	$	0	$
Information Assusrance Specialist	$	0	$	$	0	$	$	0	$	$	0	$	$	0	$	$	0	$
Contracts Manager	$	0	$	$	0	$	$	0	$	$	0	$	$	0	$	$	0	$
Finance Manager	$	0	$	$	0	$	$	0	$	$	0	$	$	0	$	$	0	$
Procurement Analyst	$	196	$	$	235	$	$	235	$	$	235	$	$	235	$	$	39	$
Material/Packaging Technician	$	0	$	$	0	$	$	0	$	$	0	$	$	0	$	$	0	$
Shipping/Receiving Technician	$	71	$	$	85	$	$	85	$	$	85	$	$	85	$	$	14	$
Quality Assurance Specialist	$	108	$	$	130	$	$	130	$	$	130	$	$	130	$	$	22	$
Data Entry Technician	$	0	$	$	0	$	$	0	$	$	0	$	$	0	$	$	0	$
Technical Orders Writer	$	133	$	$	160	$	$	160	$	$	160	$	$	160	$	$	26	$
Technician	$	2546	$	$	3055	$	$	3055	$	$	3055	$	$	3055	$	$	496	$

TOTAL

Labor Categories

Labor Categories and Descriptions
Skill	SCA Code or Exempt Category	Min. Experience/No. of Yrs	Duties/Responsibilities
Program Manager	Administrative	10 yrs experience in direct Program Management	Responsible for projects placed against the contract and will be accountable by the government for the technical quality, content, and results of all projects.
Configuration / Data Mgt Mgr / Documentation	Administrative	7yrs directly related experience (5yrs with MS degree). At least 3yrs progressive responsibility in providing technical leadership.	Senior level services and technical leadership setting up CM activities throughout lifecycle of projects.
Logistics Support Mgr	21030	N/A	Provides logistics support services and technical leadership of Logistics Functions. Material Expediter.
Systems Engineer	Professional	3 yrs of directly related experience (2yrs with an MS Degree) in systems integration and analysis of military hardware and software systems/processes.	Provides technical project expertise and technical guidance in solving complex hardware/software engineering problems. Provides technical support through all phases of hardware/software design analysis, development, integration, and implementation. Capable of determining appropriate use of technologies in solving engineering problems.
Hardware Engineer	Professional	0 to 2yrs directly related experience and at least 3 years of progressive responsibility in providing technical leadership.	Hardware Engineering services and some technical leadership of Hardware Engineering.
Senior Software Engineer	Professional	7yrs directly related experience (5yrs with MS degree). At least 3yrs progressive responsibility in providing technical leadership.	Senior level engineering services and technical leadership of Software Engineering.
Software Engineer	Professional	0 to 2yrs directly related experience and at least 3 years of progressive responsibility in providing technical leadership.	Software Engineering services and some technical leadership of Software Engineering.
Test Engineer	Professional	3yrs of directly related experience	Test Engineering services.
Information Assurance Specialist	Administrative	3 years of directly related experience (2yrs with a MS Degree)	This position will be responsible for identifying assurance levels achieved in meeting all applicable security policies, standards, and requirements for the Designated Approving Authority. Will be responsible for determining the required skill sets required to adequately certify systems and for identifying personnel to accomplish the comprehensive evaluation of the technical and non-technical security features of the systems.
Contracts Manager	Administrative	7 years progressive experience in managing the contracting procurement process	Negotiates with suppliers to draw up procurement contracts: Negotiates, administers, extends, terminates, and renegotiates contracts. Formulates and coordinates procurement proposals. Directs and coordinates activities of workers engaged in formulating bid proposals. Evaluates or monitors contract performance to determine necessity for amendments or extensions of contracts, and compliance to contractual obligations. Approves or rejects requests for deviations from contract specifications and delivery schedules. Arbitrates claims or complaints occurring in performance of contracts. Analyzes price proposals, financial reports, and other data to determine reasonableness of prices. May negotiate collective bargaining agreements. May serve as liaison officer to ensure fulfillment of obligations by contractors.
Finance Manager	Professional	10 years of progressive experience in a Financial Management capacity.	Manages financial matters including economic analysis, earned value management, pricing, cost analysis, and risk analysis.
Procurement Analyst	-1013	N/A	Responsible for pricing and costing of all the products on a global scale. Must have experience in accounting to understand the metrics involved in generating cost of goods and accounting for all commissions, selling expenses, G&A costs, calculations of acceptable operating income, etc. Accounting Clerk III.
Quality Assurance Specialist	1270	N/A	Maintains / monitors QA or CM activities throughout lifecycle of projects. Production Control Clerk.
Material/Packaging Technician	-21110	N/A	Responsible for all packaging of material. Shipping Packer.
Shipping/Receiving Technician	-21130	N/A	Responsible for all shipping and receiving of material. Shipping/Receiving clerk.
Data Entry Technician	1051	N/A	Responsible for data entry.
Technical Writer	30462	N/A	Provide technical writing function for engineering specifications, user manuals, monthly reports, engineering studies, publishing, etc.
Technician	23182	N/A	Responsible to provide expertise in equipment maintenance and installation or relocation in compliance with safety standards in order to maintain qulaity assurance. Electronics Technician Maintenance II.

CLIN 0009 Option to Extend CLS

CLIN 0009 Option to Extend CLS (6 months)
Unit	QUANTITY (MONTHS)	QUANTITY (SYSTEMS)	UNIT PRICE PER QUANTITY (1)	UNIT PRICE PER QUANTITY (2-100)	UNIT PRICE PER QUANTITY (101-200)	UNIT PRICE PER QUANTITY (201-300)	UNIT PRICE PER QUANTITY (301 OR GREATER)	TOTAL
Month	6	225	$	$	$	$	$	$

File details come from the government source that posted it. Updated Jul 17, 2020.