ATTACHMENT 3B - EXCEL PRICING WORKBOOK - SUB.xlsx
XLSX spreadsheet 473 KB Posted
- Attached to
- KC-135 Center Console Refresh (CCR) Revision 2
- Solicitation number
- FA8105_CCR_Rev2
About this file
This is an Excel pricing workbook template for the KC-135 Center Console Refresh (CCR) contract, designed to capture Cost-Plus-Incentive-Fee (CPIF) pricing for three Contract Line Items (CLINs) over a 48-month basic period. The template is formatted for major subcontractor cost proposals and includes structured worksheets for labor rates, material costs, subcontractor costs, and other direct costs (ODC) across four contract years. Yellow-highlighted cells indicate required offeror inputs, with all dollar amounts and labor rates to be rounded to two decimal places and percentage rates to four decimal places. The workbook automatically calculates total proposed prices based on linked inputs from supporting worksheets.
The three CLINs are: CLIN 0001 (Development), which encompasses 11 tasks including development through design review phases, system testing, equipment kits, prototype support, testing and evaluation, spares, certification, systems engineering, training, and support equipment; CLIN 0002 (Simulator Kit), covering requirements determination, material procurement, and delivery; and CLIN 0003 (Systems Integration Laboratory), addressing development labor, contractor-procured materials, government-furnished equipment, and delivery. The template includes separate rate sheets for direct labor categories, indirect cost rates (labor fringe, overhead, G&A, FCCOM, and target fee), and material and subcontractor burden rates. Supporting worksheets require detailed labor-by-task breakdowns with Full-Time Equivalent (FTE) allocations and rationale, consolidated bills of material cross-referenced to RFP Section L, and reconciliation with the prime contractor's accounting systems. All indirect rates and labor costs must link to the rate master worksheet to ensure proper cost buildup and fee calculations across all proposal elements.
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 3B, EPW - SUB |
| Notes: |
| 1. The worksheet tabs highlighted in yellow within Attachment 3B 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 proposed price is calculated in the "SUMMARY" worksheet |
Instructions for completing this Cost Model:
| 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 "SUB CPIF RATES (ALL)", "SUB CPIF RATE DESC (ALL)", "SUB CPIF LABOR by TASK", "SUB CPIF LABOR INPUTS", "SUB CPIF TOTAL MATERIAL", "SUB CPIF TOTAL SUB", "SUB 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 "SUB CPIF RATES (ALL)", "SUB CPIF LABOR INPUTS", "SUB CPIF TOTAL MATERIAL", "SUB CPIF TOTAL SUB", and "SUB 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; no inputs required |
SUMMARY
| MAJOR SUBCONTRACTOR | NAME |
| PRIME OFFEROR | NAME |
Notes: Proposed CLIN amounts are linked to the "CPIF CLIN 000X TOTAL" worksheets; no input required
| KC-135 Center Console Refresh (CCR) Competitive Pricing Matrix SUMMARY | Basic Period (48 months) | |||
| CLIN Description | Contract Type | Unit of Issue | Basic Period CLIN | |
| Qty |
Unit Price Extended
| Price | TOTAL EVALUATED PRICE | ||||||||
| EMD | EMD | ||||||||
| Development | Cost Plus Incentive Fee (CPIF) | Lot | 0001 | 1 | $ - 0 | $ - 0 | $ - 0 | ||
| Simulator Kit | 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 | ||||||
| TOTAL | $ - 0 | $ - 0 | TOTAL EVALUATED PRICE |
SUB CPIF RATES (ALL)
| MAJOR SUBCONTRACTOR | NAME |
| PRIME OFFEROR | NAME |
| KC-135 Center Console Refresh (CCR) Major Subontractor Direct Labor and Indirect Rates |
| Notes: |
| 1. The format of this worksheet may be revised as required to be consistent with the Major Subcontractor's approved Accounting System to include, but not limited to, inserting additional labor categories and revising the indirect rate structure |
| 2. The Major Subcontractor 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 Major Subcontractor 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 Major Subcontractor shall provide descriptions of the labor categories and indirect rates in the "SUB CPIF RATE DESC (ALL)" worksheet, in addition to base costs upon which indirect rates apply |
| 5. The Major Subcontractor 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 'SUB CPIF RATE DESC (ALL)' work sheet | ||||
| 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 Major Subcontractor 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)' work sheet | |||||
| 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)' work sheet | ||||
| 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)' work sheet | ||||
| Indirect Category: [Overhead] | ||||
| Indirect Category: [G&A] | ||||
| Indirect Category: [FCCOM] | ||||
| Indirect Category: [Target Fee] |
SUB CPIF RATE DESC (ALL)
| MAJOR SUBCONTRACTOR | NAME |
| PRIME OFFEROR | NAME |
| KC-135 Center Console Refresh (CCR) Major Subcontractor Direct Labor and Indirect Rates |
| Notes: |
| 1. The format of this worksheet may be revised as required to be consistent with the Major Subcontractor's approved Accounting System to include, but not limited to, inserting additional labor categories and revising the indirect rate structure |
| 2. The Major Subcontractor shall list all proposed labor categories and provide a summary description for each labor category |
| 3. The Major Subcontractor 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 Major Subcontractor 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 |
SUB CPIF LABOR by TASK
| MAJOR SUBCONTRACTOR | NAME |
| PRIME OFFEROR | NAME |
KC-135 Center Console Refresh (CCR) Major Subcontractor 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 |
SUB CPIF LABOR INPUTS
| MAJOR SUBCONTRACTOR | NAME |
| PRIME OFFEROR | NAME |
| Notes: |
| 1. The format of this worksheet should be revised as required to include all proposed labor by task |
| 2. The Major Subcontractor 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 Major Subcontractor shall ensure that the proposed labor rates properly link to the corresponding labor rates reflected in the "SUB-CPIF RATES (ALL)" worksheet |
| 4. The Major Subcontractor 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 | 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 'SUB-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 'SUB 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 'SUB 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 'SUB 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 'SUB 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 'SUB 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 | 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 'SUB-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 'SUB 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 'SUB 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 'SUB 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 'SUB 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 'SUB 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 | 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 'SUB-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 'SUB 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 'SUB 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 'SUB 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 'SUB 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 'SUB CPIF RATES (ALL)' worksheet | ||||
| 0 | 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) | 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 'SUB-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 'SUB 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 'SUB 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 'SUB 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 'SUB 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 'SUB CPIF RATES (ALL)' worksheet | ||||
| 0 | 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 | 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 'SUB-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 'SUB 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 'SUB 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 'SUB 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 'SUB 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 'SUB 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 | 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 'SUB-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 'SUB 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 'SUB 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 'SUB 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 'SUB 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 'SUB 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 | 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 'SUB-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 'SUB 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 'SUB 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 'SUB 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 'SUB 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 'SUB 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 | 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 'SUB-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 'SUB 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 'SUB 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 'SUB 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 'SUB 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 'SUB CPIF RATES (ALL)' worksheet | ||||
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 1.08.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.08.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.08.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.09 SYSTEMS ENGINEERING AND PROGRAM MANAGEMENT | 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 'SUB-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 'SUB 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 'SUB 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 'SUB 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 'SUB 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 'SUB CPIF RATES (ALL)' worksheet | ||||
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 1.09.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.09.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.09.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.10 AIRCREW AND MAINTENANCE TRAINING | 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 'SUB-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 'SUB 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 'SUB 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 'SUB 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 'SUB 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 'SUB CPIF RATES (ALL)' worksheet | ||||
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 1.10.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.10.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.10.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.11 SUPPORT EQUIPMENT | 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 'SUB-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 'SUB 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 'SUB 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 'SUB 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 'SUB 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 'SUB CPIF RATES (ALL)' worksheet | ||||
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 1.11.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.11.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.11.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 0002 SIMULATOR KIT, TASK 1.01 SUPPORT REQUIRED TO DETERMINE ELEMENTS OF SIMULATOR KIT | 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 'SUB-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 'SUB 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 'SUB 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 'SUB 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 'SUB 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 'SUB CPIF RATES (ALL)' worksheet | ||||
| Labor Category : [INSERT LABOR CATEGORY NAME HERE] | 2.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] | 2.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] | 2.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 0002 SIMULATOR KIT, TASK 1.02 MATERIAL -1 SIMULATOR KIT (REFERENCE SECTION L) | 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 'SUB-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 'SUB 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 'SUB 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 'SUB 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 'SUB 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 'SUB CPIF RATES (ALL)' worksheet |
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 .