ATTACHMENT 3A - EXCEL PRICING WORKBOOK - PRIME - UPDATED3 (P).xlsx

XLSX spreadsheet 465 KB Posted

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

About this file

This is an Excel Pricing Workbook template for the KC-135 Center Console Refresh (CCR) contract, designed to facilitate offeror price submissions for evaluation purposes. The workbook establishes a structured format for pricing three contract types: Cost-Plus Incentive Fee (CPIF) for three Engineering and Manufacturing Development (EMD) CLINs (0001 Development, 0002 Simulator Kits, 0003 Systems Integration Laboratory) and Firm Fixed Price (FFP) for multiple Production and Deployment CLINs (X007-X021), spanning a 48-month Basic Period with six 1-year Option Periods through June 2038.

Offerors must input direct labor rates (rounded to two decimal places), indirect rates including labor fringe, overhead, G&A, FCCOM, and target fee (rounded to four decimal places), and all unit prices for FFP CLINs across performance periods. The workbook automatically calculates Total Evaluated Price (TEP) by multiplying Best Estimated Quantities by proposed prices. For CPIF CLINs, offerors must provide detailed cost buildups including labor hours by task, material costs via Consolidated Bill of Materials, subcontractor costs (with major subcontractors over $2.5M requiring separate cost models), and Other Direct Costs. For FFP CLINs eligible for price redetermination under FAR 52.216-75, redetermined pricing is capped at 112 percent of initial proposed prices for Option Periods I-III and 107 percent for Option Period IV onward. The pricing template requires no format changes to specified worksheets and includes linkages between labor rates, task inputs, and material/subcontractor summary sheets to ensure pricing consistency and mathematical accuracy throughout the proposal submission.

View the file

Other files

File Type Posted
ATTACHMENT 3A - EXCEL PRICING WORKBOOK - PRIME - UPDATED6 (P).xlsx XLSX spreadsheet
ATTACHMENT 3B - EXCEL PRICING WORKBOOK - SUB UPDATED4 (P).xlsx XLSX spreadsheet
Solicitation Amendment - FA810526RB0010007 (Conformed copy).pdf PDF
Solicitation Amendment FA810526RB0010007 SF 30.pdf PDF
Solicitation Amendment FA810526RB0010006 SF 30.pdf PDF
FA810526FB0010005 - Conformed.pdf PDF
Solicitation Amendment FA810526RB0010005 SF 30.pdf PDF
Solicitation Amendment - FA810526RB0010004.pdf PDF
ATTACHMENT 3B - EXCEL PRICING WORKBOOK - SUB UPDATED3 (P).xlsx XLSX spreadsheet
ATTACHMENT 3A - EXCEL PRICING WORKBOOK - PRIME - UPDATED5 (P).xlsx XLSX spreadsheet
Solicitation - FA810526RB0010004 3 Sept 26.pdf PDF
Solicitation Amendment FA810526RB0010003 SF 30.pdf PDF
ATTACHMENT 3A - EXCEL PRICING WORKBOOK - PRIME - UPDATED_03(P).xlsx XLSX spreadsheet
Solicitation - FA810526RB001 23Jun26.pdf PDF
Solicitation Amendment FA810526RB0010001 SF 30 28Jul26.pdf PDF
Solicitation Amendment FA810526RB0010002 SF 30 12Aug26.pdf PDF
Attachment 4. KC-135 CCR Section L - Instructions to Offerors02.pdf PDF
Attachment 5. KC-135 CCR Section M - Evaluation Factors for Award0.pdf PDF
Solicitation Amendment FA810526RB0010002 SF 30.pdf PDF
ATTACHMENT 3A - EXCEL PRICING WORKBOOK - PRIME - UPDATED (P).xlsx XLSX spreadsheet
Solicitation Amendment FA810526RB0010001 SF 30.pdf PDF
ATTACHMENT 3B - EXCEL PRICING WORKBOOK - SUB - UPDATED (P) (2).xlsx XLSX spreadsheet
Attachment 5. KC-135 - CCR Section M - Evaluation Factors for Award.pdf PDF
Attachment 4 KC-135 - CCR Section L - Instructions to Offerors.pdf PDF
Attachment 7. CUI CCR DD254.pdf PDF
Attachment 4 KC-135 CCR Section L - Instructions to Offerors.pdf PDF
Attachment 9. DCAA Preaward Survey of Prospective Contractor Accounting System Checklist.pdf PDF
Attachment 8. TM-86-01R Air Force Technical Manual Contract Requirements (TMCR)CCR_REV2.pdf PDF
Attachment 6. - CUI CCR Revision 2 Data Rights Assertion Matrix-Working.xlsx XLSX spreadsheet
ATTACHMENT 3B - EXCEL PRICING WORKBOOK - SUB UPDATED2 (P).xlsx XLSX spreadsheet
Attachment 5 KC-135 CCR Section M - Evaluation Factors for Award.pdf PDF
Solicitation - FA810526RB001.pdf PDF
Show all 32

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 "OVERALL 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 supporting information to include proposed part numbers and proposed quantities/unit prices for the individual components of the LRU Spares (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/lot 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 "OVERALL SUMMARY", 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-KitProposed unit price (fully burdened) multiplied by best estimated quantity of Production A-Kits for each performance period
0007ABFFPFirst Article Inspection - Production A-KitProposed unit price (fully burdened) multiplied by the best estimated quantity of Production A-Kit First Articles in Option Period I
X008AAFFPProduction B-KitProposed unit price (fully burdened) multiplied by best estimated quantity of Production B-Kits for each performance period
0008ABFFPProduction B-Kit Complete SpareProposed unit price (fully burdened) multiplied by the best estimated quantity of Production B-Kit Complete Spares in each performance period
X008ACFFPFirst Article Inspection - Production B-KitProposed 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 lot price (fully burdened) based on the sum of the unit prices for the individual piece parts comprising a Production B-Kit for each performance period; individual unit prices for the Production B-Kit piece parts shall be input into the 'Spares-FFP CLIN X021 INPUTS' worksheet

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 KitCPIFLot00021$ - 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-KitFFPEach0007AA14$ - 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-KitFFPEach0007AB2$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 000$ - 0$ - 00$ - 0$ - 0$ - 0
Production B-KitFFPEach0008AA10$ - 0$ - 01008AA*45$ - 0$ - 02008AA*45$ - 0$ - 03008AA*45$ - 0$ - 04008AA*45$ - 0$ - 05008AA*45$ - 0$ - 06008AA*53$ - 0$ - 0$ - 0
Production B-Kit Complete SpareFFPEach0008AB2$ - 0$ - 01008AB*8$ - 0$ - 02008AB*8$ - 0$ - 03008AB*8$ - 0$ - 04008AB*8$ - 0$ - 05008AB*8$ - 0$ - 06008AA*8$ - 0$ - 0$ - 0
First Article Inspection - Production B-KitFFPEach0008AC2$ - 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/A0019101920193019401950196019
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) SparesFFPEach00211$ - 0$ - 01021*1$ - 0$ - 02021*1$ - 0$ - 03021*1$ - 0$ - 04021*1$ - 0$ - 05021*1$ - 0$ - 06021*1$ - 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-KitFFPEach0007AA14$ - 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-KitFFPEach0007AB2$ - 0$ - 0N/A$ - 0$ - 0N/A$ - 0$ - 0N/A$ - 0$ - 0N/A$ - 0$ - 0N/A0$ - 0$ - 0N/A0$ - 0$ - 0$ - 0
Production B-KitFFPEach0008AA10$ - 0$ - 01008AA*45$ - 0$ - 02008AA*45$ - 0$ - 03008AA*45$ - 0$ - 04008AA*45$ - 0$ - 05008AA*45$ - 0$ - 06008AA*53$ - 0$ - 0$ - 0
Production B-Kit Complete SpareFFPEach0008AB2$ - 0$ - 01008AB*8$ - 0$ - 02008AB*8$ - 0$ - 03008AB*8$ - 0$ - 04008AB*8$ - 0$ - 05008AB*8$ - 0$ - 06008AB*8$ - 0$ - 0$ - 0
First Article Inspection - Production B-KitFFPEach0008AC2$ - 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/A0019101920193019401950196019
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**FFPLot00211$ - 0$ - 01021*1$ - 0$ - 02021*1$ - 0$ - 03021*1$ - 0$ - 04021*1$ - 0$ - 05021*1$ - 0$ - 06021*1$ - 0$ - 0$ - 0
*CLINs eligible for price redetermination per RFO 52.216-75TOTAL FFP$ - 0TOTAL FFP$ - 0TOTAL FFP$ - 0TOTAL FFP$ - 0TOTAL FFP$ - 0TOTAL FFP$ - 0TOTAL FFP$ - 0$ - 0TOTAL EVALUATED PRICE - FFP
**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). The total proposed lot price will be utilized by the Government for evaluation purposes only. In execution of the contract, the proposed prices for the individual components of the B-Kits (as listed in the 'SPARES-FFP CLIN X021 INPUTS' worksheet) are firm fixed prices that shall remain unchanged, with the exception of price redetermination, if applicable.$ - 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
*If the Offeror opts to utilize composite rates in their CLIN price buildup, the Offeror shall include the indirect rates and methodology utilized to calculate the composite rates in this worksheet and ensure proper linkage to the "CPIF CLIN 000X-TASK 1.XX 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, correlation to the number of Full-Time Equivalents (FTEs) and corresponding labor hours to be utilized, and description of effort ; may reference/link Basis of Estimate (BOE), if preferred
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 CategoryLabor Hours/#FTEsDescription of Effort (or reference/link to BOE, if preferred)
Example - For Illustrative Purposes Only
1.01Development Thru PDR
1.01.01ADD TITLE HEREENGINEER I3,568 hours (2 FTEs x 1,784 hours)To develop engineering plans
ENGINEER II2,676 hours (1.5 FTEs x 1,784 hours)To evaluate engineering plans
QUALITY SPECIALIST356.8 hours (0.2 FTEs x 1,784 hours)To 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

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 .