P1 Pricing Workbook.xlsx
XLSX spreadsheet 51 KB Posted
- Solicitation number
- FA825124RB001
About this file
This document is a pricing workbook (Attachment P1) for a federal contract opportunity. It provides instructions and templates for offerors to submit pricing information for a variety of labor categories, including fully burdened and direct labor and fringe rates for both government and contractor sites. The document also includes a labor category mapping table that maps government labor categories to contractor labor categories.
The related federal contract opportunity is for "Avionics Intermediate Shop Product Support Integration" activities to be provided for the 416 Supply Chain Management Squadron (416 SCMS) at Hill Air Force Base. The contractor will be a systems integrator providing a single-point solution for F-16 Avionics Intermediate Shop (AIS) Automatic Test System (ATS) requirements. The performance period is 12 months. The solicitation number is FA825124RB001, and the question and answer period will end on October 1, 2024, with answers posted by October 4, 2024. The procuring agency is the Department of the Air Force Materiel Command Air Force Sustainment Center.
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
General Instructions
| 1. This workbook is attachment P1 |
| 2. Offeror shall complete each sheet of this pricing workbook |
| 3. The data in this workbook that has been populated by the Government shall not be changed |
| 4. The base labor rate shall be exclusive of any fringe or burden. Fringe shall include any hourly benefits. Burdened rates shall be fully-burdened and include all fringe indirect labor overhead, general and admininstrative (G&A), facilities capital cost of money (FCCM), profit, etc. |
Government Site
| Government Site Fully Burdened Rates | ||||||||||||||
| Number | Labor Category | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035 | 2036 |
| 1 | Program Specialist I | |||||||||||||
| 2 | Program Specialist II | |||||||||||||
| 3 | Program Specialist III | |||||||||||||
| 4 | Junior Program Analyst | |||||||||||||
| 5 | *Intermediate Program Analyst | |||||||||||||
| 6 | *Senior Program Analyst | |||||||||||||
| 7 | Executive Program Analyst | |||||||||||||
| 8 | Operations/Research Analyst | |||||||||||||
| 9 | ILS Manager | |||||||||||||
| 10 | Quality Assurance Technician | |||||||||||||
| 11 | Quality Assurance Manager | |||||||||||||
| 12 | *Senior Program Manager | |||||||||||||
| 13 | Logistician | |||||||||||||
| 14 | Senior Logistician | |||||||||||||
| 15 | Administrative I | |||||||||||||
| 16 | Administrative II | |||||||||||||
| 17 | *Junior Equipment Specialist | |||||||||||||
| 18 | *Intermediate Equipment Specialist | |||||||||||||
| 19 | *Senior Equipment Specialist | |||||||||||||
| 20 | *Junior General Engineer | |||||||||||||
| 21 | *Intermediate General Engineer | |||||||||||||
| 22 | Senior General Engineer |
| Instructions for Completing the Worksheet | |
| Fill in the fully burdened labor rate for employees that will be working primiarly at a Government owned facility. | |
| * Indicates Key Personnel on all sheets in the workbook |
Govt_Site Direct Labor & Fringe
| Government Site Direct Labor and Fringe Rates | |||||||||||||||||||||||||||
| Number | Labor Category | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035 | 2036 | |||||||||||||
| Direct Labor | Fringe | Direct Labor | Fringe | Direct Labor | Fringe | Direct Labor | Fringe | Direct Labor | Fringe | Direct Labor | Fringe | Direct Labor | Fringe | Direct Labor | Fringe | Direct Labor | Fringe | Direct Labor | Fringe | Direct Labor | Fringe | Direct Labor | Fringe | Direct Labor | Fringe | ||
| 1 | Program Specialist I | ||||||||||||||||||||||||||
| 2 | Program Specialist II | ||||||||||||||||||||||||||
| 3 | Program Specialist III | ||||||||||||||||||||||||||
| 4 | Junior Program Analyst | ||||||||||||||||||||||||||
| 5 | *Intermediate Program Analyst | ||||||||||||||||||||||||||
| 6 | *Senior Program Analyst | ||||||||||||||||||||||||||
| 7 | Executive Program Analyst | ||||||||||||||||||||||||||
| 8 | Operations/Research Analyst | ||||||||||||||||||||||||||
| 9 | ILS Manager | ||||||||||||||||||||||||||
| 10 | Quality Assurance Technician | ||||||||||||||||||||||||||
| 11 | Quality Assurance Manager | ||||||||||||||||||||||||||
| 12 | *Senior Program Manager | ||||||||||||||||||||||||||
| 13 | Logistician | ||||||||||||||||||||||||||
| 14 | Senior Logistician | ||||||||||||||||||||||||||
| 15 | Administrative I | ||||||||||||||||||||||||||
| 16 | Administrative II | ||||||||||||||||||||||||||
| 17 | *Junior Equipment Specialist | ||||||||||||||||||||||||||
| 18 | *Intermediate Equipment Specialist | ||||||||||||||||||||||||||
| 19 | *Senior Equipment Specialist | ||||||||||||||||||||||||||
| 20 | *Junior General Engineer | ||||||||||||||||||||||||||
| 21 | *Intermediate General Engineer | ||||||||||||||||||||||||||
| 22 | Senior General Engineer |
| Instructions for Completing the Worksheet |
| Fill in the direct labor and fringe rate for employees that will be working primiarly at a Government owned facility. |
Contractor Site
| Contractor Site Fully Burdened Rates | ||||||||||||||
| Number | Labor Category | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035 | 2036 |
| 1 | Program Specialist I | |||||||||||||
| 2 | Program Specialist II | |||||||||||||
| 3 | Program Specialist III | |||||||||||||
| 4 | Junior Program Analyst | |||||||||||||
| 5 | *Intermediate Program Analyst | |||||||||||||
| 6 | *Senior Program Analyst | |||||||||||||
| 7 | Executive Program Analyst | |||||||||||||
| 8 | Operations/Research Analyst | |||||||||||||
| 9 | ILS Manager | |||||||||||||
| 10 | Quality Assurance Technician | |||||||||||||
| 11 | Quality Assurance Manager | |||||||||||||
| 12 | *Senior Program Manager | |||||||||||||
| 13 | Logistician | |||||||||||||
| 14 | Senior Logistician | |||||||||||||
| 15 | Administrative I | |||||||||||||
| 16 | Administrative II | |||||||||||||
| 17 | *Junior Equipment Specialist | |||||||||||||
| 18 | *Intermediate Equipment Specialist | |||||||||||||
| 19 | *Senior Equipment Specialist | |||||||||||||
| 20 | *Junior General Engineer | |||||||||||||
| 21 | *Intermediate General Engineer | |||||||||||||
| 22 | Senior General Engineer |
| Instructions for Completing the Worksheet |
| Fill in the fully burdened labor rate for employees that will be working primiarly at a contractor owned facility. |
Cont_Site Direct Labor & Fringe
| Contractor Site Direct Labor and Fringe Rates | |||||||||||||||||||||||||||
| Number | Labor Category | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035 | 2036 | |||||||||||||
| Direct Labor | Fringe | Direct Labor | Fringe | Direct Labor | Fringe | Direct Labor | Fringe | Direct Labor | Fringe | Direct Labor | Fringe | Direct Labor | Fringe | Direct Labor | Fringe | Direct Labor | Fringe | Direct Labor | Fringe | Direct Labor | Fringe | Direct Labor | Fringe | Direct Labor | Fringe | ||
| 1 | Program Specialist I | ||||||||||||||||||||||||||
| 2 | Program Specialist II | ||||||||||||||||||||||||||
| 3 | Program Specialist III | ||||||||||||||||||||||||||
| 4 | Junior Program Analyst | ||||||||||||||||||||||||||
| 5 | *Intermediate Program Analyst | ||||||||||||||||||||||||||
| 6 | *Senior Program Analyst | ||||||||||||||||||||||||||
| 7 | Executive Program Analyst | ||||||||||||||||||||||||||
| 8 | Operations/Research Analyst | ||||||||||||||||||||||||||
| 9 | ILS Manager | ||||||||||||||||||||||||||
| 10 | Quality Assurance Technician | ||||||||||||||||||||||||||
| 11 | Quality Assurance Manager | ||||||||||||||||||||||||||
| 12 | *Senior Program Manager | ||||||||||||||||||||||||||
| 13 | Logistician | ||||||||||||||||||||||||||
| 14 | Senior Logistician | ||||||||||||||||||||||||||
| 15 | Administrative I | ||||||||||||||||||||||||||
| 16 | Administrative II | ||||||||||||||||||||||||||
| 17 | *Junior Equipment Specialist | ||||||||||||||||||||||||||
| 18 | *Intermediate Equipment Specialist | ||||||||||||||||||||||||||
| 19 | *Senior Equipment Specialist | ||||||||||||||||||||||||||
| 20 | *Junior General Engineer | ||||||||||||||||||||||||||
| 21 | *Intermediate General Engineer | ||||||||||||||||||||||||||
| 22 | Senior General Engineer |
| Instructions for Completing the Worksheet |
| Fill in the direct labor and fringe rate for employees that will be working primiarly at a contractor owned facility. |
Labor Category Mapping Labor Category Mapping
| Instructions for Completing the Worksheet |
| Fill in the ORANGE cells. Do not adjust or make changes to the worksheet. |
| GOVERNMENT | CONTRACTOR | ||||||||||
| Number | Government Labor Category | Education Level | Minimum Experience | Substitutions | Work Description | Contractor Labor Category | Job Code | Education Level | Minimum Experience | Substitutions | Work Description |
| 1 | Program Specialist I | Bachelor’s degree or five (5) years of related experience. | Providing program management support to program management and engineering staff. Support includes project scheduling, financial management, briefing, coordination and graphic presentation. | ||||||||
| 2 | Program Specialist II | Bachelor’s degree or ten (10) years of related experience. | 10 years military service can be substituted as related experience. | Providing program management support to program management and engineering staff. Support includes project scheduling, financial management, briefing, coordination and graphic presentation. | |||||||
| 3 | Program Specialist III | Bachelor’s degree or fifteen (15) years of related experience. | 15 years military service can be substituted as related experience. | Providing program management support to program management and engineering staff. Support includes project scheduling, financial management, briefing, coordination and graphic presentation. | |||||||
| 4 | Junior Program Analyst | Bachelor’s degree | Three (3) years’ experience managing government programs is required. | Four (4) additional years of related experience will substitute for Bachelor’s degree. | Providing technical program management, budgeting, scheduling, performance trades, lifecycle costing, risk management, supportability, test and evaluation, and requirements development and management. Presentation and briefing skills required. | ||||||
| 5 | *Intermediate Program Analyst | Bachelor’s degree | Seven (7) years’ experience managing government programs is required. | Four (4) additional years of related experience will substitute for Bachelor’s degree. | Providing technical program management, budgeting, scheduling, performance trades, lifecycle costing, risk management, supportability, test and evaluation, and requirements development and management. Presentation and briefing skills required. | ||||||
| 6 | *Senior Program Analyst | Bachelor’s degree | Twelve (12) years’ experience managing government | Four (4) additional years of related experience | Providing technical program management, budgeting, scheduling, performance trades, lifecycle costing, risk management, supportability, | ||||||
| 7 | Executive Program Analyst | Bachelor’s degree | Twenty (20) years’ experience managing government programs is required. | Four (4) additional years of related experience will substitute for Bachelor’s degree. | Providing technical program management, budgeting, scheduling, performance trades, lifecycle costing, risk management, supportability, test and evaluation, and requirements development and management. Presentation and briefing skills required. | ||||||
| 8 | Operations/Research Analyst | Bachelor’s degree | Ten (10) years | Four (4) additional years of related experience will substitute for Bachelor’s degree. | Managing and directing the analyses of management problems, performing cost analyses and modeling, providing information requirements, and the formulating of scientific solutions as directed. | ||||||
| 9 | ILS Manager | Bachelor’s degree | Ten (10) years | Four (4) additional years of related experience will substitute for Bachelor’s degree. | Providing ILS administration, including supply, purchasing, provisioning, design, reliability, validation, and maintainability analysis of complex mechanical or electro-mechanical systems/equipment per DOD requirements. | ||||||
| 10 | Quality Assurance Technician | Bachelor’s degree | Five (5) years | Four (4) additional years of related experience will substitute | Providing quality oversight of MIL-Q-9858A, MIL-I-45208, or |
ISO-9000 environments to include technical review of written material and assessments of conformance to policies.
11 Quality Assurance Manager Bachelor’s degree Twelve (12) years Four (4) additional years of related experience will substitute for Bachelor’s degree. Providing quality oversight of MIL-Q-9858A, MIL-I-45208, or ISO-9000 environments to include technical review of written material and assessments of conformance to policies.
| 12 | *Senior Program Manager | Bachelor’s degree | Twelve (12) years | Four (4) additional years of related experience will substitute for Bachelor’s degree. | Organizing, directing, and coordinating the planning and implementation of all contract support activities; interfacing with government personnel; formulating and reviewing project feasibility studies, determining costs, ensuring conformance to work standards; interpreting policies, purposes, and goals of the organization for subordinates; managing logistics support analysis for military systems; managing system safety studies; and identifying, acquiring, and using company resources to achieve program technical objectives. |
| 13 | Logistician | Bachelor’s degree | Five (5) years | Four (4) additional years of related experience will substitute for Bachelor’s degree. | Performing logistic program activities from conceptual stage through life cycle of product. |
Developing and implementing logistics program activities including ILS, technical documentation, RAM, provisioning, etc.; resolving logistics problems; and compiling data on standardization and interchangeability of parts to expedite logistic activities.
14 Senior Logistician Bachelor’s degree Twelve (12) years Four (4) additional years of related experience will substitute for Bachelor’s degree. Performing logistic program activities from conceptual stage through life cycle of product.
Developing and implementing logistics program activities including ILS, technical documentation, RAM, provisioning, etc.; resolving logistics problems; and compiling data on standardization and interchangeability of parts to expedite logistic activities.
15 Administrative I High School Diploma One (1) year Administrative/technical work in management environment.
Personal knowledge of e-mail, word processing, and spreadsheet software. Uses common office equipment, e.g., facsimile (fax) machines, copiers, projectors, and PC printers. Performs administrative/technical support as directed with continual supervision. Applies skills and knowledge in data management, document control, computer support, project control, and related areas to individual and team efforts.
16 Administrative II High School Diploma Seven (7) years Administrative/technical work in management environment.
Personal knowledge of e-mail, word processing, and spreadsheet software. Uses common office equipment, e.g., facsimile (fax) machines, copiers, projectors, and PC printers. Performs high quality project support. Will interface with most levels of government personnel. Handles confidential information. Maintains logs, records, archives and/or working files. Given minimum instruction and supervision, handles correspondence, prepares reports, arranges meetings, and/or travel arrangements.
| 17 | *Junior Equipment Specialist | High School Diploma | Two (2) years | Providing technical analysis of assigned equipment or processes; formulation of recommendations for improving technical processes or procedures; drafting of technical procedures; and identifying solutions to technical issues impacting equipment functionality. | |
| 18 | *Intermediate Equipment Specialist | Bachelor’s degree | Seven (7) years | Four (4) additional years of related experience will substitute for Bachelor’s degree. | Providing technical analysis of assigned equipment or processes; formulation of recommendations for improving technical processes or procedures; drafting of technical procedures; and identifying solutions to technical issues impacting equipment functionality. |
| 19 | *Senior Equipment Specialist | Bachelor’s degree | Twelve (12) years | Four (4) additional | Providing technical analysis of assigned equipment or processes; formulation of recommendations for improving technical processes or procedures; drafting of technical procedures; and identifying solutions to technical issues impacting equipment functionality. |
| 20 | *Junior General Engineer | Bachelor’s degree in Electrical, Mechanical, or Aeronautical Engineering | Four (4) Years | Uses technical background and skills to perform in all phases of hardware design, development, and documentation. Performs fundamental engineering duties and assists senior engineers in formulating preliminary designs, performing tests, taking measurements, and performing system analyses or simulations. Applies standard practices and techniques in specific engineering assignments. |
Assists in preparation of data and documentation.
21 *Intermediate General Engineer Bachelor’s degree in Electrical, Mechanical, or Aeronautical Engineering Seven (7) years Performs system conceptualization, system level requirements definition, and system test and evaluation.
Must be familiar with probability, reliability, statistical analysis methods, sampling and test and evaluation techniques, data collection, and applicable regulations and standards.
22 Senior General Engineer Bachelor’s degree in Electrical, Mechanical, or Aeronautical Engineering Twelve (12) years Performs system conceptualization, system level requirements definition, and system test and evaluation. Must be familiar with probability, reliability, statistical analysis methods, sampling and test and evaluation techniques, data collection, and applicable regulations and standards.
Representative Task One USAF Requirement Title
| Period Of Performance in Months | |||||
| 01-60 | |||||
| Line Item | Labor Category | Hours/Year | Rate-Year | Material Burden | Total Price |
Value for Total Evaluated Price Government use Only
| Instructions for Completing the Worksheet |
| 1. In the line item column insert the appropriate line item from the solicitation document based upon who is performing the work, prime or subcontractor. |
| 2. In the labor category column insert the labor category your company is assigning as the most appropriate for the work described in the proposal. |
| 3. In the Hours/Year column insert the number of hours your company is proposing for that labor category for the period of performance. |
| 4. In the Rate-Year column insert the rate for the year the hours are proposed. If the rate year changes more than one row will need to be used for the proposed labor category. |
| 5. In the material burden percentage column insert yes if the the material burden percentage is applicable for the year proposed or no if not applicable for the year proposed. If the material burden percentage is applicable the Government will insert the average material burden based on the average of all material burden rates from the material burden amounts proposed in the material burden worksheet. |
| 6. In the Total Price column insert the product of the hours/year cell and the rate-year cell. Travel needs to be proposed for technical evaluation purposes but will be excluded from the TEP. |
Representative Task Two FMS Requirement Title
| Period Of Performance in Months | |||||
| 01-60 | |||||
| Line Item | Labor Category | Hours-Year | Rate-Year | Material Burden | Total Price |
Value for Total Evaluated Price Government use Only
| Instructions for Completing the Worksheet |
| 1. In the line item column insert the appropriate line item from the solicitation document based upon who is performing the work, prime or subcontractor. |
| 2. In the labor category column insert the labor category your company is assigning as the most appropriate for the work described in the proposal. |
| 3. In the Hours/Year column insert the number of hours your company is proposing for that labor category for the period of performance. |
| 4. In the Rate-Year column insert the rate for the year the hours are proposed. If the rate year changes more than one row will need to be used for the proposed labor category. |
| 5. In the material burden percentage column insert yes if the the material burden percentage is applicable for the year proposed or no if not applicable for the year proposed. If the material burden percentage is applicable the Government will insert the average material burden based on the average of all material burden rates from the material burden amounts proposed in the material burden worksheet. |
| 6. In the Total Price column insert the product of the hours/year cell and the rate-year cell. Travel needs to be proposed for technical evaluation purposes but will be excluded from the TEP. |
Representat Task Three 416 SCMS Requirement Title
| Period Of Performance in Months | ||||||||||||||||
| 12 | ||||||||||||||||
| Line Item | Labor Category | Hours-Year | Not Less than BaseRate | Rate-Year 2025 | Rate-Year 2026 | Rate-Year 2027 | Rate-Year 2028 | Rate-Year 2029 | Rate-Year 2030 | Rate-Year 2031 | Rate-Year 2032 | Rate-Year 2033 | Rate-Year 2034 | Rate-Year 2035 | Material Burden | Total Price |
Value for Total Evaluated Price Government use Only
| Instructions for Completing the Worksheet |
| 1. In the line item column insert the appropriate line item from the solicitation document based upon who is performing the work, prime or subcontractor. |
| 2. In the labor category column insert the labor category your company is assigning as the most appropriate for the work described in the proposal. |
| 3. In the Hours/Year column insert the number of hours your company is proposing for that labor category for the period of performance. |
| 4. In the Rate-Year column insert the rate for the year the hours are proposed. If the rate year changes more than one row will need to be used for the proposed labor category. |
| 5. In the material burden percentage column insert yes if the the material burden percentage is applicable for the year proposed or no if not applicable for the year proposed. |
| 6. In the Total Price column insert the product of the hours/year cell and the rate-year cell. Travel needs to be proposed for technical evaluation purposes but will be excluded from the TEP. |
Material Burden
| Material Burden | ||||||||||||
| 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035 | 2036 |
| Instructions for Completing the Worksheet |
| Enter the material burden rate that will be applied to all material and subcontracting throughout the life of the basic contract |
| Material Burden Average for all proposed years. |
File details come from the government source that posted it. Updated .