個案總覽

Instructor Spreadsheet to accompany product 8B21D008.

Spreadsheet to accompany product 9B21D008.

Atal Indore City Transport Service Limited operated Indore Bus Rapid Transit System, the main public transport system in the city of Indore, in the central Indian state of Madhya Pradesh. Indore Bus Rapid Transit System ran through an important section of the city, along a corridor 11.57 kilometres long with 21 bus stops. Operating the system involved meeting hourly demand for bus service—a task that required scheduling buses and their deployment to achieve the desired frequency. Indore Bus Rapid Transit System used modern technologies to identify passenger demand and the location of vehicles at all times during operation, and it used the data to plan and execute bus operations. Demand varied considerably between bus stops; therefore, management science techniques were needed for optimal planning. How could passenger service be maximized while optimizing the use of buses?

Atal Indore City Transport Service Limited operated Indore Bus Rapid Transit System, the main public transport system in the city of Indore, in the central Indian state of Madhya Pradesh. Indore Bus Rapid Transit System ran through an important section of the city, along a corridor 11.57 kilometres long with 21 bus stops. Operating the system involved meeting hourly demand for bus service-a task that required scheduling buses and their deployment to achieve the desired frequency. Indore Bus Rapid Transit System used modern technologies to identify passenger demand and the location of vehicles at all times during operation, and it used the data to plan and execute bus operations. Demand varied considerably between bus stops; therefore, management science techniques were needed for optimal planning. How could passenger service be maximized while optimizing the use of buses?

Student spreadsheet to case W21259

Spreadsheet to accompany product 9B17D016.

On June 1, 2016 a student was preparing for a summer job with Agarwal Automobiles, a vehicle fuel station owned by his father. The student had taken courses that covered supply chain management, including inventory management and forecasting. His father had suggested that, as a summer project, the student examine the fuel station’s retail inventory management practices with the intention of replacing the current simple rules with a more rational and complex planning model. The student needed some ideas to use as a guide toward a better ordering policy. The available data for the previous six months suggested that the company held an average ending inventory of ?2.1 million worth of fuel products to maintain average daily sales of ?0.52 million. The challenge was to reduce the inventory levels, while maintaining a high customer service level in fuel sales.

Student spreadsheet for case W17638.

On June 1, 2016 a student was preparing for a summer job with Agarwal Automobiles, a vehicle fuel station owned by his father. The student had taken courses that covered supply chain management, including inventory management and forecasting. His father had suggested that, as a summer project, the student examine the fuel station's retail inventory management practices with the intention of replacing the current simple rules with a more rational and complex planning model. The student needed some ideas to use as a guide toward a better ordering policy. The available data for the previous six months suggested that the company held an average ending inventory of ₹2.1 million worth of fuel products to maintain average daily sales of ₹0.52 million. The challenge was to reduce the inventory levels, while maintaining a high customer service level in fuel sales.