Inventory Turns Report providing Turn Ratio by Inventory Code (Copier, Printer, Accessory, etc.) along with Total COGS, Average Monthly Value as well as Quantity on Hand.
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+
Run Schedule: No emails generated, OnDemand Report Only
Type of Output: OnDemand SSRS Report
* * *
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.
* * *
This alert has no variables
* * *
1. Report refreshes first Sunday of each month ONLY
2. Most recent Fiscal Period shown is the last period closed in eAuto. If you expect it to be more recent, then please check with your Accounting Department as to why fiscal period needed is not closed out.
3. 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.
4. A low turnover ratio implies weak sales and, therefore, excess inventory. A high ratio implies either strong sales and/or large discounts.
5. The report ignores drop ship and fixed asset warehouses.
6. 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.)
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:
Since we use 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).
* * *
OnDemand Report Filters
Most recent Fiscal Period shown is the last period closed in eAuto. If you expect it to be more recent, then please check with your Accounting Department as to why fiscal period needed is not closed out.
* * *
Best Practices & Tips
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"):
Report breaks down your Inventory Turns for each Inventory Code in eAuto:
* * *
ID759/Inventory Items With Conflicting Accounts - This process will ensure your Sales and Service codes are not tied back to conflicting GL revenue and COG accounts. Items should have matching revenue GL and COG accounts regardless of the process that is used to relieve inventory.
* * *