ATTACHMENT L-7 COST MODEL amendment 01.xlsx

XLSX spreadsheet 3 MB Posted

Attached to
Advanced Research and Engineering Services (ARES) III Federal contract opportunity
Solicitation number
FA9300-11-R-0002
Issued by
Department of the Air Force Materiel Command Test Center

About this file

ATTACHMENT L-7 COST MODEL amendment 01

View the file

Other files for this federal contract opportunity

Other files attached to Advanced Research and Engineering Services (ARES) III, newest first.
File Type Posted
ARES III - Final RFP Cover Sheet amendment 05.pdf PDF
ARES Q A no 5.doc DOC document
ARES III - Final RFP Cover Sheet amendment 04.pdf PDF
ATTACHMENT L-7 COST MODEL amendment 04.xlsx XLSX spreadsheet
ARES III - Final RFP QandA no 4.pdf PDF
ARES III - Final RFP Cover Sheet amendment 03.pdf PDF
ARES III - Final RFP QandA no 3.pdf PDF
ATTACHMENT L-7 COST MODEL amendment 03.xlsx XLSX spreadsheet
ARES III - Final RFP QandA no 2.pdf PDF
ARES III - Final RFP Cover Sheet amendment 02.pdf PDF
ARES III - Final RFP amendment 02.pdf PDF
ATTACHMENT L-4 PAST PERFORMANCE QUESTIONNAIRE amendment 01.docx DOCX document
ARES III Final RFP amendment 01.pdf PDF
ARES III - Final RFP QandA.pdf PDF
ARES III - Final RFP Cover Sheet amendment 01.pdf PDF
ARES III - Final RFP.pdf PDF
ATTACHMENT L-2 SCENARIOS COST SUMMARY BY COST ELEMENTS.xlsx XLSX spreadsheet
ATTACHMENT L-7 COST MODEL.xlsx XLSX spreadsheet
ARES III - QandA no.3.pdf PDF
ARES III - QandA no.2.pdf PDF
ARES III - QandA.pdf PDF
ARES III Industry Day Minutes-Attendees-Slides.pdf PDF
ARES III - Draft RFP.pdf PDF
ARES III - Industry Day Feedback Question Form.pdf PDF
ARES III - Industry Day Individual Session Timeslots.pdf PDF
ARES III - Draft RFP.pdf PDF
Industry Day Announcement - 9-May-2011.pdf PDF
Map to AFRL.pdf PDF
ARES III SOW 04NOV09.doc DOC document
Show all 29

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

L-7a Prime&Inter Labor Rates

Company Name: (Note 1)Year and Inflation Rate
BaseOption 1Option 2
LABOR CLASSIFICATION (Note 2)SALARY CODE DESIGNATOR (Note 3)PRIME or INTERDIVISIONAL TRANSFER (Note 4)12 (Note 5)13141415161617
Base Rate1.02001.02001.02001.02001.02001.02001.0200
$ - 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$ - 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$ - 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$ - 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$ - 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$ - 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$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Part-Time
$ - 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$ - 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$ - 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$ - 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$ - 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$ - 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$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Provide description of cost model changes, if any (see Section L Instructions to Offerors, paragraph 6.1.5):

Provide justification of Cost if necessary (see Section L Instructions to Offerors, paragraph 6.1.5):

COST MODEL L-7a Prime and Interdivisional Labor Rates

INSTRUCTION NOTES:

1 - Company Name: Insert company name at Cell B21.

2 - Labor Classification: In Column A, identify each labor classification being proposed.

3 - Salary Code Designator: In Column B, provide a salary code designator for each labor classification being proposed.

4 - Source of Labor: In Column C, indicate whether the proposed labor is prime or interdivisional transfer. For subcontracts <$12,500,000 (including basic and option performance periods) use Attachment L-6c to identify fully burdened (wrap rate) hourly labor costs. For subcontracts > $12,500,000 or 10% or more of the prime contractor's proposed price (including basic and option performance periods) use a separate Attachment L-6 to identify their costs and fee. The Prime contractor shall place the total subcontract cost, on a separate line for each subcontract of $12,500,000 or over, in the Total Cost worksheet L-6e, 5 - Fiscal Year Unburdened Labor Rate: In Column D, provide the labor rate for each proposed labor classification. Starting in GFY 13, the Cost Model will automatically apply the escalation factors to the GFY 12 proposed labor rates (Base Rate) and for each GFY thereafter.

L-7b Prime&Inter Labor Hours

Company Name: (Note 1)
Need to account for partial year and any phase-in time
Prime Productive Yearly Man Hours (Note 2)
Interdivisional Productive Yearly Man Hours (Note 2)0Year 1 Productive Man Year Hours (Note 3)
Last Productive Man Year Hours (Note 3)
BaseOption 1Option 2
LABOR CLASSIFICATIONSALARY CODE DESIGNATORPRIME or INTERDIVISIONAL TRANSFERFTEs (Note 3)LABOR HOURSFTEsLABOR HOURSFTEsLABOR HOURSFTEsLABOR HOURSFTEsLABOR HOURSFTEsLABOR HOURSFTEsLABOR HOURSFTEsLABOR HOURSTOTAL FTEsTOTAL LABOR HOURS
12121313141414141515161616161717
14Jul12-30Sep121Oct12-30Sep131Oct13-30Jun141Jul14-30Sep141Oct14-30Sep151Oct14-30Jun161Jul16-30Sep161Oct16-30Jun17
100- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
200- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
300- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
400- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
500- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
600- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
700- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
800- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
900- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
1000- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
1100- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
1200- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
1300- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
1400- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
1500- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
1600- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
1700- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
1800- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
1900- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
2000- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
2100- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
2200- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
2300- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
2400- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
2500- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
2600- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
2700- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
2800- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
2900- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
3000- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
3100- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
3200- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
3300- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
3400- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
3500- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
3600- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
3700- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
3800- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
3900- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
4000- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
4100- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
4200- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
4300- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
4400- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
4500- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
4600- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
4700- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
4800- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
PART-TIME
1- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
2- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
3- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
4- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
5- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
6- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
7- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
8- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
9- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
10- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
11- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
12- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
13- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
14- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
15- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
16- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
17- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
18- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
19- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
20- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
21- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
22- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
23- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
24- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
25- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
26- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
27- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
28- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
29- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
30- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
31- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
32- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
33- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
34- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
35- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
36- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
37- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
38- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
39- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
40- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
41- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
42- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
43- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
44- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
45- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
46- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
47- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
48- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Add additional rows as necessary
SUBTOTAL- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0

Provide description of cost model changes, if any (see Section L Instructions to Offerors, paragraph 6.1.5):

Provide justification of Cost if necessary (see Section L Instructions to Offerors, paragraph 6.1.5):

Provide description of cost model changes, if any (see Section L Instructions to Offerors, paragraph 6.1.5):

COST MODEL L-7b Prime and Interdivisional Direct Labor Hours

1 - Company Name: Insert company name where requested.

2 - Productive Man-year Hours: In Cells D25 and D27 insert the annual productive man-year hours for prime and interdivisional.

3 - Year 1 Productive Man-year Hours: The first year of the basic period of performance is only 11 weeks versus 52 (year1 is 14Jul 2012 through 30 Sep 2012); adjust Productive Man-year hours accordingly in Cell J27. The last year (Option Period 2) period of performance is only 39 weeks versus 52 (the final year is 1 Oct 2016 through 30 Jun 2017); adjust Productive Man-year hours accordingly in Cell J28.

4 - Full Time Equivalents (FTEs): In unshaded Columns E though T, provide the number of FTEs for each labor classification.

AUTOMATIC COMPUTATIONS:

Labor Classification: The Labor Classification will automatically read from the Prime&Inter Labor Rates worksheet.

Salary Code Designator: The Salary Code will automatically read from the Prime&Inter Labor Rates worksheet.

Labor Hours by Fiscal Year: The worksheet will automatically multiply Cell D25 (Cell J27 for Year 1 of the basic period) by the number of annual FTEs identified. If interdivisional manyear hours are different than prime, adjust Labor Hours calculation accordingly.

L-7c Subcontract Labor Costs

Company Name: (Note 1)
BaseOption 1Option 2
LABOR CLASSIFICATION (Note 2)SALARY CODE DESIGNATOR (Note 3)SUBCONTRACTOR NAME (Note 4)12 (Note 5)13141415161617
Base Rate1.02001.02001.02001.02001.02001.02001.0200
$ - 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$ - 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

Add additional rows as necessary

Provide description of cost model changes, if any (see Section L Instructions to Offerors, paragraph 6.1.5):

Provide justification of Cost if necessary (see Section L Instructions to Offerors, paragraph 6.1.5):

COST MODEL L-7c Subcontract Labor Costs

This worksheet is for subcontracts valued at less than $12,500,000 (including basic and option performance periods). Subcontracts valued at $12,500,000 or over (including basic and option performance periods) shall use a separate Attachment L-6 to identify their costs and fee.

1 - Company Name: Insert company name where requested.

2 - Labor Classification: In Column A, identify each subcontractor labor classification being proposed.

3 - Salary Code Designator: In Column B, provide a salary code designator for each labor classification being proposed.

4 - Subcontractor Name: Insert the name of the subcontractor (firm).

5 - Fiscal Year Fully Burdened Labor Costs: In Column D, provide the fully burdened labor costs (Subcontractor burdens to include fee) for each labor classification. Starting in GFY 13, the Cost Model will automatically apply the escalation factors to the GFY 12 proposed labor rate (Base Rate) and for each GFY thereafter.

L-7d Subcontract Labor Hours

Company Name: (Note 1) Need to account for partial year and phase-in time

BaseOption 1Option 2
LABOR CLASSIFICATIONSALARY CODE DESIGNATORSUBCONTRACTOR NAMEPRODUCTIVE YEARLY MAN HOURS (Note 2)FTEs (Note 3)LABOR HOURSFTEsLABOR HOURSFTEsLABOR HOURSFTEsLABOR HOURSFTEsLABOR HOURSFTEsLABOR HOURSFTEsLABOR HOURSFTEsLABOR HOURSTOTAL FTEsTOTAL LABOR HOURS
12121313141414141515161616161717
000- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
000- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
000- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
000- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
000- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
000- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
000- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
000- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
000- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
000- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
000- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Add additional rows as necessary
SUBTOTAL- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0

Provide description of cost model changes, if any (see Section L Instructions to Offerors, paragraph 6.1.5):

Provide description of cost model changes, if any (see Section L Instructions to Offerors, paragraph 6.1.5):

COST MODEL L-7d Subcontract Labor Hours

This worksheet is for subcontracts valued at less than $12,500,000 (including basic and option performance periods). Subcontracts > $12,500,000 or 10% or more of the prime contractor's proposed price (including basic and option performance periods) shall use a separate Attachment L-6 to identify their costs and fee.

1 - Company Name: Insert company name where requested.

2 - Productive Yearly Man-Hours: In Column D, insert the annual productive man-year hours for each subcontracted labor classification.

3 - Full Time Equivalents (FTEs): In unshaded columns E through T, provide the number of FTEs for each labor classification.

4 - Note: The first year of the basic period of performance is only 50 weeks versus 52 (year 1 is 14 Jul 2012 through 30 Jun 2013); adjust accordingly.

Labor Classification: The Labor Classification will automatically flow from the Subcontract Labor Costs worksheet.

Salary Code Designator: The Salary Code will automatically flow from the Subcontract Labor Costs worksheet.

Labor Hours by Fiscal Year: The worksheet will automatically multiply the productive yearly man hours in Column D by the number of annual FTEs identified in Columns E through T.

L-7e Total Costs

Company Name: (Note 1)

COSTS BY YEAR
BaseOption 1Option 2
Prime & Interdivisional Labor Only1213141415161617
PRIME & INTERDIVISIONAL LABOR CLASSIFICATIONSALARY CODE DESIGNATORPRIME or INTERDIVISIONAL TRANSFERTOTALS
1000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
2000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
3000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
4000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
5000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
6000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
7000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
8000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
9000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
10000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
11000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
12000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
13000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
14000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
15000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
16000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
17000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
18000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
19000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
20000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
21000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
22000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
23000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
24000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
25000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
26000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
27000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
28000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
29000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
30000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
31000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
32000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
33000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
34000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
35000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
36000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
37000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
38000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
39000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
40000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
41000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
42000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
43000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
44000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
45000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
46000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
47000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
48000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
Part-Time
1000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
2000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
3000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
4000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
5000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
6000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
7000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
8000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
9000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
10000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
11000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
12000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
13000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
14000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
15000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
16000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
17000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
18000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
19000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
20000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
21000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
22000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
23000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
24000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
25000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
26000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
27000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
28000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
29000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
30000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
31000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
32000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
33000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
34000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
35000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
36000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
37000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
38000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
39000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
40000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
41000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
42000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
43000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
44000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
45000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
46000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
47000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
48000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
Add additional rows as necessary
SUBTOTAL (Prime & Interdivisional Labor Costs)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-
Overhead Rates (Note 2) (Enter overhead rate in percent per fiscal year)0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%
Fringe (Full Time)0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%
Fringe (Part Time)0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%
Overhead Costs (Note 3)--------
SUBTOTAL (Prime & Interdivisional Labor and Overhead Costs) (Note 4)$0$0$0$0$0$0$0$0$0
Base FEE @ 3%$ -$ -$ -$ -$ -$ -$ -$ -$0
Performance Incentive FEE @ 4%$ -$ -$ -$ -$ -$ -$ -$ -$0
Subcontract Fully Burdened Labor Costs<$12,500,000
SUBCONTRACT LABOR CLASSIFICATIONSALARY CODE DESIGNATORSUBCONTRACTOR NAMETOTALS
000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ -
000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ -
000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ -
000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ -
000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ -
000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ -
000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ -
000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ -
000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ -
000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ -
000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ -

SUBTOTAL (Subcontract Fully Burdened Labor Costs <$12,500,000) (Note 5) - - - - - - - - -

G&A ON SUBCONTRACTOR COSTS (Note 10) $ - $ - $ - $ - $ - $ - $ - $ - $0

SUBTOTAL (Prime, Interdivisional and Subcontract (<$12,500,000) Labor Costs) $ - $ - $ - $ - $ - $ - $ - $ - $ -

Subcontractor >$12,500,000 or >10% of Labor Costs listed separately (Note 6)SUBCONTRACTOR NAME$ -$ -$ -$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -$ -$ -$ -
SubTotal$ -$ -$ -$ -$ -$ -$ -$ -$ -

OTHER DIRECT COSTS $ 131,852 $ 611,077 $ 467,121 $ 155,707 $ 634,580 $ 485,454 $ 161,818 $ 495,163 $3,142,772

SUBTOTAL (Fully Burdened Labor Costs, Subcontractor >$12,500,000 or >10% of Labor Costs and ODCs) $ 131,852 $ 611,077 $ 467,121 $ 155,707 $ 634,580 $ 485,454 $ 161,818 $ 495,163 3,142,772

G&A 1 (Enter rate in percent per year) (Note 7)100.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%
G&A$0$0$0$0$0$0$0$0$0

TOTAL G&A COSTS $0 $0 $0 $0 $0 $0 $0 $0 $0

SUBTOTAL ( Fully Burdened Labor Costs, Subcontracts, ODCs and G&A) $131,852 $611,077 $467,121 $155,707 $634,580 $485,454 $161,818 $495,163 $3,142,772

FACILITIES CAPITAL COST OF MONEY (Note 8) $ - $ - $ - $ - $ - $ - $ - $ - $0

FIRM FIXED-PRICE TRANSITION PERIOD (Note 9) $ -

TOTAL (All Costs and Award Fee) $ - $131,852 $611,077 $467,121 $155,707 $634,580 $485,454 $161,818 $495,163 $3,142,772

Provide description of cost model changes, if any (see Section L Instructions to Offerors, paragraph 6.1.5):

Provide justification of Cost if necessary (see Section L Instructions to Offerors, paragraph 6.1.5):

COST MODEL L-7e Total Costs

1 - Company Name: Insert company name where requested.

2 - Labor Overhead Rates: In Columns E through L, provide the labor overhead rates. If more than one Overhead rate is applied to labor costs, insert the additional overhead rates and formulas, as necessary.

3 - Overhead Costs: Tailor the worksheet, as necessary, to reflect the application of Overhead rates to show the total labor Overhead costs.

4 - Subtotal for Prime & Interdivisional Labor Costs: Tailor the worksheet to calculate the subtotal for labor and overhead costs.

5 - Subtotals for Subcontracts <$12,500,000: Provide subtotals for each Subcontractor used. Tailor this section of the model as required.

6 - Subcontracts > $12,500,000 or 10% or more of the prime contractor's proposed price : For each Subcontract > $12,500,000 or 10% or more of the prime contractor's proposed price , provide the Subcontractor's Name in Column D, and the annual amount proposed in columns E through L. For each Subcontract > $12,500,000 or 10% or more of the prime contractor's proposed price , provide a separate L-6 cost model as supporting information. Copy the worksheets within Attachment L-6 Cost Model and rename.

7 - G&A: In Columns E through L, provide the G&A rate for each year. If there is more than one application of G&A, identify and compute additional G&A rates as necessary.

8 - Facilities Capital Cost of Money: Insert any proposed FCCM by GFY.

9 - Transition Period Price: Provide a total for the proposed firm fixed-price Transition Period.

10 - G&A on Subcontractor Costs: Insert proposed G&A rate (if any) on D169

Labor Classification: The Labor Classification will automatically flow from the Subcontract Labor Costs worksheet.

Salary Code Designator: The Salary Code will automatically read from the Subcontract Labor Costs worksheet.

Prime & Interdivisional Labor Costs: The formula will sum the salaries of all labor classifications.

Subcontract Labor Costs: The formula will sum the salaries of all subcontract labor classifications.

Total of All Labor Costs: The formula will sum all of the labor costs subtotals.

Total ODC: Totals for ODCs are Government provided estimates. No alterations of base ODC values are authorized.

Base Fee: Fee is 3% Prime Labor Costs.

Performance Incentive Fee: Incentive fee is 4% of Prime Labor Costs

L-7f Cost Element Summary

Company Name: (Note 1)

Cost ElementBaseOption 1Option 2
Phase In Period1213141415161617Total
Prime & Interdivisional Labor Hours- 0- 0- 0- 0- 0- 0- 0- 0- 0
Subcontractor <$12,500,000 Labor Hours- 0- 0- 0- 0- 0- 0- 0- 0- 0
Subcontractor >$12,500,000 or >10% of Labor Costs
Total Labor Hours- 0- 0- 0- 0- 0- 0- 0- 0- 0
Prime & Interdivisional Labor Costs$ -$ -$ -$ -$ -$ -$ -$ -$ -
Subcontractor <$12,500,000 Labor Costs$ -$ -$ -$ -$ -$ -$ -$ -$ -
Subcontractor >$12,500,000 or >10% of Labor Costs$ -$ -$ -$ -$ -$ -$ -$ -$ -
Total Labor Cost$ -$ -$ -$ -$ -$ -$ -$ -$ -

Other Direct Costs $ 131,852 $ 611,077 $ 467,121 $ 155,707 $ 634,580 $ 485,454 $ 161,818 $ 495,163 $ 3,142,772

G&A $ - $ - $ - $ - $ - $ - $ - $ - $ -

Base Fee @ 3% $ - $ - $ - $ - $ - $ - $ - $ - $ -

Performance Incentive Fee @4 % $ - $ - $ - $ - $ - $ - $ - $ -

Subcontractor fee $ - $ - $ - $ - $ - $ - $ - $ -

Facilities Capital Cost of Money $ - $ - $ - $ - $ - $ - $ - $ - $ -

Phase in price $ - 0

Total of all Costs/Price and Award Fee $ - $ 131,852 $ 611,077 $ 467,121 $ 155,707 $ 634,580 $ 485,454 $ 161,818 $ 495,163 $ 3,142,772

Total Base$ 1,210,050
Total Option 1$ 1,275,741
Total Option 2$ 656,981
Total$ 3,142,772

Provide description of cost model changes, if any (see Section L Instructions to Offerors, paragraph 6.1.5):

COST MODEL L-7f Cost Element Summary

1- Company Name

This worksheet will serve as a summary of your total effort by cost element. All fields are self-populating with the exception of:

Cells C19 - J19, Subcontractor >$12,500,000 Hours, enter the total of Subcontractor Labor Hours for all Subcontracts > $12,500,000 or > 10% or more of the prime contractor's proposed price”

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