The file's text, extracted by GovTribe without its formatting.
Section B Labor & ODC Proposed Labor & ODC
| DIRECT LABOR** | # of Personnel | Est. Productive Hours Per (Billed Hours) | Loaded Rated per Hour * | Estimated Cost |
| System Administration | 1 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Database Management Support | 1 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Web Support | 2 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Applications Programming Support | 2 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Information Assurance Support | 2 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Comsec Support | 1 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Logistics Support | 1 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| VTC Support | 5 | | | |
| Optional Categories | | | | |
| Training Support | 1 | ERROR:#REF! | | |
| IT Customer Support | 3 | ERROR:#REF! | | |
| Configuration Management Support | 2 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Systems Analyst Support | 10 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Telephone Support | 1 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| | | ERROR:#REF! | ERROR:#REF! |
| Total Labor | | ERROR:#REF! | | ERROR:#REF! |
| | Burden Rate | |
| Total ODC's | $ - 0 | | $ - 0 |
| Total Travel | $ - 0 | | $ - 0 |
Grand Total ERROR:#REF!
| Entering the appropriate percentages in the shaded areas will automatically compute the corresponding amounts in the spreadsheet. |
| * = From labor detail spreadsheet. |
| ** = NOTE: In this case, OCONUS means Iraq or Afghanistan. If performance is required in an OCONUS location other than Iraq or Afghanistan, proposed OCONUS rates will not be in effect. See CLIN 0001 for more detail. |
| Attachment 1 | Labor Categories and |
| Level of Effort | W91CRB-08-R-0092 |
Instructions
INSTRUCTIONS
Section B
| SECTION B - SUPPLIES OR SERVICES & PRICES | | | | | | |
| Solicitation: W91CRB-17-R-0030 | | | | | | |
| Prime Contractor/Subcontractor Name/Division: | | | | | | |
| Period of Performance: | | | | | | |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT | |
| 0001 | Year 1 FD Labor | 1 | Each | $ - 0 | | |
| T&M | | Cost = | | $ - 0 | From Cost Summary Worksheet |
| | | Profit = | | $ - 0 | From Cost Summary Worksheet |
| | | Total T&M = | | $ - 0 | |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT | |
| 0002 | Year 1 OCAR Labor | 1 | Each | $ - 0 | | |
| T&M | | Cost = | | $ - 0 | From Cost Summary Worksheet |
| | | Profit = | | $ - 0 | From Cost Summary Worksheet |
| | | Total T&M = | | $ - 0 | |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT | |
| 0003 | Year 1 Comptroller Proponency Labor | 1 | Each | $ - 0 | | |
| T&M | | Cost = | | $ - 0 | From Cost Summary Worksheet |
| | | Profit = | | $ - 0 | From Cost Summary Worksheet |
| | | Total T&M = | | $ - 0 | |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT | |
| 0004 | Year 1 Travel and ODCs | 1 | Each | $ - 0 | | |
| T&M | | Cost = | | $ 145,000.00 | From Cost Summary Worksheet |
| | | G&A = | | $ - 0 | |
| | | | | $ 145,000.00 | |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT |
| 0005 | Year 1 Contract Data Requirements - NSP | | | | |
| T&M | | | | |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT |
| 0006 | Year 1 Contractor Manpower Reporting - NSP | | | | |
| T&M | | | | |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT | |
| 0007 | Year 1 Surge Labor | 1 | Each | $ - 0 | | |
| T&M | | Cost = | | $ - 0 | From Cost Summary Worksheet |
| | | Profit = | | $ - 0 | From Cost Summary Worksheet |
| | | Total T&M = | | $ - 0 | |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT | |
| 0008 | Transition In | 1 | Each | $ - 0 | | |
| T&M | | Cost = | | $ - 0 | From Cost Summary Worksheet |
| | | Profit = | | $ - 0 | From Cost Summary Worksheet |
| | | Total T&M = | | $ - 0 | |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT | |
| 1001 | Year 2 FD Labor | 1 | Each | $ - 0 | | |
| T&M | | Cost = | | $ - 0 | From Cost Summary Worksheet |
| | | Profit = | | $ - 0 | From Cost Summary Worksheet |
| | | Total T&M = | | $ - 0 | |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT | |
| 1002 | OCAR Labor Year 2 | 1 | Each | $ - 0 | | |
| T&M | | Cost = | | $ - 0 | From Cost Summary Worksheet |
| | | Profit = | | $ - 0 | From Cost Summary Worksheet |
| | | Total T&M = | | $ - 0 | |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT | |
| 1003 | Comptroller Proponency Labor Year 2 | 1 | Each | $ - 0 | | |
| T&M | | Cost = | | $ - 0 | From Cost Summary Worksheet |
| | | Profit = | | $ - 0 | From Cost Summary Worksheet |
| | | Total T&M = | | $ - 0 | |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT | |
| 1004 | Year 2 Travel and ODCs | 1 | Each | $ - 0 | | |
| T&M | | Cost = | | $ 145,000.00 | From Cost Summary Worksheet |
| | | G&A = | | $ - 0 | |
| | | | | $ 145,000.00 | |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT |
| 1005 | Year 2 Contract Data Requirements - NSP | | | | |
| T&M | | | | |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT |
| 1006 | Year 2 Contractor Manpower Reporting - NSP | | | | |
| T&M | | | | |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT | |
| 1007 | Surge Labor Year 2 | 1 | Each | $ - 0 | | |
| T&M | | Cost = | | $ - 0 | From Cost Summary Worksheet |
| | | Profit = | | $ - 0 | From Cost Summary Worksheet |
| | | Total T&M = | | $ - 0 | |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT | |
| 2001 | FD Labor Year 3 | 1 | Each | $ - 0 | | |
| T&M | | Cost = | | $ - 0 | From Cost Summary Worksheet |
| | | Profit = | | $ - 0 | From Cost Summary Worksheet |
| | | Total T&M = | | $ - 0 | |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT | |
| 2002 | OCAR Labor Year 3 | 1 | Each | $ - 0 | | |
| T&M | | Cost = | | $ - 0 | From Cost Summary Worksheet |
| | | Profit = | | $ - 0 | From Cost Summary Worksheet |
| | | Total T&M = | | $ - 0 | |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT | |
| 2003 | Comptroller Proponency Labor Year 3 | 1 | Each | $ - 0 | | |
| T&M | | Cost = | | $ - 0 | From Cost Summary Worksheet |
| | | Profit = | | $ - 0 | From Cost Summary Worksheet |
| | | Total T&M = | | $ - 0 | |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT | |
| 2004 | Year 3 Travel and ODCs | 1 | Each | $ - 0 | | |
| T&M | | Cost = | | $ 145,000.00 | From Cost Summary Worksheet |
| | | G&A = | | $ - 0 | |
| | | | | $ 145,000.00 | |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT |
| 2005 | Year 3 Contract Data Requirements - NSP | | | | |
| T&M | | | | |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT |
| 2006 | Year 3 Contractor Manpower Reporting - NSP | | | | |
| T&M | | | | |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT | |
| 2007 | Surge Labor Year 3 | 1 | Each | $ - 0 | | |
| T&M | | Cost = | | $ - 0 | From Cost Summary Worksheet |
| | | Profit = | | $ - 0 | From Cost Summary Worksheet |
| | | Total T&M = | | $ - 0 | |
| TOTAL | |
| Total Cost = | $ 435,000.00 |
| Profit = | $ - 0 |
| Total = | $ 435,000.00 |
| $ 435,000.00 |
&F, &A
PAGE &P OF &N
Cost Summary
| COST SUMMARY |
| Solicitation: W91CRB-17-R-0030 |
| Prime Contractor/Subcontractor Name/Division: |
| Period of Performance: |
| Transition In | Year 1 | Year 2 | Year 3 | Total |
| FD Labor Hours | 11,045 | 121,495 | 132,540 | 132,540 | 397,620 |
| Labor & Subcontract Labor | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Profit | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Subtotal FD Labor | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| OCAR Labor Hours | 470 | 5,170 | 5,640 | 5,640 | 16,920 |
| Labor & Subcontract Labor | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Profit | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Subtotal OCAR Labor | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Comptroller Proponency Office Labor Hours | 313 | 3,447 | 3,760 | 3,760 | 11,280 |
| Labor & Subcontract Labor | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Profit | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Subtotal Comptroller Proponency Office Labor | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Surge Labor Hours | 1,723 | 18,957 | 20,680 | 20,680 | 62,040 |
| Labor & Subcontract Labor | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Profit | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Subtotal Surge Labor | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Labor Hours Total | 13,552 | 149,068 | 162,620 | 162,620 | 487,860 |
| Labor & Subcontract Labor Total | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Profit Total | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Labor | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Other Direct Costs | $ 145,000.00 | $ 145,000.00 | $ 145,000.00 | $ 435,000.00 |
| G&A | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total ODC | $ 145,000.00 | $ 145,000.00 | $ 145,000.00 | $ 435,000.00 |
TOTAL PRICE $ 145,000.00 $ 145,000.00 $ 145,000.00 $ 435,000.00
&F, &A
Page &P of &N
FD Labor - Cost Detail
| REGULAR LABOR - COST DETAIL SPREADSHEET |
| Solicitation: W91CRB-17-R-0030 |
| Prime Contractor/Subcontractor Name/Division: |
| Period of Performance: |
| Annual Productive Hours: | 1880 | | | | | | | | | | | | | | | |
| CLIN 0008: 30-day Transition In | | | | | | | | 0.00% | 0.00% | | | 0.00% | | 0.00% | | |
| Division | Labor Categories (Note 1) | CLIN Type | FTEs (Note 2) | Estimated Productive Hrs Per FTE | Total Hours | Effort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 1) | If Col e=S, Enter Name of Subcontractor(s) (Note 1) | Hourly Base Pay Rate (Note 3) | Fringe (Note 4) | Overhead (Note 5) | Rate Before Application Of Prime G&A & Profit (Note 6) | Total Prime & Sub Labor Before Prime G&A & Fee | G&A Total | Subtotal | Profit Total | Total | Total Burdened Rate Including Fee |
| a | b | c | d | e = c x d | f | g | h | i = h x fringe | j | k | l = e x k | m | n = l + m | o | p = n + o | q = p/e |
| PM - Offsite | | | | | | | | | | | | | | | | | |
| Program Manager | T&M | 0.5 | 157 | 78.3 | Enter P or S | | | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| DOM | | | | | | | | | | | | | | | |
| FDB | Senior Analyst | T&M | 1.0 | 157 | 156.7 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDC | Senior Analyst | T&M | 2.0 | 157 | 313.3 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Senior Analyst | T&M | 7.0 | 157 | 1,096.7 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDD | Senior Analyst | T&M | 6.0 | 157 | 940.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDG | Senior Analyst | T&M | 3.0 | 157 | 470.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Senior Analyst | T&M | 3.0 | 157 | 470.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDI | Senior Analyst | T&M | 4.0 | 157 | 626.7 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDL | Analyst | T&M | 2.0 | 157 | 313.3 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDL | Senior Analyst | T&M | 1.0 | 157 | 156.7 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDV | Senior Analyst | T&M | 2.0 | 157 | 313.3 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| DOR | | | | | | | | | | | | | | | |
| FDA | Operations Research Analyst | T&M | 3.0 | 157 | 470.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Senior Operations Research Analyst | T&M | 3.0 | 157 | 470.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDP | Senior Analyst | T&M | 1.0 | 157 | 156.7 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Senior Analyst | T&M | 1.0 | 157 | 156.7 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Senior Analyst | T&M | 1.0 | 157 | 156.7 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Analyst | T&M | 2.0 | 157 | 313.3 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Analyst | T&M | 2.0 | 157 | 313.3 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDR | Senior Analyst | T&M | 1.0 | 157 | 156.7 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDR | Analyst | T&M | 1.0 | 157 | 156.7 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| G8/FD | | | | | | | | | | | | | | | |
| FDZ | Force Documentation Analyst | T&M | 1.0 | 157 | 156.7 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Communications Liaison | T&M | 1.0 | 157 | 156.7 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| DIG | Senior Analyst | T&M | 1.0 | 157 | 156.7 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Web Master/Designer | T&M | 1.0 | 157 | 156.7 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Communications Liaison | T&M | 1.0 | 157 | 156.7 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| DJI | | | | | | | | | | | | | | | |
| FDF | Senior Analyst | T&M | 1.0 | 157 | 156.7 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Senior Analyst | T&M | 1.0 | 157 | 156.7 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDO | Senior Analyst | T&M | 1.0 | 157 | 156.7 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Senior Analyst | T&M | 4.0 | 157 | 626.7 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDJ | Senior Analyst | T&M | 3.0 | 157 | 470.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Analyst | T&M | 1.0 | 157 | 156.7 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDS | Senior Operations Research Analyst | T&M | 4.0 | 157 | 626.7 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| G8 LNOs | | | | | | | | | | | | | | | |
| G8 LNOs | Senior Analyst | T&M | 4.0 | 157 | 626.7 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
70.5 11,045.0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00
| CLIN 0001: Year 1, Months 2 - 12 | | | | | | | | 0.00% | 0.00% | | | 0.00% | | 0.00% | | |
| Labor Categories (Note 1) | CLIN Type | FTEs (Note 2) | Estimated Productive Hrs Per FTE | Total Hours | Effort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 1) | If Col e=S, Enter Name of Subcontractor(s) (Note 1) | Hourly Base Pay Rate (Note 3) | Fringe (Note 4) | Overhead (Note 5) | Rate Before Application Of Prime G&A & Profit (Note 6) | Total Prime & Sub Labor Before Prime G&A & Fee | G&A Total | Subtotal | Profit Total | Total | Total Burdened Rate Including Fee |
| a | b | c | d | e = c x d | f | g | h | i = h x fringe | j | k | l = e x k | m | n = l + m | o | p = n + o | q = p/e |
| PM - Offsite | | | | | | | | | | | | | | | | | |
| Program Manager | T&M | 0.5 | 1,723 | 861.7 | Enter P or S | | | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| DOM | | | | | | | | | | | | | | | |
| FDB | Senior Analyst | T&M | 1.0 | 1,723 | 1,723.3 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDC | Senior Analyst | T&M | 2.0 | 1,723 | 3,446.7 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Senior Analyst | T&M | 7.0 | 1,723 | 12,063.3 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDD | Senior Analyst | T&M | 6.0 | 1,723 | 10,340.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDG | Senior Analyst | T&M | 3.0 | 1,723 | 5,170.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Senior Analyst | T&M | 3.0 | 1,723 | 5,170.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDI | Senior Analyst | T&M | 4.0 | 1,723 | 6,893.3 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDL | Analyst | T&M | 2.0 | 1,723 | 3,446.7 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDL | Senior Analyst | T&M | 1.0 | 1,723 | 1,723.3 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDV | Senior Analyst | T&M | 2.0 | 1,723 | 3,446.7 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| DOR | | | | | | | | | | | | | | | |
| FDA | Operations Research Analyst | T&M | 3.0 | 1,723 | 5,170.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Senior Operations Research Analyst | T&M | 3.0 | 1,723 | 5,170.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDP | Senior Analyst | T&M | 1.0 | 1,723 | 1,723.3 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Senior Analyst | T&M | 1.0 | 1,723 | 1,723.3 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Senior Analyst | T&M | 1.0 | 1,723 | 1,723.3 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Analyst | T&M | 2.0 | 1,723 | 3,446.7 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Analyst | T&M | 2.0 | 1,723 | 3,446.7 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDR | Senior Analyst | T&M | 1.0 | 1,723 | 1,723.3 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDR | Analyst | T&M | 1.0 | 1,723 | 1,723.3 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| G8/FD | | | | | | | | | | | | | | | |
| FDZ | Force Documentation Analyst | T&M | 1.0 | 1,723 | 1,723.3 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Communications Liaison | T&M | 1.0 | 1,723 | 1,723.3 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| DIG | Senior Analyst | T&M | 1.0 | 1,723 | 1,723.3 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Web Master/Designer | T&M | 1.0 | 1,723 | 1,723.3 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Communications Liaison | T&M | 1.0 | 1,723 | 1,723.3 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| DJI | | | | | | | | | | | | | | | |
| FDF | Senior Analyst | T&M | 1.0 | 1,723 | 1,723.3 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Senior Analyst | T&M | 1.0 | 1,723 | 1,723.3 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDO | Senior Analyst | T&M | 1.0 | 1,723 | 1,723.3 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Senior Analyst | T&M | 4.0 | 1,723 | 6,893.3 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDJ | Senior Analyst | T&M | 3.0 | 1,723 | 5,170.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Analyst | T&M | 1.0 | 1,723 | 1,723.3 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDS | Senior Operations Research Analyst | T&M | 4.0 | 1,723 | 6,893.3 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| G8 LNOs | | | | | | | | | | | | | | | |
| G8 LNOs | Senior Analyst | T&M | 4.0 | 1,723 | 6,893.3 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
70.5 121,495.0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00
| CLIN 1001: Year 2, Months 13 - 24 | | | | | | | | 0.00% | 0.00% | | | 0.00% | | 0.00% | | |
| Labor Categories (Note 1) | CLIN Type | FTEs (Note 2) | Estimated Productive Hrs Per FTE | Total Hours | Effort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 1) | If Col e=S, Enter Name of Subcontractor(s) (Note 1) | Hourly Base Pay Rate (Note 3) | Fringe (Note 4) | Overhead (Note 5) | Rate Before Application Of Prime G&A & Profit (Note 6) | Total Prime & Sub Labor Before Prime G&A & Fee | G&A Total | Subtotal | Profit Total | Total | Total Burdened Rate Including Fee |
| a | b | c | d | e = c x d | f | g | h | i = h x fringe | j | k | l = e x k | m | n = l + m | o | p = n + o | q = p/e |
| PM - Offsite | | | | | | | | | | | | | | | | | |
| Program Manager | T&M | 0.5 | 1,880 | 940.0 | Enter P or S | | | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| DOM | | | | | | | | | | | | | | | |
| FDB | Senior Analyst | T&M | 1.0 | 1,880 | 1,880.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDC | Senior Analyst | T&M | 2.0 | 1,880 | 3,760.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Senior Analyst | T&M | 7.0 | 1,880 | 13,160.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDD | Senior Analyst | T&M | 6.0 | 1,880 | 11,280.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDG | Senior Analyst | T&M | 3.0 | 1,880 | 5,640.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Senior Analyst | T&M | 3.0 | 1,880 | 5,640.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDI | Senior Analyst | T&M | 4.0 | 1,880 | 7,520.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDL | Analyst | T&M | 2.0 | 1,880 | 3,760.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDL | Senior Analyst | T&M | 1.0 | 1,880 | 1,880.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDV | Senior Analyst | T&M | 2.0 | 1,880 | 3,760.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| DOR | | | | | | | | | | | | | | | |
| FDA | Operations Research Analyst | T&M | 3.0 | 1,880 | 5,640.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Senior Operations Research Analyst | T&M | 3.0 | 1,880 | 5,640.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDP | Senior Analyst | T&M | 1.0 | 1,880 | 1,880.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Senior Analyst | T&M | 1.0 | 1,880 | 1,880.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Senior Analyst | T&M | 1.0 | 1,880 | 1,880.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Analyst | T&M | 2.0 | 1,880 | 3,760.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Analyst | T&M | 2.0 | 1,880 | 3,760.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDR | Senior Analyst | T&M | 1.0 | 1,880 | 1,880.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDR | Analyst | T&M | 1.0 | 1,880 | 1,880.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| G8/FD | | | | | | | | | | | | | | | |
| FDZ | Force Documentation Analyst | T&M | 1.0 | 1,880 | 1,880.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Communications Liaison | T&M | 1.0 | 1,880 | 1,880.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| DIG | Senior Analyst | T&M | 1.0 | 1,880 | 1,880.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Web Master/Designer | T&M | 1.0 | 1,880 | 1,880.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Communications Liaison | T&M | 1.0 | 1,880 | 1,880.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| DJI | | | | | | | | | | | | | | | |
| FDF | Senior Analyst | T&M | 1.0 | 1,880 | 1,880.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Senior Analyst | T&M | 1.0 | 1,880 | 1,880.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDO | Senior Analyst | T&M | 1.0 | 1,880 | 1,880.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Senior Analyst | T&M | 4.0 | 1,880 | 7,520.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDJ | Senior Analyst | T&M | 3.0 | 1,880 | 5,640.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Analyst | T&M | 1.0 | 1,880 | 1,880.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDS | Senior Operations Research Analyst | T&M | 4.0 | 1,880 | 7,520.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| G8 LNOs | | | | | | | | | | | | | | | |
| G8 LNOs | Senior Analyst | T&M | 4.0 | 1,880 | 7,520.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
70.5 132,540.0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00
| CLIN 2001: Year 3, Months 25 - 36 | | | | | | | | 0.00% | 0.00% | | | 0.00% | | 0.00% | | |
| Labor Categories (Note 1) | CLIN Type | FTEs (Note 2) | Estimated Productive Hrs Per FTE | Total Hours | Effort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 1) | If Col e=S, Enter Name of Subcontractor(s) (Note 1) | Hourly Base Pay Rate (Note 3) | Fringe (Note 4) | Overhead (Note 5) | Rate Before Application Of Prime G&A & Profit (Note 6) | Total Prime & Sub Labor Before Prime G&A & Fee | G&A Total | Subtotal | Profit Total | Total | Total Burdened Rate Including Fee |
| a | b | c | d | e = c x d | f | g | h | i = h x fringe | j | k | l = e x k | m | n = l + m | o | p = n + o | q = p/e |
| PM - Offsite | | | | | | | | | | | | | | | | | |
| Program Manager | T&M | 0.5 | 1,880 | 940.0 | Enter P or S | | | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| DOM | | | | | | | | | | | | | | | |
| FDB | Senior Analyst | T&M | 1.0 | 1,880 | 1,880.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDC | Senior Analyst | T&M | 2.0 | 1,880 | 3,760.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Senior Analyst | T&M | 7.0 | 1,880 | 13,160.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDD | Senior Analyst | T&M | 6.0 | 1,880 | 11,280.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDG | Senior Analyst | T&M | 3.0 | 1,880 | 5,640.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Senior Analyst | T&M | 3.0 | 1,880 | 5,640.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDI | Senior Analyst | T&M | 4.0 | 1,880 | 7,520.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDL | Analyst | T&M | 2.0 | 1,880 | 3,760.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDL | Senior Analyst | T&M | 1.0 | 1,880 | 1,880.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDV | Senior Analyst | T&M | 2.0 | 1,880 | 3,760.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| DOR | | | | | | | | | | | | | | | |
| FDA | Operations Research Analyst | T&M | 3.0 | 1,880 | 5,640.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Senior Operations Research Analyst | T&M | 3.0 | 1,880 | 5,640.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDP | Senior Analyst | T&M | 1.0 | 1,880 | 1,880.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Senior Analyst | T&M | 1.0 | 1,880 | 1,880.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Senior Analyst | T&M | 1.0 | 1,880 | 1,880.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Analyst | T&M | 2.0 | 1,880 | 3,760.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Analyst | T&M | 2.0 | 1,880 | 3,760.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDR | Senior Analyst | T&M | 1.0 | 1,880 | 1,880.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDR | Analyst | T&M | 1.0 | 1,880 | 1,880.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| G8/FD | | | | | | | | | | | | | | | |
| FDZ | Force Documentation Analyst | T&M | 1.0 | 1,880 | 1,880.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Communications Liaison | T&M | 1.0 | 1,880 | 1,880.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| DIG | Senior Analyst | T&M | 1.0 | 1,880 | 1,880.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Web Master/Designer | T&M | 1.0 | 1,880 | 1,880.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Communications Liaison | T&M | 1.0 | 1,880 | 1,880.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| DJI | | | | | | | | | | | | | | | |
| FDF | Senior Analyst | T&M | 1.0 | 1,880 | 1,880.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Senior Analyst | T&M | 1.0 | 1,880 | 1,880.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDO | Senior Analyst | T&M | 1.0 | 1,880 | 1,880.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Senior Analyst | T&M | 4.0 | 1,880 | 7,520.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDJ | Senior Analyst | T&M | 3.0 | 1,880 | 5,640.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Analyst | T&M | 1.0 | 1,880 | 1,880.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FDS | Senior Operations Research Analyst | T&M | 4.0 | 1,880 | 7,520.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| G8 LNOs | | | | | | | | | | | | | | | |
| G8 LNOs | Senior Analyst | T&M | 4.0 | 1,880 | 7,520.0 | Enter P or S | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
70.5 132,540.0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00
Totals: 282.0 397,620.0 $0.00 ERROR:#DIV/0! ERROR:#DIV/0! $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
&F, &A
PAGE &P OF &N
OCAR Labor - Cost Detail
| REGULAR LABOR - COST DETAIL SPREADSHEET |
| Solicitation: W91CRB-17-R-0030 |
| Prime Contractor/Subcontractor Name/Division: |
| Period of Performance: |
| Annual Productive Hours: | 1880 | | | | | | | | | | | | | | | |
| CLIN 0008: 30-day Transition In | | | | | | | | 0.00% | 0.00% | | | 0.00% | | 0.00% | | |
| Division | Labor Categories (Note 1) | CLIN Type | FTEs (Note 2) | Estimated Productive Hrs Per FTE | Total Hours | Effort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 1) | If Col e=S, Enter Name of Subcontractor(s) (Note 1) | Hourly Base Pay Rate (Note 3) | Fringe (Note 4) | Overhead (Note 5) | Rate Before Application Of Prime G&A & Profit (Note 6) | Total Prime & Sub Labor Before Prime G&A & Fee | G&A Total | Subtotal | Profit Total | Total | Total Burdened Rate Including Fee |
| a | b | c | d | e = c x d | f | g | h | i = h x fringe | j | k | l = e x k | m | n = l + m | o | p = n + o | q = p/e |
| Senior Analyst | T&M | 3.0 | 157 | 470.0 | Enter P or S | | | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
3.0 470.0 ERROR:#VALUE! $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00
| CLIN 0002: Year 1, Months 2 - 12 | | | | | | | | 0.00% | 0.00% | | | 0.00% | | 0.00% | | |
| Labor Categories (Note 1) | CLIN Type | FTEs (Note 2) | Estimated Productive Hrs Per FTE | Total Hours | Effort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 1) | If Col e=S, Enter Name of Subcontractor(s) (Note 1) | Hourly Base Pay Rate (Note 3) | Fringe (Note 4) | Overhead (Note 5) | Rate Before Application Of Prime G&A & Profit (Note 6) | Total Prime & Sub Labor Before Prime G&A & Fee | G&A Total | Subtotal | Profit Total | Total | Total Burdened Rate Including Fee |
| a | b | c | d | e = c x d | f | g | h | i = h x fringe | j | k | l = e x k | m | n = l + m | o | p = n + o | q = p/e |
| Senior Analyst | T&M | 3.0 | 1,723 | 5,170.0 | Enter P or S | | | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
3.0 5,170.0 ERROR:#VALUE! $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00
| CLIN 1002: Year 2, Months 13 - 24 | | | | | | | | 0.00% | 0.00% | | | 0.00% | | 0.00% | | |
| Labor Categories (Note 1) | CLIN Type | FTEs (Note 2) | Estimated Productive Hrs Per FTE | Total Hours | Effort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 1) | If Col e=S, Enter Name of Subcontractor(s) (Note 1) | Hourly Base Pay Rate (Note 3) | Fringe (Note 4) | Overhead (Note 5) | Rate Before Application Of Prime G&A & Profit (Note 6) | Total Prime & Sub Labor Before Prime G&A & Fee | G&A Total | Subtotal | Profit Total | Total | Total Burdened Rate Including Fee |
| a | b | c | d | e = c x d | f | g | h | i = h x fringe | j | k | l = e x k | m | n = l + m | o | p = n + o | q = p/e |
| Senior Analyst | T&M | 3.0 | 1,880 | 5,640.0 | Enter P or S | | | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
3.0 5,640.0 ERROR:#VALUE! $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00
| CLIN 2002: Year 3, Months 25 - 36 | | | | | | | | 0.00% | 0.00% | | | 0.00% | | 0.00% | | |
| Labor Categories (Note 1) | CLIN Type | FTEs (Note 2) | Estimated Productive Hrs Per FTE | Total Hours | Effort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 1) | If Col e=S, Enter Name of Subcontractor(s) (Note 1) | Hourly Base Pay Rate (Note 3) | Fringe (Note 4) | Overhead (Note 5) | Rate Before Application Of Prime G&A & Profit (Note 6) | Total Prime & Sub Labor Before Prime G&A & Fee | G&A Total | Subtotal | Profit Total | Total | Total Burdened Rate Including Fee |
| a | b | c | d | e = c x d | f | g | h | i = h x fringe | j | k | l = e x k | m | n = l + m | o | p = n + o | q = p/e |
| Senior Analyst | T&M | 3.0 | 1,880 | 5,640.0 | Enter P or S | | | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
3.0 5,640.0 ERROR:#VALUE! $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00
Totals: 12.0 16,920.0 ERROR:#VALUE! ERROR:#DIV/0! ERROR:#DIV/0! $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
&F, &A
PAGE &P OF &N
CompPropOff Labor - Cost Detail
| REGULAR LABOR - COST DETAIL SPREADSHEET |
| Solicitation: W91CRB-17-R-0030 |
| Prime Contractor/Subcontractor Name/Division: |
| Period of Performance: |
| Annual Productive Hours: | 1880 | | | | | | | | | | | | | | | |
| CLIN 0008: 30-day Transition In | | | | | | | | 0.00% | 0.00% | | | 0.00% | | 0.00% | | |
| Division | Labor Categories (Note 1) | CLIN Type | FTEs (Note 2) | Estimated Productive Hrs Per FTE | Total Hours | Effort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 1) | If Col e=S, Enter Name of Subcontractor(s) (Note 1) | Hourly Base Pay Rate (Note 3) | Fringe (Note 4) | Overhead (Note 5) | Rate Before Application Of Prime G&A & Profit (Note 6) | Total Prime & Sub Labor Before Prime G&A & Fee | G&A Total | Subtotal | Profit Total | Total | Total Burdened Rate Including Fee |
| a | b | c | d | e = c x d | f | g | h | i = h x fringe | j | k | l = e x k | m | n = l + m | o | p = n + o | q = p/e |
| CPO | Communications Liasion | T&M | 1.0 | 157 | 156.7 | Enter P or S | | | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Web Master/Designer | T&M | 1.0 | 157 | 156.7 | Enter P or S | | | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
2.0 313.3 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00
| CLIN 0003: Year 1, Months 2 - 12 | | | | | | | | 0.00% | 0.00% | | | 0.00% | | 0.00% | | |
| Labor Categories (Note 1) | CLIN Type | FTEs (Note 2) | Estimated Productive Hrs Per FTE | Total Hours | Effort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 1) | If Col e=S, Enter Name of Subcontractor(s) (Note 1) | Hourly Base Pay Rate (Note 3) | Fringe (Note 4) | Overhead (Note 5) | Rate Before Application Of Prime G&A & Profit (Note 6) | Total Prime & Sub Labor Before Prime G&A & Fee | G&A Total | Subtotal | Profit Total | Total | Total Burdened Rate Including Fee |
| a | b | c | d | e = c x d | f | g | h | i = h x fringe | j | k | l = e x k | m | n = l + m | o | p = n + o | q = p/e |
| CPO | Communications Liasion | T&M | 1.0 | 1,723 | 1,723.3 | Enter P or S | | | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Web Master/Designer | T&M | 1.0 | 1,723 | 1,723.3 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
2.0 3,446.7 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00
| CLIN 1003: Year 2, Months 13 - 24 | | | | | | | | 0.00% | 0.00% | | | 0.00% | | 0.00% | | |
| Labor Categories (Note 1) | CLIN Type | FTEs (Note 2) | Estimated Productive Hrs Per FTE | Total Hours | Effort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 1) | If Col e=S, Enter Name of Subcontractor(s) (Note 1) | Hourly Base Pay Rate (Note 3) | Fringe (Note 4) | Overhead (Note 5) | Rate Before Application Of Prime G&A & Profit (Note 6) | Total Prime & Sub Labor Before Prime G&A & Fee | G&A Total | Subtotal | Profit Total | Total | Total Burdened Rate Including Fee |
| a | b | c | d | e = c x d | f | g | h | i = h x fringe | j | k | l = e x k | m | n = l + m | o | p = n + o | q = p/e |
| CPO | Communications Liasion | T&M | 1.0 | 1,880 | 1,880.0 | Enter P or S | | | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Web Master/Designer | T&M | 1.0 | 1,880 | 1,880.0 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
2.0 3,760.0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00
| CLIN 2003: Year 3, Months 25 - 36 | | | | | | | | 0.00% | 0.00% | | | 0.00% | | 0.00% | | |
| Labor Categories (Note 1) | CLIN Type | FTEs (Note 2) | Estimated Productive Hrs Per FTE | Total Hours | Effort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 1) | If Col e=S, Enter Name of Subcontractor(s) (Note 1) | Hourly Base Pay Rate (Note 3) | Fringe (Note 4) | Overhead (Note 5) | Rate Before Application Of Prime G&A & Profit (Note 6) | Total Prime & Sub Labor Before Prime G&A & Fee | G&A Total | Subtotal | Profit Total | Total | Total Burdened Rate Including Fee |
| a | b | c | d | e = c x d | f | g | h | i = h x fringe | j | k | l = e x k | m | n = l + m | o | p = n + o | q = p/e |
| CPO | Communications Liasion | T&M | 1.0 | 1,880 | 1,880.0 | Enter P or S | | | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Web Master/Designer | T&M | 1.0 | 1,880 | 1,880.0 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
2.0 3,760.0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00
Totals: 8.0 11,280.0 $0.00 ERROR:#DIV/0! ERROR:#DIV/0! $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
&F, &A
PAGE &P OF &N
Surge Labor - Cost Detail
| REGULAR LABOR - COST DETAIL SPREADSHEET |
| Solicitation: W91CRB-17-R-0030 |
| Prime Contractor/Subcontractor Name/Division: |
| Period of Performance: |
| Annual Productive Hours: | 1880 | | | | | | | | | | | | | | | |
| CLIN 0008: 30-day Transition In | | | | | | | | 0.00% | 0.00% | | | 0.00% | | 0.00% | | |
| Division | Labor Categories (Note 1) | CLIN Type | FTEs (Note 2) | Estimated Productive Hrs Per FTE | Total Hours | Effort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 1) | If Col e=S, Enter Name of Subcontractor(s) (Note 1) | Hourly Base Pay Rate (Note 3) | Fringe (Note 4) | Overhead (Note 5) | Rate Before Application Of Prime G&A & Profit (Note 6) | Total Prime & Sub Labor Before Prime G&A & Fee | G&A Total | Subtotal | Profit Total | Total | Total Burdened Rate Including Fee |
| a | b | c | d | e = c x d | f | g | h | i = h x fringe | j | k | l = e x k | m | n = l + m | o | p = n + o | q = p/e |
| FD | Senior Analyst | T&M | 6.0 | 157 | 940.0 | Enter P or S | | | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Senior Operations Research Analyst | T&M | 2.0 | 157 | 313.3 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Analyst | T&M | 2.0 | 157 | 313.3 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Operations Research Analyst | T&M | 1.0 | 157 | 156.7 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
11.0 1,723.3 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
| CLIN 0007: Year 1, Months 25 - 12 | | | | | | | | 0.00% | 0.00% | | | 0.00% | | 0.00% | | |
| Labor Categories (Note 1) | CLIN Type | FTEs (Note 2) | Estimated Productive Hrs Per FTE | Total Hours | Effort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 1) | If Col e=S, Enter Name of Subcontractor(s) (Note 1) | Hourly Base Pay Rate (Note 3) | Fringe (Note 4) | Overhead (Note 5) | Rate Before Application Of Prime G&A & Profit (Note 6) | Total Prime & Sub Labor Before Prime G&A & Fee | G&A Total | Subtotal | Profit Total | Total | Total Burdened Rate Including Fee |
| a | b | c | d | e = c x d | f | g | h | i = h x fringe | j | k | l = e x k | m | n = l + m | o | p = n + o | q = p/e |
| FD | Senior Analyst | T&M | 6.0 | 1,723 | 10,340.0 | Enter P or S | | | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Senior Operations Research Analyst | T&M | 2.0 | 1,723 | 3,446.7 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Analyst | T&M | 2.0 | 1,723 | 3,446.7 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Operations Research Analyst | T&M | 1.0 | 1,723 | 1,723.3 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
11.0 18,956.7 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
| CLIN 1007: Year 2, Months 13 - 24 | | | | | | | | 0.00% | 0.00% | | | 0.00% | | 0.00% | | |
| Labor Categories (Note 1) | CLIN Type | FTEs (Note 2) | Estimated Productive Hrs Per FTE | Total Hours | Effort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 1) | If Col e=S, Enter Name of Subcontractor(s) (Note 1) | Hourly Base Pay Rate (Note 3) | Fringe (Note 4) | Overhead (Note 5) | Rate Before Application Of Prime G&A & Profit (Note 6) | Total Prime & Sub Labor Before Prime G&A & Fee | G&A Total | Subtotal | Profit Total | Total | Total Burdened Rate Including Fee |
| a | b | c | d | e = c x d | f | g | h | i = h x fringe | j | k | l = e x k | m | n = l + m | o | p = n + o | q = p/e |
| FD | Senior Analyst | T&M | 6.0 | 1,880 | 11,280.0 | Enter P or S | | | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Senior Operations Research Analyst | T&M | 2.0 | 1,880 | 3,760.0 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Analyst | T&M | 2.0 | 1,880 | 3,760.0 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Operations Research Analyst | T&M | 1.0 | 1,880 | 1,880.0 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
11.0 20,680.0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
| CLIN 2007: Year 3, Months 25 - 36 | | | | | | | | 0.00% | 0.00% | | | 0.00% | | 0.00% | | |
| Labor Categories (Note 1) | CLIN Type | FTEs (Note 2) | Estimated Productive Hrs Per FTE | Total Hours | Effort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 1) | If Col e=S, Enter Name of Subcontractor(s) (Note 1) | Hourly Base Pay Rate (Note 3) | Fringe (Note 4) | Overhead (Note 5) | Rate Before Application Of Prime G&A & Profit (Note 6) | Total Prime & Sub Labor Before Prime G&A & Fee | G&A Total | Subtotal | Profit Total | Total | Total Burdened Rate Including Fee |
| a | b | c | d | e = c x d | f | g | h | i = h x fringe | j | k | l = e x k | m | n = l + m | o | p = n + o | q = p/e |
| FD | Senior Analyst | T&M | 6.0 | 1,880 | 11,280.0 | Enter P or S | | | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Senior Operations Research Analyst | T&M | 2.0 | 1,880 | 3,760.0 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Analyst | T&M | 2.0 | 1,880 | 3,760.0 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Operations Research Analyst | T&M | 1.0 | 1,880 | 1,880.0 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
11.0 20,680.0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Totals: 44.0 62,040.0 $0.00 ERROR:#DIV/0! ERROR:#DIV/0! $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
&F, &A
PAGE &P OF &N
ODC Summary
| ODC Cost Detail Spreadsheet |
| Solicitation: W91CRB-17-R-0030 |
| Prime Contractor/Subcontractor Name/Division: |
| Period of Performance: |
| CLIN | ODCs (Note 7) | Burden/G&A Rate | G&A $ | Total ODC Cost |
| a | b | c | d = b X c | e = b + d |
| CLIN 0004: Year 1 | $ 145,000.00 | | $ - 0 | $ 145,000.00 |
| CLIN 1004: Year 2 | $ 145,000.00 | | $ - 0 | $ 145,000.00 |
| CLIN 2004: Year 3 | $ 145,000.00 | | $ - 0 | $ 145,000.00 |
| Total | $ 435,000.00 | | $ - 0 | $ 435,000.00 |
| | | (To Section B) | |
Direct Labor Rate Schedule
| DIRECT LABOR RATE SCHEDULE |
| Solicitation: W91CRB-17-R-0030 |
| Prime Contractor/Subcontractor Name/Division: |
| Period of Performance: |
| YEAR 1 | | YEAR 2 | | YEAR 3 | |
| LABOR CATEGORIES | PROPOSED DIRECT LABOR RATES | BASIS OF PROPOSED RATE FOR COST REALISM PURPOSES | ESCALATION | PROPOSED DIRECT LABOR RATES | ESCALATION | PROPOSED DIRECT LABOR RATES |
| NOTE 1 | | NOTE 2 | NOTE 3 | | NOTE 3 | |
| FD Labor | | | | | | |
| PM-Offsite | | | | | | |
| Program Manager | | | | | | |
| DOM |
| Senior Analyst |
| Senior Analyst |
| Senior Analyst |
| Senior Analyst |
| Senior Analyst |
| Senior Analyst |
| Senior Analyst |
| Analyst |
| Senior Analyst |
| Senior Analyst |
| DOR |
| Operations Research Analyst |
| Senior Operations Research Analyst |
| Senior Analyst |
| Senior Analyst |
| Senior Analyst |
| Analyst |
| Analyst |
| Senior Analyst |
| Analyst |
| G8/FD |
| Force Documentation Analyst |
| Communications Liaison |
| Senior Analyst |
| Web Master/Designer |
| Communications Liaison |
| DJI |
| Senior Analyst |
| Senior Analyst |
| Senior Analyst |
| Senior Analyst |
| Senior Analyst |
| Analyst |
| Senior Operations Research Analyst |
| OCAR Labor |
| Senior Analyst |
| Proponency Office Labor |
| Communications Liasion |
| Web Master/Designer |
| Surge Labor | |
| Senior Analyst | |
| Senior Operations Research Analyst | |
| Analyst | |
| Operations Research Analyst | |
| NOTE 1: | Please enter all the corresponding labor categories proposed in the labor cost detail spreadhseets. |
| NOTE 2: | For cost realism purposes indicate the basis of the proposed rates and provide documentation to substantiate the rates. |
| If the rates are based on actuals provide pay stubs, signed employee letters of intent, etc. |
| If the rates are based on estimates provide salary survey data and other data to corroborate the realism of the rates. |
| NOTE 3: | Please provide the basis of escalation. |
Indirect Rate Summary
| INDIRECT RATE SUMMARY | | | | | | | |
| Solicitation: W91CRB-17-R-0030 | | | | | | | |
| Prime Contractor/Subcontractor Name/Division: | | | | | | | |
| Period of Performance: | | | | | | | |
| TYPE OF SUBCONTRACT (I.E. T&M, CP, CPFF, ETC) | FRINGE RATE | OVERHEAD RATE | G&A RATE | PROPOSED PROFIT/FEE RATE | % OF EFFORT PERFORMED BY PRIME AND SUBS BASED ON LABOR HOURS | |
| YEAR 1 | | | | | | | |
| PRIME CONTRACTOR | | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
| SUBCONTRACTOR 1 | | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
| SUBCONTRACTOR 2 | | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
| SUBCONTRACTOR 3 | | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
| ETC | | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
| | | | | | 0.00% | (Should equal 100%) |
| YEAR 2 | | | | | | | |
| PRIME CONTRACTOR | | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
| SUBCONTRACTOR 1 | | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
| SUBCONTRACTOR 2 | | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
| SUBCONTRACTOR 3 | | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
| ETC | | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
| | | | | | 0.00% | (Should equal 100%) |
| YEAR 3 | | | | | | |
| PRIME CONTRACTOR | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
| SUBCONTRACTOR 1 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
| SUBCONTRACTOR 2 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
| SUBCONTRACTOR 3 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
| ETC | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
| | | | | 0.00% | (Should equal 100%) |
| Please enter corresponding indirect rates for the prime and each subcontractor for each of the periods. |
| Subcontractors may provide data separately in the above format for proprietary reasons. |
| Provide the necessary narrative describing how the rates were derived and applied, the composition of the allocation pools & bases, and provide any supporting forward rate agreements and DCAA/DCMA agreements/reports. |
| If rates proposed are other than based on actuals or actual budgets describe why. |
| Sample Fringe, Overhead, and G&A worksheet schedules follow this tab. |
Sample Fringe Worksheet
| FRINGE EXPENSE |
| Solicitation: W91CRB-17-R-0030 |
| Prime Contractor/Subcontractor Name/Division: |
| Period of Performance: |
| Fringe Expenses: | Current Actual | Estimated Year 1 | Estimated Year 2 | Estimated Year 3 |
| Indirect payroll | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Payroll taxes (FICA, FUTA, SUTA, Workmans Comp) | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Vacation (PTO) | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Holiday | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Sick Leave | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Health/Disability Ins | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Workmans Compensation | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Bonuses | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Retention Pay | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 401k Match | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Mil Leave | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Breavement | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Insurance | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Pool | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Less: FAR 31 Unallowable Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Entertainment, etc. | | | | |
| Net Allowable cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Labor Base | | | | |
| Direct Labor | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| OH Labor | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| B&P Labor | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Labor Base | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
Rate ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
This exhibit shows a fringe benefit allocation. The offeror may have a combined allocation for fringe benefits and overhead depending on its accounting system.
Sample OH Worksheet
| OVERHEAD EXPENSE |
| Solicitation: W91CRB-17-R-0030 |
| Prime Contractor/Subcontractor Name/Division: |
| Period of Performance: |
| Overhead Expenses: | Current Actual | Estimated Year 1 | Estimated Year 2 | Estimated Year 3 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Pool | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
Less: FAR 31 Unallowable Cost
Net Allowable cost $ - 0 $ - 0 $ - 0 $ - 0
| Labor Base | | | | |
| Direct Labor | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| OH Labor | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| B&P Labor | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Labor Base | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
Rate ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
This exhibit shows an overhead allocation. The offeror may have a combined allocation for fringe benefits and overhead depending on its accounting system.
Sample G&A Worksheet
| GENERAL & ADMINISTRATIVE (G&A) EXPENSE |
| Solicitation: W91CRB-17-R-0030 |
| Prime Contractor/Subcontractor Name/Division: |
| Period of Performance: |
| G&A Expenses: | Current Actual | Estimated Year 1 | Estimated Year 2 | Estimated Year 3 |
| Labor | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Fringe | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Subscriptions | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Postage | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Printing | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Supplies | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Telephone | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Travel | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Misc | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Training | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Recruiting | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Maint | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Equip | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Consultants | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Prof fees | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Filings | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Legal | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total G&A | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Less: FAR 31 Unallowable Costs | | | | |
| Interest | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Contributions | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Advertising, etc. | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Unallowable Costs | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| G&A Pool After Deducting Unallowable Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Allocation Base | | | | |
| Direct Labor | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Fringe | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Overhead (including any unallowable cost) | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Other Direct Costs (inclusing any unallowable cost) | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total G&A Allocation Base | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
Rate ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Microsoft_Word_Document1.docx General: Offeror is to provide a cost/price proposal and accompanying narrative as part of their proposal in response to the solicitation. FAR 15.403-5(b) allows the contracting officer to specify the format of cost or pricing data or data other than certified cost or pricing data. The completed enclosed worksheets shall be part of the cost/price proposal. This is a required flow down requirement, and therefore shall be submitted for the prime offeror AND for any and all divisions and subcontractors proposed to perform effort in response to this solicitation. The information will be evaluated for acceptability, fairness, and reasonableness based on the cost/price analysis and cost realism analysis criteria in FAR 15.404-1 and FAR 52.222-46, as appropriate. Please enter the requested data in the yellow shaded areas in all Labor Detail worksheets and in the Indirect Rate Summary worksheet. The worksheets are designed to automatically compute and populate other cells in the Excel worksheets and workbooks.
Section B Worksheet: The Section B worksheet imports data from the Cost Summary worksheet and is used as a basis for the proposed formal Section B.
Cost Summary Worksheet: This worksheet is for Government analysis purposes. It is populated from all Labor Detail worksheets and the ODC Summary worksheet.
Notes 1 – 6 apply to the FD Labor - Cost Detail, OCAR Labor - Cost Detail, CompPropOff Labor - Cost Detail, and Surge Labor - Cost Detail Worksheets:
Enter the requested data in the blue shaded cells. It may be necessary for each offeror to revise the number of rows, columns, and/or formulas to reflect differences or nuances in the offeror's accounting and estimating systems. However, it is requested that the general format be maintained as much as possible for cost/price analysis and contract administration purposes.
NOTE 1: Column ‘a’ of the Labor- Detail Worksheets contains labor categories. During contract performance these categories may be performed by the prime contractor and/or other divisions or subcontractors. The offeror is to enter a P in column ‘f’ if the effort is to be performed by the prime contractor, and a S if performed by another division or subcontractor. Enter the name of the division or contractor in column ‘g’. If the particular individual category is to be performed by more than one entity, the offeror will be required to insert additional row(s) under the labor category and to allocate the column 'c' FTEs, column 'd' Estimated Productive Hours per FTE, and column ‘e’ Total Hours for the individual category among the column ‘e’ cells in the original and inserted rows to reflect the proposed performance during the contract. After this allocation, the total of the original and inserted rows under the individual category shall total to the number of hours proposed for the respective labor category.
NOTE 2: FTE = full time equivalent.
NOTE 3: Please enter the base labor rate for the labor categories listed. The base labor rate is the rate actual paid to the employee EXCLUSIVE of social security, federal unemployment, state unemployment, workman's compensation, and non-statutory fringe benefits (i.e. 401K, vacations, holidays, etc), overhead, G&A, and fee. For proprietary reasons, subcontractors may provide this information directly to the Contracting Officer if the subcontractor chooses not to disclose this information to the offeror.
NOTE 4: Apply fringe to prime offeror derived rates. "Sample Fringe Worksheet" provides a sample to be used to compute fringe.
NOTE 5: Apply fringe to prime offeror derived rates. "Sample Overhead Worksheet" provides a sample to be used to compute overhead.
NOTE 6: Please enter the prime offeror or subcontractor billing rate (if performed by a subcontractor) BEFORE application of prime offeror general and administrative (G&A) expense and fixed fee. Therefore, the rate entered for prime contractor performed rate categories is as follows: rate = prime base labor rate + prime fringe + prime overhead. If the labor category is performed by a subcontractor, the rate entered in Col j is as follows: Rate = sub base rate +sub fringe + sub overhead + sub G&A + sub fee (i.e. subcontractor loaded rate EXCEPT for prime G&A and fee).
ODC - Cost Detail Worksheet:
NOTE 7: A contract not-to-exceed amount for travel/ODCs has been specified for proposal purposes. Each offeror is to include this amount in their proposal. Any material handling and/or G&A is to be applied as appropriate. Since this is an estimated amount that may or may not occur, no fixed fee will be proposed.
Direct Labor Rate Schedule: Supporting direct labor rate worksheet. Offeror should enter all of the corresponding labor categories proposed in the labor cost detail worksheets proposed on a cost basis. For cost realism purposes, prime should indicate their basis of the proposed rates and provide documentation to substantiate the rates.
Indirect Rate Summary Worksheet: Please provide the indirect rates by year, and proposed percentage of performance by labor hour for the prime offeror and each division or subcontractor proposed to perform effort on this solicitation. For proprietary reasons, subcontractors may submit the information in the requested format directly to the Contracting Officer. This information is necessary for evaluation purposes and MUST be supplied for the offeror, other divisions, and subcontractors for the offeror's proposal to be considered complete and adequate.
Sample Fringe Worksheet: This worksheet shows a generally accepted format for overhead pool/base/rate calculations. Overhead pool, base, and rate calculations are required as part of the offeror's cost/price proposal. The overhead rates may be calculated together or separately depending on the contactor/subcontractor's accounting system. Please provide a similar schedule for overhead for each FY for the offeror and each division or subcontractor. Describe as necessary in the cost/price narrative. Please indicate if the rates are based on a forward pricing rate agreement (FPRA) or other signed rate agreement with DCAA and/or DCMA. Subcontractor data may be submitted directly to the Contracting Officer for proprietary reasons.
Sample Overhead Worksheet: This worksheet shows a generally accepted format for fringe benefit pool/base/rate calculations. Fringe benefit pool, base, and rate calculations are required as part of the offeror's cost/price proposal. The fringe rates may be calculated together or separately depending on the contactor/subcontractor's accounting system. Please provide a similar schedule for fringe for each FY for the offeror and each division or subcontractor. Describe as necessary in the cost/price narrative. Please indicate if the rates are based on a forward pricing rate agreement (FPRA) or other signed rate agreement with DCAA and/or DCMA. Subcontractor data may be submitted directly to the Contracting Officer for proprietary reasons.
Sample G&A…
This is the start of the file's text. The full file is on GovTribe.