Question: Please use Excel Solver, lessons tackled for this are binary integer, network optimization, and transportation problems. The problem is, which cities in Ukraine should receive

Please use Excel Solver, lessons tackled for this are binary integer, network optimization, and transportation problems.Please use Excel Solver, lessons tackled for this

The problem is, which cities in Ukraine should receive food (per truckload) based on supply and demand, and to determine the total cost associated with the transportation. *The objective coefficient is your cost/truckload. * Cities' names are one word only. Variable Cells Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease Cell $D$10 Lviv Kyiv 0 15 464 1E+30 15 $E$10 Lviv Kharkiv 20 513 15 21 0 654 1E+30 84 55 867 21 351 80 352 15 1E+30 45 416 21 15 217 690 1E+30 217 $F$10 Lviv Odessa $G$10 Lviv Dnipro $D$11 Mariupol Kyiv $E$11 Mariupol Kharkiv $F$11 Mariupol Odessa $G$11 Mariupol Dnipro $D$12 Donetsk Kyiv $E$12 Donetsk Kharkiv $F$12 Donetsk Odessa $G$12 Donetsk Dnipro 21 791 1E+30 21 728 1E+30 728 995 682 1E+30 351 351 70 0 388 84 1E+30 30 0 685 351 84 Final Shadow Constraint Allowable Allowable Price R.H. Side Increase Decrease Name Value Cell $D$13 Total Received Kyiv 80 352 80 0 80 $E$13 Total Received Kharkiv 416 0 45 473 0 45 $F$13 Total Received Odessa $G$13 Total Received Dnipro 770 0 45 $H$10 Lviv Total Shipped 97 45 0 $H$11 Mariupol Total Shipped 125 0 0 1E+30 $H$12 Donetsk Total Shipped 100 -85 45 0 Constraints Name oooooLFOS 8678720 0 0 0 0 OSOS550 65 70 85 75 5040007 84 Stilleltltl 678920 65 70 85 75 125 100

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!