Please include an active Excel worksheet for the Excel Solver/OpenSolver in your solution

1. Dave has $100,000 to invest in 10 mutual fund alternatives with the following restrictions. For diversification, no more than $25,000 can be invested in any one fund. If a fund is chosen for investment, then at least $10,000 will be invested in it. No more than two of the funds can be pure growth funds, and at least one pure bond fund must be selected. The total amount invested in pure bond funds must be at least as much as the amount invested in pure growth funds. Using the following expected returns, formulate and solve an integer programming model that will determine the investment strategy that will maximize expected annual return.

Expected Fund12345678910TypeGrowthGrowthGrowthGrowthGrowth&IncomeGrowth&IncomeGrowth&IncomeStock&BondBondBondReturn(%)6.707.657.557.457.506.457.056.905.205.90