DARPA-PS-26-126_RAAPTR_Attachment_F_DARPA_Price_Summary_Spreadsheet.xlsx

XLSX spreadsheet 47 KB Posted

Attached to
RF Architectures Applying Photonic Timing and Routing (RAAPTR)
Solicitation number
DARPA-PS-26-126
Issued by

About this file

This is a DARPA Price Summary Spreadsheet template for the RF Architectures Applying Photonic Timing and Routing (RAAPTR) program solicitation DARPA-PS-26-126. The template is designed to capture fully burdened pricing across a two-phase contract structure: Phase 1 spans 24 months with nine milestones (due at months 1, 3, 6, 9, 12, 15, 18, 21, and 24), and Phase 2 spans 18 months with six milestones (due at months 27, 30, 33, 36, 39, and 42). Proposers must separately complete price summaries for the prime contractor and each subcontractor, detailing direct labor (with hours and fully burdened rates for each labor category), subcontractor and consultant costs, materials, equipment, travel, and other direct costs (ODCs). All pricing elements must be inclusive of indirect costs and fee if applicable, and pricing per milestone must align with the Schedule of Milestones and Payments in Attachment J.

The spreadsheet includes detailed supporting sections for Materials-Supplies, Equipment, Travel, and ODCs, each requiring itemized descriptions, quantities, unit prices, extended prices, vendor information, and evidence of supporting documentation such as pay stubs, PBRs, supplier quotes, and vendor quotes. Travel costs must comply with federal per diem rates from GSA, with specific guidance on lodging, meals and incidental expenses (M&IE), airfare at economy rates, and transportation. The template prohibits the use of percent-level of effort calculations and requires that all totals reconcile across worksheets. Each submission must include a separate price summary for the prime and all subcontractors, with rows added as necessary to reflect actual labor categories, subcontractors, and ODCs while preserving all existing template fields and formulas.

View the file

Other files

File Type Posted
DARPA-PS-26-126_RAAPTR_QA_v4.pdf PDF
DARPA-PS-26-126_RAAPTR_Attachment_D_Proposal_Instructions_and_Volume_I_Template_Amend01.docx DOCX document
DARPA-PS-26-126-Amendment-01.pdf PDF
DARPA-PS-26-126_RAAPTR_QA_v3.1.pdf PDF
DARPA-PS-26-126_RAAPTR_Q_A_V2_-_Final.pdf PDF
DARPA-PS-26-126_RAAPTR_QA_v1.pdf PDF
RAAPTR_Proposers_Day_Slides.pdf PDF
DARPA-PS-26-126_RAAPTR_Attachment_L_BAAT_Submission_Portal_Guide.docx DOCX document
DARPA-PS-26-126_RAAPTR_Attachment_B_Abstract_Instructions_and_Template.docx DOCX document
DARPA-PS-26-126.pdf PDF
SAMPLE_OT_P__-_Fixed_Support_Nontraditional_-_2025.02.28.docx DOCX document
DARPA-PS-26-126_RAAPTR_Attachment_A_CUI_Materials_Request_Form.docx DOCX document
SAMPLE_OT_P__-_Expenditure_Based_Approach_-_2025.02.28.docx DOCX document
SAMPLE_OT_P__-_Streamlined__Fixed_-_2025.02.28.docx DOCX document
SAMPLE_OT_P__-_Cost-Share_Expenditure_Based_-_2025.02.28.docx DOCX document
DARPA-PS-26-126_RAAPTR_Attachment_D_Proposal_Instructions_and_Volume_I_Template.docx DOCX document
SAMPLE_OT_P__-_Fixed_Support_Traditional_Cost-Share_-_2025.02.28.docx DOCX document
DARPA-PS-26-126_RAAPTR_Attachment_E_Proposal_Instructions_and_Volume_II_Template_Price.docx DOCX document
DARPA-PS-26-126_RAAPTR_Attachment_J_CUI_Guide.pdf PDF
DARPA-PS-26-126_RAAPTR_Attachment_K_Model_OT_Prototype.docx DOCX document
DARPA-PS-26-126_RAAPTR_Attachment_I_Schedule_of_Milestones_and_Payments.docx DOCX document
DARPA-PS-26-126_RAAPTR_Attachment_H_Task_Description_Document.docx DOCX document
DARPA-PS-26-126_RAAPTR_Attachment_G_Other_Transaction_Certifications.docx DOCX document
DARPA-PS-26-126_RAAPTR_Attachment_C_Proposal_Summary_Slide_Template.pptx PPTX presentation
Show all 24

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

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