Question: Below is provided an Excel spreadsheet of an LP problem. The problem is already solved by Excel Solver to maximize total profit. A B D

Below is provided an Excel spreadsheet of an LP

Below is provided an Excel spreadsheet of an LP problem. The problem is already solved by Excel Solver to maximize total profit. A B D E 0.00 2.00 24.00 0.00 $5 0.00 $4 $3 $7 $10 $254.00 1 N Amount of product Profit Constraints Requirement 1 Requirement 2 Requirement 3 Requirement 4 Requirement 5 Requirement 6 3 4 10 3 1 5 6 8 2 5 1 5 2 6 4 3 8 1 3 30.00 122.00 50.00 152.00 100.00 56.00 1 4 2 = 100 20 Sign RHS 2 4 5 4 2 5 LHS a) In the LP formulation how is the objective function represented? In other words, write down the objective function of the problem as it appears in the LP formulation. b) In the LP formulation how is Requirement 2 represented? In other words, write down the constraint function of Requirement 2 as it appears in the LP formulation. c) Which constraints are binding? d) What's the slack/surplus value for Requirement 6? Specify whether it is slack or surplus

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!