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
Other questions on the subject: Business
Business, 22.06.2019 12:00, bbyniah123
Select the correct answer. martha is a healer, a healthcare provider, and an experienced nurse. she wants to share her daily experiences, as well as her 12 years of work knowledge, with people who may be interested in health and healing. which mode of internet communication can martha use? a. wiki b. email c. message board d. chat e. blog
Answers: 2
Business, 22.06.2019 14:30, deku6
United continental holdings, inc., (ual), operates passenger service throughout the world. the following data (in millions) were adapted from a recent financial statement of united. sales (revenue) $38,901 average property, plant, and equipment 17,219 average intangible assets 8,883 1. compute the asset turnover. round your answer to two decimal places.
Answers: 2
Business, 23.06.2019 08:20, megandalolipop
As task uncertainty and interdependence increase, are a more effective coordination mechanism than
Answers: 3
Business, 23.06.2019 16:30, dakshshberry
Blanchard and peale am i in compliance with the law? what contribution does this choice of action make to the company, the shareholders, the community, and others? what are the short- and long-term consequences of this decision? 1. make sure you have a grasp of all of the facts available. 2. list any information you would like to have but don't and what assumptions you would have to make, if any, in resolving the dilemma. 3. take each person involved in the dilemma and list the concerns they face or might have. 4. develop a list of resolutions for the problem. 5. evaluate the resolutions for costs, legalities, and impact. 6. make a recommendation on the actions that should be taken. "contemplating any business act, an employee should ask himself whether he would be willing to see it immediately described by an informed and critical reporter on the front page of his local paper, there to be read by his spouse, children, and friends." is it legal? is it balanced? how does it make me feel?
Answers: 2
You know the right answer?
Sinclair plastics operates two chemical plants that produce polyethylene: the ohio valley plant, wh...
Questions in other subjects:
Mathematics, 31.01.2020 22:03
History, 31.01.2020 22:03
History, 31.01.2020 22:03
History, 31.01.2020 22:03
