Before
Materials carried a different number per plant, duplicates by manufacturer part number were common, and planning parameters had been set once at creation and left; a lead time from years ago still drove purchase proposals.
Ahead of a planning-system integration of more than 1,000 tables, the company mastered its materials and planning parameters across plants, so the planning run started on one golden item list and on parameters somebody owned.
Materials carried a different number per plant, duplicates by manufacturer part number were common, and planning parameters had been set once at creation and left; a lead time from years ago still drove purchase proposals.
Golden materials from the plant ERPs matched on manufacturer part numbers and physical attributes, with 61,000 duplicates merged; planning parameters as time-phased governed values for 2.9 million item-site combinations; the lead-time rule comparing each parameter with actual receipts; the Backbone loading the golden items and hierarchies into the planning system with the nine checks.
Every Monday the rule queues the parameters that drifted from actual receipts for the planners; the planning system reads the golden items and hierarchies; the gap list that used to be a spreadsheet is the steward queue.
anonymised engagement
material records mastered across plants.
anonymised engagementduplicates by manufacturer part number merged before the planning run.
anonymised engagementitem-site combinations with governed planning parameters.
anonymised engagementtables in the planning integration fed from the golden records.
anonymised engagementSlot for the customer's own words: supplied and approved by the reference contact before publication. The story above is written in Lima's voice from the engagement material; the customer's feedback goes here in theirs.
Run the manufacturer-part-number match on live rows first and let the planners see the duplicates as a queue, before any parameter rule is written.
Under NDA, with the account owner's approval, we arrange a conversation with a customer whose domains and systems resemble yours.
Bring two systems that hold the same customers, suppliers or materials. In one working day we connect them, run the match on live rows, review the queue with your steward and publish the first golden view with its API.