Please use excel solver and show your steps.

3.23. Comfortable Hands is a company that features a prod- uct line of winter gloves for the entire familymen, women, and children. They are trying to decide what mix of these three types of gloves to produce. Comfortable Hands's manufacturing labor force is union- ized. Each full-time employee works a 40-hour week. In addi- tion, by union contract, the number of full-time employees can never drop below 20. Nonunion, part-time workers also can be hired with the following union-imposed restrictions: (1) each part-time worker works 20 hours per week and (2) there must be at least two full-time employees for each part- time employee. All three types of gloves are made out of the same 100 percent genuine cowhide leather. Comfortable Hands has a long-term contract with a supplier of the leather and receives a 5,000-square-foot shipment of the material each week. The mate- rial requirements and labor requirements, along with the gross profit per glove sold (not considering labor costs), are given in the following table. Material Required (Square Feet) Labor Required (Minutes) Gross Profit (per Pair) Glove Men's Women's Children's 2 1.5 1 30 45 40 $8 10 6 Each full-time employee earns $13 per hour, while each part-time employee earns $10 per hour. Management wishes to know what mix of each of the three types of gloves to produce per week, as well as how many full-time and part-time workers to employ. They would like to maximize their net profittheir gross profit from sales minus their labor costs. a. Formulate algebraically the Linear Programming (LP) model for this problem. (17 points) b. Formulate this same linear programming problem on a spreadsheet and SOLVE using Excel Solver (Provide the corresponding Excel Spreadsheet and the Answer Report). Include "managerial statements that communicate the results of the analyses (i.e. describe verbally the results). (13 points)