Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting Information For Decisions

Authors: John J. Wild

10th Edition

1260705587, 978-1260705584

More Books

Students also viewed these Accounting questions