B08_Amendment 01_COST Model_Consolidated Security Cooperation.xlsx
XLSX spreadsheet 284 KB Posted
- Solicitation number
- W91CRB-20-R-0010
About this file
This solicitation seeks proposals to provide technical, analytical, and administrative support services to the Department of the Army's Deputy for Acquisition and Systems Management (DASA-DEC). Services will include developing and monitoring strategic plans for Army security cooperation programs; preparing security cooperation and assistance policies; conducting technology transfer assessments; maintaining foreign military sales databases; supporting Title 10 activities; organizing meetings and outreach events; providing strategic planning and analytical services including research and data analytics; and reviewing license requests and disclosures for equipment sales. Offerors must submit any questions by March 2, 2020 to the points of contact listed.
View the file
Other files
Show all 12
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
| Instructions | ||
| Solicitation Number: W91CRB-20-R-0010 | ||
| Name of Action: Consolidated Security Cooperation | ||
| Prime Contractor/Subcontractor Name/Division: | ||
| Period of Performance: | ||
| Government Inputs | ||
| Solicitation Number: | W91CRB-20-R-0010 | |
| Name of Action: | Consolidated Security Cooperation | |
| Period of Performance: | ||
| Annual Productive Hours: | 1,920 | |
| Offeror Inputs | ||
| Prime Contractor/Subcontractor Name/Division: | ||
| Street Address: | ||
| City, State and Zip Code: |
Section B
| Section B - Supplies or Services Costs and/or Prices |
| Solicitation Number: W91CRB-20-R-0010 |
| Name of Action: Consolidated Security Cooperation |
| Prime Contractor/Subcontractor Name/Division: |
| Period of Performance: |
| (The format below is a sample. Propose in the actual format of the Section B contained in the solicitation) |
| TRANSITION IN PERIOD | ||||||
| CLIN | SUPPLIES/ SERVICES | QTY | UNIT | UNIT PRICE | AMOUNT | |
| 0001 - 0003 | Transition In Period | 1 | Each | $ - 0 | ||
| Labor - FFP | $ - 0 | From Cost Summary Worksheet | ||||
| Estimated Price = | $ - 0 | |||||
| Profit = | $ - 0 | From Cost Summary Worksheet | ||||
| Total Price = | $ - 0 |
| CLIN | SUPPLIES/SERVICES | QTY | UNIT | UNIT PRICE | AMOUNT | |
| 0004 | Transition In ODCs | 1 | Each | $ - 0 | ||
| COST | Estimated Cost = | $ 29,173.20 | From Cost Summary Worksheet | |||
| Burden/G&A = | 0.00% | $ - 0 | From Cost Summary WorkWorksheet and ODC Cost Detail WorkWorksheet | |||
| Subtotal = | $ 29,173.20 |
| BASE PERIOD | ||||||
| CLIN | SUPPLIES/SERVICES | QTY | UNIT | UNIT PRICE | AMOUNT | |
| 0001 - 0003 | Base Period | 1 | Each | $ - 0 | ||
| Labor - FFP | $ - 0 | From Cost Summary Worksheet | ||||
| Estimated Price = | $ - 0 | |||||
| Profit = | $ - 0 | From Cost Summary Worksheet | ||||
| Total Price = | $ - 0 |
| CLIN | SUPPLIES/SERVICES | QTY | UNIT | UNIT PRICE | AMOUNT | |
| 0004 | Base Period ODCs | 1 | Each | $ - 0 | ||
| COST | Estimated Cost = | $ 204,212.40 | From Cost Summary Worksheet | |||
| Burden/G&A = | 0.00% | $ - 0 | From Cost Summary WorkWorksheet and ODC Cost Detail WorkWorksheet | |||
| Subtotal = | $ 204,212.40 |
| OPTION PERIOD 1 | ||||||
| CLIN | SUPPLIES/SERVICES | QTY | UNIT | UNIT PRICE | AMOUNT | |
| 1001 - 1003 | Option Period 1 | 1 | Each | $ - 0 | ||
| Labor - FFP | $ - 0 | From Cost Summary Worksheet | ||||
| Estimated Price = | $ - 0 | |||||
| Profit = | $ - 0 | From Cost Summary Worksheet | ||||
| Total Price = | $ - 0 |
| CLIN | SUPPLIES/SERVICES | QTY | UNIT | UNIT PRICE | AMOUNT | |
| 1004 | Option Period 1 ODCs | 1 | Each | $ - 0 | ||
| COST | Estimated Cost = | $ 245,054.88 | From Cost Summary Worksheet | |||
| Burden/G&A = | 0.00% | $ - 0 | From Cost Summary WorkWorksheet and ODC Cost Detail WorkWorksheet | |||
| Subtotal = | $ 245,054.88 |
| OPTION PERIOD 2 | ||||||
| CLIN | SUPPLIES/SERVICES | QTY | UNIT | UNIT PRICE | AMOUNT | |
| 2001 - 2003 | Option Period 2 | 1 | Each | $ - 0 | ||
| Labor - FFP | $ - 0 | From Cost Summary Worksheet | ||||
| Estimated Price = | $ - 0 | |||||
| Profit = | $ - 0 | From Cost Summary Worksheet | ||||
| Total Price = | $ - 0 |
| CLIN | SUPPLIES/SERVICES | QTY | UNIT | UNIT PRICE | AMOUNT | |
| 2004 | Option Period 2 ODCs | 1 | Each | $ - 0 | ||
| COST | Estimated Cost = | $ 257,307.62 | From Cost Summary Worksheet | |||
| Burden/G&A = | 0.00% | $ - 0 | From Cost Summary WorkWorksheet and ODC Cost Detail WorkWorksheet | |||
| Subtotal = | $ 257,307.62 |
| OPTION PERIOD 3 | ||||||
| CLIN | SUPPLIES/SERVICES | QTY | UNIT | UNIT PRICE | AMOUNT | |
| 3001 - 3003 | Option Period 3 | 1 | Each | $ - 0 | ||
| Labor - FFP | $ - 0 | From Cost Summary Worksheet | ||||
| Estimated Price = | $ - 0 | |||||
| Profit = | $ - 0 | From Cost Summary Worksheet | ||||
| Total Price = | $ - 0 |
| CLIN | SUPPLIES/SERVICES | QTY | UNIT | UNIT PRICE | AMOUNT | |
| 3004 | Option Period 3 ODCs | 1 | Each | $ - 0 | ||
| COST | Estimated Cost = | $ 270,173.01 | From Cost Summary Worksheet | |||
| Burden/G&A = | 0.00% | $ - 0 | From Cost Summary WorkWorksheet and ODC Cost Detail WorkWorksheet | |||
| Subtotal = | $ 270,173.01 |
| OPTION PERIOD 4 | ||||||
| CLIN | SUPPLIES/SERVICES | QTY | UNIT | UNIT PRICE | AMOUNT | |
| 4001 - 4003 | Option Period 4 | 1 | Each | $ - 0 | ||
| Labor - FFP | $ - 0 | From Cost Summary Worksheet | ||||
| Estimated Price = | $ - 0 | |||||
| Profit = | $ - 0 | From Cost Summary Worksheet | ||||
| Total Price = | $ - 0 |
| CLIN | SUPPLIES/SERVICES | QTY | UNIT | UNIT PRICE | AMOUNT | |
| 4004 | Option Period 4 ODCs | 1 | Each | $ - 0 | ||
| COST | Estimated Cost = | $ 248,221.45 | From Cost Summary Worksheet | |||
| Burden/G&A = | 0.00% | $ - 0 | From Cost Summary WorkWorksheet and ODC Cost Detail WorkWorksheet | |||
| Subtotal = | $ 248,221.45 |
| TRANSITION OUT PERIOD | ||||||
| CLIN | SUPPLIES/SERVICES | QTY | UNIT | UNIT PRICE | AMOUNT | |
| 4001 - 4003 | Transition Out Period | 1 | Each | $ - 0 | ||
| Labor - FFP | $ - 0 | |||||
| Estimated Price = | $ - 0 | From Cost Summary Worksheet | ||||
| Profit = | $ - 0 | From Cost Summary Worksheet | ||||
| Total Price = | $ - 0 |
| CLIN | SUPPLIES/SERVICES | QTY | UNIT | UNIT PRICE | AMOUNT | |
| 4004 | Transition Out ODCs | 1 | Each | $ - 0 | ||
| COST | Estimated Cost = | $ 35,460.21 | From Cost Summary Worksheet | |||
| Burden/G&A = | 0.00% | $ - 0 | From Cost Summary WorkWorksheet and ODC Cost Detail WorkWorksheet | |||
| Subtotal = | $ 35,460.21 |
| TOTAL | ||
| TOTAL | ||
| Estimated Price = | $ 1,289,602.76 | |
| Profit = | $ - 0 | |
| Total Price = | $ 1,289,602.76 |
| Double check figure | $ 1,289,602.76 | Total of clin totals |
| Double check figure | $ 1,289,602.76 | Cost Summary Total |
| Double check figure | $ 1,289,602.76 | Total from individual Worksheets |
Cost Summary
| Cost Summary Spreadsheet |
| Solicitation Number: W91CRB-20-R-0010 |
| Name of Action: Consolidated Security Cooperation |
| Prime Contractor/Subcontractor Name/Division: |
| Period of Performance: |
| Consolidated Security Cooperation | Transition in | Base Period | Option 1 | Option 2 | Option 3 | Option 4 | Transition Out | Total | |
| FMS Labor & Subcontract Labor Hours | 4,800 | 52,800 | 57,600 | 57,600 | 57,600 | 52,800 | 4,800 | 288,000 | From Labor Cost Detail Worksheet |
| FMS Direct & Indirect Labor & Subcontract Labor Costs (less G&A) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | From Labor Cost Detail Worksheet |
| FMS G&A Costs | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | From Labor Cost Detail Worksheet |
| FMS Direct & Indirect Labor & Subcontract Labor Costs (Less Fee) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| FMS Profit/Fee | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | From Labor Cost Detail Worksheet |
| FMS Labor Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| OMA Labor & Subcontract Labor Hours | 1,760 | 19,360 | 21,120 | 21,120 | 21,120 | 19,360 | 1,760 | 288,000 | From Labor Cost Detail Worksheet |
| OMA Direct & Indirect Labor & Subcontract Labor Costs (less G&A) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | From Labor Cost Detail Worksheet |
| OMA G&A Costs | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | From Labor Cost Detail Worksheet |
| OMA Direct & Indirect Labor & Subcontract Labor Costs (Less Fee) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| OMA Profit/Fee | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | From Labor Cost Detail Worksheet |
| OMA Labor Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| RDTE Labor & Subcontract Labor Hours | 1,360 | 14,960 | 16,320 | 16,320 | 16,320 | 14,960 | 1,360 | 288,000 | From Labor Cost Detail Worksheet |
| RDTE Direct & Indirect Labor & Subcontract Labor Costs (less G&A) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | From Labor Cost Detail Worksheet |
| RDTE G&A Costs | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | From Labor Cost Detail Worksheet |
| RDTE Direct & Indirect Labor & Subcontract Labor Costs (Less Fee) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| RDTE Profit/Fee | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | From Labor Cost Detail Worksheet |
| RDTE Labor Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Total Labor & Subcontract Labor Hours | 7,920 | 87,120 | 95,040 | 95,040 | 95,040 | 87,120 | 7,920 | 475,200 | From Labor Cost Detail Worksheet |
| Total Direct & Indirect Labor & Subcontract Labor Costs (less G&A) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | From Labor Cost Detail Worksheet |
| Total G&A Costs | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | From Labor Cost Detail Worksheet |
| Total Direct & Indirect Labor & Subcontract Labor Costs (Less Fee) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Total Profit/Fee | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | From Labor Cost Detail Worksheet |
| Total Labor Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Other Direct Costs (ODCs) (Less Burden) | $ 29,173.20 | $ 204,212.40 | $ 245,054.88 | $ 257,307.62 | $ 270,173.01 | $ 248,221.45 | $ 35,460.21 | $ 1,289,602.76 | From ODC Cost Detail Sheet |
| G&A Burden on ODCs | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | From ODC Cost Detail Sheet |
| ODCs | $ 29,173.20 | $ 204,212.40 | $ 245,054.88 | $ 257,307.62 | $ 270,173.01 | $ 248,221.45 | $ 35,460.21 | $ 1,289,602.76 | |
| Total Labor & ODC Costs | $ 29,173.20 | $ 204,212.40 | $ 245,054.88 | $ 257,307.62 | $ 270,173.01 | $ 248,221.45 | $ 35,460.21 | $ 1,289,602.76 |
Direct Labor Rate Schedule
| Direct Labor Rate Schedule |
| Solicitation Number: W91CRB-20-R-0010 |
| Name of Action: Consolidated Security Cooperation |
| Prime Contractor/Subcontractor Name/Division: |
| Period of Performance: |
| CLIN 0001 - 0003: Transition In Period - 30 Days | CLIN 0001 - 0003: Base Period - 11 Months | CLIN 1001 - 1003: Option Period 1 | CLIN 2001 - 2003: Option Period 2 | CLIN 3001 - 3003: Option Period 3 | CLIN 4001 - 4003: Option Period 4 - 11 Months | CLIN 4001 - 4003: Transition Out Period - 30 Days | |||||||||
| Labor Categories | Location | Labor Type | SCA Identifier | Proposed Direct Labor Rate | Cost Realism Basis for Rate Proposed | Proposed Labor Rate | Escalation | Proposed Labor Rate | Escalation | Proposed Labor Rate | Escalation | Proposed Labor Rate | Escalation | Proposed Labor Rate | Proposed Labor Rate |
| Senior Program Manager | Professional | n/a | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Program Manager Alternate | Professional | n/a | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Senior Subject Matter Expert | Professional | n/a | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Senior Operations Analyst | Professional | n/a | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Contract Manager | Professional | n/a | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Info Functional Analyst 3 | Professional | n/a | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Senior Program Analyst | Professional | n/a | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Consultant Operations Analyst | Professional | n/a | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Program Admin Assistant | Professional | n/a | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| FIAR SME (Auditor) | Professional | n/a | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Program Analyst | Professional | n/a | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| IT Specialist | Professional | n/a | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
Labor Cost Detail - FMS
| Labor Cost Detail Spreadsheet |
| Solicitation Number: W91CRB-20-R-0010 |
| Name of Action: Consolidated Security Cooperation |
| Prime Contractor/Subcontractor Name/Division: |
| Period of Performance: |
| Annual Productive Hours: 1920 |
| Direct Labor | Indirect Cost | ||||||||||||||||
| CLIN 0001 - 0003: Transition In Period - 30 Days | 0.00% | 0.00% | 0.00% | 0.00% | |||||||||||||
| Location (Note 1) | Labor Type (Note 2) | Labor Categories (Note 3) | Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 4) | If Column D=S, Enter Name of Subcontractor(s) (Note 5) | FTEs (Note 6) | Total Productive Hours (Note 7) | Hourly Base Pay Rate (Note 8) | Fringe (Note 9) | Overhead (Note 10) | Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 11) | Total Prime & Sub Labor Before Prime G&A & Fee | G&A (Note 12) | Total Cost | Fee | Total Price | Proposal Fully Burdened Hourly Billing Rate | Wrap Rate |
| a | b | c | d | e | f | g | h | i | j | k = h + i + j | l = g x k | m | n = l + o | o | p = n + o | q = p/g | r = q/h |
| Professional | Senior Program Manager | Enter P or S | 0.50 | 80.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Program Manager Alternate | Enter P or S | 2.00 | 320.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Senior Subject Matter Expert | Enter P or S | 7.00 | 1,120.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Senior Operations Analyst | Enter P or S | 2.00 | 320.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Contract Manager | Enter P or S | 0.50 | 80.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Info Functional Analyst 3 | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Senior Program Analyst | Enter P or S | 4.00 | 640.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Consultant Operations Analyst | Enter P or S | 2.00 | 320.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Program Admin Assistant | Enter P or S | 3.00 | 480.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | FIAR SME (Auditor) | Enter P or S | 1.00 | 160.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Program Analyst | Enter P or S | 4.00 | 640.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | IT Specialist | Enter P or S | 4.00 | 640.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Total: | 30.00 | 4,800.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| Weighted Average: | 160.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Direct Cost | Indirect Cost | ||||||||||||||||
| CLIN 0001 - 0003: Base Period - 11 Months | 0.00% | 0.00% | 0.00% | 0.00% | |||||||||||||
| Location (Note 1) | Labor Type (Note 2) | Labor Categories (Note 3) | Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 4) | If Column D=S, Enter Name of Subcontractor(s) (Note 5) | FTEs (Note 6) | Total Productive Hours (Note 7) | Hourly Base Pay Rate (Note 8) | Fringe (Note 9) | Overhead (Note 10) | Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 11) | Total Prime & Sub Labor Before Prime G&A & Fee | G&A (Note 12) | Total Cost | Fee | Total Price | Proposal Fully Burdened Hourly Billing Rate | Wrap Rate |
| a | b | c | d | e | f | g | h | i | j | k = h + i + j | l = g x k | m | n = l + o | o | p = n + o | q = p/g | r = q/h |
| Professional | Senior Program Manager | Enter P or S | 0.50 | 880.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Program Manager Alternate | Enter P or S | 2.00 | 3,520.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Senior Subject Matter Expert | Enter P or S | 7.00 | 12,320.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Senior Operations Analyst | Enter P or S | 2.00 | 3,520.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Contract Manager | Enter P or S | 0.50 | 880.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Info Functional Analyst 3 | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Senior Program Analyst | Enter P or S | 4.00 | 7,040.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Consultant Operations Analyst | Enter P or S | 2.00 | 3,520.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Program Admin Assistant | Enter P or S | 3.00 | 5,280.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | FIAR SME (Auditor) | Enter P or S | 1.00 | 1,760.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Program Analyst | Enter P or S | 4.00 | 7,040.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | IT Specialist | Enter P or S | 4.00 | 7,040.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Total: | 30.00 | 52,800.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| Weighted Average: | 1,760.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Direct Cost | Indirect Cost | ||||||||||||||||
| CLIN 1001 - 1003: Option Period 1 | 0.00% | 0.00% | 0.00% | 0.00% | |||||||||||||
| Location (Note 1) | Labor Type (Note 2) | Labor Categories (Note 3) | Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 4) | If Column D=S, Enter Name of Subcontractor(s) (Note 5) | FTEs (Note 6) | Total Productive Hours (Note 7) | Hourly Base Pay Rate (Note 8) | Fringe (Note 9) | Overhead (Note 10) | Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 11) | Total Prime & Sub Labor Before Prime G&A & Fee | G&A (Note 12) | Total Cost | Fee | Total Price | Proposal Fully Burdened Hourly Billing Rate | Wrap Rate |
| a | b | c | d | e | f | g | h | i | j | k = h + i + j | l = g x k | m | n = l + o | o | p = n + o | q = p/g | r = q/h |
| Professional | Senior Program Manager | Enter P or S | 0.50 | 960.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Program Manager Alternate | Enter P or S | 2.00 | 3,840.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Senior Subject Matter Expert | Enter P or S | 7.00 | 13,440.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Senior Operations Analyst | Enter P or S | 2.00 | 3,840.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Contract Manager | Enter P or S | 0.50 | 960.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Info Functional Analyst 3 | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Senior Program Analyst | Enter P or S | 4.00 | 7,680.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Consultant Operations Analyst | Enter P or S | 2.00 | 3,840.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Program Admin Assistant | Enter P or S | 3.00 | 5,760.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | FIAR SME (Auditor) | Enter P or S | 1.00 | 1,920.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Program Analyst | Enter P or S | 4.00 | 7,680.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | IT Specialist | Enter P or S | 4.00 | 7,680.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Total: | 30.00 | 57,600.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| Weighted Average: | 1,920.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Direct Cost | Indirect Cost | ||||||||||||||||
| CLIN 2001 - 2003: Option Period 2 | 0.00% | 0.00% | 0.00% | 0.00% | |||||||||||||
| Location (Note 1) | Labor Type (Note 2) | Labor Categories (Note 3) | Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 4) | If Column D=S, Enter Name of Subcontractor(s) (Note 5) | FTEs (Note 6) | Total Productive Hours (Note 7) | Hourly Base Pay Rate (Note 8) | Fringe (Note 9) | Overhead (Note 10) | Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 11) | Total Prime & Sub Labor Before Prime G&A & Fee | G&A (Note 12) | Total Cost | Fee | Total Price | Proposal Fully Burdened Hourly Billing Rate | Wrap Rate |
| a | b | c | d | e | f | g | h | i | j | k = h + i + j | l = g x k | m | n = l + o | o | p = n + o | q = p/g | r = q/h |
| Professional | Senior Program Manager | Enter P or S | 0.50 | 960.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 219,705.60 | ||
| Professional | Program Manager Alternate | Enter P or S | 2.00 | 3,840.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Senior Subject Matter Expert | Enter P or S | 7.00 | 13,440.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Senior Operations Analyst | Enter P or S | 2.00 | 3,840.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Contract Manager | Enter P or S | 0.50 | 960.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Info Functional Analyst 3 | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| Professional | Senior Program Analyst | Enter P or S | 4.00 | 7,680.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Consultant Operations Analyst | Enter P or S | 2.00 | 3,840.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Program Admin Assistant | Enter P or S | 3.00 | 5,760.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | FIAR SME (Auditor) | Enter P or S | 1.00 | 1,920.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Program Analyst | Enter P or S | 4.00 | 7,680.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | IT Specialist | Enter P or S | 4.00 | 7,680.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Total: | 30.00 | 57,600.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| Weighted Average: | 1,920.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Direct Cost | Indirect Cost | ||||||||||||||||
| CLIN 3001 - 3003: Option Period 3 | 0.00% | 0.00% | 0.00% | 0.00% | |||||||||||||
| Location (Note 1) | Labor Type (Note 2) | Labor Categories (Note 3) | Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 4) | If Column D=S, Enter Name of Subcontractor(s) (Note 5) | FTEs (Note 6) | Total Productive Hours (Note 7) | Hourly Base Pay Rate (Note 8) | Fringe (Note 9) | Overhead (Note 10) | Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 11) | Total Prime & Sub Labor Before Prime G&A & Fee | G&A (Note 12) | Total Cost | Fee | Total Price | Proposal Fully Burdened Hourly Billing Rate | Wrap Rate |
| a | b | c | d | e | f | g | h | i | j | k = h + i + j | l = g x k | m | n = l + o | o | p = n + o | q = p/g | r = q/h |
| Professional | Senior Program Manager | Enter P or S | 0.50 | 960.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Program Manager Alternate | Enter P or S | 2.00 | 3,840.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Senior Subject Matter Expert | Enter P or S | 7.00 | 13,440.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Senior Operations Analyst | Enter P or S | 2.00 | 3,840.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Contract Manager | Enter P or S | 0.50 | 960.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Info Functional Analyst 3 | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Senior Program Analyst | Enter P or S | 4.00 | 7,680.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Consultant Operations Analyst | Enter P or S | 2.00 | 3,840.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Program Admin Assistant | Enter P or S | 3.00 | 5,760.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | FIAR SME (Auditor) | Enter P or S | 1.00 | 1,920.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Program Analyst | Enter P or S | 4.00 | 7,680.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | IT Specialist | Enter P or S | 4.00 | 7,680.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Total: | 30.00 | 57,600.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| Weighted Average: | 1,920.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Direct Cost | Indirect Cost | ||||||||||||||||
| CLIN 4001 - 4003: Option Period 4 - 11 Months | 0.00% | 0.00% | 0.00% | 0.00% | |||||||||||||
| Location (Note 1) | Labor Type (Note 2) | Labor Categories (Note 3) | Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 4) | If Column D=S, Enter Name of Subcontractor(s) (Note 5) | FTEs (Note 6) | Total Productive Hours (Note 7) | Hourly Base Pay Rate (Note 8) | Fringe (Note 9) | Overhead (Note 10) | Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 11) | Total Prime & Sub Labor Before Prime G&A & Fee | G&A (Note 12) | Total Cost | Fee | Total Price | Proposal Fully Burdened Hourly Billing Rate | Wrap Rate |
| a | b | c | d | e | f | g | h | i | j | k = h + i + j | l = g x k | m | n = l + o | o | p = n + o | q = p/g | r = q/h |
| Professional | Senior Program Manager | Enter P or S | 0.50 | 880.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Program Manager Alternate | Enter P or S | 2.00 | 3,520.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Senior Subject Matter Expert | Enter P or S | 7.00 | 12,320.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Senior Operations Analyst | Enter P or S | 2.00 | 3,520.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Contract Manager | Enter P or S | 0.50 | 880.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Info Functional Analyst 3 | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Senior Program Analyst | Enter P or S | 4.00 | 7,040.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Consultant Operations Analyst | Enter P or S | 2.00 | 3,520.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Program Admin Assistant | Enter P or S | 3.00 | 5,280.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | FIAR SME (Auditor) | Enter P or S | 1.00 | 1,760.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Program Analyst | Enter P or S | 4.00 | 7,040.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | IT Specialist | Enter P or S | 4.00 | 7,040.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Total: | 30.00 | 52,800.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| Weighted Average: | 1,760.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Direct Cost | Indirect Cost | ||||||||||||||||
| CLIN 4001 - 4003: Transition Out Period - 30 Days | 0.00% | 0.00% | 0.00% | 0.00% | |||||||||||||
| Location (Note 1) | Labor Type (Note 2) | Labor Categories (Note 3) | Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 4) | If Column D=S, Enter Name of Subcontractor(s) (Note 5) | FTEs (Note 6) | Total Productive Hours (Note 7) | Hourly Base Pay Rate (Note 8) | Fringe (Note 9) | Overhead (Note 10) | Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 11) | Total Prime & Sub Labor Before Prime G&A & Fee | G&A (Note 12) | Total Cost | Fee | Total Price | Proposal Fully Burdened Hourly Billing Rate | Wrap Rate |
| a | b | c | d | e | f | g | h | i | j | k = h + i + j | l = g x k | m | n = l + o | o | p = n + o | q = p/g | r = q/h |
| Professional | Senior Program Manager | Enter P or S | 0.50 | 80.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Program Manager Alternate | Enter P or S | 2.00 | 320.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Senior Subject Matter Expert | Enter P or S | 7.00 | 1,120.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Senior Operations Analyst | Enter P or S | 2.00 | 320.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Contract Manager | Enter P or S | 0.50 | 80.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Info Functional Analyst 3 | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Senior Program Analyst | Enter P or S | 4.00 | 640.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Consultant Operations Analyst | Enter P or S | 2.00 | 320.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Program Admin Assistant | Enter P or S | 3.00 | 480.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | FIAR SME (Auditor) | Enter P or S | 1.00 | 160.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Program Analyst | Enter P or S | 4.00 | 640.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | IT Specialist | Enter P or S | 4.00 | 640.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Total: | 30.00 | 4,800.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| Weighted Average: | 160.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Total: | 288,000 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Weighted Average: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
Labor Cost Detail - OMA
| Labor Cost Detail Spreadsheet |
| Solicitation Number: W91CRB-20-R-0010 |
| Name of Action: Consolidated Security Cooperation |
| Prime Contractor/Subcontractor Name/Division: |
| Period of Performance: |
| Annual Productive Hours: 1920 |
| Direct Labor | Indirect Cost | ||||||||||||||||
| CLIN 0001 - 0003: Transition In Period - 30 Days | 0.00% | 0.00% | 0.00% | 0.00% | |||||||||||||
| Location (Note 1) | Labor Type (Note 2) | Labor Categories (Note 3) | Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 4) | If Column D=S, Enter Name of Subcontractor(s) (Note 5) | FTEs (Note 6) | Total Productive Hours (Note 7) | Hourly Base Pay Rate (Note 8) | Fringe (Note 9) | Overhead (Note 10) | Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 11) | Total Prime & Sub Labor Before Prime G&A & Fee | G&A (Note 12) | Total Cost | Fee | Total Price | Proposal Fully Burdened Hourly Billing Rate | Wrap Rate |
| a | b | c | d | e | f | g | h | i | j | k = h + i + j | l = g x k | m | n = l + o | o | p = n + o | q = p/g | r = q/h |
| Professional | Senior Program Manager | Enter P or S | 0.50 | 80.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Program Manager Alternate | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Senior Subject Matter Expert | Enter P or S | 2.00 | 320.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Senior Operations Analyst | Enter P or S | 2.00 | 320.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Contract Manager | Enter P or S | 0.50 | 80.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Info Functional Analyst 3 | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Senior Program Analyst | Enter P or S | 4.00 | 640.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Consultant Operations Analyst | Enter P or S | 2.00 | 320.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Program Admin Assistant | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | FIAR SME (Auditor) | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Program Analyst | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | IT Specialist | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Total: | 11.00 | 1,760.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| Weighted Average: | 160.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Direct Cost | Indirect Cost | ||||||||||||||||
| CLIN 0001 - 0003: Base Period - 11 Months | 0.00% | 0.00% | 0.00% | 0.00% | |||||||||||||
| Location (Note 1) | Labor Type (Note 2) | Labor Categories (Note 3) | Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 4) | If Column D=S, Enter Name of Subcontractor(s) (Note 5) | FTEs (Note 6) | Total Productive Hours (Note 7) | Hourly Base Pay Rate (Note 8) | Fringe (Note 9) | Overhead (Note 10) | Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 11) | Total Prime & Sub Labor Before Prime G&A & Fee | G&A (Note 12) | Total Cost | Fee | Total Price | Proposal Fully Burdened Hourly Billing Rate | Wrap Rate |
| a | b | c | d | e | f | g | h | i | j | k = h + i + j | l = g x k | m | n = l + o | o | p = n + o | q = p/g | r = q/h |
| Professional | Senior Program Manager | Enter P or S | 0.50 | 880.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Program Manager Alternate | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Senior Subject Matter Expert | Enter P or S | 2.00 | 3,520.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Senior Operations Analyst | Enter P or S | 2.00 | 3,520.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Contract Manager | Enter P or S | 0.50 | 880.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Info Functional Analyst 3 | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Senior Program Analyst | Enter P or S | 4.00 | 7,040.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Consultant Operations Analyst | Enter P or S | 2.00 | 3,520.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Program Admin Assistant | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | FIAR SME (Auditor) | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Program Analyst | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | IT Specialist | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Total: | 11.00 | 19,360.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| Weighted Average: | 1,760.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Direct Cost | Indirect Cost | ||||||||||||||||
| CLIN 1001 - 1003: Option Period 1 | 0.00% | 0.00% | 0.00% | 0.00% | |||||||||||||
| Location (Note 1) | Labor Type (Note 2) | Labor Categories (Note 3) | Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 4) | If Column D=S, Enter Name of Subcontractor(s) (Note 5) | FTEs (Note 6) | Total Productive Hours (Note 7) | Hourly Base Pay Rate (Note 8) | Fringe (Note 9) | Overhead (Note 10) | Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 11) | Total Prime & Sub Labor Before Prime G&A & Fee | G&A (Note 12) | Total Cost | Fee | Total Price | Proposal Fully Burdened Hourly Billing Rate | Wrap Rate |
| a | b | c | d | e | f | g | h | i | j | k = h + i + j | l = g x k | m | n = l + o | o | p = n + o | q = p/g | r = q/h |
| Professional | Senior Program Manager | Enter P or S | 0.50 | 960.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Program Manager Alternate | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Senior Subject Matter Expert | Enter P or S | 2.00 | 3,840.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Senior Operations Analyst | Enter P or S | 2.00 | 3,840.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Contract Manager | Enter P or S | 0.50 | 960.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Info Functional Analyst 3 | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Senior Program Analyst | Enter P or S | 4.00 | 7,680.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Consultant Operations Analyst | Enter P or S | 2.00 | 3,840.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Program Admin Assistant | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | FIAR SME (Auditor) | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Program Analyst | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | IT Specialist | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Total: | 11.00 | 21,120.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| Weighted Average: | 1,920.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Direct Cost | Indirect Cost | ||||||||||||||||
| CLIN 2001 - 2003: Option Period 2 | 0.00% | 0.00% | 0.00% | 0.00% | |||||||||||||
| Location (Note 1) | Labor Type (Note 2) | Labor Categories (Note 3) | Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 4) | If Column D=S, Enter Name of Subcontractor(s) (Note 5) | FTEs (Note 6) | Total Productive Hours (Note 7) | Hourly Base Pay Rate (Note 8) | Fringe (Note 9) | Overhead (Note 10) | Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 11) | Total Prime & Sub Labor Before Prime G&A & Fee | G&A (Note 12) | Total Cost | Fee | Total Price | Proposal Fully Burdened Hourly Billing Rate | Wrap Rate |
| a | b | c | d | e | f | g | h | i | j | k = h + i + j | l = g x k | m | n = l + o | o | p = n + o | q = p/g | r = q/h |
| Professional | Senior Program Manager | Enter P or S | 0.50 | 960.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 219,705.60 | ||
| Professional | Program Manager Alternate | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| Professional | Senior Subject Matter Expert | Enter P or S | 2.00 | 3,840.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Senior Operations Analyst | Enter P or S | 2.00 | 3,840.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Contract Manager | Enter P or S | 0.50 | 960.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Info Functional Analyst 3 | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| Professional | Senior Program Analyst | Enter P or S | 4.00 | 7,680.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Consultant Operations Analyst | Enter P or S | 2.00 | 3,840.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Program Admin Assistant | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| Professional | FIAR SME (Auditor) | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| Professional | Program Analyst | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| Professional | IT Specialist | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| Total: | 11.00 | 21,120.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| Weighted Average: | 1,920.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Direct Cost | Indirect Cost | ||||||||||||||||
| CLIN 3001 - 3003: Option Period 3 | 0.00% | 0.00% | 0.00% | 0.00% | |||||||||||||
| Location (Note 1) | Labor Type (Note 2) | Labor Categories (Note 3) | Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 4) | If Column D=S, Enter Name of Subcontractor(s) (Note 5) | FTEs (Note 6) | Total Productive Hours (Note 7) | Hourly Base Pay Rate (Note 8) | Fringe (Note 9) | Overhead (Note 10) | Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 11) | Total Prime & Sub Labor Before Prime G&A & Fee | G&A (Note 12) | Total Cost | Fee | Total Price | Proposal Fully Burdened Hourly Billing Rate | Wrap Rate |
| a | b | c | d | e | f | g | h | i | j | k = h + i + j | l = g x k | m | n = l + o | o | p = n + o | q = p/g | r = q/h |
| Professional | Senior Program Manager | Enter P or S | 0.50 | 960.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Program Manager Alternate | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Senior Subject Matter Expert | Enter P or S | 2.00 | 3,840.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Senior Operations Analyst | Enter P or S | 2.00 | 3,840.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Contract Manager | Enter P or S | 0.50 | 960.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Info Functional Analyst 3 | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Senior Program Analyst | Enter P or S | 4.00 | 7,680.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Consultant Operations Analyst | Enter P or S | 2.00 | 3,840.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Program Admin Assistant | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | FIAR SME (Auditor) | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Program Analyst | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | IT Specialist | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Total: | 11.00 | 21,120.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| Weighted Average: | 1,920.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Direct Cost | Indirect Cost | ||||||||||||||||
| CLIN 4001 - 4003: Option Period 4 - 11 Months | 0.00% | 0.00% | 0.00% | 0.00% | |||||||||||||
| Location (Note 1) | Labor Type (Note 2) | Labor Categories (Note 3) | Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 4) | If Column D=S, Enter Name of Subcontractor(s) (Note 5) | FTEs (Note 6) | Total Productive Hours (Note 7) | Hourly Base Pay Rate (Note 8) | Fringe (Note 9) | Overhead (Note 10) | Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 11) | Total Prime & Sub Labor Before Prime G&A & Fee | G&A (Note 12) | Total Cost | Fee | Total Price | Proposal Fully Burdened Hourly Billing Rate | Wrap Rate |
| a | b | c | d | e | f | g | h | i | j | k = h + i + j | l = g x k | m | n = l + o | o | p = n + o | q = p/g | r = q/h |
| Professional | Senior Program Manager | Enter P or S | 0.50 | 880.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Program Manager Alternate | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Senior Subject Matter Expert | Enter P or S | 2.00 | 3,520.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Senior Operations Analyst | Enter P or S | 2.00 | 3,520.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Contract Manager | Enter P or S | 0.50 | 880.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Info Functional Analyst 3 | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Senior Program Analyst | Enter P or S | 4.00 | 7,040.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Consultant Operations Analyst | Enter P or S | 2.00 | 3,520.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Program Admin Assistant | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | FIAR SME (Auditor) | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Program Analyst | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | IT Specialist | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Total: | 11.00 | 19,360.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| Weighted Average: | 1,760.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Direct Cost | Indirect Cost | ||||||||||||||||
| CLIN 4001 - 4003: Transition Out Period - 30 Days | 0.00% | 0.00% | 0.00% | 0.00% | |||||||||||||
| Location (Note 1) | Labor Type (Note 2) | Labor Categories (Note 3) | Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 4) | If Column D=S, Enter Name of Subcontractor(s) (Note 5) | FTEs (Note 6) | Total Productive Hours (Note 7) | Hourly Base Pay Rate (Note 8) | Fringe (Note 9) | Overhead (Note 10) | Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 11) | Total Prime & Sub Labor Before Prime G&A & Fee | G&A (Note 12) | Total Cost | Fee | Total Price | Proposal Fully Burdened Hourly Billing Rate | Wrap Rate |
| a | b | c | d | e | f | g | h | i | j | k = h + i + j | l = g x k | m | n = l + o | o | p = n + o | q = p/g | r = q/h |
| Professional | Senior Program Manager | Enter P or S | 0.50 | 80.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Program Manager Alternate | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Senior Subject Matter Expert | Enter P or S | 2.00 | 320.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Senior Operations Analyst | Enter P or S | 2.00 | 320.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Contract Manager | Enter P or S | 0.50 | 80.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Info Functional Analyst 3 | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Senior Program Analyst | Enter P or S | 4.00 | 640.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Consultant Operations Analyst | Enter P or S | 2.00 | 320.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Program Admin Assistant | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | FIAR SME (Auditor) | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Program Analyst | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | IT Specialist | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Total: | 11.00 | 1,760.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| Weighted Average: | 160.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Total: | 105,600 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Weighted Average: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
Labor Cost Detail - RDTE
| Labor Cost Detail Spreadsheet |
| Solicitation Number: W91CRB-20-R-0010 |
| Name of Action: Consolidated Security Cooperation |
| Prime Contractor/Subcontractor Name/Division: |
| Period of Performance: |
| Annual Productive Hours: 1920 |
| Direct Labor | Indirect Cost | ||||||||||||||||
| CLIN 0001 - 0003: Transition In Period - 30 Days | 0.00% | 0.00% | 0.00% | 0.00% | |||||||||||||
| Location (Note 1) | Labor Type (Note 2) | Labor Categories (Note 3) | Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 4) | If Column D=S, Enter Name of Subcontractor(s) (Note 5) | FTEs (Note 6) | Total Productive Hours (Note 7) | Hourly Base Pay Rate (Note 8) | Fringe (Note 9) | Overhead (Note 10) | Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 11) | Total Prime & Sub Labor Before Prime G&A & Fee | G&A (Note 12) | Total Cost | Fee | Total Price | Proposal Fully Burdened Hourly Billing Rate | Wrap Rate |
| a | b | c | d | e | f | g | h | i | j | k = h + i + j | l = g x k | m | n = l + o | o | p = n + o | q = p/g | r = q/h |
| Professional | Senior Program Manager | Enter P or S | 0.25 | 40.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Program Manager Alternate | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Senior Subject Matter Expert | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Senior Operations Analyst | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Contract Manager | Enter P or S | 0.25 | 40.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Info Functional Analyst 3 | Enter P or S | 3.00 | 480.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Senior Program Analyst | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Consultant Operations Analyst | Enter P or S | 4.00 | 640.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Program Admin Assistant | Enter P or S | 1.00 | 160.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | FIAR SME (Auditor) | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Program Analyst | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | IT Specialist | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Total: | 8.50 | 1,360.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| Weighted Average: | 160.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Direct Cost | Indirect Cost | ||||||||||||||||
| CLIN 0001 - 0003: Base Period - 11 Months | 0.00% | 0.00% | 0.00% | 0.00% | |||||||||||||
| Location (Note 1) | Labor Type (Note 2) | Labor Categories (Note 3) | Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 4) | If Column D=S, Enter Name of Subcontractor(s) (Note 5) | FTEs (Note 6) | Total Productive Hours (Note 7) | Hourly Base Pay Rate (Note 8) | Fringe (Note 9) | Overhead (Note 10) | Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 11) | Total Prime & Sub Labor Before Prime G&A & Fee | G&A (Note 12) | Total Cost | Fee | Total Price | Proposal Fully Burdened Hourly Billing Rate | Wrap Rate |
| a | b | c | d | e | f | g | h | i | j | k = h + i + j | l = g x k | m | n = l + o | o | p = n + o | q = p/g | r = q/h |
| Professional | Senior Program Manager | Enter P or S | 0.25 | 440.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Program Manager Alternate | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Senior Subject Matter Expert | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Senior Operations Analyst | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Contract Manager | Enter P or S | 0.25 | 440.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Info Functional Analyst 3 | Enter P or S | 3.00 | 5,280.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Senior Program Analyst | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Consultant Operations Analyst | Enter P or S | 4.00 | 7,040.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Program Admin Assistant | Enter P or S | 1.00 | 1,760.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | FIAR SME (Auditor) | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Program Analyst | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | IT Specialist | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Total: | 8.50 | 14,960.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| Weighted Average: | 1,760.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Direct Cost | Indirect Cost | ||||||||||||||||
| CLIN 1001 - 1003: Option Period 1 | 0.00% | 0.00% | 0.00% | 0.00% | |||||||||||||
| Location (Note 1) | Labor Type (Note 2) | Labor Categories (Note 3) | Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 4) | If Column D=S, Enter Name of Subcontractor(s) (Note 5) | FTEs (Note 6) | Total Productive Hours (Note 7) | Hourly Base Pay Rate (Note 8) | Fringe (Note 9) | Overhead (Note 10) | Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 11) | Total Prime & Sub Labor Before Prime G&A & Fee | G&A (Note 12) | Total Cost | Fee | Total Price | Proposal Fully Burdened Hourly Billing Rate | Wrap Rate |
| a | b | c | d | e | f | g | h | i | j | k = h + i + j | l = g x k | m | n = l + o | o | p = n + o | q = p/g | r = q/h |
| Professional | Senior Program Manager | Enter P or S | 0.25 | 480.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Professional | Program Manager Alternate | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Professional | Senior Subject Matter Expert | Enter P or S | 0.00 | 0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
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 .