Constraints

$($b$)$ Upon solving the problem, Excel solver provides the sensitivity report above. Use the

report to answer the following:

i$.(4)$ Which constraints are binding at the optimal solution?

unsheuled peamuts

ii$.(4)$ For what range of sale prices for jars of peanut butter would this production

plan remain optimal?

iii. $(4)$ For this part only, suppose the farm is required to produce at least one unit of

each product. How would this requirement affect their maximal revenue?

iv$.(4)$ The farm just received a government loan that they can use to either $1$ purchase

$2$ additional acres of land, increasing their peanut yield by $6,000$ pounds, or $[2]$ hire

$4$ new workers, increasing available shelling time by $400$ hours. Which option would

lead to a larger increase in revenue? Include calculations to back up your answer.

v$.(4)$ Explain in words the meaning of the "Allowable Increase" and "Allowable De$-$

crease" entries for the "Grinding time" constraint.