Complete all the problems provided in the attached Excel assignment. For the problem, follow these steps:

Develop the appropriate linear$/$non$-$linear model. Clearly define the$$objective function, all$$constraints$,$ and the$$variable limitations$($e$.$g$.,$ non$-$negative, binary, integer, or continuous variables$).$

Solve the problem using$$Excel Solver. Record the solutions. If there are$$no solutions,$$multiple solutions, or$$alternative solutions, provide a detailed discussion.$$

Problem $2$: The Global Investment Fund $($GIF$)$ invests in energy bonds $($E$),$ real estate loans $($R$),$ tech stocks $($T$),$ and infrastructure bonds $($I$).$ To ensure a well$-$diversified portfolio,

GIF has set limits on the maximum investment allowed in each asset category. The fund currently has $$4$ million available for investment and aims to

$(1)$ maximize the return on investment over the next six months and $(2)$ meet the diversification guidelines established by the board.

The details of the investment opportunities are as follows:

Additionally, the board has established the following diversification rules:

At least $50\%$ of the total amount invested must be allocated to tech stocks $($T$)$ and infrastructure bonds $($I$)$ combined.

At least $20\%$ of the total amount invested must be in energy bonds $($ E $).$

GIF seeks to maximize the return on its investment while complying with these restrictions.

$($a$)$ Formulate the Linear Programming $($LP$)$ Model:

Clearly define the decision variables, write the objective function that needs to be maximized, and list all the constraints governing the problem.

Ensure that all variables, constraints, and relationships are explicitly stated and aligned with the investment guidelines provided.

$($b$)$ Solve the problem using Excel Solver.