個案總覽

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.

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 modelling 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.

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.

Histograms are graphs that provide a large amount of useful information for all types of data and display the frequency of observations in a data set. The purpose of this note is to introduce histograms for several types of data, provide examples of insights that can be gained and calculations that can be performed using histograms, and demonstrate how to build histograms in Microsoft Excel. In addition, this note reviews the Normal distribution, which can be used to approximate many empirical distributions. The note includes practice exercises and their solutions, and a supporting Excel workbook for students.

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.

The purpose of this note is to illustrate the use of Data Tables in Microsoft Excel. Data Tables are commonly used for performing sensitivity analyses, sometimes called “What If?” analyses, and for preparing data for graphs. Data Tables can also be used to enable a Monte Carlo simulation in a spreadsheet in more advanced models. The technical note includes practice exercises and their solutions, and a supporting Excel workbook for students.

The purpose of this note is to illustrate the use of Microsoft Excel’s Goal Seek feature. The technical note includes practice exercises and their solutions, and a supporting Excel workbook for students.

In March 2016, an investor wanted to evaluate the strategy and stability of Cisco Systems, Inc. by using historical income statements to predict future cash flows. He knew that he might be able to use time series analysis to evaluate the company’s performance in the near future, but he was unsure how to proceed if the historical data would not be predictive of the future performance. In particular, the investor wondered, how would he determine the likelihood that the company’s next quarter would yield similar net income to the previous quarter?

At a Jilltronics Systems board meeting in 2015, the chief executive officer (CEO) indicated an interest in reviewing the firm’s supply chain strategy in light of increasing product and service demand. Jilltronics, a regional player in the U.S. home security market with sales approaching $100 million annually, had experienced significant growth in both the new housing and retrofit markets. The CEO expressed his desire to take a more analytical approach in developing the supply chain strategy that might include expanding the number of vendors. He reported to the board that this initiative could pose some risks due to the challenges associated with managing multiple suppliers. The board meeting concluded with the CEO tasking the chief analytics officer with developing a vendor selection assessment plan and reporting her findings at the next board meeting.

In July 2015, PT Trias Indra Saputra (TRIAS), Indonesia’s leading welded cable ladder producer, had just won its largest-ever tender bid. The news could get even better if it adopted alternative materials that were potentially more profitable. The production director was tasked with weighing whether TRIAS should fulfill the tender using its traditional supplier or the new materials. While more expensive, the new materials would cut out several production processes and associated costs. However, using the new suppliers presented significant risks. Only two mills, in Korea and Japan, supplied the appropriate material, and both companies presented different prices and import costs. Since TRIAS could be penalized if it did not supply the goods on time, the production manager also had to calculate the likelihood that each company could be delayed in supplying the order and how much that would reduce profits if it happened.

The purpose of this note is to give a brief introduction to dynamic programming. The note introduces dynamic programming terminology and notation and provides motivation for why these problems are difficult to solve. Five examples illustrate how dynamic programming can be applied in a variety of settings.

In December 2012, a young worker in Toronto wants to invest $50,000 savings. He needs to decide the equity portfolio that will result in the lowest risk at the best possible return on his investment. In particular, he is looking to invest in Wal-Mart, IBM, Apple, Chevron and Amazon, all large U.S. corporations that have weathered the recent economic crisis and show growth potential for the future. He remembers learning about using efficient frontiers to analyze stocks and decides to undertake an exhaustive analysis before deciding in which company to invest.

A planning analyst at Cancer Care Ontario has been tasked to recommend a strategy for allocating new linear accelerator capacity to the province’s cancer treatment centres over a five-year period. Because the introduction of additional capacity requires the investment of capital resources and long implementation timelines, accurate and timely predictions are critical to the treatment of cancer patients. The planning analyst needs to devise an allocation strategy that will ensure quality radiation treatment across the province.

The U.S.-based executive vice-president (EVP) of Glenmark Generics Inc., the subsidiary of an Indian generic manufacturer, is weighing his options on whether or not to proceed with what is known as a Launch @ Risk in the U.S. market. Defined as a “risk taken by a generic company when it puts a product on the market before resolving outstanding patent lawsuits against it,” Launch @ Risk is a widely acknowledged route to gain an entry into the world's largest and most profitable pharmaceutical market. The focal product is the generic version of a hypertension drug whose patent is set to expire in 2015. Glenmark Generics has just secured approval from the U.S. Food and Drugs Administration (FDA) to launch a low-cost generic version of the patented drug but the FDA approval is being contested in a court of law by the patent holder. While awaiting the court’s ruling, the EVP must evaluate his company's options and decide whether to proceed, in the interim, with the product launch.

The owner and chief executive officer of the India Holiday Bureau (IHB), was besieged by calls from irate travelers seeking an explanation for the poor customer service they had received. It was the peak of the tourist season in India, with international visitors pouring into the country to explore its temples, palaces, hills, beaches and wildlife reserves. IHB had accepted several online hotel-booking requests, but because the hotel did not have sufficient staff to follow through on these requests, several customers were left stranded at the airport without their promised airport transfers. Others had been forced to go without hotel rooms altogether. IHB knew that a lack of accurate forecasting and proper planning was at the root of this problem. How could the owner accurately predict the growth that would continue to overwhelm IHB unless the company prepared for it?

Cisco Systems, Inc., the dominant global supplier of the routers and switches that formed the backbone of the Internet, was considering entry into the cloud-based education market in China through the design and marketing of an in-classroom device, the Sunbird. The new vice-president and chief technology officer of Enterprise Networking Group, Cisco Greater China, had met with a Politburo member of the Communist Party of China and State Councilor with responsibilities including China’s science, technology and education policies. The vice-president had introduced Cisco’s global operations and the two women had discussed partnering, technology transfer, cross branding, joint product and service development, cooperation with Chinese companies, and the IT revolution and its effect on Chinese education. How could Cisco profitably join in the Chinese education IT revolution? Cisco had never entered the educational IT equipment space in any part of the world with its own dedicated product. Should it develop the Sunbird for the Chinese market?<br><br> A <a href=https://www.youtube.com/watch?v=Fa9uTc1JKDI>video is available for viewing online.

Trionym Systems, a designer and manufacturer of 3-D printers, was enjoying soaring sales. Trionym’s chief executive officer (CEO) presented a plan for acquiring a new production facility to address the expected demand for the firm’s latest 3-D printer, the RB-5000, which was presently under beta testing. He expressed reservations with respect to considerable uncertainty both in terms of market size and production costs. Accordingly, he wished to use the latest prescriptive analytics techniques to ensure that the decision to expand was the right one. The chief analytics officer was tasked with assessing the proposed project and had to report his findings at the next board meeting.

On September 6, 2014, a young investor is trying to find a trading strategy to use to make money on Cisco’s stock. He wants to know whether the stock is increasing or decreasing in value. He decides to use the moving average strategy to avoid the fluctuations in the stock price caused by different short-term phenomena. When should he buy, sell or do nothing?