The project involved working out a total computerization plan for the pharmaceutical company. As a part of this computerization plan, a Manufacturing Resource Planning System (MRP), named as MANAS was designed and implemented. This system provides a tool for performing all day-to-day operational activities and also to control and monitor the production process.

The system has modules for the following functions:

Purchase :
This module performs the functions of purchasing that include planning, purchase authorization, purchase ordering, material requirement analysis, pending purchase order analysis, vendor-rating analysis.

Stores :
This module performs the task of materials management that includes maintenance of inventory records of raw materials and finished products, stock ledgers and statements, branch transfers and invoicing.

Excise :
This module performs the task of maintaining statutory reports and other information for Central Excise Department.

Quality :
This module concerns itself with the quality certification of raw materials and finished products. It also maintains the set formulation for producing different finished products and detailed technical specification for different raw materials.

Production :
This module performs the functions of production planning and actual production and generates daily production statement, production monitoring report, raw material consumption statement, stock statement of semi-finished goods held in plant.

Exports :
This module is essentially meant for marketing products and performs the functions of export planning, export order processing and monitoring, statutory export documentation, introduction letters.

Accounts :
This module is meant for planning and maintenance of records for finance related activities, day books, ledgers, balance sheet and cost analysis.

Personnel :
This module is meant for maintenance of records of employees and planning for manpower requirements, personnel profile, payroll processing and leave management.

Engineering :
This module is meant for functions such as recording history of maintenance work on different machines at plant, health card of machines, maintenance schedule of machines, cost analysis of maintenance of machines, capacity assessment of spares supplied by different suppliers and work orders

Marketing & Distribution :
This module provides sales forecast for production, rolling sales plan, analysis of closing stock at warehouses and take-off of finished products.

Monitoring :
The module serves to provide an MIS for supervisory control and monitoring.

The tools/platforms used for the MRP system are as follows:

• PowerBuilder as Front-end running on Win 95/98 platform and Oracle as database running on a Novell Netware server. The design is based on Client-Server architecture.