DARPA_PS_26_137_Firefox_Attach_D_Cost_Proposal_Spreadsheet.xlsx
XLSX spreadsheet 102 KB Posted
- Attached to
- Firefox
- Solicitation number
- DARPA-PS-26-137
About this file
This is a DARPA Streamlined Cost Proposal Spreadsheet template for the Firefox program (DARPA-PS-26-137) designed for use by prime contractors and subcontractors to submit detailed cost proposals. The spreadsheet accommodates multiple contract phases, including a Base Phase and optional Phase 2, organized by Contractor Fiscal Year (CFY) with separate columns for each phase. Proposers must complete labor categories by listing employee names, hours, direct rates, fringe benefits rates, overhead rates, and other burden costs with traceable formulas for all calculations. The template requires completion of supporting detail worksheets for Materials/Supplies, Equipment, Travel, and Other Direct Costs (ODCs), with each line item necessitating vendor quotes, basis of estimate documentation, and sequential reference numbering (MAT001, EQ001, ODC001, etc.). Additional cost elements include subcontractor/interorganizational transfer costs, consultant fees, material handling costs, General and Administrative (G&A) or Facilities and Administration (F&A) rates (with universities required to use Modified Total Direct Cost bases), Facilities Capital Cost of Money, and fee/profit calculations, all of which must reconcile with subtotals and totals across worksheets.
The spreadsheet includes specialized guidance for different organization types, including a calculation methodology for universities converting annual salaries to hourly rates using 176 work hours per month and a separate section for Other Transaction (OT) award milestones if applicable. All indirect rates (overhead, fringe, G&A/F&A) must be entered in designated purple columns with formulas showing calculations based on applicable rate and base. Travel costs require detailed breakdown by trip including origin/destination, number of personnel, airfare, lodging per diem at federal GSA rates, meals and incidental expenses, car rental, mileage reimbursement, conference fees, and miscellaneous expenses, with backup documentation required for airfare and rental cars. Equipment proposals must include justification for why items are needed, identification as special test equipment, special tooling, general purpose equipment, or plant equipment, and supporting vendor quotes. The template structure ensures all cost data flows to a Total Amount worksheet that consolidates Base and Option phase costs into a final Total Cost Plus Fee (or Total Price) figure.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| DARPA-PS-26-137.pdf | ||
| DARPA_PS_26_137_Firefox_Attach_C_Model_OT_for_Prototype.docx | DOCX document | |
| DARPA_PS_26_137_Firefox_Attch_B_Abstract_Template.docx | DOCX document | |
| DARPA_PS_26_137_Firefox_Attch_A_Abstract_Summary_Template.pptx | PPTX presentation | |
| DARPA_PS_26_137_Firefox_Attch_F_OPP_Guidelines_and_Instructions.docx | DOCX document | |
| DARPA_PS_26_137_Firefox_Attch_G_Risk_Matrix.pptx | PPTX presentation | |
| DARPA_PS_26_137_Firefox_Attch_E_Milestone_and_Payment_Schedule.xlsx | XLSX spreadsheet |
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
Total Amount
| DARPA Streamlined Cost Proposal Spreadsheet SEPT 2025- See Detailed Instructions Below Cost Information and User Guide on Last Tab |
| 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: | |||||||
| Prime or Subcontractor (dropdown): | (Fill-in) | ||||||
| CAGE CODE: | (Note 2) | (Note 2) | |||||
| Base Phase 1 (CFY2X MM/YY to MM/YY) | Base Phase 1 (CFY2X MM/YY to MM/YY) | (Option) Phase 2 (CFY2X MM/YY to MM/YY) | (Option) Phase 2 (CFY2X MM/YY to MM/YY) | Total | |||
| Direct Labor (DL) | Enter Project PoP as "MM/YY to MM/YY" | Enter Project PoP as "MM/YY to MM/YY" | X-Months |
wade.wargo: Indicate the actual number of total months for the Base and Options.
Proposer's Labor Category (Note 1) DARPA Labor Category (Note 1) Name (Last, First) Hours Direct Rate Direct Cost Fringe Benefits Rate Fringe Benefits Cost tc={C15C1224-4BB6-4DB7-B485-EA952DD5E350}: [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={894B67DA-C0FD-4CA4-B965-C1FD474EE571}: [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={F4C2F5D9-F519-48E1-9FB7-BDA73E969B99}: [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={11A0C477-137F-4CC4-9291-992887BE30E4}: [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={85CE8FD7-A42D-4E76-B938-002F37932C1A}: [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 | Subtotal | |||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | |||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | |||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | |||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | |||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | |||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | |||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | |||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | |||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | |||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | |||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | |||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | |||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | |||||||||||||
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | $ - 0 | |||||||||||||||||||||||||||
| Direct Costs: | 0.00 | $ - 0 | $ - 0 | 0.00 | $ - 0 | $ - 0 | 0.00 | $ - 0 | $ - 0 | 0.00 | $ - 0 | $ - 0 | - 0 | $ - 0 | ||||||||||||||||
| Fringe Costs: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||||||||||||||
| Overhead Costs: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||||||||||||||
| Cost | Cost | Cost | Cost | |||||||||||||||||||||||||||
| Subcontracts/Interorganizational Transfer | CAGE CODE | |||||||||||||||||||||||||||||
| Subcontract/Interorganizational Name - #01 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||||||||||||||
| Subcontract/Interorganizational Name - #02 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||||||||||||||
| Subcontract/Interorganizational Name - #03 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||||||||||||||
| Insert line(s) for any additional Subcontractors/Interorganizational | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||||||||||||||
| Subtotal Subcontract Costs | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||||||||||||||
| Subcontract Overhead (if applicable see note 3) | See Note 3 | Base | Rate | Base | Rate | Base | Rate | Base | Rate | |||||||||||||||||||||
| Subcontract Overhead Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||||||||||||||
| Consultants |
tc={9B9C093F-C7D9-4FB0-86ED-358CC50826B8}: [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 Consultant name | Hours | Rate | Hours | Rate | Hours | Rate | Hours | Rate | |||||||||||||||||
| Total Consultant Costs | $ - 0 | $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | |||||||||||||||||||
| Other Direct Costs: | Check sum | ||||||||||||||||||||||||
| Materials/Supplies | Provide details in Materials Tab | $ - 0 | $ - 0 | ||||||||||||||||||||||
| Equipment | Provide details in Equip. Tab | $ - 0 | $ - 0 | ||||||||||||||||||||||
| Travel | Provide details in Travel Tab | $ - 0 | $ - 0 | ||||||||||||||||||||||
| Other ODCs | Provide details in other ODC Tab | $ - 0 | $ - 0 | ||||||||||||||||||||||
| Total Other Direct Costs | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||||||||
| Material Handling (if applicable see note 3) | See Note 3 | Base | Rate | Base | Rate | Base | Rate | Base | Rate | ||||||||||||||||
| Total Material Handling Costs | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||
| Subtotal Cost | $ - 0 | ||||||||||||||||||||||||
| General and Administrative (G&A) / Facilities and Administration (F&A) (if F&A see note 4) | See Note 4 | Base |
tc={2356491F-9D67-4FBC-B9CF-BE08670C8ABD}: [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={3F28F886-6A1A-4342-B693-4303805BD372}: [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={DBFACA4E-2A45-4A8C-AF7B-50EE2A20F5E0}: [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={85CE8FD7-A42D-4E76-B938-002F37932C1A}: [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 wade.wargo: Indicate the actual number of total months for the Base and Options. Rate Base tc={CA9090EF-060C-4066-B3DF-65609ED2F801}: [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={C15C1224-4BB6-4DB7-B485-EA952DD5E350}: [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={6BFA78AF-0603-438A-BC67-FCF4A558393C}: [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={894B67DA-C0FD-4CA4-B965-C1FD474EE571}: [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={72942640-EC15-458F-AA31-1B378BB542CA}: [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={A22E0EB2-2ED6-44FF-9C9B-E9CBFEB4FEE8}: [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={1BEBC389-C5F8-43DC-BE2E-FC33D22048AF}: [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={2356491F-9D67-4FBC-B9CF-BE08670C8ABD}: [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={F4C2F5D9-F519-48E1-9FB7-BDA73E969B99}: [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={3F28F886-6A1A-4342-B693-4303805BD372}: [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 | |||||||||||||
| Total G&A/F&A Cost | $0.00 | $ - 0 | $0.00 | $ - 0 | $0.00 | $ - 0 | $0.00 | $ - 0 | $ - 0 | |||||
| Total Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||
| Facilities Capital Cost of Money (COM) | Base | Rate | Base | Rate | Base | Rate | Base | Rate | ||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| Total COM | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||
| Fee/Profit | Rate: | 0.00% | Rate: | 0.00% | $ - 0 | Rate: | 0.00% | $ - 0 | Rate: | 0.00% | $ - 0 | $ - 0 | ||
| Total Cost Plus Fee (or Total Price) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||
| Instructions: |
• This spreadsheet must be used by all Primes and Subcontractors. Each organization must complete a separate spreadsheet. See the Volume 2 (Cost) template for additional submission information.
• 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 9, referencing the applicable Contractor Fiscal Year (CFY) in row 8. If an Option Phase 2 is applicable, enter its PoP in row 9 and its CFY in the appropriate cell(s) in row 8 ; otherwise, leave Option Phase 2 blank. 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 Rate | Number of Work hours per month | Hourly Rate | |||
| Example | $150,000.00 | 12 | $ 12,500.00 | 176 | $ 71.02 | ||
| University: input data in yellow cells only | University: replace this line with Job Title | $ - 0 | $ - 0 | Carry this rate to the applicable field above in the Direct Rate columns. | |||
| University: replace this line with Job Title | $ - 0 | $ - 0 | Carry this rate to the applicable field above in the Direct Rate columns. | ||||
| University: replace this line with Job Title | $ - 0 | $ - 0 | Carry this rate to the applicable field above in the Direct Rate columns. | ||||
| University: replace this line with Job Title | $ - 0 | $ - 0 | Carry this rate to the applicable field above in the Direct Rate columns. | ||||
| University: replace this line with Job Title | $ - 0 | $ - 0 | Carry this rate to the applicable field above in the Direct Rate columns. | ||||
| University: replace this line with Job Title | $ - 0 | $ - 0 | Carry this rate to the applicable field above in the Direct Rate columns. | ||||
| University: replace this line with Job Title | $ - 0 | $ - 0 | Carry this rate to the applicable field above in the Direct Rate columns. | ||||
| University: replace this line with Job Title | $ - 0 | $ - 0 | Carry this rate to the applicable field above in the Direct Rate columns. | ||||
| University: replace this line with Job Title | $ - 0 | $ - 0 | Carry this rate to the applicable field above in the Direct Rate columns. | ||||
| University: replace this line with Job Title | $ - 0 | $ - 0 | Carry 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 Consultant name
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
Materials-Supplies
| MATERIALS - SUPPLIES (Note 1) | Subtotals and Totals must match Total Amount worksheet | |||||||||
| See Instructions Below | ||||||||||
| Item | ||||||||||
| (Note 2) | Description of Material/ Supply | Qty | Unit Price | Extended Price | Competitive / Commercial/ Sole Source | Vendor/Source (If known) | Basis of Estimate (Note 3) | Supporting documentation has been provided (Y/N) (Note 3) | Reference Document Number | |
| Base | $0.00 | Y | ||||||||
| 1 | $0.00 | N | ||||||||
| 2 | $0.00 | |||||||||
| 3 | $0.00 | |||||||||
| Option I | $0.00 | |||||||||
| 4 | $0.00 | |||||||||
| 5 | $0.00 | |||||||||
| 6 | $0.00 | |||||||||
| 7 | $0.00 | |||||||||
| TOTAL | $0.00 |
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, included as a seperate attachment, should provide supporting documentation for 60% of the total proposed material (from highest to lowest cost per item), e.g. copy of vendor quote, past invoice/PO, page from catalog, or method used for deriving engineering estimates. Notes: DARPA reserves the right to request for more quotes as deemed necessary for cost analaysis during negotiation.
• 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, and Option I item number1.
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 needed | 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) | Qty | Unit of Issue | Unit Price | Total Price | Vendor/Source | Basis of Estimate (Note 4) | Supporting documentation has been provided (Y/N) | |||
| (Note 4) | Reference Document Number | |||||||||
| Base | $0 | Y | ||||||||
| $0 | N | |||||||||
| $0 | ||||||||||
| Option I | ||||||||||
| $0 | ||||||||||
| TOTAL | $0 | |||||||||
| 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 all proposed 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. 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 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) Subtotals and Totals must match Total Amount worksheet
| TRAVEL DETAIL | ||||||||||||||||||||||||||||
| Base / Option / Task | Purpose of Trip | Origin Destination | Final Destination | # People | # Days | # of Trips | # days at 100% Hotel per diem | # days at 100% M&IE per diem | # days at 75% M&IE per diem | Round Trip Airfare/ Trainfare per person | Total Airfare/ Trainfare $ per Trip | Hotel Per Diem Rate per person | Total Hotel Per Diem $ per trip | M&IE Per Diem Rate per person | 100% M&IE Per Diem $ | 75% M&IE Per Diem $ | Total M&IE Per Diem $ per trip | Car Rental dollars per day including Taxes & Fees | # of Cars (1-3 people per car) | Total Car rental $ per trip | Standard Personal Car Mileage Rate | Estimated Number of Round trip Miles per Car | # of Personal Cars | Total Mileage Rate Dollars | Conference Fees | Other Expenses (tolls, parking, rental gas, wi-fi) | TOTAL DIRECT DOLLARS PER TRIP | GRAND TOTAL DIRECT DOLLARS FOR ALL TRIPS |
| 0 | 0 | 0 | $ - 0 | $ - 0 | $0.00 | $0.00 | $ - 0 | $ - 0 | $ - 0 | $ - | $ - | |||||||||||||||||
| 0 | 0 | 0 | $ - 0 | $ - 0 | $0.00 | $0.00 | $ - 0 | $ - 0 | $ - 0 | $ - | $ - | |||||||||||||||||
| 0 | 0 | 0 | $ - 0 | $ - 0 | $0.00 | $0.00 | $ - 0 | $ - 0 | $ - 0 | $ - | $ - | |||||||||||||||||
| 0 | 0 | 0 | $ - 0 | $ - 0 | $0.00 | $0.00 | $ - 0 | $ - 0 | $ - 0 | $ - | $ - | |||||||||||||||||
| Base Total Travel | $ - | |||||||||||||||||||||||||||
| 0 | 0 | 0 | $ - 0 | $ - 0 | $0.00 | $0.00 | $ - 0 | $ - 0 | $ - 0 | $ - | $ - | |||||||||||||||||
| 0 | 0 | 0 | $ - 0 | $ - 0 | $0.00 | $0.00 | $ - 0 | $ - 0 | $ - 0 | $ - | $ - | |||||||||||||||||
| 0 | 0 | 0 | $ - 0 | $ - 0 | $0.00 | $0.00 | $ - 0 | $ - 0 | $ - 0 | $ - | $ - | |||||||||||||||||
| 0 | 0 | 0 | $ - 0 | $ - 0 | $0.00 | $0.00 | $ - 0 | $ - 0 | $ - 0 | $ - | $ - | |||||||||||||||||
| Option Total Travel | $ - | |||||||||||||||||||||||||||
| GRAND TOTAL TRAVEL | $ - |
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. 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.
• 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.
• 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) | Subtotals and Totals must match Total Amount worksheet | |||||||
| See Instructions Below | ||||||||
| Description | ||||||||
| (Note 2) | Qty | Unit of Issue | Unit Price | Extended Price | Basis of Estimate (Note 3) | Supporting documentation has been provided (Y/N) (Note 3) | Reference Document Number | |
| Base | $0 | Y | ||||||
| $0 | N | |||||||
| $0 | ||||||||
| Option I | $0 | |||||||
| $0 | ||||||||
| $0 | ||||||||
| $0 | ||||||||
| TOTAL | $0 |
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 labeled with Options 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 (100%). 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, and Option I item number 1.
image1.png image2.png
File details come from the government source that posted it. Updated .