Dylan’s BI Study Notes

My notes about Business Intelligence, Data Warehousing, OLAP, and Master Data Management

ABC Analysis in Inventory Management

Posted by Dylan Wan on March 11, 2008

 I did some study on the ABC Analysis in Inventory Management.  It is also useful in business analytics.  I will cover what it is and how it is supported in various ERPs. Finally, how it may be used in analytics application.

What is ABC Analysis in Inventory Management?

Here is the link to the definition in wikipedia – ABC analysis.

Some people may confuse this with activity based costing, which is also called ABC. However, in the inventory management area, ABC analysis refers to categorizing the stock according to their cost and quantity.

Not all stock is equally valuable and therefore doesn’t require the same management focus. The results of the ABC analysis provide information that helps evaluate how each inventory part should be monitored and controlled. [1]

ABC category for an inventory item is derived based on its cost and quantity. You cannot say that an item is always a class A item or a class B item. The category of an inventory item can change over time. An inventory management system should be able to based on the information available and periodically update the ABC assignment.

ABC Analysis in ERP

ABC Analysis is provided in the Inventory Management module of major ERPs:

1. J.D. Edwards can generate an ABC Analysis report based on an item’s total sales, gross margin, or on-hand value. The ABC Analysis report ranks inventory items with a letter grade of A, B, or C (where A represents the items with highest total sales, largest gross margin, or largest on-hand value). You can also use different ranking percentages in each category. For example, the system could rank Item A based on percentage of sales and Item C based on gross margin.

2. Oracle E-Business Suite support the ABC Analysis. You can run the ABC Compile process for an Inventory organization or for a subinventory. It supports multiple Compile Criterions, such as Current on–hand Quantity, Current on–hand value, Historical usage value, Forecasted usage value, etc. The result can be used to drive the cycle counts, where you might count items of high value (A items) very
frequently, items of lower value less frequently, and items of lowest value very infrequently.

3. PeopleSoft supports ABC analysis via its Utilization Types.  A “Utilization Type” is an ABC category.  It also supports multiple “Calculation Rule”: On Hand Quantity, On Hand Amount, Forecasted Amount, Forecasted Quantity, Historical # of Transactions, Historical Usage Amount, Lead Time (Days), etc. The Utilization Type Calculation process assigns each item to the utilization type that it meets.

ABC Analysis in BI

TBD

Reference

[1] How to carry out an ABC analysis of inventory

[2] JD Edwards EnterpriseOne Inventory Management Implementation Guide

[3] Oracle Inventory User Guide release 11i

[4] PeopleSoft Inventory 8.8 PeopleBook

About these ads

10 Responses to “ABC Analysis in Inventory Management”

  1. [...] cycle counts. Others prefer to count more valuable items with greater frequency, classed into prioritized levels, based on the Pareto principle. The idea behind this is that the most expensive items can account [...]

  2. I think I did a post on ABC Analysis a while back on my blog

  3. [...]  I did some study on the ABC Analysis in Inventory Management.  It is also useful in business analytics.  I will cover what it is and how it is supported in various ERPs. Finally, how it may be used in analytics application. What is ABC Analysis in Inventory Management? Here is the link to the definition [...] Dylan’s BI Study Notes [...]

  4. Rick Otton said

    Rick Otton…

    [...]ABC Analysis in Inventory Management « Dylan’s BI Study Notes[...]…

  5. home based business online business arts & crafts health & fitness…

    [...]ABC Analysis in Inventory Management « Dylan’s BI Study Notes[...]…

  6. Dresses to Wear to a Wedding as a Guest,Dresses to Wear to a Wedding…

    [...]ABC Analysis in Inventory Management « Dylan’s BI Study Notes[...]…

  7. rédacteur web…

    [...]ABC Analysis in Inventory Management « Dylan’s BI Study Notes[...]…

  8. time management…

    [...]ABC Analysis in Inventory Management « Dylan’s BI Study Notes[...]…

  9. Cycle Counting - How to Avoid Year-End Physical Inventory : PathGuide Technologies said

    […] cycle counts. Others prefer to count more valuable items with greater frequency, classed into prioritized levels, based on the Pareto principle. The idea behind this is that the most expensive items can account […]

  10. seo company orlando

    ABC Analysis in Inventory Management « Dylan’s BI Study Notes

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
Follow

Get every new post delivered to your Inbox.

Join 35 other followers

%d bloggers like this: