Do a). Mr. Yara has 200 acres of land available to plant for three types of fruit trees (lemon, peach andcherry). Based on the market survey, lemon has a selling price of $2 per kg; peach has a sellingprice of $1.5 per kg and cherry has a selling price of $4 per kg. The average yield per acre forlemon, peach and cherry is 4, 6 and 2 tonne, respectively. The fertilizer requires per acre forlemon, peach and cherry is 100, 100 and 50 kg, respectively. An acre of lemon and cherryrequires 10 labour hours each whereas an acre of peach requires 12 labour hours. Maximumavailability of labour is 20,000 hours. The cost of fertilizer is $2 per kg and the cost of labour is$40 per hour. What is the optimal allocation of acre to the three types of fruit trees?[1 tonne = 1000kg](a) Formulate a linear programming model to maximize the profit.(b) Find the optimal solution by using simplex algorithm.(c) Regenerate the sensitivity report given below by using Excel's Solver.Variable CellsFinal Reduced Objective Allowable AllowableValue Cost Coefficient Increase DecreaseCellName$B$6 Value Lemon (x1)-920$C$6 Value Peach (x2)0$D$6 Value Cherry (x3)-820ConstraintsFinal ShadowConstraint Allowable AllowableIncrease DecreaseCellNameValuePriceR.H. Side$B$9 Land (acre) (LHS)8320$B$10 Labour (hour) (LHS)0(d) From the above sensitivity report, answer the following questions.(i) Interpret the reduced cost for the decision variable of cherry in terms of profitcontribution and optimal solution.(ii) Interpret the shadow prices for the land and labour constraints, respectively.(iii) Find the right hand side range for the labour constraint. Interpret the result about theshadow price, optimal solution and the value of the optimal solution.

Question

Accepted Answer

Double check labour hour per acre. It looks not comparable with other details the question.