PLEASE PROVIDE ANSWER ON HOW TO SOLVE IN EXCEL, THANKS!

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.

$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: