Please show me this question on excel. take screen shot and upload them and also answer all questions below.Thanks Adirondack Savings Bank $($ASB$)$ has $$1$ million in new funds that must be

allocated to home loans, personal loans, and automobile loans. The annual rates of return

for the three types of loans are $6\%$ for home loans, $10\%$ for personal loans, and $7\%$ for

automobile loans. The bank's planning committee has decided that at least $40\%$ of the

new funds must be allocated to home loans. In addition, the planning committee has

specified that the amount allocated to personal loans cannot exceed $60\%$ of the amount

allocated to automobile loans. Moreover, the amount allocated to personal loans should

be between $5\%$ and $25\%$ of the available funds.

$(3\mathrm{.}1)$ Formulate a linear programming model that can be used to determine the amount

of funds the company should allocate to each type of loan to maximize the total annual

return for the new funds.

$(3\mathrm{.}2)$ Solve the above developed model by Excel$-$Solver and generate sensitivity report.

$(3\mathrm{.}3)$ Obtain the optimal solution and interpret them.

$(3\mathrm{.}4)$ For each additional dollar invested in the home loans, how much will the annual

return be affected? Justify your answer.

$(3\mathrm{.}5)$ Give the range of feasibility to the interest rate on of personal loans and interpret it$.$

$(3\mathrm{.}6)$ The company wanted to increase the total amount of funds by $$100,000.$ Discuss the

impact of this change on the optimal value of the linear programming model.