Building on the previous example$$ Suppose currently, only $160$ cars are available at the port in Newark$300$ cars are still available in Jacksonville$$ Each arc can transport a maximum of $120$ cars$$ Cars can be shipped from Richmond to Atlanta for a unit cost of $$40$ The units demanded by the distributors remain the same$$ We would like to satisfy as much demand as possible $($exhaust all supplies$)$ with the minimal cost$1.$ Modify the network diagram of the previous problem$2.$ Modify the LP formulation of the previous problem$3.$ Modify the Excel spreadsheet of the previous problem$4.$ Solve the new problem and report the optimal solution$5.$ Label each arc on your network diagram with the number of units shipped$6.$ Which distributor$($s$),$ if any, do not receive the number of cars requested? How many do they receive