Abstract
It is usually observed that small to medium sized organization with many assets do not have a have a reliable and efficient system for tracking orders, their usage within along with inventory of supplies, equipment and assets. As a result, often there are situations when the person in-charge of ordering supplies place excess or deficit orders. Moreover, as there is no defined system to track the usage of these products and/or services, it ends up wasting the valuable time of the person(s) handling it. This project focuses on developing an Inventory Management System (IMS) for tracking equipment, supplies and other assets along with the necessary report functionality. The IMS will be able to track all equipment and assets from multiple departments of the organization over period of time. By integrating inventory with workflow it is highly likely to match future demand with current supply. For e.g. it will be possible to track how many computers are available for installation\\replacement, when to upgrade them and how many new to order. Tracking the ordering and usage of supplies using IMS will create more efficient and effective use of budget and staff resources. IMS will also keep track of how much stock is going out the door via purchases and how much remains on v shelves and in the warehouse, giving people a real-time picture of how well they are utilizing their allocated resources. All-in-all my system will serve as decision support system for managers. To simulate the scenario of a medium sized organization I wish to implement IMS for Student Affairs Division at CSUS. This implementation will serve as a case study for my Master‘s Project. To facilitate control, the parts are classified into different categories. Various quantitative models for demand forecast, economic order quantity, and safety stock are considered, and for each part type, an appropriate set of models is used depending on the relative importance of its category.