ATTACHMENT 4 - FY 22 Cost_Spreadsheet.xlsx

General

Below is a summary of the proposed cost. This chart will automatically fill in from the "Total Amount" tab.

Total Amount

Instructions: • For PRIME submission - Subcontractor Name: If there are subcontracts, list all subcontractor names.

• List Principal Investigator and Key Personnel working on the project even if they receive no salary support.

• Subcontracts/Interorganizational Transfers: If appropriate, place Subcontractor name(s) or Interorganizational Name/Code in Column B.

• Consultants: If appropriate, place Consultant name(s) in Column B.

• Remember that the total of all Base and Option worksheets should equal the total of the Total Amount worksheet.

• Add descriptions in Column B if costs are entered in the following areas: Fringe Benefits, Labor Overhead, Other Direct Costs/other types, Material Handling, General and Administrative, and Facilities Cost of Money.

Labor&Ind Rates

Note 1: Add additional labor categories if needed.

Note 2: Provide the location (section, page) in the proposal's Cost Narrative/Supporting Documentation (BAA para 3.5.2.2.1) to support your price basis (e.g. copy of current payroll record or signed offer letter)

Note 3: Provide the location (section, page) in the proposal's Technical Basis of Estimate (BAA para 3.5.2.1.1.4) of the rationale for the appropriateness and necessity of the proposed labor categories and the labor hours allocated to each.

Note 5: Indicate to which cost element(s) the rate applies.

Note 6: Provide the location (section, page) in the proposal's Cost Narrative/Supporting Documentation (BAA para 3.5.2.2.1) of the supporting documentation to support the proposed rates (e.g. copy of rate agreements, rate data and projections)

Subcontractor

In accordance with FAR 15.404-3(b) and 15.404-3(c), the prime contractor shall perform and provide a cost/price analysis of each subcontractor’s cost proposal. Offerors are required to obtain competition to the maximum extent practicable when selecting subcontractors; if the offeror has obtained competitive quotes, copies should be provided. If the Offeror has selected other than the low bid for inclusion in their proposal or intends to award the subcontract on a sole-source basis, the offeror shall provide rationale for their decision. For sole-sourced subcontracts, the prime contractor must provide a short sole-source justification.

Certified cost or pricing data may be required for subcontractor proposals over $750,000, in accordance with FAR 15.404(c).

Note 1: Provide the location (section, page) in the proposal's Cost Narrative/Supporting Documentation (BAA para 3.5.2.2.1) of the cost/price analysis for each individual subcontractor.

&"Arial,Bold"&12&A

Offeror: Page &P of &N Pages &F

Consultants

Instructions: • For Prime - fill out all columns if applicable. Indicate “Not Applicable” in B5 when there is no information to include.

Note 1: Include a separate section in the above table for the Base and each Option.

Note 2: Provide the location (section, page) in the proposal's Cost Narrative/Supporting Documentation (BAA para 3.5.2.2.1) used to support your price basis (e.g. copy of quote or agreement).

Note 3: Provide the location (section, page) in the proposal's Technical Basis of Estimate (BAA para 3.5.2.1.1.4) of the rationale for the necessity of the proposed consultant(s).

Materials-Supplies

Instructions:

• Fill out all columns on the Materials/Supplies Tab for each item.

• Add additional lines if needed.

• Ensure that descriptions and vendors listed on the Materials/Supplies worksheet match information provided in the backup.

Note 1: Material is property that may be incorporated into or attached to a deliverable end item or that may be consumed or expended in performing a contract. It includes assemblies, components, parts, raw and processed materials, and small tools and supplies that may be consumed in normal use in performing a contract. Material should be proposed separately from Equipment (see following spreadsheet and definitions).

Note 2: Include a separate section in the above table for the Base and each Option.

Note 3: Provide the location (section, page) in the proposal's Cost Narrative/Supporting Documentation (BAA para 3.5.2.2.1) of the documentation used to support your price basis (e.g. copy of quote, page from catalog, recent invoice or PO). If the supporting documentation is located on a website, then please provide a screen shot.

Note 4: Provide the location (section, page) in the proposal's Technical Basis of Estimate (BAA para 3.5.2.1.1.4) for the necessity of the proposed materials/supplies

Equipment

Instructions:

• Fill out all columns on the Equipment Tab for each item.

• Add additional lines if needed.

• Ensure that descriptions and vendors listed on the Equipment worksheet match information provided in the backup.

Note 1: Contractors are normally required to furnish all equipment and/or facilities necessary to perform Government contracts (see FAR 45.102(a)). The Government may allow equipment and/or facilities only under special circumstances. If equipment and/or facilities are proposed, the specific description should identify the component, nomenclature, and configuration of the equipment/hardware that it proposes to purchase for this effort. The purchase on a direct reimbursement basis of equipment that is not included in a deliverable item will be evaluated for allowability on a case-by-case basis. Maximum use of Government integration, test, and experiment facilities is encouraged.

Note 2: Include a separate section in the above table for the Base and each Option. Add additional lines labeled with Options if needed.

Special tooling is defined as jigs, dies, fixtures, molds, patterns, taps, gauges, and all components of these items, including foundations and similar improvements necessary for installing special test equipment, and which are of such a specialized nature that without substantial modification or alteration their use is limited to the development or production of particular supplies or parts thereof or to the performance of particular services.

Plant equipment means personal property of a capital nature (including equipment, machine tools, test equipment, furniture, vehicles, and accessory and auxiliary items) for use in manufacturing supplies, in performing services, or for any administrative or general plant purpose. It does not include special tooling or special test equipment.

Note 4: Provide the location (section, page) in the proposal's Cost Narrative/Supporting Documentation (BAA para 3.5.2.2.1) used to support your price basis (e.g. copy of quote, page from catalog, recent invoice or PO).

Note 5: Provide the location (section, page) in the proposal's Technical Basis of Estimate (BAA para 3.5.2.1.1.4) of the rationale for the necessity of the proposed materials/supplies

Travel

Instructions:

• When completing the “From” and “To” information, enter the city and state where travel will originate and end. For example, from Seattle WA to Washington DC. Do not list airport codes.

• Include the trip purpose. It must be referred to in the Technical Proposal. Publications, conference attendance, and presentations are encouraged but must be justified to and approved by the Program Officer.

• Remember that you cannot stay overnight the same number of days that you travel. There must always be one more day than night.

• Do not combine any categories.

• For lodging and M&IE, use federal Per Diem Rates found at http://www.defensetravel.dod.mil/site/perdiemCalc.cfm.

• For M&IE, input the full rate in the white block. The gray block will automatically calculate the total to include 75% for the first and last day of travel.

• Submit backup for airfare and rental cars. Price airfare at economy rates; indicate if the airfare is refundable.

Note 1: Estimates and the resultant costs claimed must conform to the applicable Federal cost principles.

• Do not combine any categories.

Note 2: Include a separate section in the above table for the base and each option

Note 3: If there are miscellaneous expenses associated with the trip, provide description and rationale.

Note 4: Provide the location (section, page) in the proposal's Cost Narrative/Supporting Documentation (BAA para 3.5.2.2.1) used to support your price basis (e.g. copy of quote, page from catalog, recent invoice or PO).

Note 5: Provide the location (section, page) in the proposal's Technical Basis of Estimate (BAA para 3.5.2.1.1.4) of the rationale for the necessity of the proposed travel.

ODC Details

Instructions:

• If you have any ODC entries, be sure to fill out all columns.

• Ensure that descriptions and vendors listed on the ODC Details worksheet match information provided in the backup.

Note 1: Examples include rental fees, shipping costs, license fees

Note 2: Include a separate section in the above table for the Base and each Option. Add additional lines labeled with Options if needed.

Note 3: Provide the location (section, page) in the proposal's Cost Narrative/Supporting Documentation (BAA para 3.5.2.2.1) used to support your price basis (e.g. copy of quote, page from catalog, recent invoice or PO).

Note 4: Provide the location (section, page) in the proposal's Technical Basis of Estimate (BAA para 3.5.2.1.1.4) of the rationale for the necessity of the proposed ODC.

Sheet1