I would like to use excel to help my work. My work concern about
planning to slit steel from big coil to small coil by specific size.
Sample :
- Mother coil width = 1,000 mm. (for every coil)
- Slit coil Type_1 width = 42 mm. Q’ty need = 200 Coil.
- Slit coil Type_2 width = 50 mm. Q’ty need = 300 Coil.
- Slit coil Type_3 width = 62 mm. Q’ty need = 50 Coil.
- Slit coil Type_4 width = 70 mm. Q’ty need = 40 Coil.

How can I use excel to calculate this problem for smallest scrap?