linerar/integer programming problem
 

Hello, from maths pygmy.

I can describe this problem in words, but not put it into any mathematical
form. Can someone help by suggesting a method for solving it with xl
spreadsheet?

A client of mine sells lengths of aluminium window parts at 6.5 m length.
He has customers who want to buy it at various lengths, in various
quantities, and want to reduce the amount of wastage. E.g.:
30 lengths at 1 m, 25 at 1.5, 25 at 2. How can you work out the smallest
amount of 6.5 m lengths to buy to achieve this? (i.e. the least amount of
wastage)


Sorry for the lameness of the question, but he's a good client and thinks
I'm a whizz with computers just because I design his web-site. I hate to
disappoint.

--
Ben
(check my email address before sending)

linerar/integer programming problem
 

Well, i'm not really shure ....

but what about the formular:
int(quantity * length / 6,5) + 1 = count of 6,5 pieces.

Implement this formular in your spreadsheet.
Does it meet your ideas ?

Manfred


-----Original Message-----
Hello, from maths pygmy.

I can describe this problem in words, but not put it into
any mathematical
form. Can someone help by suggesting a method for solving
it with xl
spreadsheet?

A client of mine sells lengths of aluminium window parts
at 6.5 m length.
He has customers who want to buy it at various lengths,
in various
quantities, and want to reduce the amount of wastage.
E.g.:
30 lengths at 1 m, 25 at 1.5, 25 at 2. How can you work
out the smallest
amount of 6.5 m lengths to buy to achieve this? (i.e. the
least amount of
wastage)


Sorry for the lameness of the question, but he's a good
client and thinks
I'm a whizz with computers just because I design his web-
site. I hate to
disappoint.

--
Ben
(check my email address before sending)
.

linerar/integer programming problem
 

http://www.woodbin.com/docs/software...m#2D%20cutting

http://www.delphiforfun.org/Programs/CutList.htm


--

John

johnf202 at hotmail dot com


"ben h" wrote in message
...
Hello, from maths pygmy.

I can describe this problem in words, but not put it into any mathematical
form. Can someone help by suggesting a method for solving it with xl
spreadsheet?

A client of mine sells lengths of aluminium window parts at 6.5 m length.
He has customers who want to buy it at various lengths, in various
quantities, and want to reduce the amount of wastage. E.g.:
30 lengths at 1 m, 25 at 1.5, 25 at 2. How can you work out the smallest
amount of 6.5 m lengths to buy to achieve this? (i.e. the least amount of
wastage)


Sorry for the lameness of the question, but he's a good client and thinks
I'm a whizz with computers just because I design his web-site. I hate to
disappoint.

--
Ben
(check my email address before sending)

linerar/integer programming problem
 

Hi ben,
PLUS 1D - Bar nesting software for 1D stock cutting applications
like cutting of pipes, bars, channels, extrusions, lengths etc,
would be perfect for the job.

There is a demo verison, that should be sufficient for small problems.

http://www.nirvanatec.com/downloadcenter.html

hope it helps,
cheers,
s.shrikanth