Attachment_7_-_DIB_Development_5th_Edition_-Cost_Format_-Final.xlsx

XLSX spreadsheet 67 KB Posted

Attached to
DIB Development 5th Edition FINAL RFP FA873017R0024 Federal contract opportunity
Solicitation number
FA873017R0024
Issued by
Department of the Air Force Materiel Command Lifecycle Management Center Hanscom Air Force Base

About this file

Correct version of Attachment 7 - DIB Development 5th Edition - Cost Format

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

Cover Page

Table of Contents

Cost FormatSection L #
Summary5.3.4.1
B-Table5.3.4.2
Delivery Order 01- Initial TRN5.3.4.3
Sample Epic5.3.4.4
LH Rates at BEQ5.3.4.5
Price Track5.3.4.6

&"Times New Roman,Bold"&18&UTable of Contents

Summary

Table 1- Delivery Order 01- Initial TRN
Contract
CLINTypeDescriptionTotal Price
0001LHDMO Labor$ - 0
0002NSPDMO Data
0003CRDMO Other Direct Costs$ 5,000
0004CRDMO Travel$ 5,000
Total Table 1$ 10,000
Table 2- CR CLINs
CLINTypeDescriptionTotal Price
0003CRDMO Other Direct Costs$ 100,000
0004CRDMO Travel$ 100,000
0006CRDCGS AF Other Direct Costs$ 100,000
0007CRDCGS AF Travel$ 100,000
0009CRDCGS ARMY Other Direct Costs$ 100,000
0010CRDCGS ARMY Travel$ 100,000
0012CRDCGS NAVY Other Direct Costs$ 100,000
0013CRDCGS NAVY Travel$ 100,000
0015CRDCGS USMC Other Direct Costs$ 100,000
0016CRDCGS USMC Travel$ 100,000
0018CRDCGS SOCOM Other Direct Costs$ 100,000
0019CRDCGS SOCOM Travel$ 100,000
0021CRDCGS NGA Other Direct Costs$ 100,000
0022CRDCGS NGA Travel$ 100,000
0024CRDCGS INTEL COMMUNITY Other Direct Costs$ 100,000
0025CRDCGS INTEL COMMUNITY Travel$ 100,000
Total Table 2$ 1,620,000
Table 3- Sample Epic*
TypeDescriptionTotal Price
LHSample Epic$ - 0
Total Table 3$ - 0
*Table 2 - Sample Epic will not be included as part of the Total Evaluated Price
Table 4 - LH Rates at BEQ
TypeDescriptionTEP
LHCY1ERROR:#DIV/0!
LHCY2ERROR:#DIV/0!
LHCY3ERROR:#DIV/0!
LHCY4ERROR:#DIV/0!
LHCY5ERROR:#DIV/0!
Total Table 4ERROR:#DIV/0!

B-Table

Labor Hour
B-Table for CLINs 0001, 0005, 0008, 0011, 0014, 0017, 0020 and 0023
Prime Contractor
DO 01 - Initial TRNCY1CY2CY3CY4CY5
1 February 2018 - 16 March 201817 March 2018-16 March 201917 March 2019-16 March 202017 March 2020-16 March 202117 March 2021-16 March 202217 March 2022-31 January 2023
Labor Category
Engineer Level 6 – E6
Engineer Level 5 – E5
Engineer Level 4 – E4
Engineer Level 3 – E3
Engineer Level 2 – E2
Engineer Level 1 – E1
Technician Level 5 – T5
Technician Level 4 – T4
Technician Level 3 – T3
Technician Level 2 – T2
Technician Level 1 – T1
Program Manager
General Administration
Subcontractor A
DO 01 - Initial TRNCY1CY2CY3CY4CY5
1 February 2018 - 16 March 201817 March 2018-16 March 201917 March 2019-16 March 202017 March 2020-16 March 202117 March 2021-16 March 202217 March 2022-31 January 2023
Labor Category
Engineer Level 6 – E6
Engineer Level 5 – E5
Engineer Level 4 – E4
Engineer Level 3 – E3
Engineer Level 2 – E2
Engineer Level 1 – E1
Technician Level 5 – T5
Technician Level 4 – T4
Technician Level 3 – T3
Technician Level 2 – T2
Technician Level 1 – T1
Program Manager
General Administration
IDT A
DO 01 - Initial TRNCY1CY2CY3CY4CY5
1 February 2018 - 16 March 201817 March 2018-16 March 201917 March 2019-16 March 202017 March 2020-16 March 202117 March 2021-16 March 202217 March 2022-31 January 2023
Labor Category
Engineer Level 6 – E6
Engineer Level 5 – E5
Engineer Level 4 – E4
Engineer Level 3 – E3
Engineer Level 2 – E2
Engineer Level 1 – E1
Technician Level 5 – T5
Technician Level 4 – T4
Technician Level 3 – T3
Technician Level 2 – T2
Technician Level 1 – T1
Program Manager
General Administration
*The Prime Contractor, Subcontractor, and IDT B-Tables will be incorporated in to the contract at time of award.

Delivery Order 01-Initial TRN Delivery Order 01 (Initial TRN)

Delivery Order 01 -Initial TRN
CLIN 0001
1 February 2018- 16 March 2018
Prime ContractorSubcontractor AIDT ATotal Price
Labor CategoryWrap RateHoursTotal PriceWrap RateHoursTotal PriceWrap RateHoursTotal Price
Engineer Level 6 – E6$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Engineer Level 5 – E5$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Engineer Level 4 – E4$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Engineer Level 3 – E3$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Engineer Level 2 – E2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Engineer Level 1 – E1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Technician Level 5 – T5$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Technician Level 4 – T4$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Technician Level 3 – T3$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Technician Level 2 – T2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Technician Level 1 – T1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Program Manager$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
General Administration$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total CLIN 0001$ - 0$ - 0$ - 0$ - 0

Sample Epic Sample Epic

Sample Epic
17 March 2018 - 16 March 2019
Prime ContractorSubcontractor AIDT ATotal Price
Labor CategoryWrap RateHoursTotal PriceWrap RateHoursTotal PriceWrap RateHoursTotal Price
Engineering Level 6 – E6$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Engineering Level 5 – E5$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Engineering Level 4 – E4$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Engineering Level 3 – E3$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Engineering Level 2 – E2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Engineering Level 1 – E1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Technician Level 5 – T5$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Technician Level 4 – T4$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Technician Level 3 – T3$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Technician Level 2 – T2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Technician Level 1 – T1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Program Manager$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
General Administration$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Sample Epic$ - 0$ - 0$ - 0$ - 0

LH Rates at BEQ Labor Hour Rates at BEQ

CY1CY2CY3CY4CY5
17 March 2018-16 March 201917 March 2019 -16 March 202017 March 2020 - 16 March 202117 March 2021 - 16 March 202217 March 2022 - 31 January 2023
Prime ContractorSubcontractor AIDT ATotal Price# Rates ProposedTEPPrime ContractorSubcontractor AIDT ATotal Price# Rates ProposedTEPPrime ContractorSubcontractor AIDT ATotal Price# Rates ProposedTEPPrime ContractorSubcontractor AIDT ATotal Price# Rates ProposedTEPPrime ContractorSubcontractor AIDT ATotal Price# Rates ProposedTEP
Labor CategoryWrap RateBEQBEQ ExtensionWrap RateBEQBEQ ExtensionWrap RateBEQBEQ ExtensionWrap RateBEQBEQ ExtensionWrap RateBEQBEQ ExtensionWrap RateBEQBEQ ExtensionWrap RateBEQBEQ ExtensionWrap RateBEQBEQ ExtensionWrap RateBEQBEQ ExtensionWrap RateBEQBEQ ExtensionWrap RateBEQBEQ ExtensionWrap RateBEQBEQ ExtensionWrap RateBEQBEQ ExtensionWrap RateBEQBEQ ExtensionWrap RateBEQBEQ Extension
Engineering Level 6 – E6$ - 01,008$ - 0$ - 01,008$ - 0$ - 01,008$ - 0$ - 0- 0ERROR:#DIV/0!$ - 01,008$ - 0$ - 01,008$ - 0$ - 01,008$ - 0$ - 0- 0ERROR:#DIV/0!$ - 01,008$ - 0$ - 01,008$ - 0$ - 01,008$ - 0$ - 0- 0ERROR:#DIV/0!$ - 01,008$ - 0$ - 01,008$ - 0$ - 01,008$ - 0$ - 0- 0ERROR:#DIV/0!$ - 01,008$ - 0$ - 01,008$ - 0$ - 01,008$ - 0$ - 0- 0ERROR:#DIV/0!
Engineering Level 5 – E5$ - 02,081$ - 0$ - 02,081$ - 0$ - 02,081$ - 0$ - 0- 0ERROR:#DIV/0!$ - 02,081$ - 0$ - 02,081$ - 0$ - 02,081$ - 0$ - 0- 0ERROR:#DIV/0!$ - 02,081$ - 0$ - 02,081$ - 0$ - 02,081$ - 0$ - 0- 0ERROR:#DIV/0!$ - 02,081$ - 0$ - 02,081$ - 0$ - 02,081$ - 0$ - 0- 0ERROR:#DIV/0!$ - 02,081$ - 0$ - 02,081$ - 0$ - 02,081$ - 0$ - 0- 0ERROR:#DIV/0!
Engineering Level 4 – E4$ - 01,163$ - 0$ - 01,163$ - 0$ - 01,163$ - 0$ - 0- 0ERROR:#DIV/0!$ - 01,163$ - 0$ - 01,163$ - 0$ - 01,163$ - 0$ - 0- 0ERROR:#DIV/0!$ - 01,163$ - 0$ - 01,163$ - 0$ - 01,163$ - 0$ - 0- 0ERROR:#DIV/0!$ - 01,163$ - 0$ - 01,163$ - 0$ - 01,163$ - 0$ - 0- 0ERROR:#DIV/0!$ - 01,163$ - 0$ - 01,163$ - 0$ - 01,163$ - 0$ - 0- 0ERROR:#DIV/0!
Engineering Level 3 – E3$ - 01,160$ - 0$ - 01,160$ - 0$ - 01,160$ - 0$ - 0- 0ERROR:#DIV/0!$ - 01,160$ - 0$ - 01,160$ - 0$ - 01,160$ - 0$ - 0- 0ERROR:#DIV/0!$ - 01,160$ - 0$ - 01,160$ - 0$ - 01,160$ - 0$ - 0- 0ERROR:#DIV/0!$ - 01,160$ - 0$ - 01,160$ - 0$ - 01,160$ - 0$ - 0- 0ERROR:#DIV/0!$ - 01,160$ - 0$ - 01,160$ - 0$ - 01,160$ - 0$ - 0- 0ERROR:#DIV/0!
Engineering Level 2 – E2$ - 03,076$ - 0$ - 03,076$ - 0$ - 03,076$ - 0$ - 0- 0ERROR:#DIV/0!$ - 03,076$ - 0$ - 03,076$ - 0$ - 03,076$ - 0$ - 0- 0ERROR:#DIV/0!$ - 03,076$ - 0$ - 03,076$ - 0$ - 03,076$ - 0$ - 0- 0ERROR:#DIV/0!$ - 03,076$ - 0$ - 03,076$ - 0$ - 03,076$ - 0$ - 0- 0ERROR:#DIV/0!$ - 03,076$ - 0$ - 03,076$ - 0$ - 03,076$ - 0$ - 0- 0ERROR:#DIV/0!
Engineering Level 1 – E1$ - 01,730$ - 0$ - 01,730$ - 0$ - 01,730$ - 0$ - 0- 0ERROR:#DIV/0!$ - 01,730$ - 0$ - 01,730$ - 0$ - 01,730$ - 0$ - 0- 0ERROR:#DIV/0!$ - 01,730$ - 0$ - 01,730$ - 0$ - 01,730$ - 0$ - 0- 0ERROR:#DIV/0!$ - 01,730$ - 0$ - 01,730$ - 0$ - 01,730$ - 0$ - 0- 0ERROR:#DIV/0!$ - 01,730$ - 0$ - 01,730$ - 0$ - 01,730$ - 0$ - 0- 0ERROR:#DIV/0!
Technician Level 5 – T5$ - 020$ - 0$ - 020$ - 0$ - 020$ - 0$ - 0- 0ERROR:#DIV/0!$ - 020$ - 0$ - 020$ - 0$ - 020$ - 0$ - 0- 0ERROR:#DIV/0!$ - 020$ - 0$ - 020$ - 0$ - 020$ - 0$ - 0- 0ERROR:#DIV/0!$ - 020$ - 0$ - 020$ - 0$ - 020$ - 0$ - 0- 0ERROR:#DIV/0!$ - 020$ - 0$ - 020$ - 0$ - 020$ - 0$ - 0- 0ERROR:#DIV/0!
Technician Level 4 – T4$ - 0194$ - 0$ - 0194$ - 0$ - 0194$ - 0$ - 0- 0ERROR:#DIV/0!$ - 0194$ - 0$ - 0194$ - 0$ - 0194$ - 0$ - 0- 0ERROR:#DIV/0!$ - 0194$ - 0$ - 0194$ - 0$ - 0194$ - 0$ - 0- 0ERROR:#DIV/0!$ - 0194$ - 0$ - 0194$ - 0$ - 0194$ - 0$ - 0- 0ERROR:#DIV/0!$ - 0194$ - 0$ - 0194$ - 0$ - 0194$ - 0$ - 0- 0ERROR:#DIV/0!
Technician Level 3 – T3$ - 0405$ - 0$ - 0405$ - 0$ - 0405$ - 0$ - 0- 0ERROR:#DIV/0!$ - 0405$ - 0$ - 0405$ - 0$ - 0405$ - 0$ - 0- 0ERROR:#DIV/0!$ - 0405$ - 0$ - 0405$ - 0$ - 0405$ - 0$ - 0- 0ERROR:#DIV/0!$ - 0405$ - 0$ - 0405$ - 0$ - 0405$ - 0$ - 0- 0ERROR:#DIV/0!$ - 0405$ - 0$ - 0405$ - 0$ - 0405$ - 0$ - 0- 0ERROR:#DIV/0!
Technician Level 2 – T2$ - 020$ - 0$ - 020$ - 0$ - 020$ - 0$ - 0- 0ERROR:#DIV/0!$ - 020$ - 0$ - 020$ - 0$ - 020$ - 0$ - 0- 0ERROR:#DIV/0!$ - 020$ - 0$ - 020$ - 0$ - 020$ - 0$ - 0- 0ERROR:#DIV/0!$ - 020$ - 0$ - 020$ - 0$ - 020$ - 0$ - 0- 0ERROR:#DIV/0!$ - 020$ - 0$ - 020$ - 0$ - 020$ - 0$ - 0- 0ERROR:#DIV/0!
Technician Level 1 – T1$ - 020$ - 0$ - 020$ - 0$ - 020$ - 0$ - 0- 0ERROR:#DIV/0!$ - 020$ - 0$ - 020$ - 0$ - 020$ - 0$ - 0- 0ERROR:#DIV/0!$ - 020$ - 0$ - 020$ - 0$ - 020$ - 0$ - 0- 0ERROR:#DIV/0!$ - 020$ - 0$ - 020$ - 0$ - 020$ - 0$ - 0- 0ERROR:#DIV/0!$ - 020$ - 0$ - 020$ - 0$ - 020$ - 0$ - 0- 0ERROR:#DIV/0!
Program Manager$ - 0702$ - 0$ - 0702$ - 0$ - 0702$ - 0$ - 0- 0ERROR:#DIV/0!$ - 0702$ - 0$ - 0702$ - 0$ - 0702$ - 0$ - 0- 0ERROR:#DIV/0!$ - 0702$ - 0$ - 0702$ - 0$ - 0702$ - 0$ - 0- 0ERROR:#DIV/0!$ - 0702$ - 0$ - 0702$ - 0$ - 0702$ - 0$ - 0- 0ERROR:#DIV/0!$ - 0702$ - 0$ - 0702$ - 0$ - 0702$ - 0$ - 0- 0ERROR:#DIV/0!
General Administration$ - 070$ - 0$ - 070$ - 0$ - 070$ - 0$ - 0- 0ERROR:#DIV/0!$ - 070$ - 0$ - 070$ - 0$ - 070$ - 0$ - 0- 0ERROR:#DIV/0!$ - 070$ - 0$ - 070$ - 0$ - 070$ - 0$ - 0- 0ERROR:#DIV/0!$ - 070$ - 0$ - 070$ - 0$ - 070$ - 0$ - 0- 0ERROR:#DIV/0!$ - 070$ - 0$ - 070$ - 0$ - 070$ - 0$ - 0- 0ERROR:#DIV/0!
Total Price @ BEQ$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!

Price Track

PRICE TRACK ($)

DescriptionINITIAL PROPOSAL PRICESchedule ShiftChange in Labor HoursChange in Wrap RatesChange in MaterialChange in IndirectsTotal ChangesFPR PRICE
Delivery Order 01 - Intitial TRN (CLIN 0001)

Sample Epic

LH Rates at BEQ

TOTAL PROPOSAL

Microsoft_Word_Document1.docx For Official Use Only (FOUO)

D-ILS Statement of Objectives 1st DRAFT V ((0) 13-May-2009

ATTACHMENT 7

COST FORMATS

COST/PRICE VOLUME III

DISTRIBUTED COMMON GROUND/SURFACE SYSTEM (DCGS) INTEGRATION BACKBONE (DIB) DEVELOPMENT 5th Edition

19 September 2017

Version: Original i

For Official Use Only (FOUO) image1.emf

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