Revised_Attachment_5_-_IDIQ_Pricing_Worksheet.xls
XLS spreadsheet 116 KB Posted
- Solicitation number
- FDA-Off-Site-RIM-000141
About this file
Revised Attachment 5
View the file
Other files
Show 40 more
Latest 50 of 54 listed here. See the rest on GovTribe.
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
| Instructions for filling in IDIQ Pricing Spreadsheet |
| The offeror shall submit their price proposals in Microsoft Excel 2010 in compatibility mode and the cells shall be unlocked. The FDA should be able to view formulas and |
| manipulate the information in the pricing volume. |
| Sample Tab |
| Sample pricing table for illustration purposes only, no information should be entered into this tab |
| All pricing in the sample pricing table is for illustration purposes only |
| Any information entered into this tab will not be evaluated |
| Summary Tab |
| Enter in Company name in Cell B2, company name will pre-fill in Years 1 - 5 Tabs, please do not enter again |
| Enter in the proposed material handling fee in Cell B15 |
| Note: Cells B6 - B10 and B13 will calculate, do not enter costs into those cells |
| Year 1 Tab, Year 2 Tab, Year 3 Tab, Year 4 Tab, and Year 5 Tab |
| Direct Rate - enter in base hourly rate |
| Fringe Benefit - enter in fringe benefits as a percentage |
| Overhead - enter in overhead as a percentage |
| G&A - enter in G&A as a percentage |
| Profit - enter in profit as a percentage |
| IDIQ Fully Burdened Labor Rate - rate will calculate based on direct rate, fringe benefits, overhead, G&A and profit, do not enter hourly rate into this column |
| Discount % - enter in any discount that is offered towards the fully burdened labor rate |
| Discounted Hourly Rate - rate will calculate based on fully burdened labor rate and discount percentage |
| Annual Hours - enter in the number of hours that each labor category anticipates working in a 12 month year |
| Full Time Equivalents (FTEs) - enter in the number of FTEs per labor category |
| Yearly Total - total will calculate based on discounted hourly rate, and annual hours |
| Note: No information should be entered into IDIQ Fully Burdened Labor Rate, Discounted Hourly Rate or Yearly Total. |
| Each of those columns have formulas that will calculate |
| Assumptions Tab |
| Any assumptions that were made when determining prices should be entered into this tab |
| Limitations on Subcontracting |
| To ensure compliance with FAR 52.219-14, Limitation on Subcontracting the Offeror shall supply a list of all firms |
| subcontracting or partnering with the Offeror and indicate their areas of responsibilities and, for each, what |
| percentage (est.) of the contract their participation represents. |
Sample
| The sample pricing below, is for illustration purposes only - DO NOT ENTER ANY INFORMATION INTO THIS TAB | |||||||||||||
| Contract Year | CLIN | Labor Category Description | SCA applicable (Yes/No) | Prime or Subcontractor | Direct Rate | Fringe Benefits (%) | Overhead (%) | G&A (%) | Profit (%) | IDIQ Fully Burdened Hourly Rate | Annual Hours | Full-Time Equivalents (FTEs) | Yearly Total |
| 1 | 1001 | Analyst Coder I | No | Prime | $5.00 | 10% | 10% | 10% | 5% | $7.00 | 1920 | 1 | $13,440.00 |
| 1 | 1002 | Analyst Coder II | No | Prime | $10.00 | 10% | 10% | 10% | 5% | $14.00 | 1920 | 1 | $26,880.00 |
| 1 | 1003 | Driver Courier | Yes | Prime | $25.00 | 10% | 10% | 10% | 5% | $35.00 | 1920 | 1 | $67,200.00 |
| 1 | 1004 | Document Imaging Technician | No | Prime | $30.00 | 10% | 10% | 10% | 5% | $42.00 | 1920 | 1 | $80,640.00 |
| 1 | 1005 | Electronic Document Technician | No | Prime | $35.00 | 10% | 10% | 10% | 5% | $49.00 | 1920 | 1 | $94,080.00 |
| 1 | 1006 | Senior Electronic Document Technician | No | Prime | $40.00 | 10% | 10% | 10% | 5% | $56.00 | 1920 | 1 | $107,520.00 |
| 1 | 1007 | Program (Contract) Manager | No | Prime | $60.00 | 10% | 10% | 10% | 5% | $84.00 | 1920 | 1 | $161,280.00 |
| 1 | 1008 | Program System Analyst | No | Prime | $65.00 | 10% | 10% | 10% | 5% | $91.00 | 1920 | 1 | $174,720.00 |
| 1 | 1009 | Project Manager | No | Prime | $70.00 | 10% | 10% | 10% | 5% | $98.00 | 1920 | 1 | $188,160.00 |
| 1 | 1010 | Quality Assurance Analyst (QAA) | No | Prime | $76.00 | 10% | 10% | 10% | 5% | $106.00 | 1920 | 1 | $203,520.00 |
| 1 | 1011 | Quality Assurance Specialist (QAS) | No | Prime | $80.00 | 10% | 10% | 10% | 5% | $112.00 | 1920 | 1 | $215,040.00 |
| 1 | 1012 | Records Management Specialist I | No | Subcontractor | $85.00 | 10% | 10% | 10% | 5% | $119.00 | 1920 | 1 | $228,480.00 |
| 1 | 1013 | Shredding Specialist | No | Subcontractor | $95.00 | 10% | 10% | 10% | 5% | $133.00 | 1920 | 1 | $255,360.00 |
| 1 | 1014 | Subject Matter Expert | No | Subcontractor | $100.00 | 10% | 10% | 10% | 5% | $140.00 | 1920 | 1 | $268,800.00 |
| 1 | 1015 | Supervisor | No | Subcontractor | $105.00 | 10% | 10% | 10% | 5% | $147.00 | 1920 | 1 | $282,240.00 |
| 1 | 1016 | Technical Information Specialist | No | Subcontractor | $110.00 | 10% | 10% | 10% | 5% | $154.00 | 1920 | 1 | $295,680.00 |
| 1 | 1017 | Senior Technical Information Specialist/ Senior Task Leader | No | Prime | $115.00 | 10% | 10% | 10% | 5% | $161.00 | 1920 | 1 | $309,120.00 |
| Total | 32640 | 17 | $2,972,160.00 |
Year 1
| RFP #: | FDA-Off-Siite-RIM-000141 | ||||||||||||
| Contractor: | 0 | ||||||||||||
| Contract Year | CLIN | Labor Category Description | SCA applicable (Yes/No) | Prime or Subcontractor | Direct Rate | Fringe Benefits (%) | Overhead (%) | G&A (%) | Profit (%) | IDIQ Fully Burdened Hourly Rate | Annual Hours | Full-Time Equivalents (FTEs) | Yearly Total |
| 1 | 1001 | Analyst Coder I | No | $0.00 | 36480 | 19 | $0.00 | ||||||
| 1 | 1002 | Analyst Coder II | No | $0.00 | 2280 | 2 | $0.00 | ||||||
| 1 | 1003 | Driver Courier | Yes - 31043 | $0.00 | 1920 | 1 | $0.00 | ||||||
| 1 | 1004 | Document Imaging Technician | Yes - 01112 | $0.00 | 13440 | 7 | $0.00 | ||||||
| 1 | 1005 | Electronic Document Technician | Yes - 14042 | $0.00 | 48000 | 1 | $0.00 | ||||||
| 1 | 1006 | Senior Electronic Document Technician | No | $0.00 | 1920 | 1 | $0.00 | ||||||
| 1 | 1007 | Program (Contract) Manager | No | $0.00 | 1272 | 4 | $0.00 | ||||||
| 1 | 1008 | Program System Analyst | No | $0.00 | 1440 | 1 | $0.00 | ||||||
| 1 | 1009 | Project Manager | No | $0.00 | 384 | 2 | $0.00 | ||||||
| 1 | 1010 | Quality Assurance Analyst (QAA) | No | $0.00 | 7680 | 4 | $0.00 | ||||||
| 1 | 1011 | Quality Assurance Specialist (QAS) | No | $0.00 | 7680 | 4 | $0.00 | ||||||
| 1 | 1012 | Records Management Specialist I | Yes - 01112 | $0.00 | 42240 | 22 | $0.00 | ||||||
| 1 | 1013 | Shredding Specialist | Yes - 01111 | $0.00 | 7680 | 4 | $0.00 | ||||||
| 1 | 1014 | Subject Matter Export | No | $0.00 | 9600 | 5 | $0.00 | ||||||
| 1 | 1015 | Supervisor | No | $0.00 | 9600 | 5 | $0.00 | ||||||
| 1 | 1016 | Technical Information Specialist | Yes - 01113 | $0.00 | 7680 | 4 | $0.00 | ||||||
| 1 | 1017 | Senior Technical Information Specialist/ Senior Task Leader | No | $0.00 | 3840 | 2 | $0.00 | ||||||
| Total | 203136 | 88 | $0.00 |
Year 2
| RFP #: | FDA-Off-Siite-RIM-000141 | ||||||||||||
| Contractor: | 0 | ||||||||||||
| Contract Year | CLIN | Labor Category Description | SCA applicable (Yes/No) | Prime or Subcontractor | Direct Rate | Fringe Benefits (%) | Overhead (%) | G&A (%) | Profit (%) | IDIQ Fully Burdened Hourly Rate | Annual Hours | Full-Time Equivalents (FTEs) | Yearly Total |
| 2 | 2001 | Analyst Coder I | No | $0.00 | 36480 | 19 | $0.00 | ||||||
| 2 | 2002 | Analyst Coder II | No | $0.00 | 2280 | 2 | $0.00 | ||||||
| 2 | 2003 | Driver Courier | Yes - 31043 | $0.00 | 1920 | 1 | $0.00 | ||||||
| 2 | 2004 | Document Imaging Technician | Yes - 01112 | $0.00 | 13440 | 7 | $0.00 | ||||||
| 2 | 2005 | Electronic Document Technician | Yes - 14042 | $0.00 | 48000 | 1 | $0.00 | ||||||
| 2 | 2006 | Senior Electronic Document Technician | No | $0.00 | 1920 | 1 | $0.00 | ||||||
| 2 | 2007 | Program (Contract) Manager | No | $0.00 | 1272 | 4 | $0.00 | ||||||
| 2 | 2008 | Program System Analyst | No | $0.00 | 1440 | 1 | $0.00 | ||||||
| 2 | 2009 | Project Manager | No | $0.00 | 384 | 2 | $0.00 | ||||||
| 2 | 2010 | Quality Assurance Analyst (QAA) | No | $0.00 | 7680 | 4 | $0.00 | ||||||
| 2 | 2011 | Quality Assurance Specialist (QAS) | No | $0.00 | 7680 | 4 | $0.00 | ||||||
| 2 | 2012 | Records Management Specialist I | Yes - 01112 | $0.00 | 42240 | 22 | $0.00 | ||||||
| 2 | 2013 | Shredding Specialist | Yes - 01111 | $0.00 | 7680 | 4 | $0.00 | ||||||
| 2 | 2014 | Subject Matter Export | No | $0.00 | 9600 | 5 | $0.00 | ||||||
| 2 | 2015 | Supervisor | No | $0.00 | 9600 | 5 | $0.00 | ||||||
| 2 | 2016 | Technical Information Specialist | Yes - 01113 | $0.00 | 7680 | 4 | $0.00 | ||||||
| 2 | 2017 | Senior Technical Information Specialist/ Senior Task Leader | No | $0.00 | 3840 | 2 | $0.00 | ||||||
| Total | 203136 | 88 | $0.00 |
Year 3
| RFP #: | FDA-Off-Siite-RIM-000141 | ||||||||||||
| Contractor: | 0 | ||||||||||||
| Contract Year | CLIN | Labor Category Description | SCA applicable (Yes/No) | Prime or Subcontractor | Direct Rate | Fringe Benefits (%) | Overhead (%) | G&A (%) | Profit (%) | IDIQ Fully Burdened Hourly Rate | Annual Hours | Full-Time Equivalents (FTEs) | Yearly Total |
| 3 | 3001 | Analyst Coder I | No | $0.00 | 36480 | 19 | $0.00 | ||||||
| 3 | 3002 | Analyst Coder II | No | $0.00 | 2280 | 2 | $0.00 | ||||||
| 3 | 3003 | Driver Courier | Yes - 31043 | $0.00 | 1920 | 1 | $0.00 | ||||||
| 3 | 3004 | Document Imaging Technician | Yes - 01112 | $0.00 | 13440 | 7 | $0.00 | ||||||
| 3 | 3005 | Electronic Document Technician | Yes - 14042 | $0.00 | 48000 | 1 | $0.00 | ||||||
| 3 | 3006 | Senior Electronic Document Technician | No | $0.00 | 1920 | 1 | $0.00 | ||||||
| 3 | 3007 | Program (Contract) Manager | No | $0.00 | 1272 | 4 | $0.00 | ||||||
| 3 | 3008 | Program System Analyst | No | $0.00 | 1440 | 1 | $0.00 | ||||||
| 3 | 3009 | Project Manager | No | $0.00 | 384 | 2 | $0.00 | ||||||
| 3 | 3010 | Quality Assurance Analyst (QAA) | No | $0.00 | 7680 | 4 | $0.00 | ||||||
| 3 | 3011 | Quality Assurance Specialist (QAS) | No | $0.00 | 7680 | 4 | $0.00 | ||||||
| 3 | 3012 | Records Management Specialist I | Yes - 01112 | $0.00 | 42240 | 22 | $0.00 | ||||||
| 3 | 3013 | Shredding Specialist | Yes - 01111 | $0.00 | 7680 | 4 | $0.00 | ||||||
| 3 | 3014 | Subject Matter Export | No | $0.00 | 9600 | 5 | $0.00 | ||||||
| 3 | 3015 | Supervisor | No | $0.00 | 9600 | 5 | $0.00 | ||||||
| 3 | 3016 | Technical Information Specialist | Yes - 01113 | $0.00 | 7680 | 4 | $0.00 | ||||||
| 3 | 3017 | Senior Technical Information Specialist/ Senior Task Leader | No | $0.00 | 3840 | 2 | $0.00 | ||||||
| Total | 203136 | 88 | $0.00 |
Year 4
| RFP #: | FDA-Off-Siite-RIM-000141 | ||||||||||||
| Contractor: | 0 | ||||||||||||
| Contract Year | CLIN | Labor Category Description | SCA applicable (Yes/No) | Prime or Subcontractor | Direct Rate | Fringe Benefits (%) | Overhead (%) | G&A (%) | Profit (%) | IDIQ Fully Burdened Hourly Rate | Annual Hours | Full-Time Equivalents (FTEs) | Yearly Total |
| 4 | 4001 | Analyst Coder I | No | $0.00 | 36480 | 19 | $0.00 | ||||||
| 4 | 4002 | Analyst Coder II | No | $0.00 | 2280 | 2 | $0.00 | ||||||
| 4 | 4003 | Driver Courier | Yes - 31043 | $0.00 | 1920 | 1 | $0.00 | ||||||
| 4 | 4004 | Document Imaging Technician | Yes - 01112 | $0.00 | 13440 | 7 | $0.00 | ||||||
| 4 | 4005 | Electronic Document Technician | Yes - 14042 | $0.00 | 48000 | 1 | $0.00 | ||||||
| 4 | 4006 | Senior Electronic Document Technician | No | $0.00 | 1920 | 1 | $0.00 | ||||||
| 4 | 4007 | Program (Contract) Manager | No | $0.00 | 1272 | 4 | $0.00 | ||||||
| 4 | 4008 | Program System Analyst | No | $0.00 | 1440 | 1 | $0.00 | ||||||
| 4 | 4009 | Project Manager | No | $0.00 | 384 | 2 | $0.00 | ||||||
| 4 | 4010 | Quality Assurance Analyst (QAA) | No | $0.00 | 7680 | 4 | $0.00 | ||||||
| 4 | 4011 | Quality Assurance Specialist (QAS) | No | $0.00 | 7680 | 4 | $0.00 | ||||||
| 4 | 4012 | Records Management Specialist I | Yes - 01112 | $0.00 | 42240 | 22 | $0.00 | ||||||
| 4 | 4013 | Shredding Specialist | Yes - 01111 | $0.00 | 7680 | 4 | $0.00 | ||||||
| 4 | 4014 | Subject Matter Export | No | $0.00 | 9600 | 5 | $0.00 | ||||||
| 4 | 4015 | Supervisor | No | $0.00 | 9600 | 5 | $0.00 | ||||||
| 4 | 4016 | Technical Information Specialist | Yes - 01113 | $0.00 | 7680 | 4 | $0.00 | ||||||
| 4 | 4017 | Senior Technical Information Specialist/ Senior Task Leader | No | $0.00 | 3840 | 2 | $0.00 | ||||||
| Total | 203136 | 88 | $0.00 |
Year 5
| RFP #: | FDA-Off-Siite-RIM-000141 | ||||||||||||
| Contractor: | 0 | ||||||||||||
| Contract Year | CLIN | Labor Category Description | SCA applicable (Yes/No) | Prime or Subcontractor | Direct Rate | Fringe Benefits (%) | Overhead (%) | G&A (%) | Profit (%) | IDIQ Fully Burdened Hourly Rate | Annual Hours | Full-Time Equivalents (FTEs) | Yearly Total |
| 5 | 5001 | Analyst Coder I | No | $0.00 | 36480 | 19 | $0.00 | ||||||
| 5 | 5002 | Analyst Coder II | No | $0.00 | 2280 | 2 | $0.00 | ||||||
| 5 | 5003 | Driver Courier | Yes - 31043 | $0.00 | 1920 | 1 | $0.00 | ||||||
| 5 | 5004 | Document Imaging Technician | Yes - 01112 | $0.00 | 13440 | 7 | $0.00 | ||||||
| 5 | 5005 | Electronic Document Technician | Yes - 14042 | $0.00 | 48000 | 1 | $0.00 | ||||||
| 5 | 5006 | Senior Electronic Document Technician | No | $0.00 | 1920 | 1 | $0.00 | ||||||
| 5 | 5007 | Program (Contract) Manager | No | $0.00 | 1272 | 4 | $0.00 | ||||||
| 5 | 5008 | Program System Analyst | No | $0.00 | 1440 | 1 | $0.00 | ||||||
| 5 | 5009 | Project Manager | No | $0.00 | 384 | 2 | $0.00 | ||||||
| 5 | 5010 | Quality Assurance Analyst (QAA) | No | $0.00 | 7680 | 4 | $0.00 | ||||||
| 5 | 5011 | Quality Assurance Specialist (QAS) | No | $0.00 | 7680 | 4 | $0.00 | ||||||
| 5 | 5012 | Records Management Specialist I | Yes - 01112 | $0.00 | 42240 | 22 | $0.00 | ||||||
| 5 | 5013 | Shredding Specialist | Yes - 01111 | $0.00 | 7680 | 4 | $0.00 | ||||||
| 5 | 5014 | Subject Matter Export | No | $0.00 | 9600 | 5 | $0.00 | ||||||
| 5 | 5015 | Supervisor | No | $0.00 | 9600 | 5 | $0.00 | ||||||
| 5 | 5016 | Technical Information Specialist | Yes - 01113 | $0.00 | 7680 | 4 | $0.00 | ||||||
| 5 | 5017 | Senior Technical Information Specialist/ Senior Task Leader | No | $0.00 | 3840 | 2 | $0.00 | ||||||
| Total | 203136 | 88 | $0.00 |
Summary
| RFP #: | FDA-Off-Siite-RIM-000141 |
| Contractor: | |
| Summary by Contract Year | Total Cost |
| Contract Year 1 | $0.00 |
| Contract Year 2 | $0.00 |
| Contract Year 3 | $0.00 |
| Contract Year 4 | $0.00 |
| Contract Year 5 | $0.00 |
| ODCS | TBD |
| TOTAL | $0.00 |
| Material Handling Fee (%) |
Assumptions
Assumptions
Limitations on Subcontracting
Subcontractor Area of Responsibilty % participation represents
File details come from the government source that posted it. Updated .