RPS-III_ATTACHMENT_L-3_COST_MODEL_13_JAN.xlsx

L-3a Prime&Inter Labor Rates

Company Name: (Note 1)

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

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

Attachment L-3 to RFP FA9300-15-R-0004

COST MODEL L-3a Prime and Interdivisional Labor Rates

INSTRUCTION NOTES:

ALL WHITE CELLS REQUIRE CONTRACTOR INPUT

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

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.

5 - Fiscal Year Unburdened Labor Rate: In Column D, provide the labor rate for each proposed labor classification. Starting in GFY 17, the Cost Model will automatically apply the escalation factors to the GFY 16 proposed labor rates (Base Rate) and for each GFY thereafter. Please include the escalation factor (if any) in row 24 columns E through I.

6 - Escalation: In row 24 input annual escalation rate (if applicable).

L-3b Prime&Inter Labor Hours

Company Name: (Note 1):

Prime Productive Yearly Man-Hours (Note 2)

Interdivisional Productive Yearly Man-Hours (Note 2)

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

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

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

INSTRUCTION NOTES:

1 - Company Name: Insert company name cell C23.

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

3 - Full Time Equivalents (FTEs): In unshaded Columns E though T, provide the number of FTEs for each labor classification. Note partial year period of performance in Option 1 & 2.

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-3c Sub Burdened Labor Costs

Company Name: (Note 1)

Add additional rows as necessary

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

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

COST MODEL L-3c Subcontract Burdened Labor Rates

INSTRUCTION NOTES:

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-3 to identify their costs and fee.

1 - Company Name: Insert company name cell B19.

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 17, the Cost Model will automatically apply the escalation factors to the GFY 16 proposed labor rate and for each GFY thereafter.

L-3d Sub Labor Hours

Company Name: (Note 1)

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

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

COST MODEL L-3d Subcontract Labor Hours

INSTRUCTION NOTES:

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-3 to identify their costs and fee.

1 - Company Name: Insert company name cell B24.

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. Note partial year period of performance in Option 1 & 2.

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-3e Total Costs

Company Name: (Note 1)

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

OTHER DIRECT COSTS (Material/Travel) (Note 11) $ 3,285,717 $ 3,285,717 $ 3,285,717 $ 3,519,650 $ 1,759,825 $ 1,794,673 $16,931,298

SUBTOTAL (Prime, Interdivisional labor, Overhead, total Subcontractor, and ODCs) $ 3,285,717 $ 3,285,717 $ 3,285,717 $ 3,519,650 $ 1,759,825 $ 1,794,673 16,931,298

SUBTOTAL (Prime, Interdivisional Labor, Overhead, total Subcontracts, ODCs and G&A) $3,285,717 $3,285,717 $3,285,717 $3,519,650 $1,759,825 $1,794,673 $16,931,298

Fixed Fee: Fixed Fee (Note 10): $0 $0 $0 $0 $0 $0 $0

FACILITIES CAPITAL COST OF MONEY (Note 8) $0

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

TOTAL (All Costs and Award Fee) $3,285,717 $3,285,717 $3,285,717 $3,519,650 $1,759,825 $1,794,673 $16,931,298

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

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

COST MODEL L-3e Total Costs

INSTRUCTION NOTES:

1 - Company Name: Insert company name cell C37.

2 - Labor Overhead Rates: In Columns E through J, 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 J. 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 J, 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. Provide supporting information concerning factors and bases used.

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

10 - Fixed-Fee: Insert Fixed Fee percentage in Cell C186. The Fixed Fee calculation in Row 186 excludes ODCs (material/travel).

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.

L-3f Cost Element Summary

Company Name: (Note 1)

Other Direct Costs $ 3,285,717 $ 3,285,717 $ 3,285,717 $ 3,519,650 $ 1,759,825 $ 1,794,673 $ 16,931,298

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

Fixed Fee $ - $ - $ - $ - $ - $ - $ -

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

Phase in price $ -

Total of all Costs/Price and Fixed Fee $ 3,285,717 $ 3,285,717 $ 3,285,717 $ 3,519,650 $ 1,759,825 $ 1,794,673 $ 16,931,298

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

COST MODEL L-3f Cost Element Summary

INSTRUCTION NOTES:

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 - H19, 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”