ING (20 pts) Alberto is a farmer in Nepal. He is deciding whether to plant rice (x), tea (y), lentis (u), coconut (v) or avocado (r). She has 125 acres of land, she only has $150,000 on hand, a storage capacity of 5,000 tons, and a labor of 4,500 hours. Her wife (Betty) says he needs to plant at least 40 acres of avocado which is a requirement from the government, and that he needs to plant at least 50 acres of rice for pensional family consumption. Using all of this information, the following linear programming has been constructed in order to maximize profits (w) by planting acres office (x), palm (y). lentils (u), coconut (v) andior avocado (2) . Subject to the following constraints (1) Land (in acres) (1) Storage (in bushels): (1) Labor (in hours per year (IV) Capital (in S (V) Minimum avocado (in acres): (VI) Minimum Rice (in acres) max = 30x + 40y+60+20+25z xyz S (3 pts) Which constraints are active? Why? Constraint I Constraint II . Constraint Constraint IV Constraint V Constraint VI x+y+u+v+z 125 30x + 20y + 15u+25+20zs 5.000 50x+30y+20+20+35z 4,500 1250x+1500y + 1000u +3000+1000z 150,000 #240 *250 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 formulas correctly and solve it using SOLVER x=______Y = x.y.u.v.z 20 It's (5 pts) Please write here the problem including correctly the slack or surplus variable. Then, write the values of the slackburplus variable Linear programming including the slack and surplus variables (correct sign) ,S = Se= 4x2 (active/not active) (active/not active) (active/not active) (active/not active) (active/not active) (active/not active) St= (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 (if it does not change just write za is the same. Profit (increases/decreases/does not change) by S