Background

The material management department needs the daily consumption of caustic to order the correct amount from suppliers and avoid shortages or excess.
This is calculated from the reactor's weight sensor after each of the approximately 20 daily discharges.
Before TrendMiner, we manually recorded these weights, a tedious process prone to errors, missing data, and a lack of consumption analysis.

Challenges

Understand the normal daily raw material consumption to request the needed amount from providers and optimize inventory space.

Solution

1. Create a formula to create the derivative of the reactor weight only when it's negative (discharge).

   

    

2. Value based search to search every day in the last 6 months

3. 

   Add calculations with the day name and the integral of the formula (daily consumption)

4. 

   Export report

Results and value

-A report of the last 6 months was created in 10 minutes, the same amount of time that it takes to manually get the report of 1 day. From now on, only 1 click is needed to get the updated report.

-Seamless source of information to efficiently order the needed raw materials

-Around 15 mins savings per day -> 3.1% of the time -> 1875€/year (50h/year) savings

-Data analysis and visualization in enabled to analyze differences and keep the consumption with the least variability.

-No shortages or leftovers thanks to the data driven and accurate raw material order.