個案總覽

APLO was a reputable supplier of LED lighting systems for diverse countries from Taiwan to the United Kingdom. In 2015, APLO signed a contract to supply and install 30,000 pieces of 60-watt ecological street lights in several towns within one of Indonesia’s provinces. With over 250 million inhabitants, Indonesia was in dire need of modernizing its infrastructure as it expanded economically. Having already been contracted for street lighting in several parts of Jakarta, Indonesia’s capital city, APLO was eager for more projects across Indonesia. Would APLO be able to make this its showcase project and win many more contracts throughout Indonesia’s 34 provinces?

Instructor spreadsheet for product 8B16E001.

Student spreadsheet for product 9B16E001.

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.

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.

Student spreadsheet for product W16049.

APLO was a reputable supplier of LED lighting systems for diverse countries from Taiwan to the United Kingdom. In 2015, APLO signed a contract to supply and install 30,000 pieces of 60-watt ecological street lights in several towns within one of Indonesia's provinces. With over 250 million inhabitants, Indonesia was in dire need of modernizing its infrastructure as it expanded economically. Having already been contracted for street lighting in several parts of Jakarta, Indonesia's capital city, APLO was eager for more projects across Indonesia. Would APLO be able to make this its showcase project and win many more contracts throughout Indonesia's 34 provinces?

A Japanese management consultant company seeks to relocate some of its instructors for a period of between one and three months to Singapore in order to conduct its flagship course catering to Japanese expatriate managers. It must determine which instructors to select in order to minimize relocation costs while taking into account their productivity and availability and the number of courses booked over three future months. Cost minimization is crucial due to the expensive service apartment rentals in Singapore. The firm must develop an optimization template in order to make the best possible decision.

A Japanese management consultant company seeks to relocate some of its instructors for a period of between one and three months to Singapore in order to conduct its flagship course catering to Japanese expatriate managers. It must determine which instructors to select in order to minimize relocation costs while taking into account their productivity and availability and the number of courses booked over three future months. Cost minimization is crucial due to the expensive service apartment rentals in Singapore. The firm must develop an optimization template in order to make the best possible decision.

End-of-month account closure at many firms often requires long work hours, which may lead to staff fatigue and attrition that will affect productivity and quality of work. This is true for GlaxoSmithKline’s Record to Report Finance team in Kuala Lumpur, Malaysia in August 2014. The company is a science-led global business that researches and develops a broad range of innovative products in three primary areas: pharmaceuticals, vaccines and consumer health care. The team in Malaysia has 40 employees who provide services including month-end accounts closure, financial reporting and analytics to business units operating in the Philippines, Malaysia, Brunei, Singapore, Australia, New Zealand, Indonesia, Thailand and Vietnam. At the end of every month, the team must perform within five days a sequence of 17 activities requiring varying man-hours. The activities must follow a specific flow according to information availability and must, for internal efficiency and quality control reasons, start and end on the same day. Is there a method by which management can help the team achieve work balance or minimize the number of work hours per day?

A manufacturer of over 75 grades of styrenic resins - used to make DVD cases, refrigerator trays, packaging materials and auto parts - faces a "transition loss" each time it switches production from one grade to another. A transition loss for each grade arises from the initial 16 metric tons produced, which are sub-standard and unsuitable for usage by customers. To the company, this implies a loss of resources (raw material and production cost) and a disposal fee ($10,000) to remove each sub-standard production. The case illustrates a sample of 15 grades for which data on their requirements for machine time usage, raw materials and labour hours are provided, as well as their production cost, selling price and market demand. Some of these grades must also be sold jointly in specific ratios. A newly hired sales executive must present an optimization template that would meet the company's production constraints and maximize its profitability. Which grades of styrenic resins should be produced? Furthermore, how much of each grade should be produced?

A manufacturer of over 75 grades of styrenic resins — used to make DVD cases, refrigerator trays, packaging materials and auto parts — faces a “transition loss” each time it switches production from one grade to another. A transition loss for each grade arises from the initial 16 metric tons produced, which are sub-standard and unsuitable for usage by customers. To the company, this implies a loss of resources (raw material and production cost) and a disposal fee ($10,000) to remove each sub-standard production.<br><br>The case illustrates a sample of 15 grades for which data on their requirements for machine time usage, raw materials and labour hours are provided, as well as their production cost, selling price and market demand. Some of these grades must also be sold jointly in specific ratios. A newly hired sales executive must present an optimization template that would meet the company’s production constraints and maximize its profitability. Which grades of styrenic resins should be produced? Furthermore, how much of each grade should be produced?

Student spreadsheet for product 9B14E007.

A small publicly listed company is entertaining the idea of adding nursing home management to its medical value chain, which is currently focused on consultation. Management must rely on simulation in order to determine the feasibility of operating a nursing home according to admissions protocol and subsidies granted by a governmental agency.

The profit margin for the travel agency industry in Singapore, which mostly offered travel packages to Asia and Europe, was very thin. An up-and-coming travel agency faced the dilemma of offering maximum customer satisfaction while keeping its operating cost (e.g., fees for its tour guides) low. Rather than simply assigning travel guides to tours by trial and error, a director of the travel agency decided to use an optimization template. This case requires the development of an optimization template to advise management on the optimal assignment of tour leaders (within constraints of their availability and required rest periods) and generate maximum satisfaction among the customers. Considerations for tour-guide assignment include tour guides’ customer satisfaction levels, expertise on particular tours, visas for specific countries, and employment plans.

The degradation of the environment has led many governments and customers to pressure businesses to make their operations more nature friendly. The case illustrates an effective example of corporate social responsibility. Specifically, it demonstrates how a small increase in a supply chain budget can drastically reduce carbon dioxide (CO2) emission in the transportation of LCD TVs from their manufacturing bases to a distribution centre.

The degradation of the environment has led many governments and customers to pressure businesses to make their operations more environmentally friendly. The case illustrates an effective example of corporate social responsibility. Specifically, it demonstrates how a small increase in a supply chain budget can drastically reduce carbon dioxide emissions in the transportation of LCD TVs from their manufacturing bases to a distribution centre.

Spreadsheet for product 9B12E003.

Instructor spreadsheet for teaching note product 8B12E003.

A Stockholm-based sports broadcasting firm with five international offices is facing uncertain contract renewals by its current clients from several geographic territories. It must determine the likelihood of profitability if it purchases the global broadcasting rights of the Portuguese Soccer League (Liga Zon Sagres) for the upcoming 2011-2012 season.