Question: Problem 2 (20 points): Given here are the Solver printouts for a linear program. The xj are the outputs the firm will produce (j =

Problem 2 (20 points): Given here are the SolverProblem 2 (20 points): Given here are the Solver

Problem 2 (20 points): Given here are the Solver printouts for a linear program. The xj are the outputs the firm will produce (j = 1,2). The bi are the input availabilities/constraints (i = 1,2,3,4). The firm uses the four inputs to produce the outputs. The firm's goal is to maximize total revenue. Input Variable Per Unit Revenue X1 ????? X2 ????? TR 72.83 Total LHS Slack Constraints Constraint 1 Constraint 2 Constraint 3 Constraint 4 X1 X2 Resource Usage 2 4 3 8 5 2 vil vi vil RHS 25 30 12 6 4 1 Microsoft Excel 16.0 Sensitivity Report Variable Cells Final Cell Name Value $C$5 x1 0.620689655 $D$5 x2 ??????? Reduced Cost Objective Coefficient 4 20 Allowable Increase 76 1E+30 Allowable Decrease 1E+30 19 0 0 Constraints Cell Name $E$9 Constraint 1 Total LHS $E$10 Constraint 2 Total LHS $E$11 Constraint 3 Total LHS $E$12 Constraint 4 Total LHS Final Shadow Value Price 15.31034483 ??????? 30 2.620689655 10.13793103 0 6 -0.965517241 Constraint Allowable Allowable R.H. Side Increase Decrease ??????? 1E+30 9.689655172 30 18 25.5 12 1E+30 1.862068966 6 1.588235294 2.25 Problem 2 continued below. (a) How much slack of input 1 is there remaining? (6 points) (b) Suppose the firm decreases its amount of input 4 by two units from 6 to 4. By how many dollars with the firm's total revenue change? (6 points) (c) How many units of x2 are produced? (12 points)

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!