Could you please solve this using excel and show a step by step way to plug it in$.$ Really struglling with this question

Q$1(20$ pts$).$ One of the many linear programming applications is in doing cost$-$to$-$benefit analysis. The objective is to select a combination of benefits so as to minimize the cost $($premium$)$ while satisfying all the benefits goals.

The decision variables here are the levels of four activities $($A$1,$ A$2,$ A$3$ and A$4).$ The linear programming formulation looks like as below:

Minimize Total Cost $=2A1+A2-A3+3A4$

Subject $to$:

Benefit $1$: $3A1+2A2-2A3+5A480$

Benefit $2$: $A1-A2,+A410$

Benefit $3$: $A1+A2-A3,+2A430$

$A1,A2,A3,A4$ are algreater than or equal to $0.$

a$.$ Solve this problem using Solver, and save results and sensitivity analysis. Write down and interpret the solution.

b$.$ Which constraints are binding? If you relax the first constraint to $79,$ what will be the impact on the total cost? If you increase the second constraint to $11,$ what will be the impact on the total cost? $($Note: Look at the sensitivity analysis to answer this question.$)$

c$.$ If the cost of A$1$ was decreased to $1,$ what will be the impact on the solution? $($Note: Look at the sensitivity analysis to answer this question.$)$

Q$2(20$ pts$).$ When you examined the solution to Problem $1,$ it did not make sense. The decision variables must be integers. Solve the problem again using Solver to get an all$-$integer solution. Write down and interpret the solution. Why is the cost for this solution higher than the solution in Q$1$