Follow

ID806 - Inventory Turns Report Overview & Sample

Currently, eAutomate does not have a report or eView to show inventory turns.

Inventory turnover is a financial ratio that you should be paying close attention to because it indicates the cash efficiency a company enjoys.  Any inventory on your shelf or in your technician's cars is typically the largest place where your cash is tied up.  The higher your turn rate, the lower your risk of inventory loss and/or obsolescence.

The speed with which a company can sell inventory is a critical measure of business performance. It is also one component of the calculation for return on assets (ROA); the other component is profitability. The return a company makes on its assets is a function of how fast it sells inventory at a profit. As such, high turnover means nothing unless the company is making a profit on each sale. This article has a good explanation.

Your turn rate is the number of times per year you sell (turn) your stock. Dealers typically will track 3 primary turn rates: Equipment, Parts & Supplies.

Historically the benchmarks were:

Equipment - 4 to 5
Supplies - 7 to 8
Parts - 2.5+

Although we are seeing new numbers of:

Equipment - 6 to 7
Supplies - 9 to 10
Parts - 4+

Our report uses eAutomate's IC Ledger file system which only includes inventory transaction amounts that affected your inventory value (receipts, issuances, cost adjustments, physical qty adjustments, etc). We chose not to use the GL COGS account for the reasons below:
a) Some dealerships post their mfg rebates/credits directly to their GL COGS for the appropriate rebate (parts, equipment, etc) so that their GP is accurately impacted (while others post those rebates/credits to a revenue account, and still others post those $$ into a standalone GL account.
b) The technical challenge of trying to accurately associate a one-to-one Inventory Asset GL to a particular COGS account become apparent when we ran some tests and found many instances on items where both a sales and service code was applied (Use ID759 to catch these), that the Sales Code GL accounts (REV / COGS) did not align with the Service Code GL accounts. This resulted in the COGS going into different GL Accounts on a sales order than they might for the same item used on a service call. And in some cases, from a P&L perspective that might be by design.


An example of how the Ratio is calculated is best told in a story problem :

Mike has a dealership and his cost of goods sold for the last 12 months running was $1,000,000. Mike’s inventory value at the start of that 12 month period was $3,000,000 and the ending value was $4,000,000. Mike’s turnover ratio is:

ScreenClip.png

Since we uses a 12 month basis, the .29 indicates that Mike only sold approximately 1/3 of his inventory during the year, which implies that mike would need almost 3 years to sell his entire inventory (or complete one turn).

 

******************************************************************************

A low turnover ratio implies weak sales and, therefore, excess inventory.

A high ratio implies either strong sales and/or large discounts.

**Report refreshes first Sunday of each month ONLY**

**Also know that if you subscribe to this report it will not install until after business hours due to the heavy table build required. So you will need to wait until the following day to actually run it.**

Inventory turns are calculated using your inventory value against sales and service usage quantities. Inventory transfers , adjustments, etc are not used to calculate your turns score, only sales order and service call transactions are considered as usage.  The value/cogs calculation takes the total cogs for the previous 12 months, divided by the average monthly inventory value (The report calculates the on hand value for every item for each of the last 12 periods [for the appropriate group summing up by report grouping : inventory code, category, etc], divides that 12 month total by 12 to get your average monthly inventory value.)

The Qty turns is the same basis except using the total 'qty' of items sold over the previous 12 months divided by the average monthly total qty of items for the report grouping (inventory code, category, etc).

The report ignores drop ship and fixed asset warehouses.

Sample:

ID806.PNG

The QTY Turns for previous X months is predicated on how much data we have. Since we have to go back 12 months to get the number for 1 month, you need at least 24 months of being on eAuto to get 12 periods of data. If Qty Turns is for 4 months, for example, that is 16 months of data (12 + 4) as we have to go back 12 months for each period.

To validate the inventory valuation number ("This period Ending Value: $782,564" in the sample above) run the Inventory Valuation report in eAutomate with the following parameters:

1. Run by period

2. Use the Advanced Filter on the Items to filter by the Inventory Code. (In the sample above, the inventory code is "Copiers MFP"):

ID806.jpg

Report breaks down your Inventory Turns for each Inventory Code in eAuto:

Inv_Codes.png

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk