Question $4)(25$ points$)$ Consider a transportation problem. There are a set of suppliers and a set of customers in a region. The customers have their known demand for a specific product. Suppliers have supply capacities for the product. An operations manager wants to make shipment decisions, i$.$e$.,$ how many items to ship from each supplier to each customer, subject to the demand requirements and supply capacities. The demand and supply information are presented below.

$\backslash$table$[[$Suppliers$,\backslash$table$[[$Supply$],[$Capacity$]],$Customers,Demand$],[1,450,A,300],[2,700,B,350],[3,850,C,250],[4,1000,D,550],[5,600,E,500],[,,F,350]]$

$\backslash$table$[[$Cost Matrix,,,,,$],[$From$/$To$,A,B,$C$,$D$,$E$,$F$],[1,10,2,10,5,10,3],[2,9,4,5,4,3,4],[3,3,5,3,5,1,8],[4,2,7,8,9,2,7],[5,3,6,4,7,3,2]]$

$1-$ In the optimal solution that minimizes the total transportation costs, how many items should be shipped from each supplier to Customer B$?$ Use Excel to solve this problem.

Answer:

$2-$ What is the excess capacity of supplier $4$ in the optimal solution?

Answer: