ANLY482 AY2017-18T2 Group03 Project Overview

HOME

ABOUT US

PROJECT OVERVIEW

DATA ANALYSIS

PROJECT MANAGEMENT

DOCUMENTATION

MAIN PAGE

Previous		Current

Motivation

The company has stayed ahead of their competition by embracing technology in the early days and now, they are starting to dabble into analytics in order to help make use of the large amount of data that they have generated throughout the course of their business. Currently, these information is being stored in their proprietary Warehouse Management System (WMS) which captures transaction information whenever goods are moving in, out or within the warehouse.

The amount of information being managed by the system is massive and it is very complicated, thus managers have to spend time to use pivot tables in excel to better visualize the information being generated in order to get a better view of how the current operations is being run. This uses up valuable time which could have been used for other more important operational matters.

One important information that is very useful to a warehouse manager is an ABC analysis which is an inventory categorization technique. The purpose of this analysis is to classify the inventory into 3 categories. One possible way of doing categorization is shown below.

• ‘A’ items – 20% of the items accounts for 70% of the annual consumption value of the items.
• ‘B’ items - 30% of the items accounts for 25% of the annual consumption value of the items.
• ‘C’ items - 50% of the items accounts for 5% of the annual consumption value of the items.

Not only that, in order to provide even more better insight for their customers, they would also like to be able to have a better view of the seasonality patterns of the products, as well as an affinity analysis of the products to further improve the way the products can be organized in the warehouse to increase the efficiency of the warehouse operations.

Objective and Goals

The main objectives of the project would be to do the following:

1. Create a Operations Dashboard to visualize the following KPIs

Inbound / Outbound Volume over time chart The purpose of this chart is to visualize the operations performance at various time slices so as to allow operations to have a clear view of the inventory movement patters for the various SKUs X-axis: Time unit (day, week, month, quarter, year) Y-axis: No. of units of product Lines: Each line would symbolize the trend for a different SKU.

Product Ranking Chart The purpose of this chart is to find out which are the best-selling items and which are the least popular items. Treemap view of the products filtered by month / year Product Seasonality Chart The purpose of this chart is to see the seasonality factors of the different products. X-axis: Month of the year Y-axis: Number of pallets Actual Overtime Hours Chart (Dual-axis chart), these charts will be made up of 2 lines, one for the total number of overtime hours incurred and another being the total number of containers that were completed for the day. One chart will be used for the morning shift and another chart will be used for the night shift. The purpose of this chart is to visualize the number of overtime hours for the month in a timeline view so that managers can see the overtime performance of the operations in relation to the number of additional containers that need to be serviced for the day X-axis: Date of the month Y-axis: Number of overtime hours Y-axis: Number of containers Overtime Performance Analysis Chart The purpose of this chart is to use the historical timings to come-up with a baseline overtime hour required for varying number of additional containers. X-axis: Number of containers over the threshold limit Y-axis: Average time taken to complete the additional order 2. Validate if the current operation performance is in-line with the baseline performance of 7 containers of inbound and 7 containers of outbound per working shift.