Solicitation_Attachment_1_Cost_Model.xlsx

INSTRUCTIONS

INSTRUCTIONS

SECTION B

Cost Summary

Total Labor & ODC $ 825,000.00 $ 325,000.00 $ 411,440.00 $ 1,561,440.00

Labor - Cost Detail

0 253,440 Labor $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

0 84,480 Labor $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

0 84,480 Labor $ 22.00 $ 61,440.00 $ - 0 $ 61,440.00 $ - 0 $ 61,440.00

Labor OT - Cost Detail

0 12,672 Labor $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

0 4,224 Labor $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

0 4,224 Labor $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Sprtng Labor Detail

ODC - Cost Detail

Indirect Rate Summary

Sample Fringe-OH Worksheet

DIRECT LABOR FRINGE/OVERHEAD RATE

Rate 36.12% 36.12% 36.12% 37.61% 38.97% 38.82%

Sample PMO OH - Worksheet

PMO OVERHEAD RATE

Rate 36.12% 37.61% 38.97% 38.82% 38.97% 38.82%

Sample G&A Worksheet

GENERAL & ADMINISTRATIVE (G&A) EXPENSE

Total G&A Allocation Base $728,500.00 $728,500.00 $728,500.00 $725,400.00 $722,300.00 $683,200.00

Rate 2.30% 2.30% 2.30% 2.30% 2.30% 2.40%

Microsoft_Word_Document1.docx General: Each 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 information will be evaluated for acceptability, fairness, reasonableness and realism based on the cost/price analysis criteria in FAR 15.404-1. Please enter the requested data in the light yellow shaded areas in the Section B, Labor-Cost Detail, Labor OT-Cost Detail, ODC – Cost Detail spreadsheets and in the Indirect Rate Summary spreadsheets. The spreadsheets are designed to automatically compute and populate other cells in the Excel spreadsheets and workbooks.

Section B Spreadsheet: The Section B worksheet imports data from the Labor-Cost Detail, Labor OT-Cost Detail, and ODC-Cost Detail spreadsheets and is used as a basis for the proposed formal Section B.

Cost Summary Spreadsheet: This spreadsheet is for Government analysis purposes. It is populated from the Labor-Cost Detail, Labor OT-Cost Detail, and ODC-Cost Detail spreadsheets.

Labor - Cost Detail and Labor OT - Cost Detail Spreadsheets

General: Enter the requested data in the yellow 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: The information in this column represents the source of wages on the current contract for this requirement and is for informational purposes only.

NOTE 2: Productive hours are the total hours in a work year less any paid or unpaid leave for holidays, sick days, vacations, etc. Productive hours are hours actually worked and billed to a particular job or Government contract. Do not modify the hours in this column. These are estimated hours that may or may not be ordered by the Government

NOTE 3: Please enter the base labor rate for the labor categories listed. The base labor rate, surge pay rate and HDP pay 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 reason, subcontractors may provide this information directly to the Contracting Officer if the subcontractor chooses not to disclose this information to the offeror. Escalation on wages in out years for Service Contract Act positions is unallowable except where the Collective Bargaining Agreement and/or Wage Determinations indicates otherwise.

NOTE 4: Column B of the Labor- Detail Spreadsheets contains several 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 H 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 Column I. 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 provided by the Government for the respective labor category.

NOTE 5: Apply fringe/overhead to prime offeror derived rates. "Sample Fringe-OH Worksheet" provides a sample to be used to compute fringe/overhead. Provide a schedule and describe all elements included in overhead and fringe benefit rate. See attached sample fringe-oh worksheet. Fringe/overhead shall include social security, federal unemployment, state unemployment, workman's compensation, and non-statutory fringe benefits (i.e. 401K, vacations, holidays, etc). If the offeror's accounting system applies fringe and overhead separately, then include separate columns for the application of fringe and overhead as appropriate for the offeror's accounting/estimating system.

NOTE 6: Program Management costs are to be billed as an indirect cost. If these cost aren’t part of the offeror’s indirect cost, they will need propose than as such. The basis for the proposed PMO OH rate shall be clearly documented. A sample PMO OH worksheet has been included for offerors to show the pools and basis that make up this rate.

NOTE 7: This field will automatically calculate the prime hourly burdened rate before the application of G&A and fee, if the prime is proposing the use of a subcontractor, please enter the 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 calculated 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 L 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).

NOTE 8: Provide a schedule and describe the G&A rate pool, and allocation base.

Supporting Labor Detail – Columns c through j should be completed for each position proposed by the offeror.

ODC - Cost Detail Spreadsheet:

NOTE 9: An estimated normalized amount for other direct costs (ODC) 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.

Indirect Rate Summary Spreadsheet: 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/Overhead Spreadsheet: This spreadsheet shows a generally accepted format for fringe benefit and/or overhead pool/base/rate calculations. 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 similar schedule for fringe and overhead for each FY for the offeror and each division or subcontractor. Describe as necessary in the cost/price narrative. 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 PMO OH Spreadsheet: This spreadsheet shows a generally accepted format for Program Management Office Overhead pool/base/rate calculations. PMO OH pool, base, and rate calculations are required as part of the offeror's cost/price proposal. Please provide a similar schedule for PMO OH for each FY for the offeror and each division or subcontractor. Describe as necessary in the cost/price narrative. Please indicate if the PMO OH 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 Spreadsheet: This spreadsheet shows a generally accepted format for G&A pool/base/rate calculations. G&A pool, base, and rate calculations are required as part of the offeror's cost/price proposal. Please provide a similar schedule for G&A for each FY for the offeror and each division or subcontractor. Describe as necessary in the cost/price narrative. 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.

image1.emf