help answer a,b,c

Problem 1 The Gutchi Company manufactures purses, shaving bags, and backpacks. The construction includes leather and synthetics, leather being the scarce raw material. The production process requires two types of skilled labor: sewing and finishing. The following table gives the availability of the resources, their usage by the three products, and the profits per unit. a) Define the variables, constraints, and objective function, and formulate the problem as a linear program and find the optimal solution using Excel solver. b) Perform sensitivity analysis in excel. c) For the cases where feasibility is maintained, determine the new optimal solution (values of the variables and the objective function). (i) Available leather is increased to 45ft2. (ii) Available sewing hours is changed to 38 hours