Thread: How to force solver or excel to take the maximum productio per line

Hi all,

I have three lines producing three different products, the prodcut can be produced on two or more lines, but the problem is that, each line has different performance per product.

Example: line 1 can produce X1 at a rate of 35 ton/hr and X2 @ 40 Ton/hr and x3 @ 36 t/h. so the capacity of this line is calculated based on the best demonstarted performance when producing combined prodcuts in one year. But look to the capacity if the line is producing only the highest two grades (X2 & X3 ) , then the line will have higher yearly production (higher capacity). Solver we you run it it will asume that all products are produced at the same rate
In the attached file, you will see a simple example using solver, so the problem is that I need excel or solver when it starts to allocate the yearly production per line; first to look at the highest rate for each product and to start the production of that product first untill I the grade reached/exceed the planned amount or the line capacity, then it should look to the second highest and so on. Please put in mind that the best demonstarted rates are per hour.

Simple example1.xls

Thank you Dilip for your welling to help.

Please not that the figures that I put in my post is only for explaination. But the attached file has the actual data, so you will not see the firures in the actual file.

Setting up Solver for max hourly throughput see tag "Max_production"

Alf

Thank you Alf,

the point here is that, solver some how (or excel) should recognize the highest without having them part of the solution. but solver will start the production of the grade on the highest line and the remining demand for the same product from the second highest.

Thx