← All expertise Expertise

Materials & inventory

About 1,100 parts kept available, seven days ahead.

SAP PP / MMMD04MRPExcel/VBA
~1,100parts monitored daily
60 → 5–10 minshortage report per run

Day to day

Materials coordination for the same programme: about 1,100 actively monitored parts on models carrying 1,300+ BOM components.

  • Ran the daily shortage report across about 1,100 active parts, on models carrying 1,300+ BOM components.
  • Looked seven days ahead and found the lot at which each shortage would hit the line.
  • Expedited with Supply Chain, Stores and the Karachi plant: about 1 day by air, 3 by fast-track, 4 by container.
  • Reconciled physical stock against SAP and moved non-conforming material to Quality Inspection or Blocked.

How it runs

  1. ConsolidateStock, material data, inter-plant information and logistics updates pulled together each day.
  2. What is shortCurrent and coming shortages, with SAP status for each.
  3. When it hitsProjected balances against the lot and day each part is needed.
  4. Will it arriveInbound quantities and ETAs checked; escalate or expedite if not in time.

What I know

What I know

MRPBOM-based requirementsSafety stock policyStock types (unrestricted, QI, blocked)Inter-plant supplyOutside processing (OSP)Expediting & lead timesStock reconciliation

Safety stock tiers I worked with

Four policy tiers by supply route and risk, from about 1 day of cover for JIT parts to about 20 days for hardware and long-lead items.

What I improved

Planning should turn complexity into action.

Open to Production Planner, Materials Planner, Production Controller and Supply Chain Planning roles in the UK.

ContactStraight to my inbox

Send me a message

I’ll reply to the email address you give here.