Solving graphically and using excel solver

There are two problems to complete. 1-1. use Excel Solver to complete problem 1-2. Problems: Problem 1-1: A farmer owns 450 acres of land. He is going to plant each acre with wheat or corn. Each acre planted with wheat yields $4000 profit, requires three workers, and requires two tons of fertilizer. Each acre planted with corn yields $2000 profit, requires two workers, and requires four tons of fertilizer. There are currently 1000 workers and 1200 tons of fertilizer available. To hedge against risk, the farmer wants to sure that the acres of wheat do not exceed the acres of corn by 150 acres; similarly, the farmer wants to sure that the acres of corn do not exceed the acres of wheat by 150 acres. Let’s define the decision variables as follows: W: acres of wheat; C: acres of corn 1. Please formulate the objective function of this farmer. 2. Please write down all the constraints of this LP problem. 3. Please create a coordinate plane, putting W on the horizontal axis and C on the vertical axis. 4. Plot all boundary lines. 5. Identify feasible region. 6. Compute the coordinates and the objective value for each corner of the feasible region. 7. Clearly state your optimal solution and optimal objective value. Problem 1-2: Remark: Please type all your answers in an Excel file and submit your Excel file here. Your optimal solution must be directly generated by Excel Solver. (This assignment is associated with chapter 3. My videos “How To Use Solver to Solve an LP Problem” and “Another Solver Example: Make or Buy” definitely help.) The Weedwacker Company manufactures two types of lawn trimmers: an electric model and a gas model. The company has contracted to supply a national discount retail chain with a total of 30,000 electric trimmers and 15,000 gas trimmers. However, Weedwacker’s production capacity is limited in three departments: production, assembly, and packaging. The following table summarizes the hours of processing time available and the processing time required by each department, for both types of trimmers: Hours Required per Trimmer Electric Gas Hours Available Production 0.20 0.40 10,000 Assembly 0.30 0.50 15,000 Packaging 0.10 0.10 5,000 The company makes its electric trimmer in-house for $55 and its gas trimmer for $85. Alternatively, it can buy electric and gas trimmers from another source for $67 and $95, respectively. How many gas and electric trimmers should Weedwacker make, and how many should it buy in order to fulfill its contract in the least costly manner?