Cost_Spreadsheet.xlsx

XLSX spreadsheet 91 KB Posted

Attached to
DTRA A&AS PMO RFP Amendment Federal contract opportunity
Solicitation number
HDTRA120R0002A1A
Issued by
Defense Threat Reduction Agency

About this file

This document provides a cost proposal template and instructions for a federal contract opportunity with the Defense Threat Reduction Agency. Key details include:

The cost proposal template requires offerors to provide pricing details for direct labor costs by labor category; fringe benefits; labor overhead; subcontractor costs over $150,000 with supporting documentation; consultant costs; other direct costs including materials, supplies, equipment, travel, and other expenses; and indirect rates including general and administrative costs, facilities cost of money, and escalation rates. Instructions specify that options must be separately priced and certified cost or pricing data may be required for subcontracts over $750,000. The related federal contract opportunity is a solicitation to supply a revised cost spreadsheet for proposal submissions.

View the file

On GovTribe

Work with this file on GovTribe

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

General

Prime Contractor:Prime 1 (Fill-in)COST PROPOSAL
Subcontractor:Sub 1 (Fill-in)
GENERAL INFORMATION
The purpose of the requested information in the attached worksheets is to assist government personnel in the review and evaluation of cost proposals submitted by offerors. Offerors are reminded that the responsibility for providing adequate supporting data and attachments lies solely with them. Further, the offeror must also bear the burden of proof in establishing reasonableness of proposed costs; therefore, it is in the offeror’s best interest to submit a fully supportable and well-prepared cost proposal. The basis and rationale for all proposed costs should be provided as part of the proposal so that Government personnel can place reliance on the information as current, complete and accurate. Further, FAR 15.403-4 sets forth those circumstances in which offerors are required to submit certified cost or pricing data.
Options: Unpriced Options will not be accepted. Any Option that is not fully priced, will not be included in any resulting award.
Enter the proposed cost detail for the Base and each Option period (as needed) on the "Total Amount" tab.
• The formulas in this spreadsheet are based upon common business practices; however, Offerors may edit formulas as necessary (edited formulas must still be visible).
• Ensure all costs from other worksheets are correct.

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

Total Direct Labor Costs$0
Total Fringe Benefit Costs$0
Total Labor Overhead Costs$0
Total Subcontract Costs$0
Total Consultant Costs$0
Total Other Direct Costs$0
Total Material Handling Costs$0
Subtotal Costs$0
Total G&A Costs$0
Subtotal Costs$0
Total Cost of Money$0
Total Estimated Costs$0
Fixed Fee (If proposing a CPFF contract)$0
Total Estimated Costs Plus Fixed Fee$0

Total Amount

Cost Proposal - Total Amount
Prime Offeror:Prime 1 (Fill-in)
Subcontractor:Sub 1 (Fill-in)
BASEOPTION 1OPTION 2OPTION 3OPTION 4Total
Direct Labor (DL)MM/YR to MM/YRMM/YR to MM/YRMM/YR to MM/YRMM/YR to MM/YRMM/YR to MM/YR
Offeror's Labor Category (Note 1)Name (Last, First)Base/HoursRateExtended $Base/HoursRateExtended $Base/HoursRateExtended $Base/HoursRateExtended $Base/HoursRateExtended $Base/HoursExtended $
0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00
0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00
0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00
0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00
0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00
0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00
0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00
0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00
0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00
0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00
0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00
0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00
0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00
0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00
0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00
0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00
0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00
0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00
0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00
0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00
Total Direct Labor Costs0$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00
Fringe Benefits (F/B) (See Escalation and Indirect Rate Worksheet)
Insert F/B rate title$00.000%$0.00$00.000%$0.00$00.000%$0.00$00.000%$0.00$00.000%$0.00$0.00$0.00
Insert line(s) & title(s) for any other F/B rates$00.000%$0.00$00.000%$0.00$00.000%$0.00$00.000%$0.00$00.000%$0.00$0.00
Total Fringe Benefit Costs$0.00$0.00$0.00$0.00$0.00$0.00
Labor Overhead (O/H) (See Escalation and Indirect Rate Worksheet)
Insert O/H rate title$00.000%$0.00$00.000%$0.00$00.000%$0.00$00.000%$0.00$00.000%$0.00$0.00$0.00
Insert line(s) & title(s) for any other O/H rates$00.000%$0.00$00.000%$0.00$00.000%$0.00$00.000%$0.00$00.000%$0.00$0.00
Total Labor Overhead Costs$0.00$0.00$0.00$0.00$0.00$0.00
Subcontracts/Interorganizational TransferFile/Tab Name or Link
Subcontract/Interorganizational Name - #01Provide details in Subcontractor Tab$0.00$0.00$0.00$0.00$0.00$0.00
Subcontract/Interorganizational Name - #02Provide details in Subcontractor Tab$0.00$0.00$0.00$0.00$0.00$0.00
Subcontract/Interorganizational Name - #03Provide details in Subcontractor Tab$0.00$0.00$0.00$0.00$0.00$0.00
Insert line(s) for any additional Subcontractors/InterorganizationalProvide details in Subcontractor Tab$0.00$0.00$0.00$0.00$0.00$0.00
Total Subcontract Costs$0.00$0.00$0.00$0.00$0.00$0.00
Consultants
Consultant Name - #01Provide details in Consultant Tab$0.00$0.00$0.00$0.00$0.00$0.00
Consultant Name - #02Provide details in Consultant Tab$0.00$0.00$0.00$0.00$0.00$0.00
Consultant Name - #03Provide details in Consultant Tab$0.00$0.00$0.00$0.00$0.00$0.00
Insert line(s) for any additional ConsultantsProvide details in Consultant Tab$0.00$0.00$0.00$0.00$0.00$0.00
Total Consultant Costs$0.00$0.00$0.00$0.00$0.00$0.00
Other Direct Costs
Materials/SuppliesProvide details in Materials Tab$0.00$0.00$0.00$0.00$0.00$0.00
EquipmentProvide details in Equip. Tab$0.00$0.00$0.00$0.00$0.00$0.00
TravelProvide details in Travel Tab$0.00$0.00$0.00$0.00$0.00$0.00
Insert line(s) for any other types of ODCsProvide details in ODC Tab$0.00$0.00$0.00$0.00$0.00$0.00
Total Other Direct Costs$0.00$0.00$0.00$0.00$0.00$0.00
Material Handling (M/H O/H) (See Escalation and Indirect Rate Worksheet)
Insert M/H O/H rate title$00.000%$0.00$00.000%$0.00$00.000%$0.00$00.000%$0.00$00.000%$0.00$0.00$0.00
Insert line(s) & title(s) for any other M/H O/H rates$00.000%$0.00$00.000%$0.00$00.000%$0.00$00.000%$0.00$00.000%$0.00$0.00
Total Material Handling Costs$0.00$0.00$0.00$0.00$0.00$0.00
Subtotal Costs$0.00$0.00$0.00$0.00$0.00$0.00
General and Administrative (G&A) (See Escalation and Indirect Rate Worksheet)
Insert G&A rate title$00.000%$0.00$00.000%$0.00$00.000%$0.00$00.000%$0.00$00.000%$0.00$0.00$0.00
Insert line(s) & title(s) for any other G&A rates$0.00$0.00$0.00$0.00$0.00$0.00
Total G&A Costs$0.00$0.00$0.00$0.00$0.00$0.00
Subtotal Costs$0.00$0.00$0.00$0.00$0.00$0.00
Facilities Cost of Money (COM) (See Escalation and Indirect Rate Worksheet)
Insert COM rate title$00.000%$0.00$00.000%$0.00$00.000%$0.00$00.000%$0.00$00.000%$0.00$0.00$0.00
Insert line(s) & title(s) for any other COM rates$0.00$0.00$0.00$0.00$0.00$0.00
Total Cost of Money$0.00$0.00$0.00$0.00$0.00$0.00
Total Estimated Costs$0.00$0.00$0.00$0.00$0.00$0.00
Fixed Fee (If proposing a CPFF contract)(Note 2)$00.000%$0.00$00.000%$0.00$00.000%$0.00$00.000%$0.00$00.000%$0.00$0.00$0.00
Total Estimated Costs Plus Fixed Fee(Note 3)$0.00$0.00$0.00$0.00$0.00$0.00

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.

Note 1:Any proposed personnel in the technical proposal should be identified with their labor category.
Note 2:Profit or fee is not allowed on direct costs for travel. In addition, a DD Form 1547 (DFARS 215.404-70) will be utilized in calculating the Government objective for fee.
Note 3:This worksheet does not pull data from other worksheets within this Excel Spreadsheet

Labor&Ind Rates

LABOR InformationPrime 1 (Fill-in)
Base PeriodOption IOption IIOption IIIOption IVSupporting DocumentationSupporting Rationale
Labor Category (Note 1)NameDirect Labor RateEscalation RateEscalation RateEscalation RateEscalation Rate(Note 2)(Note 3)
Indirect Rates (Note 4)
Base PeriodOption IOption IIOption IIIOption IVBasis of RateApplied Against (Note 5)Supporting Documentation (Note 6)
Rate CategoryRateRateRateRateRate(Example: FPRA, FPRP, Estimate, etc.)
Fringe Benefits
Labor Overhead
Material Handling
General and Administrative
Facilities Cost of Money

Note 1: Add additional labor categories if needed.

Note 2: Provide the location (section, page) in the proposal's Cost Narrative/Supporting Documentation 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 of the rationale for the appropriateness and necessity of the proposed labor categories and the labor hours allocated to each.

Note 4:Add additional indirect rates as needed.
If the offeror does not have a Forward Pricing Rate Agreement (FPRA), Forward Pricing Rate Recommendation (FPRR), or provisional billing rates; in order to assist the Government in evaluating the reasonableness of your proposed indirect rates, please provide the following information:
1. Performance data used to develop your proposed indirect rates. This typically consists of pool costs and base costs that demonstrate how the indirect rates were derived.
2. Information regarding your projections for out years, including your assumptions and method for developing these estimates.

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 of the supporting documentation to support the proposed rates (e.g. copy of rate agreements, rate data and projections)

Subcontractor

SUBCONTRACTOR COST DATAPrime 1 (Fill-in)
Subcontracts/Interorganizational Transfers – A fully disclosed cost proposal as detailed as the Offeror’s cost proposal including support documentation will be required to be submitted by all proposed subcontractors and for all interorganizational transfers over $150,000. For subcontracts and interorganizational transfers under $150,000, only a cost proposal with cost categories broken out must be provided. If options are proposed, the option periods should be separately priced. The subcontract or interorganizational transfer proposal, along with supporting documentation, must be provided either with the prime’s proposal or via email directly to the Contracting Officer or Contract Specialist upon request. The email should identify the prime Offeror, proposal title, and that the attached proposal is a subcontract. The subcontractor and interorganizational transfer proposals with supporting documentation must be received and reviewed before the Government can complete its cost analysis of the proposal and enter negotiations.

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

SubcontractorCAGE
CodeCompetitive/Sole SourceCost/price analysis included (Y/N)Type of Subcontract (i.e., Fixed Price, Time and Materials, etc.)Competitive Quotes or Sole Source Documentation Included (Y/N)Total amount exceeds $750K (Y/N)Cost/Price Analysis (Note 1)
Y
N

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

&"Arial,Bold"&12&A

Offeror: Page &P of &N Pages &F

Consultants

CONSULTANTSPrime 1 (Fill-in)
Name (Note 1)Description of effort to be performed by the Consultant or attach Consultant Statement of WorkNumber of HoursHourly RateTotalSupporting Documentation (Note 2)Supporting Rationale (Note 3)
BaseY
$0.00N
$0.00
$0.00
Option I
$0.00
$0.00
$0.00
$0.00

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 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 of the rationale for the necessity of the proposed consultant(s).

Materials-Supplies

MATERIALS - SUPPLIES (Note 1)Prime 1 (Fill-in)
Item
(Note 2)Description of Material (include model number)QtyUnit PriceTotal PriceCompetitive /Sole SourceVendor/Source (If known)Supporting Documentation (Note 3)Supporting Rationale (Note 4)
Base$0.00Y
1$0.00N
2$0.00
3$0.00
Option I$0.00
4$0.00
5$0.00
6$0.00
7$0.00

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 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 for the necessity of the proposed materials/supplies

Equipment

EQUIPMENT (NOTE 1)Prime 1 (Fill-in)
Item
(Note 2)Description of Equipment (include model number) (Note 1)Will the equipment be included as part of a deliverable item under the award? (Y/N)Type of Equipment (special test equipment, special tooling, general purpose equipment, or plant equipment)
(Note 3)QtyUnit of IssueUnit PriceTotal PriceVendor/SourceSupporting Documentation
(Note 4)Supporting Rationale (Note 5)
BaseY
$0N
$0
Option I
$0

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.

Note 3:Definitions:
Special Test Equipment is defined as either single or multipurpose integrated test units engineered, designed, fabricated, or modified to accomplish special purpose testing in performing a contract. It consists of items or assemblies of equipment including standard or general purpose items or components that are interconnected and interdependent so as to become a new functional entity for special testing purposes.

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 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 of the rationale for the necessity of the proposed materials/supplies

Travel

TRAVEL(Notes 1 and 2)Prime 1 (Fill-in)
Trip PurposeNumber of TripsNumber of TravelersNumber of DaysAir/RailPer Diem Rate (Meals)Per Diem Rate (Lodging)Rental Car Rate (Per Day)Parking Rate (Per Day)MileageTaxiOther (Note 3)TOTALSupporting Documentation (Note 4)Supporting Rationale (Note 5)
BaseCity, State
From:000$0.00$0.00$0.00$0.00$0.000$0.00$0.00
To:Totals$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
From:000$0.00$0.00$0.00$0.00$0.000$0.00$0.00
To:Totals$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
From:000$0.00$0.00$0.00$0.00$0.000$0.00$0.00
To:Totals$0$0$0$0$0$0.00$0.00$0.00$0.00
From:000$0.00$0.00$0.00$0.00$0.000$0.00$0.00
To:Totals$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
From:000$0.00$0.00$0.00$0.00$0.000$0.00$0.00
To:Totals$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Option 1
From:000$0.00$0.00$0.00$0.00$0.000$0.00$0.00
To:Totals$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
From:000$0.00$0.00$0.00$0.00$0.000$0.00$0.00
To:Totals$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
From:000$0.00$0.00$0.00$0.00$0.000$0.00$0.00
To:Totals$0$0$0$0$0$0.00$0.00$0.00$0.00
From:000$0.00$0.00$0.00$0.00$0.000$0.00$0.00
To:Totals$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
From:000$0.00$0.00$0.00$0.00$0.000$0.00$0.00
To:Totals$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
TOTAL$0

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 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 of the rationale for the necessity of the proposed travel.

ODC Details

OTHER DIRECT COSTS (Note 1)Prime 1 (Fill-in)
Description
(Note 2)QtyUnit of IssueUnit PriceTotal PriceSupporting Documentation (Note 3)Supporting Rationale (Note 4)
Base$0Y
$0N
$0
Option I$0
$0
$0
$0

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 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 of the rationale for the necessity of the proposed ODC.

File details come from the government source that posted it. Updated .