Web Application Resource ABOUT PROJECT 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 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. 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. Proposed System Project Proposal Based on the analysis of problem areas in Flowwell and the preliminary study, it is proposed that Flowwell 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. 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. SOFTWARE  REQUIREMANTS 1.       Java  SDK                       : J2SE  1.4 2.      web Server                       : Tomcat 3.      IDE Tool                          : J-Builder 8.0 4.      Web Design Tool             : DreamWeaver 4 5.      Database                          : MS SQL Server7.0 6.      web technologies              : servlets,jsp,html HARDWARE  REQUIREMANTS 1.      Personal computer with 80486 or higher processor 2.      20 GB hard disk space 3.      256  MB RAM