Monthly Indirect Rebate Rate Report – MMIS

In the Gross to Net Historical module, there is a report available called the Monthly Indirect Rebate Rate Report. This report can be found within the Gross to Net tab under the Reporting menu.

To run this report, the user must first select the applicable accrual period to view the rates for. The accrual period filter must be entered YYYY MM format.

There are also filters available for customer (vendor) and product if the user wishes to narrow down the results of the report further.

Once you have selected the applicable filters, click on GO to run the report.

The results will list out the indirect rebate accrual rates calculated for the accrual month selected by wholesaler and product.

In this main summary screen the following fields are available:

WAC Price: The WAC or invoice price for this wholesaler effective on the last day of the accrual period chosen.
Units Sold Through: This value represents the total indirect sales units for this wholesaler and product based on the product lookback chosen. For more information on the product lookbacks, click HERE.
Weighted Average Price: the sum of the weighted average contract prices for the indirect contracts included in the product lookback data.
Weighted Average Rebate: the sum of the weighted average rebate amounts for the indirect contracts included in the product lookback data.
Weighted Average Rebate Rate: Weighted Average Rebate / WAC Price

To view the further details of how these rates were calculated, click on the Details hyperlink next to the record.

This will bring you into the contract details drill down screen.

In this screen, we display the details used in calculating the Weighted Average Indirect Rebate Rate at the indirect contract level.

In this drill down screen the following fields are available:

Contract Price: Indirect contract price effective on last day of accrual period chosen.
Units Sold Thru: This value represents the contract specific indirect sales units for this wholesaler and product based on the product lookback chosen.
Weighting of Units: Contract Specific Units Sold Thru / Total Units Sold Thru
Various Rebate Type Headers - IE Admin Fee: These columns display the rebate percentages applicable per each indirect contract by rebate type.
Dollar Derived: For any rebates set up as per unit amounts, we convert those amounts into a percentage based on contract price.
Total Rebates: Sum of percentages from all rebate types.
Total Rebate Per Unit: Total Rebates * Contract Price
Weighted Average Rebate: Total Rebate Per Unit * Weighting of Units
Weighted Average Rebate Rate: Weighted Average Rebate / WAC Price

Related to