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). ObjectiveWe are making four products (P1-P4). Objective

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 Increase Decrease 1 P1 Cost Coefficient (1.1) 22.0 21.0 1.1 1E+30 2 P2 91.7 4.0 2.4 3 P3 225.0 20.0 3.9 1.3 4 P4 66.7 35.0 4.0 4.3 Constraints Shadow Constraint Allowable Final Allowable Cell Name Value Price R.H. Side Increase Decrease 1 Labor 425.0 5.3 425.0 375.0 111.4 2 Raw 1 408.3 490.0 1E+30 81.7 3 Raw2 800.0 2.7 800.0 100.0 112.5 4 Raw3 700.0 6.3 700.0 140.6 98.2 5 Capacity 383.3 500.0 1E+30 116.7 One more unit of which constrint would be worth the most (use constraint number 1- 5) A Which constraint has slack (if more than one jenter either constriant numer)? The objective function coeficient for product 4 can increase to a value of A/ without changing the solution quantities 1 decimal place A 1 An additional unit of Raw3 is worth decimal place

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
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!