Use the Consigned Inventory GMROI Report to evaluate your return on investment as it relates to your consigned inventory. This report helps you determine how well your consignments are working. The report shows the Gross Margin Return On Investment (GMROI) for all consignment products at a branch or all consignment products for designated customers at a branch.
For more information on how the system calculates this report, see How the System Calculates Gross Margin Return On Investment (GMROI).
From the Reports > End of Month Reports #2 > GMROI Reports menu, select Consigned Inventory GMROI Report to display the Consigned Inventory GMROI Report window.
In the Branch field, enter the number that identifies the branch for which to run the report.
In the Start Date field, enter the first date in a range of dates for which to view invoices. This field supports variable dates.
In the End Date field, enter the last date in the range of dates for which to view invoices. This field supports variable dates.
In the Select by field, select Bill-ToCustomer, Ship-To Customer, Buy Line, Price Line, or Productto limit the report selections. Your selection determines the name of the next field.
In the adjacent field determined by the value in the Select By field, select a value to use to define the subset of transactions for the report's sales analysis. For example, if you select Buy Line in the Select by field, then enter BRU in this field.
To enter multiple values in this field, use the Multi button. If you leave the Select by field blank, this field is not active.
In the Sort by field, select Customer, Buy Line, Price Line, Cust Part #, or Description to limit the report selections.
In the Detail/Summary field, enter one of the following to determine the level of detail for the report:
Detail - Includes product descriptions and totals for each product. This is the default.
Summary - Produces GMROI totals at the product line level, without product descriptions.
In the Cost Basis field, specify the global basis to use as the cost basis for the report. The default value is COGS-COST.
If you use the File >Print or File >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 (COGS), or no costs on the report. Select an option to run the report. The system processes the report.
The Consigned Inventory GMROI Report lists the following fields and columns of information:
|
Field/Column |
Description |
|
Price Line |
The price line selected for the time frame. |
|
Actual GP$ |
Actual gross profit dollars for the time frame selected. |
|
Actual COGS$ |
Actual cost of good sold dollars for the time frame selected. |
|
Annual GP$ |
Annual gross profit dollars for the price lines selected. |
|
Annual COGS$ |
Annual cost of good sold dollars for the time frame 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 |
|
MU% |
The markup percentage on the price line selected. |
|
GMROI |
The gross margin return on investment for the price line selected. |
|
Adjusted Margin% |
The percentage of gross margin including the carrying cost for the price line. |
See Also:
How the System Calculates Adjusted Margin
How the System Calculates Gross Margin Return On Investment (GMROI)