1. Solve the integer programming model formulated in Question 3 of Problem set 8 document located in itslearning by using Excel. You can see the required IP model in the relevant solution document as well. Include the excel file you generated (answer report, excel model). (50 points) (If you do not submit an excel file, you will get 0 (zero)). 3. Coach Night is trying to choose the starting lineup for the basketball team. The team consists of seven players who have been rated (on a scale of 1= poor to 3-excellent) according to their ball-handling, shooting, rebounding, and defensive abilities. The positions that each player is allowed to play and the player's abilities are listed in the table below. Pasien Handling Defense Player 1 2 3 4 5 G G-F F-C Shooting 3 1 3 3 3 1 2. Rebounding 1 3 2 NN 1 3 3 3 -- NNW FC 3 2 2 7 G-F The five-player starting lineup must satisfy the following restrictions: 1. At least 4 members must be able to play guard, at least 2 members must be able to play forward, and at least 1 member must be able to play center. 2. The average, shooting level of the starting lineup must be at least 2 4. Either player 2 or player 3 mmast start. Given these constraints, Coach Night wants to maximize the total defensive ability of the starting team. Formulate an IP that will help him choose his starting team