ANLY482 AY2017-18 T1 Group1/Project Overview

Home

Team

Project Overview

Midterm Progress

Final Progress

Project Management

Documentation

Motivation

Our group comprises of 2 business students and 1 accountancy student, all having a second major in analytics. As final year students, we realise that there is a need to familiarise ourselves with analytics in the working world. This module serves as an opportunity for us to undergo a project with XYZ which would give us more experience on a real-life working world situation. These hands on experience are invaluable that cannot be taught in a classroom environment. We hope this internship-like experience with XYZ will prepare us for our jobs in the future.

Objective & Goals

XYZ wants to increase profits by reducing their costs. However, the company is plagued by data problems which makes the task of optimizing their supply chain very difficult.

Their data are stored in many locations and are often transferred using excel files. This results in inconsistency and incoherence in their data sources which makes analysis extremely time-consuming. On average, the company takes 30 days to consolidate the data on excel and produce a report.

There is also no standardized way of labelling certain items. For example, raw materials such as bottles are labelled as ‘botl’ or ‘btl’ in other regions. Thus, consolidating the data requires manual override of the labels in excel, prolonging the process unnecessarily.

To aid in their roadmap to optimize their supply chain, our team will be developing a proof-of-concept model to aid in identifying redundant costs. We will begin this by analyzing the supply chain data for a product (e.g. baby oil). This product has relatively fewer levels of abstraction which makes modelling easier. The model can then be scaled to add additional levels for more complex products.

We will identify factors that results in the cost complexity such as:

• Freight cost
• Regional labour cost
• Raw material cost
• Distribution cost
• Storage cost
• Tax laws

Provided Data

Text here

Methodology

Text here

Project Scope

Text here