5L3. Section L Attachment L3 Pricing Workbook (V2).xlsx

XLSX spreadsheet 224 KB Posted

Attached to
AN/TMQ-53 Tactical Meteorological Observing System (TMOS), Contractor Logistics Support (CLS) effort
Solicitation number
FA8730-20-R-0050
Issued by

About this file

This request for proposal solicits proposals for contractor logistics support of the AN/TMQ-53 Tactical Meteorological Observing System. Proposals are due no later than August 17, 2020 and must be submitted to the procuring contracting officer at the Air Force Life Cycle Management Center.

The solicitation is set aside for small businesses with annual receipts less than $16.5 million. The resulting contract will have a five-year base period and one-year option to provide contractor logistics support including maintenance, repair, and logistics services for 225 systems. The support services will include transition assistance, contractor logistics support, spare parts provisioning, engineering services, and a six-month option to extend support. The Air Force Life Cycle Management Center is seeking proposals for these contractor logistics support requirements.

View the file

Other files

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

Text version

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
UnitQuantityPrice
Lot1
CLIN 0002 Transition Phase-Out
UnitQuantityPrice
Lot1
CLIN 0004 CLS
YEARUNITQUANTITY (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
FY21Month102250
FY22Month122250
FY23Month122250
FY24Month122250
FY25Month122250
FY26Month22250
CLIN Total0

CLIN 0005 Spares Repairs

CLIN 0005 Spares
FY21FY22FY23FY24FY25FY26
Part NumberPart NameBEQUnit PriceTotalBEQUnit PriceTotalBEQUnit PriceTotalBEQUnit PriceTotalBEQUnit PriceTotalBEQUnit PriceTotalTOTAL
TMQ-53
4017Back-up Battery for QMP201140160160160160300
16139QMP202 Case Key7080808080200
19558Velcro Belts (Set of 10ea)290340340340340600
25925Allen Wrench - 4mm120140140140140300
25926Sledge Hammer6060606060200
26222International Adapter Kit120140140140140300
26271Stubby Common Screwdriver - 5.5mm100110110110110200
A3LA-RIridium Modem130150150150150300
AC4pkIridium A/C Adapter Kit7080808080200
ASM210283QPD Mounting Bracket190230230230230400
AT-30023UHF Whip Antenna (410-470)260300300300300600
AT-30028VHF Whip Antenna (138-175)120140140140140300
AW100AfVHF Modem (138-174 MHz)230280280280280500
AW400AfUHF Modem (410-470 MHz)280330330330330600
CBL210103-5MAQPD 120 VAC U.S. Mains Input Cable6070707070200
CBL210104-5MAQPD Output Cable90100100100100200
CBL210127-AQPD Grounding Cable7080808080200
CF-311TO35VMToughbook Computer110130130130130300
CF-AA1653AMCOMPUTER POWER SUPPLY6808108108108101400
CF-K31HD5032CF-31 Hard Disk Drive320380380380380700
CL31MCeilometer CL31M180210210210210400
CM-00212Radio TMOS Cable210250250250250500
CM-00213Radio Modem PC Cable200240240240240400
CM-10008Programming Radio Modem Cable170190190190190400
CT25KAMCeilometer CT25KM330390390390390700
CT45298DC Data Cable-CT25KAM170190190190190400
CT45300Cable-CT25KAM, AC Power100110110110110200
HMP155Probe,Temp/RH340400400400400800
HRC-24-7XAIRIDIUM POWER SUPPLY340400400400400800
LMR400-50Iridium Antenna Cable170210210210210400
MC-2 (19772)Compass100120120120120200
PT-10003RF Antenna Cable400470470470470800
PT-10008PC Tripod Antenna Holder300350350350350600
PWD11APresent Weather Detector-11A140160160160160300
PWD22MPresent Weather Detector-22M5606706706706701200
QM30154-MEKASPTelescopic Wind Mast200240240240240400
QM30176Tripod, PC Antenna120140140140140300
QM30185Tripod Antenna Arm - UHF200230230230230400
QM40142Ground Pegs for CT25KAM6070707070200
QM40287Grounding Net & Pegs200240240240240400
QMA102MSensor Arm4705605605605601000
QMASSY201MTripod, Processor280330330330330600
QMD102MHandheld display140170170170170400
QML201TData Logger (Viasala NSN)250290290290290600
QMP202Power Supply, Enhancement140160160160160300
QMP211USModem & HHD Power Supply190230230230230400
QMY103MGround Peg and Foot Pad, Tripod8090909090200
QPD101Power Distribution Unit220260260260260500
QPS102Indoor Power Strip230280280280280500
QTR101SPCase, Meteorological Equipment4050505050200
QTR102SPCase, Meteorological Equipment230280280280280500
QTR103SPCase, Meteorological Equipment4040404040100
QTR104SPCase, Meteorological Equipment180210210210210400
QTR105SPCase, Meteorological Equipment100120120120120200
SA20MLightning Detector4705605605605601000
SAF5350-CIridium Antenna130150150150150300
SAT111Tripod, SA20M100120120120120200
SDFP44Iridium screwdriver130150150150150300
SYN-MNT-ANTIridium Antenna Tripod130150150150150300
TMOS-SAKSupport Arm Kit90100100100100200
TMOS-TMKTripod Maintenance Kit80100100100100200
USB-SERUSB to Serial converter cable330390390390390700
VSG76756Allen Wrench - 3mm140150150150150300
YUBIKEYYubiKey FIPS 140-2 USB-A (Non-nano)210250250250250500
WMS302MWind Speed/Direction Sensor131015601560156015602700
ZZ45113Wind Sensor Cable86010301030103010301800
ZZ45114Cable, Landline280330330330330600
ZZ45121-IP67Cable, Enhancement Mains Input5060606060200
ZZ45123Cable, Enhancement Data150170170170170400
ZZ45202Cable, PC/Handheld Data140160160160160300
ZZ45215SA20M Data Cable150170170170170400

TOTAL 0

CLIN 0005 Repairs
FY21FY22FY23FY24FY25FY26
Part NumberPart NameBEQUnit PriceTotalBEQUnit PriceTotalBEQUnit PriceTotalBEQUnit PriceTotalBEQUnit PriceTotalBEQUnit PriceTotalTOTAL
TMQ-53
A3LA-X or A3LA-RIRIDIUM MODEM5060404060200
AW100AFVHF MODEM2020202020100
AW400AFUHF MODEM190220150150220400
CF30/31 or EquivLAPTOP3030202030100
CL31 or CT25KAMCEILOMETER180210140140210400
PWDXXXPRESENT WEATHER DETECTOR280330220220330600
QMA102MSENSOR ARM170190130130190400
QMASSY201MTRIPOD, PROCESSOR4305203403405201000
QMD102MHANDHELD DISPLAY8090606090200
QML201TDATA LOGGER1001208080120200
QMP202POWER SUPPLY, ENHANCEMENT270310210210310600
QPD101MPOWER DISTRIBUTION UNIT (PDU)8090606090200
SA20M-MTLIGHTNING DETECTOR140170120120170400
WMS302MWINDSPEED/DIRECTION SENSOR4305203403405201000
QTR101TRANSIT CASE, BASIC SENSOR80100100100100200
QTR102TRANSIT CASE, BASIC TRIPOD80100100100100200
QTR103TRANSIT CASE, SPARES AND TOOL KIT80100100100100200
QTR104TRANSIT CASE, CELIOMETER80100100100100200
QTR105TRANSIT CASE, ENAHNCED POWER SUPPLY80100100100100200

TOTAL 0

CLIN 0006 Systems Engineering

CLIN 0006 Systems Engineering
FY21FY22FY23FY24FY25FY26
Labor CategoryRateBEQ HrsTotalRateBEQ HrsTotalRateBEQ HrsTotalRateBEQ HrsTotalRateBEQ HrsTotalRateBEQ HrsTotalTOTAL
Program Manager154018501850185018503000
Configuration manager7008408408408401400
Logistics Support Manager0000000000000
Systems Engineer489058705870587058709600
Hardware Engineer0000000000000
Senior Software Engineer0000000000000
Software Engineer0000000000000
Test Engineer0000000000000
Information Assusrance Specialist0000000000000
Contracts Manager0000000000000
Finance Manager0000000000000
Procurement Analyst196023502350235023503900
Material/Packaging Technician0000000000000
Shipping/Receiving Technician7108508508508501400
Quality Assurance Specialist108013001300130013002200
Data Entry Technician0000000000000
Technical Orders Writer133016001600160016002600
Technician254603055030550305503055049600

TOTAL 0

Labor Categories Labor Categories and Descriptions

SkillSCA Code or Exempt CategoryMin. Experience/No. of YrsDuties/Responsibilities
Program ManagerAdministrative10 yrs experience in direct Program ManagementResponsible 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 / DocumentationAdministrative7yrs 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 Mgr21030N/AProvides logistics support services and technical leadership of Logistics Functions. Material Expediter.
Systems EngineerProfessional3 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 EngineerProfessional0 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 EngineerProfessional7yrs 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 EngineerProfessional0 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 EngineerProfessional3yrs of directly related experienceTest Engineering services.
Information Assurance SpecialistAdministrative3 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 ManagerAdministrative7 years progressive experience in managing the contracting procurement processNegotiates 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 ManagerProfessional10 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-1013N/AResponsible 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 Specialist1270N/AMaintains / monitors QA or CM activities throughout lifecycle of projects. Production Control Clerk.
Material/Packaging Technician-21110N/AResponsible for all packaging of material. Shipping Packer.
Shipping/Receiving Technician-21130N/AResponsible for all shipping and receiving of material. Shipping/Receiving clerk.
Data Entry Technician1051N/AResponsible for data entry.
Technical Writer30462N/AProvide technical writing function for engineering specifications, user manuals, monthly reports, engineering studies, publishing, etc.
Technician23182N/AResponsible 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)
UnitQUANTITY (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
Month62250

File details come from the government source that posted it. Updated .