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.