A farm co-op has two farms, one at Spring Run and one at Willow Bend, where it grows corn and soybeans. Differences between the farms affect the associated costs and yield of each crop, as shown in the following table.

Each farm has 100 acres available to plant, and the total desired yields are at least 46,800 bushels of corn and at least 42,300 bushels of soybeans. How many acres of each crop should be planted at each farm in order to achieve the desired crop yields at minimum cost? What is the minimum cost?
Use Excel or some other technology.

Soybeans Corn Yield (bu/acre) Cost/Acre (bu/acre) Cost/Acre $330 Yield Spring Run Willow Bend 450 585 360 315 $297 $396 $264