Solve it using excel solver

clearly mention the formulae visibly and also solver dialogue box parameters also, if possible attach the final excel file

a. Revenue Bananas Potatoes Onions Tomatoes Unit Price $ $ $ $ Units per Hectare Hectares used 3.10 30 4.00 25 5.50 24 9.50 17 Obj. Func. Units of resources per hectare for each crop Potatoes Onions 9 Bananas 10 Tomatoes 4 1000 5 7 8 300 800 4 5 6 Water Labor Pesticides Nutrients Hectares 4. 4 3 4 8 7 5 600 150 b. Hectares used Profit per Hectare Bananas $ Potatoes $ Onions $ Tomatoes $ Unit Price 3.10 4.00 5.50 Units per Hectare Revenue per Hectare Expenses per Hectare 30 $ 93.00 $ 83.20 25 $ 100.00 $ 87.00 24 $ 132.00 $ 117.00 $ 161.50 $ 142.40 9.50 17 Obj. Func. 5 5 7 8 9 Bananas 10 Tomatoes 4 $ 1,500.00 Total Profit Obj. Func. 19 10 11 2 3 4 5 Bananas Units of resources per hectare for each crop Potatoes Onions 9 5 5 7 10 Tomatoes 4 8 $ 1,700.00 Total Profit Obj. Func . 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 CE Bananas 10 4 4 4 Units of resources per hectare for each crop Potatoes Onions 9 5 5 7 3 6 4 5 Tomatoes 4 4 8 8 7 Price of Resources Water S 1.20 Labor $ 9.00 Pesticides S 4.00 Nutrients $ 4.80 Hectares $ Farming G 1000 800 800 600 150 68 TI BON a. Revenue Bananas Potatoes Onions Tomatoes Unit Price $ $ $ $ Units per Hectare Hectares used 3.10 30 4.00 25 5.50 24 9.50 17 Obj. Func. Units of resources per hectare for each crop Potatoes Onions 9 Bananas 10 Tomatoes 4 1000 5 7 8 300 800 4 5 6 Water Labor Pesticides Nutrients Hectares 4. 4 3 4 8 7 5 600 150 b. Hectares used Profit per Hectare Bananas $ Potatoes $ Onions $ Tomatoes $ Unit Price 3.10 4.00 5.50 Units per Hectare Revenue per Hectare Expenses per Hectare 30 $ 93.00 $ 83.20 25 $ 100.00 $ 87.00 24 $ 132.00 $ 117.00 $ 161.50 $ 142.40 9.50 17 Obj. Func. 5 5 7 8 9 Bananas 10 Tomatoes 4 $ 1,500.00 Total Profit Obj. Func. 19 10 11 2 3 4 5 Bananas Units of resources per hectare for each crop Potatoes Onions 9 5 5 7 10 Tomatoes 4 8 $ 1,700.00 Total Profit Obj. Func . 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 CE Bananas 10 4 4 4 Units of resources per hectare for each crop Potatoes Onions 9 5 5 7 3 6 4 5 Tomatoes 4 4 8 8 7 Price of Resources Water S 1.20 Labor $ 9.00 Pesticides S 4.00 Nutrients $ 4.80 Hectares $ Farming G 1000 800 800 600 150 68 TI BON