The client is one of the leading cable manufacturer in coimbatore and he was looking for ERP for his Cable Manufacturing unit. His end customers are the top leading suppliers of wires with their own brand names in and outside India. The client had their own in-house developed Desktop application software, which partially met the management expectation. But it needed more customisation to make the process simpler, easier and more user friendly.
The existing version of software was developed using traditional Visual Basic version 6 (VB6) and Microsoft SQL (MSSQL) as backend.
While doing the case study in the existing system, it has been discovered that tracking the inventory levels of copper is not straight forward. Every time the resources should calculate the list of copper utilised during a course of time, calculate and analyse the requirements for the future, and place the next order to the vendors that is not accurate and precise. It takes lot of time to track production, sales, past orders, wastage and future orders manually. Not only the above, improper planning results to wasting useful labor in trivial works, and is also prone to human error
Another major drawback on using the existing system is the employees in the production area have to leave the production area, go to a computer, log in to the computers, open the software, provide the required inputs, get information about the input product, and provide the required updates. And the process to do that takes about thirty minutes to an hour
To overcome this situation, we recommend to build an android mobile app where the employees can bring an android phone or tablet into the production area and enter the inputs and get all the information that they need in about one second. That is really the beauty of mobile software. It simplifies some complex tasks that do not need to be complex. Our business model is very simple but the Desktop Software that is being used is complex.
What we proposed
The best way to simplify complex business processes and make employees’ jobs easier is to migrate the existing version of desktop software into webbased version using PHP as the development language, MYSQL as backend and develop mobile application using Android. Since android version devices are cheap we plan to develop android application that will get the input from the user and synchronise that information into the main server similarly, the same approach will be used for the output.
The Opportunity after the initial discussion with the client’s IT organization with their IT heads, the goals / key were derived as below Some of them are the key criteria’s
- a) Current version of application platform should be customized according to the needs of each So the existing application source code should be altered / modified to meet the requirement. No clear roadmap is laid to follow the requirements.
- b) Develop an android version of the software that will help the users to use the system in the areas where desktops cannot be used.
The proposal for Cable Industry for our client can be viewed hereYou should be logged in to download the PDF Version of the proposal