pls show how to enter it in Excel Solver

1. XYZ Tires, Inc. makes two types of tires, for SUV's and Hatchbacks. The firm has 500 hours of production time, 250 hours of packaging, and 150 hours available for shipping. The production time required per tire type is given in the following table: Assuming that the company is interested in maximizing the total profit contribution, find the optimal solution using Excel Solver and answer the following: a. How many hours of production time will be scheduled in each department? b. What is the slack time in each department? Implement a spreadsheet model and use Excel Solver to obtain a solution to the problem. (Submit the complete Solver File) 2. A farmer in Egypt owns 50 acres of land. He is going to plant each acre with cotton or corn. Each acre planted with cotton yields $400 profit; each with corn yields $200 profit. The labor and fertilizer used for each acre are given in the table below. Resources available include 150 a. Formulate a linear programing model that will enaoie me corn to maximize his profit. acres that should be planted cotton and /or corn the optimal b. Implement the model in (a) in c. Obtain a sensitivity report for the model in (a). 1. XYZ Tires, Inc. makes two types of tires, for SUV's and Hatchbacks. The firm has 500 hours of production time, 250 hours of packaging, and 150 hours available for shipping. The production time required per tire type is given in the following table: Assuming that the company is interested in maximizing the total profit contribution, find the optimal solution using Excel Solver and answer the following: a. How many hours of production time will be scheduled in each department? b. What is the slack time in each department? Implement a spreadsheet model and use Excel Solver to obtain a solution to the problem. (Submit the complete Solver File) 2. A farmer in Egypt owns 50 acres of land. He is going to plant each acre with cotton or corn. Each acre planted with cotton yields $400 profit; each with corn yields $200 profit. The labor and fertilizer used for each acre are given in the table below. Resources available include 150 a. Formulate a linear programing model that will enaoie me corn to maximize his profit. acres that should be planted cotton and /or corn the optimal b. Implement the model in (a) in c. Obtain a sensitivity report for the model in (a)