28-08-2014, 04:04 PM
SPARE PARTS MANAGEMENT SYSTEM
SPARE PARTS.docx (Size: 32.25 KB / Downloads: 9)
1. Introduction:
In manufacturing plants that own a large number of equipment, managing the spare parts properly and in a timely manner is a challenging task. Usually, spare parts are categorized into two main groups: fast moving and slow moving parts. Fast moving spares are those that are very often required, and slow moving spares are those that are rarely required. The managers find it difficult to keep track of the spare parts used and determine future demand manually.
The objective of this project is to build a database management system that will help the managers with the process of managing spare parts. In particular, the system should do the following: (a) keep record of the spare parts required for a particular type of maintenance; (b) keep record of the spare parts received and used in the past; © schedule forthcoming major maintenance services; (d) keep record of spare parts vendors; (e) forecast future demand for fast moving spare parts based on past consumptions; etc. In this model we assume that lead-time for all spare parts is one week.
The following are other functionalities of this database: (a) generating weekly order reports for each spare part. The system should generate reports of on-hand inventory of all spare parts and on-hand inventory of spare parts that have been in the inventory for more than three months. These reports will enable the managers to decide the proper disposal/utilization plan of the spares.
2. ExistingSystem:
Existing system includes paper works made by human so the times taken to maintain all these details are very long and also tedious to implement.
3. Scope:
System uses in variety of areas:
1) Small Workshops
2) Private Industries
3) Government Sectors
4. Advantages:
1) Availability of information from single system, i.e. Single Software
2) Monitoring all functions.
3) Keeping data for long time
.
5. Requirement
5.1 Software Requirements:
Operating System: Windows XP/ 7
Programming Language: .NET
Database: Microsoft SQL Server
5.2Minimum Hardware Requirements:
Processor: Pentium IV Processor
Hard Disk: 40GB
RAM: 256MB
Processor clock speed: 2.53 GHz Clock Speed
6. Conclusion:
This system manages explained how to manage spare part of different manufacturers, manage different kinds of vendors, customers, generate report such daily, weekly, monthly, vendor wise, customer wise, purchase report, sell report, etc.