using Excel solver, solve the following LP problem

Question number 2 Using excel solver, solve the following LP problem. X, number of cases of model A made X2= number of cases of model B made X-number of cases of model C made X, number of cases of model D made Min cost (Z) = 10x, +6 X2 + 14 x3 +9 X4 Subject to 1x1 + 1x3 = 100 Demand model A 1x2 + 1x4 = 150 Demand model B 4x + 4x2 S 600 Molding time 6x1 + 8x2 S 1100 Assembly time X1, X3, X3 X4 20 (Non-negativity constraint) Note that fractional values for the models are acceptable. Use two decimal places to provide answers to questions 4 through 8 eet Each of the following questions carries two marks 4. What is the optimal solution? What is the value of the objective function? 5. Suppose that the cost for the model A is increased by S1 per unit, and the cost for the model C is decreased by 0.50 per unit. What will be the new optimal solution be? 6. What is the value of reduced cost for the model C? Explain it in not more than four sentences. Provide any calculation to support your point. 7. If the company buys 20 more assembly time, what is the new profit? 8. Identify the range of optimality for the objective function coefficients