Attachment_3_-_Fixed_Fully_Burdened_Labor_Rate_Buildup.xls

XLS spreadsheet 241 KB Posted

Attached to
Battle Command Training Capability - Equipment Support (BCTC-ES) Competition
Solicitation number
W900KK-17-R-0013
Issued by

About this file

Attachment 3 - Fixed Fully Burdened Labor Rate Buildup

View the file

Other files

File Type Posted
Attachment_4_-_Scenario_Cost-Price_Workbook_(Amend_002).xlsx XLSX spreadsheet
W900KK-17-R-0013_Conformed_Copy_through_Amend_0002.pdf PDF
Offeror_Questions_and__Government_Answers_for_Amend_0002.pdf PDF
Attachment_2_-_Cost-Price_Workbook_(Amend_0002).xlsx XLSX spreadsheet
Attachment_9_-_PAST_PERFORMANCE_EVALUATION_QUESTIONNAIRE_FORM_(Amend_0002).docx DOCX document
Attachment_8_Performance_Work_Statement_(Amend_0002).docx DOCX document
Attachment_10_-_Draft_Authorization_to_use_FSS_and_Army_CHESS_(Amend_0002).doc DOC document
W900KK-17-R-0013_Amend_0002.pdf PDF
Attachment_9_-_PAST_PERFORMANCE_EVALUATION_QUESTIONNAIRE_FORM.docx DOCX document
W900KK-17-R-0013_Amendment_0001.pdf PDF
Attachment_2_-_Cost-Price_Workbook.xlsx XLSX spreadsheet
Attachment_6_-_Question_Comment_Form.xlsx XLSX spreadsheet
Exhibit_A_-_CDRLs.pdf PDF
W900KK-17-R-0013_Released_4_April_2017.pdf PDF
Attachment_4_-_Scenario_Cost-Price_Workbook.xlsx XLSX spreadsheet
Attachment_1_-_BCTC-ES_FFE_Packages_S_M_L_MTC.xlsx XLSX spreadsheet
Attachment_7_Security_Form_DD254.pdf PDF
Attachment_5_-_Data_Item_Transmittal_Form.doc DOC document
Attachment_8_Performance_Work_Statement.pdf PDF
W900KK17R0013DRFPQuestions.xlsx XLSX spreadsheet
Official_Draft_Solicitation_W900KK-17-R-0013_BCTC-ES_121316.docx DOCX document
Attachment_3_-_Fixed_Fully_Burdened_Labor_Rate_Buildup.xls XLS spreadsheet
Attachment_1_-_BCTC-ES_FFE_Packages_S,_M,_L_MTC.xlsx XLSX spreadsheet
Attachment_2_-_Cost-Price_Workbook.xlsx XLSX spreadsheet
Attachment_4_-_Scenario_Cost-Price_Workbook.xlsx XLSX spreadsheet
Show all 25

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

Instructions

Base Year

FIXED FULLY BURDENED LABOR RATE BUILD UP - BASE CONTRACT YEAR
LABOR CATEGORYBase Labor Rate, $ Per HourFringe % = (C70)Labor With Fringe $ = C*(1+F)O/H % = (C71)Labor With O/H $ = G*(1+H)G&A % = (C72)Labor With G&A $ = I*(1+J)Profit % = C73Cost of Money = C75Fully Burdened Labor Rate = K*(1+L)+M
1$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
2$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
3$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
4$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
5$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
6$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
7$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
8$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
9$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
10$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
11$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
12$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
13$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
14$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
15$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
16$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
17$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
18$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
19$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
20$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
21$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
22$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
23$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
24$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
25$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
26$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
27$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
28$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
29$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
30$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
31$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
32$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
33$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
34$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
35$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
36$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
37$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
38$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
39$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
40$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
41$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
42$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
43$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
44$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
45$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
46$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
47$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
48$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
49$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
50$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
51$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
52$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
53$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
54$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
55$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
56$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
57$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
58$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
59$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
Indirect/Escalation/Profit Rates for Base Year
Escalation % (for Direct Labor)MATERIAL$ 500,000
Fringe0.00%MATERIAL HANDLING0.00%$ - 0
Overhead0.00%MATERIAL G&A BASE$ 500,000
G&A0.00%G&A (if applicable)0.00%$ - 0
Profit0.00%MATERIAL TOTAL$500,000
Material Handling0.00%
Cost of Money$0.00TRAVEL$ 500,000
G&A0.00%- 0
TRAVEL TOTAL$500,000

&C

Option 1

FIXED FULLY BURDENED LABOR RATE BUILD UP - CONTRACT OPTION YEAR 1
LABOR CATEGORYBase Labor Rate, $ Per Hour =Year 1Escal. % =C69Labor With Escal. $ =C*(1+D)Fringe % = (C70)Labor With Fringe $ = C*(1+F)O/H % = (C71)Labor With O/H $ = G*(1+H)G&A % = (C72)Labor With G&A $ = I*(1+J)Profit % = C73Cost of Money = C75Fully Burdened Labor Rate = K*(1+L)+M
10$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
20$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
30$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
40$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
50$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
60$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
70$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
80$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
90$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
100$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
110$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
120$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
130$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
140$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
150$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
160$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
170$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
180$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
190$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
200$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
210$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
220$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
230$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
240$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
250$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
260$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
270$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
280$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
290$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
300$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
310$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
320$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
330$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
340$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
350$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
360$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
370$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
380$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
390$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
400$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
410$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
420$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
430$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
440$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
450$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
460$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
470$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
480$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
490$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
500$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
510$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
520$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
530$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
540$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
550$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
560$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
570$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
580$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
590$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
Indirect/Escalation/Profit Rates for Option Year One
Escalation % (for Direct Labor)0.00%MATERIAL$ 500,000
Fringe0.00%MATERIAL HANDLING0.00%$ - 0
Overhead0.00%MATERIAL G&A BASE$ 500,000
G&A0.00%G&A (if applicable)0.00%$ - 0
Profit0.00%MATERIAL TOTAL$500,000
Material Handling0.00%
Cost of Money$0.00TRAVEL$ 500,000
G&A0.00%- 0
TRAVEL TOTAL$500,000

&C

Option 2

FIXED FULLY BURDENED LABOR RATE BUILD UP - CONTRACT OPTION YEAR 2
LABOR CATEGORYBase Labor Rate, $ Per Hour = Year 2Escal. % =C69Labor With Escal. $ =C*(1+D)Fringe % = (C70)Labor With Fringe $ = C*(1+F)O/H % = (C71)Labor With O/H $ = G*(1+H)G&A % = (C72)Labor With G&A $ = I*(1+J)Profit % = C73Cost of Money = C75Fully Burdened Labor Rate = K*(1+L)+M
10$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
20$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
30$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
40$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
50$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
60$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
70$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
80$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
90$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
100$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
110$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
120$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
130$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
140$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
150$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
160$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
170$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
180$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
190$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
200$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
210$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
220$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
230$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
240$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
250$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
260$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
270$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
280$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
290$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
300$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
310$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
320$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
330$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
340$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
350$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
360$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
370$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
380$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
390$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
400$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
410$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
420$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
430$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
440$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
450$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
460$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
470$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
480$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
490$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
500$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
510$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
520$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
530$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
540$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
550$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
560$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
570$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
580$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
590$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
Indirect/Escalation/Profit Rates for Option Year 2
Escalation % (for Direct Labor)0.00%MATERIAL$ 500,000
Fringe0.00%MATERIAL HANDLING0.00%$ - 0
Overhead0.00%MATERIAL G&A BASE$ 500,000
G&A0.00%G&A (if applicable)0.00%$ - 0
Profit0.00%MATERIAL TOTAL$500,000
Material Handling0.00%
Cost of Money$0.00TRAVEL$ 500,000
G&A0.00%- 0
TRAVEL TOTAL$500,000

&C

Option 3

FIXED FULLY BURDENED LABOR RATE BUILD UP - CONTRACT OPTION YEAR 3
LABOR CATEGORYBase Labor Rate, $ Per Hour = Year3CEscal. % =C69Labor With Escal. $ =C*(1+D)Fringe % = (C70)Labor With Fringe $ = C*(1+F)O/H % = (C71)Labor With O/H $ = G*(1+H)G&A % = (C72)Labor With G&A $ = I*(1+J)Profit % = C73Cost of Money = C75Fully Burdened Labor Rate = K*(1+L)+M
10$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
20$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
30$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
40$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
50$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
60$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
70$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
80$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
90$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
100$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
110$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
120$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
130$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
140$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
150$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
160$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
170$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
180$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
190$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
200$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
210$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
220$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
230$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
240$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
250$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
260$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
270$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
280$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
290$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
300$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
310$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
320$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
330$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
340$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
350$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
360$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
370$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
380$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
390$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
400$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
410$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
420$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
430$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
440$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
450$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
460$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
470$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
480$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
490$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
500$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
510$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
520$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
530$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
540$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
550$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
560$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
570$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
580$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
590$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
Indirect/Escalation/Profit Rates for Option Year 3
Escalation % (for Direct Labor)0.00%MATERIAL$ 500,000
Fringe0.00%MATERIAL HANDLING0.00%$ - 0
Overhead0.00%MATERIAL G&A BASE$ 500,000
G&A0.00%G&A (if applicable)0.00%$ - 0
Profit0.00%MATERIAL TOTAL$500,000
Material Handling0.00%
Cost of Money$0.00TRAVEL$ 500,000
G&A0.00%- 0
TRAVEL TOTAL$500,000

Option 4

FIXED FULLY BURDENED LABOR RATE BUILD UP - CONTRACT OPTION YEAR 4
LABOR CATEGORYBase Labor Rate, $ Per Hour = Year4CEscal. % =C69Labor With Escal. $ =C*(1+D)Fringe % = (C70)Labor With Fringe $ = C*(1+F)O/H % = (C71)Labor With O/H $ = G*(1+H)G&A % = (C72)Labor With G&A $ = I*(1+J)Profit % = C73Cost of Money = C75Fully Burdened Labor Rate = K*(1+L)+M
10$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
20$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
30$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
40$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
50$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
60$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
70$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
80$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
90$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
100$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
110$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
120$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
130$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
140$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
150$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
160$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
170$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
180$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
190$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
200$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
210$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
220$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
230$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
240$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
250$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
260$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
270$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
280$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
290$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
300$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
310$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
320$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
330$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
340$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
350$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
360$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
370$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
380$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
390$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
400$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
410$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
420$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
430$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
440$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
450$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
460$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
470$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
480$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
490$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
500$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
510$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
520$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
530$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
540$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
550$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
560$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
570$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
580$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
590$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00$0.00
Indirect/Escalation/Profit Rates for Option Year 4
Escalation % (for Direct Labor)0.00%MATERIAL$ 500,000
Fringe0.00%MATERIAL HANDLING0.00%$ - 0
Overhead0.00%MATERIAL G&A BASE$ 500,000
G&A0.00%G&A (if applicable)0.00%$ - 0
Profit0.00%MATERIAL TOTAL$500,000
Material Handling0.00%
Cost of Money$0.00TRAVEL$ 500,000
G&A0.00%- 0
TRAVEL TOTAL$500,000

&C

MBD00252BB0.doc Instructions for completing the Fixed Fully Burdened Labor Rate Worksheet

1. Offeros shall provide information for all areas highlighted in yellow.

a. Offerors shall provide the naming convention of the labor category proposed in column B.

b. For each labor category listed in year one, the Offeror shall provide the direct labor rate in column c.

i. The direct labor rate from the base year will populate Option Year 1.

ii. The direct labor rate from the Option Year 1 will populate Option Year 2.

iii. The direct labor rate from the Option Year 2 will populate Option Year 3.

iv. The direct labor rate from the Option Year 3 will populate Option Year 4.

c. In cells C65 – C70, the Offeror shall provide the applicable rates (in %) for the specified year. Rates provided in this section will automatically populate applicable areas in the spreadsheet.

d. In cell C71, the offeror shall insert, if applicable, the amount ($0.00) for the specified year.

e. In cell J68, the offeror shall insert, if applicable, the rate (in %) for each contract year. If the offeror’s accounting structure is such that G&A is not applicable, the offeror shall insert 0%.

f. Offerors may add more labor category lines if necessary.

2. Offerors shall populate each tab of the spreadsheet (base year – Option Year 4).

3. Offerors shall not change the numbers provided for Material and Travel. This is for evaluation purposes only.

4. An Offeror may tailor the Fixed Fully Burdened Labor Rate spreadsheet to depict the application of their indirect rates if different than what is depicted. A tailored spreadsheet is also authorized for those companies that have divisional rate differences (multiple cost centers for the same labor category) within one company. In this case, Offerors should provide each rate and a differentiated description for each (i.e. Software Engineer 1 = $20.00, Software Engineer 1A = $21.00). If a tailored spreadsheet is used, the offeror shall ensure the spreadsheet provides all the formulas for all calculations.

5. Offerors shall provide only one Fixed Fully Burdened Labor Rate Build Up workbook for evaluation.

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