Attachment 5 - Pricing Worksheet.xlsx
XLSX spreadsheet 40 KB Posted
- Solicitation number
- H9821025RE012
- Issued by
-
Defense Human Resources Activity
About this file
The document is a Pricing Worksheet for a federal contract opportunity for Survey and Market Research Services (Solicitation H9821025RE012) issued by the Defense Human Resources Activity. The pricing template includes a comprehensive breakdown of labor categories and other direct expenses (ODE) across five contract years, with zero-dollar placeholders for offerors to complete. Labor categories range from Data Entry Clerk to Subject Matter Expert, with specified skill levels and educational requirements for each role. The total contract ceiling is $96,557,811.24, with labor categories including 16,286 hours for Subject Matter Expert, 34,854 hours for Consultant, and 128,205 hours for Analyst, among others.
The worksheet provides detailed instructions for price proposal submission, emphasizing that offerors must demonstrate pricing reasonableness and provide supporting documentation. The solicitation has a two-phase proposal submission timeline, with Phase 1 due June 16, 2025, at 9am Eastern time and Phase 2 due June 30, 2025, at 12pm Eastern time. Other direct expenses (ODE) include items like survey booklets, mailing envelopes, paper, segmentation software, and public opinion polling, with pricing to be determined by the offeror. The document serves as a comprehensive pricing template for potential contractors to complete and submit their proposed rates and expenses.
View the file
Other files
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 Price | This worksheet is used for evaluation and contract ceiling purposes only. |
| Actual Labor | Individual labor prices that will be used to price task orders, and will be evlauated for price fair and reasonableness |
| Labor Category Descriptions | For informational purposes, the descriptions for the labor categories are provided. |
| Actual ODE | Individual ODE prices that will be used to price task orders, and will be evlauated for price fair and reasonableness |
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 will adjust the estimated ODE ceiling amount at the time of award |
| CLIN 0003 - ODE (Non-Rate Card) | DO NOT PROPOSE | *the Government will adjust the estimated ODE ceiling amount at the time of award |
| CLIN 0004 - TRAVEL | DO 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 will be made to get to a total contract ceiling of $96,557,811.24. |
| [INSERT OFFEROR'S NAME] | |||||||||||||||||
| LABOR | |||||||||||||||||
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Total | ||||||||||||
| (NOTE 2) | (INSTR. 1) | (NOTE 3) | (NOTE 2) | (INSTR. 1) | (NOTE 3) | (NOTE 2) | (INSTR. 1) | (NOTE 3) | (NOTE 2) | (INSTR. 1) | (NOTE 3) | (NOTE 2) | (INSTR. 1) | (NOTE 3) | |||
| Labor Category (NOTE 1) | Base/Hours | Rate | Extended $ | Base/Hours | Rate | Extended $ | Base/Hours | Rate | Extended $ | Base/Hours | Rate | Extended $ | Base/Hours | Rate | Extended $ | Base/Hours | Extended $ |
| Subject Matter Expert | 2846 | $0.00 | 3265 | $0.00 | 3267 | $0.00 | 3431 | $0.00 | 3477 | $0.00 | 16,286 | $0.00 | |||||
| Consultant | 6427 | $0.00 | 7345 | $0.00 | 6967 | $0.00 | 6954 | $0.00 | 7161 | $0.00 | 34,854 | $0.00 | |||||
| Project Manager | 5262 | $0.00 | 5865 | $0.00 | 5621 | $0.00 | 5903 | $0.00 | 5761 | $0.00 | 28,412 | $0.00 | |||||
| Project Leader | 7746 | $0.00 | 8474 | $0.00 | 8307 | $0.00 | 8464 | $0.00 | 8489 | $0.00 | 41,480 | $0.00 | |||||
| Project Coordinator | 4461 | $0.00 | 5,093 | $0.00 | 4871 | $0.00 | 4881 | $0.00 | 5065 | $0.00 | 24,371 | $0.00 | |||||
| Senior Research Associate | 13021 | $0.00 | 14692 | $0.00 | 14390 | $0.00 | 15011 | $0.00 | 15932 | $0.00 | 73,046 | $0.00 | |||||
| Associate Programmer | 500 | $0.00 | 500 | $0.00 | 500 | $0.00 | 500 | $0.00 | 500 | $0.00 | 2,500 | $0.00 | |||||
| Research Associate | 16422 | $0.00 | 17853 | $0.00 | 18055 | $0.00 | 18960 | $0.00 | 19435 | $0.00 | 90,725 | $0.00 | |||||
| Analyst | 23741 | $0.00 | 25591 | $0.00 | 25546 | $0.00 | 26597 | $0.00 | 26730 | $0.00 | 128,205 | $0.00 | |||||
| Data Entry Clerk | 1000 | $0.00 | 1000 | $0.00 | 1000 | $0.00 | 1000 | $0.00 | 1000 | $0.00 | 5,000 | $0.00 | |||||
| Total Direct Labor Costs (Fully Burdened) | 81,426.00 | $0.00 | 89,678.00 | $0.00 | 88,524.00 | $0.00 | 91,701.00 | $0.00 | 93,550.00 | $0.00 | 444,879 | $0.00 |
| OTHER DIRECT EXPENSES (ODE) (RATE CARD) | |||||||||||||||||
| Description | Unit Price (YEAR 1) | Unit Price (YEAR 2) | Unit Price (YEAR 3) | Unit Price (YEAR 4) | Unit Price (YEAR 5) | TOTAL | |||||||||||
| Quantity | Unit Price | Total | Quantity | Unit Price | Total | Quantity | Unit Price | Total | Quantity | Unit Price | Total | Quantity | Unit Price | Total | Quantity | Total | |
| Survey Booklet: (8) page, 8.5" x 11" sized bound, color (price per 1000) | |||||||||||||||||
| Laminated Survey Booklets; 8.5" x 11" page size (15 pages front and back) (price per 1,000) | |||||||||||||||||
| Paper : 8.5" x 11" letter, standard size, white (price per 1,000) | |||||||||||||||||
| Paper: 8.5 "x 11" letter, with letterhead, signature and unique ID (price per 1,000) scantron | |||||||||||||||||
| #10 Mailing Envelopes; white (price per 1,000) | |||||||||||||||||
| 9"x12" Mailing Envelopes: white (price per 1000) | |||||||||||||||||
| 8.75" x 11.5" Mailing envelopes with graphic design (price per 1000) | |||||||||||||||||
| 6" x 4.25" post card (price per 1000) | |||||||||||||||||
| Segmentation Software w/ 20 licenses & (10) Location Coding software (Note 1) | |||||||||||||||||
| Public Opinion Polling of Influencers (IAW PWS 4.4) (Note: 2) | |||||||||||||||||
| Total ODE's | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| TRANSITION IN | |||
| TRANSITION IN | |||
| Quantity | Unit of Issue | Unit Price | Total |
| 3 | Months |
| TRANSITION OUT | |||
| TRANSITION OUT | |||
| Quantity | Unit of Issue | Unit Price | Total |
| 3 | Months |
Actual Labor
| The offeror's actual labor categories and fully burdened rates proposed to support this requirement (to include any subcontracting) shall be provided under this Tab. Please also see the "Labor Category Descriptions" Tab. These labor categories and rates will be used by the offerors to price the sample task order, and will be used by the awardee to price each task order issued against the contract after award. Should the offeror have different skill levels within a labor category, add those rates here. | |||||||
| [INSERT OFFEROR'S NAME] | |||||||
| Direct Labor (DL) | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | ||
| (NOTE 2) | (NOTE 3) | (NOTE 3) | (NOTE 3) | (NOTE 3) | (NOTE 3) | ||
| Labor Category (NOTE 1) | Offeror's Title for the Labor Category(ies) | Rate | Rate | Rate | Rate | Rate | |
| Subject Matter Expert | |||||||
| Consultant | |||||||
| Project Manager | |||||||
| Project Leader | |||||||
| Project Coordinator | |||||||
| Senior Research Associate | |||||||
| Associate Programmer | |||||||
| Research Associate | |||||||
| Analyst | |||||||
| Data Entry Clerk |
| 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. |
&"Arial,Bold"&12&A
Offeror: Page &P of &N Pages &F
Labor Category Descriptions
| Labor Category Descriptions | |
| Labor Category | Description |
| 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. |
| Skill Level I: 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. | |
| 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. |
| 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 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. |
| 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 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. |
| Skill Level __: Five years of project experience. (Advanced degree may be substituted for up to 2 years of experience). Minimum Education: Bachelors Degree | |
| Senior Research 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. |
| 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) | |
| Research 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. |
| Skill Level __: Three years of professional research experience. (Advanced degree may be substituted for up to 2 years of experience) |
Minimum Education: Bachelors Degree
| Analyst | Performs 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 Clerk | Enter and manage data from surveys and other research according to established protocols, complete necessary forms and record-keeping as directed by supervisor. |
| Skill Level _II_: 6 months of experience. |
Minimum Education: High School Diploma
Actual ODE
| The offeror's other direct expense prices (excluding travel) proposed to support this requirement shall be provided under this Tab. These prices will be used by the offerors to price the sample task order, and will be used by the awardee to price each task order issued against the contract after award. The prices below will be "not to exceed", however if efficiencies are found during performance lower prices may be provided at the task order level. If other ODEs become necessary for task orders beyond those currently estimated/historically used, those ODEs will be priced and evaluated at the task order level in accordance with PWS section 7.0. | ||||||
| [INSERT OFFEROR'S NAME] | ||||||
| Description | Year 1 Price | Year 2 Price | Year 3 Price | Year 4 Price | Year 5 Price | |
| Survey Booklet: (8) page, 8.5" x 11" sized bound, color (price per 1000) | ||||||
| Laminated Survey Booklets; 8.5" x 11" page size (15 pages front and back) (price per 1,000) | ||||||
| Paper : 8.5" x 11" letter, standard size, white (price per 1,000) | ||||||
| Paper: 8.5 "x 11" letter, with letterhead, signature and unique ID (price per 1,000) scantron | ||||||
| #10 Mailing Envelopes; white (price per 1,000) | ||||||
| 9"x12" Mailing Envelopes: white (price per 1000) | ||||||
| 8.75" x 11.5" Mailing envelopes with graphic design (price per 1000) | ||||||
| 6" x 4.25" post card (price per 1000) | ||||||
| Segmentation Software w/ 20 licenses & (10) Location Coding software (Note 1) | ||||||
| Public Opinion Polling of Influencers (IAW PWS 4.4) (Note: 2) |
File details come from the government source that posted it. Updated .