DARPA-PA-27-02_Protein_Palace_Attachment_E_Price_Summary_Spreadsheet.xlsx

XLSX spreadsheet 47 KB Posted

Attached to
Protein Palace
Solicitation number
DARPA-PA-27-02
Issued by

About this file

Written by GovTribe AI ·

This is a Price Summary Spreadsheet template for the DARPA Protein Palace solicitation (DARPA-PA-27-02), designed to capture milestone-based pricing for proposals across two phases of performance. The spreadsheet structures pricing for a 24-month Phase 1 period with nine milestones (due at months 1, 3, 6, 9, 12, 15, 18, 21, and 24) and an 18-month Phase 2 period with six milestones (due at months 27, 30, 33, 36, 39, and 42). Bidders must complete separate Price Summary spreadsheets for the prime contractor and each subcontractor, filling only the yellow cells while preserving all existing formulas and fields.

The template requires pricing to be presented as fully burdened rates, inclusive of all applicable indirect costs and fees, organized by cost categories including direct labor (listed by category with hours and rates), subcontractors and consultants, materials and supplies with vendor quotes, equipment with task applications, travel (with detailed per diem calculations following GSA federal rates), and other direct costs. Proposers must submit supporting documentation such as pay stubs, pricing basis documents, fractions of reimbursable pricing agreements, supplier quotes, and evidence of vendor quotes. All pricing per milestone must be consistent with Attachment H (Schedule of Milestones and Payments), percent-level-of-effort calculations are prohibited, and materials, equipment, and travel costs must be itemized separately with vendor information and supporting evidence. The spreadsheet includes detailed instructions for travel calculations, requiring one more day than nights for overnight trips, 75% M&IE per diem rates for first and last days, and economy airfare pricing with backup documentation.

View the file

Other files

File Type Posted
DARPA-PA-27-02_Protein_Palace_Attachment_C_Proposal_Instructions_and_Volume_I_Template_Technical_and_Management.docx DOCX document
DARPA-PA-27-02_Protein_Palace_Enclosure_1_Proposer_Checklist.docx DOCX document
DARPA-PA-27-02_Protein_Palace_Attachment_I_Model_Other_Transaction_for_Research.docx DOCX document
DARPA-PA-27-02_Protein_Palace_Attachment_A_Abstract_Instructions_and_Template.docx DOCX document
DARPA-PA-27-02_Protein_Palace_Attachment_G_Task_Description_Document_TDD_Template.docx DOCX document
DARPA-PA-27-02_Protein_Palace_Attachment_H_Schedule_of_Milestones_and_Payments.docx DOCX document
DARPA-PA-27-02.pdf PDF
DARPA-PA-27-02_Protein_Palace_Attachment_J_CUI_Guild.pdf PDF
DARPA-PA-27-02_Protein_Palace_Enclosure_2_DARPA_BAAT_Submission_Portal_Guide.docx DOCX document
DARPA-PA-27-02_Protein_Palace_Attachment_B_Proposal_Summary_Slide_Template.pptx PPTX presentation
DARPA-PA-27-02_Protein_Palace_Attachment_F_Other_Transaction_Certifications.docx DOCX document
DARPA-PA-27-02_Protein_Palace_Attachment_D_Proposal_Instructions_and_Volume_II_Template_Price.docx DOCX document
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
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Phase 1- Budget per Milestone

Competition Sensitive Information – Distribution with Agreements Officer’s authorization onlyPhase 1 (24 Months)
Milestone 1
(Due at Month 1)Milestone 2
(Due at Month 3)Milestone 3
(Due at Month 6)Milestone 4
(Due at Month 9)Milestone 5
(Due at Month 12)Milestone 6
(Due at Month 15)Milestone 7
(Due at Month 18)Milestone 8
(Due at Month 21)Milestone 9
(Due at Month 24)TOTAL PROPOSED HOURSTOTAL PROPOSED AMOUNT
DIRECT LABOR
(List each category separately)HOURSFully Burdened RATEAMOUNTHOURSFully Burdened RATEAMOUNTHOURSFully Burdened RATEAMOUNTHOURSFully Burdened RATEAMOUNTHOURSFully Burdened RATEAMOUNTHOURSFully Burdened RATEAMOUNTHOURSFully Burdened RATEAMOUNTHOURSFully Burdened RATEAMOUNTHOURSFully Burdened RATEAMOUNT
- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0
- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0
- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0
- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0
- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0
- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0
- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0
- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 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)- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0
SUBCONTRACTOR(S) & CONSULTANT(S)
(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
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
SUBTOTAL
(all subcontractors/consultants)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
MATERIALS$ - 0$ - 0$$$$$$$ - 0
EQUIPMENT$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
TRAVEL$ - 0$ - 0$ - 0$$$$$$$ - 0
OTHER DIRECT COSTS (ODCs) 1$$$$$$$$$$ - 0
OTHER DIRECT COSTS (ODCs) 2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
OTHER DIRECT COSTS (ODCs) 3$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
SUBTOTAL
(all M, E, Travel, ODCs)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
TOTAL PRICE$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
PERFORMER SHARE
(if applicable)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
GOVERNMENT SHARE$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Gov't
SharePerformer ShareTotal Price
Phase 1 Total- 0$ - 0$ - 0
Note: Fill out yellow cells.
1. Each submission shall include a separate Price Summary spreadsheet for the Prime and each Subcontractor.
3. 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. Use of Percent level of effort (LOE) calculations are prohibited
5. Price elements above should be Fully Burdened, inclusive of all applicable indirect costs and fee, if applicable. Submit supporting documentation (Pay Stubs, PBRs, FRPAs, FPRR, Supplier Quotes) and basis of estimate with this Spreadsheet
6. The pricing must be presented using the format above.
7. Total per milestone should consistent with Attachment H Schedule of Milestones and Payments

DARPA-PA-25-01

Price Summary Spreadsheet

Version 2, 06/21/2022

Source Selection Information

Phase 2- Budget per Milestone

Competition Sensitive Information – Distribution with Agreements Officer’s authorization onlyPhase 2 (18 Months)
Milestone 10
(Due at Month 27)Milestone 11
(Due at Month 30)Milestone 12
(Due at Month 33)Milestone 13
(Due at Month 36)Milestone 14
(Due at Month 39)Milestone 15
(Due at Month 42)TOTAL PROPOSED HOURSTOTAL PROPOSED AMOUNT
DIRECT LABOR
(List each category separately)HOURSFully Burdened RATEAMOUNTHOURSFully Burdened RATEAMOUNTHOURSFully Burdened RATEAMOUNTHOURSFully Burdened RATEAMOUNTHOURSFully Burdened RATEAMOUNTHOURSFully Burdened RATEAMOUNT
- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0
- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0
- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0
- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0
- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0
- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0
- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0
- 0$ - 0- 0$ - 0- 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)- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0
SUBCONTRACTOR(S) & CONSULTANT(S)
(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
SUBTOTAL
(all subcontractors/consultants)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
MATERIALS$ - 0$ - 0$$$$ - 0
EQUIPMENT$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
TRAVEL$ - 0$ - 0$ - 0$$$$ - 0
OTHER DIRECT COSTS (ODCs) 1$$$$$$$ - 0
OTHER DIRECT COSTS (ODCs) 2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
OTHER DIRECT COSTS (ODCs) 3$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
SUBTOTAL
(all M, E, Travel, ODCs)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
TOTAL PRICE$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
PERFORMER SHARE
(if applicable)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
GOVERNMENT SHARE$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Gov't
SharePerformer ShareTotal Price
Phase 2 Total- 0$ - 0$ - 0
Note: Fill out yellow cells.
1. Each submission shall include a separate Price Summary spreadsheet for the Prime and each Subcontractor.
3. 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. Use of Percent level of effort (LOE) calculations are prohibited
5. Price elements above should be Fully Burdened, inclusive of all applicable indirect costs and fee, if applicable. Submit supporting documentation (Pay Stubs, PBRs, FRPAs, FPRR, Supplier Quotes) and basis of estimate with this Spreadsheet
6. The pricing must be presented using the format above.
7. Total per milestone should consistent with Attachment H Schedule of Milestones and Payments

DARPA-PA-25-01

Price Summary Spreadsheet

Version 2, 06/21/2022

Source Selection Information

Materials-Supplies MATERIALS - SUPPLIES Totals must match Total Amount worksheet

ItemDescription of Material/ SupplyQtyUnit PriceExtended PriceVendor/Supplier NameSupporting documentation (evidence) attached to proposal ?
(Y / N)Vendor/Supplier Quote Number
1$0.00
2$0.00
3$0.00
4$0.00
5$0.00
6$0.00
7$0.00
TOTAL$0.00

Equipment EQUIPMENT Totals must match Total Amount worksheet

ItemDescription of EquipmentQtyUnit PriceExtended PriceVendor/Supplier NameSupporting documentation (evidence) attached to proposal ?
(Y / N)Vendor/Supplier Quote NumberTasks to be performed with the Equipment (see TDD)
1$0.00
2$0.00
3$0.00
4$0.00
5$0.00
6$0.00
7$0.00
TOTAL$0.00

Travel TRAVEL Totals must match Total Amount worksheet

Trip # (list)Purpose 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 PER TRIP
10$ - 0$ - 00$0.00$0.00
20$ - 0$ - 00$0.00$0.00
30$ - 0$ - 00$0.00$0.00
40$ - 0$ - 00$0.00$0.00
50$ - 0$ - 00$0.00$0.00
60$ - 0$ - 00$0.00$0.00
70$ - 0$ - 00$0.00$0.00
GRAND TOTAL TRAVEL$0.00

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 each Phase

Note 3: If there are miscellaneous expenses associated with the trip, provide description and rationale.

ODCs OTHER DIRECT COSTS Totals must match Total Amount worksheet

ItemODC Item DescriptionQtyUnit PriceExtended PriceVendor/Supplier NameSupporting documentation (evidence) attached to proposal ?
(Y / N)Vendor/Supplier Quote NumberTasks to be performed with the ODC item
1$0.00
2$0.00
3$0.00
4$0.00
5$0.00
6$0.00
7$0.00
TOTAL$0.00

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