BALANCED TRANSPORTATION $-$ MAXIMIZING PROFIT METHOD $(SEE$ CHAPTER $15$ SOLVED

PROBLEM $2$ FOR SOLVED EXAMPLE$)$: Bindley Corporation has a one$-$year contract $to$ supply

motors for all washing machines produced $by$ Rinso $Ltd.$ They manufacture the washers $at$

Dfour locations around the country: $NY,$ Fort Worth, San Diego, and Minneapolis.

Plans call for the following numbers $of$ washing machines $to$ produced $at$ each location:

Location $\frac{?}{?}$#$1$: $NY=>50,000$ machines

Location $\frac{?}{?}$#$2$: Fort Worth $=70,000$ machines

Location $\frac{?}{?}$#$3$: San Diego $=60,000$

machines

Location $\frac{?}{?}$#$4$: Minneapolis $=>80,000$ machines

Bindley has three plants that can produce the motors. The plants and production capacities

are:

Plant $\frac{?}{?}$#$1$: Boulder $=>{?}_{100},{000}_m$achines

Plant $\frac{?}{?}$#$2$: Macon $=100,000$ machines

Plant $\frac{?}{?}$#$3$: Gary $=1150,000$ machines

Due $to$ varying production and transportation costs, the profit Bindley earns $on$ each $1000$

units depends $on$ where they were produced and where they were shipped. The following

table give the account department estimates $of$ the dollar profit per unit $(Shipment$ will $be$

made $in$ lots $of1000).$

TRANSPORTATION GRID:

CHAPTER $15$ PRACTICE PROBLEMS $-$ TRANSPORTATION

Given profit maximization $as$ a criterion, Bindley would like $to$ determine how many motors

should $be$ produced $at$ each plant and how many motors should $be$ shipped from each plant

$to$ each destination.

$a.$ Develop a transportation grid for this problem $(FILLIN$ THE ABOVE GRID$).$

$b.$ Use the developed transportation grid $to$ determine the optimal solution using

Microsoft Excel. Make sure $to$ indicate the proper constraints $(supply,$ demand,

required supply, unnecessary supply$).-$ COP$\frac{Y}{P}$ASTE $or$ SCREENSHOT YOUR

ANSWER