Based on Bean et al XXXXXXXXXXSimon’s Mall has 10,000 square feet of space to rent and wants to determine the types of stores that should occupy the mall. The minimum number and maximum number of each...

Based on Bean et al. (1988). Simon’s Mall has 10,000 square feet of space to rent and wants to determine the types of stores that should occupy the mall. The minimum number and maximum number of each type of store (along with the square footage of each type) are given in the file P06_74.xlsx. The annual profit made by each type of store depends on how many stores of that type are in the mall. This dependence is also given in the file P06_74.xlsx (where all profits are in units of $10,000). For example, if two department stores are in the mall, each department store will earn $210,000 profit per year. Each store pays 5% of its annual profit as rent to Simon’s. Determine how Simon can maximize its rental income from the mall.