What is the linear programming model for this problem

Reference no: EM133212561

Assignment - Sensitivity Report Excel Task

"Muir Manufacturing produces two popular grades of commercial carpeting among its many other products. In the coming production period, Muir needs to decide how many rolls of each grade should be produced in order to maximize profit. Each roll of Grade X carpet uses 50 units of synthetic fiber, requires 25 hours of production time, and needs 20 units of foam backing. Each roll of Grade Y carpet uses 40 units of synthetic fiber, requires 28 hours of production time, and needs 15 units of foam backing.

The profit per roll of Grade X carpet is $200 and the profit per roll of Grade Y carpet is $160. In the coming production period, Muir has 3,000 units of synthetic fiber and 1,500 units of foam backing available for use. Workers have been scheduled to provide 1,800 hours of production time.

a) What is the linear programming model for this problem?

b) What is the optimal solution for this problem?

c) Compared to the optimal solution, how would profit change for each additional unit of synthetic fiber that is made available?"

Reference no: EM133212561

Questions Cloud

Kell has had difficulty competing in marketplace : Kell Systems manufactures computer monitors in Texas and sells the monitors throughout the world. Kell has had difficulty competing in the marketplace,

Indicating the driving and resisting forces : Undoubtedly, Starbucks is going through an immense time of change with regard to the unionization effort. Assume that Starbucks wants to return to a culture of

Review the article - are hazard models superior : Review the article attached and see the way they tested the models to predict bankruptcy and check the the scores and calculations then assess prediction

Cost-volume-profit analysis : This is assignment is designed to help you think analytically. As an HR Manager, you will need to be able to speak to any variances from the budget you prepared

What is the linear programming model for this problem : What is the linear programming model for this problem? Compared to the optimal solution, how would profit change for each additional unit of synthetic fiber

Contains detailed plan for negotiating with your firm : The stakes are high as you and your team negotiate a deal with a major supplier. you discover it contains a detailed plan for negotiating with your firm

Identify review and then present the most important theory : Identify, review and then present the most important theory you learned about that duty/responsibility (for instance, for performance evaluation it may be the t

Describe the relevance of performance standards : Describe the relevance of performance standards for today's knowledge-directed workers, and how their use will result in a more competitive compensation and ben

What is the purpose of system : How do you create a business rule system for healthcare. I'm struggling to find examples or even how to begin.

User Account

All Pages