Attachment_G_DARPA_Cost_Proposal_Spreadsheet.xlsx
XLSX spreadsheet 124 KB Posted
- Attached to
- Defense Sciences Office (DSO) Office-wide BAA
- Solicitation number
- HR001126S0015
About this file
This is the DARPA Streamlined Cost Proposal Spreadsheet template for the Defense Sciences Office (DSO) Office-wide Broad Agency Announcement (BAA) solicitation HR001126S0015. The spreadsheet is designed for use by both prime contractors and subcontractors to submit cost proposals for innovative research projects supporting national security applications. All calculations within the spreadsheet must contain traceable formulas, and proposers must complete separate spreadsheets for each organization involved.
The template accommodates multiple performance phases, including a Base Phase 1 and optional Phase 2, with cost tracking across multiple fiscal years. Cost categories include direct labor (organized by labor category with hours, rates, and burden calculations), fringe benefits, overhead costs, subcontractor costs, consultant fees, and other direct costs (materials/supplies, equipment, travel, and miscellaneous ODCs). The spreadsheet includes specialized tabs for detailed breakdowns of materials, equipment, travel, and other direct costs, each requiring supporting documentation for items exceeding $5,000. Additional worksheets address General and Administrative/Facilities and Administration costs, Cost of Money calculations, Fee/Profit determinations, and a Schedule of Milestones and Payments. For universities, the template provides Modified Total Direct Cost (MTDC) application bases for F&A rates rather than G&A rates. A supplementary FDRTA (Fundamental Defense Research Talent Award) option tab accommodates graduate student and post-doctoral researcher costs up to $150,000 annually, including tuition, stipends, research materials, and travel. Reference documentation must be clearly labeled with sequential numbering (MAT001, EQ001, ODC001, etc.) and cross-referenced on the respective worksheets.
View the file
Other files
Show all 16
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 Option $ - 0
TOTAL COST PLUS FEE (OR TOTAL PRICE) $ - 0
Total Amount
| DARPA Streamlined Cost Proposal Spreadsheet DSO Office Wide BAA- 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) | |||||
| 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) | Base Phase 1 (CFY2X MM/YY to MM/YY) | Enter Project PoP as "MM/YY to MM/YY" | XX Months |
tc={AF3C7959-E7A9-47E3-A506-BE05EC295B54}: [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 Number of Total Months 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={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={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 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 | |||||||||||||
| 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 | |||||||||||||||||||||||||||
| Sub-awardees/Subcontracts/Interorganizational Transfer | CAGE CODE | |||||||||||||||||||||||||||||
| Sub-awardee/Subcontract/Interorganizational Name - #01 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||||||||||||||
| Sub-awardee/Subcontract/Interorganizational Name - #02 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||||||||||||||
| Sub-awardee/Subcontract/Interorganizational Name - #03 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||||||||||||||
| Insert line(s) for any additional Sub-awardee/Subcontractors/Interorganizational | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||||||||||||||
| Subtotal Sub-awardee/Subcontract Costs/Interorganizational | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||||||||||||||
| Sub-awardee/Subcontract/Interorganizational Overhead (if applicable see note 3) | See Note 3 | Base | Rate | Base | Rate | Base | Rate | Base | Rate | |||||||||||||||||||||
| Subcontract Overhead Cost | $0.00 | $ - 0 | $0.00 | $ - 0 | $0.00 | $ - 0 | $0.00 | $ - 0 | $ - 0 |
| Consultants | Hours | Rate | Cost | Hours | Rate | Cost | Hours | Rate | Cost | Hours | Rate | Cost | |
| Consultant Name #1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||
| Consultant Name #2 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||
| Consultant Name #3 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||
| Consultant Name #4 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||
| Total Consultant Costs | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | $ - 0 |
| Other Direct Costs: | Cost | Cost | Cost | Cost | 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 $ - 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 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 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 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={AF3C7959-E7A9-47E3-A506-BE05EC295B54}: [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 Number of Total Months 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={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={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 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={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={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 |
Total Cost $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
| Facilities Capital Cost of Money (COM) | Base | Rate | Base | Rate | Base | Rate | Base | Rate | |||||
| Insert COM Rate Title. Insert additional line(s) & title(s) for any other COM rates as needed | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||
| Total COM | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||
| Base | Rate | Base | Rate | Base | Rate | Base | Rate | ||||||
| Fee/Profit | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||
| Total Cost Plus Fee (or Total Price) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| DSO Fundamental Defense Research Talent Award (FDRTA) | $ - 0 |
| Total Cost Plus Fee Including FDRTA 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 - see Academia calculator tool below.
• 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 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 Number of Total Months
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
Materials-Supplies
| MATERIALS - SUPPLIES (Note 1) | ||||||||||
| 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 | |||||||||
| 4 | $0.00 | |||||||||
| 5 | $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 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 | ||||||||||
| $ - 0 | N | |||||||||
| $ - 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 / Option | Purpose of Trip | Origin Destination | Final Destination | # People | # Days | # Nights Hotel | Round Trip Airfare/ Trainfare Cost Per Person | Total Airfare/ Trainfare Cost | Hotel Per Diem Rate per person | Total Hotel cost per trip | # days at 100% M&IE per diem per person | M&IE Per Diem Rate per person | Total M&IE Per Diem Cost per trip | Total Non Airfare/Trainfare Transportation Fees (e.g. rental cars fee/taxi/Uber) | Conference Fees | Other Expenses (tolls, parking, rental gas) | TOTAL DIRECT DOLLARS |
| 0 | $ - 0 | $ - 0 | 0 | $0.00 | $ - 0 | |||||||||||||
| 0 | $ - 0 | $ - 0 | 0 | $0.00 | $ - 0 | |||||||||||||
| 0 | $ - 0 | $ - 0 | 0 | $0.00 | $ - 0 | |||||||||||||
| 0 | $ - 0 | $ - 0 | 0 | $0.00 | $ - 0 | |||||||||||||
| Base Total Travel | $ - 0 | |||||||||||||||||
| 0 | $ - 0 | $ - 0 | 0 | $0.00 | $ - 0 | |||||||||||||
| 0 | $ - 0 | $ - 0 | 0 | $0.00 | $ - 0 | |||||||||||||
| 0 | $ - 0 | $ - 0 | 0 | $0.00 | $ - 0 | |||||||||||||
| 0 | $ - 0 | $ - 0 | 0 | $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) | 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 | ||||||||
| $ - 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.
Milestones instructions(note 5) Please complete this schedule of milestones and payments spreadsheet. This should contain information about proposed milestones, due dates, deliverables, and payments associated. The spreadsheet contains suggested milestones and schedule. Add, remove, or edit milestones as needed. Red milestones are required. Tasks and targets should be keyed to the Task Description Document. Note that "ACA" denotes "after contract award", and the highlighted sections are not to be filled out by proposers.
Helpful notes for Milestones:
• Each milestone will mark the completion of a measurable event (i.e., completing a baseline execution plan, completing measurable events in the performance of the research and development of the technology, completing and submitting the final report, etc.).
• Deliverable narrative should provide description of what is being delivered, the word “Report” is not sufficient. “Status/Progress/Reports” cannot be milestones.
• The milestone description will show how the milestone will be demonstrably completed.
• Payments associated with each milestone must reflect the actual comprehensive costs to achieve milestone completion. (Note do not take total cost and divide by number of milestones)
• Although this is a R&D effort the amounts against each milestone should NOT be the same. consider what actually goes into the pricing of that particular milestone as each milestone should have its own cost. (If amounts remain the same, please clearly expand the deliverable description)
• The milestones need to be more definitive and consider what actually goes into the pricing of that particular milestone.
• The milestone description will show how the milestone will be demonstrably completed.
• No advance payments on milestones
Three Milestone Examples:
| • | Kickoff Meeting presentation including project design, acquisition of equipment, and overall workflow leading to accomplishment of deliverables. Kickoff briefing package will include team organization, technical approach and research goals, expected results and schedule, and risk and mitigation strategies |
| • | Kick-off meeting presentation with description of proposed effort to include the description of proposed concept, focus area and potential application domain; Justification of proposed approach based on preliminary analyses or modeling; Justification of the benefits of the proposed scheme in achieving beyond-XXX performance in the potential application domain; Description and preliminary analyses of the proposed concept metrics that will be achieved during the period of performance, and comparison of these metrics to the current XXX. All supporting positions identified in the proposal are assigned to personnel, and names are provided to the Government. Order materials and equipment. |
| • | Design XXXX molecule candidate(s) and investigate simulated molecular conformation changes induced by the onset and offset of near infrared (NIR) light in the range of 750 nm to 900 nm, as well as simulated binding to target protein(s) of interest in the presence of NIR light. METRIC: XXXX candidates demonstrate molecular conformation change in the presence of NIR light in the range of XXX to XXX nm, and bind to target protein(s) of interest in the presence of NIR light in a simulated environment. |
Two Exit Criteria Examples:
• Submit kickoff meeting charts and Initial Test Plan
• Submit Milestone report describing design approach and molecular structure(s) of XXXX and simulation results.
Milestone Schedule (see note 5)
| 3 | ||||
| Milestone # | Milestones (Description) | Exit Criteria/Deliverable | Due | |
| Date | Payment | Funded | CLIN | |
| SUBCLIN | ACRN | |||
| … This is a suggested schedule of milestones. Propose your own as needed … | ||||
| 1 | Kickoff Meeting: A briefing on the technical plan for the effort to include milestone schedule and path to accomplish the objectives of the agreement. | |||
| Insert Deliverable description: XXXX Exit Criteria: (1) Government Acceptance of PowerPoint presentation submitted with appropriate markings included. (2) Meeting held for performer to explain/present kickoff material. | Month 1 ACA |
| 1 | … Propose your own as needed … | ||
| Total Agreement | $ - 0 | $ - 0 | |
| *Tasks and targets are keyed to Task Description Document | |||
| HIGHLIGHTED SECTION NOT TO BE FILLED OUT BY PROPOSERS |
Attachment 3 - Schedule of Milestones and Payments
FDRTA Option This sheet is for the DSO Fundamental Defense Research Talent Award (FDRTA) Option ($150,000 maximum per year)
| Base Phase 1 | |||||||||||||
| Graduate Student/Post-Doctoral Researcher Costs | Mo. 1 | Mo. 2 | Mo. 3 | Mo. 4 | Mo. 5 | Mo. 6 | Mo. 7 | Mo. 8 | Mo. 9 | Mo. 10 | Mo. 11 | Mo. 12 | Total |
| 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 | |||||||||||||
| Graduate Student/Post-Doctoral Researcher Costs | Mo. 1 | Mo. 2 | Mo. 3 | Mo. 4 | Mo. 5 | Mo. 6 | Mo. 7 | Mo. 8 | Mo. 9 | Mo. 10 | Mo. 11 | Mo. 12 | Total |
| 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
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 .