I originally wrote this article, “Customer relationship management” in November 2003. A systematic process is used to prepare a comprehensive proposal to a sponsor for approval to implement a Customer Relationship Management (CRM) System in an organisation. The proposed system introduces a new information system and improves organisational productivity. The sponsor is a financial institution. The information system supports the strategic goals of the organisation where it will be implemented. A systematic approach was followed to identify the opportunity and the choice of proposed system is justified. A feasibility study for the system is proposed, including system investigation and the preparation of functional specifications for the intended system (from a managerial viewpoint) and a system implementation plan is given.
SUMMARY
An investment is proposed for the implementation of a customer relationship management (CRM) system within the client company over a six month period. It is the optimum solution to the client’s problem of how to achieve their sales revenue growth requirement for the next five years.
The proposed system has a good fit with the six strategic goals of their business. In particular, it meets the need to secure lifelong customers who buy the most profitable products using the client’s unique service.
The problem of achieving sales revenue growth is solved using a systems approach. First, we established that the problem has the four components of; creating customer awareness, encouraging sales, maintaining repeat custom and deciding upon the marketing mix.
Six alternative solutions to the problem are appraised. Mass marketing, CRM, local distributors, local sales representatives, advertising and the internet are considered. These possible solutions are evaluated againstthe definedproblem, cost, time and the degree of fit in supporting the business goals.
The optimum solution is a CRM system to focus the marketing and sales efforts in the right direction. It is envisaged that the system will help to attract, retain and get customers to spend more with the company. Using a relational database, the system will be used to co-ordinate the direct mail and telemarketing campaigns.
A feasibility study is required during the systems analysis and conceptual design phase to ensure that it meets the requirements for data; warehousing,extraction, management, mining, analysis and query. Implementation of the project will proceed only upon a favourable outcome from the feasibility study.
Project implementation is in nine stages. The critical stage is that of training staff in system adoption, data mining, use of technology and in how to get system support.
INTRODUCTION
The client company is a new business venture formed to utilize an opportunity to satisfy a UK demand for Asian products exported from Singapore by air parcel. The target market is small British retailers who already sell antiques, clocks, gifts, handicrafts and home decor. They compete by having product variety, and very few currently sell handcrafted goods from Asia. Their present offerings are either locally made expensively machined products or poor quality imports from wholesale warehouses. The client company offers good quality, high value, low weight, hand-made Asian products by 7 day delivery air parcel for payment by credit card.
STRATEGIC GOALS OF THE ORGANIZATION
The client company has six strategic goals, and they are: Annual export sales of S$2M in 5 years and 10% net profit after tax - The client company will acquire 500 lifelong European retail outlet customers. The average order
