b. Solve the problem using Excel Solver or Lingo. 7. Televco produces TV picture tubes at three plants. Plant 1 can produce 50 tubes per week; plant 2, 100 tubes per week; and plant 3, 50 tubes per week. Tubes are shipped to three customers. The profit earned per tube depends on the site where the tube was produced and on the customer who purchases the tube (sees the following table). Customer 1 is willing to purchase as many as 80 tubes per week; customer 2, as many as 90 ; and customer 3 , as many as 100 . Televco wants to find a shipping and production plan that will maximize profits. (10 point) a. Formulate a balanced transportation problem that can be used to maximize Televco's profits. b. Use the northwest corner method to find a bfs to the problem. c. Use the transportation simplex to find an optimal solution to the problem (first iteration only). 8. Four cargo ships will be used for shipping goods from one port to four other ports (labeled 1, 2, 3, 4). Any ship can be used for making any one of these four trips. However, because of differences in the ships and cargoes, the total