Dark Heart Coffee: Sensitivity Report Variable Cells Cell Name $B$9 Solution Values x1 $C$9 Solution Values...

 

Transcribed Image Text:

Dark Heart Coffee: Sensitivity Report Variable Cells Cell Name $B$9 Solution Values x1 $C$9 Solution Values x2 Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease S 0 20 9 0 17 1.25 9.67 7.25 Constraints Cell Name SDSS Assembly left hand side SD$6 Inspection left hand side SD$7 Shipping left hand side Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 0.625 50 10 14 0 60 1E+30 23.75 30 7.25 30 10.56 S 50 36.25 Dark Heart Coffee had a local competitor that ran out of Decaf Coffee, so Dark Heart raised prices to capitalize on the opportunity. They raised prices by $4 per bag on the Soothing Decaf product. What is the new profit they will see going forward on the Soothing Decaf product? Dark Heart Coffee: Sensitivity Report Variable Cells Cell Name $B$9 Solution Values x1 $C$9 Solution Values x2 Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease S 0 20 9 0 17 1.25 9.67 7.25 Constraints Cell Name SDSS Assembly left hand side SD$6 Inspection left hand side SD$7 Shipping left hand side Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 0.625 50 10 14 0 60 1E+30 23.75 30 7.25 30 10.56 S 50 36.25 Dark Heart Coffee had a local competitor that ran out of Decaf Coffee, so Dark Heart raised prices to capitalize on the opportunity. They raised prices by $4 per bag on the Soothing Decaf product. What is the new profit they will see going forward on the Soothing Decaf product?