Using excel will aid in finding the solution to this problem.

(20 pts) Alberto is a former in Nepal. He is deciding whether to plant rice () a (1) lentils (u), coconut (M) or avocado in She has 125 land she only has $150,000 on hand, a storage capacity of 5,000 tons, and a labor of 4.500 hours. Her wille Belly says he needs to plant family consumption at least 40 acres of avocado which is a requirement from the govemment, and that he needs to plant at least 50 acres of rice for personal Using all of this information, the following linear programming has been constructed in order to maximize profits (r) by planting res of rice (*). palm ly). Lentis (), coconut (V) andior avocado max = 30x + 4y +60+20 +25 Subject to the following constraints Land (in acres x+y+ + +5 125 () Storage (in busheis) 30x + 20y + 15 + 25 +202 55.000 (1) Labor (in hours per your 50x + 30y +20+20 +353 4.500 (1) Capital (in 1250x + 1500y + 1000 + 3000 + 10002 5 150,000 (M) Minimum avocado (in acres 2240 (VI) Minimum Rice (in acros) x 250 X. y.U.V.Z 20 Directions: Solve using Solver, please write your name and entitle the tab and file as your name LP Problem 1. No credits are given if these steps are not followed carefully (10 pts) Write the LP problem in Excel, establish the fomulas comectly and solve it using SOLVER v (5 pts) Please write here the problem including correctly the sack or surplus variable. Then, write the values of the slack surplus variable Linear programming including the lack and surplus variables (correct sign: S- S, S = S S = S- (3 pts) Which constraints are active? Why? Constraint (activeot active) Constraint il (activeot active) Constraint Hill (activeot active) Constraint IV (active not active) Constraint V (active not active) Constraint Vi (activeot active) (2 pts) Use sensitivity analysis: Alberto is able to borrow 1 acre of land to plant more of these crops. Assuming the optimal crop combination is the same. Profit (increases/decreases does not change) by S does not change, just to zero