Attachment_F_DARPA_Cost_Proposal_Spreadsheet.xlsx

XLSX spreadsheet 129 KB Posted

Attached to
Protein ENGineering (PENG)
Solicitation number
DARPA-PS-26-129
Issued by

About this file

This is a DARPA Streamlined Cost Proposal Spreadsheet template designed for use by prime contractors and subcontractors responding to the Protein ENGineering (PENG) solicitation (DARPA-PS-26-129). The spreadsheet provides a standardized format for proposing costs across a multi-phase program structure, with a Base Phase 1 (18 months in Performer FY 2027-2028), an Option Phase 1 Capability Demo (6 months in FY 2028 and 18 months in FY 2029), and an Option Phase 2 (18 months in FY 2029-2030). The template requires all calculations to include traceable formulas and accommodates various cost categories including direct labor (with separate columns for proposer and DARPA labor categories, hours, rates, fringe benefits, and overhead), subcontract costs with applicable overhead, consultant costs, and other direct costs (materials, supplies, equipment, and travel).

The spreadsheet includes detailed supporting tabs for materials and supplies, equipment, travel, other direct costs (ODCs), and optional cost elements including the Fundamental Defense Research Talent Award (FDRTA) and Industry Immersion Program (IIP). All cost proposals must be submitted in this format by both primes and subcontractors as separate spreadsheets, with supporting documentation required for individual line items exceeding $5,000. The template provides specific guidance for indirect cost application (G&A for commercial contractors and F&A with Modified Total Direct Cost base for universities), Cost of Money calculations where applicable, and fee or profit proposals. Each cost category includes instructions for proper documentation and cross-referencing with the technical proposal, and the spreadsheet automatically calculates subtotals and grand totals across all proposed phases and options.

View the file

Other files

Show all 12

On GovTribe

Work with this file

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

Text version

SUMMARY

SUMMARY OF THE TOTAL PROPOSED COST

Direct Costs$ - 0
Fringe Costs$ - 0
Overhead Costs$ - 0
Subcontract Costs (if applicable)$ - 0
Subcontract Overhead$ - 0

Total Consultant Costs $ - 0

OTHER DIRECT COSTS
Materials/Supplies$ - 0
Equipment$ - 0
Travel$ - 0
Other ODC's$ - 0
Total Other Direct Costs$ - 0

TOTA Material Handling Costs $ - 0

SUBTOTAL COSTS $ - 0

G&A/F&A COSTS $ - 0

TOTAL COSTS $ - 0

TOTAL Cost of Money (COM) $ - 0

Fee/Profit (If applicable) $ - 0

FDRTA/ IIP Option $ - 0

TOTAL COST PLUS FEE (OR TOTAL PRICE) $ - 0

Total Amount

DARPA Streamlined Cost Proposal Spreadsheet PENG - See Detailed Instructions Below
Highlighted cell color corresponds to notes below (some cells also have notes for additional guidance)
**All calculations in cells must have a traceable formula**
Proposer Name:
Date of Proposal or Revision Submission:
Prime or Subcontractor (dropdown):(Fill-in)
CAGE CODE:(Note 2)(Note 2)(Note 2)
Base Phase 1 (Performer FY 2027)Base Phase 1 (Performer FY 2028)Option Phase 1 Capability Demo (Performer FY 2028)Option Phase 1 Capability Demo (Performer FY 2029)(Option) Phase 2 (Performer FY 2029)(Option) Phase 2 (Performer FY 2030)Total
Direct Labor (DL)Enter Project PoP as "MM/YY to MM/YY" 18 MonthsEnter Project PoP as "MM/YY to MM/YY" 6 MonthsEnter Project PoP as "MM/YY to MM/YY" 18 Months42 Months
Proposer's Labor Category (Note 1)DARPA Labor Category (Note 1)Name (Last, First)HoursDirect RateDirect CostFringe Benefits RateFringe Benefits Cost

tc={90A6E888-1A75-4266-98F9-4B8314C515C6}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Insert formulas in Column as appropriate. See Note 3 Overhead Rate Overhead Cost tc={37D6EDB9-9504-49E9-B8D5-667BE466E0CD}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Insert formulas in Column as appropriate. See Note 3 Burdened Labor Hours Direct Rate Direct Cost Fringe Benefits Rate Fringe Benefits Cost tc={274927CE-D48C-4461-ACC5-6763DC3F958C}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Insert formulas in Column as appropriate. See Note 3 Overhead Rate Overhead Cost Burdened Labor $ Hours Direct Rate Direct Cost Fringe Benefits Rate Fringe Benefits Cost tc={1D08FF4B-5966-4642-B19B-D25B04A61208}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Insert formulas in Column as appropriate. See Note 3 Overhead Rate Overhead Cost Burdened Labor $ Hours Direct Rate Direct Cost Fringe Benefits Rate Fringe Benefits Cost tc={0B11B64A-CD5B-489A-A18B-CE62F132541B}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Insert formulas in Column as appropriate. See Note 3 Overhead Rate Overhead Cost Burdened Labor $ Hours Direct Rate Direct Cost Fringe Benefits Rate Fringe Benefits Cost tc={E374389D-2B3C-4089-B85A-FEBDFFCA2F7F}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Insert formulas in Column as appropriate. See Note 3 Overhead Rate Overhead Cost Burdened Labor $ Hours Direct Rate Direct Cost Fringe Benefits Rate Fringe Benefits Cost tc={68F51A89-1F22-4FE7-9CD3-A891344E3A10}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Insert formulas in Column as appropriate. See Note 3Overhead RateOverhead CostBurdened Labor $HoursSubtotal
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0- 0$ - 0
Direct Costs:0.00$ - 0$ - 00.00$ - 0$ - 00.00$ - 0$ - 00.00$ - 0$ - 00.00$ - 0$ - 00.00$ - 0$ - 0- 0$ - 0
Fringe Costs:$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Overhead Costs:$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
CostCostCostCostCostCost
Sub-awardees/Subcontracts/Interorganizational TransferCAGE CODE
Sub-awardee/Subcontract/Interorganizational Name - #01$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Sub-awardee/Subcontract/Interorganizational Name - #02$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Sub-awardee/Subcontract/Interorganizational Name - #03$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Insert line(s) for any additional Sub-awardee/Subcontractors/Interorganizational$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Subtotal Sub-awardee/Subcontract Costs/Interorganizational$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Sub-awardee/Subcontract/Interorganizational Overhead (if applicable see note 3)See Note 3BaseRateBaseRateBaseRateBaseRateBaseRateBaseRate
Subcontract Overhead Cost$0.00$ - 0$0.00$ - 0$0.00$ - 0$0.00$ - 0$0.00$ - 0$0.00$ - 0$ - 0
ConsultantsHoursRateCostHoursRateCostHoursRateCostHoursRateCostHoursRateCostHoursRateCost
Consultant Name #1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Consultant Name #2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Consultant Name #3$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Consultant Name #4$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Consultant Costs- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0$ - 0
Other Direct Costs:CostCostCostCostCostCostCheck sum
Materials/SuppliesProvide details in Materials Tab$ - 0$ - 0
EquipmentProvide details in Equip. Tab$ - 0$ - 0
TravelProvide details in Travel Tab$ - 0$ - 0
Other ODCsProvide details in other ODC Tab$ - 0$ - 0
Total Other Direct Costs$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Material Handling (if applicable see note 3)See Note 3BaseRateBaseRateBaseRateBaseRateBaseRateBaseRate
Total Material Handling Costs$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

Subtotal Cost $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $0.00 $ - 0

General and Administrative (G&A) / Facilities and Administration (F&A) (if F&A see note 4) See Note 4 Base tc={0CE4E0F3-B411-40AA-92BC-6EF8820A8587}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

For Universities: Use MTDC base as applicable Rate Base tc={3AD27D8E-7400-4072-BC5B-2A0344B67DC0}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

For Universities: Use MTDC base as applicable Rate Base tc={4227A699-0BE4-46E8-8090-58BD389F7857}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

For Universities: Use MTDC base as applicable Rate Base tc={E0C975F0-3E02-4914-8461-2C655845DA39}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

For Universities: Use MTDC base as applicable Rate Base tc={2A193924-D991-4AFC-B7D3-19C7F04D6968}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

For Universities: Use MTDC base as applicable tc={1D08FF4B-5966-4642-B19B-D25B04A61208}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Insert formulas in Column as appropriate. See Note 3 tc={3AD27D8E-7400-4072-BC5B-2A0344B67DC0}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

For Universities: Use MTDC base as applicable Rate Base tc={7DC60369-E9AC-4EA1-AEA7-4D52A80E99F1}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

For Universities: Use MTDC base as applicable tc={0B11B64A-CD5B-489A-A18B-CE62F132541B}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Insert formulas in Column as appropriate. See Note 3 tc={4227A699-0BE4-46E8-8090-58BD389F7857}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

For Universities: Use MTDC base as applicable tc={90A6E888-1A75-4266-98F9-4B8314C515C6}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Insert formulas in Column as appropriate. See Note 3 tc={E374389D-2B3C-4089-B85A-FEBDFFCA2F7F}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Insert formulas in Column as appropriate. See Note 3 tc={37D6EDB9-9504-49E9-B8D5-667BE466E0CD}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Insert formulas in Column as appropriate. See Note 3 tc={50BD16B6-8BEC-4961-8C22-B411A15ABE5C}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Break out all ODCs by Phase/CFY that equals the grand total on corresponding worksheets & Subtotal Column tc={D4345C74-5B9A-4A43-B1D4-D9DCEE15F4F5}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Break out all ODCs by Phase/CFY that equals the grand total on corresponding worksheets & Subtotal Column tc={E0C975F0-3E02-4914-8461-2C655845DA39}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

For Universities: Use MTDC base as applicable tc={274927CE-D48C-4461-ACC5-6763DC3F958C}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Insert formulas in Column as appropriate. See Note 3 tc={68F51A89-1F22-4FE7-9CD3-A891344E3A10}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Insert formulas in Column as appropriate. See Note 3 tc={C2B85035-6466-41B9-847D-3B9A1AB021F9}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Break out all ODCs by Phase/CFY that equals the grand total on corresponding worksheets & Subtotal Column tc={5E969442-EE9C-4498-88CB-2EF13BB42D91}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Break out all ODCs by Phase/CFY that equals the grand total on corresponding worksheets & Subtotal Column

Rate
Total G&A/F&A Cost$0.00$ - 0$0.00$ - 0$0.00$ - 0$0.00$ - 0$0.00$ - 0$0.00$ - 0$ - 0

Total Cost $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Facilities Capital Cost of Money (COM)BaseRateBaseRateBaseRateBaseRateBaseRateBaseRate
Insert COM Rate Title. Insert additional line(s) & title(s) for any other COM rates as needed$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total COM$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
BaseRateBaseRateBaseRateBaseRateBaseRateBaseRate
Fee/Profit$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Cost Plus Fee (or Total Price)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DSO Fundamental Defense Research Talent Award (FDRTA)/ Industry Immersion Program (IIP) Option$ - 0
Total Cost Plus Fee Including FDRTA/ IIP Option$ - 0
Instructions:

• This spreadsheet must be used by all Primes and Subcontractors. Each organization must complete a separate spreadsheet.

• The Direct Labor Hours can be discretly estimated hours or extrapolated hours from a percentage of full time effort dedicated to the program (e.g. Academia)

• For PRIME submission – Subcontractor/Interorganizational Name: If there are subcontracts, list all subcontractor names

• In upper right last column (cell AK9), replace the X in X-Months with actual number of months for the Base and Options

• 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 C.

• Do not delete any cells, rows, or columns as it may distort formulas that are implemented

Note 1: Personnel Identification: For each proposed person/labor category in the technical proposal, list both your company's labor category and select the corresponding DARPA labor category.
Note 2: or the Period of Performance (PoP), enter the Base Phase 1 PoP in row 10. Model is based on Jan - Dec performer fiscal year. If the proposer's FY is different, adjust the worksheet as necessary or submit a question to the BAA team. Ensure all dates match your technical proposal.
Note 3: Indirect Rates: Enter your company's applicable indirect rates in the purple columns. If rate categories do not apply leave cells blank. For each indirect rate, include a traceable formula showing the calculation based on the rate and application base, following your company's accounting procedures.
Note 4: Universities: Use F&A rates (instead of G&A) with a Modified Total Direct Cost (MTDC) application base. All calculations must have traceable formulas.
Note 5: Other Transaction (OT) Awards: Complete the Milestone Tabs only if proposing an OT award.
To determine the Hourly Rate used by a salaried occupation, utilize the formula set forth below. The first line is an example of how the formula works. The second line allows the University to input the necessary data in the yellow cells only, to populate an hourly rate. The University will then place that Hourly Rate in the applicable field above in the Direct Rate columns (E, M, U, or AC).
Annual Salary# of months Comprising Annual Salary$ Per Month RateNumber of Work hours per monthHourly Rate
Example$150,000.0012$ 12,500.00176$ 71.02
University: input data in yellow cells onlyUniversity: replace this line with Job Title$ - 0$ - 0Carry this rate to the applicable field above in the Direct Rate columns.
University: replace this line with Job Title$ - 0$ - 0Carry this rate to the applicable field above in the Direct Rate columns.
University: replace this line with Job Title$ - 0$ - 0Carry this rate to the applicable field above in the Direct Rate columns.
University: replace this line with Job Title$ - 0$ - 0Carry this rate to the applicable field above in the Direct Rate columns.
University: replace this line with Job Title$ - 0$ - 0Carry this rate to the applicable field above in the Direct Rate columns.
University: replace this line with Job Title$ - 0$ - 0Carry this rate to the applicable field above in the Direct Rate columns.
University: replace this line with Job Title$ - 0$ - 0Carry this rate to the applicable field above in the Direct Rate columns.
University: replace this line with Job Title$ - 0$ - 0Carry this rate to the applicable field above in the Direct Rate columns.
University: replace this line with Job Title$ - 0$ - 0Carry this rate to the applicable field above in the Direct Rate columns.
University: replace this line with Job Title$ - 0$ - 0Carry this rate to the applicable field above in the Direct Rate columns.

Insert formulas in Column as appropriate. See Note 3

Insert formulas in Column as appropriate. See Note 3

Insert formulas in Column as appropriate. See Note 3

Insert formulas in Column as appropriate. See Note 3

Insert formulas in Column as appropriate. See Note 3

Insert formulas in Column as appropriate. See Note 3

Insert formulas in Column as appropriate. See Note 3

Break out all ODCs by Phase/CFY that equals the grand total on corresponding worksheets & Subtotal Column

Break out all ODCs by Phase/CFY that equals the grand total on corresponding worksheets & Subtotal Column

Break out all ODCs by Phase/CFY that equals the grand total on corresponding worksheets & Subtotal Column

Break out all ODCs by Phase/CFY that equals the grand total on corresponding worksheets & Subtotal Column

For Universities: Use MTDC base as applicable

For Universities: Use MTDC base as applicable

For Universities: Use MTDC base as applicable

Materials-Supplies

MATERIALS - SUPPLIES (Note 1)
See Instructions Below
Item
(Note 2)Description of Material/ SupplyQtyUnit PriceExtended PriceCompetitive / Commercial/ Sole SourceVendor/Source (If known)Basis of Estimate (Note 3)Supporting documentation has been provided (Y/N) (Note 3)Reference Document Number
Base$0.00Y
1$0.00N
2$0.00
3$0.00
4$0.00
5$0.00
Option I$0.00
6$0.00
7$0.00
8$0.00
9$0.00
10$0.00
Option Phase 2$0.00
11$0.00
12$0.00
13$0.00
14$0.00
15$0.00
TOTAL$0.00
Total must match Total Amount worksheet

Instructions: • Fill out all columns on the Materials/Supplies Tab for each item. Subtotals and Totals must match Total Amount worksheet

• Insert the most specific unit description of material in column B. Avoid general descriptions of categories of material.

• In column F, indicate is the material line is competitive, commercial (e.g. catalog, internet, price list) or a sole source manufactured item

• Provide vendor or source name in Column G

• Add additional lines if needed.

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.

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: Column H, insert a basis of estimate for each material line item (e.g. vendor quote, internet pricing, historical pricing, etc). Column I, in an attachment, provide supporting documentation for all items with an extended price of $5000 or greater, e.g. copy of vendor quote, past invoice/PO, page from catalog, or method used for deriving engineering estimates. • Clearly label Materials/Supplies backup with a Reference Document Number in the format of MAT000 starting with MAT001. Place the Reference Document Number in the upper right hand side of the backup page. If there are several quotes on a page, items not desired must be lined out and each desired item must have a separate reference number placed to the left of the item on the backup page. The Reference Document Number must be listed next to the appropriate item on the Materials/Supplies worksheet under the Reference Document Number column.

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

• Number Reference Document Numbers sequentially so they match the Item number in the Base. For example, Item number 1 should match MAT001. If the same items are used again in the options, there is no need to renumber or add additional copies of the backup, but list the items sequentially for each option by Reference Document Number. As an example, MAT010 could be used for Base item number 10, Option I item number 1 and Option II Item number 6.

Equipment List EQUIPMENT (Note 1) Subtotals and Totals must match Total Amount worksheet

Item
(Note 2)Description of Equipment (Note 1)Justification for why the equipment is neededWill 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/SourceBasis of Estimate (Note 4)Supporting documentation has been provided (Y/N)
(Note 4)Reference Document Number
Base$ - 0Y
$ - 0
$ - 0N
$ - 0
$ - 0
Option I$ - 0
$ - 0
$ - 0
Option Phase 2$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
TOTAL$ - 0
Total must match Total Amount worksheet
Instructions:• Subtotals and Totals must match Total Amount worksheet

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

• Add additional lines if needed.

• Provide justification for equipment. Be sure to indicate the benefit(s) to the Government. Expand on any statements along the lines of “It is needed to support the project deliverables”. Costs must be approved by the Program Officer. Link the justification to the type of equipment purchase, i.e. special test equipment, special tooling, or plant equipment.

• Include supporting documentation for each entry with unit cost over $5,000. Backup may consist of a vendor quote, past purchase order or invoice, information from a website, or a detailed explanation of labor and material costs for custom made items.

• Label equipment backup clearly with a Reference Document Number in the format of EQ000 starting with EQ001. Place the Reference Document Number in the upper right hand side of the backup page. If there are several quotes on a page, items not desired must be lined out and each desired item must have a separate reference number placed to the left of the item on the backup page. The Reference Document Number must be listed next to the appropriate item on the Equipment worksheet under the Reference Document Number column.

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

• Number Reference Document Numbers sequentially so they match the Item number in the Base. For example, Item number 1 should match EQ001. If the same items are used again in the options, there is no need to renumber or add additional copies of the backup, but list the items sequentially for each option by Reference Document Number. As an example, EQ010 could be used for Base item number 10, Option I item number 1 and Option II Item number 6.

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: In an attachment, provide all supporting documentation to support your price basis, e.g. copy of vendor quote, past invoice/PO, page from catalog, or method used for deriving engineering estimates.

Travel

TRAVEL(Notes 1, 2 and 3)
Proposers fill out yellow cells only.
TRAVEL DETAIL
Trip # (list)Base / OptionPurpose of TripOrigin DestinationFinal Destination# People# Days# Nights HotelRound Trip Airfare/ Trainfare Cost Per PersonTotal Airfare/ Trainfare CostHotel Per Diem Rate per personTotal Hotel cost per trip# days at 100% M&IE per diem per personM&IE Per Diem Rate per personTotal M&IE Per Diem Cost per tripTotal Non Airfare/Trainfare Transportation Fees (e.g. rental cars fee/taxi/Uber)Conference FeesOther Expenses (tolls, parking, rental gas)TOTAL DIRECT DOLLARS
0$ - 0$ - 00$0.00$ - 0
0$ - 0$ - 00$0.00$ - 0
0$ - 0$ - 00$0.00$ - 0
0$ - 0$ - 00$0.00$ - 0
Base Total Travel$ - 0
0$ - 0$ - 00$0.00$ - 0
0$ - 0$ - 00$0.00$ - 0
0$ - 0$ - 00$0.00$ - 0
0$ - 0$ - 00$0.00$ - 0
Option 1 Total Travel$ - 0
0$ - 0$ - 00$0.00$ - 0
0$ - 0$ - 00$0.00$ - 0
0$ - 0$ - 00$0.00$ - 0
0$ - 0$ - 00$0.00$ - 0
Phase 2 Option Total Travel$ - 0
GRAND TOTAL TRAVEL$ - 0
Total must match Total Amount worksheet

Instructions: • When completing the “Origin” and “Final” Destination 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. All travel must directly support the objectives of the program.

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

• The first day and the last day of travel are charged at 75% of the M&IE per diem rate. If you travel for just one day (lasting 12 hours or more), the M&IE per diem rate is also charged at 75%. For answers to FAQs about per diem and travel rates, please review: https://www.gsa.gov/travel/plan-book/per-diem-rates/frequently-asked-questions-per-diem.

• Column P for Non Airfare Transportation would be for Uber, Lift, Subways, Car Rental, Personal Vehicle Mileage, etc. just to name a few examples.

• Do not combine any categories.

• For lodging and M&IE, use federal Per Diem Rates found at https://www.gsa.gov.

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

Other ODCs

OTHER DIRECT COSTS (Note 1)
See Instructions Below
Description
(Note 2)QtyUnit of IssueUnit PriceExtended PriceBasis of Estimate (Note 3)Supporting documentation has been provided (Y/N) (Note 3)Reference Document Number
Base$ - 0Y
$ - 0N
$ - 0
$ - 0
$ - 0
$ - 0
Option I$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
Phase 2 Option$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
TOTAL$ - 0
Total must match Total Amount worksheet

Instructions:

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

Note 1: Examples include tuition, 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 if needed.

Note 3: In an attachment, provide all supporting documentation to support your price basis, e.g. copy of quote, page from catalog, or method used for deriving engineering estimates. Include supporting documentation for each entry with unit extended price $5,000 or greater. Backup may consist of a vendor quote, past purchase order/invoice, information from a website, or a detailed explanation of labor and material costs for custom made items.

• Label ODC backup clearly with a Reference Document Number in the format of ODC000 starting with ODC001. Place the Reference Document Number in the upper right hand side of the backup page. If there are several quotes on a page, make sure each desired item has a separate reference number placed to the left of the item on the backup page. The Reference Document Number must be listed next to the appropriate item on the ODC worksheet under the Reference Document Number column.

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

• Number Reference Document Numbers sequentially so they match the Item number in the Base. For example, Item number 1 should match ODC001. If the same items are used again in the options, there is no need to renumber or add additional copies of the backup, but list the items sequentially by Reference Document Number. As an example, ODC002 could be used for Base item number 2, Option I item number 1 and Option II Item number 1.

FDRTA Option This sheet is for the DSO Fundamental Defense Research Talent Award (FDRTA) Option ($150,000 maximum per year, Phasing below)

Base Phase 1 (18 Months- Maximum $225,000)
Graduate Student/Post-Doctoral Researcher CostsMo. 1Mo. 2Mo. 3Mo. 4Mo. 5Mo. 6Mo. 7Mo. 8Mo. 9Mo. 10Mo. 11Mo. 12Mo. 13Mo. 14Mo. 15Mo. 16Mo. 17Mo. 18Total
Tuition$0.00
Stipend$0.00
Research Materials$0.00
Travel$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
Total$0.00
Option 1 (6 Months- Maximum $75,000)
Graduate Student/Post-Doctoral Researcher CostsMo. 1Mo. 2Mo. 3Mo. 4Mo. 5Mo. 6Total
Tuition$0.00
Stipend$0.00
Research Materials$0.00
Travel$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
Total$0.00
Phase 2 Option (18 Months -Maximum $225,000).
Graduate Student/Post-Doctoral Researcher CostsMo. 1Mo. 2Mo. 3Mo. 4Mo. 5Mo. 6Mo. 7Mo. 8Mo. 9Mo. 10Mo. 11Mo. 12Mo. 13Mo. 14Mo. 15Mo. 16Mo. 17Mo. 18Total
Tuition$0.00
Stipend$0.00
Research Materials$0.00
Travel$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
Total$0.00

Grand Total FDRTA $0.00

IIP Option This sheet is for the DSO Industry Immersion Program (IIP) Option ($160,000 maximum per university partner, limited to 1 student per university, 9 to 12 months duration)

Base Phase 1 (18 Months)
Graduate Student/Post-Doctoral Researcher CostsMo. 1Mo. 2Mo. 3Mo. 4Mo. 5Mo. 6Mo. 7Mo. 8Mo. 9Mo. 10Mo. 11Mo. 12Mo. 13Mo. 14Mo. 15Mo. 16Mo. 17Mo. 18Total
Labor$0.00
Travel$0.00
Lodging$0.00
Per Diem Expenses$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
Total$0.00
Option 1 (6 Months)
Graduate Student/Post-Doctoral Researcher CostsMo. 1Mo. 2Mo. 3Mo. 4Mo. 5Mo. 6Total
Labor$0.00
Travel$0.00
Lodging$0.00
Per Diem Expenses$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
Total$0.00
Phase 2 Option (18 Months )
Graduate Student/Post-Doctoral Researcher CostsMo. 1Mo. 2Mo. 3Mo. 4Mo. 5Mo. 6Mo. 7Mo. 8Mo. 9Mo. 10Mo. 11Mo. 12Mo. 13Mo. 14Mo. 15Mo. 16Mo. 17Mo. 18Total
Labor$0.00
Travel$0.00
Lodging$0.00
Per Diem Expenses$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
Total$0.00

Grand Total IIP $0.00

LCAT Picklist

Principal Program/Project Manager
Program/Project Manager V
Program/Project Manager IV
Program/Project Manager III
Program/Project Manager II
Program/Project Manager I
Principal Scientist/Engineer
Scientist/Engineer V
Scientist/Engineer IV
Scientist/Engineer III
Scientist/Engineer II
Scientist/Engineer I
Principal Software Developer
Software Developer V
Software Developer IV
Software Developer III
Software Developer II
Software Developer I
Principal Manufacturer
Manufacturer V
Manufacturer IV
Manufacturer III
Manufacturer II
Manufacturer I
Principal Quality Control (Manufacturing)
Quality Control V (Manufacturing)
Quality Control IV (Manufacturing)
Quality Control III (Manufacturing)
Quality Control II (Manufacturing)
Quality Control I (Manufacturing)
Consultant (General)
Administrative Support
Security
Financial
Contracts
Principal Investigator
Co-Principal Investigator
Faculty/Professor
Sr. Post-Doc
Post-Doc
Research Scientist/Engineer
Research Associate
Research Assistant
Staff Scientist
Graduate Research Assistant
Graduate Student
Student

image1.png image2.png

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