Hi

I still can't see that it needs Solver.
The cheapest solution is to split the order into 2 orders of 6,500 each and
place with company 2. Total Cost = 6500 x (4.38 + 1.99) x 2 = 82,940

If they won't accept the 2 orders of 6500 each, then place the maximum order
of 10000 with them = 10000 x (4.38 + 1.99) = 63,800

The balance needs to be placed with company 1 as their's is the next lowest
cost = 6.56 (4.59 + 1.97) x 3000 = 19,680

This then gives a total cost of 83,480 or 540 greater than the "cheapest"
solution.


Regards

Roger Govier


bentor wrote:
Sorry for all that..
it should be $2.4.. I need get some coffee.. :-)

So. The problem is.. There are 3 companys that can print for our
posters. They can do that according to price-list. It's obvious that
more we order the best price we can get. But for example we can't
print all 13000 posters in Company 2, becouse of theirs 10000 limit.
So.. there are few conditins that we have to consider, like the best
price in Company 3, but transport is most expencive.

Problem is to make Solver to consider all our requirements including
different price per poster dependent of quantity which we order in
each Company.

--
Bartosz Dlugokecki