Hi

Unless I am misunderstanding the problem, there is nothing for Excel to solve.
You want 13,000 posters. Company 3 is the cheapest cost. Use company 3.

Regards

Roger Govier


bentor wrote:
Hello,


I've been given a task and I think the most reasonable way to solve it
is by using Excel's Solver. Those are conditions of this task:

Some company needs to print 13000 posters. We've got 3 options:


Company 1:


<500 posters - $5,59 'per poster
501-1400 - $5,31
1401-1500 - $5,03
1500 - $4,59


transportation costs = $1,97 'per poster

Company 2:
(it only takes orders between 5000 to 10000 posters)

5000-1000 - $4,38


transportation costs = $1,99


Company 3:


<2000 - $4,75
2000-3000 - $4,35
3000-6000 - $4,29
6000-8000 - $4,23
8000 - $4,17


transportation costs = $1,9

Our job (or in fact Solver's job:) is to find quantitys that each
Company will print which assure us the best price per poster - in other
words: We want to print it as cheep as it's possible.


Looking forward to your help,
Bartosz Dlugokecki.