1.
INTRODUCTION
Flow well Automation System is web based
application to automate the process of sales of that company i.e raising new
order , calculating total bill to that
order and stock maintenance , pending order maintenance ,shipping of items
,damaged stock maintenance ,quality control ,viewing order status etc.
The team approach offers
local executive representation in USA and both executive and technical staff
located in the high-tech corridor of Hyderabad, India. This combination ensures
close collaboration, expert-driven results and dramatically reduced development
costs compared to conventional methods of designing, developing and maintaining
software. Additionally, Inforaise manages our project using a disciplined yet
flexible methodology that is adaptable to our preferred processes. As your
offshore development team, their goal is to always operate with perfect
synchronization and communication with your local team.
this ensures success for
its Customers by combining the best products, people and practices to meet your
project schedules with savings of up to 60 percent. They support flexible
billing system offering their Customers the leverage required in Invoicing.
1.2 Problem Definition
A pump industry is a company, which
manufactures the following products. They are 100 mm Submersible Pump Sets ,
150 mm Submersible Pump Sets.
Pump Industry’s Inventory department has been
automated in 2000 using Visual Basic as front end and Oracle as backend. First
of all, the user receives the product chosen by the customer and then the
industry maintains the details manually .They faced a lot of problems. In the
long run it becomes difficult to maintain the records when the number of
customers, products and dealers increase. Also getting the required data
regarding customer details, the various product details, the stock available
for the respective products, the payment details becomes difficult. At a
particular time monitoring, the performance of the various products available
or details of payments or details of the customer who have bought some goods,
becomes difficult and time consuming .And the departments want to communicate
through internal mailing system.
Any
time a change is implemented in the product details, stock details, customer
details, dealer details or credit payment details there are manipulations in
the respective records or new records have to be maintained.
2.0 SYSTEM SPECIFICATION
2.1
Introduction
Water
is an essential need all over the world. PUMP INDUSTRIES
offers a wide range of submersible pumping systems, to draw the water from
deepest.
Started in 1987, it is a unit of
well-established group that has diversified into AC pressure pipes, PVC pipes,
RCC pipes, HDPE pipes and chemicals. The unit has all modern manufacturing and
strong R&D facilities, a stringent quality assurance system and efficient
technical know how to ensure the customer a reliable and energy efficient pump
set.
PUMP INDUSTRIES
is going for ISO 9002 for their quality procedures in Maintaining their product
quality and systems.
SAILENT
FEATURES
Production & Verification Facilities
- The Unit has all
modern manufacturing & verification facilities and an efficient
technical know how.
- 100%
in-coming and final inspection of products involved in the system.
Performance
- Flowell pumps run
in a wide varied voltage range (180V - 440V).
- Saves power
consumption up to 30% over the nominal efficiency pumps.
- Trouble
free and long life.
Accuracy
- The pump &
motor fittings are made within an accuracy limit of 0.00 to 0.04mm.
- The Eccentricity
and face run outs are maintained up to maximum 30 microns.
- The surface
finish of rotor & protecting sleeve is maximum 0.30 microns.
2.2
Present System
Industry’s Inventory (stores) department has
been automated in 2000 using Visual Basic as front end and Oracle as backend.
This system is well adopted but could cater only stores but could not
synchronize sales database. It requires lot of attention and risk from the
user’s side. Other departments such as Sales department, Quality department,
and management had not automated. So this computerized automated solution
proves to be extremely handy. In the present system the user has to enter the
details of the product chosen by the customer. He also maintains the details of
the form of payment (cash or credit) made by the customer in the logbooks. He
also maintains and updates the stock details. All this is carried out manually.
Manager
measures the performance of the product and the payment details by checking the
papers, which are maintained by user. Manager sees the stock available for each
product by checking the logbooks, which have to be maintained by the user.
Problems
in present system
- Could not synchronize the Outward
information to order details.
- No track of the complaints and
replaced goods after ordering
- Order status is updated manually
using Order Confirmation.
- Very high levels of effort for
preparing invoices and dispatch related documents and routing them to
relevant departments or locations and high levels of clerical activity on
account of applicability of different customers and products.
- Increased levels of expectation
from customers with respect to prompt delivery of items.
- Inability to accurately judge
changing patterns of fast and slow moving items on account of large
volumes of data, and inability to track goods in transit.
- Difficulties in handling customer
queries pertaining to consignments in-transit and partial dispatches.
- Important orders not discriminated
from others since all orders since all orders were processed on a FIFO
basis-hence need to be able to prioritize and process orders on a
preferential basis (for high value orders or important customers), if
required.
- Increase in frequency of goods
returned on account of damage leading to high stock levels of damaged
goods in the factory.
- Discrepancy between ordered and
invoiced quantities on account of either partial availability of stocks or
clerical oversights.
- Insufficient checks in the current
system for ensuring customer credit limits are not exceeded.
- Sales data not analyzed properly to
streamline production volumes. This is primarily on account of varying
sales patterns across the year and high volumes of transaction.
- Customers could communicate to the
Sales people but no information is kept in track for future references.
Management couldn’t not have any information
regarding latest sales reports unless requested and taken it for Spreadsheet
applications.
Management requires the Quality information updates
against the complaints and quality measures and metrics, which the current
system couldn’t provide such facilities.
2.3
The Project Proposal for Flowell
Project
Proposal
Based on the analysis of problem areas in Flowell and the preliminary
study, it is proposed that Flowell Industries Ltd. Should go in for automation
of some of their key areas of operations in the company. This will not only
alleviate the current problems but also provide an information network, which
will strengthen the manner in which the organizations address its priority
areas.
Application
Portfolio
It
is recommended that the organization takes up the following four functional
areas for automation
- Sales order department
- Quality department
- Stores department
- Management Information System
The
reasons for selecting the above are that firstly they directly address the
problems enumerated. Secondly, together they forma cohesive set of
well-integrated application with one system acting as the feeder system for the
other.
Software hardware Requirements
The
following software and hardware are recommended for the company.
Software
NO/S : Windows 2000 Advanced
Server/Server
Web
technologies :servlets ,html ,jsp
Mail
Server : POP3, SMTP
Service Pack : Service Pack 2 or more
JDK
: J2SE1.3 or more
Hardware
RAM:
512 MB Minimum Recommended
HDD: At least 1 GB Minimum HDD Space required.
2.4 Advantages of the Proposed System
1. Inter-Department
Communication using Intranet Mailing Services (emails)
2. Tracking
the mails received from the customers as complaints and using them for
appraisal and audit purpose purposes.
3. Customized
and adhoc reports for the MIS for decision-making.
4. Order
indent-automation from the direct sales dept.
5. Inventory
Database updates.
6. Stock
information
Communication with the customers regarding the orders
and complaints and tracking them for the future purposes.
