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?

User Account

All Pages