This case is based on a real-life consulting engagement with a major Fortune 100 telecommunications company. The name of the firm has been disguised for confidentiality reasons. Completing the case teaches students how to develop a cost-containment ROI analysis and develop a business case for a large enterprise technology project. The class discussion focuses on strategies to understand and manage the risks of the project and organizational issues. In addition, the case teaches students good questions to ask when reviewing a complex project business case, and how to present a project for funding approval. This case is the second in a series of three cases designed to teach students ROI analysis for technology projects; the first is "B&K Distributors: Calculating Return on Investment for a Web-Based Customer Portal" and the third is the case "ROI for a Customer Relationship Management Initiative at GST."

In this return on investment (ROI) for customer relationship management (CRM) case scenario, students must calculate the ROI for analytic CRM enabled by an enterprise data warehouse. The case is based upon a real-life consulting engagement with a major Fortune 100 telecommunications company. In this case the executive management team's strategic objective is to grow the customer base by 5 percent annually by customer acquisition. The internal rate of return calculated from the data given in the case is more than 800 percent for one year, and sensitivity analysis shows this is a robust projection, suggesting it should be funded without question. However, the strategy of the firm is customer acquisition in an environment of high customer churn. As a result of these dynamics, the revenues and net income of the firm are actually decreasing by hundreds of millions of dollars each year. A better solution would realize that the executive team has the incorrect strategic objective. Customer acquisition is the wrong approach in an environment of high customer churn and executives should focus on customer retention and cross-sell and up-sell to high-value customers. The case discussion therefore takes students beyond CRM ROI to focuses on the key strategic concepts of customer relationship management.

Technology projects are inherently risky; research shows that large IT projects succeed as originally planned only 28 percent of the time. Building flexibility, or real options, into a project can help manage this risk. Furthermore, the management flexibility of options has value, as the downside risk is reduced and the upside is increased. The case is based upon real options analysis for an enterprise data warehouse (EDW) and analytic customer relationship management (CRM) program at a major U.S. firm. The firm has been disguised as Global Airlines for confidentiality reasons. The data mart consolidation or EDW marginally meets the hurdle rate for the firm as analyzed using a traditional net present value (NPV) analysis. However, different tactical deployment strategies help mitigate the risk of the project by building options into the project, and the traditional NPV is expanded by the real option value. Students analyze the different deployment strategies using a binomial model compound option Excel macro, and calculate the volatility using Monte Carlo analysis in Excel. A step-by-step tutorial is provided to teach students how to accomplish the real options analysis for a simplified project, and this tutorial is easily generalized by students to the case scenario. In addition to the tactical options, the case also has the strategic growth option of analytic CRM. Students must therefore analyze both the tactical and strategic growth options and make a management recommendation on funding the project and also recommend an optimal deployment strategy to manage the project risk.