QUESTION $26$

A

B

$1$

$2$ Plant

$$

$4$

$5$

$1$

$2$

$3$

$6$ Demand

$35$

$30$

$60$

$9000$

$$

$8$

$9$ Plant

$10$

$11$

$12$

$1$

$2$

$$

$13$ Demand

$14$

$15$

$16$ Min Total Cost

$17$

$18$ Capacity

LHS

$19$

$20$

$21$

$1$

$2$

$3$

$22$

$$Demand

$$ILHS

$$Relation

$$RHS

Reference: Transportation Model $-$ Excel

$35$

$36$

$37$

$100$

$38$

$39$

$40$

C

D

Distribution Center

E

F

$40$

$30$

$65$

$3000$

$60$

$45$

$50$

$9500$

$120$

$130$

$100$

$1500$

$4$ Capacity

$12000$

$8000$

$5000$

Distribution Center

$2$

$4$ Supply

Relation

$$

RHS

$<=$

What formula should be entered in cell B$20?$

$$A$.=$SUMPRODUCT$($B$3$:E$5,$ B$10$:E$12)$

$$B$.=$F$11-$B$13$

AC $=$SIIM$/$R$11$F$11)$