(Q22-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 $4 $10 $12 $10 6 0 New Jersey 6 10 14 15 65 Delaware 8 11 17 20 100 Warehouse Demand 40 50 65 70 225/225 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). 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). Candidate Solution Ohio Denver Ohio Denver Louis St. Chicago Total Shipped 0 (C) Philadelphia New Jersey Delaware 0 0 40 0 0 (A) 55 (D) (B) 100 Delaware 10 Total Shipped 40 50 65 70 Cost Ohio Denver Stie Chicago Philadelphia New Jersey Delaware Total (F) Cost= Question 21 (4 points) (A) and (B)=? a) (A)=0; (B)=50 Ob) (A)=30; (B)=20 Oc) (A)=50; (B)=0 O d) (A)=20; (B)=30 Question 22 (4 points) (C) and (D)=? a) (C)=60; (D)=10 Ob) (C)=40; (D)=20 O c) (C)=20; (D)=40 O d) (C)=10; (D)=60 Question 23 (4 points) (E)=? Oa) (E)=550 Ob) (E)=770 Oc) (E)=600 Od) (E)=320 Question 24 (4 points) What is the total cost (F)? a) 2,725 Ob) 2,560 Oc) 2,450 d) 3,120 e) 2,650