User Account

All Pages

Use excel solver to obtain the optimal shipping

Assignment Help Operation Management
Reference no: EM132108190

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?

Reference no: EM132108190

Questions Cloud

Freelance musician for several major symphonies : Bob Areebob is a recognized french horn player. Bob has played as a freelance musician for several major symphonies.
Developing risk mitigation strategies : Developing risk Mitigation strategies. Develop a preliminary risk mitigation strategy for each of the risk factors identified in Problem 2.
Discuss the overall communication climate : Discuss the overall communication climate - describe the communication climate and discuss any barriers.
Adversely affects the profitability of their firm : How can an industrial distribution firm ensure that its customers are not a competitive force that adversely affects the profitability of their firm?
Use excel solver to obtain the optimal shipping : Use Excel Solver to obtain the optimal shipping plan. What is the optimal shipping plan? What is the optimized cost?
Winemaker be willing to pay for additional labor hour : How much should the winemaker be willing to pay for an additional labor hour? Please explain.
To leave your reader with feeling of goodwill : To leave your reader with a feeling of goodwill, you should. Which of the following statements about closing an adjustment refusal is true?
Course change your understanding of business ethics : One possible purpose of evaluation is to determine the severity of a problem. Has this course change your understanding of business ethics?
Difference between agent and independent contractor : What is the difference between an agent and an independent contractor? Consider and discuss.

Reviews

Write a Review

Operation Management Questions & Answers

  Key factors and enablers of supply chain management

Explain the environmental triggers that forces companies to adopt supply chain management. What are the key factors/enablers of supply chain management?

  Intent of the authors

While we all became familiar with the "Parable of the Sadhu," what do you believe the intent of the authors including it in our discussions? What should we gain from it? Is it relevant? Are there any obscure, well-hidden lessons that may not be ob..

  Why is navigating our global future so important

Why are leadership fundamentals so important toward global business management? Is there room for improvement between medical and public health to work together? Why is navigating our global future so important?

  How the strategic plan will relate to individual performance

Critically evaluate how the strategic plan will relate to individual performance.

  Meaning maximizing stakeholder value

Social responsibility for a business aligns into four key areas. First, economic - meaning maximizing stakeholder value; second - legal, abiding by all the laws and regulations; third - ethical, following standards of acceptable behavior; and fourth ..

  Traditional and the new public relations objectives

Explain the difference between traditional and the new public relations objectives (MPRs). What are the advantages and disadvantages of each?

  What are some significant areas of overlap

What are some significant areas of overlap between the long-term and mental health care categories? Implications for providers of care, for the patients.

  Total ordering costs are equal at the optimal solution

A general property of the EOQ inventory model is that total inventory holding and total ordering costs are equal at the optimal solution,

  Functional organization- matrix organization structure

A functional organization structure, a Matrix organization structure or a projectized organizzation structure?

  ISF stand for importer security filling

"ISF stand for importer security filling. This will allow America to keep their water port and citizen safety. It is the requirement for the importer to provide the following information, importer of record, consignee, buyer, seller, shipper, manufac..

  Summarize which platforms are the most effective

Create a professional quality PowerPoint presentation that conveys the results of your research into social media, various platforms and outlets.

  Discuss the advantages of using quantitative risk assessment

Discuss the reasons as well as the advantages and disadvantages on why a project manager creates and manages a project risk matrix.Do you believe it is possible to eliminate all risk from a project? Explain your reasoning.Discuss the advantages of ..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd