PLEASE ONLY USE EXCEL SOLVER AND I WANT TO INTEGER PROGRAMMING SOLUTION AND I WANT TO EXPLAIN STEP BY STEP WITH PHOTOS!

Ecoblem (9.50-1*52-42ed- Simon's Mall has 10,000 sq ft of space to rent and wants to determine the types of stores that should occupy the mall. The minimum and maximum number of each type is given in the first table along with the square footage of each type. The annual profit made by each type of store will depend on how many stores of that type are in the mall. This dependence is found in the second table in $10,000). For example, if there are two department stores in the mall, each department store earns $210,000 profit per year. Each store pays 5% of its annual profit as rent to Simon's. Formulate an IP whose solution will tell Simon's how to maximize its rental income. Store Type Sqr. Footage Minimum Maximum Jewelry 500 1 3 Shoe 600 1 3 Department 1500 1 3 Book 700 0 3 900 Clothing 1 3 Store Type 1 store 2 stores 3 stores Jewelry 9 8 7 10 Shoe 9 5 27 21 Department 20 Book 16 9 7 Clothing 17 13 10