個案總覽

Student Spreadsheet to accompany product W34028.

Instructor Spreadsheet to accompany product W34029.

James Waite, the manager at Western Film, must decide which film to screen at his cinema in the upcoming week. He must evaluate whether to continue showing Spider-Man: Far From Home (Spider-Man), or replace it with one of three other films available for him to screen. Western Film, a second-run theatre, has the advantage of having domestic box office information available, and Waite must analyze whether this information is helpful to him in making this decision.

Mike Cassidy owned Maritime Bus, which provided an essential service built on efficient and effective travel and terminal-to-terminal package delivery in the Maritime provinces of Prince Edward Island (PEI), New Brunswick (NB), and Nova Scotia (NS). Headquartered in Charlottetown, PEI, the Maritime Bus company was part of the Cassidy Group, which employed over 500 people, including Cassidy’s wife and three sons, and served over 80 per cent of the busing needs of the region. The company had experienced historic profits in 2018 and finally broke even in 2019; 2020 was supposed to be its first profitable year. However, the COVID-19 pandemic brought instability to the industry, and ridership shrunk to nearly zero. By December 31, 2020, Cassidy had covered over $2.2 million in business losses with personal retirement savings. Despite the large personal financial cost, he was determined not to let COVID-19 destroy his company’s legacy. Canadian intercity busing was historically regional, and many prominent companies had failed without federal or provincial government bailouts. Facing surmounting financial pressures and lacking ridership as the company entered the 2021 season, Cassidy had to plan for the venture’s survival.

Student Spreadsheet to accompany product W33716.

In March 2023, two strawberry producers in Ontario, Canada had to decide how many acres to plant with each of four strawberry varieties at Xanadu Farms. They had committed to providing 275,000 pounds of berries to a local independent grocery chain and also required some of their berry crop to make strawberry preserves. Complicating this decision was the impact that weather had on the yield of each type of berry. If the weather reduced the yield, the two producers would need to make up for the loss by sourcing berries from several nearby farmers. However, if the weather was favourable, they would be able to sell any excess berries at their own storefront. What current decision should the two strawberry producers make to ensure they achieve the best outcome one year later?

Instructor Spreadsheet to accompany product W33717.

Nykaa E-Retail Private Limited (Nykaa), an Indian e-commerce start-up catering to the beauty and personal care segment, was preparing for its IPO amid the uncertainty presented by the nationwide lockdown in India during the COVID-19 pandemic. Since only retailers selling essential goods were allowed to remain open during the strictest lockdown phase, Nykaa was not able to operate during the first three months of 2020. Nykaa had adopted an omnichannel retailing strategy and made good use of digital marketing activities to ensure customer satisfaction, but its existing business model appeared to be insufficient to overcome the pandemic-related hardships. Nykaa needed to decide on potential strategy changes and the timing of its stock market debut, knowing that by postponing the highly anticipated IPO, the company could be risking its reputation.

In December 2022, after the independent film distributing company levelFILM Inc. experienced several box office failures, the company’s manager of sales strategy was wondering if the company needed to re-examine its portfolio strategy. Based in Toronto, Ontario, levelFILM Inc. operated in the highly uncertain film industry, in which it was almost impossible to predict how any one film would perform at the box office. The various distributors in the industry employed different strategies for managing risk, including building a large diversified portfolio of projects or pursuing a blockbuster strategy with heavy investment in fewer projects. The company’s manager was wondering which strategy would be most appropriate for levelFILM Inc. and how he might use extensive historical data that he had available to determine optimal risk management and investment returns options for the company.

Instructor Spreadsheet to accompany product W33829.

Student Spreadsheet to accompany product W33828.

Data cleaning, data preparation, and model development are the crucial steps in data analytics. The first two steps aim to improve data quality for higher accuracy, improved productivity, and better efficiency in modelling and obtaining results. The last step, model development, seeks to improve accuracy of prediction, especially in predictive modelling. In this technical note, we use a sample to illustrate how to work with a multivariate dataset in Python. This dataset’s massive number of variables requires different approaches to data cleaning, preparation, and model development, such as data normalization and dimension reduction.

Student Spreadsheet to accompany product W28361.

In early 2020, the rapid spread of COVID-19 across the world led the most highly affected countries, such as the United States and India, to focus on rapid testing and contact tracing to break the chain of transmission. By August 25, 2020, India had tested nearly 37 million cumulative COVID-19 samples as part of the government’s “Test, Track, Treat” initiative. The efficient allocation of collected swabs with saliva samples to appropriate testing labs had become an urgent operational requirement. The senior consultant of GD Labs was appointed officer on special duty by the State Government of Chhattisgarh to devise a plan for the optimal allocation of swabs to government and private labs across the state. He decided to roll out a pilot study for two districts that had six labs—both government and private. The task required access to extensive data on the collection of swabs with saliva samples, previous backlogs, locations of labs, and the maximum capacity per lab. The goal of the project was to maximize the allocation of swabs for testing within budget constraints.

Instructor Spreadsheet to accompany product W28362.

Instructor Spreadsheet to accompany product W28362.

On the morning of June 30, 2019, the Orlando Magic had only a few hours to make a major decision, before the National Basketball Association free agency period was set to begin at 6 p.m. The management team needed a recommendation regarding whether to offer a new contract to the team’s current player, Terrence Ross, or pursue a free agent replacement, such as Rudy Gay. With extensive analytical data available, a thorough analysis was needed to predict which player was most likely to contribute to the Orlando Magic’s future success.

Spreadsheet to accompany product W27082.

Spreadsheet to accompany product W27081.

London Hydro, Inc. (London Hydro) must forecast the electricity demand of the firm’s clients. The Ontario Energy Board had just announced the results of a pilot program to introduce a new pricing scheme to residential energy consumers in Ontario. This was the origin of tiered pricing, which was based on overall monthly energy usage. In the past, consumers had all been on a time-of-use plan where energy was more expensive during peak hours and cheaper in lower-demand hours. Thus, London Hydro had to anticipate the potential change in client behaviour and predict the effects of the pricing shift.Using data it had gathered on individual household energy consumption, London Hydro hoped that by forecasting which consumers might shift to the new tiered pricing plan it could gain key insights that would help the firm understand what effects the plan might have on its revenues and on its clients’ consumption behaviours.