Remember the Batman V Superman Jeep Renegade Dawn of Justice edition? Built to release with the movie in 2016 this special edition included standard popular equipment group in addition to all the Batman black. Now imagine a customer walking into a dealer store looking for replacement of its dual zone climate control. The dealer says they don’t carry it any longer and neither are they able to locate one that does.
Automotive companies where part identification and reporting diversity has proliferated across storage locations & production units lose the ability of sharing parts inventory between sister dealers. In turn this makes availability check and response to opportunistic spares sales situations super hard to service.
Customers looking to replace that climate control now has to wait for days as dealer agents navigate through store systems to confirm earliest availability.
Part NamePart NumberVendorLocationStock(numbers)QtyAvailabilityBlower fan82105-LFTUniversal Spare PartsEveret, MA15EvaporatorCC-20167Integrated Climate Control SystemsRoxbury64Condensing coil30248USP Inc.24 Shetland St, Everett90Expansion valveCLMT CNTR-70345Univ. Spare PartsEverett, MA210CC FanCC-82105ICC Syst.Wash. Street, Rox.84Cond. coil49350Int. CC SystemWashington St., Roxbury, MA104
Systems unaware of alternates (after all Dawn of Justice used the same climate control as many other Jeep models) and unable to understand that Stock, Qty, Availability mean the same - have no way of responding to that waiting customer.
On the input side too, without harmonized view of inventory, centralized procurement department created to drive economies of scale, does very little in rationalizing vendors or simplifying supply chain.
It’s not uncommon to receive call from a Telco’s local sales team offering an upgrade, just a day after one has signed up for same on the web. Absence of golden record, with subscriber’s personal, service, and related information, leaves the subscriber annoyed and sales representative frustrated. B2B insurance gets complicated with different divisions and geographies buying multiple disparate risk coverage from the same insurer. Policies are often distributed via different channels that may include third party agencies as well.
Policy HolderAddressIDMillennial Motors1200 Ilderton Rd, London SE15 1NP1003-495-7680MM Asia65/1 Obudan Street Manresa. Quezon City, PhilippinesNullBaltasar GoncalvesMM Europe1003-495-7688Pringle Motors (MM)Corporate Office1003-495-7700
Claim managers will have to struggle through these records manually - checking every address, asking colleagues, sieving thru’ past records before they can conclude that all of them roll up to Millennial Motors in London. Different policies were sold to its operating units by multiple agencies drawing from the central negotiated agreement.
Inconsistent levels of detail, missing fields or descriptions, missing or inaccurate classifications (if that at all exists) are daily challenges that operations teams across industries are living with.
Digital commerce has now made this problem truly explode. Localized field attributes is the challenge that every retailer is grappling with. The table below would give you a sense already.
SIZE0 10 20 30 40 50 60 70 911JPXSSMLXLXXL3XL4XL5XLUSXXSXSSMLXLXXL3XL4XLEU424446485052545658UK323436384042444648Heightcm155 ~ 165160 ~ 170165 ~ 175170 ~ 180175 ~ 185180 ~ 190185 ~ 195185 ~ 195185 ~ 195feet5'1 ~ 5'45'3 ~ 5'65'4 ~ 5'75'6 ~ 5'95'8 ~ 6'15'9 ~ 6'26'1 ~ 6'46'1 ~ 6'46'1 ~ 6'4Chestcm78 ~ 8682 ~ 9086 ~ 9491 ~ 9996 ~ 104101 ~ 109106 ~ 114116 ~ 124126 ~ 134inch31 ~ 3432 ~ 3534 ~ 3736 ~ 3938 ~ 4140 ~ 4342 ~ 4546 ~ 4950 ~ 53Waistcm66 ~ 7470 ~ 7874 ~ 8279 ~ 8784 ~ 9291 ~ 9998 ~ 106111 ~ 119124 ~ 132inch26 ~ 2928 ~ 3129 ~ 3231 ~ 3433 ~ 3636 ~ 3939 ~ 4244 ~ 4749 ~ 52Sleeve(Center Back)cm ~82 ~83 ~84 ~85 ~86 ~87 ~89 ~91 ~93inch ~32.3 ~32.7 ~33.1 ~33.5 ~33.9 ~34.3 ~35 ~35.8 ~56.6Neckcm ~34 ~36 ~38 ~40 ~42 ~44 ~46 ~50 ~54inch ~13.4 ~14.2 ~15 ~15.7 ~16.5 ~17.3 ~18.1 ~19.7 ~21.3
Should the production unit treat JP XS and US XXS as 2 different ‘products’? Or should that be done at the dispatch end? Add to this the challenges of different retail chains using different expressions to count inventory – stock, quantity, qty, available units and so on. Production planning, ATP check, distribution planning have never been this complex.
Big data analytics or AI enabled decision making can be impactful only with robust data governance. And data governance can only be attempted after masters are harmonized and standardized.
Until then customers will continue to
- receive telecom sales rep’s upgrade request calls even after signing up for the same
- be surprised to know that the climate control was always available, and
- wait for insurance claim processing for weeks