In the tabular version of the report, data fields include:
Category or Vendor
|
The category or vendor by which the items are being grouped. This column type will vary depending on the type of report generated.
|
Cost Range
|
Each category or vendor can be further broken down by price ranges.
|
% Total
|
What percentage of total sales this category or vendor and price point accounts for. It is calculated based on the selling price.
|
# Sold
|
The total number of items in that grouping sold.
|
ADTS
|
Average days to sell. Of the items sold in this line, the number of days, on average, it took for them to sell.
|
ARS
|
Average retail sale.
|
ANOH
|
Average number on hand.
|
#End
|
Number of items remaining on hand.
|
ADOH
|
Average days in stock. Average number of days that unsold items are in inventory.
|
Retail
|
The retail price of the items that sold.
|
Profit
|
The net profit of the sales from that grouping.
|
% Margin
|
The profit margin based on the items that sold.
|
% Mkdn
|
The discount that was taken at point of sale marked down from retail.
|
ACOI
|
The average value of inventory during the period.
|
GROI
|
The gross return on investment for that grouping. If the value is above 150%, it will appear highlighted in green.
|
TROI
|
The true return on investment for that grouping. This figure takes into account the full amount of time the item was in stock during the reporting period.
|
Turn
|
Number of times that inventory investment turned at cost of goods sold.
|