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
View the file
Other files for this federal contract opportunity
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 Content | Tab Color | Description | Hyperlink |
| Tab 1. Pricing Template Overview | Black | Provides offeror background information & the layout of the pricing template. | T1.Pricing Template Overview |
| Tab 2. IDIQ Cost Summary | Blue | Provides summary of IDIQ labor costs and level of effort by labor category. | T2. IDIQ Cost Summary |
| Tab 3. Input Tab - IDIQ Labor Inputs | Gray | Input Tab for offeror to populate proposed labor categories, labor hours and labor rates. | T3. IDIQ Labor Inputs |
| Tab 4. Ground Rules & Assumptions | Red | Input 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 Summary | Ordering Period I | Ordering Period II | Ordering Period III | Ordering Period IV | Ordering Period V | Ordering Period VI | Total |
| Total Labor | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| IDIQ Labor Cost Summary | Ordering Period I | Ordering Period II | Ordering Period III | Ordering Period IV | Ordering Period V | Option Period VI | Total |
| 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 Summary | Ordering Period I | Ordering Period II | Ordering Period III | Ordering Period IV | Ordering Period V | Option Period VI | Total |
| Contract Support Specialist I | 3,910 | 3,910 | 3,910 | 3,910 | 3,910 | 1,955 | 21,505 |
| Contract Support Specialist II | 7,820 | 7,820 | 7,820 | 7,820 | 7,820 | 3,910 | 43,010 |
| Contract Support Specialist III | 7,820 | 7,820 | 7,820 | 7,820 | 7,820 | 3,910 | 43,010 |
| Senior Contract Support Specialist | 1,990 | 1,990 | 1,990 | 1,990 | 1,990 | 995 | 10,945 |
| Grants and Agreement Support Specialist I | 3,910 | 3,910 | 3,910 | 3,910 | 3,910 | 1,955 | 21,505 |
| Grant and Agreement Support Specialist II | 5,865 | 5,865 | 5,865 | 5,865 | 5,865 | 2,933 | 32,258 |
| Senior Grant and Agreement Support Specialist III | 1,990 | 1,990 | 1,990 | 1,990 | 1,990 | 995 | 10,945 |
| Program Manager | 480 | 480 | 480 | 480 | 480 | 240 | 2,640 |
| Project Manager | 480 | 480 | 480 | 480 | 480 | 240 | 2,640 |
| Junior Acquisition Support Specialist I | 4,800 | 4,800 | 4,800 | 4,800 | 4,800 | 2,400 | 26,400 |
| Junior Acquisition Support Specialist II | 4,800 | 4,800 | 4,800 | 4,800 | 4,800 | 2,400 | 26,400 |
| Total Labor Hours | 43,865 | 43,865 | 43,865 | 43,865 | 43,865 | 21,933 | 241,258 |
| Total FTEs | 22.85 | 22.85 | 22.85 | 22.85 | 22.85 | 11.42 | 125.66 |
T3. IDIQ Labor Inputs
| Tab 3. IDIQ Labor Inputs | ||
| U.S. Food and Drug Administration | ||
| Instructions: Only edit the sections highlighted in Yellow | Annual Hours | 1,920 |
| Pricing for evaluation purposes only |
| Ordering Period I (OPI) (12 Months) | ||||||
| Item No. | Government Provided Labor Category | Labor Category Mapping (Offeror's equivalent labor category name) | Proposed Labor Hours | FTE | Proposed Labor Rate | Total Proposed Cost |
| 1 | Contract Support Specialist I | 3,910 | 2.04 | $ - 0 | ||
| 2 | Contract Support Specialist II | 7,820 | 4.07 | $ - 0 | ||
| 3 | Contract Support Specialist III | 7,820 | 4.07 | $ - 0 | ||
| 4 | Senior Contract Support Specialist | 1,990 | 1.04 | $ - 0 | ||
| 5 | Grants and Agreement Support Specialist I | 3,910 | 2.04 | $ - 0 | ||
| 6 | Grant and Agreement Support Specialist II | 5,865 | 3.05 | $ - 0 | ||
| 7 | Senior Grant and Agreement Support Specialist III | 1,990 | 1.04 | $ - 0 | ||
| 8 | Program Manager | 480 | 0.25 | $ - 0 | ||
| 9 | Project Manager | 480 | 0.25 | $ - 0 | ||
| 10 | Junior Acquisition Support Specialist I | 4,800 | 2.50 | $ - 0 | ||
| 11 | Junior Acquisition Support Specialist II | 4,800 | 2.50 | $ - 0 | ||
| Total - OP I Price | 43,865 | 22.85 | $0.00 |
| Ordering Period II (OPII) (12 Months) | ||||||
| Item No. | Government Provided Labor Category | Labor Category Mapping (Offeror's equivalent labor category) | Proposed Labor Hours | FTE | Proposed Labor Rate | Total Proposed Cost |
| 1 | Contract Support Specialist I | 3,910 | 2.04 | $ - 0 | ||
| 2 | Contract Support Specialist II | 7,820 | 4.07 | $ - 0 | ||
| 3 | Contract Support Specialist III | 7,820 | 4.07 | $ - 0 | ||
| 4 | Senior Contract Support Specialist | 1,990 | 1.04 | $ - 0 | ||
| 5 | Grants and Agreement Support Specialist I | 3,910 | 2.04 | $ - 0 | ||
| 6 | Grant and Agreement Support Specialist II | 5,865 | 3.05 | $ - 0 | ||
| 7 | Senior Grant and Agreement Support Specialist III | 1,990 | 1.04 | $ - 0 | ||
| 8 | Program Manager | 480 | 0.25 | $ - 0 | ||
| 9 | Project Manager | 480 | 0.25 | $ - 0 | ||
| 10 | Junior Acquisition Support Specialist I | 4,800 | 2.50 | $ - 0 | ||
| 11 | Junior Acquisition Support Specialist II | 4,800 | 2.50 | $ - 0 | ||
| Total OP II Price | 43,865 | 22.85 | $0.00 |
| Ordering Period III (OPIII) (12 Months) | ||||||
| Item No. | Government Provided Labor Category | Labor Category Mapping (Offeror's equivalent labor category) | Proposed Labor Hours | FTE | Proposed Labor Rate | Total Proposed Cost |
| 1 | Contract Support Specialist I | 3,910 | 2.04 | $ - 0 | ||
| 2 | Contract Support Specialist II | 7,820 | 4.07 | $ - 0 | ||
| 3 | Contract Support Specialist III | 7,820 | 4.07 | $ - 0 | ||
| 4 | Senior Contract Support Specialist | 1,990 | 1.04 | $ - 0 | ||
| 5 | Grants and Agreement Support Specialist I | 3,910 | 2.04 | $ - 0 | ||
| 6 | Grant and Agreement Support Specialist II | 5,865 | 3.05 | $ - 0 | ||
| 7 | Senior Grant and Agreement Support Specialist III | 1,990 | 1.04 | $ - 0 | ||
| 8 | Program Manager | 480 | 0.25 | $ - 0 | ||
| 9 | Project Manager | 480 | 0.25 | $ - 0 | ||
| 10 | Junior Acquisition Support Specialist I | 4,800 | 2.50 | $ - 0 | ||
| 11 | Junior Acquisition Support Specialist II | 4,800 | 2.50 | $ - 0 | ||
| Total OP III Price | 43,865 | 22.85 | $0.00 |
| Ordering Period IV (OP IV (12 Months) | ||||||
| Item No. | Government Provided Labor Category | Labor Category Mapping (Offeror's equivalent labor category) | Proposed Labor Hours | FTE | Proposed Labor Rate | Total Proposed Cost |
| 1 | Contract Support Specialist I | 3,910 | 2.04 | $ - 0 | ||
| 2 | Contract Support Specialist II | 7,820 | 4.07 | $ - 0 | ||
| 3 | Contract Support Specialist III | 7,820 | 4.07 | $ - 0 | ||
| 4 | Senior Contract Support Specialist | 1,990 | 1.04 | $ - 0 | ||
| 5 | Grants and Agreement Support Specialist I | 3,910 | 2.04 | $ - 0 | ||
| 6 | Grant and Agreement Support Specialist II | 5,865 | 3.05 | $ - 0 | ||
| 7 | Senior Grant and Agreement Support Specialist III | 1,990 | 1.04 | $ - 0 | ||
| 8 | Program Manager | 480 | 0.25 | $ - 0 | ||
| 9 | Project Manager | 480 | 0.25 | $ - 0 | ||
| 10 | Junior Acquisition Support Specialist I | 4,800 | 2.50 | $ - 0 | ||
| 11 | Junior Acquisition Support Specialist II | 4,800 | 2.50 | $ - 0 | ||
| Total OP IV Price | 43,865 | 22.85 | $0.00 |
| Ordering Period V (OPI V (12 Months) | ||||||
| Item No. | Government Provided Labor Category | Labor Category Mapping (Offeror's equivalent labor category) | Proposed Labor Hours | FTE | Proposed Labor Rate | Total Proposed Cost |
| 1 | Contract Support Specialist I | 3,910 | 2.04 | $ - 0 | ||
| 2 | Contract Support Specialist II | 7,820 | 4.07 | $ - 0 | ||
| 3 | Contract Support Specialist III | 7,820 | 4.07 | $ - 0 | ||
| 4 | Senior Contract Support Specialist | 1,990 | 1.04 | $ - 0 | ||
| 5 | Grants and Agreement Support Specialist I | 3,910 | 2.04 | $ - 0 | ||
| 6 | Grant and Agreement Support Specialist II | 5,865 | 3.05 | $ - 0 | ||
| 7 | Senior Grant and Agreement Support Specialist III | 1,990 | 1.04 | $ - 0 | ||
| 8 | Program Manager | 480 | 0.25 | $ - 0 | ||
| 9 | Project Manager | 480 | 0.25 | $ - 0 | ||
| 10 | Junior Acquisition Support Specialist I | 4,800 | 2.50 | $ - 0 | ||
| 11 | Junior Acquisition Support Specialist II | 4,800 | 2.50 | $ - 0 | ||
| Total OP V Price | 43,865 | 22.85 | $0.00 |
| Ordering Period VI (OPI V (6 Months) (Option to Extend up to six months) | ||||||
| Item No. | Government Provided Labor Category | Labor Category Mapping (Offeror's equivalent labor category) | Proposed Labor Hours | FTE | Proposed Labor Rate | Total Proposed Cost |
| 1 | Contract Support Specialist I | 1,955 | 1.02 | $ - 0 | ||
| 2 | Contract Support Specialist II | 3,910 | 2.04 | $ - 0 | ||
| 3 | Contract Support Specialist III | 3,910 | 2.04 | $ - 0 | ||
| 4 | Senior Contract Support Specialist | 995 | 0.52 | $ - 0 | ||
| 5 | Grants and Agreement Support Specialist I | 1,955 | 1.02 | $ - 0 | ||
| 6 | Grant and Agreement Support Specialist II | 2,933 | 1.53 | $ - 0 | ||
| 7 | Senior Grant and Agreement Support Specialist III | 995 | 0.52 | $ - 0 | ||
| 8 | Program Manager | 240 | 0.13 | $ - 0 | ||
| 9 | Project Manager | 240 | 0.13 | $ - 0 | ||
| 10 | Junior Acquisition Support Specialist I | 2,400 | 1.25 | $ - 0 | ||
| 11 | Junior Acquisition Support Specialist II | 2,400 | 1.25 | $ - 0 | ||
| Total OP VI Price | 21,933 | 11.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 .