Using solver-order quantities of part

Assignment Help Operation Management

Reference no: EM132105290

Using Solver:

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: EM132105290

Questions Cloud

Your stated qualifications should be targeted to position : Your stated qualifications should be targeted to the position to which you are applying.

Inputs and outputs of operations transformation process : What are the five inputs and two outputs of an operations transformation process?

Paragraph one of the cover letter is to market your skills : The function of paragraph one of the cover letter is to market your skills.

Create plan for team building that you can implement : You need to plan a team building activity that will last for half the workday. Create a plan for team building that you can implement in the four hour period.

Using solver-order quantities of part : Drvol Die and Tool needs to order quantities of part XY76 which they need for machining purposes. Assume demand for these parts must be exactly met.

Innovation stream and technology cycles associated : Discuss how the landline phone went through the innovation stream and technology cycles associated with this product.

Personal patient data-laboratory data and financial data : Sensitive information in a physician's office setting includes: personal patient data, laboratory data, and financial data.

Main contributor to formation of trust : Which of the following is NOT a main contributor to formation of trust? Which of the following is NOT a relationship building block?

Variable costs might change for health program : Speculate how fixed and variable costs might change for a health program at the direct services level, the enabling services level,

User Account

All Pages