Ask Mr. Excel - Answer to Challenge of the Month

Current Challenge Past Challenges

About MrExcel

Consulting Services

Learn Excel Resources

Challenge of the Month

Past Challenge

March 1999 Challenge: You are a buyer of steel for a construction company. From the various project plans, you compile the number and sizes of steel needed for tomorrow's projects. Your suppliers only sell steel in 20, 30, and 40 foot pieces. How can you find an optimal number of bars to order in order to minimize scrap?

We never found a solution to this challenge. Kudos to Peter Tesler, who came the closest to solving this extremely complex problem.

MrExcel.com Consulting can be hired to implement this concept, or many other cool applications, with your data.

MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.

Excel is a registered trademark of the Microsoft® Corporation.