Can you please help explain Excel Solver while you do this? I would greatly appreciate it, it is in review for a test.

15. The Bradley family owns 410 acres of farmland in North Carolina on which they grow corn and tobacco. Each acre of corn costs $105 to plant, cultivate, and harvest; each acre of tobacco costs $210. The Bradleys have a budget of $52,500 for next year. The government limits the number of acres of tobacco that can be planted to 100. The profit from each acre of corn is $300; the profit from each acre of tobacco is $520. The Bradleys want to know how many acres of each crop to plant to maximize their profit. The LP formulation is as follows: x1 = no. of acres of corn x2 = no. of acres of tobacco maximize Z= 300xi + 520x2 subject to X1 + x2 0 Using Excel Solver, answer the following: A. How many acres of farmland will not be cultivated at the optimal solution? Do the Bradleys use the entire 100-acre tobacco allotment? B. What would the profit for corn have to be for the Bradleys to plant only corn? C. If the Bradleys can obtain an additional 100 acres of land, will the number of acres of corn and tobacco they plan to grow change? D. If the Bradleys decide not to cultivate a 50-acre section as part of a crop recovery program, how will it affect their crop plans? E. The Bradleys have an opportunity to lease some extra land from a neighbor. The neighbor is offering the land to them for $110 per acre. Should the Bradleys lease the land at that price? What is the maximum price the Bradleys should pay their neighbor for the land, and how much land should they lease at that price? F. The Bradleys are considering taking out a loan to increase their budget. For each dollar they borrow, how much additional profit would they make? If they borrowed an additional $1,000, would the number of acres of corn and tobacco they plant change