Please solve using excel solver - A company has 3 factories and 5 warehouses. Production capacity in terms of boxes of product is 310, 260 and 280 in factories A, B and C respectively. The maximum number of of boxes that can be stored in each warehouse (numbered W#1 through W#5) is: 180, 80, 200, 160 and 220. Warehouses 1 to 5 have to carry at least 175, 80, 195, 140, and 210 boxes respectively. The transportation costs from factory A, B, C to the five warehouses are listed below. How many boxes should be shipped from each factory to each warehouse to minimize total transportation costs?

	w#1	W#2	W#3	W#4	W#5
factory A	$7.00	$12.00	$4.00	$9.00	$2.00
Factory B	$8.00	$2.00	$15.00	$9.00	$4.00
Factory C	$7.00	$4.00	$6.00	$3.00	$7.00

QUESTION 1

At the optimal solution, what is the transportation cost of shipping boxes from Factoy A to Warehouse 5?

A. $230

B. $140

C. $360

D. $0

QUESTION 2 At the optimal solution, what is the total transportation cost?

A. $4,260

B. $2,650

C. $2,460

D. $3,230

QUESTION 3 At the optimal solution, how many boxes were shipped from Factory C to Warehouse 1?

A. 0

B. 140

C. 195

D. 80

QUESTION 4 At the optimal solution, how many were shipped to Warehouse 3?

A. 145

B. 210

C. 195

D. 140

QUESTION 5 At the optimal solution, how many boxes were shipped from Factory B to Warehouse 3?

A. 85

B. 120

C. 0

D. 135

QUESTION 6 At the optimal solution, what is the transportation cost of shipping boxes from Factoy C to Warehouse 4?

A. $0

B. $420

C. $250

D. $320

QUESTION 7 At the optimal solution, How many more boxes can be stored in warehouse 1?

A. 0 B. 15 C. 20 D. 5

QUESTION 8 At the optimal solution, how many boxes were shipped from Factory A?

A. 195 B. 0 C. 310 D. 140

QUESTION 9 At the optimal solution, what is the transportation cost of shipping boxes from Factoy B to Warehouse 2?

A. $160 B. $0 C. $280 D. $140

QUESTION 10 At the optimal solution, How many more boxes can be stored in warehouse 4?

A. 10 B. 20 C. 0 D. 5