Question: Distributing a Product ( From Kenneth Baker Opt Modeling ) The Lincoln Lock Company manufactures a commercial security lock at plants in Atlanta, Louisville, Detroit,

Distributing a Product (From Kenneth Baker Opt Modeling)
The Lincoln Lock Company manufactures a commercial security lock at plants in Atlanta, Louisville, Detroit, and Phoenix. The unit cost of production at each plant is 35.50,37.50,37.25, and $36.25, and the annual capacities are 18,000,15,000,25,000, and 20,000, respectively. The locks are sold through wholesale distributors in seven locations around the country. The unit shipping cost for each plant-distributor combination is shown in the following table, along with the forecasted demand from each distributor for the coming year.
\table[[,Tacoma,\table[[San],[Diego]],Dallas,Denver,St Louis,Tampa,Baltimore],[Atlanta,2.5,2.75,1.75,2,2.1,1.8,1.65],[Louisville,1.85,1.9,1.5,1.6,1,1.9,1.85],[Detroit,2.3,2.25,1.85,1.25,1.5,2.25,2],[Phoenix,1.9,0.9,1.6,1.75,2,2.5,2.65],[Demand,5500,11500,10500,9600,15400,12500,6600]]
1.) Determine the least costly way of shipping locks from plants to distributors.
Note that part of the answer is already pre-filled (the zeros). When running this optimization problem, you do not know there are zeros beforehand. The answer is just partially prefilled to facilitate grading.
\table[[,Tacoma,\table[[San],[Diego]],Dallas,Denver,St Louis,Tampa,Baltimore],[Atlanta,0,0,0,0,0,,],[Louisville,0,0,0,0,,0,0],[Detroit,0,0,,,,0,DB],[Phoenix,,,,0,0,0,0],[,,,,,,,]]
2.) How much would the least costly way still cost me?
 Distributing a Product (From Kenneth Baker Opt Modeling) The Lincoln Lock

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!