Question: PLEASE HELP ME SOLVE THIS USING DETAILED STEPS, and PLEASE USE EXCEL SOLVER FOR PART 2 LP 1.1 Nitin Adhikari owns a land in Uttar

PLEASE HELP ME SOLVE THIS USING DETAILED STEPS, and PLEASE USE EXCEL SOLVER FOR PART 2
LP 1.1 Nitin Adhikari owns a land in Uttar Pradesh and has managed to divide his farmland of 2010 acre into three individual plots with different sizes (Plot A: 510-acre, Plot B: 800-acre, and Plot C: 700-acre). He has arranged a contract with the local farmers to plant one or more of the three chosen crops: paddy, potato, and cauliflower. Each crop has been assigned a specific land area within the assigned plot. In this case, any of the three crops are allowed to be grown on each of the plots, but Mr. Adhikari has implemented restrictions on the whole operation. Restriction 1: The max. acreage to be grown with paddy, potato, and cauliflower are being restricted to 710-acre, 460-acre, and 810-acre respectively. Restriction 2: Moreover, 60% of each individual plot must be cultivated and exactly the same proportion of each individual plot should be under cultivation. Mr. Adhikari is anticipating the per acre profit for growing paddy, potato, and cauliflower would be around $440, $400, and $260, respectively. Questions: 1. Please formulate, LP model in detailed steps for an optimal solution to Mr. Adhikari's operation. 2. Solve the model in part 1, using the help of EXCEL SOLVER, and mention Mr. Adhikari's instructions to each farmer. Also, find the total profit contributionStep by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
