DRP + MPS = Network Optimization?

DRP + MPS = Network Optimization?

Network Optimization

Network Optimization

Cristina Radu

๐Ÿšš DRP (Distribution Requirements Planning) is a process used to plan inventory replenishment across the distribution network. The right products are delivered to the right locations at the right time, optimizing stock levels and minimizing costs.

The main activities are calculating net requirements and scheduling stock transfers (STRs) - when and how much - from upstream locations (e.g., from central warehouses or manufacturing plants) to meet the net requirements on time
considering lead times capacity limitations at both supplying and receiving nodes.

๐Ÿ”ข Net Requirements = Forecasted Demand + Safety Stock - (On-hand Inventory + Scheduled Receipts).

๐Ÿญ The MPS (Master Production Schedule) provides a schedule for manufacturing: which finished goods need to be produced, how much and when.

The activities are inventory check (on-hand inventory, WIP, scheduled production), capacity & constraints review and plan production based on requirements, inventory, and capacity.


๐Ÿšฒ Letโ€™s say a company manufactures electric bikes.

DRP: in the Netherlands the forecasted demand in the next 2 weeks is:

Amsterdam DC needs 50 bikes (30 + 20)
Eindhoven DC needs 40 bikes (30 + 10)

On-hand inventory: 10
Safety Stock : 5

๐Ÿงฎ Net Requirements (50 + 40) + 5 - 10 = 85 โ†’ tells Rotterdam plant how much it needs to supply.

MPS receives the net requirements and schedules production in the plant:

Week 1: Build 45 bikes
Week 2: Build 40 bikes

Note that the demand in week 1 is 60, but we can only cover 55: 45 + 10.

๐Ÿง  How does one take the best decision for the remaining 5 bikes?

In summary:

DRP โ†’ MPS: โ€œThis is how much bikes we need, when.โ€
MPS โ†’ DRP: โ€œThis is how much bikes we can produce and deliver.โ€

๐Ÿ” These two processes are generally done separately and there is a feedback loop: if production can't meet DRP requirements (due to capacity, materials, etc.), MPS sends feedback to DRP which adjusts transportation schedules, or even customer delivery dates.

Typically the planning is done using separate tools, e.g. ERP system (DRP) + Excel (MPS), or ERP + APS (no optimization) or Excel + Excel etc.

In an optimization type of solver we can do BOTH at the same time.

The input data is extracted from the ERP system and the results are send back to the ERP.

ERP -> Optimizer -> ERP

The solver considers all of the inputs, activities, constraints of MPS + DRP at the same time:

๐Ÿ”ท aggregate demand over the full network
๐Ÿ”ถ calculate net requirements
๐Ÿ’Ž automatic MRP
๐Ÿ”ท check production and distribution constraints
๐Ÿ”ถ plan transfers (STRs) and customer shipments (how much and when)
๐Ÿ”ท plan production (how much and when)
๐Ÿ”ถ chose from which location to serve the customer demand
๐Ÿ”ท optimise production, inventory and transportation costs

The feedback loop happens instantly. This saves a lot of (planning) time and gives the full optimised picture of the end-to-end network.

For the sake of completeness we can say that MPS + DRP + MRP + MEIO = Network Optimization. Agree?

๐ŸŽฏ Anything to add?

2021โ€“2024 ยฉ

2021โ€“2024 ยฉ

Mathematical optimization for business

Mathematical optimization for business