Open Design Cases and Exercises

1 The realisation area (shaded) 212

1.1 What's Best! toolbar 218

1.2 The standard LP form represented in Excel with What's Best! 219

1.3 Two house types 220

1.4 Screenshot solved model (project developer's problem) 222

1.5 Screenshot solved model (municipality's problem) 224

1.6 Screenshot solved model (facility manager's problem) 226

1.7 Four house types 227

1.8 Screenshot solved model (maximising the number of affordable houses) 230

1.9 Screenshot solved model (maximising the project developer's fee) 230

2.1 Monte Carlo simulation for a real estate investment 232

2.2 Output illustration of Monte Carlo simulation 235

2.3 Output illustration of Monte Carlo simulation project A 237

2.4 Output illustration of Monte Carlo simulation project B 237

2.5 Portfolio characteristics 241

2.6 Output of Monte Carlo simulation on portfolio, before adding new project 242

2.7 Output of Monte Carlo simulation on portfolio, after adding new project 243

3.1 Example GANTT chart 245

3.2 Example CPM 246

3.3 Illustration of part of a construction planning 247

3.4 Defining 'Adjustable' cells 248

3.5 Defining 'Best' cell 248

3.6 Defining 'Constraints' 249

3.7 Screenshot of solved model 250

3.8 Beta probability distribution with three estimates 250

3.9 Network planning of Lanza example 254

3.10 Output of Monte Carlo simulation (Lanza example): probability distribution of total project duration for Path 1 255

3.11 Output of Monte Carlo simulation (Lanza example): probability distribution of total project duration for Path 2 256

3.12 Output of Monte Carlo simulation (Lanza example): probability distribution of total project duration and frequencies of occurrence in the simulation of primary and secondary paths 257

3.13 GANTT chart of construction industry example 257

3.14 Network planning of construction industry example 257

3.15 Output of Monte Carlo simulation (construction industry example) 258

3.16 Output graph showing which activities needed corrective measures most frequently 260

4.1 Graph showing all data points 265

4.2 Graph showing a line that fits the data points 265

4.3 The three deviations associated with a data point (Source: Aczel (2002)) 266

4.4 Coefficients of determination in different regressions (Source: Aczel

4.5 Data from database in spreadsheet 268

4.6 Graph showing a line that fits the data points 269

4.7 Add-Ins dialog 269

4.8 Regression option 269

4.9 Single regression analysis output in spreadsheet 270

4.10 Actual cost prices (left columns) compared to estimated cost prices (right columns) 271

4.11 Data from database in spreadsheet 274

4.12 Multiple regression analysis output in spreadsheet 275

4.13 Multiple regression analysis output in spreadsheet 276

4.14 Optimistic, pessimistic estimates for Monte Carlo simulation related to standard deviation from regression analysis 277

5.1 Normal distribution: Number of competitors and scores 286

5.2 Normal distribution: Number of competitors and scores 286

5.3 Example of relevance scaling 287

6.1 Model structure after adding restrictions 290

6.2 Screenshot solved model (project developer's problem using stakeholder's weight factors) 291

7.1 The price a decision maker is prepared to pay for a location at some distance from a noisy factory follows an exponential curve 294

8.1 Urban area 303

8.2 Division into zones 305

8.3 The Urban Decision Room 307

9.1 The position of the dwellings in the building complex 314

10.1 Return-risk profile without lift 323

10.2 Return-risk profile with lift 323

13.1 Location of military airbase 'Valkenburg' 338

13.2 Preference scaling according criterion 'Security of VIPs' 341

14.1 Average flying cost per flight movement as a function of occupancy of the airbase 345

14.2 Preference for maintaining the airbase depends on its occupancy 347

14.3 Average flying cost per flight movement, preference value for nature and overall preference as a function of airbase occupancy 347

16.1 Screenshot solved model (national airport) 360

16.2 Screenshot solved model (European airport) 360

17.1 Stedelijk Museum, Amsterdam 364

17.2 Screenshot of output of LP-model minimising cost 365

17.3 Ground floor existing building with roomnumbers 366

17.4 Ground floor of existing building showing allocated functions 366

Real Estate Essentials

Real Estate Essentials

Tap into the secrets of the top investors… Discover The Untold Real Estate Investing Secrets Used By The World’s Top Millionaires To Generate Massive Amounts Of Passive Incomes To Feed Their Families For Decades! Finally You Can Fully Equip Yourself With These “Must Have” Investing Tools For Creating Financial Freedom And Living A Life Of Luxury!

Get My Free Ebook


Post a comment