Advisor/Bulletin sensitivity analysis For the Advisor/Bulletin Publishing problem (LP model on page 12) sensitivity report provided, consider each of the following changes independently. Explain the consequences. C IDLE F G H 1 Microsoft Excel 9.0 Sensitivity Report 2 Worksheet: [AdvisorBulletin Problem.xls]Model 3 Report Created: 9/9/2002 1:08:26 PM 4 5 6 Adjustable Cells 7 Final Reduced Objective Allowable Allowable 8 Cell Name Value Cost Coefficient Increase Decrease 9 $B$5 No. to publish X's): Advisors 5 0 3000 300 250 10 $C$5 No. to publish (xs). Bulletins 5 0 5500 500 500 11 12 Constraints 13 Final Shadow Constraint Allowable Allowable 14 Cell Name Value Price R.H. Side Increase Decrease 15 SD$12 Machine time (hrs.) LHS (Used)) 40 500 40 4 2.5 16 $D$13 Ink (barrels) LHS (Used)) 15 1500 15 1 1.666666667 17 $D$ 14 Paper (rolls) LHS (Used)) 50 0 82 1E+30 32 18 19 A 1. The projected profit contribution for Advisor is revised from $3000 to $3200. 2. The projected profit contribution for Bulletin is revised from $5500 to $4500. 3. The publishing firm has 42 hours of machine time instead of 40 hours. 68