1922-25: Data set 2-Use Excel Solver) 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 12 16 150 Warehouse Demand 60 80 45 70 255255 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) ORI E BED 9. 31 Cost= Question 21 (4 points) (A) and (B)=? a) (A)=35; (B)=45 b) (A)=45; (B)=35 c) (A)=35; (B)=0 d) (A)=0; (B)=35 Question 22 (4 points) O a a 99 1922-25: Data set 2-Use Excel Solver) 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 12 16 150 Warehouse Demand 60 80 45 70 255255 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) ORI E BED 9. 31 Cost= Question 21 (4 points) (A) and (B)=? a) (A)=35; (B)=45 b) (A)=45; (B)=35 c) (A)=35; (B)=0 d) (A)=0; (B)=35 Question 22 (4 points) O a a 99