A07_ATTACH_5_LOE-Data_Collection_Cost_Model_AMD_04.xlsx

XLSX spreadsheet 172 KB Posted

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

About this file

Updated LOE Spreadsheet

View the file

Other files

File Type Posted
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
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_2.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
B01_W91CRB-18-R-0004_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_5_LOE-Data_Collection_Cost_Model.XLSX XLSX spreadsheet
A07_ATTACH_3_DD254_DATTACHMENT_ONE_THROUGH_FOUR_for_Data_Collection_Solicitation.doc DOC document
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
A01_CDRL001-_Training.pdf PDF
A01_W91CRB-18-R-0004.pdf PDF
A07_ATTACH_4_Data_Collection_SSEP_Forms.xlsx XLSX spreadsheet
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 =$ 21,581.56From Cost Summary Worksheet
Profit =$ - 0From Cost Summary Worksheet
Total T&M =$ 21,581.56
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0003Year 1 Labor1Each$ - 0
FFP - NormalizedCost =
Profit =
Total FFP - Normalized =$ 854,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 =$ 24,664.64From Cost Summary Worksheet
Profit =$ - 0From Cost Summary Worksheet
Total T&M =$ 24,664.64
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0006Year 2 Labor1Each$ - 0
FFP - NormalizedCost =
Profit =
Total FFP - Normalized =$ 823,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 =$ 24,664.64From Cost Summary Worksheet
Profit =$ - 0From Cost Summary Worksheet
Total T&M =$ 24,664.64
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0009Year 3 Labor1Each$ - 0
FFP - NormalizedCost =
Profit =
Total FFP - Normalized =$ 823,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,282,950.84
Profit =$ - 0
Total =$ 1,282,950.84
$ 3,782,950.84

&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&M286,850327,800327,800942,450
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&M19,62022,42222,42264,464
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&M14,01416,01616,01646,046
Labor & Subcontract Labor T&M$ 15,415.40$ 17,617.60$ 17,617.60$ 50,650.60
Profit T&M$ - 0$ - 0$ - 0$ - 0
Subtotal Labor Shift T&M$ 15,415.40$ 17,617.60$ 17,617.60$ 50,650.60
Labor Hours Shift Overtime T&M5,6066,4066,40618,418
Labor & Subcontract Labor T&M$ 6,166.16$ 7,047.04$ 7,047.04$ 20,260.24
Profit T&M$ - 0$ - 0$ - 0$ - 0
Subtotal Labor Shift Overtime T&M$ 6,166.16$ 7,047.04$ 7,047.04$ 20,260.24
Labor Hours Total T&M326,089372,645372,6451,071,379
Labor & Subcontract Labor Total T&M$ 21,581.56$ 24,664.64$ 24,664.64$ 70,910.84
Profit Total T&M$ - 0$ - 0$ - 0$ - 0
Total Labor T&M$ 21,581.56$ 24,664.64$ 24,664.64$ 70,910.84
Labor Hours Regular FFP19,11021,84021,84062,790
Labor & Subcontract Labor FFP$ - 0NORMALIZED$ - 0$ - 0
Profit FFP$ - 0$ - 0$ - 0
Subtotal Labor Regular FFP$ - 0$ - 0$ - 0
Labor Hours Overtime FFP1,3381,5291,5294,395
Labor & Subcontract Labor FFP$ - 0NORMALIZED$ - 0$ - 0
Profit FFP$ - 0$ - 0$ - 0
Subtotal Labor Overtime FFP$ - 0$ - 0$ - 0
Labor Hours Shift FFP9561,0921,0923,140
Labor & Subcontract Labor FFP$ - 0NORMALIZED$ - 0$ - 0
Profit FFP$ - 0$ - 0$ - 0
Subtotal Labor Shift FFP$ - 0$ - 0$ - 0
Labor Hours Shift Overtime FFP3824374371,256
Labor & Subcontract Labor FFP$ - 0NORMALIZED$ - 0$ - 0
Profit FFP$ - 0$ - 0$ - 0
Subtotal Labor Shift Overtime FFP$ - 0$ - 0$ - 0
Labor Hours Total FFP21,78524,89824,89871,581
Labor & Subcontract Labor Total FFP$ - 0$ - 0$ - 0
Profit Total FFP$ - 0$ - 0$ - 0
Total Labor FFP$ - 0$ 854,000.00$ 823,000.00$ 823,000.00$ - 0$ 2,500,000.00
Labor Hours Total347,875397,542397,5421,142,959
Labor & Subcontract Labor Total$ - 0$ 21,581.56$ 24,664.64$ 24,664.64$ - 0$ 70,910.84
Profit Total$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Labor$ - 0$ 21,581.56$ 24,664.64$ 24,664.64$ - 0$ 70,910.84
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,275,581.56 $ 1,251,664.64 $ 1,255,704.64 $ - 0 $ 3,782,950.84

&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:
Annual Hours:1,820
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,592.501,592.50Enter 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,592.501,592.50Enter P or S0.000.000.000.000.000.000.000.000.00
Computer Operator IIIT&M2.001,592.503,185.00Enter P or S0.000.000.000.000.000.000.000.000.00
Computer Operator IVT&M0.031,592.5050.00Enter P or S0.000.000.000.000.000.000.000.000.00
Computer Operator V (Computer Operator Leader)T&M1.001,592.501,592.50Enter P or S0.000.000.000.000.000.000.000.000.00
Data collector IT&M51.001,592.5081,217.50Enter P or S0.000.000.000.000.000.000.000.000.00
Data collector I (part of CLIN 0003)FFP7.001,592.5011,147.50NORMALIZED
Data collector IIT&M77.001,592.50122,622.50Enter P or S0.000.000.000.000.000.000.000.000.00
Data collector IIIT&M8.001,592.5012,740.00Enter P or S0.000.000.000.000.000.000.000.000.00
Data collector IVT&M2.001,592.503,185.00Enter P or S0.000.000.000.000.000.000.000.000.00
Data collector VT&M12.001,592.5019,110.00Enter P or S0.000.000.000.000.000.000.000.000.00
Data collector VIT&M3.001,592.504,777.50Enter P or S0.000.000.000.000.000.000.000.000.00
Editorial Technician I - Conformed to WD Comp Op IIT&M0.031,592.5050.00Enter P or S0.000.000.000.000.000.000.000.000.00
Editorial Technician II - Conformed to WD Comp Op IIIT&M0.031,592.5050.00Enter P or S0.000.000.000.000.000.000.000.000.00
Editorial Technician III - Conformed to WD Comp Op IVT&M1.001,592.501,592.50Enter P or S0.000.000.000.000.000.000.000.000.00
Editorial Technician IV - Conformed to WD Comp Op VT&M1.001,592.501,592.50Enter P or S0.000.000.000.000.000.000.000.000.00
Technical Writer IT&M10.001,592.5015,925.00Enter P or S0.000.000.000.000.000.000.000.000.00
Technical Writer I (part of CLIN 0003)FFP5.001,592.507,962.50NORMALIZED
Technical Writer IIT&M8.001,592.5012,740.00Enter P or S0.000.000.000.000.000.000.000.000.00
Technical Writer III (Technical Writer Manager)T&M1.001,592.501,592.50Enter P or S0.000.000.000.000.000.000.000.000.00
Range Support Technician I - Conformed WD Eng Tech IIIT&M0.031,592.5050.00Enter P or S0.000.000.000.000.000.000.000.000.00
Range Support Technician II - Conformed WD Eng Tech IVT&M1.001,592.501,592.50Enter P or S0.000.000.000.000.000.000.000.000.00

192.13 305,960.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00 Tackett, Bruce W CIV:

Non-Normalized Rate

CLIN 0005 - 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,820.001,820.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,820.001,820.00Enter P or S0.000.000.000.000.000.000.000.000.00
Computer Operator IIIT&M2.001,820.003,640.00Enter P or S0.000.000.000.000.000.000.000.000.00
Computer Operator IVT&M0.031,820.0050.00Enter P or S0.000.000.000.000.000.000.000.000.00
Computer Operator V (Computer Operator Leader)T&M1.001,820.001,820.00Enter P or S0.000.000.000.000.000.000.000.000.00
Data collector IT&M51.001,820.0092,820.00Enter P or S0.000.000.000.000.000.000.000.000.00
Data collector I (part of CLIN 0006)FFP7.001,820.0012,740.00NORMALIZED
Data collector IIT&M77.001,820.00140,140.00Enter P or S0.000.000.000.000.000.000.000.000.00
Data collector IIIT&M8.001,820.0014,560.00Enter P or S0.000.000.000.000.000.000.000.000.00
Data collector IVT&M2.001,820.003,640.00Enter P or S0.000.000.000.000.000.000.000.000.00
Data collector VT&M12.001,820.0021,840.00Enter P or S0.000.000.000.000.000.000.000.000.00
Data collector VIT&M3.001,820.005,460.00Enter P or S0.000.000.000.000.000.000.000.000.00
Editorial Technician I - Conformed to WD Comp Op IIT&M0.031,820.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,820.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,820.001,820.00Enter P or S0.000.000.000.000.000.000.000.000.00
Editorial Technician IV - Conformed to WD Comp Op VT&M1.001,820.001,820.00Enter P or S0.000.000.000.000.000.000.000.000.00
Technical Writer IT&M10.001,820.0018,200.00Enter P or S0.000.000.000.000.000.000.000.000.00
Technical Writer I (part of CLIN 0006)FFP5.001,820.009,100.00NORMALIZED
Technical Writer IIT&M8.001,820.0014,560.00Enter P or S0.000.000.000.000.000.000.000.000.00
Technical Writer III (Technical Writer Manager)T&M1.001,820.001,820.00Enter P or S0.000.000.000.000.000.000.000.000.00
Range Support Technician I - Conformed WD Eng Tech IIIT&M0.031,820.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,820.001,820.00Enter P or S0.000.000.000.000.000.000.000.000.00

192.11 349,640.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00

CLIN 0008 - 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,820.001,820.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,820.001,820.00Enter P or S0.000.000.000.000.000.000.000.000.00
Computer Operator IIIT&M2.001,820.003,640.00Enter P or S0.000.000.000.000.000.000.000.000.00
Computer Operator IVT&M0.031,820.0050.00Enter P or S0.000.000.000.000.000.000.000.000.00
Computer Operator V (Computer Operator Leader)T&M1.001,820.001,820.00Enter P or S0.000.000.000.000.000.000.000.000.00
Data collector IT&M51.001,820.0092,820.00Enter P or S0.000.000.000.000.000.000.000.000.00
Data collector I (part of CLIN 0009)FFP7.001,820.0012,740.00NORMALIZED
Data collector IIT&M77.001,820.00140,140.00Enter P or S0.000.000.000.000.000.000.000.000.00
Data collector IIIT&M8.001,820.0014,560.00Enter P or S0.000.000.000.000.000.000.000.000.00
Data collector IVT&M2.001,820.003,640.00Enter P or S0.000.000.000.000.000.000.000.000.00
Data collector VT&M12.001,820.0021,840.00Enter P or S0.000.000.000.000.000.000.000.000.00
Data collector VIT&M3.001,820.005,460.00Enter P or S0.000.000.000.000.000.000.000.000.00
Editorial Technician I - Conformed to WD Comp Op IIT&M0.031,820.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,820.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,820.001,820.00Enter P or S0.000.000.000.000.000.000.000.000.00
Editorial Technician IV - Conformed to WD Comp Op VT&M1.001,820.001,820.00Enter P or S0.000.000.000.000.000.000.000.000.00
Technical Writer IT&M10.001,820.0018,200.00Enter P or S0.000.000.000.000.000.000.000.000.00
Technical Writer I (part of CLIN 0009)FFP5.001,820.009,100.00NORMALIZED
Technical Writer IIT&M8.001,820.0014,560.00Enter P or S0.000.000.000.000.000.000.000.000.00
Technical Writer III (Technical Writer Manager)T&M1.001,820.001,820.00Enter P or S0.000.000.000.000.000.000.000.000.00
Range Support Technician I - Conformed WD Eng Tech IIIT&M0.031,820.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,820.001,820.00Enter P or S0.000.000.000.000.000.000.000.000.00

192.11 349,640.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00

CLIN 0011 - 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.35 1,005,240.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&M222.95Enter 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&M111.48Enter P or S0.000.000.000.000.000.000.000.000.000.00
Data collector IT&M5,685.23Enter P or S0.000.000.000.000.000.000.000.000.000.00
Data collector I (part of CLIN 0003)FFP780.33NORMALIZED
Data collector IIT&M8,583.58Enter P or S0.000.000.000.000.000.000.000.000.000.00
Data collector IIIT&M891.80Enter P or S0.000.000.000.000.000.000.000.000.000.00
Data collector IVT&M222.95Enter P or S0.000.000.000.000.000.000.000.000.000.00
Data collector VT&M1,337.70Enter P or S0.000.000.000.000.000.000.000.000.000.00
Data collector VIT&M334.43Enter 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&M111.48Enter P or S0.000.000.000.000.000.000.000.000.000.00
Technical Writer IT&M1,114.75Enter P or S0.000.000.000.000.000.000.000.000.000.00
Technical Writer I (part of CLIN 0003)FFP557.38NORMALIZED
Technical Writer IIT&M891.80Enter P or S0.000.000.000.000.000.000.000.000.000.00
Technical Writer III (Technical Writer Manager)T&M111.48Enter 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 20,957.30 $0.00 $0.00 $0.00 $0.00 $0.00 0.00

CLIN 0005 - 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&M254.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&M127.40Enter P or S0.000.000.000.000.000.000.000.000.000.00
Data collector IT&M6,497.40Enter P or S0.000.000.000.000.000.000.000.000.000.00
Data collector I (part of CLIN 0006)FFP891.80NORMALIZED
Data collector IIT&M9,809.80Enter P or S0.000.000.000.000.000.000.000.000.000.00
Data collector IIIT&M1,019.20Enter P or S0.000.000.000.000.000.000.000.000.000.00
Data collector IVT&M254.80Enter P or S0.000.000.000.000.000.000.000.000.000.00
Data collector VT&M1,528.80Enter P or S0.000.000.000.000.000.000.000.000.000.00
Data collector VIT&M382.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&M127.40Enter P or S0.000.000.000.000.000.000.000.000.000.00
Technical Writer IT&M1,274.00Enter P or S0.000.000.000.000.000.000.000.000.000.00
Technical Writer I (part of CLIN 0006)FFP637.00NORMALIZED
Technical Writer IIT&M1,019.20Enter P or S0.000.000.000.000.000.000.000.000.000.00
Technical Writer III (Technical Writer Manager)T&M127.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 23,951.20 $0.00 $0.00 $0.00 $0.00 $0.00 0.00

CLIN 0008 - 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&M254.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&M127.40Enter P or S0.000.000.000.000.000.000.000.000.000.00
Data collector IT&M6,497.40Enter P or S0.000.000.000.000.000.000.000.000.000.00
Data collector I (part of CLIN 0009)FFP891.80NORMALIZED
Data collector IIT&M9,809.80Enter P or S0.000.000.000.000.000.000.000.000.000.00
Data collector IIIT&M1,019.20Enter P or S0.000.000.000.000.000.000.000.000.000.00
Data collector IVT&M254.80Enter P or S0.000.000.000.000.000.000.000.000.000.00
Data collector VT&M1,528.80Enter P or S0.000.000.000.000.000.000.000.000.000.00
Data collector VIT&M382.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&M127.40Enter P or S0.000.000.000.000.000.000.000.000.000.00
Technical Writer IT&M1,274.00Enter P or S0.000.000.000.000.000.000.000.000.000.00
Technical Writer I (part of CLIN 0009)FFP637.00NORMALIZED
Technical Writer IIT&M1,019.20Enter P or S0.000.000.000.000.000.000.000.000.000.00
Technical Writer III (Technical Writer Manager)T&M127.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 23,951.20 $0.00 $0.00 $0.00 $0.00 $0.00 0.00

CLIN 0011 - 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,859.70 $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&M159.25Enter P or S1.100.000.001.10175.180.00175.180.00175.181.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&M79.63Enter P or S1.100.000.001.1087.590.0087.590.0087.591.10
Data collector IT&M4,060.88Enter P or S1.100.000.001.104466.960.004466.960.004466.961.10
Data collector I (part of CLIN 0003)FFP557.38NORMALIZED
Data collector IIT&M6,131.13Enter P or S1.100.000.001.106744.240.006744.240.006744.241.10
Data collector IIIT&M637.00Enter P or S1.100.000.001.10700.700.00700.700.00700.701.10
Data collector IVT&M159.25Enter P or S1.100.000.001.10175.180.00175.180.00175.181.10
Data collector VT&M955.50Enter P or S1.100.000.001.101051.050.001051.050.001051.051.10
Data collector VIT&M238.88Enter P or S1.100.000.001.10262.760.00262.760.00262.761.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&M79.63Enter P or S1.100.000.001.1087.590.0087.590.0087.591.10
Technical Writer IT&M796.25Enter P or S1.100.000.001.10875.880.00875.880.00875.881.10
Technical Writer I (part of CLIN 0003)FFP398.13NORMALIZED
Technical Writer IIT&M637.00Enter P or S1.100.000.001.10700.700.00700.700.00700.701.10
Technical Writer III (Technical Writer Manager)T&M79.63Enter P or S1.100.000.001.1087.590.0087.590.0087.591.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 14,969.50 $15,415.40 $0.00 $15,415.40 $0.00 $15,415.40 1.10

CLIN 0005 - 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&M182.00Enter P or S1.100.000.001.10200.200.00200.200.00200.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&M91.00Enter P or S1.100.000.001.10100.100.00100.100.00100.101.10
Data collector IT&M4,641.00Enter P or S1.100.000.001.105,105.100.005,105.100.005,105.101.10
Data collector I (part of CLIN 0006)FFP637.00NORMALIZED
Data collector IIT&M7,007.00Enter P or S1.100.000.001.107,707.700.007,707.700.007,707.701.10
Data collector IIIT&M728.00Enter P or S1.100.000.001.10800.800.00800.800.00800.801.10
Data collector IVT&M182.00Enter P or S1.100.000.001.10200.200.00200.200.00200.201.10
Data collector VT&M1,092.00Enter P or S1.100.000.001.101,201.200.001,201.200.001,201.201.10
Data collector VIT&M273.00Enter P or S1.100.000.001.10300.300.00300.300.00300.301.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&M91.00Enter P or S1.100.000.001.10100.100.00100.100.00100.101.10
Technical Writer IT&M910.00Enter P or S1.100.000.001.101,001.000.001,001.000.001,001.001.10
Technical Writer I (part of CLIN 0006)FFP455.00NORMALIZED
Technical Writer IIT&M728.00Enter P or S1.100.000.001.10800.800.00800.800.00800.801.10
Technical Writer III (Technical Writer Manager)T&M91.00Enter P or S1.100.000.001.10100.100.00100.100.00100.101.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 17,108.00 $17,617.60 $0.00 $17,617.60 $0.00 $17,617.60 1.10

CLIN 0008 - 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&M182.00Enter P or S1.100.000.001.10200.200.00200.200.00200.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&M91.00Enter P or S1.100.000.001.10100.100.00100.100.00100.101.10
Data collector IT&M4,641.00Enter P or S1.100.000.001.105,105.100.005,105.100.005,105.101.10
Data collector I (part of CLIN 0009)FFP637.00NORMALIZED
Data collector IIT&M7,007.00Enter P or S1.100.000.001.107,707.700.007,707.700.007,707.701.10
Data collector IIIT&M728.00Enter P or S1.100.000.001.10800.800.00800.800.00800.801.10
Data collector IVT&M182.00Enter P or S1.100.000.001.10200.200.00200.200.00200.201.10
Data collector VT&M1,092.00Enter P or S1.100.000.001.101,201.200.001,201.200.001,201.201.10
Data collector VIT&M273.00Enter P or S1.100.000.001.10300.300.00300.300.00300.301.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&M91.00Enter P or S1.100.000.001.10100.100.00100.100.00100.101.10
Technical Writer IT&M910.00Enter P or S1.100.000.001.101,001.000.001,001.000.001,001.001.10
Technical Writer I (part of CLIN 0009)FFP455.00NORMALIZED
Technical Writer IIT&M728.00Enter P or S1.100.000.001.10800.800.00800.800.00800.801.10
Technical Writer III (Technical Writer Manager)T&M91.00Enter P or S1.100.000.001.10100.100.00100.100.00100.101.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 17,108.00 $17,617.60 $0.00 $17,617.60 $0.00 $17,617.60 1.10

CLIN 0011 - 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,185.50 $50,650.60 $0.00 $50,650.60 $0.00 $50,650.60 $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&M63.70Enter P or S1.100.000.001.1070.070.0070.070.0070.071.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&M31.85Enter P or S1.100.000.001.1035.040.0035.040.0035.041.10
Data collector IT&M1,624.35Enter P or S1.100.000.001.101786.790.001786.790.001786.791.10
Data collector I (part of CLIN 0003)FFP222.95NORMALIZED
Data collector IIT&M2,452.45Enter P or S1.100.000.001.102697.700.002697.700.002697.701.10
Data collector IIIT&M254.80Enter P or S1.100.000.001.10280.280.00280.280.00280.281.10
Data collector IVT&M63.70Enter P or S1.100.000.001.1070.070.0070.070.0070.071.10
Data collector VT&M382.20Enter P or S1.100.000.001.10420.420.00420.420.00420.421.10
Data collector VIT&M95.55Enter P or S1.100.000.001.10105.110.00105.110.00105.111.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&M31.85Enter P or S1.100.000.001.1035.040.0035.040.0035.041.10
Technical Writer IT&M318.50Enter P or S1.100.000.001.10350.350.00350.350.00350.351.10
Technical Writer I (part of CLIN 0003)FFP159.25NORMALIZED
Technical Writer IIT&M254.80Enter P or S1.100.000.001.10280.280.00280.280.00280.281.10
Technical Writer III (Technical Writer Manager)T&M31.85Enter P or S1.100.000.001.1035.040.0035.040.0035.041.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 5,987.80 $6,166.16 $0.00 $6,166.16 $0.00 $6,166.16 1.10

CLIN 0005 - 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.