I need someone that knows solver for excel with parameters

profilefamar
copy_of_ideal_solution_week_5.xlsx

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.

Sheet2

Sheet3