Revised_Attachment_6_-_Task_Order_1_PricingWorksheet.xls
XLS spreadsheet 103 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 6 - Task Order 1 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 Task Order 1 Pricing Spreadsheet |
| This worksheet shall be used to for Task Order 1 - Premarket Survey - Performance Work Statement |
| Sample Tab |
| This worksheet provides a sample of pricing to illustrate how an offeror may propose the labor categories and corresponding |
| level of effors (LOEs) necessary to support the SOW |
| All pricing in the sample pricing table is for illustration purposes only |
| Any information entered into this tab will not be evaluated |
| Transition-In Tab |
| This tab shall be used for the 90 days (3 month) transition-in period of Task Order 1 |
| This tab will not factor into the fixed price amount on the summary tab, it will be a separate CLIN |
| Labor Pricing Tab |
| This tab shall be used to for the fixed price portion of Task Order 1 |
| 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 shall be entered into Discounted Hourly Rate or Yearly Total as they will calculate from pre-filled formulas |
| Each of those columns have formulas that will calculate |
| Other Direct Costs |
| Travel - Enter in the total number of trips, number of persons per trip, anticipated number of miles, |
| mileage rate (which shall adhere to Federal Travel Regulations), and total dollar amount of meals |
| Total for travel will calculate based on numbers entered |
| Equipment - Enter in a description of each piece of equipment, the quantity of each piece of equipment proposed and |
| the unit price |
| Assumptions Tab |
| This worksheet shall be used to list all notes and assumptions used in the derivation of proposed prices |
Sample
| Sample - For Illustration Purposes Only | ||||||||
| Contract Year | IDIQ CLIN | Labor Category Description | IDIQ Fully Burdened Hourly Rate | Discount (%) | Discounted Hourly Rate | Annual Hours | Full-Time Equivalents (FTEs) | Yearly Total |
| 1 | 1001 | Analyst Coder I | $20.00 | 10% | $18.00 | 1,880 | 1 | $33,840.00 |
| 1 | 1002 | Analyst Coder II | $25.00 | 10% | $22.50 | 1,880 | 1 | $42,300.00 |
| 1 | 1003 | Driver Courier | $30.00 | 10% | $27.00 | 1,880 | 1 | $50,760.00 |
| 1 | 1004 | Document Imaging Technician | $35.00 | 10% | $31.50 | 1,880 | 1 | $59,220.00 |
| 1 | 1005 | Electronic Document Technician | $40.00 | 10% | $36.00 | 1,880 | 1 | $67,680.00 |
| 1 | 1006 | Senior Electronic Document Technician | $45.00 | 10% | $40.50 | 940 | 0.5 | $38,070.00 |
| Total | 10340 | 5.5 | $291,870.00 | |||||
| A sample pricing, which is shown in the above table, is for illustration purposes. As noted, the pricing data shown is for illustration purposes only. | ||||||||
| Let's assume that Offeror A proposes the above labor categories and the corresponding level of efforst (LOEs) for Task Order 1. | ||||||||
| Offeror A's proposed pricing represents the following: | ||||||||
| § The 6 labor categories, e.g., Analyst Coder I, Analyst Coder II, etc., represent the labor mix with the skill sets necessary to support this Task | ||||||||
| § For all 6 labor categories, Offeror A is offering an additional 10% discount off their IDIQ pricing schedule (Discounts are highly encouraged) | ||||||||
| § Offeror’s A annual labor hours are 1,880 | ||||||||
| § Offeror A is proposing 5.5 FTEs to support this Task |
Transition-In
| RFP #: | FDA-Off-Site-RIM-000141 | |||||||
| Contractor: | ||||||||
| Contract Year | IDIQ CLIN | Labor Category Description | IDIQ Fully Burdened Hourly Rate | Discount (%) | Discounted Hourly Rate | Hours for 3 months | Full-Time Equivalents (FTEs) | 3 month Total |
| 1 | 1001 | Analyst Coder I | $0.00 | $0.00 | ||||
| 1 | 1002 | Analyst Coder II | $0.00 | $0.00 | ||||
| 1 | 1003 | Driver Courier | $0.00 | $0.00 | ||||
| 1 | 1004 | Document Imaging Technician | $0.00 | $0.00 | ||||
| 1 | 1005 | Electronic Document Technician | $0.00 | $0.00 | ||||
| 1 | 1006 | Senior Electronic Document Technician | $0.00 | $0.00 | ||||
| 1 | 1007 | Program (Contract) Manager | $0.00 | $0.00 | ||||
| 1 | 1008 | Program System Analyst | $0.00 | $0.00 | ||||
| 1 | 1009 | Project Manager | $0.00 | $0.00 | ||||
| 1 | 1010 | Quality Assurance Analyst (QAS) | $0.00 | $0.00 | ||||
| 1 | 1011 | Quality Assurance Specialist | $0.00 | $0.00 | ||||
| 1 | 1012 | Records Management Specialist I | $0.00 | $0.00 | ||||
| 1 | 1013 | Shredding Specialist | $0.00 | $0.00 | ||||
| 1 | 1014 | Subject Matter Export | $0.00 | $0.00 | ||||
| 1 | 1015 | Supervisor | $0.00 | $0.00 | ||||
| 1 | 1016 | Technical Information Specialist | $0.00 | $0.00 | ||||
| 1 | 1017 | Senior Technical Information Specialist/ Senior Task Leader | $0.00 | $0.00 | ||||
| Total | 0 | 0 | $0.00 |
Labor Pricing
| RFP #: | FDA-Off-Site-RIM-000141 | |||||||
| Contractor: | ||||||||
| Contract Year | IDIQ CLIN | Labor Category Description | IDIQ Fully Burdened Hourly Rate | Discount (%) | Discounted Hourly Rate | Annual Hours | Full-Time Equivalents (FTEs) | Yearly Total |
| 1 | 1001 | Analyst Coder I | $0.00 | $0.00 | ||||
| 1 | 1002 | Analyst Coder II | $0.00 | $0.00 | ||||
| 1 | 1003 | Driver Courier | $0.00 | $0.00 | ||||
| 1 | 1004 | Document Imaging Technician | $0.00 | $0.00 | ||||
| 1 | 1005 | Electronic Document Technician | $0.00 | $0.00 | ||||
| 1 | 1006 | Senior Electronic Document Technician | $0.00 | $0.00 | ||||
| 1 | 1007 | Program (Contract) Manager | $0.00 | $0.00 | ||||
| 1 | 1008 | Program System Analyst | $0.00 | $0.00 | ||||
| 1 | 1009 | Project Manager | $0.00 | $0.00 | ||||
| 1 | 1010 | Quality Assurance Analyst (QAS) | $0.00 | $0.00 | ||||
| 1 | 1011 | Quality Assurance Specialist | $0.00 | $0.00 | ||||
| 1 | 1012 | Records Management Specialist I | $0.00 | $0.00 | ||||
| 1 | 1013 | Shredding Specialist | $0.00 | $0.00 | ||||
| 1 | 1014 | Subject Matter Export | $0.00 | $0.00 | ||||
| 1 | 1015 | Supervisor | $0.00 | $0.00 | ||||
| 1 | 1016 | Technical Information Specialist | $0.00 | $0.00 | ||||
| 1 | 1017 | Senior Technical Information Specialist/ Senior Task Leader | $0.00 | $0.00 | ||||
| Total | 0 | 0 | $0.00 |
Transition-Out
| RFP #: | FDA-Off-Site-RIM-000141 | |||||||
| Contractor: | ||||||||
| Contract Year | IDIQ CLIN | Labor Category Description | IDIQ Fully Burdened Hourly Rate | Discount (%) | Discounted Hourly Rate | Hours for 3 months | Full-Time Equivalents (FTEs) | 3 month Total |
| 1 | 1001 | Analyst Coder I | $0.00 | $0.00 | ||||
| 1 | 1002 | Analyst Coder II | $0.00 | $0.00 | ||||
| 1 | 1003 | Driver Courier | $0.00 | $0.00 | ||||
| 1 | 1004 | Document Imaging Technician | $0.00 | $0.00 | ||||
| 1 | 1005 | Electronic Document Technician | $0.00 | $0.00 | ||||
| 1 | 1006 | Senior Electronic Document Technician | $0.00 | $0.00 | ||||
| 1 | 1007 | Program (Contract) Manager | $0.00 | $0.00 | ||||
| 1 | 1008 | Program System Analyst | $0.00 | $0.00 | ||||
| 1 | 1009 | Project Manager | $0.00 | $0.00 | ||||
| 1 | 1010 | Quality Assurance Analyst (QAS) | $0.00 | $0.00 | ||||
| 1 | 1011 | Quality Assurance Specialist | $0.00 | $0.00 | ||||
| 1 | 1012 | Records Management Specialist I | $0.00 | $0.00 | ||||
| 1 | 1013 | Shredding Specialist | $0.00 | $0.00 | ||||
| 1 | 1014 | Subject Matter Export | $0.00 | $0.00 | ||||
| 1 | 1015 | Supervisor | $0.00 | $0.00 | ||||
| 1 | 1016 | Technical Information Specialist | $0.00 | $0.00 | ||||
| 1 | 1017 | Senior Technical Information Specialist/ Senior Task Leader | $0.00 | $0.00 | ||||
| Total | 0 | 0 | $0.00 |
Other Direct Costs
| Other Direct Costs | |||||
| Travel | |||||
| # of trips | persons per trip | # of miles | mileage rate | Meals | Total |
| $0.00 | |||||
| Equipment | |||||
| Description | Cost | # of units | Total | ||
| Total | $0.00 | ||||
| Total ODCs | $0.00 |
Summary
| Summary | Total |
| Labor | $0.00 |
| ODCs | $0.00 |
| Total FFP | $0.00 |
Assumptions Assumptions
Limitations on Subcontracting Limitations on Subcontracting
File details come from the government source that posted it. Updated .