Use Excel solver to solve the model and interpret the results

1. Walnut Orchard has two farms that grow wheat and corn. Because of differing soil conditions, there are differences in the yields and costs of growing crops on the two farms. The yields and costs are shown in the table below. Farm 1 has 100 acres available for cultivation, while Farm 2 has 150 acres. The farm has contracted to grow 11,000 bushels of corn and 6000 bushels of wheat. Determine a planting plan using an LP that will minimize the cost of meeting these contracts. Farm 1 Farm 2 Corn yield (bushels/acre) Cost of corn ($/acre) 90 Wheat yield (bushels/acre) Cost of wheat ($/acre) 80 100 120 115 35 40 90