Question: 1 points Save Ans Consider the following sensitivity report generated for an organization that produces two products (Product M and Product N) using two resources

1 points Save Ans Consider the following
1 points Save Ans Consider the following
1 points Save Ans Consider the following sensitivity report generated for an organization that produces two products (Product M and Product N) using two resources (Resource X and Resource Y). The organization needs to determine the quantity of each product to be manufactured in order to maximize the total profit. Variable Cells Name Cell $B$9 Product M SC$9 Product N Final Reduced Objective Allowable Value Cost Coefficient Increase 1875 0 13 13 375 0 26 13 Allowable Decrease 4.3 13 Constraints Cell Name SD$5 Resource X SOS6 Resource Y Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 3000 6.5 3000 1050 750 4500 3.25 4500 1500 2100 What is the maximum price that the company would be willing to pay for an additional unit of Resource X? How many more units of the resource could be purchased at this price? 56.5 per unit of Resource for 750 additional units $6.5 per unit of Resource X for 1,500 additional units. $6.5 per unit of Resource X for 1,050 additional units. $6.5 per unit of Resource X for 3,000 additional units. Question 2 1 points Save Ang Consider the following sensitivity report generated for an organization that produces two products (Product M and Product N) using two resources (Resource X and Resource Y). The organization needs to determine the quantity of each product to be manufactured in order to maximize the total profit. Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease SBS9 Product M 1875 0 13 13 4.3 $C$9 Product N 375 0 26 13 13 Constraints Cell Name SD$5 Resource X $D$6 Resource Y Final Shadow Constraint Allowable Value Price R.H. Side Increase 3000 6.5 3000 1050 4500 3.25 4500 1500 Allowable Decrease 750 2100 Based on the information above, calculate the optimal objective function value. $156,000 $34,125 $2,250 $29,250 Moving to the next question prevents changes to this answer Question 2 of 10 MacBook Pro SNS

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!