The Edge
Increase Your Bottom Line and Profitably Manage Your Inventory with The Edge
WHAT IT IS
The Replenish Current Inventory report shows categories that performed reasonably well and might make good areas for in which you might consider investing.
WHAT IT DOES
Use this report in concert with the Replenish Base Stock report found in the Inventory Buying Tools feature to make smart choices when investing in inventory.
HOW IT WORKS
To run this report:
-
Click Reports → Inventory → Replenish Current Inventory. The Replenish Current Inventory Report window will appear.
-
Enter your desired search criteria and click OK to generate your report.
Data fields in the Replenish Current Inventory report include:
-
Cost Range: The cost range to which the data is categorized.
-
% 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 for each item included in the number sold.
-
ANOH: Average number on hand during that time period.
-
#End: Number of items remaining on hand.
-
ADOH: Average days in stock. Average number of days that unsold items are in inventory.
-
Retail: The total retail value.
-
COGS: Cost of goods sold.
-
%Mgn: 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 cost of inventory. In this case, it is the average cost of each item included in the number sold.
-
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.
- Click Reports → Inventory → Replenish Current Inventory. The Replenish Current Inventory Report window will appear.
- Enter your desired search criteria and click OK to generate your report.
- Cost Range: The cost range to which the data is categorized.
- % 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 for each item included in the number sold.
- ANOH: Average number on hand during that time period.
- #End: Number of items remaining on hand.
- ADOH: Average days in stock. Average number of days that unsold items are in inventory.
- Retail: The total retail value.
- COGS: Cost of goods sold.
- %Mgn: 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 cost of inventory. In this case, it is the average cost of each item included in the number sold.
- 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.
EXPAND YOUR EDGE EDUCATION
Click below to learn more about this important inventory report, or visit EdgeUser.com and search “Replenish Current Inventory.” You can also refresh your knowledge on Inventory Buying Tools, found under the Inventory section of the site.
