Question: Use genetic algorithm ( the one in excel ) and maximize the sum of profit shown in cell I 8 . Do so by changing

Use genetic algorithm (the one in excel) and maximize the sum of profit shown in cell I8. Do so by changing only cells H2 through H7(meaning changing the area irrigated for different categories of crops). All others should be treated as coefficients/not variables to be changed by genetic algorithm. The constraints are to make sure total area irrigated doesn't change, total revenue doesn't drop but can increase, carbon footprint can drop but can't increase, cost of water use can drop but can't increase.
Use genetic algorithm ( the one in excel ) and

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 Programming Questions!