Replenish Current Inventory Report Overview


The Replenish Current Inventory report shows categories that performed reasonably well and might make good areas for in which you might consider investing.  

This report works in concert with the Replenish Base Stock report found in the Inventory Buying Tools feature.

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.

 

Updated on Mon, 07 Jun 2021 by Angela Chiaravalle

Glad we could be helpful. Thanks for the feedback.

Sorry we couldn't be helpful. Your feedback will help us improve this article.

How helpful was this page?