Inventory Management System

Good Essays
Topics: Inventory
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.

You May Also Find These Documents Helpful

  • Powerful Essays

    Inventory Management System

    • 5099 Words
    • 21 Pages

    own.” * Inventory [Donald Reimer (1989)] According to Donald Reimer (1989), “Today, maintaining the right inventory levels is a tough challenge. If not properly managed, your inventory can result in a significant expense. Looking over your shoulder is the lender who is concerned about the cost of carrying too much inventory- which can affect profitability.” * Inventory System [Michael Bernacchi (2002)] According to an author Michael Bernacchi (2002),an inventory systems maintain information…

    • 5099 Words
    • 21 Pages
    Powerful Essays
  • Good Essays

    Inventory Management System By Joann Jones Course CIS/210 Professor Jesse Witherspoon January 18, 2013 The materials needed to help my sister manage her inventory would first to get a retail software package. With a good retail software package it gives you up to the minute reports on what she will have in stock, on order and what is in transit. With the new system it will eliminate the need to guess if she has enough of a popular item or not enough of a particular item. This system will…

    • 867 Words
    • 4 Pages
    Good Essays
  • Good Essays

    TRIBHUVAN UNIVERSITY Office of the dean Faculty of Management Kirtipur Kathmandu An Internship Report on Inventory Management System(IMS) In partial fulfillment of the requirement for the degree of Bachelor in Information Management (BIM) Submitted by: Sumit Lacoul Roll no:1237 T.U Regd No: National College of Computer Studies (NCCS) ACKNOWLEDGEMENT The Internship report is prepared for the partial fulfillment of the requirement of the degree of BIM with prescribed rules…

    • 2025 Words
    • 9 Pages
    Good Essays
  • Better Essays

    businesses have come to rely on computerized inventory management systems. Automated systems can replace the cost and time consuming processes that were once completed by hand while providing companies with more accurate data. Inventory control is important to ensure control in businesses that handle transactions revolving around consumer goods. Without proper inventory control, a store may run out of stock on an important item. A good inventory control system will alert the retailer when it is time to…

    • 973 Words
    • 4 Pages
    Better Essays
  • Good Essays

    Inventory Management System

    • 2609 Words
    • 11 Pages

    MANAGEMENT INFORMATION SYSTEMS (MIS) PROJECT Inventory Management System (MIS) GROUP-B22 DEVINA BHASKAR (082) DILDAR SINGH (083) DIPTO KAR (084) BINAL DOSHI (085) DWIP SEN GUPTA (086) EKTA PODDAR (087)  CONTENTS O OBJECTIVE O WHAT IS INVENTORY MANAGEMENT? O APPROACH  BUSINESS PROBLEM  SYSTEM INVESTIGATION  SYSTEM ANALYSIS  SYSTEM DESIGN  SYSTEM IMPLEMENTATION  SYSTEM MAINTENANCE O FUNCTIONING OF THE SYSTEM O END USERS O FUNCTIONALITIES o BUSINESS APPLICATION OF THE INVENTORY MANAGEMENT…

    • 2609 Words
    • 11 Pages
    Good Essays
  • Satisfactory Essays

    every year because of poor accounting and bad inventory management. The neighbor grocery store, Wow Grocery is a small business that is lacking inventory management system. Since the inventory control was updated manually on paper, the inventory would run out or over stock its ice creams which cause customer dissatisfaction. Since this is a small business with the budget constraints, I would try and look for cheap but reliable inventory management systems that are available out there over the shelf…

    • 494 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Inventory management system

    • 3997 Words
    • 16 Pages

    Technology is simultaneously advancing together with what internet offers. Many system made by programmers and companies are innovating people look and need them via internet. One click, thousands results, probably millions or ever billions of different system. One button press brings people to new discoveries and massive enjoyment. A sales and inventory system is a system that can handle a company data. With this system, company will not easily lost their record of items and record of their daily…

    • 3997 Words
    • 16 Pages
    Powerful Essays
  • Powerful Essays

    Inventory Management Systems

    • 9724 Words
    • 39 Pages

    A CA SE ST UDY Master Project in International Logistics and Supply Chain Management Authors: Lining Bai Ying Zhong Tutor: Jönköping Jens Hultman 2008-01 Master Thesis in International Logistics and Supply Chain Management Title: Authors: Tutor: Date: Subject terms: Improving Inventory Management in Small Business: A Case Study Lining Bai and Ying Zhong Jens Hultman 2008-01 Supply Chain Management, Inventory Management, Purchasing, IT, Small Business. Abstract Introduction: The growth of small…

    • 9724 Words
    • 39 Pages
    Powerful Essays
  • Good Essays

    goal of Inventory Management System is to ensure consistent availability of supplies for consumers. Thus, Inventory Management System is directed toward owners of small to large stores and stock managers who are responsible of maintaining sufficient goods on hand in a retail or manufacturing business. It can scale from a single computer running both client and server software up to multiple stores and warehouses. 4.2 Schedules The time estimated to complete the Inventory Management System project…

    • 446 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    Assignment 1: Inventory Management Systems Mondith Sreng CIS210 4/15/2012 During a conversion at my family dinner my sister mentioned her small clothing store and she also discussed how frustrating it is to manually track and record all of the high demanding items in her store. My sister would like an easier solution for her problem. She decided she wanted an automated system, but she told us that she has a very small budget. So she asked my mother…

    • 605 Words
    • 3 Pages
    Satisfactory Essays