Chapter $6$ TEMPLATE FOR TRANSPORTATION PROBLEM two tables stacked top and bottom Enter Your Name Here:$>>>>>$

Cost

A B C D

$1$

$2$

$3$ For the OBJECTIVE FUNCTION:

IN cell I$8,$ enter the correct formula for the Objective Function

MINIMIZED TOTAL COST $=$ using $"=$SUMPRODUCT$()"$ for the Objective Function will be faster

Supply and Demand and Decision Variables LHS RHS GREEN cells are the Cost Coefficients for the Objective Function

A B C D Shipped Sign Supply Slack as given in the Cost table for the problem.

$10=0$ YELLOW cells are for the Decision Variables

$20=0$

$30=0$ Fill in the GRAY cells with RHS values for ALL Constraints.

LHS Transported $0000$ Double check the LHS formulas to be sure they are correct.

Sign $===$ Compare Total Supply and Total Demand

RHS Demand Is the problem Balanced or Unbalanced?