Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Sources of Cell Values Orange INPUTS Sheet Red Scenarios/Changes Blue: Copy from Base (Column) Yellow from BldgEnv White: Calculated Building Envelope EREP Quiz 2(b) Part
Sources of Cell Values | Orange INPUTS Sheet | |||||||
Red Scenarios/Changes | ||||||||
Blue: Copy from Base (Column) | ||||||||
Yellow from BldgEnv | ||||||||
White: Calculated | ||||||||
Building Envelope | ||||||||
EREP Quiz 2(b) Part 1 | Change the # Stories, Efficiency, Parking Index, SF/Stall & parking floors | |||||||
Input Parameters | Base Case | Option 1 | Option 2 | Option 3 | Option 4 | Option 5 | ||
Gross Site Area | 51,000 | 51,000 | 51,000 | 51,000 | 51,000 | 51,000 | ||
Lot Coverage Ratio | 85% | 85% | 85% | 85% | 85% | 85% | ||
FAR Maximum | 3.0 | 3.0 | 3.0 | 3.0 | 3.0 | 3.0 | ||
Building Design | ||||||||
Building Stories | 5 | 1 | 5 | 5 | 5 | 5 | ||
Efficiency %(Rentable) | 88% | 88% | 100% | 88% | 88% | 88% | ||
Revenue Unit Size (SF) | 1 | 1 | 1 | 1 | 1 | 1 | ||
Parking | ||||||||
Index (Spaces/1,000sf) | 4.0 | 4.0 | 4.0 | 4.0 | 4.0 | 4.0 | ||
SF/Stall | 320 | 320 | 320 | 320 | 1 | 320 | ||
Parking Floors | 1 | 1 | 1 | 1 | 1 | 4 | ||
Building Envelope Components | ||||||||
Square Footage | Base Case | Option 1 | Option 2 | Option 3 | Option 4 | Option 5 | ||
Building | 29,291 | 19,013 | 29,291 | 29,291 | 153,000 | 83,365 | ||
Parking | 37,492 | 24,337 | 37,492 | 37,492 | 612 | 106,708 | ||
Open Space | 7,650 | 7,650 | 7,650 | 7,650 | 7,650 | 7,650 | ||
Site AllocationTest | ||||||||
Square Footage | ||||||||
Building Footprint (SF) | 5,858 | 19,013 | 5,858 | 5,858 | 30,600 | 16,673 | ||
Parking Footprint | 37,492 | 24,337 | 37,492 | 37,492 | 612 | 26,677 | ||
Open Space | 7,650 | 7,650 | 7,650 | 7,650 | 7,650 | 7,650 | ||
Total Site | 51,000 | 51,000 | 51,000 | 51,000 | 38,862 | 51,000 | ||
Building Envelope Comparisons | ||||||||
No. of Parking Stalls | 117 | 76 | 117 | 117 | 612 | 333 | ||
Building | 100% | 65% | 100% | 100% | 522% | 285% | ||
No. of Parking Stalls | 0% | -35% | 0% | 0% | 422% | 185% | ||
Answer this question, including an analysis of the impact that was made on the numbers with the checkmark next to it. | What did you learn from the Sensitivity Analysis? | |||||||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started