Draft 47QFPA23R0001_RFP_Exhibit A_Price_Workbook.xlsx
XLSX spreadsheet 199 KB Posted
- Attached to
- Synopsis - Office of People Analytics (OPA) Analytical Support for Research, Surveys, and Statistics
- Solicitation number
- 47QFPA23R0001_DRAFT
View the file
Other files
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
| 47QFPA23R0001 RFP Exhibit A - INSTRUCTIONS TO OFFERORS | |
| General Instructions: | |
| 1 | Insert Offeror Name |
| 2 | Fill out all applicable yellow highlighted cells on all tabs of this Excel workbook. |
| 3 | Include all applicable prices and costs for the IDIQ contract on the Price Input Tab, including both prime and suboffer (subcontract) amounts. Task order pricing shall go on the subsequent task order tabs of the workbook. |
| 4 | Ensure all formulas are functional and intact on the proposal submission. |
| Price Input Tab Instructions: | |
| 1 | Column C - If offeror nomenclature differs from Government provided labor category name, add offeror's equivalent or alternative name for each Government provided labor category. Otherwise, leave blank. |
| 2 | Column D - Indicate if information in this row will be for the prime contractor or a subcontractor. Provide subcontractor name if applicable. |
| 3 | Columns F, J, N, R, V - Enter a fully burdened labor rate for each labor category. If proposing subcontractor labor, a separate fully burdened labor rate may be proposed that differs from the rate proposed for prime contractor labor. Provide labor rates that are fair, reasonable, and realistic for the work to be accomplished in the PWS. |
| 4 | If proposing to add indirect burdens to the Government's other direct cost or travel estimate for the IDIQ contract, provide a description of the burden type, applicable rate, and amount for each type of indirect burden in the price narrative, not in this spreadsheet. |
| 5 | Enter any escalation rate used or applied to develop option year labor rates in row 54. |
| 6 | Do not edit Column B labor categories, labor hours per labor category, total labor hours per year, or other direct cost amounts. These are provided for proposal consistency purposes and to help develop realistic maximum IDIQ contract amounts. |
| Subcontracts Tab Instructions: | |
| 1 | If applicable, provide detail related to subcontract pricing amounts for the IDIQ contract on the Subcontracts tab. If proposing no subcontracts, leave blank. |
| 2 | Include only subcontract prices and costs that are also included on the Price Input Tab. (See General Instructions #3 Above) |
| 3 | Small business subcontract amounts shall support information proposed in the Small Business Participation Information Sheet and Small Business Subcontracting Plan (if large business concern) |
| Contract Price Summary Tab Instructions: | |
| 1 | Table should fill in automatically if all data is inserted properly in the price input tab. Ensure formulas are correct and the chart accurately fills in all blanks and accurately reflects proposed prices. |
| Task Order 0001 and Sample Task Order A Price Tab Instructions | |
| 1 | Fill in applicable direct labor hours and fully burdened hourly labor rates for each labor category proposed for the task order. If a labor category is not used, leave rate and hour information blank. |
| 2 | Fill in any applicable other direct costs and direct travel cost information, as well as any proposed indirect cost burdens. If proposing indirect costs, provide the name of the indirect burden, the indirect rate (%) used. No fee or profit is allowed on ODC or travel. |
| 3 | Ensure totals for Labor hours, labor price, other direct costs, and overall total price are accurate. |
| Task Order 0001 and Sample Task Order A Backup Tab Instructions | |
| 1 | If ODC is proposed, include a description of each other direct cost item proposed for the task order with any applicable quantities and unit price amounts, and a total price for ODC. |
| 2 | If travel costs are proposed, include a summary of any proposed travel costs to include identification of number of travelers, destination, duration, and price for airfare, car rental, subtotal cost for each trip, and total travel cost for the task order. |
| 3 | If no ODC or travel is proposed, leave blank. |
Price Input
| Base Ordering Period ( 60 Months) | ||||||||||||||||||
| Base Year (April 2022 - Mar 2023) | Year 1 (April 2023 - Mar 2024) | Year 2 (April 2024 - Mar 2025) | Year 3 (April 2025 - Mar 2026) | Year 4 (Jun 2026 - May 2027) | Contract Total | |||||||||||||
| CLIN 0001 - Labor Category (LCAT) - Government Site | Provide offeror's equivalent or alternate LCAT name (if different than LCAT Name in Column B, otherwise leave blank) | Indicate if labor proposed is from prime or subofferor (sub) (If sub, also include name of sub) | Estimated Labor Hours | Fully Burdened Labor Rate | Year 1 Total | Estimated Labor Hours | Fully Burdened Labor Rate | Year 2 Total | Estimated Labor Hours | Fully Burdened Labor Rate | Year 3 Total | Estimated Labor Hours | Fully Burdened Labor Rate | Year 4 Total | Estimated Labor Hours | Fully Burdened Labor Rate | Year 5 Total | |
| Subject Matter Expert 1 | 14,000 | $0.00 | 10,000 | $0.00 | 10,000 | $0.00 | 10,000 | $0.00 | 12,000 | $0.00 | ||||||||
| Project Manager | 15,000 | $0.00 | 10,440 | $0.00 | 10,000 | $0.00 | 12,000 | $0.00 | 15,000 | $0.00 | ||||||||
| Consultant | 9,711 | $0.00 | 9,438 | $0.00 | 9,000 | $0.00 | 10,000 | $0.00 | 12,000 | $0.00 | ||||||||
| Project Leader | 10,000 | $0.00 | 10,000 | $0.00 | 10,000 | $0.00 | 10,000 | $0.00 | 12,000 | $0.00 | ||||||||
| Project Coordinator | 10,000 | $0.00 | 10,000 | $0.00 | 5,000 | $0.00 | 10,000 | $0.00 | 10,000 | $0.00 | ||||||||
| Senior Associate | 20,000 | $0.00 | 20,000 | $0.00 | 20,000 | $0.00 | 20,000 | $0.00 | 22,450 | $0.00 | ||||||||
| Associate | 20,000 | $0.00 | 20,000 | $0.00 | 20,000 | $0.00 | 20,000 | $0.00 | 20,000 | $0.00 | ||||||||
| Analyst | 20,000 | $0.00 | 20,000 | $0.00 | 20,000 | $0.00 | 20,000 | $0.00 | 20,000 | $0.00 | ||||||||
| Research Analyst | 15,000 | $0.00 | 15,000 | $0.00 | 7,939 | $0.00 | 10,000 | $0.00 | 10,000 | $0.00 | ||||||||
| Data Collection Manager | 10,000 | $0.00 | 10,000 | $0.00 | 5,000 | $0.00 | 10,735 | $0.00 | 10,143 | $0.00 | ||||||||
| CLIN 0001 - Labor Category - Offsite ( Contractor Facility) | ||||||||||||||||||
| Subject Matter Expert 1 | 40 | $0.00 | 30 | $0.00 | 35 | $0.00 | 40 | $0.00 | 40 | $0.00 | ||||||||
| Project Manager | 60 | $0.00 | 60 | $0.00 | 60 | $0.00 | 60 | $0.00 | 60 | $0.00 | ||||||||
| Consultant | 376 | $0.00 | 325 | $0.00 | 325 | $0.00 | 325 | $0.00 | 325 | $0.00 | ||||||||
| Project Leader | 110 | $0.00 | 70 | $0.00 | 70 | $0.00 | 70 | $0.00 | 70 | $0.00 | ||||||||
| Project Coordinator | 805 | $0.00 | 700 | $0.00 | 700 | $0.00 | 700 | $0.00 | 700 | $0.00 | ||||||||
| Senior Associate | 920 | $0.00 | 708 | $0.00 | 708 | $0.00 | 700 | $0.00 | 700 | $0.00 | ||||||||
| Associate | 920 | $0.00 | 700 | $0.00 | 700 | $0.00 | 700 | $0.00 | 700 | $0.00 | ||||||||
| Analyst | 1,850 | $0.00 | 1,700 | $0.00 | 1,700 | $0.00 | 1,700 | $0.00 | 1,700 | $0.00 | ||||||||
| Research Analyst | 500 | $0.00 | 500 | $0.00 | 500 | $0.00 | 500 | $0.00 | 500 | $0.00 | ||||||||
| Data Collection Manager | 706 | $0.00 | 508 | $0.00 | 435 | $0.00 | 453 | $0.00 | 453 | $0.00 |
| Total Labor Hours | 149,998 | 140,179 | 122,172 | 137,983 | 148,841 | 699,173 | |||||
| Total Labor Price | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| CLIN 0002 - Not to Exceed Travel | $225,000.00 |
| CLIN 0003 - Not to Exceed ODC's | $1,979,000.00 |
Totals $2,204,000.00 Grand Total
Indicate Any Escalation (Esc.) Rate Applied to labor rates from one year to the next in this row as a percentage (example: 2.0%) Esc. rate for Year 1 Esc. rate for Year 2 Esc. rate for Year 3 Esc. rate for Year 4
Subcontracts 47QFPA23R0001 RFP Exhibit A - INSTRUCTIONS TO OFFERORS
| Subcontractor Name | Year 1 Amount | Year 2 Amount | Year 3 Amount | Year 4 Amount | Year 5 Amount | Total Amount | ||
| Subcontract 1 | Labor | $0.00 | ||||||
| Other Direct Costs/ Travel | $0.00 | |||||||
| Total Subcontract | $0.00 | |||||||
| Subcontract 2 | Labor | $0.00 | ||||||
| Other Direct Costs/ Travel | $0.00 | |||||||
| Total Subcontract | $0.00 | |||||||
| Subcontract 3 | Labor | $0.00 | ||||||
| Other Direct Costs/ Travel | $0.00 | |||||||
| Total Subcontract | $0.00 | |||||||
| (Offerors may add or subtract rows as necessary to enter all subcontract pricing information) |
Contract Price Summary
| Contract Period | CLIN | Description | Price |
| Base Ordering Period | 0001 | FFP - Services in accordance with PWS | $ - 0 |
| 0002 | Not to Exceed Travel | $ 225,000.00 | |
| 0003 | Not to Exceed ODC's | $ 1,979,000.00 | |
| TOTAL Price for 5 years | $ 2,204,000.00 |
TOTAL IDIQ Contract $ 2,204,000.00
Task Order 0001 Price
| CLIN 0001 - Labor Category (LCAT) - Government Site | Estimated Labor | Labor Hours | Fully Burdened Labor Rate | Price |
| Subject Matter Expert 1 | 90 | $ - 0 | ||
| Project Manager | 1900 | $ - 0 | ||
| Consultant | 1350 | $ - 0 | ||
| Project Leader | 4050 | $ - 0 | ||
| Project Coordinator | $ - 0 | |||
| Senior Associate | 2210 | $ - 0 | ||
| Associate | 2280 | $ - 0 | ||
| Analyst | 1990 | $ - 0 | ||
| Research Analyst | $ - 0 | |||
| Data Collection Manager | $ - 0 | |||
| CLIN 0001 - Labor Category (LCAT) - Contractor Site | ||||
| Subject Matter Expert 1 | $ - 0 | |||
| Project Manager | $ - 0 | |||
| Consultant | $ - 0 | |||
| Project Leader | $ - 0 | |||
| Project Coordinator | $ - 0 | |||
| Senior Associate | $ - 0 | |||
| Associate | $ - 0 | |||
| Analyst | $ - 0 | |||
| Research Analyst | $ - 0 | |||
| Data Collection Manager | $ - 0 | |||
| 0 | ||||
| $ - 0 | ||||
| CLIN 0002 - Other Direct Costs (if applicable) | $ 1,979,000.00 | |||
| Name of Indirect burden (if Applicable): | Rate |
| Total Other Direct Costs (CLIN 0002) | $ 1,979,000.00 | |
| CLIN 0003 - Travel (if applicable) | $ 225,000.00 | |
| Name of Indirect burden (if Applicable): | Rate |
Total Travel (CLIN 0003) $ 225,000.00
Total Price for Task Order $ 2,204,000.00
Task Order 0001 Backup
If proposed, provide quantity and description and unit prices of any ODCs and travel related to Task Order 1 here:
Sample Task A Price
| CLIN 0001 - Labor Category (LCAT) - Government Site | Estimated Labor | Labor Hours | Fully Burdened Labor Rate | Price |
| Subject Matter Expert 1 | 96 | $ - 0 | ||
| Project Manager | 1225 | $ - 0 | ||
| Consultant | 1363 | $ - 0 | ||
| Project Leader | 1374 | $ - 0 | ||
| Project Coordinator | $ - 0 | |||
| Senior Associate | 1065 | $ - 0 | ||
| Associate | 340 | $ - 0 | ||
| Analyst | $ - 0 | |||
| Research Analyst | $ - 0 | |||
| Data Collection Manager | $ - 0 | |||
| CLIN 0001 - Labor Category (LCAT) - Contractor Site | ||||
| Subject Matter Expert 1 | $ - 0 | |||
| Project Manager | $ - 0 | |||
| Consultant | $ - 0 | |||
| Project Leader | $ - 0 | |||
| Project Coordinator | $ - 0 | |||
| Senior Associate | $ - 0 | |||
| Associate | $ - 0 | |||
| Analyst | $ - 0 | |||
| Research Analyst | $ - 0 | |||
| Data Collection Manager | $ - 0 | |||
| 0 | ||||
| $ - 0 | ||||
| CLIN 0002 - Other Direct Costs (if applicable) | ||||
| Name of Indirect burden (if Applicable): | Rate |
| Total Other Direct Costs (CLIN 0002) | $ - 0 | |
| CLIN 0003 - Travel (if applicable) | ||
| Name of Indirect burden (if Applicable): | Rate |
Total Travel (CLIN 0003) $ - 0
Total Price for Task Order $ - 0
Sample Task A Backup
If proposed, provide quantity and description and unit prices of any ODCs and travel related to Sample Task A here:
Sample Task B Price
| CLIN 0001 - Labor Category (LCAT) - Government Site | Estimated Labor | Labor Hours | Fully Burdened Labor Rate | Price |
| Subject Matter Expert 1 | 10 | $ - 0 | ||
| Project Manager | 771 | $ - 0 | ||
| Consultant | 773 | $ - 0 | ||
| Project Leader | 1882 | $ - 0 | ||
| Project Coordinator | $ - 0 | |||
| Senior Associate | 793 | $ - 0 | ||
| Associate | 753 | $ - 0 | ||
| Analyst | 785 | $ - 0 | ||
| Research Analyst | $ - 0 | |||
| Data Collection Manager | $ - 0 | |||
| CLIN 0001 - Labor Category (LCAT) - Contractor Site | ||||
| Subject Matter Expert 1 | $ - 0 | |||
| Project Manager | $ - 0 | |||
| Consultant | $ - 0 | |||
| Project Leader | $ - 0 | |||
| Project Coordinator | $ - 0 | |||
| Senior Associate | $ - 0 | |||
| Associate | $ - 0 | |||
| Analyst | $ - 0 | |||
| Research Analyst | $ - 0 | |||
| Data Collection Manager | $ - 0 | |||
| 0 | ||||
| $ - 0 | ||||
| CLIN 0002 - Other Direct Costs (if applicable) | $ 3,000.00 | |||
| Name of Indirect burden (if Applicable): | Rate |
| Total Other Direct Costs (CLIN 0002) | $ 3,000.00 | |
| CLIN 0003 - Travel (if applicable) | $ 37,000.00 | |
| Name of Indirect burden (if Applicable): | Rate |
Total Travel (CLIN 0003) $ 37,000.00
Total Price for Task Order $ 40,000.00
Sample Task B Backup
If proposed, provide quantity and description and unit prices of any ODCs and travel related to Sample Task A here:
Personnel (Key)Requirements
| KEY PERSONNEL LABOR CATEGORIES | DESCRIPTION | REQUIRED DEGREE OR EQUIVALENT | REQUIRED YEARS OF EXPERIENCE |
| Subject Matter Expert I | Possesses highly specialized knowledge in areas of particular value of clients. Demonstrates mastery of scarce capability or area of expertise which dictates high compensation. Identifies areas in which theoretical research may enhance clients’ performance and leads efforts to advance understanding in these areas. Provides expertise including an understanding of current best practices and appropriate implementation of the latest techniques and tools. In addition to providing specialized advice, delivers presentations, leads client meetings, and performs assessments. | Must possess at least a PhD or MA/MS (or equivalent) in area of specialty. | At least 8 years experience and documented experience as a specialist (title and responsibility appropriate to recognized expert in field). |
| Project Manager (Key) | The Project Manager (PM) shall be the Contractor's primary point of contact for the government on all areas of performance under this requirement. The PM will be responsible for providing project management capabilities, including scheduling and attending meetings, developing agendas, documenting meeting minutes, and coordinating survey review packages. | Ph.D in interdisciplinary field | 10 years of experience in replace of degree |
| Consultant | Has mastery of and provides advice in a particular area of expertise. Provides expertise including an understanding of current best practices and appropriate implementation of the latest techniques and tools. Delivers presentations, leads client meetings, and performs assessments. Applies expertise and experience to execute clients’ initiatives and lead efforts toward positive change. | Must possess at least a PhD or MA/MS (or equivalent) in area of specialty. | At least eight years of professional experience including at least 4 years leading projects. (Advanced degree may be substituted for up to 2 years of experience). |
| Project Leader | Responsible for management and supervision of the research team, quality control, review and approval of deliverables and assisting managers and directors in determining the overall approach to a project. Directs the completion of project specific tasks within time frame and budget. Leads project meetings and client presentations. | Masters Degree (Bachelors + 6 years of experience can be substituted for MA/MS) | Five years of professional experience and experience including at least one year leading projects. (Advanced degree may be substituted for up to 2 years of experience). |
| Project Coordinator | Responsible for coordination of individual or multiple projects including quality control, communications and assisting managers and directors in ensuring quality and timely completion of projects within time frame and budget. Coordinators’ experiences and skills allow them to manage different aspects of complex projects and effectively organize and track them for clients. | Bachelors Degree | Five years of project experience. (Advanced degree may be substituted for up to 2 years of experience). |
| Senior Associate | Provides guidance and direction for specific sub-tasks of a project. Holds specific expertise in one or more key areas and knowledgeable in others. Interfaces with the client on regular basis. Produces deliverables with minimal supervision from senior team members including presentations, reports, etc. Supports the completion of project specific tasks within estimated time frames and budget constraints. Supports presentations and client meetings. | Masters Degree (Bachelors + 6 years of experience can be substituted for MA/MS) | Four years of professional research experience. (Advanced degree may be substituted for up to 2 years of experience). |
| Associate | Interfaces with the client on regular basis. Produces deliverables under supervision of senior team members including presentations, reports, etc. Supports the completion of project specific tasks within estimated time frames and budget constraints. Supports presentations and client meetings. | Bachelors Degree | Three years of professional research experience. (Advanced degree may be substituted for up to 2 years of experience) |
| Analyst | Plans, develops, or conducts surveys, studies, and/or survey sampling. Analyze and interpret the meaning of survey data, determine survey objectives, or suggest or test question wording. Develop or apply mathematical or statistical theory and methods to collect, organize, interpret, and summarize numerical data to provide usable information. Develop survey samples, statistically weight data. | B.A. or higher in field of statistics, surveys, data science, psychology, sociology, or economics. | 5-10 years of experience in replace of degree |
| Data Scientist Senior | Provides interdisciplinary analytical expertise utilizing skills from various fields, such as statistics, mathematics, and computer programming, to obtain interpretable insights from large structured and unstructured data. | Master’s degree or higher in computer science, mathematics, management science, engineering, economics, social science, operations research or related field. | 4 years of experience in field (Advanced degree may be substituted for up to 2 years of experience) |
| Data Scientist Junior | Provides interdisciplinary analytical expertise utilizing skills from various fields, such as statistics, mathematics, and computer programming, to obtain interpretable insights from large structured and unstructured data. | Bachelors or higher in computer science, mathematics, management science, engineering, economics, social science, operations research or related field. | 2 years of experience in field (Advanced degree may be substituted for up to 2 years of experience) |
| Associate Programmer | Provides specialized expertise across several systems hardware, networking and/or software functions. Performs programming and technical support of systems and leads the planning and conversions for new hardware and software products. Responsible for customization, installation, maintenance, setting of standards, and optimizing performance for systems in areas of expertise. | Bachelors Degree | 3 years of systems and programming expertise |
File details come from the government source that posted it. Updated .