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
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
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: | |
| 1 | Offerors 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) |
| 2 | Offerors 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 |
| 3 | The extended price for CLINs X007 - X021 will be automatically calculated by multiplying the proposed unit price by the best estimated evaluation quantity |
| 4 | A subtotal price will be automatically calculated at the bottom of each contract period/year |
| 5 | The 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: | |
| 1 | Refer to the "Notes" on each CPIF worksheet for specific information/instructions |
| 2 | The 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 |
| 3 | The "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 |
| 4 | The "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 |
| 5 | The "CPIF CLIN 000X SUMMARY" worksheets includes links to the "CPIF CLIN 000X-TASK 1.XX INPUTS" worksheets; no inputs required |
| 6 | The total proposed amounts for the CPIF CLINs will automatically populate the "SUMMARY" worksheet, which will ultimately calculate the TEP; no inputs required |
| 7 | The 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 | |||
| CLIN | CONTRACT TYPE | DESCRIPTION | CALCULATION METHODOLOGY |
| EMD | |||
| 0001 | CPIF | Development PDR, Post PDR, PICO, Test, Software, Support Equipment, Prototype Support Equipment, Material | Proposed target price for EMD CLIN 0001 based on inputs from EMD CPIF worksheets (lot price) |
| 0002 | CPIF | Simulator Kits | Proposed target price for EMD CLIN 0002 based on inputs from EMD CPIF worksheets (lot price) |
| 0003 | CPIF | Systems Integration Laboratory (SIL) | Proposed target price for EMD CLIN 0003 based on inputs from EMD CPIF worksheets (lot price) |
| 0004 | NSP | Data - EMD | Not evaluated |
| 0005 | CR-NF | Travel - EMD | Not evaluated |
| 0006 | NSP | Intellectual Property | Not evaluated |
| PRODUCTION | |||
| X007AA | FFP | Production A-KITS | Proposed unit price (fully burdened) multiplied by best estimated quantity of A-Kits for each performance period |
| 0007AB | FFP | First Article Inspection - Production A-KITS | Proposed unit price (fully burdened) multiplied by the best estimated quantity of A-Kit First Articles in Option Period I |
| X008AA | FFP | Production B-KITS | Proposed unit price (fully burdened) multiplied by best estimated quantity of B-Kits for each performance period |
| 0008AB | FFP | First Article Inspection - Production B-KITS | Proposed unit price (fully burdened) multiplied by the best estimated quantity of B-Kit First Articles in Option Period I |
| X009 | FFP | Support Equipment | Proposed lot price (fully burdened) for Support Equipment for each performance period |
| X010 | FFP | Installations Surge | Not evaluated (To Be Negotiated) |
| X011 | FFP | Production Configuration Control/Engineering Change Orders | Proposed monthly price (fully burdened) multiplied by quantity of months in the performance period |
| X012 | FFP | Maintenance & Repair Support | Proposed monthly price (fully burdened) multiplied by quantity of months in the performance period |
| X013 | FFP | Technical Orders | Proposed monthly price (fully burdened) multiplied by quantity of months in the performance period |
| X014 | FFP | Simulator Kits | Proposed unit price (fully burdened) multiplied by best estimated quantity of Simulator Kits for each performance period |
| X015 | FFP | Systems Integration Laboratories | Proposed unit price (fully burdened) multiplied by best estimated quantity of SILs for each performance period |
| X016 | FFP | Training | Proposed monthly price (fully burdened) multiplied by quantity of months in the performance period |
| X017 | NSP | Data - Production | Not evaluated |
| X018 | CR-NF | Travel - Production | Not evaluated |
| X019 | CR-NF | Over & Above (O&A) | Not evaluated |
| X020 | FFP | Program Management - Production & Deployment (P&D) | Proposed monthly price (fully burdened) multiplied by quantity of months in the performance period |
| X021 | FFP | Line Replacement Unit (LRU) Spares | Proposed 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 SUMMARY | Basic 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 | ||||||||||||||||||||||||||||||||
| EMD | EMD | EMD | EMD | EMD | EMD | EMD | EMD | ||||||||||||||||||||||||||
| Development PDR, Post PDR, PICO, Test, Software, Support Equipment, Prototype Support Equipment, Material | Cost Plus Incentive Fee (CPIF) | Lot | 0001 | 1 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||||
| Simulator Kits | CPIF | Lot | 0002 | 1 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||||
| Systems Integration Laboratory (SIL) | CPIF | Lot | 0003 | 1 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||||
| Data - EMD | Not Separately Priced (NSP) | N/A | 0004 | ||||||||||||||||||||||||||||||
| Travel - EMD | Cost Reimbursable - No Fee (CR-NF) | N/A | 0005 | ||||||||||||||||||||||||||||||
| Intellectual Property | NSP | N/A | 0006 | ||||||||||||||||||||||||||||||
| PRODUCTION | PRODUCTION | PRODUCTION | PRODUCTION | PRODUCTION | PRODUCTION | PRODUCTION | PRODUCTION | ||||||||||||||||||||||||||
| Production A-KITS | FFP | Each | 0007AA | 10 | $ - 0 | $ - 0 | 1007AA* | 50 | $ - 0 | $ - 0 | 2007AA* | 50 | $ - 0 | $ - 0 | 3007AA* | 47 | $ - 0 | $ - 0 | 4007AA* | 45 | $ - 0 | $ - 0 | 5007AA* | 45 | $ - 0 | $ - 0 | 6007AA* | 53 | $ - 0 | $ - 0 | $ - 0 | ||
| Production A-KITS - First Article | FFP | Each | 0007AB | 2 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| Production B-KITS | FFP | Each | 0008AA | 10 | $ - 0 | $ - 0 | 1008AA* | 45 | $ - 0 | $ - 0 | 2008AA* | 45 | $ - 0 | $ - 0 | 3008AA* | 45 | $ - 0 | $ - 0 | 4008AA* | 45 | $ - 0 | $ - 0 | 5008AA* | 45 | $ - 0 | $ - 0 | 6008AA* | 53 | $ - 0 | $ - 0 | $ - 0 | ||
| Production B-KITS - First Article | FFP | Each | 0008AB | 2 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| Support Equipment | FFP | Lot | 0009 | 1 | $ - 0 | $ - 0 | 1009* | 1 | $ - 0 | $ - 0 | 2009* | 1 | $ - 0 | $ - 0 | 3009* | 1 | $ - 0 | $ - 0 | 4009* | 1 | $ - 0 | $ - 0 | 5009* | 1 | $ - 0 | $ - 0 | 6009* | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| Installations Surge | FFP | Each | 0010 | 1010 | 2010 | 0 | $ - 0 | 3010 | 0 | $ - 0 | 4010 | 0 | $ - 0 | 5010 | 0 | 6010 | |||||||||||||||||
| Production Configuration Control/Engineering Change Orders | FFP | Month | 0011 | 12 | $ - 0 | $ - 0 | 1011 | 12 | $ - 0 | $ - 0 | 2011 | 12 | $ - 0 | $ - 0 | 3011 | 12 | $ - 0 | $ - 0 | 4011 | 12 | $ - 0 | $ - 0 | 5011 | 12 | $ - 0 | $ - 0 | 6011 | 12 | $ - 0 | $ - 0 | $ - 0 | ||
| Maintenance & Repair Support | FFP | Month | 0012 | 1012 | 12 | $ - 0 | $ - 0 | 2012 | 12 | $ - 0 | $ - 0 | 3012 | 12 | $ - 0 | $ - 0 | 4012 | 12 | $ - 0 | $ - 0 | 5012 | 12 | $ - 0 | $ - 0 | 6012 | 12 | $ - 0 | $ - 0 | $ - 0 | |||||
| Technical Orders | FFP | Month | 0013 | 1013 | 12 | $ - 0 | $ - 0 | 2013 | 12 | $ - 0 | $ - 0 | 3013 | 12 | $ - 0 | $ - 0 | 4013 | 12 | $ - 0 | $ - 0 | 5013 | 12 | $ - 0 | $ - 0 | 6013 | 12 | $ - 0 | $ - 0 | $ - 0 | |||||
| Simulator Kits | FFP | Each | 0014 | 3 | $ - 0 | $ - 0 | 1014* | 6 | $ - 0 | $ - 0 | 2014* | 6 | $ - 0 | $ - 0 | 3014* | 6 | $ - 0 | $ - 0 | 4014 | 5014 | 6014 | $ - 0 | |||||||||||
| System Integration Laboratories | FFP | Each | 0015 | 1015 | 2015* | 1 | $ - 0 | $ - 0 | 3015 | 4015 | 5015 | 6015 | $ - 0 | $ - 0 | |||||||||||||||||||
| Training | FFP | Month | 0016 | 12 | $ - 0 | $ - 0 | 1016 | 12 | $ - 0 | $ - 0 | 2016 | 12 | $ - 0 | $ - 0 | 3016 | 12 | $ - 0 | $ - 0 | 4016 | 12 | $ - 0 | $ - 0 | 5016 | 12 | $ - 0 | $ - 0 | 6016 | 12 | $ - 0 | $ - 0 | $ - 0 | ||
| Data - Production | NSP | N/A | 0017 | 1017 | 2017 | 3017 | 4017 | 5017 | 6017 | ||||||||||||||||||||||||
| Travel - Production | CR-NF | N/A | 0018 | 1018 | 2018 | 3018 | 4018 | 5018 | 6018 | ||||||||||||||||||||||||
| Over & Above (O&A) | CR-NF | N/A | 0019 | 1019 | 2019 | 3019 | 4019 | 8019 | 6019 | ||||||||||||||||||||||||
| Program Management - Production & Deployment (P&D) | FFP | Month | 0020 | 12 | $ - 0 | $ - 0 | 1020 | 12 | $ - 0 | $ - 0 | 2020 | 12 | $ - 0 | $ - 0 | 3020 | 12 | $ - 0 | $ - 0 | 4020 | 12 | $ - 0 | $ - 0 | 5020 | 12 | $ - 0 | $ - 0 | 6020 | 12 | $ - 0 | $ - 0 | $ - 0 | ||
| Line Replacement Unit (LRU) Spares | FFP | Each | 0021 | 2 | $ - 0 | $ - 0 | 1021* | 6 | $ - 0 | $ - 0 | 2021* | 7 | $ - 0 | $ - 0 | 3021* | 8 | $ - 0 | $ - 0 | 4021* | 10 | $ - 0 | $ - 0 | 5021* | 10 | $ - 0 | $ - 0 | 6021* | 7 | $ - 0 | $ - 0 | $ - 0 | ||
| TOTAL | $ - 0 | TOTAL | $ - 0 | TOTAL | $ - 0 | TOTAL | $ - 0 | TOTAL | $ - 0 | TOTAL | $ - 0 | TOTAL | $ - 0 | $ - 0 | TOTAL EVALUATED PRICE |
$ - 0 Double Check
TOTAL EVALUATED PRICE ROLLUP
| PRIME OFFEROR | NAME |
| PERIOD OF PERFORMANCE | PRICE |
| 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 CLINS | Basic 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
| Price | TOTAL EVALUATED PRICE - FFP | ||||||||||||||||||||||||||||||||
| PRODUCTION CLINs | |||||||||||||||||||||||||||||||||
| Production A-KITS | FFP | Each | 0007AA | 10 | $ - 0 | $ - 0 | 1007AA* | 50 | $ - 0 | $ - 0 | 2007AA* | 50 | $ - 0 | $ - 0 | 3007AA* | 47 | $ - 0 | $ - 0 | 4007AA* | 45 | $ - 0 | $ - 0 | 5007AA* | 45 | $ - 0 | $ - 0 | 6007AA* | 53 | $ - 0 | $ - 0 | $ - 0 | ||
| First Article Inspection - Production A-KITS | FFP | Each | 0007AB | 2 | $ - 0 | $ - 0 | N/A | $ - 0 | $ - 0 | N/A | $ - 0 | $ - 0 | N/A | $ - 0 | $ - 0 | N/A | $ - 0 | $ - 0 | N/A | 0 | $ - 0 | $ - 0 | N/A | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| Production B-KITS | FFP | Each | 0008AA | 10 | $ - 0 | $ - 0 | 1008AA* | 45 | $ - 0 | $ - 0 | 2008AA* | 45 | $ - 0 | $ - 0 | 3008AA* | 45 | $ - 0 | $ - 0 | 4008AA* | 45 | $ - 0 | $ - 0 | 5008AA* | 45 | $ - 0 | $ - 0 | 6008AA* | 53 | $ - 0 | $ - 0 | $ - 0 | ||
| First Article Inspection - Production B-KITS | FFP | Each | 0008AB | 2 | $ - 0 | $ - 0 | N/A | $ - 0 | $ - 0 | N/A | $ - 0 | $ - 0 | N/A | $ - 0 | $ - 0 | N/A | $ - 0 | $ - 0 | N/A | 0 | $ - 0 | $ - 0 | N/A | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| Support Equipment | FFP | Lot | 0009 | 1 | $ - 0 | $ - 0 | 1009* | 1 | $ - 0 | $ - 0 | 2009* | 1 | $ - 0 | $ - 0 | 3009* | 1 | $ - 0 | $ - 0 | 4009* | 1 | $ - 0 | $ - 0 | 5009* | 1 | $ - 0 | $ - 0 | 6009* | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| Installations Surge | FFP | Each | 0010 | 1010 | 2010 | 3010 | 4010 | 5010 | 6010 | ||||||||||||||||||||||||
| Production Configuration Control/Engineering Change Orders | FFP | Month | 0011 | 12 | $ - 0 | $ - 0 | 1011 | 12 | $ - 0 | $ - 0 | 2011 | 12 | $ - 0 | $ - 0 | 3011 | 12 | $ - 0 | $ - 0 | 4011 | 12 | $ - 0 | $ - 0 | 5011 | 12 | $ - 0 | $ - 0 | 6011 | 12 | $ - 0 | $ - 0 | $ - 0 | ||
| Maintenance & Repair Support | FFP | Month | 0012 | 1012 | 12 | $ - 0 | $ - 0 | 2012 | 12 | $ - 0 | $ - 0 | 3012 | 12 | $ - 0 | $ - 0 | 4012 | 12 | $ - 0 | $ - 0 | 5012 | 12 | $ - 0 | $ - 0 | 6012 | 12 | $ - 0 | $ - 0 | $ - 0 | |||||
| Technical Orders | FFP | Month | 0013 | 1013 | 12 | $ - 0 | $ - 0 | 2013 | 12 | $ - 0 | $ - 0 | 3013 | 12 | $ - 0 | $ - 0 | 4013 | 12 | $ - 0 | $ - 0 | 5013 | 12 | $ - 0 | $ - 0 | 6013 | 12 | $ - 0 | $ - 0 | $ - 0 | |||||
| Simulator Kits | FFP | Each | 0014 | 3 | $ - 0 | $ - 0 | 1014* | 6 | $ - 0 | $ - 0 | 2014* | 6 | $ - 0 | $ - 0 | 3014* | 6 | $ - 0 | $ - 0 | 4014 | 5014 | 6014 | $ - 0 | |||||||||||
| System Integration Laboratories | FFP | Each | 0015 | 1015 | 2015* | 1 | $ - 0 | $ - 0 | 3015 | 4015 | 5015 | 6015 | $ - 0 | ||||||||||||||||||||
| Training | FFP | Month | 0016 | 12 | $ - 0 | $ - 0 | 1016 | 12 | $ - 0 | $ - 0 | 2016 | 12 | $ - 0 | $ - 0 | 3016 | 12 | $ - 0 | $ - 0 | 4016 | 12 | $ - 0 | $ - 0 | 5016 | 12 | $ - 0 | $ - 0 | 6016 | 12 | $ - 0 | $ - 0 | $ - 0 | ||
| Data - Production | NSP | N/A | 0017 | 1017 | 2017 | 3017 | 4017 | 5017 | 6017 | ||||||||||||||||||||||||
| Travel - Production | CR-NF | N/A | 0018 | 1018 | 2018 | 3018 | 4018 | 5018 | 6018 | ||||||||||||||||||||||||
| Over & Above (O&A) | CR-NF | N/A | 0019 | 1019 | 2019 | 3019 | 4019 | 8019 | 6019 | ||||||||||||||||||||||||
| Program Management - Production & Deployment (P&D) | FFP | Month | 0020 | 12 | $ - 0 | $ - 0 | 1020 | 12 | $ - 0 | $ - 0 | 2020 | 12 | $ - 0 | $ - 0 | 3020 | 12 | $ - 0 | $ - 0 | 4020 | 12 | $ - 0 | $ - 0 | 5020 | 12 | $ - 0 | $ - 0 | 6020 | 12 | $ - 0 | $ - 0 | $ - 0 | ||
| Line Replacement Unit (LRU) Spares* | FFP | Each | 0021 | 2 | $ - 0 | $ - 0 | 1021* | 6 | $ - 0 | $ - 0 | 2021* | 7 | $ - 0 | $ - 0 | 3021* | 8 | $ - 0 | $ - 0 | 4021* | 10 | $ - 0 | $ - 0 | 5021* | 10 | $ - 0 | $ - 0 | 6021* | 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 | $ - 0 | TOTAL FFP | $ - 0 | TOTAL FFP | $ - 0 | TOTAL FFP | $ - 0 | TOTAL FFP | $ - 0 | TOTAL FFP | $ - 0 | TOTAL FFP | $ - 0 | $ - 0 | TOTAL EVALUATED PRICE - FFP | |||||||||||||||||
| $ - 0 | Double Check | ||||||||||||||||||||||||||||||||
| $ - 0 | Difference 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 Period | Option Period I | Option Period II | Option Period III | Option Period IV | Option Period V | Option Period VI | ||||||||||
| NSN | P/N | Item Description | Qty | Unit Price | Extended | Unit Price | Extended | Unit Price | Extended | Unit Price | Extended | Unit Price | Extended | Unit Price | Extended | Unit Price | Extended |
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| $0.00 | $0.00 | $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 Category | Hourly Rate | Hourly Rate | Hourly Rate | Hourly 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 Category | Description |
| Example Labor Category: Systems Engineer/Integrator | Conducts 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 Category | Description | Allocation Base (Provide the base upon which the Indirect Rate is applied) |
| Example: Labor Fringe | Includes employee retirement plans, health insurance, and paid time off for sick leave and vacation | The 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 Number | Task | Labor Category | # FTEs/Hours | Rationale |
| Example - For Illustrative Purposes Only | ||||
| 1.01 | Development Thru PDR | |||
| 1.01.01 | ADD TITLE HERE | ENGINEER I | 2 FTEs x 1,784 hours | To develop engineering plans |
| ENGINEER II | To evaluate engineering plans | |||
| QUALITY SPECIALIST | 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 - LABOR | PROPOSED COSTS/PRICES - LABOR | PROPOSED COSTS/PRICES - LABOR | PROPOSED COSTS/PRICES - LABOR | |||||||||
| Basic Period (Year 1) | Basic Period (Year 2) | Basic Period (Year 3) | Basic Period (Year 4) | ||||||||||
| Labor Category | Task | Labor Hours | Labor Rates | Direct Labor Cost | Labor Hours | Labor Rates | Direct Labor Cost | Labor Hours | Labor Rates | Direct Labor Cost | Labor Hours | Labor Rates | Direct 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)' worksheet | Insert 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' worksheet | Insert proposed labor hours by labor category and sub-task | Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet | Insert proposed labor hours by labor category and sub-task | Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet | Insert proposed labor hours by labor category and sub-task | Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet | Insert proposed labor hours by labor category and sub-task | Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet | ||||
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 1.01.01 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 1.01.02 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 1.01.03 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| TOTAL DIRECT LABOR HOURS/COST | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| CLIN 0001 DEVELOPMENT, TASK 1.02 DEVELOPMENT FROM PDR TO CDR (CLIN 0001AB) | PROPOSED COSTS/PRICES - LABOR | PROPOSED COSTS/PRICES - LABOR | PROPOSED COSTS/PRICES - LABOR | PROPOSED COSTS/PRICES - LABOR | |||||||||
| Basic Period (Year 1) | Basic Period (Year 2) | Basic Period (Year 3) | Basic Period (Year 4) | ||||||||||
| Labor Category | Task | Labor Hours | Labor Rates | Direct Labor Cost | Labor Hours | Labor Rates | Direct Labor Cost | Labor Hours | Labor Rates | Direct Labor Cost | Labor Hours | Labor Rates | Direct 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)' worksheet | Insert 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' worksheet | Insert proposed labor hours by labor category and sub-task | Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet | Insert proposed labor hours by labor category and sub-task | Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet | Insert proposed labor hours by labor category and sub-task | Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet | Insert proposed labor hours by labor category and sub-task | Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet | ||||
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 1.02.01 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 1.02.02 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 1.02.03 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| TOTAL DIRECT LABOR HOURS/COST | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| CLIN 0001 DEVELOPMENT, TASK 1.03 SYSTEM TEST AND EVALUATION (CLIN 0001AC) | PROPOSED COSTS/PRICES - LABOR | PROPOSED COSTS/PRICES - LABOR | PROPOSED COSTS/PRICES - LABOR | PROPOSED COSTS/PRICES - LABOR | |||||||||
| Basic Period (Year 1) | Basic Period (Year 2) | Basic Period (Year 3) | Basic Period (Year 4) | ||||||||||
| Labor Category | Task | Labor Hours | Labor Rates | Direct Labor Cost | Labor Hours | Labor Rates | Direct Labor Cost | Labor Hours | Labor Rates | Direct Labor Cost | Labor Hours | Labor Rates | Direct 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)' worksheet | Insert 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' worksheet | Insert proposed labor hours by labor category and sub-task | Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet | Insert proposed labor hours by labor category and sub-task | Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet | Insert proposed labor hours by labor category and sub-task | Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet | Insert proposed labor hours by labor category and sub-task | Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet | ||||
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 1.03.01 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 1.03.02 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 1.03.03 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| TOTAL DIRECT LABOR HOURS/COST | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| CLIN 0001 DEVELOPMENT, TASK 1.04 DEVELOPMENT KITS (COTS AND DEVELOPMENTAL) (CLIN 0001AD) | PROPOSED COSTS/PRICES - LABOR | PROPOSED COSTS/PRICES - LABOR | PROPOSED COSTS/PRICES - LABOR | PROPOSED COSTS/PRICES - LABOR | |||||||||
| Basic Period (Year 1) | Basic Period (Year 2) | Basic Period (Year 3) | Basic Period (Year 4) | ||||||||||
| Labor Category | Task | Labor Hours | Labor Rates | Direct Labor Cost | Labor Hours | Labor Rates | Direct Labor Cost | Labor Hours | Labor Rates | Direct Labor Cost | Labor Hours | Labor Rates | Direct 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)' worksheet | Insert 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' worksheet | Insert proposed labor hours by labor category and sub-task | Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet | Insert proposed labor hours by labor category and sub-task | Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet | Insert proposed labor hours by labor category and sub-task | Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet | Insert proposed labor hours by labor category and sub-task | Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet | ||||
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 1.04.01 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 1.04.02 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 1.04.03 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| TOTAL DIRECT LABOR HOURS/COST | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| CLIN 0001 DEVELOPMENT, TASK 1.05 PROTOTYPE SUPPORT, INSTALLATION, AND CHECKOUT (CLIN 0001AE) | PROPOSED COSTS/PRICES - LABOR | PROPOSED COSTS/PRICES - LABOR | PROPOSED COSTS/PRICES - LABOR | PROPOSED COSTS/PRICES - LABOR | |||||||||
| Basic Period (Year 1) | Basic Period (Year 2) | Basic Period (Year 3) | Basic Period (Year 4) | ||||||||||
| Labor Category | Task | Labor Hours | Labor Rates | Direct Labor Cost | Labor Hours | Labor Rates | Direct Labor Cost | Labor Hours | Labor Rates | Direct Labor Cost | Labor Hours | Labor Rates | Direct 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)' worksheet | Insert 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' worksheet | Insert proposed labor hours by labor category and sub-task | Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet | Insert proposed labor hours by labor category and sub-task | Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet | Insert proposed labor hours by labor category and sub-task | Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet | Insert proposed labor hours by labor category and sub-task | Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet | ||||
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 1.05.01 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 1.05.02 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 1.05.03 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| TOTAL DIRECT LABOR HOURS/COST | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| CLIN 0001 DEVELOPMENT, TASK 1.06 QUALIFICATION, DEVELOPMENTAL, AND OPERATIONAL TESTING (CLIN 0001AF) | PROPOSED COSTS/PRICES - LABOR | PROPOSED COSTS/PRICES - LABOR | PROPOSED COSTS/PRICES - LABOR | PROPOSED COSTS/PRICES - LABOR | |||||||||
| Basic Period (Year 1) | Basic Period (Year 2) | Basic Period (Year 3) | Basic Period (Year 4) | ||||||||||
| Labor Category | Task | Labor Hours | Labor Rates | Direct Labor Cost | Labor Hours | Labor Rates | Direct Labor Cost | Labor Hours | Labor Rates | Direct Labor Cost | Labor Hours | Labor Rates | Direct 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)' worksheet | Insert 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' worksheet | Insert proposed labor hours by labor category and sub-task | Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet | Insert proposed labor hours by labor category and sub-task | Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet | Insert proposed labor hours by labor category and sub-task | Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet | Insert proposed labor hours by labor category and sub-task | Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet | ||||
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 1.06.01 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 1.06.02 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 1.06.03 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| TOTAL DIRECT LABOR HOURS/COST | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| CLIN 0001 DEVELOPMENT, TASK 1.07 MATERIAL - DEVELOPMENT SPARES (CLIN 0001AG) | PROPOSED COSTS/PRICES - LABOR | PROPOSED COSTS/PRICES - LABOR | PROPOSED COSTS/PRICES - LABOR | PROPOSED COSTS/PRICES - LABOR | |||||||||
| Basic Period (Year 1) | Basic Period (Year 2) | Basic Period (Year 3) | Basic Period (Year 4) | ||||||||||
| Labor Category | Task | Labor Hours | Labor Rates | Direct Labor Cost | Labor Hours | Labor Rates | Direct Labor Cost | Labor Hours | Labor Rates | Direct Labor Cost | Labor Hours | Labor Rates | Direct 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)' worksheet | Insert 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' worksheet | Insert proposed labor hours by labor category and sub-task | Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet | Insert proposed labor hours by labor category and sub-task | Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet | Insert proposed labor hours by labor category and sub-task | Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet | Insert proposed labor hours by labor category and sub-task | Link corresponding proposed labor rate; ensure the labor rate aligns with 'PRIME CPIF RATES (ALL)' worksheet | ||||
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 1.07.01 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 1.07.02 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 1.07.03 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| TOTAL DIRECT LABOR HOURS/COST | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| CLIN 0001 DEVELOPMENT, TASK 1.08 BLACK LABEL HARDWARE AND SOFTWARE CERTIFICATION (CLIN 0001AH) | PROPOSED COSTS/PRICES - LABOR | PROPOSED COSTS/PRICES - LABOR | PROPOSED COSTS/PRICES - LABOR | PROPOSED 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 .