Remaining shelf life and expiry risks systematically taken into account in materials planning
Situation
A manufacturer of durable and perishable products managed material supply through an ERP system. In quantity planning, existing batches could cover a requirement on paper even though their remaining shelf life was no longer sufficient for the intended use.
Challenge
Planning had to take into account not only the available quantity but also the actual usability of stock. Without suitable rules, there was a risk of planning errors, short-term reordering or the use of batches with too little remaining shelf life. At the same time, changes to master data, system logic and operational processes had to be aligned.
Approach
Within supply chain management, we developed internal shelf-life groups and agreed the associated process rules with the functions involved. Together with IT, we prepared the maintenance of item and batch data in the planning systems. For critical materials, we checked the theoretically available stocks and carried out manual recalculations where necessary. Control and reporting mechanisms were also planned.
Outcome
The shelf-life groups were set up in the systems concerned, and the procedural rules were largely agreed. For individual materials, planning had already been corrected manually; further system approvals were still pending. This created a more concrete basis for taking remaining shelf life into account in replenishment. A complete technical elimination of all planning risks had not yet been achieved.