Comfortable Hands Comfortable Hands is a company which features a product 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 manufacturing labor force is unionized. Each full-time employee works a 40-hour week. In addition, by union contract, the number of full-time employees can never drop below 20. Nonunion part-time workers can also 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 2 full-time employees for each part-time employee. All three types of gloves are made out of the same genuine cotton. Comfortable Hands has a long-term contract with a supplier of the cotton, and receives a 5,000 kg shipment of the material each week. The material requirements and labor requirements, along with the gross profit per glove sold (not considering labor costs) is given in the following table.

Milestone 1) to present your spreadsheet and its optimization results (you may take screenshots). In addition, your presentation file should address the followings: a. What is the mathematical LP formulation of the problem? b. Which input parameter in the problem has the greatest impact on the objective function? c. What is the optimal solution to the problem? Describe it in words. Your spreadsheet model should be contained in a single Excel file and it will be evaluated based on the following criteria: (1) organization, neatness, and design of the spreadsheet, (2) capturing all the facts of the presented project and (3) quality and impact of the results derived.

Glove Material Required Labor Required Gross Profit (kg) (Minutes) (per Pair) 30 Men's Women's Children's 2 1.5 1 45 40 $8 $10 $6 Glove Material Required Labor Required Gross Profit (kg) (Minutes) (per Pair) 30 Men's Women's Children's 2 1.5 1 45 40 $8 $10 $6