Attachment 5 FDA CSTAR Pricing Worksheet.xls
XLS spreadsheet 81 KB Posted
- Solicitation number
- FDA-SOL-11-1085941
About this file
Pricing Worksheet
View the file
Other files
Show 40 more
Latest 50 of 56 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
Summary
| Food and Drug Administration (FDA) | ||||||||
| Project Title: Center Submission Tracking and Reporting (CSTAR) | ||||||||
| Summary of Pricing | ||||||||
| Description | Contract Year 1 | Contract Year 2 | Contract Year 3 | Contract Year 4 | Contract Year 5 | 5 Year Total | % of Total | |
| Task Order 1 Total Price (Including Option) | ||||||||
| Task Order 2 Total Ceiling | ||||||||
| Task Order 3 Total Ceiling | ||||||||
| IDIQ Labor (Govt Site) | ||||||||
| IDIQ Labor (Contractor Site) | ||||||||
| Total |
IDIQ Government Site Rate
| Food and Drug Administration (FDA) | |||||||||||
| Project Title: Center Submission Tracking and Reporting (CSTAR) | |||||||||||
| IDIQ Pricing Schedule - Government Site Rates | |||||||||||
| IDIQ Contract Year 1 | |||||||||||
| CLIN # | Labor Category | Direct Rate | Fringe | Overhead | G&A | Profit/Fee | FCOM/ COM | Full Burdened Hourly Labor Rate | Estimated Annual Hours | Labor Category Annual Total | |
| A001 | Senior Systems Architect | 6000 | |||||||||
| A002 | Senior Application Engineer | 4000 | |||||||||
| A003 | Applications Engineer | 4000 | |||||||||
| A004 | Help Desk Specialist | 2000 | |||||||||
| A005 | Application Systems Analyst | 6000 | |||||||||
| A006 | Senior Computer Systems Analyst | 4000 | |||||||||
| A007 | Software Systems Engineer | 4000 | |||||||||
| A008 | Quality Assurance Analyst | 2500 | |||||||||
| A009 | Project Manager | 4000 | |||||||||
| A010 | Principal System Architect | 2500 | |||||||||
| A011 | Application Programmer | 10000 | |||||||||
| A012 | Senior Information Engineer | 2500 | |||||||||
| A013 | Principal Business Process Engineer Specialist | 2000 | |||||||||
| A014 | Database Management Specialist | 4000 | |||||||||
| A015 | Training Specialist | 1000 | |||||||||
| 58500 | |||||||||||
| IDIQ Contract Year 2 | |||||||||||
| CLIN # | Labor Category | Direct Rate | Fringe | Overhead | G&A | Profit/Fee | FCOM/ COM | Full Burdened Hourly Labor Rate | Estimated Annual Hours | Labor Category Annual Total | |
| A001 | Senior Systems Architect | 6000 | |||||||||
| A002 | Senior Application Engineer | 4000 | |||||||||
| A003 | Applications Engineer | 4000 | |||||||||
| A004 | Help Desk Specialist | 2000 | |||||||||
| A005 | Applications Systems Analyst | 6000 | |||||||||
| A006 | Senior Computer Systems Analyst | 4000 | |||||||||
| A007 | Software Systems Engineer | 4000 | |||||||||
| A008 | Quality Assurance Analyst | 2500 | |||||||||
| A009 | Project Manager | 4000 | |||||||||
| A010 | Principal System Architect | 2500 | |||||||||
| A011 | Application Programmer | 10000 | |||||||||
| A012 | Senior Information Engineer | 2500 | |||||||||
| A013 | Principal Business Process Engineer Specialist | 2000 | |||||||||
| A014 | Database Management Specialist | 4000 | |||||||||
| A015 | Training Specialist | 1000 | |||||||||
| 58500 | |||||||||||
| IDIQ Contract Year 3 | |||||||||||
| CLIN # | Labor Category | Direct Rate | Fringe | Overhead | G&A | Profit/Fee | FCOM/ COM | Full Burdened Hourly Labor Rate | Estimated Annual Hours | Labor Category Annual Total | |
| A001 | Senior Systems Architect | 6000 | |||||||||
| A002 | Senior Application Engineer | 4000 | |||||||||
| A003 | Applications Engineer | 4000 | |||||||||
| A004 | Help Desk Specialist | 2000 | |||||||||
| A005 | Applications Systems Analyst | 6000 | |||||||||
| A006 | Senior Computer Systems Analyst | 4000 | |||||||||
| A007 | Software Systems Engineer | 4000 | |||||||||
| A008 | Quality Assurance Analyst | 2500 | |||||||||
| A009 | Project Manager | 4000 | |||||||||
| A010 | Principal System Architect | 2000 | |||||||||
| A011 | Application Programmer | 10000 | |||||||||
| A012 | Senior Information Engineer | 2500 | |||||||||
| A013 | Principal Business Process Engineer Specialist | 2000 | |||||||||
| A014 | Database Management Specialist | 4000 | |||||||||
| A015 | Training Specialist | 500 | |||||||||
| 57500 | |||||||||||
| IDIQ Contract Year 4 | |||||||||||
| CLIN # | Labor Category | Direct Rate | Fringe | Overhead | G&A | Profit/Fee | FCOM/ COM | Full Burdened Hourly Labor Rate | Estimated Annual Hours | Labor Category Annual Total | |
| A001 | Senior Systems Architect | 6000 | |||||||||
| A002 | Senior Application Engineer | 4000 | |||||||||
| A003 | Applications Engineer | 4000 | |||||||||
| A004 | Help Desk Specialist | 2000 | |||||||||
| A005 | Applications Systems Analyst | 6000 | |||||||||
| A006 | Senior Computer Systems Analyst | 4000 | |||||||||
| A007 | Software Systems Engineer | 4000 | |||||||||
| A008 | Quality Assurance Analyst | 2500 | |||||||||
| A009 | Project Manager | 4000 | |||||||||
| A010 | Principal System Architect | 2000 | |||||||||
| A011 | Application Programmer | 10000 | |||||||||
| A012 | Senior Information Engineer | 2500 | |||||||||
| A013 | Principal Business Process Engineer Specialist | 2000 | |||||||||
| A014 | Database Management Specialist | 4000 | |||||||||
| A015 | Training Specialist | 500 | |||||||||
| 57500 | |||||||||||
| IDIQ Contract Year 5 | |||||||||||
| CLIN # | Labor Category | Direct Rate | Fringe | Overhead | G&A | Profit/Fee | FCOM/ COM | Full Burdened Hourly Labor Rate | Estimated Annual Hours | Labor Category Annual Total | |
| A001 | Senior Systems Architect | 6000 | |||||||||
| A002 | Senior Application Engineer | 4000 | |||||||||
| A003 | Applications Engineer | 4000 | |||||||||
| A004 | Help Desk Specialist | 2000 | |||||||||
| A005 | Applications Systems Analyst | 6000 | |||||||||
| A006 | Senior Computer Systems Analyst | 4000 | |||||||||
| A007 | Software Systems Engineer | 4000 | |||||||||
| A008 | Quality Assurance Analyst | 2500 | |||||||||
| A009 | Project Manager | 4000 | |||||||||
| A010 | Principal System Architect | 2000 | |||||||||
| A011 | Application Programmer | 10000 | |||||||||
| A012 | Senior Information Engineer | 2500 | |||||||||
| A013 | Principal Business Process Engineer Specialist | 2000 | |||||||||
| A014 | Database Management Specialist | 4000 | |||||||||
| A015 | Training Specialist | 500 | |||||||||
| 57500 |
IDIQ Contractor Site Rate
| Food and Drug Administration (FDA) | |||||||||||
| Project Title: Center Submission Tracking and Reporting (CSTAR) | |||||||||||
| IDIQ Pricing Schedule- Contractor Site Rates | |||||||||||
| IDIQ Contract Year 1 | |||||||||||
| CLIN # | Labor Category | Direct Rate | Fringe | Overhead | G&A | Profit/Fee | FCOM/ COM | Full Burdened Hourly Labor Rate | Estimated Annual Hours | Labor Category Annual Total | |
| B001 | Senior Systems Architect | 6000 | |||||||||
| B002 | Senior Application Engineer | 4000 | |||||||||
| B003 | Applications Engineer | 4000 | |||||||||
| B004 | Help Desk Specialist | 2000 | |||||||||
| B005 | Application Systems Analyst | 6000 | |||||||||
| B006 | Senior Computer Systems Analyst | 4000 | |||||||||
| B007 | Software Systems Engineer | 4000 | |||||||||
| B008 | Quality Assurance Analyst | 2500 | |||||||||
| B009 | Project Manager | 4000 | |||||||||
| B010 | Principal System Architect | 2500 | |||||||||
| B011 | Application Programmer | 10000 | |||||||||
| B012 | Senior Information Engineer | 2500 | |||||||||
| B013 | Principal Business Process Engineer Specialist | 2000 | |||||||||
| B014 | Database Management Specialist | 4000 | |||||||||
| B015 | Training Specialist | 1000 | |||||||||
| 58500 | |||||||||||
| IDIQ Contract Year 2 | |||||||||||
| CLIN # | Labor Category | Direct Rate | Fringe | Overhead | G&A | Profit/Fee | FCOM/ COM | Full Burdened Hourly Labor Rate | Estimated Annual Hours | Labor Category Annual Total | |
| B001 | Senior Systems Architect | 6000 | |||||||||
| B002 | Senior Application Engineer | 4000 | |||||||||
| B003 | Applications Engineer | 4000 | |||||||||
| B004 | Help Desk Specialist | 2000 | |||||||||
| B005 | Applications Systems Analyst | 6000 | |||||||||
| B006 | Senior Computer Systems Analyst | 4000 | |||||||||
| B007 | Software Systems Engineer | 4000 | |||||||||
| B008 | Quality Assurance Analyst | 2500 | |||||||||
| B009 | Project Manager | 4000 | |||||||||
| B010 | Principal System Architect | 2500 | |||||||||
| B011 | Application Programmer | 10000 | |||||||||
| B012 | Senior Information Engineer | 2500 | |||||||||
| B013 | Principal Business Process Engineer Specialist | 2000 | |||||||||
| B014 | Database Management Specialist | 4000 | |||||||||
| B015 | Training Specialist | 1000 | |||||||||
| 58500 | |||||||||||
| IDIQ Contract Year 3 | |||||||||||
| CLIN # | Labor Category | Direct Rate | Fringe | Overhead | G&A | Profit/Fee | FCOM/ COM | Full Burdened Hourly Labor Rate | Estimated Annual Hours | Labor Category Annual Total | |
| B001 | Senior Systems Architect | 6000 | |||||||||
| B002 | Senior Application Engineer | 4000 | |||||||||
| B003 | Applications Engineer | 4000 | |||||||||
| B004 | Help Desk Specialist | 2000 | |||||||||
| B005 | Applications Systems Analyst | 6000 | |||||||||
| B006 | Senior Computer Systems Analyst | 4000 | |||||||||
| B007 | Software Systems Engineer | 4000 | |||||||||
| B008 | Quality Assurance Analyst | 2500 | |||||||||
| B009 | Project Manager | 4000 | |||||||||
| B010 | Principal System Architect | 2000 | |||||||||
| B011 | Application Programmer | 10000 | |||||||||
| B012 | Senior Information Engineer | 2500 | |||||||||
| B013 | Principal Business Process Engineer Specialist | 2000 | |||||||||
| B014 | Database Management Specialist | 4000 | |||||||||
| B015 | Training Specialist | 500 | |||||||||
| 57500 | |||||||||||
| IDIQ Contract Year 4 | |||||||||||
| CLIN # | Labor Category | Direct Rate | Fringe | Overhead | G&A | Profit/Fee | FCOM/ COM | Full Burdened Hourly Labor Rate | Estimated Annual Hours | Labor Category Annual Total | |
| B001 | Senior Systems Architect | 6000 | |||||||||
| B002 | Senior Application Engineer | 4000 | |||||||||
| B003 | Applications Engineer | 4000 | |||||||||
| B004 | Help Desk Specialist | 2000 | |||||||||
| B005 | Applications Systems Analyst | 6000 | |||||||||
| B006 | Senior Computer Systems Analyst | 4000 | |||||||||
| B007 | Software Systems Engineer | 4000 | |||||||||
| B008 | Quality Assurance Analyst | 2500 | |||||||||
| B009 | Project Manager | 4000 | |||||||||
| B010 | Principal System Architect | 2000 | |||||||||
| B011 | Application Programmer | 10000 | |||||||||
| B012 | Senior Information Engineer | 2500 | |||||||||
| B013 | Principal Business Process Engineer Specialist | 2000 | |||||||||
| B014 | Database Management Specialist | 4000 | |||||||||
| B015 | Training Specialist | 500 | |||||||||
| 57500 | |||||||||||
| IDIQ Contract Year 5 | |||||||||||
| CLIN # | Labor Category | Direct Rate | Fringe | Overhead | G&A | Profit/Fee | FCOM/ COM | Full Burdened Hourly Labor Rate | Estimated Annual Hours | Labor Category Annual Total | |
| B001 | Senior Systems Architect | 6000 | |||||||||
| B002 | Senior Application Engineer | 4000 | |||||||||
| B003 | Applications Engineer | 4000 | |||||||||
| B004 | Help Desk Specialist | 2000 | |||||||||
| B005 | Applications Systems Analyst | 6000 | |||||||||
| B006 | Senior Computer Systems Analyst | 4000 | |||||||||
| B007 | Software Systems Engineer | 4000 | |||||||||
| B008 | Quality Assurance Analyst | 2500 | |||||||||
| B009 | Project Manager | 4000 | |||||||||
| B010 | Principal System Architect | 2000 | |||||||||
| B011 | Application Programmer | 10000 | |||||||||
| B012 | Senior Information Engineer | 2500 | |||||||||
| B013 | Principal Business Process Engineer Specialist | 2000 | |||||||||
| B014 | Database Management Specialist | 4000 | |||||||||
| B015 | Training Specialist | 500 | |||||||||
| 57500 |
Task Order 1
| Food and Drug Administration (FDA) | |||||||
| Project Title: Task Order 1 - CSTAR Operations and Maintenance (O&M), Steady State, Project Management Support, and Transition Work Activities | |||||||
| Order Type: Firm Fixed Price | |||||||
| Government Site | |||||||
| Task 1 - Project Management Support (Base Period) | |||||||
| CLIN | Labor Category | Fully Burdened Hourly Labor Rate (Govt Site) | Full Burdened Hourly Labor Rate (Contractor Site) | Total Hours | Full Time Equivalents (FTE) | Labor Category Total | |
| Task 1 - Project Management Support (Option Period 1) | |||||||
| CLIN | Labor Category | Fully Burdened Hourly Labor Rates (Govt Site) | Full Burdened Hourly Labor Rate (Contractor Site) | Total Hours | Full Time Equivalents (FTE) | Labor Category Total | |
| Task 1 - Project Management Support (Option Period 2) | |||||||
| CLIN | Labor Category | Fully Burdened Hourly Labor Rates (Govt Site) | Full Burdened Hourly Labor Rate (Contractor Site) | Total Hours | Full Time Equivalents (FTE) | Labor Category Total | |
| Task 1 - Project Management Support (Option Period 3) | |||||||
| CLIN | Labor Category | Fully Burdened Hourly Labor Rates (Govt Site) | Full Burdened Hourly Labor Rate (Contractor Site) | Total Hours | Full Time Equivalents (FTE) | Labor Category Total | |
| Task 1 - Project Management Support (Option Period 4) | |||||||
| CLIN | Labor Category | Fully Burdened Hourly Labor Rates (Govt Site) | Full Burdened Hourly Labor Rate (Contractor Site) | Total Hours | Full Time Equivalents (FTE) | Labor Category Total | |
| Task 2 - Operations and Maintenance/Steady State (SS) Work Activities (Base Period) | |||||||
| CLIN | Labor Category | Fully Burdened Hourly Labor Rates (Govt Site) | Full Burdened Hourly Labor Rate (Contractor Site) | Total Hours | Full Time Equivalents (FTE) | Labor Category Total | |
| Task 2 - Operations and Maintenance/Steady State (SS) Work Activities (Option Period 1) | |||||||
| CLIN | Labor Category | Fully Burdened Hourly Labor Rates (Govt Site) | Full Burdened Hourly Labor Rate (Contractor Site) | Total Hours | Full Time Equivalents (FTE) | Labor Category Total | |
| Task 2 - Operations and Maintenance/Steady State (SS) Work Activities (Option Period 2) | |||||||
| CLIN | Labor Category | Fully Burdened Hourly Labor Rates (Govt Site) | Full Burdened Hourly Labor Rate (Contractor Site) | Total Hours | Full Time Equivalents (FTE) | Labor Category Total | |
| Task 2 - Operations and Maintenance/Steady State (SS) Work Activities (Option Period 3) | |||||||
| CLIN | Labor Category | Fully Burdened Hourly Labor Rates (Govt Site) | Full Burdened Hourly Labor Rate (Contractor Site) | Total Hours | Full Time Equivalents (FTE) | Labor Category Total | |
| Task 2 - Operations and Maintenance/Steady State (SS) Work Activities (Option Period 4) | |||||||
| CLIN | Labor Category | Fully Burdened Hourly Labor Rates (Govt Site) | Full Burdened Hourly Labor Rate (Contractor Site) | Total Hours | Full Time Equivalents (FTE) | Labor Category Total | |
| Task 3 - Transition In | |||||||
| CLIN | Labor Category | Fully Burdened Hourly Labor Rates (Govt Site) | Full Burdened Hourly Labor Rate (Contractor Site) | Total Hours | Full Time Equivalents (FTE) | Labor Category Total | |
| Task 4 - Transition Out (Optional) | |||||||
| CLIN | Labor Category | Fully Burdened Hourly Labor Rates (Govt Site) | Full Burdened Hourly Labor Rate (Contractor Site) | Total Hours | Full Time Equivalents (FTE) | Labor Category Total |
Task Order 2
| Food and Drug Administration (FDA) | |||||||
| Project Title: Task Order 2 - CSTAR Architecture and Interface Refresh | |||||||
| Order Type: Labor Hour | |||||||
| Government Site | |||||||
| Months 1-12 | |||||||
| CLIN | Labor Category | Fully Burdened Hourly Labor Rate (Govt Site) | Full Burdened Hourly Labor Rate (Contractor Site) | Total Hours | Full Time Equivalents (FTE) | Labor Category Total |
Task Order 3
| Food and Drug Administration (FDA) | |||||||
| Project Title: Task Order 3 - Legacy Premarket Replacement | |||||||
| Order Type: Labor Hour | |||||||
| Government Site | |||||||
| Month 1 - 13 | |||||||
| CLIN | Labor Category | Fully Burdened Hourly Labor Rate (Govt Site) | Full Burdened Hourly Labor Rate (Contractor Site) | Total Hours | Full Time Equivalents (FTE) | Labor Category Total |
Sample BOE
| Food and Drug Administration | ||||||||||||
| Project Title: Center Submission Tracking and Reporting (CSTAR) | ||||||||||||
| Sample Basis of Estimate (BOE) | ||||||||||||
| Other Direct Costs (ODCs) | ||||||||||||
| Contract Year | CLIN Description | Manufacturer | Part/Product # | Quantity | Unit Cost | Overhead | G&A | Other Indirect (Specify) | Fee | Price Start-Date | Price Stop-Date | Total Cost |
| 1 | Portable Label Maker | Brother | PT-7600 | 3 | $ 47.69 | $ - 0 | $ 9.54 | $ - 0 | $ - 0 | 4/1/10 | 3/31/11 | $ 57.23 |
| Labor Rate Buildup | ||||||||||||
| Overhead (OH) | ||||||||||||
| Fringe | Govt. Site | Contractor Site | G&A | Fee | FCOM / COM | Material Handling | Others | |||||
| 40% | 30% | 40% | 20% | 8% | 0.5% | 0% | 0% | |||||
| Sample Hourly Labor Rate Build-Up – Using Contractor Site Rate | ||||||||||||
| CLIN # | CLIN Description | Direct Rate | Fringe | OH | G&A | Fee | FCOM / COM | Material Handling | Others | Fully Burdened Hourly Rate | ||
| A0102 | Project Manager | $ 59.05 | $ 23.62 | $ 33.07 | $ 23.15 | $ 11.11 | $ - 0 | $ - 0 | $ - 0 | $ 150.00 | ||
| Sample Hourly Labor Rate Build-Up – Using Government Site Rate | ||||||||||||
| CLIN # | CLIN Description | Direct Rate | Fringe | OH | G&A | Fee | FCOM / COM | Material Handling | Others | Fully Burdened Hourly Rate | ||
| B0102 | Project Manager | $ 59.05 | $ 23.62 | $ 24.80 | $ 21.49 | $ 10.32 | $ - 0 | $ - 0 | $ - 0 | $ 139.28 | ||
| Notes: | ||||||||||||
| The rates and percentages used are for illustration purposes only. | ||||||||||||
| The Contractor must clearly show the derivation of the fully burdened hourly or annual rate from the direct rate. | ||||||||||||
| For example, the Contractor must show how the fully burdened $150/hr for the Project Manager (Contractor Site) was derived from the $59.05/hr direct rate. | ||||||||||||
| All formulas must be clearly shown. The Government will not accept pasted values. | ||||||||||||
| For Others, where applicable, please clearly clarify what they are. | ||||||||||||
| Where an indirect cost element is not applicable, i.e., Material Handling, Others, etc., please put in 0% or leave blank. | ||||||||||||
| The Contractor must also specify the annual hours for a full-time equivalent (FTE), e.g,, 1920, 1880 hours. |
Notes-Assumptions
| Food and Drug Administration (FDA) |
| Project Title: Center Submission Tracking and Reporting (CSTAR) |
| Notes and Assumptions |
| The Contractor shall use this worksheet to clearly list all pricing notes and assumptions used in the derivation of its pricing proposal. |
File details come from the government source that posted it. Updated .