個案總覽

Excel spreadsheet for product 9B01E009.

Spreadsheet supplement for 901E09.

Spreadsheet supplement for 901E09.

Excel spreadsheet for product 9B04E018.

Excel spreadsheet for 9B04E018.

Three Excel files, two are simulations, one contains data.

BriLux develops early-stage high-speed data networking equipment. In recent month, BriLux customers have hinted that combining ARTRAN, the company's flagship optical data service platform, with a new fiber optic transportation product (tentatively referred to as FOT-320) would increase the market appeal of the company's portfolio. The research and development director must decide whether to support the development of this new product. Excel files are available upon request, products 7B04E018A, 7B04E018B and 7B04E018C.

BriLux develops early-stage high-speed data networking equipment. In recent month, BriLux customers have hinted that combining ARTRAN, the company's flagship optical data service platform, with a new fiber optic transportation product (tentatively referred to as FOT-320) would increase the market appeal of the company's portfolio. The research and development director must decide whether to support the development of this new product.

Solver model for product 9B02E012.

Data for product 9B02E012.

Excel spreadsheets containing data and solver for case 9B03E010.

Excel solution solver for case 9B01E013.

Excel spreadsheet for case 9B03E013.

Orion Bus Industries is a manufacturer of transit buses that are purchased by transit authorities across North America. The majority of Orion's sales are made through competitive bidding processes. The company's goal is to either increase margins while maintaining sales levels or to increase the total volume of sales. The chief executive officer would like to know whether historical contract bidding data can be used to improve the success of future bids for bus contracts.

Vytec Corporation is a subsidiary of Owens Corning, and manufactures extruded vinyl residential siding. In order to maximize the quantity and quality of the product, the operations analyst had to decide how best to use the available silos and extruder. He must determine the best way to configure the extruders to their respective material silos in order to ensure that each silo faced a similar demand for material. An Excel spreadsheet containing data and solver solutions is available (product 5B03E10).

Vytec Corporation is a subsidiary of Owens Corning and is a leading manufacturer of vinyl siding. The operations analyst wanted to determine if there was a more efficient way to organize the company's warehouse. After finding some high demand products being stored a long distance from the shipping dock, his first reaction was to move the product closer to the shipping area, reducing the time and distance required to retrieve the product for shipping. Doing so, however, would displace another product that should also be near the docks. Further research into the problem revealed many other issues. Two files are available - the case data file, product 7B03E013 and the solver model 5B03E13.

Four Star Motorsports is a family owned and operated garage specializing in rally cars and the sale of rally tires. In the winter, the business would have sales on tires if there was excess inventory, however, the owner was recently made aware of new pricing concepts through associates. The owner must investigate various pricing options during the upcoming selling season to increase revenue and to develop a plan that will allow adjustments for customers who are unhappy with the new pricing policy or an excess of tire inventory.

Four Star Motorsports is a family owned and operated garage specializing in rally cars and the sale of rally tires. In the winter, the business would have sales on tires if there was excess inventory, however, the owner was recently made aware of new pricing concepts through associates. The owner must investigate various pricing options during the upcoming selling season to increase revenue and to develop a plan that will allow adjustments for customers who are unhappy with the new pricing policy or an excess of tire inventory.

A venture capital firm needs to allocate $50 million in capital. Due to the firm's below-average performance and the currently sluggish financial market, a strategic allocation of this capital is critical to the firm's survival. The chief executive officer turns to his senior management team for advice. One team leader identifies firms for follow-on investments, a second team leader recommends new investments and the third team leader proposes a buy-out opportunity. The chief executive officer must decide whether the restrictions on the number of new investments is too limiting, whether due diligence is required on additional new companies and what the impact will be on the firm's return if a balanced portfolio is maintained. (Data and Solver model are available, products 7B02E012 and 5B02E12.)

SW Construction (Holding) Limited is a construction company that develops and manages properties. After a number of successful years in exclusively developing its own properties, the company has suffered a loss in revenue. The executive director is concerned that they have not been able to obtain a government contract. He must determine how the company can win more government contracts by collecting and analysing data from the last 20 auctions.