solve using ms excel solver.

Vigan Pottery Company is formulated as maximize Z = $(4-0.1 x1)x1+(5-0.2 x2) x2 subject to X1 + 2 x 2 = 40 hours (labor) where X 1 = number of bowls produced X2 = number of mugs produced 40.1 x 1 = profit ($) per bowl 50.2 x 2 = profit ($) per mug Solve for the best combination using MS Excel Solver Look for the Lagrange multiplier by checking on sensitivity analysis