ANLY482 AY2017-18 T1 Group2
In our project, we will focus on how to help Johnson & Johnson to do analysis about the price of the materials they use to produce baby oil, which can help them make better decisions when purchasing materials. This can add value to their business since it can let them save cost and provide better service to customers. The data we can get from Johnson & Johnson mainly includes: the list of materials and price for them, vendor information and the relationship between each plant and distribution center. Johnson & Johnson has many plants and distribution centres all over the Asia. So, from the data, we can see the shipment flow of materials and the locations of the plants. To help J&J better understand their data, first thing we will do is to use some data visualization tools to visualize the shipment relationship between each plants and distribution centres. Then we will compare the shipment in different areas in details. Ideally, we would like to identify somel the factors contributing to the variance of the material’s price and the shipment price.