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

  Book review - the goal

Operations Management is about a book review. Title of the book is "Goal". This book has been written by Dr. Eliyahu Goldartt. The book has been appreciated by many as one of those books which offers an insight into the operations and strategic capac..

  Operational plan in hospitality enterprise

Operational plan pertaining to a hospitality enterprise is given in detail in the solution. The operational plan is an important plan or preparation which gives guidelines regarding the role and responsibilities of each and every operation at all lev..

  Managing operations and information

Recognise the importance of a strategic approach to the development and deployment of organisational information systems. Demonstrate an understanding of the importance of databases and their integration to the organisation's overall information mana..

  A make-or-buy analysis

An analysis of the holding costs, including the appropriate annual holding cost rate.

  Evolution and contributor of operations management

Briefly explain Evolution and contributor of Operations management.

  Functions and responsibilities of an operations manager

A number of drivers of change have transformed the roles, functions and responsibilities of an operations manager over recent years. These drivers have not only been based on technological innovations but also on the need for organisations to develop..

  Compute the optimal order quantity

Compute the Optimal Order quantity of DVD players. Determine the appropriate reorder point.

  Relationship to operations practice in the organisation

Evaluate problems in operations and identify approaches to overcoming them. Critically evaluate operating plans and identify areas for improvement. Justify, implement and evaluate changes to operations in line with modern approaches.

  A make or buy analysis

Develop a report for Figi Fabricating that will address the question of whether the company should continue to purchase the part from the supplier or begin to produce the part itself.

  Prepare a staffing plan

Prepare a staffing plan showing the change of your unit from medical/surgical staffing to oncology staffing.

  Leadership styles in different organizations

Ccompare the effectiveness of different leadership styles in different organizations

  Risk management tools and models

Be able to understand the concept of risk, roles and responsibilities for risk management and risk management tools and models.

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