Explain how many tons from each alloy should be in order

Assignment Help Operation Management

Reference no: EM1378602

Q. Steel co has received an order for exactly 125 tons of steel. Order must contain at least 5.5 tons of nickel, at most 3.2 tons of carbon, also exactly 4 tons of manganese. To fill order Steel co can combine four alloys whose chemical composition is given in Table below. Steel co wishes to minimize cost for filling order. Explain how many tons from each Alloy should be in order?

Alloy 1 Alloy 2 Alloy 3 Alloy 4
Nickel 8% 5% 3% 4%
Carbon 3% 4% 5% 6%
Manganese 5% 6% 3% 2%
Cost/ton $15 $12 $10 $5

solve it by utilizing excel solver"

Reference no: EM1378602

Questions Cloud

List three directional strategies : Identify five forces which shape competition as described by Porter. Explain illustrate what is meant by term "competitive advantage". List three directional strategies.

Evaluate expected completion time for each path : Subsequent precedence diagram reflects three time estimates for each activity. Evaluate: Expected completion time for each path also its variance.

Which had greatest utilization rate : During a three day period, 109 healthy babies were born. 60 babies were born in separate labour also delivery rooms, 45 were born in combined labour also delivery rooms, also only 4 babies required a labour room also complicated delivery room. Whi..

Illustrate what is average time spent waiting in line to get : Illustrate what is average time spent waiting in line to get to ticket window. Illustrate what is probability which re are more than two people in system? More than three people or more than four.

Explain how many tons from each alloy should be in order : Steel co has received an order for exactly 125 tons of steel. Steel co wishes to minimize cost for filling order. Explain how many tons from each Alloy should be in order.

Describe an area of improvement for your company or industry : Describe an area of improvement for your company or industry of choice. Find two benchmarks for your improvement area.

Should wiley adopt this policy : Order also holding costs will remain same. Should Wiley adopt this policy. Explain why or explain why not. Illustrate what is maximum backorder.

Explain how you have calculated it : MPS calls for 50 units of Product A also 60 of B. re are presently 25 of Product B on hand. Each A requires 2 of Part C; each B requires 5 of C. there are 160 units of C available. Net requirements for C are.

Forecast quarterly demand for a product : Determine what forecasts are appropriate for the last quarter of this year and the 1st quarter of next year?

User Account

All Pages