$22**$Please put into excel sheet form$**$ A supply chain consists of three plants $($A$,$ B$,$ and

C$),$ three distributors $($J$,$ K$,$ and L$),$ and three stores

$($X$,$ Y$,$ and Z$).$ The relevant supply, demand, and

unit shipping cost information are given in the table

at the bottom of this page. Set up and solve the trans$-$shipment model to minimize total shipping costs.

Table for Problem $22$

TO TO

PLANT SUPPLY STORE DEMAND FROM J K L FROM X Y Z J K L

A $400$ X $400$ A $$4$ $$7$ $$5$ J $$6$ $$4$ $$8$ $$6$ $$5$

B $500$ Y $325$ B $$8$ $$5$ $$4$ K $$3$ $$6$ $$7$ $$6$ $$7$

C $350$ Z $400$ C $$5$ $$6$ $$7$ L $$2$ $$4$ $$5$ $$5$ $$7$