Question: please solve via Excel Solver (Data-->Solver) The following 5 questions are based on this information. A farmer has a 40-acre farm in Georgia. The farmer

please solve via Excel Solver (Data-->Solver)  please solve via Excel Solver (Data-->Solver) The following 5 questions are
based on this information. A farmer has a 40-acre farm in Georgia.
The farmer is trying to determine how many acres of corn, peanuts,
and cotton to plant. Each crop requires labor, fertilizer, and insecticide. The

The following 5 questions are based on this information. A farmer has a 40-acre farm in Georgia. The farmer is trying to determine how many acres of corn, peanuts, and cotton to plant. Each crop requires labor, fertilizer, and insecticide. The farmer has developed the following linear programming model to determine the number of acres of corn (X1), peanuts (X2), and cotton (X3) to plant Constraint1:Constraint2:Constraint3:Constraint4:s.t.21+32+2312041+32+30LaborhoursFertilizer,TonsInsecticide,FonsAcres in order to maximize profit. Solve the problem via Excel Solver (Data > Solver) using the data file: Farming.xlsx from the link below to determine how much the total profit will be and how many acres should be planted for each crop. Generate both the Answer report and the Sensitivity Report. Upload the solutions file using the link provided. How many acres of Corn should be planted? Question 26 How many acres of Cotton should be planted? How many acres of Peanuts should be planted? Question 28 What is the maximum profit? (don't use $ sign and give two decimal places) How much profit will increase if you can get 10 more tons of insecticide? So not use the "\$" sign in your answer. Hint: Look at the Sensitivity report, and consider the Shadow Price (for the relevant operation)

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