Need Help with BOM

Hello Everyone,
I have scenario where I need help. We are a steel processing business. We purchase steel coils and manufacture bars out of it.
Now the scenario is (example):
I purchase 1 steel coil which is around 2 tons, and produce straight bars out of it. These finished goods are marked as bundles. Each bundle has 422 bars.
Now when I process 1 coil. I get 480 bars which is 1 bundle (422 bars) and 58 bars.

Now the question is:
How can I create a BOM where I use 1 coil as Raw Material and get 2 different products.?

Or is there any work around out of this?

Any help will be highly appreciated.

https://docs.erpnext.com/docs/v14/user/manual/en/manufacturing/articles/how-to-handle-a-scenario-of-1-raw-material-multiple-finish-goods

See if that would work for you

You could create a different batch for each produced bundle.