Question: please answer the questions based on this sensitivity analysis 328 Chapter 8 Linear Programming: Sensitivity Analysis and Interpretation of Solution FIGURE 8.13 SENSITIVITY REPORT FOR

please answer the questions based on this sensitivity analysis please answer the questions based on this
please answer the questions based on this
328 Chapter 8 Linear Programming: Sensitivity Analysis and Interpretation of Solution FIGURE 8.13 SENSITIVITY REPORT FOR THE ELECTRONIC COMMUNICATIONS PROBLEM WEB file Variable Cells Model Variable Name M Number of Units Produced Marine B Number of Units Produced Business R Number of Units Produced Retail Electronic D Number of Units Produced Direct Mail Final Reduced Objective Allowable Allowable Value Cost Coellicient Increase Decrease 25.000 0.000 90.000 IE+30 6.000 425.000 0.000 84.000 6.000 34.000 150.000 0.000 70.000 17.000 IE+30 0.000 -45.000 60.000 45.000 IE+30 Constraints Constraint Number Nante Advertising Budget 2 Sales Force Availability Production Level 4 Retail Stores Requirement Final Shadow Constraint Value Price R.H. Side 5000.000 3.000 SOXX0.000 1775.000 0.000 1800.000 600.000 60.000 64X0.000 150.000 - 17.000 150.000 Allowable Allowable Increase Decrease 850.000 50.000 IE+30 25.000 3.571 85.000 50.000 150.000 Cengage .camning 2013 3 1 If the company make a change on the limits of constraints, which constraint should receive the highest priority? Why? 2 A suggestion is made to increase the Production Level at the additional cost of $50/unit. Is this advisable? Why? 3 If the Advertising Budget is increased from the present $5000 hours to $5500, how will this increase impact the optimum profit contribution? 4 What would happen if the objective function coefficient associated with Number of Units Produced Direct Mail (D) increases up to $100 per unit? 5 For what range of profit contributions for the Number of Units Produced Business (B) will the original solution remain optimal? 6 What happens to the optimum profit contribution if the objective function coefficient associated with Number of Units Produced Business (B) drops to $80 per unit B

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!