pricingworkbook.xlsx
XLSX spreadsheet 30 KB Posted
- Attached to
- Professional, Administrative and Management Support Services Federal contract opportunity
- Solicitation number
- FA8217-12-R-5006
About this file
Pricing Workbook dated 18 Jan 2012
View the file
Other files for this federal contract opportunity
Show all 49
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
TEP Worksheet
| ATTACHMENT 6 (TEP Worksheet) dated 18 Jan 2012 | ||||||
| The Contractor shall not change any row or column information and shall fill-in the following CLINs information as shown below: | ||||||
| CLIN X001- FFP for CLS (Service Tier Pricing Table- 2nd tab) | ||||||
| CLIN X002- FFP for CDRLS (TEP Worksheet- 1st tab) | ||||||
| CLIN X003- Fully burdened rates (Fixed Rates Table- 3rd tab), which shall include incidental material (including data); shipping; and indirect costs associated with travel, materials, and shipping in accordance with solicitation instructions. | ||||||
| CLIN X004- FFP for Transition (TEP Worksheet- 1st tab) | ||||||
| The Government will calculate CLIN entries to determine the Total Evaluated Price | ||||||
| CLIN | TYPE | DESCRIPTION | QTY | U/I | Unit Price | EXT TOTAL |
| BASIC YEAR | ||||||
| 0001 | FFP | Contractor Logistics Support - Program Management, Logistics Support, and Computer Resource Support - Contractor shall provide labor, materials, travel, and shipping necessary to plan, manage, and execute the Program Management, Logistics Support, and Computer Resource Support requirements in accordance with the Performance Work Statement (PWS). Service Tier: Price Per Month: | 11 | MO | $0.00 | $0.00 |
| 0002 | FFP | Contract Data Requirements List (CDRLs) (PWS Para 6.0) | 11 | MO | $0.00 | $0.00 |
| 0003 | FFP | Special Projects/ Engineering Change Proposals/Contract Change Proposals - The Contractor shall provide labor, materials, travel, and shipping neceesary to perform special projects, ECPs, or CCPs (PWS para 4.12, 4.12.1) as directed by the PCO to support the AN/FMQ-19 Weather Systems. Each special project will be funded individually. | 1 | LO | $0.00 | $0.00 |
| 0004 | FFP | Transition - The contractor shall provide labor, materials, travel, and shipping necessary to transition the FMQ-19 AMS in accordance with the PWS requirements (PWS para 3.7). | 1 | LO | $0.00 | $0.00 |
| BASIC YEAR TOTAL | $0.00 | |||||
| OPTION YEAR 1 | ||||||
| 1001 | FFP | Contractor Logistics Support - Program Management, Logistics Support, and Computer Resource Support - Contractor shall provide labor, materials, travel, and shipping necessary to plan, manage, and execute the Program Management, Logistics Support, and Computer Resource Support requirements in accordance with the Performance Work Statement (PWS). Service Tier: Price Per Month: | 12 | MO | $0.00 | $0.00 |
| 1002 | FFP | Contract Data Requirements List (CDRLs) (PWS Para 6.0) | 12 | MO | $0.00 | $0.00 |
| 1003 | FFP | Special Projects/ Engineering Change Proposals/Contract Change Proposals - The Contractor shall provide labor, materials, travel, and shipping neceesary to perform special projects, ECPs, or CCPs (PWS para 4.12, 4.12.1) as directed by the PCO to support the AN/FMQ-19 Weather Systems. Each special project will be funded individually. | 1 | LO | $0.00 | $0.00 |
| OPTION YEAR 1 TOTAL | $0.00 | |||||
| OPTION YEAR 2 | ||||||
| 2001 | FFP | Contractor Logistics Support - Program Management, Logistics Support, and Computer Resource Support - Contractor shall provide labor, materials, travel, and shipping necessary to plan, manage, and execute the Program Management, Logistics Support, and Computer Resource Support requirements in accordance with the Performance Work Statement (PWS). Service Tier: Price Per Month: | 12 | MO | $0.00 | $0.00 |
| 2002 | FFP | Contract Data Requirements List (CDRLs) (PWS Para 6.0) | 12 | MO | $0.00 | $0.00 |
| 2003 | FFP | Special Projects/ Engineering Change Proposals/Contract Change Proposals - The Contractor shall provide labor, materials, travel, and shipping neceesary to perform special projects, ECPs, or CCPs (PWS para 4.12, 4.12.1) as directed by the PCO to support the AN/FMQ-19 Weather Systems. Each special project will be funded individually. | 1 | LO | $0.00 | $0.00 |
| OPTION YEAR 2 TOTAL | $0.00 | |||||
| OPTION YEAR 3 | ||||||
| 3001 | FFP | Contractor Logistics Support - Program Management, Logistics Support, and Computer Resource Support - Contractor shall provide labor, materials, travel, and shipping necessary to plan, manage, and execute the Program Management, Logistics Support, and Computer Resource Support requirements in accordance with the Performance Work Statement (PWS). Service Tier: Price Per Month: | 12 | MO | $0.00 | $0.00 |
| 3002 | FFP | Contract Data Requirements List (CDRLs) (PWS Para 6.0) | 12 | MO | $0.00 | $0.00 |
| 3003 | FFP | Special Projects/ Engineering Change Proposals/Contract Change Proposals - The Contractor shall provide labor, materials, travel, and shipping neceesary to perform special projects, ECPs, or CCPs (PWS para 4.12, 4.12.1) as directed by the PCO to support the AN/FMQ-19 Weather Systems. Each special project will be funded individually. | 1 | LO | $0.00 | $0.00 |
| OPTION YEAR 3 TOTAL | $0.00 | |||||
| OPTION YEAR 4 | ||||||
| 4001 | FFP | Contractor Logistics Support - Program Management, Logistics Support, and Computer Resource Support - Contractor shall provide labor, materials, travel, and shipping necessary to plan, manage, and execute the Program Management, Logistics Support, and Computer Resource Support requirements in accordance with the Performance Work Statement (PWS). Service Tier: Price Per Month: | 12 | MO | $0.00 | $0.00 |
| 4002 | NSP | Contract Data Requirements List (CDRLs) (PWS Para 6.0) | 12 | MO | $0.00 | $0.00 |
| 4003 | FFP | Special Projects/ Engineering Change Proposals/Contract Change Proposals - The Contractor shall provide labor, materials, travel, and shipping neceesary to perform special projects, ECPs, or CCPs (PWS para 4.12, 4.12.1) as directed by the PCO to support the AN/FMQ-19 Weather Systems. Each special project will be funded individually. | 1 | LO | $0.00 | $0.00 |
| OPTION YEAR 4 TOTAL | $0.00 | |||||
| 52.217-8 Option to Extend Services | ||||||
| 5001 | FFP | Contractor Logistics Support - Program Management, Logistics Support, and Computer Resource Support - Contractor shall provide labor, materials, travel, and shipping necessary to plan, manage, and execute the Program Management, Logistics Support, and Computer Resource Support requirements in accordance with the Performance Work Statement (PWS). Service Tier: Price Per Month: | 6 | MO | $0.00 | $0.00 |
| 5002 | FFP | Contract Data Requirements List (CDRLs) (PWS Para 6.0) | 6 | MO | $0.00 | $0.00 |
| 5003 | FFP | Special Projects/ Engineering Change Proposals/Contract Change Proposals - The Contractor shall provide labor, materials, travel, and shipping neceesary to perform special projects, ECPs, or CCPs (PWS para 4.12, 4.12.1) as directed by the PCO to support the AN/FMQ-19 Weather Systems. Each special project will be funded individually. | 1 | LO | $0.00 | $0.00 |
| Option to Extend Services TOTAL | $0.00 | |||||
| TOTAL EVALUATED PRICE (TEP) | $0.00 |
Service Tier Pricing CLIN X001
| CLIN X001 Contractor Logistics Support (CLS) Pricing Table | ||||||||||||
| Offeror's shall insert their fully burdened CLS Rate to accomplish | ||||||||||||
| requirements as stated in the PWS. The Government will evaluate | ||||||||||||
| (for the purpose of the Total Evalauted Price (TEP)) a notional Service | ||||||||||||
| Tier (not disclosed to Offerors, but will be the same for all | ||||||||||||
| offerors). The notional tiered monthly price will be multiplied by | ||||||||||||
| a notional quantity of months (again, not disclosed to the Offerors, | ||||||||||||
| but the same for all offerors). The toal price will be input into the TEP | ||||||||||||
| worksheet in the appropriate CLIN cell and added into the TEP apprpriately. | ||||||||||||
| (2017 is also expected to be used for CLIN 5001) | ||||||||||||
| CLIN 0001 | CLIN 1001 | CLIN 2001 | CLIN 3001 | CLIN 4001 | CLIN 5001 | |||||||
| PWS 4.1 | Unit of Issue | MO Price | Unit of Issue | MO Price | Unit of Issue | MO Price | Unit of Issue | MO Price | Unit of Issue | MO Price | Unit of Issue | MO Price |
| TIER A | MO | $0 | MO | $0 | MO | $0 | MO | $0 | MO | $0 | MO | $0 |
| TIER B | MO | $0 | MO | $0 | MO | $0 | MO | $0 | MO | $0 | MO | $0 |
Fixed Rates Table CLIN X003
| FMQ-19 Engineering Change Proposal (ECP)/Special Projects Pricing Worksheet for CLIN X003 |
| 1. Do not add labor categories or change worksheet columns/rows. |
| 2. All labor categories for all years shall be filled in. |
| 3. Do not extend labor hour rates beyond two decimial places. |
| 4. Do not rename worksheet tabs. |
| 5. The fixed rates are to be fully burdened to include all incidental material (including data), shipping, and indirect costs associated with travel/materials/shipping. |
| 6. The fixed rates shall be utilized to propose future modifications. (ECPs/Special Projects) |
| 7. Additional labor categories and rates may be negotiated at time of task order at the Government’s discretion |
| FMQ-19 Contractor Logistics Support | LABOR RATES | |||||
| LABOR CATEGORIES | CLIN 0003 | CLIN 1003 | CLIN 2003 | CLIN 3003 | CLIN 4003 | CLIN 5003 |
| Program Manager | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Configuration Manager | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Logistics Support Manager | $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 |
| Hardware 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 |
| Senior Applications Engineer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Applications 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 |
| Information Assurance Specialist | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Contracts Manager | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Finance Manager | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Procurement Analyst | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Material/Packaging Technician | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Shipping/Receving Technician | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Quality Assurance Specialist | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Data Entry Technician | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Training Specialist | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Technical Orders Writer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Technician | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
Labor Cat Definitions
| The contractor shall employ qualified personnel according to the categories listed in the following table to support modification tasks under this contract. Employees must meet 29CFR541 requirements in addition to our description requirements in the below table. |
| Waivers: Waivers can be considered on a case by case basis. The Government Program Office retains sole decision authority. |
| Skill | SCA Code or Exempt Category | Min. Experience/No. of Yrs | Duties/Responsibilities |
| Program Manager | Administrative | 10 yrs experience in direct Program Management | Responsible 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 / Documentation | Administrative | 7yrs 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 Mgr | 21030 | N/A | Provides logistics support services and technical leadership of Logistics Functions. Material Expediter. |
| Systems Engineer | Professional | 3 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 Engineer | Professional | 0 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 Engineer | Professional | 7yrs 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 Engineer | Professional | 0 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. |
| Senior Applications Engineer | Professional | 7yrs 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 systems analysis or computer systems administration. |
| Applications Engineer | Professional | 3 years of directly related experience (2yrs with an MS Degree) | Engineering services and technical leadership of software systems analysis or computer systems administration. |
| Test Engineer | Professional | 3yrs of directly related experience | Test Engineering services. |
| Information Assurance Specialist | Administrative | 3 years of directly related experience (2yrs with an 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 Manager | Administrative | 7 years progressive experience in managing the contracting procurement process | Negotiates 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 Manager | Professional | 10 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 | 01013 | N/A | Responsible 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 Specialist | 01270 | N/A | Maintains / monitors QA or CM activities throughout lifecycle of projects. Production Control Clerk. |
| Material/Packaging Technician | 21110 | N/A | Responsible for all packaging of material. Shipping Packer. |
| Shipping/Receiving Technician | 21130 | N/A | Responsible for all shipping and receiving of material. Shipping/Receiving clerk. |
| Data Entry Technician | 01051 | N/A | Responsible for data entry. |
| Training Specialist | 15090 | N/A | Responsible to provide training to sites. Technical Instructor. |
| Technical Writer | 30462 | N/A | Provide technical writing function for engineering specifications, user manuals, monthly reports, engineering studies, publishing, etc. |
| Technician | 23182 | N/A | Responsible 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. |
&"-,Bold"&16Labor Categories
Labor Category Definitions
File details come from the government source that posted it. Updated .