A07_SolicAttach-J.7_Cost_Model_121317.xlsx

INSTRUCTIONS

INSTRUCTIONS

ALL CELLS HIGHLIGHTED IN YELLOW WILL BE POPULATED FROM OTHER TABS OR AUTOMATICALLY CALCULATED

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 spreadsheets 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 proposed costs and prices will be evaluated for completeness, acceptability, fairness, and reasonableness based on the cost/price analysis criteria in FAR 15.404-1. Only cost CLINs will be evaluated for realism. Please enter the requested data in the light blue shaded areas in the Section B, Cost summary, Labor CLIN spreadsheets, the Fringe, Overhead and G & A spreadsheets and in the ODC Detail spreadsheet. The spreadsheets are designed to automatically compute and populate other cells in the Excel spreadsheets and workbooks. Fixed price CLINs will be evaluated based on the TEP Matrix, therefore those amounts should be copied directly to the Section B tab.

Section B Worksheet: The Section B worksheet imports data from the Cost Summary, Labor- Cost Spreadsheets and ODC Summary spreadsheet and is used as a basis for the proposed formal Section B.

Cost Summary Worksheet: This spreadsheet is for Government analysis purposes. It is populated from the Transition In/out spreadsheet, Labor-Cost Detail spreadsheet and the ODC – Cost Detail spreadsheet.

NOTE 1: A contract normalized amount for CLINs 0031 and 0032 has been specified for proposal purposes. Each offeror is to include this amount in their proposal. If awarded, individual task orders will specify the scope of work, schedule and cost.

Labor-Cost Detail Worksheets:

General: 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 2: FTE = full time equivalent.

NOTE 3: Column a of the Labor- Detail Spreadsheets contains labor categories. During contract performance these categories ostensibly may be performed by the prime contractor and/or other divisions or subcontractors. The offeror is to enter a P in Col e if the effort is to be performed by the prime contractor, and an S if performed by another division or subcontractor. Enter the name of the division or contractor in Col f. 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 Col d hours for the individual category among the Col d 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 4: 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 overhead, G&A, and fee. For proprietary reason, subcontractors may provide this information directly to the Contracting Officer if the subcontractor chooses not to disclose this information to the offeror.

NOTE 5: Apply fringe/overhead to prime offeror derived rates. These amounts are populated from the “Indirect Rate Summary“ tab, which is populated from the detail provided in the "Sample Fringe-OH Worksheet".

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 Spreadsheet: Provide summary costs for ODCs applicable to CLINs 0001 and 0002. Provided details of the ODC cost in a separate tab.

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 each division or subcontractor proposed to perform effort on this solicitation. The rates for the Prime contractor will populate from the Fringe, Overhead and G &A worksheets. 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. If your accounting system does not estimate ten years out, you may use the rates for the last year estimated for the out years.

Sample Fringe/Overhead Worksheet: This spreadsheet shows a generally accepted format for fringe benefit and/or overhead pool/base/rate calculations and is designed to populate the Indirect Rate Summary tab. Fringe benefit and overhead pool, base, and rate calculations are required as part of the offeror's cost/price proposal. The fringe and overhead rates may be calculated together or separately depending on the contactor/subcontractor's accounting system. Please provide a schedule for all fringe and overhead rates for the offeror and each division or subcontractor. Describe as necessary in the cost/price narrative. Please provide three years of cost detail to support proposed rates. 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. If your accounting system does not estimate ten years out, you may use the amounts for the last year estimated for the out years.

Sample G&A Worksheet: This spreadsheet shows a generally accepted format for G&A pool/base/rate calculations and is designed to populate the Indirect Rate Summary tab. G&A pool, base, and rate calculations are required as part of the offeror's cost/price proposal. Please provide a schedule for G&A for the offeror and each division or subcontractor. Describe as necessary in the cost/price narrative. Please provide three years of cost detail to support proposed rates. Please indicate if the G&A 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. If your accounting system does not estimate ten years out, you may use the amounts for the last year estimated for the out years.

SECTION B

Cost Summary

TOTAL SUMMARY

ALL CELLS HIGHLIGHTED IN YELLOW WILL BE POPULATED FROM OTHER TABS OR AUTOMATICALLY CALCULATED

TOTAL CONTRACT PRICE $ 63,098,877

Labor- CLIN 0001

ALL CELLS HIGHLIGHTED IN YELLOW WILL BE POPULATED FROM THE INDIRECT RATE SUMMARY

TOTAL LABOR 0.00 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

TOTAL LABOR 0.00 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Labor- CLIN 0002

ALL CELLS HIGHLIGHTED IN YELLOW WILL BE POPULATED FROM THE INDIRECT RATE SUMMARY

TOTAL LABOR 0.00 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

ODC - Cost Summary

ALL CELLS WILL BE POPULATED FROM THE ODC DETAIL TAB OR AUTOMATICALLY CALCULATED

Total $ - 0 $ - 0 $ - 0

CLIN 0060 - 0065 - Sustainment Support $ 13,232,822 $ 681,159 $ 13,913,981

Total $ 60,001,262 $ 3,097,616 $ 63,098,877

ODC Details

CLIN 0050 - System Tech Support $ 17,538,165.00 $ 5,846,055 $ 5,846,055 $ 5,846,055

CLIN 0051 - System Tech Support $ 5,846,055.00 $ 5,846,055

CLIN 0052 - System Tech Support $ 5,846,055.00 $ 5,846,055

CLIN 0053 - System Tech Support $ 5,846,055.00 $ 5,846,055

CLIN 0054 - System Tech Support $ 5,846,055.00 $ 5,846,055

CLIN 0055 - System Tech Support $ 5,846,055.00 $ 5,846,055

CLIN 0060 - Sustainment Support $ 3,780,806.80 $ 1,890,403 $ 1,890,403

CLIN 0061 - Sustainment Support $ 1,890,403.00 $ 1,890,403

CLIN 0062 - Sustainment Support $ 1,890,403.00 $ 1,890,403

CLIN 0063 - Sustainment Support $ 1,890,403.00 $ 1,890,403

CLIN 0064 - Sustainment Support $ 1,890,403.00 $ 1,890,403

CLIN 0065 - Sustainment Support $ 1,890,403.00 $ 1,890,403

Indirect Rate Summary

Sample Fringe - Worksheet

Rate 38.71% 38.87% 38.71% 36.03% 37.51% 35.17% 31.04% 30.75% 30.46% 30.18% 29.91% 29.64% 29.37% 29.11%

Sample Overhead Worksheet

Rate 46.18% 45.33% 48.76% 53.27% 47.80% 44.71% 42.02% 41.63% 41.24% 40.86% 40.49% 40.12% 39.76% 39.41%

Sample G&A Worksheet

Rate 5.66% 5.08% 5.16% 5.31% 5.39% 5.35% 5.30% 5.26% 5.22% 5.18% 5.15% 5.11% 5.07% 5.04%

Direct Labor Rate Schedule