Attachment_E_NIEHS_Level_of_Effort_worksheet.xlsx
XLSX spreadsheet 40 KB Posted
- Solicitation number
- 75N94026R00002
About this file
This is a Level of Effort cost proposal template for the NIEHS Division of Translational Toxicology (DTT) Chemistry Research solicitation (75N94026R00002). The Excel-based template requires offerors to input direct labor costs, indirect rates, and other direct costs across a base year and up to ten option years, with a standard 3% annual inflation escalation factor. Offerors must populate only designated yellow cells with hourly rates for four labor categories (Senior Research Professional GS-14/15, Research Professional GS-12/13, Technical GS-7/11, and Support Staff GS-5), as well as fringe benefits, indirect costs, General & Administration, and fixed fee percentages. The template automatically calculates total costs by category and contract year through embedded formulas.
The cost proposal is structured into two primary sections: Base Government Cost Estimate for core DTT services and Optional Work Government Cost Estimate for Option 1 additional studies. Offerors must estimate labor hours by task type across 24 defined chemistry-related functional areas including ADMES, Characterization, Formulation, Biosample Analysis, Special Studies, Animal Studies, and Omics activities. Other direct costs categories include materials, supplies, equipment, travel, consultants, and computing communications. The template includes sections for contractor notes and assumptions, and offerors are required to document any formula modifications made to the template. A detailed labor cost breakdown table requires allocation of anticipated hours per year across all four labor categories for both base and optional work tasks.
View the file
Other files
Show all 20
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Instructions
Offerors shall utilize and submit this Excel template for their cost proposal. Instructions are provided on each tab in red font. If any changes are made to the template, such as formula adjustments, please include a note in the file so that it can be easily identified by the evaluator.
Please only input information into the yellow cells or text boxes.
Total Contract Base and Each Option
| Contract Year | Base Cost | Option 1 | ||
| Additional Work Cost/Exercise | Total Contract Cost | |||
| Base | $ - 0 | ERROR:#REF! | ERROR:#REF! | |
| Option Year 1 | $ - 0 | ERROR:#REF! | ERROR:#REF! | |
| Option Year 2 | $ - 0 | ERROR:#REF! | ERROR:#REF! | |
| Option Year 3 | $ - 0 | ERROR:#REF! | ERROR:#REF! | |
| Option Year 4 | $ - 0 | ERROR:#REF! | ERROR:#REF! | |
| Option Year 5 | $ - 0 | ERROR:#REF! | ERROR:#REF! | |
| Option Year 6 | $ - 0 | ERROR:#REF! | ERROR:#REF! | |
| Option Year 7 | $ - 0 | ERROR:#REF! | ERROR:#REF! | |
| Option Year 8 | $ - 0 | ERROR:#REF! | ERROR:#REF! | |
| Option Year 9 | $ - 0 | ERROR:#REF! | ERROR:#REF! | |
| Option Year 10 (Option 2 6monthe ext) | $ - 0 | $ - 0 | $ - 0 | |
| Total | $ - 0 | ERROR:#REF! | ERROR:#REF! |
Rates
| Direct Rates | |
| Personnel Category Rates | $/hour |
| Senior Research Professional | |
| Professional | |
| Technical Staff | |
| Support Staff |
| Indirect Rates |
| Fringe Benefits % |
| Indirect Costs % |
| General &Administration (G & A( % |
| Fixed Fee % |
| Inflation Escalation Factor (%/year) |
Please insert rates into the yellow boxes in Column F. These rates will flow to the following tabs.
Base Government Cost Estimate
| DIRECT LABOR - BASE CONTRACT | ||||
| (PER AWARD) | ESTIMATED | |||
| CLASS/GS EQUIVALENT | HOURS | RATE $/HOUR | TOTAL | This tab is for the base services in the statement of work. Offerors are required to propose costs for this item. |
| Senior Research Professional (GS-14/15) | 0.00 | $0 | Please insert hours into the yellow boxes in Column C. All other items flow from other tabs. | |
| Research Professional (GS-12/13) | 0.00 | $0 | Include any assumptions or notes in this text box below if needed. | |
| Technical (GS-7/11) | 0.00 | $0 | Contractor Notes: | |
| Support Staff (GS-5) | 0.00 | $0 | ||
| 0 | ||||
| TOTAL DIRECT LABOR | $0 |
| FRINGE BENEFITS | |
| x% of Total Direct Labor | $0 |
OTHER DIRECT COSTS
| Materials/Supplies |
| Equipment & Equipment Transfer (Year 1) |
| Travel |
| Consultants |
| Computing & Communications Costs |
TOTAL OTHER DIRECT COSTS $0
TOTAL DIRECT COSTS $0
INDIRECT COSTS
X% of Total Direct Costs* $0
| TOTAL DIRECT AND INDIRECT COSTS | $0 |
| General and Administrative (G & A) (x%) | $0 |
| TOTAL COST ( with G & A) | $0 |
| FIXED FEE (x%) | $0 |
| TOTAL COST PLUS FIXED FEE | ||
| Base Year | $0 | |
| Option Year 1 (add inflation factor of 3% to Base Year costs)† | $0 | |
| Option Year 2 (add inflation factor of 3% to Option Year 1 costs)† | $0 | |
| Option Year 3 (add inflation factor of 3% to Option Year 2 costs)† | $0 | |
| Option Year 4 (add inflation factor of 3% to Option Year 3 costs)† | $0 | |
| Option Year 5 (add inflation factor of 3% to Option Year 4 costs)† | $0 | |
| Option Year 6 (add inflation factor of 3% to Option Year 5 costs)† | $0 | |
| Option Year 7 (add inflation factor of 3% to Option Year 6 costs)† | $0 | |
| Option Year 8 (add inflation factor of 3% to Option Year 7 costs)† | $0 | |
| Option Year 9 (add inflation factor of 3% to Option Year 8 costs)† | $0 | |
| Option Year 10 (Option 2): 6 month ext (add inflation factor of 3% to Option Year 9 costs)† | $0 | |
| GRAND TOTAL | $0 |
Optional Work Government Cost Estimate
| DIRECT LABOR - OPTIONAL STUDIES - ADDITIONAL WORK | ||||
| (PER AWARD) | ESTIMATED | This tab is for the Option 1 services in the statement of work. Offerors are required to propose costs for this item. | ||
| CLASS/GS EQUIVALENT | HOURS | RATE/HOUR | TOTAL | Please insert hours into the yellow boxes in Column C. All other items flow from other tabs. |
| Senior Research Professional (GS-14/15) | 0 | 0.00 | $0 | Include any assumptions or notes in this text box below if needed. |
| Research Professional (GS-12/13) | 0 | 0.00 | $0 | Contractor Notes: |
| Professional (GS-7/11) | 0 | 0.00 | $0 | |
| Support Staff (GS-5) | 0 | 0.00 | $0 | |
| 0.00 | ||||
| TOTAL DIRECT LABOR | $0 |
| FRINGE BENEFITS | |
| X%* of Total Direct Labor | $0 |
OTHER DIRECT COSTS
| Materials/Supplies | ERROR:#REF! |
| Consultants | ERROR:#REF! |
| Computing & Communications Costs | ERROR:#REF! |
TOTAL OTHER DIRECT COSTS ERROR:#REF!
TOTAL DIRECT COSTS ERROR:#REF!
INDIRECT COSTS
X%* of Total Direct Costs ERROR:#REF!
| TOTAL DIRECT AND INDIRECT COSTS | ERROR:#REF! |
| General and Administrative (G & A) | ERROR:#REF! |
| TOTAL COST (with G & A) | ERROR:#REF! |
| FIXED FEE (X%) | ERROR:#REF! |
| TOTAL COST PLUS FIXED FEE | ||
| Base Year | ERROR:#REF! | |
| Option Year 1 (add inflation factor of 3% to Base Year costs)† | ERROR:#REF! | |
| Option Year 2 (add inflation factor of 3% to Option Year 1 costs)† | ERROR:#REF! | |
| Option Year 3 (add inflation factor of 3% to Option Year 2 costs)† | ERROR:#REF! | |
| Option Year 4 (add inflation factor of 3% to Option Year 3 costs)† | ERROR:#REF! | |
| Option Year 5 (add inflation factor of 3% to Option Year 4 costs)† | ERROR:#REF! | |
| Option Year 6 (add inflation factor of 3% to Option Year 5 costs)† | ERROR:#REF! | |
| Option Year 7 (add inflation factor of 3% to Option Year 6 costs)† | ERROR:#REF! | |
| Option Year 8 (add inflation factor of 3% to Option Year 7 costs)† | ERROR:#REF! | |
| Option Year 9 (add inflation factor of 3% to Option Year 8 costs)† | ERROR:#REF! | |
| GRAND TOTAL | ERROR:#REF! |
Base Labor & Cost Details
| Task Type* | ||||||||||
| Type | Anticipated Tasks per Year | Senior Research Professional hr | Research Professional hr | Technical hr | Support hr | Total hrs | This tab is for the base services in the statement of work. | |||
| ADMES | 1 | 0 | Please insert hours into the yellow box in columns E through H for applicable labor categories. | |||||||
| AWA | 1 | 0 | Offeror can add or delete labor categories as appropriate. | |||||||
| BMD | 3 | 0 | Include any assumptions or notes in this text box below if needed. | |||||||
| BSA | 5 | 0 | Contractor Notes: | |||||||
| CCA | 3 | 0 | ||||||||
| CH | 3 | 0 | ||||||||
| CIPS | 3 | 0 | ||||||||
| CP | 3 | 0 | ||||||||
| CRA | 2 | 0 | ||||||||
| CS | 2 | 0 | ||||||||
| FA | 2 | 0 | ||||||||
| FD | 3 | 0 | ||||||||
| FPAS | 3 | 0 | ||||||||
| IVS | 2 | 0 | ||||||||
| MCH | 3 | 0 | ||||||||
| MCP | 3 | 0 | ||||||||
| MIPS | 3 | 0 | ||||||||
| PD | 1 | 0 | ||||||||
| PFS | 1 | 0 | ||||||||
| SCA | 8 | 0 | ||||||||
| SHIP | 10 | 0 | ||||||||
| TKS | 2 | 0 | ||||||||
| VA | 3 | 0 | ||||||||
| OMICS | 2 | 0 | ||||||||
| Contract Administration* | 1 | 0 | ||||||||
| Total | 0 | 0 | 0 | 0 | 0 |
* Refer to DTT chemistry specifications for description of task types and Sample Research Outlines for specific scope.
Opt. Work Labor & Cost Details
| Optional Studies - Additional Work | |||||||||
| Task Type* | |||||||||
| Type | Anticipated Number per Year | Senior Research Professional hr | Research Professional hr | Technical hr | Support hr | Total hrs | This tab is for Optional 1 services in the statement of work. | ||
| ADMES | 0 | 0 | Please insert hours into the yellow box in columns E through H for applicable labor categories. | ||||||
| AWA | 0 | 0 | Offeror can add or delete labor categories as appropriate. | ||||||
| BMD | 1 | 0 | Include any assumptions or notes in this text box below if needed. | ||||||
| BSA | 2 | 0 | Contractor Notes: | ||||||
| CCA | 1 | 0 | |||||||
| CH | 1 | 0 | |||||||
| CIPS | 1 | 0 | |||||||
| CP | 1 | 0 | |||||||
| CRA | 1 | 0 | |||||||
| CS | 1 | 0 | |||||||
| FA | 1 | 0 | |||||||
| FD | 1 | 0 | |||||||
| FPAS | 1 | 0 | |||||||
| IVS | 1 | 0 | |||||||
| MCH | 1 | 0 | |||||||
| MCP | 1 | 0 | |||||||
| MIPS | 1 | 0 | |||||||
| PD | 0 | 0 | |||||||
| PFS | 0 | 0 | |||||||
| SCA | 2 | 0 | |||||||
| SHIP | 3 | 0 | |||||||
| TKS | 1 | 0 | |||||||
| VA | 1 | 0 | |||||||
| OMICS | 1 | 0 | |||||||
| Contract Administration | 1 | 0 | |||||||
| Total | 0 | 0 | 0 | 0 | 0 |
* Refer to DTT chemistry specifications for description of task types and Sample Research Outlines for specific scope.
File details come from the government source that posted it. Updated .