Total Revenue Disclosure Statement_Blank.xlsx

XLSX spreadsheet 47 KB Posted

Attached to
RFP for Medical & Pharmacy Benefits
Solicitation number
S-44300-00014758
Issued by
Marion County, Oregon

About this file

This is a Total Revenue Disclosure Statement template designed for health plan vendors responding to the Oregon Public Employees' Benefit Board (PEBB) RFP for medical and pharmacy benefits services. The document requires vendors to provide comprehensive disclosure of all variable revenue sources generated through their relationship with PEBB, including both retrospective actual data from incumbent carriers and prospective estimates from non-incumbent bidders. Variable fees must be itemized by program type, including out-of-network savings programs, non-contracted provider savings, subrogation, payment integrity programs, medical pharmacy specialty rebates, network access fees, and other fee categories. The disclosure captures per-member-per-month (PEPM) pricing, fee percentages, per-claim fees, claims experience data, and savings metrics. The template requires vendors to specify whether fees flow through invoice or claims wire mechanisms and whether fees are included in the total capped rate offered. All revenue generated at the company or parent company level, as well as amounts paid to third-party administrators for program administration, must be disclosed.

The statement mandates complete transparency regarding all revenue streams and explicitly reserves the client's right to audit any component of the disclosure. Vendors must provide clarifying comments, identify any revenue sources that cannot be disclosed with justification, and detail data limitations impacting projections. The form includes specific footnotes regarding how fees should be calculated, with savings based on eligible billed minus allowed charges for most programs, and requires an authorized company representative to verify accuracy and attest that the disclosure reflects all variable revenue sources. This comprehensive revenue disclosure mechanism is designed to enable PEBB to make fully informed vendor comparisons and ensure competitive pricing and transparency in the medical benefits procurement process.

View the file

Other files

File Type Posted
AttachB_Definitions.pdf PDF
AttachE_COBID.pdf PDF
PEBB Medical_Rx_MainRFP_clean.pdf PDF
AttachA_Questionnaire.pdf PDF
Attachment V - Detailed Weight Component Info.pdf PDF
AttachI_SampleGrpBenCon_MedRx.pdf PDF
AttachI_SampleGrpBenefitsCon_Rx_v4.pdf PDF
AttachK_Point Solutions Guidelines.pdf PDF
AttachG_FinalSubForm_v2.pdf PDF
Attachment M_Medical Claims Data_clean.xlsx XLSX spreadsheet
AttachI_SampleGrpBenCon_MedOnly.pdf PDF
Attachment N_Provider Disruption Data_clean.xlsx XLSX spreadsheet
AddendumFive_clean.pdf PDF
AttachC_PlanDesigns.pdf PDF
Attachment L_Census Data_clean.xlsx XLSX spreadsheet
AttachF_RespInquiry.pdf PDF
AddendumSix_Final.pdf PDF
AttachI_SampleGrpBenCon_MedOnly_v3.pdf PDF
Oregon PEBB 2025 Medical and Pharmacy RFP_20251111.pdf PDF
Oregon PEBB 2025 Medical and Pharmacy RFP_20251016PT.pdf PDF
Attachment A_10032025.pdf PDF
Attachment N_Provider Disruption Data updated.xlsx XLSX spreadsheet
Amendment 001 - RFI PAD MOUNT XFMR 2025.pdf PDF
Attachment Q_Pharmacy Clinical Programs.xlsx XLSX spreadsheet
Attachment S_Pharmacy Data Tables.xlsx XLSX spreadsheet
AddendumTwo.pdf PDF
AttachB_Definitions_v2.pdf PDF
Oregon PEBB 2025 Medical and Pharmacy RFP_20251015.pdf PDF
AddendumFour~1.pdf PDF
Attachment T_Pharmacy Pricing Terms_10132025.xlsx XLSX spreadsheet
AttachI_SampleGrpBenCon_MedRx_v3.pdf PDF
Attachment U_Pharmacy Claims Data.xlsx XLSX spreadsheet
AttachI_SampleGrpBenCon_MedRx_v2.pdf PDF
AttachG_FinalSubForm.pdf PDF
Attachment R_Pharmacy GeoAccess Analysis Template.xlsx XLSX spreadsheet
AddendumThree_20251015_clean.pdf PDF
Attachment P_Pharmacy Plan Design Summary.xlsx XLSX spreadsheet
AttachI_SampleGrpBenCon_MedOnly_v2.pdf PDF
MainRfp_UpdatedByAddenda1-2_20250917.pdf PDF
MainRfp_UpdatedByAddenda1-3_20251015~1.pdf PDF
AddendumOne~1.pdf PDF
Attachment T_Pharmacy Pricing Terms.xlsx XLSX spreadsheet
Attachment O_Provider Discount Data_clean.xlsx XLSX spreadsheet
MainRfp_UpdatedByAddenda1-6_Final.pdf PDF
Attachment S_Pharmacy Data Tables_10132025.xlsx XLSX spreadsheet
AttachI_SampleGrpBenefitsCon_Rx_v3.pdf PDF
Attachment J_Data Warehouse File Layout_clean.xlsx XLSX spreadsheet
GeoAccess Standards for Out of State Providers.xlsx XLSX spreadsheet
AttachI_SampleGrpBenefitsCon_Rx.pdf PDF
Attachment W_Pharmacy Claims Data Layout.xlsx XLSX spreadsheet
Show 40 more

Latest 50 of 54 listed here. See the rest on GovTribe.

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

TRDS

CONFIDENTIAL MATERIAL INTENDED ONLY FOR MERCER, CLIENT, & RESPONDING CARRIER
Total Revenue Disclosure Statement

Health Plan Vendor Name:

Disclosure type: Retrospective (Actual) / Prospective (Estimated) Retrospective

Employer Group Name:

Effective Period: Start End

Plan Name(s) For Which Disclosure Applies:

Enrolled subscribers:

Average Contract Size:

This statement is intended to capture the full and complete variable revenue as pertaining to this group's relationship with you, the carrier. The carrier represents that the information provided below reflects an accurate and complete picture of all revenue sources.

Note that members with Medicare coverage should be captured on a separate statements vs. actives.

For purposes of this disclosure:

• Variable Fees represent amounts charged by programs where fees are dependent on the level of savings.

• Other Fees will capture revenue outside of variable fees which are not part of fixed fees captured separately (see below for more details).

As you complete this Revenue Disclosure, please be mindful of the following expectations.

• Actuals should be completed if you are the current carrier for this employer and are asked to complete a retrospective lookback of variable fees. Estimates should be provided for non-incumbents in RFP situations, and for prospective requests for current employer groups.

• For new business opportunities, estimates of variable fees should reflect best estimates based on information available from the client and your book of business. There is an understanding that these fees will vary from actual experience.

• Should terms vary by plan, please complete a Total Revenue Disclosure for each of the client’s plans (for all coverages included in the fees - e.g. medical and behavioral)

• This Revenue Disclosure contemplates the medical plan only (e.g. PBM, dental, and other coverages are outside of this scope). All revenue generated at either your company or your parent level (as applicable), as well as amounts paid to a 3rd party who is charged with administering programs is required to be disclosed herein.

• The 'Other' category is intended to capture any items that are part of your Total Revenue but fall outside named categories, such as specialty drug rebates coming through the medical plan.

• Pass through of claims expenses can be excluded unless carrier will retain a portion of these revenues. However, if there are fees, charges, or other mechanisms that represent an incremental net revenue (or possibility thereof), such disclosure is required. An example of this might be any spread pricing, such as what you the carrier charges the client on a capitated basis (higher) as compared to what then gets paid to providers.

• If there are sources of revenue that you are unable or unwilling to disclose, please detail below the nature of the revenue stream and the reason for not disclosing. The client has the right to audit any and all of the components of this disclosure.

• We ask that an authorized representative of the company attest to accuracy of the statement on the signature line below the grid.

VARIABLE FEES
ActualActualActualActualActualActualActualActualActualActualCLARIFYING COMMENTS
Variable Fees % charged by carrierVariable Fees % charged by 3rd party vendor
(if not included by carrier)Per Claim Fee Caps
(if applicable, excluding Aggregate)Revenue as a PEPM1, 2
(including vendor revenue)Savings as a PEPM3Program Level Variable Fee Cap Offered (PEPM)Did Fee Come Through Invoice or Claim Wire?Was Fee Included in 'Total Capped Rate Offered' below? (Y/N)
Programs/ServicesAssumed enrollmentPEPMBook of Business Average PEPMPEPMBook of Business Average PEPMDid Fee Come Through Invoice or Claim Wire?Was Fee Included in 'Total Capped Rate Offered' below? (Y/N)
Out of Network

Please provide for each program that falls within category

example: Proprietary Program Name #12,50030%10.00%$300,000$25.00$25.00$43.00$43.00$120.00Claims WireY
Non-Contracted Provider Savings Program0
Traditional Network Savings Program0
0
0
0
0
0
0
0
0
0
0
Subrogation

Please provide for each program that falls within category

Subrogation0
0
0
0
0
0
0
0
0
0
0
0
Payment Integrity

(e.g. Bill Review, Audits, etc.)

Please provide for each program that falls within category

Program Integrity Aligned Incentive Program0
0
0
0
0
0
0
0
0
0
0
0
Other Variable Fees (% of X)

Please provide for each program that falls within category

Medical Pharmacy Specialty Rebates0
Network Access Fees0
Fees embedded in capitation rates0
Discount Share0
Qualifying Payment Amount Shared Savings Fee0
Enhanced Personal Health Care (EPHC) program administration0
Clinical Program Claim Related Charges0
Interplan Fees0
0
0
0
0
0
0
0
0
0
0
0
0
TOTAL VARIABLE REVENUE$0.00$0.00$0.00$0.00$0.00

Total Capped Rate Offered (PEPM, across all revenue sources - both fixed + variable) (if applicable)

Additional Questions:ActualCarrier Specific Footnotes
1. Anthem fees are reported on a paid basis.
1. For the out-of-network programs that you have highlighted above, please confirm the percentage of total claims estimated to be out-of-network.2. Reporting should reflect fees after any fee caps have been applied
3. Savings is calculated based on eligible billed minus allowed charges, except for payment integrity which is based on the amount the Employer would have been charged absent prepayment analysis activities (rather than billed)
2. Across all out-of-network claims, what is the estimated (or actual) discount percentage?

3. For programs where you are estimating a range of variable fees, please explain how you calculate client-specific estimates. This response can include but is not limited to how you leverage book of business information, client-specific information like demographics, geography, claims experience, etc. among other factors that play into your calculations.

4. Please describe any other Variable Fee programs not specified above or circumstances where any of the above disclosure does not apply.

Revenue Sources Not Disclosed / Reason For Non-Disclosure
Source #1
Source #2
Source #3
Source #4
Source #5
Data/Information that impacts these projections but was not available are:
Item #1
Item #2
Item #3
Item #4
Item #5
VERIFICATION
I am an authorized representative of the Company, have reviewed the above, and ensured that it fairly reflects all variable revenue sources (unless otherwise disclosed above) that will be generated as a result of our relationship with XYZ. Any contracts issued shall conform to this document unless the Company clearly identifies any deviations and such deviations are mutually agreed between Company and XYZ. In instances where we have provided estimates, they reflect our best efforts to quantify the impact, and are consistent with any and all internal financial reporting and accounting.

Name:

Title:

Signature:

Date:

< select one >
Claims WirePEPM
Through InvoicePEPY
Total Annual Amount
Included in Base Fee; carve-out fee known = $___________
Included in Base Fee; no carve-out fee available
Not Applicable

Mercer Health && Benefits LLC Page &P of &N

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