Inventory Management System
Project Report
On
SPARE PARTS INVENTORY MANAGEMENT SYSTEM
Undertaken At
COLGATE PALMOLIVE INDIA LIMITED
EXECUTIVE SUMMARY
The main problem faced by the production & stores is the poor availability of spare parts of various machines. The non-availability often leads to loss in production time.
The objective of the current project is to design a user friendly inventory management system that would minimize stock outs and at the same time help in maintaining optimum inventory levels according to the criticality of the material.
For the identified electrical spares, classification has been done on the basis of criticality. For this, three parameters have been considered viz., lead time, cost and effect on operations. For A category items line wise data has been collected to know the actual installed quantity of each item.
All A category items would be identified with a 10 digit material code (e-code). Also, the manufacturer‟s catalogue number has been mentioned for every item. This catalogue number has been hyperlinked with a soft copy of the specification sheet of the item. This specification sheet has been taken from the website of the manufacturer.
After identifying a preferred make with the item, the discount rates have been negotiated with 13 vendors. The negotiation happened in two stages and the discount rate at the end of second stage has been confirmed. For B & C category items for which e-code is not created a catalogue format has been prepared that is compatible with eBuy.
The consumption for the spares for a period of ten months (Jan 2009 to Oct 2009) has been determined. The inventory policy has been decided on the basis of classification of the material and at the same time due importance was given to the demand and installed quantity of the item. For A & B category items EOQ, (S-1,S) policies have been applied. For C category items the Reorder Quantity is selected in such a way that it would satisfy atleast 6 months demand.
On
SPARE PARTS INVENTORY MANAGEMENT SYSTEM
Undertaken At
COLGATE PALMOLIVE INDIA LIMITED
EXECUTIVE SUMMARY
The main problem faced by the production & stores is the poor availability of spare parts of various machines. The non-availability often leads to loss in production time.
The objective of the current project is to design a user friendly inventory management system that would minimize stock outs and at the same time help in maintaining optimum inventory levels according to the criticality of the material.
For the identified electrical spares, classification has been done on the basis of criticality. For this, three parameters have been considered viz., lead time, cost and effect on operations. For A category items line wise data has been collected to know the actual installed quantity of each item.
All A category items would be identified with a 10 digit material code (e-code). Also, the manufacturer‟s catalogue number has been mentioned for every item. This catalogue number has been hyperlinked with a soft copy of the specification sheet of the item. This specification sheet has been taken from the website of the manufacturer.
After identifying a preferred make with the item, the discount rates have been negotiated with 13 vendors. The negotiation happened in two stages and the discount rate at the end of second stage has been confirmed. For B & C category items for which e-code is not created a catalogue format has been prepared that is compatible with eBuy.
The consumption for the spares for a period of ten months (Jan 2009 to Oct 2009) has been determined. The inventory policy has been decided on the basis of classification of the material and at the same time due importance was given to the demand and installed quantity of the item. For A & B category items EOQ, (S-1,S) policies have been applied. For C category items the Reorder Quantity is selected in such a way that it would satisfy atleast 6 months demand.