Using Excel and SolverTable please answer the following:

*all info must be put in a table*

Problem 1: A farmer in Iowa owns 450 acres of land. He is going to plant each acre with wheat or corn. Each acre planted with wheat yields $2000 profit, requires three workers, and requires two tons of fertilizer. Each acre planted with corn yields $3000 profit, requires two workers, and requires four tons of fertilizer. There are currently 1000 workers and 1200 tons of fertilizer available. 1. Use Solver to help the farmer maximize the profit from his land. 2. Use SolverTable to see what happens to the decision variables and the total profit when the availability of fertilizer varies from 200 tons to 2200 tons in 100-ton increments. When does the farmer discontinue producing wheat? When does he discontinue producing corn? How does the profit change for each 10-ton increment? Problem 2: PC TECH assembles and tests two models of computers, Basic and XP. The company wants to decide how many of each model to assemble and test. No computers are in inventory from previous month and because models are not going to change after this month, the company doesn't want to hold any inventory after this month. The company believes it will: Sell: 800 Basic and 1500 XPs Each Basic will sell for $200 Each XP will sell for $350 The cost component parts for Basic is $50 The cost component parts for XP is $125 Labor is required for assembly and testing: There are 20000 hours for assembly/ each labor hour $15 There are 5000 hours for testing/each labor hour $20 Each Basic requires 2 Hrs. for Assembly and 1 Hr. for Testing Each XP requires 8 hrs. For Assembly and 4 Hrs. for Testing The objective is the company wants to know how many of each model it should produce to Maximize the net profit subject that it doesn't violate the labor hours and it doesn't want to produce more that it can sell. So, you are tasked to find the best MIX of the number of computer models within the company labor availability and sales constraints that will MAX the NET Profit Do sensitivity analysis for changing the labor cost for assembly between 1-5 with increments of 1 for basic and from 6-15 with increments of for XP. Can you be creative to change the maximum sales to change from -50% to + 50% and se what will happen to the Max Profits? Other sensitivity analyses besides those discussed could be performed on the product mix model. Use Solver Table to perform each of the following. In each case keep track of the values in the decision variable cells and the objective cell and discuss your findings. 1. Let the selling price for Basics vary from $220 to $350 in increments of $10. 2. Let the labor cost per hour for assembling vary from $5 to $20 in increments of $1. 3. Let the labor hours for testing a Basic vary from 0.5 to 3.0 in increments of 0.5. 4. Let the labor hours for assembling and testing an XP vary independently, the first from 4.5 to 8.0 and the second from 1.5 to 3.0, both in increments of 0.5