please help!! .

Aa. 21 AaBbcd AaBbcc AaBbc AaBbcc Aa Normal T No Spac... Heading 1 Heading 2 Tit Paragraph Styles 5 6 A real estate developer is planning to build an office complex Currently, there are three office sizes under consideration small, medium and large Small offices can be rented for $500 per month, medium offices can be rented for $650 per mouth, and large offices can be rented for $900 per mooth. Each small office requires 600 square feet, each medium office requires 750 square feet, and each large office requires 1000 suare feet. The current plot of land available to the developer is 90,000 square feet. The developer wants to ensure that the office complex bas at least 2 units of each office size. Moreover, zoning restrictions limit the total number of offices to 60. Provide LP model solve using Excel Solver and answer the questions below: For LP Model Let XI - no. of small offices to build X2 - no. of medium offices to build X3 = no. of large offices to build 1. a. How many small, medium and large offices should the developer build? b. What is the total optimal monthly revenue? c. Which constraints are binding? Which constraints are nors binding? d. How much square footage would remain used if the developer implements the optimal solution? 2. a. What would be the impact on the optimal allocation of offices and the objective function value if small offices can be Texted for $800 per month rather than $600 per month? b. What would be the impact on the optimal allocation of offices and the objective function value if medium offices can be rented for $650 per month rather than $750 per month? c. What would be the impact on the optimal allocation of offices if medium offices can be rented for $1100.00 rather than $750 per month d. Is the solution to the problem unique or are there alternate optimal solutions? 3. a. Suppose that the square footage available to the developer increases to 110,000 square feet. What impact would this have on the optimal objective function value? b. Suppose that the minimal number of small officers that the developer needs to build must be at least 5 offices. What impact would this have on the optimal objective function value? c. Suppose that the monthly rental of small offices increases to 5650, and that the monthly rental of medium offices increases to $800. What impact will this have on the current optimal solution and the objective function value? d. Suppose that the total number of offices increases to a maximum of 35, and the minimum number of medium offices increases to 5. What impact would this bare on the current optimal objective function value? O DLL