please use excel if you can to solve this problem.

1. A certain company produces clothing, footwear, and accessories for dancing and gymnastics. They produce three models of pointe shoes used by ballerinas to balance on the tips of their toes. The shoes are produced from four materials: cardstock, satin, plain fabric, and leather The number of square inches of each type of material used in each model of shoe, the amount of material available, and the profit/model are shown. (20-points) Material Model1 Model2 Model3 Material Available Cardstock 12 10 13 1,100 Satin 22 20 21 2,000 Plain Fabric 6,500 Leather 10 1,000 Profit per model $50 $44 $39 30 40 13 40 13 Questions a Provide an LP formulation that will yield the maximum profit from each type of shoe - Do not forget the non-negativity constraints b. Using Excel, solve part (a) using linear optimization o What is the maximum profit? o How many of model 1, 2 and 3 shoes to produce? o Which constraints are binding? Which ones are not? o Find the slack for non-binding constraints