What is the maximum price that the company would be willing to pay for an additional unit of Resource A? How many more units of the resource could be purchased at this price? Question 5 Consider the following sensitivity report generated for an organization that produces two products Product Mand Product Ny using two resources (Resource X and Resource Y). The organization needs to determine the quantity of each product to x manufactured in order to maximize the total profit. Variable Cells Cell Name SB59 Product M SCS9 Product N Final Reduced Objective Allowable Value Cost Coefficient Increase 1875 0 13 13 0 13 Allowable Decrease 4.3 13 375 26 Constraints Cell Name SDS5 Resource X SD$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 Which of the above parameters is the most sensitive to a decrease in its value? Question 6 Consider the following sensitivity report generated for an organization that produces two products Product X and Product Y using two resources (Resource A and Resource B). The organization needs to determine the quantity of each product to be X manufactured in order to maximize the total profit. Variable Cells Final Value Cell SB59 $C$9 Name Product X Product Y Reduced Cost 0 0 Objective Coefficient 2 5 Allowablo Increase 0.5 1 Allowable Decrease 0.3 2 Constraints Allowablo Increase Allowable Decrease Cell 5035 SD$6 Final Name Value Resource A Used 10 Resource B Used 12 Shadow Price 1 1 Constraint R.H. Side 10 12 3 2 What is the maximum price that the company would be willing to pay for an additional unit of Resource B? How many more units of the resource could be purchased at this price? Question 7 Consider the following sensitivity report generated for an organization that produces two products (Product Mand Product N) using two resources (Resource X and Resource Y). The organization needs to determine the quantity of each product to be X manufactured in order to maximize the total profit. Variable Calls Final Reduced Obiective Allowable Allowable A4 ENG What is the maximum price that the company would be willing to pay for an additional unit of Resource A? How many more units of the resource could be purchased at this price? Question 5 Consider the following sensitivity report generated for an organization that produces two products Product Mand Product Ny using two resources (Resource X and Resource Y). The organization needs to determine the quantity of each product to x manufactured in order to maximize the total profit. Variable Cells Cell Name SB59 Product M SCS9 Product N Final Reduced Objective Allowable Value Cost Coefficient Increase 1875 0 13 13 0 13 Allowable Decrease 4.3 13 375 26 Constraints Cell Name SDS5 Resource X SD$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 Which of the above parameters is the most sensitive to a decrease in its value? Question 6 Consider the following sensitivity report generated for an organization that produces two products Product X and Product Y using two resources (Resource A and Resource B). The organization needs to determine the quantity of each product to be X manufactured in order to maximize the total profit. Variable Cells Final Value Cell SB59 $C$9 Name Product X Product Y Reduced Cost 0 0 Objective Coefficient 2 5 Allowablo Increase 0.5 1 Allowable Decrease 0.3 2 Constraints Allowablo Increase Allowable Decrease Cell 5035 SD$6 Final Name Value Resource A Used 10 Resource B Used 12 Shadow Price 1 1 Constraint R.H. Side 10 12 3 2 What is the maximum price that the company would be willing to pay for an additional unit of Resource B? How many more units of the resource could be purchased at this price? Question 7 Consider the following sensitivity report generated for an organization that produces two products (Product Mand Product N) using two resources (Resource X and Resource Y). The organization needs to determine the quantity of each product to be X manufactured in order to maximize the total profit. Variable Calls Final Reduced Obiective Allowable Allowable A4 ENG