How to use the solver in excel to solve this problem?

Product Mix Problem - Shoestore Problem Description O What we have We have four products: Flats ($20 profit) Heels ($30 profit Wedges ($25 profit) Sandals ($5 profit) We have 1500 square feet of leather We have 500 lbs. of rubber We have 200 lbs. of cork O O . O What we know Flats require o 2 square feet of leather Heels require 2.8 square feet of leather 1.2 lbs. of cork Wedges require 1.2 square feet of leather 2 lbs. of cork Sandals Require 0.8 square feet of Leather 1.5 lbs of rubber You must make at least 10 of each. You must make 2 flats for each set of heels. O O Find out How many each type of shoes do we make? What happens when our constraints change? What happens if the objective function coefficient changes