The file's text, extracted by GovTribe without its formatting.
General
| DARPA Standard Cost Proposal Spreadsheet (Single Technical Area) November 2021 | | |
| Proposer Name: | Proposer's Name (Prime or Subcontractor) | Proposer's CAGE |
| Top Prime Proposer: | Prime Contractor (Fill-in) (if applicable) | Prime's CAGE |
| Solicitation No. | Solicitation # (Fill-in) | |
| Proposer's Proposal ID: | Proposer's Proposal ID | |
| SBIR/STTR Phase: | Not Applicable | (drop-down list) |
| GENERAL INFORMATION |
| The purpose of the requested information in the 25 attached worksheets is to assist government personnel in the review and evaluation of cost proposals submitted by proposers. Proposers are reminded that the responsibility for providing adequate supporting data and attachments lies solely with them. Further, the proposer must also bear the burden of proof in establishing reasonableness of proposed costs; therefore, it is in the proposer’s best interest to submit a fully supportable and well-prepared cost proposal. The basis and rationale for all proposed costs should be provided as part of the proposal so that Government personnel can place reliance on the information as current, complete and accurate. Further, for procurement contracts, FAR 15.403-4 sets forth those circumstances in which proposers are required to submit certified cost or pricing data. This spreadsheet should be used for all cost proposals, regardless of award instrument: grant, cooperative agreement, contract, other transaction, or technology investment agreement. |
| The purpose of this cost proposal spreadsheet is to assist the Government in completing a rapid analysis of your proposed costs and, if your proposal is selected for award, speeding up the negotiation and award execution process. |
| Cost by Task: In addition to providing summary by period of performance (Base and any Options), the contractor is also responsible for providing a breakdown of cost for each task identified in the statement of work. The sum of all cost by task worksheets MUST equal the total cost summary. |
Options: Unpriced Options will not be accepted. Any Option that is not fully priced, will not be included in any resulting award.
Enter the proposed cost detail for the Base and each Option period (as needed) on the tabs entitled,, "Base", "O-I". "O-II", O-III", "O-IV", and "O-V". The tab entitled, "Total Amount" will automatically calculate from the Base and Option tabs.
| • Before entering other data, fill in yellow fields on General tab, Proposer Constants tab, Labor Rates tab, and Indirect Rates tab. A Business Type on the Proposer Constants tab must be selected before Labor Groups and Labor Categories can be selected on the Labor Rates tab. | |
| • Proposers may add additional specific cost categories (Subcontractors, ODC types, etc.) as needed but must ensure those new cost categories track to the Total Amount tab. See the General Instructions document below for details. | DARPA is interested in your feedback on this updated cost proposal spreadsheet. If you have suggestions for improving this spreadsheet, please send an email to costproposal@darpa.mil |
| • Yellow and Clear cells are for data entry. Gray cells indicate references or formulas that should not be changed unless the formula does not match your organization's business rules. If you change these formulas, you must ensure the change does not affect the overall flow of the spreadsheet. | |
| • Ensure all costs from other worksheets are correct. | |
| • If a row, column, or worksheet in this spreadsheet is not needed for your proposal, either ignore it or Hide it; do not delete it. | |
| Below is a summary of the proposed cost. This chart will automatically fill in from the "Total Amount" tab. | | | Below is a summary of Documentation/Documents Required |
| Total Direct Labor Costs | $0 | Prior to Negotiations |
| Total Fringe Benefit Costs | $0 | |
| Total Labor Overhead Costs | $0 | |
| Total Subcontract Costs | $0 | |
| Total Consultant Costs | $0 | |
| Total Other Direct Costs | $0 | |
| Total Material Handling Costs | $0 | |
| Subtotal Costs | $0 | |
| Total G&A Costs | $0 | |
| Subtotal Costs | $0 | |
| Total Cost of Money | $0 | Prior to Contract |
| Total Estimated Costs | $0 | Certificate of Current Cost/Pricing Data for Prime if Contract > $2,000,000 |
| Fixed Fee (If proposing a CPFF contract) or Profit | $0 | Certificate of Current Cost/Pricing Data for each Subcontractor > $2,000,000 |
| Total Estimated Costs Plus Fixed Fee | $0 | If small business or non-traditional defense contractor, Certificate of Current Cost/Pricing Data for each Contract/Subcontractor > $7,500,000 |
Instructions
| Spreadsheet Instructions |
| • These instructions describe how to use this DARPA Standard Cost Proposal spreadsheet to prepare an organization's cost proposal. These instructions do not replace or supersede cost proposal instructions given in the solicitation or announcement. |
| • This spreadsheet can be used by both prime and sub proposers. Each proposer completes a spreadsheet specific to their organization. |
| • The instructions that follow apply to the tabs/worksheets that are colored yellow, dark-gray, purple, and orange because these tabs are linked together using references and formulas. The light-gray tabs, such as Subcontractor, Consultants, Travel, etc., are stand-alone tabs that provide space for cost proposal details as required. You may modify formulas on the light-gray tabs. You may add tabs to clarify your proposal. |
| • In addition to the instructions provided below, each tab may have additional guidance and instructions on it. |
| Worksheet/Tab (Yellow, Dark-Gray, Purple or Orange color tabs) | |
| All Tabs | |
| • DO NOT DELETE tabs, rows, or columns that exist in this template. This will damage the structure of the spreadsheet. If you don't want to see a tab, row, or column, use the Hide function. |
| • Before entering detailed proposal data, fill in the yellow fields on the General, Proposer Constants, Labor Rates, and Indirect Rates tabs. A Business Type on the Proposer Constants tab must be selected before Labor Groups and Labor Categories can be selected on the Labor Rates tab. |
| • Yellow and Clear cells are for data entry. Gray cells indicate references or formulas that should not be changed unless the formula does not match your organization's business rules. If you change these formulas, you must ensure the change does not affect the overall flow of the spreadsheet. |
| • When you are asked to select from a pick-list, use your best judgement and choose the closest fit. |
| • If you need to add a new line on any tab, the line must be simultaneously added to multiple tabs. See the instructions below to add new lines. |
| General Tab | |
| • Complete the yellow cells as appropriate. CAGE codes and an accurate DARPA solicitation number are helpful. |
| • The Summary of Proposed Cost and Summary of Documentation will self-complete as you enter cost data into the template. |
| Proposer Constants Tab | |
| • In cell A4, select the organization type that best describes your organization. This selection drives the list of DARPA Labor Groups and Labor Categories that appear on the Labor Rates tab. If you change this selection, you need to reselect Labor Categories and Labor Categories on the Labor Rates tab. |
| • If you select a Business Type of 'Small Business', the Small Business Size Estimate area will activate. Select the range of the number of employees that best fits your organization at the time of this proposal. |
| • Proposer Accounting Periods describe the begin/end dates for your organization's accounting periods. Transitions between accounting periods represent when labor rates and other costs change. Most likely, each part of a proposed effort will include more than one proposer accounting period. Do not leave a gap between fiscal years. |
| • Change the Proposer's Preferred Label for each fiscal year as you see fit. This label will appear on the Labor Rates, Indirect Rates, and all Cost Detail tabs. |
| • This spreadsheet provides six proposer fiscal years, which is typically sufficient for DARPA efforts. If you need more fiscal years (or accounting periods), use a second spreadsheet -- do not attempt to add fiscal years to this spreadsheet. |
| Labor Rates Tab | |
| • This spreadsheet heavily relies on the Labor Rates tab. This tab is where you list all labor categories and changing rates to be used in all Cost Detail tabs of the proposal, be it the Base/Option tabs, Task tabs, or Technical Area tabs. |
| • Each of your labor categories represent one line in this table. Enter your labor category name in column C and more details (if needed) in column D. These two columns will appear on all of the cost detail tabs. |
| • For each of your labor categories, select the DARPA Labor Group and Category that best fits the labor category. First select a Group, and this will shorten the list of Categories. See the Labor Rates tab itself for a description of the DARPA Labor Categories. These descriptions do not have strictly defined boundaries. |
| • For academic institutions (or other organizations) that may normally apply a percentage of a Full Time Equivalent (FTE) to an annual salary, please show the labor rate calculation in the Hourly Labor Rate cell. This can be done by dividing an annual salary by the FTE labor hours (for example, hourly labor rate = annual salary/2080) |
| • You only need to enter rate information for the fiscal years when that particular labor category will be used. |
| • If you need more labor categories than the 24 provided lines, see the instructions below to add more lines to this Labor Rates tab and all of the Cost Detail tabs. |
| Indirect Rates and Profit_Fee Tab | |
| • For each proposer fiscal year, list each indirect rate (or profit/fee rate) your organization uses in this proposal. Pick the DARPA Rate Category that best matches each indirect rate. If no Category matches, pick "Other". |
| • You should connect the Fringe, Overhead, and G&A/F&A rates entered on this tab to the appropriate cells in the Labor Rates tab. A relationship is set by default, and you can change this relationship to make it accurate for your organization. For example, University organizations should change the G&A DARPA Category to be F&A. |
| Cost Detail Tabs (These include Base, Options, TA, TA Summary, and Task tabs) | |
| • Place costs and labor hours under the appropriate proposer fiscal year for this particular section of work. |
| • In the Direct Labor section, do not change the labor categories or names on these Cost Detail tabs. All changes to labor categories and names must be done centrally on the Labor Rates tab. |
| • Other than the Direct Labor section, the names or labels that appear in column B of the Base, Option, Task and Total Amount tabs (after row 38) all come from column B of the Base (Phase I) tab. Enter/change all names/labels on the Base tab, even if that particular row is not used for the Base phase. All cost detail tabs should have the exact same rows. For example, if you have a particular consultant that will only be involved in Option II, enter that consultant’s name on the Base tab but only enter that consultant’s costs on the Option II tab. |
| • Proposers may add additional specific cost categories (Subcontractors, ODC types, etc.) as needed but must ensure those new cost categories track to the Total Amount tab. Follow the instructions below to add more rows. |
| • The orange Task tabs (at the far right end of the many tabs) should be used when the proposal instructions request a breakdown of costs below the Option, Phase, or Technical Area level. Examples are task-breakout, milestones, or months. Costs should be entered on these Task tabs and mapped up to the proper Option, Phase or Technical Area tab using formulas. The Task tabs can be duplicated as many times as needed and can be renamed to be appropriate for your proposal. |
| Adding Rows | |
| • This spreadsheet is designed to handle the addition of rows. It cannot handle the addition or removal of columns. As you use the spreadsheet, feel free to use the Excel Hide function to hide rows or columns that seem excessive. |
| • When you add rows to the spreadsheet, it must be done consistently for all related worksheets. The instructions below describe how to add rows for the Labor Rates and Cost Detail tabs. |
| Add Rows to Labor Rates Tab | |
| • Whenever an additional labor category row is needed (in addition to the 24 provided rows), a row must be added to all related worksheets. The worksheets involved are: Labor Rates, Total Amount, Base, O-I, O-II, O-III, O-IV, O-V, and all Task or Technical Area worksheets. |
| 1. First, select any one of the involved worksheets. |
| 2. Holding down the Ctrl key, multi-select all of the other related worksheets tabs. These tabs will remain selected as you execute steps 3 and 4. |
| 3. Highlight one or more rows in the Direct Labor section of the active worksheet. Right click on a highlighted row number and choose the Insert function. This will insert one or more rows in all selected worksheets. |
| 4. Select the formula-populated row above the newly inserted blank rows. Using your mouse, grab the dark square in the lower left corner of the column A cell. Drag this down to cover all of the just-created blank rows. This will copy all relevant formulas and formats down into the new rows in all selected worksheets. |
| 5. DE-SELECT the involved worksheets by clicking any other (not currently selected) worksheet tab. |
| 6. Go to the Labor Rates worksheet and enter data for the newly inserted labor category rows. |
| Add Rows to Cost Detail Tabs | |
| • Whenever an additional cost category row is needed (in addition to the several provided rows), a row must be added to all related worksheets. The worksheets involved are: Total Amount, Base, O-I, O-II, O-III, O-IV, O-V, and all Task or Technical Area worksheets. |
| 1. First, select any one of the involved worksheets. |
| 2. Holding down the Ctrl key, multi-select all of the other related worksheets tabs. These tabs will remain selected as you execute steps 3 and 4. |
| 3. Highlight one or more rows in the active worksheet. Right click on a highlighted row number and choose the Insert function. This will insert one or more rows in all selected worksheets. |
| 4. Select the formula-populated row above the newly inserted blank rows. Using your mouse, grab the dark square in the lower left corner of the column A cell. Drag this down to cover all of the just-created blank rows. This will copy all relevant formulas and formats down into the new rows in all selected worksheets. |
| 5. DE-SELECT the involved worksheets by clicking any other (not currently selected) worksheet tab. |
| 6. Go to the BASE tab and enter labels in column B for the newly inserted cost category rows. |
Change Notes
| Version ID | Tab | Changes from Previous |
| 12-2019 | | Original Version used for BTO BAA. |
| 01-2020.1 | Base, all Options, Tasks | In Base and all Option tabs and two TASK tabs, column Q in Labor Rates table, now refers to correct column (N) instead of (M). Incorrect column caused Fringe Benefit Rate to be used instead of Labor Overhead Rate in calculations. This was only incorrect for the second fiscal year (only column Q). |
| 01-2020.1 | Base, all Options, Tasks | In all of the same tabs described above, cell U72 was distributed with "10%" as the default value. This is changed to be 0% |
| 01-2020.1 | Summary Cost Table | Removed the inclusion of row D (hours) in the Checksum value in the bottom row. |
| 03-2020 | Base, all Options, Tasks | Summed the Hours for Consultants. |
| 03-2020 | General | Updated the General Instructions Word document. |
| 03-2020 | Base | Yellow highlights added to column B. |
| 04-2020 | Constants | There were two "Program/Project Manager III" categories. Changed second one to be "Program/Project Manager II" |
| 1.04.00 | General | Top, added CAGE codes and proposer's proposal ID. |
| 1.04.00 | Constants | Added Fringe, Overhead (Labor), G&A (Labor) and F&A (Labor) to the Indirect Rates list. |
| 1.04.00 | General | Cells B18 & B19 instructions expanded. |
| 1.04.00 | Labor Rates | Updated A7, B7 to include the word "Required". |
| 1.04.00 | Offeror Constants | Replaced out-year fiscal year dates with formulas that add 12 months to the prior FY date. Plus conditional formatting on FY Begin Dates. |
| 1.04.00 | Summary Cost Table | Added checksums and Hour Totals by Proposer's FY |
| 1.04.00 | Indirect Rates | Added Profit and Fee categories. Renamed tab to be Indirect Rates and Profit_Fee |
| 1.04.00 | Labor Rates | Changed Escalation Rate to be "N/A" when the prior year's labor rate is zero. |
| 1.04.00 | Additional Tabs | Copied additional tabs from the "Multiple TAs" version of this spreadsheet. |
| 1.05.00 | General | Added the SBIR/STTR Phase selection |
| 1.05.00 | Proposer Constants | Added the Small Business Size Estimate selection |
| 1.05.00 | Indirect Rates and Profit_Fee | Updated instructions in cell B16 |
| 1.06.00 | Constants | Removed the (labor) and (non-labor) designations after G&A and F&A indirect rate categories |
| 1.06.01 | Constants | Added Faculty/Professor to Research labor group for Academia business type |
| 1.06.02 | Constants | Added new Fringe (Students) indirect category for academia |
| 1.06.02 | Instructions | Added new worksheet named Instructions |
| 1.06.02 | Travel | Updated to accommodate first/last day of travel calculations |
| 1.06.02 | Indirect Rates and Profit_Fee | Increased precision of percentages to seven decimal places, primarily for Cost of Money |
| 1.06.03 | ALL | Removed duplicate reference names |
| 1.06.03 | Labor Rates | Took away the privilege to add or remove columns from this tab. |
| 1.06.03 | Labor Rates | Tied Fringe, Overhead, and G&A/F&A rates to three prepopulated rows in the Indirect Rates and Profit_Fee tab. |
| 1.06.03 | Labor Rates | Changed column name from Fully Loaded Rate to Loaded Hourly Rate |
| 1.06.04 | Base, all Options, Tasks | Fixed G&A $$ calculation in Proposer Year 6 (cell AR63) |
Constants
| Spreadsheet Version Number | |
| 1.06.04 | First digit change --> prior functions changes. Second digit change --> new function added. Third digit change --> change in spreadsheet that does not affect CPDB. |
| SpecificAnnouncementNumber | |
| General, I2, Picklist of Offeror Business Types | | | Cell Range Naming Conventions: |
| Large Business | | | ThisIsAName = internal constants such as pick-lists |
| Small Business | | | This.Is.a.Name = named ranges holding proposer data |
| Non-Profit | | | |
| Academia | | | |
| Lab/FFRDC | | | Labor Collection --> Labor Group --> Labor Category |
| Labor Collection based on Offeror Business Type Selection | | Offeror.Bus.Type is | |
| Valid values are Academia or General | | Add/Change Labor Collection requires Data Validation code change on Labor Rates tab, and new Labor Group list below. |
| No Business Type Selected | instructional choice |
| First select a Business Type | No Labor Collection is available |
| Academia Labor Groups | Add/Change Labor Group requires changes below to Categories |
| Project Management | |
| Research | |
| Consultant | |
| Administrative Support | |
| General Labor Groups |
| Project Management |
| Science and Engineering |
| Software Development |
| Manufacturing |
| Consultant |
| Support |
| Academia Project Management Categories |
| Principal Investigator |
| Co-Principal Investigator |
| Co-Investigator |
| Project Manager |
| Academia Research Categories |
| Faculty/Professor |
| Sr. Post-Doc |
| Post-Doc |
| Post-Doc Fellow |
| Research Scientist/Engineer |
| Research Associate |
| Research Assistant |
| Staff Scientist |
| Graduate Research Assistant |
| Graduate Student |
| Student |
| Consultant |
| Academia Consultant Categories |
| Consultant |
| Academia Administrative Support Categories |
| Project Administrator |
| Systems Administrator |
| General Support Categories |
| Administrative |
| Security |
| Financial |
| Contracts |
| General Project Management Categories |
| Principal Program/Project Manager |
| Program/Project Manager V |
| Program/Project Manager IV |
| Program/Project Manager III |
| Program/Project Manager II |
| Program/Project Manager I |
| General Science and Engineering Categories |
| Principal Scientist/Engineer |
| Scientist/Engineer V |
| Scientist/Engineer IV |
| Scientist/Engineer III |
| Scientist/Engineer II |
| Scientist/Engineer I |
| General Software Development Categories |
| Principal Software Developer |
| Software Developer V |
| Software Developer IV |
| Software Developer III |
| Software Developer II |
| Software Developer I |
| General Manufacturing Categories |
| Principal Manufacturer |
| Manufacturer V |
| Manufacturer IV |
| Manufacturer III |
| Manufacturer II |
| Manufacturer I |
| Principal Quality Control |
| Quality Control V |
| Quality Control IV |
| Quality Control III |
| Quality Control II |
| Quality Control I |
| General Consultant Categories |
| Consultant |
| Indirect Rate Categories |
| Fringe |
| Fringe (Students) |
| Overhead (Labor) |
| General and Administrative |
| Facilities and Administrative Cost Rate |
| Material Handling |
| Procurement Overhead |
| Subcontract Overhead |
| Business Operating Support Overhead |
| Information Technology Support Overhead |
| Other Direct Cost (ODC) Overhead |
| Facilities Cost of Money: Procurement COM |
| Facilities Cost of Money: G&A COM |
| Facilities Cost of Money: Labor/Engineering COM |
| Other Overhead/Cost Factors |
| Profit (Fixed Price Awards) |
| Fee (Cost Type Awards) |
| SBIR/STTR Phase Choices |
| Not Applicable |
| Phase I |
| Phase II |
| Phase III |
| Small Business Size Choices |
| Not Applicable |
| 1-100 |
| 101-500 |
| 501-1000 |
Business
Proposer Constants
| Proposer's Data Affecting Entire Spreadsheet | | | | | | |
| This Organization's Business Type: | | Small Business Size Estimate: | | | | |
| (drop-down-list) | Not Applicable | (drop-down-list) | | | |
| Proposer Accounting Periods | | | | | | |
| Enter the expected date range of each accounting period from the Proposer's perspective. A period change would represent a change in hourly rates or indirect cost rates. | | | | | | |
| Proposer's Preferred Label: | Proposer FY 1 | Proposer FY 2 | Proposer FY 3 | Proposer FY 4 | Proposer FY 5 | Proposer FY 6 |
| Fiscal Year Begin Date: | 06/01/21 | 06/01/22 | 06/01/23 | 06/01/24 | 06/01/25 | 06/01/26 |
| Fiscal Year End Date: | 05/31/22 | 05/31/23 | 05/31/24 | 05/31/25 | 05/31/26 | 05/31/27 |
| Note 1 - Proposers should set the period of performance for the Base and each Option in cell C1 of the corresponding tabs. | | | | | | |
| Note 2 - A Fiscal Year Begin Date should be one day after the Fiscal Year End Date of the prior fiscal year (or accounting period). Cells will turn red if this condition is not met. | | | | | | |
Labor Rates
| Labor Rates | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| Proposer's Name (Prime or Subcontractor) | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| This line is blank to help align row numbers on this tab with the rows on the Base and Options tabs | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| This line is blank to help align row numbers on this tab with the rows on the Base and Options tabs | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | Proposer FY 1 | | | | | Proposer FY 2 | | | | | | Proposer FY 3 | | | | | | Proposer FY 4 | | | | | | Proposer FY 5 | | | | | | Proposer FY 6 | | | | | | Basis of Labor Rate (Note 1) |
| Pick-List | Pick-List | Open Text | Open Text | $$$ | % | % | % | Calculated | $$$ | Calculated | % | % | % | Calculated | $$$ | Calculated | % | % | % | Calculated | $$$ | Calculated | % | % | % | Calculated | $$$ | Calculated | % | % | % | Calculated | $$$ | Calculated | % | % | % | Calculated | |
| Required | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
1.
DARPA Labor Group Required 2.
| DARPA Labor Category | Proposer's Labor Category | Name or Comment | Hourly Labor Rate | Fringe Benefits Rate | Labor Overhead Rate | G&A Rate | Loaded Hourly Rate | Hourly Labor Rate | Labor Escalation Rate | Fringe Benefits Rate | Labor Overhead Rate | G&A Rate | Loaded Hourly Rate | Hourly Labor Rate | Labor Escalation Rate | Fringe Benefits Rate | Labor Overhead Rate | G&A Rate | Loaded Hourly Rate | Hourly Labor Rate | Labor Escalation Rate | Fringe Benefits Rate | Labor Overhead Rate | G&A Rate | Loaded Hourly Rate | Hourly Labor Rate | Labor Escalation Rate | Fringe Benefits Rate | Labor Overhead Rate | G&A Rate | Loaded Hourly Rate | Hourly Labor Rate | Labor Escalation Rate | Fringe Benefits Rate | Labor Overhead Rate | G&A Rate | Loaded Hourly Rate | (Example: FPRA, Individual Payrate, Average for Job Category, etc.) | |
| | | | $ - 0 | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 |
| | | | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 |
| | | | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 |
| | | | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 |
| | | | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 |
| | | | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 |
| | | | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 |
| | | | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 |
| | | | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 |
| | | | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 |
| | | | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 |
| | | | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 |
| | | | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 |
| | | | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 |
| | | | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 |
| | | | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 |
| | | | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 |
| | | | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 |
| | | | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 |
| | | | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 |
| | | | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 |
| | | | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 |
| | | | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 |
| | | | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 | | N/A | 0.00% | 0.00% | 0.00% | $ - 0 |
| Insert additional Labor Category rows above this line. Also select Base and all Option tabs before inserting new rows. Copy formulas from adjacent rows. | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| Instructions: | • For each row in the Labor Rates table above, the Hourly Labor Rate, Fringe Benefits Rate, and Labor Overhead Rate columns are used for cost calculations in the Base and Options tabs. The G&A/F&A Rate and Loaded Rate are not used for calculations anywhere in this spreadsheet -- these two columns are used for review and evaluation. | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
• Do not insert new columns in this table. If needed, composite rates may be used for Fringe Benefits, Labor Overhead, and G&A/F&A.
• If composite rates are used, provide the calculations used in deriving the composite rates in your cost volume or add another worksheet tab in this spreadsheet to show calculations.
• As a default, the Fringe Benefits, Labor Overhead, and G&A/F&A values are tied to entries on the Indirect Rates and Profit_Fee worksheet. Modify this link as appropriate.
• Do not include any Cost of Money or Profit/Fee costs on this tab.
• If the rates have been approved/negotiated by a Government agency, provide a copy of the memorandum/agreement (FPRA/FPRR).
• If the rates have not been approved/negotiated, provide sufficient detail to enable a determination of allowability, allocability and reasonableness of the allocation bases and how the rates are calculated. This information can be provided in your cost volume or add another worksheet tab in this spreadsheet to show calculations.
• If FPRA is not available, provide back-up documentation for labor rates (e.g., current payroll records)
| Note 1: | Set This Organization's Business Type on the Proposer Constants worksheet to populate the list of DARPA Labor Categories |
| Note 2: | Each proposed Proposer Labor Category must be associated with a DARPA Labor Category (columns A and B above). Choose the best fit using the descriptions below. Proposer's should then place their own labor category title and name of proposed personnel as they normally would (columns C and D above). |
| Labor Category Level | Description |
| I | Entry-level/Junior |
| II | Junior to Mid-level/Journeyman |
| III | Mid-level/Journeyman |
| IV | Mid-Level/Journeyman to Senior Level |
| V | Senior Level |
| Principal | Team Lead/Subject Matter Expert |
| Description Definitions | Consider experience, education, and expertise when selecting a labor category level. |
| ENTRY-LEVEL/JUNIOR: | The junior-level or entry-level position assists more senior positions and may perform tasks and duties under supervision. This level performs work that requires practical experience and training, and applies fundamental concepts, processes, practices, and procedures on technical assignments. |
| MID-LEVEL/JOURNEYMAN: | The journeyman or mid-level position usually performs tasks and duties independently. This position displays and applies intermediate expertise in several complex work assignments which may require originality, innovation, or independent thinking to accomplish. The journeyman or mid-level position contributes to deliverables and performance metrics and is afforded some flexibility to develop or design methods, processes, or solutions to problems. |
| SENIOR-LEVEL: | The senior-level position works on high-visibility or mission-critical aspects of programs or projects and performs tasks and duties independently. This position may oversee or supervise or be responsible for the work of subordinate or less senior positions assigned to programs or projects. The senior-level position displays and applies mastery or distinguished expertise in critical tasks and high-impact assignments. This position leads, manages, plans, and functions as the technical or subject matter expert across multiple programs or projects. |
| PRINCIPAL: | The Principal position leads or manages the entire program or project. The Principal is often a person who is considered to be a leader in a scientific or technical field. |
Summary Cost Table
| Proposer Fiscal Year Labels: | Proposer FY 1 | Proposer FY 2 | Proposer FY 3 | Proposer FY 4 | Proposer FY 5 | Proposer FY 6 | | |
| Hours Proposed in Each Fiscal Year: | 0 | 0 | 0 | 0 | 0 | 0 | | |
| | Base | Op1 | Op2 | Op3 | Op4 | Op5 | Row Sum |
| Total Direct Labor Hours | tdlc.hrs | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| Total Direct Labor Costs | tdlc.dlrs | $ - | $ - | $ - | $ - | $ - | $ - | $ - |
| Total Fringe Benefit Costs | tfbc.dlrs | $ - | $ - | $ - | $ - | $ - | $ - | $ - |
| Total Labor Overhead Costs | tloc.dlrs | $ - | $ - | $ - | $ - | $ - | $ - | $ - |
| Total Subcontract Costs | tsc.dlrs | $ - | $ - | $ - | $ - | $ - | $ - | $ - |
| Total Consultant Costs | tcc.dlrs | $ - | $ - | $ - | $ - | $ - | $ - | $ - |
| Total Other Direct Costs | todc.dlrs | $ - | $ - | $ - | $ - | $ - | $ - | $ - |
| Total Material Handling Costs | tmhc.dlrs | $ - | $ - | $ - | $ - | $ - | $ - | $ - |
| Subtotal Costs | sc.dlrs | $ - | $ - | $ - | $ - | $ - | $ - | $ - |
| Total G&A Costs | tgac.dlrs | $ - | $ - | $ - | $ - | $ - | $ - | $ - |
| Total Cost of Money | tcm.dlrs | $ - | $ - | $ - | $ - | $ - | $ - | $ - |
| Fixed Fee | ff.dlrs | $ - | $ - | $ - | $ - | $ - | $ - | $ - |
| Total Estimated Costs Plus Fixed Fee | tecpff.dlrs | $ - | $ - | $ - | $ - | $ - | $ - | |
| Column Totals | | $ - | $ - | $ - | $ - | $ - | $ - | $ - |
| | | Sum of Column Totals ($) | $ - | | | | |
| | | Sum of Row Totals ($) | $ - | | | | |
| | | COLUMN TOTALS - ROW TOTALS | $ - | This should be $0. If not, research is needed. | | | |
Indirect Rates and Profit_Fee
| Indirect Rates and Profit or Fee | | | | | | | | | |
| Proposer's Name (Prime or Subcontractor) | | | | | | | | | |
| | Proposer FY 1 | Proposer FY 2 | Proposer FY 3 | Proposer FY 4 | Proposer FY 5 | Proposer FY 6 | Basis of Rate | Applied Against |
| DARPA Rate Category | Proposer's Indirect Rate Name | % Rate | % Rate | % Rate | % Rate | % Rate | % Rate | (Example: FPRA, FPRP, Estimate, etc.) | |
| Fringe | Labor Fringe | | | | | | | | |
| Overhead (Labor) | Labor Overhead | | | | | | | | |
| General and Administrative | G&A | | | | | | | | |
Insert additional Indirect Rates above this line
Instructions: • If the rates have been approved/negotiated by a Government agency, provide a copy of the memorandum/agreement.
• If the rates have not been approved/negotiated, provide sufficient detail to enable a determination of allowability, allocability and reasonableness of the allocation bases and how the rates are calculated. This information can be provided in your cost volume or add another worksheet tab in this spreadsheet to show calculations.
• If composite rates are used, provide the calculations used in deriving the composite rates in your cost volume or add another worksheet tab in this spreadsheet to show calculations.
Note 1: Choose an indirect rate from the drop down box in Column A above. Add additional indirect rate category rows if needed. If one proposer rate covers two different DARPA Rate Categories, enter the rate twice with the two different DARPA Rate Categories.
| Note 2: | If the proposer does not have a Forward Pricing Rate Agreement (FPRA), Forward Pricing Rate Recommendation (FPRR), or provisional billing rates; in order to assist the Government in evaluating the reasonableness of your proposed indirect rates, please provide the following information: | |
| | 1. Proforma data used to develop your proposed indirect rates. This consists of breakout of cost pool and cost base that demonstrate how the indirect rate(s) was derived. This information can be provided in your cost volume or add another worksheet tab in this spreadsheet to show calculations |
| | 2. Information regarding your projections for out years, including your assumptions and method for developing these estimates. |
Total Amount
| Cost Proposal - Total Amount | | | | | | | | | |
| Proposer | Proposer's Name (Prime or Subcontractor) | | | | | | | | |
| Prime Contractor | Prime Contractor (Fill-in) (if applicable) | | | | | | | | |
| | (Note 2) | (Note 2) | (Note 2) | (Note 2) | (Note 2) | (Note 2) | | |
| | BASE | OPTION 1 | OPTION 2 | OPTION 3 | OPTION 4 | OPTION 5 | Total | |
| Direct Labor (DL) | | Enter proposed PoP as "MM/YY to MM/YY" | Enter proposed PoP as "MM/YY to MM/YY" | Enter proposed PoP as "MM/YY to MM/YY" | Enter proposed PoP as "MM/YY to MM/YY" | Enter proposed PoP as "MM/YY to MM/YY" | Enter proposed PoP as "MM/YY to MM/YY" | (Note 3) | X-Months |
wade.wargo: Indicate the actual number of total months for the Base and Options.
| Proposer's Labor Category (Note 1) | Name (Last, First) | Hours | Rate | Cost | Hours | Rate | Cost | Hours | Rate | Cost | Hours | Rate | Cost | Hours | Rate | Cost | Hours | Rate | Cost | Hours | Cost |
| | | 0 | See Base Tab | $ - | 0 | See O-I tab | $ - | 0 | See O-II tab | $ - | 0 | See O-III tab | $ - | 0 | See O-IV tab | $ - | 0 | See O-V tab | $ - | 0 | $ - |
| | | 0 | See Base Tab | $ - | 0 | See O-I tab | $ - | 0 | See O-II tab | $ - | 0 | See O-III tab | $ - | 0 | See O-IV tab | $ - | 0 | See O-V tab | $ - | 0 | $ - |
| | | 0 | See Base Tab | $ - | 0 | See O-I tab | $ - | 0 | See O-II tab | $ - | 0 | See O-III tab | $ - | 0 | See O-IV tab | $ - | 0 | See O-V tab | $ - | 0 | $ - |
| | | 0 | See Base Tab | $ - | 0 | See O-I tab | $ - | 0 | See O-II tab | $ - | 0 | See O-III tab | $ - | 0 | See O-IV tab | $ - | 0 | See O-V tab | $ - | 0 | $ - |
| | | 0 | See Base Tab | $ - | 0 | See O-I tab | $ - | 0 | See O-II tab | $ - | 0 | See O-III tab | $ - | 0 | See O-IV tab | $ - | 0 | See O-V tab | $ - | 0 | $ - |
| | | 0 | See Base Tab | $ - | 0 | See O-I tab | $ - | 0 | See O-II tab | $ - | 0 | See O-III tab | $ - | 0 | See O-IV tab | $ - | 0 | See O-V tab | $ - | 0 | $ - |
| | | 0 | See Base Tab | $ - | 0 | See O-I tab | $ - | 0 | See O-II tab | $ - | 0 | See O-III tab | $ - | 0 | See O-IV tab | $ - | 0 | See O-V tab | $ - | 0 | $ - |
| | | 0 | See Base Tab | $ - | 0 | See O-I tab | $ - | 0 | See O-II tab | $ - | 0 | See O-III tab | $ - | 0 | See O-IV tab | $ - | 0 | See O-V tab | $ - | 0 | $ - |
| | | 0 | See Base Tab | $ - | 0 | See O-I tab | $ - | 0 | See O-II tab | $ - | 0 | See O-III tab | $ - | 0 | See O-IV tab | $ - | 0 | See O-V tab | $ - | 0 | $ - |
| | | 0 | See Base Tab | $ - | 0 | See O-I tab | $ - | 0 | See O-II tab | $ - | 0 | See O-III tab | $ - | 0 | See O-IV tab | $ - | 0 | See O-V tab | $ - | 0 | $ - |
| | | 0 | See Base Tab | $ - | 0 | See O-I tab | $ - | 0 | See O-II tab | $ - | 0 | See O-III tab | $ - | 0 | See O-IV tab | $ - | 0 | See O-V tab | $ - | 0 | $ - |
| | | 0 | See Base Tab | $ - | 0 | See O-I tab | $ - | 0 | See O-II tab | $ - | 0 | See O-III tab | $ - | 0 | See O-IV tab | $ - | 0 | See O-V tab | $ - | 0 | $ - |
| | | 0 | See Base Tab | $ - | 0 | See O-I tab | $ - | 0 | See O-II tab | $ - | 0 | See O-III tab | $ - | 0 | See O-IV tab | $ - | 0 | See O-V tab | $ - | 0 | $ - |
| | | 0 | See Base Tab | $ - | 0 | See O-I tab | $ - | 0 | See O-II tab | $ - | 0 | See O-III tab | $ - | 0 | See O-IV tab | $ - | 0 | See O-V tab | $ - | 0 | $ - |
| | | 0 | See Base Tab | $ - | 0 | See O-I tab | $ - | 0 | See O-II tab | $ - | 0 | See O-III tab | $ - | 0 | See O-IV tab | $ - | 0 | See O-V tab | $ - | 0 | $ - |
| | | 0 | See Base Tab | $ - | 0 | See O-I tab | $ - | 0 | See O-II tab | $ - | 0 | See O-III tab | $ - | 0 | See O-IV tab | $ - | 0 | See O-V tab | $ - | 0 | $ - |
| | | 0 | See Base Tab | $ - | 0 | See O-I tab | $ - | 0 | See O-II tab | $ - | 0 | See O-III tab | $ - | 0 | See O-IV tab | $ - | 0 | See O-V tab | $ - | 0 | $ - |
| | | 0 | See Base Tab | $ - | 0 | See O-I tab | $ - | 0 | See O-II tab | $ - | 0 | See O-III tab | $ - | 0 | See O-IV tab | $ - | 0 | See O-V tab | $ - | 0 | $ - |
| | | 0 | See Base Tab | $ - | 0 | See O-I tab | $ - | 0 | See O-II tab | $ - | 0 | See O-III tab | $ - | 0 | See O-IV tab | $ - | 0 | See O-V tab | $ - | 0 | $ - |
| | | 0 | See Base Tab | $ - | 0 | See O-I tab | $ - | 0 | See O-II tab | $ - | 0 | See O-III tab | $ - | 0 | See O-IV tab | $ - | 0 | See O-V tab | $ - | 0 | $ - |
| | | 0 | See Base Tab | $ - | 0 | See O-I tab | $ - | 0 | See O-II tab | $ - | 0 | See O-III tab | $ - | 0 | See O-IV tab | $ - | 0 | See O-V tab | $ - | 0 | $ - |
| | | 0 | See Base Tab | $ - | 0 | See O-I tab | $ - | 0 | See O-II tab | $ - | 0 | See O-III tab | $ - | 0 | See O-IV tab | $ - | 0 | See O-V tab | $ - | 0 | $ - |
| | | 0 | See Base Tab | $ - | 0 | See O-I tab | $ - | 0 | See O-II tab | $ - | 0 | See O-III tab | $ - | 0 | See O-IV tab | $ - | 0 | See O-V tab | $ - | 0 | $ - |
| | | 0 | See Base Tab | $ - | 0 | See O-I tab | $ - | 0 | See O-II tab | $ - | 0 | See O-III tab | $ - | 0 | See O-IV tab | $ - | 0 | See O-V tab | $ - | 0 | $ - |
| Total Direct Labor Costs | | 0 | | $ - | 0 | | $ - | 0 | | $ - | 0 | | $ - | 0 | | $ - | 0 | | $ - | 0 | $ - |
| F/B Based on Labor Rates Tab | | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | $ - |
| Insert line(s) & title(s) for any other F/B rates | | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | $ - |
| Total Fringe Benefit Costs | | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | $ - |
| O/H Based on Labor Rates Tab | | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | $ - |
| Insert line(s) & title(s) for any other O/H rates | | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | $ - |
| Total Labor Overhead Costs | | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | $ - |
| Subcontracts/Interorganizational Transfer | | File/Tab Name or Link | | | | | | | | | | | | | | | | | | | | |
| Subcontract/Interorganizational Name - #01 | Provide details in Subcontractor Tab | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | $ - |
| Subcontract/Interorganizational Name - #02 | Provide details in Subcontractor Tab | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | $ - |
| Subcontract/Interorganizational Name - #03 | Provide details in Subcontractor Tab | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | $ - |
| Insert line(s) for any additional Subcontractors/Interorganizational | Provide details in Subcontractor Tab | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | $ - |
| Total Subcontract Costs | | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | $ - |
| Consultants | | | Hours | Amount | | | | | | | Hours | Amount | | | | | | | Hours | Amount | | |
| Consultant Name - #01 | Provide details in Consultant Tab | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | $ - |
| Consultant Name - #02 | Provide details in Consultant Tab | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | $ - |
| Consultant Name - #03 | Provide details in Consultant Tab | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | $ - |
| Insert line(s) for any additional Consultants | Provide details in Consultant Tab | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | $ - |
| Total Consultant Costs | | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | $ - |
| Other Direct Costs | | | | | | | | | | | | | | | | | | | | | | |
| Materials/Supplies | Provide details in Materials Tab | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | $ - |
| Equipment | Provide details in Equip. Tab | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | $ - |
| Travel | Provide details in Travel Tab | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | $ - |
| Insert line(s) for any other types of ODCs | Provide details in ODC Tab | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | $ - |
| Total Other Direct Costs | | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | $ - |
| Material Handling (M/H O/H) (See Escalation and Indirect Rate Worksheet) | | | Base | Rate | | | | | | | Base | Rate | | | | | | | Base | Rate | | |
| Insert M/H O/H rate title | | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | $ - |
| Insert line(s) & title(s) for any other M/H O/H rates | | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | $ - |
| Total Material Handling Costs | | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | $ - |
| Subtotal Costs | | | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | $ - |
| General and Administrative (G&A) (See Escalation and Indirect Rate Worksheet) | | | Base | Rate | | | | | | | Base | Rate | | | | | | | Base | Rate | | |
| G&A | | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | $ - |
| Insert line(s) & title(s) for any other G&A rates | | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | $ - |
| Total G&A Costs | | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | $ - |
| Subtotal Costs | | | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | $ - |
| Facilities Cost of Money (COM) (See Escalation and Indirect Rate Worksheet) | | | Base | Rate | | | | | | | Base | Rate | | | | | | | Base | Rate | | |
| Insert COM rate title | | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | $ - |
| Insert line(s) & title(s) for any other COM rates | | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | $ - |
| Total Cost of Money | | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | $ - |
| Total Estimated Costs | | | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | $ - |
| Fixed Fee (If proposing a CPFF contract) or Profit | | (Note 4) | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | $ - |
| Total Estimated Costs Plus Fixed Fee | | | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | | $ - | | $ - |
Instructions: • For PRIME submission - Subcontractor Name: If there are subcontracts, list all subcontractor names.
• In upper right last column, 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 B.
• Consultants: If appropriate, place Consultant name(s) in Column B.
• Remember that the total of all Base and Option worksheets should equal the total of the Total Amount worksheet.
• Add descriptions in Column B if costs are entered in the following areas: Fringe Benefits, Labor Overhead, Other Direct Costs/other types, Material Handling, General and Administrative, and Facilities Cost of Money.
| Note 1: | Any proposed personnel in the technical proposal should be identified with their labor category. |
| Note 2: | Indicate the period of performance for the Base effort and each Option on their respective worksheets in cell C1. Ensure that the time periods match those stated in the technical proposal. |
| Note 3: | The values under Total Direct Labor "Hours" column indicate the total level of effort for the project for each labor category. The Proposer must define the split of hours between initial and subsequent rate years based on its FY in the detail worksheets. |
| Note 4: | Profit or fee is not allowed on direct costs for equipment, Government entities or cost share contracts. In addition, a DD Form 1547 (DFARS 215.404-70) will be utilized in calculating the Government objective for fee. |
Base
| Cost Proposal - Base Effort | | Enter proposed PoP as "MM/YY to MM/YY" | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| Proposer | Proposer's Name (Prime or Subcontractor) | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| Prime Contractor | Prime Contractor (Fill-in) (if applicable) | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | (Note 2) | | | | | | | | (Note 2) | | | | | | | | (Note 2) | | | | | | | | (Note 2) | | | | | | | | (Note 2) | | | | | | | | | (Note 2) | | |
| | | | | | Proposer FY 1 | | | | | | | | Proposer FY 2 | | | | | | | | Proposer FY 3 | | | | | | | | Proposer FY 4 | | | | | | | | Proposer FY 5 | | | | | | | | | Proposer FY 6 | | |
| Direct Labor (DL) | | | | | | 06/01/21 to 05/31/22 | | | | | | | | 06/01/22 to 05/31/23 | | | | | | | | 06/01/23 to 05/31/24 | | | | | | | | 06/01/24 to 05/31/25 | | | | | | | | 06/01/25 to 05/31/26 | | | | | | | | | 06/01/26 to 05/31/27 | | |
| Proposer's Labor Category (Note 1) | Name (Last, First) | Hours | Hourly Labor Rate | Direct Labor Cost | Fringe Benefit Rate | Fringe Benefit Cost | Labor Overhead Rate | Labor Overhead Cost | Total $ | Hours | Hourly Labor Rate | Direct Labor Cost | Fringe Benefit Rate | Fringe Benefit Cost | Labor Overhead Rate | Labor Overhead Cost | Total $ | Hours | Hourly Labor Rate | Direct Labor Cost | Fringe Benefit Rate | Fringe Benefit Cost | Labor Overhead Rate | Labor Overhead Cost | Total $ | Hours | Hourly Labor Rate | Direct Labor Cost | Fringe Benefit Rate | Fringe Benefit Cost | Labor Overhead Rate | Labor Overhead Cost | Total $ | Hours | Hourly Labor Rate | Direct Labor Cost | Fringe Benefit Rate | Fringe Benefit Cost | Labor Overhead Rate | Labor Overhead Cost | Total $ | Hours | Hourly Labor Rate | Direct Labor Cost | Fringe Benefit Rate | Fringe Benefit Cost | Labor Overhead Rate | Labor Overhead Cost |
| | | | $ - 0 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 |
| | | | $ - 0 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 |
| | | | $ - 0 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 |
| | | | $ - 0 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 |
| | | | $ - 0 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 |
| | | | $ - 0 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 |
| | | | $ - 0 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 |
| | | | $ - 0 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 |
| | | | $ - 0 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 |
| | | | $ - 0 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 |
| | | | $ - 0 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 |
| | | | $ - 0 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 |
| | | | $ - 0 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 |
| | | | $ - 0 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 |
| | | | $ - 0 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 |
| | | | $ - 0 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 |
| | | | $ - 0 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 |
| | | | $ - 0 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 |
| | | | $ - 0 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - | | $0.00 | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 |
This is the start of the file's text. The full file is on GovTribe.