Steel co has received an order for exactly 125 tons of, Ask an Expert

Management Studies

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"

View complete question

Operation Management, Management Studies

Category:- Operation Management
Reference No.:- M9313903

Have any Question?Write your Review or question?

Related Questions in Operation Management

Each response must have a minimum of 150 words must have

Each response must have a minimum of 150 words MUST have references for each response!Quality work! No Plagiarism! Ch. 2:The Market System and the Circular Flow 1. Innovation is often associated with the products the org ...

1 what is the purpose of monitoring and measuring the smm

1. What is the purpose of monitoring and measuring the SMM campaign? 2. Why must SMM content focus on the audience rather than the organization? 3. You are getting together to start a company that sells widgets for consu ...

1 the london whale example best illustrated what aspect of

1) The London Whale example best illustrated what aspect of control system failure? a) Statement falsification b) Overcontrol c) Employee resistance d) Rewards for inefficiency 2) A budget that is put together by senior ...

Discussion proofreadingrefer to chapter 11 to help guide

Discussion : Proofreading Refer to chapter 11 to help guide your response for this discussion thread. What techniques or tools do you use to proofread and edit your work (e.g., reading out loud, digital editing tools, et ...

Sam has earmarked a budget of 225000 for this project with

Sam has earmarked a budget of $225,000 for this project with a discount rate of 6%. He estimates that the new system will help in reducing staff cost by $4,500 per month and save wastage of food by at least another $5,00 ...

Do some additional outside research on comcastrsquos

Do some additional outside research on Comcast’s approach to customer service. Cite your sources and discuss what you believe to be the root cause of the customer service problems at Comcast. 2. If you were Mr. Herrin an ...

1 describe one specific area in which you believe that

1. Describe one specific area in which you believe that strategic purchasing could improve a supply chain that you are familiar with. If you are not aware of a supply chain, then describe how a particular aspect of the W ...

1 porters five forces model and the mckinsey 7-s model are

1. PORTER's Five Forces model and the McKINSEY 7-S model are pictorial summary devices for thinking about environmental analysis. Choose one or the other, and fully explain how it can work to enhance the marketing effort ...

1 using each of the readings citing and referencing each

1. Using each of the readings (citing and referencing each one), compare and contrast common themes and viewpoints each one has about sustainable competitive advantage. Include an example of a company that you feel has u ...

Evaluation of post-discharge telephone follow-up call with

Evaluation of Post-discharge Telephone follow-up call with Patients Diagnosed with COPD My proposal is related to "quality Improvement evaluation projects". In specific the post-discharge telephone follow-up with COPD pa ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Operation Management Expert