3. ATTACHMENT 3A - DRAFT EXCEL PRICING WORKBOOK - PRIME - UPDATED (P) - Draft.xlsx

XLSX spreadsheet 469 KB Posted

Attached to
KC-135 Center Console Refresh (CCR) Revision 2
Solicitation number
FA8105_CCR_Rev2
Issued by

About this file

This is a Draft Excel Pricing Workbook template for the KC-135 Center Console Refresh (CCR) contract, designed for offeror cost and pricing submissions. The workbook is structured to capture pricing for both Cost Plus Incentive Fee (CPIF) Engineering and Manufacturing Development (EMD) CLINs (0001-0003) and Firm Fixed Price (FFP) production CLINs (X007-X021) across a 4-year basic period plus six 1-year option periods.

The CPIF EMD CLINs include: CLIN 0001 (Development activities spanning PDR through qualification testing), CLIN 0002 (Simulator Kits), and CLIN 0003 (Systems Integration Laboratory). Offerors must provide detailed labor rates by category and year, indirect rate structures (labor fringe, overhead, G&A, FCCOM, and target fee), and material/subcontractor cost summaries linked to a Consolidated Bill of Material (CBOM). The FFP Production CLINs encompass A-Kits (CLIN X007AA), B-Kits (CLIN X008AA), Support Equipment (X009), Configuration Control/ECOs (X011), Maintenance & Repair (X012), Technical Orders (X013), Simulator Kits (X014), Systems Integration Laboratories (X015), Training (X016), Program Management (X020), and LRU Spares (X021), with pricing calculated by multiplying proposed unit prices by Best Estimated Quantities. Specific CLINs (marked with asterisks) are eligible for prospective price redetermination, capped at 112% for the first redetermination period (Option Periods I-III) and 107% thereafter. All dollar amounts must be rounded to two decimal places, with percentages rounded to four decimal places. The template automatically calculates Total Evaluated Price (TEP) by performance period and includes worksheets for labor inputs by task, material cost summaries, and subcontractor cost breakdowns, with cells requiring offeror input highlighted in yellow.

View the file

Other files

File Type Posted
Draft Solicitation - FA810526RB001 21 May 26.pdf PDF
Draft Solicitation - FA810526RB001 21 May 26 (1).pdf PDF
3. ATTACHMENT 3B - DRAFT EXCEL PRICING WORKBOOK - SUB UPDATED (P) - Draft.xlsx XLSX spreadsheet
4. Attachment 4. KC-135 CCR DRAFT Section L - Instructions to Offerors (1).pdf PDF
5. Attachment 5. KC-135 CCR DRAFT Section M - Evaluation Factors for Award.pdf PDF
DRAFT Solicitation - FA810526RB001.pdf PDF
Attachment 8 - DRAFT TM-86-01R Air Force Technical Manual Contract Requirements (TMCR)_REV2_7 July 2025.pdf PDF
ATTACHMENT 3B - EXCEL PRICING WORKBOOK - SUB.xlsx XLSX spreadsheet
ATTACHMENT 3A - EXCEL PRICING WORKBOOK - PRIME.xlsx XLSX spreadsheet
KC-135 CCR Industry Day Flyer.pdf PDF
DRAFT Exhibit A CCR Revision 2 CDRL Package.pdf PDF
Attachment 9 - DCAA Preaward Survey of Prospective Contractor Accounting System Checklist.pdf PDF
Attachment 4 - DRAFT CCR Section L - Instructions to Offerors (1).pdf PDF
MEMO Draft Solicitation FA810526RB001.pdf PDF
DRAFT SOW Appendix D DD2794_KC-135 CCR.pdf PDF
Attachment 6 - DRAFT CCR Revision 2 Data Rights Assertion Matrix.pdf PDF
Attachment 7 -DRAFT CCR DD254 - Feb 2026.pdf PDF
Attachment 5 - DRAFT CCR Section M - Evaluation Factors for Award (1).pdf PDF
Attachment 4 - DRAFT CCR Section L - Instructions to Offerors.pdf PDF
Attachment 5 - DRAFT CCR Revision 2 Section M - Evaluation Factors for Award as of 25 Feb.pdf PDF
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

INSTRUCTIONS

Source Selection Information - See FAR 2.101 and 3.104
KC-135 Center Console Refresh (CCR) Source Selection
Attachment 3A, EPW - PRIME
Notes:
1. The worksheet tabs highlighted in yellow within Attachment 3A require Offeror input; the cells within each worksheet requiring input are highlighted in yellow
2. All proposed dollar amounts and labor rates shall be rounded to two decimal places. All proposed rates in percentages shall be rounded to four decimal places (ex. .0755 = 7.55%)
3. The Total Evaluated Price (TEP) is calculated by multiplying the Best Estimated Quantities (BEQs) by the amounts proposed for the FFP and CPIF CLINs. The TEP will automatically calculate in the "SUMMARY" worksheet
4. The Total Evaluated Price (TEP) by performance period will automatically calculate on the "TOTAL EVALUATED PRICE ROLLUP" worksheet

Instructions for completing this Pricing Matrix/Cost Model:

Pricing Matrix - FFP CLINs X007 - X016, X020, and X021:
1Offerors are required to input the proposed unit prices into the "FFP CLINs X007-X021" worksheet in ALL yellow highlighted cells (Offeror Name in Cell B1 and dollar amounts in Columns F, J, N, R, V, Z, and AD)
2Offerors are required to input the supporting information and proposed quantities/unit prices for the Production Spares for the B-Kit in the "SPARES-FFP CLIN X021 INPUTS" worksheet. The total amount by period will automatically populate the "FFP CLINs X007-X021" worksheet for CLIN X021
3The extended price for CLINs X007 - X021 will be automatically calculated by multiplying the proposed unit price by the best estimated evaluation quantity
4A subtotal price will be automatically calculated at the bottom of each contract period/year
5The total proposed amounts for the FFP CLINs will automatically populate the "SUMMARY" worksheet, which will ultimately calculate the Total Evaluated Price (TEP)
Cost Model - CPIF CLINs 0001 - 0003:
1Refer to the "Notes" on each CPIF worksheet for specific information/instructions
2The format of the Cost Model worksheets entitled "PRIME CPIF RATES (ALL)", "PRIME CPIF RATE DESC (ALL)", "PRIME CPIF LABOR by TASK", "PRIME CPIF LABOR INPUTS", "PRIME CPIF TOTAL MATERIAL", "PRIME CPIF TOTAL SUB", "PRIME CPIF TOTAL ODC" and "CPIF CLIN 000X-TASK 1.XX INPUTS" may be revised by the Offeror as necessary; if revisions are made, Offerors shall ensure properly linking to corresponding worksheets
3The "CPIF CLIN 000X-TASK 1.XX INPUTS" worksheets are linked to the "PRIME CPIF RATES (ALL)", "PRIME CPIF LABOR INPUTS", "PRIME CPIF TOTAL MATERIAL", "PRIME CPIF TOTAL SUB", and "PRIME CPIF TOTAL ODC" worksheets. Inputs in the "CPIF CLIN 000X-TASK 1.XX INPUTS" worksheets are not required, but the format of these worksheets may be revised, if necessary
4The "CPIF CLIN 000X TOTAL" worksheets are linked to the "CPIF CLIN 000X-TASK 1.XX INPUTS" worksheets; no inputs are required, but the format of these worksheets should be revised to align with "CPIF 000X-TASK 1.XX INPUTS" worksheets, if necessary
5The "CPIF CLIN 000X SUMMARY" worksheets includes links to the "CPIF CLIN 000X-TASK 1.XX INPUTS" worksheets; no inputs required
6The total proposed amounts for the CPIF CLINs will automatically populate the "SUMMARY" worksheet, which will ultimately calculate the TEP; no inputs required
7The minimum fees, maximum fees, and share ratios are provided by the Government in the "CPIF CLIN BREAKDOWN" worksheet. The CPIF CLIN breakout by Target Cost, Target Fee, Target FCCOM, and Target Price will automatically populate the "CPIF CLIN BREAKDOWN" worksheet for each CPIF CLIN based on the Offeror's inputs in the above worksheets; no inputs required.

CALCULATION METHODOLOGY

KC-135 CCR EXCEL PRICING WORKBOOK (EPW) - CALCULATION METHODOLOGY - PRIME OFFEROR
CLINCONTRACT TYPEDESCRIPTIONCALCULATION METHODOLOGY
EMD
0001CPIFDevelopment PDR, Post PDR, PICO, Test, Software, Support Equipment, Prototype Support Equipment, MaterialProposed target price for EMD CLIN 0001 based on inputs from EMD CPIF worksheets (lot price)
0002CPIFSimulator KitsProposed target price for EMD CLIN 0002 based on inputs from EMD CPIF worksheets (lot price)
0003CPIFSystems Integration Laboratory (SIL)Proposed target price for EMD CLIN 0003 based on inputs from EMD CPIF worksheets (lot price)
0004NSPData - EMDNot evaluated
0005CR-NFTravel - EMDNot evaluated
0006NSPIntellectual PropertyNot evaluated
PRODUCTION
X007AAFFPProduction A-KITSProposed unit price (fully burdened) multiplied by best estimated quantity of A-Kits for each performance period
0007ABFFPFirst Article Inspection - Production A-KITSProposed unit price (fully burdened) multiplied by the best estimated quantity of A-Kit First Articles in Option Period I
X008AAFFPProduction B-KITSProposed unit price (fully burdened) multiplied by best estimated quantity of B-Kits for each performance period
0008ABFFPFirst Article Inspection - Production B-KITSProposed unit price (fully burdened) multiplied by the best estimated quantity of B-Kit First Articles in Option Period I
X009FFPSupport EquipmentProposed lot price (fully burdened) for Support Equipment for each performance period
X010FFPInstallations SurgeNot evaluated (To Be Negotiated)
X011FFPProduction Configuration Control/Engineering Change OrdersProposed monthly price (fully burdened) multiplied by quantity of months in the performance period
X012FFPMaintenance & Repair SupportProposed monthly price (fully burdened) multiplied by quantity of months in the performance period
X013FFPTechnical OrdersProposed monthly price (fully burdened) multiplied by quantity of months in the performance period
X014FFPSimulator KitsProposed unit price (fully burdened) multiplied by best estimated quantity of Simulator Kits for each performance period
X015FFPSystems Integration LaboratoriesProposed unit price (fully burdened) multiplied by best estimated quantity of SILs for each performance period
X016FFPTrainingProposed monthly price (fully burdened) multiplied by quantity of months in the performance period
X017NSPData - ProductionNot evaluated
X018CR-NFTravel - ProductionNot evaluated
X019CR-NFOver & Above (O&A)Not evaluated
X020FFPProgram Management - Production & Deployment (P&D)Proposed monthly price (fully burdened) multiplied by quantity of months in the performance period
X021FFPLine Replacement Unit (LRU) SparesProposed unit price (fully burdened) multiplied by best estimated quantity of Production Spare Kits (unit price calculated by inputs in the "Spares-FFP CLIN X021 INPUTS" worksheet) for each performance period

SOURCE SELECTION INFORMATION - SEE FAR 2.101 and 3.104

SOURCE SELECTION INFORMATION - SEE FAR 2.101 and 3.104

OVERALL SUMMARY

PRIME OFFEROR NAME

Notes:
1. Proposed CLIN unit costs/prices are linked to the "CPIF CLIN 000X TOTAL" and "FFP CLINs X007 - X021" worksheets; no input required
2. To calculate the final TEP, unit prices will automatically be rounded to the nearest dollar
3. CLINs notated with an asterisk (*) indicate firm fixed prices eligible for price redetermination (prospective) per RFO 52.216-75 (reference notes included in the "FFP CLINs X007 - X021" worksheet) After contract award, redetermined pricing will be capped at 112% of the initial proposed price for the first redetermination period (applicable to Option Periods I through III). Redetermined pricing will be capped at 107% of the FFP pricing in effect for the second redetermination period (beginning in Option Period IV)
KC-135 Center Console Refresh (CCR) Competitive Pricing Matrix SUMMARYBasic Period (48 months)Option Period I Performance
(12 months)Option Period II Performance
(12 months)Option Period III Performance
(12 months)Option Period IV Performance
(12 months)Option Period V Performance
(12 months)Option Period VI Performance

(12 months) CLIN Description Contract Type Unit of Issue Basic Period CLIN Qty/BEQ Unit Price Extended Price (Rounded) Option Period I CLIN Qty/BEQ Unit Price Extended Price (Rounded) Option Period II CLIN Qty/BEQ Unit Price Extended Price (Rounded) Option Period III CLIN Qty/BEQ Unit Price Extended Price (Rounded) Option Period IV CLIN Qty/BEQ Unit Price Extended Price (Rounded) Option Period V CLIN Qty/BEQ Unit Price Extended Price (Rounded) Option Period VI CLIN Qty/BEQ Unit Price Extended

Price (Rounded)TOTAL EVALUATED PRICE
EMDEMDEMDEMDEMDEMDEMDEMD
Development PDR, Post PDR, PICO, Test, Software, Support Equipment, Prototype Support Equipment, MaterialCost Plus Incentive Fee (CPIF)Lot00011$ - 0$ - 0$ - 0
Simulator KitsCPIFLot00021$ - 0$ - 0$ - 0
Systems Integration Laboratory (SIL)CPIFLot00031$ - 0$ - 0$ - 0
Data - EMDNot Separately Priced (NSP)N/A0004
Travel - EMDCost Reimbursable - No Fee (CR-NF)N/A0005
Intellectual PropertyNSPN/A0006
PRODUCTIONPRODUCTIONPRODUCTIONPRODUCTIONPRODUCTIONPRODUCTIONPRODUCTIONPRODUCTION
Production A-KITSFFPEach0007AA10$ - 0$ - 01007AA*50$ - 0$ - 02007AA*50$ - 0$ - 03007AA*47$ - 0$ - 04007AA*45$ - 0$ - 05007AA*45$ - 0$ - 06007AA*53$ - 0$ - 0$ - 0
Production A-KITS - First ArticleFFPEach0007AB2$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 000$ - 0$ - 00$ - 0$ - 0$ - 0
Production B-KITSFFPEach0008AA10$ - 0$ - 01008AA*45$ - 0$ - 02008AA*45$ - 0$ - 03008AA*45$ - 0$ - 04008AA*45$ - 0$ - 05008AA*45$ - 0$ - 06008AA*53$ - 0$ - 0$ - 0
Production B-KITS - First ArticleFFPEach0008AB2$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 000$ - 0$ - 00$ - 0$ - 0$ - 0
Support EquipmentFFPLot00091$ - 0$ - 01009*1$ - 0$ - 02009*1$ - 0$ - 03009*1$ - 0$ - 04009*1$ - 0$ - 05009*1$ - 0$ - 06009*1$ - 0$ - 0$ - 0
Installations SurgeFFPEach0010101020100$ - 030100$ - 040100$ - 0501006010
Production Configuration Control/Engineering Change OrdersFFPMonth001112$ - 0$ - 0101112$ - 0$ - 0201112$ - 0$ - 0301112$ - 0$ - 0401112$ - 0$ - 0501112$ - 0$ - 0601112$ - 0$ - 0$ - 0
Maintenance & Repair SupportFFPMonth0012101212$ - 0$ - 0201212$ - 0$ - 0301212$ - 0$ - 0401212$ - 0$ - 0501212$ - 0$ - 0601212$ - 0$ - 0$ - 0
Technical OrdersFFPMonth0013101312$ - 0$ - 0201312$ - 0$ - 0301312$ - 0$ - 0401312$ - 0$ - 0501312$ - 0$ - 0601312$ - 0$ - 0$ - 0
Simulator KitsFFPEach00143$ - 0$ - 01014*6$ - 0$ - 02014*6$ - 0$ - 03014*6$ - 0$ - 0401450146014$ - 0
System Integration LaboratoriesFFPEach001510152015*1$ - 0$ - 03015401550156015$ - 0$ - 0
TrainingFFPMonth001612$ - 0$ - 0101612$ - 0$ - 0201612$ - 0$ - 0301612$ - 0$ - 0401612$ - 0$ - 0501612$ - 0$ - 0601612$ - 0$ - 0$ - 0
Data - ProductionNSPN/A0017101720173017401750176017
Travel - ProductionCR-NFN/A0018101820183018401850186018
Over & Above (O&A)CR-NFN/A0019101920193019401980196019
Program Management - Production & Deployment (P&D)FFPMonth002012$ - 0$ - 0102012$ - 0$ - 0202012$ - 0$ - 0302012$ - 0$ - 0402012$ - 0$ - 0502012$ - 0$ - 0602012$ - 0$ - 0$ - 0
Line Replacement Unit (LRU) SparesFFPEach00212$ - 0$ - 01021*6$ - 0$ - 02021*7$ - 0$ - 03021*8$ - 0$ - 04021*10$ - 0$ - 05021*10$ - 0$ - 06021*7$ - 0$ - 0$ - 0
TOTAL$ - 0TOTAL$ - 0TOTAL$ - 0TOTAL$ - 0TOTAL$ - 0TOTAL$ - 0TOTAL$ - 0$ - 0TOTAL EVALUATED PRICE

$ - 0 Double Check

TOTAL EVALUATED PRICE ROLLUP

PRIME OFFERORNAME
PERIOD OF PERFORMANCEPRICE
ESTIMATED TOTAL PRICE FOR BASIC PERIOD (48 MONTHS)$0.00
ESTIMATED TOTAL PRICE FOR OPTION PERIOD I (12 MONTHS)$0.00
ESTIMATED TOTAL PRICE FOR OPTION PERIOD II (12 MONTHS)$0.00
ESTIMATED TOTAL PRICE FOR OPTION PERIOD III (12 MONTHS)$0.00
ESTIMATED TOTAL PRICE FOR OPTION PERIOD IV (12 MONTHS)$0.00
ESTIMATED TOTAL PRICE FOR OPTION PERIOD V (12 MONTHS)$0.00
ESTIMATED TOTAL PRICE FOR OPTION PERIOD VI (12 MONTHS)$0.00
TOTAL EVALUATED PRICE (TEP) = (1) 4-YEAR BASIC PERIOD + (6) 1-YEAR OPTION PERIODS$0.00

FFP CLINs X007-X021

PRIME OFFEROR NAME

Notes:
1. Input the Prime Offeror's name in cell B1
2. Insert proposed unit prices in all yellow-highlighted cells
3. All proposed prices shall be rounded to the nearest dollar
4. All proposed prices shall be proposed sufficiently to ensure adequate coverage of all labor costs, all subcontractor costs, all indirect costs, including G&A, COM, and so forth as well as prime and subcontractor profit in every contract out-year
5. CLINs notated with an asterisk (*) indicate firm fixed prices eligible for price redetermination (prospective) per RFO 52.216-75. After contract award, redetermined pricing will be capped at 112% of the initial proposed price for the first redetermination period (applicable to Option Periods I through III). Redetermined pricing will be capped at 107% of the FFP pricing in effect for the second redetermination period (beginning in Option Period IV)
6. No format changes on this worksheet are permitted
KC-135 Center Console Refresh (CCR) Competitive Pricing Matrix FFP CLINSBasic Period (48 months)Option Period I Performance
(12 months)Option Period II Performance
(12 months)Option Period III Performance
(12 months)Option Period IV Performance
(12 months)Option Period V Performance
(12 months)Option Period VI Performance

(12 months) CLIN Description Contract Type Unit of Issue Basic Period CLIN

BEQ

Unit Price Extended Price Option Period I CLIN

BEQ

Unit Price Extended Price Option Period II CLIN

BEQ

Unit Price Extended Price Option Period III CLIN

BEQ

Unit Price Extended Price Option Period IV CLIN

BEQ

Unit Price Extended Price Option Period V CLIN

BEQ

Unit Price Extended Price Option Period IV CLIN

BEQ

Unit Price Extended

PriceTOTAL EVALUATED PRICE - FFP
PRODUCTION CLINs
Production A-KITSFFPEach0007AA10$ - 0$ - 01007AA*50$ - 0$ - 02007AA*50$ - 0$ - 03007AA*47$ - 0$ - 04007AA*45$ - 0$ - 05007AA*45$ - 0$ - 06007AA*53$ - 0$ - 0$ - 0
First Article Inspection - Production A-KITSFFPEach0007AB2$ - 0$ - 0N/A$ - 0$ - 0N/A$ - 0$ - 0N/A$ - 0$ - 0N/A$ - 0$ - 0N/A0$ - 0$ - 0N/A0$ - 0$ - 0$ - 0
Production B-KITSFFPEach0008AA10$ - 0$ - 01008AA*45$ - 0$ - 02008AA*45$ - 0$ - 03008AA*45$ - 0$ - 04008AA*45$ - 0$ - 05008AA*45$ - 0$ - 06008AA*53$ - 0$ - 0$ - 0
First Article Inspection - Production B-KITSFFPEach0008AB2$ - 0$ - 0N/A$ - 0$ - 0N/A$ - 0$ - 0N/A$ - 0$ - 0N/A$ - 0$ - 0N/A0$ - 0$ - 0N/A0$ - 0$ - 0$ - 0
Support EquipmentFFPLot00091$ - 0$ - 01009*1$ - 0$ - 02009*1$ - 0$ - 03009*1$ - 0$ - 04009*1$ - 0$ - 05009*1$ - 0$ - 06009*1$ - 0$ - 0$ - 0
Installations SurgeFFPEach0010101020103010401050106010
Production Configuration Control/Engineering Change OrdersFFPMonth001112$ - 0$ - 0101112$ - 0$ - 0201112$ - 0$ - 0301112$ - 0$ - 0401112$ - 0$ - 0501112$ - 0$ - 0601112$ - 0$ - 0$ - 0
Maintenance & Repair SupportFFPMonth0012101212$ - 0$ - 0201212$ - 0$ - 0301212$ - 0$ - 0401212$ - 0$ - 0501212$ - 0$ - 0601212$ - 0$ - 0$ - 0
Technical OrdersFFPMonth0013101312$ - 0$ - 0201312$ - 0$ - 0301312$ - 0$ - 0401312$ - 0$ - 0501312$ - 0$ - 0601312$ - 0$ - 0$ - 0
Simulator KitsFFPEach00143$ - 0$ - 01014*6$ - 0$ - 02014*6$ - 0$ - 03014*6$ - 0$ - 0401450146014$ - 0
System Integration LaboratoriesFFPEach001510152015*1$ - 0$ - 03015401550156015$ - 0
TrainingFFPMonth001612$ - 0$ - 0101612$ - 0$ - 0201612$ - 0$ - 0301612$ - 0$ - 0401612$ - 0$ - 0501612$ - 0$ - 0601612$ - 0$ - 0$ - 0
Data - ProductionNSPN/A0017101720173017401750176017
Travel - ProductionCR-NFN/A0018101820183018401850186018
Over & Above (O&A)CR-NFN/A0019101920193019401980196019
Program Management - Production & Deployment (P&D)FFPMonth002012$ - 0$ - 0102012$ - 0$ - 0202012$ - 0$ - 0302012$ - 0$ - 0402012$ - 0$ - 0502012$ - 0$ - 0602012$ - 0$ - 0$ - 0
Line Replacement Unit (LRU) Spares*FFPEach00212$ - 0$ - 01021*6$ - 0$ - 02021*7$ - 0$ - 03021*8$ - 0$ - 04021*10$ - 0$ - 05021*10$ - 0$ - 06021*7$ - 0$ - 0$ - 0
*See 'SPARES-FFP CLIN X021 INPUTS' worksheet to input individual components of the spare B-KITS; the extended totals will automatically populate in cells F23, J23, N23, R23, V23, Z23, and AD23)TOTAL FFP$ - 0TOTAL FFP$ - 0TOTAL FFP$ - 0TOTAL FFP$ - 0TOTAL FFP$ - 0TOTAL FFP$ - 0TOTAL FFP$ - 0$ - 0TOTAL EVALUATED PRICE - FFP
$ - 0Double Check
$ - 0Difference should be $0

SPARES-FFP CLIN X021 INPUTS

PRIME OFFEROR NAME

Notes:
1. The Offeror is required to list the individual parts within the B-Kit below, along with unit pricing and quantities for the individual parts in each shipset; reference Statement of Work (SOW) Paragraph 13.7.1
2. The unit prices for B-Kit parts will be multiplied by the proposed quantity to arrive at a total amount for CLIN X021 LRU Spares for each performance period
3. The Offeror shall provide the required information in the table below (amend as necessary). Additional information may be provided in contractor format. If contractor format is utilized, the information shown in the table below must be included at a minimum.
4. The Offeror shall ensure the total proposed amounts by period properly link to the "FFP CLINs X007-X021" worksheet for CLIN X021
CLIN X021 - LRU Spares (for B-Kits)Basic PeriodOption Period IOption Period IIOption Period IIIOption Period IVOption Period VOption Period VI
NSNP/NItem DescriptionQtyUnit PriceExtendedUnit PriceExtendedUnit PriceExtendedUnit PriceExtendedUnit PriceExtendedUnit PriceExtendedUnit PriceExtended
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
TOTAL$0.00$0.00$0.00$0.00$0.00$0.00$0.00

PRIME CPIF RATES (ALL)

PRIME OFFEROR NAME

KC-135 Center Console Refresh (CCR) Prime Contractor Direct Labor and Indirect Rates

Notes:
1. The format of this worksheet may be revised as required to be consistent with the Prime Offeror's approved Accounting System to include, but not limited to, inserting additional labor categories and revising the indirect rate structure
2. The Prime Offeror shall propose labor rates and indirect rates in the yellow-highlighted cells below. All proposed labor rates shall be rounded to two (2) decimal places. All rates in percentages shall be rounded to four decimal places (ex. .0755 = 7.55%)
3. The Prime Offeror shall input the proposed rates and indirect rates below and ensure these cells are linked correctly to the relevant CPIF rate cells on the "CPIF CLIN 0001 - TASK 1.0X" INPUTS", "CPIF CLIN 0002 - TASK 1.0X INPUTS", and "CPIF CLIN 0003 - TASK 1.0X INPUTS" worksheets
4. The Prime Offeror shall provide descriptions of the labor categories and indirect rates in the "PRIME CPIF Rate Desc (All)" worksheet, in addition to base costs upon which indirect rates apply
5. The Prime Offeror shall ensure that all labor and indirect rate categories included in the proposal for EMD CLINs 0001, 0002, and 0003 are included in this worksheet
Proposed Direct Labor Rates
Basic (Year 1)Basic (Year 2)Basic (Year 3)Basic (Year 4)
Labor CategoryHourly RateHourly RateHourly RateHourly Rate
Insert all direct labor categories that apply (add more rows if necessary); make changes to below categories accordingly and ensure cells properly link to the 'CPIF CLIN 000X - TASK 1.XX INPUTS' worksheets for CLINs 0001,0002, and 0003
Proposed Indirect Rates/Factors
Indirect Rate Category (Labor)Basic (Year 1)Basic (Year 2)Basic (Year 3)Basic (Year 4)
Insert all indirect categories that apply to labor costs; make changes to below categories accordingly and ensure cells properly link to the 'CPIF CLIN 000X - TASK 1.XX INPUTS' worksheets (Columns E, I, and M for CLINs 0001,0002, and 0003) and align with the rates reflected in the 'PRIME CPIF Rate Desc (All)' worksheet
Indirect Labor Category: [Labor Fringe]
Indirect Labor Category: [Labor Overhead]
Indirect Labor Category: [G&A]
Indirect Labor Category: [FCCOM]
Indirect Labor Category: [Target Fee]
Proposed Subcontractor Rates/Factors (Burdens added by Prime to Subcontractor Costs)
Indirect Rate Category (Subcontractor)Basic (Year 1)Basic (Year 2)Basic (Year 3)Basic (Year 4)
Insert all indirect categories that the prime offeror will apply to subcontractor costs; make changes to below categories accordingly and ensure cells link properly to the 'CPIF CLIN 000X - TASK 1.XX INPUTS' worksheets (Columns E, I, and M for CLINs 0001, 0002, and 0003) and align with the rates reflected in the 'PRIME CPIF Rate Desc (All)' worksheet
Indirect Category: [Overhead]`
Indirect Category: [G&A]
Indirect Category: [FCCOM]
Indirect Category: [Target Fee]
Proposed Material Rates/Factors
Indirect Rate Category (Material)Basic (Year 1)Basic (Year 2)Basic (Year 3)Basic (Year 4)
Insert all indirect categories that apply to material costs; make changes to below categories accordingly and ensure cells link properly to the 'CPIF CLIN 000X - TASK 1.XX INPUTS' worksheets (Columns, E, I, and M for CLINs 0001, 0002, and 0003) and align with the rates reflected in the 'PRIME CPIF Rate Desc (All)' worksheet
Indirect Category: [Material Overhead]
Indirect Category: [G&A]
Indirect Category: [FCCOM]
Indirect Category: [Target Fee]
Proposed Other Direct Cost (ODC) Rates/Factors
Indirect ODC Category (Other)Basic (Year 1)Basic (Year 2)Basic (Year 3)Basic (Year 4)
Insert all indirect categories that apply to ODC; make changes to below categories accordingly and ensure cells link properly to the 'CPIF CLIN 000X - TASK 1.XX INPUTS' worksheets (Columns, E, I, and M for CLINs 0001, 0002, and 0003) and align with the rates reflected in the 'PRIME CPIF Rate Desc (All)' worksheet
Indirect Category: [Overhead]
Indirect Category: [G&A]
Indirect Category: [FCCOM]
Indirect Category: [Target Fee]

PRIME CPIF RATE DESC (ALL)

PRIME OFFEROR NAME

KC-135 Center Console Refresh (CCR) Prime Contractor Direct Labor and Indirect Rates

Notes:
1. The format of this worksheet may be revised as required to be consistent with the Prime Offeror's approved Accounting System to include, but not limited to, inserting additional labor categories and revising the indirect rate structure
2. The Prime Offeror shall list all proposed labor categories and provide a summary description for each labor category
3. The Prime Offeror shall list all proposed indirect rate categories, and provide a summary description of each indirect rate category along with the base cost upon which the indirect rate is applied
4. The Prime Offeror shall ensure that all labor and indirect rate categories included in the proposal for EMD CLINs 0001, 0002, and 0003 are included in this worksheet

Labor Category and Indirect Rate Descriptions

Labor CategoryDescription
Example Labor Category: Systems Engineer/IntegratorConducts comprehensive system-wide review and analysis of all aspects of the development life cycle. Provides expertise in the transition of legacy systems to modernized systems.
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Indirect Rate CategoryDescriptionAllocation Base (Provide the base upon which the Indirect Rate is applied)
Example: Labor FringeIncludes employee retirement plans, health insurance, and paid time off for sick leave and vacationThe base for Labor Fringe is total direct labor costs
Labor Fringe
Overhead (Labor)
Overhead (Material)
Overhead (Subcontractor)
Overhead (ODC)
General & Administrative (G&A)
Facilities Capital Cost of Money (FCCOM)
Target Fee

PRIME CPIF LABOR by TASK

PRIME OFFEROR NAME

KC-135 Center Console Refresh (CCR) Prime Contractor Labor by Task

Notes:
1. The format of this worksheet shall be revised to include every WBS (at the sub-task level) with proposed labor (if a WBS does not include proposed labor, do not include below)
2. At the sub-WBS level, the Prime Offeror shall provide the task to be performed, the labor category proposed to perform this task, the number of Full-Time Equivalents (FTEs) and corresponding labor hours to be utilized, and rationale to support the proposed labor
3. An example input has been provided in the template below (for illustrative purposes only); offerors shall delete the example in their proposal submission
Task NumberTaskLabor Category# FTEs/HoursRationale
Example - For Illustrative Purposes Only
1.01Development Thru PDR
1.01.01ADD TITLE HEREENGINEER I2 FTEs x 1,784 hoursTo develop engineering plans
ENGINEER IITo evaluate engineering plans
QUALITY SPECIALISTTo evaluate quality of the engineering plans

PRIME CPIF LABOR INPUTS

PRIME OFFEROR NAME

Notes:
1. The format of this worksheet should be revised as required to include all proposed labor by task
2. The Prime Offeror shall input the proposed labor categories and corresponding labor hours by task (at the sub-task level) in the yellow-highlighted cells below; ensure consistency with the "PRIME LABOR by TASK" worksheet
3. The Prime Offeror shall ensure that the proposed labor rates properly link to the corresponding labor rates reflected in the "PRIME-CPIF RATES (ALL)" worksheet
4. The Prime Offeror shall ensure that all labor categories included in the proposal for EMD CLINs 0001, 0002, and 0003 are included in this worksheet
CLIN 0001 DEVELOPMENT, TASK 1.01 DEVELOPMENT THROUGH PDR (CLIN 0001AA)PROPOSED COSTS/PRICES - LABORPROPOSED COSTS/PRICES - LABORPROPOSED COSTS/PRICES - LABORPROPOSED COSTS/PRICES - LABOR
Basic Period (Year 1)Basic Period (Year 2)Basic Period (Year 3)Basic Period (Year 4)
Labor CategoryTaskLabor HoursLabor RatesDirect Labor CostLabor HoursLabor RatesDirect Labor CostLabor HoursLabor RatesDirect Labor CostLabor HoursLabor RatesDirect Labor Cost
Insert all labor categories that apply; add/delete rows as necessary and ensure cells in Columns E, I, and M are properly linked to the rates in the 'PRIME-CPIF RATES (ALL)' worksheetInsert applicable task by labor category at sub-task level (ex. 1.01.01, 1.01.02, and so forth); ensure consistency with the 'PRIME CPIF LABOR by TASK' worksheetInsert proposed labor hours by labor category and sub-taskLink corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheetInsert proposed labor hours by labor category and sub-taskLink corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheetInsert proposed labor hours by labor category and sub-taskLink corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheetInsert proposed labor hours by labor category and sub-taskLink corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet
Labor Category : [INSERT LABOR CATEGORY NAME HERE]1.01.010$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]1.01.020$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]1.01.030$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
TOTAL DIRECT LABOR HOURS/COST0$0.000$0.000$0.000$0.00
CLIN 0001 DEVELOPMENT, TASK 1.02 DEVELOPMENT FROM PDR TO CDR (CLIN 0001AB)PROPOSED COSTS/PRICES - LABORPROPOSED COSTS/PRICES - LABORPROPOSED COSTS/PRICES - LABORPROPOSED COSTS/PRICES - LABOR
Basic Period (Year 1)Basic Period (Year 2)Basic Period (Year 3)Basic Period (Year 4)
Labor CategoryTaskLabor HoursLabor RatesDirect Labor CostLabor HoursLabor RatesDirect Labor CostLabor HoursLabor RatesDirect Labor CostLabor HoursLabor RatesDirect Labor Cost
Insert all labor categories that apply; add/delete rows as necessary and ensure cells in Columns E, I, and M are properly linked to the rates in the 'PRIME-CPIF RATES (ALL)' worksheetInsert applicable task by labor category at sub-task level (ex. 1.01.01, 1.01.02, and so forth); ensure consistency with the 'PRIME CPIF LABOR by TASK' worksheetInsert proposed labor hours by labor category and sub-taskLink corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheetInsert proposed labor hours by labor category and sub-taskLink corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheetInsert proposed labor hours by labor category and sub-taskLink corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheetInsert proposed labor hours by labor category and sub-taskLink corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet
Labor Category : [INSERT LABOR CATEGORY NAME HERE]1.02.010$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]1.02.020$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]1.02.030$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
TOTAL DIRECT LABOR HOURS/COST0$0.000$0.000$0.000$0.00
CLIN 0001 DEVELOPMENT, TASK 1.03 SYSTEM TEST AND EVALUATION (CLIN 0001AC)PROPOSED COSTS/PRICES - LABORPROPOSED COSTS/PRICES - LABORPROPOSED COSTS/PRICES - LABORPROPOSED COSTS/PRICES - LABOR
Basic Period (Year 1)Basic Period (Year 2)Basic Period (Year 3)Basic Period (Year 4)
Labor CategoryTaskLabor HoursLabor RatesDirect Labor CostLabor HoursLabor RatesDirect Labor CostLabor HoursLabor RatesDirect Labor CostLabor HoursLabor RatesDirect Labor Cost
Insert all labor categories that apply; add/delete rows as necessary and ensure cells in Columns E, I, and M are properly linked to the rates in the 'PRIME-CPIF RATES (ALL)' worksheetInsert applicable task by labor category at sub-task level (ex. 1.01.01, 1.01.02, and so forth); ensure consistency with the 'PRIME CPIF LABOR by TASK' worksheetInsert proposed labor hours by labor category and sub-taskLink corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheetInsert proposed labor hours by labor category and sub-taskLink corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheetInsert proposed labor hours by labor category and sub-taskLink corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheetInsert proposed labor hours by labor category and sub-taskLink corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet
Labor Category : [INSERT LABOR CATEGORY NAME HERE]1.03.010$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]1.03.020$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]1.03.030$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
TOTAL DIRECT LABOR HOURS/COST0$0.000$0.000$0.000$0.00
CLIN 0001 DEVELOPMENT, TASK 1.04 DEVELOPMENT KITS (COTS AND DEVELOPMENTAL) (CLIN 0001AD)PROPOSED COSTS/PRICES - LABORPROPOSED COSTS/PRICES - LABORPROPOSED COSTS/PRICES - LABORPROPOSED COSTS/PRICES - LABOR
Basic Period (Year 1)Basic Period (Year 2)Basic Period (Year 3)Basic Period (Year 4)
Labor CategoryTaskLabor HoursLabor RatesDirect Labor CostLabor HoursLabor RatesDirect Labor CostLabor HoursLabor RatesDirect Labor CostLabor HoursLabor RatesDirect Labor Cost
Insert all labor categories that apply; add/delete rows as necessary and ensure cells in Columns E, I, and M are properly linked to the rates in the 'PRIME-CPIF RATES (ALL)' worksheetInsert applicable task by labor category at sub-task level (ex. 1.01.01, 1.01.02, and so forth); ensure consistency with the 'PRIME CPIF LABOR by TASK' worksheetInsert proposed labor hours by labor category and sub-taskLink corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheetInsert proposed labor hours by labor category and sub-taskLink corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheetInsert proposed labor hours by labor category and sub-taskLink corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheetInsert proposed labor hours by labor category and sub-taskLink corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet
Labor Category : [INSERT LABOR CATEGORY NAME HERE]1.04.010$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]1.04.020$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]1.04.030$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
TOTAL DIRECT LABOR HOURS/COST0$0.000$0.000$0.000$0.00
CLIN 0001 DEVELOPMENT, TASK 1.05 PROTOTYPE SUPPORT, INSTALLATION, AND CHECKOUT (CLIN 0001AE)PROPOSED COSTS/PRICES - LABORPROPOSED COSTS/PRICES - LABORPROPOSED COSTS/PRICES - LABORPROPOSED COSTS/PRICES - LABOR
Basic Period (Year 1)Basic Period (Year 2)Basic Period (Year 3)Basic Period (Year 4)
Labor CategoryTaskLabor HoursLabor RatesDirect Labor CostLabor HoursLabor RatesDirect Labor CostLabor HoursLabor RatesDirect Labor CostLabor HoursLabor RatesDirect Labor Cost
Insert all labor categories that apply; add/delete rows as necessary and ensure cells in Columns E, I, and M are properly linked to the rates in the 'PRIME-CPIF RATES (ALL)' worksheetInsert applicable task by labor category at sub-task level (ex. 1.01.01, 1.01.02, and so forth); ensure consistency with the 'PRIME CPIF LABOR by TASK' worksheetInsert proposed labor hours by labor category and sub-taskLink corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheetInsert proposed labor hours by labor category and sub-taskLink corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheetInsert proposed labor hours by labor category and sub-taskLink corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheetInsert proposed labor hours by labor category and sub-taskLink corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet
Labor Category : [INSERT LABOR CATEGORY NAME HERE]1.05.010$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]1.05.020$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]1.05.030$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
TOTAL DIRECT LABOR HOURS/COST0$0.000$0.000$0.000$0.00
CLIN 0001 DEVELOPMENT, TASK 1.06 QUALIFICATION, DEVELOPMENTAL, AND OPERATIONAL TESTING (CLIN 0001AF)PROPOSED COSTS/PRICES - LABORPROPOSED COSTS/PRICES - LABORPROPOSED COSTS/PRICES - LABORPROPOSED COSTS/PRICES - LABOR
Basic Period (Year 1)Basic Period (Year 2)Basic Period (Year 3)Basic Period (Year 4)
Labor CategoryTaskLabor HoursLabor RatesDirect Labor CostLabor HoursLabor RatesDirect Labor CostLabor HoursLabor RatesDirect Labor CostLabor HoursLabor RatesDirect Labor Cost
Insert all labor categories that apply; add/delete rows as necessary and ensure cells in Columns E, I, and M are properly linked to the rates in the 'PRIME-CPIF RATES (ALL)' worksheetInsert applicable task by labor category at sub-task level (ex. 1.01.01, 1.01.02, and so forth); ensure consistency with the 'PRIME CPIF LABOR by TASK' worksheetInsert proposed labor hours by labor category and sub-taskLink corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheetInsert proposed labor hours by labor category and sub-taskLink corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheetInsert proposed labor hours by labor category and sub-taskLink corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheetInsert proposed labor hours by labor category and sub-taskLink corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet
Labor Category : [INSERT LABOR CATEGORY NAME HERE]1.06.010$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]1.06.020$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]1.06.030$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
TOTAL DIRECT LABOR HOURS/COST0$0.000$0.000$0.000$0.00
CLIN 0001 DEVELOPMENT, TASK 1.07 MATERIAL - DEVELOPMENT SPARES (CLIN 0001AG)PROPOSED COSTS/PRICES - LABORPROPOSED COSTS/PRICES - LABORPROPOSED COSTS/PRICES - LABORPROPOSED COSTS/PRICES - LABOR
Basic Period (Year 1)Basic Period (Year 2)Basic Period (Year 3)Basic Period (Year 4)
Labor CategoryTaskLabor HoursLabor RatesDirect Labor CostLabor HoursLabor RatesDirect Labor CostLabor HoursLabor RatesDirect Labor CostLabor HoursLabor RatesDirect Labor Cost
Insert all labor categories that apply; add/delete rows as necessary and ensure cells in Columns E, I, and M are properly linked to the rates in the 'PRIME-CPIF RATES (ALL)' worksheetInsert applicable task by labor category at sub-task level (ex. 1.01.01, 1.01.02, and so forth); ensure consistency with the 'PRIME CPIF LABOR by TASK' worksheetInsert proposed labor hours by labor category and sub-taskLink corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheetInsert proposed labor hours by labor category and sub-taskLink corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheetInsert proposed labor hours by labor category and sub-taskLink corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheetInsert proposed labor hours by labor category and sub-taskLink corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet
Labor Category : [INSERT LABOR CATEGORY NAME HERE]1.07.010$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]1.07.020$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]1.07.030$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Labor Category : [INSERT LABOR CATEGORY NAME HERE]0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
TOTAL DIRECT LABOR HOURS/COST0$0.000$0.000$0.000$0.00
CLIN 0001 DEVELOPMENT, TASK 1.08 BLACK LABEL HARDWARE AND SOFTWARE CERTIFICATION (CLIN 0001AH)PROPOSED COSTS/PRICES - LABORPROPOSED COSTS/PRICES - LABORPROPOSED COSTS/PRICES - LABORPROPOSED COSTS/PRICES - LABOR

This is the start of the file's text. The full file is on GovTribe.

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