Warhawk Company has seven new projects available. To receive a project's return, Warhawk must invest in the project for all three years (if they do not invest all three years, then there is NO return from the project). Warhawk Company can invest a maximum of $20,000,000 each year. Project A B C D E F G Year 1 Investment $5,000,000 $4,000,000 $3,000,000 $3,000,000 $7,000,000 $3,000,000 $6,000,000 Year 2 Investment $1,000,000 $7,000,000 $8,000,000 $9,000,000 2. Create a Text Box a. b. $4,000,000 $2,000,000 $8,000,000 a. Hint: You will need to use a bin constraint. Year 3 Investment $8,000,000 $9,000,000 $4,000,000 $2,000,000 $1,000,000 $3,000,000 $9,000,000 Requirements: Both requirements must be completed on a single worksheet. 1. Use solver to determine which projects should be invested in to maximize the total return from the projects. Project's Return $25,000,000 $35,000,000 $30,000,000 $20,000,000 $15,000,000 $10,000,000 $40,000,000 In the Text Box, state which projects that Warhawk Company should invest in. In the Text Box, state the total return that Warhawk Company will earn from the projects.