Smallest costs. [Excel.Solver]

[bentor]

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.

 

[bentor]

Oh..

there's a mistake.. "Company 3" transportation cost is $24, not $19.

Sorry for that.

 

[bentor]

$2,4 of course..

...I definitely need coffee. =)

 

[Tushar Mehta]

See the responses to the multi-post in .excel.misc.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

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:

{snip}