RFP 250000002730 Schedule B2 Pricing - EBD.xlsx

XLSX spreadsheet 28 KB Posted Jul 29, 2025

Attached to: ORS & EBD Healthcare Actuarial, Underwriting and Planning
Solicitation number: RFP-171-250000002730-2
Issued by: Grand Traverse County, Michigan

About this file

Written by GovTribe AI · Aug 1, 2025

This document is a detailed pricing schedule (RFP 250000002730 Schedule B2) for an Enterprise Benefits and Design (EBD) contract covering a three-year period from 2027-2029. The pricing spreadsheet outlines a comprehensive set of audit and project services for health and insurance-related activities, including medical plan audits (standard health plans, high-deductible health plans, and Medicare Advantage), pharmacy audits (commercial, EGWP, and implementation), dental plan audits, life insurance plan audits, vision audits, and flexible spending account (FSA) audits. Additional projects include HMO renewal analysis, rate development, cost trend reviews, behavioral health/substance use disorder (BH/SUD) RFP support, compliance support, and Mental Health Parity and Addiction Equity Act (MHPAEA) assessments.

The pricing template is structured to allow bidders to detail hourly labor rates for up to 11 staff roles across three contract years, with placeholders for estimated hours, hourly rates, and total costs per deliverable. Despite the comprehensive nature of the document, no actual rates or cost figures have been filled in, suggesting this is a template for potential bidders to complete. The document covers a wide range of health and benefits-related consulting services, indicating a complex, multi-year engagement with extensive project scope and potential for detailed cost customization based on the specific staffing and hours required for each project type.

View the file

Other files

File	Type	Posted
RFP 250000002730 Schedule B1 Pricing - (ORS).xlsx	XLSX spreadsheet	Jul 29, 2025
RFP 250000002730 Schedule C - Insurance Requirements.docx	DOCX document	Jul 29, 2025
RFP 250000002730 Schedule F2 - HIPAA Business Associate Agreement (BAA) (EBD).docx	DOCX document	Jul 29, 2025
RFP 250000002730 Schedule G Contractor Performance Evaluation Survey - ORS.docx	DOCX document	Jul 29, 2025
RFP 250000002730 Schedule F1 - HIPAA Business Associate Agreement (BAA) (ORS).docx	DOCX document	Jul 29, 2025
RFP 250000002730 Schedule A1 - Healthcare Actuary and Consulting (ORS).docx	DOCX document	Jul 29, 2025
RFP 250000002730 Terms + Conditions & Schedule E.docx	DOCX document	Jul 29, 2025
RFP 250000002730 Schedule A2 - Healthcare Actuary and Consulting (MCSC).docx	DOCX document	Jul 29, 2025
RFP 250000002730 Proposal Instructions - CT Forms - Vendor Questions Worksheet.docx	DOCX document	Jul 29, 2025

On GovTribe

Work with this file

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

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 Aug 1, 2025.