Linear programming model in solver

Assignment Help Operation Management

Reference no: EM131438581

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

Questions Cloud

Compute the relative and cumulative relative frequency : Compute the relative frequency and cumulative relative frequency of the age groups.

Explain how the kabre diaspora came to exist in southern : According to Charles Piot Kabre society may be seen to be living in the remote past, a society that is characterized by ritual practice and the exchange economy but it is also a society that is very much modern and was central to the construct..

Determine the appropriate mix of investments : Determine the appropriate mix of investments. Give an explanation as to why you think the investments will meet the needs of the client along with your projections of how these investments will meet the cash demands of the future.

Series of short articles for networking magazine : You have been asked to write a series of short articles for a networking magazine. There are six articles in all.

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..

Organisation with a strong market presence : Consider an organisation with a strong market presence. What types of activities does it undertake? Which work best? Why? (50-75 words)

How do you use cost structure to differentiate products : How do you use cost structure to differentiate products? Do you think product differentiation is a successful growth strategy? Why or why not?

Consider making extra attack brownies : Yumminess has asked Jordon and Taylor to consider making Extra Attack Brownies and Nutty Attack Brownies, in addition to Chocolate Attack Brownies. Remember that the contribution margin for Chocolate Attack Brownies per tin is $1.995. What would be t..

Describe potential solutions to the social issues : you selected a social issue, analyzed its background information, developed a problem statement, and provided an explanation about why the social issue is important to investigate. This week, you examine multiple perspectives regarding potential s..

User Account

All Pages