should be solved in excel please

Q5. (20 points) Fatagonia Jeans is setting up a production schedule for the coming week. Fatagonia can make four jean products: men's and women's jackets and pants. Although it can make different sizes of each, the variation in material usage and labor between sizes is negligible. Each jacket and pair of pants goes through cutting and stitching operations before being boxed, The following table gives the profit, denim, cutting time, stitching time, and boxing time required per 100 items, as well as the total resource availabilities during the week. Profit Cutting hr Item Men's jackets Women's jackets Denim (yd) 150 125 Stitching Boxing (hr) (hr) 4,0 75 3.0 25 3 $2,000 $2800 1 Mes's pants Women's pants $1.200 $1.500 200 150 2 2 36 20 25 360 so 50 8 Available of this 2500 Required: Solve this LP model by using Excel and computer a Develop and solve a linear programming model for Fatagonia Jeans which will maximize its profit for the weck b. Suppose that, in addition to the existing restrictions, management wishes to produce at least 500 of each item. Add these constraints to your linear program and re-solve the problem. What is the result? To what do you attribute this result? c. Suppose the minimum production for each item is 300. What is the optimal solution? d. Suppose a constraint was added that requires at least 50% of the items manufactured to be women's items. How would this affect the optimal solution? Suppose instead that the added constraint requires that at least 50% of the items manufactured are men's items. How would this affect the optimal solution? Q5. (20 points) Fatagonia Jeans is setting up a production schedule for the coming week. Fatagonia can make four jean products: men's and women's jackets and pants. Although it can make different sizes of each, the variation in material usage and labor between sizes is negligible. Each jacket and pair of pants goes through cutting and stitching operations before being boxed, The following table gives the profit, denim, cutting time, stitching time, and boxing time required per 100 items, as well as the total resource availabilities during the week. Profit Cutting hr Item Men's jackets Women's jackets Denim (yd) 150 125 Stitching Boxing (hr) (hr) 4,0 75 3.0 25 3 $2,000 $2800 1 Mes's pants Women's pants $1.200 $1.500 200 150 2 2 36 20 25 360 so 50 8 Available of this 2500 Required: Solve this LP model by using Excel and computer a Develop and solve a linear programming model for Fatagonia Jeans which will maximize its profit for the weck b. Suppose that, in addition to the existing restrictions, management wishes to produce at least 500 of each item. Add these constraints to your linear program and re-solve the problem. What is the result? To what do you attribute this result? c. Suppose the minimum production for each item is 300. What is the optimal solution? d. Suppose a constraint was added that requires at least 50% of the items manufactured to be women's items. How would this affect the optimal solution? Suppose instead that the added constraint requires that at least 50% of the items manufactured are men's items. How would this affect the optimal solution