Abigail Kwan is an operations manager at FashionTech, a manufacturer of clothing for families with…

Abigail Kwan is an operations manager at FashionTech, a manufacturer of clothing for families with an active andoutdoor lifestyle. One of the difficult decisions that Abigail has to make every winter season is to decide how manyparkas and winter jackets for women to produce. Both products use the same materials and require very similarsewing and stitching skills and manufacturing steps, and, therefore, compete for the same resources.After collecting necessary information, Abigail narrows down the scope of her analysis. She starts by focusing onanalyzing data for the medium-sized jackets and parkas. The per-unit profits for a winter jacket and parka are $9 and$12.50, respectively. Also, a medium-sized jacket requires approximately 8.5 feet of fabric, while a medium-sized parkarequires about 12.5 feet of the same fabric. The amount of machine time needed to produce a jacket and a parka are1.5 hours and 2 hours, respectively. A tailor usually spends about 2 hours on sewing and stitching for a winter jacketand about 3 hours for a parka.FashionTech has a monthly contract with its supplier to procure 4,000 feet of the required fabric. The amount ofmachine time allocated to producing the two products is 650 hours per month, and each month a number of skilledtailors are assigned to these products for approximately 900 hours. Historically, FashionTech has never sold more than400 jackets and 150 parkas in a month, and, therefore, the monthly production rate of parkas and winter jackets neednot be more than these historical limits. (1) Please create the spreadsheet and LP model for this case.(2) Optimize the model and share your results.