how do i do this on excel?

The three blood banks in Franklin county are coordinated through a central office that facilitates blood delivery to four hospitals in the region. The cost to ship a standard container of blood from each bank to each hospital is shown in the table below. The weekly demand at hospitals in number of containers, and the weekly supply at each blood bank are also give. Unit costs HOSPITAL 3 Supply 1 N 4 Bank 1 $8 $9 $2 $4 50 Bank 2 $7 $3 $5 $8 80 Bank 3 $14 $4 $6 $7 110 Demand 90 70 40 30 An optimal shipment plan is to be calculated using an optimization model in which the total cost of shipments is minimized, supply at each blood bank is not violated, and demand at each hospital is met Shipments HOSPITAL 1 34 Supply Bank 1 50 Bank 2 80 Bank 3 110 Demand 90 70 4030 Using the SOLVER within EXCEL, compute the optimal solution to this transportation problem and then select the statement that is true Shipments HOSPITAL 1 2 3 4 Supply Bank 1 50 Bank 2 80 Bank 3 110 Demand 90 70 40 30 Using the SOLVER within EXCEL, compute the optimal solution to this transportation problem and then select the stateme that is true Select one The optimal shipment cost is $10:40 On The optimal shipment cost is $1270 The optimal shipment costs 51370