Attachment_E_NIEHS_Level_of_Effort_worksheet.xlsx

XLSX spreadsheet 40 KB Posted

Attached to
Chemistry Research for the Division of Translational Toxicology (DTT)
Solicitation number
75N94026R00002
Issued by

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 YearBase CostOption 1
Additional Work Cost/ExerciseTotal Contract Cost
Base$ - 0ERROR:#REF!ERROR:#REF!
Option Year 1$ - 0ERROR:#REF!ERROR:#REF!
Option Year 2$ - 0ERROR:#REF!ERROR:#REF!
Option Year 3$ - 0ERROR:#REF!ERROR:#REF!
Option Year 4$ - 0ERROR:#REF!ERROR:#REF!
Option Year 5$ - 0ERROR:#REF!ERROR:#REF!
Option Year 6$ - 0ERROR:#REF!ERROR:#REF!
Option Year 7$ - 0ERROR:#REF!ERROR:#REF!
Option Year 8$ - 0ERROR:#REF!ERROR:#REF!
Option Year 9$ - 0ERROR:#REF!ERROR:#REF!
Option Year 10 (Option 2 6monthe ext)$ - 0$ - 0$ - 0
Total$ - 0ERROR:#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 EQUIVALENTHOURSRATE $/HOURTOTALThis 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$0Please insert hours into the yellow boxes in Column C. All other items flow from other tabs.
Research Professional (GS-12/13)0.00$0Include any assumptions or notes in this text box below if needed.
Technical (GS-7/11)0.00$0Contractor 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)ESTIMATEDThis tab is for the Option 1 services in the statement of work. Offerors are required to propose costs for this item.
CLASS/GS EQUIVALENTHOURSRATE/HOURTOTALPlease insert hours into the yellow boxes in Column C. All other items flow from other tabs.
Senior Research Professional (GS-14/15)00.00$0Include any assumptions or notes in this text box below if needed.
Research Professional (GS-12/13)00.00$0Contractor Notes:
Professional (GS-7/11)00.00$0
Support Staff (GS-5)00.00$0
0.00
TOTAL DIRECT LABOR$0
FRINGE BENEFITS
X%* of Total Direct Labor$0

OTHER DIRECT COSTS

Materials/SuppliesERROR:#REF!
ConsultantsERROR:#REF!
Computing & Communications CostsERROR:#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 COSTSERROR:#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 YearERROR:#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 TOTALERROR:#REF!

Base Labor & Cost Details

Task Type*
TypeAnticipated Tasks per YearSenior Research Professional hrResearch Professional hrTechnical hrSupport hrTotal hrsThis tab is for the base services in the statement of work.
ADMES10Please insert hours into the yellow box in columns E through H for applicable labor categories.
AWA10Offeror can add or delete labor categories as appropriate.
BMD30Include any assumptions or notes in this text box below if needed.
BSA50Contractor Notes:
CCA30
CH30
CIPS30
CP30
CRA20
CS20
FA20
FD30
FPAS30
IVS20
MCH30
MCP30
MIPS30
PD10
PFS10
SCA80
SHIP100
TKS20
VA30
OMICS20
Contract Administration*10
Total00000

* 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*
TypeAnticipated Number per YearSenior Research Professional hrResearch Professional hrTechnical hrSupport hrTotal hrsThis tab is for Optional 1 services in the statement of work.
ADMES00Please insert hours into the yellow box in columns E through H for applicable labor categories.
AWA00Offeror can add or delete labor categories as appropriate.
BMD10Include any assumptions or notes in this text box below if needed.
BSA20Contractor Notes:
CCA10
CH10
CIPS10
CP10
CRA10
CS10
FA10
FD10
FPAS10
IVS10
MCH10
MCP10
MIPS10
PD00
PFS00
SCA20
SHIP30
TKS10
VA10
OMICS10
Contract Administration10
Total00000

* 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 .