個案總覽

This very short and seemingly straightforward case is an efficient vehicle for exploring the nuances of hypothesis testing via regression modeling and t-tests in the context of an MBA or advanced undergraduate analytics course.

Spreadsheet for case UV6484.

Madison Kryswada, director of alumni relationships at State University, assembled a 125-school data set to explore, in her words, "the drivers of alumni giving rate." The alumni giving rate contributed 5% to the increasingly important U.S. News & World Report rankings of U.S. colleges and universities. Wanting to understand the relationship between this variable and school characteristics, Kryswada gave her assistant a list of four well-formed questions to answer.

Spreadsheet for case UV6394

Movie-industry analyst David Fitzhugh must estimate the value of the sequel rights associated with Chance Encounters (CE), a soon-to-be-produced movie. The producers of CE intend to use the cash from the sale of the sequel rights to help fund production of the original movie. With the purchase of the sequel rights to CE, the client intends to produce a sequel to CE--should the original movie prove successful.

Spreadsheet supplement to case UV6342.

Spreadsheet supplement for case UV6325.

These exercises, designed for use in a spreadsheet modeling pre-matriculation course, provide a baseline education in spreadsheet modeling and Microsoft Excel to incoming MBA students who have not had extensive modeling experience or exposure to Excel.

This case series is appropriate for undergraduate, MBA, executive education, and MBA Exec audiences but is specifically designed for decision analysis, a first-year MBA core course. In the Part I case, Osvaldo Correa, CEO of Salmones Puyuhuapi (SP), must decide how to respond to news that the ISA virus has infected a competitor's salmon farming site. The alternatives include harvesting SP's 900,000 salmon two months early, waiting for the fish to grow and risk losing fish to the virus, and vaccinating the fish. The "harvest now" alternative is evaluated using normally distributed fish weights. It is necessary to account for monthly growth of the fish and mortality to value the ends of the decision tree. Other alternatives, e.g. testing the water, fish, and marine life can be studied with the expected value of perfect information. Vaccination is an example of the value of perfect control.

This case describes an IQ experiment in which 66 students, under the direction of their professor, used Excel to generate simulated IQs. The instructions were such that the generated IQs should have come from a normal distribution with a mean of 100 and standard deviation of 15. The sample average IQ, however, was 104.3. Students are asked to use their data-analysis skills to make sense of the results. The data set also contains gender (male or female) and fall section (A, B, C, D, or E) for each student, which allow for additional statistical analyses (tests of equality of means).

This short case describes a famous experiment conducted by Sir Ronald A. Fisher and colleagues to test Dr. B. Muriel Bristol's claim that she could tell-only by tasting-whether milk or tea was poured first into her cup. Using hypothesis testing, students must answer the question of how many correct picks the lady tasting tea (LTT) must make in order to "prove" her claim.

This third and final part of the case about a Google AdWords campaign for Motorcowboy, an online source of custom footwear, delineated the Darden team's recommendations for future efforts.

This continuation of the case about a Google AdWords campaign for Motorcowboy, an online source of custom footwear, recounts the Darden team's revised approach.

As part of the Google Online Marketing Challenge, a team of Darden students devises an AdWords campaign for Motorcowboy, an online source of custom footwear that caters to segments as varied as motorcycle police, cross dressers, movie buffs, equestrians, and plus-size individuals. When an initial keyword list yields low traffic, the team must adapt its approach. This three-part case illustrates the segmentation process and the relative merits of paid search over traditional mass media outlets. It also serves to underscore the importance of monitoring and adapting any advertising plan.

Pfeifer's Fine Olive Oil was formulated and positioned to serve as a heart-healthy, but slightly more expensive substitute for butter and margarine in cooking. With a narrow target market and growing product offerings and market potential, it was particularly important for Pfeifer's Fine Olive Oil to get the most for its limited advertising budget. The range of possible media for advertising its line of products was daunting. Would a media planning model (optimizer) that required executive judgments on several key inputs be helpful?

This technical note accompanies the case/class on "The Lady Tasting Tea" (LTT). It describes how a Bayesian would update his or her prior probability for the probability the LTT can correctly distinguish cups of tea based on whether the milk was added first or last. The long-form note (UVA-QA-0769) describes both a discrete model (LTT has p of 0.5 or 0.8) and a more complicated continuous model (p is beta distributed). This abridged note describes only the discrete model. The case/class itself provides a very useful analogy with which students can explore the elements of statistical inference.

This technical note accompanies the case/class on "The Lady Tasting Tea" (LTT). It describes how a Bayesian would update his or her prior probability for the probability the LTT can correctly distinguish cups of tea based on whether the milk was added first or last. This long-form note describes both a discrete model (LTT has p of 0.5 or 0.8) and a more complicated continuous model (p is beta distributed). The abridged note (UVA-QA-0768) describes only the discrete model. The case/class itself provides a very useful analogy with which students can explore the elements of statistical inference.

This technical note introduces important metrics firms use to monitor customer relationships. An important summary of customer activity is the profit the firm receives from each customer. Customer profit (CP) is the metric that summarizes the past financial performance of a customer relationship and is covered in a companion note, ""Customer Profit"" (UVA-M-0799). The central difference between CP and customer lifetime value (CLV) is that CP measures the past and CLV looks forward. This note addresses the forward-looking metric that attempts to put a dollar value on a customer relationship. This technical note is an excerpt of the more comprehensive treatment of customer metrics found in "Customer Profitability" (UVA-M-0718).

This technical note introduces important metrics firms use to monitor customer relationships. The note begins by discussing how to count the firms' customers and keep track of their activity using the concepts of recency and retention. An important summary of customer activity is the profit the firm receives from each customer. Just as some brands are more profitable than others, so too are some customer relationships more profitable than others. Customer profit is the metric that summarizes the past financial performance of a customer relationship. A companion note, "Customer Lifetime Value" (UVA-M-0800), addresses the forward-looking metric that attempts to put a dollar value on a customer relationship. This technical note is an excerpt of the more comprehensive treatment of customer metrics found in "Customer Profitability" (UVA-M-0718).

This case is appropriate for undergraduate, MBA, and MBA Exec audiences but is specifically designed for Decision Analysis and Decision Analysis and Optimization, first-year MBA electives. It is related to but separable from "Salmones Puyuhuapi (A)" (UVA-QA-0749). That A case was about whether to harvest salmon early due to the threat of a virus, and it used a simple approximation for relating the value of a harvested salmon to its live weight. This production planning case addresses in detail how harvested salmon are processed and sold. Here, the plan Elisa Perez develops will determine how much value Salmones Puyuhuapi achieves from a day's harvest of salmon from one of the company's sites in southern Chile.