47QFPA23R0001_RFP_Exhibit A_Price_Workbook_2023-02-28.xlsx

XLSX spreadsheet 142 KB Posted

Attached to
Office of People Analytics (OPA) Analytical Support for Research, Surveys, and Statistics
Solicitation number
47QFPA23R0001
Issued by

View the file

Other files

File Type Posted
47QFPA23R0001_RFP_Amendment_0003_SF30_04042023.pdf PDF
47QFPA23R0001 RFP QA Response 3 04042023.pdf PDF
47QFPA23R0001_RFP_OPA_Analytics rev 2 03282023.pdf PDF
47QFPA23R0001 RFP QandA 2 Response 03282023.pdf PDF
47QFPA23R0001_RFP_Amendment_0002_SF30_03282023.pdf PDF
Attachment_1_Analytics_PWS_rev 1_03232023.pdf PDF
Attachment_2-Small_Business_Participation_Information_Sheet rev 1.docx DOCX document
47QFPA23R0001_RFP_OPA_Analytics rev 1 03232023.pdf PDF
47QFPA23R0001 RFP QandA Response 03232023.pdf PDF
47QFPA23R0001_RFP_Exhibit A_Price_Workbook rev 1 03232023.xlsx XLSX spreadsheet
47QFPA23R0001_RFP_Amendment_0001_SF30_03232023.pdf PDF
47QFPA23R0001_Attachment_9 - Question_and_Answer_Template_2023-02-28 (1).xlsx XLSX spreadsheet
47QFPA23R0001_RFP_SF 1449.pdf PDF
47QFPA23R0001_RFP_OPA_Analytics_2023-02-28.pdf PDF
47QFPA23R0001_Attachment_11_CUI_Non-Disclosure_Agreement.docx DOCX document
47QFPA23R0001_Attachment_2-Small_Business_Participation_Information_Sheet_2023-02-28.docx DOCX document
47QFPA23R0001_Attachment_3-Reference_Information_Sheet_2023-02-28.docx DOCX document
47QFPA23R0001_Attachment_10_47QFPA23R0001__Letter of Commitment Template_2023-02-28.docx DOCX document
47QFPA23R0001_Attachment_7-Quality_Assurance_Surveillance_Plan_2023-02-28.pdf PDF
47QFPA23R0001_Attachment_4 - Task Order 1 PWS (FY23_DEOCS_Support) 2023-02-28.pdf PDF
47QFPA23R0001_Attachment_8-OCI_Template_2023-02-28.docx DOCX document
47QFPA23R0001_Attachment_6 - Sample Task Order B PWS (SAGR2024) 2023-02-28.pdf PDF
47QFPA23R0001_Task_Order_0001_Attachment_1_DEOCS5.0 Phase 2 Validation Analysis Plan Outline V2 2023-02-28 .pdf PDF
47QFPA23R0001_RFP_Attachment_1_Analytics_PWS_09302022.pdf PDF
47QFPA23R0001_Attachment_5 - Sample Task Order A PWS - Modernization_Optimization_2023-02-28.pdf PDF
Show all 25

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:
1Insert Offeror Name
2Fill out all applicable yellow highlighted cells on all tabs of this Excel workbook.
3Include 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.
4Ensure all formulas are functional and intact on the proposal submission.
IDIQ Price Input Tab Instructions:
1Column 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.
2Column D - Indicate if information in this row will be for the prime contractor or a subcontractor. Provide subcontractor name if applicable.
3Columns 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.
4If 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.
5Enter any escalation rate used or applied to develop option year labor rates in row 54.
6Do 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.
Task Order 0001 and Sample Task Orders A and B Price Tab Instructions
1Fill 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.
2Fill 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.
3Ensure totals for Labor hours, labor price, other direct costs, and overall total price are accurate.

IDIQ 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 SiteProvide 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 HoursFully Burdened Labor RateYear 1 TotalEstimated Labor HoursFully Burdened Labor RateYear 2 TotalEstimated Labor HoursFully Burdened Labor RateYear 3 TotalEstimated Labor HoursFully Burdened Labor RateYear 4 TotalEstimated Labor HoursFully Burdened Labor RateYear 5 Total
Subject Matter Expert 114,000$0.0010,000$0.0010,000$0.0010,000$0.0012,000$0.00
Project Manager15,000$0.0010,440$0.0010,000$0.0012,000$0.0015,000$0.00
Consultant9,711$0.009,438$0.009,000$0.0010,000$0.0012,000$0.00
Project Leader10,000$0.0010,000$0.0010,000$0.0010,000$0.0012,000$0.00
Project Coordinator10,000$0.0010,000$0.005,000$0.0010,000$0.0010,000$0.00
Senior Associate20,000$0.0020,000$0.0020,000$0.0020,000$0.0022,450$0.00
Associate20,000$0.0020,000$0.0020,000$0.0020,000$0.0020,000$0.00
Analyst20,000$0.0020,000$0.0020,000$0.0020,000$0.0020,000$0.00
Research Analyst15,000$0.0015,000$0.007,939$0.0010,000$0.0010,000$0.00
Data Collection Manager10,000$0.0010,000$0.005,000$0.0010,735$0.0010,143$0.00
CLIN 0001 - Labor Category - Offsite ( Contractor Facility)
Subject Matter Expert 140$0.0030$0.0035$0.0040$0.0040$0.00
Project Manager60$0.0060$0.0060$0.0060$0.0060$0.00
Consultant376$0.00325$0.00325$0.00325$0.00325$0.00
Project Leader110$0.0070$0.0070$0.0070$0.0070$0.00
Project Coordinator805$0.00700$0.00700$0.00700$0.00700$0.00
Senior Associate920$0.00708$0.00708$0.00700$0.00700$0.00
Associate920$0.00700$0.00700$0.00700$0.00700$0.00
Analyst1,850$0.001,700$0.001,700$0.001,700$0.001,700$0.00
Research Analyst500$0.00500$0.00500$0.00500$0.00500$0.00
Data Collection Manager706$0.00508$0.00435$0.00453$0.00453$0.00
Total Labor Hours149,998140,179122,172137,983148,841699,173
Total Labor Price$0.00$0.00$0.00$0.00$0.00$0.00CLIN 0001 Grand Total
CLIN 0002 - Not to Exceed Travel$225,000.00CLIN 0002 GrandTotal
CLIN 0003 - Not to Exceed ODC's$1,979,000.00CLIN 0003 Grand Total

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

Task Order 0001 Price

CLIN 0001 - Labor Category (LCAT) - Government SiteEstimated LaborProposed Labor HoursFully Burdened Labor RatePriceIf proposed, provide quantity and description and unit prices of any ODCs and travel related to Task Order 0001 here:
Subject Matter Expert 190$ - 0
Project Manager1900$ - 0
Consultant1350$ - 0
Project Leader4050$ - 0
Project Coordinator0$ - 0
Senior Associate2210$ - 0
Associate2280$ - 0
Analyst1990$ - 0
Research Analyst0$ - 0
Data Collection Manager0$ - 0
CLIN 0001 - Labor Category (LCAT) - Contractor SiteEstimated LaborProposed Labor HoursFully Burdened Labor RatePrice
Subject Matter Expert 10$ - 0
Project Manager0$ - 0
Consultant0$ - 0
Project Leader0$ - 0
Project Coordinator0$ - 0
Senior Associate0$ - 0
Associate0$ - 0
Analyst0$ - 0
Research Analyst0$ - 0
Data Collection Manager0$ - 0
TOTAL CLIN 0001 PRICE ==>$ - 0
CLIN 0002 - Other Direct Costs (if applicable)$ - 0
Name of Indirect burden (if Applicable):Rate
Total Other Direct Costs (CLIN 0002)$ - 0
CLIN 0003 - Travel (if applicable)$ - 0
Name of Indirect burden (if Applicable):Rate

Total Travel (CLIN 0003) $ - 0

Total Price for Task Order$ - 0
For CLINs 0002 and 0003, please note that regardless of the number of burdens and their applicable rates, the CLIN value is a not-to-exceed (NTE) ceiling and is the maximum amount that the Government will pay.

Sample Task A Price

CLIN 0001 - Labor Category (LCAT) - Government SiteEstimated LaborProposed Labor HoursFully Burdened Labor RatePriceIf proposed, provide quantity and description and unit prices of any ODCs and travel related to Sample Task A here:
Subject Matter Expert 196$ - 0
Project Manager1225$ - 0
Consultant1363$ - 0
Project Leader1374$ - 0
Project Coordinator0$ - 0
Senior Associate1065$ - 0
Associate340$ - 0
Analyst0$ - 0
Research Analyst0$ - 0
Data Collection Manager0$ - 0
CLIN 0001 - Labor Category (LCAT) - Contractor SiteEstimated LaborProposed Labor HoursFully Burdened Labor RatePrice
Subject Matter Expert 10$ - 0
Project Manager0$ - 0
Consultant0$ - 0
Project Leader0$ - 0
Project Coordinator0$ - 0
Senior Associate0$ - 0
Associate0$ - 0
Analyst0$ - 0
Research Analyst0$ - 0
Data Collection Manager0$ - 0
TOTAL CLIN 0001 PRICE ==>$ - 0
CLIN 0002 - Other Direct Costs (if applicable)
Name of Indirect burden (if Applicable):Rate10%
$ 3.00
Total Other Direct Costs (CLIN 0002)$ 3.00
CLIN 0003 - Travel (if applicable)
Name of Indirect burden (if Applicable):Rate

Total Travel (CLIN 0003) $ - 0

Total Price for Task Order$ 3.00
For CLINs 0002 and 0003, please note that regardless of the number of burdens and their applicable rates, the CLIN value is a not-to-exceed (NTE) ceiling and is the maximum amount that the Government will pay.

Sample Task B Price

CLIN 0001 - Labor Category (LCAT) - Government SiteEstimated LaborLabor HoursFully Burdened Labor RatePriceIf proposed, provide quantity and description and unit prices of any ODCs and travel related to Sample Task B here:
Subject Matter Expert 110$ - 0
Project Manager771$ - 0
Consultant773$ - 0
Project Leader1882$ - 0
Project Coordinator0$ - 0
Senior Associate793$ - 0
Associate753$ - 0
Analyst785$ - 0
Research Analyst0$ - 0
Data Collection Manager0$ - 0
CLIN 0001 - Labor Category (LCAT) - Contractor SiteEstimated LaborLabor HoursFully Burdened Labor RatePrice
Subject Matter Expert 10$ - 0
Project Manager0$ - 0
Consultant0$ - 0
Project Leader0$ - 0
Project Coordinator0$ - 0
Senior Associate0$ - 0
Associate0$ - 0
Analyst0$ - 0
Research Analyst0$ - 0
Data Collection Manager0$ - 0
TOTAL CLIN 0001 PRICE ==>$ - 0
CLIN 0002 - Other Direct Costs (if applicable)
Name of Indirect Burden (if Applicable) and the Applicable Rate Per Each Burden
Total Other Direct Costs (CLIN 0002) (Not-to-Exceed or NTE)$ 3,000.00
CLIN 0003 - Travel (if applicable)
Name of Indirect Burden (if Applicable) and the Applicable Rate Per Each Burden

Total Travel (CLIN 0003) (Not-to-Exceed or NTE) $ 37,000.00

Total Price for Task Order$ 40,000.00
Footnote: For CLINs 0002 and 0003, please note that regardless of the number of burdens and their applicable rates, the CLIN value is a not-to-exceed (NTE) ceiling and is the maximum amount that the Government will pay.

Personnel Requirements

PERSONNEL LABOR CATEGORIESDESCRIPTIONREQUIRED DEGREE OR EQUIVALENTREQUIRED YEARS OF EXPERIENCEIf applicable, provide offeror's equivalent or alternate LCAT name (if different than LCAT Name in Column B, otherwise leave blank)
Subject Matter Expert IPossesses 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 MA/MS (or equivalent) in the candidate's area of specialty
A Bachelor's degree and 6 years of relevant experience may be substituted for a MA/MSAt least 8 years of relevant experience as a specialist (with a title and responsibility appropriate to a recognized expert in field)
Project Manager

Note that 1 (one) Full Time Equivalent (FTE) Project Manager (PM) is required to be Key Personnel (Key) and will work at the IDIQ level. This Key PM will be reimbursed on individual orders and will not be paid directly from the IDIQ.

Additional PMs may be proposed at the order-level and are not required to be 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. Must possess at least a Ph.D in an interdisciplinary field

10 years of relevant experience may be substituted in place of a Ph.DAt least 8 years of relevant experience
ConsultantHas 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 MA/MS (or equivalent) in the candidate's area of specialty

A Bachelor's degree and 6 years of experience may be substituted for a MA/MS At least 8 years of relevant professional experience, including at least 4 years leading projects

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. Must possess at least a MA/MS

A Bachelor's degree and 6 years of experience may be substituted for a MA/MSAt least 5 years of relevant professional experience and experience, including at least 1 year leading projects
Project CoordinatorResponsible 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

6 years of experience can be substituted for a Bachelors Degree

At least 5 years of relevant project experience
Senior AssociateProvides 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.Must possess at least a MA/MS
A Bachelor's degree and 6 years of experience may be substituted for a MA/MSAt least 4 years of relevant professional research experience
AssociateInterfaces 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.Must possess at least a Bachelor's Degree
There is no equivalency for years of relevant experience. A Bachelor's degree is required for this position.At least 3 years of relevant professional research experience
AnalystPlans, 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.Bachelor's or higher in the field of statistics, surveys, data science, psychology, sociology, or economics

There is no equivalency for years of relevant experience. A Bachelor's degree is required for this position.

At least 2 years of relevant experience in a similar position
Research AnalystSkilled in gathering, analyzing and working with data to improve efficiency; effective communicator; and able to present the data in anunderstandable format for business decision-makers.Bachelor's Degree or a minimum of 2 years' experience in a similar position is requiredAt least 2 years of relevant experience in a similar position
Data Collection ManagerSkilledin managing all aspects of the data collection group along with overseeing and contributing to all phases of collection and can demonstrate attention todetail, strong initiative, a passion for innovation, and a vast planning andorganizational skill set.Bachelor's Degree or a minimum of 2 years' experience in a similar position is requiredAt least 2 years of relevant experience in a similar position
Footnote: In the event of an education/experience substitution, the substituted education/experience must be in addition to the other requirements.

For example, for the Project Manager, if 10 years of relevant experience are used to substitute for a PhD for the Project Manager, then the Project Manager must have at least 18 years of relevant experience (10 to substitute for the PhD and 8 to meet the required years of experience).

Another example is the Subject Matter Expert I - if a candidate is using a Bachelor's degree and 6 years of relevant experience to substitute for a MA/MS, the candidate needs a total of 14 years of relevant experience (6 for the substitution and 8 to meet the required years of experience).

File details come from the government source that posted it. Updated .