(Q7-10: Data set 1- Use Excel file) 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	60
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).

Candidate Solution	Ohio	Denver	St. Louis	Chicago	Total Shipped
Philadelphia	0	0	0	(C)
New Jersey	0	(A)	55	(D)
Delaware	40	(B)	10	0
Total Supplied	40	50	65	70
Cost	Ohio	Denver	St. Louis	Chicago
Philadelphia
New Jersey			(E)
Delaware
				Total Cost=	(F)________

Question 14

(A) and (B)=?

Question 13 options:

a)	(A)=20; (B)=30

b)	(A)=0; (B)=50

c)	(A)=30; (B)=20

d)	(A)=50; (B)=0

Question 14

(C) and (D)=?

Question 14 options:

a)	(C)=40; (D)=20

b)	(C)=60; (D)=10

c)	(C)=20; (D)=40

d)	(C)=10; (D)=60

Question 15

(E)=?

Question 15 options:

a)

(E)=770

b)

(E)=550

c)

(E)=600

d)

(E)=320

Question 16

What is the total cost (F)?

Question 16 options:

a)

2,725

b)

2,560

c)

2,650

d)

3,120

e)

2,450