The "Sensitivity Report" for problem 19 (above) is, as follows: If the Corner Coffee Shop can acquire more of one of the additional types of coffee, it should be Colombian Dark Mild Special The Corner Coffee Shop blends and sells three basic blends in 1lb. bags - Special, Mountain Dark and Mill Regular. It uses four different types of coffee to produce the blends - Brazilian, mocha, Colombian and mild. The shop has the following blend recipe requirements: The cost of Brazilian coffee is $2.00 per lb., the cost of mocha is $2.75 per lb., the cost of Colombian is $2.00 per lb., and the cost of mild is $1.75 per lb. The shop has 110lbs. of Brazilian coffee, 70lbs. of mocha, 80lbs. of Colombian and 150lbs. of mild coffee available each week. The shop wants to know the amount of each blend - Special, Dark, and - to prepare each week to maximize profit. The linear programming model for this problem is, as follows: Xi=lbs. of coffee i used in blend j per week, where i=b (Brazilian), o (Mocha), c (Colombian), m (mild), and j=s (special), d (dark), and r (regular) MaximizeZ=4.5Xbs+3.75Xos+3.60Xcs+4.80Xms+3.25Xbd+2.5Xod+2.35Xcd+3.55Xmd+1.75Xbr+1.00Xbr+0.85Xcr+2.05Xmr Subject to .6Xcs.4Xbs.4Xos.4Xms0.3Xbs+.7Xos.3Xcs.3Xms0.4Xbd.6Xod.6Xcd.6Xmd0.1Xbd.1Xod.1Xcd+.9Xmd0.6Xbr.6Xor.6Xcr+.4Xmr0.7Xbr.3Xor.3Xcr.3Xmr0Xbs+Xbd+Xbr110Xos+Xod+Xor70Xcs+Xcd+Xcr80Xms+Xmd+Xmr150Xij0 For problem 19 (above) the Solver window is, as follows: The formula for the model decision variables that should be entered into the "By Changing Variable Cells:" window in the Solver window above is C5:E18 C4:E4 C5:E8 C4:E9 For problem 19 , the formula for the constraint dealing with the availability of Columbian coffee that should be entered in the "Subject to the Constraints:" window in the Solver window (above in problem 21) is F7G7 G7 F7 C9:EP=F5:FB C5:EBF5:FB For problem 23 (above), if the Corner Coffee Shop could get more Mocha coffee for free, how many pounds of it could be acquired before the marginal value (shadow price) changes? The formula in cell C10 for profit is =SUMPRODUCT(C4:E8) =SUMPRODUCT(C5:E8,C15:E18) =SUM(C5:E8,C15:E18) =PRODUCT(C5:E18) The Excel spreadsheet with the optimal solution is, as follows: + In problem 19 (above) the formula in cell G15 for the mix requirement amount of Brazilian in the Dark blend is =0.6E50.6E60.6E7+0.4E8 =0.6C70.4C50.4C60.4C8 =0.4D50.6D60.6D70.6D8 =0.3C5+0.7C60.3C70.3C8