Revised_Attachment_6_-_Task_Order_1_PricingWorksheet.xls
XLS spreadsheet 103 KB Posted
- Solicitation number
- FDA-Off-Site-RIM-000141
About this file
Revised Attachment 6 - Task Order 1 Pricing Worksheet
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 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 .