Please show all work and use excel

1. (5 pts) In part, the problem was solved both algebraically in Excel in class in "V348-LP-1-2-Min": min Z = 6 X1 + 3 X2 s.t. 2:21 +422 > 16 421 +3:22 > 24 X1, X2 > 0 Make sure you received solution the same to that we obtained in class. Perform sensitivity analysis. 2. (5 pts) problem #3 from ch.4 (p.153) this is the continuation of the problem solved in class. Perform sensitivity analysis for the appropriate constraint only (resource) 3. In the investment example in this chapter, how would the solution be affected if the requirement that the entire $70,000 be invested was relaxed such that it is the maximum amount available for investment? If the entire amount available for investment does not have to be invested and the amount available is increased by $10,000 (to $80,000), how much will the total optimal return increase? Will the entire $10,000 increase be invested in one alternative