Information to set up linear programming model in solver

Assignment Help Operation Management

Reference no: EM131438690

Use the following information to set up a linear programming model in Solver and use it to reach a solution. In the body of your post, be sure to write out the equations you used to build the model in addition to posting a solution. S&N Manufacturing makes four different steel sheets, A, B, C, and D, with different percentages of iron. Each sheet must flow through five departments, forming, rolling, sintering, painting, and quality check. The table below shows the relevant data. Production rates are shown in units/hour. (Sheet A uses imported steel and does not require rolling.) Sheet model Selling price Variable cost Min Sales Max Sales A $260.00 $220.00 0 4000 B $310.00 $250.00 0 3000 C $410.00 $310.00 500 2000 D $660.00 $530.00 500 1000 Production rates (units/hour) A B C D Hours Available (Monthly) Forming 50 40 20 20 330 Rolling - 30 20 20 330 Sintering 35 25 25 22 330 Painting 30 30 35 25 330 Quality check 60 50 50 40 330. S&N wants to determine the number of steel sheets to produce in order to maximize monthly profit. Let A, B, C, and D denote the number of units of model A, B, C, and D to be produced, respectively.

Reference no: EM131438690

Questions Cloud

Explain how does place of interest impact local community : How does the place of interest impact the local community or local culture in a positive and or negative way (tourism? recreation? jobs? beauty? worship? community? environmentally?)

Sustainable competitive advantage : Does your own workplace follow more of a conqueror mentality or an explorer mentality? Is that good for sustainable competitive advantage? (My company is probably a conqueror FYI)

Resources for collecting real or anticipated data : Provide a brief overview of some of the possible tools, techniques, and resources for collecting real or anticipated data about the process you are aiming to improve in your OIP.

Write a analysis of the change : In the Heritage Foundation report, "After Hurricane Sandy: Time to Learn and Implement the Lessons in Preparedness, Response, and Resilience" (2013), nine recommendations are described to improve emergency preparedness and response to natural disa..

Information to set up linear programming model in solver : Use the following information to set up a linear programming model in Solver and use it to reach a solution. In the body of your post, be sure to write out the equations you used to build the model in addition to posting a solution. S&N Manufacturing..

Effective marketplace differentiator : Why is ethics an effective marketplace differentiator?

Subsequently used in the aerospace industry : The Goodparts Company produces a component that is subsequently used in the aerospace industry. The component consists of three parts (A, B, and C) that are purchased from outside and cost 35, 30, and 10 cents per piece, respectively.

Services important to global supply chain management : Why is the design of products and services important to global supply chain management and what are the main design alternatives that are available?

Great deal of time preparing the registration statement : Charlene, a newly-licensed CPA, who set up an office in South Beach, prepared the expertise portion of the registration statement and prospectus for the IPO of the Cardozo Corporation. Charlene took her job very seriously and spent a great deal of ti..

User Account

All Pages