excel document

Rubble Company has seven new projects available. To receive a project's return, Rubble 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). Rubble Company has a maximum of $22,000,000 to invest each year. 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. a. Hint: You will need to use a bin constraint. 2. Create a Text Box a. In the Text Box, state which projects that Rubble Company should invest in. b. In the Text Box, state the total return that Rubble Company will earn from the projects