個案總覽

Spreadsheet to accompany product 8B18M194.

By August 2015, Swiggy, an on-demand food delivery start-up, had been operating for almost one year in Bengaluru, India. The exponential growth of the business was expected to persist. However, Swiggy was incurring a loss, or a cash burn, on each delivery it was making. The company's current cash reserves were also drying up, and its chief executive officer had been unsuccessful in attracting new venture capital funding to finance the cash burn estimated for the next four quarters. Swiggy must figure out how to pursue its growth without the injection of any fresh funds.

By August 2015, Swiggy, an on-demand food delivery start-up, had been operating for almost one year in Bengaluru, India. The exponential growth of the business was expected to persist. However, Swiggy was incurring a loss, or a cash burn, on each delivery it was making. The company’s current cash reserves were also drying up, and its chief executive officer had been unsuccessful in attracting new venture capital funding to finance the cash burn estimated for the next four quarters. Swiggy must figure out how to pursue its growth without the injection of any fresh funds.

Student Spreadsheet to accompany product 9B18M194.

Student spreadsheet for case W18813

In mid-2017, the regional head of Operations and Supply Chain at Sika AG, a Swiss specialty chemicals leader that developed solutions for building and automotive industries, faced a new challenge in the company’s epoxy flooring supply chain. She was tasked with identifying a robust solution that would both satisfy a shortened lead time and provide spare capacity to accommodate future growth. How should she proceed with these tasks?

Instructor Spreadsheet to accompany product 8B18E008.

Student spreadsheet for case W18195.

In mid-2017, the regional head of Operations and Supply Chain at Sika AG, a Swiss specialty chemicals leader that developed solutions for building and automotive industries, faced a new challenge in the company's epoxy flooring supply chain. She was tasked with identifying a robust solution that would both satisfy a shortened lead time and provide spare capacity to accommodate future growth. How should she proceed with these tasks?

Student Spreadsheet to accompany product 9B18E008.

Student Spreadsheet to accompany product 9B18E001.

A key contributor to the business reputation and success of Caterpillar Inc. (Caterpillar) was the company’s reliable aftermarket service. Caterpillar’s Asia Distribution Centre in Singapore processed urgent spare parts orders received from dealers located in 10 Southeast Asian countries. In 2017, the operations team was working to develop a rigorous analytical method for making daily decisions about how to ship the spare parts. Shipments were consolidated by country destination and needed to optimize the interests of three stakeholders: (1) Caterpillar, which wanted to minimize freight costs; (2) dealers, who wanted to receive the spare parts in the shortest time possible; and (3) freight forwarders, who wanted to be rewarded for their on-time delivery performance.

Student spreadsheet for case W18038.

Instructor Spreadsheet to accompany product 8B18E001.

A key contributor to the business reputation and success of Caterpillar Inc. (Caterpillar) was the company's reliable aftermarket service. Caterpillar's Asia Distribution Centre in Singapore processed urgent spare parts orders received from dealers located in 10 Southeast Asian countries. In 2017, the operations team was working to develop a rigorous analytical method for making daily decisions about how to ship the spare parts. Shipments were consolidated by country destination and needed to optimize the interests of three stakeholders: (1) Caterpillar, which wanted to minimize freight costs; (2) dealers, who wanted to receive the spare parts in the shortest time possible; and (3) freight forwarders, who wanted to be rewarded for their on-time delivery performance.

In early 2016, LUX* Resorts & Hotels, a hotel group headquartered in Mauritius, needed to determine the room mix to sell to foreign guests to achieve a specific earnings target. The hotel group also intended to sell some of the remaining rooms to local residents at affordable (discounted) prices. The objective was to maximize the revenue stream to finance local corporate social responsibility projects. The case highlights the practical use of Microsoft Excel Solver, an optimization tool, to resolve routine planning challenges faced by a hotel group.

Student spreadsheet for case W17282.

Student spreadsheet to accompany product 9B17E004.

Spreadsheet to accompany product 8B17E004.

In early 2016, LUX* Resorts & Hotels, a hotel group headquartered in Mauritius, needed to determine the room mix to sell to foreign guests to achieve a specific earnings target. The hotel group also intended to sell some of the remaining rooms to local residents at affordable (discounted) prices. The objective was to maximize the revenue stream to finance local corporate social responsibility projects. The case highlights the practical use of Microsoft Excel Solver, an optimization tool, to resolve routine planning challenges faced by a hotel group.