Use matrix approach to implement

Assignment Help Operation Management
Reference no: EM131468360

Use matrix approach to implement and solve this problem in Excel showing work.

Drvol Die and Tool needs to order quantities of part XY76 which they need for machining purposes. They have two different suppliers they utilize to order the parts. Drvol Die and Tool has two plants that need XY76 for the next production period – the Omaha plant needs 850 units and the Lincoln plant 1100 units. Assume demand for these parts must be exactly met.

Supplier Alpha can supply up to 1500 units for 5.5 cents each. Supplier Beta can supply up to 1300 units for 4.7 cents each. There are no quantity discounts. To maintain strong relationships with both suppliers, at least 50% of the maximum of XY76 available from each supplier must be used/ordered. To ensure that there are no quality issues, each supplier must provide at least 30% of the individual plant’s need for XY76.

Finally, there is a little cost difference in getting the XY76 from the suppliers to the two Plants. Based on past data, assess a cost of 1.1 cents/unit for parts going from Supplier Alpha to Omaha, 1.6 cents/unit from Supplier Alpha to Lincoln, 1.3 cents/unit for parts going from Supplier Beta to Omaha, and 1 cent/unit from Supplier Beta to Lincoln. Find the least cost way for Drvol Die and Tool to procure part XY76.

Hint: You can simplify the ratio requirements by utilizing the information that part demand must be met exactly.

Reference no: EM131468360

Questions Cloud

Find relationship in natural selection and self-organisation : The discussion about self-organization shows it is potentially relevant to fundamental questions about evolution. One issue is whether life itself can come.
Briefly explain personnel planning and employee recruiting : Analyze and briefly explain personnel planning and employee recruiting in organization that you are in or any organization of your choice
Characteristic that affects the distribution of this disease : List 1-person characteristic that affects the distribution of this disease.
Define the concept of agent-based theory : Two other important concepts in natural computing are competition and cooperation among agents. Provide definitions for both concepts under the perspective.
Use matrix approach to implement : Drvol Die and Tool needs to order quantities of part XY76 which they need for machining purposes. They have two different suppliers they utilize to order parts
Find the cost equation and the revenue equation : ?(A) Find the cost equation and the revenue equation. ?(B) How many DVDs must be sold each month for the company to break? even?
Find the optimal protection level for high fare seats : Find the optimal protection level for high fare seats. If overbooking is allowed as in part (f), then what is the booking limit for the low fare seat?
What steps take to protect their company system from threats : Interview the IT staff of a company to find out whether they take information warfare or cyber terrorism into direct account when they are securing their system
What is the focus of the theory : What does the theory tell us about how things operate in the real world?What is the focus of the theory?

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!

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