Liquid_Surge_Streamlined_Cost_Buildup_Workbook.xlsx

XLSX spreadsheet 38 KB Posted

Attached to
Liquid Surge
Solicitation number
DARPA-PA-25-07-05
Issued by

About this file

This is a cost buildup workbook template for proposals submitted to DARPA's Liquid Surge Disruption Opportunity under solicitation DARPA-PA-25-07-05. The template is designed for fixed-price, payable-milestone Other Transactions for Prototype Agreements with a two-phase structure: Phase 1 (Base) spanning 9 months and Phase 2 (Option) spanning an additional 9 months, totaling 18 months. The workbook requires proposers to provide fully-burdened cost estimates broken down by four milestones in Phase 1 (at months 1, 3, 6, and 9) and three milestones in Phase 2 (at months 12, 15, and 18), with payments made only in the amounts specified in Attachment 3 of the agreement.

Cost elements must include direct labor (with actual hours and rates—not percent level of effort calculations), subcontractor and consultant costs, travel, and other direct costs (ODCs), all fully burdened with applicable indirect costs. Proposers, including universities and institutions of higher education, must list principal investigators and key personnel and provide cost justification in Volume 2 of their price proposal. Phase 1 milestones focus on establishing an experimental rig for studying shock-induced wave propagation in fluids, validating against kinetic theory simulations, and developing prototype wave diagnostic hardware and computational prediction tools. Phase 2 milestones extend the experimental approach to higher shock intensities and broader parameter ranges while demonstrating validation and prediction accuracy across specified wave Mach numbers, base pressures, density, and salinity ranges. All milestone deliverables require data packages and technical reports.

View the file

Other files

File Type Posted
Liquid_Surge_Abstract_Template.docx DOCX document
DARPA-PA-25-07-05.pdf PDF

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

Cell Key:
Input
DARPA Solicitation Number:Insert DO number
Proposal Number:DARPA Proposal Number
Proposer:Proposer's Name (Prime or Sub)
Prime ContractorPrime (If Applicable)
Total MonthsPrice per Phase
Phase 1 (Base)9$ - 0
Phase 2 (Option)9$ - 0
TOTAL PRICE PROPOSED$ - 0

Budget by MS Phase 1 Base

NOTES/INSTRUCTIONS:
1. The milestone due dates are stipulated in the Disruption Opportunity, and Attachment 1 Task Description Document and Attachment 3 Schedule of Milestones and Payments of the DO SAMPLE OT. The milestone amounts will be automatically populated from the sums in the "Milestone [X] Total" at the bottom of this sheet.
2. Rows can be added to reflect labor categories, subcontractors/consultants, and additional ODCs, as necessary. However, none of the fields currently in the template should be removed, to include formulas.
3. All proposers, to include Universities/Institutions of Higher Education, must include labor hours and associated labor rates for each labor category as stipulated above. Proposers are prohibited from using percent level of effort (LOE) calculations. Proposers are reminded that the resulting awards are Fixed-Price Payable Milestone Other Transactions for Prototype Agreements (meaning, payments are made solely in the amounts found in Attachment 3 of the Agreement).
4. Cost elements above should be fully burdened, inclusive of all applicable indirect costs. Visibility into indirect rates/costs is not required.
5. Proposers must provide justification in Volume 2 Price Proposal and any supporting documentation as required.
6 For PRIME submission - Subcontractor Name: If there are subcontracts, list all subcontractor names.
7 List Principal Investigator and Key Personnel working on the project even if they receive no salary support.
8 Subcontracts/Interorganizational Transfers: If appropriate, place Subcontractor name(s) or Interorganizational Name/Code under the Subcontractor section.
9 Consultants: If appropriate, place Consultant name(s) under the Subcontractor section.
Cell Key:
DARPA Solicitation Number:Insert DO numberInput
Proposer:Proposer's Name (Prime or Sub)Calculation (DO NO EDIT)
Prime ContractorPrime (If Applicable)No Input
PHASE 1 BASEMilestone 1Milestone 2Milestone 3Milestone 4TOTAL PROPOSED HOURSTOTAL PROPOSED AMOUNT
Month 1
(see Notes/Instructions above)Month 3Month 6Month 9
DIRECT LABOR
(List each category separately)HOURSRATEAMOUNTHOURSRATEAMOUNTHOURSRATEAMOUNTHOURSRATEAMOUNT
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
SUBTOTAL
(all direct labor costs)- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0
SUBCONTRACTOR(S) & CONSULTANT(S)

(List each separately)

Subcontract/Interorganizational Name - #01$ - 0$ - 0$ - 0$ - 0
Subcontract/Interorganizational Name - #02$ - 0$ - 0$ - 0$ - 0
Subcontract/Interorganizational Name - #03$ - 0$ - 0$ - 0$ - 0
Insert line(s) for any additional Subcontractors/Interorganizational$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0
SUBTOTAL
(all subcontractor/consultant costs)$ - 0$ - 0$ - 0$ - 0$ - 0
TRAVEL$ - 0$ - 0$ - 0$ - 0$ - 0
OTHER DIRECT COSTS

(List each separately)

$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
SUBTOTAL
(Travel, ODCs)$ - 0$ - 0$ - 0$ - 0$ - 0
TOTAL PRICE$ - 0$ - 0$ - 0$ - 0$ - 0
GOVERNMENT SHARE$ - 0
RECIPIENT SHARE
(if applicable)$ - 0$ - 0$ - 0$ - 0$ - 0

Milestone 1 Total $ - 0 Milestone 2 Total $ - 0 Milestone 3 Total $ - 0 Milestone 4 Total $ - 0

DARPA-PA-21-05

Price Summary Spreadsheet

Version 2, 06/21/2022

Source Selection Information

Budget by MS Phase 2 Option

NOTES/INSTRUCTIONS:
1. The milestone due dates are stipulated in the Disruption Opportunity, and Attachment 1 Task Description Document and Attachment 3 Schedule of Milestones and Payments of the DO SAMPLE OT. The milestone amounts will be automatically populated from the sums in the "Milestone [X] Total" at the bottom of this sheet.
2. Rows can be added to reflect labor categories, subcontractors/consultants, and additional ODCs, as necessary. However, none of the fields currently in the template should be removed, to include formulas.
3. All proposers, to include Universities/Institutions of Higher Education, must include labor hours and associated labor rates for each labor category as stipulated above. Proposers are prohibited from using percent level of effort (LOE) calculations. Proposers are reminded that the resulting awards are Fixed-Price Payable Milestone Other Transactions for Prototype Agreements (meaning, payments are made solely in the amounts found in Attachment 3 of the Agreement).
4. Cost elements above should be fully burdened, inclusive of all applicable indirect costs. Visibility into indirect rates/costs is not required.
5. Proposers must provide justification in Volume 2 Price Proposal and any supporting documentation as required.
6 For PRIME submission - Subcontractor Name: If there are subcontracts, list all subcontractor names.
7 List Principal Investigator and Key Personnel working on the project even if they receive no salary support.
8 Subcontracts/Interorganizational Transfers: If appropriate, place Subcontractor name(s) or Interorganizational Name/Code under the Subcontractor section.
9 Consultants: If appropriate, place Consultant name(s) under the Subcontractor section.
Cell Key:
DARPA Solicitation Number:Insert DO numberInput
Proposer:Proposer's Name (Prime or Sub)Calculation (DO NO EDIT)
Prime ContractorPrime (If Applicable)No Input
PHASE 2 OPTIONMilestone 5Milestone 6Milestone 7TOTAL PROPOSED HOURSTOTAL PROPOSED AMOUNT
Month 12
(see Notes/Instructions above)Month 15Month 18
DIRECT LABOR
(List each category separately)HOURSRATEAMOUNTHOURSRATEAMOUNTHOURSRATEAMOUNT
$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0- 0$ - 0
SUBTOTAL
(all direct labor costs)- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0
SUBCONTRACTOR(S) & CONSULTANT(S)

(List each separately)

Subcontract/Interorganizational Name - #01$ - 0$ - 0$ - 0
Subcontract/Interorganizational Name - #02$ - 0$ - 0$ - 0
Subcontract/Interorganizational Name - #03$ - 0$ - 0$ - 0
Insert line(s) for any additional Subcontractors/Interorganizational$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0
SUBTOTAL
(all subcontractor/consultant costs)$ - 0$ - 0$ - 0$ - 0
TRAVEL$ - 0$ - 0$ - 0$ - 0
OTHER DIRECT COSTS

(List each separately)

$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0
SUBTOTAL
(Travel, ODCs)$ - 0$ - 0$ - 0$ - 0
TOTAL PRICE$ - 0$ - 0$ - 0$ - 0
GOVERNMENT SHARE$ - 0
RECIPIENT SHARE
(if applicable)$ - 0$ - 0$ - 0$ - 0

Milestone 5 Total $ - 0 Milestone 9 Total $ - 0 Milestone 10 Total $ - 0

DARPA-PA-21-05

Price Summary Spreadsheet

Version 2, 06/21/2022

Source Selection Information

ScheduleOfMilestonesAndPayments

SCHEDULE OF MILESTONES AND PAYMENTS
Milestone #MilestoneExit Citeria / DeliverableDue
DatePaymentFundedCLIN
SUBCLINACRN
1a. Program Kickoff
b. Revise and and complete experimental and computational research execution planKickoff slides and research execution plan submittedMonth 1$ - 0
2a. Obtain validation against experimental data with shock jumps for water using existing closures and/or preliminary results from kinetic theory calculationsOrganization chart and level of effort tables submittedMonth 3$ - 0
3a. Demonstrate operability of experimental rig up to critical pressures for the fluid

b. Demonstrate validation against experimental data with first-principles-based kinetic theory simulations according to metrics table

c. Report highlighting operability of experimental rig and validation against experimental data with first-principles-based kinetic theory simulationsData package submittedMonth 6$ - 0
4a. Demonstrate operability of experimental rig at twice the critical pressure for the fluid

b. Demonstrate handshake with first-principles-based kinetic theory simulations according to metrics table

c. Final phase 1 report incorporating salinity effects in the measurements and simulations

d. Draft of: (a) technical drawings of prototype wave diagnostic hardware and (b) prototype wave prediction computational tool, including associated standard operating procedure (SOP) document for both.Data package and final Phase 1 presentation submittedMonth 9$ - 0
Sub-Total Phase 1 (Base)$0.00$0.00
5a. Extension of experimental approach to double the maximum shock intensity

b. Demonstrate handshake with first-principles-based kinetic theory simulations according to metrics table

c. Preliminary phase 2 report highlighting the updated experimental approach and simulationsData package submittedMonth 12$ - 0
6a. Demonstrate validation against experimental data with first-principles-based kinetic theory simulations according to metrics table
b. Updated preliminary report of kinetic theory simulationsData package submittedMonth 15$ - 0
7a. Demonstration of ultimate experimental precision and prediction accuracy, covering the wave Mach number and base pressure, density and salinity range of interest.

b. Final report of demonstration

c. Final version of: (a) technical drawings of prototype wave diagnostic hardware and (b) prototype wave prediction computational tool, including associated standard operating procedure (SOP) document for both.Data package and final program presentation submittedMonth 18$ - 0
Sub-Total Phase 2 (Option)$0.00$0.00
Total Agreement$0.00$0.00
*Tasks and targets are aligned with OT Agreement Attachment 1 - Task Description Document
AUTO POPULATES FROM OTHER TABS -- DO NOT CHANGE FORMULAS OR IN THIS SPREADSHEET

Attachment 3 - Schedule of Milestones and Payments

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