Attachment 5 - Pricing Workbook_11 9 2020.xlsx
XLSX spreadsheet 30 KB Posted
- Attached to
- Cyber Capability Development Integration Directorate (CDID) MA IDIQ Federal contract opportunity
- Solicitation number
- W9124921R0001
About this file
This document contains a pricing workbook and instructions for a solicitation seeking proposals for cyber capability development integration services. Offerors are required to submit pricing for fixed-price labor, travel costs, other direct costs, and reporting using the provided spreadsheets. Labor categories, rates, and hours are to be detailed for a base period of five years. Professional employee categories require total compensation plans. The solicitation number is W9124921R0001 and was issued by the Department of the Army Materiel Command Mission and Installation Contracting Command at Fort Eustis for the Cyber Capability Development Integration Directorate multiple-award IDIQ. Proposals were due by November 18, 2020.
View the file
Other files for this federal contract opportunity
Show all 16
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
Instructions
INSTRUCTIONS
General: Each offeror is to provide a price proposal and accompanying narrative as part of its proposal in response to the solicitation. FAR 15.403-5(b) allows the contracting officer to specify the format of cost or pricing data or data other than certified cost or pricing data. The completed enclosed spreadsheets shall be part of the price proposal. This is a required flow down requirement, and therefore shall be submitted for the prime offeror AND for any subcontractors/teaming partners proposed to perform effort in response to this solicitation. The proposed costs and prices will be evaluated for completeness, fairness, and reasonableness based on the price analysis criteria in FAR 15.404-1. For proprietary reasons, subcontractors may provide this information directly to the Contracting Officer if the subcontractor chooses not to disclose this information to the offeror. However, the total proposed price shall be reflected in the Prime's offer.
Section B Worksheet: The Section B worksheet is used as a basis for the proposed Section B.
Fixed Price Labor Detail Worksheet:
General: It may be necessary for Offerors to revise the number of rows, columns, and/or formulas to reflect differences or nuances in the offeror's accounting and estimating systems. However, it is requested that the general format be maintained as much as possible for price analysis and contract administration purposes. Formulas may be adjusted to accommodate variances in accounting system. All data must be included and may not be linked to data not provided in the workbook.
NOTE 1: The Government has identified specific labor categories it deems as a Professional Employee. These labor categories are marked in the Fixed Price Labor tab with a bolded (PE). These labor categories require a Total Compensation Plan as required by the solicitation and FAR provision 52.222-46. For proprietary reasons, subcontractors may provide this information directly to the Contracting Officer if the subcontractor chooses not to disclose this information to the offeror. However, the total proposed price shall be reflected in the Prime's offer.
NOTE 2: Please specify whether the Offeror has deemed a specific labor category to fall under the Service Contract Labor Standards by stating 'SCLS' and providing the selected SCLS occupation code in the applicable columns. For labor categories the Government has deemed to be Professional Employees, a Bureau of Labor Statistics Occupation Code shall be provided. These labor categories have already been entered as 'BLS' in the applicable column. If a labor category does not fall under either category, please insert an 'NA' in the SCLS/BLS column.
NOTE 3: Complete all columns for all labor categories, regardless of SCLS or Professional Employee status. For any labor categories deemed as SCLS, the direct rate, fringe benefit detail, and other information will be used to validate SCLS rate requirements (e.g.: health and wellness requirements) and may be used for future REAs were an increase in labor rate be required. Once all information has been provided, enter the total billabable labor rate for the listed labor categories and calculate the total value for each labor category for each year using the estimated hours provided. A total evaluated price is located at the bottom that shall be a sum total of all labor categories for all 5 years with the specified number of hours.
NOTE 4: The Service Contract Reporting requirement at CLIN 0004 shall not be priced at the IDIQ level. This reporting requirement shall be priced at the TO level.
Section B
| Labor - Price Detail Spreadsheet |
| Solicitation # W9124921R0001 |
| Prime Contractor: |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT |
| 0001 | Labor - Years 1-5 | 1.00 | Job | $ - 0 | |
| FFP | Total Price = |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT |
| 0002 | Travel - Years 1 - 5 | 1.00 | Job | $ - 0 | |
| Cost | Total Cost = | $ 9,550,000 |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT |
| 0003 | Other Direct Costs (ODCs) - Years 1 - 5 | 1.00 | Job | $ - 0 | |
| Cost | Total Cost = | $ 10,000,000 |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT |
| 0004 | Service Contract Reporting | 1.00 | Job | $ - 0 | PRICED AT TO |
| FFP | Total Price = | PRICED AT TO |
TOTAL EVALUATED PRICE
Fixed Price Labor
| Labor - Price Detail Spreadsheet |
| Solicitation # W9124921R0001 |
| Prime Contractor: |
| SEE NOTE 1 | SEE NOTE 2 | SEE NOTE 3 | Year 1 of 5 | Year 2 of 5 | Year 3 of 5 | Year 4 of 5 | Year 5 of 5 | Grand Total for 5-year Ordering Period | ||||||||||||||||
| PWS Appendix A | LABOR CATEGORY | Total Estimated Hours | Service Contract Labor Standards or Bureau of Labor Statistics Occupation Code | Vendor Name | Direct Labor Rate | FICA | FUTA | SUTA | Worker's Comp | Health/Life Insurance | Retirement Plan | Other (Specify) | Total Fringe Benefits | Overhead Costs | G&A Cost | Proft | Total Billable Labor Rate | Total Price @ Burdened Rate | Total Price @ Burdened Rate | Total Price @ Burdened Rate | Total Price @ Burdened Rate | Total Price @ Burdened Rate | Total Price @ Burdened Rate | |
| SCLS/BLS/NA | Occupation Code | _______ % | _______ % | _______ % | _______ % | _______ % | _______ % | _______ % | _______ % | _______ % | _______ % | |||||||||||||
| A-1 | Program Manager | 1920 | ||||||||||||||||||||||
| A-2 | Security Assistant | 3840 | ||||||||||||||||||||||
| A-3 | Logistics Technician | 1920 | ||||||||||||||||||||||
| A-4 | Technical Writer | 1920 | ||||||||||||||||||||||
| A-5 | Operations Management Technician/Analyst | 8640 | ||||||||||||||||||||||
| A-6 | Operations Management Technician/Analyst (Unit Engagement) | 8640 | ||||||||||||||||||||||
| A-7 | Administrative Support Technician | 5760 | ||||||||||||||||||||||
| A-8 | Executive Assistant | 13440 | ||||||||||||||||||||||
| A-9 | Knowledge Manager | 3840 | ||||||||||||||||||||||
| A-10 | Systems Administrator | 1920 | ||||||||||||||||||||||
| A-11 | Digital Graphics Designer/Print Production Specialist | 1920 | ||||||||||||||||||||||
| A-12 | Information Assurance Network Officer (IANO) | 7680 | ||||||||||||||||||||||
| A-13 | DOTMLPF Capability Evaluator | 19200 | ||||||||||||||||||||||
| A-14 | Concept Editor (PE) | 5760 | BLS | |||||||||||||||||||||
| A-15 | Concept Developer | 11520 | ||||||||||||||||||||||
| A-16 | Scenario Developer | 3840 | ||||||||||||||||||||||
| A-17 | Communications Requirements Editor (PE) | 3840 | BLS | |||||||||||||||||||||
| A-18 | Cyberspace Operations Requirements Editor (PE) | 4800 | BLS | |||||||||||||||||||||
| A-19 | Communications Requirements Editor (Test & Evaluation) (PE) | 3840 | BLS | |||||||||||||||||||||
| A-20 | Communications Requirements Editor (Integration) (PE) | 3840 | BLS | |||||||||||||||||||||
| A-21 | Communications Requirements Editor (SATCOM Systems Analyst) (PE) | 3840 | BLS | |||||||||||||||||||||
| A-22 | Cyberspace Operations Requirements Editor (PE) | 4800 | BLS | |||||||||||||||||||||
| A-23 | Electromagnetic Spectrum Operations (EMSO) Requirements Editor (PE) | 9600 | BLS | |||||||||||||||||||||
| A-24 | Information Related Capabilities Requirement Editor | 5760 | ||||||||||||||||||||||
| A-25 | Communications Requirements Developer | 3414 | ||||||||||||||||||||||
| A-26 | Communications Requirements Developer (Tactical Transport) | 3414 | ||||||||||||||||||||||
| A-27 | Communications Requirements Developer (Tactical Network) | 3414 | ||||||||||||||||||||||
| A-28 | Communications Requirements Developer (Tactical SATCOM) | 3414 | ||||||||||||||||||||||
| A-29 | Communications Requirements Developer (Enterprise Transport) | 3414 | ||||||||||||||||||||||
| A-30 | Communications Requirements Developer (Enterprise DoDIN Ops) | 3414 | ||||||||||||||||||||||
| A-31 | Communications Requirements Developer (Tactical DoDIN Ops) | 3413 | ||||||||||||||||||||||
| A-32 | Communications Requirements Developer (Cyber Security) | 3413 | ||||||||||||||||||||||
| A-33 | Communications Requirements Developer (COMSEC/KMI) | 3413 | ||||||||||||||||||||||
| A-34 | Communications Requirements Developer (IDM/CS) | 3413 | ||||||||||||||||||||||
| A-35 | Communications Requirements Developer (Enterprise Data/Cloud) | 3413 | ||||||||||||||||||||||
| A-36 | Communications Requirements Developer (Enterprise Services Infrastructure) | 3413 | ||||||||||||||||||||||
| A-37 | Communications Requirements Developer (Tactical Services Infrastructure) | 3413 | ||||||||||||||||||||||
| A-38 | Communications Requirements Developer (Enterprise Computing Environment) | 3413 | ||||||||||||||||||||||
| A-39 | Communications Requirements Developer (Mission Partner Interoperability) | 3413 | ||||||||||||||||||||||
| A-40 | Communications Requirements Developer (Enterprise Network) | 3413 | ||||||||||||||||||||||
| A-41 | Communications Requirements Developer (Enterprise SATCOM) | 3413 | ||||||||||||||||||||||
| A-42 | Communications Requirements Developer (LNO) | 3413 | ||||||||||||||||||||||
| A-43 | Cyberspace Operations Requirements Developer | 7680 | ||||||||||||||||||||||
| A-44 | EMSO Requirements Developer | 17280 | ||||||||||||||||||||||
| A-45 | EMSO Requirement Developer (Junior) | 3840 | ||||||||||||||||||||||
| A-46 | EMSO Requirements Developer (Operations Support) | 1920 | ||||||||||||||||||||||
| A-47 | Information Related Capabilities Requirement Developer (PE) | 11520 | BLS | |||||||||||||||||||||
| A-48 | Operations Research and Systems Analyst | 11520 | ||||||||||||||||||||||
| A-49 | Capability Cost Analyst | 3840 | ||||||||||||||||||||||
| A-51 | Communications Analyst | 11520 | ||||||||||||||||||||||
| A-52 | Cyberspace Operations Analyst | 21120 | ||||||||||||||||||||||
| A-53 | Electromagnetic Spectrum Operations Analyst | 17280 | ||||||||||||||||||||||
| A-54 | Information Related Capabilities Analyst | 19200 | ||||||||||||||||||||||
| A-55 | Data Analyst | 3840 | ||||||||||||||||||||||
| A-56 | Capability Manager/ DOTmLPF Integrator | 15360 | ||||||||||||||||||||||
| A-57 | Force Design Developer | 7680 | ||||||||||||||||||||||
| A-58 | Threat and Operational Environment Analyst | 9600 | ||||||||||||||||||||||
| Year 1 of 5 | Year 2 of 5 | Year 3 of 5 | Year 4 of 5 | Year 5 of 5 | Grand Total for 5-year Ordering Period | |||||||||||||||||||
| TOTAL FIXED PRICE LABOR | 366,720.00 |
File details come from the government source that posted it. Updated .