Download Data Set Excel File. Use Excel Solver to solve the problem. Suppose the U.S. Pharmaceutical Company has three factories supplying the warehouses of four major customers and its management want to determine the minimum-cost shipping schedule for its monthly output to these customers. Factory supply, warehouse demands, and shipping costs per case for these drugs are shown in the table below. From To Ohio Denver St. Louis Chicago Factor Supply Philadelphia $14 $14 $13 $6 65 New Jersey 10 5 10 5 40 Delaware 8 10 It 12 16 150 Warehouse Demand 60 80 45 70 255 255 The solution below is based on Excel Solver (Linear Programming). Choose the right numbers below (Assume that the solution is based upon the minimization of transportation costs). What is (E)? Candidate Solution Ohio Denver St. Louis Total Chicago Shipped Philadelphia o o (C) 65 New Jersey (A) O (D) 40 Delaware 60 (B) 45 10 150 Total Shipped 60 80 45 70 255 Cost Ohio Denver St. Louis Chicago Cost Ohio Denver St. Louis Chicago Philadelphia New Jersey Delaware (E) Total Cost- (F) Philadeipnia New Jersey Delaware (E) Total Cost= (F). O (E)=770 (E)=320 (E)=600 (E)=540 G H 1 Data set 1 (US Phar) 2 3 Philly 4 NJ 5 DA 6 Demand 7 Ohio 14 10 8 60 Denver 14 5 10 80 St. Louis 13 10 12 45 Chicago 6 5 16 70 Supply 65 40 150 255\255 DO 8