Integration of ERP System
Prepared by Dil Afroz Farzana ID: 6163326011 Batch: 26th Submitted to Dr. Md. Rakibul Hoque Assistant Professor Department of Management Information Systems University of Dhaka
Company Profile Square Pharmaceuticals Ltd. (SPL) is the leading Bangladeshi Pharmaceutical company and it is the most successful venture as well as the Flagship Company of the Square Group a renowned local business conglomerate. The company was founded in 1958 by Samson H. Chowdhury along with three of his friend as a private firm. It went public in 1991 and is currently listed on the Dhaka Stock Exchange. Square Pharmaceuticals Ltd. is holding the strong leadership position in the pharmaceutical industry of Bangladesh since 1985 and it has been continuously in the 1st position among all national and multinational companies. Square Pharmaceuticals Ltd is now on its way to becoming a high performance global player.
Square is a group of more than 30 companies that are operating in the nation. Most of these companies are renowned around the nation for their quality product / service and most of all their transparent and ethical business policies. SQUARE today symbolizes a name – a state of mind. The sales turnover of SPL was more that Taka 5 Billion (US$ 90 Million)with about 15% market share (April 2003 – March 2004) having a growth rate of about 16%.
Enterprise resource planning (ERP) systems are the world’s largest and most complex ES. ERP systems focus primarily on intra-company processes— that is, the operations that are performed within an organization— and they integrate functional and cross-functional business processes. Typical ERP systems Operations (Production), Human Resources, Finance & ing, Sales & Distribution & Procurement.
Supply Chain Process in Pharmaceutical Company
ERP System
Problems before using ERP: Before using ERP, it was difficult to meet the demand of the market, as there was no integration with the sales & marketing department to others like, commercial, production, procurement, technical department, audit department etc. to fulfill the goal to be the market leader. But after using ERP they solve the problem. It was difficult to forecast the demand of production, information were not available to all the related department, so they had to face lot of difficulties.
Square Informatix Ltd.:
The IT division of Square Pharmaceuticals emerged as a separate entity with the name ‘Square Informatix Ltd (SIL)’ in 2000.
Square Informatix developed a software for sales of its own business in the year 1992
Square developed another software for its human resource department in 1995
Square also kept developing various other software that addressed issues of quality control, inventory management and production.
Square Consumer Products Ltd (which was later renamed as Square Food and Beverage) used the integrated version of the software first successfully.
Gradually, this software turned into a complete ERP by integrating all issues including procurement, inventory management, production, quality control, sales and distribution management.
Square Informatix proudly named the software as ConSIL.
After Using ERP Software SPL can easily maintain below issues: Raw Material/Product Specifications Supplier Management and Qualification FDA 21 CFR part 11 Compliance Quality Control (QC) Quality Assurance (QA) as per cGMP norms Sampling Plan, Stability Testing Batch Monitoring Activities by Inspection Plan Electronic Execution of SOP’s by Inspection Checklist Electronic Batch Ticket and Electronic Weigh Sheet. Non-conformance (NC), Corrective and Preventive Action (CAPA) Easy Material Substitutions Multiple Packaging of Same Formulation Manufacturing Batch Record (MBR).
After Using ERP Software SPL can easily maintain below issues:
Shelf Life / Expiration
Bi-directional Lot Traceability and Lot Recall
Separate Granular Costing of Formula and Packaging Material
s Contract Manufacturing
Adverse Event
/ Complaint Reporting
Allergen Management
Master Production Scheduling (MPS)
Material Requirement Planning (MRP)
Benefits of ERP:
Enhance the quality, consistency and speed to deliver drugs to market
Control costs through reduced wastage, optimum material utilization and inventory management.
Ensure absolute compliance to the stringent regulations.
Eliminate risk by delivering safer products of superior quality at the right price and right time.
Introduce new products to market faster and cheaper than competitors
Helps take quicker preventive & corrective action
Real-time batch monitoring to make accurate business decisions
Maintain your formula secrecy
Respond quickly to customer demands
Smoothen operational process flow and enhance profits
End-to-end bidirectional traceability, from the raw material to the finished product
THANKS