Question: We are making four products (P1-P4). Objective function coefficients are profit per unit for each product. Constraints are the amount of labor available, raw materials

We are making four products (P1-P4). Objective function coefficients are profit per unit for each product. Constraints are the amount of labor available, raw materials (1,2 and 3) and plant capacity. Use the following excel LP to answer this question. Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Decrease 1 P1 Cost Coefficient Increase (3.7) 20.0 3.7 25.0 5.0 1E+30 P2 186.7 7.9 WN P3 20.0 3.9 80.0 106.7 1.7 4.4 4 P4 30.0 5.0 Constraints Final Shadow Constraint Allowable Allowable Constraint Name Value Decrease Price 7.3 1 Labor 800.0 2. 2.3 Raw1 Raw2 R.H. Side Increase 800.0 50.0 400.0 133.3 490.0 1E+30 800.0 55.0 400.0 453.3 800.0 200.0 50.0 36.7 3 4 Raw3 3.3 40.0 Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Decrease 1 P1 1E+30 P2 2 3 7.9 186.7 80.0 Cost Coefficient Increase (3.7) 20.0 3.7 25.0 5.0 20.0 3.9 30.0 5.0 P3 1.7 4 P4 106.7 4.4 Constraints Final Shadow Constraint Allowable Allowable Constraint Name Value Price Decrease 1 Labor 800.0 7.3 2 400.0 2.3 Raw1 Raw2 R.H. Side Increase 800.0 50.0 400.0 133.3 490.0 1E+30 800.0 55.0 500.0 1E+30 200.0 50.0 36.7 40.0 3 453.3 800.0 4 Raw3 3.3 5 Capacity 373.3 126.7 One more unit of which constrint would be worth the most (use constraint number 1- 5) A Constraint Name Value Price R.H. Side Increase 800.0 50.0 1 Labor 800.0 400.0 7.3 2.3 Decrease 200.0 50.0 2 Raw 1 133,3 400.0 490.0 3 Raw 36.7 453.3 800.0 1E+30 55.0 4 Raw3 3.3 40.0 5 Capacity 800.0 500.0 373.3 1E+30 126.7 One more unit of which constrint would be worth the most (use constraint number 1- 5) A/ 5 Which constraint has slack (if more than one just enter either constraint number)? A The objective function coeficient for product 2 can increase to a value of A without changing the solution quantities 1 decimal place AM Aan additional unit of Raw1 is worth 1 decimal places

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Lets go through the questions stepbystep using the information provided in the tables 1 One more uni... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

We are making four products ( P 1 - P 4 ) . Objective function coefficients are profit per unit for each product. Constraints are the amount of labor available, raw materials ( 1 , 2 and 3 ) and...

We are making four products (P1-P4). Objective function coefficients are profit per unit for each product. Constraints are the amount of labor available, raw materials (1, 2 and 3) and plant...

Question 18 (8 points) We are making four products (P1-P4). Objective function coefficients are profit per unit for each product. Constraints are the amount of labor available, raw materials (1, 2...

We are making four products (P1-P4). Objective function coefficients are profit per unit for each product. Constraints are the amount of labor available, raw materials (1.2 and 3) and plant capacity....

We are making four products (P1-P4). Objective function coefficients are profit per unit for each product. Constrain the amount of labor available, raw materials (1, 2 and 3) plant capacity. Use the...

Maximize 1 5 x 1 + 2 0 x 2 + 1 4 x 3 where x 1 = quantity of product 1 x 2 = quantity of product 2 x 3 = quantity of product 3 subject to Labor 5 x 1 + 6 x 2 + 4 x 3

Problem 2 ( Each question is worth two marks. Total sixteen marks ) Maximize 1 5 x 1 + 2 0 x 2 + 1 4 x 3 where x 1 = quantity of product 1 x 2 = quantity of product 2 x 3 = quantity of product 3...

Maximize 1 5 x 1 + 2 0 x 2 + 1 4 x 3 where x 1 = quantity of product 1 x 2 = quantity of product 2 x 3 = quantity of product 3 subject to Labor 5 x 1 + 6 x 2 + 4 x 3

What are commitments, and why should commitments also match your goals and priorities in life? How can you take steps to eliminate mismatches?

We are considering two bonds. One pays 3% and has a maturity of 8 years, while the other pays 4% and has a maturity of 8 years. If we expect rates to fall by 1% from their current level, which is 4%,...

According to the findings of Chen who used the phenomenological approach to study cultural adaptation, migrants in the second phase Multiple Choice try to actively reject the assertions of the new of...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...