Inventory Management (Abc-Xyz-Ved-Fsn)
Inventory Analysis
Inventory analysis is done at regular intervals to support decision making. Inventory analysis basically helps inventory manager to take necessary steps to protect their valuable items. There are many analysis techniques that are used but some of the important techniques are mentioned here.
- ABC Analysis
- XYZ Analysis
- FSN Analysis
- VED Analysis
ABC Analysis
ABC Analysis helps in the classification of the Items on the basis of their Consumption values in a given period. This analysis in Inventory can be done for specified financial period/s or for a range of dates as specified by the user. Analysis can be done on a selective manner on the basis of the Item types or the Group types. It is possible to do this analysis for a particular Warehouse in a location or for all the Warehouses in the location
The consumption value of the items over the specified period for which Analysis is to be done is calculated on the basis of the Receipts, Returns and Adjustments made during that time. The consumption value for items are then put in descending order of their values and the percentage of total consumption value for each item calculated.
Usually the first 70% of the total consumption value in the specified period corresponds to A Class, the next 20% are of B Class and the last 10% of the value corresponds to the C Class. Part # | Consumption Qty | Unit Cost | Cons. Value | Role in Total Cons. In % | Cum. % | Class | Remarks | P3 | 400 | 20 | 8000 | 37.12 | 37.12 | A | up to 70 i.e. from 1 to 70% range | P1 | 300 | 20 | 6000 | 27.84 | 64.97 | A | up to 70 | P6 | 200 | 10 | 2000 | 9.28 | 74.25 | B | up to 20% i.e. from 70 to 90% range | P8 | 100 | 15 | 1500 | 6.96 | 81.21 | B | up to 20 | P5 | 200 | 5 | 1000 | 4.64 | 85.85 | B | up to 20 | P7 | 200 | 4 | 800 | 3.71 | 89.56 | B | up to 20 | P2 | 150 | 5 | 750 | 3.48 |
Inventory analysis is done at regular intervals to support decision making. Inventory analysis basically helps inventory manager to take necessary steps to protect their valuable items. There are many analysis techniques that are used but some of the important techniques are mentioned here.
- ABC Analysis
- XYZ Analysis
- FSN Analysis
- VED Analysis
ABC Analysis
ABC Analysis helps in the classification of the Items on the basis of their Consumption values in a given period. This analysis in Inventory can be done for specified financial period/s or for a range of dates as specified by the user. Analysis can be done on a selective manner on the basis of the Item types or the Group types. It is possible to do this analysis for a particular Warehouse in a location or for all the Warehouses in the location
The consumption value of the items over the specified period for which Analysis is to be done is calculated on the basis of the Receipts, Returns and Adjustments made during that time. The consumption value for items are then put in descending order of their values and the percentage of total consumption value for each item calculated.
Usually the first 70% of the total consumption value in the specified period corresponds to A Class, the next 20% are of B Class and the last 10% of the value corresponds to the C Class. Part # | Consumption Qty | Unit Cost | Cons. Value | Role in Total Cons. In % | Cum. % | Class | Remarks | P3 | 400 | 20 | 8000 | 37.12 | 37.12 | A | up to 70 i.e. from 1 to 70% range | P1 | 300 | 20 | 6000 | 27.84 | 64.97 | A | up to 70 | P6 | 200 | 10 | 2000 | 9.28 | 74.25 | B | up to 20% i.e. from 70 to 90% range | P8 | 100 | 15 | 1500 | 6.96 | 81.21 | B | up to 20 | P5 | 200 | 5 | 1000 | 4.64 | 85.85 | B | up to 20 | P7 | 200 | 4 | 800 | 3.71 | 89.56 | B | up to 20 | P2 | 150 | 5 | 750 | 3.48 |