• DIY CAMBRIDGE ANALYTICA: RUNNING PERSONALITY ANALYTICS

    The case walks the readers first through the Cambridge Analytica scandal, eliciting its effect and presenting an overview of the analysis the infamous company did. Readers are then introduced with simple steps on how a similar approach may be used today - running surveys on inconspicuous questions very affordably and quickly, and creating simple analytical models (linear and logistic) to infer respondents' age and gender. The raw survey data is available upon request to the co-authors.
    詳細資料
  • What Managers Need to Know About Data Exchanges

    Data exchanges platforms where individuals and organizations voluntarily share data enable third parties to gain insights they couldn't otherwise access, with downstream benefits for consumers. To enhance and capitalize on the value generated, managers must become familiar with the unique features of data as a factor of production.
    詳細資料
  • Closing Time

    Jennifer McDougall is considering investing in mutual funds for the first time, and has narrowed her options down to three: one that is domiciled in Germany, and two that are domiciled in Luxembourg. As a cautious and risk-averse investor, Jennifer has done extensive research on the three funds, and has come across a curious fact: the beta of the German fund is surprisingly low. After speaking to her financial planner, she learns there is no legal requirement in Germany for mutual funds to compute net asset values at a particular time of the day. If the German fund is closing its books in the middle of the day and its net asset values reflect its midday holdings, rather than end-of-day holdings, this could explain the low beta. Thus, the German fund might appear less risky, without actually being so. Jennifer needed to get a clearer picture of what was going on before making her decision. Using the data provided with the case, students will determine the closing time of the three funds and how that affects the beta of each. Then they must make a recommendation about which fund would be the best investment for Jennifer.
    詳細資料
  • Closing Time, Student Spreadsheet

    Student spreadsheet for case KE1020.
    詳細資料
  • Solid as Steel: Production Planning at thyssenkrupp

    thyssenkrupp Steel Europe, a major European steel company, operates a so-called push-pickling line (PPL) in Bochum, Germany. The PPL produces a particular type of steel strips that are sold to B2B customers, mainly in the automotive industry. In spring 2014, a senior vice president of thyssenkrupp Steel's production operations and one of his production managers notice that over the span of ten years the production facility regularly did not meet its planned production volumes. They set out to determine the drivers for the deviations from planned production figures with the ultimate goal to improve the production planning process at the Bochum PPL. Students will step into the shoes of Markus Schulze-a production manager at thyssenkrupp Steel-as he searches for performance drivers at the Bochum PPL and analyzes recent production data to build a forecasting model for production planning.
    詳細資料
  • Solid as Steel: Production Planning at thyssenkrupp, Student Spreadsheet

    Student spreadsheet for case KEL942.
    詳細資料
  • Spreadsheet: Germany's Bundesliga: Does Money Score Goals? Data

    Spreadsheet Supplement for KEL754
    詳細資料
  • Germany's Bundesliga: Does Money Score Goals?

    During one of the most nerve-wracking football matches of the 2012-2013 Bundesliga season, life-long friends Franz Dully and Max Vogel begin arguing about whether the wealth of a football club determines its success during the season. In order to disprove Vogel's claim that "money scores goals," Dully must analyze the Bundesliga's current market values, points earned, and mid-season leader data.
    詳細資料
  • Arbor City Community Foundation (A): The Foundation

    The Arbor City Community Foundation (ACCF) was a medium-sized endowment established in Illinois in the late 1970s through the hard work of several local families. The vision of the ACCF was to be a comprehensive center for philanthropy in the greater Arbor City region. ACCF had a fund balance (known collectively as "the fund") of just under $240 million. The ACCF board of trustees had appointed a committee to oversee investment decisions relating to the foundation assets. The investment committee, under the guidance of the board, pursued an active risk-management policy for the fund. The committee members were primarily concerned with the volatility and distribution of portfolio returns. They relied on the value-at-risk (VaR) methodology as a measurement of the risk of both short- and mid-term investment losses. The questions in Part (A) of the case direct the students to analyze the risk inherent in both one particular asset and the entire ACCF portfolio. For this analysis the students need to calculate daily VaR and monthly VaR values and interpret these figures in the context of ACCF's risk management. In Part (B) the foundation receives a major donation. As a result, the risk inherent in its portfolio changes considerably. The students are asked to evaluate the risk of the fund's new portfolio and to perform a portfolio rebalancing analysis.
    詳細資料
  • Arbor City Community Foundation: Executive Education Version

    The Arbor City Community Foundation (ACCF) was a medium-sized endowment established in Illinois in the late 1970s through the hard work of several local families. The vision of the ACCF was to be a comprehensive center for philanthropy in the greater Arbor City region. ACCF had a fund balance (known collectively as "the fund") of just under $240 million. The ACCF board of trustees had appointed a committee to oversee investment decisions relating to the foundation assets. The investment committee, under the guidance of the board, pursued an active risk-management policy for the fund. The committee members were primarily concerned with the volatility and distribution of portfolio returns. They relied on the value-at-risk (VaR) methodology as a measurement of the risk of both short- and mid-term investment losses. In its report for the investment committee, the ACCF risk analytics team recommended the daily VaR at 95% confidence as a measure for short-term risk and reported the corresponding numbers. It is now the task of the investment committee to interpret these figures. The case questions guide the executive students to a critical evaluation of both the reported VaR figures as well as of the VaR methodology.
    詳細資料
  • Arbor City Community Foundation (B): Managing Good Fortune

    The Arbor City Community Foundation (ACCF) was a medium-sized endowment established in Illinois in the late 1970s through the hard work of several local families. The vision of the ACCF was to be a comprehensive center for philanthropy in the greater Arbor City region. ACCF had a fund balance (known collectively as "the fund") of just under $240 million. The ACCF board of trustees had appointed a committee to oversee investment decisions relating to the foundation assets. The investment committee, under the guidance of the board, pursued an active risk-management policy for the fund. The committee members were primarily concerned with the volatility and distribution of portfolio returns. They relied on the value-at-risk (VaR) methodology as a measurement of the risk of both short- and mid-term investment losses. The questions in Part (A) of the case direct the students to analyze the risk inherent in both one particular asset and the entire ACCF portfolio. For this analysis the students need to calculate daily VaR and monthly VaR values and interpret these figures in the context of ACCF's risk management. In Part (B) the foundation receives a major donation. As a result, the risk inherent in its portfolio changes considerably. The students are asked to evaluate the risk of the fund's new portfolio and to perform a portfolio rebalancing analysis.
    詳細資料
  • Hollywood Rules

    Wall Street hedge fund manager Kim Meyer is considering investing in an SFA (slate financing arrangement) in Hollywood. Dave Griffith, a Hollywood producer, is pitching for the investment and has conducted a broad analysis of recent movie data to determine the important drivers of a movie's success. In order to convince Meyer to invest in an SFA, Griffith must anticipate possible questions to maximize his persuasiveness.
    詳細資料
  • Spreadsheet: Hollywood Rules

    Spreadsheet Supplement for Product #KEL700
    詳細資料
  • Milk and Money Data Spreadsheet, Spreadsheet Supplement

    The financial success of dairy farms depends critically on the price of their main output, milk. Large volatility in the price of milk poses a considerable business risk to dairy farms. This is particularly true for family-run dairy farms. The question then arises: how can a farm owner hedge the milk price risk? The standard approach to establish a price floor for a commodity such as milk is to purchase put options on commodity futures. At the Chicago Mercantile Exchange, farmers can buy put options on the price of a variety of milk products. However, the price a farm receives for its milk depends on many factors and is unique to the farm. Thus, a farmer cannot directly buy put options on the price he receives for the milk his farm produces. Instead the farmer needs to determine which of the options available for trade at the Chicago Mercantile Exchange offer the best hedge for his own milk price. The assignment in this case is to examine historical data on several prices of milk products and the milk price received by a family-run dairy farm in California. Students need to find the price that is most closely correlated to the farm's milk price and to then choose options with the appropriate strike price that serve as the best hedge for the farm's price risk.
    詳細資料
  • Spiegel Online Budget, Student Spreadsheet

    Student spreadsheet for case KEL330.
    詳細資料
  • Milk and Money

    The financial success of dairy farms depends critically on the price of their main output, milk. Large volatility in the price of milk poses a considerable business risk to dairy farms. This is particularly true for family-run dairy farms. The question then arises: how can a farm owner hedge the milk price risk? The standard approach to establish a price floor for a commodity such as milk is to purchase put options on commodity futures. At the Chicago Mercantile Exchange, farmers can buy put options on the price of a variety of milk products. However, the price a farm receives for its milk depends on many factors and is unique to the farm. Thus, a farmer cannot directly buy put options on the price he receives for the milk his farm produces. Instead the farmer needs to determine which of the options available for trade at the Chicago Mercantile Exchange offer the best hedge for his own milk price. The assignment in this case is to examine historical data on several prices of milk products and the milk price received by a family-run dairy farm in California. Students need to find the price that is most closely correlated to the farm's milk price and to then choose options with the appropriate strike price that serve as the best hedge for the farm's price risk.
    詳細資料
  • Spiegel Online

    Spiegel Online (www.spiegel.de) is the leading news Web site in Germany. The site was first designed to accompany Der Spiegel, one of Europe's largest and Germany's most influential weekly magazine, which has a weekly circulation of around one million. The site's content is produced by a team of more than fifty journalists writing in several categories: politics, business, networld, panorama, arts and entertainment, science, university, school, sports, travel, weather, and automobiles. The original content is complemented by articles purchased from news agencies and selected articles from the print edition. Spiegel-Verlag is a major contributor to the Hamburg Media School, which offers professional master's degree programs in Media Management (MBA), film, and journalism. In their second year, MBA students typically engage in consulting projects with major media companies. In a recent assignment, Spiegel Online posed two questions to the MBA team: are there any chances for an economically successful entry into the market for interactive classifieds? And if so, what should the business model look like in detail? A student team analyzed markets for classified ads and found one market segment that appeared to be particularly promising: the market for art objects. During the development of a business plan for a new venture in this market it became apparent that there is much uncertainty about the key input parameters to the business plan. As a result, it is very difficult to assess the viability of the business idea. How can the team properly account for the uncertain input parameters? What is the impact of this uncertainty on the bottom line? Will a Web site for art objects earn or lose money? How can the team communicate this uncertainty to a group of high-level decision makers who want a simple "go or no-go" recommendation?
    詳細資料
  • Pedigree vs. Grit: Predicting Mutual Fund Manager Performance

    An asset management company must replace the manager of its two signature mutual funds, who is about to retire. Two candidates have been short-listed. The management team is divided and cannot decide which of the two candidates would make the better mutual fund manager. The retiring manager presents a linear regression model to examine success factors of mutual fund managers. This linear regression is the starting point for the subsequent analysis.
    詳細資料
  • Pedigree vs. Grit: Predicting Mutual Fund Manager Performance Data Spreadsheet, Spreadsheet Supplement

    An asset management company must replace the manager of its two signature mutual funds, who is about to retire. Two candidates have been short-listed. The management team is divided and cannot decide which of the two candidates would make the better mutual fund manager. The retiring manager presents a linear regression model to examine success factors of mutual fund managers. This linear regression is the starting point for the subsequent analysis.
    詳細資料
  • Fueling Sales at EuroPet Data Spreadsheet, Spreadsheet Supplement

    EuroPet S.A. was a multinational company operating gas stations in many European countries. There was a growing propensity for supermarkets to attach gas stations to their retail operations, which was developing into a major threat to EuroPet. As a result, in the mid-1990s, the company began to develop and brand its own convenience stores co-located with its gas stations. However, the company was spending much more on advertising the convenience stores than its competitors did. Management now had to decide if the increase in sales attributed to advertising efforts justified the advertising spend by analyzing the market data from one large metropolitan area: Marseille, France.
    詳細資料