A01_Cost_Model_Force_Development_22Sep17.xlsx

XLSX spreadsheet 142 KB Posted

Attached to
Force Development Federal contract opportunity
Solicitation number
W91CRB-17-R-0030
Issued by
Department of the Army Materiel Command Army Contracting Command Aberdeen Proving Ground

About this file

Cost Model

View the file

Other files for this federal contract opportunity

Other files attached to Force Development, newest first.
File Type Posted
Attachment_6_con't.pdf PDF
W91CRB-17-R-0030-P0006.pdf PDF
A01_-_Cost_Model_-_FOrce_Development_-_12617.xlsx XLSX spreadsheet
W91CRB-17-R-0030-P0005.pdf PDF
Attachment_6_con't.pdf PDF
A01_Workload_Data_Force_Development_12617.xlsx XLSX spreadsheet
Attachment_6_con't.pdf PDF
W91CRB-17-R-0030-P0004.pdf PDF
A07_Solicitation_Questions_W91CRB-17-R-0030.pdf PDF
A07_Solicitation_Amendment_03_Force_Development.pdf PDF
A07_Solicitation_Amendment_03_Conformed_Force_Development.pdf PDF
A07_Solicitation_Amendment_02_Conformed_Force_Development.pdf PDF
A07_Solicitation_Amendment_02_Force_Development.pdf PDF
A07_Solicitation_Questions_Amendment_02_W91CRB-17-R-0030.pdf PDF
A01_Cost_Model_Force_Development_Revised.xlsx XLSX spreadsheet
A07_Solicitation_Questions_W91CRB-17-R-0030.pdf PDF
A07_Solicitation_Amendment_01_Force_Development.pdf PDF
A07_Solicitation_Amendment_01_Conformed_Force_Development.pdf PDF
A01_Workload_Data_Force_Development_Revised.xlsx XLSX spreadsheet
A01_QASP_Final_Force_Development.pdf PDF
A07_Solicitation_Draft_25Sep17_Force_Development.pdf PDF
A01_Workload_Data_Force_Development_25Sep17.xlsx XLSX spreadsheet
A01_CDRL_1_4May17.pdf PDF
A01_CDRL_2_4May17.pdf PDF
A01_DD254_Force_Development.pdf PDF
Show all 25

On GovTribe

Work with this file on GovTribe

  • 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-17-R-0030
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0001Year 1 FD Labor1Each$ - 0
T&MCost =$ - 0From Cost Summary Worksheet
Profit =$ - 0From Cost Summary Worksheet
Total T&M =$ - 0
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0002Year 1 OCAR Labor1Each$ - 0
T&MCost =$ - 0From Cost Summary Worksheet
Profit =$ - 0From Cost Summary Worksheet
Total T&M =$ - 0
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0003Year 1 Comptroller Proponency Labor1Each$ - 0
T&MCost =$ - 0From Cost Summary Worksheet
Profit =$ - 0From Cost Summary Worksheet
Total T&M =$ - 0
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0004Year 1 Travel and ODCs1Each$ - 0
T&MCost =$ 145,000.00From Cost Summary Worksheet
G&A =$ - 0
$ 145,000.00
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0005Year 1 Contract Data Requirements - NSP
T&M
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0006Year 1 Contractor Manpower Reporting - NSP
T&M
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0007Year 1 Surge Labor1Each$ - 0
T&MCost =$ - 0From Cost Summary Worksheet
Profit =$ - 0From Cost Summary Worksheet
Total T&M =$ - 0
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0008Transition In1Each$ - 0
T&MCost =$ - 0From Cost Summary Worksheet
Profit =$ - 0From Cost Summary Worksheet
Total T&M =$ - 0
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
1001Year 2 FD Labor1Each$ - 0
T&MCost =$ - 0From Cost Summary Worksheet
Profit =$ - 0From Cost Summary Worksheet
Total T&M =$ - 0
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
1002OCAR Labor Year 21Each$ - 0
T&MCost =$ - 0From Cost Summary Worksheet
Profit =$ - 0From Cost Summary Worksheet
Total T&M =$ - 0
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
1003Comptroller Proponency Labor Year 21Each$ - 0
T&MCost =$ - 0From Cost Summary Worksheet
Profit =$ - 0From Cost Summary Worksheet
Total T&M =$ - 0
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
1004Year 2 Travel and ODCs1Each$ - 0
T&MCost =$ 145,000.00From Cost Summary Worksheet
G&A =$ - 0
$ 145,000.00
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
1005Year 2 Contract Data Requirements - NSP
T&M
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
1006Year 2 Contractor Manpower Reporting - NSP
T&M
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
1007Surge Labor Year 21Each$ - 0
T&MCost =$ - 0From Cost Summary Worksheet
Profit =$ - 0From Cost Summary Worksheet
Total T&M =$ - 0
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
2001FD Labor Year 31Each$ - 0
T&MCost =$ - 0From Cost Summary Worksheet
Profit =$ - 0From Cost Summary Worksheet
Total T&M =$ - 0
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
2002OCAR Labor Year 31Each$ - 0
T&MCost =$ - 0From Cost Summary Worksheet
Profit =$ - 0From Cost Summary Worksheet
Total T&M =$ - 0
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
2003Comptroller Proponency Labor Year 31Each$ - 0
T&MCost =$ - 0From Cost Summary Worksheet
Profit =$ - 0From Cost Summary Worksheet
Total T&M =$ - 0
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
2004Year 3 Travel and ODCs1Each$ - 0
T&MCost =$ 145,000.00From Cost Summary Worksheet
G&A =$ - 0
$ 145,000.00
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
2005Year 3 Contract Data Requirements - NSP
T&M
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
2006Year 3 Contractor Manpower Reporting - NSP
T&M
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
2007Surge Labor Year 31Each$ - 0
T&MCost =$ - 0From Cost Summary Worksheet
Profit =$ - 0From Cost Summary Worksheet
Total T&M =$ - 0
TOTAL
Total Cost =$ 435,000.00
Profit =$ - 0
Total =$ 435,000.00
$ 435,000.00

&F, &A

PAGE &P OF &N

Cost Summary

COST SUMMARY
Solicitation: W91CRB-17-R-0030
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
Transition InYear 1Year 2Year 3Total
FD Labor Hours11,045121,495132,540132,540397,620
Labor & Subcontract Labor$ - 0$ - 0$ - 0$ - 0$ - 0
Profit$ - 0$ - 0$ - 0$ - 0$ - 0
Subtotal FD Labor$ - 0$ - 0$ - 0$ - 0$ - 0
OCAR Labor Hours4705,1705,6405,64016,920
Labor & Subcontract Labor$ - 0$ - 0$ - 0$ - 0$ - 0
Profit$ - 0$ - 0$ - 0$ - 0$ - 0
Subtotal OCAR Labor$ - 0$ - 0$ - 0$ - 0$ - 0
Comptroller Proponency Office Labor Hours3133,4473,7603,76011,280
Labor & Subcontract Labor$ - 0$ - 0$ - 0$ - 0$ - 0
Profit$ - 0$ - 0$ - 0$ - 0$ - 0
Subtotal Comptroller Proponency Office Labor$ - 0$ - 0$ - 0$ - 0$ - 0
Surge Labor Hours1,72318,95720,68020,68062,040
Labor & Subcontract Labor$ - 0$ - 0$ - 0$ - 0$ - 0
Profit$ - 0$ - 0$ - 0$ - 0$ - 0
Subtotal Surge Labor$ - 0$ - 0$ - 0$ - 0$ - 0
Labor Hours Total13,552149,068162,620162,620487,860
Labor & Subcontract Labor Total$ - 0$ - 0$ - 0$ - 0$ - 0
Profit Total$ - 0$ - 0$ - 0$ - 0$ - 0
Total Labor$ - 0$ - 0$ - 0$ - 0$ - 0
Other Direct Costs$ 145,000.00$ 145,000.00$ 145,000.00$ 435,000.00
G&A$ - 0$ - 0$ - 0$ - 0
Total ODC$ 145,000.00$ 145,000.00$ 145,000.00$ 435,000.00

TOTAL PRICE $ 145,000.00 $ 145,000.00 $ 145,000.00 $ 435,000.00

&F, &A

Page &P of &N

FD Labor - Cost Detail

REGULAR LABOR - COST DETAIL SPREADSHEET
Solicitation: W91CRB-17-R-0030
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
Annual Productive Hours:1880
CLIN 0008: 30-day Transition In0.00%0.00%0.00%0.00%
DivisionLabor 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
PM - Offsite
Program ManagerT&M0.515778.3Enter P or S$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
DOM
FDBSenior AnalystT&M1.0157156.7Enter P or S0.000.000.000.000.000.000.000.000.00
FDCSenior AnalystT&M2.0157313.3Enter P or S0.000.000.000.000.000.000.000.000.00
Senior AnalystT&M7.01571,096.7Enter P or S0.000.000.000.000.000.000.000.000.00
FDDSenior AnalystT&M6.0157940.0Enter P or S0.000.000.000.000.000.000.000.000.00
FDGSenior AnalystT&M3.0157470.0Enter P or S0.000.000.000.000.000.000.000.000.00
Senior AnalystT&M3.0157470.0Enter P or S0.000.000.000.000.000.000.000.000.00
FDISenior AnalystT&M4.0157626.7Enter P or S0.000.000.000.000.000.000.000.000.00
FDLAnalystT&M2.0157313.3Enter P or S0.000.000.000.000.000.000.000.000.00
FDLSenior AnalystT&M1.0157156.7Enter P or S0.000.000.000.000.000.000.000.000.00
FDVSenior AnalystT&M2.0157313.3Enter P or S0.000.000.000.000.000.000.000.000.00
DOR
FDAOperations Research AnalystT&M3.0157470.0Enter P or S0.000.000.000.000.000.000.000.000.00
Senior Operations Research AnalystT&M3.0157470.0Enter P or S0.000.000.000.000.000.000.000.000.00
FDPSenior AnalystT&M1.0157156.7Enter P or S0.000.000.000.000.000.000.000.000.00
Senior AnalystT&M1.0157156.7Enter P or S0.000.000.000.000.000.000.000.000.00
Senior AnalystT&M1.0157156.7Enter P or S0.000.000.000.000.000.000.000.000.00
AnalystT&M2.0157313.3Enter P or S0.000.000.000.000.000.000.000.000.00
AnalystT&M2.0157313.3Enter P or S0.000.000.000.000.000.000.000.000.00
FDRSenior AnalystT&M1.0157156.7Enter P or S0.000.000.000.000.000.000.000.000.00
FDRAnalystT&M1.0157156.7Enter P or S0.000.000.000.000.000.000.000.000.00
G8/FD
FDZForce Documentation AnalystT&M1.0157156.7Enter P or S0.000.000.000.000.000.000.000.000.00
Communications LiaisonT&M1.0157156.7Enter P or S0.000.000.000.000.000.000.000.000.00
DIGSenior AnalystT&M1.0157156.7Enter P or S0.000.000.000.000.000.000.000.000.00
Web Master/DesignerT&M1.0157156.7Enter P or S0.000.000.000.000.000.000.000.000.00
Communications LiaisonT&M1.0157156.7Enter P or S0.000.000.000.000.000.000.000.000.00
DJI
FDFSenior AnalystT&M1.0157156.7Enter P or S0.000.000.000.000.000.000.000.000.00
Senior AnalystT&M1.0157156.7Enter P or S0.000.000.000.000.000.000.000.000.00
FDOSenior AnalystT&M1.0157156.7Enter P or S0.000.000.000.000.000.000.000.000.00
Senior AnalystT&M4.0157626.7Enter P or S0.000.000.000.000.000.000.000.000.00
FDJSenior AnalystT&M3.0157470.0Enter P or S0.000.000.000.000.000.000.000.000.00
AnalystT&M1.0157156.7Enter P or S0.000.000.000.000.000.000.000.000.00
FDSSenior Operations Research AnalystT&M4.0157626.7Enter P or S0.000.000.000.000.000.000.000.000.00
G8 LNOs
G8 LNOsSenior AnalystT&M4.0157626.7Enter P or S0.000.000.000.000.000.000.000.000.00

70.5 11,045.0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00

CLIN 0001: Year 1, Months 2 - 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
PM - Offsite
Program ManagerT&M0.51,723861.7Enter P or S$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
DOM
FDBSenior AnalystT&M1.01,7231,723.3Enter P or S0.000.000.000.000.000.000.000.000.00
FDCSenior AnalystT&M2.01,7233,446.7Enter P or S0.000.000.000.000.000.000.000.000.00
Senior AnalystT&M7.01,72312,063.3Enter P or S0.000.000.000.000.000.000.000.000.00
FDDSenior AnalystT&M6.01,72310,340.0Enter P or S0.000.000.000.000.000.000.000.000.00
FDGSenior AnalystT&M3.01,7235,170.0Enter P or S0.000.000.000.000.000.000.000.000.00
Senior AnalystT&M3.01,7235,170.0Enter P or S0.000.000.000.000.000.000.000.000.00
FDISenior AnalystT&M4.01,7236,893.3Enter P or S0.000.000.000.000.000.000.000.000.00
FDLAnalystT&M2.01,7233,446.7Enter P or S0.000.000.000.000.000.000.000.000.00
FDLSenior AnalystT&M1.01,7231,723.3Enter P or S0.000.000.000.000.000.000.000.000.00
FDVSenior AnalystT&M2.01,7233,446.7Enter P or S0.000.000.000.000.000.000.000.000.00
DOR
FDAOperations Research AnalystT&M3.01,7235,170.0Enter P or S0.000.000.000.000.000.000.000.000.00
Senior Operations Research AnalystT&M3.01,7235,170.0Enter P or S0.000.000.000.000.000.000.000.000.00
FDPSenior AnalystT&M1.01,7231,723.3Enter P or S0.000.000.000.000.000.000.000.000.00
Senior AnalystT&M1.01,7231,723.3Enter P or S0.000.000.000.000.000.000.000.000.00
Senior AnalystT&M1.01,7231,723.3Enter P or S0.000.000.000.000.000.000.000.000.00
AnalystT&M2.01,7233,446.7Enter P or S0.000.000.000.000.000.000.000.000.00
AnalystT&M2.01,7233,446.7Enter P or S0.000.000.000.000.000.000.000.000.00
FDRSenior AnalystT&M1.01,7231,723.3Enter P or S0.000.000.000.000.000.000.000.000.00
FDRAnalystT&M1.01,7231,723.3Enter P or S0.000.000.000.000.000.000.000.000.00
G8/FD
FDZForce Documentation AnalystT&M1.01,7231,723.3Enter P or S0.000.000.000.000.000.000.000.000.00
Communications LiaisonT&M1.01,7231,723.3Enter P or S0.000.000.000.000.000.000.000.000.00
DIGSenior AnalystT&M1.01,7231,723.3Enter P or S0.000.000.000.000.000.000.000.000.00
Web Master/DesignerT&M1.01,7231,723.3Enter P or S0.000.000.000.000.000.000.000.000.00
Communications LiaisonT&M1.01,7231,723.3Enter P or S0.000.000.000.000.000.000.000.000.00
DJI
FDFSenior AnalystT&M1.01,7231,723.3Enter P or S0.000.000.000.000.000.000.000.000.00
Senior AnalystT&M1.01,7231,723.3Enter P or S0.000.000.000.000.000.000.000.000.00
FDOSenior AnalystT&M1.01,7231,723.3Enter P or S0.000.000.000.000.000.000.000.000.00
Senior AnalystT&M4.01,7236,893.3Enter P or S0.000.000.000.000.000.000.000.000.00
FDJSenior AnalystT&M3.01,7235,170.0Enter P or S0.000.000.000.000.000.000.000.000.00
AnalystT&M1.01,7231,723.3Enter P or S0.000.000.000.000.000.000.000.000.00
FDSSenior Operations Research AnalystT&M4.01,7236,893.3Enter P or S0.000.000.000.000.000.000.000.000.00
G8 LNOs
G8 LNOsSenior AnalystT&M4.01,7236,893.3Enter P or S0.000.000.000.000.000.000.000.000.00

70.5 121,495.0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00

CLIN 1001: Year 2, Months 13 - 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
PM - Offsite
Program ManagerT&M0.51,880940.0Enter P or S$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
DOM
FDBSenior AnalystT&M1.01,8801,880.0Enter P or S0.000.000.000.000.000.000.000.000.00
FDCSenior AnalystT&M2.01,8803,760.0Enter P or S0.000.000.000.000.000.000.000.000.00
Senior AnalystT&M7.01,88013,160.0Enter P or S0.000.000.000.000.000.000.000.000.00
FDDSenior AnalystT&M6.01,88011,280.0Enter P or S0.000.000.000.000.000.000.000.000.00
FDGSenior AnalystT&M3.01,8805,640.0Enter P or S0.000.000.000.000.000.000.000.000.00
Senior AnalystT&M3.01,8805,640.0Enter P or S0.000.000.000.000.000.000.000.000.00
FDISenior AnalystT&M4.01,8807,520.0Enter P or S0.000.000.000.000.000.000.000.000.00
FDLAnalystT&M2.01,8803,760.0Enter P or S0.000.000.000.000.000.000.000.000.00
FDLSenior AnalystT&M1.01,8801,880.0Enter P or S0.000.000.000.000.000.000.000.000.00
FDVSenior AnalystT&M2.01,8803,760.0Enter P or S0.000.000.000.000.000.000.000.000.00
DOR
FDAOperations Research AnalystT&M3.01,8805,640.0Enter P or S0.000.000.000.000.000.000.000.000.00
Senior Operations Research AnalystT&M3.01,8805,640.0Enter P or S0.000.000.000.000.000.000.000.000.00
FDPSenior AnalystT&M1.01,8801,880.0Enter P or S0.000.000.000.000.000.000.000.000.00
Senior AnalystT&M1.01,8801,880.0Enter P or S0.000.000.000.000.000.000.000.000.00
Senior AnalystT&M1.01,8801,880.0Enter P or S0.000.000.000.000.000.000.000.000.00
AnalystT&M2.01,8803,760.0Enter P or S0.000.000.000.000.000.000.000.000.00
AnalystT&M2.01,8803,760.0Enter P or S0.000.000.000.000.000.000.000.000.00
FDRSenior AnalystT&M1.01,8801,880.0Enter P or S0.000.000.000.000.000.000.000.000.00
FDRAnalystT&M1.01,8801,880.0Enter P or S0.000.000.000.000.000.000.000.000.00
G8/FD
FDZForce Documentation AnalystT&M1.01,8801,880.0Enter P or S0.000.000.000.000.000.000.000.000.00
Communications LiaisonT&M1.01,8801,880.0Enter P or S0.000.000.000.000.000.000.000.000.00
DIGSenior AnalystT&M1.01,8801,880.0Enter P or S0.000.000.000.000.000.000.000.000.00
Web Master/DesignerT&M1.01,8801,880.0Enter P or S0.000.000.000.000.000.000.000.000.00
Communications LiaisonT&M1.01,8801,880.0Enter P or S0.000.000.000.000.000.000.000.000.00
DJI
FDFSenior AnalystT&M1.01,8801,880.0Enter P or S0.000.000.000.000.000.000.000.000.00
Senior AnalystT&M1.01,8801,880.0Enter P or S0.000.000.000.000.000.000.000.000.00
FDOSenior AnalystT&M1.01,8801,880.0Enter P or S0.000.000.000.000.000.000.000.000.00
Senior AnalystT&M4.01,8807,520.0Enter P or S0.000.000.000.000.000.000.000.000.00
FDJSenior AnalystT&M3.01,8805,640.0Enter P or S0.000.000.000.000.000.000.000.000.00
AnalystT&M1.01,8801,880.0Enter P or S0.000.000.000.000.000.000.000.000.00
FDSSenior Operations Research AnalystT&M4.01,8807,520.0Enter P or S0.000.000.000.000.000.000.000.000.00
G8 LNOs
G8 LNOsSenior AnalystT&M4.01,8807,520.0Enter P or S0.000.000.000.000.000.000.000.000.00

70.5 132,540.0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00

CLIN 2001: Year 3, Months 25 - 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
PM - Offsite
Program ManagerT&M0.51,880940.0Enter P or S$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
DOM
FDBSenior AnalystT&M1.01,8801,880.0Enter P or S0.000.000.000.000.000.000.000.000.00
FDCSenior AnalystT&M2.01,8803,760.0Enter P or S0.000.000.000.000.000.000.000.000.00
Senior AnalystT&M7.01,88013,160.0Enter P or S0.000.000.000.000.000.000.000.000.00
FDDSenior AnalystT&M6.01,88011,280.0Enter P or S0.000.000.000.000.000.000.000.000.00
FDGSenior AnalystT&M3.01,8805,640.0Enter P or S0.000.000.000.000.000.000.000.000.00
Senior AnalystT&M3.01,8805,640.0Enter P or S0.000.000.000.000.000.000.000.000.00
FDISenior AnalystT&M4.01,8807,520.0Enter P or S0.000.000.000.000.000.000.000.000.00
FDLAnalystT&M2.01,8803,760.0Enter P or S0.000.000.000.000.000.000.000.000.00
FDLSenior AnalystT&M1.01,8801,880.0Enter P or S0.000.000.000.000.000.000.000.000.00
FDVSenior AnalystT&M2.01,8803,760.0Enter P or S0.000.000.000.000.000.000.000.000.00
DOR
FDAOperations Research AnalystT&M3.01,8805,640.0Enter P or S0.000.000.000.000.000.000.000.000.00
Senior Operations Research AnalystT&M3.01,8805,640.0Enter P or S0.000.000.000.000.000.000.000.000.00
FDPSenior AnalystT&M1.01,8801,880.0Enter P or S0.000.000.000.000.000.000.000.000.00
Senior AnalystT&M1.01,8801,880.0Enter P or S0.000.000.000.000.000.000.000.000.00
Senior AnalystT&M1.01,8801,880.0Enter P or S0.000.000.000.000.000.000.000.000.00
AnalystT&M2.01,8803,760.0Enter P or S0.000.000.000.000.000.000.000.000.00
AnalystT&M2.01,8803,760.0Enter P or S0.000.000.000.000.000.000.000.000.00
FDRSenior AnalystT&M1.01,8801,880.0Enter P or S0.000.000.000.000.000.000.000.000.00
FDRAnalystT&M1.01,8801,880.0Enter P or S0.000.000.000.000.000.000.000.000.00
G8/FD
FDZForce Documentation AnalystT&M1.01,8801,880.0Enter P or S0.000.000.000.000.000.000.000.000.00
Communications LiaisonT&M1.01,8801,880.0Enter P or S0.000.000.000.000.000.000.000.000.00
DIGSenior AnalystT&M1.01,8801,880.0Enter P or S0.000.000.000.000.000.000.000.000.00
Web Master/DesignerT&M1.01,8801,880.0Enter P or S0.000.000.000.000.000.000.000.000.00
Communications LiaisonT&M1.01,8801,880.0Enter P or S0.000.000.000.000.000.000.000.000.00
DJI
FDFSenior AnalystT&M1.01,8801,880.0Enter P or S0.000.000.000.000.000.000.000.000.00
Senior AnalystT&M1.01,8801,880.0Enter P or S0.000.000.000.000.000.000.000.000.00
FDOSenior AnalystT&M1.01,8801,880.0Enter P or S0.000.000.000.000.000.000.000.000.00
Senior AnalystT&M4.01,8807,520.0Enter P or S0.000.000.000.000.000.000.000.000.00
FDJSenior AnalystT&M3.01,8805,640.0Enter P or S0.000.000.000.000.000.000.000.000.00
AnalystT&M1.01,8801,880.0Enter P or S0.000.000.000.000.000.000.000.000.00
FDSSenior Operations Research AnalystT&M4.01,8807,520.0Enter P or S0.000.000.000.000.000.000.000.000.00
G8 LNOs
G8 LNOsSenior AnalystT&M4.01,8807,520.0Enter P or S0.000.000.000.000.000.000.000.000.00

70.5 132,540.0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00

Totals: 282.0 397,620.0 $0.00 ERROR:#DIV/0! ERROR:#DIV/0! $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

&F, &A

PAGE &P OF &N

OCAR Labor - Cost Detail

REGULAR LABOR - COST DETAIL SPREADSHEET
Solicitation: W91CRB-17-R-0030
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
Annual Productive Hours:1880
CLIN 0008: 30-day Transition In0.00%0.00%0.00%0.00%
DivisionLabor 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
Senior AnalystT&M3.0157470.0Enter P or S$0.00$0.00$0.000$0.00$0.00$0.00$0.00$0.00

3.0 470.0 ERROR:#VALUE! $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00

CLIN 0002: Year 1, Months 2 - 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
Senior AnalystT&M3.01,7235,170.0Enter P or S$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00

3.0 5,170.0 ERROR:#VALUE! $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00

CLIN 1002: Year 2, Months 13 - 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
Senior AnalystT&M3.01,8805,640.0Enter P or S$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00

3.0 5,640.0 ERROR:#VALUE! $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00

CLIN 2002: Year 3, Months 25 - 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
Senior AnalystT&M3.01,8805,640.0Enter P or S$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00

3.0 5,640.0 ERROR:#VALUE! $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00

Totals: 12.0 16,920.0 ERROR:#VALUE! ERROR:#DIV/0! ERROR:#DIV/0! $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

&F, &A

PAGE &P OF &N

CompPropOff Labor - Cost Detail

REGULAR LABOR - COST DETAIL SPREADSHEET
Solicitation: W91CRB-17-R-0030
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
Annual Productive Hours:1880
CLIN 0008: 30-day Transition In0.00%0.00%0.00%0.00%
DivisionLabor 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
CPOCommunications LiasionT&M1.0157156.7Enter P or S$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Web Master/DesignerT&M1.0157156.7Enter P or S$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00

2.0 313.3 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00

CLIN 0003: Year 1, Months 2 - 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
CPOCommunications LiasionT&M1.01,7231,723.3Enter P or S$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Web Master/DesignerT&M1.01,7231,723.3Enter P or S0.000.000.000.000.000.000.000.000.00

2.0 3,446.7 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00

CLIN 1003: Year 2, Months 13 - 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
CPOCommunications LiasionT&M1.01,8801,880.0Enter P or S$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Web Master/DesignerT&M1.01,8801,880.0Enter P or S0.000.000.000.000.000.000.000.000.00

2.0 3,760.0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00

CLIN 2003: Year 3, Months 25 - 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
CPOCommunications LiasionT&M1.01,8801,880.0Enter P or S$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Web Master/DesignerT&M1.01,8801,880.0Enter P or S0.000.000.000.000.000.000.000.000.00

2.0 3,760.0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00

Totals: 8.0 11,280.0 $0.00 ERROR:#DIV/0! ERROR:#DIV/0! $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

&F, &A

PAGE &P OF &N

Surge Labor - Cost Detail

REGULAR LABOR - COST DETAIL SPREADSHEET
Solicitation: W91CRB-17-R-0030
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
Annual Productive Hours:1880
CLIN 0008: 30-day Transition In0.00%0.00%0.00%0.00%
DivisionLabor 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
FDSenior AnalystT&M6.0157940.0Enter P or S$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Senior Operations Research AnalystT&M2.0157313.3Enter P or S0.000.000.000.000.000.000.000.000.00
AnalystT&M2.0157313.3Enter P or S0.000.000.000.000.000.000.000.000.00
Operations Research AnalystT&M1.0157156.7Enter P or S0.000.000.000.000.000.000.000.000.00

11.0 1,723.3 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

CLIN 0007: Year 1, Months 25 - 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
FDSenior AnalystT&M6.01,72310,340.0Enter P or S$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Senior Operations Research AnalystT&M2.01,7233,446.7Enter P or S0.000.000.000.000.000.000.000.000.00
AnalystT&M2.01,7233,446.7Enter P or S0.000.000.000.000.000.000.000.000.00
Operations Research AnalystT&M1.01,7231,723.3Enter P or S0.000.000.000.000.000.000.000.000.00

11.0 18,956.7 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

CLIN 1007: Year 2, Months 13 - 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
FDSenior AnalystT&M6.01,88011,280.0Enter P or S$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Senior Operations Research AnalystT&M2.01,8803,760.0Enter P or S0.000.000.000.000.000.000.000.000.00
AnalystT&M2.01,8803,760.0Enter P or S0.000.000.000.000.000.000.000.000.00
Operations Research AnalystT&M1.01,8801,880.0Enter P or S0.000.000.000.000.000.000.000.000.00

11.0 20,680.0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

CLIN 2007: Year 3, Months 25 - 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
FDSenior AnalystT&M6.01,88011,280.0Enter P or S$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Senior Operations Research AnalystT&M2.01,8803,760.0Enter P or S0.000.000.000.000.000.000.000.000.00
AnalystT&M2.01,8803,760.0Enter P or S0.000.000.000.000.000.000.000.000.00
Operations Research AnalystT&M1.01,8801,880.0Enter P or S0.000.000.000.000.000.000.000.000.00

11.0 20,680.0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Totals: 44.0 62,040.0 $0.00 ERROR:#DIV/0! ERROR:#DIV/0! $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

&F, &A

PAGE &P OF &N

ODC Summary

ODC Cost Detail Spreadsheet
Solicitation: W91CRB-17-R-0030
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
CLINODCs (Note 7)Burden/G&A RateG&A $Total ODC Cost
abcd = b X ce = b + d
CLIN 0004: Year 1$ 145,000.00$ - 0$ 145,000.00
CLIN 1004: Year 2$ 145,000.00$ - 0$ 145,000.00
CLIN 2004: Year 3$ 145,000.00$ - 0$ 145,000.00
Total$ 435,000.00$ - 0$ 435,000.00
(To Section B)

Direct Labor Rate Schedule

DIRECT LABOR RATE SCHEDULE
Solicitation: W91CRB-17-R-0030
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
YEAR 1YEAR 2YEAR 3
LABOR CATEGORIESPROPOSED DIRECT LABOR RATESBASIS OF PROPOSED RATE FOR COST REALISM PURPOSESESCALATIONPROPOSED DIRECT LABOR RATESESCALATIONPROPOSED DIRECT LABOR RATES
NOTE 1NOTE 2NOTE 3NOTE 3
FD Labor
PM-Offsite
Program Manager
DOM
Senior Analyst
Senior Analyst
Senior Analyst
Senior Analyst
Senior Analyst
Senior Analyst
Senior Analyst
Analyst
Senior Analyst
Senior Analyst
DOR
Operations Research Analyst
Senior Operations Research Analyst
Senior Analyst
Senior Analyst
Senior Analyst
Analyst
Analyst
Senior Analyst
Analyst
G8/FD
Force Documentation Analyst
Communications Liaison
Senior Analyst
Web Master/Designer
Communications Liaison
DJI
Senior Analyst
Senior Analyst
Senior Analyst
Senior Analyst
Senior Analyst
Analyst
Senior Operations Research Analyst
G8 LNOS
Senior Analyst
OCAR Labor
Senior Analyst
Proponency Office Labor
Communications Liasion
Web Master/Designer
Surge Labor
Senior Analyst
Senior Operations Research Analyst
Analyst
Operations Research Analyst
NOTE 1:Please enter all the corresponding labor categories proposed in the labor cost detail spreadhseets.
NOTE 2:For cost realism purposes indicate the basis of the proposed rates and provide documentation to substantiate the rates.
If the rates are based on actuals provide pay stubs, signed employee letters of intent, etc.
If the rates are based on estimates provide salary survey data and other data to corroborate the realism of the rates.
NOTE 3:Please provide the basis of escalation.

Indirect Rate Summary

INDIRECT RATE SUMMARY
Solicitation: W91CRB-17-R-0030
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
TYPE OF SUBCONTRACT (I.E. T&M, CP, CPFF, ETC)FRINGE RATEOVERHEAD RATEG&A RATEPROPOSED PROFIT/FEE RATE% OF EFFORT PERFORMED BY PRIME AND SUBS BASED ON LABOR HOURS
YEAR 1
PRIME CONTRACTOR0.00%0.00%0.00%0.00%0.00%
SUBCONTRACTOR 10.00%0.00%0.00%0.00%0.00%
SUBCONTRACTOR 20.00%0.00%0.00%0.00%0.00%
SUBCONTRACTOR 30.00%0.00%0.00%0.00%0.00%
ETC0.00%0.00%0.00%0.00%0.00%
0.00%(Should equal 100%)
YEAR 2
PRIME CONTRACTOR0.00%0.00%0.00%0.00%0.00%
SUBCONTRACTOR 10.00%0.00%0.00%0.00%0.00%
SUBCONTRACTOR 20.00%0.00%0.00%0.00%0.00%
SUBCONTRACTOR 30.00%0.00%0.00%0.00%0.00%
ETC0.00%0.00%0.00%0.00%0.00%
0.00%(Should equal 100%)
YEAR 3
PRIME CONTRACTOR0.00%0.00%0.00%0.00%0.00%
SUBCONTRACTOR 10.00%0.00%0.00%0.00%0.00%
SUBCONTRACTOR 20.00%0.00%0.00%0.00%0.00%
SUBCONTRACTOR 30.00%0.00%0.00%0.00%0.00%
ETC0.00%0.00%0.00%0.00%0.00%
0.00%(Should equal 100%)
Please enter corresponding indirect rates for the prime and each subcontractor for each of the periods.
Subcontractors may provide data separately in the above format for proprietary reasons.
Provide the necessary narrative describing how the rates were derived and applied, the composition of the allocation pools & bases, and provide any supporting forward rate agreements and DCAA/DCMA agreements/reports.
If rates proposed are other than based on actuals or actual budgets describe why.
Sample Fringe, Overhead, and G&A worksheet schedules follow this tab.

Sample Fringe Worksheet

FRINGE EXPENSE
Solicitation: W91CRB-17-R-0030
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
Fringe Expenses:Current ActualEstimated Year 1Estimated Year 2Estimated Year 3
Indirect payroll$ - 0$ - 0$ - 0$ - 0
Payroll taxes (FICA, FUTA, SUTA, Workmans Comp)$ - 0$ - 0$ - 0$ - 0
Vacation (PTO)$ - 0$ - 0$ - 0$ - 0
Holiday$ - 0$ - 0$ - 0$ - 0
Sick Leave$ - 0$ - 0$ - 0$ - 0
Health/Disability Ins$ - 0$ - 0$ - 0$ - 0
Workmans Compensation$ - 0$ - 0$ - 0$ - 0
Bonuses$ - 0$ - 0$ - 0$ - 0
Retention Pay$ - 0$ - 0$ - 0$ - 0
401k Match$ - 0$ - 0$ - 0$ - 0
Mil Leave$ - 0$ - 0$ - 0$ - 0
Breavement$ - 0$ - 0$ - 0$ - 0
Insurance$ - 0$ - 0$ - 0$ - 0
Total Pool$ - 0$ - 0$ - 0$ - 0
Less: FAR 31 Unallowable Cost$ - 0$ - 0$ - 0$ - 0
Entertainment, etc.
Net Allowable cost$ - 0$ - 0$ - 0$ - 0
Labor Base
Direct Labor$ - 0$ - 0$ - 0$ - 0
OH Labor$ - 0$ - 0$ - 0$ - 0
B&P Labor$ - 0$ - 0$ - 0$ - 0
Total Labor Base$ - 0$ - 0$ - 0$ - 0

Rate ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!

This exhibit shows a fringe benefit allocation. The offeror may have a combined allocation for fringe benefits and overhead depending on its accounting system.

Sample OH Worksheet

OVERHEAD EXPENSE
Solicitation: W91CRB-17-R-0030
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
Overhead Expenses:Current ActualEstimated Year 1Estimated Year 2Estimated Year 3
$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0
Total Pool$ - 0$ - 0$ - 0$ - 0

Less: FAR 31 Unallowable Cost

Net Allowable cost $ - 0 $ - 0 $ - 0 $ - 0

Labor Base
Direct Labor$ - 0$ - 0$ - 0$ - 0
OH Labor$ - 0$ - 0$ - 0$ - 0
B&P Labor$ - 0$ - 0$ - 0$ - 0
Total Labor Base$ - 0$ - 0$ - 0$ - 0

Rate ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!

This exhibit shows an overhead allocation. The offeror may have a combined allocation for fringe benefits and overhead depending on its accounting system.

Sample G&A Worksheet

GENERAL & ADMINISTRATIVE (G&A) EXPENSE
Solicitation: W91CRB-17-R-0030
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
G&A Expenses:Current ActualEstimated Year 1Estimated Year 2Estimated Year 3
Labor$ - 0$ - 0$ - 0$ - 0
Fringe$ - 0$ - 0$ - 0$ - 0
Subscriptions$ - 0$ - 0$ - 0$ - 0
Postage$ - 0$ - 0$ - 0$ - 0
Printing$ - 0$ - 0$ - 0$ - 0
Supplies$ - 0$ - 0$ - 0$ - 0
Telephone$ - 0$ - 0$ - 0$ - 0
Travel$ - 0$ - 0$ - 0$ - 0
Misc$ - 0$ - 0$ - 0$ - 0
Training$ - 0$ - 0$ - 0$ - 0
Recruiting$ - 0$ - 0$ - 0$ - 0
Maint$ - 0$ - 0$ - 0$ - 0
Equip$ - 0$ - 0$ - 0$ - 0
Consultants$ - 0$ - 0$ - 0$ - 0
Prof fees$ - 0$ - 0$ - 0$ - 0
Filings$ - 0$ - 0$ - 0$ - 0
Legal$ - 0$ - 0$ - 0$ - 0
Total G&A$ - 0$ - 0$ - 0$ - 0
Less: FAR 31 Unallowable Costs
Interest$ - 0$ - 0$ - 0$ - 0
Contributions$ - 0$ - 0$ - 0$ - 0
Advertising, etc.$ - 0$ - 0$ - 0$ - 0
Total Unallowable Costs$ - 0$ - 0$ - 0$ - 0
G&A Pool After Deducting Unallowable Cost$ - 0$ - 0$ - 0$ - 0
Allocation Base
Direct Labor$ - 0$ - 0$ - 0$ - 0
Fringe$ - 0$ - 0$ - 0$ - 0
Overhead (including any unallowable cost)$ - 0$ - 0$ - 0$ - 0
Other Direct Costs (inclusing any unallowable cost)$ - 0$ - 0$ - 0$ - 0
Total G&A Allocation Base$ - 0$ - 0$ - 0$ - 0

Rate ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!

Microsoft_Word_Document1.docx General: Offeror is to provide a cost/price proposal and accompanying narrative as part of their proposal in response to the solicitation. FAR 15.403-5(b) allows the contracting officer to specify the format of cost or pricing data or data other than certified cost or pricing data. The completed enclosed worksheets shall be part of the cost/price proposal. This is a required flow down requirement, and therefore shall be submitted for the prime offeror AND for any and all divisions and subcontractors proposed to perform effort in response to this solicitation. The information will be evaluated for acceptability, fairness, and reasonableness based on the cost/price analysis and cost realism analysis criteria in FAR 15.404-1 and FAR 52.222-46, as appropriate. Please enter the requested data in the yellow shaded areas in all Labor Detail worksheets and in the Indirect Rate Summary worksheet. The worksheets are designed to automatically compute and populate other cells in the Excel worksheets and workbooks.

Section B Worksheet: The Section B worksheet imports data from the Cost Summary worksheet and is used as a basis for the proposed formal Section B.

Cost Summary Worksheet: This worksheet is for Government analysis purposes. It is populated from all Labor Detail worksheets and the ODC Summary worksheet.

Notes 1 – 6 apply to the FD Labor - Cost Detail, OCAR Labor - Cost Detail, CompPropOff Labor - Cost Detail, and Surge Labor - Cost Detail Worksheets:

Enter the requested data in the blue shaded cells. It may be necessary for each offeror to revise the number of rows, columns, and/or formulas to reflect differences or nuances in the offeror's accounting and estimating systems. However, it is requested that the general format be maintained as much as possible for cost/price analysis and contract administration purposes.

NOTE 1: Column ‘a’ of the Labor- Detail Worksheets contains labor categories. During contract performance these categories may be performed by the prime contractor and/or other divisions or subcontractors. The offeror is to enter a P in column ‘f’ if the effort is to be performed by the prime contractor, and a S if performed by another division or subcontractor. Enter the name of the division or contractor in column ‘g’. If the particular individual category is to be performed by more than one entity, the offeror will be required to insert additional row(s) under the labor category and to allocate the column 'c' FTEs, column 'd' Estimated Productive Hours per FTE, and column ‘e’ Total Hours for the individual category among the column ‘e’ cells in the original and inserted rows to reflect the proposed performance during the contract. After this allocation, the total of the original and inserted rows under the individual category shall total to the number of hours proposed for the respective labor category.

NOTE 2: FTE = full time equivalent.

NOTE 3: Please enter the base labor rate for the labor categories listed. The base labor rate is the rate actual paid to the employee EXCLUSIVE of social security, federal unemployment, state unemployment, workman's compensation, and non-statutory fringe benefits (i.e. 401K, vacations, holidays, etc), overhead, G&A, and fee. For proprietary reasons, subcontractors may provide this information directly to the Contracting Officer if the subcontractor chooses not to disclose this information to the offeror.

NOTE 4: Apply fringe to prime offeror derived rates. "Sample Fringe Worksheet" provides a sample to be used to compute fringe.

NOTE 5: Apply fringe to prime offeror derived rates. "Sample Overhead Worksheet" provides a sample to be used to compute overhead.

NOTE 6: Please enter the prime offeror or subcontractor billing rate (if performed by a subcontractor) BEFORE application of prime offeror general and administrative (G&A) expense and fixed fee. Therefore, the rate entered for prime contractor performed rate categories is as follows: rate = prime base labor rate + prime fringe + prime overhead. If the labor category is performed by a subcontractor, the rate entered in Col j is as follows: Rate = sub base rate +sub fringe + sub overhead + sub G&A + sub fee (i.e. subcontractor loaded rate EXCEPT for prime G&A and fee).

ODC - Cost Detail Worksheet:

NOTE 7: A contract not-to-exceed amount for travel/ODCs has been specified for proposal purposes. Each offeror is to include this amount in their proposal. Any material handling and/or G&A is to be applied as appropriate. Since this is an estimated amount that may or may not occur, no fixed fee will be proposed.

Direct Labor Rate Schedule: Supporting direct labor rate worksheet. Offeror should enter all of the corresponding labor categories proposed in the labor cost detail worksheets proposed on a cost basis. For cost realism purposes, prime should indicate their basis of the proposed rates and provide documentation to substantiate the rates.

Indirect Rate Summary Worksheet: Please provide the indirect rates by year, and proposed percentage of performance by labor hour for the prime offeror and each division or subcontractor proposed to perform effort on this solicitation. For proprietary reasons, subcontractors may submit the information in the requested format directly to the Contracting Officer. This information is necessary for evaluation purposes and MUST be supplied for the offeror, other divisions, and subcontractors for the offeror's proposal to be considered complete and adequate.

Sample Fringe Worksheet: This worksheet shows a generally accepted format for overhead pool/base/rate calculations. Overhead pool, base, and rate calculations are required as part of the offeror's cost/price proposal. The overhead rates may be calculated together or separately depending on the contactor/subcontractor's accounting system. Please provide a similar schedule for overhead for each FY for the offeror and each division or subcontractor. Describe as necessary in the cost/price narrative. Please indicate if the rates are based on a forward pricing rate agreement (FPRA) or other signed rate agreement with DCAA and/or DCMA. Subcontractor data may be submitted directly to the Contracting Officer for proprietary reasons.

Sample Overhead Worksheet: This worksheet shows a generally accepted format for fringe benefit pool/base/rate calculations. Fringe benefit pool, base, and rate calculations are required as part of the offeror's cost/price proposal. The fringe rates may be calculated together or separately depending on the contactor/subcontractor's accounting system. Please provide a similar schedule for fringe for each FY for the offeror and each division or subcontractor. Describe as necessary in the cost/price narrative. Please indicate if the rates are based on a forward pricing rate agreement (FPRA) or other signed rate agreement with DCAA and/or DCMA. Subcontractor data may be submitted directly to the Contracting Officer for proprietary reasons.

Sample G&A…

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

File details come from the government source that posted it. Updated .