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,

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 contribution

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!