ANLY482 AY1516 G1 Team Skulptors - Inbound EDA

HOME

ABOUT US

PROJECT OVERVIEW

DATA ANALYSIS

PROJECT MANAGEMENT

DOCUMENTATION

Data Cleaning

Inbound EDA

Outbound EDA

Putaway Location Analysis

Most of the inbounds putaway location is TEMP or FLOORS. This indicates a detrimental issue of overloading, whereby the warehouses ran out of space to store the goods. There can be another possibility, where the storehouse is not properly utilized, and thus temporary and floor areas are used predominantly.

Motivation

The complication of big data resonates strongly with the company, much like many others. The Warehouse Management System (WMS) captures data of logistics supplies in the warehouses of the company, such as quantity of movement, time of movement and identification codes of the packages stored. With extensive data provided by the WMS, analyzing of spreadsheets can be cumbersome and inefficient due to visualization impediments. The company is unable to effectively analyze and sculpt solutions as a result.

In addition, the company is in the midst of implementing a vertical lift high-tech system for its new warehouses in its upcoming Supply Chain City (SCC) project. In light of these recent developments, the company saw an opportunity to better analyze their WMS data to determine its Stock Keeping Unit (SKU)’s inbound rate, outbound rate, warehouse utilization trend, and ideally, by performing the aforementioned analysis, categorizing each SKUs into namely A, B, C categories. ‘A’ category refers to fast moving SKUs while ‘C’ category SKUs refers to slow moving SKUs.

With the analyzed results, the company hopes to determine the optimal warehouse location and vertical lift in which a particular SKU can be placed for picking. In addition, the company would also like to see the extent of productivity savings it can obtain with the adoption of a batch picking technique instead of an order picking technique. Order picking involves going into the warehouse to collect the supplies per order basis, while batch picking involves collecting for multiple orders in a batch.