PricingWorksheets.xlsx

XLSX spreadsheet 59 KB Posted Jan 21, 2010

Attached to: Tactical Meteorological Observation System Logistics Support
Solicitation number: FA8217-10-R-5002
Issued by: Department of the Air Force Materiel Command Lifecycle Management Center Hill Air Force Base

About this file

From the source

Pricing Worksheets (For Total Price Evaluation)

View the file

Other files

File	Type	Posted
FA821710R5002_______0004.pdf	PDF	Mar 24, 2010
Section L 23Feb10.docx	DOCX document	Feb 23, 2010
Section M 23Feb10.docx	DOCX document	Feb 23, 2010
Industry Day Questions-AnswersRev2-23-10.doc	DOC document	Feb 23, 2010
IndustryDayQuestions-AnswersRev2-17-10.doc	DOC document	Feb 17, 2010
IndustryDayAttendees.pdf	PDF	Feb 11, 2010
IndustryDayQuestions-Answers.doc	DOC document	Feb 11, 2010
FA821710R5002_______0002.pdf	PDF	Feb 11, 2010
TMOSPricingWorksheet.xlsx	XLSX spreadsheet	Feb 8, 2010
RevisedCDRLs.pdf	PDF	Feb 8, 2010
TMOSShipmentHistory.xls	XLS spreadsheet	Feb 8, 2010
IndustryDayQuestions-Answers.doc	DOC document	Feb 8, 2010
CET.docx	DOCX document	Feb 8, 2010
FA821710R5002_______0001.pdf	PDF	Feb 8, 2010
TMQ053 Parts Usage 2008_2009.xls	XLS spreadsheet	Feb 8, 2010
TMQ-53IndustryDayBrief.pptx	PPTX presentation	Feb 8, 2010
WageDeterminations.pdf	PDF	Feb 8, 2010
PartConsumptionTrendAnalysis.pdf	PDF	Feb 8, 2010
RevisedPWS.pdf	PDF	Feb 8, 2010
Section M 8Feb10.docx	DOCX document	Feb 8, 2010
Section L 8Feb10.docx	DOCX document	Feb 8, 2010
TMQ053 Parts Usage 2008_2009.xls	XLS spreadsheet	Jan 22, 2010
WageDeterminations.pdf	PDF	Jan 21, 2010
CDRLs.pdf	PDF	Jan 21, 2010
FA821710R5002.pdf	PDF	Jan 21, 2010
CET.docx	DOCX document	Jan 21, 2010
PWS.pdf	PDF	Jan 21, 2010
TMQ53 Signed Performance Plan.pdf	PDF	Jan 21, 2010
FA821710R5002.pdf	PDF	Jan 12, 2010
CDRLs.pdf	PDF	Jan 12, 2010
WageDeterminations.pdf	PDF	Jan 12, 2010
CET.docx	DOCX document	Jan 12, 2010
PricingWorksheets.pdf	PDF	Jan 12, 2010
PWS.pdf	PDF	Jan 12, 2010
Section L.PDF	PDF	Nov 3, 2009
PWS.PDF	PDF	Nov 3, 2009
Section M Oct.docx	DOCX document	Nov 3, 2009
Performance Plan.docx	DOCX document	Nov 3, 2009
Draft Solicitation.pdf	PDF	Nov 3, 2009
CDRLs.PDF	PDF	Nov 3, 2009

Show all 40

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.

Section B FA8217-09-R-76013 TMQ-53 TMOS CLS Requirement CLIN Structure

BASIC YEAR Pricing/Ordering Period: Date of Award through 12 Months

CLIN NOUN PRICING U/I QTY Unit Price

0001	Contractor Logistics Support-CLS *	Firm-Fixed Price	MM	12	$_________
0002	Repairs	Firm-Fixed Price	EA	ATTCH 1	ATTCH 1
0003	Software Maintenance *	Firm-Fixed Price	MM	12	$_________
0004	Software Licenses *	Firm-Fixed Price	EA	As Ordered	$_________

	CLIN	NOUN	PRICING	U/I	QTY	QTY
(1-10)	QTY
(11-25)	QTY
(26-50)	QTY

(>51)

0005 TMQ-53 Systems - NEW Firm-Fixed Price EA As Ordered $_________ $_________ $_________ $_________

CLIN NOUN PRICING U/I QTY Unit Price

0006	Spares	Firm-Fixed Price	EA	ATTCH 2	ATTCH 2
0007	Travel	Cost Reimb - No Fee	LO	Ceiling in Orders
0008	Data *	Firm-Fixed Price	LO	ATTCH 3	ATTCH 3
0009	Modifications (New Capabilities, ECPs)	Cost Plus Fixed Fee	As Req'd by Future Actions	ATTCH 4	ATTCH 4

	CLIN	NOUN	PRICING	U/I	QTY	QTY
(1-10)	QTY
(11-20)	QTY

(>21)

0010	Additional CLS (a)	Firm-Fixed Price	MM	1
0011	Additional Software Maintenance (a)	Firm-Fixed Price	MM	1

*	These items constitute the minimum ordering requirement for 1st Order under ID/IQ clause, FAR 52.216-22.
(a)	CLIN 0010 and 0011 used for: 1) quantities above the Baseline; 2) new, non-replacement systems purchased that require CLS.
	FA8217-09-R-76013 TMQ-53 TMOS CLS Requirement CLIN Structure

YEAR 2 Pricing/Ordering Period: 13 through 24 Months after Award.

	CLIN	NOUN	PRICING	U/I	QTY	QTY
(200)	QTY
(250)	QTY
(310)	QTY

(350)

1001 Contractor Logistics Support-CLS Firm-Fixed Price MM 12 $_______ $_______ $_______ $_______

CLIN NOUN PRICING U/I QTY Unit Price

	1002	Repairs	Firm-Fixed Price	EA	ATTCH 1	ATTCH 1
	CLIN	NOUN	PRICING	U/I	QTY	QTY
(200-249)	QTY
(250-309)	QTY
(310-349)	QTY

(>350)

1003 Software Maintenance Firm-Fixed Price MM 12 $_______ $_______ $_______ $_______

	CLIN	NOUN	PRICING	U/I	QTY	QTY
(1-10)	QTY
(11-25)	QTY
(26-50)	QTY

(>51)

1004	Software Licenses	Firm-Fixed Price	EA	As Ordered	$_______	$_______	$_______	$_______
1005	TMQ-53 Systems - NEW	Firm-Fixed Price	EA	As Ordered	$_______	$_______	$_______	$_______

CLIN NOUN PRICING U/I QTY Unit Price

1006	Spares	Firm-Fixed Price	EA	ATTCH 2	ATTCH 2
1007	Travel	Cost Reimb - No Fee	LO	Ceiling in Orders
1008	Data	Firm-Fixed Price	LO	ATTCH 3	ATTCH 3
1009	Modifications (New Capabilities, ECPs)	Cost Plus Fixed Fee	As Req'd by Future Actions	ATTCH 4	ATTCH 4

	CLIN	NOUN	PRICING	U/I	QTY	QTY
(1-10)	QTY
(11-20)	QTY

(>21)

1010	Additional CLS (a)	Firm-Fixed Price	MM	1	$_______	$_______	$_______
1011	Additional Software Maintenance (a)	Firm-Fixed Price	MM	1	$_______	$_______	$_______

CLIN NOUN PRICING U/I QTY Unit Price

1012	Transition: Contractor to Tobyhanna AD (b)	Cost Plus Fixed Fee	If Required by future decisions
(a)	CLIN 1010 and 1011 used for: 1) quantities above the Baseline; 2) new, non-replacement systems purchased that require CLS.
(b)	CLIN 1012 will be ordered if decision is made to send workload to TYAD. Proposal will be requested at that time.
	FA8217-09-R-76013 TMQ-53 TMOS CLS Requirement CLIN Structure

YEAR 3 Pricing/Ordering Period: 25 through 36 Months after Award.

	CLIN	NOUN	PRICING	U/I	QTY	QTY
(200)	QTY
(250)	QTY
(310)	QTY

2001 Contractor Logistics Support-CLS Firm-Fixed Price MM 12 $_______ $_______ $_______ $_______

CLIN NOUN PRICING U/I QTY Unit Price

2002 Repairs Firm-Fixed Price EA ATTCH 1 ATTCH 1

	CLIN	NOUN	PRICING	U/I	QTY	QTY
(200-249)	QTY
(250-309)	QTY
(310-349)	QTY

2003 Software Maintenance Firm-Fixed Price MM 12 $_______ $_______ $_______ $_______

	CLIN	NOUN	PRICING	U/I	QTY	QTY
(1-10)	QTY
(11-25)	QTY
(26-50)	QTY

(>51)

2004	Software Licenses	Firm-Fixed Price	EA	As Ordered	$_______	$_______	$_______	$_______
2005	TMQ-53 Systems - NEW	Firm-Fixed Price	EA	As Ordered	$_______	$_______	$_______	$_______

CLIN NOUN PRICING U/I QTY Unit Price

2006	Spares	Firm-Fixed Price	EA	ATTCH 2	ATTCH 2
2007	Travel	Cost Reimb - No Fee	LO	Ceiling in Orders
2008	Data	Firm-Fixed Price	LO	ATTCH 3	ATTCH 3
2009	Modifications (New Capabilities, ECPs)	Cost Plus Fixed Fee	As Req'd by Future Actions	ATTCH 4	ATTCH 4

	CLIN	NOUN	PRICING	U/I	QTY	QTY
(1-10)	QTY
(11-20)	QTY

(>21)

2010	Additional CLS (a)	Firm-Fixed Price	MM	1	$_______	$_______	$_______
2011	Additional Software Maintenance (a)	Firm-Fixed Price	MM	1	$_______	$_______	$_______

CLIN NOUN PRICING U/I QTY Unit Price AMOUNT

2012	Transition: Contractor to Tobyhanna AD (b)	Cost Plus Fixed Fee	If Required by future decisions	Gov't provided Ceiling
(a)	CLIN 2010 and 2011 used for: 1) quantities above the Baseline; 2) new, non-replacement systems purchased that require CLS.
(b)	CLIN 2012 will be ordered if decision is made to send workload to TYAD. Proposal will be requested at that time.
	FA8217-09-R-76013 TMQ-53 TMOS CLS Requirement CLIN Structure

YEAR 4 Pricing/Ordering Period: 37 through 48 Months after Award.

	CLIN	NOUN	PRICING	U/I	QTY	QTY
(200)	QTY
(250)	QTY
(310)	QTY

3001 Contractor Logistics Support-CLS Firm-Fixed Price MM 12 $_______ $_______ $_______ $_______

CLIN NOUN PRICING U/I QTY Unit Price

3002 Repairs Firm-Fixed Price EA ATTCH 1 ATTCH 1

	CLIN	NOUN	PRICING	U/I	QTY	QTY
(200-249)	QTY
(250-309)	QTY
(310-349)	QTY

3003 Software Maintenance Firm-Fixed Price MM 12 $_______ $_______ $_______ $_______

	CLIN	NOUN	PRICING	U/I	QTY	QTY
(1-10)	QTY
(11-25)	QTY
(26-50)	QTY

(>51)

3004	Software Licenses	Firm-Fixed Price	EA	As Ordered	$_______	$_______	$_______	$_______
3005	TMQ-53 Systems - NEW	Firm-Fixed Price	EA	As Ordered	$_______	$_______	$_______	$_______

CLIN NOUN PRICING U/I QTY Unit Price

3006	Spares	Firm-Fixed Price	EA	ATTCH 2	ATTCH 2
3007	Travel	Cost Reimb - No Fee	LO	Ceiling in Orders
3008	Data	Firm-Fixed Price	LO	ATTCH 3	ATTCH 3
3009	Modifications (New Capabilities, ECPs)	Cost Plus Fixed Fee	As Req'd by Future Actions	ATTCH 4	ATTCH 4

	CLIN	NOUN	PRICING	U/I	QTY	QTY
(1-10)	QTY
(11-20)	QTY

(>21)

3010	Additional CLS (a)	Firm-Fixed Price	MM	1	$_______	$_______	$_______
3011	Additional Software Maintenance (a)	Firm-Fixed Price	MM	1	$_______	$_______	$_______

CLIN NOUN PRICING U/I QTY Unit Price

3012	Transition: Contractor to Tobyhanna AD (b)	Cost Plus Fixed Fee	If Required by future decisions
(a)	CLIN 3010 and 3011 used for: 1) quantities above the Baseline; 2) new, non-replacement systems purchased that require CLS.
(b)	CLIN 3012 will be ordered if decision is made to send workload to TYAD. Proposal will be requested at that time.
	FA8217-09-R-76013 TMQ-53 TMOS CLS Requirement CLIN Structure

YEAR 5 Pricing/Ordering Period: 49 through 60 Months after Award.

	CLIN	NOUN	PRICING	U/I	QTY	QTY
(200)	QTY
(250)	QTY
(310)	QTY

4001 Contractor Logistics Support-CLS Firm-Fixed Price MM 12 $_______ $_______ $_______ $_______

CLIN NOUN PRICING U/I QTY Unit Price

4002 Repairs Firm-Fixed Price EA ATTCH 1 ATTCH 1

	CLIN	NOUN	PRICING	U/I	QTY	QTY
(200-249)	QTY
(250-309)	QTY
(310-349)	QTY

4003 Software Maintenance Firm-Fixed Price MM 12 $_______ $_______ $_______ $_______

	CLIN	NOUN	PRICING	U/I	QTY	QTY
(1-10)	QTY
(11-25)	QTY
(26-50)	QTY

(>51)

4004	Software Licenses	Firm-Fixed Price	EA	As Ordered	$_______	$_______	$_______	$_______
4005	TMQ-53 Systems - NEW	Firm-Fixed Price	EA	As Ordered	$_______	$_______	$_______	$_______

CLIN NOUN PRICING U/I QTY Unit Price

4006	Spares	Firm-Fixed Price	EA	ATTCH 2	ATTCH 2
4007	Travel	Cost Reimb - No Fee	LO	Ceiling in Orders
4008	Data	Firm-Fixed Price	LO	ATTCH 3	ATTCH 3
4009	Modifications (New Capabilities, ECPs)	Cost Plus Fixed Fee	As Req'd by Future Actions	ATTCH 4	ATTCH 4

	CLIN	NOUN	PRICING	U/I	QTY	QTY
(1-10)	QTY
(11-20)	QTY

(>21)

4010	Additional CLS (a)	Firm-Fixed Price	MM	1	$_______	$_______	$_______
4011	Additional Software Maintenance (a)	Firm-Fixed Price	MM	1	$_______	$_______	$_______

CLIN NOUN PRICING U/I QTY Unit Price

4012 Transition: Contractor to Tobyhanna AD (b) Cost Plus Fixed Fee If Required by future decisions

(a)	CLIN 4010 and 4011 used for: 1) quantities above the Baseline; 2) new, non-replacement systems purchased that require CLS.
(b)	CLIN 4012 will be ordered if decision is made to send workload to TYAD. Proposal will be requested at that time.

Attachment 1

	TMQ-53 TMOS REPAIRS PRICING WORKSHEET			CLIN ATTACHMENT 1
			Unit Price Per Repair (Including Evaluation)
Description	P/N	CAGE	UNIT $ / EACH

CEILOMETER CT25KAM 63653

PRESENT WEATHER DETECTOR PWDXXX 63653

HANDHELD DISPLAY QMD101M 63653

WIND SENSOR WMS302M 63653

TRIPOD PROCESSOR QML101T 63653

POWER SUPPLY, ENHANCEMENT QMP202 63653

LIGHTNING DETECTOR SA20M 63653

SENSOR ARM QMA102M 63653

UHF RF MODEM AW400AF 4G8Z1

VHF RF MODEM AW100AF 4G8Z1

DATA LOGGER QML201T 63653

LAPTOP RA-TM-LT-CPU-XX 072E5

AUTO-RETART CABLE (ARC) INPUT POWER PROTECTOR RA-TM-PW-ARC-01 072E5

IRIDIUM MODEM A3LA-IU 1SZL2

Attachment 2

TMQ-53 TMOS SPARES PRICING WORKSHEET CLIN ATTACHMENT 2

			ORDERING QUANTITY PRICING PER UNIT
Description	P/N	CAGE	1-10 Units (UNIT $/EACH)	11+ Units (UNIT $/EACH)
QMP202 CASE KEY	16139	63653
VELCRO BELTS	19558 (Equiv)
ALLEN WRENCH - 4 mm	25925 (Equiv)
SLEDGE HAMMER	25926 (Equiv)
INTERNATIONAL ADAPTER KIT	2622	63653
SCREWDRIVER - 5.5 mm	26271 (Equiv)
IRIDIUM MODEM	A3LA-IU	1SZL2
AOS CLIENT SOFTWARE	AOS 2X.X	3CX96
UHF WHIP ANTENNA (410-470Mhz)	AT-30023	4G8Z1
VHF WHIP ANTENNA (138-175Mhz)	AT-30028	4G8Z1
VHF RADIO MODEM (138-175Mhz)	AW100AF	4G8Z1
UHF RADIO MODEM (410-470Mhz)	AW400AF	4G8Z1
CABLE, RADIO TMOS	CM-00212	4G8Z1
CABLE, RADIO MODEM PC	CM-00213	4G8Z1
PROGRAMMING CABLE, RADIO MODEM	CM-10008	4G8Z1
CEILOMETER	CT25KAM	63653
DC DATA CABLE - CT25KAM	CT45298	63653
AC POWER CABLE- CT25KAM	CT45300	63653
POWER SUPPLY, LAPTOP	ED495UT (Equiv)
TEMP/RH PROBE	HMP45DX-SWD	63653
IRIDIUM SYSTEM RESTORATION CD	IRID-CD	1SZL2
IRIDIUM MODEM POWER SUPPLY W/USB INTERFACE	LA-XX98U	1SZL2
IRIDIUM ANTENNA CABLE	LMR400-50	1SZL2
MC-2G COMPASS	19772	63653
LAPTOP BATTERY	PB992UT (Equiv)
ANTENNA CABLE W/TNC	PT-10003	4G8Z1
PC TRIPOD ANTENNA HOLDER	PT-10008	4G8Z1
MOUNTING BRACKET CLIP	PT-10009	4G8Z1
PRESENT WEATHER DETECTOR	PWD-XXX	63653
TELESCOPIC WIND MAST	QM30154-MEKA	63653
TRIPOD, PC ANTENNA	QM30176	63653
TRIPOD, ANTENNA ARM - UHF	QM30185	63653
GROUND PEGS for CT25KAM (1 SET of 4)	QM40142	63653
GROUNDING NETS PEGS,SA20M (NET & PEGS)	QM40287	63653
SENSOR ARM	QMA102M	63653
HANDHELD DISPLAY	QMD101M	63653
TRIPOD PROCESSOR	QML101T	63653
DATA LOGGER	QML201T	63653
ENHANCEMENT, POWER SUPPLY	QMP202	63653
POWER SUPPLY, MODEM to HANDHELD DEVICE	QMP211US	63653
GROUND PEGS and FOOT PADS - TRIPOD (SET of 3)	QMY103M	63653
OUTDOOR POWER STRIP, 120VAC	QPS101	63653
INDOOR POWER STRIP	QPS102	63653
OUTDOOR POWER STRIP, 240VAC	QPS103	63653
TRANSIT CASE, BASIC SENSOR	QTR101	63653
TRANSIT CASE, TRIPOD	QTR102	63653
TRANSIT CASE, SPARES and TOOLKIT	QTR103	63653
TRANSIT CASE, CEILOMETER	QTR104	63653
TRANSIT CASE, POWER SUPPLY	QTR105	63653
LAPTOP	RA-TM-LT-CPU-XX	072E5
AUTO-RESTART CABLE (ARC) - IPP	RA-TM-PW-ARC-01	072E5
POWER ADAPTER CABLE - ARC	RA-TM-PW-PAC-01	072E5
LIGHTNING DETECTOR	SA20M-MT	63653
IRIDIUM PIPE ANTENNA	SAF5350-C	1SZL2
TRIPOD, SA20M LIGHTNING DETECTOR	SAT111	63653
IRIDIUM SCREWDRIVER	SDFP44 (Equiv)
IRIDIUM SIM CARD	SIM CARD	GFP
IRIDIUM TRIPOD	SYN-MNT-ANT	1SZL2
IRIDIUM USB to SERIAL CONVERTER CABLE	USB-SER	1SZL2
ALLEN WRENCH - 3 mm	VSG85756 (Equiv)
WIND SPEED / DIRECTION SENSOR	WMS302M	63653
MAWS BATTERY	YP1, 2-6 (Equiv)
CABLE, WIND SENSOR	ZZ45113	63653
CABLE, LANDLINE	ZZ45114	63653
CABLE, MAINS INPUT	ZZ45121-1	63653
CABLE, ENHANCEMENT MAINS INPUT	ZZ45121-2	63653
CABLE, ENHANCEMENT DATA	ZZ45123	63653
CABLE, PC / HANDHELD DATA	ZZ45202	63653
CABLE, RFM96W MAWS	ZZ45212	63653
CABLE, RFM96W PC CONNECTION	ZZ45213	63653
CABLE, SA20M DATA	ZZ45215	63653

Attachment 3

TMQ-53 TMOS DATA PRICING WORKSHEET			CLIN ATTACHMENT 3
		PRICING PER LOT
Description	ELIN	UNIT $/LOT

TRANSITION PLAN, PROGRAM PLAN A001

CAC LIST OF TMQ-53 PERSONNEL A002

MEETING AGENDA A003

MEETING MINUTES A004

MONTHLY STATUS REPORT A005

SPARE PARTS USAGE REPORT A006

PROVISIONING SPARES RECOMMENDATION A007

ENGINEERING CHANGE PROPOSAL A008

TECHNICAL MANUAL A009

TEST REPORT A010

CONFIGURATION MGT PLAN A011

DIACAP SECURITY PACKAGE A012

COMPUTER-BASED TRAINING MATERIALS	A013
Note: As the CLS baseline changes on subsequent ordering/pricing periods, the magnitude of the data reporting requirment may vary slightly. Offerors should take this into consideration when providing a Firm Fixed Priced value for data.

Attachment 4

TMQ-53 TMOS MODIFICATION PRICING WORKSHEET CLIN ATTACHMENT 4

1. Do not add labor categories or change worksheet columns/rows.

2. All labor categories for all years must be populated.

3. Do not extend labor hour rates beyond two decimal places.

4. Do not rename worksheet tabs.

5. The cost rates are fully burdened to include all applicable direct and indirect costs. These rates do not include fixed fee amounts. The fixed fee amouts will be proposed on the task/delivery orders. The cost rates shall be utilized to propose future modifications.

Cost Rates-Applicable to CPFF CLINs

AN/TMQ-53 Handheld Device P/N QMD101M Replacement

LABOR RATES

Labor Categories

FY 2010

FY 2011

FY 2012

FY 2013

FY 2014

FY 2015

RATE

Program - Project Manager

Program Task Manager

Project Configuration - Integration Engineer

Hardware Engineer

Software Engineer

Logistics Manager

Data Entry Technician

Procurement - Supply Chain

Material - Supply Chain

Packaging - Receiving

Shipping - Distribution

QA - Inspection

Mechanical Engineer - Technician

Electronic Engineer - Technician

Assembler Engineer - Technician

Test - Integration Technician

Training - Familiarization Specialists

Technical Orders Writer

Note: This spreadsheet MUST be submitted electronically as a Microsoft Excel spreadsheet and not in any other format. DO NOT limit/protect the worksheet to "read only" format.

BML TEP Worksheet - 5 OCT 2009

File details come from the government source that posted it. Updated Nov 14, 2017.