Question: 6. Interpreting Sensitivity Report Adjustable Cells Cell Name S859 Acres Planted Peppers SC59 Acres Planted Tomotoes Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase

6. Interpreting Sensitivity Report Adjustable

6. Interpreting Sensitivity Report Adjustable Cells Cell Name S859 Acres Planted Peppers SC59 Acres Planted Tomotoes Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 4 0 30000 10000 10000 8 0 40000 20000 10000 Constraints Final Shadow Value Price 20000 30 6666.666667 0 Cell Name $B$14 Land LHS SBS15 Labor LHS $B$16 Max Pepper LHS 12 Constraint Allowable Allowable R.H. Side Increase Decrease 12 1 30 6 1E+30 Provide as much information as you can for each of the questions without re-solving the LP. Consider each question independent of the others. a. What minimum profit per acre should Organic consider planting more tomatoes? b. The profit per acre of tomatoes has dropped to $35,000. How will this affect the optimal solution? Total profit? c. The profit per acre of peppers has dropped to $15,000. How will this affect the optimal solution? Total profit? d. The workforce has been reduced by 3. How will this affect the optimal solution? Total profit? e. Two more acres of the 12 acres can be converted to produce peppers at a cost of $20,000. Should they make the conversion? f. The nearby community college wants to rent a 2-acre greenhouse for $35,000 per year. Should they do it? Why or why not

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!