please solve asap with steps

(12.5 pts) Q.3 Comfortable Hands" is a company that features a product line of winter gloves for the entire family - men, women, and children. They are trying to decide what mix of these three types of gloves to produce. Comfortable Hands' manufacturing labor force is unionized. Each full-time employee works a 8-hours. All three types of gloves are made out of the same 100% genuine cowhide leather. Comfortable Hands has a long term contract with a supplier of the leather, and receives a 10 thousands square feet shipment of the material. The material available for decoration is 7 thousands square feet. The material requirements and labor requirements, along with the gross profit per glove sold (not considering labor costs) is given in the following table. Management wishes to know what mix of each of the three types of gloves to produce per week. They would like to maximize their net profit. Glove Gross Profit Material Required (sq ft) Labor Required (hrs) (per pair) Material required for decorations (sq ft) 2 0 2 1 Men Children Women 3 1 5 1 2 4 a) Formulate a linear programming model for this problem. [3pts] b) Using Solver, find the value of Z and how many to produce from each category. Upload your answer. [2pts] c) Are all products profitable for the company? If not, name the non-profitable product(s). [Bonus Ipts] d) What are the values of the shadow prices? [2pts] e) By how much can you increase resource 1 in order to improve the solution? Do it manually and compare to excel answer (42) [5.5pts] - No more than 3 iterations. (12.5 pts) Q.3 Comfortable Hands" is a company that features a product line of winter gloves for the entire family - men, women, and children. They are trying to decide what mix of these three types of gloves to produce. Comfortable Hands' manufacturing labor force is unionized. Each full-time employee works a 8-hours. All three types of gloves are made out of the same 100% genuine cowhide leather. Comfortable Hands has a long term contract with a supplier of the leather, and receives a 10 thousands square feet shipment of the material. The material available for decoration is 7 thousands square feet. The material requirements and labor requirements, along with the gross profit per glove sold (not considering labor costs) is given in the following table. Management wishes to know what mix of each of the three types of gloves to produce per week. They would like to maximize their net profit. Glove Gross Profit Material Required (sq ft) Labor Required (hrs) (per pair) Material required for decorations (sq ft) 2 0 2 1 Men Children Women 3 1 5 1 2 4 a) Formulate a linear programming model for this problem. [3pts] b) Using Solver, find the value of Z and how many to produce from each category. Upload your answer. [2pts] c) Are all products profitable for the company? If not, name the non-profitable product(s). [Bonus Ipts] d) What are the values of the shadow prices? [2pts] e) By how much can you increase resource 1 in order to improve the solution? Do it manually and compare to excel answer (42) [5.5pts] - No more than 3 iterations