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-18-R-0004 | | | | | | |
| Prime Contractor/Subcontractor Name/Division: | | | | | | |
| Period of Performance: | | | | | | |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT | |
| 0001 | 45-day Transition In | 1 | Each | $ - 0 | | |
| FFP | | Cost = | | $ - 0 | From Cost Summary Worksheet |
| | | Profit = | | $ - 0 | From Cost Summary Worksheet |
| | | Total FFP = | | $ - 0 | |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT | |
| 0002 | Year 1 Labor | 1 | Each | $ - 0 | | |
| T&M | | Cost = | | $ 24,602.27 | From Cost Summary Worksheet |
| | | Profit = | | $ - 0 | From Cost Summary Worksheet |
| | | Total T&M = | | $ 24,602.27 | |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT | |
| 0003 | Year 1 Labor | 1 | Each | $ - 0 | | |
| FFP - Normalized | | Cost = | | | |
| | | Profit = | | | |
| | Total FFP - Normalized = | | | $ 810,000.00 | From Cost Summary Worksheet |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT | |
| 0004 | Year 1 ODCs | 1 | Each | $ - 0 | | |
| COST | | Cost = | | $ 400,000.00 | From Cost Summary Worksheet |
| | | G&A = | | $ - 0 | |
| | | | | $ 400,000.00 | |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT | |
| 0005 | Year 2 Labor | 1 | Each | $ - 0 | | |
| T&M | | Cost = | | $ 23,574.32 | From Cost Summary Worksheet |
| | | Profit = | | $ - 0 | From Cost Summary Worksheet |
| | | Total T&M = | | $ 23,574.32 | |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT | |
| 0006 | Year 2 Labor | 1 | Each | $ - 0 | | |
| FFP - Normalized | | Cost = | | | |
| | | Profit = | | | |
| | Total FFP - Normalized = | | | $ 780,000.00 | From Cost Summary Worksheet |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT | |
| 0007 | Year 2 ODCs | 1 | Each | $ - 0 | | |
| COST | | Cost = | | $ 404,000.00 | From Cost Summary Worksheet |
| | | G&A = | | $ - 0 | |
| | | | | $ 404,000.00 | |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT | |
| 0008 | Year 3 Labor | 1 | Each | $ - 0 | | |
| T&M | | Cost = | | $ 23,574.32 | From Cost Summary Worksheet |
| | | Profit = | | $ - 0 | From Cost Summary Worksheet |
| | | Total T&M = | | $ 23,574.32 | |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT | |
| 0009 | Year 3 Labor | 1 | Each | $ - 0 | | |
| FFP - Normalized | | Cost = | | | |
| | | Profit = | | | |
| | Total FFP - Normalized = | | | $ 780,000.00 | From Cost Summary Worksheet |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT | |
| 0010 | Year 3 ODCs | 1 | Each | $ - 0 | | |
| COST | | Cost = | | $ 408,040.00 | From Cost Summary Worksheet |
| | | G&A = | | $ - 0 | |
| | | | | $ 408,040.00 | |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT | |
| 0011 | 45-day Transition Out | 1 | Each | $ - 0 | | |
| FFP | | Cost = | | $ - 0 | From Cost Summary Worksheet |
| | | Profit = | | $ - 0 | From Cost Summary Worksheet |
| | | Total FFP = | | $ - 0 | |
| TOTAL | |
| Total Cost = | $ 1,283,790.91 |
| Profit = | $ - 0 |
| Total = | $ 1,283,790.91 |
| $ 3,653,790.91 |
&F, &A
PAGE &P OF &N
Cost Summary
| COST SUMMARY |
| Solicitation: W91CRB-18-R-0004 |
| Prime Contractor/Subcontractor Name/Division: |
| Period of Performance: |
| Transition In | Year 1 | Year 2 | Year 3 | Transition Out | Total |
| Labor Hours Regular T&M | | 326,890 | 313,240 | 313,240 | | 953,370 |
| Labor & Subcontract Labor T&M | | $ - 0 | $ - 0 | $ - 0 | | $ - 0 |
| Profit T&M | | $ - 0 | $ - 0 | $ - 0 | | $ - 0 |
| Subtotal Labor Regular T&M | | $ - 0 | $ - 0 | $ - 0 | | $ - 0 |
| Labor Hours Overtime T&M | 22,366 | 21,431 | 21,431 | 65,228 |
| Labor & Subcontract Labor T&M | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Profit T&M | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Subtotal Labor Overtime T&M | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Labor Hours Shift T&M | 15,976 | 15,308 | 15,308 | 46,592 |
| Labor & Subcontract Labor T&M | $ 17,573.05 | $ 16,838.80 | $ 16,838.80 | $ 51,250.65 |
| Profit T&M | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Subtotal Labor Shift T&M | $ 17,573.05 | $ 16,838.80 | $ 16,838.80 | $ 51,250.65 |
| Labor Hours Shift Overtime T&M | 6,390 | 6,123 | 6,123 | 18,637 |
| Labor & Subcontract Labor T&M | $ 7,029.22 | $ 6,735.52 | $ 6,735.52 | $ 20,500.26 |
| Profit T&M | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Subtotal Labor Shift Overtime T&M | $ 7,029.22 | $ 6,735.52 | $ 6,735.52 | $ 20,500.26 |
| Labor Hours Total T&M | 371,621 | 356,102 | 356,102 | 1,083,826 |
| Labor & Subcontract Labor Total T&M | $ 24,602.27 | $ 23,574.32 | $ 23,574.32 | $ 71,750.91 |
| Profit Total T&M | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Labor T&M | $ 24,602.27 | $ 23,574.32 | $ 23,574.32 | $ 71,750.91 |
| Labor Hours Regular FFP | | 17,950 | 17,200 | 17,200 | | 52,350 |
| Labor & Subcontract Labor FFP | $ - 0 | NORMALIZED | | | $ - 0 | $ - 0 |
| Profit FFP | $ - 0 | | | | $ - 0 | $ - 0 |
| Subtotal Labor Regular FFP | $ - 0 | | | | $ - 0 | $ - 0 |
| Labor Hours Overtime FFP | | 1,257 | 1,204 | 1,204 | | 3,665 |
| Labor & Subcontract Labor FFP | $ - 0 | NORMALIZED | | | $ - 0 | $ - 0 |
| Profit FFP | $ - 0 | | | | $ - 0 | $ - 0 |
| Subtotal Labor Overtime FFP | $ - 0 | | | | $ - 0 | $ - 0 |
| Labor Hours Shift FFP | | 898 | 860 | 860 | | 2,618 |
| Labor & Subcontract Labor FFP | $ - 0 | NORMALIZED | | | $ - 0 | $ - 0 |
| Profit FFP | $ - 0 | | | | $ - 0 | $ - 0 |
| Subtotal Labor Shift FFP | $ - 0 | | | | $ - 0 | $ - 0 |
| Labor Hours Shift Overtime FFP | | 359 | 344 | 344 | | 1,047 |
| Labor & Subcontract Labor FFP | $ - 0 | NORMALIZED | | | $ - 0 | $ - 0 |
| Profit FFP | $ - 0 | | | | $ - 0 | $ - 0 |
| Subtotal Labor Shift Overtime FFP | $ - 0 | | | | $ - 0 | $ - 0 |
| Labor Hours Total FFP | | 20,463 | 19,608 | 19,608 | | 59,679 | | 34% | 33% | 33% | |
| Labor & Subcontract Labor Total FFP | $ - 0 | | | | $ - 0 | $ - 0 | | $ 813,596.18 | $ 779,601.91 | $ 779,601.91 | |
| Profit Total FFP | $ - 0 | | | | $ - 0 | $ - 0 | | | | | |
| Total Labor FFP | $ - 0 | $ 810,000.00 | $ 780,000.00 | $ 780,000.00 | $ - 0 | $ 2,370,000.00 | 2,370,000.00 | 810,000.00 | 780,000.00 | 780,000.00 | 2,370,000.00 |
| | | | | | | $ 48,716,209.09 | | | | |
| Labor Hours Total | | 392,084 | 375,710 | 375,710 | | 1,143,505 | | | | | |
| Labor & Subcontract Labor Total | $ - 0 | $ 24,602.27 | $ 23,574.32 | $ 23,574.32 | $ - 0 | $ 71,750.91 | | | | | |
| Profit Total | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | | | | | |
| Total Labor | $ - 0 | $ 24,602.27 | $ 23,574.32 | $ 23,574.32 | $ - 0 | $ 71,750.91 | | | | | |
| Other Direct Costs | $ 400,000.00 | $ 404,000.00 | $ 408,040.00 | $ 1,212,040.00 |
| G&A | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total ODC | $ 400,000.00 | $ 404,000.00 | $ 408,040.00 | $ 1,212,040.00 |
TOTAL PRICE $ - 0 $ 1,234,602.27 $ 1,207,574.32 $ 1,211,614.32 $ - 0 $ 3,653,790.91
&F, &A
Page &P of &N
Regular Labor - Cost Detail
| REGULAR LABOR - COST DETAIL SPREADSHEET |
| Solicitation: W91CRB-18-R-0004 |
| Prime Contractor/Subcontractor Name/Division: |
| Period of Performance: |
| CLIN 0001 - Year 1: 45-day Transition In, Months 0 - 1.5 | | | | | | | | 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 |
| | | | 0.00 | Enter P or S | | | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
0.00 0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ERROR:#DIV/0!
| CLIN 0002 - Year 1: Months 1.5 - 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 |
| GOVERNMENT SITE POSITIONS: | | | | | | | | | | | | | | | | |
| Computer Operator I | T&M | 1.00 | 1,795.00 | 1,795.00 | Enter P or S | | | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Computer Operator II | T&M | 1.00 | 1,795.00 | 1,795.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Computer Operator III | T&M | 2.00 | 1,795.00 | 3,590.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Computer Operator IV | T&M | 0.03 | 1,795.00 | 50.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Computer Operator V (Computer Operator Leader) | T&M | 1.00 | 1,795.00 | 1,795.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Data collector I | T&M | 52.00 | 1,795.00 | 93,340.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Data collector I (part of CLIN 0003) | FFP | 6.00 | 1,795.00 | 10,770.00 | NORMALIZED | | | | | | | | | | | |
| Data collector II | T&M | 77.00 | 1,795.00 | 138,215.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Data collector III | T&M | 8.00 | 1,795.00 | 14,360.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Data collector IV | T&M | 2.00 | 1,795.00 | 3,590.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Data collector V | T&M | 12.00 | 1,795.00 | 21,540.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Data collector VI | T&M | 3.00 | 1,795.00 | 5,385.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Editorial Technician I - Conformed to WD Comp Op II | T&M | 0.03 | 1,795.00 | 50.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Editorial Technician II - Conformed to WD Comp Op III | T&M | 0.03 | 1,795.00 | 50.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Editorial Technician III - Conformed to WD Comp Op IV | T&M | 1.00 | 1,795.00 | 1,795.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Editorial Technician IV - Conformed to WD Comp Op V | T&M | 1.00 | 1,795.00 | 1,795.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Technical Writer I | T&M | 11.00 | 1,795.00 | 19,745.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Technical Writer I (part of CLIN 0003) | FFP | 4.00 | 1,795.00 | 7,180.00 | NORMALIZED | | | | | | | | | | | |
| Technical Writer II | T&M | 8.00 | 1,795.00 | 14,360.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Technical Writer III (Technical Writer Manager) | T&M | 1.00 | 1,795.00 | 1,795.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Range Support Technician I - Conformed WD Eng Tech III | T&M | 0.03 | 1,795.00 | 50.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Range Support Technician II - Conformed WD Eng Tech IV | T&M | 1.00 | 1,795.00 | 1,795.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
192.11 344,840.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00 Tackett, Bruce W CIV:
Non-Normalized Rate
| CLIN 0004 - 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 |
| GOVERNMENT SITE POSITIONS | | | | | | | | | | | | | | | | |
| Computer Operator I | T&M | 1.00 | 1,720.00 | 1,720.00 | Enter P or S | | | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Computer Operator II | T&M | 1.00 | 1,720.00 | 1,720.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Computer Operator III | T&M | 2.00 | 1,720.00 | 3,440.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Computer Operator IV | T&M | 0.03 | 1,720.00 | 50.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Computer Operator V (Computer Operator Leader) | T&M | 1.00 | 1,720.00 | 1,720.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Data collector I | T&M | 52.00 | 1,720.00 | 89,440.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Data collector I (part of CLIN 0006) | FFP | 6.00 | 1,720.00 | 10,320.00 | NORMALIZED | | | | | | | | | | | |
| Data collector II | T&M | 77.00 | 1,720.00 | 132,440.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Data collector III | T&M | 8.00 | 1,720.00 | 13,760.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Data collector IV | T&M | 2.00 | 1,720.00 | 3,440.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Data collector V | T&M | 12.00 | 1,720.00 | 20,640.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Data collector VI | T&M | 3.00 | 1,720.00 | 5,160.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Editorial Technician I - Conformed to WD Comp Op II | T&M | 0.03 | 1,720.00 | 50.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Editorial Technician II - Conformed to WD Comp Op III | T&M | 0.03 | 1,720.00 | 50.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Editorial Technician III - Conformed to WD Comp Op IV | T&M | 1.00 | 1,720.00 | 1,720.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Editorial Technician IV - Conformed to WD Comp Op V | T&M | 1.00 | 1,720.00 | 1,720.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Technical Writer I | T&M | 11.00 | 1,720.00 | 18,920.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Technical Writer I (part of CLIN 0006) | FFP | 4.00 | 1,720.00 | 6,880.00 | NORMALIZED | | | | | | | | | | | |
| Technical Writer II | T&M | 8.00 | 1,720.00 | 13,760.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Technical Writer III (Technical Writer Manager) | T&M | 1.00 | 1,720.00 | 1,720.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Range Support Technician I - Conformed WD Eng Tech III | T&M | 0.03 | 1,720.00 | 50.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Range Support Technician II - Conformed WD Eng Tech IV | T&M | 1.00 | 1,720.00 | 1,720.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
192.12 330,440.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00
| CLIN 0006 - 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 |
| GOVERNMENT SITE POSITIONS | | | | | | | | | | | | | | | | |
| Computer Operator I | T&M | 1.00 | 1,720.00 | 1,720.00 | Enter P or S | | | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Computer Operator II | T&M | 1.00 | 1,720.00 | 1,720.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Computer Operator III | T&M | 2.00 | 1,720.00 | 3,440.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Computer Operator IV | T&M | 0.03 | 1,720.00 | 50.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Computer Operator V (Computer Operator Leader) | T&M | 1.00 | 1,720.00 | 1,720.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Data collector I | T&M | 52.00 | 1,720.00 | 89,440.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Data collector I (part of CLIN 0009) | FFP | 6.00 | 1,720.00 | 10,320.00 | NORMALIZED | | | | | | | | | | | |
| Data collector II | T&M | 77.00 | 1,720.00 | 132,440.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Data collector III | T&M | 8.00 | 1,720.00 | 13,760.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Data collector IV | T&M | 2.00 | 1,720.00 | 3,440.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Data collector V | T&M | 12.00 | 1,720.00 | 20,640.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Data collector VI | T&M | 3.00 | 1,720.00 | 5,160.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Editorial Technician I - Conformed to WD Comp Op II | T&M | 0.03 | 1,720.00 | 50.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Editorial Technician II - Conformed to WD Comp Op III | T&M | 0.03 | 1,720.00 | 50.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Editorial Technician III - Conformed to WD Comp Op IV | T&M | 1.00 | 1,720.00 | 1,720.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Editorial Technician IV - Conformed to WD Comp Op V | T&M | 1.00 | 1,720.00 | 1,720.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Technical Writer I | T&M | 11.00 | 1,720.00 | 18,920.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Technical Writer I (part of CLIN 0009) | FFP | 4.00 | 1,720.00 | 6,880.00 | NORMALIZED | | | | | | | | | | | |
| Technical Writer II | T&M | 8.00 | 1,720.00 | 13,760.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Technical Writer III (Technical Writer Manager) | T&M | 1.00 | 1,720.00 | 1,720.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Range Support Technician I - Conformed WD Eng Tech III | T&M | 0.03 | 1,720.00 | 50.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Range Support Technician II - Conformed WD Eng Tech IV | T&M | 1.00 | 1,720.00 | 1,720.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
192.12 330,440.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00
| CLIN 0008 - Year 3: 45-day Transition Out, Months 34.5 - 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 |
| GOVERNMENT SITE POSITIONS | | | | | | | | | | | | | | | | |
| | | | 0.00 | Enter P or S | | | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
0.00 0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ERROR:#DIV/0!
Totals: 576.34 1,005,720.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
&F, &A
PAGE &P OF &N
Overtime Labor - Cost Detail
| REGULAR LABOR - COST DETAIL SPREADSHEET |
| Solicitation: W91CRB-18-R-0004 |
| Prime Contractor/Subcontractor Name/Division: |
| Period of Performance: |
| CLIN 0001 - Year 1: 45-day Transition In, Months 0 - 1.5 | | | | | | | | 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 |
| | | | 0.00 | Enter P or S | | | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
0.00 0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ERROR:#DIV/0!
| CLIN 0002 - Year 1: Months 1.5 - 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 |
| GOVERNMENT SITE POSITIONS: | | | | | | | | | | | | | | | | |
| Computer Operator I | T&M | | | 0.00 | Enter P or S | | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! |
| Computer Operator II | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Computer Operator III | T&M | | | 251.30 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Computer Operator IV | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Computer Operator V (Computer Operator Leader) | T&M | | | 125.65 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Data collector I | T&M | | | 6,533.80 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Data collector I (part of CLIN 0003) | FFP | | | 753.90 | NORMALIZED | | | | | | | | | | | |
| Data collector II | T&M | | | 9,675.05 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Data collector III | T&M | | | 1,005.20 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Data collector IV | T&M | | | 251.30 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Data collector V | T&M | | | 1,507.80 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Data collector VI | T&M | | | 376.95 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Editorial Technician I - Conformed to WD Comp Op II | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Editorial Technician II - Conformed to WD Comp Op III | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Editorial Technician III - Conformed to WD Comp Op IV | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Editorial Technician IV - Conformed to WD Comp Op V | T&M | | | 125.65 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Technical Writer I | T&M | | | 1,382.15 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Technical Writer I (part of CLIN 0003) | FFP | | | 502.60 | NORMALIZED | | | | | | | | | | | |
| Technical Writer II | T&M | | | 1,005.20 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Technical Writer III (Technical Writer Manager) | T&M | | | 125.65 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Range Support Technician I - Conformed WD Eng Tech III | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Range Support Technician II - Conformed WD Eng Tech IV | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
0.00 23,622.20 $0.00 $0.00 $0.00 $0.00 $0.00 0.00
| CLIN 0004 - 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 |
| GOVERNMENT SITE POSITIONS | | | | | | | | | | | | | | | | |
| Computer Operator I | T&M | | | 0.00 | Enter P or S | | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! |
| Computer Operator II | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Computer Operator III | T&M | | | 240.80 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Computer Operator IV | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Computer Operator V (Computer Operator Leader) | T&M | | | 120.40 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Data collector I | T&M | | | 6,260.80 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Data collector I (part of CLIN 0006) | FFP | | | 722.40 | NORMALIZED | | | | | | | | | | | |
| Data collector II | T&M | | | 9,270.80 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Data collector III | T&M | | | 963.20 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Data collector IV | T&M | | | 240.80 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Data collector V | T&M | | | 1,444.80 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Data collector VI | T&M | | | 361.20 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Editorial Technician I - Conformed to WD Comp Op II | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Editorial Technician II - Conformed to WD Comp Op III | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Editorial Technician III - Conformed to WD Comp Op IV | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Editorial Technician IV - Conformed to WD Comp Op V | T&M | | | 120.40 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Technical Writer I | T&M | | | 1,324.40 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Technical Writer I (part of CLIN 0006) | FFP | | | 481.60 | NORMALIZED | | | | | | | | | | | |
| Technical Writer II | T&M | | | 963.20 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Technical Writer III (Technical Writer Manager) | T&M | | | 120.40 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Range Support Technician I - Conformed WD Eng Tech III | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Range Support Technician II - Conformed WD Eng Tech IV | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
0.00 22,635.20 $0.00 $0.00 $0.00 $0.00 $0.00 0.00
| CLIN 0006 - 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 |
| GOVERNMENT SITE POSITIONS | | | | | | | | | | | | | | | | |
| Computer Operator I | T&M | | | 0.00 | Enter P or S | | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! |
| Computer Operator II | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Computer Operator III | T&M | | | 240.80 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Computer Operator IV | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Computer Operator V (Computer Operator Leader) | T&M | | | 120.40 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Data collector I | T&M | | | 6,260.80 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Data collector I (part of CLIN 0009) | FFP | | | 722.40 | NORMALIZED | | | | | | | | | | | |
| Data collector II | T&M | | | 9,270.80 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Data collector III | T&M | | | 963.20 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Data collector IV | T&M | | | 240.80 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Data collector V | T&M | | | 1,444.80 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Data collector VI | T&M | | | 361.20 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Editorial Technician I - Conformed to WD Comp Op II | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Editorial Technician II - Conformed to WD Comp Op III | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Editorial Technician III - Conformed to WD Comp Op IV | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Editorial Technician IV - Conformed to WD Comp Op V | T&M | | | 120.40 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Technical Writer I | T&M | | | 1,324.40 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Technical Writer I (part of CLIN 0009) | FFP | | | 481.60 | NORMALIZED | | | | | | | | | | | |
| Technical Writer II | T&M | | | 963.20 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Technical Writer III (Technical Writer Manager) | T&M | | | 120.40 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Range Support Technician I - Conformed WD Eng Tech III | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Range Support Technician II - Conformed WD Eng Tech IV | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
0.00 22,635.20 $0.00 $0.00 $0.00 $0.00 $0.00 0.00
| CLIN 0008 - Year 3: 45-day Transition Out, Months 34.5 - 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 |
| GOVERNMENT SITE POSITIONS | | | | | | | | | | | | | | | | |
| | | | 0.00 | Enter P or S | | | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
0.00 0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ERROR:#DIV/0!
Totals: 0.00 68,892.60 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
&F, &A
PAGE &P OF &N
Shift Labor - Cost Detail
| REGULAR LABOR - COST DETAIL SPREADSHEET |
| Solicitation: W91CRB-18-R-0004 |
| Prime Contractor/Subcontractor Name/Division: |
| Period of Performance: |
| CLIN 0001 - Year 1: 45-day Transition In, Months 0 - 1.5 | | | | | | | | 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 |
| | | | 0.00 | Enter P or S | | | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
0.00 0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ERROR:#DIV/0!
| CLIN 0002 - Year 1: Months 1.5 - 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 |
| GOVERNMENT SITE POSITIONS: | | | | | | | | | | | | | | | | |
| Computer Operator I | T&M | | | 0.00 | Enter P or S | | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! |
| Computer Operator II | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Computer Operator III | T&M | | | 179.50 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 197.45 | 0.00 | 197.45 | 0.00 | 197.45 | 1.10 |
| Computer Operator IV | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Computer Operator V (Computer Operator Leader) | T&M | | | 89.75 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 98.73 | 0.00 | 98.73 | 0.00 | 98.73 | 1.10 |
| Data collector I | T&M | | | 4,667.00 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 5133.70 | 0.00 | 5133.70 | 0.00 | 5133.70 | 1.10 |
| Data collector I (part of CLIN 0003) | FFP | | | 538.50 | NORMALIZED | | | | | | | | | | | |
| Data collector II | T&M | | | 6,910.75 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 7601.83 | 0.00 | 7601.83 | 0.00 | 7601.83 | 1.10 |
| Data collector III | T&M | | | 718.00 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 789.80 | 0.00 | 789.80 | 0.00 | 789.80 | 1.10 |
| Data collector IV | T&M | | | 179.50 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 197.45 | 0.00 | 197.45 | 0.00 | 197.45 | 1.10 |
| Data collector V | T&M | | | 1,077.00 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 1184.70 | 0.00 | 1184.70 | 0.00 | 1184.70 | 1.10 |
| Data collector VI | T&M | | | 269.25 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 296.18 | 0.00 | 296.18 | 0.00 | 296.18 | 1.10 |
| Editorial Technician I - Conformed to WD Comp Op II | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Editorial Technician II - Conformed to WD Comp Op III | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Editorial Technician III - Conformed to WD Comp Op IV | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Editorial Technician IV - Conformed to WD Comp Op V | T&M | | | 89.75 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 98.73 | 0.00 | 98.73 | 0.00 | 98.73 | 1.10 |
| Technical Writer I | T&M | | | 987.25 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 1085.98 | 0.00 | 1085.98 | 0.00 | 1085.98 | 1.10 |
| Technical Writer I (part of CLIN 0003) | FFP | | | 359.00 | NORMALIZED | | | | | | | | | | | |
| Technical Writer II | T&M | | | 718.00 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 789.80 | 0.00 | 789.80 | 0.00 | 789.80 | 1.10 |
| Technical Writer III (Technical Writer Manager) | T&M | | | 89.75 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 98.73 | 0.00 | 98.73 | 0.00 | 98.73 | 1.10 |
| Range Support Technician I - Conformed WD Eng Tech III | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Range Support Technician II - Conformed WD Eng Tech IV | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
0.00 16,873.00 $17,573.05 $0.00 $17,573.05 $0.00 $17,573.05 1.10
| CLIN 0004 - 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 |
| GOVERNMENT SITE POSITIONS | | | | | | | | | | | | | | | | |
| Computer Operator I | T&M | | | 0.00 | Enter P or S | | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! |
| Computer Operator II | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Computer Operator III | T&M | | | 172.00 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 189.20 | 0.00 | 189.20 | 0.00 | 189.20 | 1.10 |
| Computer Operator IV | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Computer Operator V (Computer Operator Leader) | T&M | | | 86.00 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 94.60 | 0.00 | 94.60 | 0.00 | 94.60 | 1.10 |
| Data collector I | T&M | | | 4,472.00 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 4,919.20 | 0.00 | 4,919.20 | 0.00 | 4,919.20 | 1.10 |
| Data collector I (part of CLIN 0006) | FFP | | | 516.00 | NORMALIZED | | | | | | | | | | | |
| Data collector II | T&M | | | 6,622.00 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 7,284.20 | 0.00 | 7,284.20 | 0.00 | 7,284.20 | 1.10 |
| Data collector III | T&M | | | 688.00 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 756.80 | 0.00 | 756.80 | 0.00 | 756.80 | 1.10 |
| Data collector IV | T&M | | | 172.00 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 189.20 | 0.00 | 189.20 | 0.00 | 189.20 | 1.10 |
| Data collector V | T&M | | | 1,032.00 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 1,135.20 | 0.00 | 1,135.20 | 0.00 | 1,135.20 | 1.10 |
| Data collector VI | T&M | | | 258.00 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 283.80 | 0.00 | 283.80 | 0.00 | 283.80 | 1.10 |
| Editorial Technician I - Conformed to WD Comp Op II | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Editorial Technician II - Conformed to WD Comp Op III | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Editorial Technician III - Conformed to WD Comp Op IV | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Editorial Technician IV - Conformed to WD Comp Op V | T&M | | | 86.00 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 94.60 | 0.00 | 94.60 | 0.00 | 94.60 | 1.10 |
| Technical Writer I | T&M | | | 946.00 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 1,040.60 | 0.00 | 1,040.60 | 0.00 | 1,040.60 | 1.10 |
| Technical Writer I (part of CLIN 0006) | FFP | | | 344.00 | NORMALIZED | | | | | | | | | | | |
| Technical Writer II | T&M | | | 688.00 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 756.80 | 0.00 | 756.80 | 0.00 | 756.80 | 1.10 |
| Technical Writer III (Technical Writer Manager) | T&M | | | 86.00 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 94.60 | 0.00 | 94.60 | 0.00 | 94.60 | 1.10 |
| Range Support Technician I - Conformed WD Eng Tech III | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Range Support Technician II - Conformed WD Eng Tech IV | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
0.00 16,168.00 $16,838.80 $0.00 $16,838.80 $0.00 $16,838.80 1.10
| CLIN 0006 - 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 |
| GOVERNMENT SITE POSITIONS | | | | | | | | | | | | | | | | |
| Computer Operator I | T&M | | | 0.00 | Enter P or S | | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! |
| Computer Operator II | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Computer Operator III | T&M | | | 172.00 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 189.20 | 0.00 | 189.20 | 0.00 | 189.20 | 1.10 |
| Computer Operator IV | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Computer Operator V (Computer Operator Leader) | T&M | | | 86.00 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 94.60 | 0.00 | 94.60 | 0.00 | 94.60 | 1.10 |
| Data collector I | T&M | | | 4,472.00 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 4,919.20 | 0.00 | 4,919.20 | 0.00 | 4,919.20 | 1.10 |
| Data collector I (part of CLIN 0009) | FFP | | | 516.00 | NORMALIZED | | | | | | | | | | | |
| Data collector II | T&M | | | 6,622.00 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 7,284.20 | 0.00 | 7,284.20 | 0.00 | 7,284.20 | 1.10 |
| Data collector III | T&M | | | 688.00 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 756.80 | 0.00 | 756.80 | 0.00 | 756.80 | 1.10 |
| Data collector IV | T&M | | | 172.00 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 189.20 | 0.00 | 189.20 | 0.00 | 189.20 | 1.10 |
| Data collector V | T&M | | | 1,032.00 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 1,135.20 | 0.00 | 1,135.20 | 0.00 | 1,135.20 | 1.10 |
| Data collector VI | T&M | | | 258.00 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 283.80 | 0.00 | 283.80 | 0.00 | 283.80 | 1.10 |
| Editorial Technician I - Conformed to WD Comp Op II | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Editorial Technician II - Conformed to WD Comp Op III | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Editorial Technician III - Conformed to WD Comp Op IV | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Editorial Technician IV - Conformed to WD Comp Op V | T&M | | | 86.00 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 94.60 | 0.00 | 94.60 | 0.00 | 94.60 | 1.10 |
| Technical Writer I | T&M | | | 946.00 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 1,040.60 | 0.00 | 1,040.60 | 0.00 | 1,040.60 | 1.10 |
| Technical Writer I (part of CLIN 0009) | FFP | | | 344.00 | NORMALIZED | | | | | | | | | | | |
| Technical Writer II | T&M | | | 688.00 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 756.80 | 0.00 | 756.80 | 0.00 | 756.80 | 1.10 |
| Technical Writer III (Technical Writer Manager) | T&M | | | 86.00 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 94.60 | 0.00 | 94.60 | 0.00 | 94.60 | 1.10 |
| Range Support Technician I - Conformed WD Eng Tech III | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Range Support Technician II - Conformed WD Eng Tech IV | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
0.00 16,168.00 $16,838.80 $0.00 $16,838.80 $0.00 $16,838.80 1.10
| CLIN 0008 - Year 3: 45-day Transition Out, Months 34.5 - 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 |
| GOVERNMENT SITE POSITIONS | | | | | | | | | | | | | | | | |
| | | | 0.00 | Enter P or S | | | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
0.00 0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ERROR:#DIV/0!
Totals: 0.00 49,209.00 $51,250.65 $0.00 $51,250.65 $0.00 $51,250.65 $1.10
&F, &A
PAGE &P OF &N
Shift OT Labor - Cost Detail
| REGULAR LABOR - COST DETAIL SPREADSHEET |
| Solicitation: W91CRB-18-R-0004 |
| Prime Contractor/Subcontractor Name/Division: |
| Period of Performance: |
| CLIN 0001 - Year 1: 45-day Transition In, Months 0 - 1.5 | | | | | | | | 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 |
| | | | 0.00 | Enter P or S | | | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| | | | 0.00 | Enter P or S | | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
0.00 0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ERROR:#DIV/0!
| CLIN 0002 - Year 1: Months 1.5 - 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 |
| GOVERNMENT SITE POSITIONS: | | | | | | | | | | | | | | | | |
| Computer Operator I | T&M | | | 0.00 | Enter P or S | | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! |
| Computer Operator II | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Computer Operator III | T&M | | | 71.80 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 78.98 | 0.00 | 78.98 | 0.00 | 78.98 | 1.10 |
| Computer Operator IV | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Computer Operator V (Computer Operator Leader) | T&M | | | 35.90 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 39.49 | 0.00 | 39.49 | 0.00 | 39.49 | 1.10 |
| Data collector I | T&M | | | 1,866.80 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 2053.48 | 0.00 | 2053.48 | 0.00 | 2053.48 | 1.10 |
| Data collector I (part of CLIN 0003) | FFP | | | 215.40 | NORMALIZED | | | | | | | | | | | |
| Data collector II | T&M | | | 2,764.30 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 3040.73 | 0.00 | 3040.73 | 0.00 | 3040.73 | 1.10 |
| Data collector III | T&M | | | 287.20 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 315.92 | 0.00 | 315.92 | 0.00 | 315.92 | 1.10 |
| Data collector IV | T&M | | | 71.80 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 78.98 | 0.00 | 78.98 | 0.00 | 78.98 | 1.10 |
| Data collector V | T&M | | | 430.80 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 473.88 | 0.00 | 473.88 | 0.00 | 473.88 | 1.10 |
| Data collector VI | T&M | | | 107.70 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 118.47 | 0.00 | 118.47 | 0.00 | 118.47 | 1.10 |
| Editorial Technician I - Conformed to WD Comp Op II | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Editorial Technician II - Conformed to WD Comp Op III | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Editorial Technician III - Conformed to WD Comp Op IV | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Editorial Technician IV - Conformed to WD Comp Op V | T&M | | | 35.90 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 39.49 | 0.00 | 39.49 | 0.00 | 39.49 | 1.10 |
| Technical Writer I | T&M | | | 394.90 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 434.39 | 0.00 | 434.39 | 0.00 | 434.39 | 1.10 |
| Technical Writer I (part of CLIN 0003) | FFP | | | 143.60 | NORMALIZED | | | | | | | | | | | |
| Technical Writer II | T&M | | | 287.20 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 315.92 | 0.00 | 315.92 | 0.00 | 315.92 | 1.10 |
| Technical Writer III (Technical Writer Manager) | T&M | | | 35.90 | Enter P or S | | 1.10 | 0.00 | 0.00 | 1.10 | 39.49 | 0.00 | 39.49 | 0.00 | 39.49 | 1.10 |
| Range Support Technician I - Conformed WD Eng Tech III | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
| Range Support Technician II - Conformed WD Eng Tech IV | T&M | | | 0.00 | Enter P or S | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ERROR:#DIV/0! |
0.00 6,749.20 $7,029.22 $0.00 $7,029.22 $0.00 $7,029.22 1.10
| CLIN 0004 - Year 2: Months 13 - 24 | | | | | | | | 0.00% | 0.00% | | | 0.00% | | 0.00% | | |
This is the start of the file's text. The full file is on GovTribe.