Running the Inventory GMROI by Price Class Report

Use the Inventory GMROI by Price Class Report to evaluate your return on investment as it relates to your price classes. This report helps you determine how well your price classes are working.

A price class is the mechanism used to assign a group of similar customers to a pricing column in the pricing matrix in order to offer them the same price basis and formula for the majority of the items they buy.

For more information about how the system calculates this report, see How the System Calculates Gross Margin Return On Investment (GMROI).

To run the Inventory GMROI by Price Class Report:

From the Reports > End of Month Reports #2 > GMROI Reports menu, select Inventory GMROI by Price Class Report to display the Inventory GMROI by Price Class Report window.

In the Line Type field, identify whether to run the report for price lines or buy lines. Based on your selection, the system populates the selections in the Price Line / Buy Line field accordingly. The default is Price Line.
In the Price Line / Buy Line field, do one of the following:

To run the report for one price line/buy line, enter the price line/buy line ID.
To run the report for all price lines/buy lines, leave the field blank.
To run the report for multiple price lines/buy lines, click the Multiple button and enter the ID of each price line/buy line to include in the report and click OK. *Multi* displays in the Price Line / Buy Line field.

In the Branch(es) field, enter a branch, branches, or territories to include in the report. To include all branches and territories for the buyer, enter ALL.
Change the dates in the Start Date and End Date fields, as needed, to encompass a 365-day period for the current fiscal year.

By default the system populates the Start Date field with the first day of the current fiscal year as the start date and the current date as the end date. These fields also support variable dates.

In the Summary/Detail field, enter one of the following to determine the report level of detail:

Summary - Produces GMROI totals at the product line level, without product descriptions.
Detail - Includes product descriptions and totals for each product.

In the Cost Basis field, select the Global Basis code to use to calculate the values for the Cost and Avg $OnHand columns of the report. The default value is Cost of Goods Sold (COGS-COST).

If you select the Avg Cost option, the value in the Cost column is calculated by dividing the amount in the Actual COGS$ column of the report by the number of orders. The value in the Actual COGS$ column is calculated using the actual cost of goods on the order.

Set options, if needed, and generate the report.

If you use the Print or Hold menu options, depending on your authorization level, the system may prompt you to choose whether to view generic (commission) costs, cost of goods sold, or no costs on the report. Select an option to run the report.

Inventory GMROI by Price Class Report Data

The Inventory GMROI by Price Class Report lists the following fields and columns of information:

Field/Column	Description
Class Rank	The rank, if any, applied to the price class for this report.
Actual UnSls	Actual unit sales for the specified time frame. If the period is run for less than a year, the sales are annualized.
Avg QOH	Average quantity on hand.
Cost UM	Cost per unit of measure for the line item.
Actual GP$	Actual gross profit dollars for the time frame selected.
Actual Sales$	Actual sales dollars for the time frame selected.
Actual COMM$	Actual commission dollars applied for the time frame selected.
Annual GP$	Annual gross profit dollars for the price lines selected.
Annual COMM$	Annual commission dollars for the price line selected.
Avg $OnHand	Average cost multiplied by average quantity on hand. Avg Cost x Avg QOH
Turns	The number of times the product moves through your warehouse in a year based on demand and average on hand. Turns = (365 x annualized demand / day) / average on hand
Avg MU%	Average markup. The average percentage markup on the products sold for the indicated price line.
GMROI	The calculated gross margin return on investment. For more information about this is calculated, see How the System Calculates Gross Margin Return On Investment (GMROI) in this documentation.
Adjusted Margin%	The percentage of gross margin including the carrying cost for the price line.