Please answer the following questions based on the Sensitivity Report provided above. (a) What is the optimal solution? What is the optimal objective value (i.e. annual savings)?

(b) How much would the Yonsei be willing to pay for an increase of one hour of labor from its current level of 225?

(c) How far would the price per pound of blue berries have to drop before the optimal solution would change. (d) Suppose a neighboring farmer wins 10 acres of the Yonsei farmland in a poker match. How much would this reduce the objective value for the LP?

Problem 1. Yonsei Crunch is trying to reduce costs for his tasty Crunch berries cereal. Currently he buys crunchy red berries and blue berries on the open market for $3 and $1 per pound respectively. To help reduce costs, he has purchased a 100 -acre farm to grow his own tasty, crunchy berries. Each acre planted with berries requires a yearly allotment of water as well as a specified number of hours of labor to harvest. Additionally, each type of berry provides a different yearly yield from the harvest. All of this information is provided in the table below: The Yonsei's farm is fed by a well which can only pump 6,000 tons of water per year for irrigation. Additionally, the Yonsei has found two Operations Research graduate students who will work for peanuts over the summer harvest season to satisfy their practicum requirements. The students provide 225 hours of labor at a fixed cost. All of the resource limitations are provided in the table below: If the Yonsei is capable of using all of the berries he produces, how many acres of each type should he plant to maximize his yearly cost savings? For this problem, we will use the following decision variables: xr= Number of acres planted with red berries x_b= Number of acres planted with blue berries Thus, we setup our Linear Program as follows: Maximize 270x_r+300x_b (yearly savings) subject to x_r+x_b100 (limit on farm land) 50x_r+75x_b6000 (limit on water) 2x_r+2.5x_b225 (limit on labor) x_r, _b0 After inputting this model into Excel, we receive the following Sensitivity Report: Adiustahle Celle Canctosinte Please answer the following questions based on the Sensitivity Report provided above