3 replies to this topic

[chemtoli]

How to begin solve this problem

 

 

A company has three plants that produce ethanol and four clients to whom the ethanol can be delivered. See the attachment

Attached Files

•  Minimizing cost using solver.pdf   21.35KB   10 downloads

Edited by chemtoli, 30 May 2023 - 03:42 PM.

[breizh]

Hi,

what did you do to solve this problem?

Attached a document to support your query:

https://cheguide.com...rogramming.html

 

my answer for the minimum of the objective function: 19183 unit price corresponding to an average delivery price :81.63 unit price per ton.

Good luck.

Breizh 

[chemtoli]

Hi,

what did you do to solve this problem?

Attached a document to support your query:

https://cheguide.com...rogramming.html

 

my answer for the minimum of the objective function: 19183 unit price corresponding to an average delivery price :81.63 unit price per ton.

Good luck.

Breizh 

 

Dear Breizh, I found constraints and build excel table but I  couldn't go further. (please see attached files pdf and xlsx)

Attached Files

•  min delivery cost.xlsx   11KB   7 downloads
•  Minimizing cost using excel Solver.pdf   79.58KB   6 downloads

Edited by chemtoli, 31 May 2023 - 05:02 PM.

[breizh]

Hi,

Attached my calculations.

I believe the doc from Chemcalc should help you out.

hope this is helping you.

Breizh