You will need the sover add on$,$ please include screenshots for each step as well as formulas.

Problem Text

A fruit importer faces the weekly problem of meeting demand for bananas at three regional customer centers

$($Denver$,$ Kansas City, and Fort Worth$)$ from the supply available at the source countries: Honduras and Costa

Rica. Bananas are shipped from the sources, to two port facilities at Miami and San Diego. Miami is also a

regional customer center. See the network diagram below.

Supplies and demands $($in hundreds of pounds$)$ for the coming week are shown in the tables below.

Transportation costs are roughly proportional to the amount of bananas and the distance the product must be

shipped. The number of miles $($in hundreds$)$ between locations is given in the next two tables. That is$,$ treat

these values as the unit costs for the problem.

Anything shipped into a port must be shipped out to a customer $($treat Miami as essentially both a port and a

customer$).$ How should the bananas be transported to minimize total $$cost$($banana$-$miles$)?$

Two spreadsheet templates are provided for the problem. One is in standard form, and one is in the alternate

form $($see the transshipment problem from class$/$Canvas$).$

Instructions and Guidelines

Algebraic Formulation. Define decision variables, and write the algebraic formulation of the problem. Write

the formulation in the text box provided in the spreadsheet file. Use the node numbers as from and to

subscripts in the decision variables $($e$.$g