Solve the integer programming model formulated in Question 3 by using Excel. You can see the required IP model in the relevant

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. Position Ball- Handling Shooting Defense 3 Player 1 2 3 4 5 G G-F F-C G-F F-C G-F 2 2 1 3 3 3 1 3 3 3 1 2 Rebounding 1 3 2 3 3 2 2 1 3 3 1 3 6 2 7 3 2 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 must 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