Spare Parts Management
Spare Parts Management
Spare Parts Management
Introduction
1.1 Introduction
I.A.S is a company which makes Tractor parts with the label of I.A.S. They are distributing
their parts to the retailers in all south Punjab. They have the reputation of high-end quality parts
in the market. Their main office is near Vehari Chowk Multan.
They get their parts manufactured from different manufacturers with their own standard
requirements. Their manufactured parts are then packed with their company’s packing and then
kept in their stores. Required parts are then transported to different shopkeepers on the loader
vehicle of the company.
The business structure of their company is totally depending on old manual book system which
includes number of problems. With the proposed Business Management System their company
will have a transition from manual system to a computerized management system. Their current
system includes ledger of all the manufacturers from where they manufacture their parts and
their payments throughout past years with each and every detail. Then there is a ledger of all
the shop keepers who collect their parts and then sale it to their customers, it also includes the
dates, payment history and bill number. Their manual system also includes the information of
their employees and their payment history which is sometimes divided on weekly basis rather
than monthly on the demand of their workers. It also includes the payment history and
information receipts of the carriers who always bought their parts from manufacturers to their
stores; it also includes all the calculation of daily, weekly, monthly and even yearly details of
their sales and profits.
The important thing I considered is to have a system with the most basic interface because most
of the employees working there are not well educated and have lack of awareness about modern
day technology so it will only make sense to have an application having maximum benefits
with a simple and easy interface to use and understand.
Current system has many problems. In this section we discuss those problems.
All the works are carried out with pen and paper.
Sometime stock information will be not typed accurately
Sometime user cannot get the proper information about the product.
Buyers cannot place the order easily.
This system is not efficient and take long time.
The major problem in the supply of spare parts, is planning, executing, the required spares
planning. Spare parts requirement requires articulate planning procedural lead time, and the
correct required spares. Drawing/specification should be confirm to standards. The Purchase
order should given correct description, code no: drawings and amendments if any in due course.
The supplier should be a A class supplier. The major problem in spares part management is
identification and procurement of exact match. Normally in Pakistan, the technicians on the
road are not aware of exact specifications and try to fit the materials available with them to
make quick money. Standard workshops are the best solution. They procure and manage spares
parts from genuine source and exact match.
Identification of spare parts is not a problem, but keeping inventory of the spares is the biggest
problem. How do you identify the correct spares, and do allow to keep excess inventory. A
good planning for spares, with proper drawing/identification/requirement of spares is required.
Forecast the required quantity and keep minimum stock.
1.3 Motivations
The idea about the improvements and positive changes of a manual system to a computerized
system and then all the opportunities that comes with that to improve a business gives me
motivation to introduce information technology in the traditional business sector of Pakistan.
And beside this experts say that individual and team motivation is the leading factor affecting
the productivity of a project team. There are a few steps the Project Manager should take to
ensure that the foundation of sound motivation is in place in the project environment. And I
will keep these point in minds:
1.4 Objective
The main objective of this project is to develop a system to convert manual system into
computerized system. Other objective is to provide them organized form of information
regarding their stock, clients and manufacturers as well as their employees. Application will
provide modern way to manage their business and they will be able to have a more secure and
reliable management system.
And objectives of auto parts management are to provide the desired level of customer service,
to allow cost-efficient operations, and to minimize the auto parts investment.
Waterfall Model
Iterative model
Spiral model
V-shaped model
Agile Model
Waterfall model
Waterfall is a type of SDLC model, in which development of the software goes in a downwards
direction from analysis to maintenance just like the flow of waterfall. This SDLC model
includes execution of each stage completely and then moving towards next stage. This model
is not the best choice for long term or complex project as the requirements cannot be stable in
complex project.
The Iterative SDLC model does not need the full list of requirements before the project starts.
The development process may start with the requirements to the functional part, which can be
expanded later. The process is repetitive, allowing to made new versions of the product for
every cycle. Each iteration includes the development of a separate component of the system,
and after that, this component is added to the functional developed earlier. The phases of
Iterative SDLC model include:
Analysis
Design
Coding
Testing
Implementation
The spiral model combines the idea of iterative development with the systematic, controlled
aspects of the waterfall model. This Spiral model is a combination of iterative development
process model and sequential linear development model. The phases of Spiral SDLC model
include:
Determine Objectives
Identify Risks
Development and Test
Plan the Next Iteration
Agile software life cycle is very different from other traditional SDLC models. It works with
the requirement defined at each module and after getting the requirements, module is prepared.
In agile development customer is able to see the results at any specific point and it can respond
to change in design and requirements if needed. The phases of Agile include
Requirements
Architecture and Design
Development
Test and Feedback
1.9 Procedure
Analysis
Design
Coding
Tesing
Maintenance
2. Literature Review and Analysis
2.1 Literature Review
I always felt that there can be few major improvements in their way of doing business as I
know them personally so I did some research on how to achieve those improvements. I found
that they can boost their business performance if they can have the whole information of each
aspect of their business on their fingertips. Employees normally working there are not highly
educated and hence they always prefer manual system to run business, I researched few
companies who are working on a bigger level than IAS and how are they running their business.
One of those companies in this particular field is Millat Tractors. I was impressed the way these
companies have made a transition from typical framework of their business to a modern
framework which involves information technology. All those companies are using some sort
of applications to manage their business, now they know how much they are left with their
stock and how their employees are working and most importantly all the calculations of their
business are now easily calculated even if those calculations are their monthly or yearly profits
including their sales.
So with the same framework in mind I started studying on how can I computerize the business
structure of IAS with the help of an application and for that purpose it was important for me to
see some of those same sort of application systems running to control these sort of businesses.
New Pak Autos is a Store Selling Car parts for the past 40 years and I personally know them.
About 4 years ago they installed an application system which was developed by some
developer. I met them at that time and they explained me about how they are going to make
the transition from their existing manual system to a computerized system. Obviously I was
not getting that information at that time for my own system I was just interested to know about
the benefits. They told me that they are going to put each and every item into their database
and then they will know exactly how much each item is remaining and then they can order for
that particular item. The only challenge they told me was to teach their uneducated employees
how to work with that. The major benefit they see with this approach is the security of data
through backup as few years back their store catches fire and hence was destroyed with all of
their record ledgers.
Another similar business holder I know is Al Qamar Autos who are selling their Motor Bike
parts for the past 20 to 22 years and they have adopted similar approach to handle their business
with the help of an inventory management system with the main focus in mind of calculating
their stock. The additional function they have in their system is to print out their bill from the
computer and hence automatically adding the sales in total.
Al Nawaz traders are selling Solar panels, Batteries and UPS near Vehari chowk. Their
business framework is somewhat like IAS with stock in hold and then selling it to other
shopkeepers in different cities. They have been using their custom made inventory management
system which also includes computer generated receipts and all the directories of shopkeepers.
The main benefit they take from their software is to calculate who sold their batteries the most
on monthly and yearly basis and they award those shopkeepers with different gifts and lucky
draw. It is just one of the many advantages they see in their software.
2.4 Comparison
Economic Feasibility:
Economic analysis is the most frequently used method for evaluating the effectiveness of the
candidate system. More commonly known as cost/benefit analysis, the procedure is to be
determining the benefits and savings that are expected from a candidate and compare them
with costs. If benefits outweigh costs, then the decision is made to design and implement the
system.
A systems financial benefit must exceed the cost of developing that system. i.e. a new system
being developed should be a good investment for the organization. Economic feasibility
considers the following
The cost to conduct a full system investigation.
The cost of hardware and software for the class of application.
The benefits in the form of reduced cost or fewer costly errors.
The cost if nothing changes (i.e. The proposed system is not developed).
Technical Feasibility:
Technical feasibility centers around the existing computer system (Hardware and Software)
and to what extend it support the proposed addition. For example, if the current computer is
operating at 80 percent capacity - an arbitrary ceiling - then running another application could
overload the system or require additional Hardware. This involves financial considerations to
accommodate technical enhancements. If the budgets are a serious constraint, then the project
is judged not feasible. In this project, all the necessary cautions have been taken care to make
it technically feasible. Using a key, the display of text/object is very fast. Also, the tools,
operating system and programming language used in this localization process is compatible
with the existing one.
Behavioral Feasibility:
People are inherently resistant to change, and computers have been known to facilitate change.
An estimate should be made of how strong a reaction the user staff is likely to have toward the
development of a computerized system. Therefore, it is understandable that the introduction of
a candidate system requires special efforts to educate and train the staff. The software that is
being developed is user friendly and easy to learn. In this way, the developed software is truly
efficient and can work on any circumstances, tradition, locales.
Behavioral study strives on ensuring that the equilibrium of the organization and status quo in
the organization are nor disturbed and changes are readily accepted by the users.
ORGANIZATION
NAME
CONTACT
ADDRESS
PROJECT
NAME
BRAND
PRODUCT
BEGIN DATE
END DATE
DURATION
ASSUMPTIONS
GOALS
OBJECTIVE
SCOPE
DELIVERABLES
PAYMENTS
ADVANCE
MID
TOTAL COST
A Gantt chart, commonly used in project management, is one of the most popular and useful
ways of showing activities (tasks or events) displayed against time. On the left of the chart is a
list of the activities and along the top is a suitable time scale. Each activity is represented by a
bar; the position and length of the bar reflects the start date, duration and end date of the
activity.
3. System Design
3.1 Introduction
Systems design is the process of defining the architecture, modules, interfaces, and data for
a system to satisfy specified requirements. Systems design could be seen as the application
of systems theory to product development. There is some overlap with the disciplines
of systems analysis, systems architecture and systems engineering.
The DFD is an excellent communication tool for analysts to model processes and functional
requirements. Used effectively, it is a useful and easy to understand modeling tool. It has broad
application and usability across most software development projects. It is easily integrated with
data modeling, workflow modeling tools, and textual specs. Together with these, it provides
analysts and developers with solid models and specs. Alone, however, it has limited usability.
It is simple and easy to understand by users and can be easily extended and refined with further
specification into a physical version for the design and development teams.
The different versions are Context Diagrams (Level 0), Partitioned Diagrams (single process
only -- one level), functionally decomposed, and leveled sets of Data Flow Diagrams.
Data Store
A repository of information. In the physical model, this represents a file, table, etc. In
the logical model, a data store is an object or entity.
Data Flows
DFDs show the flow of data from external entities into the system, showed how the data
moved from one process to another, as well as its logical storage. There are only four symbols:
Squares representing external entities, which are sources or destinations of data.
Rounded rectangles representing processes, which take data as input, do something to it, and
output it.
Arrows representing the data flows, which can either, be electronic data or physical items.
Open-ended rectangles representing data stores
A context diagram is a top level (also known as "Level 0") data flow diagram. It only contains
one process node ("Process 0") that generalizes the function of the entire system in relationship
to external entities.
A level 1 data flow diagram (DFD) is more detailed than a level 0 DFD but not as detailed as
a level 2 DFD. It breaks down the main processes into subprocesses that can then be analyzed
and improved on a more intimate level.
The boundary, which defines the system of interest in relation to the world around it.
The actors, usually individuals involved with the system defined according to their
roles.
The use cases, which are the specific roles played by the actors within and around the
system.
The relationships between and among the actors and the use cases.
Usage scenarios. A usage scenario is a description of a potential way your system is used. The
logic of a usage scenario may be part of a use case, perhaps an alternate course. It may also be
one entire pass through a use case, such as the logic described by the basic course of action or
a portion of the basic course of action, plus one or more alternate scenarios. The logic of a
usage scenario may also be a pass through the logic contained in several use cases. For example,
a student enrolls in the university, and then immediately enrolls in three seminars.
The logic of methods. Sequence diagrams can be used to explore the logic of a complex
operation, function, or procedure. One way to think of sequence diagrams, particularly highly
detailed diagrams, is as visual object code.
The logic of services. A service is effectively a high-level method, often one that can be
invoked by a wide variety of clients. This includes web-services as well as business transactions
implemented by a variety of technologies.
3.6 ER Diagram
The entity relationship (ER) data model has existed for over 35 years. It is well suited to data
modelling for use with databases because it is fairly abstract and is easy to discuss and explain.
ER models are readily translated to relations. ER models, also called an ER schema, are
represented by ER diagrams.
An entity is an object in the real world with an independent existence that can be differentiated
from other objects. An entity might be
An object with physical existence (e.g., a lecturer, a student, a car)
An object with conceptual existence (e.g., a course, a job, a position)
Each entity is described by a set of attributes (e.g., Employee = (Name, Address, Birthdate
(Age), Salary).
Each attribute has a name, and is associated with an entity and a domain of legal
values. However, the information about attribute domain is not presented on the ERD.
Relationships are the glue that holds the tables together. They are used to connect related
information between tables.
Relationship strength is based on how the primary key of a related entity is defined. A weak,
or non-identifying, relationship exists if the primary key of the related entity does not contain
a primary key component of the parent entity.
3.7 Database
A database is a collection of information that is organized so that it can be easily accessed,
managed and updated.
Data is organized into rows, columns and tables, and it is indexed to make it easier to find
relevant information. Data gets updated, expanded and deleted as new information is added.
Databases process workloads to create and update themselves, querying the data they contain
and running applications against it.
Computer databases typically contain aggregations of data records or files, such as sales
transactions, product catalogs and inventories, and customer profiles.
A database schema defines its entities and the relationship among them. It contains a
descriptive detail of the database, which can be depicted by means of schema diagrams. It’s
the database designers who design the schema to help programmers understand the database
and make it useful.
3.8 Normalization
Normalization is the branch of relational theory that provides design insights. It is the process
of determining how much redundancy exists in a table. The goals of normalization are to:
Be able to characterize the level of redundancy in a relational schema
Provide mechanisms for transforming schemas in order to remove redundancy
All the tables in any database can be in one of the normal forms we will discuss next. Ideally,
we only want minimal redundancy for PK to FK. Everything else should be derived from other
tables. There are six normal forms, but we will only look at the first four, which are:
First normal form (1NF)
Second normal form (2NF)
Third normal form (3NF)
Boyce-Codd normal form (BCNF)
In the first normal form, only single values are permitted at the intersection of each row and
column; hence, there are no repeating groups.
To normalize a relation that contains a repeating group, remove the repeating group and form
two new relations.
The PK of the new relation is a combination of the PK of the original relation plus an attribute
from the newly created relation for unique identification.
For the second normal form, the relation must first be in 1NF. The relation is automatically in
2NF if, and only if, the PK comprises a single attribute.
If the relation has a composite PK, then each non-key attribute must be fully dependent on the
entire PK and not on a subset of the PK (i.e., there must be no partial
dependency or augmentation).
Third Normal Form
To be in third normal form, the relation must be in second normal form. Also, all transitive
dependencies must be removed; a non-key attribute may not be functionally dependent on
another non-key attribute.
When a table has more than one candidate key, anomalies may result even though the relation
is in 3NF. Boyce-Codd normal form is a special case of 3NF. A relation is in BCNF if, and
only if, every determinant is a candidate key.
4. Development
4.1 Development Plan
I have used Rad Model for my development
Language: C Sharp or C#
IDE: Visual Studio 2017:
Framework: .Net Framework 4.5
Technology: Winform
UI and Reporting Framework: DevExpress 18.1.4
Database: SQL SERVER 2012
DB IDE: DbForge for Sql Server 5.1
Drawing: Microsoft Visio 2016
Report Making: Microsoft Word 2016
User Interface were made using drag and drop facility beside this UI Framework DevExpress
was used to create more good looking, professional and responsive design
Coding was done by keeping in view the 3-tier architecture. Visual studio itself provide 2 tier
it keeps drag and drop code separate from other logic. But in 3 tier we further divide that logic
into business logic and database logic.
4.3.3 OOP
Features like inheritance, encapsulation and other oop features were used by default. Every
custom Form or Control is inheriting from the basic form or control provided by visual studio
itself
Dialog Box are used to show exception, success and error alerts. A few examples are given
below
4.3.5 Events
Mouse and Keyboard events are used beside them dropdown change event, and data grid
selection changed event are also used.
Errors are handled very wisely so that the software should not close unexpectedly. Few
examples are given below.
4.3.7 Forms and Controls
I have chosen c# because it is very easy to create desktop application with it and criteria to
create a computer shop management system was fulfilled by c#. and hardware work like
printing was also added very easily.
5. Deployment
5.1 Implementation
A product software implementation method is a blueprint to get users and/or organizations
running with a specific software product.
The method is a set of rules and views to cope with the most common issues that occur when
implementing a software product: business alignment from the organizational view and
acceptance from human view.
The implementation of product software, as the final link in the deployment chain of software
production, is in a financial perspective of a major issue.
It is stated that the implementation of (product) software consumes up to 1/3 of the budget of
a software purchase (more than hardware and software requirements together).
When the main point of the computer study program is to implement counter measures to bots
and bugs.
5.1.1 Location
The software was implemented at IAS
5.1.2 Hardware
I told them to buy:
Processor: Core 2 Dou 2.4 Ghz
Ram: 2Gb
HDD: 160Gb
5.2 Configuration
I installed sql server on their system. Made the installer of the software with automatic database
connection setting. And database creation and table creation and insert one record for admin
user in admin table for login
5.3 Testing
5.3.1 Purpose
Software testing enables making objective assessments regarding the degree of conformance
of the system to stated requirements and specifications.
Testing verifies that the system meets the different requirements including, functional,
performance, reliability, security, usability and so on. This verification is done to ensure that
we are building the system right.
In addition, testing validates that the system being developed is what the user needs. In essence,
validation is performed to ensure that we are building the right system. Apart from helping
make decisions, the information from software testing helps with risk management.
Software testing contributes to improving the quality of the product. You would notice that we
have not mentioned anything about defects/bugs up until now.
This system has some benefits to their staffs. Currently they are keeping every record by written
down in memo manually. At least this system will give them relieve from exhausted life which
they are dealing with their customers. Besides this system will make them more reliable to its
customers as all the customers records will be kept safely than any previous
times. Moreover, they can manage their stock more handily.
Reference
SMARTDRAW
http://www.smartdraw.com
TECHNOPEDIA
https://www.techopedia.com
UML-DIAGRAM
http://www.uml-diagrams.org
GURU99
https://www.guru99.com/