Manufacturing Business Administration System (Plus: Stock Control System Add On)

The system was designed for a manufacturing, maintenace and sales business for a number of products. The system stores and administers all the information for the 8000+ clients of the business and their complete history.

The history that is kept revolves around:

• All the queries the client has ever had so that no matter whom is assisting the client they will know all the relevant queries the client has had,
• Their products (all products they ever had as well as their current products),
• Their product maintenance information,
• Their products test results (the performance charts of their product at date of
• manufacture and at the point of maintenance), and
• The parts used in the maintenance.

The client profile is able to be viewed by the client over the internet to allow them to know exactly what work has been done by the business on their products as well as their product’s test results. The system is responsible for the tracking and storing of the history of all the product information.
To date 12 000+ products are stored in the system, and it keeps track of by use of the products unique serial number:

• When the product was manufactured,
• Its test results at manufacture date and maintenance periods,
• Maintenance that has been performed and what parts were used, and
• Who has owned it.

All the different parts and spare parts that the business uses are stored by the system and tracked to which product has used them and how many are on hand.

When a client brings in a product that is either faulty or needs general maintenance done on it the system creates the needed Job Card. This Job Card gets associated to a particular client and the particular product that the client has brought in.
This Job Card is then sent through to the Workshop; the workshop then gets notified of the new Job Card and collects the product from the maintenance stores.

The workshop then assigns different Technicians to perform the different tasks as needed for the particular job card. This is done to allow management to perform various data mining on which technicians are doing what work, how much work they are doing and which technician are having the most returns for a particular function or in general.

Thus, providing the business with information that allows then to make a knowledgeable decision about the work being done and by which technician. There are various management reports built in to the system that can be generated to get the most from the work being done and by whom.

The system manages the different Technicians, their details, and the different functions that the Technician performs.

Other Functional Areas include:
Pastel Integration – the system integrates into Pastel to pull and push information into invoices from the created job cards, and parts used. This was the only integration functionality that was required, but more extensive integration can also be done.

The system allows different users and user types to be created from Admin users, front desk clerks, admin clerks and workshop users (Forman and Technicians). These users and user roles allowed and disallowed various function areas in the system as required by management.

The system also included a backup/restore area which was automated to be stored off site to ensure that correct business continuity measures where in place and that data was as protected as possible.

Additional Module
The current add on module that is being developed consists of using hand held barcode scanners that are used to capture stock and other items entering the business. These items are then added or deducted as stock moves in and out of the business, from sale of the items as well as through the use of the various parts in the maintenance work done on products.

Another feature is the ability for the business to receive a stock item and track how many products are created from it after the manufacturing process has been completed, as well as tracking what other items are being used in the manufacturing process.

Thus creating a complete stock control system as well as a manufacturing administration system through this add on module.