Essay
Exhibit 6-2
Sinclair Plastics operates two chemical plants which produce polyethylene; the Ohio Valley plant which can produce up to 10,000 tons per month and the Lakeview plant which can produce up to 7,000 tons per month. Sinclair sells its polyethylene to three different auto manufacturing plants, Grand Rapids (demand = 3000 tons per month), Blue Ridge (demand = 5000 tons per month), and Sunset (demand = 4000 tons per month). The variable unit cost of shipping a ton is $1 per mile. The number of miles between the respective plants is shown in the table below:
In addition to the variable unit costs of shipping, Sinclair incurs a fixed handling cost (of pickup and delivery) for any shipping routes it uses. These costs are discounted for longer routes, as shown below:
-Refer to Exhibit 6-2.Suppose the shipping capacity for all routes is 3000 tons per month.What is Sinclair's optimal shipping plan in that case
What is the total cost in that case
Correct Answer:

Verified
Correct Answer:
Verified
Q1: In a linear model,the target cell and
Q3: Exhibit 6-2<br>Sinclair Plastics operates two chemical
Q4: The default integer optimality setting in Solver
Q5: Rounding the solution of a linear programming
Q6: In a model with 8 changing cells,all
Q7: The LP relaxation of an integer programming
Q8: In a set-covering model,each member of a
Q9: Optimization software,including Solver,typically has more difficulty solving
Q10: Exhibit 6-1<br>A recent college graduate is
Q11: If Solver fails to find an optimal