個案總覽

Spreadsheet (B) for product 9B11M117.

Spreadsheet for product 8B13D022.

Spreadsheet Supplement for Product #914541.

In January 2013, John C. Liu, New York City's comptroller, wrote to the residents of the city about his audit of the New York City Department of Parks and Recreation (DPR). Liu summarized his office's findings: "The audit found that DPR was not carrying out and overseeing capital construction projects in a timely and cost effective manner." To investigate the existence of the "planning fallacy" in organizations, information from nearly 1,800 capital projects undertaken between 1998 and 2008 was obtained from the office of the chief engineer of the New York City DPR. In light of the data, how severe was the planning fallacy during this time and could it be used for overcoming the planning fallacy?

Supplement to case CU125.

Instructor spreadsheet for product 8B14A028.

Spreadsheet Supplement for product UV6790.

Excel spreadsheet.

Excel spreadsheet for 9B10E017 and 9B10E018.

Spreadsheet Supplement for Product #914533

Excel spreadsheet for instructors.

Instructor Excel spreadsheet for product 8B13D019.

Student Excel spreadsheet for product 9B13D019.

Excel spreadsheet for students.

Student spreadsheet for product W13556.

Student spreadsheet supplement to case W13569

Spreadsheet Supplement for Product #914537

Spreadsheet Supplement for Product #914509.

This case, follows Ali Hurbas's efforts to use data extracted from the Dunia data warehouse to establish potential customers' customer lifetime value (CLV). Hurbas plans to use a spreadsheet model to evaluate Dunia's various cross-selling activities and their effectiveness in creating the greatest CLV. First, students should explain how the spreadsheet reflects the way in which Dunia makes money from cross-selling. Then students should use the spreadsheet to conduct what-if analysis to see how combinations of activities might improve total CLV, and sensitivity analysis to understand how cost parameters and other parameters would affect profitability. A teaching note for this case series is available to instructors to aid in class preparation.

Instructor spreadsheet for product 8B13N026.