Project Explanation | Data Analytics for Optimal Steel Rod Cutting and Scrap Management | 360DigiTMG
1 Video View·Nov 7, 2024
Good evening friends, this is Sivakumar.
Today I'm going to explain the project regarding one of the leading companies in India.
The company operates three distinct manufacturing divisions.
So here the three divisions are one of the solar division and the second one is railway and the third one is TLT.
We have worked on this TLT division only.
These are our transmission line towers.
You know that the power transmit from the generating station to a distribution, right?
The big towers in the outskirts of the cities.
These are the raw materials for manufacturing these towers.
The problem is here.
These raw materials are common to all three divisions.
Two of the raw materials, right?
These raw materials have been of different dimensions and different grades such as high-tension and mild steel.
So the problem is here too.
The client is procuring the raw material.
So as part of procurement, a lot of waste is generated.
So our goal is to minimize the scrap.
The constraint is we're going to maximize the material use in all three divisions, right?
So this is the overview of this project.
So coming to this, as part of this, this is the entire flow of this project.
We're collecting the data from this database.
So here the data contains around five distinct towers.
There are 18 extension and 0 extension and 9 meter extension transmission towers.
So regarding this, the height of this tower and those materials, the length of the material with everything is here.
So we're going to pre-process the data using a Python and we have some pre-processing,
setting values in this few of these columns.
So then finally we are creating the dashboard for this using Power BI and Tableau as well.
So this is a high-level dashboard.
Here we can see this different MSL 90 90 by 6.
This is one kind of L means L angles.
MS means grade.
This is different columns.
MS is the grade column and we are combining this grade and the dimension of this prod.
So the ultimate goal is to minimize the scrap.
So come up with this dashboard.
But all that you can see is this normal tower and 0 meters extension and 18 meters and 25 meters and 9 meters extension.
So there are distinct sections of 55 distinct sections around all these towers.
Means different L angles are there with different lengths.
The same L angle with different length and width.
You know, right?
So this is the high-level information.
You can choose the tower wisely.
What are the all the raw materials are common to all the towers.
What are the common raw materials around all these things.
And finally we've come up with this optimal.
There's one more problem.
The problem is this is the standard rods are available at 6 meters and 12 meters.
These are the standard raw materials.
We need to cut this as per our requirement.
That's it, that's it.
Thank you for joining us and stop sharing.

