Linfox

Systems & data

Linfox

Linfox: tools and process in a brand-new 3PL warehouse.

Problem

A brand-new 3PL warehouse for Woolworths and Big W needed standing up: stock, systems and process at the same time, while the operation was live. Data moved by hand between Excel and SAP, and every manual step was a place for stock to drift and picks to slow down.

Diagnosis

In a launch like that the two risks are manual data entry and undocumented process. Both failures show up later as wrong stock and wasted picking time, and both are fixable in place: automate the Excel to SAP paths, and write the process down as the site comes up.

Action

  • Built and maintained Excel tools using VBA to automate the extraction and entry of data to SAP
  • Used SAP WM to convert customer orders into picking work
  • Implemented goods receival procedures for incoming shipments
  • Maintained inventory control and accurate records
  • Analysed SAP WM data to find trends and improve order processing
  • Created work instructions to standardise warehouse processes
  • Worked across functions in the DC to build tools, support and train teams

Outcome

  • The warehouse launched and operated with automated data flows between Excel and SAP
  • Documented, standardised processes and work instructions the teams used
  • Better order processing from analysing SAP WM trends
  • Teams trained on the tools and the process

What I'd do differently

Pending

Reflection to be written by Jupiter.

Clock
--:--:--—Local time