Standa Y Excels Excel 2 co Optir G Concie C Get He CC Cor C Backg C 1. Wh C Q2) W What What: 00008 Shorte d.adu.acae Webapps/assessment/review/review.jsp?attemp_id=_3159642.1&course_id= 52492_1&content_id=_944335_1&retum content=1&step= Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease SD$5 Resource X 3000 6.5 3000 1050 750 SD$6 Resource Y 4500 3.25 4500 1500 2100 BU Linear BU Linear + 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 M and Product N) using two resources (Resource X and Resource Y). The organization needs to determine the quantity of each pro x manufactured in order to maximize the total profit. Variable Cells Name Cell SBS9 Product M SC$9 Product N Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 1875 0 13 13 4.3 375 0 26 13 13 Constraints Cell Name SDSS 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? 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 ). The organization needs to determine the quantity of each product X manufactured in order to maximize the total profit Variable Cells Name Cell SB59 Product M $C$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 SDS5 Resource X SDS6 Resource Y Final Shadow Constraint Allowable Value Price R.H. Side Increase 3000 65 3000 1050 4500 325 4500 1500 Allowable Decrease 750 2100 For Product M. what is the range of unit price over which the optimal solution given above will hold true? WhatsApp Imagejpeg WhatsApp Image..jpeg WhatsApp Image.--.jpeg A WhatsApp Image.jpeg A O li P A4 ENG C Cone westion 6 scattered=3169542_1&Courte_d=52492 18 corred=341551 C1W Consider the eng serstity report generated for an organization that produces two products Product Mand Products using to resorts RTX These Xasuresinorder to maximize the total profit Cele Name ses Product SCS ProducN Final Reduced Objective Allowable Allowable Value Cost Coefficient increase Decrease 1875 0 13 375 0 26 13 13 Constants Name Cele SO55 Resource X SOS6 Resource Y Final Shadow Constraint Allowable Value Price RH. Side Increase 3000 6.5 3000 1050 4500 3.25 4500 1500 Allowable Decrease 750 2100 What is the maximum price that the company would be willing to pay for an additional unit of Resource Xe How many more units of the resource could be purchased at this price uestion 7 Consider the following sensitivity report generated for an organization that produce two products Product Mand Product ) using to resources Resource and restaurante x manufactured in order to maximize the total profit Variable Cells Final Reduced Objective Allowable Allowable Value Cost Coefficient increase Decrease 1875 25 13 ses Product M SC59 Product N 375 Final Shadow Constraint Allowable Value Price RH. Side Increase 3000 65 3.25 1500 Allowable Decrease 750 2100 SOSS Resource X For Product what is the range of unit price over which the optimal solution ven above wil hold true? Question 8 Consider the following sensory report generated for an organization that produces to products Product and Product ning resources Resort and Ruang Standa Y Excels Excel 2 co Optir G Concie C Get He CC Cor C Backg C 1. Wh C Q2) W What What: 00008 Shorte d.adu.acae Webapps/assessment/review/review.jsp?attemp_id=_3159642.1&course_id= 52492_1&content_id=_944335_1&retum content=1&step= Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease SD$5 Resource X 3000 6.5 3000 1050 750 SD$6 Resource Y 4500 3.25 4500 1500 2100 BU Linear BU Linear + 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 M and Product N) using two resources (Resource X and Resource Y). The organization needs to determine the quantity of each pro x manufactured in order to maximize the total profit. Variable Cells Name Cell SBS9 Product M SC$9 Product N Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 1875 0 13 13 4.3 375 0 26 13 13 Constraints Cell Name SDSS 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? 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 ). The organization needs to determine the quantity of each product X manufactured in order to maximize the total profit Variable Cells Name Cell SB59 Product M $C$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 SDS5 Resource X SDS6 Resource Y Final Shadow Constraint Allowable Value Price R.H. Side Increase 3000 65 3000 1050 4500 325 4500 1500 Allowable Decrease 750 2100 For Product M. what is the range of unit price over which the optimal solution given above will hold true? WhatsApp Imagejpeg WhatsApp Image..jpeg WhatsApp Image.--.jpeg A WhatsApp Image.jpeg A O li P A4 ENG C Cone westion 6 scattered=3169542_1&Courte_d=52492 18 corred=341551 C1W Consider the eng serstity report generated for an organization that produces two products Product Mand Products using to resorts RTX These Xasuresinorder to maximize the total profit Cele Name ses Product SCS ProducN Final Reduced Objective Allowable Allowable Value Cost Coefficient increase Decrease 1875 0 13 375 0 26 13 13 Constants Name Cele SO55 Resource X SOS6 Resource Y Final Shadow Constraint Allowable Value Price RH. Side Increase 3000 6.5 3000 1050 4500 3.25 4500 1500 Allowable Decrease 750 2100 What is the maximum price that the company would be willing to pay for an additional unit of Resource Xe How many more units of the resource could be purchased at this price uestion 7 Consider the following sensitivity report generated for an organization that produce two products Product Mand Product ) using to resources Resource and restaurante x manufactured in order to maximize the total profit Variable Cells Final Reduced Objective Allowable Allowable Value Cost Coefficient increase Decrease 1875 25 13 ses Product M SC59 Product N 375 Final Shadow Constraint Allowable Value Price RH. Side Increase 3000 65 3.25 1500 Allowable Decrease 750 2100 SOSS Resource X For Product what is the range of unit price over which the optimal solution ven above wil hold true? Question 8 Consider the following sensory report generated for an organization that produces to products Product and Product ning resources Resort and Ruang