Business, 26.12.2019 22:31 allisonpierce1787

Sinclair plastics operates two chemical plants that 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 = 3,000 tons per month), blue ridge (demand = 5,000 tons per month), and sunset (demand = 4,000 tons per month). the cost of shipping between the respective plants is shown in the table below.

grand rapids blue ridge sunset

ohio valley 50 40 100

lakeview 60 50 75

a. use excel solver to obtain the optimal shipping plan. obtain an answer report and a sensitivity report. what is the optimal shipping plan? what is the optimized cost?

b. suppose the lakeview plant was required to run at capacity. use excel solver to obtain the optimal shipping plan in this case. obtain an answer report. how much more would the shipping plan cost sinclair plastics in this case relative to the plan found in part a?

c. suppose the shipping capacity between any two plants was limited to 2500 tons per month. use excel solver to obtain the optimal shipping plan. obtain an answer report. how much more would the shipping plan cost sinclair plastics in this case relative to the plan found in part a?

Answers: 3

Show answers

Another question on Business

Business, 22.06.2019 10:10

Karen is working on classifying all her company’s products in terms of whether they have strong or weak market share and whether this share is in a slow or growing market. what type of strategic framework is she using?

Answers: 2

Answer

Business, 22.06.2019 17:00

Dan wants to start a supermarket in his hometown, and wants to get into the business only after finding out about the market and how successful his business might be. the best way for dan to gain knowledge is to:

Answers: 2

Answer

Business, 22.06.2019 22:40

Effective capacity is the: a. capacity a firm expects to achieve given the current operating constraints.b. minimum usable capacity of a particular facility.c. sum of all the organization's inputs.d. average output that can be achieved under ideal conditions.e. maximum output of a system in a given period.

Answers: 1

Answer

Business, 22.06.2019 23:10

R& m chatelaine is one of the largest tax-preparation firms in the united states. it wants to acquire the tax experts, a smaller rival. after the merger, chatelaine will be one of the two largest income-tax preparers in the u.s. market. what should chatelaine include in its acquisition plans? it should refocus its attention from the national to the international market. in addition to acquiring the tax experts, it should also determine the best way to drive independent "mom and pop" tax preparers out of business. chatelaine will need to explain to the federal trade commission how the acquisition will not result in an increase in prices for consumers. chatelaine should enter a price-based competition with its other major competitor to force it out of business and become a monopoly.

Answers: 3

Answer

You know the right answer?

Sinclair plastics operates two chemical plants that produce polyethylene: the ohio valley plant, wh...

Questions