Attachment J.1 Cost Model.xlsx

Instructions

Section B

Cost Summary

Direct Labor Rate Schedule

Labor - DAMO

Labor - USANCA

ODC Cost Detail

Indirect Rate Summary

Please enter corresponding indirect rates for the prime and each subcontractor for each of the periods.

Subcontractors may provide data separately in the above format for proprietary reasons.

Provide the necessary narrative describing how the rates were derived and applied, the composition of the allocation pools & bases, and provide any supporting forward rate agreements and DCAA/DCMA agreements/reports.

If rates proposed are based on other than actual rates, please state the reason(s).

Sample Fringe, Overhead, and G&A worksheet schedules follow this tab.

Fringe Rate Worksheet

Rate ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!

Fringe Benefit Worksheet

Paid Leave/Vacation (PTO, Sick, Military, etc.) Years of Experience Hours Alloted Per Year

Overhead Rate Worksheet

Rate ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!

G&A Rate Worksheet

Rate ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!

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 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 and all divisions and subcontractors 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

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

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

· Type the appropriate name of the Prime Contractor/Subcontractor/Division in Cell H14, the street address in Cell H15, and the city, state, and zip code in Cell H16 on the Instructions worksheet of the LOE Workbook. It will carry through the remaining worksheets.

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

· 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). Column L will only need inputs if the prime offeror is inputting a subcontractor’s fully burdened labor rate into that column.

· 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.

· Please enter the requested data in the green shaded areas on the Indirect Rate Summary worksheet.

· Please enter the requested data in the green shaded areas on the Fringe, Overhead, and G&A Rate worksheets. These worksheets assist in calculating the indirect rates. This will enable the cost evaluation team to analyze the indirect costs. PLEASE NOTE: The rates at the bottom DO NOT carry over to the Indirect Rate Summary.

· To assist in the evaluation of the total compensation plan, please complete the requested data on the Fringe Benefit Worksheet. Any information not included will be assumed to not be offered. Offerors shall still supply a copy of its total compensation plan in accordance with the RFP.

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.

Cost Summary Worksheet

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

Direct 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 or different pay rates. However, it is requested that the general format be maintained as much as possible for cost/price analysis and contract administration purposes.

Labor Cost 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: Column A is the location where the Labor Category will perform.

NOTE 2: Column B is the type of labor.

NOTE 3: Column C of the Labor Cost Detail worksheet are the labor categories for this action.

NOTE 4: 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.

NOTE 5: 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 6: 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 7: The Total Productive Hours are estimated productive hours that may or may not be ordered by the Government during the contract. The Total Productive Hours are based on the number of FTEs multiplied by the Annual Productive Hours, which is 1,920, multiplied by the number of months in that period. Total 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). Total 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.

· Transition In: One Month

· Base Period: 11 Months

· Option Periods 1, 2, 3, and 4: 12 Months

NOTE 8: THE OFFEROR OR SUBCONTRACTOR SHALL PROVIDE DETAILED DOCUMENTATION TO SUPPORT THE REALISM OF THE PROPOSED DIRECT LABOR RATES. 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.

NOTE 9: Apply fringe to prime or subcontractor offeror derived rates. ‘Fringe Worksheet’ provides a sample to be used to compute the fringe rate. Provide a schedule and describe all elements included in the fringe benefit rate. Fringe 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 together, use only one of the worksheets and clearly indicate this in the proposal. The rate will carry over from the Indirect Rate Summary.

NOTE 10: Apply overhead to prime or subcontractor offeror derived rates. ‘Overhead Worksheet’ provides a sample to be used to compute the overhead rate. Provide a schedule and describe all elements included in the overhead rate. If the offeror's accounting system applies fringe and overhead together, use only one of the worksheets and clearly indicate this in the proposal. The rate will carry over from the Indirect Rate Summary.

NOTE 11: 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 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 column k 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 12: Provide a schedule and describe the G&A rate pool, and allocation base. The rate will carry over from the Indirect Rate Summary.

ODC Cost Detail Worksheet

NOTE 13: 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.

Indirect Rate Summary Worksheet

THE OFFEROR OR SUBCONTRACTOR SHALL PROVIDE THREE YEAR’S WORTH OF HISTORICAL DATA AND SUPPORTING DOCUMENTATION FROM DCAA OR DCMA, IF AVAILABLE. 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.

Fringe Worksheet

THE OFFEROR OR SUBCONTRACTOR SHALL PROVIDE THREE YEAR’S WORTH OF HISTORICAL DATA AND SUPPORTING DOCUMENTATION FROM DCAA OR DCMA, IF AVAILABLE. This worksheet shows a generally accepted format for fringe benefit pool/base/rate calculations. Fringe benefit pool, base, and rate calculations are required as part of the offeror's cost/price proposal. The fringe rates may be calculated together or separately depending on the contactor/subcontractor's accounting system. Please provide at least two years historical data, the current data, and estimates for the period of performance. Also, provide a similar fringe schedule 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.

Overhead Worksheet

THE OFFEROR OR SUBCONTRACTOR SHALL PROVIDE THREE YEAR’S WORTH OF HISTORICAL DATA AND SUPPORTING DOCUMENTATION FROM DCAA OR DCMA, IF AVAILABLE. This worksheet shows a generally accepted format for overhead pool/base/rate calculations. Overhead pool, base, and rate calculations are required as part of the offeror's cost/price proposal. The overhead rates may be calculated together or separately depending on the contactor/subcontractor's accounting system. Please provide at least two years historical data, the current data, and estimates for the period of performance. Also, provide a similar overhead schedule 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.

G&A Worksheet

THE OFFEROR OR SUBCONTRACTOR SHALL PROVIDE THREE YEAR’S WORTH OF HISTORICAL DATA AND SUPPORTING DOCUMENTATION FROM DCAA OR DCMA, IF AVAILABLE. This worksheet 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.