The system is a web based Product Service Management System that enables a Manufacturing company to schedule its manufacturing operations based on the daily update of sales from its dealers. The system is modeled to be used by a Manufacturing company, whose main activity is manufacturing different products & then selling the finished goods through a network of Dealers. To start with, the Stocks of all the Products manufactured by the company and held in the company ware-house are stored in a Database. The details that are stored include the quantity of each product held with the company dealers who hold the stocks of finished products for sale.
More about Product Service Management System:
Once the sales figures of Products sold in the past week are entered by the Dealers over the internet along with the Orders for the next delivery, the schedule for the next week’s production will be drawn up. A report of the required raw materials or parts will be drawn up with the approved suppliers for each & the suppliers will be intimated about the part requirements over the internet & asked to quote their rates. The message asking for a Quotation will be sent as an e-mail message. Once the rates are quoted, the Order will be placed with the required delivery schedules.
Once the parts are supplied the Part Stocks will be updated. Then a production plan will be drawn up taking the Bill-of-materials into consideration. The Bill-of-Materials contains the details of each Product & the type & quantity of Parts required for manufacturing a single unit of the Product. Once the Production plan is approved, the Part Stocks will be updated when the Parts are issued to the Production Department. Once the finished products are available from the Production Department, the Products will be dispatched based on the Orders placed by the Dealers. The stocks with the dealers will also be maintained.
In the existing system all the information is placed based on paper based system.It will take more man power and it will take more time. The redundancy of data is to be maintained. So the dealer details,order details and the manager Once Dealers place the Orders, a Production Schedule Report will be generated.
In this System all the information is to be maintained on the computer system So all the information can see very easily It can take the customer details and also the purchase details are to be maintained. It can take product details and updated into the database . the customer can select the corresponding product whether the goods are to be placed on the customer side the order data is to be removed from the order table.
The staff will check all the details of the product and dealer details and also the productstock details.
Scope of the System
- The scope of the project is the products are to be selled entire the internet. The dealer can access any where
- He can access all his details and sell the products and he can submit all the his selling details to the administratorScope of the SystemThe scope of the project is the products are to be selled entire the internet. The dealer can access any where
- He can access all his details and sell the products and he can submit all the his selling details to the administrator
The system “psms” consists of 4 modules.
The administrator has the capabilities of add the new dealer , new product, new Part details , new product stocks he can also view all the details of entire organization . new product and he view all the information to the organization he add the new suppliers information who supplies the raw material to our organisation
The dealer can sell the related item can given to him by the admin .He can give report to the admin how many products are to be sell and give total information to the particular product .If any products are to be wanted he send message to the admin so and so product are to be wanted the admin can see the message and send the products to the dealer
The staff can enter all the products information in to the computer and he can send the information to the related to the person He can see the all reports to the particular person.
The supplier can view all the product details and he can give the quotation about the poroducts . the supplier can give quotation to the admin . The admin can take the supplier who give low quotation
Features to be implemented:
- Session management
- Connection pooling
- Normalized database
- Prevention of duplication login
- Design patterns
- Three-tier architecture
- Easy deployment with Ant script.
- Exception handling
- Client-side validations
Technologies to be used:
- Web Presentation: HTML, CSS
- Programming Language: Java
- Web based Technologies: JNDI, Servlets, JSP
- Database Connectivity API: JDBC
- Build Tool: ANT
- Debug Tool: Log 4J
- CASE tool: Rational Rose, Visual Paradigm, Enterprise Architect
- Backend Database: Oracle/SQL Server/MY SQL/MS Access
- Operating System: Windows XP/2000/2003, LINUX, Solaris
- J2EE Web/Application Server: Tomcat/Weblogic/Websphere/JBoss/Glass Fish
- IDEs: Eclipse with My Eclipse plug-ins/Net Beans/RAD
- Browser: IE/Mozilla
- Pentium processor ——– 233 MHZ or above
- RAM Capacity ——– 128MB
- Hard Disk ——– 20GB
- Floppy disk ——– 1.44 MB
- CD-ROM Drive ——– 32 HZ
- KEYBOARD ——– 108 Standard
Download Product Service Management System: