Attachment 07_Subcontractor_Pricing_ModelR1.xls

XLS spreadsheet 133 KB Posted

Attached to
Solicitation N0003918R0006 (NILE ISS)
Solicitation number
N00039-18-R-0006
Issued by

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

Ceiling (Total Price)

SOLICITATION NO. N0003918R0006 - ATTACHMENT 7
COST SUMMARY FORMAT - SUBCONTRACTOR
Subcontractor Name:
DCAA Point of Contact Information:
CLINsProposed Price
CLIN 0001$ - 0
CLIN 1001$ - 0
CLIN 2001$ - 0
CLIN 3001$ - 0
CLIN 4001$ - 0
CLINs 0002, 1002, 2002, 3002, 4002$ - 0
CLIN 0004$ - 0
CLIN 1004$ - 0
CLIN 2004$ - 0
CLIN 3004$ - 0
CLIN 4004$ - 0
CLINs 0005, 1005, 2005, 3005, 4005$ - 0
CLINs 0006, 1006, 2006 3006, 4006$ - 0
CLIN 0007$ - 0
CLIN 0008$ - 0
CLIN 0009$ - 0
CLIN 0010$ - 0
Total Proposed Price$ - 0

CPFF

SOLICITATION NO. N0003918R0006 - ATTACHMENT 7Contract Type: CPFF
COST SUMMARY FORMAT - SUBCONTRACTOR
Subcontractor Name:
DCAA Point of Contact Information:
BASE YEARTOTAL FOR ALL YEARSBASE YEAROPTION 1OPTION 2AWARD TERM 1AWARD TERM 2
Cost ElementsLabor Category*Hours*AmountActual Current Labor RateEscalation RateProposed Rate**HoursAmount ($)Proposed Rate**HoursAmount ($)Proposed Rate**HoursAmount ($)Proposed Rate**HoursAmount ($)Proposed Rate**HoursAmount ($)
BLOCK CYCLE UPDATES AND ENG/PM SERVICES - NILE PMOCLIN 0001CLIN 1001CLIN 2001CLIN 30014001
Period of Performance01 Aug 2018- 31 July 20192 Aug 2019- 31 July 20203 Aug 2020- 31 July 20214 Aug 2021- 31 July 20225 Aug 2022- 31 July 2023
Subcontractor Labor Cost
Subcontractor Direct Labor:
Employee Name 1
Employee Name 2
Etc.
Total Direct Labor Cost
Subcontractor Indirect Labor Costs:
Fringe Benefits
Subtotal
Overhead
Subtotal
G&A
Total Subcontractor Indirect Cost
Total Direct and Indirect Labor cost
COM (If Applicable)
Total Subcontractor Labor Cost
Total Subcontractor Labor Cost
Fixed Fee ***
Subcontractor Fee for Subcontractor Labor
Total Subcontractor Fee
Total Labor Cost Plus Fixed Fee for BLOCK CYCLE UPDATES AND ENG/PM SERVICES FOR NILE IT SYSTEMS PMO CLINs
ENGINEERING SREVICES NATION-SPECIFIC SUPPORTCLIN 0004CLIN 1004CLIN 2004CLINI 30044004
Period of Performance01 Aug 2018- 31 July 20192 Aug 2019- 31 July 20203 Aug 2020- 31 July 20214 Aug 2021- 31 July 20225 Aug 2022- 31 July 2023
Subcontractor Labor Cost
Subcontractor Direct Labor:
Employee Name 1
Employee Name 2
Etc.
Total Direct Labor Cost
Subcontractor Indirect Labor Costs:
Fringe Benefits
Subtotal
Overhead
Subtotal
G&A
Total Subcontractor Indirect Cost
Total Direct and Indirect Labor cost
COM (If Applicable)
Total Subcontractor Labor Cost
Total Subcontractor Labor Cost
Fixed Fee ***
Subcontractor Fee for Subcontractor Labor
Total Subcontractor Fee
Total Labor Cost Plus Fixed Fee for ENGINEERING SERVICES FOR NILE IT SYSTEMS CLINs
Total Subcontractor Labor Cost Plus Fixed Fee (CPFF)
OTHER DIRECT COSTSCLIN 0002CLIN 1002CLIN 2002CLIN 30024002
Period of Performance01 Aug 2018- 31 July 20192 Aug 2019- 31 July 20203 Aug 2020- 31 July 20214 Aug 2021- 31 July 20225 Aug 2022- 31 July 2023
Subcontractor Other Direct Costs (ODCs)
Other Direct Costs
Any Adders to ODCs
Total Subcontractor ODCs
OTHER DIRECT COSTSCLIN 0005CLIN 1005CLIN 2005CLIN 30054005
Period of Performance01 Aug 2018- 31 July 20192 Aug 2019- 31 July 20203 Aug 2020- 31 July 20214 Aug 2021- 31 July 20225 Aug 2022- 31 July 2023
Subcontractor Other Direct Costs (ODCs)
Other Direct Costs
Any Adders to ODCs
Total Subcontractor ODCs
TOTAL Subcontractor ODCs
TOTAL Subcontractor CPFF all CLINs
OTHER DIRECT COSTS - NILE PMOCLIN 0002CLIN 1002CLIN 2002CLIN 3002CLIN 4002
Period of Performance01 Aug 2018- 31 July 20192 Aug 2019- 31 July 20203 Aug 2020- 31 July 20214 Aug 2021- 31 July 20225 Aug 2022- 31 July 2023
Other Direct Costs (ODCs) - Incidental Materials/Travel
Other Direct Costs
Any Adders to ODCs
Total ODCs - Cost Only Non-Fee Bearing
OTHER DIRECT COSTS - NATION-SPECIFIC SUPPORTCLIN 0005CLIN 1005CLIN 2005CLIN 3005CLIN 4005
Period of Performance01 Aug 2018- 31 July 20192 Aug 2019- 31 July 20203 Aug 2020- 31 July 20214 Aug 2021- 31 July 20225 Aug 2022- 31 July 2023
Other Direct Costs (ODCs) - Incidental Materials/Travel
Other Direct Costs
Any Adders to ODCs
Total ODCs - Cost Only Non-Fee Bearing
OTHER DIRECT COSTSCLIN 0006CLIN 1006CLIN 2006CLIN 3006CLIN 4006
Period of Performance01 Aug 2018- 31 July 20192 Aug 2019- 31 July 20203 Aug 2020- 31 July 20214 Aug 2021- 31 July 20225 Aug 2022- 31 July 2023
Other Direct Costs (ODCs) - Other Hardware for Lab
Other Direct Costs
Any Adders to ODCs
Fee (limited to 3%)
Total ODCs - CPFF (limited to 3% fee)
OTHER DIRECT COSTS0007
Ordering Period01 August 2018 - 31 July 2023
Other Direct Costs (ODCs) - Thales TRG 6034 Radio (NATO Version of the TRG6030 series of radios)
Other Direct Costs
Total ODCs - FFP$ - 0
OTHER DIRECT COSTS0008
Ordering Period01 August 2018 - 31 July 2023
Other Direct Costs (ODCs) - Thales TRG 6034 Radio (NATO Version of the TRG6030 series of radios)
Other Direct Costs
Total ODCs - FFP$ - 0
OTHER DIRECT COSTS0009
Ordering Period01 August 2018 - 31 July 2023
Other Direct Costs (ODCs) - Rohde and Schwarz M3SR Series 4400 Software Defined Radios
Other Direct Costs
Total ODCs - FFP$ - 0
OTHER DIRECT COSTS0010
Ordering Period01 August 2018 - 31 July 2023
Other Direct Costs (ODCs) - Rohde and Schwarz M3SR Series 4400 Software Defined Radios
Other Direct Costs
Total ODCs - FFP$ - 0
TOTAL ODCs
TOTAL CPFF all CLINs
*Total hours may be distributed between prime and subcontractors at the offeror’s discretion. When prime and subcontractor hours for each labor category are combined, they must equal the Government's estimate of annual level of effort, segregated by labor category as specified in the table in Section L of the RFP.
Proposed rate may be a direct labor rate, fringe, overhead or any other factor as applicable.
Fee on fee shall NOT allowable.
**As Specified in Section B, CLINs 0006-4006 are Option Periods.

Formulas shall be created by the Contractor. An MS Excel file shall be submitted to the Government with formulas left intact. Round to decimal places only.

PTDL 0001

SOLICITATION NO. N0003918R0006 - ATTACHMENT 7Contract Type: CPFF
COST SUMMARY FORMAT - SUBCONTRACTOR
Subcontractor Name:
DCAA Point of Contact Information:
POTENTIAL TECHNICAL DIRECTION LETTER (PTDL) 0001
Cost ElementsLabor Category*Hours
CLIN 000X - BLOCK CYCLE UPDATES AND ENG/PM SERVICES FOR NILE IT SYSTEMS PMO
Subcontractor Labor Hours
Program Manager (Key Personnel) (Sr)
Principal Systems Architect (Key Personnel) (Sr)
Applications Programmer (Sr)
Software Systems Engineer (Sr)
Applications Programmer (Mid)
Computer Security Systems Specialist (Mid)
Applications Programmer (Jr)
Quality Assurance Manager (Mid)
Web Architect (Jr)
Mgmt/Contracts/Financial Specialist (Mid)
Test Engineer (Mid)
Configuration Mgmt Specialist (Mid)
Network Engineer (Mid)
Subject Matter Expert (Sr)
CLIN 000X - ENGINEERING SERVICES FOR NILE IT SYSTEMS
Subcontractor Labor Hours
Program Manager (Key Personnel) (Sr)
Principal Systems Architect (Key Personnel) (Sr)
Applications Programmer (Sr)
Software Systems Engineer (Sr)
Applications Programmer (Mid)
Computer Security Systems Specialist (Mid)
Applications Programmer (Jr)
Quality Assurance Manager (Mid)
Web Architect (Jr)
Mgmt/Contracts/Financial Specialist (Mid)
Test Engineer (Mid)
Configuration Mgmt Specialist (Mid)
Network Engineer (Mid)
Subject Matter Expert (Sr)
Total Subcontractor Labor Hours
Total Labor Hours
*Total hours may be distributed between prime and subcontractors at the offeror’s discretion. When prime and subcontractor hours for each labor category are combined, they must equal the Government's estimate of annual level of effort, segregated by labor category as specified in the table in Section L of the RFP.

Formulas shall be created by the Contractor. An MS Excel file shall be submitted to the Government with formulas left intact.

PTDL 0002

SOLICITATION NO. N0003918R0006 - ATTACHMENT 7Contract Type: CPFF
COST SUMMARY FORMAT - SUBCONTRACTOR
Subcontractor Name:
DCAA Point of Contact Information:
POTENTIAL TECHNICAL DIRECTION LETTER (PTDL) 0002
Cost ElementsLabor Category*Hours
CLIN 000X - BLOCK CYCLE UPDATES AND ENG/PM SERVICES FOR NILE IT SYSTEMS PMO
Subcontractor Labor Hours
Program Manager (Key Personnel) (Sr)
Principal Systems Architect (Key Personnel) (Sr)
Applications Programmer (Sr)
Software Systems Engineer (Sr)
Applications Programmer (Mid)
Computer Security Systems Specialist (Mid)
Applications Programmer (Jr)
Quality Assurance Manager (Mid)
Web Architect (Jr)
Mgmt/Contracts/Financial Specialist (Mid)
Test Engineer (Mid)
Configuration Mgmt Specialist (Mid)
Network Engineer (Mid)
Subject Matter Expert (Sr)
CLIN 000X - ENGINEERING SERVICES FOR NILE IT SYSTEMS
Subcontractor Labor Hours
Program Manager (Key Personnel) (Sr)
Principal Systems Architect (Key Personnel) (Sr)
Applications Programmer (Sr)
Software Systems Engineer (Sr)
Applications Programmer (Mid)
Computer Security Systems Specialist (Mid)
Applications Programmer (Jr)
Quality Assurance Manager (Mid)
Web Architect (Jr)
Mgmt/Contracts/Financial Specialist (Mid)
Test Engineer (Mid)
Configuration Mgmt Specialist (Mid)
Network Engineer (Mid)
Subject Matter Expert (Sr)
Total Subcontractor Labor Hours
Total Labor Hours
*Total hours may be distributed between prime and subcontractors at the offeror’s discretion. When prime and subcontractor hours for each labor category are combined, they must equal the Government's estimate of annual level of effort, segregated by labor category as specified in the table in Section L of the RFP.

Formulas shall be created by the Contractor. An MS Excel file shall be submitted to the Government with formulas left intact.

Formulas shall be created by the Contractor. An MS Excel file shall be submitted to the Government with formulas left intact.

PTDL 0003

SOLICITATION NO. N0003918R0006 - ATTACHMENT 7Contract Type: CPFF
COST SUMMARY FORMAT - SUBCONTRACTOR
Subcontractor Name:
DCAA Point of Contact Information:
POTENTIAL TECHNICAL DIRECTION LETTER (PTDL) 0003
Cost ElementsLabor Category*Hours
CLIN 000X - BLOCK CYCLE UPDATES AND ENG/PM SERVICES FOR NILE IT SYSTEMS PMO
Subcontractor Labor Hours
Program Manager (Key Personnel) (Sr)
Principal Systems Architect (Key Personnel) (Sr)
Applications Programmer (Sr)
Software Systems Engineer (Sr)
Applications Programmer (Mid)
Computer Security Systems Specialist (Mid)
Applications Programmer (Jr)
Quality Assurance Manager (Mid)
Web Architect (Jr)
Mgmt/Contracts/Financial Specialist (Mid)
Test Engineer (Mid)
Configuration Mgmt Specialist (Mid)
Network Engineer (Mid)
Subject Matter Expert (Sr)
CLIN 000X - ENGINEERING SERVICES FOR NILE IT SYSTEMS
Subcontractor Labor Hours
Program Manager (Key Personnel) (Sr)
Principal Systems Architect (Key Personnel) (Sr)
Applications Programmer (Sr)
Software Systems Engineer (Sr)
Applications Programmer (Mid)
Computer Security Systems Specialist (Mid)
Applications Programmer (Jr)
Quality Assurance Manager (Mid)
Web Architect (Jr)
Mgmt/Contracts/Financial Specialist (Mid)
Test Engineer (Mid)
Configuration Mgmt Specialist (Mid)
Network Engineer (Mid)
Subject Matter Expert (Sr)
Total Subcontractor Labor Hours
Total Labor Hours
*Total hours may be distributed between prime and subcontractors at the offeror’s discretion. When prime and subcontractor hours for each labor category are combined, they must equal the Government's estimate of annual level of effort, segregated by labor category as specified in the table in Section L of the RFP.

Formulas shall be created by the Contractor. An MS Excel file shall be submitted to the Government with formulas left intact.

Formulas shall be created by the Contractor. An MS Excel file shall be submitted to the Government with formulas left intact.

ODCs

SOLICITATION NO. N00039-13-R-0010 - ATTACHMENT 7Other Direct Costs
COST SUMMARY FORMAT - SUBCONTRACTORContract Type: Cost Only
Subcontractor Name:
DCAA Point of Contact Information:
Cost ElementsBASE YEAROPTION 1OPTION 2AT1AT2Total
OTHER DIRECT COSTS (NILE)00021002200230024002
Other Direct Costs (ODCs)
Adders
Total ODCs - Cost Only Non-Fee Bearing
OTHER DIRECT COSTS (NATION SPECIFIC)00051005200530054005
Other Direct Costs (ODCs)
Adders
Total ODCs - Cost Only Non-Fee Bearing
OTHER DIRECT COSTS (Other Hardware for Lab)00061006200630064006
Other Direct Costs (ODCs)
Adders
Total ODCs - CPFF (limted to 3% fee)
OTHER DIRECT COSTS (Thales TRG 6034 Radio (NATO Version of the TRG6030 series of radios))0007
Other Direct Costs (ODCs)$ - 0
Total ODCs (FFP)$ - 0
OTHER DIRECT COSTS Thales TRG 6034 Radio (NATO Version of the TRG6030 series of radios)0008
Other Direct Costs (ODCs)$ - 0
Total ODCs (FFP)$ - 0
OTHER DIRECT COSTS (Rohde and Schwarz M3SR Series 4400 Software Defined Radios)0007
Other Direct Costs (ODCs)$ - 0
Total ODCs (FFP)$ - 0
OTHER DIRECT COSTS (Rohde and Schwarz M3SR Series 4400 Software Defined Radios)0008
Other Direct Costs (ODCs)$ - 0
Total ODCs (FFP)$ - 0
TOTAL Other Direct Costs$ - 0
X002 and X005: It is anticipated that ODC costs will consist mainly of travel and incidental material costs. For the purpose of establishing the CLIN ceiling, the Offeror shall propose a ‘lump sum’ cost exactly in accordance with
the Government estimate; however, Offerors may include applicable burdens i.e. G&A, in accordance with the Offeror’s disclosed accounting practices. ODC costs shall not be fee bearing, i.e. this is a cost only CLIN
X006: It is anticipated that during performance of the contract, additional hardware may be required to support the NILE Compatibility Laboratory. The exact items are unknown at this time. CLINs 0006-4006 are Options. For the purpose of establishing the
CLIN ceiling, the Offeror shall propose a ‘lump sum’ cost exactly in accordance with the Government estimate. This amount shall be inclusive ofOfferors may include applicable burdens and proposed fee, not-to-exceed 3%.
X007 - X010: It is anticipated that UHF EPM radios in accordance with Section 5.2.4 of the PWS may be required during performance of this contract. Offerors shall propose a Firm Fixed Price
for the radios at a quantity of 1 each or propose Economic Pricing Quantity per the table in Section B

CPFF Hours

SOLICITATION NO. N00039-13-R-0010 - ATTACHMENT 7
COST SUMMARY FORMAT - SUBCONTRACTOR
Subcontractor Name:
DCAA Point of Contact Information:
SubKtrTotal HoursSubKtrTotal HoursSubKtrTotal HoursSubKtrTotal HoursSubKtrTotal Hours
Base YearBase YearOption 1Option 1Option 2Option 2Option 3Option 3Option 4Option 4
Cost ElementsOfferor's Category
BLOCK CYCLE UPDATES AND ENG/PM SERVICES - NILE PMOCLIN 0001CLIN 0001CLIN 1001CLIN 1001CLIN 2001CLIN 2001CLIN 3001CLIN 3001CLIN 4001CLIN 4001
Program Manager (Key Personnel) (Sr)
Principal Systems Architect (Key Personnel) (Sr)
Applications Programmer (Sr)
Software Systems Engineer (Sr)
Applications Programmer (Mid)
Computer Security Systems Specialist (Mid)
Applications Programmer (Jr)
Quality Assurance Manager (Mid)
Web Architect (Jr)
Mgmt/Contracts/Financial Specialist (Mid)
Test Engineer (Mid)
Configuration Mgmt Specialist (Mid)
Network Engineer (Mid)
Subject Matter Expert (Sr)
Total Direct Labor Hours
ENGINEERING SERVICES - NATION SPECIFICCLIN 0004CLIN 0004CLIN 1004CLIN 1004CLIN 2004CLIN 2004CLIN 3004CLIN 3004CLIN 4004CLIN 4004
Program Manager (Key Personnel) (Sr)
Principal Systems Architect (Key Personnel) (Sr)
Applications Programmer (Sr)
Software Systems Engineer (Sr)
Applications Programmer (Mid)
Computer Security Systems Specialist (Mid)
Applications Programmer (Jr)
Quality Assurance Manager (Mid)
Web Architect (Jr)
Mgmt/Contracts/Financial Specialist (Mid)
Test Engineer (Mid)
Configuration Mgmt Specialist (Mid)
Network Engineer (Mid)
Subject Matter Expert (Sr)
Total Direct Labor Hours

Supporting Cost Data

SOLICITATION NO. N0003918R0006 - ATTACHMENT 7
COST SUMMARY FORMAT - SUBCONTRACTOR
Subcontractor Name:
DCAA Point of Contact Information:
Historical RatesProposed Rates
Direct Labor:
Employee NameLabor CategoryHistorical Year 1Historical Year 2Historical Year 3
(Actual Current Labor Rate)Proposed Base Period Labor RateProposed Option 1 Period Labor RateProposed Option 2 Period Labor RateProposed Option 3 Period Labor RateProposed Option 4 Period Labor RateReason for difference between actual current labor rate and proposed labor rates. Reason for difference between proposed rates and DCMA/DCAA Forward Pricing Rate Agreement (FPRA) rates.
Ex: John DoeEx: Sr. Program Mgr$$$$$$
Ex: Jane DoeEx: Sr. Systems Engineer$$$$$$
Ex: New Employee 1Ex: Jr. Junior Analyst$$$$$$
$$$$$$
$$$$$$
Indirect Rates:Historical Year 1Historical Year 2Historical Year 3Proposed Base RateProposed Option 1 RateProposed Option 2 RateProposed Option 3 RateProposed Option 4 RateReason for difference between actual current labor rate and proposed labor rates. Reason for difference between proposed rates and DCMA/DCAA Forward Pricing Rate Agreement (FPRA) rates.
Fringe
Overhead Rate
G&A
Material and Handling
Other
Rate PeriodStart DateEnd Date
Historical Year 1:
Historical Year 2:
Historical Year 3:
Proposed Base Period:
Proposed Option 1:
Proposed Option 2:
Proposed Option 3:
Proposed Option 4:
Proposed Option 5:
Note to Offerors: The Offeror shall provide historical labor rates and proposed labor rates for the personnel (named and unnamed) identified above. The Offeror shall provide historical rates in Columns C, D and E; year 3 shall contain the Offeror's most recent annual labor rates. The Offeror shall then identify their proposed labor rates for those same individuals in columns F, G, H, I, J and K. The Offeror shall provide similar historical and proposed indirect rates for the items listed on lines 17 through 21. The Offeror shall identify the Start and End dates for each of their rate periods in the table on lines 25-33.

File details come from the government source that posted it.