The file is an Excel-based pricing schedule (RFP 250000002730 Schedule B2) for a multi-year contract focused on employee benefits and healthcare audit services. The document outlines a three-year contract from 2027-2029 with detailed project lists and potential service deliverables across various audit and analysis categories, including medical plan audits (SHP, HDHP, Medicare Advantage), pharmacy audits (commercial, EGWP, implementation), dental plan audits, life insurance plan audits, and supplementary projects like HMO renewal analysis, rate development, cost trend reviews, and compliance support.
The pricing schedule is structured to allow bidders to complete hourly labor rate tables and estimated project costs, with provisions for up to six staff roles per project. While no specific dollar amounts are filled in, the document provides a comprehensive framework for pricing different healthcare and benefits-related audit services across three consecutive years. The pricing template allows for flexibility in staffing and hourly rates, with space for bidders to insert additional rows and customize their proposed cost structure. The document appears designed to standardize pricing submissions and facilitate comparative evaluation of potential service providers' proposed costs and staffing approaches.
The file's text, extracted by GovTribe without its formatting.
Year 1 2027
Bidders must complete all tables on all tabs in this EBD Project List Pricing. Additional rows may be inserted and/or deleted as needed.
Hourly Labor Rates
Please identify staff roles anticipated for involvement with EBD projects with rate charged for duration of contract. Add additional lines if necessary.
Role
Hourly Billing Rate Year 1
Hourly Billing Rate Year 2
Hourly Billing Rate Year 3
1
2
3
4
5
6
7
8
9
10
11
Estimated Planned Project list:
Year 1 – 2027
Audit Projects
Medical Plan Audit (SHP and HDHP)
Staff Position(s) Required for Deliverable
Estimated Hours Per Role
Hourly Rate Per Role
Total Cost Per Staff Role
1
$ - 0
2
$ - 0
3
$ - 0
4
$ - 0
5
$ - 0
6
$ - 0
Total Cost of Deliverable (without expenses)
$ - 0
Medical Plan Audit (Medicare Advantage)
Staff Position(s) Required for Deliverable
Estimated Hours Per Role
Hourly Rate Per Role
Total Cost Per Staff Role
1
$ - 0
2
$ - 0
3
$ - 0
4
$ - 0
5
$ - 0
6
$ - 0
Total Cost of Deliverable (without expenses)
$ - 0
Pharmacy Commercial Audit
Staff Position(s) Required for Deliverable
Estimated Hours Per Role
Hourly Rate Per Role
Total Cost Per Staff Role
1
$ - 0
2
$ - 0
3
$ - 0
4
$ - 0
5
$ - 0
6
$ - 0
Total Cost of Deliverable (without expenses)
$ - 0
Pharmacy EGWP Audit
Staff Position(s) Required for Deliverable
Estimated Hours Per Role
Hourly Rate Per Role
Total Cost Per Staff Role
1
$ - 0
2
$ - 0
3
$ - 0
4
$ - 0
5
$ - 0
6
$ - 0
Total Cost of Deliverable (without expenses)
$ - 0
Pharmacy Implementation Audit
Staff Position(s) Required for Deliverable
Estimated Hours Per Role
Hourly Rate Per Role
Total Cost Per Staff Role
1
$ - 0
2
$ - 0
3
$ - 0
4
$ - 0
5
$ - 0
6
$ - 0
Total Cost of Deliverable (without expenses)
$ - 0
Dental Plan Audit
Staff Position(s) Required for Deliverable
Estimated Hours Per Role
Hourly Rate Per Role
Total Cost Per Staff Role
1
$ - 0
2
$ - 0
3
$ - 0
4
$ - 0
5
$ - 0
6
$ - 0
Total Cost of Deliverable (without expenses)
$ - 0
Life Insurance Plan Audit
Staff Position(s) Required for Deliverable
Estimated Hours Per Role
Hourly Rate Per Role
Total Cost Per Staff Role
1
$ - 0
2
$ - 0
3
$ - 0
4
$ - 0
5
$ - 0
6
$ - 0
Total Cost of Deliverable (without expenses)
$ - 0
Other Projects
HMO Renewal Analysis and Negotiations
Staff Position(s) Required for Deliverable
Estimated Hours Per Role
Hourly Rate Per Role
Total Cost Per Staff Role
1
$ - 0
2
$ - 0
3
$ - 0
4
$ - 0
5
$ - 0
6
$ - 0
Total Cost of Deliverable (without expenses)
$ - 0
HDHP and PPO Rate Development and Actuarial Value Analysis
Staff Position(s) Required for Deliverable
Estimated Hours Per Role
Hourly Rate Per Role
Total Cost Per Staff Role
1
$ - 0
2
$ - 0
3
$ - 0
4
$ - 0
5
$ - 0
6
$ - 0
Total Cost of Deliverable (without expenses)
$ - 0
Cost Trend Review
Staff Position(s) Required for Deliverable
Estimated Hours Per Role
Hourly Rate Per Role
Total Cost Per Staff Role
1
$ - 0
2
$ - 0
3
$ - 0
4
$ - 0
5
$ - 0
6
$ - 0
Total Cost of Deliverable (without expenses)
$ - 0
BH/SUD RFP
Staff Position(s) Required for Deliverable
Estimated Hours Per Role
Hourly Rate Per Role
Total Cost Per Staff Role
1
$ - 0
2
$ - 0
3
$ - 0
4
$ - 0
5
$ - 0
6
$ - 0
Total Cost of Deliverable (without expenses)
$ - 0
Compliance Support
Staff Position(s) Required for Deliverable
Estimated Hours Per Role
Hourly Rate Per Role
Total Cost Per Staff Role
1
$ - 0
2
$ - 0
3
$ - 0
4
$ - 0
5
$ - 0
6
$ - 0
Total Cost of Deliverable (without expenses)
$ - 0
MHPAEA Assessment
Staff Position(s) Required for Deliverable
Estimated Hours Per Role
Hourly Rate Per Role
Total Cost Per Staff Role
1
$ - 0
2
$ - 0
3
$ - 0
4
$ - 0
5
$ - 0
6
$ - 0
Total Cost of Deliverable (without expenses)
$ - 0
Year 1 2027 Totals
Audit Projects
Medical Plan Audit (SHP and HDHP)
$ - 0
Medical Plan Audit (Medicare Advantage)
$ - 0
Pharmacy Commercial Audit
$ - 0
Pharmacy EGWP Audit
$ - 0
Pharmacy Implementation Audit
$ - 0
Dental Plan Audit
$ - 0
Life Insurance Plan Audit
$ - 0
Other Projects
HMO Renewal Analysis and Negotiations
$ - 0
HDHP and PPO Rate Development and Actuarial Value Analysis
$ - 0
Cost Trend Review
$ - 0
BH/SUD RFP
$ - 0
Compliance Support
$ - 0
MHPAEA Assessment
$ - 0
Total
$ - 0
Year 2 2028
Estimated Planned Project list:
Year 2 – 2028
Audit Projects
Pharmacy Commercial Audit
Staff Position(s) Required for Deliverable
Estimated Hours Per Role
Hourly Rate Per Role
Total Cost Per Staff Role
1
$ - 0
2
$ - 0
3
$ - 0
4
$ - 0
5
$ - 0
6
$ - 0
Total Cost of Deliverable (without expenses)
$ - 0
Pharmacy EGWP Audit
Staff Position(s) Required for Deliverable
Estimated Hours Per Role
Hourly Rate Per Role
Total Cost Per Staff Role
1
$ - 0
2
$ - 0
3
$ - 0
4
$ - 0
5
$ - 0
6
$ - 0
Total Cost of Deliverable (without expenses)
$ - 0
Vision Audit (3 plan years)
Staff Position(s) Required for Deliverable
Estimated Hours Per Role
Hourly Rate Per Role
Total Cost Per Staff Role
1
$ - 0
2
$ - 0
3
$ - 0
4
$ - 0
5
$ - 0
6
$ - 0
Total Cost of Deliverable (without expenses)
$ - 0
FSA Audit
Staff Position(s) Required for Deliverable
Estimated Hours Per Role
Hourly Rate Per Role
Total Cost Per Staff Role
1
$ - 0
2
$ - 0
3
$ - 0
4
$ - 0
5
$ - 0
6
$ - 0
Total Cost of Deliverable (without expenses)
$ - 0
Disability Plan Audit
Staff Position(s) Required for Deliverable
Estimated Hours Per Role
Hourly Rate Per Role
Total Cost Per Staff Role
1
$ - 0
2
$ - 0
3
$ - 0
4
$ - 0
5
$ - 0
6
$ - 0
Total Cost of Deliverable (without expenses)
$ - 0
Other Projects
HMO Renewal Analysis and Negotiations
Staff Position(s) Required for Deliverable
Estimated Hours Per Role
Hourly Rate Per Role
Total Cost Per Staff Role
1
$ - 0
2
$ - 0
3
$ - 0
4
$ - 0
5
$ - 0
6
$ - 0
Total Cost of Deliverable (without expenses)
$ - 0
HDHP and PPO Pricing
Staff Position(s) Required for Deliverable
Estimated Hours Per Role
Hourly Rate Per Role
Total Cost Per Staff Role
1
$ - 0
2
$ - 0
3
$ - 0
4
$ - 0
5
$ - 0
6
$ - 0
Total Cost of Deliverable (without expenses)
$ - 0
Cost Trend Review
Staff Position(s) Required for Deliverable
Estimated Hours Per Role
Hourly Rate Per Role
Total Cost Per Staff Role
1
$ - 0
2
$ - 0
3
$ - 0
4
$ - 0
5
$ - 0
6
$ - 0
Total Cost of Deliverable (without expenses)
$ - 0
Pharmacy Market Check
Staff Position(s) Required for Deliverable
Estimated Hours Per Role
Hourly Rate Per Role
Total Cost Per Staff Role
1
$ - 0
2
$ - 0
3
$ - 0
4
$ - 0
5
$ - 0
6
$ - 0
Total Cost of Deliverable (without expenses)
$ - 0
Compliance Support
Staff Position(s) Required for Deliverable
Estimated Hours Per Role
Hourly Rate Per Role
Total Cost Per Staff Role
1
$ - 0
2
$ - 0
3
$ - 0
4
$ - 0
5
$ - 0
6
$ - 0
Total Cost of Deliverable (without expenses)
$ - 0
MHPAEA Assessment
Staff Position(s) Required for Deliverable
Estimated Hours Per Role
Hourly Rate Per Role
Total Cost Per Staff Role
1
$ - 0
2
$ - 0
3
$ - 0
4
$ - 0
5
$ - 0
6
$ - 0
Total Cost of Deliverable (without expenses)
$ - 0
Year 2 2028 Totals
Audit Projects
Pharmacy Commercial Audit
$ - 0
Pharmacy EGWP Audit
$ - 0
Vision Audit (3 plan years)
$ - 0
FSA Audit
$ - 0
Disability Plan Audit
$ - 0
Other Projects
HMO Renewal Analysis and Negotiations
$ - 0
HDHP and PPO Pricing
$ - 0
Cost Trend Review
$ - 0
Pharmacy Market Check
$ - 0
Compliance Support
$ - 0
MHPAEA Assessment
$ - 0
Total
$ - 0
Year 3 2029
Estimated Planned Project list:
Year 3 – 2029
Audit Projects
Medical Plan Audit (SHP and HDHP)
Staff Position(s) Required for Deliverable
Estimated Hours Per Role
Hourly Rate Per Role
Total Cost Per Staff Role
1
$ - 0
2
$ - 0
3
$ - 0
4
$ - 0
5
$ - 0
6
$ - 0
Total Cost of Deliverable (without expenses)
$ - 0
Medical Plan Audit (Medicare Advantage)
Staff Position(s) Required for Deliverable
Estimated Hours Per Role
Hourly Rate Per Role
Total Cost Per Staff Role
1
$ - 0
2
$ - 0
3
$ - 0
4
$ - 0
5
$ - 0
6
$ - 0
Total Cost of Deliverable (without expenses)
$ - 0
Pharmacy Commercial Audit
Staff Position(s) Required for Deliverable
Estimated Hours Per Role
Hourly Rate Per Role
Total Cost Per Staff Role
1
$ - 0
2
$ - 0
3
$ - 0
4
$ - 0
5
$ - 0
6
$ - 0
Total Cost of Deliverable (without expenses)
$ - 0
Pharmacy EGWP Audit
Staff Position(s) Required for Deliverable
Estimated Hours Per Role
Hourly Rate Per Role
Total Cost Per Staff Role
1
$ - 0
2
$ - 0
3
$ - 0
4
$ - 0
5
$ - 0
6
$ - 0
Total Cost of Deliverable (without expenses)
$ - 0
Dental Plan Audit
Staff Position(s) Required for Deliverable
Estimated Hours Per Role
Hourly Rate Per Role
Total Cost Per Staff Role
1
$ - 0
2
$ - 0
3
$ - 0
4
$ - 0
5
$ - 0
6
$ - 0
Total Cost of Deliverable (without expenses)
$ - 0
Life Insurance Plan Audit
Staff Position(s) Required for Deliverable
Estimated Hours Per Role
Hourly Rate Per Role
Total Cost Per Staff Role
1
$ - 0
2
$ - 0
3
$ - 0
4
$ - 0
5
$ - 0
6
$ - 0
Total Cost of Deliverable (without expenses)
$ - 0
Other Projects
HMO Renewal Analysis and Negotiations
Staff Position(s) Required for Deliverable
Estimated Hours Per Role
Hourly Rate Per Role
Total Cost Per Staff Role
1
$ - 0
2
$ - 0
3
$ - 0
4
$ - 0
5
$ - 0
6
$ - 0
Total Cost of Deliverable (without expenses)
$ - 0
HDHP and PPO Rate Development and Actuarial Value Analysis
Staff Position(s) Required for Deliverable
Estimated Hours Per Role
Hourly Rate Per Role
Total Cost Per Staff Role
1
$ - 0
2
$ - 0
3
$ - 0
4
$ - 0
5
$ - 0
6
$ - 0
Total Cost of Deliverable (without expenses)
$ - 0
Cost Trend Review
Staff Position(s) Required for Deliverable
Estimated Hours Per Role
Hourly Rate Per Role
Total Cost Per Staff Role
1
$ - 0
2
$ - 0
3
$ - 0
4
$ - 0
5
$ - 0
6
$ - 0
Total Cost of Deliverable (without expenses)
$ - 0
Compliance Support
Staff Position(s) Required for Deliverable
Estimated Hours Per Role
Hourly Rate Per Role
Total Cost Per Staff Role
1
$ - 0
2
$ - 0
3
$ - 0
4
$ - 0
5
$ - 0
6
$ - 0
Total Cost of Deliverable (without expenses)
$ - 0
MHPAEA Assessment
Staff Position(s) Required for Deliverable
Estimated Hours Per Role
Hourly Rate Per Role
Total Cost Per Staff Role
1
$ - 0
2
$ - 0
3
$ - 0
4
$ - 0
5
$ - 0
6
$ - 0
Total Cost of Deliverable (without expenses)
$ - 0
Year 3 2029 Totals
Audit Projects
Medical Plan Audit (SHP and HDHP)
$ - 0
Medical Plan Audit (Medicare Advantage)
$ - 0
Pharmacy Commercial Audit
$ - 0
Pharmacy EGWP Audit
$ - 0
Dental Plan Audit
$ - 0
Life Insurance Plan Audit
$ - 0
Other Projects
HMO Renewal Analysis and Negotiations
$ - 0
HDHP and PPO Rate Development and Actuarial Value Analysis
$ - 0
Cost Trend Review
$ - 0
Compliance Support
$ - 0
MHPAEA Assessment
$ - 0
Total
$ - 0
File details come from the government source that posted it.
Updated .