ATM Price Model 030326 v3.xlsx

Instructions

Section B

Price Summary

Labor Rate Schedule

Please enter all the corresponding labor categories proposed in the labor cost detail spreadhseets.

For cost realism purposes indicate the basis of the proposed rates and provide documentation to substantiate the rates, such as pay stubs, signed employee letters of intent, etc. If the rates are based on estimates please provide salary survey data and other data to corroborate the realism of the rates.

Please provide the basis of escalation.

Labor Detail

ODC Cost Detail

Microsoft_Word_Document.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 workbook 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 major subcontractors (performing 10% or more of hours) proposed to perform effort in response to this solicitation. The information will be evaluated for fairness, reasonableness, based on the cost/price analysis, and cost realism analysis (on cost CLINS) criteria in FAR 15.404-1.

Overall Instructions

1. The worksheets are designed to automatically compute and populate other cells in the Excel workbook.

2. The worksheet tabs shaded green have inputs required on that worksheet.

3. More detailed instructions follow number 9 below.

4. Type the appropriate name of the Prime Contractor/Subcontractor/Division in Cell H14 on the Instructions worksheet of the LOE Workbook. It will carry through the remaining worksheets.

5. Please enter the requested data in the green shaded areas on the Labor Rate Schedule, which includes the proposed labor rates, and the escalation rate used. The direct rate information feeds into the Labor Cost Detail worksheet.

6. Please enter the requested data in the green shaded areas on the Labor Cost Detail worksheet, which includes which entity will be performing the work (columns D and E).

7. Please enter the requested data in the green shaded areas on the ODC Cost Detail worksheet. For the purposes of proposal, the Government has input normalized values for the ODCs. These numbers are to be used. The offerors may add any burden and/or G&A as appropriate. Since these are estimated amounts that may or may not occur, no fixed fee will be allowed on the ODCs.

Section B Worksheet

The Section B worksheet imports data from the Cost Summary, Labor Cost Detail, and ODC Cost Detail worksheets and is used as a basis for the proposed formal Section B. Please note that there are three cells that may turn green. THESE ARE NOT INPUTS. It is a different shade of green and is only used as a check to ensure the final price on the Section B worksheet agrees with the summations pulled from the other worksheets.

Price Summary Worksheet

This worksheet is for Government analysis purposes. It is populated from the Labor Detail and ODC Cost Detail worksheets.

Labor Rate Schedule Worksheet

Enter the requested data in the green shaded cells. It may be necessary for each offeror to revise the number of rows, columns, and/or formulas to reflect 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.

Labor Detail Worksheet

Enter the requested data in the green shaded cells. It may be necessary for each offeror to revise the number of rows, columns, and/or formulas to reflect 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. For specific instructions, see the Notes that follow.

NOTE 1: NOT USED.

NOTE 2: Column C of the Labor Cost Detail worksheet 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 D if the effort is to be performed by the prime contractor and a ‘S’ if performed by another division or subcontractor. Enter the name of the division or subcontractor in column E. 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 FTEs in column F and the hours in columns G and H for the individual category in column C for 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 3: For the purposes of this solicitation, the hours worked under a FTE shall consist of the hours worked by an individual employee and not multiple employees (i.e. 1 FTE = 1 employee). One FTE shall not be split among two or more employees.

NOTE 4: Offerors are permitted to propose an alternative labor mix. The productive hours in this column are estimated productive hours that may or may not be ordered by the Government during the contract and are based on a 1,920 hour work year per FTE. Productive hours are the total hours in a work year less any days not actually worked (i.e. not including holidays, sick days, vacations, etc). Productive hours are hours that will actually be worked and billed to the contract. For the purposes of this solicitation please assume a 40 hour work week NOT to include overtime or uncompensated overtime.

NOTE 5: The hourly base pay rate copies over from the Direct Labor Rate Schedule. The base labor rate is the rate actual paid to the employee EXCLUSIVE of social security, federal unemployment, state unemployment, workman's compensation, 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 indicate otherwise.

ODC Cost Detail Worksheet

(NOTE 10): Enter the requested data in the green shaded cells. An estimated normalized amount for other direct cost (ODC) and travel has been specified for proposal purposes for all periods. 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 authorized.

image1.emf