Impact of Master Data Management on Supply Chain - Part 2
By Atin Harsh Bhola
In the last part, we discussed the supply chain pain points that modern enterprises face. In this part, we will look into the key supply chain practical issues and their MDM solutions.
Practical supply chain issues and their MDM solutions
Practical issue 1: A retailer's distribution center (DC) in X city has its operations shut down for an extended period of time due to a hurricane. Unfortunately, the retailer is unable to shift distribution for those regional stores because its store-order codes are a combination of item codes and the supplying DC's codes. Changing the distribution channel requires changing the order guides, which for most organizations is a herculean task. The delay leads to empty shelves, lost sales, unhappy customers and irreparable brand damage.
MDM solution (Responsiveness): Sound master data can source items from anywhere to anywhere at the touch of a button because all data around items, suppliers, contracts and sites have been uncoupled from their source This enables the retailer to easily reconfigure the data so that store-order codes are a combination of uniform item codes and the new supplying DC's codes.
Practical issue 2: Customer A goes to a grocery store to pick 8 items that are needed for dinner that evening. One of the most important item is out of stock in the store. The customer abandons the shopping cart and leaves without purchasing a single item. To this customer, purchasing all eight items in one store is a more attractive option than waiting in checkout lines at two different stores To the retailer, this out-of-stock led to the lost sale of eight items and a very dissatisfied customer
MDM solution (Reduced Out of Stocks): Out-of-stocks are inextricably linked to poor forecasts in 47 percent of cases. And poor forecasts are often the result of data inaccuracies in retailers' supply chain, merchandising and inventory systems--precisely the kind of inaccuracies that master data management helps prevent. An MDM implementation ensures that the inventory is correctly tracked and orders are placed accurately in advance to meet the demand. Since MDM implementation ensures that the customer, supplier, product, BOM data is correct, accurate forecasting also enables the correct value of safety stock to be maintained for changing demands.
Practical issue 3: A northern regional buyer of a multinational organization purchases a large volume of jackets from a vendor named 'Cook & Wilson Outfitters'. This allows him to negotiate a favorable deal with the vendor. Another southern regional buyer of the same MNC purchases a large volume of the same product from the same vendor. However, in the southern regional system, this vendor's details are entered as "C&W Outfitters." Because the vendor description is not uniform between the two systems, the southern buyer is unable to negotiate an advantageous price based on total volume purchased by the MNC as a whole
MDM solution (Cost Reduction): An MDM implementation ensures that the product codes appear uniform throughout the applications used by an organization. Since MDM serves as a central repository, any changes done to the product code/value through any applications comes to MDM. MDM validates the change and applies data quality rules so that the most trusted version of the product code/value appears in MDM hub. This cleansed and standardized product data is then published to the relevant applications using this data through real time/batch framework so that the most trusted version of product data appears uniformly in all the applications
Practical issue 4: A fast food company X is a competitor of a company Y.Company X finds that in order to compete, it has to improve value/revenue generated against some of its low revenue yielding products
MDM solution (Additional Revenues): With MDM implementation, a company may discover that in the northern region, customers who buy boneless chicken also buy a marinade 43 percent of the time.With that information, the retailer can craft a campaign to help drive sales of a slow-moving marinade while increasing the average customer sale.
About the Author: Atin Bhola is a consultant working on SCM domain having 5 years of IT experience. He has worked on oracle applications (distribution modules) and also in MDM domain (Siebel UCM).



