ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Optimal material layout (https://www.excelbanter.com/excel-worksheet-functions/85221-optimal-material-layout.html)

Paulymon

Optimal material layout
 
I have a roll of paper that has to be slit into 3 different widths, may be
more than one lane of each width. Lets say 5", 10" and 15".
I need to decide the best layout of the slitters that will be slitting this
parent roll to ensure the least amount of waste.
Is there a formula that I could use to figure the optimal layout or is this
something that I'll just have to figure manually.
At this time the width of the paper could be ordered around 48" total width
but could go +/- a few inches either way to accomodate optimal slitting.
Any help would be appreciated.


Gord Dibben

Optimal material layout
 
Try the free trial of CutListPlus.

A non-Excel application that optimizes cutting layouts.

http://cutlistplus.com/Default.aspx

Trial is functional enough for your purposes.


Gord Dibben MS Excel MVP

On Tue, 25 Apr 2006 13:52:02 -0700, Paulymon
wrote:

I have a roll of paper that has to be slit into 3 different widths, may be
more than one lane of each width. Lets say 5", 10" and 15".
I need to decide the best layout of the slitters that will be slitting this
parent roll to ensure the least amount of waste.
Is there a formula that I could use to figure the optimal layout or is this
something that I'll just have to figure manually.
At this time the width of the paper could be ordered around 48" total width
but could go +/- a few inches either way to accomodate optimal slitting.
Any help would be appreciated.




All times are GMT +1. The time now is 05:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com