SuperPharm transforms the pharmacy business in Trinidad with help from an ERP/POS solution from VAI and IBM

Published on 28-Jan-2010

Validated on 02 Dec 2013

"With a framework and guidance provided by VAI and IBM, we built a business from the ground up and essentially revolutionized the pharmacy business in Trinidad." - Christian Anderson, Chief Operations Officer, SuperPharm Limited

Customer:
SuperPharm Limited

Industry:
Retail

Deployment country:
Trinidad and Tobago

Solution:
Smarter Planet

Smarter Planet:
Smarter Solutions for Retail, Smarter Supply Chain

IBM Business Partner:
VAI

Overview

SuperPharm Limited was the first chain of retail pharmacy superstores to operate in Trinidad, where small, ‘mom and pop’ establishments had long been the norm. To build its business and support all enterprise and store-level operations, SuperPharm wanted a centralized system with a robust architecture that required minimal maintenance and facilitated fast growth.

Business need:
To build its business and support all enterprise and store-level operations, SuperPharm sought a management system that would encompass point-of-sale (POS), accounts payable and receivable, purchasing, inventory, general ledger and reporting.

Solution:
S2K for Retail from VAI -- enterprise resource planning (ERP) and POS software built on an IBM WebSphere Studio Workbench platform. The S2K application uses DB2 for data access, management and integration and is installed on a centralized IBM Power Systems server.

Results:
•Automatically tracks and analyzes sales trends for 15,000 individual stock items and up to 10,000 transactions daily. •Sales analysis triggers alerts that provide actionable information and suggestions that maximize decision-making abilities and purchasing power to increase profitability. •Local backup systems ensure continuous operation, saving a potential $2-3,000 in revenue per store for each hour an Internet connection is unavailable.

Benefits:
• Automatically tracks and analyzes sales trends for 15,000 individual stock items and up to 10,000 transactions daily. • Sales analysis triggers alerts that provide actionable information and suggestions that maximize decision-making abilities and purchasing power to increase profitability. • Local backup systems ensure continuous operation, saving a potential $2-3,000 in revenue per store for each hour an Internet connection is unavailable.

Case Study

Challenge

SuperPharm Limited was the first chain of retail pharmacy superstores to operate in Trinidad, where small, ‘mom and pop’ establishments had long been the norm.

To build its business and support all enterprise and store-level operations, SuperPharm sought a management system that would encompass point-of-sale (POS), accounts payable and receivable, purchasing, inventory, general ledger and reporting. SuperPharm wanted a centralized system with a robust architecture that required minimal maintenance and facilitated fast growth.

Solution

S2K for Retail from VAI -- enterprise resource planning (ERP) and POS software built on an IBM WebSphere® Studio Workbench platform. S2K uses DB2® for data access, management and integration and the installed IBM server scales easily to keep up with the needs of six current stores, nine by the end of 2010 and future expansion plans for up to 20 stores in Trinidad and Tobago.

All stores are linked to a central server, providing instant access to real-time data on sales, purchases and inventory. The system automatically keeps track of stock fluctuations and performs its own sales analysis, demand planning and forecasting. Analysis results trigger alerts with suggestions for immediate action and future consideration. A detailed view and insight into sales trends by both item and location help SuperPharm’s management and purchasing agents make informed, confident decisions in identifying profitable and unprofitable products and determining appropriate stock levels.

In the event of a disruption to the Internet connection, a backup system in each store ensures that there is no interruption to local point of sale processing, data management or other critical operations. When the connection resumes, the store’s system immediately catches up with the central server and brings all information up-to-date across the entire organization.

Benefits

• Automatically tracks and analyzes sales trends for 15,000 individual stock items and up to 10,000 transactions daily.

• Sales analysis triggers alerts that provide actionable information and suggestions that maximize decision-making abilities and purchasing power to increase profitability.

• Local backup systems ensure continuous operation, saving a potential $2-3,000 in revenue per store for each hour an Internet connection is unavailable.

Products and services used

IBM products and services that were used in this case study.

Software:
DB2 for Linux, UNIX and Windows

Legal Information

©Copyright IBM Corporation 2009 Route 100 Somers, NY 10589 U.S.A. Produced in the United States of America 12-09 All Rights Reserved IBM, the IBM logo, ibm.com, DB2, Power Systems and WebSphere are trademarks of International Business Machines Corporation, registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at HYPERLINK "http://www.ibm.com/legal/copytrade.shtml" www.ibm.com/legal/copytrade.shtml Other company product or service names may be trademarks or service marks of others. The information contained in this documentation is provided for information purposes only. While efforts were made to verify the completeness and accuracy of the information contained in this documentation, it is provided “as is” without warranty of any kind, expressed or implied. In addition, this information is based on IBM’s current product plans and strategy, which are subject to change by IBM without notice. IBM shall not be responsible for any damages arising out of the use of, or otherwise related to, this documentation or any other documentation. Nothing contained in this documentation is intended to, nor shall have the effect of, creating any warranties or representations from IBM (or its suppliers or licensors), or altering the terms and conditions of the applicable license agreement governing the use of IBM software.

Document options