Attachment_D_OAGS_IDIQ_Pricing_Worksheets.xlsx

XLSX spreadsheet 495 KB Posted

Attached to
Acquisitions and Grants Support Services Federal contract opportunity
Solicitation number
17-223-SOL-00038
Issued by
Department of Health and Human Services Food and Drug Administration

View the file

Other files for this federal contract opportunity

Other files attached to Acquisitions and Grants Support Services, newest first.
File Type Posted
Solicitation_FDA-17-223-SOL-00038_-_AGSS_(June_26,_2017)__(Clarify_Evaluation_Factor_2).docx DOCX document
Solicitation_FDA-17-223-SOL-00038_-_AGSS_clean_(June_16,_2017)_.pdf PDF
Copy_of_Amendment_0002__Attachment_J__Vendor_Questions_and_Answers_(16-June-2017).xls XLS spreadsheet
3_Attachment_A__Statement_of_Work_Acquisition_Support_IDIQ_6_13_17_.pdf PDF
1_Attachment_J__Vendor_Questions_and_Answers__(13-June-2017).xls XLS spreadsheet
5_Attachment_D_OAGS_IDIQ_Pricing_Worksheets_(13-June-2017).xlsx XLSX spreadsheet
4_Attachment_B_Acquisitions_and_Grants_Support_Services_Labor_Categories_and_Descriptions.pdf PDF
2_Solicitation_FDA-17-223-SOL-00038_-_AGSS_clean_.pdf PDF
Attachment_F_FAR_Clause_52.212-5_JAN_2017.docx DOCX document
Solicitation_FDA-17-223-SOL-00038_-_AGSS_.pdf PDF
Attachment_B_Acquisitions_and_Grants_Support_Services_Labor_Categories_and_Descriptions.pdf PDF
Attachment_G__FDA_1335_PERSONNEL_SECURITY_CLEARANCE_REQUIREMENTS.pdf PDF
Attachment_J_Vendor_Question_Format.xls XLS spreadsheet
Attachment_C__Past_Performance_Questionnaire.doc DOC document
Attachment_E_FAR_Provision_52.212-3_JAN_2017.docx DOCX document
Attachment_A__Statement_of_Work_Acquisition_Support_IDIQ_.pdf PDF
Attachment_I__Sample_Commitment_Letter.doc DOC document
Attachment_H_COMMITMENT_TO_PROTECT_NON-PUBLIC_INFORMATION_(NPI)_EMPLOYEE_AGREEMENT,_FORM_FDA_3398_.pdf PDF
Show all 18

On GovTribe

Work with this file on GovTribe

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

T1.Overview

Solicitation: 17-223-SOL-00038
Attachment D-Pricing Template
Acquisitions and Grants Support Services
Instructions: Only edit the areas highlighted in Yellow
Section 1: Offeror Background Information
Project Title:
Offeror Name:
Subcontractors (if applicable):
Date:
Section 2: Workbook ContentTab ColorDescriptionHyperlink
Tab 1. Pricing Template OverviewBlackProvides offeror background information & the layout of the pricing template.T1.Pricing Template Overview
Tab 2. IDIQ Cost SummaryBlueProvides summary of IDIQ labor costs and level of effort by labor category.T2. IDIQ Cost Summary
Tab 3. Input Tab - IDIQ Labor InputsGrayInput Tab for offeror to populate proposed labor categories, labor hours and labor rates.T3. IDIQ Labor Inputs
Tab 4. Ground Rules & AssumptionsRedInput Tab. Describes offerors background information, cost estimate assumptions, risks/constraints, sources of input, etc.T4. Ground Rules & Assumptions

T2. IDIQ Cost Summary

T2. IDIQ Cost Summary

IDIQ Cost SummaryOrdering Period IOrdering Period IIOrdering Period IIIOrdering Period IVOrdering Period VOrdering Period VITotal
Total Labor$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
IDIQ Labor Cost SummaryOrdering Period IOrdering Period IIOrdering Period IIIOrdering Period IVOrdering Period VOption Period VITotal
Contract Support Specialist I$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Contract Support Specialist II$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Contract Support Specialist III$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Senior Contract Support Specialist$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Grants and Agreement Support Specialist I$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Grant and Agreement Support Specialist II$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Senior Grant and Agreement Support Specialist III$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Program Manager$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Project Manager$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Junior Acquisition Support Specialist I$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Junior Acquisition Support Specialist II$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Direct Labor Costs$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
IDIQ Labor Hours SummaryOrdering Period IOrdering Period IIOrdering Period IIIOrdering Period IVOrdering Period VOption Period VITotal
Contract Support Specialist I3,9103,9103,9103,9103,9101,95521,505
Contract Support Specialist II7,8207,8207,8207,8207,8203,91043,010
Contract Support Specialist III7,8207,8207,8207,8207,8203,91043,010
Senior Contract Support Specialist1,9901,9901,9901,9901,99099510,945
Grants and Agreement Support Specialist I3,9103,9103,9103,9103,9101,95521,505
Grant and Agreement Support Specialist II5,8655,8655,8655,8655,8652,93332,258
Senior Grant and Agreement Support Specialist III1,9901,9901,9901,9901,99099510,945
Program Manager4804804804804802402,640
Project Manager4804804804804802402,640
Junior Acquisition Support Specialist I4,8004,8004,8004,8004,8002,40026,400
Junior Acquisition Support Specialist II4,8004,8004,8004,8004,8002,40026,400
Total Labor Hours43,86543,86543,86543,86543,86521,933241,258
Total FTEs22.8522.8522.8522.8522.8511.42125.66

T3. IDIQ Labor Inputs

Tab 3. IDIQ Labor Inputs
U.S. Food and Drug Administration
Instructions: Only edit the sections highlighted in YellowAnnual Hours1,920
Pricing for evaluation purposes only
Ordering Period I (OPI) (12 Months)
Item No.Government Provided Labor CategoryLabor Category Mapping (Offeror's equivalent labor category name)Proposed Labor HoursFTEProposed Labor RateTotal Proposed Cost
1Contract Support Specialist I3,9102.04$ - 0
2Contract Support Specialist II7,8204.07$ - 0
3Contract Support Specialist III7,8204.07$ - 0
4Senior Contract Support Specialist1,9901.04$ - 0
5Grants and Agreement Support Specialist I3,9102.04$ - 0
6Grant and Agreement Support Specialist II5,8653.05$ - 0
7Senior Grant and Agreement Support Specialist III1,9901.04$ - 0
8Program Manager4800.25$ - 0
9Project Manager4800.25$ - 0
10Junior Acquisition Support Specialist I4,8002.50$ - 0
11Junior Acquisition Support Specialist II4,8002.50$ - 0
Total - OP I Price43,86522.85$0.00
Ordering Period II (OPII) (12 Months)
Item No.Government Provided Labor CategoryLabor Category Mapping (Offeror's equivalent labor category)Proposed Labor HoursFTEProposed Labor RateTotal Proposed Cost
1Contract Support Specialist I3,9102.04$ - 0
2Contract Support Specialist II7,8204.07$ - 0
3Contract Support Specialist III7,8204.07$ - 0
4Senior Contract Support Specialist1,9901.04$ - 0
5Grants and Agreement Support Specialist I3,9102.04$ - 0
6Grant and Agreement Support Specialist II5,8653.05$ - 0
7Senior Grant and Agreement Support Specialist III1,9901.04$ - 0
8Program Manager4800.25$ - 0
9Project Manager4800.25$ - 0
10Junior Acquisition Support Specialist I4,8002.50$ - 0
11Junior Acquisition Support Specialist II4,8002.50$ - 0
Total OP II Price43,86522.85$0.00
Ordering Period III (OPIII) (12 Months)
Item No.Government Provided Labor CategoryLabor Category Mapping (Offeror's equivalent labor category)Proposed Labor HoursFTEProposed Labor RateTotal Proposed Cost
1Contract Support Specialist I3,9102.04$ - 0
2Contract Support Specialist II7,8204.07$ - 0
3Contract Support Specialist III7,8204.07$ - 0
4Senior Contract Support Specialist1,9901.04$ - 0
5Grants and Agreement Support Specialist I3,9102.04$ - 0
6Grant and Agreement Support Specialist II5,8653.05$ - 0
7Senior Grant and Agreement Support Specialist III1,9901.04$ - 0
8Program Manager4800.25$ - 0
9Project Manager4800.25$ - 0
10Junior Acquisition Support Specialist I4,8002.50$ - 0
11Junior Acquisition Support Specialist II4,8002.50$ - 0
Total OP III Price43,86522.85$0.00
Ordering Period IV (OP IV (12 Months)
Item No.Government Provided Labor CategoryLabor Category Mapping (Offeror's equivalent labor category)Proposed Labor HoursFTEProposed Labor RateTotal Proposed Cost
1Contract Support Specialist I3,9102.04$ - 0
2Contract Support Specialist II7,8204.07$ - 0
3Contract Support Specialist III7,8204.07$ - 0
4Senior Contract Support Specialist1,9901.04$ - 0
5Grants and Agreement Support Specialist I3,9102.04$ - 0
6Grant and Agreement Support Specialist II5,8653.05$ - 0
7Senior Grant and Agreement Support Specialist III1,9901.04$ - 0
8Program Manager4800.25$ - 0
9Project Manager4800.25$ - 0
10Junior Acquisition Support Specialist I4,8002.50$ - 0
11Junior Acquisition Support Specialist II4,8002.50$ - 0
Total OP IV Price43,86522.85$0.00
Ordering Period V (OPI V (12 Months)
Item No.Government Provided Labor CategoryLabor Category Mapping (Offeror's equivalent labor category)Proposed Labor HoursFTEProposed Labor RateTotal Proposed Cost
1Contract Support Specialist I3,9102.04$ - 0
2Contract Support Specialist II7,8204.07$ - 0
3Contract Support Specialist III7,8204.07$ - 0
4Senior Contract Support Specialist1,9901.04$ - 0
5Grants and Agreement Support Specialist I3,9102.04$ - 0
6Grant and Agreement Support Specialist II5,8653.05$ - 0
7Senior Grant and Agreement Support Specialist III1,9901.04$ - 0
8Program Manager4800.25$ - 0
9Project Manager4800.25$ - 0
10Junior Acquisition Support Specialist I4,8002.50$ - 0
11Junior Acquisition Support Specialist II4,8002.50$ - 0
Total OP V Price43,86522.85$0.00
Ordering Period VI (OPI V (6 Months) (Option to Extend up to six months)
Item No.Government Provided Labor CategoryLabor Category Mapping (Offeror's equivalent labor category)Proposed Labor HoursFTEProposed Labor RateTotal Proposed Cost
1Contract Support Specialist I1,9551.02$ - 0
2Contract Support Specialist II3,9102.04$ - 0
3Contract Support Specialist III3,9102.04$ - 0
4Senior Contract Support Specialist9950.52$ - 0
5Grants and Agreement Support Specialist I1,9551.02$ - 0
6Grant and Agreement Support Specialist II2,9331.53$ - 0
7Senior Grant and Agreement Support Specialist III9950.52$ - 0
8Program Manager2400.13$ - 0
9Project Manager2400.13$ - 0
10Junior Acquisition Support Specialist I2,4001.25$ - 0
11Junior Acquisition Support Specialist II2,4001.25$ - 0
Total OP VI Price21,93311.42$0.00

Total (Base Year + Option Years) inclusive of six month extension 241,258 125.66 $0.00

T4. Ground Rules & Assumptions

Solicitation: 17-223-SOL-00038
Attachment D-Pricing Template
Acquisitions and Grants Support Services

Instructions: Provide inputs in highlighted yellow area

T4. Ground Rules & Assumptions

General Assumptions:

1.) The contractor assumes that the base year period of performance will be <insert date>
2.) The contractor assumes that period of performance will be as follows:
BY <insert dates>
OP1 <insert dates>
OP2 <insert dates>
OP3 <insert dates>
OP4 <insert dates>
OP for six months
3.) Other assumptions and/or source files

Labor Assumptions:

1.) State general assumptions and basis of estimate for proposed labor rates.

Fee/Factors

1.) Assumes a X% escalation factor applied to labor rates after the base year. (Example) image1.jpeg

File details come from the government source that posted it. Updated .