Business Problem:
A manufacturer of Rice Bran oil wanted to solve the problem of purchasing raw materials from various vendors as prices of raw materials fluctuate every day
Main Objectives:
Rank raw material suppliers based on various parameters, to save manufacturing costs
Rank customers based on various parameters, to increase margins per sale
Impact Created:
Ranked all the vendors daily (historically for 2 years) on the parameters of price, quality, quantity, and delivery frequency.
Ranked all the customers based on a monthly period (historically for 2 years) on the parameters of quantity, payment frequency, effective selling rate, and purchase frequency.
Reports were standardized periodically to improve purchasing decisions and increase organizational communication and collaboration between the sales teams across different regions.
Data visualization projects were implemented monthly to improve the analysis and decision-making of data that was originally in SAP.
Comments