I need someone that knows solver for excel with parameters
Toledo
| Optimal Shipping Strategy | |||||||
| A | B | C | Shipped | Supply | |||
| 1 | 0 | 0 | 209.9999999998 | 209.9999999998 | 210 | ||
| 2 | 140 | 0 | 0 | 140 | 140 | ||
| 3 | 79.9999999994 | 60 | 10.0000000003 | 149.9999999997 | 150 | ||
| Toledo | 0 | 160 | 0 | 160 | 160 | ||
| Received | 219.9999999994 | 220 | 220.0000000001 | ||||
| Demand | 220 | 220 | 220 | ||||
| Shipping Cost Per Unit | |||||||
| A | B | C | |||||
| 1 | $ 10.00 | $ 14.00 | $ 10.00 | ||||
| 2 | $ 12.00 | $ 17.00 | $ 20.00 | ||||
| 3 | $ 11.00 | $ 11.00 | $ 12.00 | ||||
| Toledo | $ 18.00 | $ 8.00 | $ 13.00 | ||||
| Minimal Cost: | $ 6,720.00 | ||||||
| Note: Since total supply = total demand | |||||||
| all supply and demand constraints | |||||||
| have the equality sign. |
This is the area reserved for the decision variables.
Demand Constraints
Supply Constraints
Don't forget to click on the "Assume Linear Model" and "Assume Non-Negative" check boxes from
If you are using Excel 2010, please note the minor changes as shown below.
Cincinnati
| Optimal Shipping Strategy | |||||||
| A | B | C | Shipped | Supply | |||
| 1 | 0 | 0 | 210 | 210 | 210 | ||
| 2 | 70.0000000003 | 69.9999999995 | 0 | 139.9999999997 | 140 | ||
| 3 | 0 | 149.9999999994 | 0 | 149.9999999994 | 150 | ||
| Cincinnati | 149.9999999992 | 0 | 10 | 159.9999999991 | 160 | ||
| Received | 219.9999999994 | 219.9999999989 | 220 | ||||
| Demand | 220 | 220 | 220 | ||||
| Shipping Cost Per Unit | |||||||
| A | B | C | |||||
| 1 | $ 10.00 | $ 14.00 | $ 10.00 | ||||
| 2 | $ 12.00 | $ 17.00 | $ 20.00 | ||||
| 3 | $ 11.00 | $ 11.00 | $ 12.00 | ||||
| Cincinnati | $ 7.00 | $ 17.00 | $ 13.00 | ||||
| Minimal Cost: | $ 6,960.00 | ||||||
| Note: Since total supply = total demand | |||||||
| all supply and demand constraints | |||||||
| have the equality sign. |
This is the area reserved for the decision variables.
Demand Constraints
Supply Constraints
Don't forget to click on the "Assume Linear Model" and "Assume Non-Negative" check boxes from
If you are using Excekl 2010, please note the minor changes as shown below.