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 Chemistry Research contract (Solicitation 75N94026R00002). Offerors must utilize the provided Excel template to submit detailed cost proposals with all calculations flowing from labor rates and hours entered into designated yellow cells. The template requires input of hourly rates for four labor categories: Senior Research Professional (GS-14/15), Research Professional (GS-12/13), Technical Staff (GS-7/11), and Support Staff (GS-5), along with indirect cost rates (fringe benefits, indirect costs, G&A, and fixed fee). Offerors must also apply a 3% annual inflation escalation factor across the contract period.
The cost structure addresses two distinct work scopes: base services and optional studies (Option 1). For each, offerors allocate labor hours across 22 defined task types including ADMES, AWA, BMD, BSA, CCA, CH, CIPS, CP, CRA, CS, FA, FD, FPAS, IVS, MCH, MCP, MIPS, PD, PFS, SCA, SHIP, TKS, VA, and OMICS, plus contract administration. The base year costs flow through to ten option years, with Option Year 10 representing a six-month extension under Option 2. The template includes separate worksheets for base labor and cost details, optional work labor and cost details, direct labor calculations, other direct costs (materials, supplies, equipment, travel, consultants, computing), indirect costs, and cumulative contract totals. Any modifications to formulas must be noted for evaluator identification.
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 .