個案總覽

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.

The purpose of this note is to illustrate the use of Microsoft Excel functions for generating descriptive statistics for continuous data. These functions are common when analyzing data to provide insights for decision making. The note includes practice exercises and their solutions, and a supporting Excel workbook for students.

Student spreadsheet for case W16411.

Student spreadsheet for case W16413.

Student spreadsheet for case W16415.

Student spreadsheet for case W16417.

Student spreadsheet for case W16419.

In January 2016, the program director of Royal FloraHolland and a supply chain consultant met to develop a supply chain strategy that would allow Royal FloraHolland to adapt to the changing competitive environment that jeopardized its business model. Royal FloraHolland was the largest floriculture auction organization in the world, selling more than 30 million flowers and plants daily. Located in the Netherlands, Royal FloraHolland was a co-operative owned by 4,500 growers. A century-long tradition, where buyers purchased flowers and plants through the Dutch flower auction clock, was being threatened. Pressures facing Royal FloraHolland included emerging global competition, industry consolidation, and customers bypassing the auction process to buy directly from the growers. The two supply chain experts considered opportunities and challenges that lay ahead for the organization.

In response to a recommendation at a government-sponsored power forum, Delhi's aging and inefficient Rajghat Power House (RPH) was scheduled to close its doors. The coal-based plant had reached the end of its 25-year useful life, and its outdated equipment spewed toxins into Delhi's air and water on a daily basis. Environmentalist bodies and power-distributing units in Delhi had made similar recommendations for the RPH's closure over the years, and while the government had gone so far as to approve some of those plans, nothing had ever come of them. With the arrival of the forum's recommended date of October 2015 for the plant's closure, Delhi's government officials faced a difficult decision. Should they ignore the environmental degradation to achieve a high growth rate in the short run, or should they protect the environment to achieve a sustainable growth rate in the long run?

The Vibrance Kegel Device (VKD) was an intra-vaginal device that helped women correctly identify and strengthen their pelvic floor muscles to prevent and improve health issues related to urinary incontinence, back pain, and sexual dysfunction. The VKD was owned and marketed by Bioinfinity, a three-person, start-up company based in Malaysia. Despite being an innovative and award-winning product, its marketing strategy was challenging as its target market was Malaysian women, the majority of whom were conservative and uncomfortable with discussing these types of medical issues. As a result, educating women and developing product awareness had been a struggle. Bioinfinity's market development director needed to think of ways to grow the business. He was also contemplating whether the VKD was ready to compete in established markets such as Australia, the United States, and the United Kingdom.

Molly Langenstein, Macy's executive vice president for fashion and new business development, and members of Macy's senior team were rethinking the company's approach to serving millennial customers, customers born between the years of 1980 and 2000. To tackle this challenge, a dedicated Millennial team was created. The team looked at the preferences of millennial consumers and how those consumers were served by existing retailers. The team moved on to formulate a new market strategy. To date, the team has seen some improvements in sales and market share in its millennial apparel business, but they believe that additional opportunities exist. Was the Macy's millennium strategy working? What should they do next?

Me to We was a Canadian social enterprise created in 2008 to provide a stable source of funds to finance Free the Children, a non-profit organization that partnered with villages in Latin America, Africa, and Asia to provide clean water, sanitation, health care, food security, and alternative income in exchange for the commitment that all village children would attend school. The ultimate aim was to reduce child labour and exploitation, which was rooted in families who were living in poverty and unable to support themselves. In 2015, as Me to We continued to grow, the co-founders realized that its product portfolio could benefit from items that would increase the frequency of the organization's contact and interactions with customers. Should Me to We move towards the fast consumables market to reach as many people as possible?

In 2015, Burger King France operated 26 Burger King restaurants in France and had ambitious plans for growth. In a press release, Burger King France shareholders announced the projected acquisition of Quick, a chain of 509 fast-food restaurants operating in France and a few other countries. Burger King France intended to gradually convert the Quick restaurants into Burger King restaurants-a move that would turn Burger King into the second-largest fast-food chain in France. While this acquisition provided a significant growth option for the Burger King chain, it also posed several challenges in the form of brand image, company culture, and the many issues that could come with the process of converting and internationalizing a chain within its home country.

In June 2015, the Toyota Motor Corporation's annual shareholders' meeting included a proposal regarding Toyota's new share issue. Named "Model AA" shares after the company's first passenger car, the shares would offer investors new hybrid securities. This proposal created a lot of controversy among existing shareholders. Although President Toyoda claimed that no one would be disadvantaged by these shares, it remained unclear how many shareholders had confidence in this assurance. The share issue, which would potentially comprise up to 5 per cent of Toyota's total outstanding shares, would require the support of a two-thirds majority of shareholders. The new shares looked like ordinary shares with a "lock-up" period or preferred shares with voting rights. At the same time, Model AA shares resembled a convertible debt issue with voting rights (with a conversion ratio to be determined later). It was time to vote on the approval of Toyota's new share issue, but the following questions lingered in the shareholders' minds: what exactly was the difference between Model AA shares and ordinary shares? What was the difference between Model AA shares and bonds (or convertible bonds)? Finally, if the vote was approved, how should Model AA shares be priced?

By late 2015, the chief executive officer of Devonian Coast Wineries in the Canadian province of Nova Scotia had invested in the business and had broadened the distribution of the wines he produced. His chief concern was growing sales beyond Nova Scotia's provincial borders. Selling wines in other provinces was difficult because it required approaching the various provincial liquor control boards. He had three options: continue to engage with each provincial liquor board's buyers, lobby for greater retail access, or pursue the removal of provincial barriers to wine trade within the Atlantic provinces. If all interprovincial barriers were removed, he would need to compete with other provinces' larger wine producers, and they would likely gain market share at the expense of local wineries. What was the best strategy to expand Devonian Coast Wineries' distribution beyond Nova Scotia?

In July 2015, the chief executive officer of Toshiba Corporation (Toshiba) resigned over the revelation of a JPÂ¥151.8 billion accounting scandal that shocked the world. Toshiba, a Japanese multinational conglomerate with net sales of JPÂ¥6.5 trillion and total assets of JPÂ¥6.2 trillion, had been widely criticized in the news for the multi-billion-dollar accounting fraud. The company's stock prices declined by 38% after the accounting probe was announced, and the company withdrew the dividend that had been declared earlier. These setbacks challenged company investors, who had always regarded Toshiba as a reputable company. The investors were wondering the same thing as everyone else watching the scandal unfold: how could a company with a 140-year history do this, and why? What were the consequences? What should Toshiba do in response to this crisis?

In 2014, the chief executives officers of Amazon and Future Group led their companies into an alliance that, while initially successful, encountered some difficulties in regards to discounts on their retail products. With the global retail industry standing at US$25.4 trillion in 2016, and the percentage of which e-commerce made up 7.4 per cent, the partners would have to decide if they should resolve their conflict and remain allies, or if they should consider becoming independent companies again. If one partner placed a higher value on the use of discounts than the other, how much was the alliance really worth?