Question: Thanks for the help A real estate developer is planning to build an office complex. Currently, there are three office sizes under consideration: small, medium,

Thanks for the help A real estate developer is

Thanks for the help A real estate developer is

Thanks for the help

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 $600 per month, medium offices can be rented for $750 per month, and large offices can be rented for $1000 per month. Each small office requires 600 square feet, each medium office requires 800 square feet, and each large office requires 1000 square feet. The current plot of land available to the developer is 100,000 square feet. The developer wants to ensure that the office complex has at least 3 units of each office size. Moreover, zoning restrictions limit the total number of offices to 50. Use the Sensitivity Report to answer the following questions: Sensitivity Report Adjustable Cells Cell $B$4 Final Value 3 Reduced Cost 0 Objective Coefficient 600 Allowable Increase 400 Allowable Decrease 1E+30 Name Optimal Values Small Optimal Values Medium Optimal Values Large 3 0 750 $C$4 $D$4 250 1E+30 1E+30 250 44 0 1000 Constraints Shadow Price Final Value 48200 3 Constraint R.H. Side 100000 3 Allowable Increase 1E+30 41 Allowable Decrease 51800 3 0 -400 Cell Name $E$8 Square footage $E$9 Minimum no. of small Minimum no. of $E$10 medium $E$11 Minimum no. of large $E$12 Total no. of offices -250 3 3 3 44 0 3 41 41 51.8 1E+30 41 50 1000 50 A. 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 non-binding? d. How much square footage would remain unused if the developer implements the optimal solution

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!