A07_ATTACH_5_LOE-Data_Collection_Cost_Model.XLSX

XLSX spreadsheet 171 KB Posted

Attached to
Data Collection Support Services
Solicitation number
W91CRB-18-R-0004
Issued by

About this file

Attachment 5 Cost Model

View the file

Other files

File Type Posted
A07_ATTACH_5_LOE-Data_Collection_Cost_Model_AMD_04.xlsx XLSX spreadsheet
A01_W91CRB-18-R-0004_AMD_04.pdf PDF
B01_W91CRB-18-R-0004_AMD_3.pdf PDF
A07_ATTACH_4_DATA_COLLECTION_SSEP_FORMS_AMD_3.docx DOCX document
B01_W91CRB-18-R-0004_AMD_2.pdf PDF
A07_ATTACH_8_Past_Performance_Questionaire_AMD_2.docx DOCX document
A07_ATTACH_4_DATA_COLLECTION_SSEP_FORMS.docx DOCX document
A07_ATTACH_5_LOE-Data_Collection_Cost_Model_AMD_02.XLSX XLSX spreadsheet
B01_W91CRB-18-R-0004_AMD_01.pdf PDF
A07_ATTACH_8_Past_Performance_Questionaire_AMD_01.docx DOCX document
A01_CDRL006-_Unfilled_Requirements_and_Staffing_Report-_AMD_1.pdf PDF
A07_-_ATTACH_4-TAB_5,_Appendix_H,_Encl_1-_OCI_Certification_AMD_01.docx DOCX document
A07_ATTACH_4_Data_Collection_SSEP_Forms_AMD_01.xlsx XLSX spreadsheet
A07_ATTACH_5_LOE-Data_Collection_Cost_Model_AMD_01.XLSX XLSX spreadsheet
A01_CDRL007-_Cost_Report_AMD_01.pdf PDF
A01_W91CRB-18-R-0004.pdf PDF
A07_ATTACH_6_Wage_Determination_15-4265_(Rev_4).pdf PDF
A07_ATTACH_3_DD_Form_254_for_Data_Collection_Solicitation.pdf PDF
A02_ATTACH_1_Job_Quals.pdf PDF
A07_ATTACH_3_DD254_DATTACHMENT_ONE_THROUGH_FOUR_for_Data_Collection_Solicitation.doc DOC document
A01_CDRL001-_Training.pdf PDF
A01_W91CRB-18-R-0004.pdf PDF
A07_ATTACH_4_Data_Collection_SSEP_Forms.xlsx XLSX spreadsheet
A01_CDRL006-_Unfilled_Requirements_and_Staffing_Report.pdf PDF
A01_CDRL003-_Safety_Plan.pdf PDF
A01_CDRL002-_Property.pdf PDF
A02_ATTACH_2_-_ATC_MandatoryTraining_Matrix.xlsx XLSX spreadsheet
A01_CDRL004-_Quality_Management_Plan.pdf PDF
A07_ATTACH_7_CBA.pdf PDF
A01_CDRL005-_Monthly_Strength_Report.pdf PDF
Show all 30

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Section B Labor & ODC Proposed Labor & ODC

DIRECT LABOR**# of PersonnelEst. Productive Hours Per (Billed Hours)Loaded Rated per Hour *Estimated Cost
System Administration1ERROR:#REF!ERROR:#REF!ERROR:#REF!
Database Management Support1ERROR:#REF!ERROR:#REF!ERROR:#REF!
Web Support2ERROR:#REF!ERROR:#REF!ERROR:#REF!
Applications Programming Support2ERROR:#REF!ERROR:#REF!ERROR:#REF!
Information Assurance Support2ERROR:#REF!ERROR:#REF!ERROR:#REF!
Comsec Support1ERROR:#REF!ERROR:#REF!ERROR:#REF!
Logistics Support1ERROR:#REF!ERROR:#REF!ERROR:#REF!
VTC Support5
Optional Categories
Training Support1ERROR:#REF!
IT Customer Support3ERROR:#REF!
Configuration Management Support2ERROR:#REF!ERROR:#REF!ERROR:#REF!
Systems Analyst Support10ERROR:#REF!ERROR:#REF!ERROR:#REF!
Telephone Support1ERROR:#REF!ERROR:#REF!ERROR:#REF!
ERROR:#REF!ERROR:#REF!
Total LaborERROR:#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 1Labor Categories and
Level of EffortW91CRB-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:
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
000145-day Transition In1Each$ - 0
FFPCost =$ - 0From Cost Summary Worksheet
Profit =$ - 0From Cost Summary Worksheet
Total FFP =$ - 0
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0002Year 1 Labor1Each$ - 0
T&MCost =$ 24,602.27From Cost Summary Worksheet
Profit =$ - 0From Cost Summary Worksheet
Total T&M =$ 24,602.27
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0003Year 1 Labor1Each$ - 0
FFP - NormalizedCost =
Profit =
Total FFP - Normalized =$ 810,000.00From Cost Summary Worksheet
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0004Year 1 ODCs1Each$ - 0
COSTCost =$ 400,000.00From Cost Summary Worksheet
G&A =$ - 0
$ 400,000.00
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0005Year 2 Labor1Each$ - 0
T&MCost =$ 23,574.32From Cost Summary Worksheet
Profit =$ - 0From Cost Summary Worksheet
Total T&M =$ 23,574.32
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0006Year 2 Labor1Each$ - 0
FFP - NormalizedCost =
Profit =
Total FFP - Normalized =$ 780,000.00From Cost Summary Worksheet
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0007Year 2 ODCs1Each$ - 0
COSTCost =$ 404,000.00From Cost Summary Worksheet
G&A =$ - 0
$ 404,000.00
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0008Year 3 Labor1Each$ - 0
T&MCost =$ 23,574.32From Cost Summary Worksheet
Profit =$ - 0From Cost Summary Worksheet
Total T&M =$ 23,574.32
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0009Year 3 Labor1Each$ - 0
FFP - NormalizedCost =
Profit =
Total FFP - Normalized =$ 780,000.00From Cost Summary Worksheet
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0010Year 3 ODCs1Each$ - 0
COSTCost =$ 408,040.00From Cost Summary Worksheet
G&A =$ - 0
$ 408,040.00
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
001145-day Transition Out1Each$ - 0
FFPCost =$ - 0From Cost Summary Worksheet
Profit =$ - 0From 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 InYear 1Year 2Year 3Transition OutTotal
Labor Hours Regular T&M326,890313,240313,240953,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&M22,36621,43121,43165,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&M15,97615,30815,30846,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&M6,3906,1236,12318,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&M371,621356,102356,1021,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 FFP17,95017,20017,20052,350
Labor & Subcontract Labor FFP$ - 0NORMALIZED$ - 0$ - 0
Profit FFP$ - 0$ - 0$ - 0
Subtotal Labor Regular FFP$ - 0$ - 0$ - 0
Labor Hours Overtime FFP1,2571,2041,2043,665
Labor & Subcontract Labor FFP$ - 0NORMALIZED$ - 0$ - 0
Profit FFP$ - 0$ - 0$ - 0
Subtotal Labor Overtime FFP$ - 0$ - 0$ - 0
Labor Hours Shift FFP8988608602,618
Labor & Subcontract Labor FFP$ - 0NORMALIZED$ - 0$ - 0
Profit FFP$ - 0$ - 0$ - 0
Subtotal Labor Shift FFP$ - 0$ - 0$ - 0
Labor Hours Shift Overtime FFP3593443441,047
Labor & Subcontract Labor FFP$ - 0NORMALIZED$ - 0$ - 0
Profit FFP$ - 0$ - 0$ - 0
Subtotal Labor Shift Overtime FFP$ - 0$ - 0$ - 0
Labor Hours Total FFP20,46319,60819,60859,67934%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.002,370,000.00810,000.00780,000.00780,000.002,370,000.00
$ 48,716,209.09
Labor Hours Total392,084375,710375,7101,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

5.22%
64.86%

&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.50.00%0.00%0.00%0.00%
Labor Categories (Note 1)CLIN TypeFTEs (Note 2)Estimated Productive Hrs Per FTETotal HoursEffort 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 & FeeG&A TotalSubtotalProfit TotalTotalTotal Burdened Rate Including Fee
abcde = c x dfghi = h x fringejkl = e x kmn = l + mop = n + oq = p/e
0.00Enter P or S$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#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 - 120.00%0.00%0.00%0.00%
Labor Categories (Note 1)CLIN TypeFTEs (Note 2)Estimated Productive Hrs Per FTETotal HoursEffort 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 & FeeG&A TotalSubtotalProfit TotalTotalTotal Burdened Rate Including Fee
abcde = c x dfghi = h x fringejkl = e x kmn = l + mop = n + oq = p/e
GOVERNMENT SITE POSITIONS:
Computer Operator IT&M1.001,795.001,795.00Enter P or S$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Computer Operator IIT&M1.001,795.001,795.00Enter P or S0.000.000.000.000.000.000.000.000.00
Computer Operator IIIT&M2.001,795.003,590.00Enter P or S0.000.000.000.000.000.000.000.000.00
Computer Operator IVT&M0.031,795.0050.00Enter P or S0.000.000.000.000.000.000.000.000.00
Computer Operator V (Computer Operator Leader)T&M1.001,795.001,795.00Enter P or S0.000.000.000.000.000.000.000.000.00
Data collector IT&M52.001,795.0093,340.00Enter P or S0.000.000.000.000.000.000.000.000.00
Data collector I (part of CLIN 0003)FFP6.001,795.0010,770.00NORMALIZED
Data collector IIT&M77.001,795.00138,215.00Enter P or S0.000.000.000.000.000.000.000.000.00
Data collector IIIT&M8.001,795.0014,360.00Enter P or S0.000.000.000.000.000.000.000.000.00
Data collector IVT&M2.001,795.003,590.00Enter P or S0.000.000.000.000.000.000.000.000.00
Data collector VT&M12.001,795.0021,540.00Enter P or S0.000.000.000.000.000.000.000.000.00
Data collector VIT&M3.001,795.005,385.00Enter P or S0.000.000.000.000.000.000.000.000.00
Editorial Technician I - Conformed to WD Comp Op IIT&M0.031,795.0050.00Enter P or S0.000.000.000.000.000.000.000.000.00
Editorial Technician II - Conformed to WD Comp Op IIIT&M0.031,795.0050.00Enter P or S0.000.000.000.000.000.000.000.000.00
Editorial Technician III - Conformed to WD Comp Op IVT&M1.001,795.001,795.00Enter P or S0.000.000.000.000.000.000.000.000.00
Editorial Technician IV - Conformed to WD Comp Op VT&M1.001,795.001,795.00Enter P or S0.000.000.000.000.000.000.000.000.00
Technical Writer IT&M11.001,795.0019,745.00Enter P or S0.000.000.000.000.000.000.000.000.00
Technical Writer I (part of CLIN 0003)FFP4.001,795.007,180.00NORMALIZED
Technical Writer IIT&M8.001,795.0014,360.00Enter P or S0.000.000.000.000.000.000.000.000.00
Technical Writer III (Technical Writer Manager)T&M1.001,795.001,795.00Enter P or S0.000.000.000.000.000.000.000.000.00
Range Support Technician I - Conformed WD Eng Tech IIIT&M0.031,795.0050.00Enter P or S0.000.000.000.000.000.000.000.000.00
Range Support Technician II - Conformed WD Eng Tech IVT&M1.001,795.001,795.00Enter P or S0.000.000.000.000.000.000.000.000.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 - 240.00%0.00%0.00%0.00%
Labor Categories (Note 1)CLIN TypeFTEs (Note 2)Estimated Productive Hrs Per FTETotal HoursEffort 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 & FeeG&A TotalSubtotalProfit TotalTotalTotal Burdened Rate Including Fee
abcde = c x dfghi = h x fringejkl = e x kmn = l + mop = n + oq = p/e
GOVERNMENT SITE POSITIONS
Computer Operator IT&M1.001,720.001,720.00Enter P or S$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Computer Operator IIT&M1.001,720.001,720.00Enter P or S0.000.000.000.000.000.000.000.000.00
Computer Operator IIIT&M2.001,720.003,440.00Enter P or S0.000.000.000.000.000.000.000.000.00
Computer Operator IVT&M0.031,720.0050.00Enter P or S0.000.000.000.000.000.000.000.000.00
Computer Operator V (Computer Operator Leader)T&M1.001,720.001,720.00Enter P or S0.000.000.000.000.000.000.000.000.00
Data collector IT&M52.001,720.0089,440.00Enter P or S0.000.000.000.000.000.000.000.000.00
Data collector I (part of CLIN 0006)FFP6.001,720.0010,320.00NORMALIZED
Data collector IIT&M77.001,720.00132,440.00Enter P or S0.000.000.000.000.000.000.000.000.00
Data collector IIIT&M8.001,720.0013,760.00Enter P or S0.000.000.000.000.000.000.000.000.00
Data collector IVT&M2.001,720.003,440.00Enter P or S0.000.000.000.000.000.000.000.000.00
Data collector VT&M12.001,720.0020,640.00Enter P or S0.000.000.000.000.000.000.000.000.00
Data collector VIT&M3.001,720.005,160.00Enter P or S0.000.000.000.000.000.000.000.000.00
Editorial Technician I - Conformed to WD Comp Op IIT&M0.031,720.0050.00Enter P or S0.000.000.000.000.000.000.000.000.00
Editorial Technician II - Conformed to WD Comp Op IIIT&M0.031,720.0050.00Enter P or S0.000.000.000.000.000.000.000.000.00
Editorial Technician III - Conformed to WD Comp Op IVT&M1.001,720.001,720.00Enter P or S0.000.000.000.000.000.000.000.000.00
Editorial Technician IV - Conformed to WD Comp Op VT&M1.001,720.001,720.00Enter P or S0.000.000.000.000.000.000.000.000.00
Technical Writer IT&M11.001,720.0018,920.00Enter P or S0.000.000.000.000.000.000.000.000.00
Technical Writer I (part of CLIN 0006)FFP4.001,720.006,880.00NORMALIZED
Technical Writer IIT&M8.001,720.0013,760.00Enter P or S0.000.000.000.000.000.000.000.000.00
Technical Writer III (Technical Writer Manager)T&M1.001,720.001,720.00Enter P or S0.000.000.000.000.000.000.000.000.00
Range Support Technician I - Conformed WD Eng Tech IIIT&M0.031,720.0050.00Enter P or S0.000.000.000.000.000.000.000.000.00
Range Support Technician II - Conformed WD Eng Tech IVT&M1.001,720.001,720.00Enter P or S0.000.000.000.000.000.000.000.000.00

192.12 330,440.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00

CLIN 0006 - Year 3: Months 25 - 360.00%0.00%0.00%0.00%
Labor Categories (Note 1)CLIN TypeFTEs (Note 2)Estimated Productive Hrs Per FTETotal HoursEffort 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 & FeeG&A TotalSubtotalProfit TotalTotalTotal Burdened Rate Including Fee
abcde = c x dfghi = h x fringejkl = e x kmn = l + mop = n + oq = p/e
GOVERNMENT SITE POSITIONS
Computer Operator IT&M1.001,720.001,720.00Enter P or S$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Computer Operator IIT&M1.001,720.001,720.00Enter P or S0.000.000.000.000.000.000.000.000.00
Computer Operator IIIT&M2.001,720.003,440.00Enter P or S0.000.000.000.000.000.000.000.000.00
Computer Operator IVT&M0.031,720.0050.00Enter P or S0.000.000.000.000.000.000.000.000.00
Computer Operator V (Computer Operator Leader)T&M1.001,720.001,720.00Enter P or S0.000.000.000.000.000.000.000.000.00
Data collector IT&M52.001,720.0089,440.00Enter P or S0.000.000.000.000.000.000.000.000.00
Data collector I (part of CLIN 0009)FFP6.001,720.0010,320.00NORMALIZED
Data collector IIT&M77.001,720.00132,440.00Enter P or S0.000.000.000.000.000.000.000.000.00
Data collector IIIT&M8.001,720.0013,760.00Enter P or S0.000.000.000.000.000.000.000.000.00
Data collector IVT&M2.001,720.003,440.00Enter P or S0.000.000.000.000.000.000.000.000.00
Data collector VT&M12.001,720.0020,640.00Enter P or S0.000.000.000.000.000.000.000.000.00
Data collector VIT&M3.001,720.005,160.00Enter P or S0.000.000.000.000.000.000.000.000.00
Editorial Technician I - Conformed to WD Comp Op IIT&M0.031,720.0050.00Enter P or S0.000.000.000.000.000.000.000.000.00
Editorial Technician II - Conformed to WD Comp Op IIIT&M0.031,720.0050.00Enter P or S0.000.000.000.000.000.000.000.000.00
Editorial Technician III - Conformed to WD Comp Op IVT&M1.001,720.001,720.00Enter P or S0.000.000.000.000.000.000.000.000.00
Editorial Technician IV - Conformed to WD Comp Op VT&M1.001,720.001,720.00Enter P or S0.000.000.000.000.000.000.000.000.00
Technical Writer IT&M11.001,720.0018,920.00Enter P or S0.000.000.000.000.000.000.000.000.00
Technical Writer I (part of CLIN 0009)FFP4.001,720.006,880.00NORMALIZED
Technical Writer IIT&M8.001,720.0013,760.00Enter P or S0.000.000.000.000.000.000.000.000.00
Technical Writer III (Technical Writer Manager)T&M1.001,720.001,720.00Enter P or S0.000.000.000.000.000.000.000.000.00
Range Support Technician I - Conformed WD Eng Tech IIIT&M0.031,720.0050.00Enter P or S0.000.000.000.000.000.000.000.000.00
Range Support Technician II - Conformed WD Eng Tech IVT&M1.001,720.001,720.00Enter P or S0.000.000.000.000.000.000.000.000.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 - 360.00%0.00%0.00%0.00%
Labor Categories (Note 1)CLIN TypeFTEs (Note 2)Estimated Productive Hrs Per FTETotal HoursEffort 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 & FeeG&A TotalSubtotalProfit TotalTotalTotal Burdened Rate Including Fee
abcde = c x dfghi = h x fringejkl = e x kmn = l + mop = n + oq = p/e
GOVERNMENT SITE POSITIONS
0.00Enter P or S$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#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.50.00%0.00%0.00%0.00%
Labor Categories (Note 1)CLIN TypeFTEs (Note 2)Estimated Productive Hrs Per FTETotal HoursEffort 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 & FeeG&A TotalSubtotalProfit TotalTotalTotal Burdened Rate Including Fee
abcde = c x dfghi = h x fringejkl = e x kmn = l + mop = n + oq = p/e
0.00Enter P or S$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#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 - 120.00%0.00%0.00%0.00%
Labor Categories (Note 1)CLIN TypeFTEs (Note 2)Estimated Productive Hrs Per FTETotal HoursEffort 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 & FeeG&A TotalSubtotalProfit TotalTotalTotal Burdened Rate Including Fee
abcde = c x dfghi = h x fringejkl = e x kmn = l + mop = n + oq = p/e
GOVERNMENT SITE POSITIONS:
Computer Operator IT&M0.00Enter P or S$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00ERROR:#DIV/0!
Computer Operator IIT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#DIV/0!
Computer Operator IIIT&M251.30Enter P or S0.000.000.000.000.000.000.000.000.000.00
Computer Operator IVT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#DIV/0!
Computer Operator V (Computer Operator Leader)T&M125.65Enter P or S0.000.000.000.000.000.000.000.000.000.00
Data collector IT&M6,533.80Enter P or S0.000.000.000.000.000.000.000.000.000.00
Data collector I (part of CLIN 0003)FFP753.90NORMALIZED
Data collector IIT&M9,675.05Enter P or S0.000.000.000.000.000.000.000.000.000.00
Data collector IIIT&M1,005.20Enter P or S0.000.000.000.000.000.000.000.000.000.00
Data collector IVT&M251.30Enter P or S0.000.000.000.000.000.000.000.000.000.00
Data collector VT&M1,507.80Enter P or S0.000.000.000.000.000.000.000.000.000.00
Data collector VIT&M376.95Enter P or S0.000.000.000.000.000.000.000.000.000.00
Editorial Technician I - Conformed to WD Comp Op IIT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#DIV/0!
Editorial Technician II - Conformed to WD Comp Op IIIT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#DIV/0!
Editorial Technician III - Conformed to WD Comp Op IVT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#DIV/0!
Editorial Technician IV - Conformed to WD Comp Op VT&M125.65Enter P or S0.000.000.000.000.000.000.000.000.000.00
Technical Writer IT&M1,382.15Enter P or S0.000.000.000.000.000.000.000.000.000.00
Technical Writer I (part of CLIN 0003)FFP502.60NORMALIZED
Technical Writer IIT&M1,005.20Enter P or S0.000.000.000.000.000.000.000.000.000.00
Technical Writer III (Technical Writer Manager)T&M125.65Enter P or S0.000.000.000.000.000.000.000.000.000.00
Range Support Technician I - Conformed WD Eng Tech IIIT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#DIV/0!
Range Support Technician II - Conformed WD Eng Tech IVT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#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 - 240.00%0.00%0.00%0.00%
Labor Categories (Note 1)CLIN TypeFTEs (Note 2)Estimated Productive Hrs Per FTETotal HoursEffort 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 & FeeG&A TotalSubtotalProfit TotalTotalTotal Burdened Rate Including Fee
abcde = c x dfghi = h x fringejkl = e x kmn = l + mop = n + oq = p/e
GOVERNMENT SITE POSITIONS
Computer Operator IT&M0.00Enter P or S$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00ERROR:#DIV/0!
Computer Operator IIT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#DIV/0!
Computer Operator IIIT&M240.80Enter P or S0.000.000.000.000.000.000.000.000.000.00
Computer Operator IVT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#DIV/0!
Computer Operator V (Computer Operator Leader)T&M120.40Enter P or S0.000.000.000.000.000.000.000.000.000.00
Data collector IT&M6,260.80Enter P or S0.000.000.000.000.000.000.000.000.000.00
Data collector I (part of CLIN 0006)FFP722.40NORMALIZED
Data collector IIT&M9,270.80Enter P or S0.000.000.000.000.000.000.000.000.000.00
Data collector IIIT&M963.20Enter P or S0.000.000.000.000.000.000.000.000.000.00
Data collector IVT&M240.80Enter P or S0.000.000.000.000.000.000.000.000.000.00
Data collector VT&M1,444.80Enter P or S0.000.000.000.000.000.000.000.000.000.00
Data collector VIT&M361.20Enter P or S0.000.000.000.000.000.000.000.000.000.00
Editorial Technician I - Conformed to WD Comp Op IIT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#DIV/0!
Editorial Technician II - Conformed to WD Comp Op IIIT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#DIV/0!
Editorial Technician III - Conformed to WD Comp Op IVT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#DIV/0!
Editorial Technician IV - Conformed to WD Comp Op VT&M120.40Enter P or S0.000.000.000.000.000.000.000.000.000.00
Technical Writer IT&M1,324.40Enter P or S0.000.000.000.000.000.000.000.000.000.00
Technical Writer I (part of CLIN 0006)FFP481.60NORMALIZED
Technical Writer IIT&M963.20Enter P or S0.000.000.000.000.000.000.000.000.000.00
Technical Writer III (Technical Writer Manager)T&M120.40Enter P or S0.000.000.000.000.000.000.000.000.000.00
Range Support Technician I - Conformed WD Eng Tech IIIT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#DIV/0!
Range Support Technician II - Conformed WD Eng Tech IVT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#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 - 360.00%0.00%0.00%0.00%
Labor Categories (Note 1)CLIN TypeFTEs (Note 2)Estimated Productive Hrs Per FTETotal HoursEffort 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 & FeeG&A TotalSubtotalProfit TotalTotalTotal Burdened Rate Including Fee
abcde = c x dfghi = h x fringejkl = e x kmn = l + mop = n + oq = p/e
GOVERNMENT SITE POSITIONS
Computer Operator IT&M0.00Enter P or S$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00ERROR:#DIV/0!
Computer Operator IIT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#DIV/0!
Computer Operator IIIT&M240.80Enter P or S0.000.000.000.000.000.000.000.000.000.00
Computer Operator IVT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#DIV/0!
Computer Operator V (Computer Operator Leader)T&M120.40Enter P or S0.000.000.000.000.000.000.000.000.000.00
Data collector IT&M6,260.80Enter P or S0.000.000.000.000.000.000.000.000.000.00
Data collector I (part of CLIN 0009)FFP722.40NORMALIZED
Data collector IIT&M9,270.80Enter P or S0.000.000.000.000.000.000.000.000.000.00
Data collector IIIT&M963.20Enter P or S0.000.000.000.000.000.000.000.000.000.00
Data collector IVT&M240.80Enter P or S0.000.000.000.000.000.000.000.000.000.00
Data collector VT&M1,444.80Enter P or S0.000.000.000.000.000.000.000.000.000.00
Data collector VIT&M361.20Enter P or S0.000.000.000.000.000.000.000.000.000.00
Editorial Technician I - Conformed to WD Comp Op IIT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#DIV/0!
Editorial Technician II - Conformed to WD Comp Op IIIT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#DIV/0!
Editorial Technician III - Conformed to WD Comp Op IVT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#DIV/0!
Editorial Technician IV - Conformed to WD Comp Op VT&M120.40Enter P or S0.000.000.000.000.000.000.000.000.000.00
Technical Writer IT&M1,324.40Enter P or S0.000.000.000.000.000.000.000.000.000.00
Technical Writer I (part of CLIN 0009)FFP481.60NORMALIZED
Technical Writer IIT&M963.20Enter P or S0.000.000.000.000.000.000.000.000.000.00
Technical Writer III (Technical Writer Manager)T&M120.40Enter P or S0.000.000.000.000.000.000.000.000.000.00
Range Support Technician I - Conformed WD Eng Tech IIIT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#DIV/0!
Range Support Technician II - Conformed WD Eng Tech IVT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#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 - 360.00%0.00%0.00%0.00%
Labor Categories (Note 1)CLIN TypeFTEs (Note 2)Estimated Productive Hrs Per FTETotal HoursEffort 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 & FeeG&A TotalSubtotalProfit TotalTotalTotal Burdened Rate Including Fee
abcde = c x dfghi = h x fringejkl = e x kmn = l + mop = n + oq = p/e
GOVERNMENT SITE POSITIONS
0.00Enter P or S$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#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.50.00%0.00%0.00%0.00%
Labor Categories (Note 1)CLIN TypeFTEs (Note 2)Estimated Productive Hrs Per FTETotal HoursEffort 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 & FeeG&A TotalSubtotalProfit TotalTotalTotal Burdened Rate Including Fee
abcde = c x dfghi = h x fringejkl = e x kmn = l + mop = n + oq = p/e
0.00Enter P or S$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#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 - 120.00%0.00%0.00%0.00%
Labor Categories (Note 1)CLIN TypeFTEs (Note 2)Estimated Productive Hrs Per FTETotal HoursEffort 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 & FeeG&A TotalSubtotalProfit TotalTotalTotal Burdened Rate Including Fee
abcde = c x dfghi = h x fringejkl = e x kmn = l + mop = n + oq = p/e
GOVERNMENT SITE POSITIONS:
Computer Operator IT&M0.00Enter P or S$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00ERROR:#DIV/0!
Computer Operator IIT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#DIV/0!
Computer Operator IIIT&M179.50Enter P or S1.100.000.001.10197.450.00197.450.00197.451.10
Computer Operator IVT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#DIV/0!
Computer Operator V (Computer Operator Leader)T&M89.75Enter P or S1.100.000.001.1098.730.0098.730.0098.731.10
Data collector IT&M4,667.00Enter P or S1.100.000.001.105133.700.005133.700.005133.701.10
Data collector I (part of CLIN 0003)FFP538.50NORMALIZED
Data collector IIT&M6,910.75Enter P or S1.100.000.001.107601.830.007601.830.007601.831.10
Data collector IIIT&M718.00Enter P or S1.100.000.001.10789.800.00789.800.00789.801.10
Data collector IVT&M179.50Enter P or S1.100.000.001.10197.450.00197.450.00197.451.10
Data collector VT&M1,077.00Enter P or S1.100.000.001.101184.700.001184.700.001184.701.10
Data collector VIT&M269.25Enter P or S1.100.000.001.10296.180.00296.180.00296.181.10
Editorial Technician I - Conformed to WD Comp Op IIT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#DIV/0!
Editorial Technician II - Conformed to WD Comp Op IIIT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#DIV/0!
Editorial Technician III - Conformed to WD Comp Op IVT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#DIV/0!
Editorial Technician IV - Conformed to WD Comp Op VT&M89.75Enter P or S1.100.000.001.1098.730.0098.730.0098.731.10
Technical Writer IT&M987.25Enter P or S1.100.000.001.101085.980.001085.980.001085.981.10
Technical Writer I (part of CLIN 0003)FFP359.00NORMALIZED
Technical Writer IIT&M718.00Enter P or S1.100.000.001.10789.800.00789.800.00789.801.10
Technical Writer III (Technical Writer Manager)T&M89.75Enter P or S1.100.000.001.1098.730.0098.730.0098.731.10
Range Support Technician I - Conformed WD Eng Tech IIIT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#DIV/0!
Range Support Technician II - Conformed WD Eng Tech IVT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#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 - 240.00%0.00%0.00%0.00%
Labor Categories (Note 1)CLIN TypeFTEs (Note 2)Estimated Productive Hrs Per FTETotal HoursEffort 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 & FeeG&A TotalSubtotalProfit TotalTotalTotal Burdened Rate Including Fee
abcde = c x dfghi = h x fringejkl = e x kmn = l + mop = n + oq = p/e
GOVERNMENT SITE POSITIONS
Computer Operator IT&M0.00Enter P or S$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00ERROR:#DIV/0!
Computer Operator IIT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#DIV/0!
Computer Operator IIIT&M172.00Enter P or S1.100.000.001.10189.200.00189.200.00189.201.10
Computer Operator IVT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#DIV/0!
Computer Operator V (Computer Operator Leader)T&M86.00Enter P or S1.100.000.001.1094.600.0094.600.0094.601.10
Data collector IT&M4,472.00Enter P or S1.100.000.001.104,919.200.004,919.200.004,919.201.10
Data collector I (part of CLIN 0006)FFP516.00NORMALIZED
Data collector IIT&M6,622.00Enter P or S1.100.000.001.107,284.200.007,284.200.007,284.201.10
Data collector IIIT&M688.00Enter P or S1.100.000.001.10756.800.00756.800.00756.801.10
Data collector IVT&M172.00Enter P or S1.100.000.001.10189.200.00189.200.00189.201.10
Data collector VT&M1,032.00Enter P or S1.100.000.001.101,135.200.001,135.200.001,135.201.10
Data collector VIT&M258.00Enter P or S1.100.000.001.10283.800.00283.800.00283.801.10
Editorial Technician I - Conformed to WD Comp Op IIT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#DIV/0!
Editorial Technician II - Conformed to WD Comp Op IIIT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#DIV/0!
Editorial Technician III - Conformed to WD Comp Op IVT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#DIV/0!
Editorial Technician IV - Conformed to WD Comp Op VT&M86.00Enter P or S1.100.000.001.1094.600.0094.600.0094.601.10
Technical Writer IT&M946.00Enter P or S1.100.000.001.101,040.600.001,040.600.001,040.601.10
Technical Writer I (part of CLIN 0006)FFP344.00NORMALIZED
Technical Writer IIT&M688.00Enter P or S1.100.000.001.10756.800.00756.800.00756.801.10
Technical Writer III (Technical Writer Manager)T&M86.00Enter P or S1.100.000.001.1094.600.0094.600.0094.601.10
Range Support Technician I - Conformed WD Eng Tech IIIT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#DIV/0!
Range Support Technician II - Conformed WD Eng Tech IVT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#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 - 360.00%0.00%0.00%0.00%
Labor Categories (Note 1)CLIN TypeFTEs (Note 2)Estimated Productive Hrs Per FTETotal HoursEffort 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 & FeeG&A TotalSubtotalProfit TotalTotalTotal Burdened Rate Including Fee
abcde = c x dfghi = h x fringejkl = e x kmn = l + mop = n + oq = p/e
GOVERNMENT SITE POSITIONS
Computer Operator IT&M0.00Enter P or S$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00ERROR:#DIV/0!
Computer Operator IIT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#DIV/0!
Computer Operator IIIT&M172.00Enter P or S1.100.000.001.10189.200.00189.200.00189.201.10
Computer Operator IVT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#DIV/0!
Computer Operator V (Computer Operator Leader)T&M86.00Enter P or S1.100.000.001.1094.600.0094.600.0094.601.10
Data collector IT&M4,472.00Enter P or S1.100.000.001.104,919.200.004,919.200.004,919.201.10
Data collector I (part of CLIN 0009)FFP516.00NORMALIZED
Data collector IIT&M6,622.00Enter P or S1.100.000.001.107,284.200.007,284.200.007,284.201.10
Data collector IIIT&M688.00Enter P or S1.100.000.001.10756.800.00756.800.00756.801.10
Data collector IVT&M172.00Enter P or S1.100.000.001.10189.200.00189.200.00189.201.10
Data collector VT&M1,032.00Enter P or S1.100.000.001.101,135.200.001,135.200.001,135.201.10
Data collector VIT&M258.00Enter P or S1.100.000.001.10283.800.00283.800.00283.801.10
Editorial Technician I - Conformed to WD Comp Op IIT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#DIV/0!
Editorial Technician II - Conformed to WD Comp Op IIIT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#DIV/0!
Editorial Technician III - Conformed to WD Comp Op IVT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#DIV/0!
Editorial Technician IV - Conformed to WD Comp Op VT&M86.00Enter P or S1.100.000.001.1094.600.0094.600.0094.601.10
Technical Writer IT&M946.00Enter P or S1.100.000.001.101,040.600.001,040.600.001,040.601.10
Technical Writer I (part of CLIN 0009)FFP344.00NORMALIZED
Technical Writer IIT&M688.00Enter P or S1.100.000.001.10756.800.00756.800.00756.801.10
Technical Writer III (Technical Writer Manager)T&M86.00Enter P or S1.100.000.001.1094.600.0094.600.0094.601.10
Range Support Technician I - Conformed WD Eng Tech IIIT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#DIV/0!
Range Support Technician II - Conformed WD Eng Tech IVT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#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 - 360.00%0.00%0.00%0.00%
Labor Categories (Note 1)CLIN TypeFTEs (Note 2)Estimated Productive Hrs Per FTETotal HoursEffort 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 & FeeG&A TotalSubtotalProfit TotalTotalTotal Burdened Rate Including Fee
abcde = c x dfghi = h x fringejkl = e x kmn = l + mop = n + oq = p/e
GOVERNMENT SITE POSITIONS
0.00Enter P or S$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#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.50.00%0.00%0.00%0.00%
Labor Categories (Note 1)CLIN TypeFTEs (Note 2)Estimated Productive Hrs Per FTETotal HoursEffort 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 & FeeG&A TotalSubtotalProfit TotalTotalTotal Burdened Rate Including Fee
abcde = c x dfghi = h x fringejkl = e x kmn = l + mop = n + oq = p/e
0.00Enter P or S$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#DIV/0!
0.00Enter P or S0.000.000.000.000.000.000.000.00ERROR:#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 - 120.00%0.00%0.00%0.00%
Labor Categories (Note 1)CLIN TypeFTEs (Note 2)Estimated Productive Hrs Per FTETotal HoursEffort 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 & FeeG&A TotalSubtotalProfit TotalTotalTotal Burdened Rate Including Fee
abcde = c x dfghi = h x fringejkl = e x kmn = l + mop = n + oq = p/e
GOVERNMENT SITE POSITIONS:
Computer Operator IT&M0.00Enter P or S$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00ERROR:#DIV/0!
Computer Operator IIT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#DIV/0!
Computer Operator IIIT&M71.80Enter P or S1.100.000.001.1078.980.0078.980.0078.981.10
Computer Operator IVT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#DIV/0!
Computer Operator V (Computer Operator Leader)T&M35.90Enter P or S1.100.000.001.1039.490.0039.490.0039.491.10
Data collector IT&M1,866.80Enter P or S1.100.000.001.102053.480.002053.480.002053.481.10
Data collector I (part of CLIN 0003)FFP215.40NORMALIZED
Data collector IIT&M2,764.30Enter P or S1.100.000.001.103040.730.003040.730.003040.731.10
Data collector IIIT&M287.20Enter P or S1.100.000.001.10315.920.00315.920.00315.921.10
Data collector IVT&M71.80Enter P or S1.100.000.001.1078.980.0078.980.0078.981.10
Data collector VT&M430.80Enter P or S1.100.000.001.10473.880.00473.880.00473.881.10
Data collector VIT&M107.70Enter P or S1.100.000.001.10118.470.00118.470.00118.471.10
Editorial Technician I - Conformed to WD Comp Op IIT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#DIV/0!
Editorial Technician II - Conformed to WD Comp Op IIIT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#DIV/0!
Editorial Technician III - Conformed to WD Comp Op IVT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#DIV/0!
Editorial Technician IV - Conformed to WD Comp Op VT&M35.90Enter P or S1.100.000.001.1039.490.0039.490.0039.491.10
Technical Writer IT&M394.90Enter P or S1.100.000.001.10434.390.00434.390.00434.391.10
Technical Writer I (part of CLIN 0003)FFP143.60NORMALIZED
Technical Writer IIT&M287.20Enter P or S1.100.000.001.10315.920.00315.920.00315.921.10
Technical Writer III (Technical Writer Manager)T&M35.90Enter P or S1.100.000.001.1039.490.0039.490.0039.491.10
Range Support Technician I - Conformed WD Eng Tech IIIT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#DIV/0!
Range Support Technician II - Conformed WD Eng Tech IVT&M0.00Enter P or S0.000.000.000.000.000.000.000.000.00ERROR:#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 - 240.00%0.00%0.00%0.00%

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it.