• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Manufacturing Question: Optimum Yield of Sheet Material

Y

Yufan Chen

New Member
Hello,

I run a small picture frames manufacturing company. We run into a lot of jobs that have a large quantity of pictures at different sizes. Picture framing uses sheet material such as glass and mat board, which is usually cut out of larger stock size sheets.

I want to use excel to calculate the optimum yield when cutting a large volume of various smaller sized sheets out of large stock sized sheets.

Example

Customer order for glass:
20 sheets of 8 x 10"
20 sheets of 20 x 24"
20 sheets of 32 x 40"

Stock sizes of glass:
40 x 60" (unlimited sheets)
48 x 96" (unlimited sheets)

The customer's order will be filled by cutting down the stock sizes. How do I setup a table with the proper formulas to calculate the optimum yield?

Thank you!

-Yufan
 
Hi, Yufan Chen!

As a new user you might want to (I'd say should and must) read this:
http://chandoo.org/forum/forums/new-users-please-start-here.14/

And regarding your issue, it's a classic problem sometimes analyzed at college or university, one not so easy to face here, I guess. Have you tried Google search? Then if found anything it'd be easier to translate it to VBA than writing the whole stuff from scratch.

Keywords should be two-dimensional rectangular packing.

Regards!
 
Hi Yufan ,

There is readily available software which can do this job for you. And it is not costly.

If you put in the terms : sheet cutting optimization software in Google , you will get plenty of results ; we have used one of them , whose link is :

http://www.tmachines.com/index.htm

Narayan
 
You must log in or register to reply here.
Back
Top