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, 23.06.2019 01:30

Vortex company operates a retail store with two departments. information about those departments follows. department a department b sales $ 800,000 $ 450,000 cost of goods sold 497,000 291,000 direct expenses salaries 125,000 88,000 insurance 20,000 10,000 utilities 24,000 14,000 depreciation 21,000 12,000 maintenance 7,000 5,000 the company also incurred the following indirect costs. salaries $36,000 insurance 6,000 depreciation 15,000 office expenses 50,000 indirect costs are allocated as follows: salaries on the basis of sales; insurance and depreciation on the basis of square footage; and office expenses on the basis of number of employees. additional information about the departments follows. department square footage number of employees a 28,000 75 b 12,000 50 required: 1. determine the departmental contribution to overhead and the departmental net income for department a and department b.

Answers: 2

Answer

Business, 23.06.2019 17:30

Globalman tech purchased raw material from newbiztr co. when the sales team at newbiztr co checked the system, there was no payment detail in the system, though the order-delivery details were present. also, it seemed that someone had tampered with the details of the previous order. which important data-management features were compromised? the of data was compromised because there were corresponding payment details. the of data was compromised as someone had tampered with the details of the previous order.

Answers: 3

Answer

Business, 23.06.2019 20:00

If overnight delivery makes you think of fedex, what marketing strategy caused that association in your mind? direct mail tv advertising branding connectivity

Answers: 1

Answer

Business, 23.06.2019 21:30

Explain what is meant when it is said that "data vary". how does the variability affect the results of statistical analysis?

Answers: 3

Answer

You know the right answer?

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

Questions