Warhawk Company has seven new projects available. To receive a project's return, Warhawk must invest in...

 

Transcribed Image Text:

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. 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.