ERP Proposal for Cable Manufacturing Industry

Current Situation

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.

Existing System

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

Major Drawback

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

  1. 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.
  2. 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 here

You should be logged in to download the PDF Version of the proposal