(CUI) ATTCH 5L3 Section L Attachment L3 Pricing Workbook.xlsx

XLSX spreadsheet 71 KB Posted

Attached to
AN/TMQ-53 Tactical Meteorological Observing System (TMOS) Contractor Logistics Support (CLS)
Solicitation number
FA2330-26-R-B006
Issued by

About this file

This is a pricing workbook template for federal contract solicitation FA2330-26-R-B006, which concerns Contractor Logistics Support (CLS) for the AN/TMQ-53 Tactical Meteorological Observing System (TMOS). The workbook is structured around eight CLINs (Contract Line Item Numbers) with specific pricing instructions for contractors responding to this Air Force Life Cycle Management Center (AFLCMC) solicitation.

Contractors must submit firm fixed-price (FFP) proposals for five active CLINs: CLIN 0001 for Transition Phase-In efforts (inclusive of all labor, materials, indirect rates, and profit); CLIN 0002 for Transition Phase-Out efforts; CLIN 0004 for Contractor Logistics Support per system per month across contract years one through four plus a six-month option, with tiered unit pricing for quantities 1, 2-100, 101-200, and 201-300 systems; CLIN 0005 for Spares/Repairs Parts with unit pricing multiplied by best estimated quantities (BEQs) provided for each contract year covering 59 spare parts and 21 repair items; and CLIN 0006 for Systems Engineering labor rates across 17 labor categories (ranging from Program Manager to Technician) with specified experience requirements and hourly rates. CLINs 0003, 0007, and 0008 require no contractor pricing, as the government will apply plug numbers ($10,000, $0, and $726,000 respectively) for evaluation purposes. The contract covers worldwide support for TMQ-53 systems from FY26 through FY31, and this is designated as a total small business set-aside under NAICS code 541990 with a size standard of less than $19.5M in annual receipts.

View the file

Other files

Show all 17

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 $10K.

CLIN 0004 - The contractor shall fill in the Unit Price for performing CLS per system per month for each contract year and quantity (i.e. $10,000 for the first system in CY1, $500 for systems 2-100 in CY1, $11,000 for the first system in CY2, $600 for systems 2-100 in CY2, 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 Contract Year. Determine the Unit Price and multiply by the BEQ given for a total amount for each Contract Year. Complete the same for the remaining Contract Years and tally up the Total of the Contract Years in the far right column for each part.

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 $726K.

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)TOTAL
CY1 (Month 1 - Month 12)Month12236$$$$$
CY2 (Month 13 - Month 24)Month12236$$$$$
CY3 (Month 25 - Month 36)Month12236$$$$$
CY4 (Month 37 - Month 48)Month12236$$$$$
6-Mo Option (Month 49 - Month 54)Month6236$$$$$
$$$$$
CLIN Total

CLIN 0005 Spares Repairs

CLIN 0005 Spares
CY1 (Month 1 - Month 12)CY2 (Month 13 - Month 24)CY3 (Month 25 - Month 36)CY4 (Month 37 - Month 48)6-Mo Option (Month 49 - Month 54)
Part NumberPart NameBEQUnit PriceTotalBEQUnit PriceTotalBEQUnit PriceTotalBEQUnit PriceTotalBEQUnit PriceTotalTOTAL
TMQ-53
4017Back-up Battery for QMP2013333
16139QMP202 Case Key38383838
19558Velcro Belts (Set of 10ea)18181818
25925Allen Wrench - 4mm8888
25926Sledge Hammer32323232
26222International Adapter Kit13131313
26271Stubby Common Screwdriver - 5.5mm35353535
A3LA-RIridium Modem30303030
AC4pkIridium A/C Adapter Kit39393939
ASM210283QPD Mounting Bracket15151515
AT-30023UHF Whip Antenna (410-470)62626262
AT-30028VHF Whip Antenna (138-175)12121212
AW100AfVHF Modem (138-174 MHz)38383838
AW400AfUHF Modem (410-470 MHz)72727272
CBL210103-5MAQPD 120 VAC U.S. Mains Input Cable59595959
CBL210104-5MAQPD Output Cable118118118118
CBL210127-AQPD Grounding Cable18181818
CL31MCeilometer CL31M29292929
CM-00212Radio TMOS Cable13131313
CM-00213Radio Modem PC Cable10101010
CM-10008Programming Radio Modem Cable29292929
CT25KAMCeilometer CT25KM155155155155
CT45298DC Data Cable-CT25KAM23232323
CT45300Cable-CT25KAM, AC Power12121212
HMP155Probe,Temp/RH74747474
HRC-24-7XAIRIDIUM POWER SUPPLY31313131
LMR400-50Iridium Antenna Cable16161616
MC-2 (19772)Compass12121212
PT-10003RF Antenna Cable28282828
PT-10008PC Tripod Antenna Holder33333333
PWD11APresent Weather Detector-11A3333
PWD22MPresent Weather Detector-22M98989898
QM30154-MEKASPTelescopic Wind Mast12121212
QM30176Tripod, PC Antenna22222222
QM30185Tripod Antenna Arm - UHF18181818
QM40142Ground Pegs for CT25KAM61616161
QM40287Grounding Net & Pegs33333333
QMA102MSensor Arm68686868
QMASSY201MTripod, Processor91919191
QMD102MHandheld display66666666
QML201TData Logger (Viasala NSN)133133133133
QMP202Power Supply, Enhancement71717171
QMP211USModem & HHD Power Supply18181818
QMY103MGround Peg and Foot Pad, Tripod24242424
QPD101Power Distribution Unit144144144144
QPS102Indoor Power Strip23232323
QTR101SPCase, Meteorological Equipment28282828
QTR102SPCase, Meteorological Equipment12121212
QTR103SPCase, Meteorological Equipment25252525
QTR104SPCase, Meteorological Equipment20202020
QTR105SPCase, Meteorological Equipment12121212
SA20MLightning Detector152152152152
SAF5350-CIridium Antenna19191919
SAT111Tripod, SA20M15151515
SDFP44Iridium screwdriver19191919
SYN-MNT-ANTIridium Antenna Tripod18181818
USB-SERUSB to Serial converter cable3333
VSG76756Allen Wrench - 3mm5555
WMS302MWind Speed/Direction Sensor224224224224
ZZ45113Wind Sensor Cable40404040
ZZ45114Cable, Landline29292929
ZZ45121-IP67Cable, Enhancement Mains Input41414141
ZZ45123Cable, Enhancement Data20202020
ZZ45202Cable, PC/Handheld Data9999
ZZ45215SA20M Data Cable13131313
TOTALTOTALTOTALTOTALTOTAL
TOTAL
CLIN 0005 Repairs
CY1 (Month 1 - Month 12)CY2 (Month 13 - Month 24)CY3 (Month 25 - Month 36)CY4 (Month 37 - Month 48)6-Mo Option (Month 49 - Month 54)
Part NumberPart NameBEQUnit PriceTotalBEQUnit PriceTotalBEQUnit PriceTotalBEQUnit PriceTotalBEQUnit PriceTotalTOTAL
TMQ-53
A3LA-X or A3LA-RIRIDIUM MODEM5644
AW100AFVHF MODEM2222
AW400AFUHF MODEM19221515
CL31 or CT25KAMCEILOMETER18211414
PWDXXXPRESENT WEATHER DETECTOR28332222
QMA102MSENSOR ARM17191313
QMASSY201MTRIPOD, PROCESSOR43523434
QMD102MHANDHELD DISPLAY8966
QML201TDATA LOGGER101288
QMP202POWER SUPPLY, ENHANCEMENT27312121
QPD101MPOWER DISTRIBUTION UNIT (PDU)8966
SA20M-MTLIGHTNING DETECTOR14171212
WMS302MWINDSPEED/DIRECTION SENSOR43523434
QTR101TRANSIT CASE, BASIC SENSOR8101010
QTR102TRANSIT CASE, BASIC TRIPOD8101010
QTR103TRANSIT CASE, SPARES AND TOOL KIT8101010
QTR104TRANSIT CASE, CELIOMETER8101010
QTR105TRANSIT CASE, ENAHNCED POWER SUPPLY8101010
TOTALTOTALTOTALTOTALTOTAL
TOTAL

CLIN 0006 Systems Engineering

CLIN 0006 Systems Engineering
CY1 (Month 1 - Month 12)CY2 (Month 13 - Month 24)CY3 (Month 25 - Month 36)CY4 (Month 37 - Month 48)6-Mo Option (Month 49 - Month 54)
Labor CategoryRateBEQ HrsTotalRateBEQ HrsTotalRateBEQ HrsTotalRateBEQ HrsTotalRateBEQ HrsTotal
Program Manager$154$$185$$185$$185$$185$
Configuration manager$70$$84$$84$$84$$84$
Logistics Support Manager$0$$0$$0$$0$$0$
Systems Engineer$489$$587$$587$$587$$587$
Hardware Engineer$0$$0$$0$$0$$0$
Senior Software Engineer$0$$0$$0$$0$$0$
Software Engineer$0$$0$$0$$0$$0$
Test Engineer$0$$0$$0$$0$$0$
Information Assusrance Specialist$0$$0$$0$$0$$0$
Contracts Manager$0$$0$$0$$0$$0$
Finance Manager$0$$0$$0$$0$$0$
Procurement Analyst$196$$235$$235$$235$$235$
Material/Packaging Technician$0$$0$$0$$0$$0$
Shipping/Receiving Technician$71$$85$$85$$85$$85$
Quality Assurance Specialist$108$$130$$130$$130$$130$
Data Entry Technician$0$$0$$0$$0$$0$
Technical Orders Writer$0$$0$$0$$0$$0$
Technician$2546$$3055$$3055$$3055$$3055$

TOTAL

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.

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