Attch 3 - Solicitation IDIQ Pricing Table.xlsx
XLSX spreadsheet 26 KB Posted
- Attached to
- Cost-of-Living Data Collection and Analysis
- Solicitation number
- H9821025R0001
- Issued by
-
Defense Human Resources Activity
About this file
This is a pricing table template for an IDIQ contract supporting cost-of-living data collection and analysis services for the Defense Human Resources Activity. The template covers five ordering periods from May 15, 2025 through May 14, 2030, with each period requiring 5,500 total estimated labor hours across four key labor categories: Program Manager (1,000 hours), Senior Data Analyst (1,500 hours), Economic Research Specialist (1,200 hours), and Junior Data Analyst (1,800 hours).
The file includes detailed labor category descriptions with required skill levels and qualifications, such as a Program Manager requiring Level III skills with BA/BS plus 5-7 years experience or MA/MS plus 1-5 years experience. Offerors must provide fully burdened labor rates for each category and ordering period, which will be evaluated for price reasonableness and used to establish the total contract ceiling when combined with the government's not-to-exceed travel amount under CLIN 0002. The template requires offerors to map their proposed labor categories to the government's specified categories and demonstrate adequate price support documentation.
View the file
Other files
Show all 11
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
| ENCLOSURE 3, BASIC IDIQ PRICING TABLE |
| Ordering Period Labor Category Pricing |
GENERAL INFORMATION
The purpose of the requested information in the attached worksheets is to assist Government 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 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 Labor Estimate | This worksheet is used for price evaluation and contract ceiling purposes. |
| Individual labor categories and rates that will be used to price task orders, and will be evaluated for price fair and reasonableness. | |
| Labor Category Descriptions | For informational purposes, the descriptions for the labor categories are provided. |
Total Labor Estimate
| Attachment 3, BASIC IDIQ PRICING TABLE |
| FOR EVALUATION & CONTRACT CEILING PURPOSES. Offeror's shall complete the table below by using their fully burdened labor rate for each labor category, for each ordering period to determine a total quoted price for CLIN 0001. The quoted CLIN value for 0001 (Labor) will be used with the Government's not-to-exceed amount for travel (CLIN 0002) to calculate a total quoted price, which will become the resulting contract ceiling for the awardee. |
| [INSERT OFFEROR'S NAME] | ||||
| ORDERING PERIOD 1 | 15 May 2025 - 14 May 2026 | |||
| Fully Burdened Direct Labor (DL) | ||||
| Labor Descripton | Total Estimated hours | Offeror's proposed Labor Category(ies) | Rate | Extended $ |
| Program Manager | 1000 | $0.00 | ||
| Senior Data Analyst | 1500 | $0.00 | ||
| Economic Research Specialist | 1200 | $0.00 | ||
| Junior Data Analyst | 1800 | $0.00 | ||
| $0.00 | ||||
| $0.00 | ||||
| Total Estimated Labor Hours for Ordering Period | 5,500 | |||
| Total Direct Labor (Fully Burdened) for Ordering Period 1 | $0.00 |
| ORDERING PERIOD 2 | 15 May 2026 - 14 May 2027 | |||
| Fully Burdened Direct Labor (DL) | ||||
| Labor Descripton | Total Estimated hours | Offeror's proposed Labor Category(ies) | Rate | Extended $ |
| Program Manager | 1000 | $0.00 | ||
| Senior Data Analyst | 1500 | $0.00 | ||
| Economic Research Specialist | 1200 | $0.00 | ||
| Junior Data Analyst | 1800 | $0.00 | ||
| $0.00 | ||||
| $0.00 | ||||
| Total Estimated Labor Hours for Ordering Period | 5,500 | |||
| Total Direct Labor (Fully Burdened) for Ordering Period 2 | $0.00 |
| ORDERING PERIOD 3 | 15 May 2027 - 14 May 2028 | |||
| Fully Burdened Direct Labor (DL) | ||||
| Labor Descripton | Total Estimated hours | Offeror's proposed Labor Category(ies) | Rate | Extended $ |
| Program Manager | 1000 | $0.00 | ||
| Senior Data Analyst | 1500 | $0.00 | ||
| Economic Research Specialist | 1200 | $0.00 | ||
| Junior Data Analyst | 1800 | $0.00 | ||
| $0.00 | ||||
| $0.00 | ||||
| Total Estimated Labor Hours for Ordering Period | 5,500 | |||
| Total Direct Labor (Fully Burdened) for Ordering Period 3 | $0.00 |
| ORDERING PERIOD 4 | 15 May 2028 - 14 May 2029 | |||
| Fully Burdened Direct Labor (DL) | ||||
| Labor Descripton | Total Estimated hours | Offeror's proposed Labor Category(ies) | Rate | Extended $ |
| Program Manager | 1000 | $0.00 | ||
| Senior Data Analyst | 1500 | $0.00 | ||
| Economic Research Specialist | 1200 | $0.00 | ||
| Junior Data Analyst | 1800 | $0.00 | ||
| $0.00 | ||||
| $0.00 | ||||
| Total Estimated Labor Hours for Ordering Period | 5,500 | |||
| Total Direct Labor (Fully Burdened) for Ordering Period 4 | $0.00 |
| ORDERING PERIOD 5 | 15 May 2029 - 14 May 2030 | |||
| Fully Burdened Direct Labor (DL) | ||||
| Labor Descripton | Total Estimated hours | Offeror's proposed Labor Category(ies) | Rate | Extended $ |
| Program Manager | 1000 | $0.00 | ||
| Senior Data Analyst | 1500 | $0.00 | ||
| Economic Research Specialist | 1200 | $0.00 | ||
| Junior Data Analyst | 1800 | $0.00 | ||
| $0.00 | ||||
| $0.00 | ||||
| Total Estimated Labor Hours for Ordering Period | 5,500 | |||
| Total Direct Labor (Fully Burdened) for Ordering Period 5 | $0.00 | |||
| Grand Total Direct Labor (Fully Burdened) |
&"Arial,Bold"&12&A
Offeror: Page &P of &N Pages &F
Labor Category Descriptions Labor Category Descriptions
| Skill Level. Many Labor Categories have multiple Skill Levels such as Level I (Entry/Junior), Level II (Intermediate) and Level III (Senior). | |
| Program Manager | The Program Manager oversees the entire COLA project, ensuring that objectives related to scope, schedule, budget, and quality are met while managing risks and stakeholder expectations. This role coordinates between internal OACT staff, technical POCs, and vendors, developing project plans, tracking milestones, and ensuring compliance with government standards. The Program Manager ensures that deliverables meet quality expectations by implementing oversight mechanisms throughout the project lifecycle. |
| Skill Level III: BA/BS Degree and 5-7 years experience or MA/MS and 1-5 years experience. PMP certification is recommended. | |
| Senior Data Analyst | The Senior Data Analyst leads the data collection and analysis efforts, applying statistical methods and predictive models to ensure acccuracy and relevancy. This role collaborates with technical POCs and external partners, performing quality control checks on incoming data to ensure alignment with project goals and reporting requirements. The Senior Data Analyst provides forecasts, builds dashboards, and delivers reports with actionable insights, ensuring data meets the highest quality standards. |
| Skill Level III : BA/BS Degree and 6–8 years in data analysis or economics, with proficiency in statistical tools such as R, Python, or Stata. | |
| Economic Research Specialist | The Economic Research Specialist focuses on gathering, interpreting, and validating economic data from third-party sources (e.g., IMF, Numbeo) and public datasets to support COLA calculations. This role ensures the quality and accuracy of vendor-provided data and stays current on macroeconomic trends impacting COLA rates. The Economic Research Specialist maintains vendor relationships and monitors data subscriptions to guarantee timely, reliable inputs for OACT decision-making. |
| Skill Level II: BA/BS Degree and 5–7 years in economic research or market analysis, with experience in vendor data and public datasets. | |
| Junior Data Analyst | The Junior Data Analyst supports the team by handling data entry, cleaning, and validation, ensuring that all collected data is accurate and ready for further analysis. Under the guidance of the Senior Data Analyst, this role generates basic reports, maintains data integrity, and assists with quality control efforts to meet reporting deadlines. The Junior Analyst contributes to delivering high-quality outputs by following established processes for data management. |
| Skill Level I:1–3 years in data analytics or economics, with proficiency in Microsoft Excel and basic statistical tools. |
File details come from the government source that posted it. Updated .