個案總覽

The case supplement focuses on the implementation of Netflix's global expansion in early 2016. As criticism of its strategy mounts, the company's share price declines and Netflix encounters problems with censorship and content laws in various countries. ln some locations, governments attempt to block the service. This is a supplement to 9B16M118.

Spreadsheet to accompany product 9B16E010.

Spreadsheet to accompany product 9B16E011.

Spreadsheet to accompany product 9B16E013.

Spreadsheet to accompany product 9B16E014.

Spreadsheet to accompany product 9B16E015.

Spreadsheet to accompany product 9B16E016.

Spreadsheet to accompany product 9B16E017.

Spreadsheet to accompany product 9B16E018.

Jade eServices Pvt. Limited (Jabong), an e-retailer of fashion products in India, regularly had to balance conflicting expectations from its supplier brands and consumers. The discounts that e-retailers had to offer to consumers to generate sufficient sales resulted in brand dilution, which compelled these brands to avoid the online channel. After allowing large discounts on Jabong's website for two years, Puma, a major international sports shoe brand, decided to stop discounting product lines that were contributing to 14 per cent of Jabong's footwear sales. Puma products helped to attract new customers, and Puma's decision had the potential to affect the commercial terms offered by other footwear brands, which would have even more impact on Jabong. Jabong's director of sports apparel knew that he was unlikely to meet the required growth figures without discounts on Puma's products. He needed a new strategy to compensate for Puma's withdrawal of discounting options, and he needed it immediately.

In 2015, many people in southwest Sri Lanka were experiencing severe health problems as a result of poor water sanitation, decaying pumps and pipes, and the resultant unsanitary water. With Sri Lanka's dubious credit record and extremely poor economy, the country's government was unsure of how to raise the US$70 million that was required to build new sanitation plants and replace many aging pipes throughout the region. Would it have to accept the first offer of support or would its long-time allies from other foreign governments come to the rescue? There was little doubt that Sri Lanka would be faced with a number of caveats and conditions as part of any agreement to secure the necessary funding. Furthermore, even if the country could find the funds, would the designated officials use them appropriately without falling prey to corruption? As in any developing country, there were many concerns that needed to be addressed, and very few resources with which to address them.

The purpose of this note is to introduce students to the basic use and vocabulary of Microsoft Excel. Excel is commonly used to do quantitative analysis in business. Students will encounter Excel applications in just about every area of business, including finance, accounting, operations management, marketing, and analytics.

This teaching note provides step-by-step illustrations and practice problems to assist students in learning how to use basic mathematical functions in Microsoft Excel. These functions are the necessary building blocks for many spreadsheet models. This teaching note includes practice exercises, answers, and a supporting Excel workbook for students.

Student spreadsheet for case W16405.

The purpose of this note is to illustrate how to use cell references in Microsoft Excel. References are necessary when using functions and building models. This teaching note provides students with practice exercises and a supporting Excel workbook.

The purpose of this note is to illustrate the use of good modeling practices in Microsoft Excel. An effective spreadsheet model can be a valuable decision-making tool for businesses wanting to improve or expand their operations. To do so, a model must provide information relevant to the decision maker.

The purpose of this note is to introduce the concept of logical statements in Microsoft Excel and to illustrate the use of Excel's built-in logic functions. The note includes practice exercises and their solutions, and a supporting Excel workbook for students.

Student spreadsheet for case W16409.

The purpose of this technical note is to introduce and illustrate the use of Microsoft Excel's built-in advanced logic functions. Excel's advanced logic functions add logical capabilities to normal descriptive statistics functions. The note includes practice exercises and their solutions, and a supporting Excel workbook for students.

Student spreadsheet for case W16406.