Attachment 5 - Pricing Worksheet. Rev1.xlsx

XLSX spreadsheet 33 KB Posted

Attached to
Amendment 0005 - Survey and Market Research Services
Solicitation number
H9821025RE012
Issued by

About this file

The file is a Pricing Worksheet for a federal contract opportunity for Survey and Market Research Services issued by the Defense Human Resources Activity. The solicitation (H9821025RE012) involves a five-year contract with a total ceiling of $96,557,811.24, covering multiple labor categories including Subject Matter Experts, Consultants, Project Managers, Project Leaders, Project Coordinators, Senior Research Associates, Associate Programmers, Research Associates, Analysts, and Data Entry Clerks.

The pricing worksheet details labor hours and rates across nine distinct labor categories for each of the five contract years, with a total of 444,879 projected labor hours. The contract includes provisions for Other Direct Expenses (ODE) with rate card items such as Segmentation Software and Public Opinion Polling, as well as 3-month transition in and transition out periods. Proposal submission is structured in two phases, with Phase 1 due on June 16, 2025, at 9am Eastern time and Phase 2 due on June 30, 2025, at 12pm Eastern time. Each labor category has specific skill level requirements, typically ranging from bachelor's to doctoral degrees with corresponding professional experience requirements.

View the file

Other files

File Type Posted
Solicitation Amendment H9821025RE0120005 SF 30 (1).pdf PDF
Attachment 2 - Transition Plan PWS Rev 1.pdf PDF
Consolidated QA_Amendment 0004.pdf PDF
Attachment 11 - Addendum FAR 52.212-2 Evaluation Rev 2.pdf PDF
Solicitation Amendment H9821025RE0120004 SF 30.pdf PDF
Attachment 1 - Survey and Market Research Services PWS Rev 2 .pdf PDF
Solicitation Amendment H9821025RE0120003 SF 30.pdf PDF
H9821025RE0120002_Signature Page.pdf PDF
Attachment 1 - Survey and Market Research Services PWS Rev1.pdf PDF
SAM_QA Spreadsheet Rev 1.pdf PDF
SAM_Combined QA.pdf PDF
Solicitation Amendment H9821025RE0120002 SF 30.pdf PDF
Attachment 12_QA Template.xlsx XLSX spreadsheet
Solicitation Amendment H9821025RE0120001 SF 30.pdf PDF
Attachment 4 - Sample Task Order Pricing Rev1.xlsx XLSX spreadsheet
Attachment 11 - Addendum FAR 52.212-2 Evaluation Rev1.pdf PDF
Attachment 3 - Sample Task Order PWS Rev1.pdf PDF
Attachment 9 - Optional Procurement and Risk Management Narrative.pdf PDF
Attachment 10 - Step-by-Step Guide to Submitting a Proposal in PIEE.pdf PDF
Attachment 2 - Transition Plan PWS.pdf PDF
Attachment 11 - Addendum FAR 52.212-2 Evaluation. .pdf PDF
Attachment 6 - Past Performance Questionnaire-.docx DOCX document
Attachment 8 - SBPCD.pdf PDF
Attachment 4 - Sample Task Order Pricing Sheet.xlsx XLSX spreadsheet
Attachment 1 - Survey and Market Research Services PWS.pdf PDF
Solicitation___H9821025RE012_FS.pdf PDF
Attachment 7 - Ordering Procedures-.pdf PDF
Attachment 3 - Sample Task Order PWS.pdf PDF
Attachment 5 - Pricing Worksheet.xlsx XLSX spreadsheet
Show all 29

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

General Information Price Proposal

GENERAL INFORMATION

The purpose of the requested information in the attached worksheets is to assist Government personnel in the review and evaluation of price proposals submitted by Offerors. Offerors are reminded that the responsibility for providing adequate supporting data and attachments lies solely with them. Further, the offeror must also bear the burden of proof in establishing reasonableness of proposed pricing; therefore, it is in the offeror’s best interest to submit a fully supportable and well-prepared price proposal. The basis and rationale for all proposed prices should be provided as part of the proposal so that Government personnel can place reliance on the information as complete and accurate.

Summary of Tabs: \

Total Evaluated PriceThis worksheet is used for evaluation and contract ceiling purposes only.
Labor Category DescriptionsFor informational purposes, the descriptions for the labor categories are provided.

TOTAL EVALUATED PRICE

PRICING SHEET

CLIN 0001 - LABOR$0.00*the Government may adjust the estimated labor ceiling amount at the time of award
CLIN 0002 - ODE (Rate Card)$0.00*the Government may adjust the estimated ODE ceiling amount at the time of award
CLIN 0003 - ODE (Non-Rate Card)DO NOT PROPOSE*the Government may adjust the estimated ODE ceiling amount at the time of award
CLIN 0004 - TRAVELDO NOT PROPOSE*the Government may adjust the estimated travel ceiling amount at the time of award
CLIN 0005 - Transition In$0.00
CLIN 0006 - Transitiion Out$0.00
Total Price$0.00
* adjustments mentioned above may be made to get to a total contract ceiling of $96,557,811.24.
[INSERT OFFEROR'S NAME]
CLIN 0001 - LABOR
Year 1Year 2Year 3Year 4Year 5Total
(NOTE 3)(NOTE 3)(NOTE 3)(NOTE 3)(NOTE 3)
Labor Category (NOTE 1)Offeror's Title for the Labor Category(ies) (NOTE 2)HoursRateExtended $HoursRateExtended $HoursRateExtended $HoursRateExtended $HoursRateExtended $HoursExtended $
Subject Matter Expert2846$0.003265$0.003267$0.003431$0.003477$0.0016,286
Consultant6427$0.007345$0.006967$0.006954$0.007161$0.0034,854$0.00
Project Manager5262$0.005865$0.005621$0.005903$0.005761$0.0028,412$0.00
Project Leader7746$0.008474$0.008307$0.008464$0.008489$0.0041,480$0.00
Project Coordinator4461$0.005,093$0.004871$0.004881$0.005065$0.0024,371$0.00
Senior Research Associate13021$0.0014692$0.0014390$0.0015011$0.0015932$0.0073,046$0.00
Associate Programmer500$0.00500$0.00500$0.00500$0.00500$0.002,500$0.00
Research Associate16422$0.0017853$0.0018055$0.0018960$0.0019435$0.0090,725$0.00
Analyst23741$0.0025591$0.0025546$0.0026597$0.0026730$0.00128,205$0.00
Data Entry Clerk1000$0.001000$0.001000$0.001000$0.001000$0.005,000$0.00
Total Direct Labor Costs (Fully Burdened)81,426$0.0089,678$0.0088,524$0.0091,701$0.0093,550$0.00444,879$0.00
CLIN 0002 - OTHER DIRECT EXPENSES (ODE) (RATE CARD
DescriptionUnit Price (YEAR 1)Unit Price (YEAR 2)Unit Price (YEAR 3)Unit Price (YEAR 4)Unit Price (YEAR 5)TOTAL
QuantityUnit PriceTotalQuantityUnit PriceTotalQuantityUnit PriceTotalQuantityUnit PriceTotalQuantityUnit PriceTotalQuantityTotal
Segmentation Software w/ 20 licenses & (10) Location Coding software
Public Opinion Polling of Influencers
Total ODE's$0.00$0.00$0.00$0.00$0.00$0.00
CLIN 0005 - TRANSITION IN (NOTE4)
TRANSITION IN
QuantityUnit of IssueUnit PriceTotal
3Months
CLIN 0006 - TRANSITION OUT (NOTE 4)
TRANSITION OUT
QuantityUnit of IssueUnit PriceTotal
3Months
Note 1: Labor category descriptions are provided under a separate tab ("Labor Category Descriptions).
Note 2: The Offeror's Title for the Labor Category(ies) may be different from the General Labor Category, fill in title here.
Note 3: Offerors shall propose fully burdened labor rates for each proposed labor category for the base and each option year.
Note 4: Please note the Government will evaluate transition pricing independently from the total evaluated price. Transition pricing will be determined fair and reasonable and included in the final contract price.

Labor Category Descriptions

Labor Category Descriptions
Labor CategoryDescription
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.
Skill Level III: At least 8 years experience and documented experience as a specialist (title and responsibility appropriate to recognized expert in field). Must possess at least a PhD or MA/MS (or equivalent) in area of specialty.
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.
Skill Level II : 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). Must possess at least a PhD or MA/MS (or equivalent) in area of specialty.
Project ManagerResponsible for management and supervision of all research teams in an area of expertise. Approves overall approach and plans to projects and resolve elevated client issues. Creates synergies among research teams by synthesizing information from multiple projects and reallocating resources optimally. Delivers presentations and leads client meetings. Identifies areas in which theoretical research may enhance clients’ performance and leads efforts to advance understanding in these areas.
Skill Level _II_: At least eight years of professional experience including at least 4 years leading projects and 2 years leading multiple projects simultaneously. (Advanced degree may be substituted for up to 2 years of experience). PhD or MA/MS (or equivalent)
Project leaderResponsible 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.
Skill Level _II_: 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). Masters Degree (Bachelors + 6 years of experience can be substituted for MA/MS)
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.
Skill Level _II: Five years of project experience. (Advanced degree may be substituted for up to 2 years of experience). Minimum Education: Bachelors Degree
Senior Research 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.
Skill Level _II_: Four years of professional research experience. (Advanced degree may be substituted for up to 2 years of experience). Minimum Education: Masters Degree (Bachelors + 6 years of experience can be substituted for MA/MS)
Associate ProgrammerProvides 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.
Skill Level _II_: Three years of systems and programming expertise. Associates Degree & Certifications in Areas of Expertise
Research 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.
Skill Level _II_: Three years of professional research experience. (Advanced degree may be substituted for up to 2 years of experience)

Minimum Education: Bachelors Degree

AnalystPerforms analyst tasks with minimal supervision as directed by team leader or other senior members of team. Assists with training of junior team members and contributes to production of reports, presentations and other deliverables.
Skill Level _II_: Two years of experience.

Minimum Education: Bachelors Degree

Data Entry ClerkEnter and manage data from surveys and other research according to established protocols, complete necessary forms and record-keeping as directed by supervisor.
Skill Level _I_: 6 months of experience.

Minimum Education: High School Diploma

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