IB
ProfessionalSupply Chain2026

Supply Planning

Deciding what to order and when relied on the buyer's experience and on Excel exports rebuilt every week. This tool brings stock levels, sales history and supplier constraints together in one place, then proposes a dated order plan. The buyer adjusts whatever they want before validating: the tool prepares the work, it doesn't decide in their place.

Business value

Fewer stockouts on fast-moving references, less capital tied up in overstock, no more rebuilding the need by hand

Who it's for

Buyers and the supply team

Who it helps

Buyers who rebuilt their replenishment needs by hand every week, and logistics teams left dealing with stockouts and overstock

Input

SAP stock levels, sales history, lead times and minimum order quantities per supplier

Output

Order proposal per supplier with a trigger date, adjustable before validation

How it works

Buyer

Starts from their own range of references

suppliers, seasonality, priorities

SAP data

The tool pulls the data needed for the calculation

  • ·Stock on hand and on order
  • ·Sales history per reference
  • ·Lead times and minimums per supplier

Requirement calculation

The tool projects coverage and proposes an order plan

  • ·Stock coverage per reference
  • ·Recommended trigger date
  • ·Alerts on stockout risk

Buyer arbitration

The buyer adjusts the proposal before validating

  • ·Quantities editable line by line
  • ·The business decides on edge cases

Validated order plan

The requirement goes out to the supplier

  • ·Fewer stockouts on fast-moving references
  • ·Less capital tied up in overstock

Stack

PythonPandasSAP