Revised_Attachment_5_-_IDIQ_Pricing_Worksheet.xls
XLS spreadsheet 115 KB Posted
- Attached to
- Fully Integrated Records Facility (Offsite Document Control Center) Federal contract opportunity
- Solicitation number
- FDA-Off-Site-RIM-000141
About this file
Revised Attachment 5 - IDIQ Pricing Worksheet
View the file
Other files for this federal contract opportunity
Show all 50
Fully Integrated Records Facility (Offsite Document Control Center) has more files on GovTribe.
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
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 |
| 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 | No | $0.00 | 13440 | 7 | $0.00 | ||||||
| 1 | 1005 | Electronic Document Technician | No | $0.00 | 48000 | 25 | $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 | No | $0.00 | 42240 | 22 | $0.00 | ||||||
| 1 | 1013 | Shredding Specialist | No | $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 | No | $0.00 | 7680 | 4 | $0.00 | ||||||
| 1 | 1017 | Senior Technical Information Specialist/ Senior Task Leader | No | $0.00 | 3840 | 2 | $0.00 | ||||||
| Total | 203136 | 112 | $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 | No | $0.00 | 13440 | 7 | $0.00 | ||||||
| 2 | 2005 | Electronic Document Technician | No | $0.00 | 48000 | 25 | $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 | No | $0.00 | 42240 | 22 | $0.00 | ||||||
| 2 | 2013 | Shredding Specialist | No | $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 | No | $0.00 | 7680 | 4 | $0.00 | ||||||
| 2 | 2017 | Senior Technical Information Specialist/ Senior Task Leader | No | $0.00 | 3840 | 2 | $0.00 | ||||||
| Total | 203136 | 112 | $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 | No | $0.00 | 13440 | 7 | $0.00 | ||||||
| 3 | 3005 | Electronic Document Technician | No | $0.00 | 48000 | 25 | $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 | No | $0.00 | 42240 | 22 | $0.00 | ||||||
| 3 | 3013 | Shredding Specialist | No | $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 | No | $0.00 | 7680 | 4 | $0.00 | ||||||
| 3 | 3017 | Senior Technical Information Specialist/ Senior Task Leader | No | $0.00 | 3840 | 2 | $0.00 | ||||||
| Total | 203136 | 112 | $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 | No | $0.00 | 13440 | 7 | $0.00 | ||||||
| 4 | 4005 | Electronic Document Technician | No | $0.00 | 48000 | 25 | $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 | No | $0.00 | 42240 | 22 | $0.00 | ||||||
| 4 | 4013 | Shredding Specialist | No | $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 | No | $0.00 | 7680 | 4 | $0.00 | ||||||
| 4 | 4017 | Senior Technical Information Specialist/ Senior Task Leader | No | $0.00 | 3840 | 2 | $0.00 | ||||||
| Total | 203136 | 112 | $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 | No | $0.00 | 13440 | 7 | $0.00 | ||||||
| 5 | 5005 | Electronic Document Technician | No | $0.00 | 48000 | 25 | $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 | No | $0.00 | 42240 | 22 | $0.00 | ||||||
| 5 | 5013 | Shredding Specialist | No | $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 | No | $0.00 | 7680 | 4 | $0.00 | ||||||
| 5 | 5017 | Senior Technical Information Specialist/ Senior Task Leader | No | $0.00 | 3840 | 2 | $0.00 | ||||||
| Total | 203136 | 112 | $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 .