Attachment 6 - Pricing Matrix Worksheet.xlsx
XLSX spreadsheet 57 KB Posted
- Attached to
- Solicitation: Full and Open CLS Sustainment services for the AEWS AN/FPS-117 Radar System
- Solicitation number
- FA821725RB004
About this file
The provided file is an Excel-based Pricing Matrix Worksheet for a federal contract opportunity involving Contractor Logistics Support (CLS) services for the AN/FPS-117 Long Range Radar System. The worksheet details labor rate categories across six years, including positions such as Program Manager, Systems Engineer, Software Engineer, and Test Technician, with fully burdened hourly rates to be populated by the offeror. The pricing structure includes both Fixed Price (FFP) and Cost Reimbursable (CPFF) Contract Line Item Numbers (CLINs) for various services including Program Management, Engineering Technical Support, Emergency Depot Level Maintenance, Shipping, Travel, and Diminishing Manufacturing Sources and Material Shortages (DMSMS) management.
The contract is an Indefinite Delivery/Indefinite Quantity (ID/IQ) solicitation by the Air Force Life Cycle Management Center for sustaining the AN/FPS-117 radar system across 27 operational sites in Alaska, Canada, and Hawaii, with an Engineering Facility at Hill AFB, Utah. The five-year contract (with a six-month extension option) has a total potential performance period not exceeding nine years, targeting full and open competition with a small business size standard of 1,350 employees. The NAICS code is 334511, and the solicitation (FA821725RB004) requires electronic offer submission through the PIEE Solicitation Module, with all questions due by 15 August 2025 at 2:00 PM Mountain Standard Time.
View the file
Other files
Show all 20
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
Labor Rate Matrix Fully Burdened Labor Rates Pricing Worksheet
| 1. Do not add labor categories or change worksheet columns and rows. |
| 2. Do not rename worksheet tabs |
| 3. All Labor Categories for all years must be populated. Do not leave priced cells blank, even if duplicative or only loosely matched to actual categories. Apply best match practicable. |
| 4. All labor hour rates shall be fully burdened rates less profit/fee, and include all applicable indirect costs, fringe, overhead, G&A, FCCOM, etc. Except profit and fee. Profit and fee will be included separately below. |
| 5. Do not extend rates beyond two decimal places |
| 6. These rates shall be utilized as a not to exceed for proposing future contract actions and modifications. Any deviation or modification to this table will be solely at the Government's discretion. |
| 7. This rate table will be used as a NTE table for the prime offeror/Joint Venture/Teaming Members |
| 8. Additional labor categories and rates may be negotiated at time of task order at the Government's discretion |
| 9. Detail the profit and fee rates to be used for each pricing arrangement in the bottom table, provide the FCCOM (if used) included in the rates to verify that the statutory maximum (FAR 15.404-4(c)(4)(i)(c)) is not exceeded for the CPFF arrangement. |
| 10. Profit and fee rates applied to each labor category will be determined by the pricing arrangement (FFP, CPFF). All profit and fee rates shall be the same within each pricing arrangement for all labor rates. |
| Labor Category | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 |
| Hourly Rate $ | Hourly Rate $ | Hourly Rate $ | Hourly Rate $ | Hourly Rate $ | Hourly Rate $ | |
| Subject Matter Expert | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Program Manager | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Senior Manager | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Project Technical Manager | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Senior Systems Engineer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Systems Engineer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Senior Electronic/Electrical Engineer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Electronic/Electrical Engineer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Junior Electronic/Electrical Engineer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Senior Software Engineer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Software Engineer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Junior Software Engineer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Senior Systems Analyst | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Systems Analyst | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Junior Systems Analyst | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Quality Assurance/Configuration Management Engineer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Quality Assurance/Configuration Management Analyst | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Senior Logistician | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Logistician | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Senior Test Engineer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Test Engineer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Junior Test Engineer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Senior Engineering Technicians | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Engineering Technicians | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Junior Engineering Technicians | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Senior Drafting/CAD | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Drafting/CAD | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Junior Drafting/CAD | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Senior Documentation/Technical Writer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Documentation/Technical Writer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Junior Documentation/Technical Writer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Production Engineer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Scheduler/Planner | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Test Technician Operator | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Production Test Engineer/Process Control Engineer - Test | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Shipping Specialist | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Supply Technician/Specialist | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Production Program Financial Manager | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| FCCOM Rate | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% |
| Profit % (FFP) | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% |
| Fee % (CPFF) | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% |
Awardable Task Order
| Instructions: |
| 1. Propose program management, engineering services, EDLM, and DMSMS CLINs (highlighted in yellow) for base year and each option year. Only enter values in yellow cells. The Unit Price, Estimated Cost, and Fixed Fee will be multiplied by the Estimated Quantities to determine an Amount (FFP) or Est Total Cost (CPFF). |
| 2. Proposed costs and Fee/Profit shall be proposed using the rates identified in the "Labor Rate Matrix" tab. |
| 3. Shipping and Travel cost will be provided at award and time of option exercise. |
| 4. The below CLIN structure represent the awardable task order. |
| 5. These proposed CLIN values will be considered in the TEP calculation. |
| FFP | CPFF | |||||||||||
| CLINS | PRICING ARRANGEMENT | NOUN | Estimated Quantities | U/I | POP | Inspection/Acceptance | Period | Unit Price | Amount | Estimated Cost | Fixed Fee | Est Total Cost |
| 0001 | Not Separately Priced (NSP) | Data | 1 | Lot | As Required | Destination | Upon Award | NSP | NSP | |||
| 1001 | Not Separately Priced | Data | 1 | Lot | As Required | Destination | Option Year 1 | NSP | NSP | |||
| 2001 | Not Separately Priced | Data | 1 | Lot | As Required | Destination | Option Year 2 | NSP | NSP | |||
| 3001 | Not Separately Priced | Data | 1 | Lot | As Required | Destination | Option Year 3 | NSP | NSP | |||
| 4001 | Not Separately Priced | Data | 1 | Lot | As Required | Destination | Option Year 4 | NSP | NSP | |||
| 5001 | Not Separately Priced | Data | 1 | Lot | As Required | Destination | Six Month Option | NSP | NSP |
| 0002 | FFP | Program Management | 12 | Months | 12 Months | Destination | Upon Award | $ - 0 | $ - 0 |
| 1002 | FFP | Program Management | 12 | Months | 12 Months | Destination | Option Year 1 | $ - 0 | $ - 0 |
| 2002 | FFP | Program Management | 12 | Months | 12 Months | Destination | Option Year 2 | $ - 0 | $ - 0 |
| 3002 | FFP | Program Management | 12 | Months | 12 Months | Destination | Option Year 3 | $ - 0 | $ - 0 |
| 4002 | FFP | Program Management | 12 | Months | 12 Months | Destination | Option Year 4 | $ - 0 | $ - 0 |
| 5002 | FFP | Program Management | 6 | Months | 6 Months | Destination | Six Month Option | $ - 0 | $ - 0 |
| 0004 | CPFF | Engineering Technical Support Services (Section H Clause is applicable) | 1 | Lot | 12 Months | Destination | Upon Award | $ - 0 | $ - 0 | $ - 0 |
| 1004 | CPFF | Engineering Technical Support Services (Section H Clause is applicable) | 1 | Lot | 12 Months | Destination | Option Year 1 | $ - 0 | $ - 0 | $ - 0 |
| 2004 | CPFF | Engineering Technical Support Services (Section H Clause is applicable) | 1 | Lot | 12 Months | Destination | Option Year 2 | $ - 0 | $ - 0 | $ - 0 |
| 3004 | CPFF | Engineering Technical Support Services (Section H Clause is applicable) | 1 | Lot | 12 Months | Destination | Option Year 3 | $ - 0 | $ - 0 | $ - 0 |
| 4004 | CPFF | Engineering Technical Support Services (Section H Clause is applicable) | 1 | Lot | 12 Months | Destination | Option Year 4 | $ - 0 | $ - 0 | $ - 0 |
| 5004 | CPFF | Engineering Technical Support Services (Section H Clause is applicable) | 1 | Lot | 6 Months | Destination | Six Month Option | $ - 0 | $ - 0 | $ - 0 |
| 0007 | CPFF | ACC Emergency Depot Level Maintenance (EDLM) | 150 | Hours | 12 Months | Destination | Upon Award | $ - 0 | $ - 0 | $ - 0 |
| 1007 | CPFF | ACC Emergency Depot Level Maintenance (EDLM) | 150 | Hours | 12 Months | Destination | Option Year 1 | $ - 0 | $ - 0 | $ - 0 |
| 2007 | CPFF | ACC Emergency Depot Level Maintenance (EDLM) | 150 | Hours | 12 Months | Destination | Option Year 2 | $ - 0 | $ - 0 | $ - 0 |
| 3007 | CPFF | ACC Emergency Depot Level Maintenance (EDLM) | 150 | Hours | 12 Months | Destination | Option Year 3 | $ - 0 | $ - 0 | $ - 0 |
| 4007 | CPFF | ACC Emergency Depot Level Maintenance (EDLM) | 150 | Hours | 12 Months | Destination | Option Year 4 | $ - 0 | $ - 0 | $ - 0 |
| 5007 | CPFF | ACC Emergency Depot Level Maintenance (EDLM) | 75 | Hours | 6 Months | Destination | Six Month Option | $ - 0 | $ - 0 | $ - 0 |
| 0009 | CPFF | Air National Guard EDLM | 50 | Hours | 12 Months | Destination | Upon Award | $ - 0 | $ - 0 | $ - 0 |
| 1009 | CPFF | Air National Guard EDLM | 50 | Hours | 12 Months | Destination | Option Year 1 | $ - 0 | $ - 0 | $ - 0 |
| 2009 | CPFF | Air National Guard EDLM | 50 | Hours | 12 Months | Destination | Option Year 2 | $ - 0 | $ - 0 | $ - 0 |
| 3009 | CPFF | Air National Guard EDLM | 50 | Hours | 12 Months | Destination | Option Year 3 | $ - 0 | $ - 0 | $ - 0 |
| 4009 | CPFF | Air National Guard EDLM | 50 | Hours | 12 Months | Destination | Option Year 4 | $ - 0 | $ - 0 | $ - 0 |
| 5009 | CPFF | Air National Guard EDLM | 25 | Hours | 6 Months | Destination | Six Month Option | $ - 0 | $ - 0 | $ - 0 |
| 0024 | CRNF | Shipping | 1 | Lot | 12 Months | Destination | Year 1 | TBD | No Fee | TBD |
| 1024 | CRNF | Shipping | 1 | Lot | 12 Months | Destination | Year 2 | TBD | No Fee | TBD |
| 2024 | CRNF | Shipping | 1 | Lot | 12 Months | Destination | Year 3 | TBD | No Fee | TBD |
| 3024 | CRNF | Shipping | 1 | Lot | 12 Months | Destination | Year 4 | TBD | No Fee | TBD |
| 4024 | CRNF | Shipping | 1 | Lot | 12 Months | Destination | Year 5 | TBD | No Fee | TBD |
| 5024 | CRNF | Shipping | 1 | Lot | 6 Months | Destination | Year 6 | TBD | No Fee | TBD |
| 0025 | CRNF | Travel | 1 | Lot | 12 Months | Destination | Year 1 | TBD | No Fee | TBD |
| 1025 | CRNF | Travel | 1 | Lot | 12 Months | Destination | Year 2 | TBD | No Fee | TBD |
| 2025 | CRNF | Travel | 1 | Lot | 12 Months | Destination | Year 3 | TBD | No Fee | TBD |
| 3025 | CRNF | Travel | 1 | Lot | 12 Months | Destination | Year 4 | TBD | No Fee | TBD |
| 4025 | CRNF | Travel | 1 | Lot | 12 Months | Destination | Year 5 | TBD | No Fee | TBD |
| 5025 | CRNF | Travel | 1 | Lot | 6 Months | Destination | Year 6 | TBD | No Fee | TBD |
| 0026 | FFP | Diminishing Manufacturing Sources and Material Shortages (DMSMS) | 12 | Months | 12 Months | Destination | Upon Award | $ - 0 | $ - 0 |
| 1026 | FFP | Diminishing Manufacturing Sources and Material Shortages (DMSMS) | 12 | Months | 12 Months | Destination | Option Year 1 | $ - 0 | $ - 0 |
| 2026 | FFP | Diminishing Manufacturing Sources and Material Shortages (DMSMS) | 12 | Months | 12 Months | Destination | Option Year 2 | $ - 0 | $ - 0 |
| 3026 | FFP | Diminishing Manufacturing Sources and Material Shortages (DMSMS) | 12 | Months | 12 Months | Destination | Option Year 3 | $ - 0 | $ - 0 |
| 4026 | FFP | Diminishing Manufacturing Sources and Material Shortages (DMSMS) | 12 | Months | 12 Months | Destination | Option Year 4 | $ - 0 | $ - 0 |
| 5026 | FFP | Diminishing Manufacturing Sources and Material Shortages (DMSMS) | 6 | Months | 6 Months | Destination | Six Month Option | $ - 0 | $ - 0 |
Mapping Worksheet
| MAPPING WORKSHEET |
| Notes and Instructions: |
| REQUEST THE OFFEROR PROVIDE CONTRACTOR COMPANY EQUIVALENT LABOR TITLES FOR THE FOLLOWING GOVERNMENT DEFINED LABOR CATEGORIES IF LABOR TITLES DIFFER IN CONTRACTOR PROPOSAL |
| Example Duties/Responsibilities | CONTRACTOR EQUIVALENTS | |
| Labor Categories | ||
| Subject Matter Expert | Supports Project Technical Manager in the execution of their duties. Lead highly complex technical studies and analysis efforts. | |
| Program Manager | Responsible for tasks and will be accountable by the government for the technical quality, content, and results of all projects. | |
| Senior Manager | Manages multiple contracts/ projects, ensuring conformance to task specifications and contract provisions. Directs, oversees, and controls a team of multi-disciplined personnel to accomplish the overall management of the contracts. | |
| Project Technical Manager | Accountable to the Program Manager for tasks. Shall serve as a focal point for assigned projects. | |
| Senior Systems Engineer | Supports Project Technical Manager in the execution of their duties. Provides highly technical expertise and guidance in solving complex hardware/software engineering problems. Provides technical leadership of all phases of hardware/software design analysis, development, integration, and implementation. Capable of determining appropriate use of technologies in solving engineering problems. | |
| Systems Engineer | Provides highly technical expertise and guidance in solving complex hardware/software engineering problems. Provides technical support of all phases of hardware/software design analysis, development, integration, and implementation. Capable of determining appropriate use of technologies in solving engineering problems. | |
| Senior Electronic/Electrical Engineer | Senior level engineering services and technical leadership of Electronic/ Electrical Engineering. | |
| Electronic/Electrical Engineer | Electronic/ Electrical Engineering services. | |
| Junior Electronic/Electrical Engineer | Jr. Electronic/Electrical Engineering services. | |
| Senior Software Engineer | Senior level engineering services and technical leadership of Software Engineering. |
| Software Engineer | Software Engineering services. |
| Junior Software Engineer | Jr. Software Engineering services. |
| Senior Systems Analyst | Senior level engineering services and technical |
leadership of software systems analysis or computer systems administration.
| Systems Analyst | Software systems analysis or computer systems administration. |
| Junior Systems Analyst | Jr. Software systems analysis services or computer systems administration. |
| Quality Assurance/Configuration Management Engineer | Maintains/Monitors QA or CM activities throughout lifecycle of projects. |
| Quality Assurance/Configuration Management Analyst | Supports QA or CM activities throughout lifecycle of projects. |
| Senior Logistician | Senior level logistics services and technical leadership of Logistics Functions. |
| Logistician | Logistics services. |
| Senior Test Engineer | Senior level engineering services and technical leadership of Test Engineering. |
| Test Engineer | Test Engineering services. |
| Junior Test Engineer | Jr. Test Engineering services. |
| Senior Engineering Technicians | Complex data collection and preparation necessary to support engineering studies and reports provide help desk support of hardware and software applications, and support of prototype & modification development/installation. |
| Engineering Technicians | Basic data collection and preparation necessary to support engineering studies and reports provide help desk support of hardware and software applications, and support of prototype and modification development/installation. |
| Junior Engineering Technicians | Support data collection and preparation necessary to support engineering studies and reports, provide help desk support of hardware and software applications, and support of prototype and modification development/installation. |
| Senior Drafting/CAD | Complex usage of CAD software in generating detailed engineering drawings necessary to support engineering studies and reports |
| Drafting/CAD | Capable of using CAD software in generating detailed engineering drawings necessary to support engineering studies and reports |
| Junior Drafting/CAD | Support usage of CAD software in generating detailed engineering drawings necessary to support engineering studies and reports |
| Senior Documentation/Technical Writer | Provide Senior level technical writing function for complex engineering specifications, user manuals, monthly reports, engineering studies, publishing, etc. |
| Documentation/Technical Writer | Provide technical writing function for engineering specifications, user manuals, monthly reports, engineering studies, publishing, etc. |
| Junior Documentation/Technical Writer | Provide technical writing support for engineering specifications, user manuals, monthly reports, engineering studies, publishing, etc. |
| Production Engineer | Applies knowledge of design principles to assess and resolve product/process issues through the product lifecycle. Analyzes, conducts root cause analysis and develops dispositions for design non-conformances. Identifies, documents and communicates deviations that could impact design intent and safety. Develops and implements product/process improvements. Provides comprehensive build knowledge of the end product to ensure producibility. Represents the engineering community in the production environment. Develops and implements technical training. |
| Scheduler/Planner | Plans, prepares, issues and controls production schedules and coordinates with material requirements to ensure a controlled flow of approved materials timed to meet production requirements. |
| Test Technician Operator | Sets up test apparatus and conducts tests of production assemblies and units following established methods, procedures, standards, and sequences. |
| Production Test Engineer/Process Control Engineer - Test | Familiar with test equipment design and development. Ability to read and understand technical requirements. Ability to troubleshoot test problems and train test operators. |
| Shipping Specialist | Design safe and reliable shipping containers and manage shipment to defined processes for military and commercial equipment. |
| Supply Technician/Specialist | Performs all aspects of technical supply management work (e.g., inventory management, storage management, cataloging, and property utilization) related to depot, local, or other supply activities. Work usually is segregated by commodity area or function, and controlled in terms of difficulty, complexity, or responsibility. Assignments usually relate to stable or standardized segments of technical supply management operations; or to functions or subjects that are narrow in scope or limited in difficulty. Assignments require: |
(a) a good working knowledge of the governing supply systems, programs, policies, nomenclature, work methods, manuals, or other established guidelines; (b) an understanding of the needs of the organization serviced; and (c) analytical ability to define or recognize the dimension of the problems involved, to collect the necessary data to establish the facts, and take or recommend action based upon application or interpretation of established guidelines.
Production Program Financial Manager Develops, analyzes, reviews and maintains resource forecasts and/or Estimates at Completion (EACs) at the control account, budget, function or pool level (financial operations); financial statements forecasts and/or financial EACs at the contract, program, business unit or enterprise level (financial planning). Develops performance reports and initiates variance analyses to provide understanding of operational and financial performance. Develops and maintains cost and/or schedule performance measurement baselines, including earned value (financial operations). Analyzes business opportunities by assimilating strategic plans (financial planning) and business cases. Analyzes external financial statements results and projections to provide visibility of financial performance to internal/external stakeholders (financial planning).
File details come from the government source that posted it. Updated .