iA - Inventory Academy Client Pre-engagement Checklist

• Conducted on

  Date

• Prepared by

• Location
  Address

Executive Directions

• Does the company have a policy of shelf stock and velocity? (ie. to hold 'x' weeks worth of stock on the shelf)

  Yes

  No

  N/A

• Does the business have a Risk Management policy?

  Yes

  No

  N/A

Inventory Management functions

• How often are Position Descriptions reviewed for relevance against current processes?

  Quarterly

  Bi-annually

  Annually

  Never

• Is there a scrap/environmental policy?

  Yes

  No

  N/A

Software management

• What type of software is used for the inventory management function?

  Select SAP MILIS Oracle JD Edwards Pronto WMS Manhattan WMS Exceed MS Dynamic MYOB QuickBooks Other

  • SAP
  • MILIS
  • Oracle
  • JD Edwards
  • Pronto
  • WMS Manhattan
  • WMS Exceed
  • MS Dynamic
  • MYOB
  • QuickBooks
  • Other

• How many spreadsheets have been created to support the inventory functions?3

  1-3

  4-7

  7+

  0

• Does the inventory team manage the system Master Data?

  Yes

  No

  N/A

KPI's

• Can you export a detailed Locations report to Excel?

  Yes

  No

  N/A

• Can you export a detailed Stock on Hand report to Excel?

  Yes

  No

  N/A

• Can the above reports be easily modified?

  Yes

  No

  N/A

• Are KPI's used inline with inventory functions?

  Select Yes No N/A

  • Yes
  • No
  • N/A

• ○ SOH value - compare against budget forecasts (filter to define excesses and stock-outs)

  Yes

  No

  N/A

• Stock Turn Ratio

  Yes

  No

  N/A

• Months Stock on Hand - (SOH/average demand)

  Yes

  No

  N/A

• ○ Wastes - how defined and acceptable levels

  Yes

  No

  N/A

• ○ Excess inventory

  Yes

  No

  N/A

• ○ Obsolete inventory

  Yes

  No

  N/A

• ○ DIFOT

  Yes

  No

  N/A

• ○ DOT

  Yes

  No

  N/A

• ○ DIFOTIS

  Yes

  No

  N/A

• ○ Empty pick faces

  Yes

  No

  N/A

• ○ Empty reserves

  Yes

  No

  N/A

• ○ OOC SOH value

  Yes

  No

  N/A

• ○ Stocktake progress

  Yes

  No

  N/A

• Were the KPI's designed from metrics or system created?

  Metric

  System

  N/A

Communication & Training

• Communication - how frequently are Inventory Toolbox discussions held?

  Daily

  Weekly

  Monthly

  Never

• How often is formal inventory training conducted?

  Daily

  Weekly

  Monthly

  Never

Purchasing

• Does the inventory staffs also perform purchasing functions?

  Yes

  No

  N/A

• Are financial delegation approval levels used?

  Yes

  No

  N/A

• Do staffs manage MIN MAX calculations?

  Yes

  No

  N/A

Continuous Improvement

• Is a slotting tool used for warehousing efficiencies?

  Yes

  No

  N/A

• Does your IMS contain pick path function?

  Yes

  No

  N/A

• How often is it run/reviewed?

  Daily

  Weekly

  Monthly

  Never

• Does the site engage with any Production Platforms (eg. TQM, Lean, Six Sigma)

  Yes

  No

  N/A

• How often are the reporting metrics reviewed?

  Daily

  Weekly

  Monthly

  Never

• Is 5S use evident?

  Yes

  No

  N/A

• Are processes measured on site for benchmarking purposes?

  Yes

  No

  N/A

Safety

• MHE use?

  Compliant

  Non-Compliant

  N/A

• Safety equipment?

  Compliant

  Non-Compliant

  N/A

• Traffic Management

  Compliant

  Non-Compliant

  N/A

• Does the site comply with general safety requirements?

  Yes

  No

  N/A

• Racking?

  Compliant

  Non-Compliant

  N/A

• Select date

  Date

• Add signature

  Sign

• Add signature

  Sign

• Is the warehouse layout conducive to operational efficiencies?

  Yes

  No

  N/A

• Are the SKU slots best suited for the type of inventory?

  Yes

  No

  N/A

• Is the warehouse flow logical - In/Out without cross over?

  Yes

  No

  N/A

• Is there excessive space available?

  Yes

  No

  N/A