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
Issued by
Department of the Army Materiel Command Mission and Installation Contracting Command Fort Eustis

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:
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0001Labor - Years 1-51.00Job$ - 0
FFPTotal Price =
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0002Travel - Years 1 - 51.00Job$ - 0
CostTotal Cost =$ 9,550,000
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0003Other Direct Costs (ODCs) - Years 1 - 51.00Job$ - 0
CostTotal Cost =$ 10,000,000
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0004Service Contract Reporting1.00Job$ - 0PRICED AT TO
FFPTotal Price =PRICED AT TO

TOTAL EVALUATED PRICE

Fixed Price Labor

Labor - Price Detail Spreadsheet
Solicitation # W9124921R0001
Prime Contractor:
SEE NOTE 1SEE NOTE 2SEE NOTE 3Year 1 of 5Year 2 of 5Year 3 of 5Year 4 of 5Year 5 of 5Grand Total for 5-year Ordering Period
PWS Appendix ALABOR CATEGORYTotal Estimated HoursService Contract Labor Standards or Bureau of Labor Statistics Occupation CodeVendor NameDirect Labor RateFICAFUTASUTAWorker's CompHealth/Life InsuranceRetirement PlanOther (Specify)Total Fringe BenefitsOverhead CostsG&A CostProftTotal Billable Labor RateTotal Price @ Burdened RateTotal Price @ Burdened RateTotal Price @ Burdened RateTotal Price @ Burdened RateTotal Price @ Burdened RateTotal Price @ Burdened Rate
SCLS/BLS/NAOccupation Code_______ %_______ %_______ %_______ %_______ %_______ %_______ %_______ %_______ %_______ %
A-1Program Manager1920
A-2Security Assistant3840
A-3Logistics Technician1920
A-4Technical Writer1920
A-5Operations Management Technician/Analyst8640
A-6Operations Management Technician/Analyst (Unit Engagement)8640
A-7Administrative Support Technician5760
A-8Executive Assistant13440
A-9Knowledge Manager3840
A-10Systems Administrator1920
A-11Digital Graphics Designer/Print Production Specialist1920
A-12Information Assurance Network Officer (IANO)7680
A-13DOTMLPF Capability Evaluator19200
A-14Concept Editor (PE)5760BLS
A-15Concept Developer11520
A-16Scenario Developer3840
A-17Communications Requirements Editor (PE)3840BLS
A-18Cyberspace Operations Requirements Editor (PE)4800BLS
A-19Communications Requirements Editor (Test & Evaluation) (PE)3840BLS
A-20Communications Requirements Editor (Integration) (PE)3840BLS
A-21Communications Requirements Editor (SATCOM Systems Analyst) (PE)3840BLS
A-22Cyberspace Operations Requirements Editor (PE)4800BLS
A-23Electromagnetic Spectrum Operations (EMSO) Requirements Editor (PE)9600BLS
A-24Information Related Capabilities Requirement Editor5760
A-25Communications Requirements Developer3414
A-26Communications Requirements Developer (Tactical Transport)3414
A-27Communications Requirements Developer (Tactical Network)3414
A-28Communications Requirements Developer (Tactical SATCOM)3414
A-29Communications Requirements Developer (Enterprise Transport)3414
A-30Communications Requirements Developer (Enterprise DoDIN Ops)3414
A-31Communications Requirements Developer (Tactical DoDIN Ops)3413
A-32Communications Requirements Developer (Cyber Security)3413
A-33Communications Requirements Developer (COMSEC/KMI)3413
A-34Communications Requirements Developer (IDM/CS)3413
A-35Communications Requirements Developer (Enterprise Data/Cloud)3413
A-36Communications Requirements Developer (Enterprise Services Infrastructure)3413
A-37Communications Requirements Developer (Tactical Services Infrastructure)3413
A-38Communications Requirements Developer (Enterprise Computing Environment)3413
A-39Communications Requirements Developer (Mission Partner Interoperability)3413
A-40Communications Requirements Developer (Enterprise Network)3413
A-41Communications Requirements Developer (Enterprise SATCOM)3413
A-42Communications Requirements Developer (LNO)3413
A-43Cyberspace Operations Requirements Developer7680
A-44EMSO Requirements Developer17280
A-45EMSO Requirement Developer (Junior)3840
A-46EMSO Requirements Developer (Operations Support)1920
A-47Information Related Capabilities Requirement Developer (PE)11520BLS
A-48Operations Research and Systems Analyst11520
A-49Capability Cost Analyst3840
A-51Communications Analyst11520
A-52Cyberspace Operations Analyst21120
A-53Electromagnetic Spectrum Operations Analyst17280
A-54Information Related Capabilities Analyst19200
A-55Data Analyst3840
A-56Capability Manager/ DOTmLPF Integrator15360
A-57Force Design Developer7680
A-58Threat and Operational Environment Analyst9600
Year 1 of 5Year 2 of 5Year 3 of 5Year 4 of 5Year 5 of 5Grand Total for 5-year Ordering Period
TOTAL FIXED PRICE LABOR366,720.00

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