[attachment=11551]
Abstract
Water is an essential need all over the world. FLOWELL 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.
FLOWELL 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
• Flow well 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.
Present System
Flow well 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
1. Could not synchronize the Outward information to order details.
2. No track of the complaints and replaced goods after ordering
3. Order status is updated manually using Order Confirmation.
4. 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.
5. Increased levels of expectation from customers with respect to prompt delivery of items.
6. 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.
7. Difficulties in handling customer queries pertaining to consignments in-transit and partial dispatches.
8. 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.
9. Increase in frequency of goods returned on account of damage leading to high stock levels of damaged goods in the factory.
10. Discrepancy between ordered and invoiced quantities on account of either partial availability of stocks or clerical oversights.
11. Insufficient checks in the current system for ensuring customer credit limits are not exceeded.
12. 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.
13. Customers could communicate to the Sales people but no information is kept in track for future references.
14. Management couldn’t not have any information regarding latest sales reports unless requested and taken it for Spreadsheet applications.
15. Management requires the Quality information updates against the complaints and quality measures and metrics, which the current system couldn’t provide such facilities.
The Project Proposal for Flow Well
Project Proposal
Based on the analysis of problem areas in Flow well and the preliminary study, it is proposed that Flow Well 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.