DARPA-PS-26-126_RAAPTR_Attachment_F_DARPA_Price_Summary_Spreadsheet.xlsx
XLSX spreadsheet 47 KB Posted
- Solicitation number
- DARPA-PS-26-126
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
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 only | Phase 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 HOURS | TOTAL PROPOSED AMOUNT | ||||||||||||||||||||||||||||
| DIRECT LABOR | ||||||||||||||||||||||||||||||
| (List each category separately) | HOURS | Fully Burdened RATE | AMOUNT | HOURS | Fully Burdened RATE | AMOUNT | HOURS | Fully Burdened RATE | AMOUNT | HOURS | Fully Burdened RATE | AMOUNT | HOURS | Fully Burdened RATE | AMOUNT | HOURS | Fully Burdened RATE | AMOUNT | HOURS | Fully Burdened RATE | AMOUNT | HOURS | Fully Burdened RATE | AMOUNT | HOURS | Fully Burdened RATE | AMOUNT | |||
| - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | |||||||||||
| - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | |||||||||||
| - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | |||||||||||
| - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | |||||||||||
| - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | |||||||||||
| - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | |||||||||||
| - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | |||||||||||
| - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 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 | ||||
| Share | Performer Share | Total 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 only | Phase 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 HOURS | TOTAL PROPOSED AMOUNT | |||||||||||||||||||
| DIRECT LABOR | |||||||||||||||||||||
| (List each category separately) | HOURS | Fully Burdened RATE | AMOUNT | HOURS | Fully Burdened RATE | AMOUNT | HOURS | Fully Burdened RATE | AMOUNT | HOURS | Fully Burdened RATE | AMOUNT | HOURS | Fully Burdened RATE | AMOUNT | HOURS | Fully Burdened RATE | AMOUNT | |||
| - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | - 0 | $ - 0 | ||||||||
| - 0 | $ - 0 | - 0 | $ - 0 | - 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 | ||||
| Share | Performer Share | Total 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
| Item | Description of Material/ Supply | Qty | Unit Price | Extended Price | Vendor/Supplier Name | Supporting 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
| Item | Description of Equipment | Qty | Unit Price | Extended Price | Vendor/Supplier Name | Supporting documentation (evidence) attached to proposal ? | |
| (Y / N) | Vendor/Supplier Quote Number | Tasks 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 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 PER TRIP |
| 1 | 0 | $ - 0 | $ - 0 | 0 | $0.00 | $0.00 | |||||||||||
| 2 | 0 | $ - 0 | $ - 0 | 0 | $0.00 | $0.00 | |||||||||||
| 3 | 0 | $ - 0 | $ - 0 | 0 | $0.00 | $0.00 | |||||||||||
| 4 | 0 | $ - 0 | $ - 0 | 0 | $0.00 | $0.00 | |||||||||||
| 5 | 0 | $ - 0 | $ - 0 | 0 | $0.00 | $0.00 | |||||||||||
| 6 | 0 | $ - 0 | $ - 0 | 0 | $0.00 | $0.00 | |||||||||||
| 7 | 0 | $ - 0 | $ - 0 | 0 | $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
| Item | ODC Item Description | Qty | Unit Price | Extended Price | Vendor/Supplier Name | Supporting documentation (evidence) attached to proposal ? | |
| (Y / N) | Vendor/Supplier Quote Number | Tasks 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 .