please set up using excel solver. and show/ explain all steps. i need to be able to do it myself in solver. so the equations and constrants are very important.

Provide MIN COST formulation and solve with Excel next slide's network with these b; 1) b = 50, b, = 40, by = -10, b, = -30, bs = -40 II) b = 50, b2 = 40, b- 10, be = -30, bs = -80 [Provide Model, Answer report and Sensitivity report) Use the Sensitivity report only to answer these questions for both cases (I, II): a) If you have the option of increasing the capacity of one of your links by 10 units, which one would you select? Why? How much Z would change? b) How much would Z change by decreasing C14 by 1? b b4 4/4 = 60 C4 = 9 4 4,3 = 30 C13=4 by Uus 30 U12 = 10 C12=1 usa = 40 cse = 3 3 Cas - 2 Uy3 =50 Uzs - 50 23 = 3 C3s = 1 2 5 Ibs 62 Provide MIN COST formulation and solve with Excel next slide's network with these b; 1) b = 50, b, = 40, by = -10, b, = -30, bs = -40 II) b = 50, b2 = 40, b- 10, be = -30, bs = -80 [Provide Model, Answer report and Sensitivity report) Use the Sensitivity report only to answer these questions for both cases (I, II): a) If you have the option of increasing the capacity of one of your links by 10 units, which one would you select? Why? How much Z would change? b) How much would Z change by decreasing C14 by 1? b b4 4/4 = 60 C4 = 9 4 4,3 = 30 C13=4 by Uus 30 U12 = 10 C12=1 usa = 40 cse = 3 3 Cas - 2 Uy3 =50 Uzs - 50 23 = 3 C3s = 1 2 5 Ibs 62