Abstract
The member firm client, a Fortune 500 company is one of the largest providers of health care products and services. Recognized for its quality of customer service and competitive prices, the company’s business groups serve more than 700,000 customers worldwide. They operate through a centralized and automated distribution network, providing customers in more than 200 countries with a comprehensive selection of stock.
They were accused of wrongful product distribution by their main manufacturer/vendor by supplying goods into mainland China, when they did not hold the rights to distribute these goods within China. The vendor presented the member firm client with an ultimatum – find out how and where these products were entering the Chinese market, or we will cancel all trades with you. A team of member firm specialists, including data analytic experts, was assembled overnight and got to work analyzing and interpreting information from various sources throughout the company in an attempt to find out how these products were distributed into the Chinese market.
The challenge
While products into mainland China needed correct certification or licences, it was discovered that the products found within China had no supporting documents.
Distribution chains into and out of Hong Kong, were analysed to find out who was selling what, and in which areas products were being sold, to try and distinguish how the products were getting into mainland China.
There were 12 particular products to focus on which had already been found within the mainland. It was also important to establish if there were other products not yet discovered.
How analytics helped
To begin with, all financial, account, sales, and distribution data was collected in order to understand the level of sales and the distribution pipeline into various countries. The primary focus was on the Hong Kong and China markets; looking at who sells to whom, what sales were made by each sales person, and who the customers were outside Hong Kong. This information pinpointed any mainland customers, and from that a process map was developed of what that type of sale looked like.
The analysis gave insight into the types of products being distributed in this area, tracing the distribution and sale of products and testing various hypotheses regarding the movement of goods into mainland China.
The Solution
Through the analysis, it was discovered that there were some customers who were traveling to Hong Kong, purchasing the product and bringing it back into mainland China. These products were small and therefore easily bought and transported privately.
The analysis proved that through no overt action of the member firm client, the product was being sold in mainland China. Although the product was infiltrating that market, the member firm client was not the distributor. The vendor accepted this and continued to use the member firm client as the main provider of their products through a number of countries.