The file's text, extracted by GovTribe without its formatting.
Change Notes
| Change Notes for Internal Tracking | | |
| Version ID | Tab | Changes from Previous |
| 1.00.00 | All | Adopted DARPA version 1.06.02 with multiple minor revisions to tailor for TRMC T&E/S&T Program needs |
Drop-Down Values
| Drop-Down Values for Lists in Workbook | | | | |
| 1.00.00 | First digit change --> prior functions changes. Second digit change --> new function added. Third digit change --> change in spreadsheet that does not affect functionality | | | |
| BAA # (not used) - Offeror to complete | | Y/N | Equipment Type | PoP |
| | Y | Special Test | N/A |
| | N | Special Tooling | 1 |
| Test Tecchnology Area (TTA) Acronym | | | General Purpose | 2 |
| AAIT | | | Plant Equipment | 3 |
| AIST | | | | 4 |
| _C4T | | | | 5 |
| CTT | | | | 6 |
| DET | | | | 7 |
| EWT | | | | 8 |
| HSST | | | | 9 |
| SST | | | | 10 |
| SET | | | | 11 |
| | | | 12 |
| | | | 13 |
| General, I2, Picklist of Offeror Business Types | | | Cell Range Naming Conventions: | 14 |
| Large Business | | | ThisIsAName = internal constants such as pick-lists | 15 |
| Small Business | | | This.Is.a.Name = named ranges holding proposer data | 16 |
| Non-Profit | | | | 17 |
| Academia | | | | 18 |
| Lab/FFRDC | | | | 19 |
| | | | 20 |
| | | | 21 |
| | | | 22 |
| Small Business Size Choices | | | | 23 |
| Not Applicable | | | | 24 |
| 1-100 | | | | |
| 101-500 | | | | |
| 501-1000 | | | | |
| SBIR/STTR Phase Choices |
| Not Applicable |
| Phase I |
| Phase II |
| Phase III |
Below Content is for DARPA database comparative information. Not used for TRMC T&E/S&T. Retained for future reference
| 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) |
Business
Summary Check Sum
| Check Sum of Project Cost Summary From All Phases Build Up Data (ALL data is from other spreadsheets) | | | | | | | | | |
| 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 | $ - | $ - | $ - | $ - | $ - | $ - | $ - | Total Direct Labor Costs |
| Total Direct Labor Costs | tdlc.dlrs | $ - | $ - | $ - | $ - | $ - | $ - | $ - | Total Fringe Benefit Costs |
| Total Fringe Benefit Costs | tfbc.dlrs | $ - | $ - | $ - | $ - | $ - | $ - | $ - | Total Labor Overhead Costs |
| Total Labor Overhead Costs | tloc.dlrs | $ - | $ - | $ - | $ - | $ - | $ - | $ - | Total Subcontract Costs |
| Total Subcontract Costs | tsc.dlrs | $ - | $ - | $ - | $ - | $ - | $ - | $ - | Total Consultant Costs |
| Total Consultant Costs | tcc.dlrs | $ - | $ - | $ - | $ - | $ - | $ - | $ - | Total Other Direct Costs |
| Total Other Direct Costs | todc.dlrs | $ - | $ - | $ - | $ - | $ - | $ - | $ - | Total Material Handling Costs |
| Total Material Handling Costs | tmhc.dlrs | $ - | $ - | $ - | $ - | $ - | $ - | $ - | Subtotal Costs |
| Subtotal Costs | sc.dlrs | $ - | $ - | $ - | $ - | $ - | $ - | $ - | Total G&A Costs |
| Total G&A Costs | tgac.dlrs | $ - | $ - | $ - | $ - | $ - | $ - | $ - | Subtotal Costs |
| Total Cost of Money | tcm.dlrs | $ - | $ - | $ - | $ - | $ - | $ - | $ - | Total Cost of Money |
| Fixed Fee | ff.dlrs | $ - | $ - | $ - | $ - | $ - | $ - | $ - | Total Estimated Costs |
| Total Estimated Costs Plus Fixed Fee | tecpff.dlrs | $ - | $ - | $ - | $ - | $ - | $ - | | Fixed Fee (If proposing a CPFF contract) or Profit |
| Column Totals | | $ - | $ - | $ - | $ - | $ - | $ - | $ - | Total Estimated Costs Plus Fixed Fee |
| | | Sum of Column Totals ($) | $ - | | | | | |
| | | Sum of Row Totals ($) | $ - | | | | | |
| | | COLUMN TOTALS - ROW TOTALS | $ - | This should be $0. If not, research is needed. | | | | |
INITIALIZATION
| INTRODUCTION / INITIALIZATION | | | | | | | | | |
| | | | | | Contract Structure / Project Phasing | | | |
| Enter requested data in light yellow cells. | | | | | Enter Periods of Performance (PoP) for Project | | | |
| Enter below information for ues throughout workbook: | | | | | Contract | Scope | PoP | |
| Proposer Name: | Proposer's Name (Prime or Sub) | | CAGE: | Proposer's CAGE | | Base | Phase 1 | | months |
| Top Prime Proposer: | Prime Contractor (Fill-in) (if applicable) | | CAGE: | Prime's CAGE | | O-I | Phase 2 | | months |
| BAA #: | W900KK-22-R-0012 | | TTA acronym: | AAIT | (drop-down list) | O-II | Phase 3 | | months |
| Opportunity Notice #: | Identify the topic response document | | | | | O-III | Phase 4 | | months |
| Proposer's Internal Proposal ID | | | | | O-IV | Phase 5 | | months |
| | | | | | O-V | Phase 6 | | months |
| This Organization's Business Type: | | Small Business Size Estimate: | | | | | Total | 0 | months |
| (drop-down-list) | Not Applicable | (drop-down-list) | | | | | | |
| If Small business is chosen, see content to the right. | | | | | | | | | |
| Workbook Purpose and Proposer Obligations: |
| The design and format in the attached worksheets assists Government personnel in the expedited review and evaluation of cost proposals concurrently submitted by multiple 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: cooperative agreement, contract, or other transaction. |
| Completion of this cost proposal workbook per above with the Cost Narrative document enables a rapid cost/price analysis and, if your proposal is selected for award, expedited negotiation and award execution. |
| The contract base and options (or severable major milestones) are referred throughout this document per the Contract Structure/Project Phasing Table in the top right corner of this tab. Successive Options are represented by 'O-I, O-II, O-III, O-IV, O-V). If a Proposer needs more than 6 Phases, use another workbook to address the remaining needs. |
Options: Unpriced Options will not be accepted. Any Option that is not fully priced, will not be included in any resulting award.
Before proceeding to completing other tabs, read the 'General Instructions' tab contents for an overview on the use of each tab and workbook tab color-coding legend. If a row, column, or worksheet in this workbook is not needed for your proposal, either ignore it or hide it; do not delete it.
| Summary of other Documentation/Documents Required for Award |
| Certificate of Current Cost/Pricing Data for Prime if Contract > $2,000,000 |
| Certificate of Current Cost/Pricing Data for each Subcontractor > $2,000,000 |
| If small business or non-traditional defense contractor, Certificate of Current Cost/Pricing Data for each Contract/Subcontractor > $7,500,000 |
| Proposed Project Cost Summary by Cost Type | | | Proposed Project Cost Summary by Phase Execution | | | |
| (auto-populated from 'Project Cost Summary' tab) | | | (auto-populated from 'Project Cost Summary' tab) | | | |
| Total Direct Labor Costs | | $0 | | Base | Phase 1 | $0 |
| Total Fringe Benefit Costs | | $0 | | O-I | Phase 2 | $0 |
| Total Labor Overhead Costs | | $0 | | O-II | Phase 3 | $0 |
| Total Subcontract Costs | | $0 | | O-III | Phase 4 | $0 |
| Total Consultant Costs | | $0 | | O-IV | Phase 5 | $0 |
| Total Other Direct Costs | | $0 | | O-V | Phase 6 | $0 |
| Total Material Handling Costs | | $0 | | | Total | $0 |
| Subtotal Costs | | $0 | | | | |
| Total G&A Costs | | $0 | | | | |
| Subtotal Costs | | $0 | | | | |
| Total Cost of Money | | $0 | | | | |
| Total Estimated Costs | | $0 | | | | |
| Travel | (sub-component of ODCs above) | $0 | | | | |
| Fixed Fee (If proposing a CPFF contract) or Profit | | $0 | | | | |
| Total Project Fee Percentage: | ERROR:#DIV/0! | | | | | |
| Total Estimated Costs Plus Fixed Fee | | $0 | | | | |
TRMC and ACC-Orlando are interested in your feedback on this updated cost proposal spreadsheet. If you have suggestions for improving this spreadsheet, please send an email to the specified email address in the BAA.
General Instructions Overview TRMC T&E/S&T BAA Standardized Cost Proposal Workbook
| Revision Number | |
| 1.00.00 | Overview Instructions and Notes |
| Tab Colors | |
| INTRODUCTION / INITIALIZATION | Fill out data cells associated with submitter's and PRIME information (if PRIME is not the submtter). |
| Enter data associated with the applicable BAA #, Opportunity Notice #, TTA acronym, and each phase's period of performance in months. |
| Identify the proposal ID # (typically specified in the request for proposal/solutions letter from the Contracting Officer). |
| Enter type organization using drop-down menu. If small business, include additional info when cell is activated. |
| Read and follow explanatory information about workbook completion process. |
| Note that the grey cells for Summary of Proposed Cost tables self-complete on this tab (via links from the Project Cost Summary tab). |
| General Instructions | The PRIME and all subcontractors (per stipulations within) shall complete this workbook to develop the complete cost/pricing elements breakouts of the cost proposal. |
| These instructions describe how to use this standardized Cost Proposal workbook to prepare an organization's cost proposal. These instructions do not replace or supersede cost proposal instructions given in the solicitation or announcement. |
| In addition to the instructions provided below, each tab may have additional guidance and instructions on it either at the top or bottom of the tab (or both). |
| DO NOT DELETE tabs, rows, or columns that exist in this template. This will damage the structure of the workbook. If you don't want to see a tab, row, or column, use the Hide function. |
| Input your data in the YELLOW highlighted cells only. Existing data in yellow cells, if any, are provided as illustrative examples or instructions. Delete sample data before submission and populate YELLOW cells as needed. |
| Tab Color-coding Legend: Orange - Introductory/Informational // Green - Requisite set-up information for cost tables // Purple - Cost Tables (requiring proposer input Light purple - 'Flex' Cost tables for use only when directed - and normally hidden) // Sky Blue - Non-labor build-up worksheets for Subcontactors, Consultants, Materials, Equipment, ODCs (each a separate tab) requiring futher input into cost tables // Olive - other Cost/Projected Expenditure tabs (e.g. Project Cost Summary - no data entry required), Project Spend Plan, Cost by Task (used only when directed - and normally hidden)). // Black - Any tabs created by the Proposer for amplification, calculations, or other uses. |
| Before entering any detailed proposal data, complete the yellow fields on the 'INTRODUCTION / INITILIALIZATION", 'Proposer Acct. Data, Project Direct Labor Description', 'Labor Rates', and 'Indirect Rates' tabs. On these green-colored tabs, the data sets are a prequisite for completion of other tabs. |
| Data entered into YELLOW highlighted cells will automatically populate other relevant cells within that worksheet and other tabs. |
| Grey cells have pre-formatted formulas in them to auto-populate data from other tabs and within the same tab. These formulas should not be changed unless there is specific reason to align with the Proposer's business practices. If any changes are made to grey cell formulas or new formulas are created, create a red outline for the cell as shown in cell B2 on this tab. Either use a comments field for the cell to explain the changes, or enter comments in a 'Formula Update Ledger' at the bottom of the same tab. A Proposer must contact the Contracting Officer to obtain a copy of the workbook if any of these cells need to be unlocked. |
| If you need to add tabs to create datasets to populate in other tabs or for other explanatory purposes, use BLACK for the tab color and include the following below the data sets: tab purpose statement, notes that provide specific explanations of data cells (as used in exising tabs), and/or any other relavent commentary. |
| The Proposer is encouraged to create checksum tables where Proposer-created data sets must be transferred for entry into Base (Ph1), O-I (Ph2), O-II (Ph3), O-III (Ph4), O-IV (Ph5), O-V (Ph6), tabs (and Flex tabs, if used). Note that Flex tabs are normally hidden due to estimated infrequent use. |
| DO NOT add rows to worksheets without first understanding guidance in the 'Workbook Change Instructions' tab. Many workbooks need to be selected together when changes are made to keep formulas and links intact across the workbook. |
| Build-up (Sky Blue) workbooks typically do NOT have automatic data population into the phase cost tables. Recommend creating/using a check-sum table in each build-up tab for the respective data populated in the applicable phase cost tables. |
| | Workbook Change | |
| Instructions | This tab provides guidance if you need to modify the workbook by adding rows on any tab, | | |
| | | This tab will discuss conventions that should be used throughout the workbook. Some may be specified for specified worksheets. |
| Proposer Accounting Data | The information collected in this tab is used throughout the workbook. After entering type business, the Proposer enters their corporate accounting fiscal year (FY) timeframe and designates the preferred name for six consecutive corparate fiscal years. All labor and other cost information is entered in relation to a specific corporate FY per the submitted project schedule. This is done to ensure indirect charges that apply over a specific corporate FY period are correctly applied to the time-phased costs. |
| The Proposer's Preferred Label for each fiscal year period will appear on the Labor Rates, Indirect Rates, and all Cost Detail tabs. |
| This workbook provides six proposer fiscal years, which is typically sufficient for TRMC efforts. If you need more fiscal years (or accounting periods), use a second workbook to add the remaining needs -- do not attempt to add fiscal year periods to this workbook. |
| Indirect Rates | List each indirect category required to complete the cost proposal. Add rows if additional indirect categories are required. |
| For each proposer fiscal year/accounting period, list each indirect rate your organization uses in this proposal. |
| You may choose to create links for the Fringe and Overhead rates entered on this tab to the appropriate cells in the 'Labor Rates' tab. There is no pre-set relationship between these tabs. |
| Note the requirements for justifying proposed rates and what costs they are applied against for verification. |
| Direct Labor Categories | Note that Column C of this tab is where labor categories are identified and then used heavily throughout the remainder of the workbook. First list each labor category required for the entire project in this workbook to allow other tabs to properly populate. |
| This tab is also used to provide a basis for the requirement for the use of the labor categories per amplified information discussed below. |
| Provide narrative description of related qualifications, duties, and responsibilities that each labor category will perform. Also include concrete tasks that relate to overall phase objectives identified in the Technical Proposal and SOW. |
| Also note that for each project phase, the labor hours are reflected (in formula cells) from the 'Project Cost Summary' tab. This provides an opportunity for technical review of responsibilities and activities proposed with respect to the calculated Level of Effort (LOE) in the phase cost tables. |
Phase Cost Tables:
Base, O-I, O-II,
| O-III, O-IV, O-V | Each phase tab provides for inputs over six corporate accounting time periods to allow for rate changes for direct labor charges and changes in indirect rates over time. For instance, an 18-month phase may be timed in execution such that the Contractor’s labor rates may change over three Contractor fiscal years. This allows for labor escalation to be shown plus any planned adjustments to indirect rates over the intended Phase Period of Performance. | |
| | Other than the Direct Labor section, the names or labels that appear in column C of the Base, Options, and Project Cost Summary tabs (after row 54) all come from Proposer entrries in Column C of the Base (Ph I) tab. Enter/change ALL names/labels on the Base tab, even if that particular row is not used for the Base phase. All Phase Cost Table tabs (and the Project Cost Summary tab 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. |
| | Enter the proposed cost detail for the Base and each Option period (as needed) on the tabs entitled, "Base (Ph1)", "O-I (Ph2)", "O-II - (Ph3)", O-III (Ph4)", "O-IV (Ph5)", and "O-V (Ph6)". The tab entitled, "Project Cost Summary" will automatically populate from the Base and Option tabs. Note that the term 'Phase' will be used throughout this document to represent the correlated programmatic execution of Base and Options. |
| | Input labor hours for each labor category (or further named individual) apportioned across the Proposer FY periods. Input costs for other categories. |
| | Ensure rows exist for all non-labor cost elements (based on content created in the Sky Blue tabs) by adding rows if necessary under the correct category, naming the source and entering the costs in the appropriate cells. Ensure all indirect costs are associated with and are entered in the correct cells in the respective Proposer FY period. Follow procedures in 'Workbook Change Instructions' tab if required to add rows for Phase Cost Tables tabs (and other data linked tabs). |
| | Note that FEE INPUT is performed at the phase summary level. Total Fixed Fee is input as a dollar amount and the fee percentage of costs are calculated from that. Note that Fee-bearing costs do NOT include travel costs. Fee percentage is based upon the fee bearing costs. |
| | Reminder: Do not change labor categories or names in the Direct Labor section in these Cost Detail tabs. All changes to labor categories and names must be done on previously discussed tabs. |
Project Cost Summary Workbook data is rolled up for summary costs in this tab. No data should be directly entered on this tab. Note required tab updates instructions under the 'INITIALIZATION' tab.
Subcontractors, Consultants, Material, Equipment, Travel, ODC Details
| (separate tabs for each) | Provide cost quotes or estimates with justifications as directed for subcontractors, consultants, material, equipment, travel, and ODCs for the entire project. Each of these categories has its own tab. Tab specific instructions amplifies specific submission and data requiements. | |
| | Costs must also be apportioned across the respective Proposer FY period as labor is performed above. Each of these tabs has tables to orvide details about the details of the respective items, but also includes another table to track how the data on the tab is represented in the Phase Cost Tables tabs as a cross check for information continuity. Instructions on the tabs provide more information. |
| | Subcontractor Section: Provide requested information regarding each contractor. Note the second table on the tab for cost allocation and Phase Cost Table data validation. |
| | Consultants Section: Ths enables data input for consultant cost requirements correlated to scope. |
| | Material Section: For each material item listed, furnish substantiating cost verification information. THIS IS MANDATORY. Sufficient detail must be provided for each material itemized for the Government to ascertain its use during the proposed effort described in the Technical Proposal and SOW. Cost reasonableness should be addressed with appropriate explanations for cost assertions. Competitive pricing information is preferred for demonstrating cost reasonableness. See further guidance in the Materials/Supples tab. |
| | Equipment Section: This is similar to the Materials section, but also requires justification for use of equipment as it is defined per the FAR on the tab. |
| | Travel Section: For all travel, attach all sources for cost verification and explain purpose for travel cost provided. Cost basis for trips may include use of travel web sites, airlines. See Joint Travel Regulations (JTR), OMB Circular A-21, and Joint Federal Travel Regulations (JFTR) for guidance as applicable. More specific guidance is in the tab. |
| | ODC Section: List all ODCs and provide their supporting rationale/justification based on technical proposal and separately attached documentation for cost verification. Complete subcontractor and consultant proposals must be forwarded to the referenced Contract Specialist for rate verification. See above discussion regarding cost reasonableness. |
| Project Spend Plan | Phases must correlate to TRL level advancements. No phase may exceed 24 months. |
| Input the planned monthly expenditures (rounded to whole dollar amount) for each proposed phase as displayed in the tab. |
| Check that the comment boxes below each Phase 'Total Plan $' row are green after all data is entered. If red, address the discrepancy. |
| Cost By Task | This is used only if directed to do so or Proposer obtain permission to to so. This tab inputs all costs associated with eah sub-task that comprise a task. |
| Color-coding enables associating Proposer FYs with the sub-tasks to facilate ease of summing of tasks to Proposer FYs within each proposed phase. |
| A data validation table is availble for entering phase cost entries to demonstrate costs are properly allocated within the entire document. |
| Proposer Use | The Proposer may find value in creating a separate worksheet for explantions, amplificaion, calculations, or other purposes to improve compliance with the Cost Volume submission requirements. If so, create the needed tabs with a unique name for each and an explanation/purpose at the top of the tab. |
| Add a brief comment about each added tab in this section using this color font to draw attention to the Proposer's added content on this tab. |
Workbook Change Instructions
| Workbook Change Instructions |
| • The instructions that follow apply to the tabs/worksheets that are colored green, purple, sky blue, and olive because these tabs are linked together using references and formulas. The sky blue tabs, such as Subcontractor, Consultants, Travel, etc., provide space for cost proposal details, as required. These tabs also contain tables to assimilate costs per the phase an Proposer FY period and a means to track data integrity between the sky blue data and the costs that mus be represented in the Phase Cost Tables tabs. |
| Phase Cost Tables Tabs (These include project Phases as identified by Base, Options, an Flex tabs) | |
| • Ensure rows exist for all non-labor cost elements (based on content created in the Sky Blue tabs) by adding rows if necessary under the correct category, naming the source and entering the costs in the appropriate cells. Ensure all indirect costs are associated with and are entered in the correct cells in the respective Proposer FY period. Follow procedures below tab if required to add rows for Phase Cost Tables tabs (and other data linked tabs). |
| • Proposers may add additional specific cost categories (Subcontractors, ODC types, etc.) as needed, but must ensure those new cost categories also track to the Project Cost Summary tabs. Follow the instructions below to add more rows. |
| Adding Rows | |
| • This workbook is designed to handle the addition of rows. It cannot handle the addition or removal of columns. As you use the workbook, 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 (and linked) worksheets. The instructions below describe how to add rows for the Labor Rates and Cost Detail tabs. |
| Add Rows to obtain MORE Labor Categories | |
| • Whenever an additional labor category row is needed (in addition to the 40 provided rows), a row must be added to all related worksheets. The worksheets involved are: Direct labor Categories, Labor Rates, Project Cost Summary, and the Base, O-I, O-II, O-III, O-IV, O-V, and Flex worksheets. |
| Step # | |
| 1 | First, select any one of the involved worksheets above, EXCEPT the Direct Labor Categories tab. |
| 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 | The Direct Labor Categories worksheet can have rows copied from the last row below it for the number needed. Follow step 4 above for this tab to ensure all formulas are updated. |
| 7 | Update both the Direct Labor Categories and Labor Rates tabs with requisite entries. |
| Add Rows to provide for MORE Other Cost Category elements | |
| • 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: Project Cost Summary, and the Base, O-I, O-II, O-III, O-IV, O-V, and Flex worksheets. No direct labor-focused tabs are involved. |
| • All common row labels, such as Subcontractor names, Consultant names, and Indirect Rates, are pulled from the labels of the Base worksheet. This means that when you want to add a row for one Option, you need to add rows to all related worksheets. For example, if you want a particular subcontractor to be involved only with Option 1, you need to name that subcontractor on the Base worksheet and leave all dollar amounts as zero for the Base period. |
| Step # | |
| 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 data rows in the relevant section of the active worksheet. Do not highlight a Title row or a Total row. Right click on a highlighted row number and select 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 C for the newly inserted cost category rows. Changing the description on the Base worksheet also updates the description on the other worksheets. |
Proposer Acct. Data
| Proposer Accounting Data as Constants (used throughout this workbook) |
| Proposer's Name (Prime or Sub) |
| 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. |
| Color-Codes for Sections (see Note 1): | | | | | | |
| Proposer's Preferred Label (see Note 2): | Proposer FY 1 | Proposer FY 2 | Proposer FY 3 | Proposer FY 4 | Proposer FY 5 | Proposer FY 6 |
| Corp. Fiscal Year Begin Date (see Note 3): | | 12/31/00 | 12/31/01 | 12/31/02 | 12/31/03 | 12/31/04 |
| Corp. Fiscal Year End Date (see Note 3): | | 12/31/00 | 12/31/01 | 12/31/02 | 12/31/03 | 12/31/04 |
| Note 1 - Throughout the workbook, the Proposer FY periods are consistently color-coded using the colors above. |
| This is intended to help visually group cost elements in the correct timeframes. |
Note 2 - Proposers should set the Period of Performance for the Base and each Option in cell C1 of the corresponding tabs.
Note 3 - A corporate 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.
Enter accounting period (Proposer FY) data below and name each period if prefer to use if different than below.
Direct Labor Categories
| Project Direct Labor Description |
| Proposer's Name (Prime or Sub) |
| | Category # | (Note 1) Labor Category Title | Qualifications | Duties/Responsibilities | (Note 2) Major Tasks: Phase 1 (Base) | Ph1 Hrs | (Note 2) Major Tasks: Phase 2 (O-I) | Ph 2 Hrs | (Note 2) Major Tasks: Phase 3 (O-II) | Ph 3 Hrs | (Note 2) Major Tasks: Phase 4 (O-III) | Ph 4 Hrs | (Note 2) Major Tasks: Phase 5 (O-IV) | Ph 5 Hrs | (Note 2) Major Tasks: Phase 6 (O-V) | Ph 6 Hrs | (Note 2) Major Tasks: Flex (if used) |
| | Example or | | | | | | | | | | | | | | | | |
| Intructions | Sr. Research Engineer | PhD in Physics or Engineering, 7 - 12 years direct technology related experience. | Performs advanced physics computations related to the modeling and simulation of developed systems. | Identify primary tasks performed during this period by this labor grade/person. If specific to an individual, identify name in the task. | | | | | | | | | | | | | | |
| From completed | | | | | | | | | | | | | | | | | |
| 'Base' tab | Identify primary tasks performed during this period by this labor grade/person. If specific to an individual, identify name in the task activity. | From completed | | | | | | | | | | | | | | | | |
| 'O-I' tab | Identify primary tasks performed during this period by this labor grade/person. If specific to an individual, identify name in the task activity. | From completed | | | | | | | | | | | | | | | | |
| 'O-II' tab | Identify primary tasks performed during this period by this labor grade/person. If specific to an individual, identify name in the task activity. | From completed | | | | | | | | | | | | | | | | |
| 'O-III' tab | Identify primary tasks performed during this period by this labor grade/person. If specific to an individual, identify name in the task activity. | From completed | | | | | | | | | | | | | | | | |
| 'O-IV' tab | Identify primary tasks performed during this period by this labor grade/person. If specific to an individual, identify name in the task activity. | From completed | | | | | | | | | | | | | | | | |
| 'O-V' tab | NOT INTENDED FOR USE UNLESS SPECIFIED OR REQUESTED ON A CASE BASIS. If used, follow prior guidance. | | | | | | | | | | | | | | | | | |
| | 1 | | | | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | |
| | 2 | | | | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | |
| | 3 | | | | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | |
| | 4 | | | | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | |
| | 5 | | | | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | |
| | 6 | | | | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | |
| | 7 | | | | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | |
| | 8 | | | | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | |
| | 9 | | | | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | |
| | 10 | | | | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | |
| | 11 | | | | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | |
| | 12 | | | | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | |
| | 13 | | | | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | |
| | 14 | | | | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | |
| | 15 | | | | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | |
| | 16 | | | | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | |
| | 17 | | | | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | |
| | 18 | | | | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | |
| | 19 | | | | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | |
| | 20 | | | | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | |
| | 21 | | | | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | |
| | 22 | | | | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | |
| | 23 | | | | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | |
| | 24 | | | | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | |
| | 25 | | | | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | |
| | 26 | | | | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | |
| | 27 | | | | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | |
| | 28 | | | | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | |
| | 29 | | | | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | |
| | 30 | | | | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | |
| | 31 | | | | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | |
| | 32 | | | | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | |
| | 33 | | | | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | |
| | 34 | | | | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | |
| | 35 | | | | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | |
| | 36 | | | | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | |
| | 37 | | | | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | |
| | 38 | | | | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | |
| | 39 | | | | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | |
| | 40 | | | | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | |
Note 1: This is the source tab where each Labor Category Title is automatically pasted into Labor Rates, Summary and Phase Tabs for Base (Ph1), O-I (Ph2), O-II (Ph3), O-III (Ph4), O-IV (Ph5), O-V (Ph6), and Flex (if used).
Note 2: Expound on tasks summary using the Cost Narrative document with cross references to this tab and the applicable cells.
Provide labor category title and narrative description of related qualifications, duties, and responsibilities that category will perform. Identify major concrete tasks that relate to overall phase objectives identified in Technical Proposal and SOW.
Indirect Rates
| Indirect Rates |
| Proposer's Name (Prime or Sub) |
| Proposer FY 1 | Proposer FY 2 | Proposer FY 3 | Proposer FY 4 | Proposer FY 5 | Proposer FY 6 | Basis of Rate (Note 2) | |
| Proposer's Indirect Rate Name | % Rate | % Rate | % Rate | % Rate | % Rate | % Rate | (Example: FPRA, FPRP, Estimate, etc.) | Applied Against |
| fringe | | | | | | | | |
| labor OH | | | | | | | | |
| Matl OH | | | | | | | | |
| G&A | | | | | | | | |
Insert additional Indirect Rates above this line Note 1
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.
| • Rates are shown to six decimal places to support Cost of Money rate assessments. |
| Hint: | • To expedite workflow, consider linking these rates to the applicable cells in the phase cost build-up tabs for the Base and Options. |
| Note 1: | Add additional indirect rate category rows, if needed. |
| 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. |
Identify each Indirect Rate category that applies to this proposal, then list the rates used within each of the accounting periods below (that correspond to the Proposer Acct. Data tab entries). Also complete remaining columns per amplification in further instructions below.
Labor Rates
| | Labor Rates | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | Proposer's Name (Prime or Sub) | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | SCROLL STOP |
| | 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) | |
| | Open Text | Open Text | | $$$ | | % | % | % | Calculated | | $$$ | Calculated | % | % | % | Calculated | | $$$ | Calculated | % | % | % | Calculated | | $$$ | Calculated | % | % | % | Calculated | | $$$ | Calculated | % | % | % | Calculated | | $$$ | Calculated | % | % | % | Calculated | | |
| | Proposer's Labor Category | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| (from Project Direct Labor Descriptions) | Name or Number of People Billing | Hourly Labor Rate | | Fringe Benefits Rate | Labor Overhead Rate | G&A Rate | Fully Loaded Rate | | Hourly Labor Rate | Labor Escalation Rate | Fringe Benefits Rate | Labor Overhead Rate | G&A Rate | Fully Loaded Rate | | Hourly Labor Rate | Labor Escalation Rate | Fringe Benefits Rate | Labor Overhead Rate | G&A Rate | Fully Loaded Rate | | Hourly Labor Rate | Labor Escalation Rate | Fringe Benefits Rate | Labor Overhead Rate | G&A Rate | Fully Loaded Rate | | Hourly Labor Rate | Labor Escalation Rate | Fringe Benefits Rate | Labor Overhead Rate | G&A Rate | Fully Loaded Rate | | Hourly Labor Rate | Labor Escalation Rate | Fringe Benefits Rate | Labor Overhead Rate | G&A Rate | Fully Loaded Rate | (Example: FPRA, Individual Payrate, Average for Job Category, etc.) | | | | |
| | | | | | | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | |
| | | | | | | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | |
| | | | | | | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | |
| | | | | | | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | |
| | | | | | | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | |
| | | | | | | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | |
| | | | | | | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | |
| | | | | | | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | |
| | | | | | | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | |
| | | | | | | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | |
| | | | | | | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | |
| | | | | | | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | |
| | | | | | | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | |
| | | | | | | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | |
| | | | | | | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | |
| | | | | | | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | |
| | | | | | | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | |
| | | | | | | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | |
| | | | | | | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | |
| | | | | | | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | |
| | | | | | | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | |
| | | | | | | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | |
| | | | | | | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | |
| | | | | | | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | |
| | | | | | | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | |
| | | | | | | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | |
| | | | | | | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | |
| | | | | | | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | |
| | | | | | | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | |
| | | | | | | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | |
| | | | | | | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | |
| | | | | | | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | |
| | | | | | | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | |
| | | | | | | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | |
| | | | | | | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | |
| | | | | | | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | |
| | | | | | | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | |
| | | | | | | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | |
| | | | | | | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | |
| | | | | $ 206.67 | | 60.00% | 20.00% | 16.00% | $ 460.29 | | | -100% | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 0 | | | N/A | | | | $ - 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: | |
| Note 1: | • 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 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.
• If FPRA is not available, provide back-up documentation for labor rates (e.g., current payroll records) Scroll Stop
Enter requested data in yellow cells. Annotate per convention if formulas are added for indirect rates. See further instructions below
Project Cost Summary
| Project Cost Summary - Total Amount | | |
| Proposer | Proposer's Name (Prime or Sub) | SCROLL STOP |
| Prime Contractor | Prime Contractor (Fill-in) (if applicable) | |
| | | | BASE | | | OPTION 1 | | | OPTION 2 | | | OPTION 3 | | | OPTION 4 | | | OPTION 5 | | Summary | & Tot PoP (mo) |
| 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) | 0 |
| 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 | Total Hours | Total 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 | $ - |
| | | 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 | | | Sub-totals | | | Sub-totals | | | Sub-totals | | | Sub-totals | | | Sub-totals | | | Sub-totals | | Sub-totals |
| 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 | | | | | Sub-totals | | | Sub-totals | | | Sub-totals | | | Sub-totals | | | Sub-totals | | | Sub-totals | | Sub-totals |
| 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 | | | | | Sub-totals | | | Sub-totals | | | Sub-totals | | | Sub-totals | | | Sub-totals | | | Sub-totals | | Sub-totals |
This is the start of the file's text. The full file is on GovTribe.
